Script Workspace and Script Triggers

Again, I am sure this is a simple matter; so don't look to pathetically upon me for asking please! I have inserted the current Record Entry for each record, so for example on Record 1 it will say Record 1 and so on, so record 56 will say Record 56. However, what I would like to do is have it say Record 15 of 1056. How would I go about doing this? I can not find a function that allows me to put in the total number of records in the database. Any suggestions or ideas would be most appreciated. Many thanks to you all in advance. Mark

OK, whilst I am here, I may as well try and push my luck a bit. I have setup a layout that will show everyones email address. However, the results also include empty fields of people who do not have email addresses. How can I achieve only showing results that actually have email addressess entered in my email fields? Did that make sense.

Hi All Ok, I have 5 tabs in my database, each holding different info. I have popped a Print button on each tab which takes it to a new layout for previewing, then prints. I have also put a Return Button on that layout to take me back to the Tab section I came from in the main database. However, how do I specify which of the tabs it returns to? I have tried this, and it always seems to go to the wrong tab. So, how can I specify which tab my return buttons takes people to. Again, many thanks for your help. Mark

Hi, When I try to runa script by clicking on an image, an Hour Glass with esc next to it appears. I know if I press the Esc Key, it stops, but why does it appear and can I stop it from happening? Many thanks Mark

Hi my friends, I'm trying to write a script that, when a button in a portal row is clicked, takes the user to a found set of all the related records and then lands the user on the particular record that was clicked on. The problem is that the "go to related record" script step takes you to the related records correctly, but then lands you on the first record of the found set. I know i could script it to take me to only that record, but I want to bring up the entire found set of all related records and land on the specific record that was clicked on. I have a feeling I'm missing a simple solution to this problem. Can someone help? Thanks in advance!

I am trying to create a script which reads records and look at their due date and number of days notice field to determine if they should be "found" in order to be displayed to the user. The days notice field (number) varies by record and depending on this field, the user will get some advance notice before the due date comes. The rest of the script is working fine but not the calculation in the Set Field command. The script is attached. Thanks in advanced for any help. Tasks.pdf

I am trying to set up a step by step training manual for my cabinetshop. Some of the things we build use essentially the same steps as other things we make. I would like to be able to develop a task list for one product then use that same task list again for something else. [color:red]I would like to start from a FOUND SET then duplicate just those records with a script. Can somebody suggest a way to do this? Thanks, Jarvis

I am looking for a script that will delete a record in a portal. I want to click on a field in a selected portal row and delete that specific related record. I know this must be very simple, but ... thanks to all!

I'm trying to find a good way to extract email addresses from a text and use this addresses to find records in other DB files and do some other automated stuff based on the found sets. Problem is, an email adress can come along in a variety of ways, e.g. , or "[email protected]" etc... So far I focused on the version including "<>" which happens to the addresses in the header in Entourage, if you forward it and then copy and paste the whole text into a FileMaker text field. Question 1: Is there a way (like PatternCount) to count all words that include "@" AND "<" to get the total number of valid emails in the text??? Question 2: Is the…

I have a layout and there are several fields and i have a counter. I want to add new records but set some filelds sometimes previous record. I tried set ( filed::a) getnthrecord ( field::a , getfield ( field::counter ) - 1 ) counter is auto enter serial field but it didnt work. how can i add new record with some fields are duplicated by previous..?

Hi Everyone, I'd like to create a script that would cut the last five characters from one field, and paste them into another, then repeat the process for all the records. I remember doing this in the past, but it's been so long. Anyone have any advice? Thanks, Chris

I have an ordering system now that I need a button that runs a script that does the following: Copies the contents of the Order # field and performs a find in another layout with those contents, then with the results being placed in a table view ready for printing. Yea. Maybe better in other words: Order Layout - User currently view Order #2 Script - Finds all the records in Parts Layout associated with Order #2 Script - Places all found records in Table Layout ready for print. What does the script need to contain to allow this to occur? thanks in advance

I have created a script that takes me into find mode where I can enter a date to give me a list of things I need to ship on a particular day. Is it possible to have a prompt when I go into find mode that will ask me to enter a date.

How can I record the date that a specific field in a record is modified? You can record the date that the record is modified easily enough, but this includes all fields. I want to track dates for changes in value of a specific field.

I'm writing a script to populate five tables in my database by importing from five data sources, taking care to set each Primary Key's next serial number. Here's the procedure: Go to Layout ["All Invoice fields" (Invoices)] Import Records [No dialog ; "Invoices.fp7" ; Add ; Mac Roman ] Sort Records [Restore; No dialog] /* sort asc. on primary key */ Go to Record [ Last ] SetNextSerialValue [ Invoices::Invoice_ID ; SerialIncrement ( Invoices::Invoice_ID ; 1 ) ] For the LineItems table I expected to be able to write Go to Layout ["All LineItem fields" (LineItems)] Import Records [No dialog ; "LineItems.fp7" ; Add ; Mac Roman ] Sort Records […

I'm working with a school that is running OSX4 on all machines. We upgraded their database from 5.5 to 8.5. There are some lengthly print scripts that print pages from multiple layouts. I found that the page setup needed to be recaptured - easily done in 8.5. Tested all scripts and things were fine...until someone running a MacBook with the Intel chips ran the script. Only on the 3 MacBooks in district do we get: the first page in landscape (should not be), then all other pages print fine (unless the printer locks up which is frequent - requiring a que clearing). This same script runs fine from multiple machines to different printers - as long as it's an iBook or eMac! :

I read the documentation on the "Freeze Window" script step provided by FMI and in the Scott Love, et al., book FM 8 Functions and Scripts (page 301). The Love books says that you can navigate to a utility layout and return to the "main" or original layout and the user won't see the the window change while this is happening. So I wrote a test script (see below) that switches between two layouts, Main1 and Main2 and uses the Freeze Window step. I added some pause steps to see what is happening and sure enough, the window does NOT freeze. What am I not understanding? TAI --Sam I'm using FM 8.5 Advanced on Mac OS 10.4.7 --- TEST Script --- …

Had a script in a database in FM6 that upon opening one file (Menu), it would close another file if file #2 (Contacts) were opened. The script is (with FM8 formatting) If( PatternCount( DatabaseNames; "Contacts" ) > 0 ) { Close[ Contacts.fp7 ] } Problem is, Contacts is open and when Menu opens, it does not close Contacts. I see it under Window > Show Window -> (Contacts) Actually, wait, it seems as if the script IS working (I stuck a popup in the If statement and it certainly is triggering the Close[] function). Are the files that are in parenthesis "differently open" than the ones not in parenthesis? If so, is there a way to close…

I know I'm this > < close to getting this db to work; the only problem now is the print script (^3 or Create_Incident_Report) for printing an Incident Report. Layouts to look at: Incident_Report_Entry and Incident_Report Problem: When I try to view or print a report in the Incident_Report layout (after running the Create_Incident_Report script), I always get the data for EMP00001 even though I'm "sitting" in the record for EMP00002 when I run the script. I thought I had the Find requests nailed in the script but I guess not; I'm missing something. So, if you can tell me where I went wrong with the script, I'd appreciate it very much. Many thanks in ad…

I've created a variable in one script: Messages::applicant_FirstName_ae&"¶"& Messages::applicant_Middle&"¶"& Messages::applicant_LastName_ae&"¶"& Messages::Search&"¶"& Messages::Male_Female_ae and am trying to pass it as a ScriptParameter to a script in a related external file.. by entering $script_values in the ScriptParameter box. Then, in the script in the other file's script, I'm trying to retrieve the values (minus their carriage return)... and somehow I'm ending up with field values that are only the first two characters. So, "Johnson" is coming over as "Jo" The way I'm trying to retrieve the values in the scrip…

I have a layout with 3 buttons. 1-concept 2-existing 3-revise. Problem. in layout #2 I have 3 fields on the header. Concept __ existing __ revise __ What i want to do is. if i click on my concept button, i would like my concept field to get an "X" right next to it. How can i do this. Thanks

My current project consisits of 2 tables to make a mailing database. Records is all the companies Issue Sent is all the well issues Sent, referected to the Company Id Now wheni get updates of sent issues New companes are mixed with old companies and i end up with duplicite Records. How do i go about searching my Records Table to find Identical records (so are similar but are different clients. Say i have Company XYZ, Company XYZ, Company ZZZ, and Company ZZZ. The second ZZZ may be a different department and would have a different address, contact person. While the second XYZ has the same contact, address etc) what i need to do is auto sort though the…

I have my Database setup and I am very happy with it. However, I would like to place a button in my header that when clicked, sends the user to an already created Layout. I did this and it does not work. Any ideas plaese? This is what I did: Created the button, then clicked on Scipts/Script Maker/New Gave my script a name then chose Go To Layout. I moved it over and then I clicked on Specify and chose the layout that I want the script to go to. Clicked Ok and OK again. However, it does not work. Can someone tell me why and how I can get it to work. I did use the Run Script With Full Access privaleges as well, just to check if that woudl mak…

I have an FM6 DB with a script that results in printing academic reports for a particular year's students. The script opens a report file for a student, on user pressing continue, prints the report, closes the report then opens the next student's report. If cancel is pressed on the printer dialogue box being pressed then it closes that student's file and opens the next student's and so on. But the problem is that once the script is started then ALL students' reports need to be processed before the script ends. How can I add some script so that the user can abort the script at any time through the process? Below is part of the script that controls …

I want to script a Quicktime [PDF] insert into a container field [clinical::view_pdf] from a directory of PDF files residing at ~/desktop/docs/. On the same layout as the container field is a calc field [clinical::c_FilenameKey] with the filename in it. Setting the variable, I want to tell Insert QuickTime to get the file that is the same as the calc field and insert into the container? Below is the script I'm using, but in the debugger I get the error message: "Insert QuickTime could not be completed." Need the eagle eye of someone wise in the ways of FileMaker. Set Variable [$filePath; Value: Case ( Abs ( Get ( SystemPlatform ) ) = 1;"Moviemac:";"Moviewin:"…

I have two related tables - membership and attendance. I want to be able to have a script look at all the records in membership and auto creat attendance records - one for each member for a given day. Is this possible using a script? I would like to tie to to a button with a custom dialog asking for a date. Thanks for any help

I'm trying o figure out a calulation. I know how id do it in PHP or C++ but cant find how to translate that to the Calcualtion funcion in the database define calulations. A little help? psudo php code If ((isset(CompanyID)){ if (Records::Company == '' AND Records::CompanyID == CompanyID){ UniqueName = Records::First Name; UniqueName .= " "; UniqueName .= Records::Last Name; }else{ UniqueName = Records::Company; }}

Hello, I'd like help writing a script that will count the number of similar records in a field. Something like this. text - count a 2 a 2 b 3 b 3 b 3 c 2 c 2 d 1 In my file I have 3 fields (text) - which holds the information (count) - which is empty and needs to be populated with the count of the number of similar records in the text field (found_count) which is the calculation Get(FoundCount) and lists the number of records in a found set. Any help would be greatly appreciated.

Hi. I am v new to FM and databases in general. However I’ve spent a bit of time trying to find a way to link a document to a record in FM Pro. I don't want to copy and paste the body text into a field, but I do want to create an actual link that I'll be able to click, which will open up the linked document. I'm happy to amend format of document into a pdf or even an HTML page if this is a work around. I have many records that all need at least one or more documents linked in somewhere. Definitely using Mac os but not sure if it's jag/panther or tiger. Any advice is greatly appreciated.

I have a longer custom dialog message for my users. They can open the box bigger if they want to but let's face it, most of them won't do this to read the whole message. Is there a way to script the size of the custom dialog box so that it is the size I need it to be? Thanks

Hi, A real Newbie here. Hope you can help me. I have created a database which consists of names, dates, text boxes etc etc etc. What I would like to do is to create a query which would, for example, sort through the thousands of entries that I have and say list all the males who were 18 in 1986 (did that make sense?), then I would like that info displayed on the screen. Is it possible for me to create a script using a button to do this so the user can just press it and get the info? Am I able to do this, and if so, could someone kindly help me here. I do hope you can help. Mark

I have a field where the user changes it based on what market they want to see. I want a script to run everytime the market changes. How do I get the script to run based on the field change? Thanks

Is is posible to create a portal that is dynamicly scaled tothe contents. Ie if their 1 record inthe portal it has one row, if their 12 it has 12 rows? ETC (not this is only for printing it can be scrollable in screen view)

Hi All. I have a loop that needs to go through a value list and set a field to the next value (then exit loop after last value). I think i have it working except the calculation to grab the next value. I assume it uses the GetValue function, but not sure exactly how to script it. Can anyone help? Thanks!

I want to pause a script indefinitely so that a user cannot close the window, quit the program, etc... I thought that by forcing the user to choose a scripts to run that the original script would then resume.. however what happens is the the new script runs and leaves the original script paused. Can someone tell me how the 2nd script can return the first script back into a non-running state ? File attached. pause_resume.fp7.zip

I have about a dozen FIleMaker databases that contain consumer requests. Once a day I go into to each and run a script that sends an email to the new entries (e.g., using SMTPit). This is very time consuming so my plan was to create a FM file that is opened once a day by Windows Server that when opened would open each of these dozen files and run the appropriate email script. The challenge is that these dozen files are all password-protected and I don't want to be promped for the password each time this master script runs. So two questions: 1. Is there a way to pass a user name and password to the Open File script step and/or 2. Am I going about this in entirely …

Hi, I am wanting to automate my import procedure for an XML file. I have the style sheets and want to be able to do the following scenerio.... STEP 1 - user clicks "import xml" STEP 2 - popup asking where the file is. STEP 3 - user navigates to said file. STEP 4 - filemaker temp place path into "mycontainer" field. STEP 5 - filemaker imports xml using predifined stylsheet 1. STEP 6 - filemaker imports xml again using predifined stylesheet 2 and using the "mycontainer" field for the xml file path. Repeat STEP 6 - 2 more times for predifined stylesheets 3 and 4. STEP 7 - END Okay so I am fairly ok with everything except the filepath thin…

I need to write a script to find all records where the Month of the "Due Date" field is equal to the Month of the current date. HELP, please I'm a new user of FileMaker Thanks!

Hi. i have a script that sets two variables. I would like to later go to a record where those variables equal a fields value (there will only be one record that equals those values. For instance: Set Variable [$year value:"98/99"] Set Variable [$test value:"01"] ... Go to Record/Request/Page [MyYearfield = $year and MyTestfield = $test] This does not seem to work. I have tried a couple of variations, but nothing has worked so far. Can someone please help? Thanks!

I have been tweaking the Events management template that comes with FM Pro 8. In the Guest tab (in the Events tab) you can add guests to a portal from your contact list. Well, I want to be able to look at a contact (under the Contacts tab) and see what event(s) that contact had been invited to. So in the contact layout I set up a checkbox value list that has a list of the Events in the database. This value list is automatically updated when a new event is created. Now I would like for this to be automated: when I check the checkbox in the Contact form it automatically adds that contact to the Guest List portal or vice versa. Can this be done, and if so, how? (I hope this …

I recently update server to 8v4 and clients to 8v3 to get rid of broken indexing. I still can't get my scripts to print to the right printer AND with the right format (portrait vs landscape). I have different layouts that produce different forms. I make printing buttons for the staff so they do not have to memorize which printer has the right paper and which way it faces. The script that is triggered is set for the printer and orientation but usually goes back to the last last orientation used. Anyone have any new ideas other than manually using a dialog box each time. I do not want to use a plugin. I feel that this should be fixed by the 8th generation of a…

in my file i started concatoniating fields that shared company info with multi line fields. no field should be empty (unless i hadent finished entering the data manually in wich case its moot the true copy record hasnt been deleted) any fields that were empty weir either place holder records or incomplete copies. Any time a new records was multi lined they has issue name, volume, number, sent number, office from, and sent date while thing like company name and address remained a single line. it was just a caridge return concatonation to combine the issue name, volume, etc. fields. Now i want to undo the caridge return fields and split them into seperat…

I am trying to create a script that will automate the creation of records based on a variable, and copy the record ID to the new records. Thanks

I've created an "Insert Picture" script to go into a container field with the following script steps: "New Record/Request Go to Field [Flexi Jobs::Job Sheet} Insert Picture[Reference]" When I perform this script, a dialogue window appears displaying "My Documents" allowing me to choose the picture I want to insert. However, the pictures I need, reside in 2 more folder levels within "My Documents". I want to create a folder path to a folder(s) within "My Documents" folder where the pictures I need are kept. Can anyone please tell me how to create this folder path? I've tried using the Open URL script step but I'm obviously doing something wrong. So what I nee…

This actually IS a ScriptMaker question. I need to be able to search in a summary field from a related table but when I put the field on my layout, I can't click into it. The relationship is correct because the field shows the correct results. I read another thread that suggested scripting a find using Set(field) in a similar instance. OK so far, but I want to be able to modify the find on the fly. Specifically I need to search a field called yearsTotal which is a summary of the years a person has been a club member -- one record in a related table called ActiveYears per year, the relationship is based on contactID on both sides. So if I script a b…

I've created a Find Layout and have a script that allows specific finds. Right now, the user has to press the 'Enter' key on the calculator part of the keypad to continue the script. Ordinarily, in Find Mode, pressing 'Return' will perform the find. Is there a way to change the behavior of the return key? I want it to continue the script/find the record rather than doing nothing, as it does at the moment. Help!

First off, you've guys have helped me in the past so I would like to say thanks in advanced. I've run into a little snag. Here is what I need to happen in the database. I've created a script that will make a duplicate of all of the information contained in a form I've built. The script also copies the automated serial number so it doesn't have to be reentered. I would like to be able to add a revision letter to the now duplicated record, example: Serial Number 1901, revision A. If I need to make an additional revision to information in that record I would like to be able to make another duplicate and issue a revision B status. Right now it is a manual pro…

My current project requires me to import text files that contain names and related details, I have been successful in importing this data to a single field but in one recordonly. Is it possible to streamline this so I can get the name and related data into seperate records in the quickest and easiest way, my contraints appear to be because the source is not an excel doc or commas have not been entered in a logical way, carriage return has been used however. The word (txt) doc contains data like this: Joe Blogs Born Penzance Sept 1859 Joe Blogs2 Married Marlyebone, London Jul-Sep qtr 1848 Joe Blogs3 Died Henly Oct-Dec qtr 1849 (BMD 3b 466) Each J…

I am creating a email script that will ask the user if they would like a file attached. I want to avoid the Send Mail dialogue box, so how can I have the user choose the file they want attached, and store that path as a variable ($path).

I have recreated a script which checks for a related record with the parent file. It suppose to then go to the related record, if found, and display it in the desired layout. If not, I want a record created with the contactid from the related parent file posted to the contactid of the related file. But the id is simply not being entered in the record. Is there a problem with my attached script? wps_RestrictedContacts.pdf

Hi all, Seems like this should be easy, but...in FM5, what script step(s) do I use to alpabetize a list within a text field?

I need to write a script/recreate the variables that functioned in 5.5, 6 and 7, but not in 8. Here's what I want to happen: Everytime the database opens, I want a script to run and if it is before June 15th the following year, the student's grades stay the same. If it is past June 15th, the grade goes up one. Our database has students in 7-12 grade and it would be very helpful if the grades would just automatically update. Any suggestions?

I'm trying to put Back and Forward buttons on my layouts... i've kind of come up with a system that works but i'm stuck with a new problem. Here's what i have now: a SetNavPoint script that puts in a global field (or rather it adds to whatever was there before) the current layout number. As the user changes the layouts the global field, NavPath, keeps track of all visited layouts like so: 32 5 4 1 15 etc. Then i have another global field called NavPathRev that the Back and Forward scripts use. So when the user hits a back button takes the first "word" out of the NavPath field puts it in the NavPathRev, and goes to that layout. Then the Forward button doe…

Hi everyone, I was wondering if anyone has successfully created a dedicated Find Layout as described on page 385 of "Special Edition, Using Filemaker 8" (it's also in Special Edition, Using Filemaker 7 on page 374). The authors make a great case for using dedicated find layouts which appear as pop-up windows that overlay the layout for which the search is being conducted. In practice I have not been able to replicate thier process, which is to create a script that takes the user to a pop-up "find" window, places the user in Find mode, allows the user to ender the search criteria, then, through another button within the pop-up window itself, performs the request, cl…

Some scripts go freezing by changing the layout and fields 'online' on filemaker server. And then its impossible to work with this damaged scripts and they cannot delete from the scriptmaker register. There must be a bug in filemaker 8. Have anyone an idea? How can I delete a script when filemaker say "this script doesn't exist"?

I have created two scripts. 1) a script that is called up from a contact layout in one table is suppose to prompt a user for a password and if he/she enters the right one, they go to a layout on another table. But the script appears to be looping despite entering the correct password during tests. 2) Within the same script, once they enter the right password and the restricted layout is displayed, the matching/related record is suppose to be displayed showing existing data or a new one created to enter new data if an existing record is not found. But that is not working either. I uploaded some attachments for all to see and hopefully assist me in troublesho…

Is there a way to parse data from MSWord into an FM database? I get several Curriculum Vitae in everyday and currently I have to cut and paste all the data into my application. Most of the CV's come in via email in a word doc. Some pdf. I would like to be able to parse the Name/address/phone/email data into their respective fields as well as store the content in another text field. Any ideas, suggestions, plugins, whatever? Thanks for your help. Al

This may be an obvious question, but I'm having difficulty setting the cursor position in a field to a point I specify. I have a script that sets a 'timestamp' at the start of a field, and I would like to position the cursor immediately after this, so that the users can then type their notes. However, I cannot seem to find a way of doing this. Any ideas? Thanks

I'm hoping there is some sort of script or formula that can make this work for me. History: I run a lot of database that have all sorts of ingredients stored in the fields. The field that stores this data is also in a print format to create a sign for customers. The issue that I have is the field is setup to a certain point size and number of lines. I have ingredients from one line text all the way to ten lines (plus). Needed: What I need is a script to format the type to fit the field exactly. Is it possible to write a script for type formatting attributes? This way I don’t have to go in and manually change all the records so they print out correctly…

As subject. Is there a way to create a new record on a table? I have a file called the PC Asset Management.fm7 which has two tables: Asset and Inventory. There is layout called Inventory View that is based on Tabe: Inventory. OK, here is the trciky part, another file called Peripheral Management.fm7 and I am trying to write a script to copy field(s) from Peripheral Management.fm7 to PC Asset Management.fm7 that is(are) in Inventory. Problem: ======== It seems that I am unable to write a script on Peripheral Management.fm7 as ****************************************** Go to Layout ["Inventory View"(Inventory)] New Record/Request *************…

Hi, I need some help please in navigating through a related file using a script. I have 2 files, A and B. File A contains fields A::Available and A::Allocated. File B contains fields B::Available and B::Allocated. I need to allocate every qty in A::Available across one or more value of B::Available related records in B. eg. A::Available in the current record in A has a value of 200. In B there are three related records with B:Available of 140, 50, and 300. I need to allocate the value in A so that the values when finished are: A::Available = 0, A::Allocated = 200 record_1 B::Available = 0, B::Allocated = 140 record_2 B::Available =…

When I create a FileMaker solution for a variety of users, I usually provide a button that toggles window zoom level between 100% and 150% to account for screen resolution and user preference. Part of the motivation for creating my own zoom button (and locking the FileMaker zoom button) was that some scripts needed to know the current zoom level. The only way I found to do this with FileMaker 8 and earlier was for a script to set a specific zoom level and record that level. When I discovered FileMaker 8.5's new Get ( WindowZoomLevel ) function, I was tempted to remove my zoom button and let users click FileMaker's buttons. However, I quickly realized that …

Below is my Data Entry Script. It works fine, so far as I can tell. It does not seem logical to me though. This... # if user presses 'Cancel' If [Get ( LastMessageChoice ) = 2] Revert Record/Request [] ... seems to need to come before I have even make a New Record/Request ? John ================================ Allow User Abort [Off] Set Error Capture [On] Go to Layout ["Entry - Monthly" (Link)] Beep Show Custom Dialog ["Enter the Issue Number"; "Enter the Issue Number, before adding any new members"; Link::gFirst] # if user presses 'Cancel' If [Get ( LastMes…

I have a database that has a number of records, and when I print one of them, I would like to go into preview mode and print the record I am viewing. Now when I go into preview mode, it lists all of the records I am currently browsing, and I need to find the one I want to print. What is the best way to script a find that goes to the current record I am working on when I enter preview mode? I want to eliminate the manual search. This may sound confusing, but it seems like it would be a simple thing.

I have a database which I would like to use a preference file consisting of mostly Yes/No data to act as switches for some options and not sure how to go about doing it. What I believe I need to do is create a new table consisting of one record and if this is the case what is the best way to consistently reference this record and its field for my scripts? Thanks in advance.

Hi I have a small database that only contains scripts to automate exporting of information from other FM Databases. On File launch I have a Pause for 20sec before continuing the default script to initiate an unattended update of exported records. Every thing works brilliantly... except when my screen saver is active and the Database is launched... Filemaker is halted and the 20sec pause is not counded down.. so my scripts do not run. I move my mouse to wake the screen saver and Scripted Database will then continue. I have also tested that when Printing a Layout as PDF during these scripts, that the screen saver being active will cause the machine to beep every…

Our company is a bit disorganized in our filing system. See we're transitioning from previous dbs to one doen via file maker. We have authoirze.it as our ordering gate way and it stores soem info, we have a php/mysql (that passes to authoize.net) for online ordering. And we have our file maker files. I was hoping to get a heads up on wherei shoud look to get me started on intergrating File maker (which we use to manually add over phone, and more "personal" subcriptions) with our automated php system.

I'm currently using FM6 (I'll upgrade when I have the funds) :/ I have 2 databases. Database-A has 2 fields with numbers already populated in Field 1. Field 2 is to be automatically populated by Database-B, Field 3. Example: Record 1, Field 1= 14 Record 2, Field 1= 6 Record 3, Field 1= 28 Database-B has 3 Fields. Field 1 is the first number in range, Field 2 is the end of the range, Field 3 is the result Example: Record 1, Field 1= 1 Record 1, Field 2= 10 Record 1, Field 3= First Record 2, Field 1= 11 Record 2, Field 2= 20 Record 2, Field 3= Second Record 3, Field 1= 21 Record 3, Field 2= 30 Record 3, Field 3= Th…

The first time a particular script is executed each month, I want the serial number in to revert to 01. Not sure the best way to do this, any suggestions greatly appreciated. (Am in the process of rebuilding our databases to FM8, but in the meantime gotta get this working in FM6) Thanks very much.

Hi. I am new to reporting in FM. I created a layout that acts as a one-page summary for a record. How do I script to go to this layout and view in preview mode so that it will only preview the current record. I have it working but it creates the report for every record in the found set. Thanks for any help.

I have a database that I am keeping track on contributions to various programs. Multiple people can contribute to a program. I want a report that will list the debits and credits and the balance by contributor for the program. I have a set of entry fields that contain: DATE CONTRIBUTOR MEMO DEBIT CREDIT Then I have Summary fields for DEBIT and Credit. Next I have a calculation field BALANCE which is sDEBIT-sCREDIT. Finally there is a summary field for BALANCE. I set up GetSummary(sDEBIT;CONTRIBUTOR) and similar for CREDIT and BALANCE. I have a column report grouping by CONTRIBUTOR and the gsBALANCE field listed but it shows the total balance…

Hi guys, Just having a bit of an issue with the import. Basically when i do an update, i have to export from 52 tables in order to update the backend. The export works fine, i just export using the layout name of each thing as the name of the exported file (otherwise id forget). Anyway, when it comes to import, i want to import using matching field names, (with the layout name -- which im storing as a varaibel -- as the filename again).. .unfortunatley it doesnt import all the fields like you would expect, it just chooses random fields (probably from older imports)... Im running FM8v3 ... any advice here, i need to have this automated because it takes to long to…

Hi Guys, Is there a way to display a message when you attempt to close the LAST window of your filemaker solution? Im trying to prevent closing my solution down accidently. Cheers

The following short script returns only "0" where I expect the desired text to appear (is that the "no error" error message?). All the other lines seem to function correctly. I wrote the script so that I could use it from any Layout in my database. The database collects all the information regarding my photographs. The script is meant to produce I.D. cards from the data to use at art fairs. Thanks for your help. My Script: Enter Browse Mode [] Go to Layout ["Display Cards" (Photo Catalog)] Perform Find [Restore] Set Field [Photo Catalog::Display Size = "8x10 on 14x18 archival mat"] Set Field [Photo Catalog::Price = "150"] Sort Records [Restore; No…

i want to restrict data entry 10 records per day how can i do that?

Hello, I am very much a newbie to Filemaker. I am wondering how to create a script that counts characters. I need to be able to type or copy & paste data into a form-like window and count letters and spaces and then output the total amount of characters. Any ideas where to get started? I really appreciate the help.

Hi, I am a FMP 8.5 (OSX) newbie, and would like to tackle a task to try and organize my contact list. I have one data base with NAME and ADDRESS in it. I have another data base with NAME and PHONE in it. I would like to have one data base with NAME, ADDRESS, and PHONE in it. The hard part for me is to place the PHONE field beside the correct NAME field in the new data base. I don't even know where to attempt this, can someone get me started in the right direction? Thanks for your time, San.

I am looking for a way to automatically open a remote database. "Open Remote" seems to only open the dialogue box. Any suggestions? :/ Never Mind... I found it in the Open Script Step

hi, am trying to make a script that transfers a field data from file A to file B. file A has a field with a value of 20 i want to copy that value to a field in file b. i can't seem to copy it to file b. anyone can help please? basically i tried to copy the value from file A then used open file command to open file B but when i try to use "go to field" command in file b, it refuses to go to that field. thanks in advance.

FMP8A on Windows XP There's probably an answer to this somewhere on the forum, but I've looked and can't find it. Problem: I'm trying to copy and paste four fields from an existing record in table "A" to a new record in (unrelated)table "B" via a script. Copy and paste seems to work fine but I'm wondering if there is a more elegant/appropriate method that would achieve the same results? I experimented with Set Field but I guess I don't know enough about it. TIA LM

I have a button defined to do something... run a script or perform and action (via button control). In this fashion, the button works fine. Is there a way to press enter on this button rather than clicking the button? I would like to put the button last in my tab order, the user activate it (via tab, enter, etc), press enter and the button execute.

Does anyone know of a way to script the creation of a new layout? What I want to do is allow the end user to create new form letters as layouts on their own without giving them full design rights. Any help would be wonderful. Thank you. Sarah

I've attached a file that works, but I was looking for a better, cleanre way. One table is a zone chart, and one table are contacts. My goal take, take a zip code 13587 and find out the corresponding zone. The Zones are referenced by 132-145, as in you only use the first number. I made a script that worked, but as I was saying, is there a cleaner way? 148_Converted.zip

Hey everyone, Sorry this is so long. I am a newbie and don't know how to explain it any better. Essentially, the main table I created is used to create and print quotes for a potential client (before they become a real client and get assigned a Purchase Order number). When I create a new record in the Main layout for a quote, I am able to select a client from a drop down menu that is tied to the Client table (which holds all client info). The two tables are linked by the clients name. I have also set up a third layout entitled Memo that is the printable layout for the quote. I created a script button on the Main layout to take me to the related record in t…

I am searching for a way to push a layout/message to a connected client (from a script/programatically). Does anyone have any ideas?

Hey Everyone, Trying to auto-email a quote to a customer. I have seen a bunch of posts and read the filemaker help but I'm still not able to get this to work/really understand what it is doing. This is the first time I'm using variables and am not understanding how to make it work. Here's the part of my script... Set Variable [$Saveas; Value:Customer::Name and "-" and Quote::QuoteID] Save Records as PDF [Restore; "$Saveas.pdf"; Create email; records being browsed] Is this how it would be done? I get it to save in "My Documents" but it doesn't save how I want it to, "CustomerName-12345", it saves as "untitled" or "$Saveas". Any dumbed down help and/or…

Hello, I have a button on my library database called 'Execute Find' that runs the script: >Loop -Set Error Capture [On] -Perform Find -Exit Loop If [Get(FoundCount) > 0] -Perform Script ["BTA_Dialog Box (Nothing Found)"] >End Loop >Go to Layout ["List View"] So if nothing is entered or no entry is found during a search, a dialog box is displayed. This is all working well, but if a search is performed and the user chooses to go back to the "New Find" layout, if they click "Execute Find" without entering anything, it displays the previous search results as opposed to a dialog box. Is there anyway to stop this happeneing? Thanks …

So I created a custom dialog box within a script. How do you exit the script if the user clicks cancel? Right now when that is clicked the script continues. I can't figure it out. Thanks

Is it possible to have FileMaker execute a script whenever a particular text field becomes "not empty"? I have a layout with a text field that is normally blank. If the user drags a text string from another field into the empty field, I would like to immediately process the request without the user having to click on a button. Is this possible without a third-party plugin? Thanks in advance.

Can anyone give me the fastest simplest way to name a "save as PDF" file using a field from the current record? All paste, etc. features are greyed out, and scripting doesn't offer any options that I can find. Thanks for your help!!

I jsut got Filemaker for my client andi got a good handle on it. Experience with Excel, SQL, C++, and PHP was a good primer. Anyway my DB started as a a per sent mailing out list. ie record 1 sent 4 books to X company on Y, if volume = 1, and issue number = 2 name = Q record 2 sent 4 books to X company on Y, if volume = 1, and issue number = 2 name = Q record 3 sent 4 books to A company on G, if volume = 1, and issue number = 2 name = Q etc but my bosses want it revampled and now anything sent out to X is recorded in a multi row text field withthe volume, issue number, sent on, etc. But i have over 500 records to resort this way it will take fore…

I have 2 fields (State,Tag). Manually I enter Find mode, enter CA in State and =NP in Tag and I get a found set with all records with CA in State and NP in Tag. Good. Then I enter find mode, enter CA in State and PS in Tag, then click Extend Found Set under the Request tab. This adds records to the Found set that have CA in State and PS in Tag. Perfect.. that's what I want. BUT I can't make it work in a Script. (I know that as written below this should extend the found set to include ALL records with ps in the Tag field, so somewhere in the script I'm going to have to figure out how to pull the State field from the original FOUND SET and plug it into the parameters …

Hi All, I am trying to make a multiple conditional list with my address table and following the Example by John Mark Osborne, still I can't make it to work or maybe I do not know what I am doing. http://www.fmforums.com/forum/showtopic.php?tid/178697/ I attached my 2 FM file 1. Crew File 2. Philippine Zips And please check my data structure Thank you in advance... Altair Forever Newbie FILEMAKER_CSI.zip

I defined a custom dialog in a script to accept an input field. I clicked on the specify button of "Show input field #1" and chose the field that I wished to popluate via the custom dialog. I gave it a label name and then ran the script. Just as I expected, the dialog appeared with the input field just as I labeled it. I entered the information and clicked on the OK button. I expected to see the data that I entered show up in the field that was was on the layout of the current window. Nothing appeared in the field. I then entered information into the field on the layout and then ran the script again. This time the custom dialog was showing the information that I h…

Hi all, Any ideas how I can generate a list of dates from two - start date/end date? I need to enter the actual interveening dates into a series of fields. Next question: [ok I cheated! :^) ] How can I get a script to add together the contents of two fields ie. on page 1 I have 'units' = 2 on page 2 I have 'units' = 3 in another Db I need the total of these two fields. These two questions are linked as they will be date-dependant. Does that make sense? Thanx as usual - in advance Pete

Forgive me if this has been answered before. I found snippets but not entirely what I'm looking for. I'm also very new at this (scripting). I'm looking to create a script that will once daily look for any records with a reminder date of the current date (some records will not have a reminder date) and email the user (user being a filed that can be used as the " To: " email option). I have Outlook setup and talking to FM as I use another script for emailing record info. I just need to know how to: A ) Scan records once daily for today's date in a reminder field B ) When found, email a user with very basic info about that record. Thanks! David

How would I script the following? I have a field 'code' [number,unique], which contains 5 digit numbers. between 10001 and 90000. At the moment less than half are being used. i.e. 10001 10002 12589 48758 56412 etc. So how can I extract a list of the numbers NOT being used? Thanks John

Hi, Why I don't get any sound alert when I use 'beep' script step. My sound card & internal speaker are both working but I don't hear any beep from FM. Any help would be appreciated. Regards, Garry

Hi guys I have made a little popup numberpad, and i want it so that when they press a button in the popup numberpad it inserts the value entered into the field where the original button (to pop the number pad) was set. So basically i need to use setfield or insert calulated but need to be able to dynamically set the target field. cant see any way of doing this, am i missing something? cheers ben

Hi there, I would consider myself a novice to intermediate FM user. I've been using it for 3 years now but have never been able to wrap my head around the whole scripting thing (I have absolutely zero experience with scripts/macros etc, so please keep that in mind when responding ) Here's my problem... I would like to have a field that tells me the number of records, in the found set, that have a particular phrase in a certain field. For example: The field called "First Name" has multiple records with people with name "Bill". I'd like the field "total of Bills" obviously, to show the total number of Bill's there are. This is my script so far: …