AnsweredAssumed Answered

Survey 123 Report Template - Conditional text styles & geopoints from Image metadata

Question asked by pbsusa on Feb 26, 2019
Latest reply on Feb 27, 2019 by pbsusa

Good Afternoon, 

 

We're just starting to use Survey123 and are really enjoying the simplicity and functionality so far, I just have a couple questions about the docx report template and streamlining future templates. 

 

1. I have a table with a final column that reads "Client Action Required?", entered as a select_one yes_no question in Survey123.  I want "YES" responses to be in bold,red 16pt font and "NO" responses to be black 12pt font.  

 

I was able to get this to work by entering this into my report template field: 

[quote]${if field_157=="Yes"}${field_157}${/}${if field_157=="No"}${field_157}${/}[/quote]

This works fine and has the desired effect, but I'm going to have to do a lot more of these in the future and was hoping there's a better way.  I know this isn't correct, but I was thinking something like this: 

[quote]${if field_157=="Yes"}<red><b>${field_157}</b></red>${/}${if field_157=="No"}${field_157}${/}[/quote]

Is there another way to do conditional formatting by response that I'm missing, or should I stick with the first example?

 

 

2. Most of my surveys have an OBSERVATIONS repeat that is typically an image, a geopoint and a caption.  (see attached image).  

 

This works fine when someone is filling out the survey in the field/on-site, but we'd like to be able to fill these out in the browser from the office at times as well.  At those times, I'd like to be able to pull the Lat/Long from the image (cell phone or drone) and use that to generate the maps instead.  Is there a way to generate these maps automatically using the image metadata instead of a geopoint question? 

 

 

Thanks for the help!

Attachments

Outcomes