If you want to use a calculation or combine multiple fields you can use formulas, to do so select a pdf field, and in the “Mapped To” section select Formula
Adding fields to a formula
To add a field in your formula click on “Add tag to formula” and select the field that you want to include
Adding fixed values
You can also add fixed numbers to the formula by just including them without a format like this:
To add a text you need to add it surrounded by a double quotation symbol:
Combining fields
To combine text you can use an addition operation like this:
This would combine the name field with the last field. Using an operation like this would combine them without spaces though, so for example if the name is “John” and the Last Name is “Doe” this operation would show JohnDoe, to add an space you just need to also include an space between them like this:
Using conditions
You can use the following syntaxis to add conditional text
if(condition)
return value_to_use;
Value_to_use_otherwise;
Example:
The formula above will return “John submitted this form” when the name field has the value “John”. In any other case, the formula will return “Someone else submitted this form”
The following conditions are supported:
Name | Code | Description |
Equal | == | Triggered when both values are equal |
Not equal | != | Triggered when both values are different |
Greater than | > | Triggered when the first value is greater than the second |
Greater or equal than | >= | Triggered when the first value is greater or equal than the second |
Less than | < | Triggered when the first value is less than the second |
Less or equal than | <= | Triggered when the first value is less or equal to the second |
Using multiple conditions
You can use as many conditions as you want in your formula, for example, the condition below will check if the name is John or mary too
Also, you can use multiple conditions within the same if condition if you separate them with an “or” or “and”
The example above will show “John or Mary” submitted the form if either John or Mary submitted it.
NOV
2023
About the Author:
Im programmer working for an international company. I have programmed since i was 12 and i have done it professionally for 6 years. Programming for a company is fun and i have learned a lot of things but i have always been interested in running my own business so i decided to give it a shot doing what i do best, programming stuffs.