Hi, I’m a new user who just completed the Citizen Developer Foundation Course and am trying my hand at automating some tasks. I’m a reporter investigating a list of “high utilizers” responsible for a disproportionate number of cases in the Seattle Municipal Court. I have the list and am working on automating the retrieval of documents from each case from the Municipal Court Portal.
The first thing I did was retrieve all the case numbers and URLs of each case on the SMC portal. in a Google Spreadsheet and copied them to separate Sheets.
I’ve tried a few things, such as removing the hyperlinks, using an expression instead of a variable, but nothing has worked. What am I doing wrong here?
It should direct it to read the cell in the current row of the column “Case Number URL,” which is then iterated for each row (B2, B3, B4, etc.) Is that not correct? I’m trying to get it to store the value in that row and use it for the “Use Browser/Application” URL.
‘Read cell’ doesn’t work like this. In a cell you can specify cell which you’d like to read, for example ‘C4’. In your case, you already have all the data you need because of ‘Read Range’ activity. In 'For Each Row In A Datatable" you should be able to get this url using CurrentRow(“Case Number URL”).toString. I am not sure if this looks 100% the same, as I use Studio, not StudioX. Let me know if it helps.
Thank you! That worked. I feel kinda dumb that I added an extra step unnecessarily. That was supposed to be the easy part. Now I have to work on some more difficult tasks, so I’ll probably be back soon, asking more questions.
