Script Workspace and Script Triggers

I have two related tables and one has more records in it than the other. I need to make a script to add the missing records to the smaller table. Anyone have any ideas?

I have been using this script in a previous application with no problems. I installed these scripts in my separation model and it doesn't matter what file I open I get the UI file saved under all three names. Any ideas what I'm doing wrong. TIA for your help.

Is there a way to set the default value for a "global number[35]" field? I want to set [1]=1, [2]=2, [3]=3 I'm using FM7 I want something else than Set Field(f, 1) Set Field(f[2], 2) Set Field(f[3], 3) ... Set Field(f[35], 35) Set Field(f=Split("1;2;3;...;35")) would be marvelous.

Window problem I have a data entry layout. I have a button that opens a new smaller floating window (400 x 400 px). I have a button in this small window to close it. The purpose of the small window is to display info while allowing the user to keep entering data in the main window. My problem is I can't get FM to keep the small window on top of the maximized window while still being able to enter data in the main window. I have searched this site to no avail. I am facing these 2 situations: 1) The small window stays on top of the data entry layout but I cannot select the data entry layout to enter data 2) The small window pops up but when I click on the data en…

Hello All: I ran across another challange with my DB described in http://fmforums.com/forum/showtopic.php?tid/192648 What I am essentially trying to do is: - select a set the records from a table - based on the criteria that I get from another table for a field that relates the two, and then - further reducing the set to those records that has a quantity greater than zero. I have the following script: [i am starting this script from a button on a layout that is displaying a record from "equipment_repaired" table. ] Set Variable[$r_t_no; Value:equipment_repaired::Repair_Ticket_No] Perform Find [Restore] #COMMENT: Criteria: Parts_U…

Is there a way to reproduce such technique in FileMaker. SELECT t.Field1 AS Field FROM Table t WHERE t.Field1 IS NOT NULL UNION ALL SELECT t.Field2 FROM Table t WHERE t.Field2 IS NOT NULL /*[...]*/ UNION ALL SELECT t.FieldN FROM Table t WHERE t.FieldN IS NOT NULL ORDER BY Field /* If I'm correct, aliases are taken from first subquery and "ORDER BY" clause from the last one.*/ I want to be able to switch from : ID, "BMW", "Audi", "GM", NULL, NULL ID, "Ford", "Audi", NULL, NULL, NULL ID, "Toyota", "Pontiac", NULL, NULL, NULL To: "Audi" "Audi" "BMW" "Ford" "GMC" "Pontiac" "Toyota" Merci ;)

Hello, This is probably a really simple one, but since I just started using this FMP a couple of days ago it's causing me a bit of a problem when I try to send personalized group emails. Here's what I did. - Setup a new database with customary info such as last name, first name, email, www site, member of mailing list(drop down menu, yes, no) etc... - Started a script with the SriptMaker that looks like this: Step 1. Find Records test::MailingMember:[=yes] Step 2. Send Mail [no dialog; To: test::email; Subject:"email test"; Message:test::name] This works well. I get the email and my name is in the body of the message. Now the problem par…

I am looking for an easy way to email a pdf from a filemaker layout using the email address from the record in one step. I do not need to save the pdf. I am sure there is an easy solution but I have not yet been able to figure it out. Thanks for any help

I want a simple script that will get the users name from the from FileMaker, then go to a table I created (Users) and get the the value of the id field that has the same user name (a copy of the user name is stored in the Users table). That should be easy, right? What about a good reference (book, website) just for scripting? I have "The missing manual", but I'm guessing that there's something better for scripting.

Hi there! Any ideas out there for this one? I have a script that Saves Records as PDFs using a filename that encorporates several fields from the record. I am trying to create some security in the script so that if a PDF with that particular filename already exists, that it is NOT overwritten. So before the Save Records as PDF script step is intiated, I used the Insert File step with the filename to insert the file in a global container field. Then used the Get(LastError)=0 and used the Else to show a custom dialog message warning that the file exists and then exits the script before getting to the Save Records command. It works well if the PDF file doe…

Is there a way to have a start-up script with different behaviors depending on Privilege Set name work with IWP? I have made a script that does the following: If Get(PrivilegeSetName) = UserPrivilegeSet Go To Layout "Main" Else Go To Layout "Menu" When accessing via FM Network (I'm using FM Server 7 Advanced) this works fine, however, as soon as I access through IWP the script moves to my Else step. Any ideas? As usual, thanks in advance to all who reply.

I have two tables. Each table has its own layout. My first layout is Home (1 table), and my second Layout is Handbook(2nd table). I'm tring to build a script so i can click on a box in layout 1 to be able to go to a certain record number in Layout 2. How can i do this. In my layout 2 i have 35 records ,and i have several butons in layout 1 that will need to go to different records in layout 2. Hope this makes sense. Thanks

Is it possible to call a script in a field. i.e. When i click on my field, i can click calculated result. Within this option is it possible to to call a script to run? Thanks, Sully

I want to insert a pdf from the server, and place it in a container. Can I write a script that will automaticly pull the job #, and job name, and use that information to navigate to the server to find the file? Example: My budget for job# 101, job name Monterey, is lacated at Jobs/101/Montery/budget.pdf. Thank you Terry Hash

Hi, how would I accomplish: Paste script step that pastes into a field that already contains data. When pasted the "pasted data" gets appended to the end of data (data being text) without a space. For example field contains: Test If I paste a "String of text" into it I get TestString of Text I want to get when I paste Test String of Text Would I achieve that within the script or within the field via format or auto enter calculation or alike? Thank you.

Hi guys, this is the last thing I need to do to finish my system, and I am completely stuck, even my coordinator has no idea. Basically I have a layout which calculates how much each "Department" is spending, through summary fields and a currently basic script The idea is that the user enters the department and the date (drop down calender) they want the results to be shown from. So far the script works in working out the "Total Cost" when searching by Department alone, but when searching with the "Date Range" as well, unless there is a record with that matches that date exactly, no results are found. So what I was wondering if there was a way for the …

Essentially, I have one field that has more than one "passcode". If 1=1, 1. If 1=2, 2. If Neither, Show Message: "Incorrect Password" So far this is what I have, but it doesn't work as desired. ---- If 1=1, "Approved" Else Show Message: "Incorrect Password" End If If 1=2, "Approved" Else Show Message: "Incorrect Password" End If ---- Any tips would be greatly appreciated. Thank you kindly.

I have a simple script the shows a custom dialog that gives the user the choice of running one of two scripts. When I run either of these two scripts via this dialog they run very slowly. If I run them without going through this custom dialog they run almost instantaneously. I can't figure out what the problem is as I am making this work the same way I have for other scripts without any problems. Any ideas? Greg

Is it possible to make a date field (maintenance renewal date) automatically email recipients when the month of renewal is reached? If so can anyone tell me how? Hope this makes sense : Thanks

Has anyone seen a script to memorize and restore open window information. On close, it would have to keep track of. - name, size, position, and layout On Open, it would have to restore the above, but check position and size against current screen resolution, and adjust the window details accordingly.

I have a simple table with 2 fields: "Invoice" and "image". "image" is a container field that holds a pdf file (not just a reference). Now that I have this table I can search for the "Invoice" record that holds the pdf file I want to view, select the "image" field, but I how do I get the pdf file to display on the screen. Originally I was storing only the reference in the "image" field, and I could display it by using Goto Field[select/perform]. Now that I'm actually putting the file in the container and not just a reference, it no longer displays. You guys showed how to do it with the reference, I'm hoping you can help me again. Thanks very much.

Hi, Does someone have an example of a looping script they can point me to so I can try to learn, I did a search but could not find anything close that will delete records. This weekend I was trying to create a script that will delete all records that are more than a year old, and all I can manage to do is delete one record and then I have to Ctl Alt Delete so I can kill FM because I get stuck in an endless loop. James

I have an old database I use for Invoicing. It's updated to FM 9 nicely however I would like to add an aged debt section to it. I have two filemaker files. Customer Details Customer Invoices. When an invoice is created the customers address nicely fills out with just putting in the business name. I would like an aged debt section on the Customer details File. How would I search through the invoices to get the total of Invoices for Current Debt 30 days - 60 days 60 days - 90 days etc In the Relationship at the moment between the two the Business name is mapped to the invoice business name which then allows an invoice addresss to be fil…

Hey guys, I have no idea where to start with this one. Basically I have a system which needs to be able to extract management information. I have a layout which I have setup with a Department value list, and the idea is that when I perform a find the total amount spent by that department so far is to appear in a field below. I tried a summary field but it wouldn't work at all. The way the system works atm is a member of staff chooses which dept they belong to from a value list, they then go to a layout, enter their staff id and the course id and it is added to their record. Each course costs so much. I got the summary field to work out how much each person spend…

I have a script that finds "late pays" in a club database. In the “perform find” script step, the find criteria are; find “2007” in the “history” table/ “year” field AND omit “2008” in the same field. That works fine. I wind up with members that were active in 2007 but not in 2008. What I’d like to do is replace those specifically entered years with a “get” function. (Year(Get ( CurrentDate )))-1 and (Year(Get ( CurrentDate ))) How do I enter a calculation or get function in the find criteria dialog box to automatically find the prior year and omit the current year? Dudley

I've fiddled around with scripting and searched the web, but still can't make it work. I want to change the color (from black to red) and formatting (from plain to bold) of text in the Name field of a found set if the name is "Mark". How do I do that? Thanks in advance.

John(1), Sue(2) and Kate(3) need to be notified that a Purchase Request needs authorization. John must sign it first, then Sue and lastly Kate. If John(1) already singned, then Sue(2) needs to be notified and so on. I have a calculation that marks who needs to be notified next, I call it "Action Calc". I will be running this script every 30 minutes. I need a script that will notify the person next in line, but I can't quite get it to work. So far I have this: If ["Action Calc=1"] Send Mail ["Hi , please approve PR."] End If If ["Action Calc=2"] Send Mail ["Hi , please approve PR."] End If If ["Action Calc=3"] Send Mail ["Hi , pl…

I'm trying to set up a barcode using barcode 3/9 fonts. I would like my calculation to read from my purchase order number. for example: my purchase order number is 01-556792 and i would like my barcode to read 01556792 without dash. Also in order to create a field using my purchase order number field i need to an asterick "*" before and after the number to make the scanner work! the error i get is "A number, text constant, field name, or "(" is expected here."

Could someone tell me if it is better to use a series of If...End If or a series of Else If. Expl: what’s better: Script1 or Script2 Script1 IF [Amount = 100] Do 1 End IF IF [Amount = 200] Do 2 End IF IF [Amount = 300] Do 3 End IF Script2 IF [Amount = 100] Do 1 ELSE IF [Amount = 200] Do 2 ELSE IF [Amount = 300] Do 3 End IF Thanks

I have two tables which are related. The Child table had the ID number of the parent table to link it. I would like to create a button the parent tables layout that would check to see if there was a related record and if there was to open it and if there was not to create one and then open it. At this point there will be only one record related. I have created this a a separate table because it is also related to another parent table. Can anyone help me with the script I might use on a button to do this?

I would like to add 3 different accounts with different priviledge. I their a way to get a report of which account did what? for example: let say their are 3 account: A, B & C. A modified a record and B change art cost and C invoice the job. I would like to show a record indicate what each account did? Because alot of issue we are having is people delete files or modifying files and no-one seems to know what going on?

I'd like to open a folder that is located on a windows2000 pc, and i would like to be able to open it on both pc and apple clients...is this possible ? The pc-client-part is no problem... Sorry for my bad english, i'm from belgium.

I would like to know if their was a way to save a record in PDf ...BUT... I like the PDF name to be a field name i currently have. For example: my field for invoice # is A2500 and I would like write a script to save my record as a PDF with the file name A2500.pdf Any help! Maiton Vang

Hi everyone, If it weren't for one condition this would be a pretty easy script for me. But alas, because of the condition I have no idea how to do this or even if it is possible. I have a text field where ID numbers will have a suffix of sm, md, lg or no suffix at all. ex 123456789sm. 123456789md, 123456789lg, 123456789. What I want to do is create a new field that will capture the suffix information. I need to write a script to pull the last two charecters of the ID number and place them in the new field but only if the last two charecters are letters and not numbers. This is a classic example of where I should have created the DB with two fie…

I am processing a string of data that consists of x columns of info. I want to set a field to the value of each column via a Loop, however, I don't know how to ref a field who's name is dynamically determined at runtime. Example. String=/this/is/my/string/of/text set field "count" to number of "/" in string x=1 Loop set field column to middle(string,start,numberofchars) ExitLoop is x is = count EndLoop I have a formula for extracting each column of text so i just need to assign the dynamic field. TIA.

Hey guys! I am reallllllly stuck and have been attempting this for hours. Basically what I've done works fine, I just can't get one step to work, which has ruined the entire thing. I have a set of records that has the "Staff ID" entered into them, I want to extract these IDs into another set of records. Here's the script as it currently stands: 1. Show All Records 2. Go to Layout ["Staff List"] 3. Go to Records/Request/Page [First] 4. Loop 5. Go to Layout ["Add to Record"] 6. New Record/Request 7. Set Field [TrainingRecord::Staff ID;Staff::STaff ID] 8. Set Field [TrainingRecord::Course ID; TrainingRecord::INSET Course ID] 9. Set Field [Trai…

I'm creating a new database for our project managers, and they'd like for any user to be able to modify most fields in the table, but if the "target date" of a project is changed, the project managers should be emailed with information about the record. It doesn't look like this can be done through field validation, which is what I'd hoped. Does anyone have suggestions for a good way to do this? At this point, I'm wondering if my only choice is to create a "commit record" button that runs a script to check the field validation, but I fear users may not reliably use such a button, since they have never had to do so before. ~Courtney

I can't get the Go To Object script step to work. Whenever I try, I get an error code 3 (Command is unavailable (for example, wrong operating system, wrong mode, etc.)). Has anyone encountered this? User: Admin Pass: Pass is null GTO_Clone.fp7.zip

Hi all! Sorry if this has been asked before, but I'm looking for a way to switch between layouts with a keyboard shortcut. The database consists of several tables - Clients, Objects etc. Every table has 2 main layouts: as a post, and as a list. I already have switching between the various tables set up with scripts and assigned shortcuts (cmd+1, cmd+2 etc - there are 6 in total), but now my client wants to be able to switch between single post layout and list layout in all the different tables with a keyboard shortcut. The best solution would of course involve only one keyboard shortcut, so depending on which table is active, you would switch between those …

Hi All, I am trying to write a script and I want to certain script to be run if I have the email address. so far I have done this to which it did not work. If [Main Screen::Party Contact Email=True] Perform Script ["Email: Paperwork Received"] End If I know I am doing something wrong, would any know... Thank you in advance.

I am a "Newbie" so please keep it simple. I would like to make a button that would copy the plant name (Botanical Name)field; go to Google Images and do a search for images with that field name. Can you help me? Thanks in advance Con

I'm developing a DB for a customer and use button-click with Ctrl-key to delete a record, rather then have an 'are you sure message". It works fine on my 8.5V2A but not on the customer's V8.5v1. I suspect it is due to lack of the upgrade. Does anyone know if that is the case? The script is a very simple if modifierkeys <> 4, don't delete else etc. I've changed this to if modifierkeys = 4, delete else etc. but hven't had the result yet.

i'm new to this and this is probably something that everyone here already does all the time.... i want users to see only the records that they have entered into the db. i'm not sure how to do this, but i've been trying to do it by creating a user field that calculates (get(accountname)) for each record. then, i've tried to create a script that upon login performs a Find on all records with that username. I have not had any luck figuring out how to do that though, and I'm guessing there must be a better, simpler, more standard way to do this.

For debugging purposes I need to create some sort of logging capability that I can deploy at a client site to catch an intermittent problem that I can't track down. I've created a variable that concatenates the suspect variables, date, time, record number, and script step. I've successfully used the Export Field Contents to export this concatenated string to a text file. The problem is, I need to export this string hundreds of times during a session to catch the anomalous values and see what's going on and the way I have it done now, each export overwrites the external text file exported by the previous execution of the command. Is there an elegant way to make t…

Hello I opened up a computer repair shop and created a filemaker database I really like using filemaker 8.5 My problem is simple to me but hard for me to figure out. When a customer comes in that has been there before I would like to do a search by either their last name or phone number and if either is found then create a new record using there pre existing information ( address ) thats it I have be creating a new record with their last name then doing a find and copying the information between records. I know this isn't hard but I cannot figure it out Please help me Ronald

Hi has anyone got any good examples of generic startup scripts. I'm a bit of a novice and I have been asked to write a startup script for our new version of software. All I can think off is setting window size and entering browse mode etc....Can anyone help???

help!! I am teaching myself FM until my boss springs for a proper class. In the meantime, I want to create buttons that create labels for people whose have specific data in certain fields. how do I do this??? not to seem daft but if someone can give me step by step instructions that would be REALLY helpful. isabelle

It's strange but I can't get my head around this. In a table (A) I have a numberfield with the age of a person (age). In another table (: I have records with two numberfields: minAge (minimum Age) maxAge (maximum Age) I need to find in table ( all the records where the 'age' from table A falls between minAge - 5 years and maxAge + 5 years. I start my script from table A where I set a variable $age to 'age'. Go to table B Enter find mode set field minAge > $age -5 ... and now I'm stuck... set field maxAge < $age+5 Perform find doesn't give the right result. What do I miss here ? TIA

So I want a script that will send out batches of email to everyone in a large database. mostly I want it to go in groups of 99 to get past a home business's server limitations. any hints? I tried things and loops and counts but I'm in over my head.

I am populating a database of research from the web which if often easier to copy and paste into FM pro than re-type in each field but I cannot get the fonts to switch to a standard in my FM file. I would assume there is a simple setting to change all the helvetica 12pt, black upon entry.. Is there such a feature or must I make a script to change the font, size and color in every field? Thanks, Dominic

Hello everybody, is there any Get property, or some plugin or something like that, which recognize state of system keys? For example, when i click on a specific field i want to do something when Ctrl is pressed and something other when isn't pressed. Is there a way how to solve this problem? Some function like GetKeyState("Ctrl")? Thanks a lot for every response. Matěj

I am creating a button that performs a script to open a layout. I am using a perform find in the script to filter the records shown, but I want one of the criterial to calculate against the current system date but I can not fine what to use so that it references the current date. eg I want to have EndDate > CurrentDate Where end date is the relevant field.

I'm not sure if this is a FIND question or SCRIPT question so I thought I would start here. I would like to automatically generate a report of activities Using a timestamp field, I would like to establish what day of the week it is (Monday, Tuesday , Wednesday, etc) then find all activities that are supposed to happen on that type of day. For example: Payroll needs to be faxed on Wednesdays. If today is Wednesday, I would like to be reminded to fax the payroll. I would like a list of all Wednesday activities. If today = "Thursday" I would like the list to show Thursday's activities. Is there a way to script this? Thanks for any help. …

Hello all, Two fellow developers and I are working on a FM9 solution that's to be boxed and sold. We are hosting the file on FMP 9 Server Advanced (Mac) and working on it using FMP 9 Advanced (2 of us on Mac OS 10.5.1 and 1 on Windows Vista). Our solution makes use of a Back and Forth navigation system based on a slightly modified version of SeedCode Back Magic. The system uses various global variables to store the back and forward navigation trails and such. We just recently started experiencing very bizarre behavior with the the Back and Forth script, more precisely with the setting of global variables. I'll note that the script was working fine then star…

Hello again, everybody. Former frequent poster who stopped posting when everybody else moved up to FMP7, while my company was continuing with FMP6. Hopefully that gets me some mojo for a good answer now .... Well, we're finally moving up to FMP8, and I'm trying to design an automated conversion routine. Part of it invokes the script step Convert file to convert our .fp5 files into .fp7 files. This must be completely automatic, as we all know what happens when users get involved. It is not possible to do each conversion manually, as we have almost 1,000 licenses deployed with 85 files each. The problem with this step is that it opens the converted .fp7 o…

I have two Tables in the same database. When someone prints I want to increment the number held in the users record in table 2. It seems simple but I cannot seem to achieve this... Example someone prints from Table 1 I have tried to set a variable $$print to the value of the field in table 2 then I have tried various means to advance that number I have tried set Next Serial Value... Somehow that does not work... Even a calculated result does not work I must be missing something....

Hi Getting a solution together for completion very soon. I'm in India at present and the internet's very bad - so I can't do too many searches. I've got a lot of movies in my database that are essentially Quicktime files stored in containers. When I want to play a movie, I go to the movie-viewer layout, where I then have to click on the movie field and then hit the play button. I don't really mind - but the solution is to go on public exhibition in a museum where the public will get to play movies - and many of them almost get there.... and then it takes them so long to find out how to play the thing that they get bored and leave! Simple question then. Is there anyway…

I am trying to to use Get(PivilegeSetName) in an If else statement so the calculation is Get(PivilegeSetName) = "Design Floor" So If [Get ( PivilegeSetName ) ≠ "Design Floor" where the user is in this privilege group... however the If staement does not work and they go on to the rest of the script...

When I create a new user with a button in one Filemaker file I want to create a new record in an associated file so that the record can hold details of that user, ie counts for printing e.mail & the ability to brows users etc.... However I cannot see how to create that record in the associated file when the Create New user button is in another file, scripting does not seem to be able to do this but surely it is possible, it seems only logical that you Can do this ?

sorted

I am looking for a script that: SENDS CURRENT RECORD AS .PDF it grabs the email from a FIELD (email) field Currently I pull down menu FILE/SAVE SEND RECORDS AS/ .PDF Save as Untitled.pdf check "Create email with file as attachment SAVE= "Current record being browsed" then my email application opens ready for the email address then hit SEND Basically I am trying to AUTOMATE the process. Here is my script that does not work Save Records as PDF [Restore; "invoice.pdf"; Current record] Send Mail [To: Co…

The script debugger in earlier versions would pause when it hit a pause script step. It wouldn't release and continue until the operator interacted with the application in a way that would release it. (Hitting enter or hitting a button with a resume script command attached and so forth.) In the new version if I continue to hit advance in script debugger when it has encountered a pause it just continues on. It doesn't require an interaction with the application like the operator would have to do. Since I tend to be slap happy on the advance button in the bugger this is a hassle; making the tool less useful for me. Am I missing something? Has anyone else foun…

Hi folks.. I think this is a simple one, but can't work it out. Using FMP 9. I have a summary page, which logs whether a certain document (such as an invoice) has been sent to a customer. I save the documents as JPEGs and store them in picture Container Fields. I can assume that the document has been sent if I have dropped it into the container field. How can I make my "Sent? Yes/No" checkbox set on the summary page automatically display "Yes" in the event that the relevant container field has something in it? Thanks for your help!

Hi I need a functionality where i need to generate a alphanumeric code based on the type of customer selected. For e.g. if the Customer is of Type A then i need to just generate a numeric value. e.g. 5000 is the current and the new one will be 5001. For e.g. if the Customer is of Type B then i need to just generate an alphanumeric value. e.g. XXX C5000 is the current and the new one will be XXX C5001. I have created a table with following fields. (Please see the attached .txt file) Type of Customer text e.g. A Prefix text XXX C NeedsPrefix Boolean True NumericValue int …

Does anyone know if you can use a script to capture the current window by using the windows "shift + printscreen" function? I would like to place it in a container field.

Is there a way to list where scripts are used in a database, or at least if they are used at all? I've got a database that has been going through a lot of revisions, and I would like to clean it up a bit. I know some scripts are old and no longer in use, and others are used across multiple layouts, but I'm not certain where. There are quite a few layouts, and I don't really want to go through it by hand and make a mistake by accidentally deleting a script that is being used. Any suggestions?

I process text imported from other sources. One file I use has imbedded Form Feed characters (f). Is there a way to locate this character in FMP 9? The file I am importing an parsing has about 3000 fixed length records, about 70 of these records will have the Form Feed character. Presently I open the raw text file with BBedit, remove the /f characters then import and process the file in FileMaker. I would like to eliminate the BBedit step. Regards, Dennis

I want to use the Save a copy as script to create a backup. The problem I keep running into is, how do you set the script up so it doesn't save of the previous copy. I guess I'm looking more for a way to save a weeks worth of backups. Any ideas?

I’m trying to use Zippscript to manage changes made to data within a field. I have a Parent Table with several child tables. I don’t want the user to be able to change the text (ie the Name) in the Parent table if there are active child records, but to allow the change if there are no child records. I use Zippscript to capture that a change has been made to my text field, and invoke a script to check for the presence or otherwise of related child records. I have found that zippscript loses sight of the current record if the user exits the field using a mouse click to a different record. But, by having ZippScript capture the RecordID, I can go back to the c…

Hello there, I'm faily new to Filemaker scripting and could use a bit of instruction. I'm working with a database of several thousand records which I need to code in 2 ways based on the zip codes contained in the field ZIP. If the ZIP field contains any of the zip codes in a particular city the CITY field should be filled with the correct city name. The next step is similar, if CITY contains any city from a particular region, the REGION field should be filled with the appropriate number. I figure if I can figure out how to do step 1, then step 2 could be accomplished in the same way--zip codes traded for city names, etc. and respective field names…

I would like to find out what file extension a particular file has when it is inserted into a container so if it is a pdf I would like to leave it alone, but if it is a picture I would like to run a script on it.... how can I tell what the file type is ?

I have created a button on my layout and when the user hits it, it will bring them to Preview Mode. Now i want to put a script on that button so once hit, it will bring them to Preview Mode and Pause so the user can see the records etc. in Preview Mode. If the user wants to exit from Preview Mode, i would like them to be able to hit the ESC Key in Windows to return to the Browse Layout etc. as i don't want the user to see the Status Area etc. My current script is the following: Enter Preview Mode [] Print Setup [Restore; No dialog] Pause/Resume Script [indefiniely] I have tried to put in Allow User Abort [On] like below but this has not worked…

I'm trying to write one script that will direct the user to the correct layout based on which tab is clicked, its object name and combining to form the layout name by calculation. ex: clicking the Medical tab runs the script with Goto Layout( objectname&"_Form"). I tried get(activelayoutobjectname) without success. Button is named: Medical, Layout is named: Medical_Form. I'm just trying to be efficient and write one script that will work with all tabs(buttons) to navigate to the proper layout.

I have a file with external data source as: file:Company_Data fmnet:/xx.xxx.xx.xxx/Company_Data Originally I had them reversed but when I needed to design in the file and wanted to reference my local dummy copy of the program, I couldn't switch them once I had opened the file (I had to close the served version so it would find the local copy). So now I have the local version first and if I want to activate the file, I remove the Company_data file locally and when it opens, it then finds the served version. But, while I'm testing, I'm afraid it might not always grab the local version. I would like a way to display which source is being used before I begi…

I am working on taking an address and identifying duplicates in the database I have created. I want to identify duplicates and then condense the differing information in multiple other value fields into one common record. Anyone have any scripts that do something similar to this?

If a script saves various layouts to a combined pdf in the temp folder, how do you pick that pdf up to open it.....?? The only way I can see is to set the last Layout to open the file... However if you have 10 layouts all of which may or may not be printing to the current pdf how do you pick that pdf up AFTER the last layout has printed : The only way I can see is a load of scripting to ascertain which layout will be the last and use "if" statements throughout the process.... maybe there is another easier way : For instance if you want to send an e.mail you can pick up the resulting pdf and e.mail it.... I cannot see a way to pick up a resulting pdf and open it …

Hi all, I'm using a script to generate HTML and build a table of values to be displayed in an email using SMTPit Pro. The problem I'm having is that in order to specify a in my script, the double-quote character is interpreted as a literal and I can't get it to pass the script/formula checker. I thought I'd try to build it in using a custom function. But when I put a " in the custom function, it looks for a close ". I can't put """ because the third quote looks for a closed ". Can I use ASCII characters? Is there an ASCII character that represents a " like %20 represents a space? Thank you. Mac Hammer

I'm using FM7, and if I need to upgrade to accomplish what I'd like to, please let me know. I currently have a portal in a layout which displays information keying off an order number. The portal information looks something like: Supplier Cost Proceeds KS $5 $10 RL $2 $15 JH $1 $5 KS $1 $8 I want to store the totals for each supplier inside the main layout that the portal is in. The suppliers can change from order to order, and going through the order with a Find function …

I have an application where the print set up goes to a separate file (Folder Label) imports a record from the Custoer's File and prints a label using Brother P-Touch QL 500 Label maker priner on a 27mm x 90mm label. Now, all my layouts are locked to the above printers specs even though the layout shows normal on print preview using a prit setup for a regular printer. I can not change the layout to print normal anymore. Tech Support was unable to help. Any ideas?:)

I've designed a sales and marketing application and would like to add a dialing facility, but don't know where to start. I have an iMac G5 and would like to be able to use a headset when making calls. I'm in the UK and use BT as a service provider. Any ideas?

I have written a script that I execute with FM_butler when validation runs on the previous field. This script takes an alphanumeric abbreviation and looks up a counter that goes with that abbreviation to create a unique indentifier. The script works but for me to see the value I have to click on the screen in browse mode or got to create a new record and then go to previous to see the value in the field. Example of tables: Main, Product A, Product B, Product C. Main table has a drop down box where you select product a,b,c and the tables for each product contain a number field. Result field in main table looks like A1 or B1 or C1 - as I said script works - but I wanted f…

OK, this is a weird one, though I'm new to v.9, so maybe it's a known issue. I've got a script which prints 8 pages, each on a separate layout. The first print command throws up a print dialog box, but the remaining 7 print commands are with no dialog. Some pages have some simple bitmap graphics on them, but most don't. The problem is, when I go to the printer, the pages are in what seems like random order (e.g. 1, 2, 5, 6, 7, 4, 3, 8). The file is served by Server 9 with FM 9.03 clients, and I've encountered this problem printing from Windows, Mac, using different network printers, etc. If I open Debugger and step through the print script, sometimes the pages …

Im trying to make it so that my database runs a script at a certain time by itself. Is there a way to do that. I want to update my records, and i have a script that will do that, but i need to make it so that it does it automatically every night at a certain time. Thanks in advance.

Can anyone tell me why this script will not quit? Close Window [Current Window] Exit Application only a script Exit Application works. Is not Close current window and Exit the proper way to Quit FM files?

Hello, I have a basic list view with a search box at the top. It functions very well but in terms of user friendliness I would love to make it so the return/enter key will perform the search script after writing in the search box. Is this possible? How do I activate scripts with keys. Topher

Greetings I am working on a Debtors report. I need to create a report which finds all invoices which are 30-, 60-, 90- and 120 plus days old and show these in a final report. I am able to work out the date function (i.e. 30/60/90 etc) but how do I go about getting the data? Would I write a script which performs multiple finds and posts the data into a layout after each find based on the number of days past? Would I use a sub-summary report and if so, how would one summarise on different supposed date ranges? I guess I just need assistance in the thought process and the design of this script. Any help will be greatly appreciated! Mucho g…

Hello, I'm new to this forum, and somewhat new to Filemaker. Perhaps I should have listed beginner, I'm not sure. Here is my problem. Our system here at work has a Sales Order page. With it there is another page called the Traveler. On this traveler I'm trying to create a button that will copy our Part Number from a field, go to our Inventory database and find that number. I am having a horrible time with this. I have gotten it to the point where it goes into the Inventory page and sits in the FIND mode and just does nothing. I can't get it to paste text from the other database. I hope I explained this somewhat well... Thanks in advance... -Matt

I think I need some basic ScriptMaker help here. I want to add some error checking to my solutions and in some cases I want to check the contents of 2 fields and display a message depending on their contents. I seem to remember an "And" function somewhere but I don't see it in FileMaker. Can someone point me in the right direction?

Hi, I have built a patient database for my practice. I want to be able to select a folder where I store photos for the relevant patient (i.e. d:filesmedicalphotospoly_paparas) and store it within the relevant record. I know this can be done using troifile, but is it possible to do something similar using scriptmaker? Any help will be greately appreciated.

Hello, all-- Novice question here: After a find is performed, my script navigates discretely to a layout (viewed as table) with only the RecordID field present. I want to take the Record ID values from the found set (as a return-delimited list), go back to the original layout, and put the list into a global key in order to populate related records in a portal on that layout. Rather than using the Scriptmaker steps Copy All Records and Paste, I'm thinking there must be a more elegant way to accomplish this without having to copy the contents of the found set to the clipboard, or loop through hundreds (or possibly thousands) of records. Tried putting List(RecordID…

I have an antiques inventory and I added an send email to the customer and in the message I want this to add some fields of my inventory like ( shipper, tracking number, shipping date) but when I want to add the field to the message it only allow me to add one. Can somebody help me ?

Hi everyone, I'm ashamed to say I've been working on this all morning and can't get it to work. What I want to do on my Customer Entry layout is click a button that will bring up a "Pick List" view of my customers that is 250 x 639 Px. I see this as just a standard "list view" with the Customer name only. This would sit off to the left of the Customer Entry screen and you'd click on a customer so that customer would then show on the Customer Entry screen. Ideally I think it would be a good idea for the Pick List window to be open all the time but could be closed at the click of a button. I think the Pick List should also automatically close once a layout, oth…

Hi, i'm wondering if there is a better way to duplicate a record based on a quantity field. i have it working in the following way: if quantity = 2 duplicate record end if if quantity = 3 duplicate record duplicate record end if and so on.. But my wet dream would be to have something like Set variable $DupNum To field quantity loop $DupNum times duplicate record end loop i could do it in applescript, but it will be run on PC too. Any Scriptmaker way to do so?

I am not sure how to go about getting the result I want in my script. The answer is probably not in the script itself, so if I am in the wrong category, I apologize. I have employee's that have numerous records pertaining to Sick Leave. When I run the report using this script, it will give me all the records, for all the employees. This works fine. There is a field called "type". Examples of this are: sick leave reviewed sick leave letter issued sick leave warning So what I would like to do, is to be able to run a report, that will only give me the most recent record for each employee of any type. So if an employee has 5 records with reviewed, 2 under…

I'm having a problem with managing windows in my database. I have 2 tables (Songs & CD’s) in my database, and want to have one window of each table open at a time with separate window names. I want to have buttons on each table layout that opens the other table layout in a new window OR selects that window if the window is already open. How do I write this script?

Hello All: I know the basics of writing scripts only, and started having problems adapting a script I saw in one of the forums. Basically, what I want to do is copy from a template file a set of commonly used part numbers and part names to new records in a table. At the same time I would like to populate a field of each newly created record with a value to enable the relationship to the main table record. I'm specifically having problems with: - how to start and stop a loop, how to increment it--I am discovering that loops in FileMaker scripts does not quite resemble similar constructs in computer languages I have been exposed to over the years. …

Is it possible to script "import document" using a given path saved in a field, instead of having a dialog? I have to import multiple files where the file path is known and the files change frequently. Thanks matt

I want to do something like that Go To Layout [Any Layout Name Here] Show All Records Constrain Found Set Constrain Found Set Again Check for additionnal condition then Constrain Found Set one more time Sort etc. My main concern is that engine seems to start processing summaries and other stuffes behind the hood before I actually filter records out. Is there a way to prevent any processing before I actualy ask it to do so? Kinda Set Engine [Off] Go To Layout [...] Show All Records [...] Filter Out Sort Change my mind and Filter Out Again Sort Again Change my mind one more time and Filter Out [...] Set Engine [On] Switc…

Hi I would like to open a folder on my mac from each companies records. (Via a button) The folder name would be the company id field and its name. If the folder does not exist I would like it created in the default location. I can get this to work on Access but have no idea how to do this on FileMaker. Can anyone help?

I am over thinking this and it has me so frustrated... I have a database that needs to be kept in "order" with each record needing to be sorted. The user may not always enter the data in order and so I am tracking each record with a serial number. When the user need to "insert" a line above or below they use one of two scripts. The scripts works fine but they are long and I know there is an easier way and it's just not hitting my brain. Any suggestions on how to better manage this would be great. I would love to streamline the process and eliminate mistakes.