How to filter selection in dynamic choice field according to selection in another choice field.

Michal Bor said:
instead of recoding names in the WORKING HOURS table it records numbers in fields EMPLOYEE and SHOP.

Is there a reason why EMPLOYEE and SHOP are not reference fields? If they were reference fields then it will link the records correctly. This way all related WORKING HOURS records are linked to each EMPLOYEE and SHOP.

If you want to keep them simple text fields then just add text() around:

newRec.(
    SHOP := text(t.LOCATION);
    EMPLOYEE := text(t.NAME);

Why? LOCATION and NAME are dynamic choice fields. So you need to specifically tell Ninox which part of the data you want (choice id or choice value).

Michal Bor said:
I have tried to make it again, but still does not make record of NAME and SHOP if I add relationship between tables.

It is confusing at first. Learning any new language is. Hang in there it will all come together the more you use it.

Thanks for the DB. It makes it very easy to troubleshoot.

The original code is:

let newRec := (create 'WORKING HOURS');
newRec.(
        SHOPS.(SHOPS := t.SHOP);
        EMPLOYEES.(NAME := t.NAME);
        'WORK START' := t.'WORK START';
        'WORK END' := t.'WORK END'
    );

Imagine that you have manually created a new record in the WORKING HOURS table, what do you see. A record with no information. So your reference field SHOPS and EMPLOYEES are blank.

Now you want to link them to the selection made in the dynamic fields SHOP and NAME in WORKING HOURS FORM.

The trick behind reference fields is that you need to think record Id not about field data. I would recommend that you try to change your approach to your data. Instead of thinking how can I get the name of the employee. You should always be thinking how can I get the correct record from the Employee table to get me the Employee name.

This took me a while to understand and fully understand myself so give yourself time to get it.

Back to your code. The great thing about dynamic fields is that ones built on tables (since now you can use JSON as well) will give you the record Id. With that information we can link any reference field to the appropriate record.

You have already created a variable "t" that is equal to this. Great first step. Now you just need to change SHOPS and EMPLOYEES to be equal to the number of the selection made in the appropriate dynamic fields. Why? Because you only want the recordId of the selection not the text value of the selection. You see DERBY and NICOLE in the dynamic fields, but you need to keep in mind that it is the recordID that you want.

    newRec.(
        SHOPS := number(t.SHOP);
        EMPLOYEES := number(t.NAME);
        'WORK START' := t.'WORK START';
        'WORK END' := t.'WORK END'
    );

and you get this in the WORKING HOURS table:

I hope this helps.