I can't get a Dynamic Choice to select from a table. It works in other circumstances.

M

I'm building a dashboard form, and I'm stumped.

I have a Dynamic Choice which returns a value from Column Kit from a table Kits. Works fine. In the Dynamic Choice, the Dynamic Values are "select Kits" and Dynamic Value Name is "Kit". The Dynamic Choice populates.

In a formula box, I want to select a value from this Kits table depending on the dynamic choice. My code is:

let i := Choice;
(select Kits where Kit = i).Price

I get an empty return

As a test, I have a value from Chioce, which is "Dave". If I hard code this in as such:

let i := Choice;
(select Kits where Kit = "Dave").Price

This works fine - I don't know why Ninox isn't making the link. Can you help?

 

 

Ninox Profile

record(Kits,number(Choice)).Price

Steven

M

You're a star. This also fixed a number of formatting issues I've been having. I'm pretty steeped in SQL, but need to get my head in the Ninox idioms. 

M

Is there somewhere in the manual that explains this - it seems pretty powerful.

J

Hi Mark

 

This is what the manual says:-

record(tableName, recordId)

record(tableName, recordId).fieldName
Use the record function to return the nth record id of a table as a handle.
Note that recordID is not a position in a sorted view. If a record has been deleted, using that recordID will return a null, since the ID no longer exists and never will again.

 

Regards John

Reply