In a "county resources" database fed from a Survey123 (Connect) form, we have the user select whether it is a virtual, in person, both, or phone only resource. When it is virtual or phone only, I would like it to default to specific coordinates on our campus. Otherwise I want the user forced to place the location.
My problem is (with default coordinates set in the XLS form), for an "in person" or "both" resource, the survey assumes the default coordinates. This would be fine... but I have users that are oblivious. The user now skips over the map, and there is no "required" message anymore because the survey assumes the default coordinates, and now the resource does not have an accurate location. I have the esri::visible field set to only show the geopoint question if the user has selected "in person" or "both" option as well, so for virtual and phone only resources, setting coordinates under default works as expected.
How would I write the if statement calculation? Would I put that if statement in the default or calculation column?
Thanks!!!
Solved! Go to Solution.
Turns out the else statement was simply just "" in the calculation field
if(selected(${RESC_VIRTUAL},'Virtual') or selected(${RESC_VIRTUAL},'Phone Only'),'44.022380 -92.430309','')
Turns out the else statement was simply just "" in the calculation field
if(selected(${RESC_VIRTUAL},'Virtual') or selected(${RESC_VIRTUAL},'Phone Only'),'44.022380 -92.430309','')