I have two tables: “Widgets”, “Sales”. A Sale record can reference one or more Widgets. When I create a new Sale record, I want the the “sold” field in the corresponding widget record(s) to be toggled. Sounds like this might be an Automation, but I’m new and not sure. Can someone please point me in the right direction? Thanks.
Answer
Record(s) in one table to be modified based on record in another table
Best answer by Databaser
Hi @Brian_Hodges and welcome to the community!
Yes, you can build an automation for this. As I understand it, the widgets have 1 record each, so they can only be linked to 1 Sale record.
Trigger: table = Widgets > when a record matches conditions > when “the name of your linked field to Sale record” is “not empty”
Action: update record > table = Widgets > record ID = “select record ID from your first step” > field “sold” > “1” (assuming this field is a checkbox)
Try it out and let me know if that works for you.
+25Hi @Brian_Hodges and welcome to the community!
Yes, you can build an automation for this. As I understand it, the widgets have 1 record each, so they can only be linked to 1 Sale record.
Trigger: table = Widgets > when a record matches conditions > when “the name of your linked field to Sale record” is “not empty”
Action: update record > table = Widgets > record ID = “select record ID from your first step” > field “sold” > “1” (assuming this field is a checkbox)
Try it out and let me know if that works for you.
+25Yes. That works. I can’t thank you enough for taking the time to elucidate me!
Glad I could help! Would you mind marking my comment as the solution to your question? This helps others who may be searching with a similar challenge. Thanks!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.