I would like to have a screen where I can define a list of ? variables for a project and where the program would create a form with that list of variables.
A user will ? fill up the form, feeding the table that has been created.
I would like to have the choice to export that table in XLS AND CSV formats.
So, for example, I create a case called "001" and I define that "001" has the following variables:
[filenumber]
[name]
[lastname1]
[lastname2]
[id]
[address]
[city]
[state]
[zip]
[phone]
That should create a form that has all those fields.
We have two kinds of variables. ? Those that will be present in ALL cases, and those that belong to each case.
So I should be able to mark which variables are "global" or repetitive, and which are "case" variables.
I should have a list of repetitive variables when I create a new form/table, so that the process will be expedite.?
I should be able to mark a new variable as "global" and have the system include it automatically in all future tables. ? I should, of course, be able to edit the name of any variable, to define if this variable should be numeric and what format to expect and also, to delete a variable.