N:M comma list in same row

pierweb

Referring to the standard "Company->Organizations->Contacts" Form I would like to add a column, e.g. Teams, which shows a comma separated list of the teams the contact belongs to. Can this be done?
I apologize if this is trivial.

gabriel

While it is easy to do via subquery and comma-list aggregation, please never make changes to other peoples apps. You can extend apps - and by doing so overwrite forms; but for something this small, it would not be worth the effort I think.

I need to work on this app soon anyhow and I´ll add this as an optional column - eg. with the next version, you can click on the list settings and display this new column. It will not be shown by default as its not relevant to many and can take a lot of space.

pierweb

Dear Gabriel,
thanks for the kind reply. I referred to "Company->Organizations->Contacts" just to provide a concrete example. I also tried with subquery but without success. Can you describe what I have to do? I will do it myself without bothering you or changing the application for everybody.
Thanks again,
Pier

gabriel

This is the implementation via sub query and comma list aggregation - I removed some fields to make it more readable:

Edit: Do not forget to filter for the current contact - the filters are not visible on the screenshot.

pierweb

Great! I was totally wrong. Now I get the logic! Thanks again. Actually this is very important to me because my application is very much based on "Tags" which are typically M:N relations. It would be nice if some sort of "multiselect" option was available but I know that this is very complicated. Grist, if you know it, does it nicely but I kow it is a totally different system. I am not complaining, just saying.
Thanks again wholeheartedly.

gabriel

You can implement a single or multi value selection for filtering via collections. For an example implementation, take a look at the REI3 Password Safe application - in there we also use tags.