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
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.
      • MikeGerrity1's avatar
        MikeGerrity1
        Qrew Member
        4 years ago
        Yes - I am part of the Beta and the app I am trying to use is authorized.  Should I be seeing a new type of Formula field available? Or am I just using a Formula Text or formula Rich Text field and now have new "formula functions" available?   I have tried writing Mark's formula as both a Formula Text and Formula Multi-Select Text field and neither seems to work for me.  Not sure if I need to do something further to make sure my app is fully set up for the beta?

        ------------------------------
        Mike Gerrity
        ------------------------------