topic Re: Format Report Template Survey123 in ArcGIS Survey123 Questions

Format Report Template Survey123

joerodmey — Thu, 08 Aug 2019 19:53:56 GMT

Hi,

I'm looking for a way to format the report template that you can feed into Survey123 feature report. Right now I'm just listing all of my fields down one side the word document but I want to make a table of my data (and potentially make it look more like an invoice). When I try to accomplish this in the word document it appears that Survey123 doesn't observe these formatting operations.

Any ideas or workarounds?

Thanks

Re: Format Report Template Survey123

JamesTedrick — Fri, 09 Aug 2019 17:38:41 GMT

Hi Joe,

You certainly should be able to format the word document with tables - there are several examples of that. Could you share your current docx file?

Re: Format Report Template Survey123

YuliaMamonova — Fri, 09 Aug 2019 21:36:34 GMT

Hey Joe,

Please review example of survey 123 template in tabular format attached.

Overview of supported expressions in Survey 123 templates - Feature report templates—Survey123 for ArcGIS | ArcGIS

Hope it helps.

Re: Format Report Template Survey123

joerodmey — Mon, 12 Aug 2019 16:43:30 GMT

Thanks James Tedrick and Yulia Mamonova‌

I'm also looking at including related records (from a repeat in my form) within the report. Have either one of you accomplished this?

Re: Format Report Template Survey123

JamesTedrick — Tue, 13 Aug 2019 20:41:52 GMT

Hi Joe,

Yes, you can include related record (repeat) information in the form. The syntax to begin a section is

${#repeat_name}

You can then include fields that occur in the repeat, and fields from the parent layer by specifying ${table_name.field_name}.

A repeat section is ended with

${/repeat_name}

You should see this pattern if you generate a sample template from the form with a repeat.

Re: Format Report Template Survey123

joerodmey — Wed, 14 Aug 2019 21:25:17 GMT

Perfect.

Can the feature report template accept calculations? For example just say I want to pull in a quantity value and a unit cost value. Can I tell the template to calculate the total cost using those values and simple multiplication? James Tedrick‌

Thanks