About    Download    Order    Support

Recent News

InnPlanner 2010 Released New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... 2010 Feb 10

InnPlanner 2010 RC1 InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. 2010 Jan 14

Hotel Software Documentation

Data Functions

Data Functions

F (|Field|)

Returns the value of a Field of the current record. This function is equivalent to the square bracket operator [].

Examples:

F(|Price|), returns the price field value;

F(|Quantity|)-[Quantity], always returns 0,

RF (RecordID, |Field|)

Returns the value of a field of a record with RecordID.

Examples:

RF(107,|Price|), returns the price field value of a record with ID=107;

FLen (|Field|)

Returns the length of a Field of the current record.

Examples:

If Title field of a record is "Record", FLen(|Title|) returns 6 (number of chars);

If Title field of a record is "Hello", FLen(|Title|) returns 5.

Special Functions for Script Designer

Note. These functions is available only when editing scripts

User(DefaultValue) - only for script designer

This function opens an input dialog and prompts the user to specify its value. For example, when user clicks the button that changes the value of the Quantity field according to the formula: Quantity=[Quantity]+User(1), the value of the Quantity field is increased by the specified value. If user clicks Cancel, the calculation of the formula is aborted. The optional parameter DefaultValue is used to define the default value of the function.

Instead of this function it is recommended to use a script with preliminary input of data into the variable.

Today"s Poll

What software do use for your inn/b&b/hotel/etc?

Home Page | Contacs | Terms and Conditions

Copyright (C) 2001-2010 Binary Brilliant Inc