How to allow Time Format to input

[jameswigley]

Hello

I have a table containing some date/time fields which i need to have time recorded ( such as 09:30) for a timesheet application

I have modified my localisation file and set Date/Time Output Time to Custom Format HH:mm

However in the datapage is I try and enter 09:30 I get the message: Must be a date -idiot! ( I added Idiot to the localisation field to prove that it is being referenced)

What am I not understanding??

[bahar_vm]

That's right. The localization is for custom display purpose but not for the data entry. A Date/Time field can store either Date or Date plus Time but it can not store Time only. This is a feature we can add to the list for future considerations. For now if you would like to only store time you can choose text 255 however you will lose chronological sort capability.

Thanks,

Bahar M.

[Kurumi]

Hi @jameswigley,

As for the new Caspio releases, you may want to check these articles for you to implement the Time Format.
https://howto.caspio.com/tech-tips-and-articles/common-customizations/separate-input-fields-for-datetime-parts/
https://howto.caspio.com/faq/time-and-date/how-to-eliminate-time-from-a-date-dropdown/

I hope it helps!

[roattw]

On 11/26/2018 at 9:30 PM, Meekeee said:

Hi @jameswigley,

As for the new Caspio releases, you may want to check these articles for you to implement the Time Format.
https://howto.caspio.com/tech-tips-and-articles/common-customizations/separate-input-fields-for-datetime-parts/
https://howto.caspio.com/faq/time-and-date/how-to-eliminate-time-from-a-date-dropdown/

I hope it helps!

They need an option to remove DATE from the drop down / calendar option . SO many steps just to get a simple field to enter time of day.

[Kurumi]

Hi everyone - Just wanted to share this solution. If you want to save and select Date and Time in (1) Text Field instead of separating them into different fields. You may use an external JS library called flatpickr: https://flatpickr.js.org/getting-started/ 

To know more, you can check the post here: 

 

[ParkLoey]

Hi! Would also like to share this since I had problems with my form since I want to only enter a time value. The thing is, looks like it's Caspio's requirement or general field value requirement for Date/Time fields to have a value in this format: MM/DD/YYYY HH:MM:SS

I noticed we can enter a date value only and have the time as 00:00:00 by default. However, since we cannot set the date value to blank or 00/00/0000, we need to include a date value at least. What worked for me is I used a standard date, like January 1, 2000 for all my values that only needed time. Another option is to just use a text field  “¯\_(ツ)_/¯

 

 

[Kurumi]

Hi - For Time only fields, you can check this new forum post: