Jump to content

mwmartens

Members
  • Content Count

    8
  • Joined

  • Last visited

Community Reputation

0 Neutral

About mwmartens

  • Rank
    novice
  1. Well I needed to create my own functions for FMPro because the find and the export functions are limited. I am wanting to export two different flat files for each search result...one with fewer records than the other and a sub search of that one...i ended up figuring it out, and have included the code below, if anyone could use it...I think that it came out very well...opinions??? tell application "FileMaker Pro" set CDID_Box to display dialog "Please enter the desired CD to export:" default answer "" set CDID to text returned of CDID_Box show (records where cell "CD ROM Number" contains CDID) set number_of_matches to count records set target_file_name to
  2. Well I needed to create my own functions for FMPro because the find and the export functions are limited. I am wanting to export two different flat files for each search result...one with fewer records than the other and a sub search of that one...i ended up figuring it out, and have included the code below, if anyone could use it...I think that it came out very well...opinions??? tell application "FileMaker Pro" set CDID_Box to display dialog "Please enter the desired CD to export:" default answer "" set CDID to text returned of CDID_Box show (records where cell "CD ROM Number" contains CDID) set number_of_matches to count records set target_file_name to
  3. Well, I want to use AppleScipt for two reasons...first, the find "function" requires a continue once it has returned the results. Secondly, I am wanting to export two different flat files for each search result...one with fewer records than the other and a sub search of that one...i ended up figuring it out, and have included the code below, if anyone could use it...I think that it came out very well...opinions??? tell application "FileMaker Pro" set CDID_Box to display dialog "Please enter the desired CD to export:" default answer "" set CDID to text returned of CDID_Box show (records where cell "CD ROM Number" contains CDID) set number_of_matches to count records set target_file_name to
  4. I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001"
  5. I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell
  6. I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell
  7. I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell
  8. I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell
×
×
  • Create New...

Important Information

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