0

Integration from Calendly into Ninox

Hi, I am trying to set up intergration from calendly via zapier to my appointments table in Ninox.

The time stamps provided by Calendly appear like so: “Event Start Time 2020-12-01T08:30:00+00:00 / Event End Time 2020-12-01T09:00:00+00:00” which does not automatically match with the Ninox “Appointment” field.

Through Zapier“s text formatter, I have tried Unix formatting (1606811400000-1606813200000) and also extracted the data to show as ”01/02/2020 08:30 - 09:00“ (which matches how the appointment field is displayed to me), however, neither format works on updating an Appointment field.

 

Please can someone share the format required to update an Appointment field?

5 replies

null
    • Kent_Signorini
    • 1 yr ago
    • Reported - view

    Did you ever solve this? I'm having a similar problem.

    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    'Appointment field' := appointment(datetime(Date, 'START TIME'),datetime(Date, 'END TIME')))

      • Kent_Signorini
      • 1 yr ago
      • Reported - view

      RoSoft_Steven 

      So you have the Zap hitting separate Date fields as well as separate START TIME and END TIME fields?

      Did you put this code on the On update for the separate fields? or where?

      Thanks!

      • Kent_Signorini
      • 1 yr ago
      • Reported - view

      Kent Signorini To answer my own question, Yes!

      • Kent_Signorini
      • 1 yr ago
      • Reported - view

      RoSoft_Steven This seems to work well for almost every entry with a date and time. For ones that are full-day, it's creating an entry on the day before as well. I'm using Google Calendar instead of Calendly but this really helped me out. I just have to solve this Mountain-to-UTC problem of the extra, day-before and it's done. Thanks!

Content aside

  • 1 yr agoLast active
  • 5Replies
  • 429Views
  • 2 Following