User Guide Cancel

Add calculated fields to a form

 

Adobe Acrobat Sign Guide

What's New

  1. Pre-Release Notes
  2. Release Notes
  3. Important Notifications

Get Started

  1. Quick start guide for administrators
  2. Quick start guide for users
  3. For Developers
  4. Video tutorial library
  5. FAQ

Administer

  1. Admin Console Overview
  2. User Management
    1. Adding users
      1. Add a User
      2. Add Users in Bulk
      3. Add Users from your Directory
      4. Add Users from MS Azure Active Directory
    2. Create function-focused users
      1. Technical accounts - API driven
      2. Service accounts - Manually driven
    3. Check for users with provisioning errors
    4. Change Name/Email Address
    5. Edit a user's group membership
    6. Edit a user's group membership through the group interface
    7. Promote a user to an admin role
    8. User Identity Types and SSO
    9. Switch User Identity
    10. Authenticate Users with MS Azure
    11. Authenticate Users with Google Federation
    12. Product Profiles
    13. Login Experience 
  3. Account/Group Settings
    1. Settings Overview
    2. Global Settings
      1. Account tier and ID
      2. New Recipient Experience
      3. Self Signing Workflows
      4. Send in Bulk
      5. Web Forms
      6. Custom Send Workflows
      7. Power Automate Workflows
      8. Library Documents
      9. Collect form data with agreements
      10. Limited Document Visibility
      11. Attach a PDF copy of the signed agreement 
      12. Include a link in the email
      13. Include an image in the email
      14. Files attached to email will be named as
      15. Attach audit reports to documents
      16. Merge multiple documents into one
      17. Download individual documents
      18. Upload a signed document
      19. Delegation for users in my account
      20. Allow external recipients to delegate
      21. Authority to sign
      22. Authority to send
      23. Power to add Electronic Seals
      24. Set a default time zone
      25. Set a default date format
      26. Users in Multiple Groups (UMG)
        1. Upgrade to use UMG
      27. Group Administrator Permissions
      28. Replace recipient
      29. Audit Report
        1. Overview
        2. Allow unauthenticated access on the transaction verification page
        3. Include reminders
        4. Include view events
        5. Include agreement page/attachment count
      30. In Product Messaging and Guidance
      31. Accessible PDFs
      32. New authoring experience
      33. Healthcare customer
    3. Account Setup
      1. Add logo
      2. Customize company Hostname/URL    
      3. Add company name
      4. Post agreement URL redirect
    4. Signature Preferences
      1. Well formatted signatures
      2. Allow recipients to sign by
      3. Signers can change their name
      4. Allow recipients to use their saved signature
      5. Custom Terms of Use and Consumer Disclosure
      6. Navigate recipients through form fields
      7. Decline to sign
      8. Allow Stamps workflows
      9. Require signers to provide their Title or Company
      10. Allow signers to print and place a written signature
      11. Show messages when e-signing
      12. Require signers to use a mobile device to create their signature
      13. Request IP address from signers
      14. Exclude company name and title from participation stamps
    5. Digital Signatures
      1. Overview
      2. Download and sign with Acrobat
      3. Sign with Cloud Signatures
      4. Include metadata for Identity Providers
      5. Restricted Cloud Signatures Providers
    6. Electronic Seals
    7. Digital Identity
      1. Digital Identity Gateway
      2. Identity Check policy
    8. Report Settings
      1. New report experience
      2. Classic report settings
    9. Security Settings
      1. Single Sign-on settings
      2. Remember-me settings
      3. Login password policy
      4. Login password strength
      5. Web session duration
      6. PDF encryption type
      7. API
      8. User and group info access
      9. Allowed IP Ranges
      10. Account Sharing
      11. Account sharing permissions
      12. Agreement sharing controls
      13. Signer identity verification
      14. Agreement signing password
      15. Document password strength
      16. Block signers by Geolocation
      17. Phone Authentication
      18. Knowledge-Based Authentication (KBA)
      19. Allow page extraction
      20. Document link expiration
      21. Upload a client certificate for webhooks/callbacks
      22. Timestamp
    10. Send settings
      1. Show Send page after login
      2. Require recipient name when sending
      3. Lock name values for known users
      4. Allowed recipient roles
      5. Allow e-Witnesses
      6. Recipient groups
      7. Required fields
      8. Attaching documents
      9. Field flattening
      10. Modify Agreements
      11. Agreement name
      12. Languages
      13. Private messages
      14. Allowed signature types
      15. Reminders
      16. Signed document password protection
      17. Send Agreement Notification through
      18. Signer identification options
        1. Overview
        2. Signing password
        3. One-Time Password via Email
        4. Acrobat Sign authentication
        5. Phone authentication
        6. Cloud-based digital signature
        7. Knowledge-based authentication
        8. Government ID
        9. Signer Identity reports
      19. Content Protection
      20. Enable Notarize transactions
      21. Document Expiration
      22. Preview, position signatures, and add fields
      23. Signing order
      24. Liquid mode
      25. Custom workflow controls
      26. Upload options for the e-sign page
      27. Post-sign confirmation URL redirect
    11. Message Templates
    12. Bio-Pharma Settings
      1. Overview
      2. Enforce identity authentication
      3. Signing reasons
    13. Workflow Integration
    14. Notarization Settings
    15. Payments Integration
    16. Signer Messaging
    17. SAML Settings
      1. SAML Configuration
      2. Install Microsoft Active Directory Federation Service
      3. Install Okta
      4. Install OneLogin
      5. Install Oracle Identity Federation
    18. Data Governance
    19. Time Stamp Settings
    20. External Archive
    21. Account Languages
    22. Email Settings
      1. Email header/footer images
      2. Permit individual user email footers
      3. Customize the Signature Requested email
      4. Customize the To and CC fields
      5. Enable Linkless Notifications
      6. Customize email templates
    23. Migrating from echosign.com to adobesign.com
    24. Configure Options for Recipients
  4. Guidance for regulatory requirements
    1. Accessibility
      1. Accessibility Compliance
      2. Create accessible forms with Acrobat desktop
      3. Create accessible AcroForms
    2. HIPAA
    3. GDPR
      1. GDPR Overview
      2. Redact a user
      3. Redact a user's agreements    
    4. 21 CFR part 11 and EudraLex Annex 11
      1. 21 CRF part 11 validation pack
      2. 21 CFR and EudraLex Annex 11 handbook
      3. Analysis of shared responsibilities
    5. Healthcare customers
    6. IVES support
    7. "Vaulting" agreements
    8. EU/UK considerations
      1. EU/UK Cross-border transactions and eIDAS
      2. HMLR requirements for deeds signed electronically
      3. The impact of Brexit on e-signature laws in the UK
  5. Download Agreements in Bulk
  6. Claim your domain 
  7. Report Abuse links

Send, Sign, and Manage Agreements

  1. Recipient Options
    1. Cancel an email reminder
    2. Options on the e-signing page
      1. Overview of the e-sign page
      2. Open to read the agreement without fields
      3. Decline to sign an agreement
      4. Delegate signing authority
      5. Restart the agreement
      6. Download a PDF of the agreement
      7. View the agreement history
      8. View the agreement messages
      9. Convert from an electronic to a written signature
      10. Convert from a written to an electronic signature 
      11. Navigate the form fields
      12. Clear the data from the form fields
      13. E-sign page magnification and navigation
      14. Change the language used in the agreement tools and information
      15. Review the Legal Notices
      16. Adjust Acrobat Sign Cookie Preferences
  2. Send Agreements  
    1. Send page overview
    2. Send an agreement only to yourself
    3. Send an agreement to others
    4. Written Signatures
    5. Recipient signing order
    6. Send in Bulk
      1. Overview of the Send in Bulk feature
      2. Send in Bulk - Configure a parent template
      3. Send in Bulk - Configure the CSV file
      4. Cancel a Send in Bulk transaction
      5. Add reminders to Send in Bulk
      6. Reporting for Send in Bulk
  3. Authoring fields into documents
    1. In-app authoring environment
      1. Automatic field detection
      2. Drag and drop fields using the authoring environment
      3. Assign form fields to recipients
      4. The Prefill role
      5. Apply fields with a reusable field template
      6. Transfer fields to a new library template
      7. Updated authoring environment when sending agreements
    2. Create forms with text tags
    3. Create forms using Acrobat (AcroForms)
      1. AcroForm creation
      2. Creating accessible PDFs
    4. Fields
      1. Field types
        1. Common field types
        2. In-line Images
        3. Stamp Images
      2. Field content appearance
      3. Field validations
      4. Masked fields values
      5. Setting show/hide conditions
      6. Calculated fields 
    5. Authoring FAQ
  4. Sign Agreements
    1. Sign agreements sent to you
    2. Fill & Sign
    3. Self-signing
  5. Manage Agreements
    1. Manage page overview
    2. Delegate agreements
    3. Replace Recipients
    4. Limit Document Visibility 
    5. Cancel an Agreement 
    6. Create new reminders
    7. Review reminders
    8. Cancel a reminder
    9. Access Power Automate flows
    10. More Actions...
      1. How search works
      2. View an agreement
      3. Create a template from an agreement
      4. Hide/Unhide agreements from view
      5. Upload a signed agreement
      6. Modify a sent agreement's files and fields
      7. Edit a recipient's authentication method
      8. Add or modify an expiration date
      9. Add a Note to the agreement
      10. Share an individual agreement
      11. Unshare an agreement
      12. Download an individual agreement
      13. Download the individual files of an agreement
      14. Download the Audit Report of an agreement
      15. Download the field content of an agreement
  6. Audit Report
  7. Reporting and Data exports
    1. Overview
    2. Grant users access to reporting
    3. Report charts
      1. Create a new report
      2. Agreement Reports
      3. Transaction Reports
      4. Settings Activity Report
      5. Edit a report
    4. Data Exports 
      1. Create a new data export
      2. Edit a data export
      3. Refresh the data export content
      4. Download the data export
    5. Rename a report/export
    6. Duplicate a report/export
    7. Schedule a report/export
    8. Delete a report/export
    9. Check Transaction Usage

Advanced Agreement Capabilities and Workflows

  1. Webforms 
    1. Create a web form
    2. Edit a web form
    3. Disable/Enable a web form
    4. Hide/Unhide a web form
    5. Find the URL or script code 
    6. Prefill web form fields with URL parameters
    7. Save a web form to complete later
    8. Resize a web form
  2. Reusable Templates (Library templates) 
    1. US Government forms in the Acrobat Sign library
    2. Create a library template
    3. Change a library template's name
    4. Change a library template's type
    5. Change a library template's permission level
    6. Copy, edit, and save a shared template
    7. Download the aggregate field data for a library template
  3. Transfer ownership of web forms and library templates
  4. Power Automate Workflows 
    1. Overview of the Power Automate integration and included entitlements
    2. Enable the Power Automate integration
    3. In-Context Actions on the Manage page
    4. Track Power Automate usage
    5. Create a new flow (Examples)
    6. Triggers used for flows
    7. Importing flows from outside Acrobat Sign
    8. Manage flows
    9. Edit flows
    10. Share flows
    11. Disable or Enable flows
    12. Delete flows
    13. Useful Templates
      1. Administrator only
        1. Save all completed documents to SharePoint
        2. Save all completed documents to OneDrive for Business
        3. Save all completed documents to Google Drive
        4. Save all completed documents to DropBox
        5. Save all completed documents to Box
      2. Agreement archival
        1. Save your completed documents to SharePoint
        2. Save your completed documents to One Drive for Business
        3. Save your completed documents to Google Drive
        4. Save your completed documents to DropBox
        5. Save your completed documents to Box
      3. Webform agreement archival
        1. Save completed web form documents to SharePoint Library
        2. Save completed web form documents to OneDrive for Business
        3. Save completed   documents to Google Drive
        4. Save completed web form documents to Box
      4. Agreement data extraction
        1. Extract form field data from your signed document and update Excel sheet
      5. Agreement notifications
        1. Send custom email notifications with your agreement contents and signed agreement
        2. Get your Adobe Acrobat Sign notifications in a Teams Channel
        3. Get your Adobe Acrobat Sign notifications in Slack
        4. Get your Adobe Acrobat Sign notifications in Webex
      6. Agreement generation
        1. Generate document from Power App form and Word template, send for signature
        2. Generate agreement from Word template in OneDrive, and get signature
        3. Generate agreement for selected Excel row, send for review and signature
  5. Custom Send workflows
    1. Custom Send Workflow Overview
    2. Creating a new Send Workflow
    3. Edit a Send Workflow
    4. Activate or Deactivate a Send Workflow
    5. Send an agreement with a Send Workflow
  6. Share users and agreements
    1. Share a user
    2. Share agreements

Integrate with other products

  1.  Acrobat Sign integrations overview 
  2. Acrobat Sign for Salesforce
  3. Acrobat Sign for Microsoft
    1. Acrobat Sign for Microsoft 365
    2. Acrobat Sign for Outlook
    3. Acrobat Sign for Word/PowerPoint
    4. Acrobat Sign for Teams
    5. Acrobat Sign for Microsoft PowerApps and Power Automate
    6. Acrobat Sign Connector for Microsoft Search
    7. Acrobat Sign for Microsoft Dynamics 
    8. Acrobat Sign for Microsoft SharePoint 
  4. Other Integrations
    1. Acrobat Sign for ServiceNow
    2. Acrobat Sign for HR ServiceNow
    3. Acrobat Sign for SAP SuccessFactors
    4. Acrobat Sign for Workday
    5. Acrobat Sign for NetSuite
    6. Acrobat Sign for VeevaVault
    7. Acrobat Sign for Coupa BSM Suite
  5. Partner managed integrations
  6. How to obtain an integration key

Acrobat Sign Developer

  1. REST APIs 
    1. Methods documentation
    2. SDK/Developer Guide
    3. API FAQ    
  2. Webhooks 
    1. Webhook overview
    2. Configure a new webhook
    3. View or edit a webhook
    4. Deactivate or reactivate a webhook
    5. Delete a webhook
    6. Two-way SSL certificates
    7. Webhooks in the API

Support and Troubleshooting

  1. Customer Support Resources 
  2. Enterprise Customer Success Resources 

Calculated fields are part of Advanced forms, and as such, are included only with the multi-license levels of service.


Overview

Adobe Acrobat Sign provides the ability to dynamically update the fields in a document (agreement) based on the data entered by the signer when the agreement is signed. This can be done using Calculated Fields. You can use calculated fields to set up rules within a document (or a document template) before sending it out for signature. These rules get processed when the signer interacts with the document and dynamically updates the document based on the fields/values.

Calculated fields can be defined within documents using any of the following mechanisms:


Calculated Fields Use Cases

Calculated fields can be used for any scenarios where the document needs to be dynamically updated at time of signing. Below are a few sample use cases where calculated fields can be used. These use cases are for illustration purpose only.

1. Setting up an Order Form—Calculated fields can be used to set up an order form in which the signer has the option to select from a list of available items and specify a quantity. Selecting an item from the list automatically updates the form with the price for the selected item. The quantity selected by the signer also results in the total cost of the item being calculated automatically. The form can also incorporate additional calculations for determining total tax due on the order or calculating a volume discount based on the business rules for offering discounts to customers.

2. Automatically populating contract term expiration date—For agreements that allow customers to choose the length of term of the contract at time of signing (6 months, 12 months, 24 months, etc.), a calculated field can be used to automatically populate the end date for the contract based on the selection made by the customer at time of signing the contract.

3. Sign up forms with multiple choices—A calculated field can be used to set up sign-up forms (such as membership forms) where the person signing the form can choose from a set of available options. The choices made by the signer can drive other dynamic aspects of forms, such as the terms the signer is agreeing to, the duration of the contract, and also the total cost.


Calculated Fields Basics

Any form field, checkbox field, or radio button field in an Acrobat Sign form can be marked as a calculated field. At the time of signing, the signer cannot directly enter a value into a field designated as a calculated field, the value of the field gets automatically calculated based on the rules defined in the form.

A calculated field definition consists of two parts: the expression and the format.

Expression

Required

Defines the formula/rule on how the value of the designated field gets calculated. Acrobat Sign evaluates the expression at time of signing and the resulting value is displayed in the field.

Format

Optional

The resulting value of a calculated field can also be formatted as a date, number, or currency by specifying a format.

Calculated fields can be defined using Acrobat Sign text tags, using the Acrobat Sign web application, or using PDF form fields. When using the Acrobat Sign text tags or PDF form fields to define calculated fields, the expression for the calculation is defined using a directive called “calc”. Formatting of the calculated field can be specified using a directive called “format”.

Example

{{someCalculatedField_es_:signer1:calc(someExpn):format(formatType, someFormat)}}

This example shows text tags being used to define a field within a document called “someCalculatedField”. This field is assigned to the recipient identified as signer1. The value of this field is calculated based on the formula specified in “someExpn”. The type of the resulting value is specified by the parameter “formatType” and formatted based on the format defined as “someFormat”.

The Acrobat Sign web application’s authoring environment provides a fully functional expression builder for defining formulas for calculated fields. See Using Expression Builder For Specifying Calculated Fields for more details on building expressions.


Calculated Field Expressions

The expression defines the formula/rule for determining the value of the calculated field. An expression can consist of one or more of the following elements:

Literal

Specifies an actual value that gets used as part of the expression. Expressions can be string values, numbers, or dates. For example:

  • {{helloField_es_:signer1:calc(“Hello”)}} – This literal sets the value of the field called “helloField” to Hello.
  • {{numField_es_:signer1:calc(10)}} – This literal sets the value of the field called “numField”  to 10.
  • {{date_es_:isdate(format="mmm d, yyyy")}} - This literal includes a comma, which is a special delimiter. For the comma to be part of the formatted string, the expression must be cast as a literal value.
  • {{date_es_:isdate(format='d "day of" mmmm, yyyy')}} - It is possible to insert a literal string of characters into a date calculation.  The literal string must be enclosed in either single or double quotes. 
    • The above calculation would produce a string like:  12 day of December, 2012

Strings that need to be included in an expression must be surrounded in quotes (either double (") or single (')). If the resulting value needs to include a quote (either a single quote or a double quote), this can be achieved by using a back slash (\) to close the quote.

Important Note: For all examples going forward, only the expression will be shown, the complete syntax for the text tag will not be shown.

Operators

Operators are used to perform one or more operations as part of the expression. For example:

• 6 + 4 – This operator results in the value of 10 being populated in the calculated field.

• 5/22/2016 - 3 – This operator results in the value of 5/19/2016 being populated in the calculated field.

See Supported Operators for a list of the operators supported within expressions.

Fields

Existing fields within a document can be used to define an expression by referring to the field by its name. The fields can be Acrobat Sign fields (such as: Signature, Date Field, Signer Name, Signer Company, etc.) or fields defined within the document or other calculated fields. For example:

• price * quantity – This expression references two other fields within the document called “price” and “quantity”. The result of the multiplication of the values of these two fields will be populated in the Calculated Field.

• signerName & “employee of “ & signerCompany – This expression references two fields within the document “signerName” and “signerCompany” which get pre-populated by Acrobat Sign if available and concatenates them together. If the signer’s name is “Casey Jones” and the signer’s company is “Acme Corp”, this expression will result in a value of “Casey Jones employee of Acme Corp” being populated in the calculated field.

If a field name contains a space, the field name must be placed within a square bracket ([]) to be able to reference it in an expression. For example [field name with spaces] will reference a field in the document called “field name with spaces”.

Functions

Expressions can also include one or more functions from the Acrobat Sign list of supported functions. The specified functions get evaluated during the agreement signing process and the resulting value gets displayed in the calculated field. For example:

• dateAdd(d, signedDate, 3)– This expression uses the “dateAdd" function and specifies adding 3 days to the date on which this agreement gets signed. So if the document gets signed on 5/22/2016, the resulting value of the expression will be 5/25/2016.

Negative numbers can be used to effectively subtract from the date.

See Supported Functions for a list of functions supported within expressions.


Supported Operators

The following operators are supported in calculated fields.

+

Add two numbers together.

-

Subtracts two numbers.

/

Divides two numbers.

*

Multiplies two numbers together.

&

Concatenate two strings together.

=

Equals. Compares two values and returns true if the two values are equal and false if they are not.

!=

Not Equals. Compares two values and returns true if the two values are not equal and false if they are.

Less Than. Compares two values and returns Boolean (true or false) if the first value is less than the second value.

>=

Greater than or Equals. Compares two values and returns Boolean (true or false) if the first value is greater than or equal to the second value.

<=

Less Than or Equals. Compares two values and returns Boolean (true or false) if the first value is less than or equal to the second value.

Greater than. Compares two values and returns Boolean (true or false) if the first value is greater than the second value.

%

Modulo Operator. Returns the remainder of the division between two numbers.

^

Exponent Operator. Returns the exponential value of the specified numbers.


Supported Functions

The following functions are supported when specifying expressions within a calculated field.

Function

Category

Description

abs(number1)

Math

Returns the absolute value of the number “number1”.

roundUp(number1)

Math

Round up the number “number1”.

roundDown(number1)

Math

Round down the number “number1”.

round(number1)

Math

Round the number “number1” to nearest integer.

min(number1,number2)

Math

Returns the smaller of the two numbers “number1” and “number2”.

max(number1,number2)

Math

Returns the larger of the two numbers “number1” and “number2”.

datePart(part, date)

Date

Returns the part of the date specified by the first argument as an integer. For example: datePart(m, 5/22/2016) will return the 5, the month part of the date.

See Accepted Values for Portions of Dates below for information on the acceptable values for part attribute.

dateAdd(part, date, addition)

Date

Adds the specified number of parts (e.g., "d" for day, "m" for month, or "y" for year) to a date to calculate a future date. You may use numbers or field names.

For example: dateAdd("m", "Jan 1, 2016", 3) would return a date of Apr 1, 2016. In this example, the formula adds 3 months to the date specified.

Negative numbers can be used to effectively subtract from the date.

dateDiff(part, date1, date2)

Date

Returns the number of parts (e.g., "d" for days, "h" for hours, or "n" for minutes) between two dates. You may use numbers or field names.

For example: dateDiff("d", "Jan 1, 2016", "Jan 2, 2016") would return a value of 1 to represent 1 day between January 1st and January 2nd.

daysIn(part, date)

Date

Returns the number of days contained in the part (e.g., "d" for day, "m" for month, or "y" for year) for the date specified. You may use numbers or field names.

For example: daysIn("m", "Feb 1, 2016”) returns a value 29 for the days in February 2016 and daysIn("y", "02/01/2015") returns 365 for the days in 2015.

date(string)

Date

Convert a string value such as "1/1/2016" into a date object that can be used in other functions.

now()

Date

Return the date and time when the formula was evaluated, most often when the e-sign page is loaded.

if(logical_test, value_if_true, value_if_false)

Logic

Evaluates "logical_test". The “logical_test” can be another expression. If it is TRUE, it returns the value specified in the "value_if_true". If it is FALSE it returns the value of "value_if_false". Both the “value_if_true” and “value_if_false” attributes can also be expressions.

For example: if (1>0, "Correct", "Incorrect") would return "Correct".

and(logical1, logical2, ...)

Logic

Returns true only if all the logical arguments evaluate to TRUE. Otherwise it returns false.

For example: and (1>0, 2>1) would return "true" and (1>0, 2=1) would return "false".

or(logical1, logical2, ...)

Logic

Returns true if any of the logical arguments (logical1, logical2,...) evaluate to TRUE. If all the logical arguments are evaluated to FALSE, it returns false.

For example: or (1>0, 2>1) will return "true". or (1>0, 2=1) will return "false".

not(logical)

Logic

Returns the opposite value of "logical". So if "logical" is evaluated as FALSE, it returns true. If it is evaluated as TRUE, it returns false. For example: not (1>0) would return "false".
lookup(sourceField,("value1=return1,value2=return2", "default_value") Logic

Evaluates a source field "return value" (used in dropboxes and radio buttons) to populate a default value into the calculated field, based on a list of possible values.

For example: lookup(stateField, “CA=California,UT=Utah,MA=Massachusetts,WA=Washington”,”None”)

Would return California if stateField was CA, or Utah is stateField was UT, etc.  If no match is found, it would return None.


Accepted Values for Portions of Dates

The following values can be used in date related functions when specifying the portion of the date on which the function should operate.

Part

Portion of the date to which the function will apply

y

Year

q

Quarter

m

Month

d

Day

h

Hour

n

Minute

s

Second


Calculated Fields Formatting

In addition to specifying the expression for a calculated field the output value can also be formatted. The output can be formatted as text (the default) or formatted as a number or a date.

When used with text tags, the format directive takes two arguments: FormatType and Format.

FormatType

Specifies the type of value the calculated field represents. Accepted values for this parameter are: number and date.

Format

Specifies the structure of the output value to be placed in the calculated field.


Formatting Calculated Fields as Numbers

The following characters can be used to specify the formatting of an output in the form of a number

Format Character

Description

_

(Underscore.) Represents any digit placeholder.

9

Represents any digit placeholder.

.

Location of a mandatory decimal point (or locale-appropriate symbol).

0

Located to the left or right of a mandatory decimal point. Pads with zeros.

( )

If number is less than zero, puts parentheses around the mask.

+

Places a plus sign before positive number; a minus sign before negative number.

-

Places a space before positive number; a minus sign before negative number.

,

Separates every third decimal place with a comma (or locale-appropriate separator character).

$

Places a dollar sign (or locale-appropriate symbol) before formatted number. When specified it must be the first character for the format string.

%

Converts the number value in the field into a percentage. Multiplies it by 100 and puts the

% sign at the end. When specified it must be the last character of the format string.


Formatting Calculated Fields as Dates

The following characters can be used to specify the formatting of an output in the form of a date.

Format

Description

Example

s

The seconds of the minute between 0-59.

"0" to "59"

ss

The seconds of the minute with leading zero if required.

"00" to "59"

n

The minute of the hour between 0-59.

"0" or "59"

nn

The minute of the hour with leading zero if required.

"00" or "59"

h

The hour of the day between 1-12.

"1" to "12"

hh

The hour of the day with leading zero if required.

"01" to "12"

H

The hour of the day between 0-23.

"0" to "23"

HH

The hour of the day with leading zero if required.

"00" to "23"

d

The day of the month between 1 and 31.

"1" to "31"

dd

The day of the month with leading zero if required.

"01" to "31"

ddd

Abbreviated day name.

"Mon" to "Sun"

dddd

The full day name.

"Monday" to "Sunday"

m

The month of the year between 1-12.

"1" to "12"

mm

The month of the year with leading zero if required.

"01" to "12"

mmm

Abbreviated month name.

"Jan" to "Dec"

mmmm

The full month name.

"January" to "December"

yy

The year as a two-digit number.

"99" or "15"

yyyy

The full four digit year.

"1999" or "2015"

t

Displays the first character of the A.M./P.M. designator.

"A" or "P"

tt

Displays the A.M./P.M. designator.

"AM" or "PM"


Formatting Examples

The following examples show how to format date and number calculated fields.

  • A Calculated Field formatted as a date:

{{myField_es_:calc(otherDateField + 3):format(date, "mmm dd, yyyy")}}

The output will be something like “May 22, 2016”.

  • A Calculated Field formatted as a number.

{{myTax_es_:calc(total * taxrate):format(number, "$,.00") }}

The output will be something like “$1,987.65”.


Using Expression Builder to Specify Calculated Fields

Calculated fields can be specified through the Acrobat Sign authoring environment. The steps below will guide you through the steps of defining a calculated field once you are in the authoring environment.

1. Drag-and-drop a field in the document. Double click on the field that you just added to bring up the field properties dialog. Give the field an appropriate name. Change the Value Type attribute using the drop-down list to be of type Calculated Value. This indicates that the field value will be determined based on a calculation at time of signing.

Value Type field

 

2. Type the calculation expression in the text field called Formula or click on the function button ( fx ) to bring up the Expression Builder.

Formula builder

 

3. Use the Expression Builder to define the expression for the calculated field (see Figure below). The Expression Area at the top shows the formula that will be used to calculate the value of the field. You can type the formula into the Expression Area or use the authoring environment to construct the formula. The Expression Builder provides a list of all the available Functions, a list of existing form Fields in the document, and a list of supported Operators to assist in the construction of expressions. You can add a Field or a Function to a formula by double clicking on the item in the List Area in the Expression Builder. You can also add Operators to the expression by clicking on the specific operator in the Operators List.

4. Once you have finished defining the expression, you can check the syntax of the expression by clicking the Check Syntax button then saving the changes.

5. Set the type of the calculated fields using the Display As drop-down list.

Display As field

 

6. If your Display As value is Date or Number, set the field value Date/Number Format using the drop-down list. You can also select Custom formatting to define a custom formatting for the field.

Number Format field


Calculated Fields with a Currency format

The Currency format for a calculated field inserts a currency symbol before the calculated value. (The calculation is otherwise simple math as dictated by the formula.)

Which symbol is inserted is based on the below rules:     

  • If the source fields contain a Currency validation for the US, the displayed symbol is the US Dollar: $
  • If the source fields contain a Currency validation for the UK, the displayed symbol is the Pound sterling: £

For the Currency formatting to work, the calculated field must be configured with:

  • the Display As value set to Number
  • the Number Format value set to Currency
Calculate Field - Currency format

The source fields that are used in the calculation can be either Number or Currency validated:

Calculate Field - Source Number
Number validated source field

Calculate Field - Source Currency
Currency validated source field

Caution:

When calculating the value in a Currency formatted field, Acrobat Sign is not accounting for any type of currency exchange (Forex).

  • The calculated field is performing only the math of the calculation
  • The format of the field (Currency) is only inserting the currency symbol

Any form that needs to use a currency symbol other than the Dollar ($) or Pound (£) must either add the symbol to the document file, or add a read-only field with the currency symbol set as the default value.

When using the field option, it is recommended that the currency symbol field be:

  • Assigned To: Sender (Prefill)
  • Read Only enabled
  • Default Value set to the currency symbol (the Euro is used in the below example)
Number format

Text source fields must be formatted as a Number (not Currency)

Calculate Field - Source Number
Number validated source field

The field used to calculate the final value must be configured to have the:

  • Display As value set to Number
  • Number Format field set to the format you want to use
Calculated field - Number format



Calculated Fields Examples

 

  • {{shipState_es_:signer1:calc([billingState]):showif(sameAs=unchecked)}}
    • A field in the document assigned to the first signer that will only be displayed when another field (a check box) called “sameAs” is unchecked. The value of the field is automatically populated with the value of the field “billingState” that the signer has entered in the document.
  • {{total_es_:signer1:calc(q1*pr1):format(Number,”$,0.00”):align(right)}}
    • A field in the document assigned to the first signer. Its value gets automatically calculated as the product of the values in fields “q1” and “pr1”. The resulting value is formatted as currency and displayed with a dollar ($) symbol in front of the resulting value and containing two decimal points. The resulting value is also aligned right aligned within the field.
  • price_es_:signer1:calc(if(pn1=”W1”,9.99,if(pn1=”W2”,5.99,if(pn1=”W3”,24.99,0))))}
    • A field in the document called “price” which gets calculated based on the value selected by the signer in another fields “pn1” in the document. In this example if field “pn1” equals W1 the value displayed in the “price” field is 9.99, if field “pn1” equals W2 the value displayed in the “price” field is 5.99 and so on. If none of the values match the value of the field “pn1” the value displayed in “price” is 0. Using this mechanism, calculated fields can be used to automatically populate the price of an item based on the selection that a signer has made during signing.

 

 Adobe

Get help faster and easier

New user?