Re: Eliminating Duplicates with a Formula Query
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.
Forum Discussion
3 Replies
- 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
------------------------------- MarkShnier__You
Qrew Legend
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
------------------------------- 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
------------------------------
