I have an events database which has a tags field used to categorise the events. Let's call the tags A, B, C etc. The tags are in a separate tags table and there is a many-to-many join table.
In a layout, for each event I have a calculated field which lists the tags which are joined to that event. I have achieved this using the List() function - List ( Tags 2::Tag ).
So against each event I get a list of tags, e.g. A, C, G, M, Z.
What I want to do is to make those separate listed tags clickable, either as buttons or hyperlinks, to trigger a script.
Separately it would be good if each tag had a different color, either as a button background or as a colored hyperlink. Perhaps using conditional formatting, though I have not found a way to apply conditional formatting to individual List() items.
Any insights would be most welcome.