Skip to main content

Hi there,


My company want to have a dropdown field containing a list of values that exist on an internal database. I have built an API for this database and I was hoping to create a custom column for their Monday board that is essentially the Label field but instead of manually updating the list of options in this column it would act as an Autocomplete field, querying the API and returning a list of matches?


Is this at all possible in anyway in Monday/Monday Developer?


Thanks,

James

Hello there @Jopgood and welcome to the community!


I hope you like it here 💪


Does this column have to be editable? Should it be blocked so that the users can not change it manually? Does it have to be of type “dropdown”?


Hey Matias, thanks so much for your response!


So the board in question is for users to submit items to (like an invoicing table). So ultimately it may be turned into a form anyway. But ideally the user can choose from a list of options (or more ideally search through a list of options). These options are retrievable from an API endpoint but is best done via a remote search because this list can often change/grow over time so manually keeping it up to date just isn’t viable.


P.S. I am aware we could build an external form and have their submissions reach the Monday board via API but the company works all on Monday so we’re just trying to keep things in-Monday.


Hello again @Jopgood,


As of today there is no way to create a column that retrieves options dynamically.


What you can do, is add options to a dropdown column with a mutation like this one:


mutation {
change_simple_column_value (item_id:1234567890, board_id:1122334455, column_id:"dropdown__1", value: "Something new", create_labels_if_missing: true) {
id
}
}

And you can use the API also to read the values of the dropdown column for each item and eras the ones that are deleted from your source platform.


It is not ideal, but I believe it might be the closest you can get to what you want to do using a column.


Let me know if you have any other questions!


Cheers,

Matias


Reply