Latest Contributions by ModernElectric

@Vinzafy  Question for you. I have been reworking my code in my spreadsheets for Survey123 Connect. Previously, the pulldata function was looking at a stand-alone table. Now, I am trying to pull the data from a hosted feature layer that is published from ArcGIS Pro. Some of the feature classes/fields use Domains. When I run the code for the autopopulate based on a previous entry, the field is populated with the Domain Code. That is not helpful. I need the field to populate the Domain Description. How do I ensure that happens? Appreciate it ... View more

@JakeSkinner  This version is working great. Been working with it all week on my electric and water dataset(s). All of my relationship classes stay intact and the attachments are all loaded after running the script. Will continue to work with it and develop my update workflow and let you know if I run into any new issues or bugs. As of now, the Hosted Feature Layers are used in a web map being used in Field Maps. We are also using ESRI Workforce for our field crews and those maps/datasets need to have sync enabled, I am curious on adding those feature layers to some of our Workforce Projects and seeing how this update procedure works. Appreciate your help!! ... View more

@JenniferAcunto  I appreciate your assistance on getting me started. Using ArcGIS Survey123 Connect, there are examples that have JavaScripts associated with the spreadsheets in different downloadable examples. I will do some research to see how I can learn JavaScript and write a script to tell the spreadsheet if the date is within working hours or overtime hours.  ... View more

@JenniferAcunto  Jen: Thank You!! Looks like you are understanding exactly what I am trying to accomplish. I was able to take your example and build a test and it does exactly as you illustrated. If we could, and escalate it just a little? Our field crew's working hours are Monday to Friday from 7:30 AM to 4:00 PM PST. Anything outside of those hours and on weekends is all considered automatic overtime.  In order for this form, and future forms to be more user friendly, we want them to be able to enter their start time and end time and allow the formulas to do the calculations for them to determine their regular hours and if it during off-time, their OT hours calculated.  Appreciate your ongoing assistance ... View more

@JakeSkinner I have been able to get the code to work on a GDB that does not have any attachments or relationship classes. However, when I move onto a different GDB that does have relationship classes, I get the Error Code: 400 which indicates the Layer Truncate isn't supported on an origin layer in a relationship.  When I go thru ArcGIS Pro to Share/Ovewrite the Hosted Feature Layer from the GDB that has attachments and relationships, works out fine. However, the purpose of doing via the Python Script outside of ArcGIS Pro is to be able to run it from a Batch file. At this time, is there a work around for this, that way I can keep the relationship class intact? Appreciate your help ... View more

I have had issues with this in the past. One of the work-arounds we have found that works for us is to go into the app settings (Android) and clear the cache. The other SOP we have done is each morning, the user (mainly the foreman) is to log-out of workforce and log back in. This typically re-syncs up with the server, sometimes. I haven't had any other issues since we started doing these (2) items. However, what might work for us might not work for you, just be advised. Good Luck. ... View more

Thank you for the information and the video, has been a real help in designing my workflow. One of the issues I am having, and not sure if its something in Power Automate or the Survey123 Connect app/excel I need to do.  In the time fields, it allows the user to enter the time normally (ie 8:05 AM). However, when the report is printed, either from Survey123 (website) or thru my workflow in Power Automate, the time comes out in military time format. Looking thru the syntax, it doesn't allow me to format the time, as I can with a date entry. Any idea how I can fix this, since it was asked that I format the time entry on the printed PDF report to not be in military time. Thank You ... View more

@JakeSkinner  Wanted to provide a follow-up and see if you can identify what I am still doing wrong. First part of the batch file is to unregister the replicas. This works fine. Next is to run the script you provided and update the feature layer from the GDB Feature Class (FC without attachments). DisableSyc = True. The script runs fine without crashing and it appears the Feature Layer is updated in AGOL. However, here is the new issue I am having: These feature layers are used in ArcGIS Workforce and have editing abilities. When the project in workforce is opened, or attempted to be opened right after running the update script(s), it says the Feature Layer cannot be loaded. I have to go back in and remove and readd the layer and save the web map for it to work. Any ideas? Update: I have been doing a bunch of trial and error with this issue and havent been able to figure out why its happening. Specifically, the Field Worker project on an android phone/tablet is where I am running into issues. After running the script, doing the Sync feature on the app, does not reload the fresh data. Backing out and doing a Reload of the project, gives the error. Appreciate ALL of your help. ... View more

BINGO!! I went thru and recreated the Feature Class in ArcGIS Pro without the attachments, reshared it to AGOL and updated the script and it updated without crashing, I assume because I did not have an attachment table associated with the FC.  However, the attachment(s) are a key component to the feature(s). Is there a workaround to be able to include these in the script update process? ... View more