Script Workspace and Script Triggers

For sometime now I've suspected that my wife may be having an affair. You know the sort of thing. The phone rings, I answer, someone hangs up. Recently she has started going out 'with the girls' a lot and when I ask which girls it's always "Just some friends from work, you don't know them". I always used keep an eye out for her taxi coming home but now she always walks up to the flat although I can hear a car setting off as if she has just got out of one around the corner. The other day I picked up her mobile, just to see what time it was, and she went mental, screaming at me that I should never touch her phone again and why was I checking up on her. A…

I would like a button on my startup layout that when clicked, brings up a password screen for anyone (within the company) to enter their password (just so we know who is logging in). If a password is incorrect or if a person hits escape I want to make sure that (if the solution is a script) that the person doesn't just bypass the password and go to the password protected layout. I think the script below works, but a person can hit "Esc" and then just click to continue script without typing a password. Re-Login [] Go to Layout ["Work_Order_Entry" (Work_Order)] Any ideas? Greg

Wondering if someone out there can help a newbie... I am setting up a database of many items that I have for sale. Each item has about 5 pictures stored in a file folder with a descriptive name. Eg. C:ItemsAntiquePorcelainVase3557 I would like to set it up so that I can have a thumbnail of one picture and when I click on the thumbnail or a button next to it, it opens up the folder with the rest of the pictures in windows explorer. I've played around a bit with the Open URL command but again, I am a n00b so any help would be appreciated. Thanks. super

I have a database of 10,00 widgets. I am tiring to get field (widget name) of 250 records into a single field containing all 250 entries for field widget name. I

Is there an easy way to automatically fill a field with a different field from the previous record? This seemed easy to me, but I am new to this application and have had alot of difficulty figuring out the proper script steps. In my example, each record has a field "Starting Meter" and "Ending Meter". When a user selects the script, the script should pull the "Ending Meter" field from the previous record, and insert it in the "Starting Meter" field of the current record. I wrote it <unsuccessfully> as: Set Field ["Starting Meter"] Go to Record/Request [Previous] Go to Field [select/Perform,"Ending Meter"] Insert from Last Record [select, "Star…

I need to empty 3 fields when I duplicate a invoice (2 are date fields) (1 is a text field.) Is there an easy to script this. I need the rest of the invoice to remain untouched. Again thank you for the help. I need this to happen when I use the duplication button.

I am trying to move through and set a field's repetitions with a loop. can this be done? I have a list of records. The count can be between 1 and 28. The list of records changes all the time so I never know how many until the the script is ran. I need to copy some text data from the list of records into the global field repetition of [28]. So I created a script to loop through the records and set the field reps, but one problem in the setfield step. I can't set the field rep count to my variable counter. I can only do it manually. Does anyone know how this can be done in FM 7 counter = 1 goto first record loop setfield (data from other …

Hello, I am starting with Filemaker and I would like to build a simple script. Exemple : In a layout I have many record with a field called "Number of room". I would like to list all fields with no room. How can build this script ? Where should I put this script ? Your help will be greatly appreciate.

I made a website to interact with my DB. I put a button on my page to close my program. But he has to close my webbrowser to, somebody an idea how i can close my webbrowser with that button?? Renaat

How do I script a find to show records that have no data in a specific field? Thanks

I hope I'm in the right place...I'm using FMP ver7 and I'm trying to do two things. The first is, I've got a button that when clicks runs a script that does a simple search and returns all fields that match a specific criteria that is built into the script...instead of having the specific criteria say all fields that have the word "recorded" in them...I want to have that populated by a drop down list so i don't have to have a button for each report I can just have one button and a drop down that will allow me to select the variable I want to search for. Make sense? My next question is this. I also would like to have a button that would run a script that looks at a s…

Good afternoon! In my database I have a search layout with a field on it where you can enter you search criterias etc. Problem is if I'm on that layout and I go to my menu and click Records > Show all or > Browse last/first, the records appear in my search field and I don't want that. My question is, is there a way to disable the Show all/Browse etc scripts when I go to the Search layout?

I have a portal showing a list of records. On each portal row I have a button which is supposed to point to a list view of all the activity related to the specific record on the portal row. My problem is how to do a find or filter the list view to show only the details from the current record (the record being displayed in the portal row where the button was pressed) EG: CASE # | Name | Date | Court Date | Results <SHOW ALL> So, I might have many entries relating to several case numbers. I want to be able to see a quick report that shows only the records who meet the common case number criteria. I need it to do a find for the case …

I have a small db that holds all my movies. To make life simple I made a small script that puts the url together for a search on imdb.com. FM submits a valid url to Safari, but in the address bar appears // after the domain. Like this: http://www.google.com[color:"red"]//[/color] search?q=aardman+classics&ie=UTF-8&oe=UTF-8 Is there a bug in the Open url script step? Or do I have to look elsewhere for a fix. Running 10.3.6, FM 7.03 and Safari 1.2.4 TIA

If I use Firefox and go to the Google search page (www.google.com) and type in [color:"purple"]"prd-13", and press Enter, the resulting page has an URL of: [color:"blue"]http://www.google.com/search?hl=en&q=[color:"purple"]prd-13&btnG=Google+Search Using this as a guide, within my database, I created a local text field, called [color:"green"]"GoogleMe" and a button that calculates the URL: [color:"orange"]"http://www.google.com/search?hl=en&q=" & [color:"green"]GoogleMe & "&btnG=Google+Search", but when I press the button, the URL of the "bad" page that results is: [color:"blue"]http://www.google.com/[color:"red"]/search?hl=en&lr=&amp…

I would like to copy data from one table to another table. I have the following tables... t_Manage_Procedure_List ----------------------------------- KEY (auto) Name Description t_Manage_Procedure_Items ----------------------------------- KEY ( = t_Manage_Procedure_List KEY) Description t_Manage_Procedure_List = t_Manage_Procedure_Items (allow creation/deletion of records) t_User_Procedure_List ----------------------------------- KEY (auto) Name Description t_User_Procedure_Items ----------------------------------- KEY ( = t_User_Procedure_List KEY) Description t_User_Procedure_List = t_User_Procedure_Items…

Does anyone know if there are any UPS postage calculators that I can buy and plug into my Purchase Order system? Something that would use my zip code as the basis and then calculate shipping based on destination zip, weight and type of service? It seems that all the info is available at UPS.com to create such a calculation but I would rather find one that has been done and tested.

I thought I was getting the hand of scripting, but my brain has stopped on this one. I have two related tables, quotes and invoices. When a quote is sent out a PO number is received and the invoice generated on that PO number (same as everyone else). However, because of the strange way my industry works, the job can completed before any paperwork has started, meaning I only have a record of the date the quote was sent (held in the quotes table), but nothing in the invoices table. What I'm trying to do is created a list of all quotes that have been sent (i.e. will have an entry in Quotes::Date_Sent), but no related entry in the invoices table. I'm totally stuc…

Hi, I,m trying to make a Go Back script that is going to be attached to a Back button but for some reason it acts very weird AKA sometimes when I'm on a layout in preview mode it will turn the layout in browse mode... Err ok I found out why, it was pretty dumb on my part... Here's my script: Allow user abort(off) Go to layout (original layout) Enter browse mode Toggle window maximise The back button doesnt go back at all, it always stays on the same layout. How can I make the back script to go to the previous layout AND enter the default mode of that layout? Thanks

I have 3 related tables. Training Log, Athletes, Athlete Log. Training Log and Athletes have a relationship based on a Coach ID. Training Log and Athlete Log are related through a Training ID. I want to copy all of the related Athletes and create 'New Records' in the Athlete Log. I have global items for Coach ID and Training ID. I have been trying to loop through the Athletes without luck. Is this the correct way? Thanks.

hi, when you do a perform find from within a script and it finds no records, a dialog saying 'no records matching this set of find requests' appears, asking if you want to modify find, continue or cancel, i was wondering if it is possible to stop this dialog from appearing as if the continue option was selected, thanks, Barry

I need a script that will clear all checkboxes (set field to"") when a user changes the value of another field. The value in that field is changed using a pop-up menu so the script trigger would have to occur once the selction is made. Example: 1. (Field:Select_Body_Trim) = ZX5 SES (Field:FTDC) = 1 (checkbox contains "X") 2. User enters Field:Select_Body_Trim and changes value to ZX4 ST using the pop-up menu. 3. New script will set Field:FTDC to "" (checkbox un-checked)

I originally changed the color of a text field in Browse and it won't uncolor. I searched here and thousands of posts on how to color them but only three to uncolor. None of them work. One was recent CF but it put weird stuff in the field that looked like html). I tried Get CSS but that didn't work. I tried TextStyle Remove but must have something wrong. I even copied the text to a new field (which copied black), deleted everything in the field (using Replace Contents), closed the program and went back in - and then copied the black text back to it and it colored the original color again!!! Oh please help! I can't delete the field and re-add it because many s…

Hello, I have a group of records that I am ready to print. Each record has a 'notes' area for me to record anything that I do with that record, such as telephone calls, letter printing, etc... I have about 200 records to print letters to. I would like to have an automatic date and statement (Letter #3 sent today...) input into the notes section. How would I go about doing this? And, separate from above, each time I enter the note section and click to start typing, is there a way to tell FM to automatically insert today's date at the beginning of the note I am about to type? Thank you, Michael

Hello, After completing a find for a record, I would like to jump into another program to find more information. The first item: I know that I can have FM copy a field, but how can I set it so when I open a new program and hit control V to paste it? Or even better, have FM automatically paste the text for me. For clarity, I find an owner of a home in my database, copy their address, and would like to paste it into Microsoft Streets and Trips. The second item: similiar circumstance as above except with a web page. I can get as far as having FM open up a dialogue box verifying the web address, but not automatically opening up the page. I also have the same p…

Hi All, If i have a layout where users select various column heading to sort data (headings are buttons that trigger a sort script step)... I would like to be able to add to a sort... If the user opted to sort by company name, i would like to add "sort by date" to that users sort. Can i "get" the last sort criteria & add my own to it? Thanks Dan

Ive been scratchin my head for a few hours. I have attached an Excel spreadsheet showing UPS zones. I need to convert this to usable records that can be attached to customer zip codes to indicate which UPS zone each customer is in. I figure I need script because it's in a weird way. Any ideas how to take this data and make it into records? for a relation to zip codes? Pete UPS Zone Chart.zip

I am working on a timeclock module that has a simple START & STOP button. Each button activates a script that inserts the current time into a Start and Stop Field. I track the elapsed time with a simple calculation. Is there a way to insert these values with a button script and prohibit modification after the button has been pushed? Thanks for any help here. Jarvis

How do I create a global field which displays the sum of one specific field in all records, REGARDLESS of the found sets. For instance, I am creating a purchase order database related to an inventory database. Each PO would substract the correct amount of items from the Inventory and therefore ALL POs must be counted at all times, not just the found set.

Hey all: Is there any way to keep Debugs in your scripts but comment them or render them deactivated until you need them? I am trying to meticulously debug and, once a script is working, I HATE the idea of having to delete 40 debugs I may need later if a simple change is made to the script. And is there any way (plugin, maybe?) to place line numbers in a FM script? TRhe lack of these two features (or my lack of knowing how to implement them) is killing me. Thanks Kurt

Hello! I hope someone can help me, please! I create benefit statements and I have a fm database containing over 1000 records that I need to save into individual pdf's. I am trying to write a script that will start at the first record, print/save to pdf, then go to the next record, and repeat till the last record. Currently with the script I have it just stays on the first record and never loops to the second. Any ideas on how to fix it. This is what I have so far: Goto layout["Statement"] Go to Record/Request/Page[First] Loop Go to Record/Request/Page [Next] Print[] Exit Loop if ["Status (CurrentRecordNumber) = 1000"] End Loop Thanks Much

Hello all, Does anyone know what the basic script should be to add multiple new records into a table in my FM db? The scenario is that I am in one layout viewing records and I want the option via a button to create multi records in another table in the same db. I have tried many different ways to do it but to no avail! I have created a little area on my initial layout which takes a number to represent how many records to create and the type of the record I create corresponds to the current record I have selected. So I basically want to take a reference field from this record and go to my other table and create 'n' number of new records using this refere…

Hi All, When using the message portion of show custom dialog, can i use TextStyleAdd to bold some part of a message OR does that script step always use plain text?? I can't seem to get this to work... "Replace the existing purchase order number : " & TextStyleAdd ( Header::txt_POnumber; Bold) & " ?" What am i doing wrong?? Thanks Dan

I am a teacher and am creating a database for use by teachers at my school. The database will contain student records. Each student record contains a Help button to assist teachers using the database. The student records are on 1 layout, the Help info is on another layout. QUERY: could someone please provide me a (simple if possible) script which will take the teacher back to the student record they were looking at before clicking the Help button on that record. At the moment, the Back button on the Help layout takes the student to the first record of the layout that the student records are on, and not to the record the teacher was looking at. Assistance …

Hi. I keep a fairly elementary database for a club I belong to. I regularly send out emails using a Filemaker script. The mail is generally sent to all records in a set. I use Filemaker 6, OS X, and OS X's mail client. The problem I have is that Outlook users frequently don't get the text of the mail. They get, instead, a blank email. If I put our logo at the top of the email, they'll sometimes get that and not the text. It's never been a problem for anyone not using Outlook, and doesn't seem to be a problem for everyone using Outlook...only some of them. Anybody have any idea what's happening here (either on my end, or on the recipient's end) and what I can do t…

I may be going about this all wrong, but... I'm loading an Invoices DB with an Applescript. The AS creates one entire Invoices record (as a list), and then writes it to the DB with the following statement: create new record at end with data myFMPRecordList Invoices DB contains an Invoices_ID field. I want FM to calculate it for me, so I defined Invoices_ID as an auto-enter serial value. 'myFMPRecordList' contains a null string ("") item as the value for the Invoices_ID field. After the 'create new record', my AS invokes an FM script to calculate Invoices_ID. The script is basically just SetField[invoices_ID, GetNextSerialValue(Status(CurrentF…

I am trying to make a script that will check for duplicate records by checking fields in a specific order. Sort of an IF then script for scheduling. The fields I am using are Date, Time of Day, and Venue. If there is a duplicate record than I would like a message box to pop up. Thanks for your help.

I am trying to perform an external script. After I specify the related record, no scripts appear that I can choose from. Any idea why this is happening. Thank, Mark

Ok

Is there a way of when entering a numerical value into a number FIELD, (say 5) and the equivalent number of New Records be created? Is this possible? If so how is this done, via a script or a simple Button? corey....

Need to be able to extract from a selected set of records from large file random records and create another file from the selected records. Will use this function from time to time with different total records expected i.e. need 4000 random records from the universe and another time would need 8200 records etc. TIA

Hi all: I want to increment the duration of a trip in .15 min blocks for billing. I am currently using this equation: Hour(TripTimeCalc) + ( Case ( Minute(TripTimeCalc)/60 >= 0 and Minute(TripTimeCalc)/60 <= 14 ; 0 ; Minute(TripTimeCalc)/60 >= 15 and Minute(TripTimeCalc)/60 <= 29 ; 15 ; Minute(TripTimeCalc)/60 >= 30 and Minute(TripTimeCalc)/60 <= 44 ; 30 ; Minute(TripTimeCalc)/60 >= 45 and Minute(TripTimeCalc)/60 <= 59 ; 45 ; ) ) ... but it returns 0 mins no matter what is fed in. (I should also mention that the field TripTimeCalc is derived using: If ( DayBreak …

I'm looking for some way to change the contents of a field similar to the Set Field script step, except I want to use a calculation to determine the target field instead of choosing from a list. Is there a way to do this in FM7? Thanks for your help, Michael

- I have a button on a db. - When the button is clicked it opens a file (via a script). - The file relates to the record number (so if it is record #5 and you click the button a file called "5.pdf" is opened via the "open URL" script step) the question: Is there a way to check if the file exists? for example, if the file doesnt exist Id like to give the user a message ( "Show Custom Dialog") thanks!

I have two fields (each in a different TO) that can contain names of several items (0-20 or so). I want to make a script or calculation that will look for and identify any element in one field that may be in the the other. Previously I used a relationship: converting the substituting the comma and space with a paragraph mark then relating the fields to eachother. Then a script looked at the relationship; if the related field was "not empty", there must be a match, then a dialog box was activated informing the user. Is there a way to do this with scrip or calc function. I can only think of a looped series of "if pattern count" statements that goes to the first word…

I think this is quite a generic task. For example, we sell our Products in Packages. When we place a new Order, we want to create a list of Line Items for the invoice. There might be six Products in the chosen Package. We then want to create the corresponding six Line Item records. In the past, I followed this approach: 1. Go to related records (show only related) [show the 6 Products in the selected Package] 2. Import from the related table [import 6 records from Products into Line Items, taking key data with you] 3. Replace key [Replace Order ID in Line Item records with the number of the current Order] I wonder if there is a better way. Is there…

I want to print Letter No. 1 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 1 Sent, today's date." Later, I want to print Letter No. 2 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 2 Sent, today's date." I want the messages to accumulate so I will have a record of all letters sent to each client. I always appreciate your assistance. Maxwell Morlay

Hi, I've got a database for tracking asset movements. There are multiple entries for each asset and my problem is I would like to create a report whereby we know where each asset is at that moment in time, i.e. deployed, repair, faulty etc. I have got the report to work for all asset tracking entries but it is only required for the latest (date) entry for each asset. Is there a way of applying a script to the layout so that only the latest occurence for each asset is taken into consideration? Hope this makes sense - any help greatfully received!! Thanks

Does anyone know how to use the new features of FMP 7 to go to execute a button script after you hit enter/return in a field. I am trying to execute my login script(button) after the user hits enter/return after they type their password in to the field. So from a field -> enter password (text) -> execute button script. I know you can use tab, return, and enter to go to another field but how would you do this to execute a button script ? -Travis

Greetings All I'm sure this has been answered, perhaps I'm not searching for the right keywords. Anyway, wondering if someone can assist. I added a new text field to an existing database. The default value is "No." But, when a record is approved, the user changes this value to "Yes." This condition applies for all new records. Now here's my problem, I need a simple script that would update the other 500+ records currently in the database to reflect "Yes" in this new field. Note the field is blank for these records. Thanks in advance! -steve

I am not sure what fm function I would use to accomplish the following. I have a text field 'list' containing a list of numbers, separated by returns, that can be as long or short. 5 2 98 34 21 56 34 10 6 I need to make a calculation that will go to one of these numbers in the list replace it with something and then any numbers below the one I changed will be erased from the list. Example: I want to replace the number 21 in the list with 14. So the new list will look like: 5 2 98 34 14 I know how to go to the number and replace it but how do I erase all the number below.

I am trying to use a FileMaker script to e-mail several people in my database but the "Send Mail" tool (or whatever it's called) only allows me to specify the 'To:', 'CC:', 'Subject:' and 'Message:' e-mail fields. I want/need to also specify the 'From:' field as well. Firstly, where does FileMaker (Send Mail) get the information that it pust into this field? Secondly, how would I be able to specify the contents of the 'From:' field using FileMaker (& Send Mail, or other scripts)? Thanks...

...there's no end condition on your loop: Set Field [ Post Count ; 0 ] Loop If [ Count(InterestingThreads) > 0 and TimePermitting ] Perform Script [ "Post Reply" ] Set Field [ Post Count ; Post Count + 1 ] End If End Loop I think I need more hobbies.

I'm using filemaker 6 for this project. this is a billing database where billing information is tracked on a weekly basis. made searchable by "week ending" date. one person will be billed multiple times a week, month or year. so for their info we have fields "lname", "fname", and "id" per se. if i make a layout with those three fields in a row, and do a list, i get all their names, but for EACH and every record. what i need is a list of current people being billed (by just doing a find for a certain date) and then listing all names with id's however, don't need 67 sally jones in the list. i only need 1 sally jones, and so forth, tom smith, etc. if anybody co…

I've just created a pop-up calendar in FM6. I created it before I realised there was an almost identical thing called Calendar Snap. Well I like my version better. -) The idea being (you've all seen them before), a date field in an FM database has a small calendar button next to it. press it and it fires up a mini calendar. Scan through the months and click on a date. On clicking; the calendar closes and the selected date (which is now in the clipboard) gets pasted into the date field of the original database. Ok, i've done the hard part and created the calendar. I can call the calendar by pressing the button, which selects the appropriate external script, …

Hello, I need help. But the first, I

How do I write a script that uses a teacher ID, which is their last name plus the last four digits of their social sec. # to find only the students that are assigned to them. Have a student database with field called currentTeacher; a teacher database with all the teacher IDs; a report card database that has the currentTeacher field. I want to write a script that when the teacher enters their teacher ID it goes directly to the report card layout with their students. Example nardini3456 would go to the report card layout for students belonging to Mrs. Nardini. I'm new to FileMaker and would appreciate any help. thank you. (FM 6 and 5.0)

I am very new at scripting and wanted to know if anyone could give me a hand on the calculation that I would need to send an invoice. I have a sales table, lineitems table, and a customers table. I would like to send an invoice to the customer. I know some easy calculations like: "Dear " & sales::cust_name & ","&"

Hi Everyone. I'm a little stumped. I'm trying to do the following with a script. I've got a text field that is assigning a number like so: 1 2 3 etc. Is there a way to remove, the number 2 without doing it manually? Thanks for any and all help

I'm Developing a Cash-Register type database... and I need the user to be able to enter the data, and be able to edit this until he/she clicks a 'Complete Sale' button. Then this information will be entered into the actual database. If a record needs to be edited, a manager with the correct name/pass can access the main table and edit the record. Any Ideas on where to start on this one?? I was thinking of using a temporary table to pull in the information, when the button was clicked the info would be transferred to the actual database, and delete the temporary record, and ur back to square one... Problem with this is I'm stuck as how to transfer the record…

hey all I am fairly new to filemaker and I am wondering if anybody can help me, what I am trying to do is take text that is in a field in one database and put it in another field in a different database, but I just want it to happen when a user clicks a button thanks in advance

Hi, I am trying to create a script that sets a repeating field. I first need to clear the field (all repetitions). I know I can select go to field and pick the repetition manually, in which case I will need 25 set field script steps for all 25 repetitions. I know there must be a way to do a calculation that will take me to the next repetition. I am trying to figure out how to do it with the Get(ActiveRepetitionNumber) but I can't get my head around it. Can someone help? Thanks

I need to provide a magazine with Mac and Windows demos of a software product we are about to release. The runtimes are created using FileMaker 7 Developer. I have implemented numerous time bomb scripts on previous applications, setting global fields and incrementing, but I was wondering if there was a easy secure way without too much craziness. I was thinking about after x amount of days a script runs and changes or deleted the users account so they no longer have access to certain layouts etc... Does anyone have any ideas, sample files that may be helpful? In kindness

I have a found set that I want to update the date field. I will be using a button to start the script. How do I do this easily? TIA Ivan

I am baffled, I have a solution that has a multy level system. that is to say I have a job table which has a portal to a line item table. The line items (called Descriptors) also have a line item file attached to them. I wrote a script that would take all the piece parts from the Descriptors and place them into a separate file called BOM. When I run the script with the debugger with some test Descriptors, it works flawlessly (although slowly,I am sure there is a better way ) but when I do it with a real job consiting of hundreds of Descriptors, the script seems to miss some items and set some incorrectly. The volume couldn't possibly be the problem. I am pulling my h…

newbie to fmp - using version 6 - have a client that uses fmp - I'm experienced with msaccess, c#, .net. Not trying to be critical, but I'm having trouble with what seems to be a much more restricted set of commands/options than what I'm used to with access and using vb code. It may just be I don't understand the proper script structure/usage, etc. I've seen the examples posted how to create a 'find' script. In version 6, the set field command seems to be where my problem is --- Before I beat my head against the wall way to much, are there restrictions with scripting a 'find' in version 6? Will updating to version 7 be more user friendly? My example specifical…

Here's my problem, with my database when people want to perform a find, the layout swtiches to the main layout. But it doesn't work with all my layouts, it only works with layouts that are in browse mode, those that are in preview mode (printable ones) don't switch to the main layout, here's my script: Set Error Capture (On) If("Status(CurrentMode)=0") If("Status(CurrentLayoutName)="List" or "Help" or "Labels" or "Table"") Perform Script(Sub-Scripts, "Go to Main Layout") End if Enter Find Mode(Pause) End if ..... The layouts that are in browse mode are List, Help and Table but my Labels layout won't switch to the main layout wh…

Hey guys, I am looking at my script for a while now and I can't get it to work. I believe there is nothing wrong with it, but FM shows one record instead of none (in my case, since I have inserted values in all records). I did a found on a table and my result needs to be broken down to when a particular field is empty. I want those fields as a result. The script: Go to record[first] Loop If [not IsEmpty (field1) or field2 = "blabla"] Omit Record End if Go to record[next; exit after last] End loop If I read the above script it tells me this: 1. Go to the first record of the found set. 2. check if field2 equals "blabla", if true...omit recor…

I would like to be able to add fields to a database with a script. I am trying to track research projects. When I add a new project, I have to a add a field specifying whether that study is active/inactive, it's human subject approval number, a date for when a participant was tested etc. I was hoping to use scriptmaker to open define fields, add new fields based on the new study's nick name e.g., [nickname]_irbnum. There're about 8 new fields for each new study, so automatizing would be great. Also, this method would assure a uniformity in field names across different studies. Any and all help kindly appreciated, as always.

I am using a script step for Sort. When a sort is done, the database jumps to the first record. Is there a way to have it stay on the record it was on when the Sort script was run, or a script step to at least have it return to the record is was on previous to when the sort step was run. Larry

Hi, I have a FileMaker 6 solution on the Mac that exports a large number of htm files via xsl/xml export. I have created an AppleScript called by FM that changes the name of the files as it exports. This is below and it works very well. However, now I am migrating to a Window computer. Everything works, except of course for the AppleScript. Does anyone know how I can do what the AppleScript script does below but using VB (assuming that VB is what I should use)? I guess I need some who knows VB and perhaps enough to AppleScript to understand below. copy cell "NZSCO99_5_ID" of current record to htmName tell application "Finder" set name of file "Macintosh HD:Docu…

Having some issues! Saved program on a disk for staff to load onto there computers. The program having inconstancies with it's scripts. On one person machine (same os), everything works fine, others they can't use the export script. Someone else, everything works well with the exception of certain records. I did write it on osX but even those who run X are having problems as those who run os 9.2.2. all have filemakerpro 6. v4 Is this file corrupt? if so how do I fix it? Thanks in advance for your assistance.

Hi all In an order database i need to pull out some statistics namely how many of each products was sold by our different sales persons. The result should be something like: Pete; Product_001; 2 pieces Pete; Product_002; 5 pieces Brian; Product_001; 5 pieces Brian; Product_002; 3 pieces etc. Seller is in a value list and product is in a product number field where the productnumber is increased by 100 for each iteration eg. 101, 201, 301 etc. I need to figure out how to loop through the value list containing the sellers (whith Get(ScriptParameter) maybe?)for one product and then go to next product and do the same seller loop. Any little cl…

Is there a way to have a script go to a specific field, and enter the number two '2' to the end of what ever text is in that field? Larry

Is there a way to implement "Go to Record/Request/Page" and have my own words instead of the "Specify Number" dialogue box with "Go to record x out of y"? I want it to say "Go to period x".

Hi, I'll try to explain my problem though cannot guarantee a clear one. I have a layout on which users will enter results for a questionnaire using radio-buttons, there is a text description of the requirements for each button within the question field next to each field. There is however a more detailed description of the requirements to answer each item on the questionnaire. However, I only want to show the more detailed description if the user were to click a command button. I have the more detailed description for each question in a separate, related table. Upon clicking the command button I would like the following to happen: The primary layout for…

When doing the Move/Resize Window script step the size of the window appears to be the entire window, as opposed to the contents of the window. If I have windows contents size X by Y, what do I have to add to the height to include the size of the title bar and the footer bar (with the zoom icons and mode selector). And what do I add to the width to include the size of the Status Area and the scroll bar. Are there system constants defined for these values? I doubt the title bar or scroll bars are the same pixel size in Windows and Mac OS and it would be nice to have a cross-platform solution. - Jeff -

Hello, Does anyone have any experience of a script that sometimes works then stops working at random times? I have a script which runs through a few fields duplicating some data and inserting the text 'updated' into another field so the users know it all works. Thing is, sometimes the script stops working for no apparent reason. Opening and closing the script in scriptmaker. Or reselecting it in perform external script also seems to 'wake it up'. Does anyone have any idea what could be causing this? I should also point out that it happens on PC and Mac clients. Thanks for any help.

Is there a way to have a script that would duplicate all the records in a current found set? So if I have 50 records in my database, perorm a find, now have 5 records in my found set, then I want to run a script that would duplicate just those 5 records in the found set. Larry

I vaguely recall a discussion at a DevCon about speeding up served files. I dimly recall something about Insert being faster than Set Field. I think it had something to do with Set Field pushing the data across the network twice? Does that ring a bell with anyone?

I am new to filemaker and would like to know how to write a script, which would perform the following. A field named status has 2 different entry

I am using Filemaker 5.5 on both macs osx and windows 2000. I have made a very basic script to copy and paste data from one field from a master record to related records. It works fine on the macs, but only sometimes on the PC's. It it a problem with the version on filemaker, will upgrading help ? Or is there a solution to my problem ? Help, please.

Hi, I get download regularly of text field like example in subject. I can get the time with GetAsTime(MiddleWords ( text ; 4 ; 2 )) and even grab the time zone with RightWords(text; 1) but Im having trouble on the date. They have the months as 3 letters and I don't want to hard-code this unless I have to, ie, If(MiddleWords(text; 2) = "Sep"; September; If(MiddleWords(text; 2) = "Oct"; October) ... etc. through 12 months. Having trouble foruma like - if it equals first three letters of MonthName ... I think i can get it, if I can figure the month part because day is LeftWords(text; 1) and Year is MiddleWords(text; 3; 1). But I'm also unsure if I'll have …

With a script, I'm trying to cycle through external class records and distribute them to three tables based on Grade. The external records populate find and I create new records OK, but they are empty. Attached is a sample file. Can anyone help? Thanks SMSScheduling.zip

Please could someone tell me how to create a script which will automatically create a related record in a separate file? I have two files, Parts and Purchase Order. I would like to create a script which will allow me to create a Purchase Order record after a Parts record is created. At the moment I am having to fill in the details in Parts and then have to go to Purchase Order, insert Customer ID, select "Machine" from a value list, the information (order no., part no. etc.)appears in a portal. Is there a way to do this part automatically? Many thanks.

Perform un-supported script steps with IWP using WebTrigger! FMWebschool would like to announce their new plug-in "WebTrigger" WebTrigger allows users to perform un-supported script steps from the web. WebTrigger allows you to Print, Export Records, Send Emails, Open Files, Close Files and more. WebTrigger even allows you to perform "MULTIPLE" unsupported script steps. This plug-in is currently available for Windows users. There are many creative options that will be available with this plug-in! You can download the demo files and user manual at: http://www.fmplugin.com online movies available. More movies and example files of really neat …

Hello, Could anyone tell me if it's possible to copy data from one field to another? At the moment i'm using three tables: The first one, named AuditDetail, contains the following fields: ADid, Categorie, AuditAspect, AuditWaardering1, Auditwaardering2, Auditwaardering3. AuditDetail is linked to TraineGesprekken, containing the following fields: TRAid, TRid, ADid. The last table, linked to TraineeGesprekken, named TraineeGesprekkenDetail contains the following fields: TRAid, Categorie, AuditAspect, TraineeWaarderingDet. My problem is that I can't find a way to copy the data from the Categorie and AuditAspect fields from AuditDetail to Catego…

Hello All, I'm scripting the export of payment received information as a tab-delimited file to be imported into Quicken, but it's not working. The export ends up with all information except an amount. The qexport amount field is defined as a calculation, type text, and "T" & "-" & GetSummary(sum.victim total, victim) as parameters. I also need to check for duplicate victims before the new records are created in the export database as we, of course, want to only send one check to each victim per month. So far the script reads Export to qexport.fp5 Perform Script [

Using the "Send Event" script step, I am trying to get this information passed to the "C" drive. Any idea what I am doing wrong in this code? cmd /c Vol C:> volume.txt Thank you for your help!

I am not sure about the way Filemaker handles Set Field commands for related tables in scripts. With FM7, we are instructed to Commit Records whenever the Set Field command is used, or else changes will not be recorded. But what happens when you issue a Set Field command on a related table? My situation is this: I have an Items Purchased table and a Clients table. When a client purchases an item, I run a script that creates the item record and updates the client's account balance. In the past, I simply had: Set Field["ItemToClient::AcctBal"; "ItemToClient::AcctBal" - ItemCost] Since the record was in another table, the update was automatic. Now, however, i…

Is there a way to execute a script that is named in a database value? I am building a Reports module. This reports module has a descriptive table that identifies the Layout for the report, whether the report is to display to the end user (on a separate Execute Report layout), and the script to execute before displaying the report. This last is my attempt to work around FM's inability to build a report on an SQL-type query (e.g. "SELECT * FROM people WHERE start_date <= 2002-01-01 ORDER BY start_date DESC"); in FM, the only way I have figured out to accomplish this is to create a script that performs the find/sort, and then displaying the appropriate report. However, I …

I'm trying to have FileMaker control iTunes as I have on Mac via AppleScript. Does anyone know if iTunes for windows accepts DDE commands? Does anyone know if FM will support COM in the future as the iTunes for Windows SDK supports this. Thanks.

Is het possible to execute a script I have made at a certain time every day? I'm using windows 2000. I allready made a script Now I want to execute it at a certain time every day. Is ths possible within Filemaker? How? Or do I have to make a script in Windows? How? I would really appreciate any help.

School system using 5.0. 5.5 and 6.0 with a combination of Macs and PCs. Have a report card database where the teacher logs into their grade layout. Layouts are restricted by password. They do a FIND on the teacher field (a related field in the students database) to get their students. Then proceed to grade the students. We were having trouble with teachers being able to go back the click on the teacher field (which is a drop down value list of the teachers in their grade) and clicking another teacher while in browse mode, thus messing up the class lists. I added a second teacher field = to the related teacher field. This is the field they now do the FIND on. It is not m…

I have a script that runs every three minutes to check for changes in the data. I want to be able to run a specific script at 7 am everyday triggered by this script. I was using If Status(currenttime) >= "7:00:00 AM" perform script "a". Unfortunately, it does absolutely nothing. I had it checking to see if it was past 7:03 so it didn't run all day and I took that out for troubleshooting. It had no effect. Still nothing. I'm using the status(currendate) to run a script on the first of every month and on mondays. For some reason I can't do a certain time. Any help would be greatly appreciated. Thanks!

Does anyone have a suggestion for backing up my data that is automated? I'd like to schedule a backup from within filemaker every evening. Anyone have any ideas?

Hi all My welder's qualification form has two colunms for entering two different welding processes. When a process is chosen from a pop-up list, Two other lookup fields are populated. Sometimes a welder is qualify using only one process and sometimes the operator populates the second process field invertly and then goes back and delete the process but the lookup fields have been populated. I have tried doing a relookup but i must not understanding which field must be relookup because the lookup fields stay populated. How can i unpopulated the lookup fields. Thanks in advance Lionel

Hey all: Is it possible to insert new records into table_A from inside a loop of a found set of table_B, using data from the found set of table_B to populate fields in table_A? Example: I want to loop through a found set (table_: of clients to whom invoices should be sent. For each distinct client I want to create records in an Invoices table (table_A) that contains the current invoice number and the IDs of all line items for that distinct client. So my Invoices table would look like: Inv_ID | InvNum | LI_ID 1 1001 719 2 1001 721 3 1001 725 4 1001 726 5 1002 12…

Does anyone know if it is possible to make certain menu commands (i.e. New Record) call a script instead of the normal menu command. Or is it possible to deactivate them. Using the Access Privilages does not work, it wont even let a scrpt create a new record. Thanks David

Hi all: I am using Copy() and Paste() script steps to copy data from one global field to another. For a short while the Paste step would paste whatever old data I had lying around on my clipboard, regardless of what field was Copied. Now it appears to be pasting nothing at all. I have debug statements placed to show the value inside the global to be copied, and it shows correct data, but how can I (if at all) debug/output what FM has placed on the clipboard with the Copy step while inside a script? Thanks Kurt