Integração com Google Calendar

  • Sampaio_Octavio
    Perguntado em 10 de setembro de 2024 às 16:04

    Boa tarde

    Eu gostaria de saber se voces modificaram a integração com o GCalendar. Porque não estou conseguindo visualizar os campos do formulario na agenda . Não estou usando o appointment, porque as reservas tem um tempo de duração variavel, entao estou tuilizando o date picker com dia e hora de inicio e dia e hora de fim. Acredito que fizeram um upprade e agora so tenho os campos do appointment.

    Veja como era antes :Integração com Google Calendar Image 1 Screenshot 30

    e agora aparece desta forma impedindo o uso de outra configuração que nao o appointment.

    Integração com Google Calendar Image 2 Screenshot 41

    Seria possivel deixar a duração do evento em branco e a pessoa que fizesse a reserva escolhesse o tempo ( minimo de 1 hora).?

    Grato

  • Jefferson Jotform Support
    Respondido em 10 de setembro de 2024 às 18:37

    Hi Sampaio_Octavio,

    Thanks for reaching out to Jotform Support. Our Portuguese Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, it might take a while until they're available again.

    Now, coming back to your question, I checked your account and I cannot see a form that is the same as the screenshot that you provided. Can you provide me the form URL so we can help you more? Here's how to do it:

    1. In Form Builder, click on the Publish tab in the orange navigation bar at the top of the page.
    2. Click on the Quick Share tab on the left side of the page and click the Copy Link button on the Quick Share window.Steps to get the form URL in Jotform Screenshot 10

    We also have a guide about Where to Find Your Form URL that you can check out.

    After we hear back from you, we’ll have a better idea of what’s going on and how to help.



  • Sampaio_Octavio
    Respondido em 11 de setembro de 2024 às 11:24

    That´s the link to the form


    https://form.jotform.com/242536009082048

    Thanks

  • Jefferson Jotform Support
    Respondido em 11 de setembro de 2024 às 12:01

    Hi Sampaio_Octavio,

    Please note that the Google Calendar no longer supports the DateTime Single widget for the form integration. As a workaround, you can use instead the Appointment or Date Picker element. Check out the screencast below:

    Integração com Google Calendar Image 1 Screenshot 40

    Now, you can match the fields in your Google Calendar integration. Let me show you how:

    1. In your Google Calendar integration settings, select your email in the Select calendar field.Integração com Google Calendar Image 2 Screenshot 51
    2. Next, select the Appointment or Date Picker in the Match fields option, as well as the duration.
    3. Hit on Save to complete your integration. Integração com Google Calendar Image 3 Screenshot 62

    Give it a try and let us know how it goes.

  • Sampaio_Octavio
    Respondido em 11 de setembro de 2024 às 13:12

    Dear Jefferson

    Thank you very much for your support, but the problem still persist as the duration of the reservation time is set only till "+60min" and after that, the option is " all day", so I did not have the precise duration of the reservation. As an example if someone fill a reservation for five hours, I will have to set "all day", and after I receive a form in my calendar I have to edit the duration of the meeting, manually. This is a step back with Google calendar.

    I´ll like to suggest, as a way around of this problem with GCalendar, the appointment tool should have a variable time schedule, so that the people filling the form, will be able to define the duration of the appointment, and this will reflect in GCalendar. What you think of this, is it possible?

  • Jefferson Jotform Support
    Respondido em 11 de setembro de 2024 às 14:22

    Hi Sampaio_Octavio,

    I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    In the meantime, let us know if there’s anything else we can help you with. 



  • Jefferson Jotform Support
    Respondido em 12 de setembro de 2024 às 02:48

    Hi Sampaio_Octavio,

    Unfortunately, we cannot implement what you want because one appointment element is only for one duration. As a workaround, We can add a Date Picker element to your form and add a conditional logic. Here's how to do it:

    First, we need to add a Date Picker element. Here's how to do it:

    1. In Form Builder, click on the Build tab in the orange navigation bar at the top of the page.
    2. Click on the Basic tab on the left side of the page.
    3. Drag the Date Picker element on the form and rename it as Date and Time.Integração com Google Calendar Image 1 Screenshot 130
    4. Click on the gear icon to open the Date Picker properties.Integração com Google Calendar Image 2 Screenshot 141
    5. In the Date Picker Properties, click on the Time tab.
    6. In the Time Tab, turn on the Time Field.Integração com Google Calendar Image 3 Screenshot 152

    Next, we need to add a dropdown menu. Here's how to do it:

    1. In Form Builder, click on the Build tab in the orange navigation bar at the top of the page.
    2. Click on the Basic tab on the left side of the page.
    3. Drag the Dropdown Menu element on the form and rename it as Duration - Hours.Integração com Google Calendar Image 4 Screenshot 163
    4. Click on the Edit Options.
    5. Paste the value 1 to 12. Integração com Google Calendar Image 5 Screenshot 174

    Next, we need to add a Number element. Here's how to do it:

    1. In Form Builder, click on the Build tab in the orange navigation bar at the top of the page.
    2. Click on the Basic tab on the left side of the page.
    3. Drag the Number element on the form and rename it as Duration in Minutes.Integração com Google Calendar Image 6 Screenshot 185

    Next, we need to add a condition to your form. Here's how to do it:

    1. Click on the Settings tab in the orange navigation bar at the top of Form Builder.
    2. Select Conditions on the left side of the screen.
    3. Click on +Add a New Condition.Integração com Google Calendar Image 7 Screenshot 196
    4. Select Update/Calculate Field and then set the conditions just like you see below:Integração com Google Calendar Image 8 Screenshot 207Integração com Google Calendar Image 9 Screenshot 218

    Next, you can match the fields in your Google Calendar integration. Let me show you how:

    1. In your Google Calendar integration settings, select your email in the Select Calendar field.Integração com Google Calendar Image 10 Screenshot 229
    2. Next, select the Date and Time element in the Start Time and Duration in Minutes Number element in the Duration.
    3. Hit on Save to complete your integration. Integração com Google Calendar Image 11 Screenshot 2310

    Here's the sample output:

    Integração com Google Calendar Image 12 Screenshot 2411

    Reach out again if you have any other questions.



  • Sampaio_Octavio
    Respondido em 12 de setembro de 2024 às 14:16

    Dear Jefferson


    Thank you very much for your help and support.

    Your workaround functioned very well, and the result come out as I wished .

    Great Job and see you next time.!!!

    Thanks again