EMERGENCY: Airtable Create Record no longer wants to create data in single or multiple choice fields

[bastien]

I have a simple flow for importing Savvycal (Calendly-like) appointments into an Airtable table.

My flow was working fine until yesterday, so I didn’t change anything. Then suddenly, the flow stopped working and returned an error saying that Airtable refused to import data in multiple choice or single choice fields.

I did several tests and after removing the data sent in these specific fields, the flow works again.

This instability in the Airtable database is really annoying, and I’ve been experiencing major blockages for several times now. Please, if the Airtable parts are not stable, please report it.

Last week it was the Update Record piece that wasn’t working on single or multiple choice fields, now it’s the Create Record piece.

Can you please fix the bug urgently?

[bastien]

Please take a look at this problem history:

Can't map only one Airtable table from the database : bug?

I did delete and recreate my Airtable connection from scratch by providing the correct token authorisations. I’ve rebuilt the flow several times and the problem persists. In my database, Activepieces can’t bring up the fields in my ‘Sessions’ table and I can’t map, whereas it can bring up the fields in the other tables. The only noticeable difference between the table that doesn’t map well and the others is that the one that doesn’t map well has more records than the others (around 1500 recor…

Airtable Update Record deleting/cleaning a field data that I don't want to

When using the Airtable Update Record, it updates some fields that I don’t want to. It happens with fields that are linked with other fields on Airtable, like this one: [image] This field is in the table X and linked with table Y. And this field is always updated, even if I don’t want to. It also shows as empty in the Airtable udpate record piece: [image] If I don’t change the value and leave it as default, it just clean the current data that is in my Airtable. And if I filled it with a D…

[bastien]

@abuaboud @kishanprmr can you please help me urgently?

[kishanprmr]

Hello @bastien ,

How are you passing the data in the multiple-choice fields? Is it done dynamically, or are you selecting from dropdowns? Could you provide a screenshot for reference?

[bastien]

Dynamically, like this :

I’m sure the problem is with Activepieces because the flow was working fine yesterday and I didn’t change anything.

[kishanprmr]

Can you provide the Airtable template and let me know the incoming value from the webhook for this field in DM? Also, if it was working fine until yesterday, please share the flow link so we can troubleshoot the issue.

[bastien]

@kishanprmr I’v sent it in DM

[bastien]

Hey, over a week later and still no solution? This bug is costing me a lot of work, please help me!

[kishanprmr]

Hello @bastien , I think I’ve identified the issue. When selecting values for the Niveau and Filière columns, you are mapping the entire object to the field, which is causing the “invalid value of column” error.

Here is the webhook payload data for the Filière column, where you should be mapping the "value" field:

 {
              "id": "field_VXk0w8rH",
              "type": "select",
              "label": "Filière",
              "value": "Générale",
              "options": [
                {
                  "id": "opt_qGFtdsUf",
                  "value": "Générale"
                }
              ]
            },

You should map the “value” field, as shown in the image below.

[bastien]

What misled me is that the “value” field doesn’t come up when I do a field search in the mapping pop-up window.
The search engine needs to be improved.