Syntax in sending a Text Message
So most of our new hires are all "texters", so I am trying to get it figured out. I have looked around and have a portion of it built. BUT... What would be the texting equivalent of the email subject line and body similar to below? &"?subject=INFORMATION NEEDED TO ACTIVATE YOUR CARD" &"&body="&"Welcome Aboard "&[Associate First Name]&"!" I have not been able to find anything that will create these for me ------------------------------ Hans Hamm ------------------------------
Is there any way to trigger python script based on any event in QuickBase?
Can you please let me know if there is any way to trigger python script based on any update in QuickBase (Master/Source Data)? Either through Quickbase action/automation/pipelines. ------------------------------ Sudhir B ------------------------------
Integration of Quickbase with Quickbooks enterprise
Hi member, which are the different ways to connect my QuickBase(cloud) to QuickBooks- enterprise (cloud). Is there any software solutions currently available and if we need to hire a developer what are the technical skills that they need to possess to do this. ------------------------------ Aswin Babu ------------------------------Get HTML from Web Page DOM using Data from QB fields
I 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 ------------------------------
Searching/Filtering a Quickbase Report in WordPress
We have a database of over 1000 software products we have reviewed for our University's use. We imported this database into a WordPress page using shortcode for a report we created. However, this page just lists all 1000 products in one giant table. We would like to provide some search/filtering capabilities besides Control F or breaking it up into several reports and attaching anchors. Ideally, we would like to run searches on the Software Product, the Software Vendor and/or the Resolution (Approved, Denied or Conditional). Does anyone know of an easy way to do this in Quickbase or any WordPress plugins that would help us with this. Right now, we are manually importing the information into TablePress and then manually importing that into our WordPress site. Thanks ------------------------------ Mark Harben North Carolina State University Software Licensing Management ------------------------------
