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.
Is there any way to update this automation even if the Portfolio Title is still a computed field?
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