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)