Hi Jeff,
That last update really helped, especially with regards to enabling user profiles.
So just as an update as to where I have reached now…
Template columns are complete in both sheets!
Relation has been formed between these 2 template columns!
The rollup column is now where I am struggling with - I think the reason for this is that the data I am looking to sum in this is decimalised and when I select this column in the rollup, I am only offered the choice of ‘count’ or ‘count unique’ and not to ‘sum’. So that has become my sticking point for today.
To give a little background on this in the form on my app, I ask the user to input the miles and chains into the form separately (UK railways are still measured in this form - 80 chains equates to 1 mile) and then I join these together with a decimal place in another column within my spreadsheet and it is this column that I am trying to use in my rollup.
However, I did proceed beyond this to see if I could then complete the final 2 points of your run through - creating an if/then and adding this to a Basic Table component. I did this by just using the miles column in my rollup (this isn’t decimalised and allowed me to choose ‘sum’) and I then went through the process of the If/Then column which I am happy I have done correctly. However, when I then set the Basic Table component to display the true or false from the if/then column I simply get this in written form and I can’t see any way of adding the checkbox you mentioned as there is limited options in the Basic Table component. Not sure what I have done wrong there?!?
Also, I might as well ask this now in case it is something I am doing wrong. I trialled my progress by making a form submission relating to unit 350101 and me travelling 24 miles on it - this worked fine but the details of this also appear on every other row relating to other units as opposed to just the row relating to the unit number. Would this suggest I haven’t linked everything correctly?
Apologies for my constant questions as it kind of feels like I’m just asking you for answers to everything but I can assure you, I do reach the hair pulling stage after hours of trying different things before I resort back to this thread.
Thanks again