Solved: Automatic insert Now() value for a new row (kye co... - Page 2

andreagiordano · 02-01-2023 01:01 PM

I'm setting up an app that help user to add data of a trip to calculate costs (it's a shared cad). I chose date of registration of trip (datetime) as the kye column (i have a bunch of user so it's impossible that two people will add different trip at the exact date and time). I tried to put Now() expression in the Auto Compute /app formula but system answer that kye column doesn't accept formulas I can put Now() expression in the "Initial value" field ... but then user can modify it.

Is there a solution?

Thanks

DroidTeo

You can put an expression as "Edit_If", for example:
IF(ISBLANK([_THIS]), TRUE, FALSE)
in this way if there is something it is not possible to edit it..

Or another solution is to not show the ID column, and use a virtual column instead to show the information

And... why do you choose as key that column? Why not use a dedicate UNIQUEID() column as key, plus a column for the date and time?

View solution in original post

Automatic insert Now() value for a new row (kye column)