Skip to main content

Handling changes of approval form variables in form reports

Update report mappings after an approval variable’s type or ID changes or the variable is removed. Verify historical and new submissions.

When an approval form variable changes, a form report that uses it can show blank values or a missing-variable warning. Before editing the report, keep a known submission for comparison and note the views, filters, and controls that use the affected field.


Update a field after its source variable changes type

An existing report field may still use its original type. For example, a variable that changes from Text to Number may still appear as Single line in the report. If conversion fails, the report may show a blank value.

  1. In the report, select More Settings → Report fields. Compare the affected report field with the source variable.

  2. To remap the field, remove its existing row from the selected fields. Select the updated variable in the left panel and choose + Add selected variables. Check the new field name and type.

  3. Select OK and wait for regeneration. Compare a historical submission and a new submission using the updated type. Update report fields

Repair a missing variable mapping

If the source variable was deleted or its ID changed, select the red warning next to Export. The message lists the IDs the report could no longer find in the associated approval form.

A warning beside Export lists v_Reason as a variable that cannot be found in the associated approval form.

  1. Open Report fields and match the missing ID to a field highlighted in red.

  2. If the variable has a new ID, remove the old mapping and add the replacement variable from the left panel. If the variable was deleted, check what uses the report field before removing it.

  3. Select OK and reopen the report. Check that the warning has cleared and verify the views, filters, and controls that depended on the field.

Did this answer your question?