I have a form I want to fill in with the following fields..
Surname: <prepopulated with my surname>
Given Name: <prepopulated with my Christian name)
Email Address:
Confirm Email Address: <will not accept pasted address><will accept drop and drag address>
Phone Number:
Street Number & Street Name:
Suburb:
City or Locality:
Postcode:
I'd like to copy the entire customer data from another form to the clipboard and paste it into this form.
I've made a simple script as follows...
Smith{Tab}
John{Tab}
[email protected]{Tab}
{Tab}
(+61) 0424444444{Tab}
10 Black Street{Tab}
Queanbeyan{Tab}
NSW{Tab}
2463{Tab}
When a execute the shortcut key <send> it copies all the data to the correct fields but a second later every bit of data disappears except the contents of the first line.
What am I doing wrong?
Form Script question
You should remove new lines and enclose "+" in braces, like {+}.
Try this:
Try this:
Code: Select all
Smith{Tab}John{Tab}[email protected]{Tab}{Tab}({+}61) 0424444444{Tab}10 Black Street{Tab}Queanbeyan{Tab}NSW{Tab}2463{Tab}
Thanks for your reply. Perhaps I did not explain the requirement properly. My apologies.
I want to be able to extract a row of custom data with say 10 values from a csv or Google Sheets file (manually by <Ctl> C to clipboard or automatically by script) and then insert 5 values one by one into a government website form and a further 5 values into a second form and then submit the completed form. The site is accessed with a username and password.
My guess is I can record a macro of the insertion (pasting) process. But how do I process the copied csv data and incorporate it into the macro.
Any ideas?
I want to be able to extract a row of custom data with say 10 values from a csv or Google Sheets file (manually by <Ctl> C to clipboard or automatically by script) and then insert 5 values one by one into a government website form and a further 5 values into a second form and then submit the completed form. The site is accessed with a username and password.
My guess is I can record a macro of the insertion (pasting) process. But how do I process the copied csv data and incorporate it into the macro.
Any ideas?
Few ideas: Let's say you copied the following comma delimited text to the Clipboard:
Smith,John,[email protected]
You need to separate the values using StringSplit command and send them to the web form.
You can also get the text from a file using FileRead, like this
Smith,John,[email protected]
You need to separate the values using StringSplit command and send them to the web form.
Code: Select all
;extract the data
StringSplit, Value, Clipboard, `,
Surname:=Value1
Name:=Value2
Mail:=Value3
;send the data to the form
Send, %Surname%{Tab}%Name%{Tab}%Mail%
Code: Select all
FileRead, String, C:\DataFile.txt