Sending Numbers to a google Sheet and it convert then into date

MIT App Inventor Help
1

i am sending numbers to a google Sheet and it convert then into date.... i need the number not the dates....
date

Blockquote else if (e.parameter.Action=="WirteTrackPosition") {
var sheet = ss.getSheetByName(e.parameter.Sheet);
var date=e.parameter.Date;
var name=e.parameter.Name;
var latitude=e.parameter.Latitude;
var longitude=e.parameter.Longitude;
var distanceTotal=e.parameter.TotalDistance;
var timeTotal=e.parameter.WorkingTime;
var steps=e.parameter.Steps;

sheet.appendRow([date,name,latitude,longitude,distanceTotal,timeTotal,steps]);
return ContentService.createTextOutput("WirteTrackPosition OK");

}

date2

2

Set the column in the google sheet to number format. If this gets overwritten by the appendRow function, then you will have to do this each time using a script.

3

how do you Set the column in the google sheet to number format.

4

To set a number format to column C:

function setNumberFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName("Sheet1");
var rg = sh.("Sheet1").getRange("C"+1 + ":C");
rg.setNumberFormat("##.##");
}
5

the code is working but the convretion do not give the good numbres
nomber

it convert date to number but the numbers ar not longitude or latitude

else if (e.parameter.Action==“Transpose”) {
var sheet = ss.getSheetByName(“Spots”);
var rg = sheet.getRange(“C”+2 + “:C”);
rg.setNumberFormat("##.##");
}

6

Not sure what is going on, don’t know how you get from a “number” like 6.54675 to a “number” like 1811391 … Are you sending the lat and lon values as numbers (blue blocks) or text (purple blocks)? Why are all the “numbers” on the spreadsheet left aligned - are they numbers or text - 1234 or '1234? What number format is the column set to ?

7

First thoses numbers come from the GPS (green blocks) they are put into a variable (orange block) then put into a list via add item to a list (bleu block).

Then put them all together as " … " then i send them…

Then i put then into a google form

liste

liste2

var sheet = ss.getSheetByName("Tracks");
var dates = eval("[" + e.parameters.DateList + "]") ;
var name = eval("[" + e.parameters.NameList + "]") ;
var latitude = eval("[" + e.parameters.LatitudeList + "]") ; 
var longitude = eval("[" + e.parameters.LongitudeList + "]") ;  
var distance = eval("[" + e.parameters.DistanceList + "]") ;
var time = eval("[" + e.parameters.WorkingTimeList + "]") ; 
var step = eval("[" + e.parameters.StepsList + "]") ; 


for (var i=0;i<dates.length;i++) {
  var datei = dates[i];
  var namei = name[i];
  var latitudei = latitude[i];
  var longitudei = longitude[i];
  var distancei = distance[i];
  var timei = time[i];
  var stepi = step[i];
  sheet.appendRow([datei,namei,latitudei,longitudei,distancei,timei,stepi]);