Google sheet drop-down list control mit appinventor

MIT App Inventor Help
1

Hi
It possible to control google drop-down list on MIT appinventor?

2

Can you explain bit more about problem.

3

@preetvadaliya
I want to sheet data update from MIT appinventor I can do this type data or select spinner or list picker but I have need select or click drop-down list on sheet. How I can do this on mit appinventor?

Screenshot_20220218-000142__01__01__01
Screenshot_20220218-000142__01__01__011926×1080 251 KB

Or like this

Screenshot_20220218-001744__01
Screenshot_20220218-001744__01828×891 106 KB

I want to click this drop-down list from MIT appinventor.

4

This can be easily solved by Google apps script.

And we have one good script writer @TIMAI2 .

He definitely help you.

5

Its possible do this from appinventor?

6

@Rafik30905 I am not sure but as I know we can create a dynamic dropdown in GoogleSheet using GoogleAppsScript but maybe there is something for click dropdown also.

If you are able to write the AppsScript then probably you need to look at SpreadsheetApp.newDataValidation().

7

@Rafik30905 but why do you want to click it from App Inventor App, you can create a dropdown in App using a spinner or list view then get a selection from the user and then send this value to your sheet.

1 Like
8

@preetvadaliya
I have already create a spinner list But the problem is that when you have to add a new item to this list, you have to update the apps which all the app users have to update again. But if I can use sheet Dropdown lest then just edit the dropdown list of google sheet.

9

You want to work with the data that is used in the drop down, not the drop down itself.

You could use an apps script to edit and update the data, or a more complicated solution using a Google form and an apps script function in the spreadsheet.

You could consider making your list in clouddb or firebase