Is there someway to apply a transformation to data in a cell after it’s entered?
For example, suppose I have a column in which I want the value to be lowercase, or in some other format which I could validate with a regular expression.
I tried using a Trigger Formula, but can’t seem to figure it out without causing a circular reference.
Ok, I admit, I only skimmed the Help Docs before posting this, and OF COURSE it’s possible because Grist is amazing.
It’s all explained here for anyone wondering: Intro to formulas - Grist Help Center
Basically, if you are reacting to a change on the current field, you can use the special value variable to do “data cleaning”. So in my case, if I want to enforce a lower-case value, I can enter value.lower() LOWER(value) (either works fine).