Appsheet - Creating an Activity Log
Become a member of this channel to enjoy exclusive benefits:
/ @manuelaragonesprofesor
A log, or activity log, is a table, file, or any type of information repository where data on user activity within an application, server, or digital organization is collected.
In this case, through bots (automations) and actions, we generate information about data modifications made to our tables. This gives us absolute control over the processes carried out in our organization, allowing us to know at all times who, when, and how they modify the tables and records in our database.
The process is simple: we create a table in Google Sheets to collect the activity details. Then, we create a bot that instructs it not to create a new row in the log table when a record is deleted, and we specify the information it should fill in the row fields. An `id` field where we create a UNIQUEID(), a `date` field where we specify today's date using the `TODAY()` function, a `time` field where we specify the current time, a `record name` field, and a `user` field where we retrieve the currently logged-in user using the `USEREMAIL()` variable.
``` Become a Master with my FREE course
👉 Lesson 1 Basic Concepts: https://bit.ly/2Sta6Pm
👉 Lesson 2 Basic Formulas: https://bit.ly/2SloNnk
👉 Lesson 3 SUMIF: https://bit.ly/2TZRJ4G
👉 Lesson 4 Tricks and the IF Function: https://bit.ly/35Lb5gz
👉 Lesson 5 VLOOKUP: https://bit.ly/3wUeLbR
👉 Lesson 6 Filters, Index and Match, Database Functions: https://bit.ly/2SRNxUJ
👉 Lesson 7 PivotTables: https://bit.ly/3qkG3Wz
👉 Lesson 8 Subtotals, Charts, and Conditional Formatting: https://bit.ly/2TYP8bk
👉 Lesson 9 Goal Seek, Solver, and the PMT Function: https://bit.ly/35PJcnU
👉 Class 10 Macros: https://bit.ly/3qna9Zs