Query if possible to check latest condition for all rows on a table

Ask for Help
1

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.

1 Like
2

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?

1 Like
3

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?

1 Like
4

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.

1 Like
5

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.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.