I am working on a Survey123 app that utilizes the inbox for lechate monitoring at a landfill. I would like to use the inbox to create a list of all the wells they have to measure for each day.
I currently have the query set to [Status='Active'] and that will pull in all the wells that need to be measured. I then use a related table in a repeat for them to store the measurements.
The only problem is once they refresh the form all the wells will reappear. So is there any way to add a related table query to the inbox query to only show wells that are [Status='Active'] and do not have a related table measurement taken today.
I hope that is as clear as mud...