Creating 70+ new columns on a table. - Is there any easy/fastest way?

[Neel Patel]

Hi All,

I have been given a task to create 70+ new field/columns on the HR profile field.

Is there a way to create those column by uploading excel or import sets?

Thank you in advance!

[Michael Fry1]

Spreadsheet + App Engine Studio is about all I could think of. 

[Sandeep Rajput]

Try importing the excel in the sys_dictionary table. You can download the Excel template and use the same to create new columns.

Hope this helps,

[Sumanth16 · Accepted solution]

Hi @Neel Patel ,

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.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda