I created action, โAdd to GCalโ. It is a button on a order.
If the appointment date is filled up, the button appears and then when clicked will be redirected to google calendar.
I so far managed to get the name, remarks and location from appsheet automatically copied to the form through this code:
CONCATENATE(
โhttps://www.google.com/calendar/render?action=TEMPLATE&text=โ,
ENCODEURL([ContactRec].[Name]),
โ&dates=โ,
ENCODEURL([TIME FORMAT FOR GCAL]),
โ&details=โ,
ENCODEURL("Remarks: โ), ENCODEURL( [Remarks]), ENCODEURL(โ Next Topic: "), ENCODEURL([Next_Topic]),
โ&location=โ,
ENCODEURL([ContactRec].[Territory]),
โ&sf=true&output=xmlโ
)
I am simply unable to grab the date. It must be the date format.
I tried this:
TEXT([AppointmentDate], โYYYY/DD/MM/HH/MM/SSโ)
Solved! Go to Solution.
Try:
SUBSTITUTE(
"{}/{}",
"{}",
CONCATENATE(
TEXT(
[AppointmentDate],
"YYYYMMDD"
),
"T",
TEXT(
"02:00:00,
"HHMMSS"
)
)
)
See also:
What do you mean by this? Does your data include the date and time you need? Do you need the current date and time? Please clarify.
Yes, I need the date in the format it needs to be so I can add it too google calendar.
Like this: 20161208T160000/20161208T180000
I simply do not know how, I tried this formula:
CONCATENATE(YEAR([AppointmentDate]),MONTH([AppointmentDate]),DAY([AppointmentDate]),โTโ,HOUR(โ002:00:00โ),MINUTE(โ002:00:00โ),SECOND(โ002:00:00โ)"/"YEAR([AppointmentDate]),MONTH([AppointmentDate]),DAY([AppointmentDate]),โTโ,HOUR(โ002:00:00โ),MINUTE(โ002:00:00โ),SECOND(โ002:00:00โ))
Try:
SUBSTITUTE(
"{}/{}",
"{}",
CONCATENATE(
TEXT(
[AppointmentDate],
"YYYYMMDD"
),
"T",
TEXT(
"02:00:00,
"HHMMSS"
)
)
)
See also:
Perfect! I have not tried Substitute before. Works like a charm
Instead of TEXT() use YEAR(), MONTH() and DAY() functions to get the desired format.
What you need to pass is the ISO format - I got this from stack overflow:
I feel like this could be my answer, how would I put it as my formula though:
I tried this and it isnโt working.
CONCATENATE(YEAR([AppointmentDate]),MONTH([AppointmentDate]),DAY([AppointmentDate]),โTโ,HOUR(โ002:00:00โ),MINUTE(โ002:00:00โ),SECOND(โ002:00:00โ)"/"YEAR([AppointmentDate]),MONTH([AppointmentDate]),DAY([AppointmentDate]),โTโ,HOUR(โ002:00:00โ),MINUTE(โ002:00:00โ),SECOND(โ002:00:00โ))
AppointmentDate is where the date is.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |