AnsweredAssumed Answered

Query for Related table in Inbox Query

Question asked by ben.bond on Jul 23, 2020
Latest reply on Jul 24, 2020 by ben.bond

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...

 

Thank you

Outcomes