Script Workspace and Script Triggers

Oookay, so this should be an interesting first posting... I've got a script that I'm using for a data migration from an old, fairly poorly designed DB with no normalization and I've got a simple script to pull apart the multiple phone entries into seperate records for the usual reasons. Problem is, though it's a fairly simple script, it really slows down the process, almost tripling the time that this operation takes without said script. I was wondering if there was anyone who could find something stupid that I'm doing with it or if this is about as 'optimal' as I can make the code. Thanks in advance. Set Variable [ $email; Value:##Contact_Management_…

Any suggestions on how to move an entire record to another table? I'm sure I could copy it field by field (which is many), but is there a simpler way?

Hi, I'm looking for a way to have filemaker open a network folder on windows (not file, just a folder). I have the folder name in Clients::FolderName and the volume would be something like aaabbbccc(:FolderName) I tried a few different functions and I've had no luck. Thanks -rob

Hi all, I've lost a few hours work with this one! I've locked myself out of a DB by building a welcome script with UserAbort(off), there is a loop structure contained in the welcome script. The Exit loop has failed and now I can't stop it. Does anyone out there know how I can Stop the script? Hopefully Allan

have another little prob that i dont have an immediate answer for .... what i need is to have a drop down menu that pulls all records from another table (i know how to make this feature) ... but what i'm wanting is to be able to choose a specific (company name - in this example) and when i select it, it automatically pulls related info like phone number, email address, etc that are all specifically related to that company name (and that record) ... screenshot of what i want the outcome to look like: http://jleeinc.com/sma/referral.jpg all filled in of course so in short (to recap), i want a drop down menu that pulls from a field (company name) in a re…

I'm trying to use the get(lasterror) function without much success. The user enters a student's ID number into a g_id field. A script then runs which creates a new record and sets the ID number to equal to g_id. In the field validation I have the ID number field set to "Unique". After the new record is created I turned on error capture and set user abort to off. I added a step: If [get(lasterror)=504] show custom dialog[ "this student has already been entered into the database"] It's my intent to delete the duplicate record after (or before) the message, but I'm not getting the message suggesting the error is not being captured. Any suggestions?

this is prob easy, but aren't all things when you know how : ... i've got a database which has an area for taking notes (like for phone conversations, etc) has about 6-8 fields - client name, client ID, phone number, note reference (title), the note itself, called by, created date ... http://jleeinc.com/sma/note.jpg - screenshot and from there, i want to be able to pull specific data to essentially a list view of activity for a specific day : http://jleeinc.com/sma/callbackreport.jpg - screenshot i'm not sure how to grab the data for a specific date ... do i need scripts to call for the client ID, client name, note ref, and created date to match the d…

Hello... my question is.... I have a database where occasionally some spec information sometimes will be changed ...The problem is, I am told that may happen a few months in advance from it actually happening. I made a notes field to hold that info (the changes I need to make) and a date field to show when the change needs to happen. I would like when that date field = the current date, that it sends me that email and picks up that notes field for the body of the email. I can figure out how to do the last part, (pick up the notes field for the body of the email) but I can't figure out how to tell the computer that when the date in that date field = the current da…

Anyone know where I can get some examples of basic scripts or a good explanation to get someone started writing scripts?

how do i make the find criteria the contents of a field in the current record?

Hi, is there an effective way of moving a record (or set of records) from one table to another? Here is the situation. I have a database of exhibitors, some are active and some are inactive. On a day to day basis, I want to deal only with the active ones. Rarely do I need info about inactive exhibitors. Currently I have a radio button flag marking them as active or inactive, but every time I search for a group I have to remember to click the active flag too. I would much rather have a button that just moves an exhibitor to the inactive table and takes him out of my active one. Does that make sense? Do other people run into this minor annoyance and what is the best w…

Hi all, I need part of a script to run only if the layout is in find mode. Is there a nice easy Get( mode ) type function I can use to determine whether the user is in Browse or Find mode? Thanks in advance.

Howdy all, I can NOT figure FMP out. I am trying to help a friend and thought it would be easy to create some scripts. Turns out not so simple and I can't seem to let go. I am trying to set up an automatic script that takes the latest date in table bp. Then find all records in an unrelated table ap with dates later than that max. In SQL it would be SELECT * FROM ap WHERE date >= (SELECT MAX(date) FROM bp). First I tried Set Variable[$topDate; Value: Max(bp::Date)] then use $topDate in the Perform Find[]. When I am at "Perform Find" Specify Find Requests, it won't let me enter variable arguments - always states "The value of this field must be a valid d…

I have several fields which get acted on by very similar scripts, with small differences. So I'm trying to make the script as multi-purpose as possible so when I improve it I can just copy it and tweak a couple of lines. So, among other things, I want it to read the text in the field into a variable, perform a calculation (to strip out unwanted tabs etc) and replace the text. I have: Set Variable[$TextToProcess;Value:Get(ActiveFieldContents)] I would like to then do: Set Variable[$CurrentField;Value:Get(ActiveFieldName)] and then set field $currentField .... to the result of my calculation. But I can't see any way to put a calculation or va…

Copy/Paste was used a lot between files in FMP<7. What is the best way to "copy/paste" values between tables in FMP8? Is it Set Field? tia

Not sure this is the right forum for this question, but since the answer may require Scriptmaker, here goes. Let's say there are 4 windows open simultaneously in my solution. How can I get the names of the 3rd and 4th windows (where the 1st window is the frontmost and the 4th window is the one behind all the others?) Hope that makes sense. Many thanks--

Whenever I trigger a script to send an e-mail with data from a current record I get the following return, my e-mail client (Lotus 6.5) opens a new message is created the subject line gets populated from FMP as instructed a message is placed into the body of the e-mail by FMP as instructed but the e-mail address is not populated as instructed by FMP and then FileMaker 8.5 (via Server Advance 8.0) delivers a windows error message and shuts down. I have run this script for a couple of years on FMP 7.0-7.5 via server with the same e-mail client. I don't understand why this is happening now. Is it a problem with the e-mail, or FMP client? Is it a network i…

hmmmm I open a Filemaker File called File A. At some stage in a script I open a File B over the network. Q1: Is it possible to determine via script with which password rather than just the pw used for file A? But thats not the real problem. The real problem is: Then in the script of File A I close File B from with File Close blablbla but it remains open hidden. I have proof of that cuz when I try to quit Filemaker on B, it says A must first log out. I quit A, then B Quits okay. This is cumbersome. Shouldnt a file close break all connections to a file? YES File A has a portal to file B and one script also accesses file Bs fields, BUT if I onl…

I'm not sure if this counts a a newbie question or not...but here goes. I'm creating a survey that requires a pattern count and summary total of the specific answers...this I've scripted no problem. What I need is the ability to convert the summaries into percentages and display this beside the summary fields. I can create a percentage field, but it does not display the correct information if I place it in the summary part of my layout. example...9 boys and 5 girls take the survey... I pattern count for each result (patterncount gender,"boys") and the summary counts the number of boys and the number of girls(total of patterncount "boys"). I need to convert t…

Hello All, I have a script which has a pause and waits for user interaction. The Script opens a new window and presents a user with a list of Options and Pauses. When the user Clicks an Item the Script Resumes and does its magic. There is a cancel button that will halt the script, but The users are using the Windows/Mac Close window in the Window Title to close the window and the Script Pause is carrying over the main window. Any help with this? Thanks! -Justin

Hi Im looking for a free PDF Database implemented in filemaker for online web use. I want to; upload pdfs, have them scanned and indexed and then be able to search for them, over the web. If typed in at upload time it would also be useful to be avble to search by author, date title etc. User accounts would be a nice plus... Does anyone have experience with any filemaker based solutions? Thanx Spongebob

I'm some what of an newbie to the scripting side of FM. I have a table "Contacts" which contains a field called "Postcode" which obviously is used to store the postcode (zip code) and I want to use a button that will open up postcode location for that particular record in Google Maps. I have tried the following calculation: "http://maps.google.co.uk/?q=" + Contacts::Postcode I'm sure you're looking at this and thinking this is never going to work as is the case I might add! Also the postcodes do have spaces in between eg: "BL1 2CD", does this make a difference? Regards

Hello all I have a layout with at least one drop down box with some selections. How can I simply run a script if the user change the existing field via this drop down?

I'm building a database for my insurance office, with fmaker pro 8. It may sound to you like a silly question, but... that's how it is: I've build the dbase with, lets say, 1 table (=clients). I perform a find request (for example, based on name = john*). The found set, includes 12 records. I have add buttons in the results page list (table mode layout), so when you press the button "details" of a found record, the layout moves to the full-view mode (form mode layout), right on the record I were viewing. All I need is to be able to see ONLY this record of the found set, when I press the "details" button. I don't want the mouse roller to move me back &amp…

Hello, I have a question that is probably really simple but I can't figure it out. I have disabled most of the menu bar on the top of the screen in my database. Because I did this I have a button on particular layouts to print records. It will print the records just fine. However if you click the button and then cancel the print filemaker brings up a dialog box that says the print was canceled and asks if I want to continue the script. Is there a way to remove the dialog box from coming up? Any help is appreciated. js22

I'm trying to keep track of who edits a field and when it is edited. I'm thinking of writing a script that will auto-load user and date information when a field is selected to be edited, but I don't know how to go about setting this up.

I have a layout with the “Save records change automatically” unselected. So when the user creates a new record or makes changes to an existing one a dialog box appears. I am wondering if there is a way to piggy back a script on this save action to get FM to run my script at the same time the record is saved. The other alternative I can think of is (if possible) to totally disable the FM built-in save action in order to force the user to clik on my Save button (which would include my script). If this is possible how can I disable the automatic save in FM? Any suggestion on how I can run a script each time a record is saved/changed will be very much appreciated.

Hi all, I am having some issues trying to use the perform find function. I have tried to find information or a decent tutorial but I can't find anything that solves my problem. I am trying to take records from a temp table (used for intermediate step in import) and check to see if there is a matching record in the main table. If there is a match, I might have to update/ignore the existing record. I have unique calculation fields that I use for the comparisons. The problem that I am having is that I can't figure out how to use the Perform Find criteria with a variable. I tried the following criteria but it takes the global variable as text. Recruit Info:…

Dear Friends, I am looking if some one can help me in writing a script which could bring GPS coordinates (Long, Lati) from Palm PDA or iPaq 6515 to filemaker mobile field. Thanks in Advance for your help. Regards,

We are running FileMaker Pro 6 on OS9, OSX, Win2k and WinXP systems. FM Server 5.5 is running all the files on OSX. I need a script written that can take today's date (or an input date, if entered), check the specified number of delivery days, and calculate the actual delivery date. The problem is that the calculation will have to skip Saturdays, Sundays and national holidays (I will input national holidays somewhere else manually, into whatever type of field is appropriate). I can provide more information as needed, but let me point out I am willing to pay for this. It is not that difficult, but I just do not have time to fiddle in an app I am not that familia…

Hi. I have a column that I want users to be able to click the column header and toggle between the data sorting ascending and descending. I know that two seperate buttons will do the trick, but want to know if there's a way I can either detect a columns sort status, or have some sort of toggled status I can refer to to then run a script. Any ideas please? Greg

Hi can anyone help me I am trying to find, sort records between different dates. start_date and a End_date but I cannot get it to do it correctly. I can't not upload because its to big What gladly email someone ! :

I would like to display a window that might say,"Executing sort" with "sort" continually being updated to "delete", "search",or whatever as the script continues to execute. The purpose being to give a continual status of the execution of the script. Something like "Show Custom Dialog" but without requiring user input for script to continue, and allowing the displayed text to be continually updated. Thanks for your help.

It is late at night and when I am tired I guess I get stupid. I'm kind of new to scripting and decided to test a script with a loop in it. It is supposed to generate an e-mail to each person in the found set. Unfortunately it is just looping through the same person. How do I get it to stop running and get in to disable it? I can't exit the program. LGM

Hello, I work for a local fire department and I am trying to make a database of everyones equipment and what I have. Here is what I am trying to do... Let's say I have 20 coats, and I put in a new record and check off that i am giving johny one, how do I get it to say that I now have 19 coats available? If someone can help me out with that, it would be greatly appreciated. Thank you all, Ryan

Hi I am trying to convert a value that i have in my filemaker database into another one ie TT into 1!can i do this as a script button? also we have already got a calculation in place that changes numbers into other numbers ie.2 into 1 so that it can add up how many 2s there are but when i try to put in the TT value it says it cant find the spcified field! Please help as tearing my hair out over this!

Does anyone have any advice on how I could create scripts that do the following: First, I want to be able to flag or designate certain data entries to appear in a portal placed in another report, while not displaying the "non-flagged" data entries. For example, I have a table that tracks illnesses of our clients. I have a portal in a report but I only want the portal to display specific illnesses, not each one entered. Second, I want to have a message such as "Not Applicable" or "No Data Available" appear in a portal if there is no data for it in the database. Any ideas will be greatly appreciated.

I have a database of my students. Each student is in the database for a few clases. Every two weeks 90% of my students move on and I get new ones. The students who move on are deleted from the DB. What im trying to do is set up a unique serial number for each student so that for each class there is the same unique serial number.So for example: name class serial record 1 Jim Hitson math 1 record 2 Jim Hitson History 1 record 3 Jim hitson Spelling 1 record 4 Tiala Johnson Math 2 record 5 Tiala Johnson History 2 ect Now comes the hard part how do I get this serial number to reset every two weeks without messing up the serials for the students wh…

This has got to be one of those "it's so simple but the answer eludes me" questions... I'm trying to write a script step where a part number is copy/pasted for a Find in another file, but I want to add the "==" parameter to it for exact searching... Any suggestions??

To all who can help Being a complete novice I would like to have the following answered. I have three calculated fields. Daily calculated rate (let’s call this D), Weekly calculated rate (let’s call this W) and Monthly calculated rate (let’s call this M). In addition another field within which I would like to display a final result (let’s call this R). I have managed thus fare to get D, W and M to display their required result leaving the other two empty. I’ll explain (If D displays a result W and M does not), (if W displays a result D and M does not) and so on. This being the case I would like the following to happen. If D is not empty display D in fi…

I'm trying to set up a Send Mail script using FM8.5, Windows XP SP2, and Outlook 2003. When I perform the script "without dialog", a new email window pops up. But the problem is that this new window can't be minimized and I can't return to Filemaker until I save a draft, cancel/delete or send the new email. This is a little annoying because on OSX, and Entourage it doesn't work this way. I can minimize the window and return to FM for extra info. Does anyone know how to prevent the Send Mail script from locking the FM window? Thanks nut

Hallo everybody, I have one MySQL database, which is used via web interface (php) and FileMaker. When I try to add/change records with some of Czech or Serbian characters (like ž š đ č ć ů ů á í ý) using web interface, everything works perfect. ---------------------------------------- Character set of MySQL database: SET character_set_client = 'latin1'; SET character_set_connection = 'latin1'; SET collation_connection = 'latin1_swedish_ci'; After command “SHOW VARIABLES LIKE 'character_set%';” using MySQL_Front or Navicat, program bring to me: character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch…

I am new to filemaker. I need to write a script that will allow me to: find a keyword in one field in all records and then in all of those FOUND records ONLY, I need to enter, that is, ADD (without deleting other info within that cell) a specific text word in a DIFFERENT field . Please help!

I have a script that utilizes the export records command. If I cancel out of the step instead of continuing, I get the "Export records has been canceled. Do you wish to continue with this script?" error. What can I do to eliminate this window?

Is there any way to use a variable in the pathname of the file i'm going to import? And if I can't, I can make a windows script that will rename the file to something before importing, but how can I get the variable from filemaker to my windows script so that it knows which file to rename? Also, i'm using fm7, so if this is already a feature in 8 or above, let me know.

I've got a few complex script that run in a few windows at once and do some tricky stuff to records. The problem is that I get a lot of "You can't edit this record because it is open in another window" errors. Is there any simple way to stop this from happening, to tell a script to stop editing the record without closing the window. Would it be easier to post the entire script to find out where the problems lie?

Will someone help me with a script? Here is what i would like to do: (database attached) a scipt tha will: first - sort the field FUNDS in ascending order, then second - sum the values on field PER PeRSON until i get the equal or first greater than the value in field MIDDLE third - copy the value of the PERPERSON on a NEW FIELD from the date where i stopped. i hope this explains something something. to make things clearer i did it manually and from the database attached i must get this value on the NEW FIELD = 2,629 (this because on doing second above i get- 286 (greater than 284) and so i stopped at 47 and the equivalent value is 2,629.09. thanks. …

Hi, I need to set up filemaker 8.5 advanced with a button in my layout marked "Read CD". When pressed it will scan all the music track times and add them to the correct fields in the layout. Can you recommend a script to do this ? Any help is sincerely appreceated. Regards, Terry

Hi, I have requirement to open a till at the completion of a transaction where the keystroke equivalent on Windows XP is Ctr+F2. Is there a way to script that key combination to add it to a button or eventscript

Is there a way to automate the conversion of embeded objects (pdf files)in container fields to links only? I'm currently using fmp v6.0 but will be converting to 8.5 this year.

I have a "Master Record" with 4 portals on it. Each of those portals is related to the Master Record by a UniqueID to the Master. Depending on the users needs at data entry time, anywhere from 1 to 4 of the portals may need to be populated during the data entry event. I would like to have a script that will when activiated look at each portal/table and if a related record (to the master)has been created, switch to the appropriate layout and print it. If no related record has been created move to the nextportal/table and perform the same check and then exit after the last portal is checked. Each Master Record would always have at least one Portal Row Popul…

I have a "Display Ad?" field with the options of "Yes" or "No" I also have a container field that contains jpg file that is an image or ad for a product. How can I automatically show a message ("No ad is entered!") to the user when he or she selects "Yes" in the "Display Ad?" field when the container field is empty. Then when the user presses OK, the "Display Ad?" field resets back to "No" The existing "Display Ad?" field is currently just a text field.

I am trying to set up a database that has a field containing a risk level (Low, Medium, High). What I need is a script which will change the colour of the text in the field to either Red, Yellow, Green depending on the contents. Can't quite figure out the best way to do this.

Does anyone know if FileMaker provides a way to access an ActiveX control from withing a filemaker script?

I have a database that tracks manufacturing production. I have a text field that contains a part number (i.e. 123456). The last field in my database is one where I scan a barcode of the part number. I need to validate that the 2 fields match, however, the scanned part number contains of prefix of "P" (i.e. P123456). Previously, I had set the scanned part number field validation as a calculation Exact (part number; "P"&scannned part number). This did the job, but caused some problems during data entry. I'd like to change the validation to a script that is run after data entry. I tried creating a script with: If Exact (part number; "P"&scannned part number…

Hi Guys, Is it possible to add attachments using the open url script. I have a a pdf document stored in the following path. h:jalzdatastructure.pdf Many Thanks

I'm writing a script to find students who've not taken a specific course (Classes::Course) and have taken a prerequisite (Classes::Course). I've set up a layout for administrators to select from a value list the course they'd like to "fill" (set variable $TempCourseToFill) and then a place for them to tell me that course's prerequisite (set variable $TempPreRequisite). I want FM8.5 to omit the people who've taken the class, and find just those who've taken the prerequisite. Can I get a few ideas of how to go about this. My avenues have failed. Thanks.

Hi everyone, I have an interesting problem with a multi-user database I've written to make prodution sheets. There are 20 user using this database at the same time. When a user makes a new record a serial is automatically generated by the serial field. This is coupled to a script like the one below. Allow User Abort [off] Set Error Capture [On] Go to layout ["Num_Jobs" (Num_Jobs)] Insert Calculated Result( GetNextSerialValue (Num_Jobs" ; "Number Job Numeris")] Set Next Serial Value [Num_Jobs::Number Job Numeris; Num_Jobs::Number Job Numeris + 1] New Record/request When a user creates a record and another user creates a record lets say 30 sec …

How can I capture a field value and use it as criteria in a find script step?

I'm trying to send an email and include multiple related records in the body of the email. Specifically this is a task manager app that I've put together that consists of the following tables: Assignments AssignmentsNotes These tables are related by AssignmentID, and of course, you can have multiple notes for a single assignment. I have a button that is used to mark an assignment complete. This fires a script which sets a couple of fields in the assignment table for that assignement and sends an email to the assignment creator informing them that it's been completed. I'd like to include all the notes in this email but I'm only able to get th…

Hi, When I receive any call on my phone I want to add this phone no automatically in my filemaker database.. Is it possible? Please help me.. Thanks in Advance.. Regards, Tusif Ahmad

I am putting together an employee time off DB. I am trying to set it up so that a script will look to see if anyone has submitted a request in the past hour and then send an email to the supervisor. That email would let them know that someone submitted a request. I am looking for help to understand how a script can be running without having to click on a button to tell it to run.

Trying to make a script that looks at Field C to see if it is NOT empty. If so it copies contents of Field D to Field A, otherwise it does nothing. Can someone tell me how to write this?

I have an order table and a customer table. Sometimes it makes more sense for the user to enter customer information in the order table and then add it to the customer table if it does not already exist. However, I don't want any duplication of customer names. How do I prevent that from happening? My script does all of the copying and stuff and I can make the customer name unique so I get the confusing system message "revert field." But I know there has to be a better method. I have tired using set error capture and get last message 504 but I must not be doing something right. I hope someone can help. Thanks a bunch. Schroeder

This has probably been asked and answered so I apologizze if this is redundant. How can I script to copy the information from a current portal row in to a related database? Essentially I want to crate a new recoird in the related database from the information in the current portal row I am working on. It's the portal that is throwing me off...I can do this easily when the portal equation is not in the mix. Thank you, Steve

Greetings! I have a simple, (for everyone else), but painful (for me) task. As of now, we have our users go to a 3-ring binder behind the front desk to get the information that follows: When they require the next Invoice number to use, they go to this book, get the number(They are sequential), fill in the "Issued to", "Job #", and "Date". That's is ALL that this book is used for. They are not invoicing out of it or anything, that is done separately by the Accounting department and application that we use. Here is where it gets tricky for me. At the beginning of every fiscal year, which is October 1, the Invoice numbers start over, with a new pr…

I am trying to create a SetField script step that validates a records status and changes the status to "Renewal" if the record has expired, here is the calculaton: If ( RunSheet_PP::Date >= RunSheet_PP::Validate; "Renewal";"VARIABLE?" ) Where I have "VARIABLE?" I am looking for a value that will leave the fields existing value unmodified. Please help. Using FM Pro 8.5 advanced Thanks

Hi all, Once again, when I think I'm making headway with my self- teaching methods, I take one right across the forehead. I have a number in a text field (so that it will display a hyphen) that is 8 digits long. 12345678 This "job number" can have "sub" jobs, and we ad "-1", "-2", etc. 12345678-1 12345678-2 My script starts like this: [color:green]Case( (Length (GetAsNumber (Job Number)) = 8); (Job Number) & "-1"; That determines that the number has 8 numerals and it ads a "-1" to it. It works fine. Then, if it doesn't see 8 numerals, it asks what the suffix is here (in this case, it sees 12345678-7, and makes the next record 12345678-8. It…

This is a school record management application for a vocational institution. My problem is with the following part. I have tables: Student, Program (uses a code for each program that student is enrolled in), Supply (this is a listing of items that are given to the student based on the program and the semester they are in, things like manicure set, brush, blower, etc.). I use a portal to enter these items for each program. Now I have this working fine, the relationships are fine (the program - supply ) that is. Now what I want to do is for any given student, have another table (say newsupply) that contains the same info from the Supply table plus additional fields lik…

Is it posssible to have more than 1 Perform Find command in a single script? e.g Peform Find (look for a field match) do some processing Peform Find (look for a differnt field match) do some different processing I could really simplify a bunch of things, if this is possible. Any help will be appreciated.

Hi, I have a list layout with one field "Food And Drinks" that you can add (new record) the kind of food or drinks (wines, meat, soft drinks, veg, beers....). i did that because i want that, each time you add a kind of food or drink at the "Item" field of the invoice and you click the "ADD" button, i want that a script check if you have choose the type of service (Room service, Restaurant, Bar) for this Food or Drinks. BUT only when the "Item" at the invoice is one of the "Food And Drinks" record of the list layout. My problem is that i can't find how the script can check if the field "Item" content one of the "Food And Drinks". Sorry for the English!!!

I'm having a bit of trouble with a script that imports records from one table to another. The import order does not seem to stay the way I set it. It always reverts to "last order" so if someone does a manual import it changes the scripts import order. Any ideas?

Hi all, Does anyone know if its possible to make a script that will change the color of a button? I have some buttons that lead to related databases but I want it to be obvious whether or not a related record exists without actually having to click the button. Thanks a bunch! Suzanne

I have a situation in which a script ("Edit Invoice") has opened a foreground window and has Paused. The window is normally closed by clicking a DONE button which is defined to resume current script and to run a small script that essentially just does a Close Window. I would like to add a keystroke equivalent, so I created a script called "Done" that is bound to Command+0 in the Scripts menu. How can the Done script have the same behavior as the DONE button; i.e. is there a script step to "resume current script"? I don't really see how Pause/Resume can do it. Thanks, Chap

I have a field that compiles the record data into iCal code (.ics). Then I use the ExportFieldContents function to create a .ics file to import into iCal. But! When it exports the data, it adds really weird formatting that makes iCal unable to read it. The .ics file starts with a random "<^" and then has weird spacing format issues (I have to press the arrow key or delete key two times in order to even move the cursor). If I copy the field contents and manually create a .ics file, iCal sees it no problem and imports it. But if I use ExportFieldContents, iCal says the file is "corrupt." Any ideas on how to fix this problem? Thanks!

Hey, Im very new to this FM stuf, wondering if you guys could give me some help. Im building a database for a summer camp and having some trouble sorting. I have a CHECK BOX field with boxes numbered 1 through 8 for the 8 Sessions. Campers attend 3 or 5 days a week, so I have a RADIO BUTTON field with 3 and 5 days. I have a CHECK BOX field with days monday through friday that campers can attend. (choosing 3 or 5 of the days) I have a RADIO BUTTON field for camper grade with K through 6 and CIT. Now... I am having problems designing a SORT script to find: 1. Campers only attending 1st session (or 1 session at a time) sorted by grade and t…

Anyone know a way to suppress the spell checker dialog box when no spelling errors are found in a field. I have the spell checking scripted in my solution and it checks multiple fields. If a field is empty, the dialog box doesn't appear, but if there is a spelling error or the field is not empty and there is no spelling error the dialog box appears and needs to be dismissed. I don't want the user to have dismiss a dialog box when no spelling errors were found.

I should probably know how to do this but I do not. Is there a way I can script an automatic 30 day find based on the current date? Essentially... 5/1/07...5/30/07 I want to set up a script button that will automatically do that search. I feel ike this should be easy in the define search criteria but I can't seem to get that syntax right. Thanks, Steve

I have a database of my students. Each student is in the database for a few clases. Every two weeks 90% of my students move on and I get new ones. What im trying to do is set up a unique serial number for each student so that for each class there is the same unique serial number.So for example: name class serial record 1 Jim Hitson math 1 record 2 Jim Hitson History 1 record 3 Jim hitson Spelling 1 record 4 Tiala Johnson Math 2 record 5 Tiala Johnson History 2 ect Now comes the hard part how do I get this serial number to reset every two weeks without messing up the serials for the students who do not move on. I have to have the…

I have a form in my database that is used to gather quite a bit of information. If I wanted to create a script that would check key fields that might have been left blank during the data entry process, what would be the best way of going about it? Thanks for your help!

I'd like to create a button to show/hide fields in a database. I've searched the forum, but could only find conditionals using radio buttons and such. I want to be able to click on a "+" button to show the fields and "-" button to hide the fields. I'm not sure if these buttons should be based on a script or portal. I appreciate any help you can give! Karen

Hallo, I am looking for a way to create a script, with which I can insert a field value from another file automatically. By pressing a button in File B, the serial key from File A should be insert automatically into File B. Is there a way. Thanks Ralf from Uganda

Ok, I need to setup a script that will send an email (always to the same person) a list that is generated from my FM Pro database. So I have it set to do a find matching records, and usually there'll be 10 or so records. I need filemaker to export two fields from each record (Name and Address, for example) and put that list into an email. Can this be done within a filemaker script, or is a more complex applescript required? I'll also want this script to run automatically at 9:00 on a monday morning.

I need to pull information from the current portal row I am working in and "set" it into a global field on a different layout So far I am striking out in getting this to work right. All I seem to be able to get is the first portal row. Can anyone offer any insight as to what I am probably doing wrong? Thanks, Steve

I have created a job tracking system. Once a new job comes in we enter "open" in the job status field. Once the job is completed, I want our receptionist to be able to enter a receipt number (once payment is done) in the system and "tell" the system the job is closed - so no one can go back and change anything. Can anybody tell how the receptionist can enter (or use drop down menu ) and enter the job is closed. I just hope to know how the Methodology works. Please help. yogesh

I have a script that calls another one in a different table. Everything seems to work except the copy of field content prior to going to the next script. Nothing is being copied and I'm not sure why is doesn't. see attachment ScreenPrint2.pdf

Here is what I want to do: 1. I want a script that allows me to enter find mode to allow me to search for a contact, using a search for first and last name (the script I have for this works -- it's on a button). 2. Next I want Filemaker to enter that person's first and last name (information from two separate fields from the Contact layout) into a portal on a different layout (the Conference layout) to indicate that they are participating in a specific conference. How do I do this?

Hello to all, Concerning my data model I have the following question: My data model consists of 1 object schools and 2 other objects teachers and courses. The schools and the teachers as well as the schools and the courses are each connected through a 1-to-n relationship: So 1 school has many teachers and 1 school has many courses. (I now that here a n-to-n relationship would have been better, but for the beginning it is ok like that). As matching field I used a serial key, which means that the school is linked with teachers and courses through a key number. Thus one school has one key. In the school file this key is generated automatically as serial key …

Hi all I am building a 8 table project with a Help Text layout in only one of the tables. The users would access this layout by pressing the HELP button on the screen. The issue for me now is that this layout is in one table but I would like to be able to return back to my original screen from this Help layout. Not sure how to do that.

How can I make a script that will take my client's inputted part number into a field, and check to see if that part number already exists and then either: 1. Show the existing record, or 2. Create a new record with that part number. I would like to do this without: A. the annoying "There are no records that match that request" alert box after an unsuccessful FIND, or B. without my client needing to type the part number more than once, and: C. without needlessly creating a new record before discovering that number exists already. Thanks!

I am exporting data to a csv file. After the export, permissions of the csv file for "Group" and "Others" revert to "Read only". They need to stay "Read and Write" for everything. I'm running FileMaker Pro 8.5 in OS 10.3.9. Why is this... and how can I stop it? Hope someone can help me. Thanks, guys.

This is a new one to me. I have two scripts which now do not work correctly. The first script is a basic duplicate parent and child record (s). The parent duplicates fine, but when it gets to the child records, something strange happens. The script is a looping duplicate, change key field (using a global to hold the new key data), go back to the first record and omit. This is supposed to run until the key field matches the global, then exit the loop. It works fine until the fourth or fifth record, the the go to record/ request(First) step is ignored as is the omit step. The loop exits with only a few records duplicated. The second script is a looping set field xxx…

Is there any way to stop a user from committing a record without pressing a submit button in the FM Client? Probably know the answer to the question but... I'm just trying to avoid using global fields not that it will make a huge difference. Cheers.

Hello everyone, Is there a way to run a script by closing the active window with the "x" box on top right of window? I created a button to Validate my record but I don't want people to be able to just hit the "x" and not run the script. Also, does any one have an example or link on how to auto create a record with a serial number, but if record is not "saved", delete that record and reset the serial pattern. My serial numbers get turned into a alpha code that represents an important inventory marker for us. Thanks in advance to any help.

Hi all I have read the help file in FileMaker but I still do not understand how to imply a variable in to my FM solutions. In the post of "Returning from a hlep file". Genx posted this script. When going to the layout: Set Variable[$$curLayout ; Get(LayoutName)] Go To Layout[ Help ]; When exiting the layout Go To Layout[ $$curLayout ] . I have been trying to incoporate this into by solution but I really am missing something. I have atached a file that will better explain my question. Would you please look at the file and tell me how this can be done. Something new like variable are hard for me to understand by just reading up on them. Any help…

Hi, I would like to force the user to leave a field (in order for a script to be triggered) before the user can access any other field. Any ideas? Thanks, Bernhard

I'm new to filemaker, but am trying to automate some data entry into a table based on checkboxes selected for a record in another table. I'm working on a database of regulations that apply to our business, and in my main table I have some general regulation theme information then checkboxes to select all the regulations that theme comes up in. I then have a second table where I'm listing the specific regulation section references (so one record on table 1 results in multiple records on table 2, depending on the number of boxes checked). I have it now so that it has a dialog pop up and I enter the regulation and the section reference and it puts that in the …

Hello, I would like to send an email to our membership. I understand how to send one email at a time to many people using a script, but is there a simple way to send 1 email to everyone without showing their address using the bcc? Thanks, mt

In Filemaker Pro Advanced, how is it possible to export a record as a PDF file and have it automatically name the PDF file? Is it possible to use one of the records fields as a reference? It seems that availability now is only to export as a PDF with a constant as a file name. This would overwrite itself on each export. I'm looking for each exported record to have a unique name. Any thoughts?

Hi, what I would like to do is have a script executed everytime a user is entering a field or leaving a field (in order to generate a history or audit trail of who has done what when). So far I have seen audit trails based on evaluations (calculations) but would prefer a scripted solution. Any ideas? Thank you!