Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Eliminating Duplicates with a Formula Query

I have been able to participate in the Beta for Formula Queries.  Best I can figure not all of the features that were shown at EMPOWER are live in Beta, but these three functions are, which were provi...
Formulas and functions
DonLarson's avatar
DonLarson
Qrew Elite
4 years ago
Mark,

I got into the Beta and spent three hours trying to do a cross table query.  Only when I revisited your post did I see that it was not permitted.

Is there a list somewhere else of all the Beta limits?  Foolishly trying to do prohibited tasks is not very wise.

------------------------------
Don Larson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
What I posted is the complete documentation.  However, I hear they plan to go to an Open Beta in the September release.  That has way more features than the current Beta, but I don't think it supports Cross App queries.  We will have to wait and see if they are confident enough in the performance to let it out into the Wild.

I did have an experience in looking for duplicates in a 300,000 record set and it locked up the app.




------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • MikeGerrity1's avatar
    MikeGerrity1
    Qrew Member
    4 years ago
    Mark - thanks for this awesome post - exactly the info I was looking for.

    One question though: what is the field type for your formula field: GetCellValues(GetRecords("{73.EX." & [NPI] & "}"),3) 

    I have an App that is Beta Approved, and I was expecting to see a new field type that would be "Formula Query" or something like that, but I am only seeing the standard options.  Thanks for any guidance!

    ------------------------------
    Mike Gerrity
    ------------------------------
    • MikeGerrity1's avatar
      MikeGerrity1
      Qrew Member
      4 years ago


      ------------------------------
      Mike Gerrity
      ------------------------------
      • AustinK's avatar
        AustinK
        Qrew Commander
        4 years ago
        Mike, are you a part of the beta for formula queries? If not, try and get access to that. Check the most recent QB release notes for how to do it.