Get <<_UPDATEMODE>> in a column

[Thilina_Wick]

So I am trying to create a bot that writes to a new table when a row of the main table has been added/updated/deleted, my plan was to use 

<<_UPDATEMODE>> to application '<<_APPNAME>>' table '<<_TABLENAME>>' by '<<USEREMAIL()>>' at <<NOW()>>

something like this that appears in the email preheader but to my dismay updatemode isn't available to me, is there something we can do about this to get a good end result?

Thanks in advance!!

[Aurelien · Accepted solution]

Hi @Thilina_Wick 

Can you change your category question to "Q&A", as "Tips & Tricks" are for sharing Tips & tricks, not questions.

"Q&A"' allows to ask question, get it answered, and mark it as being solved for later community users.

About your question:

You will need to create one bot per data change, and set the column expression depending to the data change.

Let's say, for example:

For reference:

Events: The Essentials - AppSheet Help

[Thilina_Wick]

I'm very sorry I didn't realize the section I was in, how do I change it into the Q&A now?

Also thank you for the response, I am working with 30 different columns so I'd have to do it for 90 columns but it did give me and idea for writing something for deletes only.

[dbaum]

---

@Aurelien wrote:

You will need to create one bot per data change

---

FWIW, I've found it easy enough to use a single automation triggered by all changes and derive the specific type of data change (e.g., add, update, or delete) that triggered the automation by referencing the before and after values of the pertinent column. I don't have my implementation at hand for direct reference, but it's something like:

• IF key.before is blank, it's an add
• IF key.after is blank, it's a delete
• Otherwise, it's an update

[Aurelien]

I agree.

However, this method would require a bunch of branch steps: my suggestion was for first-time bot builder 😄

[Aurelien]

---

@Thilina_Wick wrote:

I'm very sorry I didn't realize the section I was in, how do I change it into the Q&A now?

---

@Roderick