{"id":66,"date":"2023-03-03T19:02:31","date_gmt":"2023-03-03T12:02:31","guid":{"rendered":"https:\/\/onesender.net\/docs\/?page_id=66"},"modified":"2023-03-03T19:02:33","modified_gmt":"2023-03-03T12:02:33","slug":"google-form","status":"publish","type":"page","link":"https:\/\/onesender.net\/docs\/integrasi\/google-form\/","title":{"rendered":"Google Form"},"content":{"rendered":"\n<p>Berikut ini langkah-langkah mengirim formulir di google form ke nomor whatsapp. Contoh yang akan kita buat adalah form pre order T-Shirt exclusive.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Buat Form yang memuat nomor WhatsApp<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1319\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/1.png\" alt=\"\" width=\"969\" height=\"700\" \/><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">2. Buat Script google spreadsheet.<\/h2>\n\n\n\n<p><p>&#8211; Buka tab jawaban kemudian klik icon hijau Google Spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1321\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/2.png\" alt=\"\" width=\"880\" height=\"718\"><\/p><\/p>\n\n\n\n\n\n<p><p>&#8211; Di halaman Google Spreadseet, buka menu ALAT -&gt; EDITOR SCRIPT. Berikutnya akan muncul halaman dialog untuk menampilkan script.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1322\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/3.png\" alt=\"\" width=\"916\" height=\"396\"><\/p><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">3. Masukkan script integrasi<\/h2>\n\n\n\n<p>&#8211; Sebelum memasukkan kode script. Harap menyesuaikan dahulu urutan kolom whatsapp di Google Spreadsheet. Pada contoh yang saya buat, kolom nomor whatsapp ada di Column C. Abjad C memiliki urutan ke-3 dalam alphabet.<br>&#8211; Silahkan mengubah nama Halaman sheet di script integrasi. Di contoh, Tab Sheet bernama &#8220;PreOrder&#8221;. Teks ini saya masukkan dalam variabel *sheet* di baris ke-7.<\/p>\n\n\n\n<p><p>&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1324\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/5.png\" alt=\"\" width=\"800\" height=\"361\"><\/p>\n<p>&#8211; Klik tombol simpan<\/p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Setting pemicu<\/h2>\n\n\n\n<p>Pemicu ini berfungsi untuk mejalankan scritp di atas pada kondisi tertentu. Dalam kasus ini, kita ingin script dijalankan setiap ada penambahan data baru dari google form.<\/p>\n\n\n\n\n\n<p><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1325\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/6.png\" alt=\"\" width=\"971\" height=\"398\"><\/p>\n<p>Cara menambahkan pemicu dengan klik Button Float di bagian kanan bawah. Lalu isi dialog yang muncul seperti di gambar.<\/p><\/p>\n\n\n\n\n\n<p><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1326\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/7-1024x572.png\" alt=\"\" width=\"1024\" height=\"572\"><\/p>\n<p>Ketika menyimpan dialog ini, google spreadsheet meminta izin untuk mengakses script tersebut. Silahkan follow popup otorisasi yang muncul dan memberi izin script di atas untuk mengakses data google spreadhseet.<\/p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">5. Selesai<\/h2>\n\n\n\n<p>Pada tahap ini, Anda telah selesai mensetting Google Form. Untuk menguji apakah script sudah berjalan. Silahkan klik tombol *Jalankan*.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.mainwordpress.com\/wp-content\/uploads\/sites\/2\/2021\/10\/6.png\" alt=\"\" class=\"wp-image-38\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Troubleshoot:<\/h2>\n\n\n\n<p>&#8211; Perlu dipastikan bahwa user menulis format nomor yang sesuai atau hanya angka. Untuk mengatasi user yang menulis asal-asalan, scritp integrasi bisa dicustom lagi dengan filter nomor berlapis.<\/p>\n\n\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1319\" src=\"https:\/\/onesender.net\/wp-content\/uploads\/2021\/11\/1.png\" alt=\"\" width=\"969\" height=\"700\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Berikut ini langkah-langkah mengirim formulir di google form ke nomor whatsapp. Contoh yang akan kita buat adalah form pre order T-Shirt exclusive. 1. Buat Form yang memuat nomor WhatsApp 2. Buat Script google spreadsheet. &#8211; Buka tab jawaban kemudian klik icon hijau Google Spreadsheet. &#8211; Di halaman Google Spreadseet, buka menu ALAT -&gt; EDITOR SCRIPT. &#8230; <a title=\"Google Form\" class=\"read-more\" href=\"https:\/\/onesender.net\/docs\/integrasi\/google-form\/\" aria-label=\"Read more about Google Form\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":33,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-66","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/66","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/comments?post=66"}],"version-history":[{"count":1,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/66\/revisions"}],"predecessor-version":[{"id":67,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/66\/revisions\/67"}],"up":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/33"}],"wp:attachment":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/media?parent=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}