HTML Form Custom Component Example Needed

We have many cutom HTML input forms already built before from our old system. It basically contains just HTML (labels, Inputt) with very simple CSS style. No Javascript. To quickly deploy our appllication, we want to make use of them.

Documentation does not give enough information about how to go about. We tried several different example given via ChatGPT...etc. and nothing works yet. We just want to use HTML forms to input data and have them update table. We tried Javascript method as well as using "state" variable method (in combination with update query). We are just using Retool built-in databse. So far, does not work. I am sure we are misunderstanding something since we are new to this.

We are hoping if you can point to some simple working example of this would be appreciated.

HTML Component:

Name:

Email:

Submit

Update Query
INSERT INTO users (name, email) VALUES ({{name}}, {{email}})

Above is just one version. We tried many version, some using parsing the HTML to get input field value. Also, tried {{state}} value method. If someone can point to actual working sample regafrdless of method would be great. Thanks,