How can I create a variable to use across my base?

Hello, hope you don’t mind the newbie question.

How do you set a variable that I can call across

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.

Any help would be hugely appreciated.

Thanks!
Ian

It sounds like you need a table for [Groups], where each row is a group. There would be a column to store the groups’ unique url.

Then when you assign your other records to groups, you’d use a Link to Another Record-type field. Then you’d use a Lookup-type field to pull in the linked Group's {URL} field.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.