# Query if possible to check latest condition for all rows on a table **URL:** \ **Category:** Ask for Help\ **Created:** [July 16, 2025, 7:03am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210 "2025-07-16T07:03:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 16, 2025, 7:03am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/1 "2025-07-16T07:03:22Z")
So before I go down the rabbit hole and see if I can make this happen, I thought I would first ask if it is even possible on the Free Glide version. I’m not sure how to explain so I hope this is clear. What I want to do is on a button click, look at all the rows on a table do the following: For each animal (because each animal could have multiple rows), look where Column X is “Worming” (and there could be multiple rows of this as worming is done monthly), and get the most recent date. If that date is 30 days or greater OLDER than today (so more than a month old) then send an email to the email in Column Z. Is that possible in the Free version of Glide or only in a paid version? And, if possible in the Free version, what would be the best approach to do this so I can possibly give it a whirl if it is in my scope. ---
**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:** [July 16, 2025, 7:14am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/2 "2025-07-16T07:14:39Z")
To do that, you would either need API access, or access to workflows with looping (eg. webhook/manual trigger). And I don’t think either is available on the free plan? ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 16, 2025, 7:27am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/3 "2025-07-16T07:27:06Z")
Ok well I was thinking manual trigger as it would only happen with push of button. Or is that not the manual trigger you mean? ---
**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:** [July 16, 2025, 7:38am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/4 "2025-07-16T07:38:23Z")
No, that’s different. A workflow that’s initiated by a user clicking a button is called an App Interaction workflow, and I believe thats the only type of workflow you get access to on a free plan. A manual triggered workflow is a different beast. ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 16, 2025, 7:49am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/5 "2025-07-16T07:49:43Z")
Ok. So the bottom line is don’t bother going down that rabbit hole while still on the free plan as no way to do it. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 23, 2025, 7:50am UTC](https://community.glideapps.com/t/query-if-possible-to-check-latest-condition-for-all-rows-on-a-table/83210/6 "2025-07-23T07:50:23Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.