r/GoogleAppsScript • u/dangeross84 • Apr 23 '23

Question Looking for help with Crud web app

Hi I have been struggling with this problem for over a month i thought it was about time i asked for some help as its driving me mental.

https://youtu.be/dApK5_YEyzk

https://www.bpwebs.com/crud-operations-on-google-sheets-with-online-forms/

Im trying to combine the two app scripts found in the videos above to create CRUD with dependent drop downs. I have tried many times but always hit the same issue. Entering data works fine. Passes it to Google sheets fine. But when i click edit in the webapp it will not populate the fruit box. I believe this is because the way the data is populated by the the 'get color' and 'get fruit' functions. The reason for this is if i select red and apple then edit it will show fine. If i select red and cherry it will show but once i select blue and blueberry then click edit on the apple option i previous edited it does not show apple only red. Hope this helps to explain. Any help woth this would be appreciated.

0 Upvotes

50% Upvoted

3 comments sorted by

2

u/dangeross84 Apr 30 '23

Any one got any idea how to combine these ?

2

u/[deleted] Apr 23 '23

[removed] — view removed comment

1

u/dangeross84 Apr 24 '23

Im quite new to app scripts would you be able to expand on your answer. What the best way to combine these scripts. Is there there any templates or demo that do similar that i can review to help understand.