Multiple records per label?
Basically I need to do a sort of records and create a label that has 3 or 4 records per 1 label, multiple labels on a page
Seems simple but I'm stumped
Perhaps you could create a table just for this labels layout with some type of relational link back to your original table. You could then have one record per label as expected. Then you place a portal on your label layout to list your multiple records/label.
I don't know if you can get that to work. It's theoretically possible, but may not work for you.
Well it has been years since I have had to think in filemaker
Someone had this solution to a similar question but it confuses me a little.
1 create a separate table "4uplables" with the required layout
2 create a found set in the original table
3 create a temporary serial number 1,2,3,4,.... in the found set
4 create new records in the table "4uplables" using serials 1,5,9 etc (so serial +4) as many as the found set divided by 4
5 create 4 relationships: serial, serial+1, serial+2, serial+3 to the found set's temp serial
6 put related fields of all four relationships in every quadrant of the layout in "4uplabels"
you should have 4 separate records on one label now, delete the records after printing
This was a solution for 4 records per label but I'm lost after 3
I'm not certain. But, maybe:
Create a layout with as many portals (based on table occurrences based on the same table, with a self join) as there are labels that can fit in the layout. Let the first portal set so it displays records 1-4, the second so it displays records 5-8, et...
Create a second layout that does the same thing, et...
Of course, this really hits a wall, when you have more than just a few records... so it's not going to work.
Div ( Get (RecordNumber) - 1 ; 4 )
However, I wonder why don't you simply reduce the size of the body part, so that 4 records fit on a single label.
Reduce the size of the body part? I wish it was that easy, are we talking about the same thing?
This is the delema, I have 4000 records, each one is an electronic part.
I need to print lables for the parts drawers, each drawer has 4 parts in it.
I do a sort that correctly puts the parts in the order
So now I need to print a sheet of 100 labels that has the part description of 4 parts (records) on each label
I dont know how reducing the body size would help me do a whole sheet of labels? but I'm all ears !
I think Comment's got the right idea. Kudos for thinking outside the box!
Don't use Filemaker's built in "create a label layout by entering a label id widget".
Totally correct, I was making it too complicated
I am also fortunate in that I have a laser to cut these small card stock labels myself
The one thing I will have to play with is because of how these custom labels fit the drawers (part is hidden)
It would help if I could create extra space in the vertical columns between each group of 4 records
Retrieving data ...