Formula Library

Use this on any button to take the user back to the previous screen.

Converts text to a numeric value.

Alternative method to join text values.

Returns the current date and time.

Returns the number of days between two dates.

Rounds a number to a specified number of decimal places.

Always rounds a number up.

Returns the smallest value from a list.

Returns the average of all values in a column.

Counts the number of records that meet a specific condition.

Saves the changes entered into a form to the data source.

Resets a control (like a text box) to its default value.

Returns the first non-empty value from a list.

Returns information about the current logged-in user.

Runs multiple actions at the same time to speed up processing.

Evaluates a condition. If it is true, it returns the first result; otherwise, it returns the second result. Like a basic 'if this, then that' decision.

Creates or updates a record in a data source. Useful when saving new data or editing existing records like forms, lists, or tables.

Clears out a collection and immediately fills it with new data. Ideal for refreshing local data from a data source.

Removes a specific record from a collection or data source. Often used with buttons to delete the selected item.

Returns only the records that meet one or more conditions.

Sorts records in a table based on column names, useful when sorting by dynamic fields.

Checks if a value is empty. Useful for validations.

Returns the number of characters in a string.

Extracts a specified number of characters from the end of a string.

Creates a global variable that can be used across the entire app. Useful for storing information like a user's name, preferences, or temporary values.

Formats a number into dollars/currency

Joins multiple text strings into one.

Returns the current date without time.

Adds or subtracts days, months, or years from a date.

Returns a number representing the day of the week.

Always rounds a number down.

Returns the largest value from a list.

Adds up all values in a column.

Counts the number of rows in a table or collection.

Returns a blank record that matches the structure of a data source.

Clears the form and resets it to its default values.

Displays a message to the user in a pop-up alert.

Creates a temporary variable to simplify formulas.

Loops through each item in a table and performs an action.

Extracts a string from the middle of another string.

Checks a single value against multiple possibilities and returns a corresponding result. It's easier to read than writing many If statements.

Adds a record to a collection (a local, temporary table stored in memory). Great for building tables dynamically in your app.

Removes all items from a collection. Think of it as clearing a temporary table stored in your app.

Deletes all records in a data source or collection that meet the given condition.

Sorts a table based on a column in ascending or descending order.

Finds the first record in a table that matches a condition and returns a specific field.

Determines if a value is a valid number.

Extracts a specified number of characters from the beginning of a string.

Navigates the user to a different screen in the app. For example, if the user clicks a button, you can use this to take them to a 'Home' or 'Details' screen.

Creates or updates a variable that only exists on the current screen. Ideal for things like toggling popups or storing user input without affecting the rest of the app.