Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 14, 2019 02:28 PM
I have a need to insert new select option into field but when i try to do it with node api i get.
Class {
error: 'INVALID_MULTIPLE_CHOICE_OPTIONS',
message: 'Insufficient permissions to create new select options',
statusCode: 422 }
I have admin permissions. Is there a way to insert array of new options into Multi select field ?
Mar 15, 2019 06:18 AM
Hi Uros, I see this is your first post so welcome.
The API does not currently support creation of tables and fields.
These will have to be set up via the UI interface and the API is for retrieving and updating the information that is already there.
Also as a side note any questions related to API you can put in the API category of the forum.
May 03, 2019 05:43 PM
Chinara,
How is it possible that, when creating a new record with Zapier, the creation of a new option in a single select is done?
May 06, 2019 03:28 PM
We have this need as well. We have an automated process to sync records to Airtable from our database via the API. We have to track down the new value when an error occurs during a sync then have to manually add it to the multi-select field. It would be super nice if it could be done via the API automatically instead.
Edit: It’s also made worse by the fact that the error message is generic, thus we don’t know the offending column either.
May 27, 2019 08:30 AM
Ok, I thought the original person was asking to create a new multiselect field but you want to add options to an existing multiselect field. Theoretically I think this should be possible by supplying the array of options via the API but I have not tested this myself.
Also in what way are you adding the option? During the create record operation or update record operation?
May 27, 2019 06:16 PM
I’m trying during the create record. I want to add a new option to an existing single select field. It throws an error but somehow this can be done with zapier.
May 28, 2019 06:16 AM
Ok I have tested your use case and you can’t add the option on either the create or update methods. I have never used Zapier integrations with airtable but perhaps they have a relationship with Airtable that allows them to do this. You will probably have to reach out to the Airtable team to ask what’s up.
A possible workaround, I don’t know you how your database is designed, is to have the options in a separate table and link that record. That way you can use the create and update methods on that table.
For example think about a users table and roles table. A user can have roles of Admin, Editor, Subscriber. These can be store in a separate table.
Oct 02, 2020 11:37 AM
Was there ever a solution for this? Running into the same issue. Thanks
Feb 18, 2021 07:05 AM
Hi all,
You can create new select options via the API with a record creation call by including the typecast parameter in your request body. Reference our API Documentation for more information on this parameter and how to include it. Here’s an example request body for creating a record with new options in a multi-select field:
{
"fields": {
"Multiple Select Field Name": [
"new select option",
"another new option"
]
},
"typecast": true
}
Feb 18, 2021 07:17 AM
Does this also work in Script Blocks?