0

Formula field not displayed in table view

Hi guys, 

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

3 replies

null
    • John_Halls
    • 1 yr ago
    • Reported - view

    Hi Jarno

    The select statement will always return an array, even if it only finds one record. Try using first()

    let a := Medewerkers.'Woon-werk afstand';
    first((select 'Barema B' where Afstand = a).'Soca / dag')
    

    Regards John

      • Jarno_Vande_Walle
      • 1 yr ago
      • Reported - view

      John Halls 

      That does the trick! Perfect, thank you very much indeed 馃檪馃憣.

    • musprats
    • 9 mths ago
    • Reported - view

    When faced with this problem in field problemfield , I solved it by adding another formula field show just to display the result in the table: 

    let show := problemfield;
    text(show)

    don't know how widely applicable this is

    Sandy

Content aside

  • 9 mths agoLast active
  • 3Replies
  • 145Views
  • 3 Following