CELF Help¶
Please refer to CELF RPA Option Help for how to use CELF RPA (Robot Action).
- Login
- StartUp(5 minutes cooking)
- Table Management
- Create Table
- Modify definition of a table after the table being created
- Duplicate the Definition of the Created Table
- Export Table Definition
- Import Table Definition
- Export Table Data (CSV)
- Import Table Data (CSV)
- Set Permission for table Setting
- Tuning For Searching Table (Set Index)
- Generate Automatically Master Management Sheet
- Create application
- Create Sheet
- Change Row Height/Column Width
- Hide/Unhide Row or Column
- Insert Or Delete Row Or Column.
- Change Format Cells
- Configure a custom number format
- Change the Format of some Characters in a Cell
- Freeze Panes
- Add Control
- Add Image Into Sheet
- Add Graph In Sheet
- Create Sheet from Excel File
- Change Rows and Columns Number
- Erase Cell Border
- Change decimal point and thousands separator
- Set the maximum number of iterations of repeating action
- Allow Cell Input When Publish
- Print the sheet
- Set paper orientation, size, etc. for printing
- Set Print Area and Page Break
- Output the calculation result of formula to Excel output
- Set Hide Icons Printing Excel
- Set the operation of the sheet at the release
- Set the display of the sheet at the release
- Copy Sheet and Create New Sheet
- Revert to Older Version Sheet
- Define a name
- Export sheet setting information
- Tag a sheet
- Create Action
- Assemble Action set
- Write the comment in the action.
- Disabled Action
- Copy Action
- Specify action to run when displaying sheet
- Run Action Set when closing a sheet
- Run Action Set When Cell Value Changed (Basic)
- Run Action Set when Cell Value Changed (Applied)
- Use other application sheet as generic parts
- Exporting action set setting information
- Operation logging during execution of action sets
- Tag a action set
- Using Action
- Cell operation
- Sheet operation
- Data operation
- Get One Table Data
- Get Multiple Data From Table
- Get the Number of Records from Table
- Display Combined Multiple Tables Data
- Insert Update Delete Table Data
- Insert, Update, Delete Table Multiple Data
- Exclusive Control when Table Update
- Send Mail
- Cross Tabulation (Basic)
- Cross Tabulation (Advanced)
- Register the Data of the CSV file in the Table
- Save Table Data in CSV file
- Control
- File operation
- Action List
- Test run
- Publish/Unpublish
- Create app from Excel file
- Confirm application type
- Check the Excel file that is used to create the app
- Notes on the application after creation
- Description of operations by screen (list / single sheet)
- Description of operations by screen (Multiple sheet combination)
- How to use automatically created applications
- Structure of Automatically Created Application
- Modify automatically created apps
- How to customize your app
- Customizing the app after creation
- Set browsing privilege to app.
- Create a Report Screen
- Adding a management item
- Create a master table
- Display the 'last updater' and 'last modified date' information on the Header Information List Screen
- Add notification function
- Add workflow function
- Exporting and importing CSV files
- How to set up the app for printing
- Useful settings for CELF
- Workflow
- Basic Steps from Creating an App to Executing a Workflow
- Advanced Topics in Workflow Features
- Workflow Actions
- Start Circulation (Obtain Workflow Number)
- Execute Circulation Process
- Execute a Specified Circulation Process
- Check if Circulation Process Can Be Executed
- Display Circulation Status
- Retrieve Circulation History
- Display Comment Screen
- Retrieve a List of Circulation Data
- Obtain the Current Circulation Status
- Retrieve Next Step’s Person-in-Charge Information
- Create a Web App from a Table (CELF BrowserAccess)
- What you can do with a Web App
- Select the template of the app you want to use
- Select the table you want to operate in the app
- Customize the operation of the app
- Setting up the master for columns
- Setting Up Related Tables
- Improve App Usability
- Publish an app
- Using the App
- Using Camera Feature
- Operation description by template (App to list data and check details)
- Operation explanation by template (App for listing and editing data)
- Operation description by template (App to Register New Data)
- Instructions by Template (App for Creating and Applying Application Data)
- Instructions by Template (App for Reviewing and Approving Application Data)
- Use Web APIs
- What you can do with Web APIs
- Using Web APIs
- The common URL/request/response for each WebAPI
- Specify search conditions for the table and get a list of search results
- Fetch one record of table data
- Register one record of table data
- Update one record of table data
- Delete one record of table data
- Bulk registration of table data
- Bulk update of table data
- Registering and updating table data in bulk
- Delete table data in bulk
- Fetch the last modified date of the table (header information only)
- Fetching table data in bulk
- Check the usage status of the Web API.
- CELF AI
- External connection/core system collaboration
- Small technic/Reverse dictionary
- Process Multiple Rows Data
- Dynamically Add Buttons
- Get Current Row Column
- Refer Hidden Sheet Data
- Create List From Getting Data
- 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
- Restrict Operations With Users' Information
- Use Application When Offline
- Save Data When Offline
- Launch Application Using URL
- Launch Application From Task Scheduler
- Output Usage Status Report
- Paging
- Save the formula entered by the user to the database
- Save the characters entered by the user and the set format in the database
- Use names in actions
- Set formulas in action
- Store encrypted data in a database
- Decrypt encrypted data from a database
- Replace encrypted table data
- List of Shortcut Keys
- Paste Special
- Exclude condition if the value as search condition is empty
- Navigating through the app with the Tab key
- Various Registrations, Settings and Referrences
- Change Password
- Enable/disable two-factor authentication
- (For On-premises Version) Register the License
- Check the license
- Register and confirm users
- Save user and group information
- Batch registration of user and group information
- Register Group
- Register and Check Organizations, Positions, and Affiliations
- Saving Information of Organizations, Positions, and Affiliations
- Bulk Registration of Organizations, Positions, and Affiliations Information
- Change the setting for ‘Action set setting’
- Add new extension
- Update the extension license.
- Check RPA license usage
- Set Password Policy.
- Set Restrict Access by IP address
- Set up two-factor authentication
- Start CELF in a past version
- Set SAML authentication（cloud version）
- Set SAML authentication（on-premise version）
- Set encryption key information
- Check usage status
- SQL Action (Extension option)
- Retrieve data from a table using SQL
- Specify search conditions with parameters
- About the "Execute SQL with identifiers in quotes" option
- Notes regarding SQL actions
- Permission check for SQL actions
- Notes on comparing date and date/time type columns and strings in MySQL
- Notes on writing SQL when using PostgreSQL
- Small tricks / reverse-lookup on SQL action
- Frequently Asked Questions about SQL Action
- Workflow (Extension option)
- Registration and Initial Setup of Extension Options
- Setup of Organization Master App
- Basic steps for circulation
- Workflow Settings
- Workflow actions
- Start the circulation (get the workflow number).
- To execute a circulation process
- Execute the specified circulation process
- Check if the circulation can be executed.
- Display the circulation status.
- Get the history of circulation.
- Display the comment screen.
- Display the workflow administrator settings screen.
- Display the agent screen
- Get a list of circulation data.
- Obtain current circulation status
- Get information of the persion in charge of next step
- Determine if a user is a workflow administrator
- About migration to standard Workflow feature from old Workflow Extension
- UI Component (Extension option)
- Accounting software peripheral business application template
- Others
- How to install and upgrade the CELF runtime environment
- App performance
- Calculation formulas placed on sheets should be minimal
- Pay attention to other sheet references and action set calls
- For registering, updating, and deleting a large number of records, use the 'Batch execution of data updates'
- Set the Index
- Use VLOOKUP when searching for specific values
- Specify the cell range when performing the same process on consecutive cell ranges
- Take time to aggregate or sort joined multiple tables
- Format adjacent cells as uniformly as possible
- About automatic conversion of display format and value
- About automatic replacement of values compared to date/time type columns
- Differences between CELF and Excel sheet specifications
- Absolute reference cells after sorting by filter button
- Numeric (floating point) precision
- Handling of "February 29" (leap year) in 1900
- Behavior of numbers with more than 16 significant digits
- Operation when comparing a "number" with a "numeric string" using the comparison operator
- Automatic update of cells that reference Cut ＆ Pasted cells
- Behavior when the cell value specified as the function argument is blank
- About spill and arrays
- AVERAGEA function behavior
- COUNTA function behavior
- ISBLANK function behavior
- SUBTOTAL function behavior
- SUMIF function behavior
- COUNTIF function behavior
- MROUND function behavior
- CEILING function behavior
- FLOOR function behavior
- TRIM function behavior
- VLOOKUP function behavior
- HLOOKUP function behavior
- XLOOKUP function behavior
- MATCH function behavior
- ADDRESS function behavior
- Related sites and Various documents
Contact Us¶
Contact Us