Formula field not displayed in table view
I've entered a valid Formula in Ninox that displays the result in the Form view. However, this result (only one) is not displayed in the Table view. When I drag the Formula Field to the Visible Columns and save it in admin mode, Ninox still does not display the column. More so, when I return to the filter, I noticed that Ninox did not accepted this field in the Visible Columns.
The Formula I used is this one:
let a := Medewerkers.'Woon-werk afstand';
(select 'Barema B' where Afstand = a).'Soca / dag'
The goal is to display the corresponding field in a different table (Barema B) of the value (Woon-werk afstand in the table Medewerkers) in column 'Soca / dag'.
I would appreciate your help on this one! Jarno