How to create records automatically

webmaster.antonioferriero said:
Question. How to associate Fulfillment to each Customer? In other words, how to fill the Fulfillment table?

 Are you starting in the Fulfillment table, the Customer table, or a Dashboard?

What is your work flow? Are you in a Customer record and need to create the fullfillment records? Or do you start in Fullfillment then want to add all Customers?

Or are you in a dashboard.

webmaster.antonioferriero said:
Can you create such a button? With which code?

 You can do most things in Ninox.

My little brain is having a hard time generalizing your workflow. Can you post a sample DB? If not then I'll spend a few more moments trying to understand your structure.

in the example you give, is there 15 records in the expiry table for customer AZName Ltd?

So there is a N:1 relationship between Expiry (many) and customer (one) and a N:N (many to many) between Fulfillment and Customer and N:1 between Fulfillment and Expiry?

You can try this in button in the Customer table:

let t := this;
let selExpiry := (select Expiry);
let st := 'Society Tipology';
let neededExpiry := selExpiry['Which company?' = 1 or (var EfS := numbers('Expiry for society');
            count(EfS[= st]) > 0)];
for loop1 in neededExpiry do
    let xYear := if loop1.'Expiry year' = 1 then
            year(today())
        else
            year(today()) + 1
        end;
    let newFF := (create Filfull);
    newFF.(
        Customer := t;
        Name := loop1.'Expiry Name';
        Data := date(xYear, loop1.'Expiry month', loop1.'Expiry day')
    )
end

Line 1 creates a variable and stores the current record info.

Line 2 creates a variable and finds all records in the Expiry table and stores it in an array

Line 3 creates a variable and put the record info selected in the Society Tipology reference field.

Lines 4-5 creates a variable that filters the selExpiry array to only those needed.

Lines 6-18 is the for loop command that uses the array in neededExpiry and:

Lines 7-11 checks the 'Expiry Year' choice field and if it is 1 then put the current year in the variable xYear. If it is not 1 then it takes the current year and adds 1.

Lines 12-17 creates a new record in Fillfull and:

Line 14: links the Customer in Fillfull to the current record in Customer

Line 15: sets the Name in Fillfull to the current loop Expiry Name

Line 16: sets the Data field to the date made up of the xYear field and the month and day fields in the current loop Expiry record.