Multiple records print with button

Jacques TUR Thanks for your feedback. Where do I put this code?

Sébastien Guillet in the formula of a button. 

You can also create a global function to use it in several places in your database. 

function printAndDownloadMutiRecord( strNids : text, reportName : text, fileName : text ) do
var n := split(replace(strNids," ",""),",");
#{    var config = {
        nid: n[0],
        nids:  n,
        reportName: reportName,
        printAllAndClose: !0
                   };
    schemas.envConfig.openDesigner(config);
}#;
end;

And call it that:

printAndDownloadMutiRecord( concat((select myTable where myField like myFilter).string(id)), "myReport", "myFileName" );

ps: in this version, I have deleted strThis and replaced it with the first Nids record.

Jacques TUR THANKS ! I understand the idea better. However, I misspoke. I would like to be able to combine 2 pdf of the same record (2 different print models).

Currently I use a button with this formula:

Facture := importFile(this, printAndSaveRecord(this, "Facture_template_dynamique"), "Facture " + 'N° de transaction' + " - " + Compte.'Nom concaténé du compte' +
    ".pdf");
Annexe := importFile(this, printAndSaveRecord(this, "Annexe_facture_template_dynamique"), "Annexe à la facture " + 'N° de transaction' + " - " +
    Compte.'Nom concaténé du compte' +
    ".pdf")

It is an invoice and an appendix to this invoice. To facilitate the sending of the invoice and its appendix, I would like the 2 files to be combined on the same pdf file. which I can download directly to my computer, in my default download folder.

Is it possible ?

Sébastien Guillet 

To have everything in the same file, to date, the best is to use the dynamic report which allows to build very complete and complex reports.

Otherwise it is possible to zip the two files together with the createZipFile function: https://forum.ninox.com/t/m1habhz/new-functions 

Jacques TUR 

Thank !

Unfortunately, I will not be able to use the dynamic reports because the 2 documents are an invoice and an appendix containing personal data. The invoice has page numbers and the appendix should not be part of this numbering because the appendix is a document that is not intended to be sent to mutual insurance companies (I work in health/well-being). If my client removes the second page (the appendix), the health insurance company will find that a page is missing and may request the second page believing that it is the rest of the invoice.

As for createZipFile(), the idea is good but in my case, it's the same because I will have 2 pdf files and not one. I would waste time decompressing which I don't currently need to do.

I will continue to work with my 2 separate files. Thank you for the previous explanations, I have already been able to use the formulas to integrate export buttons on my dashboard. It's very useful !

Jacques TUR , I think the code ignores the name assigned to the file (fileName) using the default name of the record. Could you take a look?

Thanks!

Fabio Of course, but which of the three codes are you talking about?

Jacques TUR , the global function:

function printAndDownloadMutiRecord( strNids : text, reportName : text, fileName : text ) do
   var n := split(replace(strNids," ",""),",");
   #{
      var config = {
         nid: n[0],
         nids: n,
         reportName: reportName,
         printAllAndClose: !0
      };
      schemas.envConfig.openDesigner(config);
   }#;
end;

Thanks

Fabio You are right, fileName is never used .

Please use this tow functions. One to print and retrieve the URL of pdf, seconde to download one URL : 

function downloadURL(urlFile : text,destFileName : text) do
    #{:text:callback
        fetch(urlFile)
            .then(resp => resp.blob())
            .then(blob => {
                const url = window.URL.createObjectURL(blob);
                const a = document.createElement('a');
                a.style.display = 'none';
                a.href = url;
                a.download = destFileName;
                document.body.appendChild(a);
                a.click();
                window.URL.revokeObjectURL(url);
                callback(url.url);
            })
}#
end;
function printAndDownloadMutiRecord(strNids : text,reportName : text) do
    var n := split(replace(strNids, " ", ""), ",");
    #{:text:callback
    var config = {
         nid: n[0],
         nids: n,
         reportName: reportName,
        saveToFileAndClose: (err, urlFile) => callback(err?err:urlFile)
                   };
     schemas.envConfig.openDesigner(config);     }#
end;

Then you can call them in succession :

var urlFile := printAndDownloadMutiRecord(concat((select Customer where 'First Name' like "S").string(Id)), "Kunde");
downloadURL(urlFile, "myFileName.pdf")

note: printAndDownloadMutiRecord() requires Ninext, but not downloadURL()

Thanks Jacques TUR. Now it works, however the multiple download no longer works correctly: the pdf is generated only for the first record of the selection .

Fabio I had not paid attention to that. I had to modify the code a bit more to get the selection of several records AND the choice of the file name:

function printAndDownloadMutiRecord(strNids : text,reportName : text,fileName : text) do
    var n := split(replace(strNids, " ", ""), ",");
    #{:text
    var config = {
         nid: n[0],
         nids: n,
         reportName: reportName,
        printAllAndClose : !0
                   };
    var old = database.printRich;
    database.printRich = (e, t) => { try {e.name = fileName; old.call(database, e,t)} finally {database.printRich = old}}
    schemas.envConfig.openDesigner(config);
   }#
end;

To be called with this code:

printAndDownloadMutiRecord(concat((select Customer where 'First Name' like "S").string(Id)), "Kunde", "myFileName.pdf");

Great!. Now it works perfectly.

Thank you Jacques

Erratum: I uploaded the wrong version of the demo database. Please find the correct version.

After a short test, it seems that the database does not work properly on Mac. I will try to fix this as soon as possible.Ninext 2.ninox 

Jacques TUR Look to good on Android Table.

Hello Jacques TUR , 

after the latest updates the code above, the one that allows the generation of a pdf containing several records, no longer works.

Fabio Indeed, since version 3.10.8 of Ninox, calls to JavaScript with Native JS ( #{...}# ) no longer work. I have just published a version 2.1.31 to correct this.

However, the call to OpenDesigner, which allowed printing multiple records at the same time, is currently not available. I will try to get it working again, but nothing is certain at the moment. A workaround would be to use Dynamic Reports, which allow doing this using JSON as input data