You are viewing limited content. For full access, please sign in.

Question

Question

Forms: New Forms Designer possible bug with Date Time default settings

Forms Forms Layout Designer
Updated April 8
asked on March 18, 2024 • Show version history

I have some Date fields set up to show both the Date and Time.  I'm trying to set the default time for the Start Date to 12:00:00 AM and the time for the End Date to 11:59:59 PM.  It appears to do what I expect when I'm in design mode, but once I preview the form the values aren't there and they don't show up even after I select a date from the calendar.

 

 

The goal is to allow the user to select a Start Date from the calendar and have the time default to 12:00:00 PM in the Start Date field and have the End Date default to the Start Date but with 11:59:59 PM as the Time.  Please advise.

 

0 0

Replies

replied on March 18, 2024

Couple of things.

  1. Is this in self hosted? If so are you on the latest version of Forms? (Update 5)
  2. I am able to have a default value for only time in both fields, once I add the start date variable to the end date field the end date/time is blank on preview
    1. using tokens in the field settings here uses the variables state from the process and not from the form. It does not update as the form is being filled out. instead, use formulas under advanced to dynamically set the end date field to the start field setting
      =Date_Time + TIMEVALUE("11:59:59 PM")
    2. You will notice the default value for an empty date is 2000-01-01, if this is not suitable, you can use this formula on the start date field
      =NOW() + TIMEVALUE("11:59:59 PM")
0 0
replied on March 18, 2024
  1. This is self-hosted and we are on Update 5.
  2. In order to get the Start Date field to work correctly, I had to create another Date field on the form and default it to today's date.  Then, this formula worked:  = Date_of_Request+ TIMEVALUE("12:00:00 PM")
  3. In order for the End Date field to work I had to use the DATEVALUE formula:  =DATEVALUE(Start_Date)+ TIMEVALUE("11:59:59 PM")

 

Would it be possible in a future update to allow setting the Default Time so that it would work "stand-alone" without formulas?

 

0 0
replied on March 18, 2024 • Show version history

Yes definitely, we are tracking this bug via these ids:

  • Time field defaults #492572
  • and no default when using a process variable #496642
1 0
replied on April 8

Hi, this issue has been fixed on self-hosted Forms 12 Spring 2025 Release. (BugID: 573519)

You can see other changes from: Laserfiche 12 Release Information

Get the latest Laserfiche Forms 12 package from: Laserfiche 12 - Downloads

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...