Skip to main content
Question

Automation Filter

  • September 16, 2020
  • 0 replies
  • 35 views

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 when it closes.  So far i can do this for one asset without an issue. 

I have the Trigger go when the status of a ticket changes.

Then Filter Assets by matching the Record ID# in the Asset Table with a Combined Text summary field listing the Record ID of all of the Assets on the ticket (there is a formula field in the Ticket Asset field Totext([Related Asset]) and i am using that to drive the combined text summary). 

I then have it make my changes.

This works great for one asset, however we regularly can have lots of assets on a ticket (several hundred) and it seems to only work with the first one.   Any suggestions for a better way to approach this or to get it to run on the rest?

------------------------------
Nate Kurtz
------------------------------
This topic has been closed for replies.

  • Author
  • Registered
  • September 18, 2020
I haven't made any progress with this unfortunately.   Any help would be appriciated!

------------------------------
Nate Kurtz
------------------------------