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!!
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:
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.
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:
I agree.
However, this method would require a bunch of branch steps: my suggestion was for first-time bot builder 
