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
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
------------------------------
  • MikeGerrity1's avatar
    MikeGerrity1
    Qrew Member
    4 years ago
    Thanks Mark - I got it to work.  Apparently the Query did not like the way my MRN was formatted - likely because of the "." character: sample MRN  "1297568.4.3"

    But when I updated to do the same query based on Patient Name it worked like a charm.




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