Latest Contributions by AyeletGreenberg

‎05-11-2023

I am going to do the join based on the Unique_ID field, it is just that I don't know which of the signs were updated and which weren't. So let's say the original layer has 100 records, with unique IDs ranging from 1-100. The vendor’s data uses the same Unique_IDs but contains only 70 records. I want to replace the corresponding records from the original layer with these 70 records, and keep the other 30 records, but I don’t have a way to know which Signs were updated and which weren’t. The table below represents both datasets. In the original data I need to replace only the records in red, and leave the ones in black untouched.

‎05-11-2023

I know they updated the signs because they worked in a specific area, and this is what they were supposed to do. The yellow points in the attached screenshots are ours, and the purple dots are the vendor's. The screenshot in the original message was an example, to help explaining the problem. This is the first part of a project that will include thousands of signs. so I can't sort the signs manually.

‎05-11-2023

We have a vendor that collects Signs data in the field. They couldn’t work with our hosted layer so they downloaded the data, worked on it (updated points location and other details), and then sent me the updated data. I now need to import the data back to the original GIS layer and replace existing records with those in the vendor’s data, based on the Sign_ID (unique field). But there is a problem - they didn't update all of the signs. So if there are 500 signs in the area they worked in, they updated about 450 of them, and the other 50 are not in their data. So my question is: is there a way to replace only part of the records in a table based on a unique ID? (Without knowing which Unique IDs were updated and need to be replaced) See the attached screenshot - the yellow points are our data (IDs= 6100, 6101, 6102, 6103), and the blue points are the vendor's data (IDs= 6100, 6101, 6102). So is there a way to replace only 6100, 6101, 6102 and keep 6103 as is? I can't use spatial proximity because their points often have different locations than the original points, and there are other close signs. (e.g. ID= 6101) Thanks

‎11-28-2022

@Dean_McGowan Unfortunately we can’t. It complicates the process, requires extra work, and is problematic when working with related tables where the common key is the Unit ID.

‎11-28-2022

Add the option to allocate/assign a range of unique numbers/IDs to an offline area, while creating it in the office. If there are multiple offline areas, each one will have a different and unique set of numbers or (alphanumeric manmade) IDs (i.e., not Global ID). Any numbers/IDs range that was assigned to one offline area, cannot be used in a different offline area. Each offline area will also be assigned to a specific user. No two users can download the same offline area. Each user will be able to add new features with unique IDs within the range assigned to their offline area. Users will be able to create offline areas on their devices (the same way as they do now), but without the option to add new features.

‎10-26-2022

@maoneill9& @MikaylaMinor It is doable. I created a relationship between our Storm Drain layer and the Inspection (related) table based on the Storm Drain ID. Please see the attached document that I put together with instructions on how to build it. I hope it will be helpful.

‎10-26-2022

How can I copy attributes from features displayed on a webmap to a new point feature (in a separate layer)? I'm looking for a process similar to the way it works in Workforce, where you can select a feature from a layer on the map and create an assignment (in a separate layer), and the assignment's location field is populated from the feature's fields. Thanks

‎09-21-2022

Where can the Dispatcher see the list of all the assignments, past and present? When I opened the Assignment table in the Dispatcher's map, the Assignment Type and the Worker ID were cryptic (see screenshot below). I was hoping for a convenient way to view and review assignments, similar to the way it is for Survey123 (under My Surveys), where you can edit and filter the survey results.

‎08-25-2022

Thanks, this might work but not exactly as it is in WAB, unless there is a way to show the same layer in two groups. For example, the Sewer Districts layer is in both the Sewer group and the Special District Group. Is there a way to do this without adding the same layer twice to the map?

‎08-19-2022

Is there a way to create a group with the same widget multiple times? Specifically the Layer List widget. Also, can I select only part of the layers from the webmap to be shown on the layer list? It was possible in Web AppBuilder, but I can’t find this option in Experience Builder. We have a map viewer with lots of layers, so to make it easier to navigate I grouped layers by subject. I added eight instances of the Layer List widget, and for each one I selected only specific layers. I then grouped all the Layer List widgets together. So when users are looking for Sewer data, for example, they don’t need to scroll through a long list of all the map layers, but instead they go to the Sewer Layer List group that contains only Sewer related layers and select from there. Screenshot attached. I created an Experience Builder project from the same map I used for the WAB Viewer, and I tried to mock the groups using the Column widget, but I could not select only specific layers; I had to show the entire layer list. Any suggestions on how to make this work in Experience Builder? Thanks!

‎03-28-2022

Hi Kelly, Thanks for your reply. Having the popup content displayed in the side panel is very convenient. Still, I also need the ‘Details’ section for additional explanations about some of the layers in the map. If I could edit the text under the ‘Info’ section, I wouldn’t need to use the ‘Details.’

‎03-25-2022

The 'Info' button on the sidebar opens a panel where it says: "Click on the map to view feature information". How can I edit this sentence, or instead, is there a way to remove this button? I can edit the content of the 'Details’ button, but having both ‘Info’ & ‘Details’ buttons is confusing and redundant.

‎03-15-2022

Thanks a lot! I could not figure out how to solve this problem, and none of the other solutions helped.

‎10-01-2021

Hi Uri I published the survey again, but it didn't solve the problem. The user can see the data, but the Analyze option still returns an error. The survey was created from an existing feature service with a related table. I checked another survey that was created in the same way and the user encountered the same problem with analyzing the data. I then shared a survey created from a feature service w/o a related table, and the user could open the Analyze tab and see the data. I noticed that data from related tables don't behave the same way as data from feature services on the Survey123 website. For example, I can't include photos in reports from related tables.

‎09-30-2021

I’m trying to share survey results with a user. The user can see the information under the Overview and the Data tabs but the Analyze tab returns this message “Cannot get necessary XForms file for the survey”. All three tabs loaded fine for me on different browsers. Please advise, Thanks

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by AyeletGreenberg

Re: Is there a way to replace only part of the records in a table based on a unique ID?

Re: Is there a way to replace only part of the records in a table based on a unique ID?

Is there a way to replace only part of the records in a table based on a unique ID?

Re: Auto-generate unique IDs offline while preventing identical submissions by multiple submitters

Auto-generate unique IDs offline while preventing identical submissions by multiple submitters

Re: Auto populate field in related table based on selection in Collector?

Populate a field from another feature's field by selecting on a map

A convenient way to view and review assignments

Re: Can I choose which layers will be shown on the Layer List? Can I group multiple Layer Lists?

Can I choose which layers will be shown on the Layer List? Can I group multiple Layer Lists?

Re: How do I edit the content of the 'Info' button on the sidebar?

How do I edit the content of the 'Info' button on the sidebar?

Re: Offline Map - SQLite Error

Re: Cannot get necessary XForms file for the survey

Cannot get necessary XForms file for the survey

Can I choose which layers will be shown on the Lay...

Re: Can I choose which layers will be shown on the...

How do I edit the content of the 'Info' button on ...

Re: Is there a way to prevent updating certain att...

Is there a way to toggle off all layers from the s...