Dynamically adding fields to a form and into a SQL database

[programmher]

I have a form that needs to allow users to select any number of additional fields that will be included on the form. This is a scheduling form that will allow users to schedule their own appointments. There is a default of one set of"from" and "to" fields. How do I allow the users to select an infinite number of "from" and "to" fields and include them on the next form AND the SQL database? I'm thinking JS is the key; but I am working in CF...

 

[iza]

to build a dynamic query, cf is enough
to build a dynamic form, yes it's easier to use javascript - and the easiest is to show/hide