Latest Contributions by Kara_Shindle

oh wow!  Thank you for your note.  I'm glad it was useful for you and I am always up for chatting if you want to brainstorm!  I'm excited for you and what you will accomplish! ... View more

Thank you! ... View more

You can copy the JSON files from the AGOL Assistant site.  You can also duplicate them on AGOL & save them with a different name. ... View more

Do the county or state lists HAVE to be in another layer? Because you could probably do this a few ways: 1. Using arcade, auto-populate the attribute using map viewer to look up intersecting polygon 2. Use pulldata() function to populate dropdowns with an external CSV file via Survey123 Connect   ... View more

Have you set the refresh setting on the survey itself?  I have had those settings conflict with Experience in the past. ... View more

I've been thinking about this issue a little - have you had any success with getting it to work?     I update the layer I run a map series on nightly.  It gets updated via one script that extracts the needed features to a geodatabase.  A second script then runs the map series.  After the first script runs, if I were to open the Pro doc, the map series updates automatically.   My second script, I just have the refresh built in automatically.  Have you thought about breaking this up and testing if it works if you update the layers and then try the map series?  Or maybe building in a delay? ... View more

I literally just figured this out yesterday!   I had a list was based off of a data source.  I created a window connected to the data that had the dynamic fields from the same data source as the list.  I then had the window set to display the selected features from the list/data source.     ... View more

I've created scripts that take a folder as an input.  You could probably create a geoprocessing service & put that into an app. ... View more

I think you can do this with the "edit" widget and set it to only edit existing records?  I've not tested the edit widget on related tables or attributes to tell for sure. However, I have built an experience that ties in survey123 to add attachments to point features. ... View more

Seems like it has an issue with your SQL query.  Your code is below:     sql_query = f"TAZ_REG = '{taz_value}'"       See a working example below:     whereClause = "TAX_DIST = '" + str(taxDistrict) + "'"       Why do you have a "f" at the beginning of your query? Also I believe you need to rework your quotes.  I would suggest testing your query by adding a print statement after it - you may see that your quotes are not getting inserted as Text   Update:  So testing this small bit of code: taxDistrict = 12 whereClause = "TAX_DIST = '" + str(taxDistrict) + "'" print(whereClause) I get this result printed to the console: TAX_DIST = '12'   You can also try building the query in ArcPro, switching to the SQL view & using that to help check your syntax. ... View more

Are you copying the code exactly as it appears in the box from the chat box?  Your search cursor has some loops in it that are not formatted right, and if the indents aren't in there, it's not going to run right.   import arcpy #geoprocesing layer creation #repair the geometry arcpy.management.RepairGeometry('USE_real_master_Martin_County_3_10_23_TAZ_CRA', 'KEEP_NULL') print("fetures repaired") #create points arcpy.management.FeatureToPoint('USE_real_master_Martin_County_3_10_23_TAZ_CRA','PointsWithin', 'INSIDE') print("points layer created") #Summarize points and feture layer arcpy.analysis.SummarizeWithin('USE_real_master_Martin_County_3_10_23_TAZ_CRA', 'PointsWithin','SummerizedPoints') print("SummerizedPoints created") #selections and calulations of the data # add calculation field arcpy.management.AddField('SummerizedPoints','Area_Per_Point', 'DOUBLE') print("Area_Per_Point feild created") #cleaning data #selection of all the condos arcpy.management.SelectLayerByAttribute('SummerizedPoints', 'NEW_SELECTION', 'Point_Count > 2') # Obtain list of TAZs unique_taz_values = [] with arcpy.da.SearchCursor('SummerizedPoints', 'TAZ_REG') as cursor: for row in cursor: if row[0] not in unique_taz_values: unique_taz_values.append(row[0]) # Loop through the list of TAZs, selecting each group of the same TAZ each time for taz_value in unique_taz_values: #select the current value of TAZ arcpy.management.SelectLayerByAttribute('SummerizedPoints', 'SUBSET_SELECTION', 'TAZ_REG = TAZ_REG.value') if ("Exclude = 'Exclude'"): #remove excluded arcpy.management.SelectLayerByAttribute('SummerizedPoints', 'REMOVE_FROM_SELECTION', "Exclude = 'Exclude'") #calculate the area of each point if excluded arcpy.management.CalculateField('SummerizedPoints', 'Area_Per_Point', '!MFM_ACRES! / (!Point_Count! - 1)', 'PYTHON3') else: #if there are not any excludes arcpy.management.CalculateField('SummerizedPoints', 'Area_Per_Point', '!MFM_ACRES! / (!Point_Count!)', 'PYTHON3') print("calculations complete") #clear out slection arcpy.management.SelectLayerByAttribute('SummerizedPoints', 'CLEAR_SELECTION') print("Program Done")   You should also be deleting your cursors when you're done to clean up memory, so at the end of this you would have something like:   del cursor   ... View more

I'm not overly familiar with Workforce, but what you describe I've done a good deal of with Python before.  I could also see Arcade playing a role in this workflow as well.  Alternatively, you might be able to accomplish this with attribute rules on the data side.   I saw this blog post on creating unique IDs, and it pointed to a resource for integrating Workforce with the Python API. ... View more

Without seeing your connect survey, my thoughts involve the following: - did you reformat the submission URL on the XLS settings tab?  (I know the url can be a pain when building in connect & must be a certain format to talk to the survey) - are you able to submit a response to the Connect survey outside of experience? - Are you using the same map doc & source layer for both surveys? Have you tried a new map?   ... View more