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

[andreagiordano]

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 · Accepted solution]

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? 

[andreagiordano]

Actually I found a workaround ... don't know if it is correct but it looks like it's working.  I just unfagged Show, so the field takes the Now () datetime and the user doesnt even know!

[DroidTeo]

It seems what I suggested 😅

Anyway, good news! 

[andreagiordano]

oh my ... I thought I answerd to you but I don't see my post .. .So I was saying that I didn't see your reply ... Sorry, you are right your suggestion was correct ... Saw it afterward 😁

[Steve]

---

@DroidTeo wrote:

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.. 

---

Note that ISBLANK([_THIS]) is sufficient here; wrapping it with IF() is unnecessary.