Uneditable autocomputation

AppSheet AppSheet Q&A
1

Hi,

I have a column that automatically computes NOW(), but I would like it only to compute when adding a new row, not later when editing. I tried using setting editable_if to FALSE, but I get this statement:

Column Name ‘datumtijd’ in Schema ‘uitgang_Schema’ cannot use an EditableIf constraint if it has an App Formula. The EditableIf constraint will be ignored.

Does anyone has any experience with problem? I would like to compute the time when adding a new entry only, so it should be unchangeable when editing.

2

Please put the expression NOW() in initial value of the column and set editable_if as FALSE

2 Likes
3

My bad for the post. I think I’ve found a way to make this happen.

I changed NOW() to initial value instead of app formula and the show formula to: NOT(CONTEXT(“VIEWTYPE”)=“Form”). This registers the time of creation.

1 Like
4

Oh nice this is probably better! :grin:

2 Likes