I want a user to be able to create a Meeting and add pre-made Agenda Items from a list. The meetings are for different departments, so there can be multiple meetings that share the same agenda item - the relationship would be “many-to-many”.
I’d like to show the details of the agenda items (Topic / Description / Type / etc) perhaps in a card format like this:
(I don’t think the keyword box can display more than one field)
The user could then click to select the agenda item to include it.
My idea is to have a field in the Meetings sheet that contains all the record IDs of the Agenda Items sheet that belong to it. This sounds to me like I need to use a JSON field.
Is there a formula I can use (on_click) to update a JSON field to add or remove these Agenda item IDs?