A ENUM datatype that result to a datetime instead of values

[DLPC_GISD]

Good morning!

I want to ask a way where the button in ENUM type would result in a DateTime instead of text values.
The advantages as follows:

1. This would eliminate another column in your database if you need just the DateTime value of a particular activity.
2. Using AppSheet in this manner would be easier compared to making triggers to determine the Datetime value base on another column.

I’m not sure if I explain myself well. But hoping to find an efficient way for the matter stated.

[Marc_Dillon]

Like this?

[DLPC_GISD]

This would result to an Error after saving. (shown in the image below).

Also, the button gives the remarks as the image below shows.

[Marc_Dillon]

Because “Proceeding” is not a DateTime value. You’d have to remove that option.

[DLPC_GISD]

I’m not sure what you meant to “remove that option”. I tried to have a formula of datetime(now()) instead of “Proceeding”. But the result was Error in my app…

The ENUM datatype does not allow date time values as of this moment.

But I’m hoping that there is a work around on this.

[Marc_Dillon]

This means that you still have the base type set as Text, not DateTime.

NOW() already returns a DateTime value, there is no reason to wrap it inside of DATETIME()

DLPC_GISD:

The ENUM datatype does not allow date time values as of this moment.

Yes it does. Though I have no idea why you’re wanting to do this, and especially not if you’re going to use an App Formula for the column, as that disables edit ability for the column, which is kind of the main reason for using Enum columns (easy user input).

[DLPC_GISD]

Thank you for this Marc. It works fine.

But is there a way that instead of datetime value in the interface, it would be replace by a button instead. Like the image below.

[Marc_Dillon]

A button that does what exactly?

[DLPC_GISD]

I would use the button to trigger in writing the Datetime value to my table instead of hitting “save” button.

But luckily I found a way to rename the “Save” button to “PROCEED”…

Thank you very much for your help. This helps a lot.