JamieStrauss
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Duplicate Values Between Two Tables
Sadly, with this: If( Size( GetRecords( "{8.EX.[CAP_TIN] }", [_DBID_ASC_PREFERRED_PROVIDERS] ) ) > 0, "Yes", "No") -using a formula check box field, the syntax error I get is the table name is not a recognized field. This can't be that difficult, am I making it too difficult? Or do I just sadly, have to manipulate my excel file before I upload?18Views0likes4CommentsRe: Duplicate Values Between Two Tables
Thank you! You have the intent perfect! I can't use a key on the PROV_ID field on the Provider table because there are duplicates as they participate in different plans. So I tried your second formula and recieved a syntax error on the first quotation If(Size( GetRecords( “{ 8 .EX.[CAP_TIN] }”, [_DBID_ASC_PREFERRED_PROVIDERS] ) ) > 0, "Yes,"No") I rechecked your formula and moved the quotations to ({"8".EX. -this returned a syntax error on the first . I think I'm just getting old. Ha! Help24Views0likes1CommentRe: Identifying identical values between two table
Thank you and I am so sorry! Response notifications were filtered out and I JUST saw this. I can't set the TIN in the Preferred Provider Table as key because there are some duplicates as some are in different plans. So I tried the second option formula. I get no errors (FINALLY) but, all are returning blanks. How do I get Table 2 (All) to read Table 1 (Preferred), identify a match which will then check the Preferred box on Table 2?6Views0likes0CommentsDuplicate Values Between Two Tables
Hi Everyone, I will preface this with formulas are new to me. I have two tables Table 1 (Preferred Provider): This is the master table of only the preferred providers identified by Provider ID Table 2 (Member Assignments by Provider): This table is the universe of all member assignments-both preferred and non preferred. Providers are identified by Provider ID What formula (and formula field) do I use in Table 2 that will look for a Provider ID match in Table 1 that will populate the new field in Table 2 as yes or no? This app won't have user entries so I don't think I need a relationship. I just need to be able to match the preffered providers assigned in Table 2 to the master preferred provider list in Table 1. I tried something super simple which, as you likely know, didn't work. IF(Size(GetFieldValues(GetRecords("_DBID_ASC_PREFERRED_PROVIDERS.PROV_ID = _DBID_MEMBER_ASSIGNMENTS_BY_PROVIDER.PROV_ID")) 0,"Yes","No")49Views0likes10CommentsIdentifying identical values between two table
Hi Everyone, It's been a while since using QB and my brain appears to have lost QB memory! I have two tables: Preferred Providers eligible for auto-assignment All Providers that have been auto-assigned (regardless of preferred designation) I am looking for a formula that will look for a TIN match between both tables and pull into table 2 under new field "Preferred Provider" Ultimately, I need to identify the auto assigned preferred providers without scrubbing a list of thousands of TINs. Any help is greatly appreciated!62Views0likes3CommentsRe: Formula modifying an existing set up numbers
THANK YOU! It's ALMOST working! But right at the end, $FirstFour & $LastFive is highlighted saying a number was expected but found text. Maybe I need to change the field type? I have formula numeric ------------------------------ Jamie Strauss ------------------------------8Views0likes4Comments