I would like for a user to only be able to edit an entry (any column in the entire row) for up to 7 days after the entry was initially made. Is this possible?
Yes it’s possible provided you have a DateTime type column for any record.
Can the Date/Time column be a virtual column or does it need to be in spreadsheet? I’m assuming in either scenario the column should be required, but hidden and uneditable.
Then assuming you do have a DateTime column set up, How would you accomplish restricting a user from editing an entry for more than 1 week ago?
The DateTime column shall be a physical column in the back-end, not a Virtual column.
The restriction is a quite simple mathematical equation as you may guess as well.
User | Count |
---|---|
40 | |
32 | |
30 | |
17 | |
16 |