topic Re: Utilizing Arcade Expressions in Report Template in ArcGIS Survey123 Questions

Utilizing Arcade Expressions in Report Template

Lake_Worth_BeachAdmin — Tue, 30 Jan 2018 20:32:30 GMT

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?

Re: Utilizing Arcade Expressions in Report Template

JamesTedrick — Tue, 30 Jan 2018 20:57:33 GMT

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.

Re: Utilizing Arcade Expressions in Report Template

Lake_Worth_BeachAdmin — Tue, 30 Jan 2018 21:03:02 GMT

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","")

Re: Utilizing Arcade Expressions in Report Template

JamesTedrick — Tue, 30 Jan 2018 21:43:52 GMT

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.

Re: Utilizing Arcade Expressions in Report Template

DougBrowning — Mon, 05 Mar 2018 21:45:19 GMT

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

Re: Utilizing Arcade Expressions in Report Template

JamesTedrick — Tue, 03 Apr 2018 22:45:35 GMT

Hi Doug,

Calculations inside the template are not supported- they would need to calculated in the form.

Re: Utilizing Arcade Expressions in Report Template

ClaireInbody1 — Thu, 01 Nov 2018 16:35:27 GMT

Has this been implemented yet?