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.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |