Hi Everyone, I’ve been working on this project for a couple of weeks and ran into a snag. Hoping to post here for some help.
The app will help pilots track their personal aircraft’s maintenance items. I’m starting with one type aircraft with 40 maintenance items to track. If I were building this for one user, it would probably be ready pretty easily, but running into issues for calculatable/displayable fields because I have user-specific data configurations in place.
User Table has a few test users.
User Entry Logs records when a user updates the total aircraft hours (like an odometer), also includes the date of last recorded. I ran some math and rollup columns to display the last date and hours logged per user. Related the last record back to the Users Table to have a singular value for each user.
Maintenance Item tables has a list of 40 maintenance items and their intervals, intervals are on various hourly or yearly for time when Due.
I have a Status table relating to the maintenance items with logic to display when items are Good, Due Soon, Due.
The issue I ran into is when Users log their current aircraft hours, I am not able to get singular values per user to calculate per maintenance item. I was successful in getting the last hrs recorded to show on the data table, but the way the relation works from User Entry Logs to User, I use match multiple since each user will log multiple times in the app.
I believe this is my issue, but haven’t figured out the proper work around to get the singular Current Hours and singular Current Date for displayable calculations in the Maintenance Table. I’m wanting to show the user Remaining HRS and Remaining Days for each maintenance item based on their last input.
