POST
|
I had this question as well. My understanding is that ESRI is actually working on this right now for WAB. But I have a few workarounds. If there is a lot of duplicated data in your records, just take the data for each inspection that is unique out in the field, and then you can use a filter and field calculate all of the duplicate info in the web map itself, because you CAN perform field calcs on related tables. Just filter for that days date or whatnot, and then calc the relevant info. Or use default values when possible. We do this a lot for tree inspections. Cheers!
... View more
10-22-2020
11:09 AM
|
3
|
2
|
3501
|
POST
|
OK, I have figured this out. When you export a CSV file from web app builder, it exports with a default coordinate system and wkid number which it appends to the CSV file in the last three fields. If you delete the trailing default x/y/wkid fields in your csv before you upload it, you can successfully upload and append data to your existing related table. I'm not sure why this works, but it does.
... View more
06-05-2019
12:43 PM
|
0
|
0
|
1273
|
POST
|
Hey All- So, I jumped for joy at the prospect of being able to append data to my related tables directly in AGOL without having to go through the sometimes dubious process of making a local copy of my data and then doing the append in ArcMap. Or the slightly less dubious bet definitely more time consuming process of doing it through Pro. BUT, I have tried every way since sunday, and I cannot seem to get the AGOL append tool to function on my datasets. 1:M relationship, field matching is 100%, but when I pull the trigger, I get the "There was an error appending the uploaded data to the layer" message. Note, I have never tried this with spatial data, and I know that in the documentation somewhere it mentioned having your coordinates set to decimal degrees. So is appending nonspatial data to related tables not supported at this point? Anyone been able to do this? Cheers
... View more
05-09-2019
12:03 PM
|
0
|
2
|
1716
|
IDEA
|
Thus is a repeat from the questions section, hoping to get as many views as possible: Hey All- I work for a company that does a lot of field inspections, and one of the Achilles heels of AGOL/WebApp Builder "out of the box" has been that inspection records in a related table must be added individually. What I would LOVE to see is a widget in WAB that, similar to the batch attribute editor, allowed you to ADD a related record to multiple features in one fell swoop. In other words, if a hydrant flushing crew flushed 100 hydrants this week, it would be fantastic to be able to highlight those 100 hydrants, and then add a related maintenance record (with identical field values) to each with a few clicks that denotes they were flushed, without having to visit each point and add the same related data to each. I'd be happy to hear someone say this functionality already exists and I've just missed it somewhere in the last update cycle (PLEASE!), but I'm pretty sure it doesn't. I'm not a programmer, so while I'm sure there's a way to program your way out of this issue with database triggers and custom widgets, it's probably out of my and many others league(s) for right now. I think this would be a VERY popular widget in the field-data collection and management community, so any info on plans for such a thing would be appreciated. Cheers
... View more
03-21-2018
11:24 AM
|
49
|
7
|
4048
|
POST
|
Hey All- I work for a company that does a lot of field inspections, and one of the Achilles heels of AGOL/WebApp Builder "out of the box" has been that inspection records in a related table must be added individually. Or they can be added en masse to a related table by a relatively cumbersome process of exporting a table of inspections to be completed, editing that table, and then appending that table to the live feature service (not much of a time saver). What I would LOVE to see is a widget in WAB that, similar to the batch attribute editor, allowed you to ADD a related record to multiple features in one fell swoop. In other words, if a hydrant flushing crew flushed 100 hydrants this week, it would be fantastic to be able to highlight those 100 hydrants, and then add a related maintenance record (with identical field values) to each with a few clicks that denotes they were flushed, without having to visit each point and add the same related data to each. I'd be happy to hear someone say this functionality already exists and I've just missed it somewhere in the last update cycle (PLEASE!), but I'm pretty sure it doesn't. I'm not a programmer (enough python and SQL to be dangerous to myself and others), and we don't run server (I'm sure this is fairly common in the community). I'm sure there's a way to program your way out of this issue with database triggers and custom widgets, but it's probably out of my and many others league(s) for right now. I think this would be a VERY popular widget in the field-data collection and management community, so any info on plans for such a thing would be appreciated. Cheers
... View more
03-15-2018
05:15 AM
|
11
|
14
|
3573
|
Title | Kudos | Posted |
---|---|---|
3 | 10-22-2020 11:09 AM | |
11 | 03-15-2018 05:15 AM | |
49 | 03-21-2018 11:24 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|