Can arcade expressions be utilized in the report template for survey123? I mainly want to utilize the IIF(IsEmpty($feature.fieldName), '', $feature.fieldName) so if the field is empty do not show it in the report. I have many sub-categories in my survey and those fields will be empty depending on their parent question....
If Arcade expressions are allowed in this report template is another way to accomplish this task?
Ok cool I look forward to this new feature, the report is utilizing xls formating correct? cant this already be done by somthing simular below?
IF($feature<>"","$feature","")
Hi Joe,
While the basic format in some respects looks like the XLSform, it isn't quite the same engine as that either. most likely, visibility will be implemented similar to how specifying a repeating section works - the {#REPEAT_NAME} actually includes a check to see that there is an array of values before starting the repeat.
Can you do any calculations in the Print Template? Or does any calc need to be in the form first? Mainly I want to do math across a repeat.
Thanks
Hi Doug,
Calculations inside the template are not supported- they would need to calculated in the form.
Hi Joe,
Currently there isn't a mechanism to show/hide sections of a report template. We do plan on supporting it in the future, though the mechanism will probably not be via Arcade expressions.