Home Search

DriveWorks Pro 19
Functions

Send Feedback

Functions

The following is an index of all functions available from the Rules Builder.

This does not include any functions installed with any plugin.

All functions are listed by clicking the Functions button from the command bar of the Rules Builder.

Function category headers are collapsible. Double click the category header or use the arrow on the right hand side to collapse or expand the contents of the category.

Right click in the function area to expand or collapse all the category headers.

Show Function Categories

Check this option to view functions alphabetically by category. If you know the name of the function that you're looking for you may prefer to leave this option unchecked.

The chart below lists all functions available in DriveWorks.

Full Function List

3DConversionCryptography
PreviewGetDistanceBase64EncodeHashHMACSHA1
PreviewGetDocumentSceneColorHexToNumbersHashMD5
PreviewGetNodeSuppressionStateUrlDecodeHashSHA1
PreviewGetNodeTransformUrlEncodeHashSHA256
HTMLDecode
HTMLEncode
DatabaseDate and TimeFile System
DBExecuteDateFsChangeExtension
DbQueryDateTimeFsDirectoryExists
QueryDataDateTimeLocalFsFileExists
QueryDataValuesDateTimeSpanFsGetDirectories
DateValue
DayFsGetDirectoryName
HourFsGetExtension
MinuteFsGetFileName
MonthFsGetFiles
NetWorkDaysFsGetFullPath
NetWorkDaysCustomFsGetFullPathGroupContent
NowFsGetFullPathProject
NowUTCFsGetFullPathSpecification
SecondFsGetUrl
TimeValueFsPathCombine
Today
UnixEpoch
Weekday
WeekNum
WorkDay
WorkDayCustom
Year
GroupHelperList
GetGroupCapturedComponentsColorList
GetGroupConnectionsColorHexListCountItems
GetGroupNameDimensionTextListFindItem
GetGroupReleasedDocumentsDimensionTextAllListGetCommon
GetGroupReleasedModelsEmailGetDomainNameListGetItem
GetGroupSettingEmailGetUserNameListGetItems
GetGroupSpecificationsGetApplicationNameListGetUnique
GetAutopilotLog
GetAutopilotStatus
GetDriveWorksVersionListJoin
SecurityGetNumericSuffixListMaxValue
SecGetAllTeamsIfEmptyListRemoveDuplicates
SecGetAllUsersJsonEscapeListRemoveEmpty
SecGetTeamDriveAppsMyNameListRemoveIndex
SecGetTeamProjectsMyNumberListRemoveItem
SecGetTeamsForUserTextBuilderListReplaceIndex
SecGetUsersInTeamXPathGetListReplaceItem
SecIsCurrentUserInTeamXPathJsonGetListReverse
SecIsUserInTeamXPathXMLGetListSort
ListSum
LogicalMathPDMPro Plugin
AndAbsPDMGetFileDataCardValues
BooleanACosPDMGetFolderDataCardValues
ChooseFromACosDPDMGetSerialNumberNames
IfACosHPDMBasicSearch
IfConditionAngleAbs
NotAngleAbsD
OrASin
ASinD
ASinH
ATan
ATan2
ATanD
ATanH
Ceiling
Choose
Cos
CosD
CosH
Degrees
Even
Exp
Fact
FactDouble
Floor
Int
IsEven
IsOdd
Ln
Log
Log10
Max
Min
Mod
MRound
Odd
Pi
Power
Product
Quotient
Radians
Rand
RandBetween
Round
RoundDown
RoundUp
Sign
Sin
SinD
SinH
Sqrt
SqrtPi
Sum
Tan
TanD
TanH
Trunc
SpecificationTableText
SpGetCurrentStateCountIFChar
SpGetSpecificationIdCSVFromTableConcatenate
SpGetStateDcountDollar
SpGetStatesDMaxExact
SpGetTransitionsAndOperationsDMinExtractNumber
DWHLookupFind
DWVLookupFixed
GetDataIndirect
GetTableValueLeft
HLookupLen
ListAllLower
ListAllConditionalMid
ListAllConditionalDistinctNewLine
ListAllDistinctNumber
SumTableColumnNumberLocal
TableAppendColumnsProper
TableAppendRowReplace
TableAppendRowsRept
TableAverageRight
TableBreakSearch
TableColumnString
TableCombineStringJoin
TableDistinctStringLocal
TableDistinctCountSubstitute
TableDistinctSumText
TableFilterTextFormat
TableFilterAllTrim
TableFilterByListTrimEnd
TableFormatTrimStart
TableFromCsvUpper
TableFromListValue
TableGetColumnCountValueLocal
TableGetColumnIndexByName
TableGetDataRows
TableGetHeaderRow
TableGetRowCount
TableGetRows
TableGetValue
TableJoin
TableMax
TableMaxValue
TableMin
TableMinValue
TableRemoveBlankColumns
TableRemoveBlankRows
TableRemoveRow
TableReplaceHeaderRow
TableReplaceHeaders
TableReplaceRow
TableReverse
TableRow
TableSearch
TableSelectColumns
TableSequence
TableSkipRows
TableSort
TableSortByDate
TableSortByList
TableSubstitute
TableSum
TableTakeRows
TableTranspose
TableWithSequence
VLookup
ValidationVariablesVector
IfEmptyVariableGetUniqueNumberEulerCombine
IfErrorVariableSumEulerInverse
IferrorStringVariableSumMultiplyVectorAbs
IfNonBooleanVectorAdd
IfNonNumberVectorAngle
IsBooleanVectorClamp
IsEmptyVectorCross
IsErrorVectorDivide
IsErrorStringVectorDot
IsMatchVectorLength
IsNonBooleanVectorLerp
IsNonNumberVectorLookAt
IsNonTextVectorMax
IsNumberVectorMin
IsTextVectorMultiply
IsValidDirectoryVectorNegate
IsValidEmailAddressVectorNormalize
IsValidFileNameVectorRotateAroundAxis
IsValidFileNameResultVectorRotateAroundPoint
IsValidPathVectorScale
IsValidRelativePathResultVectorSignedAngle
VectorSubtract