Body: <p>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 <strong>First Name</strong>. 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 <strong>First Name</strong> column and list them as options in the menu.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-22T19:18:48.123Z
Comments.Text: 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?)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-22T20:11:16.830Z
Comments.Text: Correct. And once I selected Bob from that list and it would return all contact in the table with First Name = Bob.
Comments.UserDisplayName: zach
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-23T04:35:35.897Z
Comments.Text: 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.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-12-23T22:38:34.903Z
Comments.Text: 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.
Comments.UserDisplayName: Aidan
Tags: <javascript><ajax><searchkit><formbuilder>
Title: Can you create a select menu that contains all values in a certain column?
ThreadText: # Can you create a select menu that contains all values in a certain column?
  
  (Asked by: username_0 on 2021-12-22)
  
  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.
  
  **Tags:** javascript, ajax, searchkit, formbuilder
  
  > **Comments:**
  > **username_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?)  
  > **username_0**: Correct. And once I selected Bob from that list and it would return all contact in the table with First Name = Bob.  
  > **username_1**: 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.  
  > **username_2**: 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.  
  
  ---
  
  ## 0 answers
  
  