Set value of cell that contains an app formula to not change once entered?

AppSheet AppSheet Q&A
,
1

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.

2

Move the USEREMAIL() to Intial Value and put ISBLANK([_THIS]) in your Editable If

5 Likes
3

Genius, worked like a charm. Thanks!

2 Likes
4

IT helped me too… Thanks

2 Likes