Opening a Flex Form in Ad Hoc Mode and Submitting Data

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:

  1. Connect to a data source.
  2. In the Smart View panel, expand the tree list and locate the flex form to open in ad hoc mode.
  3. Right-click the icon of the flex form, Flex form icon, and select Ad Hoc Analysis.

    Alternatively, right-click the icon of the flex form, Flex form icon, and select Open Form. Then, in the Smart View ribbon, click Analyze.

  4. Modify data and grid layout per your requirements.
  5. Click Submit Data.
  6. Go back to the sheet with the flex form.
  7. Click Refresh.

    The original layout and modified data appears in the flex form.