0
Export .csv to excel not work
The Scrip on formula is:
let me := this;
---
GENERAR COMBINACION FILTRO
---;
let myCon := "";
myCon := myCon + if Alpha then "X" else "_" end;
myCon := myCon + if Rating then "X" else "_" end;
---
SELECCIONAR DATOS Y ESCRIBIR EN ARRAY
---;
let myData := switch myCon do
case "X_":
(select Albums where upper(substr(Name, 0, 1)) = text(me.Alpha))
case "_X":
(select Albums where substr(Average, 0, 1) = text(me.Rating))
case "XX":
(select Albums where substr(Name, 0, 1) = text(Name) and substr(Average, 0, 1) = text(me.Rating))
default:
(select Albums)
end;
---
CREAR LA PRIMERA FILA CON TÍTULOS DE COLUMNAS
---;
let myCols := "Name, Title, Average, Format";
---
GENERAR LÍNEAS DE DATOS CON CAMPOS SEPARADOS POR COMAS
---;
let myRows := for i in myData do
"
" +
i.text(Name) +
", " +
i.Title +
", " +
i.Average +
", " +
i.Format +
", " +
"Firma"
end;
---
CREAR ARCHIVO CSV Y GUARDAR EN EL CAMPO DE IMAGEN
---;
let myFileName := "PrintView_" + format(today(), "YYYYMMDD") + ".csv";
PDF_Albums := createTextFile(this, myCols + myRows, myFileName)
But in excel no data
Version 3.10.8 some idea. ?
4 replies
-
I can't find the reason why don't see the data the same problem on Dashboard as a Page.
-
There is an issue with Export to Ninox on the MacOS so there might be just issues all around with export.
There are issues with Pages in MacOS with local/iCloud storage.
Content aside
- Status Answered
- 1 yr agoLast active
- 4Replies
- 68Views
-
2
Following