Displaying a record in another table

iliper LTD said:
now the system is set up so that I need to enter the same data in table 5 p in fields  'tab.name' - 'number' -  'group' and the rest will go automatically. That's why I need the record to be automatically displayed in this field, the system will do the rest by itself

 I don't quite understand what you are saying here?

Are you trying to show related records from Table5 in Table1 where the Date in Table3 equals the Date in Table1?

Then you want to change the button on Table1 to create records in Table5 as well as related records in Table3 and Table4?

iliper LTD said:
in table2 there are records. And if in table3 I create a day, and on this day in table2 there is a record, it should be displayed in table5
I need to work with tables, no view

Thanks for a more detailed description.

Since Table2 and Table3/Table5 are not related then you need to use a view element to show Table2 in Table5.

This is where using data in related records can be hard to see and thus hard to imagine the coding. To make things easier, I would recommend creating a formula field in both Table2 and Table5 that points to the related Date in Table1 and Table3. One it makes it more obvious what field you can search/filter on. Plus you don't have to follow the chain up everytime you want to use Date.

Then in a view element it is:

let t := this;
select Table2 where Date = t.Date.

iliper LTD said:
let d := format(Date, "DD.MM.YY"); (select 'Table2')[format(Date, "DD.MM.YY") = d].number
if ш use this formula, having previously created the 'Date' fields, then in the field it takes data from all the fields from table 2, there are three records. How to make it so that all the records from table 2 are created separately in table 5? I need to solve this issue

When you are trying to find a set of records that you need to then do something with each record individually, then you need to:

1. create an array of the record Ids
2. use the for loop

So to do step 1, you could do something like:

let d := Date;
let recsToDuplicate := (select 'Table2' where Date = d)

You don't need to format the Date field since you are not displaying it.

In line 2, I put the results of the select into a variable and I removed the square brackets [ ]. Why, because when you use a square bracket in a select you are telling Ninox to send over the entire table to your computer and then your computer will filter the results. Not something you want to do if your table has 1,000 or 10s of thousands of records. Always start with the where, but there could be moments where you need square brackets with a select statements.

Now that we have an array, in the variable recsToDuplicate, to work with we can add a for loop to cycle through the array and do something with each record.

let d := Date;
let recsToDuplicate := (select 'Table2' where Date = d);
for record in recsToDuplicate do
    let newRec := create Table5;
    newRec.(
        'Tab. Name' := record.'Tab. Name';
        Number := record.Number;
        Group := record.Group
    )
end

But there is a link that is not created, the link between Table4 and Table5. Why don't you give it a try on how to create that link. You will need to:

1. find the appropriate record in Table4 and put it in a variable
2. modify the newRec.() part of the code to use the variable from step 1 to make the link
3. you will need the first() command as well

Take a look at the attached DB.

It will open to a dashboard. You can play around with the selecting a GM TABLE record then a table record then you can click on Create Hourly Estimate and see that it creates an hourly estimate of the table you selected.

The other button to create a table doesn't do anything.