Latest Contributions by ModernElectric

Exactly Yup, that is very easy. Thank You ... View more

@abureaux  Thank you for the advice. I believe I have figure out a good workflow for the form and to make it not too difficult for the user adding their time entry. Side Question: I am using Survey123 Connect and building the form via Excel (XLS Form). Is it possible to add a table as a note to the form thru the XLS form?  ... View more

@abureaux  Thank you for the information. I have been working on nothing but this updated form for the past few days, sending updates to my management team and receiving design feedback from them.  The overtime should rarely, if ever, reach the triple digits. However, I will make a note to address this issue. Let me ask this (based on the design feedback from my management team): The user selects the date and time in the form. The new request for the design is to have the rounding happen at the start time and end time and show up as a decimal. IE: Time called 7/31/2024 @ 1:13 PM = 13.25 and End Time 7/31/2024 @ 5:40 PM = 17.75  I have an idea on how I can accomplish this, but wondering if you have a trick? Goal is for the user to select and data/time and have everything calculated for them. Hope this makes sense what I am trying to get to. Overtime Hours Worked auto-completed based on the entered start and end time rounded from the starting/ending times. ... View more

@abureaux  I think this should do the trick. This shortcut inside the form will assist our crews from having to do the math. Thank You ... View more

@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