Changed column

I want to send a report when a column is edited with the name and ID of the person who changed it. How do I do that?

Hi,
You can do that using a workflow rule (check this for more details: https://help.appsheet.com/en/articles/961729-sending-email-from-a-workflow-rule-or-scheduled-report).

In that email, you can either have the report in the body of the email or as an attached file.
Finally, in order to include the name and ID of the person who changed it, you’ll need to keep a log of the person who last changed that record. In general, you’ll want to make sure your app has ‘Required Sign-in’ enabled which will let you use the USEREMAIL() expression to identify who is logged in the app. I’d recommend the email address of the user instead of the name and ID in your report if possible.

These are general pointers to achieve what you want, given the information you’ve shared.
I hope this helps.

1 Like