AX2222
When using file processing, you may want to conditionally determine whether the file processing action occurs, depending on information within the file. This can be especially useful when using multipass processing, and you want the action to occur on some passes but not others.
The Processing Enabled setting on the File Processing Control Sheet enables conditional processing. By setting up a formula in this field that conditionally returns either True or False, you can turn the file processing action on or off for each individual pass.
When file processing is initiated, the file is always refreshed. After the refresh occurs, Axiom Software checks the Processing Enabled setting to see if the file processing action (snapshot, export, save data) should be performed.
- If True, the file processing action is performed as normal.
- If False, the file processing action is not performed.
In both cases, the process moves on to the next pass (if using multipass processing), refreshes the file again, and checks the Processing Enabled setting again. This continues until all passes are complete.
For example, you may want to configure file processing so that a snapshot is not sent if a particular pass results in zero data. You can set up a formula in the report sheet that totals all of the data columns. Then you can set up a formula in the Processing Enabled setting that checks this total, and returns False if the total results in zero, or True if it doesn't. Snapshots will be created for passes that have data, and passes without data will be skipped.
The Processing Enabled setting is only available on the File Processing Control Sheet. You cannot turn file processing on and off from the File Processing pane.
