Help

I have this automation that has been set up but it's having this error

Topic Labels: Automations
650 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Imee_Lee
6 - Interface Innovator
6 - Interface Innovator

Automation set up was.

Step 1: When a record matches a condition.

Step 2: It will update a field which is the "Client Portfolio Record" (this is a linked to another record field to a view called Client Portfolio)

This automation was just working fine before, but there was a change happened on the default column in "Client Portfolio view" which caused the issue. 

If you suggest putting it back to the normal setup, I can't because the default column in "Client Portfolio View" which is the "Portfolio Title" should be in formula type now. It should also remain as default column.

 

Screenshot 2023-11-22 at 10.33.39 PM.png

 

Is there any way to update this automation even if the Portfolio Title is still a computed field?

3 Replies 3
Sho
11 - Venus
11 - Venus

How about removing the Portfolio Title from the Update record action?

Imee_Lee
6 - Interface Innovator
6 - Interface Innovator

Portfolio Title is not on the Update record action.
It is a link field maybe that's the reason why.

Hi,
You get that error because you are trying to update a linked field with a value not present in a linked table.
When you put some value in a linked field, Airtable searches primary field of a linked table for that value and links to it. If not found, it auto creates new record with that value and links.
When you change primary field to formula, it cannot auto-create. Imagine you have table, with fields:
primary A(formula), B(number), C(number).  The formula is B*C.
A     B     C
10    2     5
24   6     4
40   8     5

and now you are trying to put 36 in linked field.
if A were text, it can just update A with 36, with empty B and C
But if you have formula in A , and it's B*C,  it should auto-populate B and C also.  4*9 ?  or 6*6 ? or 18 * 2 ?
That's why it cannot create new record. Some people even turn their primary field to a formula by purpose, to 'protect' from auto-creation.

Note that you will not receive error as long as value you put in a field will exist in a primary field of a linked table