Scribbling Dock

I've shared how to insert image in google spreadsheet here . But what if, my image is in my google drive? so here it is ... Link to my google spreadsheet . NICE!

An update from this log . A year ago, I was trying to populate my google form, from a column in a table, using a script formRanger . At that time, it can only be use in old google spreadsheet. So, when I change to new google spreadsheet, I can no longer use it. But today, I found out, it is in google Add Ons ... So... I'm in hype! The best thing is .. it can use other spreadsheet as the source. Nice he? So anyway ... I prefer to have my list in the same spreadsheet with the respons report of my form, so first thing is ... I prepare my table. I put it in another sheet, the first row is the title of the list . So if you use other spreadsheet as the source, just make sure you put the first row is the title, If you don't you'll lose the first row in the list. the list Since I start from the spreadsheet, I make a form from that spreadsheet, so it will attach automaticly. click form - edit form ... it will take you to form. The first time, I instal formRanger, just once...

I just found out that you can insert an image in google spreadsheet not just in a floating image, but inside of a cell, so you can call it back in other cell. Check it out here . The function is: =IMAGE(url,[mode],[height],[width]) ( 3 last part are optional ) First, you should have an url for your image. How? I put my image in picasa, it connects with google, and share it to get the url. This URL must have the image extention, such as .jpg, or .png, or ... if you have a website, you can put it there too ... so you can have the link. ... and then, choose the mode for the image. mode 1, is the default, so if you don't write it, it automatically use this mode. mode 2, will streatch the image to fit the cell mode 3, will show the original size. mode 4, you can custom the size as you wish. with this function, you can call the image anywhere you want in the spreadsheet. even in pivot too .... Just try in my spreadsheet , you'll get the idea. Source: Google Suppo...

Sekarang sudah tidak asing lagi ya, foto yang pakai geotagging .... Geotagging (also written as GeoTagging) is the process of adding geographical identification metadata to various media such as a geotagged photograph or video, websites, SMS messages, QR Codes[1] or RSS feeds and is a form of geospatial metadata. This data usually consists of latitude and longitude coordinates, though they can also include altitude, bearing, distance, accuracy data, and place names. Source Ini artinya, setiap foto yang pake geotag, bisa kelacak dimana foto itu diambil. Nah ... lebih seru lagi, kalo info itu ditampilkan bener-bener di peta. Semenjak Google bikin map online , lalu koleksi foto di picasa .. sekarang bisa dikombinasikan untuk menampilkan seperti ini: caranya ...

Story of Tanjakan Seribu and Puncak Guha ODT (One Day Trip) bersama bersama suami dan teman-teman ... Pukul 10 Malam, 13 Oktober, kami berangkat dari Jakarta. Tiba di Cimahi pukul 4 dini hari ... Jam 9an besoknya berangkat ... menyusuri jalur Ciwidey - Situ Patenggang - Tanjakan Seribu (banyak itu fotonya) - terus ke selatan, masuk hutan dan keluar di Cidaun - belok kiri ke arah pamengpeuk (Santolo) - Menyusuri pantai, melewati Objek Wisata Ranca Buaya, lalu berakhir di Puncak Guha. Pulangnya, lewat pengalengan langsung ke Bandung. Istirahat di rumah teman dulu, lalu jam 00.30 balik Jakarta. Sempat tepar di Maranggi puncak, but berhasil tiba di Kosan pukul 7, istirahat sebentar, jam 9 berangkat ngantor .. OMG ... So anyway .... here are some details ...

The future is here!!! Dulu pernah masalah dengan bikin notulen rapat. Butuh tukang tulis yang bisa mencatat semua percakapan. Tapi repot ... But hey ... the future is here!!! ^_^ Sekarang, google bisa voice typing ... dan udah dicoba, ternyata cukup bagus ... asal dia bisa dengar dengan baik. How? Make sure your mic is on and active Open a google doc  click File -> language ... choose your language ... click Tools -> Voice Typing  click the microphone icon and start talking ... Keren ya? 

Entah sudah berapa lama gue dihantui dengan kesalahan informasi di produk yang gue buat. Tuduhan-tuduhannya seperti berikut .... Ons TIDAK SAMA DENGAN ounce 1 kg bukan 100 ons (ounce) .... produk salah kaprah ! Lalu, apa dong yang selama ini diajarkan pada kita? Well ... setelah cari-cari info, jadi sebenernya, bukan salah kaprah ... tapi menurut gue .. hal ini lebih ke masalah kurang informasi.