Differenciate new and updated record within one single bot

[Aurelien]

Dear Community and AppSheet Champions 🤠

Among the suggested bots, we have the suggested event "A record is created or updated".

I would like to be able to differenciate the two situations, without having to create one bot for each single-event data change.

I thought about this, but that does not work:

Would you happen to have an idea?

[Suvrutt_Gurjar · Accepted solution]

Maybe not very economical  as it involves adding a column 🙂but the following works .

Please add a ChangeCounter type column , with Accumulate mode and initial value as 0 that changes on all column changes or you can set the columns you want to designate as "Update Changes"

Then your branch condition for add/update can be 

AND([_THISROW_BEFORE].[TESTCOUNTER]<>[_THISROW_AFTER].[TESTCOUNTER], [_THISROW_AFTER].[TESTCOUNTER]>1)

[TESTCOUNTER] is ChangeCounter type column here.

The Y branches to Update record Email and N branches to Add Record email