Share information between two tables
I have a formula that copies information from another table when the table name is same
let t := this;
first((select AllTables)['Table Name' = t.'Table Name'].'Number23')
how to make it copy the information when the date matches in both tables?
Elsewhere I use a table like this
let d := format(Date, "DD.MM.YY");
(select 'GM TABLE')[format(DATE, "DD.MM.YY") = d].number56
I have the "Date" field in both places, but the formula doesn't work. I checked both formulas. First one no mistake but not work
I would check that there are records that meet the requirements that you set. To check you should try each parameter separately:
first((select AllTables)['Table Name' = t.'Table Name'].'Number23') then first((select AllTables)[dateField = t.dateField].'Number23')
If they both work, then you know that there is no record that matches both requirements.
Second have a mistake
So my first question is 'Table Name' a reference field or just a text field?