Latest Contributions by DougBrowning

Have you tried calculationMode=whenEmpty?  I have heard varying success but worth a shot. https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-calculation-modes/ba-p/1206967  ... View more

You can only do direct matches you cannot use !=.   Also it has to be text matches you cannot have a field in the lists page.  I tend to make multiple rows for each option and line them up that way.  I think for yours you could have MID in that list filter column and match that up with the choice filter. ... View more

I am not sure what you mean but if(contains(${q1_cosr}, 'COS')=true,"X","") is not a correct if statement. It would be like this - you never say = true that is assumed. if(contains(${q1_cosr}, 'COS'),"X","") ... View more

Here is how I fix these.  I wrote it up somewhere but cant find it. Create a new dummy form to get a clean excel Copy that to the dir of the form to fix Rename the current xlsx to OLD_Name or something like that Rename the fresh xlsx to the exact name as the old xlxs Open both sheets then highlight all, copy, then Right click Paste Values into the new template - Big note.  If the old and new xlsx are the same version the columns will line up.  If not you will have to go a column or two at a time.  Not as bad as it sounds though. Copy over the settings and lists - again use Paste Values. Save That should fix it all up. ... View more

Did you move it at all?  Or change permissions?   ... View more

Oh boy almost looks like it was on then turned off and got orphaned.  Umm not sure at this point.  You may be able to delete it manually and recreate?  If they is production be careful but if testing?  Maybe try a rename on the old one first.  This could explain your errors. Sorry I don't know for sure. ... View more

I agree its a no.  Worse we have users making QA changes in the service via webmap or Pro, then someone also does a change in the form, resubmits and wipes the other changes.  You can turn off editing in a map but they can still backdoor to the service. ... View more

And these   DougBrowning_0-1727203685876.png   ... View more

Every figure this out?  Works in Map Viewer Classic but not seeing it in WAB? ... View more

Check the settings at https://survey123.arcgis.com/ then Collaborate tab ... View more

Do you mean before they submit the point?  I think they have to submit then click on the link. ... View more

Only other idea is special chars.  Maybe post up some values. ... View more

Why is SensitiveSpecies highlighted?  That usually means a dup field name. Detectiontype is a select one.  Do the values of PTType line up with the name column of the choice list?  (not the label column must match name column) ... View more

I would double check the spelling and the case Detectiontype={PTType} ... View more