Latest Contributions by DougBrowning

I get it, we just happen to have one that is 1.2 million and almost makes it.  So then my next question is can I somehow add a query?  We have a national dataset but we do want to make one file per state to get around the limit and to make it faster.  But I have to add all the data before I can filter in excel and then I hit the limit.  Hope that makes sense.  I am hoping not to have to make 12 maps each with a state filter. ... View more

First image is map viewer yes.  It does that when you bring in the entire service at once on its own. Second image I think I get no + symbol if the source is a map.  If there are no groups maps work to add..  Looks like you are adding form a feature service? ... View more

Thanks.  Why the 1 million limit?  That went away with xlxs format so its possible now I think. ... View more

pulldata does not work inside an if regardless.  Common issue. Do I need 15 different lines, each with a pulldata calculation? - yes that is what I would do.  Then put a relevant tied to your drop down on each one.  That way only one will fire.   Since each one is its own layer I do not know another way. Unless maybe you could if statement just the URL then use that var in the pulldata.   That may work if you put a relevant on the URL if line and the pulldata so that it only fires after they pick a choice, then it runs the if, then it runs pulldata.  It would depend if the query is the same on all 15?  If each query field for example is different then you probably need 15 lines.   It will take some testing because pulldata can be very finicky.  123 does not run lines top to bottom.  It runs in a function order.  So often pulldata will run before other fields causing it to fail.  Relevant helps with this - usually string-length(${pick list field}) > 0. Hope that all makes sense ... View more

I run a script to give me a list of replicas and a script to remove old ones as Field Maps does not remove them if you remove an area while offline.   I was actually not sure but AGOL hosted does have a way to compress also. See this post  https://community.esri.com/t5/arcgis-online-questions/reduction-of-space-and-credit-consumption/td-p/1392412 But basically go into the Rest page for the service, then admin on the top right, then compress at the bottom. I strangely do not think I have ever done this.  We only add and do not delete but we do remove old replicas so I wonder.  Anyone have more info on this or have scripted it somehow? ... View more

Sounds like you are turning off editing of the service so it turns both layers off.  You can set geometry edits by layer but not all editing by layer.  The parent and child are in the same service. Best I have found is to turn off editing of geo at the service level then in the map turn off editing of the parent.  This works in FM but technically they could back door it with Pro or a new map.  But best you can do. ... View more

Sorry I missed that these are two different repeats.  I think Deon answer may help as some functions do not fire correctly inside an if.  You still probably need "1" as these are lists so it will be a string. Try that. ... View more

There is a setting at  https://survey123.arcgis.com/  if i remember right.  Check there. ... View more

Q5 is a string have you tried quotes on the 1?    if(${Q5}= "1", indexed-repeat(${Q3}, ${RepeatA1A}, position(..)), '') Also it looks like you want to check in the same repeat number?  If so no need to index it at all. Just  if(${Q5}= "1", ${Q3}, '')  would work. Try that. ... View more

These names will not work as table name SDE.Samples_of_Milk  The name in the begin repeat line as to match the table name in the service. For the globalid issue I suggest to make a copy of the form and publish it as its own new form with no submission url.  Look at the schema it builds and match that exactly in your other service. ... View more

Did someone change any domain values?  Or change any lists?   ... View more