Latest Contributions by JonahW

Hi Peter, You solved it! The standardized SQL queries were turned off last week while an ESRI tech tried to help me troubleshoot what I though was a potential SQL injection. I just reversed that setting and now I can see the created_date and last_updated_date. Thank you very much for your help! ... View more

I tried adding a dummy field but that didn't seem to help. Unless I'm not adding it in the right place within the .XLS Form?  I tried both the if(dummy=yes, pulldata, pulldata) in the calculation field as well as adding the dummy=yes in the relevant column. I think the issue for me is with a counter value that I have set up to keep track of where to lookup in the .csv within the repeat.  I did a test and added a manual counter, basically asking the user to input the hydrant number they wanted to flush and that did seem to return the appropriate values when editing an existing survey .However, I was still unable to move on to the next hydrant within the repeat.  I might just have to redesign this whole thing, and have one survey per hydrant... Unless someone else has some ideas!  There was one way I found I could edit an existing survey and be able to get the pulldata to work properly. It worked if at the beginning of the survey I cycled through all the hydrants that needed to be flushed within that repeat. I could then save a draft or even send the survey and be able to edit the responses.  Thank you! ... View more

Hi Peter, I sent you an invite, please let me know if you don't get it.  Thank you! ... View more

Sorry, I feel like a dummy 🙂  So is  the dummy field something that the survey responder would flip yes/no when returning to edit an existing survey?  ... View more

Thank you Doug. Can you provide some more information on using the dummy field? I am not sure I understand how that would work.   ... View more

Thank you, those are great suggestions!    ... View more

Thank you, I do have the poster and it is a handy resource! The laterals are in a separate layer than the mains. I do have a few other point layers in the dataset. For instance I have a tap layer and I have been testing a combination of these two rules:  1) Taps must be covered by sewer mains. 2) Taps must be covered by endpoint of laterals.  The problem with this, we don't have all taps GPSed/digitized and also we have lots of taps but no laterals (these came from CCTV inspections of the mains) I was hoping there was a simpler way to check the connectivity of the two layers, but maybe I do need to go a different route.   Thanks! ... View more

Hi Barbara, Thank you for the suggestion. I happen to already have a counter set up in this survey so I've been trying to figure out how to set it up. I have it working right now, but it occurred to me that if the first hydrant in the repeat(so counter=1) does not have any damage reported, then I'll end up with a blank page at the beginning. I think what I need is a counter that keeps track of the hydrants with damage, so I can have a section for the first damaged hydrant and then a section for all the rest. Unless there is another place to add the "if counter" statement that I'm not thinking about? Unfortunately we just went live with the survey today so I can't add more fields to my form but I will try it once this round is complete.  Alina  ... View more

After another closer look at the Join Features Analysis tool I discovered the "Keep all target features" checkbox .This is exactly what I need! Now I can apply a filter on one of the fields from the inspection table in order to create my layer of assets that still need inspection.  ... View more

Thank you Tyler. I have used your first recommendation on one occasion, however it wouldn't work here because the inspections are in a separate layer than the hydrants. The field crew only edits the inspections. We also use Survey123 and pass the AssetID from the hydrant to the inspection so we can keep track of them.  ... View more

Doug, Could you provide a little more information on the workflow that uses Arcade? All my layers are stored in ArcGIS online, they were published originally as empty feature classes from Pro without a relationship built. So I assume there is no way in ArcGIS online to define a relationship at this point, correct?  Thank you! Alina  ... View more