Latest Contributions by JimW

I have a hosted feature service that can have five component types: asphalt base road (ABR), concrete base road (CBR), sidewalk (SWK), driveway (DWY) and grass (GRS). I have a related child table that stores bid items, quantities and costs. In my survey, the bid items are selected in a repeat and I currently have the bid items as an external choice. The bid item is selected in a select_one_external and the list is filtered using a choice filter statement based on the selected component type so that only the bid items that apply to the selected component are shown. When a bid item is selected, the name value is used in a pulldata statement to get the cost of that bid item that is stored in a CSV file and ultimately a total cost for that bid item and component is calculated. Some bid items apply to multiple components. I currently have a domain in my bid items table that lists all of the bid items that can apply to a given component type.  Below is a simplified example of my external choice sheet which is my domain in my bid item table: name label ComponentType 203  Process Trap Rock Base ABR 212  HMA S0.5 L2 <= 300 SY-inch ABR 247  Process Trap Rock Base CBR 256  HMA S0.5 L2 <= 300 SY-inch CBR 276  8 in. Reinforced CBR Installation <= 300 SY CBR 302  HMA S0.375 L2 <= 300 SY-inch SWK 304  5 in. Concrete Sidewalk SWK   This has been working well for a few years.  However a new contract was recently awarded and some bid items where added and costs changed.  I was going to generate a new list and append it to my bid item domain.  However, I found out that AGO domains don't allow you to have duplicate labels and as a result I cannot make any changes to the domain unless I go through and make each label unique, which may be what I have to do.   I did look into simplifying things so that my table above becomes this: name label ComponentType 203  Process Trap Rock Base ABR, CBR 212  HMA S0.5 L2 <= 300 SY-inch ABR, CBR 276  8 in. Reinforced CBR Installation <= 300 SY CBR 302  HMA S0.375 L2 <= 300 SY-inch SWK 304  5 in. Concrete Sidewalk SWK   But I couldn't figure out how a choice filter statement that would work.  It may be that I have spent too much time looking at this today and am missing something simple. And I still run into the issue with duplicate labels because my existing domain still has the same labels, which need to be maintained, because there is still work being done under the old contract. I attached my Survey in case that helps make any of this understandable. If anyone has any suggestions, I would love to hear them!  Thanks. ... View more

I have an additional 136 codes/values that I need to append to a domain on an existing hosted feature service in ArcGIS Online.  Is there a way to do this that doesn't involve copying and pasting values or directly editing the REST endpoint? A little background...this domain allows my end user to select bid items out in the field.  These bid items are tied to a contract and a new contract just started so I have a new list of bid items to add to this domain.  I know adding 136 additional choices to an existing domain may seem excessive and ultimately not that useful to the end user.  However, this domain has several groupings within the domain and I am using Survey123 to filter this domain to a more manageable one with far fewer choices that the end user sees.  Additionally, I have the appearance of this field in Survey123 set to autocomplete so the user can type and further limit what values display. Thanks! ... View more

I have a hosted feature layer that is composed of 11 layers.  I am trying to display some of these layers in a list element.  When I select an individual layer in the configuration panel, I get "No data" in the preview and the data table displays nothing.  However, I know there is data and the message below the table shows that there are 99 features.  Other layers within this layer work as expected.  Any ideas why this happening?  Am I missing something simple?  Thanks.     ... View more