Easy and Quick way to add fields (more than 100) to forms.

[DubeyN]

Hi,

I am working on creating new application. I am building a form and need to add around 100 fields to the form. I know the way to create and add fields to form. But I am looking for a easy way to create more than 100 fields in the form. Is there is any option to create a excel and upload the fields to the form.

It will take around 3-4 hours to create 100 fields to the form, but if there is any way to upload all fields to the form. It will save allot of time to build application.

Thanks in advance.

Regards,
ND

[Brad Tilton]

You could use an import set to import an excel spreadsheet into the sys_dictionary table. Then you can add the fields to the form at once by personalizing the form. To see an example of the table to build you excel doc, go to any form and go personalize dictionary.

[Mark Stanger]

While you may be able to get this to work, you probably ought to consider why you would need a form with that many fields. A form with that many fields is probably going to take forever to load and work with. It's not a good idea.

[DubeyN]

Hi Brad,

This idea was in my mind, but it looks risky to directly upload data to sys_dictionary table. I will give it a try and let you know. Do you have any Excel template which you are using to import fields to sys_dictionary table?

Mark,

This is users requirement to have that many fields on the form. We suppose to build a new application and user need too many fields. Fields are not exactly 100, but it could be more than 60. In future I can expect requirement of new application haveing around 100 fields. Is there is any way to avoid dificulty you are talking about?

Regards,
ND

[Mark Stanger]

I would just go back to the client and try to figure out why they think they need it to be that way. I've found that when you've got that many fields that the process is overly complex or the client is trying to use the tool for a purpose that it's not well suited for.