# Please instruct me on how to handle the issue of accessing shared data from one table. **URL:** \ **Category:** Ask for Help\ **Created:** [February 27, 2024, 4:30am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191 "2024-02-27T04:30:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 27, 2024, 4:30am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/1 "2024-02-27T04:30:05Z")
I have a raw material price list consisting of 2 columns: the raw material name column and the raw material price column. Material A costs 10, material B costs 20, material C costs 25. I have a product pricing table consisting of: column 1 is the product name column, column 2 is the quantity 1 column, column 3 is the price column taken from the raw material table. Column 4 is the quantity 2 column, column 5 is the price taken from the raw material table. Column 6 is the total of column 2 multiplied by column 3 and column 4 multiplied by column 5. So can I get the raw material price in column 3 and 5 in the product pricing table from the raw material price list? and how should I do it? The purpose is that when I change the price in the raw material price list, the corresponding price in the product pricing table also changes. ---
**Author:** ![Kartik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kartik/32/37220_2.png) [@Kartik](https://community.glideapps.com/u/Kartik)\ **Post date:** [February 27, 2024, 4:51am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/2 "2024-02-27T04:51:48Z")
You can use computed columns like Relation, Lookup, Query for such types of requirements. You can link Raw Material and Product Pricing tables using a common field. As I understood from your write up, “Material” field in the “Raw Material” table and the “Product” field in the “Product Pricing” table are common fields from both tables. You can use the Relation column to link both tables using common fields, i.e. Raw Material - Material \<—\> Product Pricing-Product. ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 27, 2024, 9:50am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/3 "2024-02-27T09:50:46Z")
Thank you very much for your response. I have attached specific images to help you understand better. My intention is to have the prices of the product table retrieved from the raw material table. If the prices in the raw material table change, the prices in the product table will change accordingly. I hope you can provide detailed guidance for me. Thank you very much. ![Glide Help](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bba2e9333fca154e137778568821dcc31b69059d.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:** [February 27, 2024, 10:29am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/4 "2024-02-27T10:29:33Z")
How do you know which material goes with which product? ---
**Author:** ![Kartik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kartik/32/37220_2.png) [@Kartik](https://community.glideapps.com/u/Kartik)\ **Post date:** [February 27, 2024, 10:30am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/5 "2024-02-27T10:30:50Z")
Thanks for sample data providing in tabular format. - What is the logic of Price 1 and Price 2 ? - How it can be derived ? - Is there any common field between these two tables ? ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 27, 2024, 10:44am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/6 "2024-02-27T10:44:39Z")
Okay! It is very simple: 1.Add Row ID column to Raw materiall table it is native basic Glide column. 2. Add RawMaterial1ID column to product table 3. Add single relation from RawMaterial1ID(in product table) column to Row ID column in raw material table 4. Add lookup column throw single relation of point 3. and retrive price1(price\_per\_gram) 5. Repeate 2, 3, 4 for price2 6. Add math column to product table with your formula ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 27, 2024, 10:59am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/7 "2024-02-27T10:59:02Z")
I’m quite confused about this issue. Could you provide me with the two tables as images after you’ve done the steps above? Thank you very much. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 27, 2024, 11:42am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/8 "2024-02-27T11:42:22Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7eb8e92959b0b55b09115417acf5a52c873ab570.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e8cf8eba2427dff4b023ba0aa0c010b161dce8c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/da9f495e9228495e8e6fb4891de9849c22f8fd6f.png) ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 27, 2024, 1:28pm UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/9 "2024-02-27T13:28:23Z")
Oh, you’re absolutely amazing. I just looked at the images and saw that you did and explained everything in such detail, very intuitively. Once again, thank you so much. I’ll give it a try and get back to you later with feedback. ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 27, 2024, 1:58pm UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/10 "2024-02-27T13:58:57Z")
Could you clarify what you mean by “2 points (in red color)”? ![image 4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f17d8291b8d219d899c2563369c9b519a758acfc.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 27, 2024, 2:02pm UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/11 "2024-02-27T14:02:56Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a96577b10f17906250049e071329a60698da9de.png) ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 28, 2024, 12:41am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/12 "2024-02-28T00:41:19Z")
That’s fantastic, I followed your instructions and it worked perfectly. It’s exactly what I needed. This issue has been troubling me for days. You’ve helped me understand Relation and Lookup much better. Thank you so much. I hope to learn more from you in the future. ![Final](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abbe0a829c7ea1279fa32a1935de50037fe6188e.jpeg) ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 28, 2024, 1:02am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/13 "2024-02-28T01:02:31Z")
From your guidance, I see the key point of the issue is to create a Relation for each price column and then Lookup the price based on that Relation. All through the Row ID. When I change the price of raw materials, even the name of the raw material, everything will change accordingly in the Product table. Perfect. ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 28, 2024, 1:35am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/14 "2024-02-28T01:35:56Z")
Oh, I’ve had a long-standing issue in Glide. Is there a way to retrieve only the integer in Glide? For example, I have a column with the result being 2.35. I want to create a column next to it that only takes the number 2. Thank you. ---
**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:** [February 28, 2024, 2:31am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/15 "2024-02-28T02:31:24Z")
You can use a math column with a formula like this to round to a whole number. ```auto Round(X) ``` Just set the replacement for X with the column that contains your price. ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 28, 2024, 2:56am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/16 "2024-02-28T02:56:48Z")
Thank you, your method rounds the number up to 3. Please see the attached image, I just want to retrieve the number 2. In summary, I just want to retrieve the number before the decimal point. ![Round](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/3420a3d720e83a094b27125e080cfa654133d463.png) ---
**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:** [February 28, 2024, 3:24am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/17 "2024-02-28T03:24:48Z")
Ah, Ok. Try this ```auto FLOOR(X) ``` ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 28, 2024, 3:33am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/18 "2024-02-28T03:33:24Z")
Exactly. Thank you very much. Previously, I had to use INT() directly in Google Sheets, but it computed and responded very slowly. ![Floor](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b79cf4d907883f18c4893a9f36978b0546526de.png) ---
**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:** [February 29, 2024, 12:03am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/19 "2024-02-29T00:03:15Z")
> [@Sinh\_Vu\_Hoang](#): > > it computed and responded very slowly. Yeah, you should move as much computation to computed columns as possible. > [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788): > > wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE) ---
**Author:** ![Sinh\_Vu\_Hoang](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sinh_vu_hoang/32/71533_2.png) [@Sinh\_Vu\_Hoang](https://community.glideapps.com/u/Sinh_Vu_Hoang)\ **Post date:** [February 29, 2024, 3:30am UTC](https://community.glideapps.com/t/please-instruct-me-on-how-to-handle-the-issue-of-accessing-shared-data-from-one-table/71191/20 "2024-02-29T03:30:38Z")
When I replace it with computation on Glide, the result returns instantly.