Solved: Runs the procedure when a change in cell values ... - Page 2

kenda_lokman · 05-16-2023 08:39 AM

welcome everybody
I have two tables
The first table (reservations table) includes the following cells: a, b, c, d
cell a is the reference,

The second table (execution section) includes the following cells:
a,b,c,d,e,f
cell a is the reference in the reservations table,

There is a procedure that copies cells (a,b,c,d) in the reservations table to the execution table.
I want to set a condition for this procedure so that it only works if there is a change in the copied cell values

dbaum

It seems possible that you might be able to streamline your data structure by referencing Bookings data in the Implementation table rather than copying data or by updating existing rows in the Implementation table rather than creating new rows.

Given your current data structure, here's one brute force approach to illustrate how you could accomplish what you need. There might be more elegant techniques. Here's a draft expression for the action's condition.

OR(
  [Situation] = "new", 
  MAXROW(
    "Implementation",
    "_RowNumber",
    [Booking Id] = [_THISROW].[ID]
  ) <>
  MAXROW(
    "Implementation",
    "_RowNumber",
    AND(
      [Booking Id] = [_THISROW].[ID],
      [Number] = [_THISROW].[Number],
      [Hotel] = [_THISROW].[Hotel]
    )
  )
)

View solution in original post

Runs the procedure when a change in cell values ​​occurs

Runs the procedure when a change in cell values occurs