Expand all | Collapse all

Feb Release Notes

  • 1.  Feb Release Notes

    Posted 02-02-2020 12:44
    The February Release notes just hit.


    The 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 Larson
    Westlake OH

  • 2.  RE: Feb Release Notes

    Posted 02-02-2020 13:42
    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

  • 3.  RE: Feb Release Notes

    Posted 02-03-2020 10:34
    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