IF statement in relevant column

Question

Hi guys.

I'm S123 connect trying to figure it out something that I believe that should be fix with an if statement. I did a workaround but my survey takes some time to upload, maybe there is a better solution and I haven't found it.

Basically I have a survey question with multiple choices that contain activities description. The user only need to select one.

Based on the selection will show a geolocation or geotrace.

I get it to work by adding a lot of geopoint and geotrace functions in the spreadsheet but it takes sometime to upload because of the amount of data in it.

Maybe there is a better solution by doing an if statement in the relevant? Don't know if there is something like that around.

Please let me know.

Thanks.

dougbrowning · Answer

It is impossible for a Feature class to be both a line and a point.  Which makes sense.  Remember all 123 does is load data into a feature class on AGOL.

You could try making them repeats so that you have 2 feature classes.  But not going to look the way you want but it would work.

Not sure your workflow but you could have 2 links in collector that opened the correct form.  Not sure how the lookup would go though with some really long if statements.  If you can preload the assets in Collector that may help.

Hope that helps

CesarAvila · Answer

Great. That worked.

Now is giving me this issue of not beign able to publish.

The workflow depends if they select one activity related to a line will be a geotrace. If is a point will be a geopoint. Do you guys have like a workaround for that?

Thanks

Jing_Sun · Answer

Hi,

I think you can use 'or' to group a number of selected() functions.

Something like this:

selected(${activitysub},'411') or selected(${activitysub},'425')

Cheers,

Sun