# 🤔 How to: "Connect" two entries and display the result (w/ video)

**URL:** <https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394>\
**Category:** Ask for Help\
**Created:** [February 2, 2024, 3:21am UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394 "2024-02-02T03:21:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\
**Post date:** [February 2, 2024, 3:21am UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394/1 "2024-02-02T03:21:53Z")

</div>

> **[Connect 2 transactions\_2024-02-01\_21-58-39.mp4](https://app.screencast.com/FQo8kSWQZVzCY)**
>
> World's leading screen capture + recorder from Snagit + Screencast by Techsmith. Capture, edit and share professional-quality content seamlessly.

Hello!

In this app, some of the transactions need to be able to share collateral. i.e.; A collateral of $500 can be used by up to 2 transactions maximum as long as the transactions are in progress.

I am looking for ways to “connect” the transactions meaning a way to know which two transactions are sharing the collateral at the same time. Then display that information.

Any feedback is appreciated!

Jamie

---

<div class="post-metadata">

**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 2, 2024, 3:41am UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394/2 "2024-02-02T03:41:47Z")

</div>

Couldn’t you use a Relation or Query to link the two TradeID to itself?

---

<div class="post-metadata">

**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\
**Post date:** [February 2, 2024, 4:02pm UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394/3 "2024-02-02T16:02:15Z")

</div>

I did create a relation which did work. So maybe I should ask the question differently:

How do I rework this so that I can mark which two transactions are sharing collateral and display just the ones currently sharing it.

So far each transaction will have a TradeID by default. But I would need to display only the ones currently sharing the collateral.

Does that make sense?  
 ![2024-02-02_10-56-30](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5faab2c43f720c6ee34d528894e0220aad14fd12.gif)

---

<div class="post-metadata">

**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 2, 2024, 4:22pm UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394/4 "2024-02-02T16:22:38Z")

</div>

So you mean that only the row that share a TradeID AND have the collateral checkbox checked would be shared?

If so, you could also add the collateral checkbox value to your trade id and use that for the relation…or you could use a Query column and specify that the Trade ID and Collateral must match.

But if I’m understanding the question correctly, then that still causes an issue where all rows with the collateral unchecked would still be grouped. In that case I would still go with a query column, but add a third condition that you only want those with the collateral checked.

So the query would be set up like this.

TradeID is This Row → TradeID  
AND  
Collateral is This Row → Collateral  
AND  
Collateral is checked

---

<div class="post-metadata">

**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\
**Post date:** [February 2, 2024, 5:25pm UTC](https://community.glideapps.com/t/how-to-connect-two-entries-and-display-the-result-w-video/70394/5 "2024-02-02T17:25:17Z")

</div>

> [@Jeff\_Hager](#):
>
> So you mean that only the row that share a TradeID AND have the collateral checkbox checked would be shared?

Currently, yes.

To be more precise both sides would have the same Live or sim designation, Ticker, spread amount, collateral and expiration date.

All five of those are the same in order to share the same collateral.

Thanks for your input!