Record(s) in one table to be modified based on record in another table

[Brian_Hodges]

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.

[Databaser · Accepted solution]

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.

[Brian_Hodges]

Yes. That works. I can’t thank you enough for taking the time to elucidate me!

[Databaser]

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!