Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 18, 2020 01:15 PM
Hi! I’m relatively new to Airtable, can I set a button field to go to a specific view and either select or scroll to the related record in a different table?
Basically, I want to ‘one click’ and get right to the related record line on a grid view. I’ve gotten to the table but am unsure how to get the view or related record I’d like selected.
Thanks!
Nov 18, 2020 03:42 PM
@Scott_Smith. Welcome to the community!
Yes this should be achievable. It’s all about the URL structure.
If you navigate to the view you’re looking navigate to, then look at the URL bar in your browser you’ll see a part of the URL that begins with viw. This is the view ID.
If you open up a record in that view, the URL changes, and now there is a section of the URL that begins with rec. This is the record ID.
You can store these portions of the URL in fields and build them in the button URL formula, or code them directly into the formula.
If you need further assistance, let me know. If you can provide some specifics I can try to emulate something for you.
Nov 18, 2020 04:53 PM
Thanks, that is helpful. So, I have the record ID stored now. What I’m stuck on is how to navigate to the correct record line item. How would I build the structure of the URL? It seems to just take me to the correct view and stops there. is it. viw…?/{rec id}. or viw…/{rec id}? or am I way off? ha.
Nov 18, 2020 06:52 PM
What is your ideal view when you click on the link?
do you want to see the card view of the record (the one with revision history, comments, and records fields stacked vertically)?
Nov 19, 2020 03:48 AM
I could see multiple uses for what I’m trying to do.
Nov 19, 2020 07:39 AM
Your formula will look something like this
"https://airtable.com/tbl9W9fL9811p3Zml/" & {field containing the target view ID} & "/" & {field containing target record ID}
Nov 19, 2020 08:17 AM
got it to work, thanks!!!
B. Is it possible to to do this, but instead of opening up the “rec…” linked record in card view it opens up a new blank record?
I’d like to try this, I made the view shareable. How would I structure the link formula?
Thanks so much for the help… really appreciated.