Hey there,
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)
- Actions:
- Find records: in product catalogue, where product code isn't empty
- Update records: in product catalogue:
- Record ID: from find records - selected the link field product-number
- fields: link field product-number, select fields to show product number (text field)
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.
Kind regards
Niklas