I have a stock table "Stock" and a catalogue of products "Catalogue". Not all products from the Catalogue are listed in the Stock and the Stock changes on a regular basis. The availability of products from the catalogue is linked via "Link to another record" field to the stock the value used for this is the "articlenumber" So when the stock changes (e.g. we have a new product) I need to manually select the article number in the linked field for the new product.
So I created an automation that runs daily at 8:00 am and runs a script that is supposed to copy values from field "Articlenumber" to field "Articlenumber-linked" in the catalogue if a record with this article number is found in the stock. This is my script:
My issue is that the field "Articlenumber-linked" is populated with a random articlenumber from the stock that doesn't match the product and when I try to change it to the value from ColumnA I get an error.
Can someone help me update this script so that "articlenumber-linked" equals "articlenumber" in catalogue if articlenumber is found in stock.
Let me know if I can assist with further clarification.