{"id":1362,"date":"2026-03-18T08:44:27","date_gmt":"2026-03-18T08:44:27","guid":{"rendered":"https:\/\/onesystemcrm.com\/help\/?post_type=docs&p=1362"},"modified":"2026-03-18T08:44:27","modified_gmt":"2026-03-18T08:44:27","password":"","slug":"workflow-action-number-formatter","status":"publish","type":"docs","link":"https:\/\/onesystemcrm.com\/help\/Supports\/workflow-action-number-formatter\/","title":{"rendered":"Workflow Action – Number Formatter"},"content":{"rendered":"

Overview<\/h2>\n

The\u00a0Number Formatter<\/strong>\u00a0workflow action is used to format and generate numeric fields. It includes several functionalities like converting text to numbers, formatting numbers, formatting phone numbers, formatting currency, and generating random numbers.<\/p>\n

Action Name<\/h2>\n

Number Formatter<\/strong><\/p>\n

Action Details<\/h2>\n

Text to Number<\/h3>\n

Converts text representations of numbers into numeric format. For example, “$12,345.67” to 12345.67.<\/p>\n

<\/p>\n

<\/h4>\n

Action Details:<\/h3>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
Field<\/td>\nDescription<\/td>\nMandatory<\/td>\n<\/tr>\n
Action Name<\/td>\nThe name of the action, which can be customized.<\/td>\nYes<\/td>\n<\/tr>\n
Action Type<\/td>\nDefines the action, set as Text to Number.<\/td>\nYes<\/td>\n<\/tr>\n
Select Field<\/td>\nChoose the field containing the text representation of a number.<\/td>\nYes<\/td>\n<\/tr>\n
Input Decimal Mark<\/td>\nSpecifies how the decimal is marked in the input (e.g., period).<\/td>\nYes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Example Workflow Configuration:<\/h3>\n
    \n
  • Trigger:<\/strong>\u00a0Form Submitted<\/li>\n
  • Action:<\/strong>\u00a0Convert text to number to process payment data accurately.<\/li>\n<\/ul>\n

    ———————————————————————————————————————-<\/p>\n

    Format Number<\/h3>\n

    Formats a number according to the defined settings, such as decimal places and thousands separators.<\/p>\n

    <\/p>\n

    Action Details<\/h3>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
    Field<\/td>\nDescription<\/td>\nMandatory<\/td>\n<\/tr>\n
    Action Name<\/td>\nThe name of the action, which can be customized.<\/td>\nYes<\/td>\n<\/tr>\n
    Action Type<\/td>\nDefines the action, set as Format Number.<\/td>\nYes<\/td>\n<\/tr>\n
    Select Field<\/td>\nChoose the field containing the number.<\/td>\nYes<\/td>\n<\/tr>\n
    Input Decimal Mark<\/td>\nDefines the current decimal mark used in the input number.<\/td>\nYes<\/td>\n<\/tr>\n
    To Format<\/td>\nThe desired output format for the number (e.g., period).<\/td>\nYes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Example Workflow Configuration:<\/h3>\n
      \n
    • Trigger:<\/strong>\u00a0Trigger link clicked<\/li>\n
    • Action:<\/strong>\u00a0Format number for displaying statistical data in messages.<\/li>\n<\/ul>\n

      ———————————————————————————————————————-<\/p>\n

      Format Phone Number<\/h3>\n

      Standardises a phone number into the desired format (e.g., (123) 456-7890).<\/p>\n

      <\/h4>\n

      <\/p>\n

      Action Details:<\/h3>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
      Field<\/td>\nDescription<\/td>\nMandatory<\/td>\n<\/tr>\n
      Action Name<\/td>\nThe name of the action, which can be customized.<\/td>\nYes<\/td>\n<\/tr>\n
      Action Type<\/td>\nDefines the action, set as Format Phone Number.<\/td>\nYes<\/td>\n<\/tr>\n
      Select Field<\/td>\nChoose the field containing the phone number.<\/td>\nYes<\/td>\n<\/tr>\n
      To Format<\/td>\nThe desired format for the phone number (e.g., E.164).<\/td>\nYes<\/td>\n<\/tr>\n
      Phone Number Country Code<\/td>\nSpecifies the country for the phone number.<\/td>\nYes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      Example Workflow Configuration:<\/h3>\n
        \n
      • Trigger:<\/strong>\u00a0Appointment Booked<\/li>\n
      • Action:<\/strong>\u00a0Format the contact’s phone number for outbound calls.<\/li>\n<\/ul>\n

        ———————————————————————————————————————-<\/p>\n

        Format Currency<\/h3>\n

        Formats a numeric value as currency, taking into account locale-specific settings.<\/p>\n

        <\/p>\n

        Action Details<\/h3>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
        Field<\/td>\nDescription<\/td>\nMandatory<\/td>\n<\/tr>\n
        Action Name<\/td>\nThe name of the action, which can be customized.<\/td>\nYes<\/td>\n<\/tr>\n
        Action Type<\/td>\nDefines the action, set as Format Currency.<\/td>\nYes<\/td>\n<\/tr>\n
        Select Field<\/td>\nChoose the field containing the numeric value.<\/td>\nYes<\/td>\n<\/tr>\n
        Currency<\/td>\nThe currency type (e.g., USD, EUR).<\/td>\nYes<\/td>\n<\/tr>\n
        Currency Locale<\/td>\nThe locale format for the currency (e.g., en-US).<\/td>\nYes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Example Workflow Configuration:<\/h3>\n
          \n
        • Trigger:<\/strong>\u00a0Payment Received<\/li>\n
        • Action:<\/strong>\u00a0Format currency for generating accurate receipts.<\/li>\n<\/ul>\n

          ———————————————————————————————————————-<\/p>\n

          Random Number<\/h3>\n

          Generates a random number within a specified range.<\/p>\n

          <\/h4>\n

          <\/p>\n

          Action Details<\/h3>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
          Field<\/td>\nDescription<\/td>\nMandatory<\/td>\n<\/tr>\n
          Action Name<\/td>\nThe name of the action, which can be customized.<\/td>\nYes<\/td>\n<\/tr>\n
          Action Type<\/td>\nDefines the action, set as Random Number.<\/td>\nYes<\/td>\n<\/tr>\n
          Lower Range<\/td>\nThe minimum value of the generated random number.<\/td>\nYes<\/td>\n<\/tr>\n
          Upper Range<\/td>\nThe maximum value of the generated random number.<\/td>\nYes<\/td>\n<\/tr>\n
          Decimal Points<\/td>\nDefines how many decimal points are allowed.<\/td>\nNo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

          Example Workflow Configuration:<\/h3>\n
            \n
          • Trigger:<\/strong>\u00a0Email Opened<\/li>\n
          • Action:<\/strong>\u00a0Generate a random number for A\/B testing purposes.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

            Overview The\u00a0Number Formatter\u00a0workflow action is used to format and generate numeric fields. It includes several functionalities like converting text to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_category":[64],"doc_tag":[],"class_list":["post-1362","docs","type-docs","status-publish","hentry","doc_category-workflow-actions"],"year_month":"2026-07","word_count":488,"total_views":"11","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"usamasaeed219","author_nicename":"usamasaeed219","author_url":"https:\/\/onesystemcrm.com\/help\/author\/usamasaeed219\/"},"doc_category_info":[{"term_name":"Workflow Actions","term_url":"https:\/\/onesystemcrm.com\/help\/Supports-category\/workflow-actions\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/comments?post=1362"}],"version-history":[{"count":1,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1362\/revisions"}],"predecessor-version":[{"id":1363,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/docs\/1362\/revisions\/1363"}],"wp:attachment":[{"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/media?parent=1362"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/doc_category?post=1362"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/onesystemcrm.com\/help\/wp-json\/wp\/v2\/doc_tag?post=1362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}