Error When Setting Initial Value for Timestamp Column While Creating Project

AppSheet AppSheet Q&A
1

Hi everyone,

I’m working on a form view where users can create a project. One of the columns in the underlying table is meant to store the created timestamp. In BigQuery, this column is of TIMESTAMP data type.

In AppSheet, I’ve tried different column types such as Date, DateTime, and ChangeTimestamp. I also experimented with initial values like NOW() and UTCNOW().

However, I’m still getting an error when submitting the form:

“Unable to add row… Value ‘2025-06-05 15-25-04’ in field ‘CRE_TS’ cannot be converted to type ‘DateTime’.”

Can someone help me understand:

What is the correct column type I should use in AppSheet?

What should be the proper initial value to store both date and time when the project is created?

Thanks in advance !

2

Have you tried datetime, reset on edit on, initial value UTCNOW() in appsheet and datetime in bigquery?

3

Yes, I have tried with datetime, reser on edit, intial value UTCNOW() in appsheet. But, in big query data type is Timestamp, I can’t change it.

1 Like
4

Don’t use the BigQuery built-in Timestamp type; instead, maybe try a plain-text BigQuery type.

1 Like