I have a google spreadsheet using which have created an app in appsheet.
sheet1 contains a dropdown menu based on a list in sheet2. the list in sheet2 can be changed manually.
This change is not reflected in the app even if i do sync. but it is reflected only after I do regenrate schema.
I need it to update every time it is changed, or via the sync, or is there a way to auto regenerate schema each time sheet2 is updated? Trying a lot, but unable to find out, can please anyone help. Thank you very much