Pick "Time of Day" to fill TIME field?

[roattw]

I would like to be able to have the user select TIME OF DAY something occurred (H:M AM/PM) and have those selections populate a Time of Day field.  Exactly like the calendar popup, but just time, date not needed really.

Or concatenate 

 

Selection box 1 = Select Hour  (1-12)

Selection box 2 = select minutes (probably 5, 10, 5, ...00)

Selection box 3 = Am or PM

Result of the three choices populates the Time of Day box: ie 2:25 PM

Surprised its just not an option in calendar....

[Vitalikssssss]

On 4/22/2017 at 11:53 PM, roattw said:

I would like to be able to have the user select TIME OF DAY something occurred (H:M AM/PM) and have those selections populate a Time of Day field.  Exactly like the calendar popup, but just time, date not needed really.

Or concatenate 

 

Selection box 1 = Select Hour  (1-12)

Selection box 2 = select minutes (probably 5, 10, 5, ...00)

Selection box 3 = Am or PM

Result of the three choices populates the Time of Day box: ie 2:25 PM

Surprised its just not an option in calendar....

 

Hi roattw,

You can concatenate several fields in single value with Formula field:

Formula-fields 

Hope this helps.

[roattw]

The problem is that I need it to concatenate on the form when being completed, not on form sumbit.  Really just need a time of day picker like tou have for Calendar.

[mike38798]

Here is my solution for a time pick that I needed on my pages.

Create a table with the time selections you want. I only needed time selections in 15 minute increments so my table looked like this:

01:00 am

01:15 am

01:30 am 

And so on.

You can create this table real fast in Excel using the time increments you need and range.

Upload this Excel sheet to a table and then point your form time field to this table for selection.

 

Hope this helps.

[roattw]

Thats beautifully simple!  I need it to the minute so one big table, but nice elegant solution.

[Sudesh]

I tried creating the table. the values created also have Jan 01 1899 . How to you get rid of the year month and only show a time droplist. Thanks

[Vitalikssssss]

7 hours ago, Sudesh said:

I tried creating the table. the values created also have Jan 01 1899 . How to you get rid of the year month and only show a time droplist. Thanks

Hi Sudesh,

It looks to me that you have used Data/Time data type.

You should use Text(255) datatype for the field in question.

Hope this helps.

[Kurumi]

Hi @roattw,

You could try to concatenate this now as a Calculated Value. Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-13-0/
This release includes a new feature, Calculated Values in Submission Forms.  This allows you to generate calculations which you can use for your TIME.

Check these videos for more information:

 

I hope this helps!