Function - Math

Perform Match Functions on Records

Function Options

Write Math Equation - Perform an extensive variety of math equations in your records
(Algebra, Basic usage, Bignumbers, Chaining, Complex numbers, Expressions, Fractions, and more)

Format Numerical Number - Format incoming numbers and output as a different format

Convert to Another Unit - Convert units to a different unit
(Length, Surface area, Volume, Liquid Volume, Angles, Time, Frequency, and more)

Statistical Formula - Perform statistical functions on your records

_______________________________________________



Configuration

Click Create New Function

Choose your Function

Click Add Configuration

Set up your Common Function Configurations - Source Connection, Source Configuration, and Trigger Mode

Set up your Function Configuration for your desired Math Function Option

(Using the Write Math Equation option in this example)



Write Math Equation

Perform an extensive variety of math equations in your records
(Algebra, Basic usage, Bignumbers, Chaining, Complex numbers, Expressions, Fractions, and more)



Variables - Configure Variable key and select the field it represents

Formula Editor - Write your math equation using variables - View the Full syntax and instructions

Select Output Field - Choose the field where you want to output your math equation result

Next, choose any Advanced Settings you need

Input Separator - Add an input separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Output Separator - Add an output separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Last Updated - Choose a date field to keep track of the last time the field was updated

Click Save Action Function Details

Next, Test Your Function

Before using your Function, you must test it.

Then, Install Your Function via a Zapier zap, an Airtable Automation, a Script in the Scripting app, or directly via REST API.

_______________________________________________

Format Numerical Number

Format incoming numbers and output as a different format

Fields to Format - Choose the Format Style, the Incoming Field, and the Outgoing/Formatted Field

Options:

Standard
Currency
Decimal
Ft Units
Percent
Or your own custom format

Manage Format Styles - You can configure your format styles to be used on each field. See full formatting documentation
IMPORTANT - These are configured across ALL functions. Be careful when configuring or deleting a format style if it's used in another function.

Choose the green icon to edit the format style. Choose the yellow icon to delete the style. Click Save Styles.

Next, choose any Advanced Settings you need

Input Separator - Add an input separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Output Separator - Add an output separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Last Updated - Choose a date field to keep track of the last time the field was updated

Click Save Action Function Details

Next, Test Your Function

Before using your Function, you must test it.

Then, Install Your Function via a Zapier zap, an Airtable Automation, a Script in the Scripting app, or directly via REST API.

_______________________________________________

Convert to Another Unit

Convert units to a different unit

Fields to Format - Choose the Conversion to use, the Incoming Field, and the Outgoing/Converted Field

Options:

Length
Surface area
Volume
Liquid Volume
Angles
Time
Frequency
Mass
Electric Current
Temperature
Amount of Substance
Luminous intensity
Force
Energy
Power
Pressure
Electricity and magnetism
Binary

Manage Conversions - You can configure your unit conversions to be available for use on each field. See full unit documentation
IMPORTANT - These are configured across ALL functions. Be careful when configuring or deleting a conversion if it's used in another function.

Manage Format Styles - You can configure your format styles to be used on each field. See full formatting documentation
IMPORTANT - These are configured across ALL functions. Be careful when configuring or deleting a format style if it's used in another function.

Choose the green icon to edit the unit conversion or format style. Choose the yellow icon to delete the conversion or style. Click Save Styles.

Next, choose any Advanced Settings you need

Input Separator - Add an input separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Output Separator - Add an output separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Last Updated - Choose a date field to keep track of the last time the field was updated

Click Save Action Function Details

Next, Test Your Function

Before using your Function, you must test it.

Then, Install Your Function via a Zapier zap, an Airtable Automation, a Script in the Scripting app, or directly via REST API.

_______________________________________________

Statistical Formula

Perform statistical functions on your records



Stats Function - Choose the stat function to perform

Options:
Mean
Median
Max
Min
Mode
Product
Standard Deviation
Sum
Variance
Median Absolute Deviation

Input Fields - Choose 1 or more fields where your input value is listed

Select Output Field - Select the field where you want to insert the final statistical result

Next, choose any Advanced Settings you need

Input Separator - Add an input separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Output Separator - Add an output separator between text elements. This will add a separation value to any field data.

You can use any character, such as a comma (,) or dash (-). If you use \n, you can add a new line in your text field. You can also use HTML.

Last Updated - Choose a date field to keep track of the last time the field was updated

Click *Save Action Function Details*

Next, Test Your Function

Before using your Function, you must test it.

Then, Install Your Function via a Zapier zap, an Airtable Automation, a Script in the Scripting app, or directly via REST API.
Was this article helpful?
Cancel
Thank you!