I am creating a grid with inputs in a repeating group. User can fill in quantity values. Each time an input is changed a orderline is created, updated or deleted based on the following conditions
1 create: when thing does not exists and input value is greater than 0.
2. update: when thing does exists and input is greater than 0
3. Delete: when input is 0 or blank it will fetch a thing to delete.
All is working fine, but I am now struggling to decide what approach is most efficient
A) one trigger with multiple action only to run on specific only when conditions like this;
Trigger 1: Do when input is changed
Action: create thing only when… See (1)
Action: make changes to thing only when… See (2)
Action: delete thing only when… See (3)
Or B) Multiple triggers for each specific action with only when condition on trigger level like this
Trigger 1. Input is changed only when…see (1)
Action: create thing
Trigger 2. Input is changed only when…see (2)
Action: make changes to thing
Trigger 3. Input is changed only when…see (3)
Action: delete thing
So from a performance standpoint, what is best to do?