Learn how to connect the userform to Google Sheets spreadsheet and use Bootstrap as a user interface. This tutorial is Part 2 from Google Sheets Userform - Level 2 series • Google Sheets Userform... #userform #googlesheets #bootstrap
Thank you, Thank you, Thank you. I am waiting for more videos of this series. I am sure, this shall add immense value for sheets in my organization. Thank you
Friendly tip: using hyphenated variables prevents double-clicking on entire variable name. I prefer underscore (so item_name instead of item-name). Great series.
I did everything the same way but button click is not working. Also the html code from had some changes in the script part. I don't know why it is not working, can you help?
Good job, I have a special question and I am not sure which of your video is the right one: I want to create a chart and I have different sheets for January, February (...) Every sheet has the same layout and in the Final sheet I want to get all the data from there but I don't want to copy all of them. Is it possible to use a formula to change just the sheet name? e.g. January!A2 January!A3 and then I need for every other sheet the same February!A2 February!A3 (...) I didn't find a solution yet to change sheet reference in the formula. Thank you in advance!
Hi. I want to add a droplist like this on a hmtl form and send results to another google sheet. Can i use this method? This example save in the same sheet. Thank you for all the assistance.
Hi, wonderful tutorial explained very well, congratulations!!! About showModalDialog or showSidebar I have a question that I can’t solve: how suspend the server-side script while the showModalDialog or showSidebar is open? Basically I would like the script resumes after the user dismisses the dialog. Sorry for my bad English I hope I made myself clear. Thanks bye Gabriele
Good day sir! I have a question sir. What if i wanted this form to automticatically open when i open the google sheet file would it be possible? I tried it by not puting the createMenu & onOpen function but it didn't work. What should i do? Thanks in advance
I'll have to double check but I think the AppScript editor has a lot of the same key binds as VS Code. You should be able to alt + shift + F to format the entire document, indentation and all!
Thank you, it's very good series. However I have not any idea how to create email with clickable button and function which can modify value in spreadsheet.
Gréât video. How would one go about having a sidebar entry form in which you could add lines of items before possibly validating the form . I have a spreadsheet for sales, with one sale having potentially several items (not more than 5) : the form would basically need date and sale number as fixed fiels and then have one or more items that would each be sent onto a separate line of the « saleitems » sheet?
Sorry, but again, when search for "Starter template" in getbootstrap, a different example show up with what appear to be arabic characters. Any advice? Thanks
google.script.run.doSomething(values) is not working with sidebar I am using new code editor. Showing type unknown and status failed in executions. Please Suggest something....
Is there any way to limit the userform to a particular tab? Or at least make the userform sidebar much larger? My idea was to limit the userform to the first tab in a workbook, where all you can see is the userform.
It is really amazing, but if we want to make an interface form then we need to have reset, delete, search, update...etc as well as sometimes we may need to have drop-down list in the interface form. I really love ur videos and if you can make these things that would be awesome. Thanks in advance.
one year after. But is there a way to create a load of info to be able to save it as directory? so from a google form we collect name, email, phone. and get the data to paste into a directory.
Thanks for this amazing video. I did and it works. But when I create with many data in column and i have followed step by step as seen in video, the data cannot add from form to spreadsheet. Please help me.
Hey, thanks so much for this content, its super helpful. I am having some trouble though. I copied everything exactly as in the video, and re-did it again. Everything works up till the button click. But, I cant get the click to run the script.
@@ExcelGoogleSheets Thanks so much, that video was also incredibly helpful. I found it was an authorization issue. After authorizing it in my default google account, its working perfectly.
have the same.. mine it works only with the first example, by specifying the value of the constants. otherwide the last method gives me 'undefined item'
Hi whatever you did its goes well for me but what i want here to do is i want to run this code in every sheet of the workbook in same range so can you help me please to modify the code
Very helpful serie ! Thanks again I come back to this video because i need to add an "radio" input to the form but there is a different ID for each option so i don't know how to process this with the JS Would be gratefull if someone can help !
@@ExcelGoogleSheets ibb.co/Sdsbm1W My drop-down has around 100 items which is not easy to select. So I chose to use . But when the form loads it also shows all options on top of the form. Without the everything works fine. After doing a quick search I found that Bootstrap isn't compatible with datalist.
@@ExcelGoogleSheets Bootstrap isn't compatible with datalist at least on chrome as said in this post. stackoverflow.com/questions/48722834/how-to-use-html-datalist-with-bootstrap Fixed it using www.w3schools.com/tags/tag_datalist.asp datalist { display: none !important; }
First of all, thank you for the tutorials! really helpful however i have a question. 1.My data is inserted just fine however, when i added arrayformula in the sheet itself , it kinda fucked up the whole sheet and i cant insert data into rows anymore. How do i fix this? Basically what im tryna achieve is when i input data into the sheet, the data will be calculated in a different collumn, so everytime i input data, it will automatically calculate the data i input into new rows. Thank you
Easy way around this is to use a copy sheet, I have an example here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0v-hQ3EecdE.html You can also use array formulas that don't overflow the range.
@@ExcelGoogleSheets Thank you kind sir, Although the first solution sounds interesting, i feel like using the second since it fits my project more. Therefore, how can i use the array formulas that dont overflow the range? is there any tutorial youve made?
Hi guys. I'm just starting with gs. I'm stuck right in the beginning (first running the app ~ 5:05). It shows the sidebar, but it doenst show the "Hello World" beneath. I just copied the starter template from bootstrap like you did. Any tip?
Thank you for the video. I did exactly the same code as the video, everything works almost but at the end when we get the input in the texts Item and Qty and click Add button, doesn't insert any data to the Google sheet. I tried checking the RU-vid video Google Apps Script & Web App Debugging of yours to debug but when I am trying to publish the code as "Deploy as web app", the web app gives the error - "Script function not found: doGet". Please help.
Thank you again sir. Question: Can the user be able to mess with already entered data in the sheet? Is there a way to lock it so they can only enter in from the form?
Thanks for your video. As soon as I click the button on the HTML, I receive an error 'ERROR: Authorization is required to perform that action.'. I have checked the authorization and it looks fine. I went here -> myaccount.google.com/permissions and checked the authorization status and it looks fine. Has access to: Google Docs - See, edit, create, and delete your spreadsheets in Google Drive Additional access - Display and run third-party web content in prompts and sidebars inside Google applications Please guide - what am I missing?
The video was awesome! It worked while using hard codes. But when procedure for get form data it stops working. Debug returned: "Cannot read property 'item' of undefined addNewRow @ funcs.gs:5" - I checked every character and evereything seems to be exaclty like shown in the video. If someone have a hint I would appreciate. Thank´s.
@@OswinTan Log into your browser with same email which you are using to make user form. You need to log in with same account into chrome(if you are using)and Gmail. 👍👍
I'm having problem running the funcs.gs file can you help me with this? TypeError: Cannot read property 'item' of undefined (line 7, file "func") function addNewRow(rowData){ const currentDate = new Date(); const ss = SpreadsheetApp.getActiveSpreadsheet(); const ws = ss.getSheetByName("Results"); ws.appendRow([rowData.item,rowData.qty, currentDate]); } I copy all the data you did in uform.html. The form did came up on spreadsheet but when I try to put some data and press Add it doesn't went to my spreadsheet. I'm a newbie on this but I'm very interested on learning it..
@@ExcelGoogleSheets Item Name Quantity Received Save function addRecord(){ var item = document.getElementById("item-name"); var qty = document.getElementbyId("qty-received"); var rowData = {item: item.value,qty: qty.value}; google.script.run.addNewRow(rowData); } document.getElementById("btn").addEventListner("click",addRecord); ...
this is piss me off. I replicate this entirely with no mistakes, and when i run ADD button, do not work. The problem is that Somethimes eventListener do not listen or i do not know. Purley do not work. Stuck after add button and the event listener. That step is not working. ANY IDEAS!? I went over the video and recreated twice but no luck. Works up till the last step. Then Done!
Dear all, I tried to reproduce the program, but at the point in which I have to write the addrow function and the button function nothing happens. I checked the dubugs, I inspected and I have some warnings. Here is thaty part of the code. I attach some warnings as well. the id of the button is defined and correct. const ss = SpreadsheetApp.getActiveSpreadsheet(); const ws = ss.getSheetByName("Results"); function bottonadd(){ var itemName = document.getElementById("item-name"); var top = document.getElementById("topic"); const aa = itemName.value; const bb = top.value; const currentDate = new Date(); ws.appendRow([aa,bb,currentDate]); } document.getElementById("main").addEventListener("click",bottonadd); debuggs: - Uncaught ReferenceError: SpreadsheetApp is not defined at userCodeAppPanel:2 - Failed to load resource: net::ERR_QUIC_PROTOCOL_ERROR.QUIC_PACKET_WRITE_ERROR Someone had the same problem and solved? Please help me. I surrend :( Thank you
Hey, I wrote the script same as yours but I am getting the following error while running funcs script file: "TypeError: Cannot read property 'item' of undefined (line 7, file "funcs")". The line number and codes are exactly same as yours. Please do help!
Hi Jithin, I understand that you have resolved it for the "TypeError :Cannot read property 'ítem' of undefined. I am having the same error like yours. Can you please share how you have resolved it ? Thanks a lot.
Below is the script I wrote per your instructions. However I am getting this error message "HtmlService.createTemplateFormFile is not a function " //... function loadForm() { const htmlForSidebar=HtmlService.createTemplateFormFile("uform"); const htmlOutput=htmlForSidebar.evaluate(); const ui = SpreadsheetApp.getUi(); ui.showSidebar(htmlOutput); } ...// Can you help