Skip to main content
Solved

Open a record in another table based on single select field

K

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}?”

Best answer by Kamille_Parks11

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.

View original
Did this topic help you find an answer to your question?

2 replies

Kamille_Parks11
Forum|alt.badge.img+15

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.

ScottWorld
H
K
3 people like this
  • ScottWorld
    ScottWorld
  • H
    Hannah_Wiginton
  • K
    Kerri_Palmer
K
  • Kerri_Palmer
  • Author
  • New Participant
  • 1 reply
  • July 17, 2022
Kamille_Parks11 wrote:

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!

Reply


Most helpful members this week

Terms & Conditions