Example Project I have a doc that multiple managers are working out of to manage our company contacts and projects. The doc has grown too large to use optimally so I have split everything into master docs and then created department docs that only sync portions of docs. For instance, I have a maste…

Hi @Tim_Sherrod the community has figured out how to do this by using hidden formulas to force syncing. Its not ‘instant’ but keeps things updated within a few minutes which is way more usable than an hour. I am using this for a client and as long as its disclosed that they need to wait a few minute…

Thanks @Johg_Ananda . I am actually trying to get it to work for me now to see if that would be sufficient. I think it might be, and it is nice to know your clients have been content with it. I tried following instructions but am failing to get the button to force a sync. In the example below, do you…

You have to use the automation / row-based change feature to do it. Its kind of hacky but required for now. Do you have that implemented?

[Screen Shot 2020-05-23 at 11.50.28 AM] Yeah, I tried but it doesn’t run when I test it. I have the button set up on the table that sends sends the information to the source doc for creating a new row. The timestamp is just Modified On() formula.

OK so you only need one row in the table to intiate the sync. Then you need to create a canvas button below, which responds to the automation. The canvas button presses the table button. Yes its confusing, but effective.

I really appreciate your feedback here @Johg_Ananda . I think I am still missing something, hopefully simple. So the Project Sync Request table is its own table with just two columns and the button in that table should perform a sync action against the cross-doc I want to sync. I need to push the “Cr…

Well I think I can use this to modify the row, so I wonder if I just have my main formula set up wrong and it is failing. [image] Pro hack: Trigger cross-doc sync with an action (hidden formula) Tips and Hacks Let’s say Doc A is a data source and Doc B is where you have t…

The button the user presses needs to do its function AND, using RunActions() modify the timestamp on Project Sync Request table. Then the automation detects that and pushes the button in that table’s row, which pushes the canvas button. Do you have that working?

I got it working! I had to create a new connection for the source doc. The other one was trying to sync but sending an error and freezing the sync. Good to go now. Thanks again! This was a tad technical for me to fill in some of the blanks. Thanks again @Johg_Ananda !

No sweat @Tim_Sherrod - these ‘failures’ you had is called the ‘learning process’ :slight_smile: great job!!

Getting end users to work with multiple cross-doc tables

Tim_Sherrod May 23, 2020, 5:23pm 8

Well I think I can use this to modify the row, so I wonder if I just have my main formula set up wrong and it is failing.

Topic		Replies	Views
Pro hack: Trigger cross-doc sync with an action (hidden formula) Tips and Hacks	37	7460	June 28, 2024
CrossDoc - Add Row Sync Time	4	1516	April 11, 2020
Cross Doc Sync Action Product Feedback	1	410	April 28, 2023
Is there a way to create button to sync cross-doc?	5	975	February 10, 2022
Cross Doc Sync'd Time	3	194	June 30, 2024

Getting end users to work with multiple cross-doc tables

Related topics