0

Show value in Choice (dynamic)

Test2.ninox

Good evening everyone

In d table

"Mine Table" - "Table1"  field  "Choice (dynamic)2" 

need to show table records from 
"Wendors" - "Name" - "Salary" - "unit"

I can't create a formula for the select (dynamic)2 field so that it is linked to records in "Name" and "Choice (Dynamik)"

Thanks everyone

3 replies

null
    • Fred
    • 4 wk ago
    • Reported - view

    Take what you learned in your previous post and extend it to the new subtable. Post your code, if it works or not and we can help troubleshoot.

      • iliper LTD
      • iliper_LTD
      • 4 wk ago
      • Reported - view

      Hi  

      To get the  "Choice (Dynamic) 2" value I use the formula 

      Name.Salary.Unit
      to get the value I use the formula "Choice (Dynamic)" and I get the result

      as you can see in the picture, all the values from the table "Unit" are displayed here, because there is no binding to the value in the field Choice (Dynamic)
      I tried this formula 

      let name := this.name1; 
      let 'Choice (Dynamic)' := this.'Choice (Dynamic)1' ;

      select 'Unit' where 'Choice (Dynamic)1'  = 'Choice (Dynamic)'  and name1 = name

      I think the beginning is right, but the problem is in the second half, it gives an error that the fields are not found

      • Fred
      • 4 wk ago
      • Reported - view

      Good start. Can I recommend that you look at your previous post where you learned about the record() command. Here is the link again.

Login to reply

Content aside

  • Status Answered
  • 4 wk agoLast active
  • 3Replies
  • 26Views
  • 2 Following