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

Creating Text/Math/Date Variables

Regular variables containing text, numbers or date can be defined one of the following ways:

• By Math Formula
• By Text Formula
• By User Input
• By Input List
• By Calendar
• By Form

By Math Formula

Set the value of the variable by using a mathematical formula.

In the formula you can use the values of other variables, database fields, queries, etc. Know more about formulas...

Examples

[$orders] = queRecN(|All Orders|). Sets variable orders as the number of records from query All Orders.

[$orders] = [$orders]+[Quantity]. Increases the value of the [$orders] variable by the value of the Quantity field of the current record.

Note: If you want to use the field values of the current record, don't forget to specify its type in the "Use the following record type" text box:

By Text Formula

Set the value of the variable using the text formula.

A Text Formula is a text string that consists of several elements such as values of the record fields, formulas, variables, system values, etc. Know more about text formulas...

Examples

For example, there is a record with fields First Name and Last Name that store values Thomas and Anderson accordingly.

[$full_name] =[First Name] [Last Name^text UCASE]. Sets full_name as value Thomas ANDERSON. ANDERSON capitalized, according to the UCASE formatting.

[$full_name] = Dear [$full_name]. Adds prefix Dear to variable [$full_name]. Now [$full_name] equals "Dear Thomas ANDERSON".

Note: If you want to use the field values of the current record, don't forget to specify its type in the Use the following record type:

By User Input

Set the value of the variable using an edit field.

The user is offered to input the value of the variable directly while the script is being executed, for example:

The default value and the message text can be set by using text formulas.

By Input List

User is offered to select a value on the list as the variable value.

Options:

• Input window text - value-entry window title; e.g., you can enter "Select a value from the list".
• List of values - the list of values - one value per line; for example:
     London
     Moscow
     Paris
• List Style - can contain one of 2 possible values and defines the appearance of the value-entry window:
  

By default, this action puts the selected value (e.g., Moscow) to the variable. However, you can have the program put the value identifier instead of the actual value to the variable. To make that happen, the list items are to be defined as identifier->value pairs; for example:

1->London
2->Moscow
3->Paris

In this case, the list will appear the same way, but the selection of, for instance, London will write 1 to the variable.

This method is especially useful for the further work with the values in formulas. For example, this way you can make the tax selection:

0->No taxes
17.5->VAT (17.5%)
5->Internal 5% tax

Depending on the selected value, the variable will have 0, 17.5 or 5.

The list text can be set by using text formulas.

By Calendar

In this case, user will be offered to select a date using the calendar:

Options:

• Default Date - date set by default.
• Result Date Format - in which format the date is to be returned:
  • Text - date is written to variable as plain text. In this format, it can be used in queries, for displaying on the screen, etc.
  • For Math Formulas - date is written as numbers. This method is to be used only if you are planning on using the variable you are creating in math formulas...

By Form

Here, the user is shown the selected form in a different window, and field values are intered into the variables:

Learn more about this way of data entry...

See Also:

Variables

Recordset Variables

Script Designer

Action Editor

List of actions

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