Generate dates/days in the configurable list based on a selection from other field

  • Profile Image
    sugam
    Asked on March 14, 2016 at 09:08 AM

    Hi, I am trying to build timesheet form. I am capturing Week Beginning Date as a separate field on the top and based on this field, I want to generate dates/days in the Configurable Listfor that week.

    i.e., Week Beginning Date: Monday, 14/03/2016

    In the Configurable list

    Date                             Start time       Finish time

    Monday, 14/03/2016        9:00 AM         5:00 PM

    Tuesday, 15/03/2016       9:00 AM         5:00 PM

    Wednesday, 16/03/2016   9:00 AM         5:00 PM

    Thursday, 17/03/2016      9:00 AM         5:00 PM

    Friday, 18/03/2016           9:00 AM         5:00 PM

  • Profile Image
    Welvin
    Answered on March 14, 2016 at 10:24 AM

    It's not possible to generate the same date from the DateTime field to the Configurable list widget so a workaround would be to configure your form this way:

    1. Add a configurable list widget based on a week. If you are going to allow 7 weeks, add 7 of this widget.

    2. Show each of the widgets based on selection from DateTime field. You can do this by adding a condition logic in the form. Here's our guide: http://www.jotform.com/help/316-How-to-show-or-hide-a-field-in-the-form-based-on-the-other-field-input-or-selection.

    I've cloned your form and made the changes to show you a sample. Please check it here: https://form.jotform.com/60734382430956. You have to choose Monday and/or Tuesday to see the configurable list widget.