So I work a alot in shopfiy and need to copy peoples information and past it in a commercial invoice on every order. I would like to automate this as much as possible and just press 1 button to copy all and paste it in the invoice.
The process works like this
I copy the
And paste all this information in to a page file with commercial information.
Unfortunately, the URL requires an account an a login. So please just upload the HTML code of the page.
Unless you happen to have a dummy, test account we could use. You could PM me with the login details.
If you click in the “Name” field and then press TAB, does it move the focus to the next field, “Street or P.O.Box” ?
If so, we can extract the data from the web page, then paste and TAB to paste into the Pages form. Make sense?
OK, assuming that the data on the web page is always in this order:
Then this macro should work.
How To Use
Open the web page to the page of interest (that you want to copy FROM)
Switch to the Pages form, and select the "Name" field.
Trigger this macro
It currently uses "Insert text by Typing" because that is what I needed to use in testing with Excel. You may be able to change to "Insert text by Pasting" with Pages app. I don't know since I don't have your Pages file/form.
Let us know if this works, or if you have issues/questions.
2018-03-08 13:59 GMT-0600
MACRO: Copy Ship Address from Shopify to Pages
~~~ VER: 1.1 2018-03-08 ~~~
Added more TABs between typing of data into Pages fields
AFAIK, it should work with any store that has the same HTML for the Shipping Address section of the web page. The easiest way to find out is to try it.
I see from your video that the tab order is NOT the same as I thought, which the Macro is designed for. But this is easy to fix. Just add additional Type the TAB keystroke actions to move the focus to the proper field:
Okey I managed to add the TAB keystroke. The only problem is that is randomly typing out the information on the invoice for some reason? Does it follow my mouse pointer or something else that makes it write random information on a random field.
I doubt that it is random. You may need to add several TAB keystrokes in the proper places. It may also be necessary to add a brief Pause (like 0.2 sec) in some/all places after the TAB to ensure Pages is ready to receive the typing in the proper location.