Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago

How to find a date from the previous record of a user in the same table

I have two tables, Coach (parent) and Meetings (child). The goal is to figure out if the next meeting is scheduled within 7 days of the last meeting the coach scheduled. So I need to somehow find the...
formula queries
DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago
Thanks Mark. Let me take a stab at it this weekend and I'll connect with you on Monday!

--

Dawn Rene
QuickBase Administrator
616.808.7210


MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
The goal of the formula query will be to it extract a text list of all of the dates for that same coach and child combination where the date was before the date on the record.

I'm pretty sure they will come back in the sequence of Record ID number. So the one at the right side of the string will be the piece of text to hive off and convert to a date.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------