So I've created a feature layer for COVID-19 cases at Province Level. I have added the fields Confirmed Cases, Recoveries, Deaths and Active Cases.
So for the Active Cases field, I used the SQL Calculate component so that the system automatically updates the values in that column.
I wanted to ask if there is a way, whereby I can make sure that every input value I place in the other fields will result in the automatic update of the Active Cases field without having to run the expression again.
I turned on sync for the feature hosted layer but the changes do not seem to be automatic.
If there a way?