Format

beasscript-logo-small

BS: Define Format of Drop-down

 

Format

Description

bitmap

Create a Bitmap drop-down

dw_1.item.udf1.dropdown.format=bitmap

 

dropdownBmp

Return only file name from bitmap without folder name

Display all icons from folder beas software\beas\bmp

calendar

Create Calendar drop-down

dw_1.item.udf1.dropdown.format=calendar

 

dropdownCalendar

 

Return the date. If target field is type char, then the system return date in system format yyyy/mm/dd

color

Create Color drop-down

dw_1.item.udf1.dropdown.format=color

 

dropdownColor

 

Return defined color in Number and String fields

and the following variables

dd:r = red (0-255)

dd:g = green (0-255)
dd:b = blue (0-255)

You can define the style from drop-down for every column

the data defined with formatvalues

 

Example drop-down with 2 columns

dropdownformatstring

 

Define the format and then send the values with "formatvalues"

 

dw_1.item.udf1.dropdown.format=title=FirstColumn,bold,italic;title=SecondColumn,width=400,color=255
dw_1.item.udf1.dropdown.formatvalues=red<tab>redcolor<CR>blue<tab>blue color

 

beasscript-logo-small

BS: Follow Properties available

Property

Description

id=string

Define the Id of related datawindow

(only used from BSL, internal)

name=string

Name of this object. If not defined, the system use value1,value2 .... If the source comes from BSL, the system use the BSL field name as name.

title=string

Define the title of this field

translate=true/false

if true, all values will be translated from beas standard translation system

color=number

define color  (rgb)

bold

show this column bold

bmp=folder as string

display this column as picture

if folder is defined, the system read the picture form defined folder, otherwise from bmp folder
Only bmp,jpg,png supported

expression=expression as string

show this column as expression (formula). See datawindow

Example: replace stock information with available stock (source is BSL)

...dropdown.script.format=stock=expression=(stock - reserveredquantity)

width=x

Define width

italic

show in italic format

visible

visible rule (0 not visible, 1=visible)

alignment

alignment: left, center or right

height

height of this field

checkbox=format as string

show as checkbox

j=J/N, y=Y/N, c=C/N, 0=1/0

Delimiter is comma for properties and semicolon for the different columns