# Getting records from one sheet to another sheet

**URL:** <https://community.glideapps.com/t/getting-records-from-one-sheet-to-another-sheet/40486>\
**Category:** Ask for Help\
**Created:** [April 7, 2022, 10:37am UTC](https://community.glideapps.com/t/getting-records-from-one-sheet-to-another-sheet/40486 "2022-04-07T10:37:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Roshan\_Abrew](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roshan_abrew/32/26773_2.png) [@Roshan\_Abrew](https://community.glideapps.com/u/Roshan_Abrew)\
**Post date:** [April 7, 2022, 10:37am UTC](https://community.glideapps.com/t/getting-records-from-one-sheet-to-another-sheet/40486/1 "2022-04-07T10:37:17Z")

</div>

Hello team,

I have a spreadsheet with two sheets as below.  
First sheet name : Bill

 ![bill records](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52f2a37af12373e15089f732433fe32c337286b2.jpeg)  
Second sheet name : Discount  
 ![discount](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e88e9d9eb1d9635d9853f56594d700d592c1b5f.jpeg)  
I have added “Row owner” both sheets in glide table.

I want to get “discount column” records from discount sheet to add bill sheet’s discount column.  
I am preparing bills based on 2022.01 see “month” column in bill sheets. therefore I need only discount records from discount sheet with 2022.01. There is one record 2022.02, I don’t need it.

Please help me on this.

Thanks,  
Roshan Abrew

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [April 7, 2022, 1:58pm UTC](https://community.glideapps.com/t/getting-records-from-one-sheet-to-another-sheet/40486/2 "2022-04-07T13:58:42Z")

</div>

It might be quicker inputting the data by hand.

But if you want to automate and pull the data, I think you could for instance:

- Bill table: Create template column, “SupplierID Month”
- Discount table: Create template column, “SupplierID Month”
- Bill table: Create single relation column between two columns above

---

<div class="post-metadata">

**Author:** ![Roshan\_Abrew](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roshan_abrew/32/26773_2.png) [@Roshan\_Abrew](https://community.glideapps.com/u/Roshan_Abrew)\
**Post date:** [April 9, 2022, 4:44am UTC](https://community.glideapps.com/t/getting-records-from-one-sheet-to-another-sheet/40486/3 "2022-04-09T04:44:22Z")

</div>

Thank you!.. I used single relation method as per your instructions, it was worked well…