gristlabs/grist-core

Linking between tables in different documents

Opened this issue · 2 comments

pesaventofilippo commented

Describe the problem to be solved

It would be very useful to be able to link (get data using a formula column) between tables located in different documents, not only between tables under the same document.

What do you think?

Describe the solution you would like

Right now you can reference a field using $Table.Column, so something useful could be $Document.Table.Column, or having a function like $GetDocument("Name").Table.Column

felurx commented

#416 is about similiar stuff and has some discussion, but it looks like there wasn't anything done on it. It's marked as blocked by #791

vviers commented

If you self-host grist and have the GRIST_ENABLE_REQUEST_FUNCTION* turned on, what you describe sounds totally feasible using formulas 🙂

*enables the REQUEST function. This function performs HTTP requests in a similar way to requests.request. This function presents a significant security risk, since it can let users call internal endpoints when Grist is available publicly. This function can also cause performance issues. Unset by default.