Hi all,
I’m working on a form that is quite long and the choices list is getting into 1000’s row so I’m making a csv file for years. When I put my form through the xlsx converter I get the error “Invalid or unexpected token interpretting formula”. I’ll attach my csv form and the callbacks I’m using to see if I have any errors, if anyone could help that would be great!
_.chain(context).pluck(‘1850_2018_DK’).uniq().map(function(1850_2018_DK){
return {name:1850_2018_DK, label:1850_2018_DK, data_value:1850_2018_DK, display:{text:1850_2018_DK}};
}).value()
_.map(context, function(place){
place.name = place.1930_2018_DK;
place.label = place.1930_2018_DK;
place.data_value = place.name;
place.display = {text:place.label};
return place;
})
_.map(context, function(place){
place.name = place.1930_2018_DK_NA;
place.label = place.1930_2018_DK_NA;
place.data_value = place.name;
place.display = {text:place.label};
return place;
})
_.map(context, function(place){
place.name = place.1900_2018_DK;
place.label = place.1900_2018_DK;
place.data_value = place.name;
place.display = {text:place.label};
return place;
})
year.csv (2.7 KB)
Thanks,
ELMPS team