Find Jobs
Hire Freelancers

Answer how to attach a pdf to a google calendar event from the FileMaker Script step detailed. R1

$30-250 CAD

Completed
Posted about 6 years ago

$30-250 CAD

Paid on delivery
I am able to successfully create calendar events on Google Calendar thanks to the great demo file from DB Services [login to view URL] My question is how to get the script step to successfully attache the file specified. I have very little understanding of json and I am stuck on how to format the url. I have been attempting to use a url pointing to a file through Google Drive File Stream but it is not working. I have been trying to follow the requirements at [login to view URL] One example that I am trying is file:///G:/Team Drives/[login to view URL] but no success. //calculation originated from [login to view URL] demo file //some modifications to the original calculation below including "location" and "attachments" Let ( [ vStartDateType = If ( not IsEmpty ( $startTime ) ; "dateTime" ; "date" ) ; vStartDate = If ( not IsEmpty ( $startTime ) ; $startDate & "T" & $startTime & timeOffsetUTC ; $startDate ) ; vEndDateType = If ( not IsEmpty ( $endTime ) ; "dateTime" ; "date" ) ; vEndDate = If ( not IsEmpty ( $endTime ) ; $endDate & "T" & $endTime & timeOffsetUTC ; $endDate ) ; vColor = $color ; vAttach = $filepaths ]; JSONSetElement ( "{}" ; [ "start" ; JSONSetElement ( "{}" ; vStartDateType ; vStartDate ; JSONString ) ; JSONObject ] ; [ "end" ; JSONSetElement ( "{}" ; vEndDateType ; vEndDate ; JSONString ) ; JSONObject ] ; [ "summary" ; $calendarTitle ; JSONString ] ; [ "location" ; $locationAddress ; JSONString ] ; [ "colorId" ; vColor ; JSONString ] ; [ "attachments" ; JSONSetElement ( "{}" ; "fileUrl" ; vAttach ; JSONString ) ; JSONObject ] ) )
Project ID: 16313952

About the project

2 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I'm former FileMaker employee, have 6 years working experience and a certified FileMaker Developer, so I can help you on this.
$111 CAD in 3 days
5.0 (1 review)
2.7
2.7
2 freelancers are bidding on average $73 CAD for this job
User Avatar
You cannot add attachments from your computer to a calendar event using the API. Only from google drive. Google servers cannot access your machine across the internet to download a file even if you had your ip in the url.
$35 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Red Deer County, Canada
5.0
2
Payment method verified
Member since Jan 11, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.