update and delete a row when add a row from zapier

Hi friends, I'm working on my app that imports booking data with zapier.

my problem is that when a reservation is canceled or modified, a new row is written in the table and the original row is not overwritten, this causes a duplication of data.

this is the original table:

Screenshot 2023-05-01 alle 11.37.57.png

Row 1 : is the original booking that the customer made on a portal,

Row 2 :the customer added a passenger but  (can change a data)

Row 3: he canceled the reservation.

I would like that when the reservation is modified, the reservation of line 1 is updated or that line 1 is eliminated.

if the reservation is cancelled, all lines related to the reservation should be deleted.

the reservations all have the same [BOOKING ID].

Can you help me? I hope I was clear.

0 5 184
5 REPLIES 5
Top Labels in this Space