I have been using AppSheet for just over a week now. I have completed the Udemy AppSheet Essentials course and am looking at some additional reference materials, trying to build and learn at the same time. All the information overload has my head spinning at this point, and I need to talk about this out loud with the hopes of bringing clarity to my own thought process, and possibly get someone else to help me figure out the best way to approach what i am looking to do.
The current project I am trying to do should be able to have a user add notes to a record. For the sake of argument, lets assume i have a list of cars that need to be worked on and currently have a cars table that details information about the cars. If user A washes a car, i'd like to add a row to a secondary table that contains the notes the user added about the job, tied back to the car along with a timestamp and a record of who added the notes.
I understand how to grab the timestamp of the when the record was created and i understand how to track the user who created the record.
What I am having trouble grasping is tying the data from two tables together. I think that if I continue to break down the Facilities Inspection app template, this will start to click for me. I'd like the end result to be something like, if I click the detail view for the car, i can see all notes that were left for that car.
As I said, i think i'll be able to get this figured out and probably just need to take a break to clear my head for a moment, but if anyone feels compelled to throw any words of wisdom, my eyes and ears are open.
If you have read this far, thank you.
LinkedIn
Twitter
