Forum Discussion

Qrew 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

Qrew Legend

4 years ago

There is not a new type of formula field, we use the regular kind. It should be a formula multi select field type.

https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=212&rl=iu

https://login.quickbase.com/db/6ewwzuuj?a=td and search on queries

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

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

Forum Discussion

Eliminating Duplicates with a Formula Query

Related Content

Duplicate Record Checker

Duplicating Page/Dashboard on New App

Pipelines to upsert just one of duplicate records

syntax help with formula

Formula Url Buttons