Is there a way to summarize previous survey data (with filters) to populate a calculated field within a survey?
I am trying to create a reservation request survey and would like to have a calculated field that shows the total reserved spots at the selected location and on the selected date. I think this may be possible in Connect, however, I need to link this survey to a map using ExB and that doesn't seem to work with Connect surveys (see other question here). When I try to set up the filters, I can filter on the text field, but I can not set a filter for "where date in survey is on date in submitted features". Is it possible to get the sum of field from filtered features?