API and templates
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
Best Answer
-
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.
Answers
-
What did you do in the template to get the field to return a value?
This "${expense.reimbursable?c},<#t>" does not work. -
This will produce a TRUE or FALSE result in the report:
${expense.reimbursable?string},<#t>
