Feb Release Notes

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
------------------------------

Hi Don,

The use case/impetus to create the Combined Text fields was a combo of ease and performance. Having to set up reverse relationships between tables was both really confusing for new builders who needed these types of info for reporting and also in a complex app having a bunch of extraneous relationship could overtime contribute to unneeded complexity and extra processing time for extra relationships. The hope was that it would be much easier and neater for a lot of people to be able to use our existing summary field functionality instead to pull data up and then if needed use formulas and filters to help parse out what they were looking for. 


------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------