Hi, I've been playing around in the sandbox trying to see if wpDataTables does what I need it to do before I go through the purchase and install. So far it's awesome. But I'm stuck on one really key requirement. I need my front end users to be able to edit a Google Sheet table. In the sandbox, I can create and configure the table from the Google Sheet no problem. But I can't for the life of me figure out where the "Allow front end editing" option is, as seen here:
I assume you are creating a table LINKED to an existing source? Tables linked to an existing Google spreadsheet don't have the front end editing feature since all the editing is done inside the spreadsheet. You would have to create a table importing the data from the Google spreadsheet to be able to enable front end editing
I'm afraid this kind of synchronization is not yet possible. It only works one way change the Google sheet and see it reflected in wpDataTables.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
Hi, I've been playing around in the sandbox trying to see if wpDataTables does what I need it to do before I go through the purchase and install. So far it's awesome. But I'm stuck on one really key requirement. I need my front end users to be able to edit a Google Sheet table. In the sandbox, I can create and configure the table from the Google Sheet no problem. But I can't for the life of me figure out where the "Allow front end editing" option is, as seen here:
https://wpdatatables.com/documentation/creating-new-wpdatatables-with-table-constructor/importing-data-to-editable-mysql-table-from-excel-or-csv-with-table-constructor/
Thanks!
David
Hi David
Thank you for reaching out to us.
I assume you are creating a table LINKED to an existing source? Tables linked to an existing Google spreadsheet don't have the front end editing feature since all the editing is done inside the spreadsheet. You would have to create a table importing the data from the Google spreadsheet to be able to enable front end editing
https://wpdatatables.com/documentation/creating-new-wpdatatables-with-table-constructor/importing-data-to-editable-mysql-table-from-excel-or-csv-with-table-constructor/
Ok thanks. Is there a way to sync a WordPress table with a google sheet, so that changes to the wp table are reflected in the external google sheet?
Hey David
I'm afraid this kind of synchronization is not yet possible. It only works one way change the Google sheet and see it reflected in wpDataTables.
I'll kindly ask you to add it as a feature suggestion on this page.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
Thanks, just added the feature request!
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!