Tambahkan 2 Kolom di googlesheet untuk menampung link file
Buat 2 Folder di Google Drive
Update [Link]
///////////////////////////////////////////////////////////////////////////////////
/
var folder1 = [Link]('fd');//ganti fd dengan id folder
var folder2 = [Link]('fd');//ganti fd dengan id folder
-------FILE DIBAWAH ADA UPDATE/PERBAIKAN-------------------------------------------
if (formObject.myFile1 && [Link] > 0) {
var blob1 = formObject.myFile1;
var blob2 = formObject.myFile2;
var file1 = [Link](blob1);
var file2 = [Link](blob2);
file1 = [Link]();
file2 = [Link]();
}
-------FILE UPDATE/PENGGANTI UNTUK SCRIPT
DIATAS------------------------------------
-------GANTI SCRIPT BARIS (17-23 DENGAN BARIS 29-
46)--------------------------------
if (([Link] > 0) && ([Link] > 0)) {
var blob1 = formObject.myFile1;
var blob2 = formObject.myFile2;
var file1 = [Link](blob1);
var file2 = [Link](blob2);
file1 = [Link]();
file2 = [Link]();
} else if (([Link] > 0) && ([Link] == 0))
{
var blob1 = formObject.myFile1;
var file1 = [Link](blob1);
file1 = [Link]();
} else if (([Link] > 0) && ([Link] == 0))
{
var blob2 = formObject.myFile2;
var file2 = [Link](blob2);
file2 = [Link]();
}
-----------------------------------------------------------------------------------
----
file1,
file2,
-----------------------------------------------------------------------------------
----
Update JavaScript
///////////////////////////////////////////////////////////////////////////////////
///
"<th scope='col'>File 1</th>" +
"<th scope='col'>File 2</th>" +
-----------------------------------------------------------------------------------
----
{
targets: [7], //colom 7 adalah kolom file1
className: 'dt-body-center',
"render": function(data, type, row, meta) {
if (type === 'display' && [Link] >
20) {
data = '<a href="' + data + '?
text=' + row[7] + '" target="_blank">' + '<i class="fa fa-file" style="font-
size:15px;color:black"></i>' + '</a>';
}
return data;
}
},
{
targets: [8], //colom 8 adalah kolom file2
className: 'dt-body-center',
"render": function(data, type, row, meta) {
if (type === 'display' && [Link] >
20) {
data = '<a href="' + data + '?
text=' + row[8] + '" target="_blank">' + '<i class="fa fa-file" style="font-
size:15px;color:black"></i>' + '</a>';
}
return data;
}
},
-----------------------------------------------------------------------------------
----
Update form
///////////////////////////////////////////////////////////////////////////////////
///
<!-- Input type text -->
<div class="form-group">
<label for="file1">File 1</label>
<input type="file" class="form-control"
name="myFile1" id="myFile2">
</div>
<!-- Input type text -->
<div class="form-group">
<label for="file1">File 2</label>
<input type="file" class="form-control"
name="myFile1" id="myFile2">
</div>
-----------------------------------------------------------------------------------
----