Input fields

Title: title of the edit line in calculator

Name: name of the field in formulas

What:

• Any Value: User can enter arbitrary value in this filed (text, number, date/time)
• Number: only numbers are allowed (input mode is set to 123 automatically)
• Date/Time: date/time value
• Formula: user can enter the value into edit line as a formula (without starting '=', e.g. 150*760). Don't confuse with Computed field.

Combo box fields

Title: title of the combo in calculator

Name: name of the field in formulas

Items: combo box items. The items are separated by ||. E.g.:

inch||cm     or
male||female||baby

If the user selects the inch item, the value of un will be "inch". If you want specify the value of each item different form its text value, you can do it using :: separator.

inch::1||cm::2

If the user selects the inch item, the value of un will be 1.

Computed fields (formulas)

Title: title of the field in calculator

Name: name of the field in another formulas. You can left this field empty.

Formula: the formula. The formula is created in the same way as in the Microsoft Excel except you do not use cell references (a1) but input/combo field names.

Use the Insert menu to insert built-in functions.

See Osymo Calc Reference for more info on Osymo Calc formulas and built-in functions.