Generates a Universally Unique Identifer ( UUID). Returns a string containing the characters from A for the specified range. Returns characters from A for the given range. Return the numeric value of the specified text value A. Returns the right most X characters from the text A.įor example, RIGHT("Tap Forms" 5) returns the value “Forms”. Returns the position of B within the text A.įor example, POS("Tap Forms" "Forms") returns the numeric value 5. Returns the number of characters in the text value A. Returns the left most X characters from the text A.įor example, LEFT("Tap Forms" 3) returns the value “Tap”. Please see the Unicode Technical Standard #35 for pattern syntax and examples. There is no limit on the number of parameters.įORMAT(X "#.00") displays the value of X using the provided number format. ) function returns the combined string “abcdef”. If X is not empty, then it returns Y, else it returns Z.ĬONCAT("abc" "def". IFNOTEMPTY(X Y Z) checks to see if X is not empty. IFEQUAL(A B C D) will return C if A and B are equal. If A and B are equal, return C, otherwise return D. If X is empty, then it returns Y, else it returns Z. IFEMPTY(X Y Z) checks for empty value of X. If X is not 0, then it returns Y, else it returns Z. YYMMDD(X Y) returns the number of years, months and days between the start and end dates as a text value. Number of years, months and days between dates YYMM(X Y) returns the number of years and months between the start and end dates as a text value. YEARS(X Y) returns the number of years between the start and end dates. Returns the week number of the year from 1 to 52. WEEKDAYS(X Y) returns the number of weekdays between the start and end dates. Inserts the current date in Unix Epoch date format, which is the number of seconds elapsed since Janu00.00.00 GMT. Inserts the current date & time in Unix Epoch date format, which is the number of seconds elapsed since Janu00.00.00 GMT. Y = Year, M = Month, W = Week of Year, WD = Weekday, WO = Week Ordinal, D = Days, H = Hours, M = Minutes, S = Seconds. MONTHS(Start Date End Date).Ĭreates a date given the specified components.įor example: NEWDATE(2017 11 0 0 0 22 0 0 0) will create a date for. MONTHS(X Y) returns the number of months between the start and end dates.
MMDD(X Y) returns the number of months and days between the start and end dates as a text value. MINUTES(X Y) returns the number of minutes between the start and end dates. HOURS(X Y) returns the number of hours between the start and end dates.
Returns the last day of the month X number of months before or after the specified date. Returns the date for the last day of the month Returns a date value for the specified date text.įor example: DATEVALUE("" "yyyy-MM-dd") returns the date Dec 31, 2017.ĭAYS(X Y) returns the number of days between the start and end dates. Y = Years, M = Months, W = Weeks, D = Days, H = Hours, M = Minutes, S = Seconds. Please see the Unicode Technical Standard #35 for pattern syntax and examples.Īdds the date components to the specified date.įor example: DATEADD(Date 0 3 0 2 0 0 0) will add 3 months and 2 days to the specified date. The second parameter is for customizing the format. Date and Time FunctionĭATE(X "yyyy-MMM-dd hh:mm:ss a") displays the date with the date and time. For example IFEMPTY(Price 0 Price) which will return 0 if the Price field is empty and the actual Price value if it’s not empty. To resolve this issue, you can either set a Default Value for all the fields used in the formula, or you can use the IFEMPTY() function to return a default value if none is provided. !If you don’t provide a value for every field in your formula, you will receive an empty result for the Calculation field. Tap Forms will do this for you when you choose a function, but you will have to go back and edit old formulas to use the semi-colon delimiter between function parameters. You will also need to use a semi-colon character as the delimiter between parameters in function calls.
*In Tap Forms 5.2, for international regions which use a comma for the decimal point, you will need to now use a comma in all the numbers you use in your formulas. The following mathematical expressions in the Calculation field formula editor are supported: Tap Forms has a special field type called Calculation.įor basic math, use the following operators: Operator