nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Update Collected Data on Device

ThomasHasselbeck

Hi All -

I have a collector inspection app that needs to calculate a 3rd field. It's not vital that the 3rd field is calculated in the field however the 3rd field does need to be seen if the asset is revisited.

To simplify I have a table in a relationship class with the fields:

Field1, Field2 and Field3.

(Basically this was built following Jeff's Hydrant example)

Worker collects values: Field1 = 250 and Field2 = 50. Field3 is NOT collected (Field3 = 0)

Worker returns to office performs a sync, I setup an update trigger within SQL database that calculates Field3 = Field1- Field2 (in this example Field3 = 200)

When the data is viewed in Portal I see all the fields with correct data values.

The problem that I'm seeing is that the data(inspection record) on the device doesn't get updated to show that Field3 = 200.

The only way (at the moment) to see the updated values is if I removed the collector app and reload it on the device.

There has to be a way to see the updated values after my trigger is executed. But I don't know how to "push" it back to the device.

Anybody have any ideas?

Thanks

Tom

Find more posts tagged with

Accepted answers

All comments

ThomasHasselbeck

Matthew -

Does collector work differently with data stored in a SQL database than say ArcMap or a webmap in portal does?

I have triggers set up on my SQL database (both in the table and view trigger folders) that fire when I do updates via ArcMap and through Portal but I can't get those triggers to fire when I make changes/updates using collector.

My suspicion is that both ArcMap and Portal work on the 'table' and collector is working on the 'view' but I can't seem to confirm this. If I understood the logic on how Collector worked with the SQL database, I might be able to solve my problem.

Thanks for you time

Tom

ThomasHasselbeck

Tobias -

Data was prepare per these instructions here.

To be clear: versioning is disabled.

Thanks

Tom

Thomas,

did you verify that geodatabase versioning isn't causing the behaviour you are seeing? In case this is versioned data, do you reconcile the data from the base table (where your SQL trigger updates Field3) with the version that Collector Sync's to&from before tapping 'Sync' in Collector?

ThomasHasselbeck

Hi Matthew -

Thanks for the quick response.

If by cache/resync you mean tapping 'SYNC' again on the main collector page, the answer is yes and the field is not updated. I have even added new inspection and all the records are not showing the update. I have also tapped 'refresh' from the menu and that doesn't update the records either. The only way I can see the updated Field3 (per my example) is by removing the app (i.e. manage>remove) then loading the app again. Which is an unacceptable workflow.

Thanks

Tom

MatthewBaber

Hi Thomas,

Do you cache/resync the device after the field is calculated and updated in portal?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.