I don’t have much to say about the your work-through for the miles and chains issue I was having - except that what you have come up with is genius and works a treat If you have the time and desire to do so, I would love to hear how you reached that solution
Onto the second part of your response and I might be wrong but I’m thinking we may be slightly at cross purposes with regards to what I am looking for - forgive me if that isn’t the case but here is a breakdown of what I am looking for:
Each of the units in question are made up of 4 carriages and each of these carriages carry separate numbers to the main unit number. As an example 350101 is made up of carriages 63761, 66811, 66861 and 63711 and it is these carriage numbers which are listed in the ‘Travelled In’ section of my app.
Basically, when (as an example) a specific user enters 350101 as the unit number in the Add Haulage Form and then 63761 as the carriage, I would want a checkbox next to 63761 to be activated.
I thought that to do this I could adapt what you had suggested but to include the carriage numbers as well.
So in my main fleet screen, I set up a template that joins the user sign up email, the unit number and the carriage 1 number as shown below
Then in my Haulage sheet, I set up a template which joins the email taken from the Add Haulage form, the unit number and the carriage number as shown below
I then returned back to the unit sheet and set up a relation to join these 2 templates together as shown below
I had become some sort of Glide expert by this point and was next going to set up and if/then column and include the emoji you have kindly supplied previously but as you will see this failed to return anything in the relation column where it should have done so in a number of rows. I have checked the information and that the detail in both template columns match and can’t see where I am going wrong.
So my questions to you would be, 1) is the above approach (ie setting up templates and relations for each individual carriage number) the best way? and 2) if it is, where am I going wrong with my template and relation in the example screenshots above?
Again, thanks very much for your help with the miles and chain issue and for your ongoing support.