One-way links

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:

  1. Name and path of the remote document or database (otherwise the current folder will be searched).

  2. Name of the field, in the remote document, whose value is sought.

  3. 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

Linking from a Write document to a spreadsheet

Linking from a spreadsheet to a database