Hi all. I would like to have a drop down input box that shows a list of the unique values for a certain field of a certain thing, and then posts to the map page all addresses of instances of that thing.
For example, take the coffee shop app idea that was recently sent around on email. Imagine a similar app where users can upload their favourite coffee shops, and one of the fields for the ‘Coffee Shop’ thing is the ‘Shop Name’. Let’s say there are 20 coffee shops in the database, and that 7 of them are Starbucks, 5 are Costa Coffee, and the rest independent. I would like the drop down to show the list of unique names (without duplicates), and the user then selects one of the names, and the map shows the list of all shop addresses that have that name. I have tried setting this up in a group, but I am a) getting duplicate names and b) not managing to link the map display to the result of the drop down.
Any help appreciated. Thanks.