Create a list from grouped by values in a colmun

Ask for Help
1

I have a people table, each people has a company, I would like to create a list in UI with all companies only, without showing people etc…
I do not have a company table.
One solution could be to create a table that automatically has all companies, or it can be done in the UI

Not sure how to do it
I am using native glide tables
Easy if i needed to do it in sheets
Let me know if there is any easy way that I have not found please.
Thanks

2

You could dynamically create a Company table from your People table. Do it like this:

  • Create a new table, call it companies.
  • Add enough rows to the table to account for the maximum number of expected companies
  • Add a RowID column
  • Add a Lookup column, that targets the RowID column. This will give you an array of RowIDs
  • Add a Find Element Index column. It should search for the RowID in the array of RowIDs. This column will result in an incrementing row number, starting at zero. Call this column RowIndex.
  • Add another Lookup column. This one should target the Company column in your People table. This will give you an array of all Companies.
  • Use a Unique Element plugin column to create an array of unique Companies
  • Use a Single Value column to target the unique Companies array, selecting the RowIndex from start.

The end result of the above should be a list of unique Companies, which you can use as the source of your list/collection.

3 Likes
3

I would take a different approach and use the same table.

  • Make sure you have a RowID column in your People table.
  • Create a Single Relation column that links the Company column to itself.
  • Create a Lookup column that returns the RowID from the relation
  • Create an IF column that compares the RowID in the row to the Lookup RowID. If it matches, return the Company name, Else return blank.
  • Create a list and filter if where the IF column is not empty.

This will give you a unique list of Companies.

3 Likes
4

hehe, I almost mentioned that option as an afterthought :slightly_smiling_face:

I guess it depends on the use case which is the better option. If the intention is to build a relation back to people and/or some other data and create roll ups or other types of aggregation, then it could be cleaner to have the company list in a separate table.

3 Likes
5

Thank you all, will try later and let you know

1 Like
6

Both methods are great suggestion I have used the first method but I populated the RowID amnually, Thanks!

7

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.