Date Reservation widget: option to pass multiple dates to separate Date picker fields

  • Dtbzz
    Asked on June 11, 2019 at 7:21 AM
    Is there a possibility with the calculate widget to only select a number of characters?
  • Girish JotForm Support
    Replied on June 11, 2019 at 7:25 AM

    You can have the similar option to copy field values based on certain characters as you require (i.e. select characters 9 to 16 from "field1" to fill "field2"?).

    See the sample condition below.

    15602522861106 2 Screenshot 10 

    Hope this helps.

  • Dtbzz
    Replied on June 11, 2019 at 7:36 AM

    Hmmm, I have no idea how to make this work in my case:

    E.g. I have a field of which I know it contains 3 dates (provided by the input from the Data Reservation widget into the date picker). It looks like this:

    30-09-201901-10-201902-10-2019

    To be able to transfer these dates to google calendar, I need to be able to separate these dates

    --> character 1 - 10 = 30-09-2019

    --> character 11 - 20 = 01-10-2019

    --> character 21 - 30 = 02-10-2019.


    Can you please explain to me how I can do this using the "conditions"? I don't know which exact values (=dates) will be in the field, in depends on what the user choses. 


    Thanks

  • Girish JotForm Support
    Replied on June 11, 2019 at 8:17 AM

    To be able to transfer these dates into Google calendar, you will need to copy the date values to date picker fields and then pass data to google calendar. That means that one Date reservation widget will transfer one date to another Date picker field.

    I've shown an example from your form here. As a sample, I've added a "Date" field just below the Date Reservation widget titled "Selecteer een dag voor het DataBuzz-bezoek":

    15602551981106 3 Screenshot 10

    Similarly you will need to create condition for the required dates and map them to the required "Date Picker" fields. If you do not know what date the user will/should pick, then modify the condition as below:

    15602554381106 4 Screenshot 21

    Hope this helps.

  • Dtbzz
    Replied on June 11, 2019 at 8:22 AM

    Yes, this works when the user selects just 1 date, but what if he/she selects multiple? In my form they can select up to 10 different dates. When copying the field's value, you end up with a situation like a described above with the 3 different dates. I cannot let my users click 10 different calendars when they need to select 10 dates...

  • Girish JotForm Support
    Replied on June 11, 2019 at 8:53 AM

    Sorry, but there is no other workaround to get the multiple dates of date reservation widget to different date picker field.

    Currently the only possibility is to add separate "Date Reservation" widget for each date. Map them to the individual Date Picker field and keep these hidden.

    Let me escalate this to out back end team to check if we can have an option to get this implemented. However, we will not be able to provide an ETA as to when or if this feature can be implemented, but we will keep you posted on updates.

  • Dtbzz
    Replied on June 11, 2019 at 10:41 AM

    Apart from the Date Reservation to Date Picker field "issue", is there a way to only select a certain amount of characters from a field and add these to another field?


    E.g.:

    Let's say you want to create e-mail addresses based on first 2 letters from first name and last name.

    First name: John

    Last name: Doe

    Wanted e-mailadress: jodo@example.com


    I know the calculation field can do

    1560264014Screenshot 2019 06 11 at 16 Screenshot 10

    resulting in john.doe@example.com.

    But is there a way to get jodo@example.com through the calculation (or any other!) widget?

  • Dtbzz
    Replied on June 11, 2019 at 10:46 AM

    I just found the substring widget, I'm going to try if this works out!

  • Dtbzz
    Replied on June 11, 2019 at 10:47 AM

    UPDATE: I can find them in the html code

     

    In addition: where can I find the field ID of the text fields in my form (in which the selected dates are from the Date Reservation widget are displayed)?

  • Alan_D
    Replied on June 11, 2019 at 12:13 PM

    You can find the Date Reservation widget's field ID from its advanced settings tab. Date Reservation widget: option to pass multiple dates to separate Date picker fields Image 10Please insert the ID without # sign into the Substring widget. Date Reservation widget: option to pass multiple dates to separate Date picker fields Image 21I think you may need to use multiple Substring widgets. Then you can concatenate them using form conditions.