Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Add a new option to an existing Single-Select / Multi-Select Field

181 3
cancel
Showing results for 
Search instead for 
Did you mean: 
NicoM
4 - Data Explorer
4 - Data Explorer

Hello,

as explained in the title:

I have a table "User" I have a single select field named "Color" 3 value possible: Red, Blue, Green Using make.com, I want to add dynamically a 4th option "yellow" So that the new possible value for this field would be: Red, Blue, Green, or Yellow

I am planning on doing it via Make.com using the API module and a PATCH but i wanted to check if it was possible to do it from an airtable perspective?

thanks

3 Replies 3
Milan_Automable
6 - Interface Innovator
6 - Interface Innovator

Hi @NicoM !

You can use Update Record to with typecast enabled to add a new option, when setting a record's value to the new option, if you want to update the options via the API.

— Best, Milan - Automable.AI Free Airtable consultation

@NicoM 

Yes, creators and above can add new options in Airtable.

If you want editors to add new options via a form, you can do that via a form using Fillout’s advanced forms for Airtable, which gives your user an “Other” option that allows them to add their own option.

Otherwise, if you want to do that via Make.com, you simply need to use the Airtable - Update Record module, and update the field with your new option for any record that needs the new option. (Similarly, you can use the Airtable - Create Record module as well.)

Very important: Note that in Make, you will need to make sure that you scroll down to the bottom of those modules and enable the “Smart Links” option. If you don’t enable the “Smart Links” option, then you won’t be able to add new options.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hello, thank you all for your response, @ComfortDevelope  I think your approach is closer to what I want to achieve as I don't want to add this option if a new record need it.

What I would like to achieve is:

Table A - contain my SingleSelect field name Color with 3 value = Red, blue, green

Table B - Contain all the value of of my different singleSelect field:

ID - Category- Value

  1.  - Color - Red
  2.  - Color - Green
  3. - Color - blue
  4. -Gender - Male
  5. ...

I will use Make.com and here is the process I want to implement:

Table B, new entry : Color - Yellow

Make.com retrieve all the value associated with Color in table B [Red, Blue, Green,Yellow]
Make.com send these new value in Table A SingleSelect field Color
In my front end, my drop down has now 4 value visible

I have tried with patch but I had an error [422] Could not parse request body - Not sure what i do wrong

Thank you