Helium Scraper

Here's how I got it to work for anyone interested:

SELECT * FROM 'tablename' ORDER BY 'tablename'.'column' DESC LIMIT 1

When I try to copy a global from one project to another, it gives me an "undeclared variable" error and does not copy. How to I deal with that? Also, I am unable to select more than one piece of code at a time. Is there a way to select a section of code with more than one piece and copy it? It's ver...

I have a couple of questions about queries. 1. I want to enter data into a text field on a website. The data is stored in the database as three separate columns - Column1, Column2, and Column3. I need to add them all together into a string so that it reads (Column1 + " " + Column2 + " " Column3) and...

Is there a way to copy a global from one project to another? Also, is there a way to copy sections of code to move them up and down or into another global within a project. Often times even copying a single line will result in an error saying that it can't be copied.

Works great now. Thanks

That works to download the PDF. Thank you. Now I am trying to use Browser.DownloadAs to create a unique name for the file and add the extension. I do an extract on the case number with Output Result to get a variable called caseNum which has the case number as a string. I would like to name the PDF ...

How would I write to a Global to use it as a variable? I am scraping from multiple tabs and would like all the data to go into one table rather than a table for each tab as is automatically created. Only way I can see doing this is writing the scraped data to a variable and then writing all of the v...

I am not able to download the PDF or find the link to the actual PDF where I can download it. Could you please look at the page and see if there is anything that can be done to download the PDF? Here is a sample case number and how to get to the PDF. 1. Navigate to https://myeclerk.myorangeclerk.com...

Wondering how to download a PDF file when there is no direct link. I can view the PDF and there is a download link at the top of the page, but I cannot create a Selector for the download button. When I click on it, there is nothing selected. I have included a screenshot of what I am talking about an...

How do I access global variables? They seem to get set automatically and then I cannot delete the code because I cannot delete the variable. I'd also like to be able to access and create them so I can use JavaScript like in Helium 2. There seems to be a lot of functionality that was in Helium 2 that...