Search: clear-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 92Activities
- 10akaBot Vision
- 8akaBot Center
- 3Data Service
- 2App Connect
- … 3 more
Last author
- 45Giang Tran
- 39admin
- 14VuNH54
- 13DatPT
- 4Nhan Nguyen
- … 1 more
Creator
- 64Giang Tran
- 46admin
- 6Tuan Nguyen
- 3Nhan Nguyen
Last modification date
Creation date
Object type
- 1Activities
- 1Overview
- 1aka Bot Vision
Upload date
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
[8] Advanced Filter in Data Service
Located in
- Rendered document content
Step 1: Navigate to the Data tab of the desired entity in Data Service. Step 2: To apply more filters on your results list, click Advanced Filter. The pop-up Advanced Filter will open Step 3: User
…a conditions, click the corresponding Delete icon or if you want to clear all filter, click Clear all
- Title
[8] Advanced Filter in Data Service
- Location
Data Service
…[2] How to use Data Service
…[8] Advanced Filter in Data Service
- Raw document content
(% class="box infomessage" %) ((( **Step 1: ** Navigate to the **Data** tab of the desired entity in Data Service. ))) [[image:image-20230630132517-1.png]] (% class="box infomessage" %) ((( **Step 2
…to clear all filter, click **Clear all conditions** button ))) 1. Click **Filter** to rerun the search
[1] Design Form
Located in
- Rendered document content
Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit
…the ability to collect user data UI components are divided into 5 main groups, based on their functions
…to fill in. Then click Save when you are done. The below table describes frequently used configure
- Raw document content
|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components used to collect data|((( * Hidden * Container * Data map * Data grid * Edit grid * Tree ))) |Premium
…provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014
[2] Add New Field for Model
Located in
- Rendered document content
and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require
…and data type for each column Step 6: Click "Save" button Table of Content
…and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button
- Raw document content
the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png
…types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage
…the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image
Read Column
Located in
- Rendered document content
(String)* - The cell from which to start extracting the column data. By default, this is filled
…" Starting Cell (String)* - The cell from which to start extracting the column data. By default
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
…)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…to consider data security requirement before using this property. * **Display Name (String) **- The name
Read Row
Located in
- Rendered document content
(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1
…" Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled
…to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties
…(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1
…. Remember to consider data security requirement before using this property. * **Display Name (String
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable
[4] Business
Located in
- Rendered document content
based upon the value entered in the ROI data set table, as well as the days until your defined goal
…the Manual Time value entered in the ROI data set table. Goal Input Static display of your defined
…to date, based upon the Manual Time value entered in the ROI data set table. Displays the Top 10
- Raw document content
value entered in the **ROI data set table**. ))) |((( **Goal ** )))|((( Input )))|((( Static display
…in the **ROI data set table**. ))) |((( **Cumulative Time Saved** )))|((( Column Chart )))|((( Total time saved
…** )))|((( Input )))|((( Displays the current total of money saved based upon the value entered in the **ROI data
Excel Read Cell
Located in
- Rendered document content
Contact” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security
…is cleared. Output Result (OutArgument) - Stores the information from the specified spreadsheet cell
- Raw document content
(Checkbox)** - Check if you want to public it. Remember to consider data security requirement before using
…this check box keeps the formatting of the cell that you want to read. By default, the check box is cleared
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}
Excel Insert Columns Table
Located in
- Rendered document content
position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
…must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
- Title
Excel Insert Columns Table
- Location
Excel Insert Columns Table
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image
…)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want