Here is my problem :
In my “people” table, I want to display a count of “meeting” records created by each collaborator.
In my “meeting” table, I created a “created by” column that automatically sets itself to the creator of each new record. It is important that this information cannot be manually overwritten, this is why I chose “collaborator” field type instead of directly linking it to my “people” table since links can be changed by every user.
Now I need to link both tables so I can create a “count” column in my “people” table to count the number of meetings created by each collaborator. In a nutshell, I need the link between those two tables to be automatically set through the creator of each record in the “meetings” table.
The problem is that there is no way to set a “Collaborator” type in the Primary Field of my “people” table.
Do you have any suggestion that could work around it ?
Hope I am clear enough