Darshan Hiranandani : How to Customize Timestamps in Your Table

[darshanhiranandani]

Hi, I'm Darshan Hiranandani, I have a use-case where I need to change the timestamp field in the table but it's uneditable is there a workaround for this?  Please give your suggestions and ideas.

[CoopperBackpack]

Hello @darshanhiranandani,

The Timestamp data type is not editable by default because its goal is to stamp the date/time when the record is inserted or updated.

Usually, there is no need to edit this date. It is good to know your use case to suggest.

Generally, you can use the Date/Time data type instead of the Timestamp and stamp the date/time on the DataPage level:

If this doesn't work, please provide more details.

[Kronos]

Hi @darshanhiranandani,

As to what CoopperBackpack mentioned, the timestamp on the table is not editable however you may add a Formula field to format the timestamp field.

You may use the references below:

HowTo article: Formula Fields

Video tutorial: Formula Fields

[Kronos]

To add, you may also use localizations to efficiently format the timestamp if you want to display them on multiple DataPages. Here are some links that can help:

HowTo: Localizations

Video tutorial: Enhancing Your Caspio Applications Using Localizations

HowTo: Custom Date Formatting

HowTo: Formatting Options

Cheers!

[ianGPT]

Hi @darshanhiranandani,

Although, you cannot edit the timestamp directly in the table. You can update the timestamp field with imported files using Data import/ Export Task

For reference you may check: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/data-import-and-export-tasks/