# Add a row in table with pre-filled values from another table **URL:** \ **Category:** Ask for Help\ **Created:** [May 23, 2022, 6:28pm UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285 "2022-05-23T18:28:36Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![cmonDE](https://avatars.discourse-cdn.com/v4/letter/c/d26b3c/32.png) [@cmonDE](https://community.glideapps.com/u/cmonDE)\ **Post date:** [May 23, 2022, 6:28pm UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285/1 "2022-05-23T18:28:36Z")
My use case is building a saas web app as an inventory management system for medical products. I’m new to the no code world an do not have any code skills. i already tried different tools like adalo, softr, stackerhq, [bubble.io](http://bubble.io). glide works very well for me until now. but there is one function i couldn’t build: i do have a table “product-template” with a lot of fields for one product (for example name, manufacturer., service interval…). the idea is to add a new row to the other table “products” and pre-fill most of the fields with values from the “product-template” table. at the end the user can duplicate the template product and just add unique information like “serial number” or “purchase date”. is there a way to build this function with glide pages or glideapps? thank you very much! cmon ---
**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:** [May 23, 2022, 6:47pm UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285/2 "2022-05-23T18:47:15Z")
> **[Column values](https://docs.glideapps.com/all/topics/values/column-values#column-values-in-submission-screens)** > > Access values for the current item ---
**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\ **Post date:** [May 23, 2022, 6:52pm UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285/3 "2022-05-23T18:52:46Z")
> [@cmonDE](#): > > pre-fill most of the fields with values from the “product-template” table Hi, if the information in the product-template table is always tied to that specific product, I wouldn’t bring that information into another table; I would reference that item with an “Item ID”, or better, add a RowID to the product-template table and reference it by that. Doing it that way, if any information changes like the price (or the description is updated to correct a spelling error), you don’t have the bad information in your “products” table – you can display all the other information by making a relation between the two tables based on the RowID of the product-template table. ---
**Author:** ![cmonDE](https://avatars.discourse-cdn.com/v4/letter/c/d26b3c/32.png) [@cmonDE](https://community.glideapps.com/u/cmonDE)\ **Post date:** [May 24, 2022, 5:51pm UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285/4 "2022-05-24T17:51:16Z")
> [@David\_Gabler](#): > > Hi, if the information in the product-template table is always tied to that specific product, I wouldn’t bring that information into another table; I would reference that item with an “Item ID”, or better, add a RowID to the product-template table and reference it by that. the new product in the “products” table should not be linked to the template. i don’t want the product to be updated, when the template is changed or deleted. @Jeff_Hager thank you. i now have a inline list of the template products an when i click on a product a details form is opened, where i can add additional values and store it in the product table as destination. this worked in the glide app. i could not find a workaround for glide pages. unfortunetly the links you posted seems to be for an older version of glide and i could not transfer this to the newer version ---
**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:** [May 25, 2022, 12:43am UTC](https://community.glideapps.com/t/add-a-row-in-table-with-pre-filled-values-from-another-table/42285/5 "2022-05-25T00:43:46Z")
> [@cmonDE](#): > > this worked in the glide app. i could not find a workaround for glide pages. Are you using a “show form” action in Glide Pages? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e207e588a32925ee4b35aeb68a39c8cc4ba5fe7.png) When you search for the column name on the left-sided panel, you should see some screen values/user profile values to automatically pass to the destination table.