Make formula columns write protected

Ask for Help
1

Hi, new Grist user here, testing out Grist-Desktop on Windows.

As a test study I have set up a training log, where you can enter different exercises and a step log for each day. Then a formula that calculate score for each exercise (duration, difficuly etc) and gives a final score, and summarize all today’s exercises in a separate report view to see if you reached your daily goal.

My problem is I can (as (for now) single user and Admin) accidently write data in the formula column for an activity and thereby overwrite the formula with a set value. It is easy to undo / set up formula again, but a bit annoying.

I tried locking the formula column down by Access Controls → Table rules → Exercise log Table → Add Column Rule → Formula Column → Set it to “Read Only” for all → Save

But, it actully only made things worse, as it now seems I can still change values in the Formula column and overwrite the formula with a value, but after Read Only setting, it is no longer possible to undo the change I made. Undo fails with message “Failed to apply undo action: Blocked by column update access rules”

Is there a better way to make a formula column “Read only” in, for now, this single user scenario?

1 Like
2

Great idea Johan. It would be great to have a confirmation window popup asking you to confirm a change to a formula.

Additionally, adding a Special rule “Allow owners to edit structure…” similar to the Allow Editors option could be used to lock down a document when not in development mode.

1 Like
3

Same problem here. I can create access rules to protect the document from everyone except for myself. When I accidentally move or delete things, it cannot be undone. I have to catch what I changed, unblock myself and manually change it back. Wish there is a way to really lock things down and prevent changes made by me.