6 Replies Latest reply on Aug 16, 2016 5:25 AM by Jonathan Drummey

    Create set and apply it on multiple fields

    Gilberto Diaz

      I have 16 fields where the value is the same pool of 2,000 value options. Lets pretend the following:

       

      I want to ask a person to list all the cities they have visited:

       

      user   | city1 | city2 | city3 | city4 | city5 | city6 | city7 | city8 | city9 | city10 | city11 | city12 | city13 | city14 | city15 | city16

      user1 | San Francisco | Madrid | San Juan ......

       

      I figure out the top 7 most visited and I did create a set of those top 7 cities, but the set is created just on city1.

      How can I create a set of those top 7 cities and apply the set to all 16 cities fields?