Hello,
Short version: I have an action link updating a connected record but I only want to update connected records where a field has a certain value, is this possible?
Long Version:
I have a shopping cart like set up on knack for registering for events.
I have a page where people choose what events they want to attend and it adds a record to a registrations object with the status pending connected to that event.
The ‘cart’ then lists pending registrations and when they click check out it creates a record in a another object called temp carts which is basically the same as the order table, once they pay the order is created in the order object from the temp cart and it updates the registrations to status paid.
All of the above is working fine.
The problem I have is on that page where they select registrations I am using action links for them to add/remove things from their ‘cart’.
The remove is set to update connected records which are the registrations, I just clear all the values and have an integromat scenario set to delete the empty registrations daily. The problem is it is clearing out the paid registrations as well if they had already previous bought one. So I would like it to only update the pending registrations, since it is a connected record the only values I see for criteria are for the event object.
I think I will have to custom code my own remove link to filter out the paid registrations but figured I would ask here first.
Thank you,
Lori