Versions Compared

Old Version 12

changes.mady.by.user Sara Glore

Saved on

compared with

New Version Current

changes.mady.by.user Sara Glore

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
titleBGColorYellow
titleGrid Filter Shortcuts


%

Wildcard

=

value or .eq value will select all records equal to the value entered

>

value or .gt value will select all records greater than the value entered

>=

value  or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)

<

value or .lt value will select all records less than the value entered  

<=

value or .le value will select all records less than or equal to the value entered

<>

value or .ne value will select all records not equal to the value entered

~

value or .like value will select all records starting with the value entered - 

Status

colour

subtle

Red

true
titleOnly works for text fields; this is the default behavior for text fields if no operator is entered

*=

value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed - 

Status

colour

subtle

Red

true
titleonly works with numeric fields

value1..value2

value1..value2 or .between value1,value2 will select records between the values listed



Panel
titleBGColorYellow
titleDate Shortcuts

YeaR (Calendar)

Y - Jan 1 of current calendar year

R - Dec 31 of current calendar year

FiscaL

F - July 1 of current fiscal year

L - June 30 of current fiscal year

MontH (based on current system date)

M - first of current month

H - last day of current month

WeeK

W - Sunday

K - Saturday

PerioD (Posting Period)

P - first day of current posting period

D - last day of current posting period

Quarter

Q - first day of quarter

U - last day of quarter

T - today

+ tomorrow

- yesterday


...

Panel
titleBGColorYellow
titleKeyboard Shortcuts

The following keyboard shortcuts may be used instead of the mouse or in conjunction with the mouse:

FUNCTION

SHORTCUT KEYS

Create

Ctrl+Shift+Enter

Save

Ctrl+Shift+S

Cancel

Ctrl+Shift+X

Edit

Ctrl+Shift+E

Find

Ctrl+F

Print

Ctrl+P

Make screen smaller

Ctrl+- (minus key)

Make screen bigger

Ctrl+ + (add key)


Tip

When in the view or edit options in any record the ESC key will allow the user to return to the grid.