I’ve added a datasource from google calendar, a column [Attendees] was added automatically in (List) type which contain the email addresses , when i view the data, it show only “PII”
If I view in AppSheet, it show the attendees email address, but also include the system gen email address (see below). How can I hidden all the system gen email address?
Thanks Aurelien,
Second question, how can I hidden the email address come with “@resource.calendar.google.com” ?
As far as I know, you can’t.
However, you could use a trick that would be to show another input field to your users, and calculate a concatenation of the user’s input and the resource email in the “real” in attendees list.
Is it add a new virtual column [new attendees], and grab the email address from [Attendees] by filter out “@resource.calendar.google.com”?
Could you show me the Expression formula, Thanks
