If the user is holding down the Shift, Caps, and Control keys when this function is evaluated, the text values for those keys are returned in the form of Shift, Caps Lock, and Control. The following formula can be used to show text values for keys being held down it can be used in a calculated field or a custom function:Ĭase (Int (Mod (keys 4)/2) 'Caps Lock ') &Ĭase (Int (Mod (keys 8)/4) 'Control ') & Calculation Dialog Interface The calculation dialog has four main areas: Fields, Operators, Functions and the area where you construct your formula. Returns 4 if the Control key is being held down, and returns 7 (1+2+4) if the Shift, Caps Lock, and Control keys are being held down. Instead, foundational concepts will be covered in order to prepare you for the formulas you will find in your journey as a budding FileMaker developer. When using Get() functions within field definitions, in most cases you should set the storage option to be 'unstored' so that the field always displays current data.

The constants for modifier keys are as follows: Returns the sum of the constants that represent the modifier keys that the user is pressing on the keyboard.

Filemaker pro 15 get foundcount