Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

-2 Poor

About philipcaplan

  • Rank

Profile Information

  • Gender
  • Location
    London, England

FileMaker Experience

  • Skill Level
  • FM Application
    16 Client

Platform Environment

  • OS Platform
  • OS Version
    MacOS X 10.13.3

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I think I've got it to work!! I used the following calculation: TextSize ( TextColor (TextFont (zMESSAGE ; zMessageTextFont ) ; Evaluate(zMessageTextColor) ) ;zMessageTextSize) Thank you.
  2. I have a calculation field called 'zpastableMESSAGE' the entire content of whose calculation is as follows: TextSize ( TextColor (TextFont (zMESSAGE ; zMessageTextFont ) ; zMessageTextColor ) ;zMessageTextSize) (1) the field 'zMessageTextSize' is a text field, and whatever numeric value I enter into it is being used as TextSize, and correctly changes the size of the text displayed in the field 'zMESSAGE' (2) the Calculation fields 'zMessageTextColor' and 'zTestMessageTextFont' at present contain values RGB(0,128,0) and "Krazy Kracks NF" respectively, BUT ARE BEING IGNORED (that is,
  3. I've tried!!!! I added a field RequestedFont, and formatted it as a popup menu with 3 names. Then I edited cTxtR to be this: ---------------------------------------------------------------- Let ( [ color = Case ( Extend ( RequestedTextColor ) = "Red" ; RGB ( 200 ; 0 ; 0 ) ; Extend ( RequestedTextColor ) = "Green" ; RGB ( 0 ; 200 ; 0 ) ; Extend ( RequestedTextColor ) = "Blue" ; RGB ( 0 ; 0 ; 200 ) ) ; fontName = Case ( Extend ( RequestedFont ) = "Beagle Boyz NZ" ; "Beagle Boyz NZ" ; Extend ( RequestedFont ) = "Candy Dancer NF" ; "Candy Dancer NF" ; Extend ( Reques
  4. Thanks, comment. That is very useful. One thing though, I don't see an option to change the Font. Could you possibly add that? Thanks again, Philip
  5. Thanks comment I am having difficulty understanding why this needs to be a REPEATING calculation field, and how SelectedRepetition and CalculationRepetitionNumber get their values. If ( Extend ( SelectedRepetition ) = Get ( CalculationRepetitionNumber ) ; TextSize ( TextFont ( TextColor ( Extend ( RequestedText ) ; RequestedTextColor ) ; RequestedTextFont ) RequestedTextSize ) ) Is there a reason why it won't work to have a Calculation field called say FormattedzMESSAGE to format the content of zMESSAGE, like this: TextSize( TextFont( TextColor(zMESSAGE;zTextColor);zTextFont) ;2
  6. Hi comment. Many thanks for your answer, very useful as always. What I am "really trying to accomplish" is the production of a 2-page A4 PDF which can be printed on an inkjet printer to produce a "personalized greeting card". The front-end of my idea is already working: it is a PHP/Javascript-based website on which a user chooses an image and then completes a simple form with their wording and choice of font and fontcolor to overlay and/or go beneath the image. When they click "SUBMIT" the site sends me an email with all their data,. I copy-and-paste that email's contents into
  7. Can some kind person please give me a script that will: (1) place a Text field on the current layout, with location and size taken from 4 fields (x_origin, y_origin,width,height) (2) insert into that field the contents of a Text field called 'this_text' formatted with font, size, color, alignment taken from 4 other fields (fontname, fontsize, fontcolor, alignment) Thanks you. Philip Caplan
  8. My skill level is "intermediate" because, if it was offered as an option, I would prefer to say "intermediate in what I know, novice in what I don't". But that wasn't a choice!!
  9. Hi comment. I'm sorry if I disappointed you please understand I am not a database expert. I am a printing-company owner who dabbles in getting freelancers to write website code, and I was introduced to FM (I think it was then Filemaker II) in the late 1980's as a way to "manipulate and massage" data to feed into DTP programs like QuarkXPress. As I only use FMPro when a need arises, I am not attuned to the subtleties of the program, and to answer your 2 points above: I had followed the installation instructions to manually copy the baseelements.plugin file into the Library on my Mac,
  10. Thanks comment. I downloaded the baseelements plugin, got a zip file which unzipped into a single item called BaseElements.fmplugin I googled how to install it, but I couldn't get it to install by copying that file into Library>Application Support>Filemaker>Extensions Sent a message to the author of the plugin, but so far no reply. So, I thought I'd try to use your suggestion in Steps 1 to 5, but in Script Workspace I couldn't see TextDecode in the script steps, so didn't understand how I could use it. Is a "function" another name for a "script step"? Can you ple
  11. I have FilemakerPro 16, and I would like a script that does the following: (1) opens a textfile on my computer, if it exists (or create it if it doesn't exist) (2) writes the content of a field at the end of the file (ie, as a new final line) (3) closes the textfile Is that possible without a plugin? If not, is there a cheap or free plugin that will enable this?
  12. Thank you, comment. Once again you save the day for me! Being an amateur, I tend to think "what steps do I want to do, which script-steps acheive that". I never use "Set" outside of scripts, so I don't tend to think of it. Thanks again
  13. I am sure this is going to seem like a very stupid question, but..... I need to write a script that (1) goes to a particular field (2) removes any content in that field (3) replaces it with a single letter "y" Can some kind person please tell me the script steps to achieve this, as I cannot seem to figure it out for myself.
  14. Thanks for this, comment. It is working perfectly for me. I also have another request. I have a Calculation field (based on what you gave me) as follows: Substitute ( Let ( [ lineStart = Position ( PASTED_INPUT_to_use ; "¶Message: " ; 1 ; 1 ) ; start = lineStart + Length("¶Message: "); end = Position ( PASTED_INPUT_to_use ; "¶Font: " ; start ; 1 ) ] ; Middle ( PASTED_INPUT_to_use ; start ; end - start ) ) ; ¶ ; "<p>" ) This nicely gives me a result containing the multiple lines of content of "Message" with each line-ending replaced by <p> Wha
  • Create New...

Important Information

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