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:

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 Dynamic value and try to force the update, it just return a error saying that the records Ids are mixed up.

Is it a bug? How can I avoid it?
Because every time I run a flow it automatically cleans that field when updating my airtable data, even when I leave it blank/default.

Thanks! :smiley:

Hello @mvpalves , Welcome to the community :wave:,

I tested it with the Linked Field type column, and it overrides the value when not provided. I have added it to bugs. Sorry for the inconvenience caused.

Has this bug been resolved? I’m having the same problem. Strangely, I didn’t have this problem at first. It happened suddenly. Can you enlighten me @kishanprmr?

Hello @Bastien, this issue has been resolved. If the linked field is already filled and left empty in the update action, it will not override it.

1 Like

Thanks, but I ran into more problems last night with the multiple choice fields. My flow stopped working because Airtable no longer wanted to accept entries that it was accepting perfectly yesterday. Is the Airtable piece stable? This is the second time in a week that I’ve encountered bugs. I can’t afford to have an unstable flow on Airtable. I thought it was a tried and tested piece that didn’t have any bugs.

Can you specify the problem with the multiple-choice fields? Is it that no options are showing, or is it that you’re unable to pass dynamic data into the field?

The problem is that I send custom question answers from Savvycal to an Airtable table. It was working fine then all of a sudden yesterday it stopped working even though I hadn’t changed anything.
I encountered the bug in all the multi-select fields. I don’t use the dynamic pass. I send data from the webhook.

Honestly, @kishanprmr , it’s a nightmare. All the multiple select fields are deleted when I don’t update them with a specific value. It’s terrible. I’m losing data. Please fix this urgently. Whether it’s in dynamic mode or not.

Hi @bastien

The update by @kishanprmr is now landed, can you try again?

@abuaboud @kishanprmr It does work again, but I have to say that this bug was extremely damaging.

I did a bulk update of my table and in fact I lost all the data from multiple fields that were not included in my update flow.

I’ve noticed since this topic that this isn’t the first time this bug has occurred, and now I’m afraid to automate my tables with Activepieces.

Remember that this is my very first flow with Activepieces and although the experience is exceptionally good when editing the flow, this execution problem is a huge setback and makes me doubt the product.

Airtable is a star tool, probably one of the first pieces that was implemented, it’s not normal to find such a dangerous bug for users.

Can you explain what’s going on with the Airtable update block and the likelihood of this problem occurring again?

Hii @abuaboud ! It was fixed for AiTable too? Or just Airtable?

Because I’m facing this issue with AiTable as well.

Many fields have been override, look:

and when we check the module (here we have the ‘Publicado’ and the ‘Responsavel’):

To at least for aitable, it seems that the issue persists.

Thanks! <3