Imported Google Sheet – Can't make changes in front end

Tagged: auto import, editable, google sheet

This topic has 4 replies, 3 voices, and was last updated 4 years, 10 months ago by Alex_support.

Viewing 5 posts - 1 through 5 (of 5 total)

Author
Posts
March 13, 2018 at 00:13 #16803

arabino
Participant
I am trying to make editable field from an imported Google Sheet, It does not work.
Situation:
– Editable field works perfect on a new table.
– Editable field does not work on imported Google Sheet
Solution Needed:
– We import a Google Sheet with Data, there are columns that the user must fill out according to the data we parse.
– New input from user must be saved in same google sheet.
Thank You
May 18, 2018 at 12:22 #17663

Alex_support
Member
Hello, @arabino.
If you are using autoimport option from google spreadsheet, you can’t make cells with data editable for that table, because it make cause conflicts with autoimported data.
Our table has autoimport option, but it doesn’t have autoexport to google sheet.
If you want to make imported from google spreadsheet tables editable, you should use simple Import option (not autoimport).
This way you can use editable fields.
May 19, 2018 at 16:23 #17671

watanabe.naoto
Participant
I also bought PRO as I was interested in connecting with Spreadsheet And succeed that the feature menu activated and tried it.
But it doesn’t work at all.
my article show “Failed to import selected file: Wrong spreadsheet id or url”
I confirmed.
– The License was activated.
– My spreadsheet shared link was set with “editable”.
– Confirmed URL on the browser and the windows.
– I created new table and just checked “Autoimport from Google Sheet ” and filled “Link from Google Tables”.
I cannot guess the reasons. I wonder if the support gave the link that I could import it.
I confirmed below just as test.
https://docs.google.com/spreadsheets/d/1ztR4aQIzDFwMJsGtfjs-BA7nTohFOAs4lDhz-eam3sU/
May 20, 2018 at 01:51 #17672

watanabe.naoto
Participant
Sorry. I could sort out by myself. I wonder if the information could help someone.
1. Windows URL
https://docs.google.com/spreadsheets/d/1ztR4aQIzDFwMJsGtfjs-BA7nTohFOAs4lDhz-eam3sU/edit?usp=sharing
-> It doesn’t work
2. Browser URL ( copy&past the URL “1”)
https://docs.google.com/spreadsheets/u/1/d/1ztR4aQIzDFwMJsGtfjs-BA7nTohFOAs4lDhz-eam3sU/edit?usp=sharing
-> Bot 1 / 2 doesn’t work
3. Browser URL – After certain second, It looks redirecting and added gid in URL – maybe it’s unique.
https://docs.google.com/spreadsheets/d/1ztR4aQIzDFwMJsGtfjs-BA7nTohFOAs4lDhz-eam3sU/edit#gid=xxx
-> It works. We should copy this with “edit#gid=xxx” to wordpress setting.
May 21, 2018 at 12:20 #17678

Alex_support
Member
Hello, @watanabe.naoto
Thank you for detailed explanation of this issue.
Also, we have an instruction about import option here: https://supsystic.com/documentation/export-import/
Here is a screenshot of required link from Google sheets: https://prnt.sc/ipzjpf – it must contain “gid” in URL.
Author
Posts