Struggling with People type column with Google Calendar sync

1

Hello,

I’m syncing some Google Calendars, so far so good. In Attendees I can see all participants, and the ones that are users of Coda appear with their avatar and correct tag.
In some cases however, for personal events, there’s no participant, so I’m creating another column that in that case it should pick the Created by column. However in this column it is displayed the email. If I set the column as People it shows as a warning.
I tried creating a “Team” table, with column Name (people type) and Email, so to add a lookup of the email to retrieve the name. In that case it shows as a chip with the name, but not with the Avatar, so it doesn’t seem to be consistent.

What am I doing wrong?

My intention, basically, is to find a way to filter all participants and show only the ones in the table Teams, and if empty, use the Created by user.

Thanks for your help!

1 Like
2

Sounds like you are retrieving a row from the ‘Team’ table and not the people column. You should add .Name to your formula.

If this doesn’t solve your issue please share the problematic formula.

1 Like