OVERVIEW
Virtual Assistants
Kore.ai Platform
Key Concepts
Natural Language Processing (NLP)
Accessing Platform
VIRTUAL ASSISTANTS
Virtual Assistant Builder
Virtual Assistant Types
Getting Started
Creating a Simple Bot
SKILLS
Storyboard
Dialog Task
Introduction
Dialog Builder (New)
Dialog Builder (Legacy)
User Intent Node
Dialog Node
Entity Node
Supported Entity Types
Composite Entities
Supported Colors
Supported Company Names
Form Node
Logic Node
Message Nodes
Confirmation Nodes
Bot Action Node
Service Node
Custom Authentication
2-way SSL for Service nodes
Script Node
Agent Transfer Node
WebHook Node
Grouping Nodes
Connections & Transitions
Manage Dialogs
User Prompts
Knowledge Graph
Terminology
Building
Generation
Importing and Exporting
Analysis
Knowledge Extraction
Build
Alert Tasks
Introduction
Ignore Words and Field Memory
How to Schedule a Smart Alert
Small Talk
Digital Views
Overview
Configuring Digital Views
Digital Forms
Overview
How to Configure Digital Forms
NATURAL LANGUAGE
Overview
Machine Learning
Introduction
Model Validation
Fundamental Meaning
Introduction
NLP Guidelines
Knowledge Graph
Traits
Introduction
How to Use Traits
Ranking and Resolver
Advanced NLP Configurations
INTELLIGENCE
Overview
Context Management
Overview
Session and Context Variables
Context Object
How to Manage Context Switching
Manage Interruptions
Dialog Management
Sub-Intents & Follow-up Intents
Amend Entity
Multi-Intent Detection
Sentiment Management
Tone Analysis
Sentiment Management
Event Based Bot Actions
Default Conversations
Default Standard Responses
TEST & DEBUG
Talk to Bot
Utterance Testing
Batch Testing
Record Conversations
CHANNELS
PUBLISH
ANALYZE
Overview
Dashboard
Custom Dashboard
Overview
How to Create Custom Dashboard
Conversation Flows
NLP Metrics
ADVANCED TOPICS
Universal Bots
Overview
Defining
Creating
Training
Customizing
Enabling Languages
Store
Smart Bots
Defining
koreUtil Libraries
SETTINGS
Authorization
Language Management
PII Settings
Variables
Functions
IVR Integration
General Settings
Management
Import & Export
Delete
Versioning
Collaborative Development
Plan Management
API GUIDE
API Overview
API List
API Collection
SDKs
SDK Overview
SDK Security
SDK App Registration
Web SDK Tutorial
Message Formatting and Templates
Mobile SDK Push Notification
Widget SDK Tutorial
Widget SDK – Message Formatting and Templates
Web Socket Connect & RTM
Using the BotKit SDK
Installing
Configuring
Events
Functions
BotKit SDK Tutorial – Agent Transfer
BotKit SDK Tutorial – Flight Search Sample Bot
Using an External NLP Engine
ADMINISTRATION
HOW TOs
Creating a Simple Bot
Creating a Banking Bot
Context Switching
Using Traits
Schedule a Smart Alert
Configure UI Forms
Add Form Data into Data Tables
Configuring Digital Views
Add Data to Data Tables
Update Data in Data Tables
Custom Dashboard
Custom Tags to filter Bot Metrics
Patterns for Intents & Entities
Build Knowledge Graph
Global Variables
Content Variables
Using Bot Functions
Configure Agent Transfer
Update Balance Task
Transfer Funds Task
RELEASE NOTES
  1. Home
  2. Docs
  3. Virtual Assistants
  4. How Tos
  5. How to Add Data into Data Tables from UI Forms

How to Add Data into Data Tables from UI Forms

In this How-To, we will explore a scenario in a Banking Bot, where the user can create an additional account.

We will see how data collected from the UI Forms can be used to create the account in a Data Table.

For details on what UI Forms are and how it is implemented in the Kore.ai Bots platform, refer here.
For details on what Data Tables are and how it is implemented in the Kore.ai Bots platform, refer here.

Problem Statement

Consider a Banking Bot trying to address the following scenarios:

  1. An already registered user wants to open an additional account.
  2. There are three types of accounts that are available, each with further options:
    • Savings Account;
    • Checking Account with an option to opt for a Cash Card and set a Minumum Balance;
    • Credit Card with an option to choose the type of card to be Platinum, Gold, Silver or Basic
  3. The above data is collected from the user using a UI form.
  4. This data needs to be updated to the data table.

Pre-requisites

  • Bot building knowledge
  • A Banking Bot with access to
    • Customer details table as created here
    • Account details table, using the same steps shown in the above link create the following data table:
      1. Name, say accountdetails;
      2. Description, say Account details Table;
      3. Under the Column section add the following details:
        Column Name Type Required Additional Settings
        AccountId number Yes Encrypted & Max Length of 5
        AccountName string Yes
        AccountType string No
        CustId number Yes Reference table & column as
        customertable.CustId
        CashCard string No
        WithdrawalLimit number No
        CCType string No

    • UI Form, we will be using the UI Form configured as shown here.

Configurations

Let us consider each of the following scenarios one by one:

  1. Dialog Task to:
    1. capture the customer id;
    2. trigger the UI Form to gather account details; and
    3. invoke the service node to add the account data.

Dialog Task Configuration

We will be creating a dialog task and adding a form node to trigger the UI Form created in the above step and use a service node to make a service call to add the new account from the form data.

Create Dialog Task

  1. From the left navigation menu, select Bot Tasks -> Dialog Tasks.
  2. Click the + against the Dialog Tasks to create a new Task
    • Enter IntentName, say, AddAccount
    • Create & Proceed to open the dialog builder page.
  3. Retain the Intent Node default settings, and close the Intent Node.
  4. Click the + next to the intent node and select the Entity node. This will be used to capture the customer id
    1. Enter Name, say, CustId
    2. Select Type, as Number
    3. User Prompt, as Enter your Customer Id
    4. Close the entity node.
  5. Add a Service node to check for the validity of the customer id entered.
  6. Add a Logic node to proceed with the Form if the customer id is valid else prompt for the customer id.
  7. The InvalidCustId is a Message node with the following JavaScript:
    context.entities.CustId = null;
    print('You have entered an invalid customer id, try again');
  8. Next, add a Form node and from the dropdown list select the form (OpenAccount).
    • You will be prompted to select the Form Experience. Kore.ai Bots platform allows you to gather user input both from the form and through conversation based on the channel.
    • For this use case, let us select Only Form UI experience.
    • A Form Node would be added, you can customize the form name, etc.
    • We are changing the Name to OpenAccountForm and Display Name to Form to open account.
  9. Using a Service node, fetch any existing account details for the customer id.
  10. Next, we will see how to capture the values returned by the Form Node using a Script node and process the same to get the next account id value and set to null the unwanted fields.
    • Use the following script:
      //get the next account id
      var resultSet = context.GetAcctData.response.body.queryResult;
      var id = 0;
      
      if (!resultSet.length) {
          id=1;
      } else {
          for (var i=0; i<resultSet.length; i++) {
              if (id < resultSet[i].AccountId) {
                  id = resultSet[i].AccountId;
               }
              }
          id++;    
          }
      context.accountid = id;
      context.name=context.GetCustData.response.body.queryResult[0].CustName;
      
      //set unwanted fields to null
      if (context.forms.OpenAccount.accounttype == 'Savings')
      	{ context.cashcard = null;
      	  context.withdrawallimit = null;
      	  context.cardtype = null;
      	  context.type=context.forms.OpenAccount.accounttype;
      	  }
      	  
      if (context.forms.OpenAccount.accounttype == 'Checkings')
      	{ context.cardtype = null;
            context.cashcard = context.forms.OpenAccount.cashcard;
      	  context.withdrawallimit = context.forms.OpenAccount.withdrawallimit;
      	  context.type=context.forms.OpenAccount.accounttype;
      	  }
      	  
      if (context.forms.OpenAccount.accounttype == 'Credit Card')
      	{ context.cashcard = null;
      	  context.withdrawallimit = null;
      	  context.cardtype = context.forms.OpenAccount.cardtype;
      	  context.type=context.forms.OpenAccount.accounttype;
      	  }
  11. Use a Service node to add the account details using the context variables populated in the previous Script node.
  12. Your dialog with form and service nodes to update the data table is ready.
  13. Talk to bot and follow the steps to add an account to a given customer id.

Conclusion

In this post, we have seen:

  • How to fetch data from data tables;
  • How to trigger the From from a Dialog;
  • How to add the data captured from the form to a data table.
Menu