Great to hear! I use the Chrome Add-on Apps Script Color. Note that it can mess up the loading of a new GAS project, just let it time out when it asks you to. chrome.google.com/webstore/detail/appsscript-color/ciggahcpieccaejjdpkllokejakhkome
Thank you! Very clear tutorial. I only had one problem: the data did not show up in the sheet and I got an error in the log. It went away when I am in incognito browser. Then there is no problem at all. Not sure how to fix that.
Hi Daniel. Not sure about your specific circumstance, but often this occurs when you have logged into chrome in one account but logged into Google Sheets with another.
Scott... How if now I want to create checkbox, and allow user to have a multiple selections, and only the selected one send to googlesheet? Like I select EV001 and EV002, and both of them send to googlesheet. Thank you.
Sorry, brain fart. I was playing around with process xxx and forgot to restore the proper file name for the function in my apps script with is processInput. That's why the editor suggested Input since that is the real file name. But with that repaired, still no joy.....
Unfortunately, you can't double click or use special key shortcuts for this. You could try and an onEdit() or onChange() trigger, though to create an event that opens the sidebar when a cell is edited or a change occurs in the sheet. developers.google.com/apps-script/guides/triggers/installable
Suggestion: Add a button in the sidebar to "Open Current Record". When this is clicked, it would load the values in the current row (the one your cursor is on) and allow it to be edited. For delete, it seems like it's better to just right-click on the row and choose Delete Row.
Hi! If for example you had 300 fleets and this way would make the user click and scroll. Is there a way to code it to be a suggested search dropdown? So instead to click and scrolling for EV162 they could type it in and would come to the top and would just take the user to click?
Yes. You can use a datalist on an input field. See this example: dev.to/vuesomedev/autocomplete-dropdown-using-native-html-moi Also note that in a dropdown menu you can type the first characters of the selection you want and it will navigate to that area.
Having trouble getting the values back to the script. Seems that onclick="google.script.run.processNode(this.parentElement);" is not doing it's thing. I can share a little spreadsheet I am using to develop the concept of presenting various different htmls depending on activity in the apps script which has the problem. I note that the editor does not offer Node as a choice after process, it only shows Input and that doesn't work either. I guess I have some syntax wrong someplace.
In the HTML file instead of directly running google.script.run, can call a function. Here you can apply the same google.scrip run an then add a success handler that, when successful, allows you to clear the input fields. You can use document.getElementById("inputForm").reset(); to reset the form then. developers.google.com/apps-script/guides/html/reference/run#withSuccessHandler(Function) yagisanatode.com/2020/11/25/creating-an-embedded-interactive-chain-story-app-with-google-apps-script-and-google-sheets/
Exactly what I was looking for. Thank you so much !
Glad I could help!
Awesome tutorial! Helped me out in my current project!
How did you enabled dark mode in GAS IDE?
Great to hear!
I use the Chrome Add-on Apps Script Color. Note that it can mess up the loading of a new GAS project, just let it time out when it asks you to. chrome.google.com/webstore/detail/appsscript-color/ciggahcpieccaejjdpkllokejakhkome
Thank you! Very clear tutorial. I only had one problem: the data did not show up in the sheet and I got an error in the log. It went away when I am in incognito browser. Then there is no problem at all. Not sure how to fix that.
Hi Daniel. Not sure about your specific circumstance, but often this occurs when you have logged into chrome in one account but logged into Google Sheets with another.
Scott... How if now I want to create checkbox, and allow user to have a multiple selections, and only the selected one send to googlesheet? Like I select EV001 and EV002, and both of them send to googlesheet. Thank you.
Sorry, brain fart. I was playing around with process xxx and forgot to restore the proper file name for the function in my apps script with is processInput. That's why the editor suggested Input since that is the real file name. But with that repaired, still no joy.....
Is it possible to double click on any record on the sheet and get it displayed on the sidebar form to edit or delete?!!
Unfortunately, you can't double click or use special key shortcuts for this. You could try and an onEdit() or onChange() trigger, though to create an event that opens the sidebar when a cell is edited or a change occurs in the sheet. developers.google.com/apps-script/guides/triggers/installable
Suggestion: Add a button in the sidebar to "Open Current Record". When this is clicked, it would load the values in the current row (the one your cursor is on) and allow it to be edited. For delete, it seems like it's better to just right-click on the row and choose Delete Row.
Hi! If for example you had 300 fleets and this way would make the user click and scroll. Is there a way to code it to be a suggested search dropdown? So instead to click and scrolling for EV162 they could type it in and would come to the top and would just take the user to click?
Yes. You can use a datalist on an input field. See this example: dev.to/vuesomedev/autocomplete-dropdown-using-native-html-moi
Also note that in a dropdown menu you can type the first characters of the selection you want and it will navigate to that area.
Hi, can i delete or replace by other text 'Aplicación Apps Script 'on the toP? Thank you
By the way Scott, I open the spreadsheet, but the appscript, is empty. EV1, EV5.
Yep. Both should be somewhat empty. They are starter sheets for you to set off and follow along from the same point in the tutorial as me. 😉
Having trouble getting the values back to the script. Seems that onclick="google.script.run.processNode(this.parentElement);"
is not doing it's thing. I can share a little spreadsheet I am using to develop the concept of presenting various different htmls depending on activity in the apps script which has the problem. I note that the editor does not offer Node as a choice after process, it only shows Input and that doesn't work either. I guess I have some syntax wrong someplace.
Hi Scott... very clear tutorial. But how if I want the data is cleared after I clicked the submit button? Thank you
In the HTML file instead of directly running google.script.run, can call a function. Here you can apply the same google.scrip run an then add a success handler that, when successful, allows you to clear the input fields. You can use document.getElementById("inputForm").reset(); to reset the form then.
developers.google.com/apps-script/guides/html/reference/run#withSuccessHandler(Function)
yagisanatode.com/2020/11/25/creating-an-embedded-interactive-chain-story-app-with-google-apps-script-and-google-sheets/
@@yagisanatode Hi Scott... thank you, I'll have a look that.
@@yagisanatode The chain story app --> no youtube video? :)
at 18:53, I don't get a log - instead, my processForm status is failed with an unknown type.
Hi Erika, you will need to look at the line that the error occurred in to better identify what happened to your script.
How is it that you get the Repo and branch menu items in your editor?
I use GitHub Assistant Chrome plugin by leonhartX chrome.google.com/webstore/detail/google-apps-script-github/lfjcgcmkmjjlieihflfhjopckgpelofo
@@yagisanatode thank you! I will have a look.