I have a feature service with a parent table and several related child tables.
Each child table supports a part of a weeks long workflow and has its own form that references the feature service. Responses entered in the child tables update fields in the related parent. I want this to happen in the background, however I can't seem to modify parent fields without manually refreshing the calculation.
If a create a new record with this form the calculations are automatic, but updating the parent requires clicking on this button.
For example:
Here is a simple form with a repeat:
type | name | |
---|
geoPoint | location_point | The point location |
dateTime | event_date | The date the point was collected |
begin repeat | child | The child table |
integer | entry | Some data entry that triggers a change to the parent |
end repeat | | |
text | event_closed | The event was closed |
The first two are collected in the initial collection form:
type | name | |
---|
geoPoint | location_point | |
dateTime | event_date | |
hidden | event_closed | |
The repeat and the "event closed" are collected in a child form:
type | name | |
---|
geoPoint | location_point | Read only (used for reference) |
dateTime | event_date | Read only |
begin repeat | child | The child table |
integer | entry | Some data entry |
end repeat | | |
calculate | event_closed | if(sum(${entry})>1,"yes","no") |
In the child form "event_closed" is invisible because it is set to a calculation. It should populate the parent field with either "yes" or "no" depending on the data collected, but it is not working that way.
When I expose the field in the form by changing from "calculate" to text I see the refresh button
which I have to manually press for the calculation to take place.
Is there any way to force this calculation so it doesn't require user input?
Survey123 - 3.6.153 (android and PC)
Survey123 Connect - 3.6.137
ArcGIS Enterprise 10.7.1