Send email if the data of a column is different from that in the top row

[personal_zona]

[_THISROW].[Datains] <> [_THISROW-1].[Datains]

I would like to be able to send an email when after a change or addition, the value of a column is different from the one placed in the previous row. i tried with this code but it gives me error

[personal_zona]

I created a bot where after an addition and modification it should send an email, but only if in this case the entered date is different from that of the previous line

[Steve]

https://help.appsheet.com/en/articles/2792618-before-and-after-values

[personal_zona]

in questo esempio io vorrei poter inserire la data del 13/05 al posto del 04/05 ma solo se nella casella precedente troverò la data del 04/05.

l'esempio del prima e dopo funziona solo per la stessa casella,

[personal_zona]

 count(select(circuito[circuitoID], and([EMAIL]=USEREMAIL(),[Datains]=today())))=1

I TRIED TO ADD THIS CONDITION BUT IT DOESN'T WORK

[Steve]

None of your posts make sense to me--I feel like each post describes a different problem.

Please restate your problem. Rather than explaining it with technical terms and describing what you've tried, instead try explaining what you want to accomplish using plain language. For instance, "I want to send email when a record comes in with a date that is different from the last record."

[personal_zona]

OK forgive me, I try to explain myself better. So, I would like to set up a bots that sends me an email when in the specific case of the insertion date the data is entered, but since it is a training card, the data to insert, so the date would be at least 10 if not more, so it would be enough for me to receive only an email always filtered for useremail () in order to be notified that that USER is using the app. otherwise if I didn't do this I would receive at least 10 or more emails, which multiplied by users would be too many.
I tried with a count but it doesn't work for me, the after-before function works but only for the box that will undergo the modification, while I would like that before modifying the box, it should check the previous one so that if it is equal to the value that I have to enter i send no email. thank you

[personal_zona · Accepted solution]

LOOKUP(
MAX(
SELECT(
circuito[_ROWNUMBER],
([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
)
),
"circuito",
"_ROWNUMBER",
"Datains"
)<>TODAY()

Ho inserito questo tuo suggerimento postato da voi tempo fa e modificato, ed inserito nella condizione del BOTS e sembra funzionare bene, in pratica guarda la riga della cella [Datains] precedente a quella della modifica, e se la data è la stessa, non invia alcuna email.