Hi there - hoping someone can help me with a specific cross-doc issue I’m having. I’m just learning my way through cross-doc functionality as I attempt to separate a doc into two separate docs - one that will be for my “users” and one that will be for my “admins”.
Some background - I have a table of Things that my Admins will manage. My Users will need to report in that they have created a batch of one of those Things.
To support this, I have a cross-doc Table in my Users’ doc for the Things table in the Admin doc.
For reporting in, I’m using the Add Row action to add a new row to a “production log” in the Admin doc to as to centralize where these activities are reported to. I’m following the method outlined here:
In my “new table” (in the User doc) that contains my button for the Add Row action, I have a column called “Thing Produced” and it is a Select List defined by a filter applied to the cross-doc table for Things.
When I add my row, using the user’s input, my row gets added correctly but the row reference to the Thing gets lost - it comes across into the Admin’s table as just a string vs. a reference to the row in the Things table in the Admin doc.
Am I trying to do the impossible, or am I just not doing it right?
Second question - is this the right way to setup this kind of structure? i.e. having “users” reporting in to a central doc from a “user” doc that is shared with all users, thereby keeping information exposure between “users” to a minimum and keeping central control over the data reported in the “admin” doc?
Thanks much!