Skip to main content
Solved

Updating the record failed

  • August 11, 2024
  • 4 replies
  • 28 views
T
Forum|alt.badge.img+3

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!

Best answer by TheTimeSavingCo

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!

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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

 

 

Adam, Airtable Consultant - thetimesaving.company
T
Forum|alt.badge.img+3
  • ThanhLong
  • Author
  • Participating Frequently
  • 6 replies
  • August 11, 2024

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

This is the automation that I try to get working.

 

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6410 replies
  • Answer
  • August 11, 2024

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!

Adam, Airtable Consultant - thetimesaving.company
T
Forum|alt.badge.img+3
  • ThanhLong
  • Author
  • Participating Frequently
  • 6 replies
  • August 11, 2024

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!


Terms & ConditionsAccessibility statement