Updating Column Dropdown List using an API or other alternatives

Jen K. · 08/05/24

Hoping someone can assist. I am aware that a Data Shuttle can be created to achieve what I am looking for, but due to the expense of a Data Shuttle I am looking for alternative options. Can anyone provide me an example of something they built using the API option or something else that worked on updating a dropdown list dynamically? Thank you in advance!

Alex Argumedo · 08/09/24

I can help you with the logic ::

Create a sheet that contains the following columns:

sheet source (for the dropdown content) ID
column source (the dropdown itself) ID
the destination sheet ID
the frequency
any other rule

then create an script that will read each row retrieving the contents of the column in the source sheet

create a list with the fields of the dropdown

then in the destination make sure you set the column as multiple choice

use https://smartsheet.redoc.ly/tag/columns#operation/column-updateColumn

making sure the field type is according to the column type,

read the frequency and execute accordingly.

Jen K. · 08/09/24

Hello. I appreciate your response Alex, but I would need more details and an example on these steps especially the script part. I am basically clueless on API methods. Thank you

Saul C. · 08/10/24

https://community.smartsheet.com/discussion/comment/448527#Comment_448527

Does anyone else feel like this should be a standard feature?

I’ve wonder if control center would also do this? I think it would still be manual, but if I could update all sheets at once with the new drop down list that would be much better. Currently I have to manually go to each sheet, even though they all come from the same template, and update the data validation on that row.

jmyzk_cloudsmart_jp · 08/11/24

Hi @Saul C.

It was previously possible to update dropdown list options in SCC, and now it is also possible to do the same with multiple dropdown lists

https://www.smartsheet.com/content-center/product-news/release-notes/control-center-global-update-multi-select-column

Updating Column Dropdown List using an API or other alternatives

Answers

Categories