There’s unfortunately no way to force sync through a button. There used to be a hack for it but they shut it down.
If you need to request a parcel of data and not necessarily sync the whole table there’s a smart trick:
- in your request doc, run a cross-doc action that clicks a button in your remote doc
- in your remote doc, set up the button to remotely addrow/modifyrow in your request doc with a requested piece of data.
Takes a minute or so to deliver the parcel this way.