Hello,
Was wondering if anyone can assist with this:
I have a column called [Tech Email] that uses an app formula USEREMAIL()
When I have another user edit a different column in that record, it changes the [Tech Email] column
How can I prevent the column [Tech Email] from changes once recorded?
I tried to use Editable_If formulas, but I get this response:
Column Name โTech Emailโ in Schema โTime Entries_Schemaโ cannot use an EditableIf constraint if it has an App Formula. The EditableIf constraint will be ignored.
Solved! Go to Solution.
Move the USEREMAIL() to Intial Value and put ISBLANK([_THIS]) in your Editable If
Move the USEREMAIL() to Intial Value and put ISBLANK([_THIS]) in your Editable If
IT helped me tooโฆ Thanks
Genius, worked like a charm. Thanks!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |