Memanfaatkan Google Docs dan Tiny URL Untuk Membuat Formulir Pendaftaran Online


Google Docs? Apa itu Google Docs? Bagi yang belum tau, Google Docs merupakan sebuah perangkat lunak yang digunakan untuk keperluan perkantoran, seperti mengolah kata (seperti microsoft word), pengolah data spreadsheet (seperti microsoft excel), mengolah persentasi (seperti microsoft power point) dan pengolah dataset (seperti microsoft access). Namun yang berbeda adalah, Google Docs berjalan diatas website! Yup tanpa harus menginstallnya kita bisa menjalankan Google Docs.

Tiny URL? Tiny URL merupakan website yang menyediakan solusi sebagai pemendek url website. Misal saja jika kita memiliki URL website yang panjang sekali, kita dapat memendekkannya mengugnakan Tiny URL, misal URL :

http://panjangsekali.panjangjuga.com/menghapus-jejak/dan-sekarang-aku-taksanggup/hello-ini-url-yang-sangat-panjang.php

dapan diubah oleh Tiny URL menjadi :

http://tiny.cc/pendek

Latar Belakang

Seandainya kita sedang membuat acara, lalu memerlukan data peserta yang akan mengikuti acara tersebut, pastinya kita harus membuka sebuah pendaftaran. Jika kita menggunakan cara manual, mungkin kita bisa meminta para peserta untuk datang dan mengisi formulir pendaftaran, dan jika jika menggunakan cara modern, kita bisa membuat sebuah website, lalu membuat form pendaftarannya berbasiskan website.

Cara manual, sangatlah memakan waktu, pertama harus ada yang menerima pendaftaran dan yang pasti belum tentu peserta mau untuk datang 😀 Sedangkan cara membuat website sangat memakan biaya, pertama harus membuat website, harus buat database untuk menampung datanya dan harus ada yang mengurus website tersebut 😀 Lantas bagaimana solusinya?

Google Docs adalah salah solusi untuk permasalahan ini. Dengan Google Docs, kita dapat membuat Formulir secara cepat, tanpa harus membuat website, database dan sebagainya. Hanya dengan bermodalkan memiliki akun Google, maka siapapun dapat dengan mudah menggunakan Google Docs. Selain itu data yang ditampung menggunakan Google Docs dapat diunduh menjadi file OpenOffice, Microsoft Office dan lain-lain…

Lantas Untuk apa Tiny URL

Membuat Formulir Menggunakan Google Docs

Pertama saya anggap anda memiliki akun Google, jika tidak punya anda bisa mendapatkannya hanya dengan daftar ke Google Mail. Sekarang tinggal masuk ke halaman website Google Docs :

Screenshot-Welcome to Google Docs - Google Chrome

Setelah itu masukkan username email dan password GMail kita, setelah sukses, maka akan terlihat tampilan seperti yang dibawah ini :

Screenshot-Google Docs - All items - Google Chrome

Sekarang kita buat sebuah form untuk formulir pendaftaran. Caranya lewat menu Create New -> Form, setelah itu akan muncul pengolah Form, kita hanya butuh mengubah tampilan form, dan komponen-komponen apa saja yang diperlukan sebagai input untuk data pendaftaran :

Screenshot-Edit form - [Formulir Pendaftaran Kontes Pemrograman] - Google Docs - Google Chrome

Jika telah selesai, tekan tombol Save untuk meyimpan perubahan. Lantas bagaimana cara tampilan Form nya? TInggal klik Link yang berada di bagian bawah pengolah Form, misalnya pada gambar diatas linknya adalah :

http://spreadsheets.google.com/viewform?formkey=dFNwYXNITUtROFdORnA5TE1yc1dqT2c6MA

Hasil formulis yang saya buat misalnya seperti dibawah ini :

Google Docs Formulir

Sekarang sudah selesai, namun masih ada masalah. APa itu? tentang URL, URL hasil Google DOcs sepertinya terlalu panjang (http://spreadsheets.google.com/viewform?formkey=dFNwYXNITUtROFdORnA5TE1yc1dqT2c6MA) sulit dituliskan dan diingat jika URL ini akan ditulis di Poster atau sejenisnya.

Memendekkan URL Menggunakan Tiny URL

Untuk menjalankan Tiny URL, tinggal buka saja website Tiny URL. dan untuk menggunakan website Tiny URL, kita tidak perlu melakukan pendaftaran seperti Google Docs. Tampilan websitenya seperti pada gambar dibawah ini :

Screenshot-Tiny URL - create a shorter link - Google Chrome

Setelah itu masukkan URL yang dibuat oleh Google Docs tadi ke field Enter a long URL that you want to make tiny dan masukkan nama URL yang kita inginkan di field Custom. Misal disini saya memasukkan kontes_pemrograman:

Screenshot-Tiny URL - create a shorter link - Google Chrome-1

Setelah itu tekan Tiny It, dan setelah selesai maka Tiny URL akan membuatkan URL pendek untuk kita, dan disini saya mendapatkan URL :

http://tiny.cc/kontes_pemrograman

Seperti yang terlihat pada gambar dibawah ini :

Screenshot-Tiny URL - create a shorter link - Google Chrome-2

Selesai, Sekarang peserta dapat mendaftar melalui form yang telah kita buat 😀

Kesimpulan

Jika para peserta telah mengisi formulir yang tadi kita buat, maka kita dapat dengan mudah mendapatkan seluruh datanya berupa spreadsheet di Google Docs seperti yang terlihat pada gambar dibawah ini :

Screenshot-Formulir Pendaftaran Kontes Pemrograman - Google Chrome

dan data tersebut bisa kita download untuk dibuat di Microsoft Excel ataupun OpenOffice 😀

Referensi

102 pemikiran pada “Memanfaatkan Google Docs dan Tiny URL Untuk Membuat Formulir Pendaftaran Online

  1. Amazing blog! Do you have any hints for aspiring writers?
    I’m hoping to start my own site soon but I’m a little lost on everything.
    Would you propose starting with a free platform like WordPress
    or go for a paid option? There are so many options out there
    that I’m totally overwhelmed .. Any tips? Thanks!

  2. I believe that is one of the most significant information for
    me. And i am satisfied studying your article. However wanna observation on few common things,
    The web site style is wonderful, the articles is in point of
    fact great : D. Good job, cheers

  3. Oh my goodness! Incredible article dude! Thank you so much, However I am encountering problems with your RSS.
    I don’t know the reason why I am unable to subscribe to it.
    Is there anybody having the same RSS issues? Anybody who knows the answer will you kindly respond?
    Thanx!!

  4. A jeweller I once worked for used to say

    “If you don’t have any jewellery cleaner handy, try using toothpaste with baking soda to help clean tarnish off of your sterling or pure Jewellery from Danon. Just rub the toothpaste on the tarnished area with a soft cloth and clean off. Make sure to dry the jewellery to prevent future tarnishing.”

  5. I’ve learn several just right stuff here. Definitely price bookmarking for revisiting.

    I wonder how so much attempt you put to create this kind of excellent informative website.

  6. こんにちわ。いつも興味深く拝見させてもらっています。私は脱毛サロンの体験口コミの評判についてのサイトを運営しています。誰であっても知りたい銀座カラーの脱毛、ジェイエステの脱毛体験談、わたしの脱毛ラボ体験談、脱毛の効果が出るまでどのくらい?、などなど全てまとめました。これからもブログ楽しみにしています。

  7. 2012 you should be prepared with lots of New Year resolutions.

    Of course, this makes it legitimate in that it is an actual product that can be tried before buying a license.
    When bad times arrive at our doorstep and our modern electrical utility systems are no longer available and functioning we simply can not
    rely upon the moon or flashlights to illuminate our yards.

  8. Hеlⅼo would you mind stating which blоg platform you’re working with?
    I’m going to start my own Ƅl᧐g soon but I’m having a tough
    time selecting between BlogEngine/Wordpress/B2evolution and Druρal.
    The reason I ask is becauѕe your layout seems different then most blogs and I’m looking for somethіng completeⅼy unique.
    P.S My apologіes for being off-topic but I hɑd to ask!

  9. Having read this I thought it was really informative.

    I appreciate you taking the time and energy to put this information together.
    I once again find myself spending a lot of time both reading and commenting.
    But so what, it was still worthwhile!

  10. It’s actually a cookl and helpful piece of information. I’m satisfied that you simply shared this helpful
    indo with us. Please stay us up to daye like this.
    Thank you for sharing.

  11. Awesome site youu have here but I was wondering if you knew of any discussion oards that
    cover the same topics discussed here? I’d really loe to be a part of
    community where I can get advice from other knowledgeable individuals hat
    share the same interest. If you have any suggestions, ploease let me know.
    Thank you!

  12. Greetings! Quick question that’s completely off topic. Do you know how to make your site mobile friendly?
    My blog looks weird when browsing from my iphone. I’m trying to find a theme orr plugin that might be able to corfrect this
    problem. If you have any recommendations, please share. With thanks!

  13. obviously like your web site however you have to take a look at the spelling on several
    of your posts. A number of them are rife with spelling problems and
    I to find it very bothersome to inform the reality nevertheless I will definitely
    come back again.

  14. Greetings from Carolina! I’m bored at woek sso I decided to check out yyour site on my iphone during lunch break.
    I love the information you provide here and can’t wait to
    take a look when I get home. I’m shocked at how quick yoyr blog loaded onn my mobile ..

    I’m not even using WIFI, just 3G .. Anyways, awesome blog!

  15. Piękny artykuł, ogólnie to ma sens, chociaż w kilku aspektach bym polemizowała.
    Na pewno Twój blog zasługuje na szacunek. Myślę, że tu jeszcze wpadnę.

  16. An outstanding share! I’ve just forwarded this onto a friend who was doing a little homework on this. And he actually ordered me breakfast due to the fact that I found it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to talk about this subject here on your site.

  17. Some individuals then again pay so much money at one time to
    boost the likelihood of winning. The system the place
    betting money is thru your financial institution is safe to work with, and the transaction is all the time between your account
    and the Ladbrokes. Easy system described in steps.
    Many are easy individuals just struggling to get by.
    This guide offers all the information it’s essential to get into the sport.

    However the thing is that to extend your possibilities of winning, you need to place a guess day-after-day.
    As an alternative, you are able to get all the knowledge
    you need from that very same site. As long because the
    owner of the Bitcoin takes care of it correctly using a excessive-security wallet and two-issue authentication, it is going to be
    extraordinarily difficult for anybody else to
    get entry to their funds. At any point, nonetheless, the bookie can bounce in and make changes to the traces that are available to his players if knows he can be getting heavy one
    sided motion.

    If you are a kind of individuals who doesnt like cats, Im sorry
    to listen to that. For the above example, it could seem like -7.5 (-110).
    Other players can legally purchase Mega Hundreds of
    thousands Lottery tickets on-line by way of the lottery
    agent you see talked about above. For example, MEGA Millions
    is a multi-state lottery and it operates in 11 states.

    As an example, you wouldn’t need to select simply any race horse
    in hopes of winning a bet. 5. Bet on sports by inserting your wager.
    Once you click on on the sport of your selecting remember to bookmark the page so you will at all times have the most present and up to
    date sports betting odds at your disposal. On this methodology, you might choose a low number from the given set comparable to
    1-50 like 1. Some successful numbers have two consecutive numerals, though not on a regular basis.
    After which with the time you saved do one thing more productive than you’ll have carried out appearing
    like a poor particular person.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google

You are commenting using your Google account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s