ContributionsMost RecentMost LikesSolutionsFormula Query Using Summary FieldHello! Having an issue using a summary field to rank customers based on revenue. On our Customers table, the Total $ Shipped is a summary field, and I'm wondering if it's causing the problem I'm seeing in my formula query. Here's my formula: var text formulaquery = "{236.GT.'" & [Total $ Shipped] & "'}AND{236.XEX.'0'}"; If([Total $ Shipped]=0,null,Size(GetRecords($formulaquery))+1) When I look at a report that sorts by this ranking, it has no number 1 record, and two number 2 records. The two records that are tied for number 2 do not match. They are off by almost 10,000. It then ranks 4, 5, 6, and 7 accurately (except for skipping number 3) and then has two number 8 and two number 10- which also are not equal to each other. I've read that it's best to use user input fields for formula queries because there's additional background calculations going in to summary fields, but it wasn't really made clear that it wouldn't work with summary fields. Any way to get this to work? ------------------------------ Matt Jones ------------------------------Re: Button to check a box, open a URL, and reload while in EditHi Paul, Thanks for the answer, but unfortunately I can't get that to work any better than my current formula. Since I also have to add another variable to open the print. I end up with this: var text URL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_203=1" ; var text URLTWO = [Customer Print URL (Lookup):]; var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); $URL & "&rdr=" & URLEncode($URLTWO) & URLEncode("&rdr=" & URLEncode($RefreshPage)) It will open the print and check the box, but it doesn't refresh the page, which means it has to be manually refreshed to show that the checkbox has been checked. I'm only ever able to get it to perform one redirect. It will either check the box and refresh, but not open the print, or check the box and open the print, but not refresh. ------------------------------ Matt Jones ------------------------------ Button to check a box, open a URL, and reload while in EditThis one has been giving me trouble for about a week now. What I am trying to do is create a button that will open a print (I have a field that extracts the URL of a file attachment field), check a box that says the print has been opened, and reload the page while still in edit. The desired workflow would look like this: user adds a child record and before they fill anything out, they have to open a print. When the print has been opened, it will check a box that verifies that they opened the print. Without manually refreshing the page, they should then be able to fill out the child form and save and close. After several failed attempts, here's the current code I'm working with that sort of works: If([Customer Print URL (Lookup):]="", URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_203=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]), URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_203=1" & "&rdr=" & URLEncode([Customer Print URL (Lookup):]) & URLEncode("&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))) This will open the print and check the box, but the page does not automatically reload to show the box is checked. It has to be manually refreshed. The work around that I have currently is to only show the button while in view mode. That way they can create the child record, fill out what they need to get the job started, and then save. Then they click the button to open the print, and when they edit to complete the job, the checkbox is checked. The problem with that is that they really should be looking at the print before they start the job. I am pretty sure I would have been able to get it to function before they disabled javascript, but not sure how to do it without. I'm not sure if a code page would be good for this as I haven't messed around too much with those. ------------------------------ Matt Jones ------------------------------