With a ‘link to another record’ data type, I’d love to be able to filter which options are available to pick.
I’m using Airtable to make a rostering database. I’ve got one table that stores the jobs to be rostered for each event, and another table with a list of volunteers and the jobs they’re able to do.
Each job is a column in the Roster table, and each job is linked to the ‘People’ table. I would find it useful if I could filter people based on whether they are able to do the job specified in the column.