# Button Action - Go To Tab - Create and Select Record **URL:** \ **Category:** Ask for Help\ **Created:** [June 7, 2024, 9:12pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971 "2024-06-07T21:12:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![mkbw](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mkbw/32/74637_2.png) [@mkbw](https://community.glideapps.com/u/mkbw)\ **Post date:** [June 7, 2024, 9:12pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/1 "2024-06-07T21:12:10Z")
Is it possible to have an action navigate to a specific record? specific record in a foreign tab? Seems really basic but I am stumped. Background: I’m working on an app for which address validation is critical. Given that this is not possible within a form screen, a form container, or when editing a record within a collection edit screen My plan of attack was to create buttons to navigate to another tab that is a custom form attached to a in-process table. That custom form with address validation in it would have a button action that committed the record to the main table and then deleted the temporary record in the in-process table. Shoutouts to @Darren_Murphy and @Robert_Petitto whose videos and posts have been great and very useful for custom forms and address validation. Became a paid subscriber today. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 8, 2024, 12:29am UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/2 "2024-06-08T00:29:26Z")
> [@mkbw](#): > > Is it possible to have an action navigate to a specific record? specific record in a foreign tab? Yes, as long as you have a relation/single value column that points to the other table’s record, then you should be able to show that related record’s details view. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 8, 2024, 4:15pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/3 "2024-06-08T16:15:04Z")
Amazing! In more complex scenarios, I’ve used this trick often: https://www.loom.com/embed/cdf1ad9dbcad4c4ea91d542f450cbbde ---
**Author:** ![mkbw](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mkbw/32/74637_2.png) [@mkbw](https://community.glideapps.com/u/mkbw)\ **Post date:** [June 10, 2024, 1:05pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/4 "2024-06-10T13:05:06Z")
Thank you both. I don’t desire to retain the original data in its initial table so I guess I need a temporary relation to capture this data before clearing the column values. On an Action \> Add Row - is there a way to query the _new_ foreign record’s Row ID or URL within an action? Seems like something that should be there? Guessing I’ll have to do something like this unless I am missing something: - Custom form “New Task” click submit button - Action \> Add Row in foreign table “Tasks” - Navigate to URL of new record in foreign table “Tasks” via a relation/lookup similar to your video but opposite perspective - Clear Column Values in Custom Form “New Task” (breaking relation) - Navigate to Record in foreign table “Tasks” Take @Darren_Alderman video [https://www.youtube.com/watch?v=6Uxh71wJVhQ](https://www.youtube.com/watch?v=6Uxh71wJVhQ) instead of landing on the “Thank You” container in the form I want to navigate to the record created in the “Form Submissions” table. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 10, 2024, 2:02pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/5 "2024-06-10T14:02:42Z")
> [@mkbw](#): > > On an Action \> Add Row - is there a way to query the _new_ foreign record’s Row ID or URL within an action? Unfortunately, no. I’ve requested this feature a few times though. Not sure if it’s been made into a formal request here in the forums. I agree that it’s a much needed feature. @Brett ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 10, 2024, 2:05pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/6 "2024-06-10T14:05:14Z")
> [@mkbw](#): > > landing on the “Thank You” container in the form I want to navigate to the record created in the “Form Submissions” table. If you’re using a form screen, the I submit action is the way to go. If you’re using a custom form with an add row, there’s no way to do this without a relation UNLESS, you first add a Unique ID to the helper table, send that value to the child table, create a relation between the two, and add a show details screen of the relation. ---
**Author:** ![mkbw](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mkbw/32/74637_2.png) [@mkbw](https://community.glideapps.com/u/mkbw)\ **Post date:** [June 10, 2024, 2:05pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/7 "2024-06-10T14:05:27Z")
I was wayyyy overthinking this but I certainly learned a lot about glide… Custom form “New Task” submit button **Action** Add row to foreign table “Tasks” Go to Screen using relationship to Tasks Set Column Values in table “New Task” to null via clear Set Column Values in “Tasks” column in field holding the rowID of it the row that created it within “New Task” Results: Custom Form creates row in foreign table User is navigated to new task in tasks table created via custom form Custom Form is cleared Temporary relationship to allow navigation is cleared I think what got me way off in the weeds was that Glide itself under the hood is creating a temporary relationship when it executes the Add Row action in a foreign table but Glide doesn’t allow you to capture that new Row ID. The concept that I had to create a relationship within the tables myself and then clear it was not obvious. Case in point to walk away when you get frustrated and revisit with fresh eyes. Also, never be afraid to ask for help and make yourself look silly. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 10, 2024, 2:09pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/8 "2024-06-10T14:09:53Z")
Vote here > [@\[REQUEST\] Return RowID of newly created row from an Add Row action](https://community.glideapps.com/t/request-return-rowid-of-newly-created-row-from-an-add-row-action/74020): > > Whenever I create a custom form, I’d like to return the row ID of the newly created row back to the parent table. Currently, this is only possible when adding a row via the API. My request is to add a new dropdown field on the Add Row action block That allows us to select a column to which will write the newly created row ID from the Add Row action. This is similar to the Glide API action blocks that allows us to write a response to a column once the action runs. ---
**Author:** ![mkbw](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mkbw/32/74637_2.png) [@mkbw](https://community.glideapps.com/u/mkbw)\ **Post date:** [June 10, 2024, 2:14pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/9 "2024-06-10T14:14:52Z")
@Robert_Petitto haha. I’m just a beginner a couple of weeks into Glide (past experience in the Filemaker, CrystalReports, and Qlik realms) but already going so far into the weeds I’m generating feature requests via an expert. 🤣 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 10, 2024, 2:28pm UTC](https://community.glideapps.com/t/button-action-go-to-tab-create-and-select-record/73971/10 "2024-06-10T14:28:55Z")
Welcome to the community! It’s a great place to learn and find support!