\{\{invoice.id}}\{\{invoice.date}}\{\{invoice.customerId}}\{\{invoice.customerName}}\{\{invoice.currency}}\{\{invoice.amount}} | Invoice\{\{invoice.customerName}} | - | \{\{invoice.customerName}} |
| \{\{invoice.customerName :: optional}} | - | |
### Default values
| Input format | Input data | Output data |
| ------------------------------------------------------------- | --------------------------- | ---------------------------- |
| \{\{invoice.customerName}} | - | \{\{invoice.customerName}} |
| \{\{invoice.customerName :: default(“Box Inc”)}} | - | Box Inc |
### Formatting text tags
| Input format | Input data | Output data | Supported \{\{invoice.customerName :: uppercase}} | Acme Inc | ACME INC | Yes | No |
| \{\{invoice.customerName :: lowercase}} | Acme Inc | acme inc | Yes | No |
| \{\{invoice.date :: format(“dd-mm-yyyy”) }} | 13-03-2023 | 13-03-2023 | Yes | No |
| \{\{invoice.date :: format(“mm-dd-yyyy”) }} | 13-03-2023 | 03-13-2023 | Yes | No |
| \{\{invoice.date :: format(“dd-mmm-yy”) }} | 13-03-2023 | 13-Mar-22 | Yes | No |
| \{\{invoice.id :: format(“xxx-xxxx”) }} | Inv1203 | Inv-1203 | Yes | No |
| \{\{invoice.amount :: format(“EU-Number”) }} | 300000 | 300.000 | Yes | No |
| \{\{invoice.amount :: format(“US-Number”) }} | 300000 | 300,000 | Yes | No |
### Rich text
Box Doc Gen allows you to generate documents with rich text. If the input JSON data contains HTML tags such as bold, italic, underline, line breaks, paragraphs, anchors, or images, Doc Gen automatically interprets them as rich text and applies the relevant formatting.
| HTML Tags | JSON data | Output |
|---|---|---|
| Bold | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Italic | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Underline | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Bold, Italic and Underline | \{ "company": "\\\Acme Inc.\\\A fictional company that features prominently in the Road Runner show as a running gag. Phone:\\\ 999-999-9999\\\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Strong | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Span | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Emphasized | \{ "company": "\Acme Inc.\ A fictional company that features prominently in the Road Runner show as a running gag. Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Line breaks | \{ "company": "\Acme Inc.\ \n A fictional company that features prominently in the Road Runner show as a running gag. \n Phone:\ 999-999-9999\" } | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Paragraphs | \{ "company": "\Acme Inc.\ \ | Acme Inc. A fictional company that features prominently in the Road Runner show as a running gag. Phone: 999-999-9999 |
| Ordered list | \ |
|
| Unordered list | \ |
|
\{\{ tablerow item in multipleImages }} | |
\{\{ item.name }} | Embedded image whose Alt Text includes JSON with image-path |
\{\{ endtablerow }} |
| Id | Name | Qty | Price |
|---|---|---|---|
\{\{tablerow item in invoice.items}} | |||
\{\{item.id}} | \{\{item.name}} | \{\{item.quantity}} | \{\{item.price}} |
\{\{endtablerow}} | |||
\{\{ for item in invoice.items }}\{\{item.name}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ for item in invoice.items }}\{\{item.name}}, \{\{item.quantity}}\{\{ endfor }} | List of products:\{\{ items :: delimiter(“,”)}} | A4 Papers, Ink cartridge, Adhesive tape |
| List - with semicolon separator | \{\{ items :: delimiter(“;”)}} | A4 Papers; Ink cartridge; and Adhesive tape |
| List - with customer separator | \{\{ items :: delimiter(“\~”)}} | A4 Papers\~ Ink cartridge\~ Adhesive tape |
| List - with Comma and last delimiter | \{\{ items :: delimiter(“,”) , lastdelimiter (“, and”)}} | A4 Papers, Ink cartridge, and Adhesive tape |
| List - with semicolon and last delimiter | \{\{ items :: delimiter(“;”) , lastdelimiter (“; and”)}} | A4 Papers; Ink cartridge; and Adhesive tape |
| List - with custom separator and last delimiter | \{\{ items \| delimiter(“~~”) , lastdelimiter (“~~ and”)}} | A4 Papers\~ Ink cartridge\~ and Adhesive tape |
***
| Tag type | Conditions supported | Operators supported to chain conditions |
|---|---|---|
| String | ==(is equal to), !=(is not equal to), isPresent | AND, OR |
| Date | isPresent | AND, OR |
| Number | \<, >, ==, !=, >=, \<= | AND, OR |
\{\{ if invoice.paymentMethod == “Online Transfer” AND invoice.paymentTerms == “Net30” }} \{\{ elseif invoice.paymentMethod == “Cheque” AND invoice.paymentTerms == “Net60” }} \{\{else}}\{\{endif}} | Payment terms:\{\{ if invoice.amount > 1000 AND invoice.amount \< 5000 AND invoice.paymentMethod == “Cheque” }} \{\{ elseif invoice.amount > 5000 AND invoice.paymentMethod == “Cheque”}} \{\{else}}\{\{endif}} | Processing fees:\{\{ if invoice.deliveryDate isPresent }} \{\{ invoice.deliveryDate}}.\{\{else}}| Id | Name | Qty | Price |
|---|---|---|---|
\{\{tablerow item in invoice.items}} | |||
\{\{item.id}} | \{\{item.name}} | \{\{item.quantity}} | \{\{item.price}} |
\{\{endtablerow}} | |||
| Id | Name | Qty | Price |
|---|---|---|---|
\{\{ tablerow item in invoice.items }} | |||
\{\{ item.id}} | \{\{ item.name}} | \{\{ item.quantity}} | \{\{ if item.price isPresent}}\{\{item.price}}\{\{ else }}-\{\{ endif }} |
\{\{ endtablerow }} | |||
\{\{ invoice.grossAmount + invoice.taxAmount}} | Net Amount:\{\{ invoice.grossAmount + invoice.taxAmount + invoice.shippingCharge}} | Net Amount:\{\{ invoice.taxRate % \* invoice.grossAmount}} | Tax Amount:\{\{ \$sum(invoice.items.amount) }} | Gross Amount:\{\{ \$count(invoice.items.amount) }} | Count:\{\{ \$average(invoice.items.amount) }} | Average Amount:\{\{ $sum(invoice.items.amount) + invoice.taxRate % * $sum(invoice.items.amount)}} | Net Amount:\[\[t\|0]] | Yes | Yes |
| Date field | \[\[d\|0]] | Yes | Yes |
| Checkbox field | \[\[c\|0]] | Yes | Yes |
| Signature field | \[\[s\|0]] | Yes | Yes |
| Stamp field type | \[\[st\|0]] | Yes | Yes |
| Initials field type | \[\[i\|0]] | Yes | Yes |
| Name field type | \[\[n\|0]] | Yes | Yes |
| First name field type | \[\[fn\|0]] | Yes | Yes |
| Last name field type | \[\[ln\|0]] | Yes | Yes |
| Company field type | \[\[co\|0]] | Yes | Yes |
| Email field type | \[\[e\|0]] | Yes | Yes |
| Title field type | \[\[ti\|0]] | Yes | Yes |
| For an attachment field type | \[\[a\|0]] | Yes | Yes |