Hello,

I am reviving the topic concerning the need to download all invoices for a given period in a zip file.

Here is my current code that downloads each pdf independently

let filterStart := 'Début du filtre';
let filterEnd := 'Fin du filtre';
let sample := (select Transactions);
for loop in sample do
    if loop.date('Date de facturation') >= filterStart and
        loop.date('Date de facturation') <= filterEnd then
        printRecord(loop, "facture_dynamique")
    end
end

Ideally, each pdf would be named "Invoice No." followed by the invoice number found at (select Transactions).'N° de transaction' and that the work is done in the background (so that it does not block Ninox during loading time which can be very long).

Thank you for your help.

If it can help someone, here is the code for each button:

Button to generate each invoice in a record of my 'Documents' table with the indicator "Type de document' := 18" which will later be used to delete all the records that have just been created.

let filterStart := 'Début du filtre';
let filterEnd := 'Fin du filtre';
let sample := (select Transactions);
for loop in sample do
    let nomFacture := "Facture n°" + loop.'N° de transaction' + ".pdf";
    if loop.date('Date de facturation') >= filterStart and
        loop.date('Date de facturation') <= filterEnd then
        let me := this;
        let newDocFacture := (create Documents);
        newDocFacture.(Compte := loop.Compte);
        newDocFacture.('Type de document' := 18);
        newDocFacture.('Date de création' := today());
        newDocFacture.(Transactions := loop);
        newDocFacture.('Nom du document' := nomFacture);
        newDocFacture.(Document := importFile(this, printAndSaveRecord(loop, "facture_dynamique"), nomFacture))
    end
end;
'Documents générés en masse' := true;
'Fichier zip généré' := false

Button to create the zip in the 'Fichier zip' field.

do as server
    'Fichier zip' := createZipFile(this, (select Documents where 'Type de document' = 18).Document, "Factures.zip")
end;
'Fichier zip généré' := true

Button to download the zip file.

let i := fileMetadata(this, last(split(text('Fichier zip'), "/")));
i.name;
downloadURL(text(shareFile('Fichier zip')), text(i.name));
'Zip téléchargé' := true

Button to delete all records that were created for invoice download. They are separated from other documents with "Type de document' := 18"

'Fichier zip' := null;
---
Suppression des documents
---;
do as server
    delete (select Documents where 'Type de document' = 18)
end;
---
Fin
---;
'Documents générés en masse' := false;
'Zip téléchargé' := false;
'Fichier zip supprimé' := true

Please note however that the zip file is deleted from 'Fichier zip' and will be moved to the paperclip.