Skip to main content

Update fields of form report

Change which approval records and variables a form report includes, edit field types and display settings, and check the result after saving.

Use Report Fields to update which records or variables a form report includes. Before changing an existing field, review the views, filters, and controls that use it. Keep a known approval record for checking the result.


Open Report Fields

Open the form report. In the upper-right corner, select More Settings → Report Fields. The left side shows the filters and available variables. The right side shows the fields already included in the report.


Change which records the report includes

In Set data filters, select Set filter conditions and add, edit, or remove rules. For example, filter a purchase requisitions report by approval status to include approved requests. Keep both a matching and a nonmatching request for testing.


Add variables or sublist fields

Select more approval form variables from the left panel. For line-item detail, select one sublist under Sub list fields and add its child fields. For example, add item name and quantity from the purchase lines. Create form reports


Edit or remove selected fields

In Selected report fields, update Field name or choose an available Field Type. To remove a field, select the delete icon on its row after checking where the field is used. If the source variable itself changed, review the field mapping steps.


Choose how a Boolean field appears

Open the settings next to a Boolean field. Under Display style, choose Switch to display On or Off, or Tick box to display Yes or No. Switch is the default.

Boolean report field display styles. Switch is the default and displays ON or OFF. Tick box displays Yes or No.


Save and check the regenerated report

Select OK at the top right. The report regenerates if you add a variable or remove a field. The time depends on how much data the report contains. When the report is ready, compare fields and sublist row counts with the known request. If you changed the report filters, confirm that the matching request appears and the nonmatching request is excluded.

Did this answer your question?