I have a tank table and a tank ticket table.
The ticket table has a relationship setup that way users can pick which tank a ticket belongs to.
When the ticket record is created I would like to set a flag on the tank table to show a ticket has been opened.
Every time I do this the zap will work in testing but only for the row that I do it for. The zap will also work for other new records when I manually process it. It seems as if the trigger only works on manual processing or trigger testing.
I have tried two types of zaps
(1) new record > (2) search for existing record from step one’s tank key > (3) update tank key ticket flag to 1
I also tried new record triggers update (skipping the search)