# Is it possible to use data from one sheet to show in others sheets without re-entry **URL:** \ **Category:** Ask for Help\ **Created:** [August 4, 2022, 8:09am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919 "2022-08-04T08:09:05Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 8:09am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/1 "2022-08-04T08:09:05Z")
Hi. I would like to use data from one sheet. Let’s say table number from one sheet. And don’t want to re-entry in others sheet. I tried to use relation already. But it didn’t work. Please advise. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 4, 2022, 8:13am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/2 "2022-08-04T08:13:19Z")
Hi @paiboolk, Get a value from one table to another table right? You can use the Single Value column! > **[Single Value Column](https://docs.glideapps.com/all/topics/computed-columns/primary/single-value-column#:~:text=The%20Single%20Value%20column%20lets,single%20value%20will%20be%20retrieved)** > > Copy a single value to every row Thank you ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 8:16am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/3 "2022-08-04T08:16:34Z")
I need only single data in single cell to update in other sheets. Not all records. It looks like to add table number for restaurant. I don’t want customer to re-entry. ---
**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:** [August 4, 2022, 8:20am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/4 "2022-08-04T08:20:41Z")
Make sure your relation is a single relation, and then use a lookup column through that relation. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 8:21am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/5 "2022-08-04T08:21:37Z")
I tried it already but didn’t work. Anyway, it worked if I entered data in such table. But I don’t want to re-entry. ---
**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:** [August 4, 2022, 8:22am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/6 "2022-08-04T08:22:51Z")
It works. You just need to configure it correctly. Please share a screenshot that shows how you have tried. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 8:41am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/7 "2022-08-04T08:41:40Z")
![1659602191472](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49fd4b2522b929e58a1d1eeffde678daf9f83641.jpeg) ![1659602191457](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/acd201d59c94b3255b9d8172f37317edfabbcc85.jpeg) ![1659602191466](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b65099064359782a064ff9d37aa47aa94957de8.jpeg) At first, I let customer to enter table number at the first page. It works by using relation to link data from all\_table\_number. After that, I want customer to enter something in the second tab (Let’s say “note”) without to enter table number again. ---
**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:** [August 4, 2022, 8:58am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/8 "2022-08-04T08:58:37Z")
Your first screen shot looks like a details screen, with a text entry component. And I’m guessing that the value that is entered there goes to your test\_order table in the table column, which looks like a user specific column. Is all of that correct? In your 3rd screen shot, it looks like you now have a form screen with another text entry component. What are you expecting to happen when the user submits the form? Because it’s a form screen, a new row will be added (presumably to your test\_orders) table. Is this your intention? It’s still not clear to me what you’re trying to do. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 9:07am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/9 "2022-08-04T09:07:49Z")
1)…which looks like a user specific column. Is all of that correct? → Correct. 2) I expect the table number entered from the first screen will be added to the 3rd screen (table) after submiting. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 9:22am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/10 "2022-08-04T09:22:47Z")
At the first page. I created “Table” field in Glide and set up to be user-specific already. It can link data from others which has the same data field. But for the 3rd form. I just want to link the table number to record in the database. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 4, 2022, 9:24am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/11 "2022-08-04T09:24:34Z")
Correct? > **[test\_order.mp4](https://drive.google.com/file/d/1gF9PUs5zwCVOVDLeHU2dEzxz-EHwULij/view?usp=sharing)** > > Google Drive file. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [August 4, 2022, 9:35am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/12 "2022-08-04T09:35:41Z")
Thank you for your kind support. It seems ok. Anyway, I will try to modify it to be mine. What happen if many users access to use this menu simultaneously. At my first page. I used user-specific column but the entried data didn’t display in the database. It’s so amazing. But it works very well. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 4, 2022, 10:14am UTC](https://community.glideapps.com/t/is-it-possible-to-use-data-from-one-sheet-to-show-in-others-sheets-without-re-entry/45919/13 "2022-08-04T10:14:30Z")
> [@paiboolk](#): > > Thank you for your kind support. Your Welcome! > [@paiboolk](#): > > What happen if many users access to use this menu simultaneously. They should get different results because this is a User Specific column! > [@paiboolk](#): > > I used user-specific column but the entried data didn’t display in the database. You mean it writes only to the first row right? Yeah, it’s because in your details tab the first row is only connected and once you write the table no it writes in the user specific column only in that row because once the screen get to the details tab the first row of that table is connected except if you add any filters!