|
POST
|
@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
12-22-2023
08:29 AM
|
0
|
0
|
1726
|
|
POST
|
@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
12-22-2023
07:49 AM
|
0
|
3
|
1733
|
|
POST
|
I have been working on creating a Work Order form for our field crews and part of it is entering their time. I have learned a lot and figured out how to do a time calculation based on the start and end time that is entered and autopopulate into another field. And of course my dept supervisor throws a curve-ball. What I need to do (and not sure if it is passable), is: Regular Hours Field (Calculate from the start and end time IF between a specific period of time) ELSE, Overtime Hours Field (Calculate from the start and end time IF between a specific period time). Example: Start time 3:00 PM End Time: 7:00 PM Regular Hours: 2 Hours (Since end of schedule is 5pm) OT Hours: 2 Hours (Since OT starts of 5pm). Is this possible?
... View more
12-21-2023
02:16 PM
|
0
|
5
|
1824
|
|
DOC
|
@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
12-18-2023
10:02 AM
|
0
|
0
|
22696
|
|
POST
|
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
12-15-2023
02:21 PM
|
0
|
0
|
1718
|
|
POST
|
I've developed a series of Survey(1) with Survey123 Connect on my desktop and published them to our server. When going thru and testing the survey(s) and my workflow(s), the date and time is correct (used my desktop Survey123 App to fill-out the survey). I've built a workflow with Microsoft Power Automate to print a report (PDF) and send an Email when a new survey is submitted with the PDF report attachment. This works fine. HOWEVER, when I open the PDF report, the times are OFF, somewhat into the future. Need to figure out if and HOW I need to make a calculation in the Excel spreadsheet thru Survey123 Connect or something I need to do in Power Automate to make the time the same as it was entered by the Survey123 user. Please help, appreciate it.
... View more
11-22-2023
08:53 AM
|
0
|
2
|
988
|
|
POST
|
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
11-21-2023
07:08 AM
|
0
|
0
|
2891
|
|
POST
|
I've created a new project for with some infrastructure data included that is used as reference information for the viewer. I've added the Hosted Feature layers to the Web Map and configured the fields, including a relationship class to a table. Work just fine in the Web Map. However, when clicking on the feature in Workforce to pull-up the attributes, the main attributes to the Hosted Feature Layer are present, BUT not able to drill-down to the related table attributes. Is this something that isn't available OR maybe in the workings???
... View more
10-27-2023
07:51 AM
|
0
|
0
|
590
|
|
POST
|
I have a project in Workforce that has background electric infrastructure hosted feature layers that are used by our field crew(s) for reference data. I also have a script created that updated the hosted feature layer from a file GDB created in ArcGIS Pro (Removes replicas, disables sync, truncates/appends data and enables sync). Script works fine. However, when the user of the project on an Android App version of Workforce needs to see the changes that were uploaded, before going into the project they have to "Reload" the project. When this happens, there is an error message that says the feature layer (that was just recently updated from the script) cannot be loaded. I have to go back into the Web Map and reload/reconfigure the feature layer for it to work. Any idea on why this is happening and/or what I can do to correct it? Goal is to run the scripts/batch files on the nightly basis so our field crews have up to date information. Thank You
... View more
10-03-2023
08:37 AM
|
0
|
0
|
767
|
|
DOC
|
@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
09-26-2023
12:22 PM
|
0
|
0
|
24528
|
|
DOC
|
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
09-21-2023
12:48 PM
|
0
|
0
|
24693
|
|
DOC
|
Jake: This appears to fix the problem. Regarding the rest of the script: It works on a Polyline feature class/feature service. However, on a point feature class/feature service with and without attachments, I get an Exception: Unknown Error (Error Code: 500) at Line 190 (Appending Features). The Field Mapping has not changed.
... View more
09-21-2023
09:14 AM
|
0
|
0
|
24711
|
|
DOC
|
Jake: Thank you for providing this script. It is very helpful. However, I am having (1) minor issue. When I set the disableSync variable to False, I get an error that says cannot disable sync on the feature layer due to Outstanding Replicas. However, If I leave it as false, the script runs properly, but does not appear to properly update the data from the ArcGIS Pro Feature Class. Any suggestions?
... View more
09-20-2023
07:55 AM
|
0
|
0
|
24738
|
|
POST
|
I've been testing this with some of my feature class(s). Yes, in order for the Truncate/Append Python script to work - it has to be from a single GDB Feature Class to a single AGOL Feature Layer. This seems to be very very inefficient. Instead of having one Hosted Feature Layer with dozens of layers/tables/relationships, I will need to upload each individual feature class to a unique Feature Layer and build a script to update each individual feature layer.
... View more
09-15-2023
11:47 AM
|
0
|
1
|
3800
|
|
POST
|
The goal is to set a script/batch file to update the whole database. Issue with that is after having to update the working dataset (new development), I would have to update the AGOL dataset as well. Seems to be inefficient to 2 it twice. Plus, the attributes for billing and services information changes alot. I did find a script (Truncate/Append) that allows me to update the whole Hosted Feature Layer even when it has sync enabled. The problem is I have to upload each individual feature class to AGOL as a unique Hosted Feature Layer to utilize the script. Would have have (1) script for the whole Hosted Feature Layer (Composed of a few dozen Feature Classes and tables and relationships classes).
... View more
09-15-2023
10:42 AM
|
0
|
1
|
3849
|
| 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 |
Online
|
| Date Last Visited |
8 hours ago
|