• Documentation
Hide navigation
  • Documentation
    • New and Noteworthy
      • January 2023
      • February 2023
      • New and Noteworthy 2022
        • January 2022
        • February 2022
        • March 2022
        • April 2022
        • May 2022
        • June 2022
        • August 2022
        • September 2022
        • October 2022
        • November 2022
        • December 2022
      • New and Noteworthy 2021
        • January 2021
        • February 2021
        • March 2021
        • April 2021
        • May 2021
        • June 2021
        • July 2021
        • August 2021
        • September 2021
        • October 2021
        • November 2021
        • December 2021
      • New and Noteworthy 2020
        • February 2020
        • March 2020
        • April 2020
        • May 2020
        • June 2020
        • July 2020
        • August 2020
        • September 2020
        • October 2020
        • November 2020
        • December 2020
    • Installation and Setup
      • Hero_Cloud
        • Hero_Cloud Install Guide
          • Sign Up for Hero_Cloud
          • Create an Environment
          • Manage Environments
          • Manage Users
          • View Usage Information
          • Account Settings
        • Hero_Cloud Administration and Support
      • Hero Platform_ On-Premises
    • Hero Platform_ Administration Guide
      • Settings and General Information
      • Backup and Restore
      • Certificates
      • Work with Nodes
      • Custom Containerized Functions
      • Custom JavaScript Functions
      • Access
      • External Libraries
    • Hero Platform_ User Guide
      • Get Started with Automation_Hero
        • Log Into Hero Platform_
        • Hero Platform_ Home Screen
        • Hero Platform_ Status Bar
      • Work with Connections
        • Create Connection
          • Create a Cosmos DB Connection
          • Create a File System Connection
          • Create a Gmail Connection
          • Create a Google Calendar Connection
          • Create an IMAP Connection
          • Create a JDBC Connection
          • Create a Kafka Connection
          • Create a Metrics Connection
          • Create a Microsoft Exchange Connection
          • Create a Microsoft Graph Connection
          • Create a MongoDB Connection
          • Create a Process Mining Connection
          • Create a Prototype Connection
          • Create a REST Connection
            • The REST Connection Form
            • REST Connection Example - Finding Definitions for English Words
            • REST Connection Example - Create a REST Connector to JIRA
          • Create a REST Endpoint Connection
            • Rest Endpoint Example
            • Rest Endpoint - Do's and Don'ts
          • Create a RobinSkill Connection
          • Create a Salesforce Connection
          • Create a ServiceNow Connection
          • Create an SMTP Connection
          • Create an SSH Connection
          • Create a Swagger Connection
          • Create a Data Store Connection
        • Edit, Delete, or Clone a Connection
      • Work with Inputs
        • Create Inputs
          • Create a Cosmo DB Input
          • Create a Data Store Input
          • Create a File System Input
            • Work with Parsers
          • Create a Gmail Input
          • Create a Google Calendar Input
          • Create an IMAP Input
          • Create a JDBC Input
          • Create a Kafka Input
          • Create a Microsoft Exchange Input
          • Create a Microsoft Graph Input
          • Create a MongoDB Input
          • Create a Prototype Input
          • Create a REST Input
          • Create a REST Endpoint Input
          • Create a RobinSkill Input
          • Create a Salesforce Input
          • Create a ServiceNow Input
          • Create a Swagger Input
        • Edit, Delete, or Clone an Input
        • Data Types Supported
        • Field Naming
      • Work with Outputs
        • Create Output
          • Create an Automatic Output
          • Create a Cosmos DB Output
          • Create a Data Store Output
          • Create a File System Output
          • Create a Gmail Output
          • Create a JDBC Output
          • Create a Metrics Output
          • Create a Microsoft Exchange Output
          • Create a MongoDB Output
          • Create a Process Mining Output
          • Create a REST Output
            • REST Output Multipart Form-Data Request
            • REST Output Text Request
            • REST Output Parsing Feedback Fields
          • Create a REST Endpoint Output
          • Create a RobinSkill Output
            • RobinSkill Custom Components
          • Create a Salesforce Output
          • Create a ServiceNow Output
          • Create an SMTP Output
          • Create a Swagger Output
        • Edit, Delete, Clone an Output
        • Variable Resolution
      • Work with Documents
        • Work with Fixed Form Document Extraction
        • Work with Invoice Extraction
        • Work with Semi-Structured Document Extraction
          • User Preparation of Training Data for Document Extraction
        • Work with the Classification Wizard
        • Work with the Text Extractor
        • Language Support for Document Extractors
      • Work with Flows
        • Create a Flow
        • Edit, Delete, Clone a Flow
        • Configure a Flow
        • Schedule a Flow
        • See Flow Details
        • Show Run Details
        • Export or Import a Flow
        • Stop a Flow
        • Work with Flow Studio
          • Function List
            • Aggregation
              • Aggregation Function
              • Repartition
              • Unflatten
            • Creators
              • ConstantBoolean
              • ConstantLong
              • ConstantString
              • Multiple Constants
              • Now
              • Rand
              • RandGaussian
              • Today
            • Filter
              • And (Filter)
              • Contains (Filter)
              • DoesNotContain (Filter)
              • DoesNotEndWith (Filter)
              • EndsWith (Filter)
              • Equals (Filter)
              • Formula (Filter)
              • HasError (Filter)
              • If (Filter)
              • IsAfter (Filter)
              • IsBefore (Filter)
              • IsBlank (Filter)
              • IsEmpty (Filter)
              • IsEven (Filter)
              • IsFalse (Filter)
              • IsGreaterThan (Filter)
              • IsGreaterThanOrEqual (Filter)
              • IsLessThan (Filter)
              • IsLessThanOrEqual (Filter)
              • IsNotBlank (Filter)
              • IsNotEmpty (Filter)
              • IsNotNull (Filter)
              • IsNull (Filter)
              • IsOdd (Filter)
              • IsTrue (Filter)
              • NotEquals (Filter)
              • Or (Filter)
            • Flatten
              • BinaryDataBytesToLongFlatten
              • Flatten List
              • Parser
            • Formulas
              • And
              • AsBoolean
              • AsDate
              • AsDouble
              • AsLong
              • AuthorityUrlExtractor
              • Average
              • Base64Encoder
              • Base64ToBinaryDecoder
              • Base64ToStringDecoder
              • Capitalize
              • Ceiling
              • Compare
              • Concat
              • Concat List Items
              • Contains
              • Convert SVG to Image
              • Cosmos DB Data Manipulation
              • Delete Tuple
              • Divide
              • DoesNotContain
              • DoesNotEndWith
              • Download by URL
              • Email Address Parser
              • EmailMainContent
              • EML to PDF
              • EndsWith
              • Equals
              • ErrorMessage
              • Even
              • ExcelToText
              • FilenameUrlExtractor
              • Floor
              • FormatBoolean
              • FormatDate
              • FormatNumber
              • GetTimeDifference
              • HasError
              • HostUrlExtractor
              • Hour
              • If
              • Image to PDF
              • IpToNumber
              • IsAfter
              • IsBefore
              • IsBlank
              • IsEmpty
              • IsEven
              • IsGreaterThan
              • IsGreaterThanOrEqual
              • IsLessThan
              • IsLessThanOrEqual
              • IsNotBlank
              • IsNotEmpty
              • IsNotNull
              • IsNull
              • IsOdd
              • Knowledge Graph
              • Left
              • List
              • ListElement
              • Lower
              • MsToDate
              • Matches
              • Merge PDFs
              • MicrosoftGraphDeleteEmail
              • MicrosoftGraphMarkEmailAsRead
              • MicrosoftGraphMoveEmailToFolder
              • Midnight
              • Millisecond
              • Minimum
              • Minus
              • Minute
              • Mod
              • Month
              • Move File
              • Mround
              • Multiply
              • Negate
              • Ngram
              • Not
              • NotEquals
              • NumberToIp
              • Odd
              • Or
              • ParamUrlExtractor
              • ParamsUrlExtractor
              • PathUrlExtractor
              • PDF Extract Image
              • PDF Extract Text
              • PDF Fill Template
              • PDF To Image
              • PDF With Xfa To Text
              • Plus
              • Power
              • Proper
              • RandBetween
              • RegExtract
              • ReplaceAll
              • ReplaceFirst
              • ReplaceWithArgument
              • Right
              • Round
              • RoundDouble
              • RoundDown
              • RoundTime
              • RoundUp
              • Second
              • Shift Time Zone
              • Size
              • SMTP
              • SplitExtract
              • SplitPDF
              • SQL Data Manipulation
              • StringToBinaryData
              • TokenizeList
              • Trim
              • Tuple to Field
              • Upper
              • UrlDecode
              • UrlEncode
              • Weekday
              • Year
            • Lookup
              • Cosmos DB Lookup
              • Fetch Salesforce Content
              • File Lookup
              • MicrosoftGraph Lookup
              • MongoDB Aggergation Lookup
              • MongoDB Find Lookup
              • REST Lookup
              • Salesforce Lookup
              • SQL Lookup
              • SSH Lookup
              • Swagger Lookup
            • Output
            • Documents
              • Multiple OCR Functions
            • Procedure
              • ErrorHandler (Beta)
              • Propagation Delay
              • WriteLogs
      • Work with the Data Store
    • Hero_Insights User's Guide
      • Getting Started with Insights
      • Work with Insights
        • Insights Metrics
        • Insights Process Map
    • Library
    • Robin User's Guide
      • Robin Skill Builders
      • Robin End Users
      • Peanut Butter and Jelly Sandwich Instruction Guide
    • Compliance
    • Automation Hero Support
Show navigation

Formulas

Formulas are ready made functions used to carryout specific calculations on your data. 

  • And
  • AsBoolean
  • AsDate
  • AsDouble
  • AsLong
  • AuthorityUrlExtractor
  • Average
  • Base64Encoder
  • Base64ToBinaryDecoder
  • Base64ToStringDecoder
  • Capitalize
  • Ceiling
  • Compare
  • Concat
  • Concat List Items
  • Contains
  • Convert SVG to Image
  • Cosmos DB Data Manipulation
  • Delete Tuple
  • Divide
  • DoesNotContain
  • DoesNotEndWith
  • Download by URL
  • Email Address Parser
  • EmailMainContent
  • EML to PDF
  • EndsWith
  • Equals
  • ErrorMessage
  • Even
  • ExcelToText
  • FilenameUrlExtractor
  • Floor
  • FormatBoolean
  • FormatDate
  • FormatNumber
  • GetTimeDifference
  • HasError
  • HostUrlExtractor
  • Hour
  • If
  • Image to PDF
  • IpToNumber
  • IsAfter
  • IsBefore
  • IsBlank
  • IsEmpty
  • IsEven
  • IsGreaterThan
  • IsGreaterThanOrEqual
  • IsLessThan
  • IsLessThanOrEqual
  • IsNotBlank
  • IsNotEmpty
  • IsNotNull
  • IsNull
  • IsOdd
  • Knowledge Graph
  • Left
  • List
  • ListElement
  • Lower
  • MsToDate
  • Matches
  • Merge PDFs
  • MicrosoftGraphDeleteEmail
  • MicrosoftGraphMarkEmailAsRead
  • MicrosoftGraphMoveEmailToFolder
  • Midnight
  • Millisecond
  • Minimum
  • Minus
  • Minute
  • Mod
  • Month
  • Move File
  • Mround
  • Multiply
  • Negate
  • Ngram
  • Not
  • NotEquals
  • NumberToIp
  • Odd
  • Or
  • ParamUrlExtractor
  • ParamsUrlExtractor
  • PathUrlExtractor
  • PDF Extract Image
  • PDF Extract Text
  • PDF Fill Template
  • PDF To Image
  • PDF With Xfa To Text
  • Plus
  • Power
  • Proper
  • RandBetween
  • RegExtract
  • ReplaceAll
  • ReplaceFirst
  • ReplaceWithArgument
  • Right
  • Round
  • RoundDouble
  • RoundDown
  • RoundTime
  • RoundUp
  • Second
  • Shift Time Zone
  • Size
  • SMTP
  • SplitExtract
  • SplitPDF
  • SQL Data Manipulation
  • StringToBinaryData
  • TokenizeList
  • Trim
  • Tuple to Field
  • Upper
  • UrlDecode
  • UrlEncode
  • Weekday
  • Year


Get Started

Search

    Powered by Instant Websites for Confluence