Hello Team,
I am encountering an error while trying to add data to my database table. Let me explain the situation in detail:
I have created a database table named EmployeeTable. To input data into this table, I designed a digital form called EmployeeDetails, which contains the columns as shown in the figure below. However, when attempting to add data to the table, I am receiving the following error message.
Error Image here
Can anyone assist me with this issue? Your help would be greatly appreciated.
Thank you for your time and support!
Can Anyone Please help me with the error?
Based on the information you have provided, I don’t see an error that should prevent this from working. I built your scenario in my bot and it worked fine. Maybe you can review my build and spot a different with your bot.
I created a form to collect the employee data:
I created a table:
I created a basic dialog flow:
Please note that I added a simple confirmation node to display the content of the form variables before submitting to the service node. You want to do this when troubleshooting your bot so the dialog will pause!
Finally, I created a service call to write the form data into a table:
When I tested…no errors. Please review and let me know if you have any questions. I suspect you have a spelling error in the form name but that’s just a guess.
good luck!