Forum Discussion

RichardChagnon's avatar
RichardChagnon
Qrew Trainee
2 years ago

Issue witth Combine text two levels up

Hi I have 3 tables Office < Activities < Barriers encountered  When our staff evaluated an office they log an activity and (among other things) check off any barriers that office has to the proje...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

It should work. On the relationship between offices and activities we should be able to summarize the combined text summary field that you first summarized up from barriers up to activities. Is that what you're doing?



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • RichardChagnon's avatar
    RichardChagnon
    Qrew Trainee
    2 years ago

    Thanks for the  quick response gents.

    Since I'm on a deadline I just created a new relationship Office < Barriers. Which works for now.  I'll update this thread when I have the time after the deadline



    ------------------------------
    Richard Chagnon
    Northwestern University
    Chicago IL
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago

      The direct relationship will not work unless you have a way to auto populate the related office field in Barriers.  The best practice is to roll up twice, in steps.



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