Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Updating the record failed

Solved
Jump to Solution
434 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ThanhLong
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions

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!

See Solution in Thread

4 Replies 4

Hmm I managed to get a very simple version of this working here:
Screen Recording 2024-08-11 at 10.05.03 AM.gif
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

 

 

ThanhLong
5 - Automation Enthusiast
5 - Automation Enthusiast

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

ThanhLong_0-1723356458254.png

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!

ThanhLong
5 - Automation Enthusiast
5 - Automation Enthusiast

It works, thank you!