Osymo Calc

Using OsymoCalc you can create your own specialized calculator. The calculator can contain input fields for entering values (numbers, date/time or texts), combo boxes and computed fields. The computed fields use formulas that are compatible with Microsoft Excel formulas.

 

Creating a new calculator

  • Create new calculator: Menu > New...
    or clone existing calculator: Menu > Create Clone...
  • Enter name of new calculator, press OK
  • Insert fields to the calculator using Menu > Edit... > Menu > Add

 

 

 

Adding/editing fields

You can add three types of fields to your calculator:

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.

 

 

Editing the calculator

Edit the calculator using Menu > Edit...:
  • Edit: edits the selected field
  • Delete: deletes selected field
  • Up: Moves the selected field up in the calculator
  • Down: Moves the selected field down in the calculator
  • Add: Adds new field into te calculator

 

 

 

 

Copyright Osymo. All rights reserved. Support: email@osymo.com