Format Report Template Survey123

[joerodmey]

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

[JamesTedrick]

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?

[YuliaMamonova]

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.

[joerodmey]

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?

[JamesTedrick]

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.

[joerodmey]

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