Trying to run a most recent note field
Hey Everyone, So I'm working on creating a interesting embedded report on a form I'm creating for a marketing firm. At the company we are working on list of prospects for clients, and I want to includ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
On the relationship summarize the Maximum Record ID and call it [Record ID# of Most Recent Note]. Look that up back down to the notes child table.
Then new Combined Text Summary field of the Note body field subject to the filter that
[Record ID#] equals [Record ID# of Most Recent Note]
Then make a formula text field on the Parent
ToText([My combined text summary field]) so it won't look like a "pill" format.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
On the relationship summarize the Maximum Record ID and call it [Record ID# of Most Recent Note]. Look that up back down to the notes child table.
Then new Combined Text Summary field of the Note body field subject to the filter that
[Record ID#] equals [Record ID# of Most Recent Note]
Then make a formula text field on the Parent
ToText([My combined text summary field]) so it won't look like a "pill" format.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------