Many thanks! You and your channel are really important for my work as a Co-CEO for a small company. I love data and I love to automate our process, and everything you teach is clear and powerfully useful
You are awesome bro. Many thanks. But, please we asked some questions in the previous tutorial videos. Hope, you will have time to answer us. Thanks again. Keep up this great work.
Hi Master! THK you. Need to learn how to validate from back end to front end, mean that if you create an user for example, avoid doing if the email is in a google sheet column , do you have a video that can guide me on this? Thank you again, love your videos
thanks, bro! awesome videos! is there any way to show dependent dropdowns dynamically. For Example for some items i have 3 levels to choose(exactly like in video, but there are items with only 1 or 2 levels of dropdown lists. So is it possible to show the third level only when the second level is not empty?
Great tutorial but what if you have two input fields, how would you add validation if you wanted to only validate a specific input field not all input fields?
Your vids are great. Another question... Is it possible to turn off the suggestions for a text input? My date field remembers past dates I have entered and displays a list of them that covers the datepicker.
@@ExcelGoogleSheets BTW, how did you get the date to make the popup drop appear without clicking on the arrow on the right? It looks like you are just clicking in the input box. I have to click the arrow to make the date popup appear.
@Learn Google Spreadsheets Hello, google spreadsheets master. How are you doing? Would you mind to let us know how to open another sheet according to the user input value? I will appreciate your kind wisdom ...
Many thanks!
You and your channel are really important for my work as a Co-CEO for a small company. I love data and I love to automate our process, and everything you teach is clear and powerfully useful
Great to hear!
Muy interesante....
You are awesome bro. Many thanks. But, please we asked some questions in the previous tutorial videos. Hope, you will have time to answer us. Thanks again. Keep up this great work.
Not sure what questions. I just answer the top 10-20 comments I see in the feed. It's impossible to reply to every comment.
Hi Master! THK you. Need to learn how to validate from back end to front end, mean that if you create an user for example, avoid doing if the email is in a google sheet column , do you have a video that can guide me on this? Thank you again, love your videos
thanks, bro! awesome videos!
is there any way to show dependent dropdowns dynamically. For Example for some items i have 3 levels to choose(exactly like in video, but there are items with only 1 or 2 levels of dropdown lists. So is it possible to show the third level only when the second level is not empty?
Great tutorial but what if you have two input fields, how would you add validation if you wanted to only validate a specific input field not all input fields?
Don't add required to the html element.
Your vids are great. Another question... Is it possible to turn off the suggestions for a text input? My date field remembers past dates I have entered and displays a list of them that covers the datepicker.
That's your browser doing it. Try adding see if it helps.
@@ExcelGoogleSheets Thanks. I will try that.
@@ExcelGoogleSheets BTW, how did you get the date to make the popup drop appear without clicking on the arrow on the right? It looks like you are just clicking in the input box. I have to click the arrow to make the date popup appear.
That's browser specific. I'm on Firefox and that's how date field works on Firefox.
@@ExcelGoogleSheets do you have a vid on better date implementation that is cross-browser compatible?
@Learn Google Spreadsheets
Hello, google spreadsheets master. How are you doing?
Would you mind to let us know how to open another sheet according to the user input value?
I will appreciate your kind wisdom ...
Hi there
I am having issues with update to sheepon submit if i have 2 switch buttons.
First button work as per ur video, but second one doesn't.
I mean something similar to arrivalTime
man HOw can I make drop down from another spreadsheet!, Please
Thank you very much . Can we change user form size? I think it’s too narrow.
function loadForm() {
const ui = SpreadsheetApp.getUi()
const Sidebar = HtmlService.createHtmlOutputFromFile("Form").setHeight(900).setWidth(900)
I would load it as a dialog instead of sidebar.
@@melenev setWidth/setHeight have been removed by google.
@@ExcelGoogleSheets Can you change the size of the modal dialog box?
please. I can't collect decimal numbers on Google spreadsheets. I'm getting an error. #VALUE! What is the solution
change input type to text
Mentor