はじめに
対話型AIプラットフォーム
チャットボットの概要
自然言語処理(NLP)
ボットの概念と用語
クイックスタートガイド
プラットフォームへのアクセス
ボットビルダーの操作
リリースノート
最新バージョン(英語)
以前のバージョン(英語)
廃止機能(英語)
コンセプト
設計
ストーリーボード
ダイアログタスク
ダイアログタスクとは
ダイアログビルダー
ノードタイプ
インテントノード
ダイアログノード
エンティティノード
フォームノード
確認ノード
ロジックノード
ボットアクションノード
サービスノード
Webhookノード
スクリプトノード
グループノード
エージェント転送ノード
ユーザープロンプト
音声通話プロパティ
イベント ハンドラー
ナレッジグラフ
ナレッジグラフの抽出
ナレッジグラフの構築
ボットにナレッジグラフを追加
グラフの作成
ナレッジグラフの構築
既存のソースからFAQを構築
通知タスク
スモールトーク
デジタルスキル
デジタルフォーム
デジタルビュー
デジタルビューとは
パネル
ウィジェット
トレーニング
トレーニングとは
機械学習
機械学習とは
モデル検証
ファンダメンタルミーニング
ナレッジグラフ
示唆
ランキングおよび解決
NLPの詳細設定
NLPのガイドライン
インテリジェンス
インテリジェンスとは
コンテキスト
コンテキストインテント
割り込み
複数インテントの検出
エンティティの変更
デフォルトの会話
センチメント管理
トーン分析
テストとデバッグ
ボットと会話
発話テスト
バッチテスト
会話テスト
デプロイ
チャネル
公開
分析
ボットの分析
NLPメトリクス
会話フロー
Usage Metrics
封じ込め測定
カスタムダッシュボード
カスタムダッシュボードとは
メタタグ
カスタムダッシュボードとウィジェット
LLM and Generative AI
Introduction
LLM Integration
Kore.ai XO GPT Module
Prompts & Requests Library
Co-Pilot Features
Dynamic Conversations Features
ユニバーサルボット
ユニバーサルボットとは
ユニバーサルボットの定義
ユニバーサルボットの作成
ユニバーサルボットのトレーニング
ユニバーサルボットのカスタマイズ
他言語の有効化
ストア
プラントと使用
Overview
Usage Plans
Support Plans
Invoices
管理
ボット認証
複数言語対応ボット
個人を特定できる情報の編集
ボット変数の使用
IVRのシステム連携
一般設定
ボット管理
ハウツー
会話スキルの設計
バンキングボットを作成
バンキングボット – 資金の振り替え
バンキングボット – 残高を更新
ナレッジグラフを構築
スマートアラートの予約方法
Integrations
Actions
Actions Overview
Asana
Configure
Templates
Azure OpenAI
Configure
Templates
BambooHR
Configure
Templates
Bitly
Configure
Templates
Confluence
Configure
Templates
DHL
Configure
Templates
Freshdesk
Configure
Templates
Freshservice
Configure
Templates
Google Maps
Configure
Templates
Here
Configure
Templates
HubSpot
Configure
Templates
JIRA
Configure
Templates
Microsoft Graph
Configure
Templates
Open AI
Configure
Templates
Salesforce
Configure
Templates
ServiceNow
Configure
Templates
Stripe
Configure
Templates
Shopify
Configure
Templates
Twilio
Configure
Templates
Zendesk
Configure
Templates
Agents
Agent Transfer Overview
Custom (BotKit)
Drift
Genesys
Intercom
NiceInContact
NiceInContact(User Hub)
Salesforce
ServiceNow
Configure Tokyo and Lower versions
Configure Utah and Higher versions
Unblu
External NLU Adapters
Overview
Dialogflow Engine
Test and Debug
デジタルスキルの設計
デジタルフォームの設定方法
デジタルビューの設定方法
データテーブルのデータの追加方法
データテーブルのデータの更新方法
Add Data from Digital Forms
ボットのトレーニング
示唆の使用方法
インテントとエンティティのパターンの使用方法
コンテキスト切り替えの管理方法
ボットのデプロイ
エージェント転送の設定方法
ボット関数の使用方法
コンテンツ変数の使用方法
グローバル変数の使用方法
ボットの分析
カスタムダッシュボードの作成方法
カスタムタグを使ってフィルタリング
Data
Overview
Data Table
Table Views
App Definitions
Data as Service
Build a Travel Planning Assistant
Travel Assistant Overview
Create a Travel Virtual Assistant
Design Conversation Skills
Create an ‘Update Booking’ Task
Create a Change Flight Task
Build a Knowledge Graph
Schedule a Smart Alert
Design Digital Skills
Configure Digital Forms
Configure Digital Views
Train the Assistant
Use Traits
Use Patterns
Manage Context Switching
Deploy the Assistant
Use Bot Functions
Use Content Variables
Use Global Variables
Use Web SDK
Build a Banking Assistant
Migrate External Bots
Google Dialogflow Bot
APIs & SDKs
API Reference
API Introduction
Rate Limits
API List
koreUtil Libraries
SDK Reference
SDK Introduction
Web SDK
How the Web SDK Works
SDK Security
SDK Registration
Web Socket Connect and RTM
Tutorials
Widget SDK Tutorial
Web SDK Tutorial
BotKit SDK
BotKit SDK Deployment Guide
Installing the BotKit SDK
Using the BotKit SDK
SDK Events
SDK Functions
Tutorials
BotKit - Blue Prism
BotKit - Flight Search Sample VA
BotKit - Agent Transfer
  1. ホーム
  2. Docs
  3. Virtual Assistants
  4. How Tos
  5. Adding Data into Data Tables from UI Forms

Adding 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.

Adding 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.
メニュー