After the changes Google made to their systems a few weeks ago I had a problem with reading data from a Google spreadsheet and solved that by using Papa Parse 5 ( www.papaparse.com/docs#json-to-csv ).
Maybe that's the way to solve this problem. I only did a read, but it seems it can also write to Sheets.
El siguiente usuario dijo gracias: tihana.krivic, Mirec
can you please share your solution with the community on how you did it (step by step), it will be great as a temporary solution, while we fix problems with google drive
can you please share your solution with the community on how you did it (step by step), it will be great as a temporary solution, while we fix problems with google drive
Thank you!
regards,
Mirko
I don't have an automated solution to the GD write problem.
As an emergency method I manually select records from the form, export them to a csv file and import them in Excel with the commands Data/From Text/CSV. The same can be done in Google Sheets File/Import/Upload and drag/drop the CSV file in the file area.
Voor reading select lists from Google Sheets I have published the sheet as on the Web, File/Publish to the web. Formerly I used Tabletop and you can find the change procedure with examples on github.com/jsoma/tabletop.
I have a little piece of the init sheet from my form
function ff_inschrijven_ndo_init() {
//Vul alle leden in de lijst met trainers/dansscholen in het veld met de naam trainer_org
Papa.parse('copy link from the publishing procedure',
{
download: true,
complete: cb_ledenlijst,
header: true,
})
function cb_ledenlijst(results) {
var data = results.data
console.log(data);
for (l = 0; l < data.length; l++) {
var opt = document.createElement("option");
opt.text = data[l]["Dansleraar/trainer"] + ", " + data[l]["Plaatsnaam"];
opt.setAttribute("value", data[l]["Dansleraar/trainer"] + ", " + data[l]["Plaatsnaam"]);
ff_getElementByName('trainer_org').options.add(opt);
}
}
} // ff_inschrijven_ndo_init
Sorry for the dutch comments.
I have written this, as is, and please don't ask me questions. It is just to point in the right direction if it applies to you!
Hi,
fisrt steps of the tuto is ok but when I arrive to :
3)after that Google Drive in located in form->Advanced->More options->Google Drive->click on Sign up with google and you will get "key" -> copy it and save