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
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.
hehe, I almost mentioned that option as an afterthought
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.