Just released a neat new tool in On2Air: Actions. It’s called Functions.
You know those times when your Airtable base is almost working great, but it’s just missing some features you feel it should have?
Well, we’ve now added Functions to our On2Air: Actions app as the answer!
Functions are no-code, pre-made actions for your bases, tables, and records in Airtable.
You can try it out with a free 14-day trial >>> (On2Air)
See the Functions page - (https://on2air.com/on2air-actions)
Some functions available are
Set Default Values – You can add default information in each field that’s added every single time a new record is created.
Convert URLs to Attachments – Have a link that needs to be an attachment in your base? With this function, the URL is automatically converted to an attachment and added to an Attachment field.
Perform financial calculations – Calculate the payment for a loan based on equal payments and interest rate, calculate the interest rate per period for a loan or investment, return the present value of an investment or the total amount that a series of future payments is worth now, and many more financial calculations.
Perform math equations, statistical functions, and format numbers – Create any sort of math equation to apply your records, perform stat functions, such as mean, median, and max, and convert number formats to a new format.
Manipulate an array (range) of items across fields – Compare field data by extracting data from one field that is not in another and adding it to another field, search for unique data and store it another field (useful for detecting duplicates), count items across fields and store in a text or number field, and many more array options.
Import data from a URL into a table – With our Table Import function, you can import data into your table from a URL.
Lookup Values from another table – Lookup values from another table based on a field match and set in each triggered record. Similar to a VLOOKUP() call.
And so many more!
We have 33 ready to go and we are already working on more Functions to add, so this list is only going to grow!
If you have a suggestion for a function, let us know.
See a list of all the available Functions here >>>(All Functions Available | On2Air Support)
You can try it out with a free 14-day trial >>>(On2Air)