Dynamic combobox/dropdown list

Fred what would be the solution, if I use multiple dynamic choice field? thank you, Kruna

Fred wow!! thank you also for the explanation, because dumb as I am it makes it clearer to me also to understand the script.

That works great

I have still one question issue facing hereby. Pls taka a look at the sample db. I imported the data from my existing db. Is there a way to get the choices sort by 1.group and then by 2.abc? To explain better I colored the categories/subcategories. As you can see the group 'green' is in the middle and at the end and not grouped and sorted.

I tried with order by and sort, but somehow it doesnt work.

Do you have an idea, if its possibel at first place?

Thanks, Kruna

Kruna Are you talking about sorting the table view or sorting the choices in a dynamic choice field?

Fred I am not sure if I am able to explain better, so here is a screenshot hoping to explain more clear, what i would like to achieve.

The last field is a fx field (formula is Subcategory)

Fred yessss, that's exactly what I wanted to achieve, but (pls apologize) when it comes to print layout the fx field (formula Subcategory) shows not text but

when I enter  the formula text(Subcategory) it shows the text, but not sorted like abc

Kruna I don't do any printing, so I can't help you out there. Printing, in my opinion, is still a weak point of Ninox.

Fredoh ok, it doesnt matter, I may open a new post concerning printing, altough I think it could be a bug. YES you are absolutely right, the print engine is disaster, but still I can use it for my 'little' needs for now.

Anyway I am more than happy that at least it is sorted by group and not mixed up. That its not sorted by abc, well I can live with that, even if there's no solution for it.

So I really thank you very much for your help!

Another possibility:

let t := this;
((select Subcategory)[contains(numbers(t.Category), number(Category))] order by Subcategory) order by Category.Category

The trick is to order by the least significant field first. As far as I know, there is unfortunately no equivalent trick to sort table views, so a combined sort field must be created.

Alain Fontaine thank you very much for your help, but somehow didnt work either.

I had the print issue also discussed in german forum and here is the solution - in formula field:

let UKatRes := numbers(Subcategory);
let sortUKat := ((select Subcategory) order by Category.Category + Subcategory);
let result := for i in sortUKat do
        for j in UKatRes do
            if i = record(Subcategory,j) then
                i.Subcategory
            end
        end
    end;
join(result[!= ""], ", ")

Now, its sorted by group and alphabatic order, which is also shown correctly in print layout. :-)

Kruna

Kruna I have zero experience with printing, but I understand that the function is severely rotten. So one should not try to print a DMC field, even if it has been correctly sorted, as shown on the screen. One thus need to produce a text field.

One should not sort on two text fields by simply concatenating them. While it will work most of the time, it will fail for certain combinations of values. If one value of the most significant field is a subset of another value, incorrect orders will result.

The proposed formula, with its two loops, seems a bit too complicated. May I propose instead:

let UKatRes := numbers(Subcategory);
let result := (((select Subcategory where contains(UKatRes, number(Id))) order by Subcategory) order by Category.Category).Subcategory;
join(result[!= ""], ", ")

Alain Fontaine well compared to you guys, I have no experience with anything in Ninox :-), so I am glad for every help and support I get and thank you for that, very much appreciated.

I tried your script and it works here as well.

The solutions here are not taht crucial, but as it is part of a contract, which I need in printed form, I would like to have 'perfectly' for better reading. If all the subcategories are mixed up, it may disturb the reading, but thats my personal perception.

have a nice day

Kruna

Kruna Hi Kruna .

You have the definitive example ? 

Rafael hi Rafael,

here is th esample db.

In table Dashboard - tab Category is the final example.

You will find two formula fields the first ist just related to the dmcf Subactegory. It is colored and you could also add some icons. Thats just for me to have a better oberview

In the second formula field is the actual script (from Alain) needed for printing. In printlayout  there is a 'test' layout.

Saludos Kruna