Arrange records on a map
I'm not sure what you would call this so I haven't been able to search much. I'm making a solution for a truck rental. The only thing I'm having some trouble with is one page I need to basically be a map of the parking lot. Then have all the truck numbers placed in boxes in the lot where the trucks are. The boxes would be either white (just came in) red (broken) or yellow (ready). Now I could change the colors with conditional formatting, but how would I get separate records from the "Trucks" table to be shown laid out according to their "Location" field. The "map" would basically be just drawing with the shape of the lot with boxes for each parking space.
Also would there be any easy way to handle arranging the trucks (fields) on the page. Is there a way to drag-and-drop the numbers to a different location on the map? If anyone needs help visualizing what I'm looking for let me know and I can draw it out and attach an image.