Appointmen field: Extract date and Time into separate columns

  • Profile Image
    Jacob_Abel
    Asked on January 25, 2021 at 12:01 PM

    Hi, we are using Jotform to create items in Monday. We are using the appointment form element to schedule some stuff. I noticed in the JotForm->Monday integration that the appointment field cannot be directly copied to a date or time column in Monday, so I created conditional logic in Jotform to copy the appointment value into a hidden date picker field and a hidden time field (so then I can copy these values to Monday), except copy value from appointment to time does not work. Copying appointment to a date picker works though.

    TL;DR I need to get appointment field date/time into date/time columns in Monday...how would I do that best?

    TIA, Jake

  • Profile Image
    Ariel_P
    Answered on January 25, 2021 at 04:48 PM

    Hi there,

    You can get the form's full source code, pass the Appointment's time to a field using JavaScript.

    If that's not an option, you can try the following workaround. Please note that this will only work if you set your Appointment's Time Format to "24 Hour".

    16116096322021-01-26 05_19_15.jpg

    1. Use a Form Calculation widget to capture the Appointment element's string value.

      16116091402021-01-26 05_03_02.jpg

    2. Add a Short Text element to your form with the following Input Mask:
      ###### ##:##

      16116097062021-01-26 05_03_43.jpg

    3. Use the Substring widget to extract the time from the Short Text.
      • Set the Substring start to "7" and the Substring end to "12".
      • The Source field ID would be your Short Text's field ID.

      16116102192021-01-26 05_04_30.jpg

    4. Use Conditional Logic's Update/Calculate Field to pass the Form Calculation field's value to the Short Text field.

      16116107652021-01-26 05_35_45.jpg

    Here's a demo form with the setup above applied. Feel free to clone the form and use it as you please.

    Hope that helps. Let us know if you have any questions or if you need further assistance.

  • Profile Image
    Jacob_Abel
    Answered on January 25, 2021 at 04:52 PM

    Hi Ariel, thanks for your response, but neither of these options are very appealing. Any chance this will get fixed? Technically, this is a bug IMO. You can set this up in conditional logic but it does not work as expected (I expect it to copy the time to the time field).

  • Profile Image
    Jovanne_A
    Answered on January 25, 2021 at 08:55 PM

    Hi Jacob,

    Please note that the value returned from the Appointment field is in full date format (ex. Tuesday, January 26, 2021 22:00). If you want to extract the time from the appointment slot, you can follow my colleague's workaround.

    Unfortunately, there is no feature or condition yet that can capture the date and time separately from the appointment field and then copy it to the other fields.

    This could be a good feature though, would you like us to add your requirements to the list of our feature requests for possible implementation?

    We look forward to your response.

  • Profile Image
    Jacob_Abel
    Answered on January 25, 2021 at 11:19 PM

    Yes, that would be good, thanks

  • Profile Image
    gerardw
    Answered on January 26, 2021 at 01:30 AM

    Thanks for the input.

    I have now escalated this as a feature request to our back end team. We will not be able to provide an ETA at the moment, but once this feature gets implemented we will let you know via this ticket.

  • Profile Image
    janberk
    Answered on March 18, 2021 at 05:59 AM

    Hi,

    We've made some updates about the appointment field recently. You can set an Update/Calculate field condition to copy appointment field values to date-time fields now. It will be more convenient to use this in your case.

    Please let us know if you have further issues.

    Thank you.