Where are form layouts saved?

[Steven G_]

I have challenges from time to time with form layouts, Does anyone know where they are saved within the instance? thank you

[Nia McCash]

In System UI > Forms, you can check the form sections that are available for a particular view.   Drilldown further into each section to see the fields in each section.

[Steven G_]

Thank you Nia. it has the form section but i am actually looking for the form layout with all the elements that I have on one instance. I deleted some old views and it messed my form layout on my sub instances.

[edwajs]

Hi Steve,

Form layouts are saved in several tables in the instance.

Every table with only a general section will have a sys_ui_section record generated as soon as you attempt to view the form, if it does not exist.   The sys_ui_section will be created in the Default view (the sys_ui_view record where the name is empty and the Title is Default view).

Once the system creates the sys_ui_section record for the form layout, it will then look at the sys_dictionary records for the table and add certain fields to this section.   If you look in the sys_ui_section record, there is a related list for Section Elements (sys_ui_element records) and all of the objects on the form (separators, formatters, fields, etc.) are specified in their own sys_ui_element record.

If you have added additional sections (tabs) to the form layout, there is more complexity, because you will have an addition sys_ui_section record with sys_ui_element records for each section.   However, you also have a sys_ui_form record, and it also has a Form Sections related list, but these are sys_ui_form_section records, and are a many-to-many relationship record to tie the sys_ui_form to the associated sys_ui_section records.

Ed Wajs

Technical Support Developer

[Steven G_]

Hi Ed,

Is there a way to export the form layout and move it to my other instance? as of now I have been rebuilding them manually. Just interested if there is an efficient way to do it.