Automation with table-to-table relationships
Hi there, I'm trying to automate some processes around budgets and projects but can't yet get it working in a simplified test-app. Am I chasing an utopia or should it work and am i doing something ...
Forum Discussion
Hi Jan,
I would recommend having an internal status on your Requests Table (not copied[default], copying, copied) and you can hide this on forms/reports. That way, when the Change's Status is changed then you automate changing its Requests' Status to copying by using a modify action, and filtering for the Related Change. Then you can have another automation that looks for the Status in Requests Table to be changed to copying, and move the record, and update the status.
I don't think that an automation is triggered when a lookup field changes. You might be able to do this inside of a single Pipeline, but I haven't used those enough to help you through that process.
Hope that this helps!
------------------------------
John Crosland
Software Developer
Inglett & Stubbs
Mableton GA
------------------------------
I would recommend having an internal status on your Requests Table (not copied[default], copying, copied) and you can hide this on forms/reports. That way, when the Change's Status is changed then you automate changing its Requests' Status to copying by using a modify action, and filtering for the Related Change. Then you can have another automation that looks for the Status in Requests Table to be changed to copying, and move the record, and update the status.
I don't think that an automation is triggered when a lookup field changes. You might be able to do this inside of a single Pipeline, but I haven't used those enough to help you through that process.
Hope that this helps!
------------------------------
John Crosland
Software Developer
Inglett & Stubbs
Mableton GA
------------------------------
Hi John,
What you basically suggest is to use the automation to set the status in the request record itself. and a second automation to act on that change.
I did not yet consider that approach to be honest but it's worth a try.
------------------------------
Jan-Willem S
------------------------------
What you basically suggest is to use the automation to set the status in the request record itself. and a second automation to act on that change.
I did not yet consider that approach to be honest but it's worth a try.
------------------------------
Jan-Willem S
------------------------------