ContributionsMost RecentMost LikesSolutionsRe: Formula Query to search for matching records with the exception of a specific field not matchingThank you, I had mis-type in my example, it was supposed to be XEX. It worked to that [field 7] not matching when the rest do match. I was thinking the XEX was an exclusion operation to exclude the display of that field for the listed matching fields, which why I needed it for the [Record ID#]. But thinking about it, that is what the 3 at the end of the formula is for to display that data in Field ID 3. ------------------------------ Jovan Vucovich ------------------------------ Formula Query to search for matching records with the exception of a specific field not matchingI currently am using a Formula Query to identify when specific fields match it returns the Record ID# that has the matching data. This is to help identify duplicate record entries for things that can not be unique fields. It works just fine. I am now trying to figure out a Formula Query to look for records that should share the same data in 3 specific fields but doesn't. The logic would be When [Field 5] equals [Field 6] but not equal to [Field 7] return [Record ID#] What needs to go in the butnot location for my logic to work for this Formula Query? GetFieldValues(GetRecords("{5.EX. ' "&[Field 5] &" '} AND {6.EX. ' "&[Field 6] &" '} butnot {7.EX. ' "&[Field 7] &" '} AND {3.EXE. ' "&[Record ID#] &" '}" ),3) ------------------------------ Jovan Vucovich ------------------------------ Re: URL Formula Button that will check multiple check boxes and return to selected record in a new tabI ended up getting it to work in a similar way shortly after making this post.. One of those, it comes to you after you ask for help kind of situations. I combined the Field ID request before the "rdr=" instead of: ... & "&_fid_15=1" & "&_fid_140=1" & "&rdr=" ... I wrote it as: ... & "&_fid_15=1&_fid_140=1&rdr=" ... Thank you very much for your response. Makes me feel better to see that I figured it out to the same concept that you replied with. ------------------------------ Jovan Vucovich ------------------------------ URL Formula Button that will check multiple check boxes and return to selected record in a new tabI currently have a button that I will successfully open a new tab of that record and have a single desired field checked. But, I am wanting for this button to perform this same new tab action of the selected record except check 2 different checkbox fields (Field ID 15 and Field ID 140). I am able to get this formula to work with checking both boxes, but it does not successfully load the new tab. It will give me a page showing XML file not having any style information. The document tree is shows for the error: <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>3436</rid> <num_fields_changed>2</num_fields_changed> <update_id>1645813465811</update_id> </qdbapi> The formula I am attempting to use: "<a class='Vibrant Success' style=\"width:200px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=dk26yixbnr8hncc57zxdnchx2mgc &_fid_15=1&rdr=" & "&apptoken=dk26yixbnr8hncc57zxdnchx2mgc &_fid_140=1&rdr="& URLEncode(URLRoot() & "db/bq7w9bprg" & "?a=dr&rid=" & [Record ID#])& "'target=_blank'" & "'>Re-Work Accepted</a>" To clarify, This will provide the desired checkboxes to be check in that record, but not load the selected record in a new tab. ------------------------------ Jovan Vucovich ------------------------------