Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

Any trick to getting a concatenated text list with more than 150 items?

Essentially, I am trying to get a combined text list with more than 150 items (closer to 1500). As this cannot be done with a combined text field, are there other work arounds? My use case: Cost...
Tables and fields
DonLarson's avatar
DonLarson
Qrew Elite
4 years ago
Is there a Pipeline call that will iterate through the table and then write a single field in the parent?   Not very hard in PHP but I am not aware of the corresponding logic in Pipelines.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
I bet there is Jinja syntax to take the result of a Pipeline Search and concatenate it together.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    But a far better solution will be a Formula Query. The only trouble is you probably have to wait a month or two to get early access to that feature.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      4 years ago
      Mark,

      Do you have any links that talk about the upcoming formula queries? Was it an empower session?

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        There was an EMPOWER session.

        Formula Queries is bigger than huge.  For those of us who have been building for a long time and even in the relatively short but intense time that you have been building, we have been programmed that the only way to get summary fields  and lookup fields is with a Relationship.

        With formula queries you don't need to even have any relationships. It is conceptually possible to build probably any of your apps with no relationships at all. So that is completely different thinking that we will have to get used to.

        If you go back to the EMPOWER site and look for the red box for Full Agenda with links and then get to page 2 of the sessions, there is a link to launch the session on Formula Queries: Redefining what's possible with Quickbase.

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