If needed, encrypt a rendered report with a password

Either toggle ON the option Set password in the Ninox UI, or alternatively use a custom script and the functions printRecord or printAndSaveRecord.

Option A: without a custom script (Ninox UI)

Option A: Toggle ON Set password (1), enter a password (2), re-enter the password (3), save by clicking Set password (4)

Option A: After clicking Set password, the entered password is saved

Option B: with a custom script

ℹ️ Works with printRecord or printAndSaveRecord.

printRecord(this,"templateLayoutName", data)

printAndSaveRecord(this,"templateLayoutName", data)

The data object can include the property _options with pdfPassword which overrides the default settings set by the print engine in the Ninox UI, if you previously toggled OFF Set password.

❗ An empty password like "" will not encrypt your report.

Example

1. Add a new layout element, here: a button.
2. Paste the script below in the formula editor.
3. Save changes.
4. Click or tap the button to run the script.

printRecord(this, "en_invoice_template", {
    date: "02.09.2022",
    notes: "Net 30",
    invoiceNumber: "RE-00001",
    totalNet: "1,342.30 €",
    totalGross: "€1,597.34",
    paymentTerm: "30.09.2022",
    vat: [{
            rate: "19%",
            amount: "€255.04"
        }],
    customer: {
        companyName: "Happy GmbH & Co. KG",
        salutation: "Mrs.",
        lastName: "Sorglos",
        department: "Purchasing",
        address: "Willy-Brandt-Weg 2",
        postalCode: "10178",
        city: "Berlin"
    },
    contact: {
        name: "Elsa Excel",
        phone: "(030) 234 567 89",
        email: "elsa.excel@ninox.com"
    },
    items: [{
            pos: 1,
            article: "Ninox Cloud",
            number: 10,
            price: "€120.00",
            sum: "€1,200.00"
        }, {
            pos: 3,
            article: "Ninox coffee cup (porcelain)",
            number: 5,
            price: "€7.50",
            sum: "€37.50"
        }, {
            pos: 4,
            article: "Ninox coffee cup (recycled)",
            number: 10,
            price: "€0.49",
            sum: "€4.90"
        }, {
            pos: 5,
            article: "Ninox basecap",
            number: 10,
            price: "€9.99",
            sum: "€99.90"
        }],
    _options: {
        pdfPassword: "lite-wake-grill"
    }
})

Result

A report (PDF file) is created and downloaded to your local files. When you open the PDF from your browser, you are prompted to enter a password to open the document.