API and templates

kadant

Hello,

We tried using custom reports but we need some basic if/then logic per field.
Is it possible with the online template builder? I found no info on that. Any pointers would be greatly appreciated.

If a conditional statements in formulas are possible please let us know the syntax.
i.e. this construct is possible in the online template builder?
{expense.billable?string("Yes", "No")}

In case it's not possible to use online template creator, we'll create our own one.
So as part of the API call we need to specify the template.

I have a couple of questions about API
- Once the .ftl file is ready, where do we upload it? Or should it?
- If not, can I specify the template as part of the request? Does anyone have a sample of this kind of request?

Aleksey

kadant

problem solved.
formulas with conditions are possible only as part of a custom template. once you create you own template you can pass it as part of the API request.

InnovAsian

What did you do in the template to get the field to return a value?
This "${expense.reimbursable?c},<#t>" does not work.

InnovAsian

This will produce a TRUE or FALSE result in the report:
${expense.reimbursable?string},<#t>