Data operation

This page is about Data operation.

• Get One Table Data
  • Choose source table
  • Set source column and display destination cell
  • Set search condition
  • Batch setting of columns to be retrieved
  • Batch setting of cells to be displayed
  • Related keywords
• Get Multiple Data From Table
  • Select Source Table
  • Set source columns and display columns
  • Set search condition
  • Set sort condition
  • Specify the start position of records to get
  • Limit the number of records to get
  • Output the number of acquisitions
  • Batch setting of columns to be displayed
  • Related keywords
• Get the Number of Records from Table
  • Choose source table
  • Set the output cell
  • Set search condition
• Display Combined Multiple Tables Data
  • Specify the join condition from the join condition section
  • Specify a join condition from the search condition section
  • Related keywords
• Insert Update Delete Table Data
  • Insert data into table
  • Update Table Data
  • Delete Table Data
  • Batch setting of columns to be registered and updated
  • Batch setting of cell addresses for data to be registered and updated
  • Related keywords
• Insert, Update, Delete Table Multiple Data
  • Create Employee Data Update Sheet
  • Get multiple record data
  • Add multiple data records
  • Update multiple record count data
  • Delete multiple record count
  • Batch setting of UTIL.CELLV function for data to be registered and updated
  • Related keywords
• Exclusive Control when Table Update
  • Exclusive Control when Table Update
  • Related keywords
• Send Mail
  • Create the action to send the mail
  • Set Mail Address
  • Set Subject, Contents
  • Set attachment file
• Cross Tabulation (Basic)
  • Set Target Summary Data
  • Set how to summarize
  • Set how to output
  • Related keywords
• Cross Tabulation (Advanced)
  • Calculate the summary.
  • Summary with formula
  • Related keywords
• Register the Data of the CSV file in the Table
  • Register the Data of the CSV file in the Table
  • Related keywords
• Save Table Data in CSV file
  • Save Table Data in CSV file
  • Related keywords