Hi @Justin_Eppley ,
If I understand the problem correctly, you could do it in 2 ways - via an automation or via script.
1) Automation
When a record is updated - Lookup the values in the SyncTable and update record in Target table.
-
not using here record created - because human created record will be created as empty first
-
limit the trigger to react only to update of the Product Name field
-
use Find records to look up the name in the other table
-
if there are records found, updates the fields you want with the “List of” values you want from Product table:
You might encounter 2 issues with the approach above:
a) The Update record can also run while you are updating the Name field… if you take long time to type the name , the field might get updated half way and trigger the lookup
b) If the result of Find records returns multiple results, you will unfortunately get list of resulting values.
2) Script
You could
- use automation above and instead of “Find records” - trigger a script - that would solve problem b) (by hardcoding some solution, e.g. select newest result)
- use script as standalone extensions and trigger it by hand - that could solve issue a) and b), but needs to be manually triggered.
You could adjust code here to have it update the fields instead of linking:
I hope that helps!
