Jump to content
  • 0

Pick "Time of Day" to fill TIME field?


roattw

Question

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....

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

  • 0

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...