@Grant_Stead thanks for the reply and the offer of assistance.
To explain what I’d like to accomplish, I’ll briefly summarize the app’s purpose:
We are a utility providing electricity and water. We utilize infrared imaging to identify potential hardware failures within the electrical grid. The grid is broken into circuits which distribute electricity. Each of these circuits are inspected on a schedule. When these inspections identify potential faults in the hardware, a report is created.
These reports include a ‘live’ image which is a standard image and an infrared image identifying the failing hardware component. With appsheet, I am using the XY column type with these IR images as the background. The app user is then able to mark the image to identify the precise component that was identified as well as the temperature at the XY coordinates. Each of these IR images may include 4 or more locations of potential failure.
The current layout of the tables:
Circuit (Parent table of all distribution circuits)
__Inspection Schedule (Over time, each circuit will have multiple inspections)
____Fault (Each inspection can have multiple faults)
______Image (Each fault can have multiple images)
________IR Points (An image can have multiple IR points)
I will need to generate PDF reports of these inspections. Ideally, each fault will be a separate page with two images; one ‘live’ (non-IR image) and one infrared image. Attached is a report created with our current software. My goal is to create an equivalent within appsheet.