# Fetching data from a previous row using date **URL:** \ **Category:** Ask for Help\ **Created:** [January 9, 2025, 2:22am UTC](https://community.glideapps.com/t/fetching-data-from-a-previous-row-using-date/79073 "2025-01-09T02:22:00Z")\ **Posts on this page:** 1\ **Showing post:** 3
**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:** [January 9, 2025, 3:06am UTC](https://community.glideapps.com/t/fetching-data-from-a-previous-row-using-date/79073/3 "2025-01-09T03:06:21Z")
You would use a variation of this. > [@Diffferent formula from Row 2 onwards](https://community.glideapps.com/t/diffferent-formula-from-row-2-onwards/75370/2): > > Make sure you record the user’s ID/email. Use a query column, filter by user’s ID/email equals to this row \> user’s ID/email. Add a rowID column to your table. Add a lookup column on top of the query resulr, pointing to that rowID column, so you get an array of IDs for the same user. Add a find element index column, use the lookup result as the base, and look for the current row’s rowID. You will get a 0-based list of index for each user. Add a math column, with the formula being: I-1, with I b… --- _[View the full topic](https://community.glideapps.com/t/fetching-data-from-a-previous-row-using-date/79073)._