Perform logic on related data (last order)

Im trying to grab the date of the last order in the person table. Actually its volunteers who signed up for shifts. I want to know the last date they signed up for a shift, and perform some actions if they havent signed up for a shift in a few weeks.

Also, Im not using unique users, there is no login, but this application is being used privately by a small group of volunteers. Login credentials are too difficult for this group.

Nevermind. I figured out a rollup can do this. :smiley:

A single value > last value in a relation would also do the trick if you’re catching the timestamp of the submission.

1 Like

I also use this one too :point_up:t3:

1 Like