topic Re: Word Report 'Bullets' format in ArcGIS Survey123 Questions

Word Report 'Bullets' format

ChristinaKimbrough — Mon, 12 Oct 2020 12:04:43 GMT

Hello, I can't seem to find an answer here or in Microsoft Word help so here goes.

I have a multi-selection question and want the answers to be listed as bullets in the word report form.

${graffiti_location | appearance: “bullets”}

This does 'list' the selection but as sequential numbers. One, we would like them as 'bullets' and if we can't get away from the numbers, it unfortunately runs through the whole report not starting the numbers again per section but continues from the last one...

i.e.

Graffiti locations:

Damage locations:

and so on.

We have several in this one report.

Can anyone offer any suggestions?

Thanks, Christina

Re: Word Report 'Bullets' format

Shwu-jingJeng — Mon, 12 Oct 2020 22:29:35 GMT

Hi Christina,

Could you try to remove the space in front of the "bullets" in your syntax and see if that would work?

${graffiti_location | appearance:”bullets”}

The syntax could be sensitive to the space though.

Re: Word Report 'Bullets' format

Survey123TfLAdmin — Tue, 13 Oct 2020 10:47:10 GMT

Hi Shwu-jing,

Thank you for the follow up. I've removed the spaces and still the same in a preview PDF sample report and MS Word generated report. I've even tried in a blank word document (no table, headings etc.) with just this syntax and it is still the same. The default appears to be numbering. What syntax string can I use to list only the selection options per line (not with a comma) and without a check box?

I have tried: ${graffiti_location | selected:"back_panel"} Back panel but this lists all of them with check boxes.

Thanks,
Christina

Re: Word Report 'Bullets' format

Shwu-jingJeng — Tue, 13 Oct 2020 16:55:23 GMT

Hi Christina,

Could you share your XLSForm and the feature report template you are using with me so that I can test it here?

You can mail them to me here if you don't want to share it publicly.

Re: Word Report 'Bullets' format

ChristinaKimbrough — Thu, 15 Oct 2020 09:14:46 GMT

Hi Shwu-jing,

I have emailed you the documents.

Thank you, Christina

Re: Word Report 'Bullets' format

gvanderwaal — Wed, 03 Mar 2021 22:13:10 GMT

I also had this issue.

As it turns out, what '| appearance: "bullets"' actually does is output the labels of the select_multiple using the first level of the default "current" multilevel list.

It does so regardless of what bullets are being used elsewhere in the document and even if no multilevel list is actually being used. In our case, the default current multilevel list is always one with sequential numbers, so the bullets appeared as sequential numbers, instead of bullets. It's likely this was the case with Christina as well.

The fix (Office 365 Word version 2101, build 13628.20448 Click-to-Run) is:

Open the multilevel list dropdown (shown above)
Click "Define New Multilevel List..." at the bottom of the menu
Click the "Number style for this level:" dropdown
Scroll down and select "Bullet, Solid Circle:" (or any desired bullet type)
Click OK

However, you're not done - the select_multiple will now output as bullets, but the bullets will ignore the surrounding formatting and use whatever is specified in the "Normal" style. So in our case, despite the whole .docx being in Arial 10, the bullets would be in Calibri (Body) 11 until the font/font size/paragraph spacing was changed in Normal.

If this was the way this feature was intended to work I wish it had been documented better.

Re: Word Report 'Bullets' format

DiegoMonge_Chinchilla — Fri, 25 Jun 2021 19:16:39 GMT

Hello Christina

It's being a long time, but maybe someone else need the info.

I had the same problem and I solved just adding a bullet in the word document with the select question. Like this:

${graffiti_location | appearance:“bullets”}

Regards

Re: Word Report 'Bullets' format

Katie_Clark — Fri, 06 May 2022 19:37:53 GMT

@DiegoMonge_Chinchilla Thank you so much for taking the time to come back and post this....it was exactly what I needed!

Re: Word Report 'Bullets' format

MikeLachance1 — Tue, 18 Apr 2023 20:32:02 GMT

I'm also having this issue and none of the solutions presented above are working for me. No matter what I do the 'Appearance: bullets" specification creates a numbered list for me. I would to see this work as intended.

Re: Word Report 'Bullets' format

Marisa_Kordecki — Mon, 26 Jun 2023 19:33:26 GMT

@MikeLachance1 I found that defaults are easier to fix in a new document. You follow the directions above but in a blank document. Then you copy and paste over your form. It's silly but it's worked for me several times when I needed to change the default bullet.