Latest Contributions by ModernElectric

Alex We implemented ESRI Workforce for our electric and water crew(s) approximately 10 months ago. There were some serious learning curves and bugs we had to workout, but at this point, it has become a primary tool for our electric supervisor and field crew foremen.  Regarding the infrastructure dataset being included in the workforce project, that has been something I had to do a lot of trial and error. What I have seen that has worked is upload the dataset from a file GDB in ArcGIS Pro to a Hosted Feature Layer. This data is for information only, not editable by the crew(s). I use ArcGIS Online to open the dispatch and mobile worker web map and add the hosted feature layer as any other AGOL layer. You do need to make sure sync is enabled. If its not, we have ran into problems with updating the feature layer. I've also built a Python script to automatically update the dataset from ArcGIS Pro on a nightly basis.  If I can try to be some more help as you implement Workforce, please let me know. I will do what I can and what I've learned up to this point.  ... View more

@DougBrowning @ZacharySutherby  Thank you for this information. I have gone thru every part of those links and programmed and reprogrammed. Im not sure, but now I am thinking its not the UTC offset that is the problem, but something else? I can see the correct time in the survey that I select. However, after the Power Automate process runs, and the report is printed to a PDF, the time is off by 1-hour. I select 2:30 AM for the time called, but on the printed report it shows 1:30 AM. I've done the UTC offset in the form template according to the reference guide, updates to .XLSX file, even update the Power Automate flow and every single time, the time off by an hour. Is there something related to day-light savings that I am not configuring? I am seriously lost here and hope its something very minor that I am overlooking.  Update Note: I've isolated the issue to Power Automate. When I view the time in Survey123 (App & Windows), and doing a preview of the PDF report, the time is correct. However, when Power Automate creates the report when a report is submitted, the time is off on the PDF printed report.  Appreciate it ... View more

@Jim-Moore  Without the WHERE clause, the field doesn't know what to populate into the Inventory Number field based on the original search getting a match from the feature table. Long story short, nothing populates. Now, I can do the Inventory Number (1025) and the Description will autopopulate based on a match from the feature table. The goal is to reverse that action and have the foreman start typing in the description, find the exact one they want, and the inventory description auto populates from there. Much each for the foreman to start typing in cedar pole to find what they want versus memorizing 1000s of inventory numbers.  I thought just reversing the code in the spreadsheet would do the trick, but apparently not.  Any other suggestions? ... View more

@Jim-Moore @ZacharySutherby  Thank you for the response and the advice. However, that did not solve the the issue. I've attached updated screenshots and the excel file to see if you can help and determine what part of the coding is incorrect.   In my previous survey I built, I was able to use the Autocomplete search for the Inventory Number and have the item description and UOM auto-populate. Have been trying to reverse that by the user doing the autocomplete search on the Inventory Description since we have 100s of inventory numbers and easier to find a match on the description compared to trying to remember a specific number. Appreciate any additional help and guidance you can provide. ... View more

@ZacharySutherby @Jim-Moore  Wondering if you have any advice on this for me? Thank You ... View more

@ZacharySutherby  Appreciate your help.  My work around has been to make a stand-alone table in ArcGIS Pro and replace the domain with basic attributes. This, however is a process. I am in the process of writing a script that will do this automatically thru Python. Not having the knowledge in Java Script, I will have to learn.  I will experiment more. Appreciate you escalating the request. ... View more

@Vinzafy  I assisted me with this awhile back, but was never really able to figure out how to get it right. I've been asked to make major improvements to our initial elementary Survey123 forms and working on the design and coding in excel. Figuring this out is going to help me on a number of forms. Thank you ... View more

@AyanPalit  I wanted to see if I could follow-up on this. I am running into the same issue. Created a feature class in ArcGIS PRO, however need to use the same FC in ArcMap. I understand ArcMap/ArcReader is considered "Obsolete" at this time. Is there a work around I can do? Thank You ... View more

@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