if/else
){{}}
. When you provide your custom data, Docupilot will replace these fields with the data. For example {{email}}, {{clientname}}, {{company_name}}.if/else
)if/else
statement works only when incorporated in a single cell (i.e. the whole statement shall end in a single cell in excel sheet).if
statement.if - else
statement.if - else if - else
statement.{{#if payment_status}}
{{/if}}
{{#if payment_status "==" "paid"}}
{{/if}}
{{#if payment_status "!=" "paid"}}
{{/if}}
{{#if price ">" 1000}}
{{/if}}
{{#if price ">=" 1000}}
{{/if}}
{{#if price "<" 1000}}
{{/if}}
{{#if price "<=" 1000}}
{{/if}}
{{#if payment_status "contains" "paid"}}
{{/if}}
{{#if payment_status "not_contains" "paid"}}
{{/if}}
{{#if status "in" "open, on-hold"}}
{{/if}}
{{#if status "not_in" "open, on-hold"}}
{{/if}}
{{#if status "==" "open"}}{{#if priority "==" "high"}}
{{/if}}{{/if}}
{{table:ITEMS.PROPERTY}}
{{table:line_items.name}}
{{table:line_items.qty}}
{{table:line_items.amount}}
line_items
we have name
,amount
and qty
as the properties.Name
,Price
and Quantity
in the table line_items
.