Display default timestamp in users timezone

[drmt1979]

I am trying to get a user to be able to record a time, that populates with a default but is editable.

I added a field in my user_table that is the default_timezone_offset in hours

In the datapage submit form, I call the default timestamp in a virtual field, call the default_timezone_offset in another field, then add the two with DATEADD( hour,[@cbParamVirtual5],'[@cbParamVirtual6]')

I had this into the field to record, but as a calculated value the user cannot edit it. I want to load the default of the above, but leave the field editable by the user on the form.

Caspio help said this couldn't be done. I'm totally open to any workflow that can do this.

Load a default timestamp dependent on user timezone, but leave it editable by user on the form.

 

Please help!

 

Thanks

[Barbie]

Hi @drmt1979,

If you want it to be editable, you might need to add a simple JavaScript code for you to achieve that. Please refer to this forum post: 

https://forums.caspio.com/topic/7002-use-timestamp-as-default-value-of-a-text-field-in-a-details-page/?tab=comments#comment-47842 

Hope this works. 

- Barbie