Pulling in the most recent data from another table to a status field.

I have some questions about pulling in the most recent data from another table to a status field. Here is the loom video ------------------------------ Jennifer Meyer --------------------------...

MarkShnier__You

Qrew Legend

I suggest not using a Formula Query.
One Job has many Status updates.

Create a Summary field on that relationship for the Maximum Record ID# and call it [Record ID# of Most Recent Status Update].
Look up down to status updates.
Create a Combined text summary field of the Status field on the updates table subject to the filter that the [Record ID#] equals the [Record ID# of Most Recent Status Update].
That will give you the most recent status up on he job record. If you don't like the bubble appearance, then make a formula text field with the formula ToText([My combined text summary status field])

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

JenniferMeyer

Qrew Member

3 years ago

It worked!!!! THANK YOU!!!!!

------------------------------
Jennifer Meyer
------------------------------

Forum Discussion

Pulling in the most recent data from another table to a status field.