I want to dynamically create fields in a form

Does anyone how or where to begin researhing the idea of being able to dynamically create fields on a form through entries from another form.

for instance, have a form where you can enter data into text fields (e.g. strTextOne). When you save (perhaps) a script will run that will take the data you entered and add that text as a field name and a new field relative to a completely different form.

Let me know if this makes no sense at all.

THANKS!!

Subject: I want to dynamically create fields in a form

Creating the fields is no problem. You’ll have to name your fields a bit more logical though, eg. have them end in _1,_2,…,_X

The problem is displaying the fields, since you can’t really put new fields on a form.

You’ll need to show the generated fields in a Richtextfield, using html or by creating a table using LS, or create a field that shows all dynamically generated fields (a few problems there, eG. the 64KB limit, it may not look pretty, etc.)

Create the formula in that field using an @for, @while formula, using @getfield to access the dynamic fields.

eg. @for( x:=1; x < 100; x := x+1;

result := result:@getfield( “strText_” + @text(x));

);

@trim(result)