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
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
      ------------------------------