# Create Screen From Table

**URL:** <https://community.glideapps.com/t/create-screen-from-table/67846>\
**Category:** Ask for Help\
**Created:** [November 16, 2023, 1:19am UTC](https://community.glideapps.com/t/create-screen-from-table/67846 "2023-11-16T01:19:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![restudewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/restudewa/32/66428_2.png) [@restudewa](https://community.glideapps.com/u/restudewa)\
**Post date:** [November 16, 2023, 1:19am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/1 "2023-11-16T01:19:41Z")

</div>

Hi…

I have a Table that looks like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2ea931209ab007dfdb681fec232279176e240538.png)

From that Table, I want to create a screen that looks like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6f34643ba901521ee2918a8749c9d63bab627bc.png)

How can I do it?

Thanks!

---

<div class="post-metadata">

**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:** [November 16, 2023, 4:39am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/2 "2023-11-16T04:39:26Z")

</div>

How did you create the columns in the first table?

They look like they’ve been derived from something very similar to that shown in your second screenshot.

---

<div class="post-metadata">

**Author:** ![restudewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/restudewa/32/66428_2.png) [@restudewa](https://community.glideapps.com/u/restudewa)\
**Post date:** [November 16, 2023, 5:24am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/3 "2023-11-16T05:24:24Z")

</div>

The Table on the first screenshot comes from this Purchase Table:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e6571afeaf2e4da211ea0850a3c1ab61eadc618.jpeg)

And this is the Payment Table:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8fc632bc3ed6e06c0bccfe2ca83958ea760ce6ae.jpeg)

I made 2 Tables, a Purchase Table and a Payment Table, and then made a relation between those tables.

I want to make a screen that shows a recap and details (such as date of purchase, purchase value, and total spent) of every row in the Payment Table without showing the details of the product name from the Purchase Table.

Did I do wrong way?

---

<div class="post-metadata">

**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:** [November 16, 2023, 5:35am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/4 "2023-11-16T05:35:18Z")

</div>

I don’t think you need the Payment table.  
If I’m understanding correctly, all you need to do is add a Collection component to your screen and set the source of it to be your Purchase table, then configure it to display just the items you want. If you need more than 3 items displayed, then a Data Grid collection might be the best choice.

---

<div class="post-metadata">

**Author:** ![restudewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/restudewa/32/66428_2.png) [@restudewa](https://community.glideapps.com/u/restudewa)\
**Post date:** [November 16, 2023, 6:08am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/5 "2023-11-16T06:08:33Z")

</div>

I forgot to mention that the Payment Table also has a relation with the Cost Table that looks like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/edafa340dc37407aebbc69d4c2a216e340defa68.jpeg)

I need to show every payment details that occur from the Purchase Table, the Cost Table, and any other Table that might be created later.

---

<div class="post-metadata">

**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:** [November 16, 2023, 11:15pm UTC](https://community.glideapps.com/t/create-screen-from-table/67846/6 "2023-11-16T23:15:13Z")

</div>

So you can just keep the tables as it is, and create relations to Purchase Table and Cost Table.

Then add collections in the details view of the Payment Table to display purchase and cost recoerds.

Is that correct?

---

<div class="post-metadata">

**Author:** ![restudewa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/restudewa/32/66428_2.png) [@restudewa](https://community.glideapps.com/u/restudewa)\
**Post date:** [November 18, 2023, 1:31am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/7 "2023-11-18T01:31:04Z")

</div>

Yes, that’s correct.

I make an array column in Payment Table that combine dates from Puchase and Cost Table

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1ec3c967dc5f72b26e3f8627f660254e30747bd9.png)

But it seems that I cannot use array column as a source in the Collections.

---

<div class="post-metadata">

**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:** [November 18, 2023, 1:41am UTC](https://community.glideapps.com/t/create-screen-from-table/67846/8 "2023-11-18T01:41:41Z")

</div>

Why do you need the lookups though? You can just cite the relations if I understand you right.
