No ratings

Handling Null Form Variables in Workflows

Topic

When a form control on a form is set to 'Visible = No', the corresponding variable for that control will always be null (regardless if the control was blank or not prior to being hidden).

nicksha_4-1644942355080.png

 

If 'My Text Control' was used as reference in a workflow action, such as SmartSheet - Add a Row. . .

nicksha_3-1644942308449.png

 

. . .this action would fail due to the null variable being used, and SmartSheet not being able to handle the null variable. 

nicksha_5-1644942471291.png

 

"Received an error response from the connector: "Required object attribute(s) are missing from your request: cell.value.". [Error Code: IO.XtensionExecute.ErrorResponse]"

Instructions

1. Set a new workflow variable to contain the value of the null form variable.

nicksha_6-1644942932050.png

 

2. Use the new workflow variable in workflow actions rather than the form variable.

nicksha_7-1644943011587.png

 

Although the form variable is null, the workflow variable will simply be blank. Conversely, if the form variable is not null, the workflow variable will contain the information in the form variable.

Additional Information

While SmartSheet is used as an example, the null variable may impact other integration actions as well. Additionally, it may be a neater design to use a 'Branch by condition' action to only leverage the workflow variable when the form control is blank. Then, when the form control is not variable, the original form variable continues to be used.

 

nicksha_8-1644943531890.png

 

This example can be imported into your Nintex Workflow Cloud tenant using the following Workflow Export Key: RPoQtiB6KQ3oQspCe4dSEF8HFCHfP7z3Ztjdg75jGQjncSpxi

Labels: (2)
Version history
Last update:
‎03-29-2022 01:59 AM
Updated by:
Contributors