h a l f b a k e r y
Veni, vedi, fish velocipede
add, search, annotate, link, view, overview, recent, by name, random
news, help, about, links, report a problem
or get an account
Feature that lets you paste to a number of text boxes
Simple idea, surpised there isn't a firefox plugin for this:
I have an excel sheet (eg):
A web interface requires me to fill several text boxes:
Since the tab order of the text fields is known, why can I just copy and paste
in one action rather than having to go back and forth?
I know I could write a SQL script to import the list, but this would be handy, no?
||erm. I didn't realise that there was a tab order in web forms - is that standard html ?
would you want it to delimit on commas or spaces ?
out of interest, what do you use your Excel sheet for ?
||I think the action is not standard html, since what I find is that TABINDEX isn't always accepted (earlier MS and Netscape ... what about FireFox?) and some anchors are similarly unreliable, particularly with MSIE. I generally work with Acrobat, and I have to agree that my sheets won't cut and paste directly to forms with a tab order. I've thought at times it would be neat to be able to do it, however.
||I just looked it up and it seems TABINDEX is standard HTML (4) and therefore supported in firefox. What you're asking for would be pretty easy to do, but.. well.. is it a common problem ?
||Right [neilp]. By w3 standards it is. (me and books collide)
||Here are scenarios:
1. I want to copy & paste material from a page that included form data I've entered.
2. I don't have a calculator, but I want to research data that has been entered across more than one area by a simple copy and paste
3. I want the act of copy to automatically advance by tab and paste the copy to both (a.) my clipboard and (b.) my next spreadsheet field.
||aah. the best we can do is to copy all the cells from the spreadsheet, and paste them all into a consecutive set in firefox. It that good enough ?
||If the website anticipates this need, they can just
provide a plain text box where you can paste your
data with a Parse button. The button would parse
each line as a separate record and populate the
boxes for you. If theres just one particular site
need this for, you could try contacting the makers
the site and asking them to add this feature. Do
have any examples of when you would want to put
spreadsheet values into text-boxes when the
site is asking for something not spreadsheety in
nature, and they therefore cant anticipate your
such a text box?