Calculate NPS

Automatically calculate NPS from form submissions


With the action “Calculate NPS”, you can calculate NPS from form submissions automatically when the chosen trigger is activated.


Trigger -> Action

The most important thing about a trick is understanding its conditions and actions. They have a simple generic structure:

When the condition (trigger) happens, then do (action).
Trigger -> Action

How to create

You just have to click on the "+ Automations" icon on the upper right corner of the screen to open the No code automations panel, and then on the "+ Create new automation" button:


Select the trigger of your choice to activate the action, then select the "Calculate NPS" action, and fill in the options:

  • Choose submission table:
    • Choose the table where NPS forms are submitted to
  • Choose the field with the ratings:
    *Choose the field in the submission table that holds the ratings (from 0 to 10)
  • Choose table to aggregate the NPS to:
    *Choose the table where the NPS will be automatically updated
  • Choose the record to aggregate the NPS to:
    • Choose a record to be automatically updated with the NPS
  • Choose the field to aggregate the score to:
    • Choose the field you wish to aggregate the NPS to
  • Aggregate by connection(optional):
    • Choose the field that connects the table of submissions to the table of NPS score. This will only use connected records for NPS calculation. Leaving it blank will use all records when calculating.

Click on save