Allowing a user to invite members of a "team"

[Robert_Petitto]

@Mike_Gell

Could I use text entry fields instead? Wondering if I could simply title them “Player 1 Email”, “Player 2 Email”, etc. and then perform some type of relation in Glide to ensure they are stored as emails.

Ehhhh…it’s hairy. If anything, you could create a custom “form” using email entry fields to user specific columns, concatenate them using a template column and then submit that to the “Team Players” sheet…but you’d still run into the issue of removing them from the team if needed. There’s a complicated solution using the Trebuchet method:

Trebuchet Method Tutorial

Here’s another breakdown of the Trebuchet method for creating a “multi select component” from an inline list. I recorded it for a subscriber of mine, but figured it could benefit everyone. It requires 11 columns and a 6-action Custom Action. Not for the faint of heart, but the end result is very slick and requires no extra rows!