You'll need to describe what you want and what you have attempted in more detail.
For starters, how does the "few letters" typed in determine which premade text should be used in the aut-fill?
And the various methods you might use fall into two categories:
1) the data is copied. If the data is later modified in the original source, this copy does not automatically update.
2) the data is referenced, any changes to the referenced data thus automatically update
Both approaches are useful in different situations.
Thanks for the response.
I would like to type 3 letters or digits, a simple refernece code. Then tab out of the field or hit enter to go to the next line. At which point the three letters auto fills into pre made lines of information. Typing in a reference code is not nesscary. The drop box feature would work perfect for this if it didn't need to replace all other text in the field because I need to be able to do this multiple times in the same field. The second category you mentioned is where I want to be.
This all looked like a very simple thing to set up until you said:
I need to be able to do this multiple times in the same field.
Please explain exactly what you mean by that.
We do printable invoices. A large section of our invoices is for "description of service." It is a large text field. We use alot of stanard text to describe our different services. We are constantly writing multiple services on each invoice. So instead of wrting out each service. We would like to type something short or use a list to auto fill thiese services.
But how does that entail doing this "Multiple times in the same field"?
What you last describe would seem to indicate that you do this one time in a field and thus a drop down list seems a very simple thing to use to set this up. It might entail doing this multiple times on an invoice, but each would be in a different related record as part of the line items that make up this invoice.
Or it might possibly mean that you have multiple fields and that you would do this one time in each such field if you have not set up an invoice with a table of related line items in a portal.
but multiple times in the same field????
Nope, it is a single text field. We type multiple lines of service in this single field. Example below.
OS1. Oil service. Changed oil and filter. Topped off fluids. Set tire pressure
TB2. Timing Belt Service. Changed belt and water pump.
FB1. Front brakes serviced. Replaced front pads and rotors.
This is typed into this single text field. I want to be able to make OS1, TB2, FB1, etc. auto fill. The drop down box would work if I could use it multiple times in the same field. The normal auto complete option for the "edit box" would wrok great too. If it could be set to search from a seperate database or values list of my making.
So you want to type in OS1. and get " Oil service. Changed oil and filter. Topped off fluids. Set tire pressure" to appear in the field? And each such entry starts on a new line of text?
Why put it all in one field?
A portal could be used with each entry in a different row of the portal and this would greatly simplify the data entry by making an auto-complete value list workable.
A script performed by onObjectKeystroke can probably be devised to do exactly what you describe, it just doesn't appear to me to be the best option.
Yeah. I though about dividing the field into multiple fields. But we also edit, add, and sometime subtract from these standard description to make them fit with each customer. Im concerned this will shift the other fields so as to not line up with other fields on the invoice. Or possibly cut off important text because the length is not set in stone. Also on a personal note. I have to keep this simple for my bosses. In the office Im the only one able to handle hiccups in programs. A mistake here or there, and my boses get flusttered and yell at me to fix it.
I think I have no fix to my issue. I will play around with it and see if multiple fields can work combined with a drop box. I appreciate your help and time. You been a big help. Thank you.
Not multiple fields, multiple records in a portal. It's not the same thing. And this shouldn't make the data entry part more complex for the user but there definitely might be issues with combining that data with other items on your layout, but I can't provide assistance when I don't have the info from which to work. Those issues might be easy to resolve or making this a more free form entry in a single field may work out as the best option.