How can I use columns from different tables to fill values into google calendar

[mario-mueller]

Hi,
I habe attached a Google calendar into my app and I want to use a form to create events from the app.
But I need to be fill out the title of the event based on a dropdown from a different table.
The title should be a dropdown from the name of a persons, that is available in the table children.
Is this possible, because there are no references between the Google calendar and the other table.
Thx, Mario.

[Aurelien]

Hi @mario-mueller 

Yes it's possible.

Change the column type of your calendar table in your app editor.

Attendees is probably a type "List" by now.

Please add a User table, with the key property set on Emails, and Label property set on names.

Then, you must change the Attendees type to be EnumList, Base type Ref, source table : your table Users.

[AleksiAlkio · Accepted solution]

Yes that's possible for example with the Enum. Change the Title's column type to Enum and read the values for the dropdown for example with the formula in "Suggested value" like Tablename[ColumnName].