Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About André

  • Rank
  • Birthday 06/07/1974

Profile Information

  • Gender
  1. [color:red]BUMP anyone?
  2. [color:blue]I've got a leftbrain torture for you, i just hope i can explain te problem clear enough... Here goes, I'm using FMP 8.5 Adv for small labels, which are saved as PDF, and in acrobat (with the aid of a imposer plugin) combined on larger sheets, and from there to a printing press. (All of the above is no problem at all, so you won't find any of this in the samplefile below) The problem is that each label (item) has its own printrun, and i'd like to optimise the sheets for the printer as much as i can. Therefore i'm duplicating some records so their printruns are lowered, and with that the surplus of the other items on that sheet are lowered too. I already made a solution to predict the number of printing sheets, and a calculation for the printrun of each sheet. What i'm boggling my mind about is a way to automate the process of duplicating records in the most efficient way. I'd like to note that just duplicating the highest printruns isn't always the best solution, every-time you duplicate a record (what can only be done a limited number of times, because you don't want extra sheets in your press if you don't really need to) And sometimes it's more efficient to duplicate one of the lower printruns, because of the shifting, the last one of one page would be the first on the next page if a record is added above. And that last one is likely to boost the printrun of that sheet. And it's possible you'll loose there more than you gained above. As you might have guessed, i've always done the duplication process manually, and it's sometimes a bit of a puzzle which record to duplicate, and keep the number of sheets & printruns optimal. Now, to save time on future orders, and to make the process easier for others (read: colleagues) i'm searching for a way to automate the optimising process. I hope all above was clear enough, suggestions are more than welcome. I'll include a stripped down sample file [color:red]Thank you for your help. combined_printrun_sample.zip
  3. André

    skipping records dymo labels

    I had this once, and it turned out to be a hidden checkbox; print evens (or odds) only. just my 2¢
  4. André

    CE fonts and PDF's don't mix well (OSX)

    So my font seems to be the problem (odd), a conflict somewhere with the FM PDF engine... I haven't used the OSX default Futura for ages (because we usually use the Futura std Opentype we bought from Adobe) Your suggestion made me search for it, and -surprise- it worked! I just hope the that font contains all special characters too (have to test that) Oh, i've found the language setting in the storage too, i'll set that for the data fields, probably helps with hyphenation on the rare occasion the text is longer that one line. Thank you for your help!
  5. André

    CE fonts and PDF's don't mix well (OSX)

    This text was typed on the layout (static text). Besides that i'm not sure what you mean, or where to look. My FM is dutch, the text is Czech Republic (i doubt i can select that language anywhere) could you explain a bit more? thank you :-)
  6. Hi, i got a nice question for you guys (gals) i'm trying to use FileMaker 8.5 Adv to generate PDF's with Central European fonts (in this example Futura CE) I receive the texts in Excel, and sometimes in a email, and importing them in FM is a breeze... But the problem i got is when i generate the PDF with the FM build-in PDF engine, the special characters are either lost or replaced with anonther letter (?) When i make the PDF's with the printdialog -> save as PDF the result is correct. And you guessed it, i'd like FileMaker to do that too (because i want the files to be named with a calculated name) Oddly, i don't have this problem when i use the font Lucida Grande, (pity the customer insists on Futura) To be sure it's not the font, i made a PDF with good old Indesign 2.0, and the result was just fine. Suggestions welcome... Below a sample image.
  7. -post deleted for not making sense- :
  8. André

    Creating a dynamic range portal

    Thank you.. it's much simpler that way nice trick with the background, and the shift-click was new for me too bcooney: i discarded the portal idea, because this worked for me just as fine :smirk:
  9. André

    Creating a dynamic range portal

    Thanks for your quick reply, i found another way to show the range, i'll include a example file, comments are welcome. example_daterange.fp7.zip
  10. Hi, i hope someone can help me with this, i'm trying to make a portal with a range between two timestamps my records all have a date and time field i made a selection box 'select', with '1' as the value for a [X] a calculation 'Timestamp_selected' > If(select;Timestamp ( Datum ; Start );"") resulting in a timestamp when the record is selected. now, i'd like to select two records (by putting a 1 in the 'select' field) and see all records between the two calculated timestamps in a portal. i tried this with three more calculations; > the calculationfield 'one' = 1 for a relationship called 'one': one=one (resulting in a relationship with all other records) then two more >timestamp_from MIN(one::Timestamp_selected) >timestamp_to MAX(one::Timestamp_selected) resulting in a relationship based those two; timestamp ≥ timestamp_from AND timestamp ≤ timestamp_to unfortunately FileMaker doesn't accept those, because they refer to a relationship... Any suggestions how to tacle this?

Important Information

By using this site, you agree to our Terms of Use.