|
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
|
714
|
|
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
|
1252
|
|
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
|
881
|
|
POST
|
@ZacharySutherby @IsmaelChivite Is this possible to do?
... View more
07-18-2024
07:32 AM
|
0
|
0
|
1292
|
|
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
|
889
|
|
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
|
4
|
1375
|
|
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
|
530
|
|
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
|
3035
|
|
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
|
392
|
|
POST
|
@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
04-29-2024
04:13 PM
|
0
|
1
|
2934
|
|
POST
|
@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
04-16-2024
07:20 AM
|
0
|
3
|
3020
|
|
POST
|
@ZacharySutherby @Jim-Moore Wondering if you have any advice on this for me? Thank You
... View more
04-11-2024
03:09 PM
|
0
|
5
|
3064
|
|
POST
|
@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
04-11-2024
11:01 AM
|
0
|
0
|
1114
|
|
POST
|
@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
04-08-2024
02:26 PM
|
0
|
1
|
5559
|
|
POST
|
I am working on reworking my code in a series of my Survey123 forms/templates. Before, I made an AGOL table and pulled information from that. I am rebuilding the forms to use the PullData function to autopopulate the fields looking at a Hosted Feature Layer. The fields that are being populated have domains and when I run the form, the Domain Code is autopopulate VERUS the Domain Description. If I am pulling the Manufacture, I am seeing 511, but need to see the description (ACC). From Spreadsheet (Calculation Field) pulldata("@layer", "getValue", "attributes.XFMR_MANUFACTURER", ${hfl_url}, ${where_clause}) Is there something I am missing? Thank You
... View more
04-08-2024
11:44 AM
|
2
|
2
|
1227
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 4 weeks ago | |
| 1 | 10-30-2025 12:42 PM | |
| 1 | 10-16-2025 10:51 AM | |
| 1 | 08-27-2025 08:47 AM | |
| 1 | 06-17-2025 07:40 AM |
| Online Status |
Offline
|
| Date Last Visited |
2 weeks ago
|