Small technic/Reverse dictionary

This page is about small or applied technic.

• Process Multiple Rows Data
  • Prepare To Register Multiple Row Data Process
  • Create Action Set For Multiple Rows Processing
  • Execute process for registering multiple data count
• Dynamically Add Buttons
  • Get Data
  • Set 'Details' button along with data count.
  • Set action of 'Details' button.
  • Hide Management Cells
  • Related keywords
• Get Current Row Column
  • Get Current Row
• Refer Hidden Sheet Data
  • Create 'Hidden summary sheet'
  • Create 'Display result sheet'.
  • Refer Data In Another Sheet
• Create List From Getting Data
  • Get data
  • Create List Control
• Check Entered Characters
  • Check if a string matches the specified type.
  • Check if value is date or not.
  • Check if a string is mail address.
  • Check if a value is a number.
  • Check if a string is recognizable as a telephone number.
  • Check if a string is post code.
  • Check if a value is Time.
  • Check if a string is URL.
  • Check if a string conforms to a specified format.
• Check Characters On Enter
  • Check in a moment if input characters are all One-byte upper alphabet characters.
• Restrict Operations With Users' Information
  • Get login user ID
  • Get login user name
  • Check if login user belongs to the group or not.
  • Check if login user has system administrator authority or not.
  • Check if login user has database administrator authority or not.
  • Check if login user has sheet creator authority or not.
• Use Application When Offline
  • Download Application
  • Use Application When Offline
• Save Data When Offline
  • Check if current session is offline or not.
  • Save data temporarily.
  • Get temporary saved data.
• Launch Application Using URL
  • Get Application URL
  • Set Parameter
  • Access To URL
• Launch Application From Task Scheduler
  • Create Application To Execute Periodically
  • Create application URL to login automatically.
  • Create batch file.
  • Set In Task Scheduler
  • Related keywords
• Output Usage Status Report
  • Refer Usage Status
  • Use 'sys_operation_log' Table
  • Use CELF Usage Status Report
• Paging
  • Create a table
  • Create a layout
  • Set values for control
  • Create an action set
  • Run the application
• Save the formula entered by the user to the database
  • Display the formula entered by the user
  • Display formulas and values entered by the user
  • Create a sample app
  • Run the sample app
• Save the characters entered by the user and the set format in the database
  • Refer to format information
  • Create a sample app
  • Run the sample app
• Use names in actions
  • Use name defined as cell
  • Use a name defined as a range
  • Use a name defined as a formula or constant
• Set formulas in action
  • Set the result of a formula in an action
  • Set formula in cell with action
  • Related keywords
• Store encrypted data in a database
  • Set encryption key information
  • Use encryption functions
  • Store encrypted data in a database
  • Related Keywords
• Decrypt encrypted data from a database
  • Set encryption key information
  • Use decryption functions
  • Decrypt encrypted data from the database and display it on a sheet
  • Related Keywords
• Replace encrypted table data
  • Change encryption key information (encryption key)
  • Related Keywords
• List of Shortcut Keys
  • Shortcut keys for sheet operations
  • Shortcut keys for cell editing
  • Related Keywords
• Paste Special
  • Paste values
  • Paste the formulas
• Exclude condition if the value as search condition is empty
  • Configure settings to exclude conditions.
• Navigating through the app with the Tab key
  • Targets for Tab key navigation
  • Tab key operation example