Help with constraints for data validation

ZoieLowery

Hi there.

How can I create a constraint that will pull from previous survey entries and compare the values to what the user enters?

I need help with a survey I am creating for utility meter readings. I have the survey successfully created using a feature layer and related table in Survey123 Connect. The meter data is stored in the Meters point layer, and associated readings are stored in the Meter Readings related table.

My problem is that the end user has asked for a way to validate/QAQC the meter reading entries. The goal is for a user to input a meter reading, and have that entry compared to previous entries for that meter. A new reading should always be greater in value than previous readings. 

Each meter has a GlobalID that links it to the related table and a serial number that separates it from other meters. 

 

Any help is very appreciated!!

 

ZoieLowery

Alright. This was my attempt at writing the calculation for pulling the last reading.

pulldata('@layer', 'getRecord', 'attributes.Reading', 'https://um-facilities.maps.arcgis.com/home/item.html?id=a160d81f924545f4a563527c858bde0&sublayer=4')

Using this formula:
'pulldata("@layer", "getValue", "<JSON property>", "<URL>", "<WHERE clause>")
I don't know what the WHERE clause should be. What I want is for it to pull the latest inputted reading value for a given serial number. The serial number is autopopulating from the point they click in field maps that brings them to the survey.