I have gone through quite some posts about this topic in the community already, but none seems to solve my problem or maybe I just haven't fully understood how to solve it yet.
I have a table "Product stock" and another table "Product catalogue". The product catalogue contains information how many products are in stock by checking via a link and lookup field to the stock table. The link between these table is the product code.
However whenever the stock is updated (e.g we have a new product in stock) I have to manually copy the product code from a text column to the link-records field. I would like to automise this step. My approach here is the following:
- Trigger: when a record is updated (product-stock)
When I test the automation I get the error: "received invalid inputs"
I hope I explained my problem in an understandable way. I attached some screenshots to provide clarification, but let me know if I can provide further explanation.
Thank you for your help in advance.
I think it would be easier to update the 1 trigger record with the list of found Record ID's in your "find records" step, rather than to the same to many records in your Catalogue table.
For your linked field "ABS Code Lagersuche", then use "Make a new list of ... Airtable record ID".