Script Workspace and Script Triggers

I would like to show the currently-logged on user account name on the screen to my users so they know whose session they might sit down in front of. Any idea what script to call on for this?

Hi, I was re-directed over to this section. I need help writing a script to import some XML Data. I have an XSLT file that takes the weather data from the NOAA website and I am currently able to import the data when I manually do the import through the File menu. However, I want to be able to simply click a button that performs a script which accomplishes the same thing, but I don't know how to do this, as I don't see which option to use to create the script. Thanks for your help!

is there anyway to pick a random record from a database using a script?

Hallo All, I have created script, and now i will perform and edit that script, but if i'm open script maker and then click that script and then click edit button the message "This Script cannot be found or has been deleted" appear. why ? the name of that script still on the Script Maker windows. Can you help me ? Thank you

to the gurus: Can I write a script that would transfer the contents of one field and dump it into another, not replacing the contents of the 2nd field, but just adding it to the top? thanks in advance for the help.

I am attempting to make two scripts, but I'm not quite sure how to go about making either. The first script I'm attempting to write goes from filemaker to Framemaker. The database I'm using refers to specific Filemaker documents and I want to be able to click on a button and have the correct Filemaker file pop up. The second script I'm attempting to write goes from filemaker to Adobe Acrobat. This time, there are only two files with a thousand pages each. The script needs to open one or the other files and then go to a specific page in that file. I am more or less lost on how to accomplish this, if anyone could provide advice on how to go about doing thi…

simple question here... if i want to set an "if a field contains this word, then set another field with this word," how do i make the script understand "contains"?

Hi, I have a database with 2 datefields, used for registration of contractors at our firm (startdate-stopdate-name-company (and so on...)) I want everyday to make 2 lists of contractors using the search-option: 1) Those who will ONLY come today. This is easy filling in // and // in both datefields when searching. 2) Those who will be here today BUT also yesterday and/or tomorrow. In "search" I use in startdate "<=//" and stopdate ">=//" This will work BUT will include also contractors ONLY for today. I want to exclude these in the second list HOWTO setup things so that contractors ONLY today will NOT show-up in this secon…

hi I'm in a bind. I have written a script that allows a file to remain open for a given time and then it closes the file. Only problem is the script uses a loop with a time designated pause. I stupidly set the script to be run when the file is opened before I fully tested it. Now my file opens for the given time but I cannot access Scriptmaker to modify the script or most of all the other menus which means that the usefulness of the file is now limited. Does anyone know of a way of forcibly breaking the loop so that I can rectify the script ? Many thanks

Hi, I have a problem where by my customer require their staff to key in "WHY U SEARCH FOR THIS RECORDS". So I created 2 tables. 1 is the main page which contains the info and the table 2 is the query page. So after I press the submit button it will copy what I keyed in the query page and perform find at the main page. I only can get 1 field but when I copy all the field which I need, it's not working. The file in the query page can be randomly filled base on name only or combination of name and products. Then upon clicking submit it will copy this 2 field which I have fill in something and perform find in the main page base on that. Attached is what I…

Is there a way to use scripting in filemaker that will do the job of converting return-delimited text to tab-delimited text proir to importing it into a filemaker database. FileMaker Pro 7 Bible (page 523) suggests using MS Word to do the job. However it would be much more useful to skip that step. I need to do it for each new piece of data or groups of data that I receive on a daily basis.

Any time I've made a script in the past it was via a wizard at the end of setting up a new layout. For some reason when I create a new layout now, FM isn't offering certain windows via the wizard, create a script being one. Any suggestions as to why this isn't offering to create a script? Thanks

I recently had to scrub a 10,000 record customer database of duplicates. Thinking it would be hard to do, I went to all the various Filemaker discussion forums and looked for a ready-made solution. But every one I encountered was baroque and difficult to transfer to my db. So, I took all of 2 minutes to write a simple duplicate remover. When I was done, it scrubbed all 10,000 records in under 5 seconds. I just thought anyone else looking for any easy way rather than a hard way might appreciate this. Who knows, there may be other simple dup removers listed around here, but I didn't find any: --Create a self-join relationship with the relevant match field (in my …

I have a huge excel spreadsheet that I am trying to import into filemaker pro - it is a couple thousand rows high and about thirty rows across. It is basically a tracking of orders. The problem is that when someone puts in a new order, they put in all contact info and order info on the same line. Basically, company name, customer number, order number, contact name, contact address, etc... is all on one line, which FMP converts into a new record for every order. My thinking - to condense things - was that I would make a relational database with company name, number, contact info and a separate database with information on each separate order that can be recalled by common …

Hi all.. Please forgive me if this has already been addressed, searched to board for an hour now and can't find anything.. Basically, I would like a script to run when the user changes a field item, currently in the form of a pop-up menu. Is there any way to do this? Thanks!

Hi folks. I did a dumb thing. I made a script that is now closing the application as soon as I attempt to log in. Anyone know what key or key combo prevents opening scripts from running in FMP 7? I can't even remember how to do it with FM6. Thanks in advance. John

I am just starting out with fmp and I was wondering how to make scripts automatically load and be active without clicking on buttons.

I have a find command in the middle of a script and don't want the "No records match this set of find requests." dialog to popup. Can I suppress this dialog and just continue on with my script checking that there are any records in the found set? Thanks.

I have a basic script that does a find, great that works, now once they choose another option with a dialogue box i want a set field or replace fields to take place on all found records. In other words; I want a "g" to be entered into a field when the user prints out a report within a certain found set so that the next script wont "find" those entries next time by omitting records with a "g". What would I use to enter a "g" in all found records? I used set field and it only changed the first record not all of them. Thanks

I want to creat a script that will process, and print to a PDF file. BUT I want it to copy one of the fields out of the database and use that for the filename in the creation of the PDF. Don't know if it can be done or not, any ideas? (I am using FMV6, but have V7 Both on PC and OS X) Thanks

Is there a way to script FileMaker so that if a user closes the active window, it can remain open. I only want users to close the FileMaker files by using the proper methods I have programmed in. I have tried using the document preferences / close script to run a script trying to halt that action, but no luck. Any ideas would be most welcome. Thanks in advance.

I need to have a script create records in a remote database. I'm sure its absolutely simple and I think i've even done it before, but I can't for the life of me remember how to do it. Thanks!

Hi all! I have 5 fields. 4 fields gets one random number each that represents false answers to a question, Field=1 Field=2 Field=3 Field=4. The 5th field automatically fetches a number that represents the right answer to the question. For simplicity we assume that the right answer shows up i field5. In the application the right answer is randomly placed i Field 1-5. So what I'm basically doing is posing a question and 5 possible answers show up on screen. 1 is correct and 4 is false. 1. Now, my problem is that from time to time there can be 2 (or more) identical incorrect answers showing up. Example: Field1= 45 Field2 = 13 Field3= 567 Field4 = 13 Field5= 435 (correc…

I have a layout where I have created tabs for navigation. The tabs are labeled using a related record. So basically I have a series of portals with Related Records from Table A. The first tab is "Initial Row 1" "Number of Rows 1" Second tab is "Initial Row 2" Number of Rows "1" and so on. (There are eight total) The tabs are buttons with a script GTRR for Table A using Layout "Current" to view the various records. Works like a charm. I would like to make the tab text bold when the record is being viewed. I thought I could use a Loop and go to Portal Row to complete a script fo this but that won't work... can anyone give me another direction? Tha…

Is there some way to use Scriptmaker to automate the entry of FORMATTED text into a text field? Are there special key combinations to create formatted text, because the regular processes do not seem to work. Thanks. [color:"red"] [color:"black"]

hi all, I'm trying to create a record navigator similar to the one in the status area since I want to keep the status area invisible to the user. I have a calculation field name called numRecords that keeps the record number of the corresponding record. This field name has been assigned to one of the fields in the layout and it is used to display the current record number. the problem is, I would also like to allow the user to key in the record number they would like to view and when they press enter they would be taken to the correct record number. However, since the numRecords is a calculation field, the field can't be modified. Basically, I just like to ha…

I would like to copy (not duplicate) multiply records from a table to the same table and some of the new fields would have same values as the original ones. The table fields are: 1. ID - auto-enter serial 2. Name - text 3. CategoryID - number 4. L - number 5. N - number For example I have records with 10 different categories and I would like to create a new category (with ID=11) and copy all the records from category 3 to category 11. The fields 2.Name and 5.N should have the same values as the values from category 3, but the other fields (without 1.ID and 3.CategoryID) should be entered manualy. The field 3.CategoryID should be set by script. Is there an…

And I hope I can explain this. I have a Table "Print Specs" with a field called "Final Spec Options". It is a value list check box set. Example Die Cut, Laminate, Perf etc. I have a Table "Estimates" with a portal to "Estimate Details" with field "Detail Description" and 'Detail Cost" I want to create a button that will pre set the "Detail Description" fields based on the contents of the "Final Specs Options" field. example If "Final Specs Options" field contains Die Cut - then set field "Detail Description" to Die Cost. I can't seem to get the If stated correctly... thanks. c.

the other day I wrote 1500 lines of code to facilitate some rather simple-seeming search functionality... you can imagine just how buggy it is. The idea is it should give the user the basic ability to find records across mutliple tables, matching any field: there are two text boxes for search criteria, on for "Any of" and one for "All of". The first thing I do is "decrypt" the search strings to seperate bare words or quoted phrases into different, reference records. This script, which looks so plain it's hard to see what I've done wrong, is failing. It correctly creates the record for the first bare word or phrase... but then for some reason it fails t…

Hi gang, I am confused. I wrote a script that has a print setup to print a pdf (adobe) in portrait mode. But every time I run the script it goes back to my default print set up. It is running on server, is this the problem. Every pc using the script has adobe running on it. Is this a server issue or am I missing something?

I am trying to create a metrhod of automatin record creation. I am writing a database to run ticketing within a company and i need to be able to add a batch of records to a table at one time. The TicketID field is a serial and i can set the next serial number and carry out a loop which creates the tickest however i want to be able to automatically populate the WardenID and Site ID fields of the new records. I have created a table which has fields WardenID - The warden to be issuing the tickets. SiteID - The site the tickets have been issued to TicketStartNo - The start number of the ticket batch Quantity - Quantity of tickets to be created A s…

I would like to make my telephone fields simple for users. Can I define a calculation to mask the telephone number so users simply enter the nine digits and it shows them as (###) ###-####. There must be some code somewhere I can recycle to make this happen. Thanks!

How can I get FMP7 to send an email through Outlook 2003 (via exchange server 2003)? My script creates the message, addresses it properly but I cannot SEND the message from outlook. Seems like an Outlook security issue (thinks it is a virus or worm creating the message). I have posted on MS support groups too, but figured one of you must have beat this by now. The send button can be pushed but it won't do anything. If I create the same message from withing outlook, it works fine. It does not like the fact that FM is creating the email for me. Any ideas?

HELP!!! I would like for the window to scroll down automatically when I am filling in fields. My fields are vertical from the top of the page down, and it is a bother to scroll and stop entering data, if only there was a way for FM to follow me down the page. Please someone help me write a script that will do this.

How do you write a script for a custom dialog box with 3 buttons: "Ok" to save current record and exit to goto Main menu layout, "No" - do not save current record and goto Main menu layout, "Cancel" -remain at current screen to continue edit. Thanks.

Ok since everyone can answer most of my quesitons I hope this one is simple also. I am trying to do a find where two fields are user entered but the second field has to be a less than or equal to ( >= or ?) i know how to specify finds but I can't put that into the find so if the user enters 4 it will automatically find ?4. I could enter ? into the field first and then have the user enter in the number, but I work with some of the most computer illiterate people around, and want to keep it simple stupid. Can I do this any other way then entering in ? and formatting it so the user can't see it???

Is it possible to run a script at a certain time everyday? I need a script that will update/shuffle data around daily.

I have a script on a button that will go to the next record, run a test, with one result will go to one layout, with another result will go to another layout. This works fine and all, but there is a bit of a delay between switching layouts. My question is, is there a way to run a calculation that can determine what the next record is without going to the next record? Maybe based on a calculation field?

I have chosen to print records from a separate file and offer the Print Setup (Windows) to the user - to offer them a choice of printer. If the user cancels the Print Setup Dialog how can I get him back to his original layout? Hope someone can help.

My knowledge in Filemaker Pro is limited to say the least, but I am aware it is very powerful. I am working with a hand surgeon who has a very basic request. He wants to be able to click a button (lets says its labeled Elbow Pain) and when he clicks it, a pre-configured string of text is entered into a text output field. So, when he clicks the Elbow Pain button, the string of text "The patient experiences elbow pain" is inserted into the field. He wants to have a number of different buttons that have this function so that he can ask a patient typical questions, and instead of typing and answer, just simply click a button. So he may click the following buttons:…

I have a field that will return a case, but I do not want the calculation done until information has been selected in another field that has a value list. Example: My charging field will return: Case(ads total inches <= 25, "25.00", ads total inches < 72, "40.00") I would like this to happen only if a selection was made in another field that contains a value list. Otherwise this charging field would remain empty. What do I need to build? Thank you!

Is there any way to 'go to field <somefield>, repetition x', where x is a 'calculated' value instead of a constant?? Or to 'set field <somefield>, repetition x' again where x is a 'calculated value instead of a constant. TIA

I am not sure if this is a scripting question, but here goes... I have many, many databases that my office uses for mailing lists. We also buy lists in excel format. I deduplicate the lists by pulling them into one Filemaker database and running a script which marks, then removes all but the first instance of the same address. We also have a growing list of people not to send to. Currently, I am doing a find and hand deleting each one, but it seems to me that there should be some way to automate this, as the list is now close to 200 names. Since we purchase new lists, I cannot just delete them from the lists we maintain and be done with it. If anyon…

I used to use a copy step in a clients file and an external script in a contracts file to place client data into a new contract. Haven't been able to figure this out in FM7. It doesn't work the same way. I'm a little embarassed about this, because I'm quite sure it's very simple. Can someone please enlighten me?

this is really rather embarassing..but I can't figure out how to have a graphic appear in a container based on a user's selection in a pop up menu.. for instance if a user selects one...a checkbox graphic appears in the container field next to the popup field...etc..etc... any help is mucho appreciated...I know this is a simple one...but I'm missing something...because I get no love from my current container...

I have 3 fields: H, W, Total H & W use value lists. W uses 1,2,3,4,5 in the value list. H uses 1, 1.5, 2, 2.5, 3, 3.5 (and so on) What I am trying to get in the total field is a pre set dollar value based on the choices made in the H&W fields. Sort of what I am trying to say or do. if ("W"=1 and "H"=2.5, "total"=(24.50) Example: If a user chooses "1.5" in the H field, and "2" in the W field, the total field would display a pre set dollar amount. I do understand this will be a good number script lines for all the combinations. [color:"red"]

Can you tell me if and how I can create a cover page with several buttons that when selected will open the corresponding databases on our server? What scripts would be needed? Thank you in advance. Frances

this is a newbie question and may have been answered b 4.. i did a search but didn't find an answer.. maybe i missed it, so feel free to point me to that thread.... Thanks for your help. ------ Problem: unable to view a specific record in a new window (created via script) using the Go To Record/Request/Page command using the By Calculation option. What I'm Doing: each record has a CONTACTID (auto generated serial #) or RECORDID (assigned by FM) which i've passed to the script via the scriptparameter. in my mind the calculation should be Go To Record/Request/Page where CONTACTID = get(scriptparameter) or alternatively where RECORDID = get(s…

I was wondering if I can create a script that will do the following: Lets say I have 5 records.Here are my fields. Target_Level InStock Used Item Size etc... 10 5 5 something 9in 10 10 0 something 2in 10 3 7 something 6in 10 10 0 something 8in 10 10 0 something 10in Now, when I print it out I would like to have records 2 and 3 shaded with 10% black to identify that those two records have something used. I would like the whole row to be shaded. I know that the used field will be my conditi…

This is probably an easy one. I know how to hide and lock the status bar from the user, but I can't figure out how to disable the mode selector at the bottom of the window. I don't want somebody switching to find mode in a preview layout, etc. Also, is there a way to lock the layout selector when the status bar comes out with the "continue" button on it? What about right click menus? I have buttons assigned to take users to special layouts for creating new records, and if they figure out that they can use the right click menu, they'll screw stuff up.

Hi, I have a database which holds records for fields "partno" and "quantity". At the end of each calendar quarter I want to know which parts are no longer in stock when compared to the list of parts of 12/31. So what I would like to accomplish is to "select" the records of i.e. 3/31 and "compare" them to the records of 12/31. I would like to "save" the found set in a separate table within the same database. Any help is much appreciated yknot

can someone tell me why Send Event ["Stuffit Expander"; "aevt"; "odoc"; Quote(FilePath & FileName)] Will not work. Assuming File name = Pages.sitx File Path = Macintosh HD:Operator's Folder: ?!? I don't understand why this doesn't work. I want it to unzip the file for me. *Edit* By the way, I don't have anything other than the path and the filename in my database, no container fields with the file in it or anything. Just want it to launch a file on my HD.

I have written a script that will validate data that a user enters into a new record. I would like to do the same validation when the user makes changes to an existing record. Is it possible to invoke a script to validate fields on a layout after a user hits enter on an existing record? or is the only way to do this type of validation via the Field rules in the database definitions?

I have a script that calls a subscript, the subscript calls the next subscript, etc. There are 7 searches, with corresponding print commands when records are found. The scripts are searching 7 date fields to see if they contain any dates within a range determined by Status (CurrentDate) - the date in the field (a positive result selects the record for printing). Naturally, some of these searches do not yield any results. What I want is a way to have the "No Records Found" alert turned off, so that I don't have to hit the "Cancel" and "Continue" buttons for those searches that do not return any records. Is this possible? TIA John Chamberlain

Is there a way to control the sizing (and location) of a custom dialog box? Thanks!

I currently have a program that contains a template file. When the User starts a new project they input the project name. A script then creates a folder and a copy of the template to this folder and renames it the project name: i.e. ....JohnsonJohnson.usr I save the path and file name in global fields. I had wanted to then open this new file without futher user input, but gave up on that. I am now just trying to have the Open File function open up in the new folder. I have tried all sorts of ways, to no avail. Can't get the default directory off the last opened table without user input. Any ideals? Thanks

We have an in-house membership database, with a script that allows users, when they've made a change to a member's record, to click a button that activates a script that will then use the Open URL function to pass the information via a URL (created in a calculation field) to a Lasso script that will then update the corresponding record in our online database (from parameters in the URL). Unfortunately, since we moved to FileMaker 7 (and Lasso 7), this script is somehow converting everything to all lowercase before updating the online database. I'm 90% positive that this is happening in FileMaker, and not in the Lasso page. Anybody know how to solve this? I'll po…

I have a portal displaying Print Specs related to Fulfillment Specs. I can successfully create a new record using a button in the portal with script parameters. What I really would like to do is have a checkbox in the portal. And one button that would create new records based on my checked selections. Not sure if I was clear enough in my explaination, but I would greatly appreciate being led in the right direction. Cath

Hello, I'm trying to finish this database for processing orders for my little bookstore. All of my data is in Filemaker, but I make heavy use of other applications like UPS Worldship and Endicia's Dazzle. Currently, the process is quite unweildly because we are opening several programs and importing and exporting all over the place. I'm looking for a way to automate almost completely. I looked into the DDE script option, but I'm having a hard time finding the actual service name, topic and command for the applications I use. (Their tech support will not help with this either.) Is there an easier way to do this? It seems like it would be a fairly common iss…

I want to be able to Script the following once I have done a find: set a field to have certain text in the whole found set. There are two things I really am unsure about - 1. How to run a script through a found set and 2. Is there a way to prompt a dialogue box to come up that allows the user to enter the text in the dialogue box and then have that be the text that is the "set field" for the set? Any help would be much appreciated - I am getting pretty desperate! Thanks, sarah

Hi, I don't know why the basic Windows functions: Copy and Paste didn't work probably sometime in FM 6 in 2 computers. 1st computer: Work fine in local but didn

I am new to Filemaker and trying to print 3 different reports but with sequential page numbers. I would like to evaluate how many pages are in a report , store this number and begin printing the next report with the next page number. I do not wish to have to enter the "Begin printing with Page Number" screen that pops up with the Print function. I would like it to be more automatic. Every thing I do to evalutae the number of pages, seems to be "unstored". Thus, not allowing me to input the # into another field. Hope this makes since. Any ideal of help is appreciated.

Hello, this is my first post and after searching a lot of the older posts, I couldn't find an answer to my problem. I am running a script with the Status(CurrentPrinterName) to check the name of the selected printer, so I can move to the correct layout for that printer model. FM Pro Dev 6 works fine in Mac OS 9, returning the correct name, but in Mac OS X it returns <unknown>. Am I missing something or doing something wrong or It is a bug on the Mac OS X version. Is there a work around this? Thanks, in advance.

Hi all, In my database, i set up a script that switches Layouts when i click on the appropriate button and works perfectly fine. My problem came when i started using the db to debug it, i realised that the relationships i had between the same table but different Occurence make some data appear in portals where they shouldn't. So i deleted the relationships and works fine, BUT now my script to change Layout cant work as it uses GTRR (go to related record) and these TO are not linked anymore even though it is the same table. The reason why i uses GTRR and not the simple go to layout is that i want to stay in the same record when i change layout to avoid any mistak…

I now have a database with user names and file names attached to them with the location, size and date last accessed. Each users has several entries in their name. I want to be able to send a single email to every user in the database listing all the files in their name. The email itself is no problem. How do I calculate the list of files and only send them one email? Thanks!

Hello all... I am trying to figure something out about exiting Filemaker. Currently most of our files have an exit button in them that Exits Filemaker. Well sometimes people have more that one file open and when they click close it closes there other files. Is there a way with a script to say if i am the only file open, close the file and filemaker. If there are other files open close file1 and leave filemaker open for the other files?:? Just curious. Garry B

Hi, Don't know if this is the right place but I have a check box within a table. When there is a cross in the check box, I want to omit records within my script. I have tried to do this by constraining my found set but I don't seem to be able to get the syntax correct. Should I have the checkbox field formatted as number? What is the syntax for omitting the boxes that are checked? If this is in the wrong place, do tell me where I should put it (clean answers only please!) Many thanks

I need a script that will sort records based on a field and the omit all of the records that don't have that field showing, I can't figure this out!!! THANKS

Yes - it was stupid! I put a script containing a close window command in as my startup script, and yes, when I open my file the script immediately closes it!!! Any thoughts on how i can prevent the script running, or get into the file by a backdoor to edit the script?

I have a printing script that directs the user to one of three printing layouts (depending upon their response to the "show message" function. If the user aborts (escape) after the redirect to one of the print pages, the script halts, but the user is looking at that layput page. How do I set it up so that when a user confirms "cancel", the script will redirect the user back to the main layout page?

I have a database that alows users to make updates. What I would like them to do, is when they make an update or correction, upload that record the server through FTP(I guess). Any help you can give is much appreciated.

I have a form named Material Order. On this form I have a field named Job Name on Table A which is linked to Job Name on Table B (Job Addresses). This field setup as a pop-up list which in turn fills in the address fields below. As new jobs arise, I would like to be able to fill in the information and have it be placed in Table B so as not to have to enter the information directly into Table B. I have tried using Set Field but none of the information ends up as a new record in Table B. Thanks, Phil

I wish to create a button that will automatically paste text (previously copied into the clipboard) into a field but which prompts me with an error message if the field in not empty ie so that I dont over write anything! Other wise if the file is empty then it will paste automatically thanks

I am working with FMP 5.5 and I have related parent to child files. In child file, I have a very long script and when in the child file and when executed, works great. However, when I attach it to the preferences-> Document "when Opening File" ->"perform script" it does not perfrom the script! Why would it not perform the script when I open the file? Many thanks in advance!

Hi Everyone, I've attached a small working file. As you know, searching through a 500,000 LineItem file can take time so I usually use GTRR to isolate LineItem records. During our shipping day, sometimes we find out a certain order (Invoice) needs to be unshipped and put into Pending (another portal window). 'Shipments In Process' appear in a specific portal window (Invoices Shipping Now). Because of back orders and other issues, my LineItems need to be flagged in various ways during the shipping process. So when an order is removed from a shipment day, those LineItems also need to be isolated and 'unshipped' as well. If you check the graph you'll see how I'v…

During a windows scripted search and export, I get the error message of: "1 record(s) could not be modified because they were in use by other users or your password does not enable you to change them." This is a shared db, but no other users are using it. I checked the password privileges and they seem to look proper. Any ideas? Is there something, that I need to really look into, scripting, passwords, users logged-on etc... I know some error messages can be misleading... Thanks all!!!

I have started the process of converting an application from FM5 to FM7. The problem I am getting is that when I move from one file to another using a script, FM7 first displays the last used layout on the file I am going to and then displays the layout I have requested in the script. The effect is a 'flash' before the desired layout is shown. Is there an obviuous way to avoid this ?

We have customers that are seasonal, and request their billing address is changed for certain periods of time... the problem I am having is getting a script or calcuation to recognize the range. "LeaveDate > Get(CurrentDate)" returns fine, but if I try "LeaveDate > Get(CurrentDate) < ReturnDate" or "(LeaveDate > Get(CurrentDate)) and (Get(CurrentDate) < ReturnDate) it fails the moment I ask it to compare that second date. It seems like this should be a simple process, but everytime I try to have it fit into an actual range, it fails. Any ideas? Thanks

I need a bit of advice on how scripts work in Filemaker Pro 7. I'm trying to build an invoicing system and have lots of automations I'd like to build in, but can't work out how to do it. My current issue is this: I want a button that, when clicked, will populate a field with the count of the number of records in the current table that relate to a different table. The current table is 'Invoices' and it has a relationship with 'Customers'. When the button is clicked, a field should be populated with the number of Invoices that the customer currently has. I can't work out how to do this. The Scriptmaker tool lets me choose from a finite list of f…

I have a database where i need a mail send to an address when a new record is created. My plan was to make a fm7 "client" on an osx machine check for new records every 15 min. i can't figure out how to make a script to do this.

Greetings everyone! I have tried to make this work, but have gotten marginal results at best. I was hopeing that someone could either show me the error(s) of my ways, or point me in a better direction. Here's what I've got - One bit of software I've developed has the main database, and several individual modules that a client can additionally purchase. These modules are not needed for the main database to run, but the modules do depend on the main database as a source of info. Since each client can order a different "set" of modules than any other client, there is a "custom" main menu file with a bunch of buttons - each button runs a separate script to …

Hi Guys, Im still thinking in FMP6 mode and am quite confused with the new

I seem to be using copy and paste a bunch in my scripts. Mainly to link records across layouts using different tables and sometimes from portal to portal in other layouts. I recall reading somewhere that copy and paste is common mistake made by a newbie like me. I have tried using Set Field but that does not work in many of my senarios. What is my best choice for getting text from one field in one table to different field in another table? And while I am at it.... What are the most common and most hurtful mistakes I could make when scripting? Thanks!

Hello all, I've written a simple export and ftp upload procedure which consists of the following steps: 1) FM exports two files in CSV format for n record representing my customers (7 cusotmers = 14 files). 2) as the csv file name is always the same, I use send event and a .bat file which rename the files after FM exports them. 3) through a .bat file I upload all the *.csv files on my FTP space. These script is very very simple, and it is working when I perform it 'manually' but, when I execute that script as subroutine of another FMscript, I think the batch files are not accessed by filemaker. Anyone experienced similar problems? Any idea?

I will preface this by saying I believe that the answer to the problem outlined below will be: "Look at your scripts closely and decide where to do error testing." I am hoping that someone else will have figured out an elegant, easy alternative to this, and will share their experience! I am in the midst of re-thinking how I handle errors that arise in the course of my scripts, and I am looking at ways of creating a generic error routine. What I envision is a system where I have: * errors stored in a separate table, * a global field for the current error, and * a layout to display the current error to the user when an error situation arises. …

I think this is a question of scripts but I'm not sure. I have a db that holds information about a companies. I want to create a button/script that allows me to go to a related record (like a subsidiary or a parent company) within that same database/table. this must be easy but i just don't know how... help is greatly greatly appreciated.

I tend to apply this script in an inventory db I'm working on but for discussion sake, say I have a db of 5 automobiles, all accords but different cars, unique Licence. 1. Honda, Accord, Licence, Date,Odometer,Fuel purchased 2. Honda, Accord, Licence, Date,Odometer,Fuel purchased 3. Honda, Accord, Licence, Date,Odometer,Fuel purchased 4. Honda, Accord, Licence, Date,Odometer,Fuel purchased 5. Honda, Accord, Licence, Date,Odometer,Fuel purchased The original record for each car was created when the car was purchased and a new record is created every time gas is put in the car. So now the bd contains, say 200 records. I am trying to come up with a script tha…

I posted a while back for some help and a member kindly posted some info but I am still confused as to how I go about writing a script to solve my problem. Members advice is below - how do i organise this into a script though... "In general though you would script a find based on the "unpaid" flag. Then sort the found set by "days outstanding", probably add a summary field showing the total amount outstanding per caterogy (30 days, 60 days,...)" I have an 'invoice' layout with a 'status' field showing paid unpaid etc...I would like to find all unpaid invoices for each client detailing the days outstanding i.e current, 30 days, 60 days etc...and move each fo…

Im having a problem sending a .pdf file via the send mail function. I have a field in a table called email with email addresses for people in my golf league. I run a script to print a report ive made to a .pdf file and then send that file as an attachment to the players whos email address i have captured. However, when it comes time to generate the email nothing happens.. Im using apple mail by the way. the script does open my mail client if thats helpful to anyone. i checked the FM7 help screen and that wasnt too helpful. as always any information would be appreciated,

good day! i'm still having trouble with this one pickle...when i run the find categories script, i want the directory layout to print the found set with the category field chosen by the user in the header, which i've attempted to set to DCategory. it's unclear what i'm doing wrong, but i either don't get a value at all or simply a zero in the merge field when i run the script. i tried to use the Category field as the merge field instead, but that only works when the matching category was chosen first in data entry. (some listings belong to multiple categories) i'm attaching the file to look at, any ideas where i'm making my mistake? thanks db GLCCt…

In FM, if you import a file reference into a container field, you can double click on the container (MAC) and the file reference will open. If it is a PDF file, it will open in acrobat. If a photoshop file, it will open in photoshop, etc. Is there a script that will act the same as double clicking in the container field? LR

I have file with layouts 1, 1a; 2, 2a; 3, 3a and 4, 4a -- four sets of pairs. At any one time there will only be one pair that is used per record and the other layouts per record are left blank. Is there a way to ensure that when selecting a record only the first of the active pair, 1, 2, 3 or 4, is the layout that comes up? For example, in record one, layout 1/1a is used and for record two, layout 3/3a is used. When choosing record one, the record opens to layout 1; if record two is choosen, it opens to layout 3 ....

Hi Guys, Just a very quick question. Im debugging someones code, and they have a statement which is: If["0"] blah blah blah End If What does If["0"] mean? and when do you use it? Thanks again a guys.

Hi I am using a script to open a pdf for a Mac. It is the perform Apple Script and the script says: Tell "Finder" open file "Intro.pdf" of disc "Notre Dame" Open Selection End Tell I am pretty sure this is what it says, since I am writing this on my PC, can't be 100% sure. But the script was working a while back, and now it's not, just wanted to see if anyone had any ideas, or similar problems. Thanks!

I have 10 teams, I'm trying to write a script that will make a 9 week schedule such that every team plays each other once. Sounds like such and easy thing to write I can easily populate all the fields, but making each match unique has got my brain all twisted. Anyone got any suggestions ?? thanks Ed

Is there a way to save a found set and then go back to it later?

FMP7: I am trying to perform a find based on find criteria input through field displayed in a custom dialog box. The Filemaker help files have this to say: The problem is that I don't know what find request to use. In other words how do I get the input fields in the dialog box to be used in the search? I already tried [Restore FieldName:=] and [Restore FieldName:==] but (of course) that just returns the empty fields I also tried performing the find using the Perform Find script step without the "Specify" (i.e. [Restore]) checked and that returned no records. Can anyone help? Thanks

To solve the show records after todays's date... Did a Find in the date field using >= //. Then created a Find script... Then made a button using the Find script returns today's plus subsequent dates...now to constrain the found set!!!

Before I get deluged with "never use repeating fields", let me say that this is a legacy database from the FileMaker IV (not 4.0) days. I had to condense a series of lookup databases into this main one all having repeating fields. I need to copy the contents of a single 40 repeating field into four ten repeat fields. I used script step Set Field("xxx,1", GetRepetition("yyy,1")) Set Field("xxx,2", GetRepetition("yyy,2")), etc. for all repeats, but onlt the first fields populate themselves. I used script debug and watched the script work, but only the first fields were populated. I found that I can copy and paste said repetitions, but I really don't want to write…

Hi, can you help me I am creating a script that will be activated when a field specified as a button is clicked. When this script is performed, it makes use of the Get(ActiveFieldContents)function, by setting other (global) fields to the value of the clicked field, and finding records with criteria in the clicked field. However I cannot seem to get it to work. The first thing the script does is: (to prevent the script from continuing if the target field is empty) If(Get(ActiveFieldContents) = "" Show Custom Message "Please select a field" Exit Script End If And this always results in the message being displayed. Another test I have done is simpl…