Feb Release Notes

Question

The February Release notes just hit.https://help.quickbase.com/release-notes/february-2020-release-notes.htmlThe one enhancement is the Combined Text Summary Field has had its limit increased.  Does anybody have a great business case for this as opposed to doing a reverse look up on the Max or Min RID field between two related tables?I suspect I am missing something here.------------------------------Don LarsonPaasporterWestlake OH------------------------------

MarkShnierYou · Answer

When the feature came out I was told the limit was 25. So it must have increased to 50 and now to 150. That is great. I used to be the Reverse Relationship king and after that feature came out I hardly do them any more. Even if I just have 1 record to float up (ie the most recent child, for example), I use this feature.

A typical use case is to float say all Project Team member names to the Project record, for example to use on reports.

Or another use case would be to float up all the email address for the Project Team members to the Parent Project in order to create an email Notification to all Team Members when something changes on the Project.

(to do that you would make a text formula field like
ToText([Team member email])

Then use a formula like this to parse out the Team member #1 email.

Trim(Part(ToText([combined text email summary]),1, ";")))
and then for Team Member #2
Trim(Part(ToText([combined text email summary]),2, ";")))

Then in the email box for who the Notification goes to, you just enter the field names

[Team Member 1 email]
[Team Member 2 email]
[Team Member 3 email]
[Team Member 4 email]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community