Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About rcorbitt

  • Rank
  • Birthday 07/28/1966
  1. I have a products database containing a "link" (text field) to a specific product on our website. At the end of a customer service phone call, I would like to be able to click a button and have the contents of an email message from three other (text) fields and the "link" copied to the clipboard. This information has to be pasted into another application, which sends the message, and records the notes of the customer service call. I cannot send the message from FileMaker, it has to be copied and pasted ... The problem lies in making the "link" field into a working URL. Currently the product l
  2. This will definitely work. Is it possible to write a script that will delete all the text "above" the string that begins with "Vendor:"? (All the records have the first four lines in the field.) Here's a better example:
  3. I'm having a foggy brain moment ... I have a text field that I would like to delete all the text in the first 18 lines, for over 7,000 records. The field contains a Product description, product ID, UPC and vendor record. I have each of these in separate fields. The text files were imported (originally Windows XP Notepad) as .txt files. Can someone point me in the right direction? Data example:
  4. Would it be possible to set the size of the body part using a calculated Applescript based on the case statement?
  5. I am generating a PDF from records in the found set. My layout has header, body, and footer parts. The page size is 11" x 15" with .5" margins on all sides. (Custom page size) The header is 1", the footer is .5"; both containing text. Is there a way to have the body records equally spaced, with a rule above and below, to fill the 12.5" available space? (There will never be more than 20 records in the body space.) Initially, I measured the size (in points) of a record including leading and created a "space" field that was placed above and below the data. Using a Case statement to coun
  6. First, let me say thank you for all the help. I'm very grateful for all the suggestions. Second, I am not experienced with Applescript. My goal using AS with this database was to reformat text "after" it had been exported from FileMaker. Fenton's suggestion to use the Substitute() function is a good one, and I will probably include it once we're done with some beta testing ... The script that I posted was not complete. It was only to illustrate that I was using more than a simple AS statement or two. After fighting with FM for a few days, I have given up on running a native AS f
  7. Thanks, but as I understand it, this will only work on data in the fields. To complete the project, I still need to manipulate the exported text, outside of FileMaker. That's why I'm using the Applescript...
  8. First, there's not much relational data in this db. I created it to handle, format, and manage imported text. (I'm better with FM Pro than Applescript, and this way we have an easily searchable record of all the info.) I'm using the text that is being exported for a Quark XPress document. There are about 2,000-8,000 records each month that get exported. Formatting this large amount of data is only feasible using Quark tags or a plug-in like Xtags. I'm using .csv format for the export, so the records have to be cleaned and formatted with Quark Style Tags. I could do some of this with
  9. Actually, I'm using the whol eApplescript for more than just this field. tell (get (current date) - 30 * days) set currentMonth to (month of it) set currentYear to (year of it) set lastMonth to ("- " & currentMonth & " " & currentYear) as string end tell set theExportedText to (path to desktop as Unicode text) & " county final.xtg" as alias set theExportedText to (open for access file thePath with write permission) --Read the whole file at once because it is a small one set FileData to (open for access file theExportedText) set c0 to {""<@FTRCo
  10. This isn't working. I get the same error. The purpose of this AS statement is to get the value stored in the global field g_CorpCounty. This field is entered by the FM user when searching for records to be exported. I want to set it to an Applescript value (object?) so that I can use it again later in the Applescript to name the file. (set theOutputName to theCounty & " County final.txt")
  11. I'm having trouble getting data from a global field into an Applescript. Here's what I have now. tell application "FileMaker Pro" to set theCounty to cell g_CorpCounty of database 1 The script keeps giving me an error "theCounty" is not defined. Unknown error -2753. I've read that adding a try statement helps native Applescripts in FileMaker, but it hasn't prevented to error so far.
  12. Works great. Thanks. I guess that I'll not worry about the text editor. (I am using Tex-Edit Plus.)
  13. I need help with two things. First, I want a script that defines the output path for an exported text file. If possible, I want the user to select the output folder/location (example: MacHD:Users:User:Desktop:$filename.txt) on the first use of the script, and then the script will remember it each time the script runs. If the folder/location is missing, the script will ask the user to redefine it. Second, this exported text file will be imported into Quark XPress 7.2. Currently, I'm using Tex-Edit to "massage" the data to remove quote marks, commas, add spaces, etc. Can Applescript ed
  14. Maybe a better solution would be just first and last name. Suggestions?
  15. THANKS! This works pretty well but ... The fourth "word" of the field will always be the suffix, if it exists; and I need to move it to the end. (BTW - Universal Capitalizer is incredible, I have it working on the address field already.) Currently "Doe, John Robert Sr." becomes "John Robert Sr. Doe". How do I get the fourth word to the end, only if it exists? "John Robert Doe Sr."
  • Create New...

Important Information

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