Bad arguments to list to csv table

[Ramon]

Yes, can you copy-paste here the whole response you have in DoIt?

Anyway, I can see "Google Drive"...Have you changed your Url?

[chistoria]

i'm sorry the whole response is so long but here

DOC-20240522-WA0003 - Google Drive html { overflow: visible; } #sheets-viewport { overflow: auto; } #sheets-viewport.widget-viewport { overflow: hidden; } .grid-container {overflow: visible; background: white;}.grid-table-container { overflow: visible; } #top-bar { margin: 0; overflow: hidden; } #top-bar { border-bottom: 1px solid #ccc; padding: 6px 6px 0;} #doc-title {padding-bottom: 5px; } #doc-title .name {font-size: 15px; } #sheet-menu {font-size: 13px; margin: 6px 0 0; padding: 0 0 5px; } #sheet-menu li { display: inline; list-style-type: none; margin: 0; padding: 5px 8px;} #sheet-menu li.active {background-color: #fff; font-weight: bold; border: 1px solid #999;} #top-bar #sheet-menu li.active { border-bottom: 0;} #sheet-menu a, #sheet-menu a:visited { color: #07c; } #footer { background: #f0f0f0; border-top: 1px #ccc solid; border-bottom: 1px #ccc solid; font-size: 13; padding: 10px 10px; } .dash { padding: 0 6px;} html { overflow: auto; } body { overflow: hidden; } #top-bar { left: 0; position: fixed; / * Height of mobileweb header + 1 px vertical shadow. / margin-top: 57px; top: 0; width: 100%; / This should match the value of DOCS_SHEETS_VIEWER_HEADER. */ z-index: 11;} #sheets-viewport { height: 100%; } .ritz.waffle a { color: inherit; }.ritz.waffle.s0{background-color:#fff fff;text-align:left;color:#000000;font-family:'docs-aptos narrow', Arial;font-size: 11pt;vertical-align:bottom;w hite-space:nowrap;direction: ltr;padding:0px 3px 0px 3px;).ritz.waffle.s1 {background-color:#ffffff;text -align:right;color:#000000;font-family:' narrow', Arial;font-size: 11pt;vertical-align:bottom;whit
e-space:nowrap;direction: ltr;padding:0px 3px 0px
3px;} var activeSheetId; function switch ToSheet(id)
{ if (document.getElementById('sheet-menu'))
{document.getElementById('sheet-button-'

• activeSheetld).className = ";
  document.getElementById('sheet-button-'
• id).className = 'active'; } document.getElementById(activeSheetId).style.display = 'none'; document.getElementById(id).style.display = "; activeSheetld = id; // posObjs() is defined in embeddedObjectJs (see EmbeddedObjectHtmlBuilder.java) posObjs();

no i have not change the URL

[Ramon]

something has changed...in your first post you were receiving the content of the spreadSheet and now you get this error? Have you modified the permissions of the Google Sheet? If you paste the url you are using into a browser, is the GoogleSheet downloaded?

[chistoria]

the only blocks that i change is "list to csv table" to "list from csv table"

the permission is same, i use link from this

[Ramon]

@Ramon

If you paste the url you are using into a browser, is the GoogleSheet downloaded?

Have you tried this?

[chistoria]

it means no right?

[Ramon]

mmm, Do you have anything at the end of this piece of url?

[chistoria]

[Ramon]

can you share your aia file?

[chistoria]

ApkKelulusanUjian.aia (10.9 KB)

like this?

[Ramon]

Yes,
It is working for me.....this is what you are receiving in your responseContent:

Do It Result: "NO ABSEN,NO UJIAN,NAMA SISWA,INFORMATIKA ,MATEMATIKA,KIMIA,FISIKA,BIOLOGI,KETERANGAN 1,56-789-1,ADI PRATAMA,100,98,95,91,94,LULUS 2,56-789-2,BIMO NUGROHI,100,95,95,91,97,LULUS 3,56-789-3,DIMAS SATYA,70,75,77,71,73,TIDAK LULUS 4,56-789-4,FARELL PUTRA,75,75,73,70,71,TIDAK LULUS"

and this is what you have after your "list from cvs table" block:

Do It Result: "[["NO ABSEN", "NO UJIAN", "NAMA SISWA", "INFORMATIKA", "MATEMATIKA", "KIMIA", "FISIKA", "BIOLOGI", "KETERANGAN"], ["1", "56-789-1", "ADI PRATAMA", "100", "98", "95", "91", "94", "LULUS"], ["2", "56-789-2", "BIMO NUGROHI", "100", "95", "95", "91", "97", "LULUS"], ["3", "56-789-3", "DIMAS SATYA", "70", "75", "77", "71", "73", "TIDAK LULUS"], ["4", "56-789-4", "FARELL PUTRA", "75", "75", "73", "70", "71", "TIDAK LULUS"]]"

And this is what you have if I write "56-789-4" in the textBox:

[chistoria]

i try it and you're right
but can i ask something, why there's empty?

[Ramon]

Maybe because you are setting to white the text of that label?

So you cannot see white text over white background.

[chistoria]

thank you it works, but why the 1-2 (green) doesnt look like the 3-4 red?

also the subject supposed to be beside the number like this example

[Ramon]

Now that you know how to use "DoIt" debug you app to check what are you doing with your data and the labels... this is your data after remove the first row received from googleSheet:
[["1", "56-789-1", "ADI PRATAMA", "100", "98", "95", "91", "94", "LULUS"],
["2", "56-789-2", "BIMO NUGROHI", "100", "95", "95", "91", "97", "LULUS"],
["3", "56-789-3", "DIMAS SATYA", "70", "75", "77", "71", "73", "TIDAK LULUS"],
["4", "56-789-4", "FARELL PUTRA", "75", "75", "73", "70", "71", "TIDAK LULUS"]]

and you have this in your code:

That part of the code will not be executed because you are comparing the forth element of each row with "BIOLOGI"... as you can see, the forth elements of your rows are numbers.

Also you are setting different labels depending on the last value:

in green case you are overwriting Lbl_Nilai.

[chistoria]

thank you, i have solved the different label problem
but can you give me the right code example for the forth element?

[Ramon]

Do you understand what your code does? There is not correct code for the forth element...If you want the texts "INFORMATIKA", "MATEMATIKA"....be shown in Lbl_Mapei always, then remove the if, which has not sense, and simply set the label.

[chistoria]

thank you so much for your help
you helped me a lot.
very sorry i'm often confused