I'm looking for a data expression/advanced formatting that will check if a survey123 'vehicle report' has been submitted by a user with a unique license plate based off a list of all license plates, an inventory list of ~200 or so records. The end goal would be if the license plate from the inventory does not have a matching report for that month, to list out the plate number so they can be contacted.
The survey123 has a .csv choice list of all license plates, and that same .csv is used in the dashboard for fetching associated information on the vehicle, so the license plate field is identical and works with the filters. I'm looking for something similar to the reference toggle in an indicator, which works if I only needed a count of distinct plates compared to total plates, but not for listing out the plate number.
Any help or advice is appreciated and am open to any suggestions!
