# Add Row to Different Table **URL:** \ **Category:** Ask for Help\ **Created:** [July 9, 2025, 3:12am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053 "2025-07-09T03:12:34Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 3:12am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/1 "2025-07-09T03:12:34Z")
Hello, Im trying to record the information of selected items or submitted forms into its own table. On a view details screen pulling from table A, I have a button which when pressed I want the action to be - Add Row, but to a different table, table B. Is this possible? The linked table initially sets the add row details to table A column names, then when I change the destination table to Table B, all the options below where you link to what column you want the data entered into clears and turns to the word Custom. So from here I am getting confused as to whether it can be done? any help here would be much appreciated it as its the main thing blocking me. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 9, 2025, 3:41am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/2 "2025-07-09T03:41:15Z")
The Add Row action can write to any table. When you select Table Byou will see the columns from that table. Then you need to choose the column values from Table A that will be written to Table B. Choose Table B as your destination and then set the the values you want to populate I to each column. ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 4:23am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/3 "2025-07-09T04:23:20Z")
Thanks Jeff, I thought that was how it was suppose to work but when I select table B (in this instance Materials), all the values change to empty and just say Custom: ![Screenshot 2025-07-09 at 2.20.57 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f75ddb6d502ac321b303bd5dc28567bb3c325a3.png) Then If I click into an option value to try link it to my table, nothing shows up in the list: ![Screenshot 2025-07-09 at 2.21.57 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6af8d8fa6aa895cdccd07a5096afde2a33ca065e.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 4:24am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/4 "2025-07-09T04:24:40Z")
Are there any columns in your Materials table? Can you share a screen shot of that table? ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 4:25am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/5 "2025-07-09T04:25:51Z")
![Screenshot 2025-07-09 at 2.25.25 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/47ecd26ec489fbfdf29240bd845b754000955024.png) this is the material table where I want the row created ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 4:27am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/6 "2025-07-09T04:27:53Z")
Okay, so just going back to your earlier screen shot… ![CleanShot 2025-07-09 at 12.26.40@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df46481af9ae22e21a996cd056166c4e45dafbc7.jpeg) ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 4:29am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/7 "2025-07-09T04:29:46Z")
oh sorry I cropped that out the only thing there is the first Column on the table. (ive changed the table layout and whatever is first in the table goes here) ![Screenshot 2025-07-09 at 2.29.26 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28d3cdbefe08e1d7a6100b21cb1ac5432dc97309.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 4:42am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/8 "2025-07-09T04:42:33Z")
Are you sure the Form is targeting the correct table? That RowID value doesn’t correspond with your earlier screen shot 🤷‍♂️ ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 4:51am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/9 "2025-07-09T04:51:25Z")
sorry let me rephrase that. that one option showing at the bottom is pulling from the table of the details originally showing so my Table A. - and like I mentioned whatever is first in that table goes here. So to clarify, I’m in a detail screen of Table A and want the button action to add a row to Table B. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 4:55am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/10 "2025-07-09T04:55:20Z")
oh yeah, sorry. That’s my bad - I asked the wrong question. So presumably your first table contains more columns than just the RowID? Would you mind sharing a screen shot of that one? ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 5:05am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/11 "2025-07-09T05:05:49Z")
yep has about 5 columns of information. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 5:08am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/12 "2025-07-09T05:08:06Z")
Something isn’t right. What type of columns are they? Can you show me please? ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 5:19am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/13 "2025-07-09T05:19:08Z")
yep, so this is table A (Toilet Types). - the temp QTY field is user specific I dont know if I need that it was just me trying to get the QTY the user enters to go somewhere but I really just need it on the Table B where I want the new row to be created. -the user would select the toilet type from a list pulling from this Table A, then I’m trying to use a form or new screen to enter a QTY then place the toilet type and QTY required into Table B. ![Screenshot 2025-07-09 at 3.19.33 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c05ea928eb63f6cca22948d90b4013ab9c327184.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 5:29am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/14 "2025-07-09T05:29:46Z")
Okay, that’s really helpful. Now I understand what’s going on. I would suggest a slightly different approach. Firstly, you can get rid of all those User Specific columns. You don’t need them. Set it up as follows: - Use an action to Show Form Screen - Target the form at your Materials table - Add a Choice component. Set the target as the Product Option column. Set the source table as the Fit Off Toilet Types table. - Add a Number Entry component. Target this at the QTY column - Add two special value components. One to capture the signed in users email address, and another to capture the current date/time. Target these at the appropriate columns in your materials table. That should be all you need. > **[Current Date/Time | Glide Docs](https://www.glideapps.com/docs/reference/values/current-date-time)** > > Submit the current date and time automatically. > **[Values | Glide Docs](https://www.glideapps.com/docs/reference/values#user-profile-values)** > > The different types of values you can work with in Glide. ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 5:46am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/15 "2025-07-09T05:46:58Z")
Followed your steps and it worked! THANK YOU! ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 9, 2025, 6:02am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/16 "2025-07-09T06:02:30Z")
a follow up question though, can the choice selector pull from different Tables other than always Table A. so for example, when they click toilet this choice selector makes sense to pull from Toilet Types table, but if the next item down was selected so Bathtub - this has its own table of bathtub types. so the selector would now need to show bathtub types not toilet types. So I guess I want to know how I can set an individual form setup for each item selected rather than one blanket form for all items in my list. hope this makes sense… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 9, 2025, 6:10am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/17 "2025-07-09T06:10:25Z")
Yes, you can do that. A choice component can use any table as its source. And then you can use screen value visibility conditions to hide/show the next choice component depending in the first selection. However, in this case I would recommend refactoring your data. Instead of multiple tables, combine them all into a single “Items” table. This table would have a minimum of two columns: - Item Type - Item Option If you set it up that way, it will be a lot easier to manage. All you would need is two choice components, no matter how many different Item Types you have. The first one would be for Item Type, and the second for Item option. And you would use screen value filtering to narrow the options in the second one. > **[Screen Values | Glide Docs](https://www.glideapps.com/docs/reference/values/screen-values)** > > Values that you can access from the current screen. ---
**Author:** ![Mel.Topazes](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mel.Topazes](https://community.glideapps.com/u/Mel.Topazes)\ **Post date:** [July 10, 2025, 12:02am UTC](https://community.glideapps.com/t/add-row-to-different-table/83053/18 "2025-07-10T00:02:19Z")
I got this working from your information, and I understand how it’s setup, much appreciated!