:dart: Set Default Values – You can add default information in each field that’s added every single time a new record is created.
:link: :arrow_forward: :camera: 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.
:heavy_division_sign: :heavy_multiplication_x: 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.
:heavy_plus_sign: 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.
:arrows_counterclockwise: 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.
:link: :arrow_forward: :computer: Import data from a URL into a table – With our Table Import function, you can import data into your table from a URL.
:eyes: 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.