Apps Script - WebApp Form: Update Data Realtime From Google Sheets Without Refreshing Page (Part 1)
ฝัง
- เผยแพร่เมื่อ 9 ธ.ค. 2021
- Source code:
docs.google.com/document/d/1d...
Part 2: • Apps Script - WebApp F...
Thanks for your support, like and subscribe.
You could support my video and my channel through this paypal link below :)
www.paypal.com/paypalme/pedri...
consulthinkprogrammer@gmail.com - วิทยาศาสตร์และเทคโนโลยี
Hi, excellant work you have done sir. Superb and good effort. I salute your contribute to society activity like gave source code and proper explanation. It's really make you as hero to new developers. One again thankyou. And please continue small small video like this with code.
Great and Excellent doing.
I was wondering it since long time. Very thankful to you for sharing this helpful tutorial
You are a MAGICIAN! Thanks a lot for share your caluable work. Thanks
Hi, Lovely work, we can modify it into an invoice designed on google sheet, great work dear. Always love to see your vides as uploaded. Wish you a happy and healthy life.
Thank you. In the next few videos I will develop a project invoice that I have made before.
Very good my friend, and thank you.
Ini video yg saya cari cari. 😍. Makasih
Siap. Sama-sama Pak.
Buenas, gracias por los aportes sería ver bueno ver el tutorial en español, saludos desde Colombia
it is possible to do this in the table, let's say I have two users editing the table and when one does the editing the other visualizes it in a moment.
Yes. But we have to consider if the user edited the same cell in the same time, because this project not really real time, more to refresh the webApp as quick as we sets
punya ku kok ga bisa buka apps script ya bang? muncul "Sorry, unable to open the file at present.
Please check the address and try again.
Biasanya itu terjadi di webApp yang baru dibuat Mas, kadang ngga langsung bisa dibuka di beberapa device. Tapi beberapa hari kemudian biasanya normal dan bisa dibuka.
Untuk saat ini, solusi jangka pendeknya, di device yang ngga bisa buka linknya (ada keterangan error seperti yang Mas gambarankan), buka link tersebut di tab penyamaran atau incognito.
I have watched this video from beginning to 11:35 for more than 10 times but my data is not updating. I have deployed bot the codes, added sheet api library and checked the code over and over again. What could be the problem?
This is what i have in script tags
document.addEventListener('DOMContentLoaded', function(){
setInterval(function(){
let title = document.getElementById('titles');
let subTitle = document.getElementById('sub-titles');
google.script.run
.withSuccessHandler(data => {
title.innerHTML = data[0];
subTitle.innerHTML = data[1];
})
.setAutomatically()
}, 2000)
})
This is what I have in code.gs
function doGet(e) {
return HtmlService.createTemplateFromFile("form").evaluate()
.setTitle("WebApp Form Series #5")
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}
function setAutomatically(){
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sheet = ss.getSheetByName('Data');
let val1 = sheet.getRange('A2').getValue();
let val2 = sheet.getrange('B2').getvalue();
return [val1, val2];
}
Sheet name is Data and when i change the values, it does not change in the result. I have checked the codes more than 10 times but could not find any issues. Please help.
@@kawalpreetkaur1848 1. Check in your webApp HTML, do an inspect element then see if there an error or not; 2. In your Code.gs, change getValues() with getDisplayValues()
@@ConsulthinkProgrammer Thanks for your reply. I finally figured out what was causing the problem If you see this line val2 = sheet.getrange('B2').getvalue(); letter R and letter V was small case. I changed the case to upper case getRange and getValue and it worked. I dont know if a small case can also cause this problem. If that is the case then it was a very silly mistake from my side which took me so much of time to figure that out.
Eagerly waiting for the 4th video of your login series. Thanks for everything !
is it possible to bring data in tabular format to page realtime ?
Can you be more specific about where the tabular data comes from? I usually use Google Sheets
Please make a video on how to copy data from one sheet to another in real time.
Thanks in advance
Like importrange but in apps script version?
This one may relate th-cam.com/video/MY80fbb-WwE/w-d-xo.html
@@ConsulthinkProgrammer Thank you 👍
Also I am looking for the same for two different external sheets rather than within sub sheets if you could make a video on it it will be great help for my project 🙏
kok saya coba, baru coba ganti titttle di run muncul ini An unknown error has occurred, please try again later.
Muncul error di file Kode.gs? Di HTML-nya ada perubahan? Coba perhatikan step by step lagi ya, biasanya krna ada step yg terlewat.
Kalau sudah merasa semua step sudah dilakukan tapi masih error juga, boleh lanjut konsultasi via email
@@ConsulthinkProgrammer saya konsul via email mas
@@dasawarsa1 Baik.. Akan saya cek selesai jam kerja
Sir how to create submit after redirect form using google web apps script
Maybe I will make it later
Okay
Boleh minta contactnya. Apakah menerima jasa?
Untuk kontak, bisa mengubungi saya melalui email yang ada di deskripsi video. Saya juga menerima custom request
Gimana kalo itu dijadikan chat messaging om implementasinya?
Project ini bisa dibilang tidak relevan dengan chat messaging app. Kalau mau di-develop, lebih cocok sebagai CV online atau kebutuhan lain yang berkenaan dengan visualisasi secara realtime data dari Google Sheets di HTML/webApp, almost kaya Google Data Studio.
@@ConsulthinkProgrammer i see, nah, kalo biar bs baca sheet row kebawah tampil di webapp, implementasinya sprti apa kalo kira2 pake konsep itu..
@@adaptivlabswebappdeveloper9046 Coba cek video terbaru saya hari ini ya. Mungkin relate.
Sy coba pake datatable kok ga bisa ya bang. Putih blank datanya