Google Calendar text formatting

AppSheet AppSheet Q&A
,
1

When we add a new event to Google Calendar we can format the text.
I have connected Google Calendar as a source to my App. Via LINKTOFORM I create new events in the Google Calendar.
Is it possible to do the formatting also via the LINKTOFORM?
Or is there another Workaround?
I like to get something like this:

2X_c_c0e900ee42d87c0b7f760f5beb7dbcc8d20f8263.jpeg
2X_c_c0e900ee42d87c0b7f760f5beb7dbcc8d20f8263.jpeg354Ă—157 5.06 KB

1 Like
2

I’m afraid you can’t format the column header… not even on the detail view.

3

Sorry Aleksi. I mean to format the data sent to Google Calendar. The Screenshot is from Google Calendar.

4

If I understand your request, I’m afraid it won’t be possible.

1 Like
5

Okay thank you for confirming.

6

I just learned, that this is possible. Thanks to @WillowMobileSystems

[Enabling app users to add Google Calendar events from your app](https://community.appsheet.com/t/enabling-app-users-to-add-google-calendar-events-from-your-app/8858/27) Tips & Tricks ?

You will need to insert in HTML new line tags -
. For example this URL &details code: [Screen Shot 2020-10-21 at 11.27.17 AM] looks like this in the Details pane of a Google calendar event form: [Screen Shot 2020-10-21 at 11.27.39 AM]

The LINKTOFORM() expression looks like this:

LINKTOFORM( .... ,
"Description" ,
CONCATENATE(
"<b>Customer</b>
" , [Customer] , "

<b>Phone</b>
" , [Phone]
)
...
)
6 Likes
7

I can’t take the credit…I actually learned this from @Steve!! Kudos to you Steve!

I have generalized this into if you are posting ANYTHING into a browser or cloud based “thing”, it is likely inserting the text into some HTML control and therefore the <br> tag will work. Of course, it may not always be the case.

4 Likes