To create a one-way link, you need to know the name and the location of the document to which you want to link. With a Write document or spreadsheet you need to know the name of the field or cell address whose value you want to access. If you want to link to a database you also need to know the table or query name, along with the field name and record number.
The link is created using one of the Remote functions. The remote functions you will most often need are:
WPGET(document_name, reference) |
Retrieve field from Write |
SSGET(document_name, reference) |
Retrieve field from Spreadsheet |
DBGET(database_name, source_table, field_name, record) |
Retrieve field from Database |
When you enter a remote function in a field in the current document, you need to specify the following:
Name and path of the remote document or database (otherwise the current folder will be searched).
Name of the field, in the remote document, whose value is sought.
When linking to a database, you will additionally need to supply the table name, field name and record number.
As well as returning single values, all field links can be used to return ranges, which can then be used to provide range totals, maximums, minimums, and so on.
The following examples should be studied. Also, for more on Remote functions, see Remote functions.
See:
Linking two spreadsheets together
Linking two Write documents togther