Hi! I’m facing a problem, I have my database with employees and their respective positions, duties and workplaces. Each month I will add the list of the month directly to the spreadsheet, so there will be repeated names and there may or may not be changes to their data. How do I ensure that names are recognized and that, in case something has changed, it stores a history of changes? I don’t know if I was clear with my question but I’m willing to explain it better. Thanks!
I could be wrong but it seems that the following simple solution would fill your needs…
Since you already have a spreadsheet that has current as well as all the historical data, I would say that is a perfectly good source of historical data. So instead of showing the entire table, you can create a slice that only displays the current month data and show that to the users.
If you want to see the history of a particular employee, you can create an action that jumps to a filtered view that shows all the records pertaining to that employee.
You could create format rules to highlight changes by comparing values of each field to its previous month values if the time stamp of your records are such that it can be calculated.
3 Likes
Thank you!