Using unique values of another gallery inside a gallery

[Wouter-J]

Hi all,

I'm trying to use unique values based on multiple parameters, for example I have a machine value, a product value and a setting value that all need to be used for various formulas.

Currently, I've got a gallery that filters the machine(s) based on the current order number, within that there is another gallery that shows the relative settings for each machine, now I wish to use these settings to change to change various formulas (for example, setting * 1000 / ( MachineID * 60)

However when I try to directly access the text value, it changes for every machine, when I only want to use the value for each row.
Currently my app looks like this:


Where 'pizzadikte' is a setting based upon the picked product and machine type.

My formula currently looks like this:

Switch(
    ThisItem.MachineRef.Value,
    "1",
    ThisItem.MachineRef.Value * 1000 / (5 * 60) * (5000 / 100) * TextInput4.Text,
    "2",
    "This machine is Infeed; should grab data of machine in front",
    "3",
    ThisItem.MachineRef.Value * 250, // This should use the relative reduction value of the user (input field)
    "4",
    "This machine is Infeed; should grab data of machine in front"
)

Where in case 1 I want to use the value the user picked, I can't use ThisItem since then I get the 'this formula uses a scope, which currently isn't supported error'. Am I doing something wrong here or is a unique value per dropdown field simply not possible?

[Drrickryp]

Hi @Wouter-J 

I think you may have complicated a possible solution by placing a gallery within a gallery.  Before attempting to do what you are trying to do, I suggest that you set up a Gallery/Form combination where you select your individual machine in the Gallery and display the details in an Edit form.  If your table contains a one to many relationship, then the solution would be different. (ie. One machine, many parts), or even a many to many relationship, (one machine/ many parts and one part/many machines) I cannot tell if this is the case from your description so please let me know.  

[Wouter-J]

Hi @Drrickryp 
I will definitely try that! The problem is that each machine has 4 different values to calculate based on the type of the machine, additionally, each machine builds upon the next e.g. changing the values for Machine A makes it that the following machine(s) also change their values.

Furthermore yes, a machine can have multiple settings, it's a one-to-many relationship at this moment.