I want to fill a table from datatable plugin automatically with data from a database table whenever a user loads the page. Also when user changes some values in table I want to write that back into database table. How can I achieve that?
Our developer checked the issue. In order to import Google sheets into table you need to:
1. Open access for everybody to edit this document.
2. Open Editor Settings Tab.
3. Click on Import Button.
4. File extension type – Google Spreadsheets.
5. Fill in the URL of your Google Spreadsheets.
6. Click on import button.
7. Save changes of the imported table.