Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Open a record in another table based on single select field

Topic Labels: Base design
Solved
Jump to Solution
245 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, all!
Is there any way to open a specific record in a table by clicking on the value in a single select field? Or is there a way to create a button with the functionality “if {single select field} says “value” open {specific record in another table}?”

1 Solution

Accepted Solutions

Since the direct URL for any record is predictable, you could I guess create a Button field that will open a specific record when you click it? The formula might be:

SWITCH(
{Single Select Field},
"Option 1", "https://airtable.com/baseID/tableID/viewID/recordID1",
"Option 2", "https://airtable.com/baseID/tableID/viewID/recordID2",
"Option 3", "https://airtable.com/baseID/tableID/viewID/recordID3"
)

Open up each of your intended records to get the base and other IDs from the address bar.

Clicking on the single select field itself will just highlight the cell, you can’t turn those into clickable links.

See Solution in Thread

2 Replies 2

Since the direct URL for any record is predictable, you could I guess create a Button field that will open a specific record when you click it? The formula might be:

SWITCH(
{Single Select Field},
"Option 1", "https://airtable.com/baseID/tableID/viewID/recordID1",
"Option 2", "https://airtable.com/baseID/tableID/viewID/recordID2",
"Option 3", "https://airtable.com/baseID/tableID/viewID/recordID3"
)

Open up each of your intended records to get the base and other IDs from the address bar.

Clicking on the single select field itself will just highlight the cell, you can’t turn those into clickable links.

Thank you so much! This worked perfectly!