I have a base that has two tables with linked records.
Table1 fields : Name, Number, Sum (linked to table2)
Table2 fields: Name, record, Table1, Total (roll up value of each category of name)
This works beautifully manually, for every new record i create in Table1. But has been failing in automation.
This is what I am doing:
Trigger on new record creation:
Note: in table 2 I have a row with unique “name” from table 1.
In this action I am trying to find the record with name == name of the record created.
Update the field “sum” in Table1 with the record found in previous step.
The tests pass, but actually fails when a new record is created. Screenshot below.
Apparently, it’s an invalid filter on the record.
It appears simple and at this point I do not know how to fix it OR why it’s not working. Can any one assist in getting this to work please?