Conditional Calculation with pulldata @layer

ZachBodenner

Hello, 

I am trying to do some conditional calculating. I have an address field in my survey and I'm using pulldata @layer to get the address of a parcel that the point is placed on. 

If the point is not placed on a parcel, I'd like to return a piece of text like "No Address Found" or something. 

My actual pulldata is working fine, I get addresses when the point is on a parcel, but I want to set a default value. From what I understand, actually using Default might not work because that only evaluates when the survey is opened, so if I click a point that isn't on an address, then the default is overwritten with nothing.

pulldata("@layer", "getValueAt", "attributes.ADDRESS", "<parcel REST endpoint>", ${EP311_point})

DuncanC

The example for if is:

if(selected(${question_one}, 'yes') and selected(${question_two}, 'yes'), 'yes', 'no')

So you'd want something like

if($raw='', 'No Address Found', $raw)

Or to smash it all together:
if(pulldata("@layer", "getValueAt", "attributes.ADDRESS", "<parcel REST endpoint>", ${EP311_point})='', 'No Address Found', pulldata("@layer", "getValueAt", "attributes.ADDRESS", "<parcel REST endpoint>", ${EP311_point}))

Yuck.  You come back to that in 6 months there is nothing you can do with it but pull it apart.  That's a pain.  Do future you a solid and try out the extra lines.  

Also yeah, I do not like the XLSforms syntax, don't end up using it quite enough to ever fully feel comfortable with it,  won't surprise me if it needs a little tweaking to work.