I am automating data entry from Google Sheets into an online html form. Every row has multiple columns of data that belong in various fields in the form (Ex. Row 1 has columns for Date, Case ID, Diagnosis, Billing Code). My Google Sheet is already connected. I am using Web Record to select the fields in the online form, one field at a time and selecting “Type in data”, which should be pulling from the Google Sheet.
I cannot figure out:
how to actually make it pull the data from the Google Sheet ("Input data into ‘Case ID*’ field). When I select “Read Data From Google Sheets” and select for example “Rows”, it just inputs {x}dt_data.Rows. Have no idea what to do with this, and it obviously doesnt work as is
how to make the process repeat the same thing, and enter the next row of data into that same form (once each cycle completes, the form is submitted, and is automatically blank again and ready to receive the next row of data from Google Sheets)
Wasted many hours on this. Would hugely appreciate your help.
You can directly use For Each row in Spreadsheet and inside that use Type Into activity and open expression editor you can type CurrentRow("yourcolumnname").ToString.
The output of it is already indt_data ..so scroll down expand dt_data you would see rows..which on expanding you can select the column you want..as its a datatable for eqch row would be added automatically once you select a row component
Thank you and Im sorry I am so inept at this. I tried that but it doesnt seem to fix the error. Here is a screenshot. Am I even setting it up correctly to keep on repeating the process so that each Row gets its own Online Form submitted, and then the process repeats for the next blank Form?
Thank you, unfortunately still having trouble figuring it out. I see the Column ID in the Read From Google Sheets dropdown, but it doesnt actually resolve the error. See screenshot:
I got it to read the Data Table and pull the 1st Column data, but current problem is it is just iteratively rewriting Field1 text with each row’s data into the 1st online form field, without ever moving on the the 2nd field in the form. Screenshot below
What it should be doing is:
entering Row1-Column1 data into Field1 in the online form, then moving on to Row1Column2 data into Field2 in the online, then once all fields are entered
submitting the form and restarting the process for the next form from Row2Column1
if the scenario is that you have a form and you need to fill first row and then submit and then the form reloads and you need to submit the second row then the way I have shown you would work
changinf for eahc to for each row in datatable is easier to use
I am trying all different way but cannot get the process to do this:
1st form, fill all the fields with data from Row1 Columns1-5
2nd form, fill all the fields with data from Row 2 Columns 1-5
3rd form, fill all the fields with data from Row 3 Columns 1-5… etc
The other issue is one of the fields is a drop down, so I need it match a Column text
Currently, my process either rewrites Field 1 with all the 700 Rows of Column 1 data over and over into Field 1
OR
It just types in the Columns header name “Lesion ID” into the field.
Very frustrating, but I really need to get this to work
It’s also unclear to me how the activity knows which row to read for the current form submission. After it submits, how does the activity know to use the Next row data. It also has no idea which row number to start with, since there is no Row starting points
For each row will loop through every row..so all activities inside that will be executed repeated for each row starting from first to last..I would say first do some basica to understand how they work
Or just use a log message and see the values then you might get an understanding..what you are doing is a straight forward process and lst step after type into in the for loop should be submit to sumbit and open new form..
Then for fropdown there is a different activity select dropdown where you can pass the value again..
Without understanding the platform you are using if you straight away implement you would see such issues of not knowing what is hppening
How it goes to next is what for each row does automatically..thats the use of a for each
Thank you. I redid it all just like you said. Now there are 2 new errors:
“Variable ‘CurrentRow’ is missing. Please use Data Manager to recreate it.
Compiler error(s) encountered processing expression “CurrentRow(LocationColumn).ToString”.(2) : error BC30451: ‘CurrentRow’ is not declared. It may be inaccessible due to its protection level. (2) : error BC30451: ‘LocationColumn’ is not declared. It may be inaccessible due to its protection level.”
The activity Select Item ‘Location’ isn’t mapping to any selections. I need to match the location listed in the “Location” Column. It just keeps says “No results found, try a different search term”
The name that you pass should exactly match else select item cannot work.to verify before passing in select item it would give a dropdown of items check how the item names look and pass accordingly
