I have a base where I’m organising people into coaching groups.
Each coaching group has a unique name (Pacha, Twilo, Space etc). Each coaching group also has its own URL.
What I want to do
I’d like a field that autopopulates that Airtable URL whenever I assign somebody to a group.
So if I assign somebody to “Pacha”, another field updates with Pacha’s URL.
I guess that I need to create a table within my base to store these “variables” but I’m stuck on how to call them into the main table. I suspect it has something to do with linked fields and lookups, but whenever I read the documentation I get stuck.