Skip to main content

Node - Calibrate

Similar to the function of batch calibrating data in the worksheet, the "calibrate" node can help refresh the values of formula field, rollup field, foreign fields (data storage), concat field and options (sorting and assigned values).

How to calibrate data

It supports calibrating single data and calibrating worksheets.

  • Calibrate single data

    Instantly refresh the formula calculations, foreign fields (data storage), rollup fields, and other field values in a single record in the worksheet. The refreshed field values can be used in subsequent nodes.

  • Calibrate worksheet

    • Refresh the calculation results, options sorting and assigned values, foreign fields (data storage), and rollup fields in the worksheet that meet the filtering conditions.

    • When the workflow reaches this node, it asynchronously queues the execution of the worksheet data calibration, and immediately execute the subsequent nodes in the workflow. The subsequent nodes cannot use the calibrated field values.

    • Up to 100,000 rows of records can be refreshed at once. If there are more than 100,000 rows, they need to be calibrated in batches through filtering.

    • Each data calibration must be at least 120 minutes apart, if less than 120 minutes, calibrating again will result in skipping that node directly.

Have questions about this article？ Send us feedback