Is it possible..?

[jdickson]

Say I have a database table with the following:

FirstName
LastName
Address
City
....etc......

Is there a way for a user, via an online form, to create a custom letter by selecting the table fields via drop down menus?

Example:

The user would have a text area where they type their letter. They would have a drop down box that lists all table fields. When they get to the point in the letter where they want to address the person's first name, they would click in that spot in the textarea, then choose the drop down list for the fields. Then the field would be dynamically placed in the letter. Then they would save the letter and could print it later.


Thanks in advance for your help!

 

[-NC-]

It should be possible.

essentially you need to store the cursor position in a textarea, and then insert a string into the text at that index.

Seems to be a lot of useful stuff if you google for:
javascript insert text textarea cursor
http://www.google.com/search?q=javascript+insert+text+textarea+cursor

sorry don't have time to work up an example!