Automation Filter
So i have a total of three tables that are linked. Tickets -> Ticket Assets Assets ->Ticket Assets I am trying to get an automation to change Asset fields based on information in the ticket whe...
Forum Discussion
OK
I would make a field on the Tickets table called [Ticket plus 1,000,000] as a formula text field and the formula is
ToText([Record ID#] + 1000000)
Look up down to Ticket Assets (TAs)
Combined Text Summary up to Assets
The convert the Combined text summary field to a formula text field so its a semi colon delimited string called [All Tickets]
Then when the Automation triggers
Action is to modify records on Assets where
[All Tickets] contains the value in the trigger record field [Ticket plus 1,000,000]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I would make a field on the Tickets table called [Ticket plus 1,000,000] as a formula text field and the formula is
ToText([Record ID#] + 1000000)
Look up down to Ticket Assets (TAs)
Combined Text Summary up to Assets
The convert the Combined text summary field to a formula text field so its a semi colon delimited string called [All Tickets]
Then when the Automation triggers
Action is to modify records on Assets where
[All Tickets] contains the value in the trigger record field [Ticket plus 1,000,000]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
That worked great! Thank you very much for the help!
------------------------------
Nate Kurtz
------------------------------
------------------------------
Nate Kurtz
------------------------------
