Editable based on a formula

aglass
New Member

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?

0 3 140
3 REPLIES 3

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.

Top Labels in this Space