I have a data set that links to another dataset through a multiple item reference. One a formula data set and one an ingredient set. I need the ingredient items to appear in the order that I enter them into the multiple item reference field because they need to be displayed in order of weight as a part of an ingredient table. Many of the items are repeated over several formulas so I am not able to sort the ingredient data set in a way that matches every formula. What are my options here for defining, per formula, exactly what order the referenced items should show up in?
Is there an option to have the ingredient dataset NOT sorted at all? Currently, it is set to sort by date created. If I could take that option out I would imagine it would sort by the order they are entered in the reference field, but I do not see a way to remove all of the sorting options. Once one is removed, the default “Date created: New → Old” shows up again.
Thanks for the help.
I don’t know if this would help, and it may not be the best way to do it, but when I’ve needed things to be in a particular order I’ve added an Order column for each item. 1 for top, 2 next etc… then just change the settings on the dataset in the editor to sort by the order column from highest to lowest or lowest to highest.
Right, I thought the same thing. The issue is that some formulas have the same ingredients but need to be represented in a differnet order. For example:
Formula One:
Ingredient 1
Ingredient 2
Ingredient 3
Formula Two:
Ingredient 2
Ingredient 3
Ingredient 1
I cant order the ingredient data set with a column and get the correct order for both formulas.