Format Report Template Survey123

Question

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

joerodmey · Answer

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

JamesTedrick · Answer

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 · Answer

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?