Latest Contributions by DougBrowning

Sounds like your formulas are not working.  Got to fix those first. ... View more

Did you try changing the number of decimal places in the Web Map that feeds Collector.  It is in Pop up then Configure Attributes. ... View more

You are on the right track.  Here is how I did it.  Not perfect. Create a large txt (or note) field outside the repeat.  i did text so users can copy and paste it. Add a calc joining the fields from the repeat join(", ", ${SpeciesList}) Set a constraint on this join field (not the field) - the trick here is to remove the last entry since it is the one you are trying to add currently.  So like this not(contains(substr(${AllPlantsCheck}, 0, string-length(${AllPlantsCheck}) - 3), ${SpeciesList}))  --If you do not do this it immediately adds to the list then complains it is already there. --(note my plant codes are 4 chars. so if i remove the last 3 chars it will not find what I just added) It can be funky if you go backwards and then change something but it still seems to work ok. I even built on exceptions to the rule. If it contains a XXXXX generic code then the repeat is allowed. Like contains(${SpeciesList}, "XXXX") or not(contains(substr(${AllPlantsCheck}, 0, string-length(${AllPlantsCheck}) - 3), ${SpeciesList})) Now it sounds like you may want to compare across multiple repeats?  If so make a join() field for each repeat then make a master field that joins all of the joins together.  Then check against that.  (Confused yet ) Hope that helps.  Works slick for me. ... View more

In your column with all the ; in there like this  BARCODE;SERIAL_NUMBER_PLATE;ASSET_DESCRIPTION;ROOMNUM;ROOM_DESCRIPTION;BUILDING;FLOOR;SITE_DESCRIPTION;RESPONSIBLE_PERSON;ASSET_CATEGORY_ID;CATEGORY;SUB_CATEGORY;SUB_CATEGORY_DESCRIPTION_FOR_DEPRECIATION;CONDITION You have new line chars in there.  That will kill you list.  If you can remove this column I would.   If not here is how to find new lines. Open in Excel Go to the column and select it Right click Format Cells Go to Alignment tab Check Wrap Text Now scroll through the list and you will see the new lines pop out at you.   To fix edit that row and delete anything before the first char and everything after.  You of course will not see anything on the screen. But when you click away from the field you will see it change. Issue number 2 is you have Commas in this field PROPERTY, PLANT AND EQUIPMENT.  You cannot have ANY commas in the label field.  It will cause you list to be all misplaced.  Oh I see them in the 3rd column also COAT HANGER - HANGER STAND(STEEL,GREY).  Again no commas anywhere.    These both get me a lot when others send me files.  Not well documented. ... View more

I feel ya.  I get requests for paper looking report a lot over the last 4 years and I always have to say no.  On the one hand it is hard to justify the cost to create a solution for a paper based item in 2019.  But, like you, we have certain times when it is law that we have to do it.  So yes we, and for sure Esri, keep saying would like something more modern but in the end the law is the law.   One Idea for you.  Assuming you have some master FC that has wells/sites in it.  Each night run a script (or a Flow) that creates a PDF version of any forms that were created during that day.  Attach this PDF to the well/site.  Then in the field use Collector to find and open these PDFs on demand (I can you can even email or txt it after it opens).  Plus then you also get a Collector map to route to and find wells, etc - you could also then add a launch 123 forms off of it to prefill form data and reduce errors on well numbers.  During the same day the inspector could still look at the Survey123 or Collector table version.  If the report is any day but today you would have the PDF.  You could also run the script multiple times a day.  (If you have to go offline attachment size may become and issue but PDFs are pretty small.) Just an idea. ... View more

If you take out selected you must remove the ( and the ) wherever you used it.  See below. For the Or statements you must not be a programmer . Cannot do this if(selected(${signtype},'S1-1 - School' or 'SS4-5 - School Speed 15 MPH Ahead (Symbol)') Must be a full compare for each Or. if(selected(${signtype},'S1-1 - School') or selected( ${signtype},'SS4-5 - School Speed 15 MPH Ahead (Symbol)')) Or if a select one it is cleaner to do  if(${signtype}='S1-1 - School' or ${signtype}='SS4-5 - School Speed 15 MPH Ahead (Symbol)',yes,no) Also are your Names all of this - 'SS4-5 - School Speed 15 MPH Ahead (Symbol)' or is that just the Label?  You need to compare with Name not label.  I would not put all those special chars in my data.  For sure you cannot have new lines or any commas in your lists! ... View more

Yea that is what I was thinking.  Just makes it easier to write.  Note if it is a select_one question you can do a = instead of selected().  Selected is more for select_multiple.   You could make them all Calculate fields so they are hidden to the user.  (or use hidden).  Can also bind to null then they will not show in the Feature Service. Depending on your math that last one may be just Max((${widthnote} * ${heightnote}).  Not sure about the div 144 because it will do that on all of them. ... View more

A workaround is to put it in a Group. Give it a shot. ... View more

For the forms that have Photos in them.  I have a large HFS with 9 forms and one main Plots FC.  They are all hooked together.  The _ATTACH tables have caused me issues with this in the past. ... View more

As many as your brain can keep straight I think.  You could also maybe do one if per field then another field that just takes the value that is not 0. So' If (case 1, value, 0) If (case 2, value, 0) Then Max(case 1, case 2) ... View more

I did that and it did not help. This MAY have worked but still testing.   Remove ALL _ATTACH tables from service map Re-Publish the service Add ALL _ATTACH tables back into the service map Re-Publish the service Works!?!? ... View more

Opps see an extra  try if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4), (${width} * ${height}) div 144) ... View more

Missing the last ) if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4)), (${width} * ${height}) div 144) ... View more

What helped?  I am having this same issue right now.  It seems from the log that it is mad there are other relationship classes besides the ones between the forms.  (I have a few extra relationships classes that point from the Form to a Master set). Thanks ... View more