MarkFuller

Thank you LaRetta for your example file. I think your example will work. Still I wish it was a native function of Filemaker, I guess it's time for a feature request. Thanks Too Daniele, that would certainly work, don't know about the "elegant" aspect of that approach. - Your english is just fine by the way. cheers, Mark

I would like to allow a filemaker user to enter a field in order to be able to copy the contents for a later paste into a different application. I don't want the user to be able edit the field or change it by mistake. I guess I could create a button for copy to the clipboard and leave the field not enterable in browse mode, but that seems a poor work around especially if I want all fields to behave the same way. Is there some secret filemaker dialog box that allows you to enter a field in browse mode and copy but not modify the data? Thanks - Mark Using FM 9 advanced on OSX

Tom, Thanks for that demo file, my css is pretty bad, but with a little brush up I think I can figure it out. Thanks again! Mark

Kind of a long question, hope this is the best catagory to post under. I am working on a label printing estimating /quotation database solution. Part of the solution involves calculating how many labels will fit on a sheet and drawing a simple sketch of the label layout. example: sheet size 8"x12", label size 3"x4" (These sizes will chage with each new quotation.) For the sake of this example I will say there is no space between labels and we can print right to the edge of the sheet. First we determine how to orient the label on the sheet to get the best yield. If we orient the 3" side of the label to come out of the 12" edge of the sheet we can fit 4 labels across and the 4" side comes out twice from the 8" giving us a total of 8 label per sheet. This gives us the best yield VS. the opposite of orienting the 3" side of the label along the 8" sheet etc. ( 6 labels per sheet) That part is pretty easy. But once those calculations are done I would like to generate a small scale drawing of the labels as they would appear on the sheet. This drawing will be included in the printed quotation report. It should show the label layout and orientation on the sheet. The drawing should show the 8"x12" sheet with a smaller grid of 3" x 4" labels. The proportions of the drawing should be somewhat accurate. So if it were a 1" x 1" label it would look correct compared to a 1" x 3" label. I am stumped as to how to approach generating this small sketch based on the yield calculation and including it into the printed quote. Any ideas or approaches would be much appreciated. Thanks, Mark ps. I could not seem to update the SW version, but I am using FM 9 Advanced.

Thanks very much to you both. I think I can put it toghether with your help. The increment by 10 is because there will be 10 labels printed on each page (in this example) so each field should increment by 10 every time a new record is made, to have multiple pages increment in sequence. Hopefully that makes sense Thanks again, this site is a great resource. Mark

I would like to create an auto incrementing serial number field to print some sheets of labels that are Mac Addresses (Media Access Control) numbers. The format is 00-00-00-AA-AA-AA each pair of numbers are hexidecimal numbers so it will increment from 00 thru 09 then 0A, 0B, 0C, 0D, 0E, 0F, 10, etc. Say I want to have a sheet of labels with 10 labels per sheet. Each label on a sheet will be its own field which will increment by 10 (10 per sheet) Is there any easy way to have filemaker use Hexidecimal numbers in the autoentry serial number field? It seems like someone would have run across this already? Thanks in advance, Mark