Hello I am new to appsheet. I have a problem here with dropdowns and google spreadsheet updates.
I have a spreadsheet (name as “info”) with, say, 3 columns: Number, name, age. There are 5 datasets already filled in this spreadsheet. I used the 3 columns to create dependent dropdowns in my app and it works pretty well. I have one more option (Y/N) for the user to key it so that the app would be like an app for user to respond to invitations, and their responses are stored in another spreadsheet (name as “response”)
However, if there are new users (besides those 5 already filled in the “info” spreadsheet), I would like to allow users to enter their info into my ‘info" spreadsheet. Since I am storing the users’ response in the “response” worksheet, is it possible to let users to enter new info to update my “info” spreadsheet, instead of adding them into the " response" spreadsheet?