Pernah melihat QR Code seperti gambar diatas? Tentu pernah dong, misalnya yang suka dengan BBM atau Kode ini juga sering kita jumpai pada aplikasi tertentu atau pada sparepart kendaraan, bahkan sekarang lebih luas lagi sering digunakan untuk logo-logo perusahaan, untuk membuat link tertentu dan sebagaikan. Menurut https://id.wikipedia.org "Kode QR atau biasa dikenal dengan istilah QR Code adalah bentuk evolusi kode batang dari satu dimensi menjadi dua dimensi. Penggunaan kode QR sudah sangat lazim di Jepang Hal ini dikarenakan kemampuannya menyimpan data yang lebih besar daripada kode batang sehingga mampu mengkodekan informasi dalam bahasa Jepang sebab dapat menampung huruf kanji. Kode QR telah mendapatkan standardisasi internasional dan standardisasi dari Jepang berupa ISO/IEC18004 dan JIS-X-0510 dan telah digunakan secara luas melalui ponsel di Jepang"
Untuk memudahkan sahabat tekno-g juga menyediakan link untuk langsung melihat file Google Sheets yang sudah ada formula untuk membuat qr code dan juga video cara membuatnya di bagian bawah artikel ini.
Kode QR ditemukan di Jepang dalam sebuah penelitian yang di pimpin oleh Masahiro Hara, dimana sebelumnya kita mengenal barcode batang yang satu dimensi lalu dikembangkan menjadi Barcode dua dimensi yaitu QR Code.
Nah sekarang mari kita coba langsung ke teknis membuatnya di google sheets. Sahabat pasti dong sudah tahu apa itu Google Sheets. Google sheets adalah aplikasi pengolahan data yang dimiliki oleh google yang sangat mirip dengan Microsoft Excel, namun Google sheets harus di akses melalui internet dan penggunanya harus sudah mempunyai Google Account atau email google. Untuk mengaksesnya sahabat tinggal mengaktifkan Aplikasi Drive Google.
Tahap Membuat QR Code dengan Google Sheets :
- Aktifkan Google Sheets dari Google Drive
- Buatlah Tabel sesuai kebutuhan, tekno-g membuat seperti ini, Kolom No, Data dan Barcode QR / Code QR, contoh di Kolom Data masukkan Link, Teks atau angka, atau kombinasi semuanya.
- Pada Kolom C (Barcode QR/Code QR), isikan formula yang membaca data yang dibuat di kolom B (Data), lihat gambar..
 |
| Untuk Lebih Jelas Perbesar Gambar |
Mudah bukan??? Jadi sesuaikan saja dengan kebutuhan sahabat, misalnya membuat link yang langsung menuju ke website kita, membuat penjelasan singkat produk kita, membuat kata-kata rahasia. Semua bisa dibaca oleh perangkat yang memiliki kemampuan menscan QR Code, beruntungnya kita pada masa ini, hampir semua smartphone sudah bisa membaca kode QR dengan aplikasi kamera pembaca kode tersebut.
Trik Mengatasi Error Jika ada spasi di Data yang akan dibuat QR Code
Pada Formula sahabat tinggal tambahkan formula =REGEXREPLACE() pada rumus atau formula diatas, caranya bisa lihat gambar berikut : |
| Klik Gambar atau Buka di Desktop untuk Melihat Lebih Besar |
Untuk memudahkan sahabat kami sudah menyediakan link untuk mendownload file atau berbagi file Barcode QR nya, silahkan ikuti tautan berikut :
Untuk lebih rinci ayo kita lihat video berikut ini :
I used to be able to find good advice from your blog articles.
ReplyDeletemas, rencananya kan kami mau bikin QR code untuk presensi peserta seminar, nah dari Google Sheet untuk bisa dibagikan ke masing2 peserta caranya gimana ya?
ReplyDeleteikuti trik berikut :
DeleteBuatlah seperti tabel, lalu pastikan ada satu coloumn unik, nanti baris pada kolom itu dibaca di print seperti mail merge... namun ini bisa kita buat google sheets, coba adopsi cara ini :
http://tekno-g.blogspot.com/2016/10/cara-membuat-surat-masal-tanpa-mail-merge-dengan-microsoft-excel.html
Just wanna comment that you have a very nice internet site, I love the style it actually stands out.
ReplyDeleteOutstanding quest there. What happened after? Thanks!
ReplyDeleteHowdy! I know this is kinda off topic nevertheless I'd figured I'd ask.
ReplyDeleteWould you be interested in exchanging links or maybe
guest authoring a blog article or vice-versa?
My blog covers a lot of the same topics as yours and I believe we
could greatly benefit from each other. If you are interested feel free
to send me an email. I look forward to hearing from you!
Wonderful blog by the way!
Hey there this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors
ReplyDeleteor if you have to manually code with HTML. I'm starting a blog soon but have no coding know-how so I
wanted to get advice from someone with experience.
Any help would be greatly appreciated!
double stopping ()
Hello to all, how is all, I think every one is getting more
ReplyDeletefrom this site, and your views are fastidious for new viewers.
kitchen range ()
This internet site is my inspiration, really excellent style and design and Perfect content.
ReplyDeletePretty section of content. I just stumbled upon your website and in accession capital to assert
ReplyDeletethat I get actually enjoyed account your blog posts. Anyway I'll be subscribing to
your feeds and even I achievement you access consistently rapidly.
Great delivery. Sound arguments. Keep up the good work.
ReplyDeleteExcellent info over again. Thumbs up.
ReplyDeleteHmm it appears like your website ate my first comment
ReplyDelete(it was super long) so I guess I'll just
sum it up what I had written and say, I'm thoroughly enjoying your blog.
I as well am an aspiring blog writer but I'm still new to
the whole thing. Do you have any tips and hints for newbie blog writers?
I'd definitely appreciate it.
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://urlki.com/3doa4
Great delivery. Sound arguments. Keep up the good effort.
ReplyDeleteBy the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://urlki.com/3dp97
Hi there i am kavin, its my first occasion to commenting anywhere, when i read
ReplyDeletethis paragraph i thought i could also make comment due to this
sensible piece of writing.
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://rlu.ru/2wesc
I am not sure where you're getting your information, but great topic.
ReplyDeleteI needs to spend some time learning more or understanding more.
Thanks for excellent information I was looking for this info for my mission.
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://ix.sk/1sRlH
Hello there! I know this is somewhat off topic but I was wondering which blog platform are you using for this site?
ReplyDeleteI'm getting sick and tired of Wordpress because I've had problems with hackers and I'm looking at
alternatives for another platform. I would be great if you could point me in the direction of
a good platform.
Thanks designed for sharing such a good idea, paragraph is fastidious, thats why i have read it
ReplyDeletecompletely
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are
filled up. Here is the link: http://qtx.de/383kl
I used to be suggested this website by way of my cousin. I'm no
ReplyDeletelonger certain whether or not this submit is written by him as nobody else understand such distinct about
my difficulty. You are wonderful! Thank you!
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://we.cx/3tncc
An interesting discussion is definitely worth comment.
ReplyDeleteI do believe that you should write more on this issue, it might not be a taboo matter
but generally people don't speak about these subjects.
To the next! Best wishes!!
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up. Here is the link:
http://gul.ly/vhuyf
Thank you for the auspicious writeup. It actually was a leisure account it.
ReplyDeleteGlance advanced to more added agreeable from you!
By the way, how can we be in contact?
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://we.cx/3tnei
Link exchange is nothing else however it is only placing the other person's webpage link on your
ReplyDeletepage at appropriate place and other person will also do same
for you.
It is really a great and useful piece of information. I am happy that you shared
ReplyDeletethis useful info with us. Please keep us up to date like this.
Thank you for sharing.
By the way, I heard about this awsome affiliate program
for Instagram influencers. Better apply soon before all the spots are
filled up. Here is the link: http://chilp.it/c99a7d8
Good site you've got here.. It's difficult to find good quality writing like yours nowadays.
ReplyDeleteI really appreciate people like you! Take care!!
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up. Here is
the link: http://we.cx/3tggc
hi!,I really like your writing very so much! share we keep up a correspondence extra approximately your article on AOL?
ReplyDeleteI require an expert on this area to unravel my problem.
May be that's you! Looking forward to peer you.
By the way, I heard about this awsome affiliate program
for Instagram influencers. Better apply soon before all the spots are filled up.
Here is the link: http://urlki.com/3doec
I need to to thank you for this wonderful read!!
ReplyDeleteI absolutely loved every little bit of it. I've got you book marked to look at new things you post…
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://gul.ly/vi78g
It's remarkable designed for me to have a site, which
ReplyDeleteis useful for my know-how. thanks admin
Excellent way of explaining, and nice post to take data about my
ReplyDeletepresentation subject matter, which i am going to deliver in school.
By the way, I heard about this awsome affiliate program for Instagram
influencers. Better apply soon before all the spots are filled
up. Here is the link: http://gul.ly/vi76m
It's amazing in favor of me to have a site, which is valuable for my knowledge.
ReplyDeletethanks admin
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up. Here is
the link: http://rlu.ru/2wexC
Very descriptive blog, I loved that bit. Will there be a part 2?
ReplyDeleteI could not refrain from commenting. Exceptionally well written!
ReplyDeleteBy the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://urlki.com/3do8m
Simply wish to say your article is as amazing. The clearness in your submit
ReplyDeleteis just spectacular and that i could think you are an expert in this
subject. Fine along with your permission let me to
snatch your RSS feed to stay up to date with approaching
post. Thanks a million and please carry on the gratifying work.
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://qtx.de/384ma
The other day, while I was at work, my sister stole my iPad
ReplyDeleteand tested to see if it can survive a forty foot drop, just so she can be
a youtube sensation. My apple ipad is now
destroyed and she has 83 views. I know this is totally off topic but I had
to share it with someone!
By the way, I heard about this awsome affiliate program for Instagram influencers.
Better apply soon before all the spots are filled up.
Here is the link: http://qtx.de/383jd
Way cool! Some extremely valid points! I appreciate you writing this write-up plus the rest
ReplyDeleteof the website is really good.