The client is visited

[Jose_R_B]

Hello,

I reformulate the question I asked a few weeks ago to see if you can help me:
I need the status of the old record to be changed to "Visited" when a new customer visit record is produced. And if there is no visit or new registration before the date in [ProximaVisita], it will remain as "Not visited".

Greetings thank you

[TeeSee1]

COUNT(
 FILTER(
  "visits table",
  [client] = [_THISROW].[client]
 )
 -
 LIST([_THISROW])
) > 0

Get the list of visits that have the same client as in that of the current (new) row, subtract the new row itself and count the result.

If result is more than 0, then records already exist.

[Jose_R_B]

Hi TeeSee1,

thanks for the info.
I will carry out checks but for now it seems that it will work

Greetings from Spain 🖖