All Functions used within form or template design.

Or view this by Categories.

FunctionDescriptionCategory
*MultiplyMath
+AddMath
-SubtractMath
<Less ThanLogic
ACOS(val)ArccosineAdvanced Math
ASIN(val)ArcsineAdvanced Math
ATAN(val)ArctangentAdvanced Math
BOOLEAN(val)To BooleanData Conversion
COS(val)CosineAdvanced Math
COSH(val)Hyperbolic CosineAdvanced Math
DATE(val)To DateData Conversion
DEGREES(angle)Converts radians to degrees DegreesAdvanced Math
IMGURL(imgfieldname)To Image URLData Conversion
INT(val)To IntegerData Conversion
LOG(val,base)LogarithmAdvanced Math
NUMBER(val)To NumberData Conversion
PI()PiAdvanced Math
RADIANS(angle)Converts degrees to radians RadiansAdvanced Math
SIN(val)SineAdvanced Math
SINH(val)Hyperbolic SineAdvanced Math
SQRT(val)Square RootAdvanced Math
STRING(val)To StringData Conversion
TAN(val)TangentAdvanced Math
TANH(val)Hyperbolic TangentAdvanced Math
COUNTER(padwidth)Simple counter that increments by 1Contextual
.Current AnswerContextual
GLOBALVAL('keyname')Global Value for the specified key nameContextual
NOW()Current Date & TimeContextual
ORGNAME()Organisation NameContextual
PARAM1()The value passed into the FormContextual
TODAY()Current DateContextual
USEREMAIL()User's Email AddressContextual
USEREXTERNALID()User's External IdContextual
USERFIRSTNAME()User's First NameContextual
USERLASTNAME()User's Last NameContextual
UTCNOW()Current UTC (GMT) Date & TimeContextual
UTCTODAY()Current UTC (GMT) DateContextual
FORMAT-DATE(val,format)Format Date/Time To StringData Conversion
FORMAT-NUM(val,format)Format Number To StringData Conversion
ROUND(val,places)Rounds a 'val' to the number of 'places'Math
RANDOM(length)Generates a random number or stringMath
=Equal ToLogic
>Greater ThanLogic
ACCRINT(issue,firstInterest,settlement,rate,par,frequency,basis,calcMethod)ACCRINTExcel Financial Functions
ACCRINTM(issue,settlement,rate,par,basis)ACCRINTMExcel Financial Functions
AMORDEGRC(cost,datePurchased,firstPeriod,salvage,period,rate,basis)AMORDEGRCExcel Financial Functions
AMORLINC(cost,datePurchased,firstPeriod,salvage,period,rate,basis)AMORLINCExcel Financial Functions
ANDAndLogic
CBOX(val,matchTo)To CheckBox (Ticked or Crossed)Data Conversion
CBOXB(val,matchTo)To CheckBox (Ticked or Blank)Data Conversion
CEILING(val)Returns the smallest integer value that is greater than or equal to the specified numberMath
COALESCE(val1,val2)First Non-Empty Value (coalesce)Logic
CONCAT(val1,val2,val3)ConcatenateText
COUNT(val)Count ValuesRepeats
COUNT-SELECTED(val)Count Selected ChoicesChoices
COUPDAYBS(settlement,maturity,frequency,basis)COUPDAYBSExcel Financial Functions
COUPDAYS(settlement,maturity,frequency,basis)COUPDAYSExcel Financial Functions
COUPDAYSNC(settlement,maturity,frequency,basis)COUPDAYSNCExcel Financial Functions
COUPNCD(settlement,maturity,frequency,basis)COUPNCDExcel Financial Functions
COUPNUM(settlement,maturity,frequency,basis)COUPNUMExcel Financial Functions
COUPPCD(settlement,maturity,frequency,basis)COUPPCDExcel Financial Functions
CUMIPMT(rate,nper,pv,startPeriod,endPeriod,typ)CUMIPMTExcel Financial Functions
CUMPRINC(rate,nper,pv,startPeriod,endPeriod,typ)CUMPRINCExcel Financial Functions
DATEADD(startdate,numberunits,unit)Add To DateDate/Time
DATEDIFF(startdate,enddate,unit)Difference Between DatesDate/Time
DAY(dateval)Returns the DayDate/Time
DAYWEEK(dateval)Returns the Day of the weekDate/Time
DAYYEAR(dateval)Returns the Day of the yearDate/Time
DB(cost,salvage,life,period,month)DBExcel Financial Functions
DDB(cost,salvage,life,period,factor)DDBExcel Financial Functions
DISC(settlement,maturity,pr,redemption,basis)DISCExcel Financial Functions
DIVDivideMath
DOLLARDE(fractionalDollar,fraction)DOLLARDEExcel Financial Functions
DOLLARFR(decimalDollar,fraction)DOLLARFRExcel Financial Functions
DURATION(settlement,maturity,coupon,yld,frequency,basis)DURATIONExcel Financial Functions
EFFECT(nominalRate,npery)EFFECTExcel Financial Functions
FALSE()FalseLogic
FLOOR(val)Returns the largest integer less than or equal to the specified numberMath
FV(rate,nper,pmt,pv,typ)FVExcel Financial Functions
FVSCHEDULE(principal,schedule)FVSCHEDULEExcel Financial Functions
GUID()Globally Unique IdentifierText
HOUR(dateval)Returns theHourDate/Time
IF(condition,'true val','false val')Conditional (if/else)Logic
INPOLYGON(point,polygonPoints)Whether the given geo-point is within the given polygonLocation
INTRATE(settlement,maturity,investment,redemption,basis)INTRATEExcel Financial Functions
IPMT(rate,per,nper,pv,fv,typ)IPMTExcel Financial Functions
IRR(values,guess)IRRExcel Financial Functions
ISBLANK(val)Is Blank or EmptyLogic
ISPMT(rate,per,nper,pv)ISPMTExcel Financial Functions
JOIN('separator',val1,val2)Concatenate Values With SeperatorRepeats
JOIN('separator',val1,val2)Concatenate With SeperatorText
KMBETWEEN(startPoint,endPoint)Kilometres BetweenLocation
LAT(gpsval)Returns the latitude in decimal degreesLocation
LON(gpsval)Returns the longitude in decimal degreesLocation
LOWER(val)Lower CaseText
MAX(val1,val2)Returns the larger of two numbersMath
MAX(val)Maximum ValueRepeats
MDURATION(settlement,maturity,coupon,yld,frequency,basis)MDURATIONExcel Financial Functions
MIBETWEEN(startPoint,endPoint)Miles BetweenLocation
MIN(val1,val2)Returns the smaller of two numbersMath
MIN(val)Minimum ValueRepeats
MIRR(values,financeRate,reinvestRate)MIRRExcel Financial Functions
MODModuloMath
MONTH(dateval)Returns the MonthDate/Time
NOMINAL(effectRate,npery)NOMINALExcel Financial Functions
NOT(val)NotLogic
NOTBLANK(val)NOT Blank or EmptyLogic
NPER(rate,pmt,pv,fv,typ)NPERExcel Financial Functions
NPV(rate,values)NPVExcel Financial Functions
OROrLogic
PMT(rate,nper,pv,fv,typ)PMTExcel Financial Functions
POSITION(repeatdataname)Repeat PositionRepeats
POW(val,power)PowerMath
PPMT(rate,per,nper,pv,fv,typ)PPMTExcel Financial Functions
PRICE(settlement,maturity,rate,yld,redemption,frequency,basis)PRICEExcel Financial Functions
PRICEDISC(settlement,maturity,discount,redemption,basis)PRICEDISCExcel Financial Functions
PRICEMAT(settlement,maturity,issue,rate,yld,basis)PRICEMATExcel Financial Functions
PV(rate,nper,pmt,fv,typ)PVExcel Financial Functions
RANDOMSTR(length)Generates a random stringText
RATE(nper,pmt,pv,fv,typ,guess)RATEExcel Financial Functions
RECEIVED(settlement,maturity,investment,discount,basis)RATEExcel Financial Functions
REGEX(input,pattern)Regular Expression MatchLogic
SECOND(dateval)Returns the SecondDate/Time
SELECTED(val,'val')Choice Is SelectedChoices
SLN(cost,salvage,life)SLNExcel Financial Functions
STEP-EMAIL('dataname')Step User's EmailProcess Steps
STEP-FIRSTNAME('dataname')Step User First NameProcess Steps
STEP-ISCURRENT('dataname')Is Current StepProcess Steps
STEP-LASTNAME('dataname')Step User Last NameProcess Steps
STEP-RESULT('dataname')Returns the result of the named Process Step fieldProcess Steps
STRING-LENGTH(val)LengthText
SUBSTITUTE(val,old_text,new_text)SubstituteText
SUBSTR(val,startIndex,lengthOptional)SubstringText
SUM(val)Sum ValuesRepeats
SYD(cost,salvage,life,per)SYDExcel Financial Functions
TBILLEQ(settlement,maturity,discount)TBILLEQExcel Financial Functions
TBILLPRICE(settlement,maturity,discount)TBILLPRICEExcel Financial Functions
TBILLYIELD(settlement,maturity,pr)TBILLYIELDExcel Financial Functions
TRUE()TrueLogic
TRUNC(val)Truncates given number value to an integerMath
UPPER(val)Upper CaseText
VDB(cost,salvage,life,startPeriod,endPeriod,factor)VDBExcel Financial Functions
XIRR(values,dates,guess)XIRRExcel Financial Functions
XNPV(rate,values,dates)XIRRExcel Financial Functions
YEAR(dateval)Returns the YearDate/Time
YIELD(settlement,maturity,rate,pr,redemption,frequency,basis)YIELDExcel Financial Functions
YIELDDISC(settlement,maturity,pr,redemption,basis)YIELDDISCExcel Financial Functions
YIELDMAT(settlement,maturity,issue,rate,pr,basis)YIELDMATExcel Financial Functions
{{ [DataName] }}Data NameReturns the result of the given Data Name of the form fieldTemplates
{{!HIDEIFEND}}Must include when using HIDEIFSTARTTemplates
{{!HIDEIFSTART( [True/False] )}}Hides a section dependent on the resultTemplates
{{!HIDEROWIF( [True/False] )}}Hides a row dependent on the resultTemplates
{{!REPEATEND}}Inserted at the end of a sectionTemplates
{{!REPEATROW|[val]}}Inserted at the beginning of a rowTemplates
{{!REPEATROW}}Inserted at the beginning of a rowTemplates
{{!REPEATSTART}}Inserted at the beginning of a sectionTemplates
{{%COMPLETELAT}}Inserts the GPS latitudeTemplates
{{%COMPLETELON}}Inserts the GPS longitudeTemplates
{{%COMPLETEMAP}}Inserts a map image for the GPS co-ordinatesTemplates
{{%COMPLETETIME}}Inserts the date and timeTemplates
{{%ENTRYGUID}}Inserts the unique identifier string of this entryTemplates
{{%ENTRYID}}Inserts the integer number of this entryTemplates
{{%ORGLETTERHEAD}}Inserts your organisation letterhead imageTemplates
{{%ORGNAME}}Inserts the name of your organisationTemplates
{{%STARTTIME}}Inserts the date and time that the userTemplates
{{%USEREMAIL}}Inserts the email address of the userTemplates
{{%USEREXTERNALID}}Inserts the external Id of the userTemplates
{{%USERFIRSTNAME}}Inserts the first name of the userTemplates
{{%USERLASTNAME}}Inserts the last name of the userTemplates
{{CBOX(val,matchTo)}}To CheckBox (Ticked or Crossed)Templates
{{CBOXB(val,matchTo)}}To CheckBox (Ticked or Blank)Templates
Repeats. boolean(). format-num(). utcnow(). userlastname(). cos(). asin(). format-date(). userfirstname(). Location Functions. sinh(). useremail(). tan(). atan(). radians(). cosh(). Logic. round(). sin(). Data Conversion.