# 🤔 How to: Connect Month to Amount w/ ability to search data points (w/ video)

**URL:** <https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409>\
**Category:** Ask for Help\
**Created:** [October 31, 2023, 12:52am UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409 "2023-10-31T00:52:27Z")\
**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:** [October 31, 2023, 12:52am UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409/1 "2023-10-31T00:52:27Z")

</div>

> **[UX/Data Structure for Challenge](https://app.screencast.com/6xTiG9624Y41c)**
>
> Questions:

Hello!

Two part question:

1. UX Design: What is the most efficient way to connect the data in a good flow? Specifically when they only need to enter certain things every 20 days?

2. How do I connect the data in the sheet in order to search it? i.e. Monthly total, year to date total, etc.

Thanks

---

<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:** [November 30, 2023, 8:19pm UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409/2 "2023-11-30T20:19:07Z")

</div>

@Robert_Petitto @ThinhDinh Any ideas or suggestions for this? Thank youhttps://app.screencast.com/6HXiwT8738k4u

---

<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 30, 2023, 11:07pm UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409/3 "2023-11-30T23:07:23Z")

</div>

It’s asking me to sign up to view the video. Is there a public way to share your video?

---

<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:** [December 1, 2023, 2:04am UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409/4 "2023-12-01T02:04:34Z")

</div>

My apologies @ThinhDinh . Here is an updated link. [Date Stamp configuration - TechSmith Screencast - TechSmith Screencast](https://app.screencast.com/6HXiwT8738k4u)

---

<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:** [December 1, 2023, 12:55pm UTC](https://community.glideapps.com/t/how-to-connect-month-to-amount-w-ability-to-search-data-points-w-video/67409/5 "2023-12-01T12:55:55Z")

</div>

If I understand you right, you want to have an entry date be filled every time a user submits the form? That can be done like this.

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

> [@JamieErvin](#):
>
> How do I connect the data in the sheet in order to search it? i.e. Monthly total, year to date total, etc.

Without knowing more about your data strucutre, you would have to create a series of queries and rollups to achieve that.