External Integrations Section - NocoDB

Basics & Overview

1. What is the External Integrations Section - NocoDB Block used for?

The NocoDB Block allows your chatbot to connect directly to your NocoDB database. You can use it to read, create, update, or delete records in your tables directly through the chatbot.

2. How does the NocoDB Block help my business?

It helps you automate data management workflows. You can use a chatbot to collect information from a user and then instantly add it as a new row in a NocoDB table, or retrieve existing data to answer a user's question.

3. What can I do with the NocoDB Block?

The block offers five main actions: get many rows, get row details, create a row, update existing row, and delete existing row.

4. What do I need to get started with the NocoDB Block?

You need an active NocoDB account that has been integrated with your chatbot platform. You must also have your Workspace ID, Base ID, and Table Name ready.

5. How do I choose the action I want the bot to perform using the NocoDB Block?

You use the "Select Type" field to choose one of the five available actions.

General Configuration

6. What is a "Workspace ID" and how do I find it in the NocoDB Block?

A Workspace ID is a unique identifier for your NocoDB workspace, and it starts with a 'w'. You can find it in the URL of your NocoDB dashboard. A sample URL is provided next to the field, and you can click the eye button to see it.

7. What is a "Base ID" in the context of the NocoDB Block?

A Base ID is a unique identifier for a specific database within your NocoDB workspace. It starts with a 'p' and can also be found in your NocoDB URL.

8. What is a "Table Name" in the NocoDB Block?

The Table Name is the name of the specific table within your selected base where you want to perform an action. You choose it from a dropdown list.

Action: Get Rows

9. How do I get a list of rows (records) from a NocoDB table using the NocoDB Block?

Select the "get many rows" type. You will need to provide your Workspace ID, Base ID, and the Table Name.

10. What does the "Fetch All Data" toggle do in the NocoDB Block?

This toggle handles pagination. If you select "yes," the block will automatically retrieve all rows from the table, even if they are spread across multiple pages. This is useful for fetching an entire dataset.

11. How do I use the data that is retrieved by the NocoDB Block?

The data is saved into a variable using the "Store the response in variable" field. You can then use this variable to display the information to the user or use it in other blocks in your flow.

12. How do I get details for a single row using the NocoDB Block?

Select the "get row details" type. You will need to provide the "Row ID" for the specific record you want to retrieve.

13. What is a "Row ID" in the context of the NocoDB Block?

A Row ID is a unique identifier for a specific record in your NocoDB table. Every row has a unique ID that the block uses to pinpoint the correct record.

14. How do I find a "Row ID" for the NocoDB Block?

You can get a Row ID by first using the "get many rows" action. The response will contain the IDs for all the rows, which you can then use in a subsequent block to get the details for a specific record.

Action: Create a Row

15. How can my chatbot create a new row in NocoDB using the NocoDB Block?

Select the "create a row" type. You'll need to provide your Workspace ID, Base ID, and Table Name, and then set up your "Variable Mapping."

16. What is "Variable Mapping" in the NocoDB Block?

Variable Mapping is the process of linking the information you've collected in your chatbot to the correct columns in your NocoDB table. You tell the system which data should go to which column.

17. What is the difference between "Partner Variable" and "ChatMaxima Variable" in the NocoDB Block?

• Partner Variable: This represents a column name in your NocoDB table (e.g., "CustomerName," "Email").

• ChatMaxima Variable: This is the variable in your bot's workflow where the user's data is stored (e.g., {{user_name}}, {{user_email}}).

18. What happens after a row is created with the NocoDB Block?

After the block successfully creates the row, the chat flow continues to the next block. The response, including the new row's ID, is saved in the response variable.

Action: Update & Delete Rows

19. How can I update an existing row using the NocoDB Block?

Select the "Update Existing Row" type. You will need to provide the "Row ID" of the record you want to update and use "Variable Mapping" to update the specific fields.

20. How do I delete an existing row using the NocoDB Block?

Select the "delete existing row" type. You will need to provide the "Row ID" for the specific record you want to delete.

21. Why is a "Row ID" required for both updating and deleting with the NocoDB Block?

The Row ID is crucial because it ensures that you are performing the action on the correct record. Without it, the bot wouldn't know which row to change or remove.

22. What happens after a row is deleted with the NocoDB Block?

The record is permanently removed from your NocoDB table. The chatbot can then store a success message in a variable to confirm the action.

Practical Use Cases

23. How can the NocoDB Block help with lead management?

You can create a chatbot that asks users for their contact information. Use the "create a row" action to automatically add each new lead to a table in your NocoDB database.

24. How can I use the NocoDB Block for a product lookup?

A customer can ask for a product's price or stock. The bot can use the "get row details" action with the product's ID to retrieve the information from your NocoDB inventory table.

25. How can the NocoDB Block help with customer feedback?

You can create a chatbot that asks for a user's feedback or a support ticket. Use the "create a row" action to add their feedback directly to a table for your team to review.

Location & Tutorials

26. Where can I find the NocoDB Block in the builder?

You can find the NocoDB Block in the External Integrations section of your chatbot builder.

27. Where can I find a video tutorial for the NocoDB Block?

You can find the video tutorial at:  https://chatmaxima.com/video-tutorials/integrations-nocodb-block-in-chatmaxima/

Advanced & Troubleshooting

28. What happens if the data doesn't sync correctly to NocoDB using the NocoDB Block?

Common reasons for failure include incorrect IDs (Workspace, Base, or Row), a mismatch in your variable mapping, or an issue with your NocoDB integration permissions.

29. How does the NocoDB Block save me from manual data entry?

This block automates the complex API calls required to interact with NocoDB. You simply configure the fields, and the platform handles the technical backend for you.

30. What is the purpose of the "Store the response in variable" field for all actions in the NocoDB Block?

This field is essential for saving the result of any action—whether it's a list of rows, a confirmation message, or the ID of a newly created row—into a variable for use in the next steps of your chatbot flow.