I have 2 sheets People and Groups. I want the People sheet to list in a sub-table all the Groups People are, in Group sheet to list all the People in those Groups. Is this possible? If not is there a workaround?
You can refer to this instruction to achieve it:
Hello, is this still the current way to implement many-to-many relationships? I have trouble linking the fields in a subtable field.
Hi, yes I’m having the same problem right now. I can easily link individual fields, but I can’t link subtable fields at all
Yes, about Many-to-many relationships, you could still find the information here: Referencing two sheets at once
Regarding Link and Load, please refer to this article: Link & load.
You couldn’t link data from subtables to your form, since a subtable could have many different values entered in an entry, but a regular field would only have one value. Subtable to subtable is the same.
If it’s not what you are looking for, please send a support ticket vis “Need Help”, provide the sheet URL and your demand and grand Ragic Support to access your database so that we could have a closer look.