So I created a value list in a layout for the users to choose. I need this value to replace a value already exists in a field. But no matter what record I am on, when script is triggered. The value is updated only for the first record, that's not the record I want to update.
I have this Buy It Now button for each record. When clicked, it'll grab the item info from this table and save to another table. And this part worked just fine.
Now I need to update the category field in Invoices table using the values in MarketplaceCategories, I created a value list using MarketplaceCategories. I add this part before the original script, which is Set Field in my new table using the values in Invoices table. I have a OK button and I set it to Resume Script. Here is the new script I add:
Then in my new table, it still got the old category value in Invoice table. But the first records in the Invoices table has the new category value.
Anyone can help?