Connect to Datasource

Now you have your first WhatsApp chatbot working properly and people can make a booking on your bot, but how to check the booking record?

In this section, we are going to teach you how to save user's data into Datasource so you can have a copy of the record.

---

What is your Result?

Check booking record in Datasource

Property	Description
Successful Result	You should also be able to check booking record in Datasource on Stella.

You may also right click Save As to download a sample result tree here to cross check with your chatbot!

---

Getting Hands-on

Save Name

1. To save the user input, we must perform the action in the node of the following level. For example, if we want to save the user's name, we have to save it in the node of "Ask email address" because the bot can only receive the user's name input at the node comes after.

2. Click on "Ask email address" node, and click "+ New Action" under Pre-actions.

Add pre-actions

3. Click "+ New Action" to create a new action to save down user's name.

Save name

4. You can save that in user's tempData and categorize it under name of booking.

Example code:

return new Promise((resolve, reject) => {
  this.lodash.set(this.member, "botMeta.tempData.booking.name", this.messageEvent.data.text)
  resolve({
    member: this.member,
  })
})

5. Save the action and save the node.

Created save name action

---

Save Email Address

6. Similarly, goes to "Booking confirmation" node, and click "+ New Action" under Pre-actions.

7. Click "+ New Action" to create a new action to save down user's email address.

Save email address

8. You can save that in user's tempData and categorize it under email of booking.

Example code:

return new Promise((resolve, reject) => {
  this.lodash.set(this.member, "botMeta.tempData.booking.email", this.messageEvent.data.text)
  resolve({
    member: this.member,
  })
})

9. Save the action and save the node.

Created save email action

---

Create Datasource

10. Now goes to Datasource at the top blue menu.

11. Click "+ New Datasource" to create a mini database to store your booking confirmation.

Datasource

12. Name your Datasource: Booking Confirmation and click "+ Create" to save it.

Name your Datasource

13. You have created your Datasource now. You can see it on the Datasource list and click "View" to see the Datasource details.

Datasource list

14. You can see that there is no data now for your Datasource but don't worry, we will add the booking record in this database later. Now copy the Data Source ID in your notes and save it for later use.

Datasource details

---

Save Record in Datasource

15. Now you can go back to your workspace and goes to "Booking confirmation" node. Click "+ New Action" under Post-actions.

Add post-action

16. Click "+ New Action". You can now retrieve the user's tempData and save it back in the Datasource.

Save record into Datasource

Example code:

return new Promise(async (resolve, reject) => {
  try {
    await this.upsertDataToDataSource({
      dataSourceId: "YOUR_DATASOURCE_ID",
      data: {
        "Name": this.lodash.get(this.member, "botMeta.tempData.booking.name"),
        "Email": this.lodash.get(this.member, "botMeta.tempData.booking.email"),
      }
    })
  } catch (e) {
    console.log("cannot run upsertDataToDataSource, ", e.message)
  }
  resolve({
    member: this.member
  })
})

Remarks:

• Remember to input the copied Data Source ID in the script.
• The pairs inside data represents the column head ("Name") and the value (this.member.botMeta.tempData.booking.name) filled in the field per record entry.

17. Save the action and save the node.

Created save record action

18. Try to make a booking on your WhatsApp chatbot now and check if you can get a successful result 🎉