About Ivy_Private

Ivy_Private · 12-19-2020

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 aut...

Ivy_Private · 12-21-2020

Steve: SUBSTITUTE( "{}/{}", "{}", CONCATENATE( TEXT( [AppointmentDate], "YYYYMMDD" ), "T", TEXT( "02:00:00, "HHMMSS" ) ) ) Perfect! I have not tried Substitute before. Works like a charm

Ivy_Private · 12-20-2020

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([Appoin...

Ivy_Private · 12-20-2020

Bellave_Jayaram: T 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:...

AppSheet Creators Community

My Stats

Ivy_Private's Bio

Badges Ivy_Private Earned

Recent Activity

Get the date to copy to google calendar

Re: Get the date to copy to google calendar

Re: Get the date to copy to google calendar

Re: Get the date to copy to google calendar