edit history picture_as_pdf (visionx) VisionX Actions picture_as_pdf Table of Contents Introduction Basics Events Create / edit event Actions Tab Action Create Statements Sort Statements Delete Statements Command Condition Repeat Validate, Finish and Cancel Search for actions Create, Edit or Delete Formulas Parameters List of events Screen On Load On Active On Close Tabset / Editing Panel Tab Activated Table / Input Fields Row Value Changed Before Row Selected After Row Selected Before Inserting Row After Inserting Row Before Inserted Row After Inserted Row Before updating Row After Updating Row Before Updated Row After Updated Row Before Deleting Row After Deleting Row Before Deleted Row After Deleted Row Before Restore Row After Restore Row Before Reload Row After Reload Row Button / Hyperlink Create Action Validator Create Validation List of actions Application Logout Reload all screens Show error message Show information message Silent abort Data management Ask before delete Assign column name Assign table Assign table for editor Calculate value Create unique identifier Delete all records Delete record Deselect Disable Delete cascade Disable Delete in table Disable Edit in table Disable Insert in table Disable data manipulation in table Disable fetching data Disable record lock Disable search in memory Disable sort in memory Disable store on server Duplicate selected record Enable Delete cascade Enable Delete in table Enable Edit in table Enable Insert in table Enable data manipulation in table Enable fetching data Enable record lock Enable search in memory Enable sort in memory Enable store on server Fetch all Insert record after Insert record before Insert sub record Make value unique Reload table Restore selected record Save table Search by key Search by value Select first record Select last inserted record Select last record Select next record Select previous record Select record having value Set ascending sort Set column default value Set column editable Set column label Set column mandatory Set column not mandatory Set column not searchabel Set column not sortable Set column readonly Set column searchable Set column sortable Set column width Set current date Set current user Set descending sort Set label with calculated currency Set label with calculated date Set label with calculated date short Set label with calculated date time Set label with calculated date time short Set label with calculated time Set label with calculated value Set read ahead count Set search current user Set selected column Set selected row Set value Set value with concatenated text Store selected record Debug Debug log Error log Info log Print to console Documents Download file Download report Import report (insert) / (merge) Remove file Save report Show file Show report Upload file Table control Disable header sorting Enable header sorting Hide Delete button Hide Duplicate button Hide Edit button Hide Export button Hide New button Hide Search button Hide Search record Hide focus rectangle Hide gridlines Hide horizontal lines Hide selection Hide table control buttons Hide vertical lines Set maximum row height Set minimum row height Set row height Set sort order column name Show Delete button Show Duplicate button Show Edit button Show Export button Show New button Show Search button Show Search record Show focus rectangle Show gridlines Show horizontal lines Show selection Show table control buttons Show vertical lines Tools Call server action Open Website QR Contact QR E-Mail QR Geo location QR Phone number QR Text Send e-mail Send e-mail with custom server Send e-mail with custom server (no TLS) Send html e-mail with custom server User interface Activate autoresize columns Activate responsive design Add style Allow focus Deactivate autoresize columns Deactivate responsive design Disable element Disable tab Disable translation Do not allow focus Do not preserve aspect ratio Enable element Enable tab Enable translation Hide button border Hide column Hide editor border Hide element Hide navigation Preserve aspect ratio Remove style Request focus Save editor immediately Save editor not immediately Select tab Set background color Set background image Set button margins Set display mode Set divider position Set element editable Set element not editable Set font Set gap between text and image Set horizontal alignment Set horizontal text position Set image Set label Set maximum size Set minimum size Set mouse over image Set navigation mode Set placeholder Set preferred size Set pressed image Set tab image Set tab text Set text color Set tooltip Set vertical alignment Set vertical text position Show button border Show button border if mouse is not over Show button border if mouse is over Show column Show editor border Show element Show navigation Start editing Toggle button down Toggle button up Trigger validation error Work screen Center this screen Close screen Close this screen Disable manual save and reload Discard all changes Enable manual save and reload Open Screen Reload all Save all changes Set Parameter Set Parameter with calculated value Set Parameter with concatenated text List of conditions Conditions Are equal Are not equal Are validations in area ok Are validations ok Has record Has role assigned Is Desktop environment Is Html5 environment Is Mobile environment Is REST environment Is Service environment Is Test environment Is between Is column changed Is e-mail invalid Is enabled Is first record selected Is greater Is greater or equal Is importing Is last record selected Is longer Is not between Is pressed or checked Is record selected Is row selected Is screen showing Is selected row greater Is selected row greater or equal Is selected row smaller Is selected row smaller or equal Is shorter Is smaller Is smaller or equal Is tab selected Is visible Not has record Not has role assigned Not is longer Not is record selected Not is row selected Not is shorter List of formulas Arithmetic operations Group Functions avg / avgNoValue min / minNoValue max / maxNoValue count / countNoValue sum / sumNoValue sumToSelected / sumToSelectedNoValue first / firstNoValue last / lastNoValue Date calculation addYears addMonths addDays addHours addMinutes addSeconds yearsBetween monthsBetween hoursBetween secondsBetween truncYear truncMonth truncDay truncHour truncMinute truncSecond now Date group functions first / firstNoValue last / lastNoValue min / minNoValue max / maxNoValue avg / avgNoValue sumToSelected / sumToSelectedNoValue sumFromSelected / sumFromCurrentNoValue sum / sumNoValue count row noValue Text operations lpad rpad ltrim rtrim trim user This is an old revision of the document!