I have created a table linked to a google sheet. Say it has columns a and b. I want to add a new column c where in one row of the new column c a user can add a number and based on that number the rest of the rows of that column c populate using a formula. Is this possible for a user to edit when connected to google sheets?
2. Create a table by importing the Google Spreadsheet. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file.
I have created a table linked to a google sheet. Say it has columns a and b. I want to add a new column c where in one row of the new column c a user can add a number and based on that number the rest of the rows of that column c populate using a formula. Is this possible for a user to edit when connected to google sheets?
Hello Anna
You can use Excel files in two ways to create wpDataTables:
1. Create a table linked to an existing Google Spreadsheet or create a table linked to the Sheet using an API, in which case, the data of that file can be changed, but the structure can't. So, you would not be able to add, remove, reorder or rename columns in that file, or the wpDataTable will break. Also, you would not be able to edit the wpDataTable generated from this file.
2. Create a table by importing the Google Spreadsheet. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables