Create a garden map with labels from records

Panorama X
1

How could I Create a community garden map with labels from records like name and plot number.Each plot number has a separate name associated with it. I do not know how to make each record be printed in a different location on the page.

Any Suggestions?

Thanks

2

Use a superlookup( function in the formulas for text display objects. You would place the text editor objects in the appropriate places for the plots they represent. The query could search for the plot number.

3

Sorry Dave, I don’t understand how to do this. Would each plot represent a separate record? I would think of having a name and number associated with each plot as a separate record. But what I don’t understand is how to distribute those on a map. All my forms have a set of objects that are then replicated in a similar location on a form for each record, as many times as there are records. The location of each record does not vary. I guess those are all view as list forms, which is the only kind I am used to using.

4

Each plot would be represented by a separate text display object. (I said text editor before but I meant text display.) As described, the appearance of the form would be the same, regardless of which record was active. If you were to print it, and you didn’t use PrintOneReccord, you would get a multipage printout, with as many pages as there were records.

Each text display object would contain a separate superlookup( function that would lookup information from a different record. There would be as many objects on the form as there were plots in the garden, arranged according to the positions of those plots.

For example, the formula for plot number one might be something like

superlookup("",{Plot=1}, {"#"+Plot+lf()+lf()+Name})

and the result could be something like

#1

John Jones

while the formula for plot number two could be

superlookup("",{Plot=2}, {"#"+Plot+lf()+lf()+Name})

and produce a result of

#2

Susan Smith

I am only guessing at the names of those fields, and you might have more information to include on the label, or want to present it differently, so you will likely need to modify those formulas to fit your circumstances.

5

What do you want to do with this? How would you like this to work?

If you are just making a map so that people would know what the plot number and name is for each plot, you certainly do not need a database for that. A graphics application would do that. If you want to be able to edit the name and number, start with the map and use an app that allows you to change the editing. You can use Panorama for that by putting buttons on the map with labels on the plots, which could bring up any information that you want fot that plot. Still, start with a graphics application, and use it for the background of whatever form you want for this display. If you want to get fancy, you could assemble the map like a jigsaw puzzle, with each plot being a piece, which could change colors when it is chosen or found or clicked.

There used to be a Panorama demo that did this with a map of the US, I believe. No matter what you want to do, start with the graphics, which may not be that easy, and then decide what you want to do with them.

6

I thought about using Pan for my Farm Map as it actually has better graphic capabilities than MacDraft. However, my map is 60" x 30" in size plus PanX can’t print anything wider than 8.5".