In my RV app, I wanted to have a clickable list of all the items that needed to be checked at certain milage intervals. Example, what needs to be done at 40,000 miles and next at 60,000 miles.
I put the Milage breakdown in each ROW, and the items in Columns. If you look at these screenshots you can see what I did. In the app I can see the milage intervals in an inline list, but I don’t know how to display all of those items that align with the milage interval.
May I ask for some help with how best to do that? Thanks so much.
you have the wrong data structure…
you don’t need to create separate columns item 1, item 2…
just put them in 1 column and in the next column assign milage to them… then just simple relation or filter to connect these
Thanks Uzo, I did the item 1, Item 2 so I could use an Array, but I guess that was not correct. So you suggest I just put them all in the same cell? Use commas?
you need only 2 columns for this project… you might use a separate sheet to put just inspection mileage for the choice component… to make assigning easier.
having all tasks in one column will make it easier to create check marks for completing tasks
no, the other way, all tasks are in separate rows and assign inspections to them in the 2nd column… unless you have other plans on how to use that data…
in my mind, I’m thinking to put one more column with timestamps, when the task is completed… so joining tasks in one column would be problematic
no, unless you have something else in mind…
separate all Maint Items to separate rows… so you can control them… like if someone only changed the oil, they can put a checkmark and time stamp on that and maybe add how many miles the car has at the moment… then you can send an alert what work needs to be done depend on time passed or milage… time control will be good to remind about insurance, inspection…
OK, sorry it took me so long to “Get it” but I have now broken each item out into its own ROW. What next? Do I need a separate table with the milage? How is the best way to show these in the app. I like Uzo’s suggestion of being able to show if and when each was accomplished!
I have been playing with creating a relationship columns, but not getting what I need. Maybe a couple of step by step instructions would help.
For setups like this, I like to have a separate table, so in your case, yes, a separate table to list the mileages would be good. Then you can create a multiple relation in your new mileage table that links the mileage value to the mileage value in your log table.
Thanks @Jeff_Hager, can you step me through the relation setup? I have the sheet you see in the post above and I have a separate sheet with just the mileage intervals that I copied from this sheet.
Which sheet do I setup the relation in? What relations am I matching? When playing with it, it seems to only bring back the mileage and not the items. Sorry Im so slow on this, but thanks for the help.
You would set up the relation in the new mileage intervals table. Relations look for matching values, so when you create your relation column, you will select your interval column, then match it up to the interval column in your existing log table. Also, make sure you have selected the Multiple checkbox when setting up the relation. You want to do that because you are matching one row in your mileage table to many rows in your log table.
If you are getting matches, then the relation is working. You just have to keep in mind that relations return rows. Not any specific column. You may be seeing the mileage in the relation column, but that’s just telling you that it found a match. What it shows is irrelevant.
Now that you have your relation set up, you would create a tab in your app that points to your mileage table. This will give you a list of each mileage. When you click on it, you will get a detail screen for that mileage row. Here is where you can add an inline list that uses the relation column as the source. This will then show all of the related matching log entries for the mileage interval you are viewing.
Im getting there, but now I have multiple intervals in the inline list. I would like to see a list of each interval, then when you click on an interval, you see the list of Maint items.