Is there a way in afform/Form Builder to create a select menu that contains all values in a specified column? An example would be First Name. I know that afform offers search fields, but these are generally based on how a Contact Field is set up. Since First Name is an open text field, the search field in afform will be an open text search. I am wanting to create a select menu that will synthesize all of the data in the First Name column and list them as options in the menu.

  • 1
    so it would have a list like: Anna, Albert, Barbara, Bob etc (and there may be 7 Bob's and 4 Anna's but the list will only show 1?)
    – petednz - fuzion
    Dec 22, 2021 at 19:18
  • Correct. And once I selected Bob from that list and it would return all contact in the table with First Name = Bob.
    – zach
    Dec 22, 2021 at 20:11
  • so in the sequel sense 'group by'. sorry i have no idea. was just trying to help elucidate the requirement in hope others can answer it.
    – petednz - fuzion
    Dec 23, 2021 at 4:35
  • 1
    So like when you add a filter on a spreadsheet - the unique values in the column are presented as a select list. I don't know how/if that can be done currently but would be a nice addition.
    – Aidan
    Dec 23, 2021 at 22:38


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.