|
POST
|
Have not had a problem, but recently within the past 2 days, the Geoprocessing tool APPEND, will not work. It hangs or freezes or crashes. Doesn't matter if I am using ArcGIS Pro (3.3.1), Python (updating AGOL) or within a data model. Anyone else have this problem recently and/or in the past and if so, how to fix it? Causing a lot of problems without this critical tool.
... View more
08-14-2024
12:53 PM
|
0
|
5
|
2265
|
|
POST
|
@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
08-01-2024
10:48 AM
|
0
|
2
|
1992
|
|
POST
|
@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
07-31-2024
03:49 PM
|
0
|
4
|
2057
|
|
POST
|
@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
07-31-2024
03:09 PM
|
0
|
6
|
2066
|
|
POST
|
Good Afternoon I have a decimal field that is created from calculating the total time. IE 7:00 AM to 7:45 AM = 0.75 What I am trying to do figure out is additional rounding. If the field $regular_hours_1 = 0.18 I need to write a formula that calculates $regular_hours_round_1 = 0.25 Not sure the proper way to do this, either a rounding formula or an if/else statement. Between 0.00 - 0.12 = Round to 0.00 Between 0.13 - 0.37 = Round to 0.25 Between 0.38 - 0.62 = Round to 0.50 Between 0.63 - 0.87 = Round to 0.75 Between 0.88 - 0.99 = Round to 1.00 I have gotten this far on doing the time calculations, its this part that I cannot figure out. Appreciate it
... View more
07-31-2024
01:19 PM
|
0
|
9
|
2112
|
|
POST
|
@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
07-30-2024
03:37 PM
|
0
|
0
|
1191
|
|
POST
|
@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
07-24-2024
06:58 AM
|
0
|
0
|
2034
|
|
POST
|
@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
07-18-2024
12:42 PM
|
0
|
0
|
1337
|
|
POST
|
@ZacharySutherby @IsmaelChivite Is this possible to do?
... View more
07-18-2024
07:32 AM
|
0
|
0
|
2074
|
|
POST
|
@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
07-18-2024
07:29 AM
|
0
|
0
|
1345
|
|
POST
|
I've built a custom Survey form thru Survey123 Connect and been using it for awhile now. After additional review(s), it was requested that an auto generated sequential number be added to the final form print (I have a power automate flow that takes the form and prints to PDF). Not sure how, OR if this is possible to do? If we start with lets say 2400, the next time the foreman starts a new form from this particular survey, the field will auto generate 2401, or at least the user will have to possible do an action for the field to populate. Any advice on how I can make this happen? I dont have any idea how to write the code for it.
... View more
07-16-2024
03:33 PM
|
0
|
5
|
2157
|
|
POST
|
It has recently been asked if I could take out completed assignments and transfer/copy them to a new project or GDB for achieve purposes and to build a series of dashboards from. I initially downloaded the project thru ArcGIS Pro to a file GDB feature class. However, doing some brainstorming, it made sense to just take the completed assignments and move/copy them to a different project. This is all because of the GlobalID in the Assignment type. This brings up a challenge. I created a new project, and appended the GDB feature class into the new project. However, the assignment types did NOT transfer. I figured if I could copy the original project and append the feature class of historical assignments, the assignment type(s) would match up and wouldn't need to spend hours reassigning the assignment types. Does this make sense? Appreciate some help to accomplish this.
... View more
06-17-2024
10:02 AM
|
0
|
1
|
705
|
|
POST
|
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
06-17-2024
09:07 AM
|
1
|
0
|
4147
|
|
POST
|
@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
04-30-2024
09:50 AM
|
0
|
0
|
744
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-23-2026 10:58 AM | |
| 1 | 11-20-2025 02:52 PM | |
| 1 | 10-30-2025 12:42 PM | |
| 1 | 10-16-2025 10:51 AM | |
| 1 | 08-27-2025 08:47 AM |
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|