You can open a flex form in ad hoc mode, just like any regular form, use ad hoc analysis to modify the grid layout, and submit data.
To open a flex form in ad hoc mode and submit data:
- Connect to a data source.
- In the Smart View Panel, expand the tree list and select the flex form you want to open in ad hoc mode.
- Click Analyze.
The form opens in a new sheet in the ad hoc mode.
- Modify data and grid layout per your requirements.
- Click Submit Data.
- Go back to the sheet with the flex form.
- Click Refresh.
The original layout and modified data appears in the flex form.