Remove reminder from Google Calendar entry

:bullseye: What is your goal?

To remove a reminder from a Google Calendar entry using a Make scenario.

:thinking: What is the problem & what have you tried?

I have an Excel spreadsheet containing the details of various appointments and I have created a scanario that will create a Google Calendar entry as soon as the appointment entry is created (using VBA). It also edits the entry and deletes it when required (all this is working well), My problem is that the ā€˜Create’ function adds a reminder to the entry (also working well), however under certain circumstances I would want to remove the reminder without deleting the complete entry.

I have tried sending..
A blank entry (returns error),
A zero entry (updates reminder to send reponse at start time of entry)
A numeric Zero entry (returns error)
A Minus number (returns error).

What I need is a value that will cause the reminder to be deleted completely… or some other way of doing.

I’ve thought of deleting the entire calendar entry then creating an extra scenario to create a new entry without the reminder but that seems awfully combersome.

I’ve searched every combination of terms I can think of nut haven’t found anything that helps…

RF

Welcome to the Make community!

Try using one of the following:

{{ null }}
{{ erase }}
{{ empty }}
{{ emptyarray }}

(copy-paste the above into the field, or type it exactly as shown)

Make sure you turn on ā€œMapā€ first.

e.g.:

Hope this helps! If you are still having trouble, please provide more details.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!