Solving calculations on a host machine

Contents > Creating a database > Working with formulas and functions > Solving calculations on a host machine

Solving calculations on a host machine

Though calculations are typically evaluated on the client machine, certain types of unstored calculations are evaluated on the host machine. These include:

finds that involve a calculation using a Get function.

finds that involve a custom record privilege calculation using a Get function.

joins that involve a custom record privilege calculation using a Get function.

plug-ins that reside only on the client machine that involve any of the above calculations.

If the host machine requires status information from the client, the result depends on which Get function is used.

Get functions that evaluate the same on client and host machines

When you log in to a networked database as a desktop or web publishing client, your client machine transfers much of its current status to the host machine. This transfer of status information enables the host machine to return the same value as the client machine for remote finds and joins that use the following Get functions:

Get(AccountName)

Get(ApplicationVersion)

Get(CalculationRepetitionNumber)

Get(CurrentDate)

Get(CurrentHostTimestamp)

Get(CurrentTime)

Get(CurrentTimestamp)

Get(ExtendedPrivileges)

Get(FileName)

Get(FilePath)

Get(FileSize)

Get(HostIPAddress)

Get(HostName)

Get(MultiUserState)

Get(NetworkProtocol)

Get(PrivilegeSetName)

Get(RecordAccess)

Get(RecordID)

Get(RecordModificationCount)

Get(SystemPlatform)

Get(SystemVersion)

Get(TotalRecordCount)

Get(UserCount)

Get functions that may evaluate differently on client and host machines

The host machine will return the status information it received when you logged in from a client machine for the following Get functions. Because the status on the client machine might change after you log in, the host and client might return different status information for finds and joins that use these Get functions:

Get(ApplicationLanguage)

Get(DesktopPath)

Get(DocumentsPath)

Get(FileMakerPath)

Get(PreferencesPath)

Get(PrinterName)

Get(SystemDrive)

Get(SystemIPAddress)

Get(SystemLanguage)

Get(SystemNICAddress)

Get(UserName)

The host machine returns an empty value for the remaining Get functions.