In the Cross Doc sync settings if I use a filter with a canvas control or a formula, I will get access to the controls from the original document instead of the current document (thisDocument actually refers to the original doc).
I wanted to create a “hub and spoke” document architecture, where the sync table would be prefiltered based on an input in the new target doc. Since this is a “public” doc I don’t want to use post filtering (also for performance reasons).
Is there any way to prefilter the sync table based on the info from the target doc (input, docId, page title, etc)?
1 Like
I don’t think this is possible.
You are trying to sync data based on a personal control in the target doc.
The closest way is to use SetCrossDocSyncFilter() and SetPackSyncTableConfigValue() formulas to dynamically change the syncing filter. However, I am almost sure that it will not work using personal controls.
Cheers,
Arnhold
2 Likes
Thank you Felipe, I never saw these formulas before. Unfortunately they seem to be supported only in enterprise workspaces.
I don’t think the issue here is that it is a personal control, as I can target personal controls from the original doc. I also tried changing the control to be collaborative, but no luck.
What I would actually prefer in this case is to filter based on the document id (like “thisRow.Document=DocId(thisDocument)”) which is static data, and should be the same for all users. But unfortunately “thisDocument” refers to the original doc and not the target doc in the filter formula.
Any other ideas?
1 Like
