Latest Contributions by ModernElectric

@JenniferAcunto  My management team is asking that I revisit this and make improvements to my survey form and spreadsheet. For rounding purposes, need to figure out how to write an if/else statement within my XLS Form. Have have been able to get the calculation down from start time to end time.  Here is the situation. Lets say the Hours Regular time comes out to 1.17, according to our time record standards, it would round-up to 1.25. How would I write an if/else statement for another field that said: Timecard Hours = Hours Regular Time rounded by if/else statement. IF .17 = .25; IF .43 = .50, IF .63 = .75, and so on and so forth.  Can this be done in XLS Forms? Or if I had a table that had the conversion, could it pull the data and do a calculation and populate the Timecard Hours field? ... View more

@ZacharySutherby @NateLickteig_KendallCoTX @IsmaelChivite @MJBiazar  Was thinking, could I use the ObjectID of the feature/form within the Hosted Feature Layer as the unique identifier? Its known this number is auto-generated and unique to each feature and layer. If this is possible, how would I pull this number into the form? I am not sure when the actual feature is created in the feature layer on AGOL when a form is created.  Edit: I understand the ObjectID is created AFTER the Survey Form is submitted so it would not show up in the Survey Form for the viewer. However, I have a Power Automate flow created the takes the data, and creates a PDF print. Is there a syntax available to use the Object ID and print it to the PDF form? Progress Update: I was able to find away (in-case someone else reading this can benefit from it) to incorporate the feature's Object ID into the final report. I used Power Automate to take the Object ID, and include it as part of the printed PDF report name. Also, was able to use the generic syntax to print the Object ID to the report template. ... View more

@HeatherMcCracken  Yes, that did the trick. I actually had to load the Assignment Feature Layer twice. One for the symbols and one for the label(s), in order for the text label(s) to work, but it did the trick. Appreciate your help. ... View more

@ZacharySutherby @IsmaelChivite  Is this possible to do? ... View more

@CraigGillgrass  Following up on this. Is this still in the workings? I have recently created a new project and added some labels to the assignment from the Map View in AGOL. They show up there, but not displaying in Workforce. Thank You ... View more

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