Latest Contributions by CharlesBailey3

Thanks James, that works but it displays the relevant if 'A' or 'B' and any other choices are selected. We's like it to specifically fire if 'A' or 'A,B' are selected, but no other combination. Is there a way to do that? Having trouble getting an 'and' operator to work. Thanks again, cob ... View more

What if you wanted to evaluate multiple choices? I have tried something like selected(${multiSelect},'A,B') but doesn't work.  ... View more

Yes I had that same idea today and it almost works, but it seems like the repeats are summed like strings instead of numbers when the if statement is used. So when I do if(${cond1}='n' and ${cond2}='n', 1,0) they are summed like this - 1st iteration = 1, 2nd = 11, 3rd = 111 and so on. Can I use the bind ESRI type to override it? Thanks, cob ... View more

That's what I was thinking - to use another field to sum the records. So I guess I will have to wait for the sum function - is it in the new beta version? Another thing is the nested repeats don't seem to be working right - if I start a 'plots' repeat for example, and within that place a 'samples' repeat, so that I want the individual samples to be allocated to a particular plot, but the survey result is that it duplicates each sample for each plot. So 4 plots with 14, 16, 18, and 20 samples becomes 4 plots with 68 samples each in the output. Is it a problem with my xls form, or is there any way to accomplish this in the current version of S123? Or should I ask this as a new question? Thanks James - cob ... View more

Thanks James - that is indeed what I need. What gets me is I can see the repeats increment in the form preview, so it has to be in the table somewhere at that point. Is there any other way you know to sum or count the number of records (or I guess I should say the number of repeats) and display a calculation on that to the form user? ... View more

Yep, trying to run the tool in desktop prior to publishing - not a model just straight from the tool dialog in the toolbox. The layer is in the map and can display. It's coming from my sql connection on the server - it is an enterprise geodatabase I created using the Create Enterprise Database tool in desktop (that in itself was an ordeal). I published it to our arcgis server (remote computer connection) as an editable feature service, and used Add Item in AGOL to get it in the cloud. Is there anything inherently wrong with this workflow? Can this type of data be used as input for the AddGeometryAttributes tool, I guess is my first question. If so then to figure out why the tool won't run, then on to the publishing process, etc. Thanks for all your time with this Derek - cob ... View more

Thanks Derek and other kind posters - using a combination of these suggestions I managed to get the feature service published to the server and hosted in AGOL. And I am now trying to publish a geoprocessing service from desktop using this data. The ultimate goal is to be able to add or update an area (acreage) field in an editable feature service after the user adds or updates the feature geometry. Can you believe something so simple requires such Herculean efforts?!?! The add geometry attributes tool in desktop keeps failing, says in_table is not a valid layer or table. Is it even possible to run this tool on the data from the server (in my sqlexpress gdb)? Or do I need to bring in a local layer and then find that, if it does happen to miraculously publish, it's pointing to a static layer that's been copied to the server, not the editable one (which has happened on previous attempts with hosted feature services). Does anyone know the best way to publish this service to work with an editable feature service on the AG server? I know hosted (AGOL) feature services are out. Thanks again for your help - cob ... View more

Thanks for your response Derek, but that's not helpful to me. I've been through the ESRI documentation a thousand times and the issue (other than it just won't publish with a generic error) is the Analyze window in service editor says the data/folder is not registered and will have to copy, but when I try to register it says it's already registered with the server. So it can't even agree with itself. I even brought the data into the map to publish directly from the sql database which is on the server machine, and it still says not registered/have to copy. But when I try to correct it, it is registered. I've tried this several times over the years and never gotten it to work, although this is the furthest I've gotten in terms of getting the database (supposedly) registered as it's validated in arcgis server manager. The same thing happens when trying to publish a geodata service from the sql sde connection. Rather than giving ESRI links can you tell me exactly what to do to properly 'define' the data stores in arc server? What can I check to verify that it is defined properly? And moreover, is this (registered/copy issue) the root cause of the publishing fail? This is very simple vector data based on a shapefile with 731 polygons in it. Thanks very much, cob ... View more

Robert we have a widget that will append a KML file to an existing layer (feature service) but it doesn't work for multi-part features. I think I've identified the pertinent code section that refers to the graphics index [0]. If we could just loop a cursor through the indices that are present I think it would work, but I can't figure out how to do it (not very good with json). Can you help? I can send you the whole widget privately but can't link it here at this time. Thanks! cob ... View more