The “FORMULA” is always triggered by the Automation....

AppSheet AppSheet Q&A
,
1

I use the expression “FORMULA” in the [editor] field.

IF(NOT(IN([key], people[key])), CONCATENATE(useremail(),“&”,text(now))
CONCATENATE(useremail(),“&”,text(now(), “yyyy/mm/dd hh:mm”),“,”),“),”,“),”,")
CONCATENATE([_THISROW]. [editor],useremail(),“&”,text(now(), “yyyy/mm/dd hh:mm”),“,”)))

The main purpose of this is that as long as there is an editor on the line, the editor and time will be added after this field.
This expression does accomplish what I need.
But now we have a situation.
If the “bots” are triggered to edit the row, the
will also let “FORMULA” do the math.
For the same edit, triggering “bots” will increase the editing data several times at the same time.

Is there any way to prevent “FORMULA” from running several times due to the editing of “bots”?

2

Yes, you can use the CONTEXT() function. One of the parameters is “Host” and you can check if that host is NOT the “Server” - automations run on the server. It would be something like this:

IF(CONTEXT("Host") <> "Server",
   <<<run calculation expression>>>,
   [_THIS])

[_THIS} values simply keep the current value the same.

I hope this helps!!

2 Likes