<h3 class="PlaygroundEditorTheme__h3" dir="ltr">Setup</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Subscribe to the add-on on the <a href="https://version2.io/explore" class="PlaygroundEditorTheme__link">Version2 website</a>.</li><li value="2" class="PlaygroundEditorTheme__listItem">Go to the<a href="https://airtable.com/marketplace" class="PlaygroundEditorTheme__link"> </a><a href="https://airtable.com/marketplace/blkw91nCmTZ9lHll9/running-total" rel="noreferrer" class="PlaygroundEditorTheme__link">Running total</a> extension on the Airtable marketplace.</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Add extension".</li><li value="4" class="PlaygroundEditorTheme__listItem">Select a base and click "Add extension".</li><li value="5" class="PlaygroundEditorTheme__listItem">When the extension is installed, click the button “Link Version2 account” and follow the instructions.</li><li value="6" class="PlaygroundEditorTheme__listItem">Repeat steps 2-5 to add the extension to all the bases you want to add this extension to.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Usage</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Open the extension from your Airtable base and click the "Extensions" button on the top right of the screen.</li><li value="2" class="PlaygroundEditorTheme__listItem">Select the table, view, and input fields to work on.</li><li value="3" class="PlaygroundEditorTheme__listItem PlaygroundEditorTheme__nestedListItem"><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">The input field can be a Number, Percentage, Currency, Duration, or Formula.</li><li value="2" class="PlaygroundEditorTheme__listItem">The running total field type must match the input field type, unless the input is a Formula.</li></ul></li><li value="3" class="PlaygroundEditorTheme__listItem">Select a running total field. Important: The extension overwrites all existing values in this field, so make sure it doesn't have important data in it.</li><li value="4" class="PlaygroundEditorTheme__listItem">Click "Update running total" to run the calculation. Note: Running this extension on large tables might take a while.</li></ol> For advanced use:<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Toggle on "Advanced mode".</li><li value="2" class="PlaygroundEditorTheme__listItem">Select a field to group by. For example, you can group the running total of credit card transactions by the month, so each month will have its own running total.</li><li value="3" class="PlaygroundEditorTheme__listItem">Select a custom operation type (default is "Sum").</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Tips</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">To create the running total for a sub-set of your records, create a view that has a filter to show only those records and run the extension on that view.</li><li value="2" class="PlaygroundEditorTheme__listItem">Sort your table view as you wish to generate the running total. For example, you can sort the table of credit card transactions by date to create a running total on transactions over time.</li><li value="3" class="PlaygroundEditorTheme__listItem">Use a chart extension (like <a href="https://airtable.com/marketplace/blkcQAzTn9Zy7CVfj/chart" class="PlaygroundEditorTheme__link">this one created by Airtable</a>) to view the running total on a graph.</li></ul> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Limitations</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">This add-on can only be used by one user in Airtable, but can be connected to unlimited bases.</li><li value="2" class="PlaygroundEditorTheme__listItem">The are no limits on the number of times you can trigger the extension.</li></ul>

### ****Setup****

1. Subscribe to the add-on on the[Version2 website](https://version2.io/explore).
2. Go to the[Running total](https://airtable.com/marketplace/blkw91nCmTZ9lHll9/running-total) extension on the Airtable marketplace.
3. Click "Add extension".
4. Select a base and click "Add extension".
5. When the extension is installed, click the button “Link Version2 account” and follow the instructions.
6. Repeat steps 2-5 to add the extension to all the bases you want to add this extension to.

### Usage

1. Open the extension from your Airtable base and click the "Extensions" button on the top right of the screen.
2. Select the table, view, and input fields to work on.
3. * The input field can be a Number, Percentage, Currency, Duration, or Formula.
 * The running total field type must match the input field type, unless the input is a Formula.
4. Select a running total field. Important: The extension overwrites all existing values in this field, so make sure it doesn't have important data in it.
5. Click "Update running total" to run the calculation. 
Note: Running this extension on large tables might take a while.

For advanced use:

1. Toggle on "Advanced mode".
2. Select a field to group by. For example, you can group the running total of credit card transactions by the month, so each month will have its own running total.
3. Select a custom operation type (default is "Sum").

### Tips

* To create the running total for a sub-set of your records, create a view that has a filter to show only those records and run the extension on that view.
* Sort your table view as you wish to generate the running total. For example, you can sort the table of credit card transactions by date to create a running total on transactions over time.
* Use a chart extension (like[this one created by Airtable](https://airtable.com/marketplace/blkcQAzTn9Zy7CVfj/chart)) to view the running total on a graph.

### Limitations

* This add-on can only be used by one user in Airtable, but can be connected to unlimited bases.
* The are no limits on the number of times you can trigger the extension.

<h1 class="PlaygroundEditorTheme__h1" dir="ltr">Airtable running total</h1> To set up this extension, you need to perform some actions in both Version2 and Airtable. <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Version2</h3>When you're subscribed to the add-on, it's listed in the "Add-ons" tab in your dashboard.<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Select the add-on and click the "Configuration" tab.</li><li value="2" class="PlaygroundEditorTheme__listItem">Enter the email address that's connected to your Airtable account</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Save changes".</li><li value="4" class="PlaygroundEditorTheme__listItem">Copy the License Key to your clipboard.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Airtable</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Go to the <a href="https://airtable.com/marketplace" class="PlaygroundEditorTheme__link">Airtable marketplace</a>.</li><li value="2" class="PlaygroundEditorTheme__listItem">Search for "Running total" by Version2.</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Add extension".</li><li value="4" class="PlaygroundEditorTheme__listItem">Select a base and click "Add extension".</li><li value="5" class="PlaygroundEditorTheme__listItem">When the extension is installed, in the top-right of the extension page, click the settings icon.</li><li value="6" class="PlaygroundEditorTheme__listItem">Paste the License Key you copied in the last step of the previous procedure into the License Key field, and click "Confirm".</li><li value="7" class="PlaygroundEditorTheme__listItem">Repeat steps 3-6 to add the extension to as many bases you're a member of.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Usage</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Open the extension from your Airtable base and click on the "Extensions" button on the top right of the screen.</li><li value="2" class="PlaygroundEditorTheme__listItem">Select the table, view, and input fields you wish to work on.</li><li value="3" class="PlaygroundEditorTheme__listItem">The input field can be a Number, Percentage, Currency, Duration, or Formula. The running total field type must match the input field type unless the input is a Formula.</li><li value="4" class="PlaygroundEditorTheme__listItem">Select a running total field, and make sure this field doesn't have important data in it, as the extension will override any existing values in the field.</li><li value="5" class="PlaygroundEditorTheme__listItem">Click "Update running total" to run the calculation. Note: Running this extension on large tables might take a while.</li><li value="6" class="PlaygroundEditorTheme__listItem">For advanced use:</li><li value="7" class="PlaygroundEditorTheme__listItem PlaygroundEditorTheme__nestedListItem"><ol class="PlaygroundEditorTheme__ol2"><li value="1" class="PlaygroundEditorTheme__listItem">Enable "Advanced mode".</li><li value="2" class="PlaygroundEditorTheme__listItem">Select a field to group by. For example, you can group the running total of credit card transactions by the month, so each month will have its own running total.</li><li value="3" class="PlaygroundEditorTheme__listItem">Select a custom operation type (default is "Sum").</li></ol></li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Tips</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">If you wish to create the running total for a sub-set of your records, create a view that has a filter to show only those records and run the extension on that view.</li><li value="2" class="PlaygroundEditorTheme__listItem">Sort your table view as you wish to generate the running total. For example, you can sort the table of credit card transactions by date to create a running total on transactions over time.</li><li value="3" class="PlaygroundEditorTheme__listItem">Use a chart extension (like <a href="https://airtable.com/marketplace/blkcQAzTn9Zy7CVfj/chart" class="PlaygroundEditorTheme__link">this one created by Airtable</a>) to view the running total on a graph.</li></ul> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Limitations</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">This add-on can only be used by one user in Airtable, but can be connected to unlimited bases.</li><li value="2" class="PlaygroundEditorTheme__listItem">The are no limits on the number of times you can trigger the extension.</li></ul>

Airtable running total

To set up this extension, you need to perform some actions in both Version2 and Airtable. <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Version2</h3>When you're subscribed to the add-on, it's listed in the "Add-ons" tab in your dashboard.<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Select the add-on and click the "Configuration" tab.</li><li value="2" class="PlaygroundEditorTheme__listItem">Enter the email address that's connected to your Airtable account</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Save changes".</li><li value="4" class="PlaygroundEditorTheme__listItem">Copy the License Key to your clipboard.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Airtable</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Go to the <a href="https://airtable.com/marketplace" class="PlaygroundEditorTheme__link">Airtable marketplace</a>.</li><li value="2" class="PlaygroundEditorTheme__listItem">Search for "Running total" by Version2.</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Add extension".</li><li value="4" class="PlaygroundEditorTheme__listItem">Select a base and click "Add extension".</li><li value="5" class="PlaygroundEditorTheme__listItem">When the extension is installed, in the top-right of the extension page, click the settings icon.</li><li value="6" class="PlaygroundEditorTheme__listItem">Paste the License Key you copied in the last step of the previous procedure into the License Key field, and click "Confirm".</li><li value="7" class="PlaygroundEditorTheme__listItem">Repeat steps 3-6 to add the extension to as many bases you're a member of.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Usage</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Open the extension from your Airtable base and click the "Extensions" button on the top right of the screen.</li><li value="2" class="PlaygroundEditorTheme__listItem">Select the table, view, and input fields to work on.</li><li value="3" class="PlaygroundEditorTheme__listItem PlaygroundEditorTheme__nestedListItem"><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">The input field can be a Number, Percentage, Currency, Duration, or Formula.</li><li value="2" class="PlaygroundEditorTheme__listItem">The running total field type must match the input field type, unless the input is a Formula.</li></ul></li><li value="3" class="PlaygroundEditorTheme__listItem">Select a running total field. Important: The extension overwrites all existing values in this field, so make sure it doesn't have important data in it.</li><li value="4" class="PlaygroundEditorTheme__listItem">Click "Update running total" to run the calculation. Note: Running this extension on large tables might take a while.</li></ol> For advanced use:<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Enable "Advanced mode".</li><li value="2" class="PlaygroundEditorTheme__listItem">Select a field to group by. For example, you can group the running total of credit card transactions by the month, so each month will have its own running total.</li><li value="3" class="PlaygroundEditorTheme__listItem">Select a custom operation type (default is "Sum").</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Tips</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">To create the running total for a sub-set of your records, create a view that has a filter to show only those records and run the extension on that view.</li><li value="2" class="PlaygroundEditorTheme__listItem">Sort your table view as you wish to generate the running total. For example, you can sort the table of credit card transactions by date to create a running total on transactions over time.</li><li value="3" class="PlaygroundEditorTheme__listItem">Use a chart extension (like <a href="https://airtable.com/marketplace/blkcQAzTn9Zy7CVfj/chart" class="PlaygroundEditorTheme__link">this one created by Airtable</a>) to view the running total on a graph.</li></ul> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Limitations</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">This add-on can only be used by one user in Airtable, but can be connected to unlimited bases.</li><li value="2" class="PlaygroundEditorTheme__listItem">The are no limits on the number of times you can trigger the extension.</li></ul>

To set up this extension, you need to perform some actions in both Version2 and Airtable. <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Version2</h3>When you're subscribed to the add-on, it's listed in the "Add-ons" tab in your dashboard.<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Select the add-on and click the "Configuration" tab.</li><li value="2" class="PlaygroundEditorTheme__listItem">Enter the email address that's connected to your Airtable account</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Save changes".</li><li value="4" class="PlaygroundEditorTheme__listItem">Copy the License Key to your clipboard.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Setup on Airtable</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Go to the <a href="https://airtable.com/marketplace" class="PlaygroundEditorTheme__link">Airtable marketplace</a>.</li><li value="2" class="PlaygroundEditorTheme__listItem">Search for "Running total" by Version2.</li><li value="3" class="PlaygroundEditorTheme__listItem">Click "Add extension".</li><li value="4" class="PlaygroundEditorTheme__listItem">Select a base and click "Add extension".</li><li value="5" class="PlaygroundEditorTheme__listItem">When the extension is installed, in the top-right of the extension page, click the settings icon.</li><li value="6" class="PlaygroundEditorTheme__listItem">Paste the License Key you copied in the last step of the previous procedure into the License Key field, and click "Confirm".</li><li value="7" class="PlaygroundEditorTheme__listItem">Repeat steps 3-6 to add the extension to all the bases you want to add this extension to.</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Usage</h3><ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Open the extension from your Airtable base and click the "Extensions" button on the top right of the screen.</li><li value="2" class="PlaygroundEditorTheme__listItem">Select the table, view, and input fields to work on.</li><li value="3" class="PlaygroundEditorTheme__listItem PlaygroundEditorTheme__nestedListItem"><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">The input field can be a Number, Percentage, Currency, Duration, or Formula.</li><li value="2" class="PlaygroundEditorTheme__listItem">The running total field type must match the input field type, unless the input is a Formula.</li></ul></li><li value="3" class="PlaygroundEditorTheme__listItem">Select a running total field. Important: The extension overwrites all existing values in this field, so make sure it doesn't have important data in it.</li><li value="4" class="PlaygroundEditorTheme__listItem">Click "Update running total" to run the calculation. Note: Running this extension on large tables might take a while.</li></ol> For advanced use:<ol class="PlaygroundEditorTheme__ol1"><li value="1" class="PlaygroundEditorTheme__listItem">Toggle on "Advanced mode".</li><li value="2" class="PlaygroundEditorTheme__listItem">Select a field to group by. For example, you can group the running total of credit card transactions by the month, so each month will have its own running total.</li><li value="3" class="PlaygroundEditorTheme__listItem">Select a custom operation type (default is "Sum").</li></ol> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Tips</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">To create the running total for a sub-set of your records, create a view that has a filter to show only those records and run the extension on that view.</li><li value="2" class="PlaygroundEditorTheme__listItem">Sort your table view as you wish to generate the running total. For example, you can sort the table of credit card transactions by date to create a running total on transactions over time.</li><li value="3" class="PlaygroundEditorTheme__listItem">Use a chart extension (like <a href="https://airtable.com/marketplace/blkcQAzTn9Zy7CVfj/chart" class="PlaygroundEditorTheme__link">this one created by Airtable</a>) to view the running total on a graph.</li></ul> <h3 class="PlaygroundEditorTheme__h3" dir="ltr" style="text-align: left;">Limitations</h3><ul class="PlaygroundEditorTheme__ul"><li value="1" class="PlaygroundEditorTheme__listItem">This add-on can only be used by one user in Airtable, but can be connected to unlimited bases.</li><li value="2" class="PlaygroundEditorTheme__listItem">The are no limits on the number of times you can trigger the extension.</li></ul>

Setup guides, usage instructions, and bonus expert usage tips.

Was this article helpful?