I’ve connect my app to Google calendars. The Title column of my calendar is coming from a referenced column:
The column Key of the reference Form Responses table is a UNIQUEID with the label of Full Name. For the header column of my calendar detail view I have selected Title:
this correctly displays as the label i.e. the Full Name.
When I go to Google calendars, the Title of the appointment is shown as the UNIQUEID. I’m assuming there’s no way to tell Google calendars to display the Full Name label instead. My work around is to force the initial view of the Description column of my calendar table to show the Full Name.
[_name] is a virtual column with formula
[Title].[Full Name]. This way, if I choose to view the appointment via Google calendars instead of Appsheet, I can at least see whom the meeting is with by looking at the description. Below is the Google calendar view of the appointment:
My question is, is there a way to disable editing of the Full Name in the Description column while still allowing users to add to the description on edit? In other words, can I force require that the initial view of
[_name] in the Description column not change on edit? e.g. Description goes from ‘Full Name’ to ‘Full Name’ + “whatever else the user inputs”?
I know I can add another virtual column and make things look okay with CONCATENATE(), but I don’t want to lose the user input on the Google calendar end.