How to export custom options a user saved in dropdowns

[gershy]

Using the dropdown in appsheets a user can add custom options that are saved for the user.

Where are those custom options saved? is it possible to view all custom options or somehow export them?

[Joseph_Seddik]

UNIQUE(tableName[dropdownColumn])

Better still, make a separate table listing the options, and make type of your dropdownColumn column a Ref pointing towards that new table. In this way, new options will be registered in the table and you can easily do further operations as needed on the options.

[gershy]

Hi and thanks for replying i am not setting anything up i took over an existing appsheets app and i need to see custom options that a user could have added to a dropdown (enum list) the solution mentioned will not show me where appsheets stores the options for each user, is there somewhere i can that?

[Joseph_Seddik]

The "options" and all other data is stored in the database (or sheet). If there was no per-user data stored in the database, for example through a userEmail column, then there's no way of finding which user had added which option.

Moving forward, you can do as I told you to make an "Options" table, with a column registering the user's email so that you'd know who added which custom option to the list. Then in your current table, you can add a similar column so that you know which user used which option.

[Trevwiller]

Depends on how you organize your tables-

- They are added as new rows to the data table. If you go to the data table. You should be able to see all the options listed in the column. 

- If not then they will only be saved on the row that was created from the form view. It is best to create a seperate table for the choices and create an enum ref to the table if you plan on having many user added options. This will keep them separate and organized.

[gershy]

Hi thanks for the reply but can you help me i took over this existing appsheets project, in the data all i see is the column and the type set to enum list, when i click on it i see the options (which are the default options) but the user has the options to add custom options when using the app where can i see those options?

[Trevwiller]

So there is not really a straightforward way to go about it. Will require time and most likely tears as all the data is saved in the table. So you would need to go to the data table or google sheet that the info is pulling from and go by hand through all the rows in that column to view every answer that has been inputted.