Im trying to create simple CRM with wix, on my website (testing website at the moment)
The purpose of the CRM will be for my employs to enter customers data in the fields of the CRM form, which will be indicated in the table and can be viewed by us and i wish my managers to be able to edit that form and to be able to change information.
So far i have created custom forms of inputs of the information's which are required for me to collect, (sales date, customer name, ect), when the form is filled the details are indicated in wix table on other page.
Im looking for a solution to be able to edit that wix table, from the website. It is editable with dashboard, yes i can also add contributors but my priority is to make the wix table editable from the live website just like from google forms.
I have made multiple attempts by setting data set on the page on read and write but wix table just wont let me to do so.
One of the method is which im trying to use is to make custom HTML code of editable table, but i would need to connect it to database for information to be submitted on it.
Is there any way for me to connect HTML table to database and make it editable from live wix site?