I have 3 tables: 1 - Incomes, 2 - Outcomes and 3 - Monthly reports.
I’m trying to link new records in tables 1-2 to the appropriate record in table 3.
in tables 1-2 I have a formula field which gives year and month (e.g. “2021 01”). The 1st column in table 3 is “YYYY MM”.
I created automation that trigger in new record in table 1, finds the matching record in table 3, and updates it with the newly created record. And it worked as planned!
When I tried to do the same thing on the 2nd table I encountered the problem in the picture - I can not insert the record to search by. It only allows me to enter the metadata of the record (only length is available).
Any ideas what the issue might be? Do you know what are the criterias for inserting record’s field in the automation?
Any thoughts will be highly appreciated!