Pulling field from one table to another
I've been trying to for days to figure this out on my own and I can't. I'm newish to writing formulas, and I'm not even sure if what I'm trying to do is best or even right.
I have Table A, Employee...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendLet start with the basics. Did you try a summary field in the relationship to detect if any children meet the criteria? The vanilla way of getting Child information up to the Parent is by going to the Relationship and creating a summary field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark, thank you for the reply. I'm unsure what you mean by adding the Summary field. I can't add a summary field that will pull the date. If I try, I get an error that says the summary field can't be applied to the date field. I already have a summary field that adds whether the employee has a record for the meeting. That's how I filter out the reports of who still needs to have one scheduled.
------------------------------
Hannah Engelson
------------------------------
- MarkShnier__You
You can do a summary on a date field or a date/time field type if you select "Maximum" or Minimum depending on what you want. You can also add filters to that summary field when configuring it.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------The maximum worked!! Thank you so much!
As an aside, what would be the difference between maximum and minimum in regards to date?
------------------------------
Hannah Engelson
------------------------------Think of Maximum as 'the most recent, or newest, date' and minimum as 'the oldest date'.
------------------------------
Mike Tamoush
------------------------------