Calendly to dropbox integration shows wrong time + cancelled meetings

[Christian_Valtanen]

QUESTION 1:

I have created automation that exports all calendly meetings to dropbox and then print those with printer.

Make is like this:

Result is like this:

Problem is time is three hours too early. In calendly times are showing right. How that could be fixed?

QUESTION 2:

If people cancels meeting I dont get a print. I was thinking how if I automate so that it prints only in the morning at 07:00 so would it not print events that are cancelled during same day or how it could be arranged so I dont get cancelled meetings printed?

[samliew]

Welcome to the Make community!

@Christian_Valtanen

Problem is time is three hours too early. In calendly times are showing right. How that could be fixed?

The date/time is correct, just displayed in the UTC timezone.

If you want to format it in another timezone, you can use the built-in function formatDate.

According to the Tokens you can use to format a date variable, you can use DD-MM-YYYY HH:mm:ss.

e.g.:

{{ formatDate(now; "DD-MM-YYYY HH:mm:ss") }}

For more information, see Date Format links below.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Christian_Valtanen]

@samliew

{{ formatDate(now; "DD-MM-YYYY HH:mm:ss") }}

Thanks for tips:

I changed code like this and it shows right time.

Alkaa: {{formatDate(1.scheduled_event.start_time; “ddd DD-MM-YYYY HH:mm”)}}

Päättyy: {{formatDate(1.scheduled_event.end_time; “ddd DD-MM-YYYY HH:mm:ss”)}}

Question two. Can Make translate weekdays to Finnish language?

[samliew]

@Christian_Valtanen

Can Make translate weekdays to Finnish language?

No problem, glad I could help!

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

• others can save time when catching up with the latest activity here, and
• allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.