Skip to main content

I am trying to set a simple automation but for some reason It does not work and I cannot make anything out of what the error is giving by Airtable: Updating the record failed.

For more context, I have a formula field that is concatenate from multiple text fields and I want to have a multi-select field that is pasted from the aforemention formula field. The purpose of this is to have tags type as well as remove the duplicated tags.

Let me know if you have any suggestion. Thanks!

Hmm I managed to get a very simple version of this working here:

Hard to say why yours might be giving you problems though

If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable

 

 

hi @TheTimeSavingCo 
Thanks for your support, please access here for the base

This is the automation that I try to get working.

 

hi @TheTimeSavingCo 
Thanks for your support, please access here for the base

This is the automation that I try to get working.

 


Thanks!  Try using this formula for the formula field:

REGEX_REPLACE(
IF(CODE, CODE & "," ) &
IF(TestName, TestName & "," ) &
IF({TestName (Vn)}, {TestName (Vn)} & "," ) &
IF({simple_name_en}, {simple_name_en} & "," ) &
IF({simple_name_vi}, {simple_name_vi} & "," ) &
IF({Alias (Non-Vn)}, {Alias (Non-Vn)} & "," ) &
IF({Alias (Vn)}, {Alias (Vn)} & "," ) &
IF({Group Component Name (English)}, {Group Component Name (English)} & "," ) &
IF({Group Component Name}, {Group Component Name} & "," ) &
IF({Component Aliases}, {Component Aliases} & "," ),
',$',
''
)

I think the trailing commas are the causing the automation to fail.  I've also sent you a direct message!

Thanks!  Try using this formula for the formula field:

REGEX_REPLACE(
IF(CODE, CODE & "," ) &
IF(TestName, TestName & "," ) &
IF({TestName (Vn)}, {TestName (Vn)} & "," ) &
IF({simple_name_en}, {simple_name_en} & "," ) &
IF({simple_name_vi}, {simple_name_vi} & "," ) &
IF({Alias (Non-Vn)}, {Alias (Non-Vn)} & "," ) &
IF({Alias (Vn)}, {Alias (Vn)} & "," ) &
IF({Group Component Name (English)}, {Group Component Name (English)} & "," ) &
IF({Group Component Name}, {Group Component Name} & "," ) &
IF({Component Aliases}, {Component Aliases} & "," ),
',$',
''
)

I think the trailing commas are the causing the automation to fail.  I've also sent you a direct message!


It works, thank you!

Reply


Terms & Conditions