ContributionsMost RecentMost LikesSolutionsWhat causes "about:blank#blocked"?I have an formula URL button to generate an email. It was working just fine. Now when I click it, a browser page "about:blank#blocked" opens. I've tried this in Chrome, Explorer and Edge, and it keeps happening, so this is not a browser dependent problem. ------------------------------ ROBERT SACHS ------------------------------ Re: Formulas in For Email Body Failing MysteriouslyI'll send it to your gmail account. ------------------------------ ROBERT SACHS ------------------------------ Re: Formulas in For Email Body Failing MysteriouslyThanks, but that raises more questions. The button to invoke the email is standard: "mailto:"&[Submitter.Email] & "?subject="&[Email.SubjectLine: CTS_Evaluation_Completed]& ""&"&body="&[Email.Body: CTS Evaluation Completed]&"" The problematic component is body field. I understand that this button is constructing a URL, using the computed result in the body field [Email.Body:CTS Evaluation Complete] . I'm not using URLEncode in the body at all. I'm constructing a large string of defined text blocks concatenated together, using formulas to determine which blocks to select. Throughout, I use the &"%0D%0A" & "%0D%0A" & for paragraph returns, and it works just fine. The problem arises when I simply add that one extra text block MyTextB. Even if it just 14 chars of straight text, no spaces or special characters, then the entire thing fails. Indeed, I just ran another text and setting MyTextB to "AAAAAAAAAAAAA" worked, but "AAAAAAAAAAAAAx" failed. That was the only change made, adding "x", and bingo. Nothing. I do use chars including : and / in the other texts but that does not cause any problems. Still stumped... ------------------------------ ROBERT SACHS ------------------------------ Formulas in For Email Body Failing Mysteriously I use a Formula URL to generate an Outlook email. In the body portion, I define various text variables up front, and then inline those as needed. Everything was working just fine. Then I decided to add a new text variable (e.g. var text Mytext = "foo...") and include that text in the body as $Mytext &...., and now it fails. Specificaly, when I call the text then the email simply does not generate at all; in other words, clicking on the button in QB to generate the email does nothing. I know the button formula for the mailto action works, along with the subject line portion. What fails is the body portion. The text does not have any special characters. I've tried multiple approaches. First, tried reducing the length of the text, and did find that there seems to be a limit around 360 chars. Ok. So I broke up the text into 2 sentences, each much shorter than that limit. Call them MyTextA, MyTextB . I can get MyTextA to work, but when then add a line to include MyTextB, the formula fails. I note that the text vars are combinations of raw text and previously defined text vars, which in turn are based on the values in text fields in the database. Schematically this is what I'm doing: var text TextA = [field1]; var text TextB = [field2]; var text MyTextA = "foo" & $TextA & "more foo" & $TextB; var text $Letter="yaa dah yaa dah yaa had"; var text $Final="blah blah blah"; If([field3]="yes", $Letter, (If([field4]="yes", $Final & "%0D%0A" & "%0D%0A" & $MyTextA,$Final))) &"%0D%0A" & "%0D%0A" & The nested if statement works fine, and will correctly print either Letter, Final or {MyTextA and Final}, depending on the values of field3 and field4. Now if I add $MyTextB like this: If([field3]="yes", $Letter, (If([field4]="yes", $Final & "%0D%0A" & "%0D%0A" & $MyTextA & MyTextB,$Final))) &"%0D%0A" & "%0D%0A" & or even simply put in line immediately after the if statement as $MyTextB &.... then the formula button fails. Nothing, no email generated at all. Remove the addition of $MyTextB, and everything works again. Now with further testing I find this: If I set MyTextB to 13 characters like "xxxxxxxxxxxxx" then it works. But if I add a 14th character, the formula fails. And only, I have more text that follows the above text blocks what works just fine. Thanks, ------------------------------ ROBERT SACHS ------------------------------ Re: Get HTML from Web Page DOM using Data from QB fieldsYes, I'm using screen scraping. But first the data is public data and the volume is trivially low (a few calls per day). Google used to have an API for this, but discontinued it. ------------------------------ ROBERT SACHS ------------------------------ Re: Set URL Button Color based on Field ValuePaul, thanks for the response. However, perhaps my question suggested that I had a greater sophistication than in fact I do. I get the concept of what you are saying, but have no idea how to implement. Can you provide sample code? ------------------------------ ROBERT SACHS ------------------------------ Set URL Button Color based on Field ValueIs there a way to change the color of a URL button based on the value in another field? I track projects, and have a status field, say the status is either Pending or Completed. I have a button to generate an email to the client. I want the color of the button to be the default color (gray) while the status is pending, but when the status is set to Completed, the button color is updated to green (as a visual reminder to send the email). So when status is pending: and when Status is set to Complete: There is no native function to set the color of the button, but is there a way to set the color of the button on the page itself? ------------------------------ ROBERT SACHS ------------------------------ Re: Get HTML from Web Page DOM using Data from QB fieldsUnclear to me According tohttps://developers.google.com/gdata/docs/directory, there is no supported API. Similarly this says nohttps://rapidapi.com/blog/directory/google-patent-search/ But I did find this servicehttps://docs.ificlaims.com/display/CDVDP/CLAIMS+Direct+2.1 Thoughts? ------------------------------ ROBERT SACHS ------------------------------ Get HTML from Web Page DOM using Data from QB fieldsI have a database of patents. Each record includes a patent number field, a claim number field, and a claim field. I want to extract the corresponding text of the patent claim from Google Patents using the patent number and claim number. I've written code in VBA that performs this function to populate a spreadsheet (which I import and merge by record ID). I figure it would be better to directly pull the data from Google patents. I've more or less figured out the DOM for Google patents. Here is the relevant VBA code. --patno is the patent number. It's alphanumeric string CCnnnnnnn where CC is country code string "US", "EP". I use the country code extract to select how to pull the data from Google patents, since the DOMs for countries are different. --claimnumber is the number of the claim to be extracted. --claim is the text. url = "https://patents.google.com/patent/" & patno & "/en" ' Fetch page at URL With CreateObject("WINHTTP.WinHTTPRequest.5.1") .Open "GET", url, False .send patent.body.innerHTML = .responseText End With Set pElements = patent.getElementsByClassName("claim") Set pElement = pElements(claimNumber) claim = pElement.innerText Once I have claim as text, I would save it to the relevant field. For purposes of discussion assume my QB uses the same field names (patno, claimnnumber, claim). What would the equivalent javascript and QB code be for something like this? I've done lots of searching in the QB community and have found only a couple discussions of using js to pull data from other website, but nothing I felt I could generalize. Thanks Robert ------------------------------ ROBERT SACHS ------------------------------ Restore ""Previous, Return, Next"" links after Formula-URL button call?This is probably really easy, but I could not find an answer: After a button executes a formulaURL, the "Next, Return, Previous" links disappear. That means I have to go to the Home page and then find the next record and continue. How do I maintain those links on the page after the button executes?