Skip to main content

Create form reports

Create a form report from submitted approvals. Choose which records and fields to include, set access, and verify the published report.

Use a form report to turn submitted approvals into a searchable list. For example, create a purchase request report that shows the requester, approval status, and amount.


1. Choose an approval form

In the application, select + Add Component → Form report. In the wizard, choose the source approval form, enter a name and an optional description, and select Next.

2. Choose records and fields

Set which submissions the report includes, then choose the values readers need to see. You can create separate views for subsets of the included records.

Filter the source records

Under Set data filters, open Set filter conditions. Choose a source variable, comparison type, operator, and value. Use And when multiple conditions must match, or Or when any of them can match. Keep the base report broad enough to support the views you plan to create.

Add approval form variables

Select the variables in the left panel and click Add selected variables. Confirm they appear in Selected report fields on the right.

Add sublist fields

Under Sub list fields, select one sublist, check the child fields you need, and click Add selected fields. Each item from the selected sublist becomes a report row. For example, a purchase request with three line items produces three rows in a line-item report.

Review the selected fields

Use Field Name for the column label and Field Type for how the value is presented. Where a settings button appears, review the options for that type, such as date format or lookup display field. Remove fields readers do not need, then select Next.

3. Set access and export permissions

Decide who can view the report, who can open the underlying approval form, and who can export records.

Choose who can view and manage the report

Keep Inherit from Application if the application’s access already matches the report’s audience. To manage permissions separately, clear it and specify report administrators and viewers. Check which people or groups are included before continuing.

Control access to approval details

Enable Allow users to access the form’s detail page if readers need to open the underlying approval record. When report-level access is enabled, individual data views can further restrict access to details.

Form report permissions. Inherit from Application controls report access. Separate options allow readers to open approval details and export the report.

Control export

If readers need an Excel file, enable Allow users to export the report and choose Specified Users or All Users, according to the intended audience. Select Next after reviewing the three settings.

4. Publish the report

Review the wizard’s confirmation screen, then select Publish. Wait for generation to finish before testing the report.


Verify the generated report

  1. Check a known submission against the source approval form. If you used a source filter, verify that one matching request appears and one excluded request does not.

  2. If you included a sublist, compare the reported rows with the number of items on the source request.

  3. Open the report with a reader account. Check which views and records it can see, whether approval details open, and whether export is available. Form report overview

Did this answer your question?