Script Workspace and Script Triggers

I have MOnth in name format and year in number format. I need it to create a date field for sorting purposes. I tried several different methods none have worked is there a way to get "January" "2005" to read 01/01/2005. Day is not important month and year is all I care about. Thanks Tony D.

Hi gang, I have a script that uses a variable to determine which fields contents are to be set into another field. For now I have the following script: If [right ($$v_Diagram;2) = "01"] Set Field [iSP::Diagram_orig; ISP::Photo 01] Else If [right ($$v_Diagram;2) = "02"] Set Field [iSP::Diagram_orig; ISP::Photo 02] Else If [right ($$v_Diagram;2) = "03"] Set Field [iSP::Diagram_orig; ISP::Photo 03] I have 20 different possiblilities. I would like to have a single script step that would set the field using a calculation. I know there is no "field by calculation" step, is there another way to do this? Thanks

the set field part of the script never works..and it is very crucial to the compeletion of my project

Ok I have just purchased SMTPit Pro. I see the plug in in my fm8 folder... But now how do I use it with a script... every time I use the send mail function it opens outlook... Also, how do i get it to put formating in my email? Example: I have number fields that look great with $ signs and , as seperators, but when I email non appear? Can some one point me in the correct direction...

Hey Everyone, I've been trying to come up with a script that will easily move the outstanding balance to a field which shows how overdue it is.. (i.e. 30 days, 60 days, 90 days). Haven't been able to figure out how to do this so far though, wondering if anyone has any ideas at what seems like should be a simple function of Filemaker. Thanks

Hello, I'm not sure if any of you will be able to help me with this.. I'm not sure if it is FM7 or if it is my mail program that is the issue. In order to reply to inquiries faster and more efficiently I set up a "Send Mail" script which automatically places the email address and subject into the mail fields. This saves me time from copy and pasting over. But, when it creates a new mail message it doesn't create it with my set stationary (I'm using Microsoft Outlook). When I create a new message directly from Outlook my stationary works, just not when I do it through FM7. Any ideas on how I can get the stationary to appear when emailing through FM7? …

I'm trying to compose a script which will perform a find and if records aren't found letting the user input their search criteria again. I've managed to get it to put up the error message if there are no records found but seem to have an eternal loop if there are records found. It seems my Exit Script If step is wrong. Basically I want to exit if records are found but just can't work out the syntax. I've attached the script for those who can help (when you've stopped giggling at the amateur!) : :

Is there a way to make a script run auto everytime you open a layout... I know there is an easy way by putting the script on the script that opens tha layout... but there are so many different way to the same layout I thought there might be another way... Example: I have a script that will check certain boxes when a certain user has opened the layout... and when other users open the same layout nothing is checked. Need like a auto run of a script. Thank you, Joseph

Hi Gang, I am attempting to import a folder of images to one of my tables. I go through the "Import Records" step, and select "Folder" and images. I am only storing a reference to the image. What I also need to do as I import the images into the table, is to automatically assign an ID field to each new image/record, that comes from another field in another table. In the one import process, all the images will be assigned this same value. But on another import, the ID may change. How can I achieve this with Scriptmaker. I am new to the FM world so I apologize if this is too basic a question. Many thanks, Nando

Hi - I am using FM Dev 7. I have a script that exports a video file within a container field to a temporary file. The script opens that temporary file in its native application depending on the video's file extention. When the user is done viewing the video, I would like the temporary file deleted from its exported destination. This is a cross platform solution. Anyone have any thoughts on how to delete the exported temporary file in the native operating system (OSX or XP)? I think that the variable function within FMA 8 would be able to do it (??), but I am using FM Dev 7. Any help would be greatly appreciated. Thanks - AAHH

I have a certain field that carries tax sale amount. I need to be able to go in and put in a certain start date and end date that will give me every record witin that range with the tax amount. I do not have a portal set up since I am still learning FileMaker Pro. How can I do this?

Hi, I am writing a script that allows the user to copy the contents of the active field to the same field in every other record within the found set, using "replace field contents". However, I am having a little trouble getting the script to automatically identify the active field. I found the get (activefieldname) function, but I don't know how to create a script command to go to this field in the next record. Anyone have any thoughts? Marcel

In a script, I want to loop through the open windows and set a global field to information about each window size and position. This works just fine as long as all the open windows belong to the file running the script. However, if you hit a window from a different file during the loop, you can't gather ANY information on that window. You can select it and it comes to the front, but you can't even get the window name. If I could get the file name I might be able to use a plug-in to run a script in that file, but I can't even get that. Anyone have any idea?

What is the script step (is there one?) that will automatically check a checkbox? Thanks.

I have changed date format (to European format of yyyy.mm.dd)when converting an application from FM6 to FM7. There were some dates which did not display correctly when I looked at them and they were those which had spaces between the elements. So I wrote a script which looks for spaces in the 2 or 3rd position of the date field and replaces it with a slash "/". The script runs and then converts the date but replaces the year with the current year. For example: 12 19 2001 becomes 12/19/2005. What am I doing wrong?

I search the forum and tried several of the scripts mentioned but I can't seem to find or create one that supplies the information I need. I have a membership database that includes [color:purple]Date Joined and [color:purple]Date Dropped fields. What I am trying to do is to find all that joined between a certain date range. Any advice would be greatly appreciated.

In a portal layout I have set the line ID field as a serial number in increments of 1. When I request a new record, I would like to reset the serial number back to 1. How can I do this ??

I am new to FileMaker (using the trial version) but have done some db programming over the past (DB III+, Paradox for Win, etc.) I am trying to set up a script to automatically import some excel files (that will be updated daily) that have some unique attributes: 1) I do not need every column (field) to be imported 2) the first row of actual data begins on row 5 (ie, don't want to import first 4 rows with erroneous data) 3) There will be 19 sub files, each with a unique file name and I would like to somehow add the filename as a new field with the filename in that new field for each record, so that when I combine all 19 files into a final single file,…

I have not worked hand on with FileMaker until this week. This is our situation. We had a developer create a program in FM that our Mail dept uses to make mailing lists. They really like it, but they are currenlty entering in all mailing info by hand. We are now working with the Central IT department, and have come up with a way of trying to end the manual entry. Once a week the Oracle running on the Mainframe will spit out a CSV file with the information. This is where I need some help, and I do not have any FM experience. How can I map that data into FM? Also with this solution, we want to come up with a simple way for our end user to do the import without us ha…

I have a script to save found set (see below). I don't want user to enter and save duplicate set name. So I want to add a function to check whether the new set name is already exist or not. Please help. New Record/Request Show Custom Dialog [Enter the set name] If [status(CurrentMessageChoice=2] Delete Record/Request[No Dialog] Else Select All Go to Layout Paste [Record ID] End If

can you attatch script steps to custom dialog buttons?...if they hit ok the script continues and if they hit cancel it ends?

Hi, I'd like to make a script that allows me to go to the field set in the script parameter. There doesn't seem to be an option to specify the field that you're going to as a calculation in the Go To Field script step. Any ideas? Thanks, Andrew

I am working on an FM7 database. I have 3 related dbs and I cannot succeed on a script that will take me from database 1 to a specific layout in database 2. Any suggestions/assistance will be appreciated.

OK I have 2 files. File one: contains all data from the customer Contract and all the terms of said contract. File Two: Contains a billing overview sheet. I need the data from File One to go into File Two. Now for all the information on who, what, when, where, and why! File One has 6 Tables. Ad Table - Contains all ad information from months running, size of ad to number of zones running. Company Information - All Customer data related to the physical address and sale rep who sold it as well as what magazine it is running in. Billing Information - All Customers Billing information. Contact one - All personal data about contract signer us…

Right, im sure this isnt that complex (but i can be a tad daft sometimes), i have 5 fields, single checkboxes with a value list set to each with the only option being "yes" within the checkbox (i know you can have one field with 5 options ive just being having trouble with the if statements). If certain checkboxes are selected i need a calculated result to be entered into another field. I.e. if field one is checked, add in text specific to that field. If field two is set to yes add more text to the previous text entered as a result of checkbox one being set to yes and so on. So i guess my final question is how would i setup a script to check which of the five …

I have a text field, "ID", that is set to auto-enter serial numbers in the format "pt00001" and increment by 1. It works great when adding new records. When adding new records the field increments by one in the format I specified. ie, pt00002, pt00003, etc. The problem I have is when using the Set Next Serial Value script step on this field. I use it in a script when certain conditions exist. I use a calculation like: ID + 1. So basically I am saying set the counter to the value of the ID field on the current record plus one. The problem is that when I use the script step it returns a straight number without the formatting that I wanted. For example if the I…

When I run a script in FMP7 I am unable to access the database until the script completes. This is especially troublesome when using container fileds to play back quicktime media files. If I use a button click to "Perform" container elements (NOT a script, just the button navigating to the container filed directly), I am able to access everything while the file plays. I can also access the progress bar of the file playing. If the "Perform" function is called via a script however, I must wait until the file completes to access the database & the progress bar is not viewable. I have tried some external media player extensions (24U SimpleSound & PS Media…

This is not the first time I experiment this behaviour. But i wonder if someone knows the reasson why. I have this script. Freeze Window Loop If [ T2::NM ≠ "" ] Go to RR[ From table: "T2"; Using layout: T2L ][ Show only RR ] Go to Record/Request/Page[ First ] Loop If [ T2::NM > 1 ] If [ T2::NM > 2 ] If [ T2::NM > 3 ] If [ T2::NM = 4 ] PerforScript ["newReG";Parameter:T1::ID & "¶" T2::F1] PerforScript ["newReG";Parameter:T1::ID & "¶" T2::F2] PerforScript ["newReG";Parameter:T1::ID & "¶" T2::F3] PerforScript ["newReG";Parameter:T1::ID & …

it seems to me that FMI had a free plugin that would trigger script when exiting a does anyone know where it was, just checked the dev7 cd. Maybe I am mistaken...

I'm using FM7 and I've noticed that there isn't a way to rearrange the search criteria list for a perform find (or any other find for that matter). Am I mistaken or am I right? Is there a way to insert a search criteria in between or before any other in the search criteria list?

It seems to me that this script step don't go any more to the next field of a repeating field (as it does in 7). Is this correct ?

I have created a script with a "Show Message" step in File B which I am running via the external function in File A and I want the user to be taken to a layout in File B and then be shown the message after a find has taken place. For some unknown reason the message shows in File A My script is; FILE A Perform Script: External "File B" - Show Message FILE B Perform Find If Status(CurrentFoundCount) >0 Go to Layout (Refresh) Sort found records Beep Show Message Can anyone help?

I have an application which uses different windows for reading and updating. I have a button on a read window which invokes a script which switches to the other window and updates the selected record. However I haven't figured out how to select that record in the new window. I try to do a Find, but I cannot find a way of moving the key field into the Find request. I'm sure it is easy, but I just can't figure it out. Any advice? :

Are there any plugins available that will allow users to import or export scripts as txt files in windows? I haven't used filemaker in awhile, and I am getting back into it for gis applications. I seem to recall at one time the scriptmaker had a macro recorder the would map user menu selections to the script file. Was this a mac thing?

Hi gang, I am writing a script that uses the tab order to set the fields. I am trying to use the go to next field step but how do I exit a loop? I know I can manually count the number of fields in the layout and use a script variable, but is there an easier way? Thanks in advance

OK, I'm in Dev 7.0v3 (8 upgrade coming). Been doing FMP since 1.0. But I've never really used repeating fields. I need to find how to set a particular repetition in a repeating field. Help! Jim

I have a super simple script that I just don't see why it's not working 100%. My script is: If ["Start_Date" = Today] Go to Layout [Refresh Window, "Warning -- Same Day Request'] Else Go to Layout [Refresh Window, "Reservation -- When and Where"] End If OK, so it works properly when the statement is TRUE, but it doesn't work when it's FALSE (when the Start_Date field is set to a date after today. I'm sure it's something super simple, but I am just too dang dumb to figure this one out.

Hi there The picture - I got members who must pay a monthly fee in advance to remain active. Before the end of the month, I review their records and I unmark a field for those who didn't pay. For those who paid their monthly fee, the field remains checked. Then I update the Date field manually. I want to add a month to a Date field automatically by clicking on a button. I know the following script can perform the task. Go to Record/Request/Page (First) Loop if ("Payment = "Paid"") :? End If Go to Record/Request/Page (Exit after last, Next) End Loop Go to Record/Request/Page (First) --- All I need is a way to add a month to a …

Is it possible to put radio buttons or checkboxes, value lists etc. into custom dialogue boxes or is it only text based entry? Cheers for the reply guys, genx

Hi, I am trying to tidy up the records that I have imported from a Inmagic library database into my own FM database, but as the file formats are quite different it has been a difficult process. In one of the keyword fields I have noticed that the spaces between many words have been removed so that I have entries like "OperaClassical" or "AfghanWorldMusic" which makes it difficult to use this field for searching. Is there a way that I could use a script to loop through the records and put a space before any capital letters (except the first one) to separate the words? Thanks.

i don't want to set the field to the script parameter but define the field i want to be set to the script parameter... i want field (script parameter) to be set to .....whatever...

Hi, I'd like to make my Filemaker database automatically send me an email every day at the same time with my current ToDo list. This is running from a windows computer, if that's relevant. Is this possible? If not possible with filemaker alone, can I incorporate this by combining it with some kind of web script?

Hey all, Is there a way to use the Export Records script step with variable filenames? I'm writing up a script which will loop through certain found sets and then each time export an HTML file, but right now I can't figure out how to export a new HTML file each time ScriptMaker goes through a single loop. I'm currently using FMP7 and therefore am not able to utilize the Troi plugin. Any other solutions that anyone can think of? Much appreciated.

Is there anyway to use the Sort Records script without having the dialog box come up. I would like to use a button that specifies the sort and then sorts the records without this dialog appearing. Thanks, Coffee.

Hi, One of the most frustrating aspects of Filemaker for me is that you can't insert a variable or field in a "Perform Find" script step... i.e. you can't "Find by a date before Field1 and after Field2." I'd like to allow my users to enter a start date and end date in global fields and find records with a CreationDate field in that range when clicking on a button. What's the best way to do this? Thanks!

Dear all, Manifestly, I'm a FileMaker novice, so perhaps I am posting this in the wrong forum etc. Apologies. I have created a calculated field which works successfully for each of the 3900 records in my database. I now want to output (preferrably to a text file) etc. Any help would be much appreciated, Many thanks, James Boulter

Is there anyway of using a find request to find related records using a current field value? EG. A client can have many products. when on the products layout, I want a button to be clicked to view all the products related to that client only. How can this be accomplished? If I need to use a gloabl field, can you give an explanation as to how because I am a little confused on how to use gloabl fields. Thanks in advance.

Hello, Can someone please help me out with scripting a dynamic field that would contain information from 1 of 3 fields. I.e If Status field = "submitted"= Summary field displays the information. This is not the script I'd like to create but somthing that would actually work. I'm new to some of the advanced scripting so any help would be appreciated.

this is a simple script to eliminate duplicates found by a self join. The self join makes a record count field= 1 for single and = 2 for duplicate. Then it finds record count >1 and deletes one entry in a loop. It works but does not delete them all unless I run the script 4 times. Each time it misses less. Must be a bug in my loop where it misses values. Here is the script Perform find (record count>1) Go to first record Loop Freeze Window Commit records If record count >1 Delete record End if go to record next (exit after last) end loop show all records

Thanks for the insight. I just posted on the script forum trying to debug. I can confirm that in a large data set (40,000) records this will clearly miss records. Changing the go to next record to an else statement definitely fixes the problem.

I have 2 scenarios I need to have explained to me as extracting one value from a value list is really stumping me. I have Included a sample File if you can show me how to do these I will have all the tools I need to finish this project of old data transport. Thanks Tony D. Zones_to_letters.zip

Hello everyone, I hope this hasn't been brought up before because I couldn't find it. I have a field that is formated by a value list. The values are 1-13. The field is set up with radio buttons. I want to be able to click a box and have it open another layout. I assume this can be done with some sort of script. I had tried the "If" and "Case" formulas but it won't work right. I am not new to filemaker but am to scripts. I hope this is not some simple answer I'm just overlooking. Thanks in advance for any help.

In looking over a plugin (eauthorize), I noticed the following in a script step: GetAsNumber (${Authnet - Auth-Capture}::gt_plugin_result) =1 and ${Authnet - Auth-Capture}::td_result_response_code = 1 Now, I realize the /* */ comment out the line.. but I've never come across the ${} before. Can someone shed some light on this for me?

I am trying to have FM use scripting to start a batch file with a paramater. I'm using a calculated field in FM that looks like this: "cmd /c c:play.bat test" I call this calculated field using Send Message in a script. However, my batch file doesn't run. If I use it in the command shell in Windows it works fine. Any ideas of what I did wrong? Thanks, Joe

OK I have START_DATE (1-25-2005) END_DATE (7-25-2005) From the start Date I need 2 pieces of data. Start month in word format. The months field it is going into is a value list already with january thru December. Start year is just a edit field I need it to take the year and insert it here. Then I need to know the number of months between the START_DATE and the END_DATE. With this information I need it to mark checkboxes. The checkboxes are numered 1 to 12. Based on the difference between the the month I need it to check that number of boxes. Thanks Tony D.

I've got a button on a layout for table A that, when clicked, creates a related record in table B. I'd like to disable this button if the related record already exists since only one such record is permitted. What's the best way to do this? Is there a way to get a script to run when the layout for A opens? Thanks in advance.

i have a field defined with a radio buttons for Y and N those are made ot tell yes or no for someting to be included in a script and at the start of my script it should say "IF(field 1 = Y, perform scripts, go to next script) but it won't accept Y and an answer... it works if i change the Y and N to 1 and 2...but it needs to be a Yes or No visually not 1 for yes and 2 for no....why won't it work?

Is there any way to verify a remote volume has been mounted before executing the rest of a script? I have an export script that needs send an error if the volume has not been mounted on a clients computer.

Newbie question: I've got a layout Contact displaying a record in table Contact. I want a button that creates a related record in table Client. The relationship is such that for a record in Contact there can be either 0 or 1 record in Client. So, I need to first check to make sure the related Client doesn't already exist and disable the button if so. (See related posting.) Next I need to open a Client layout, create a new Client record, set the primary key field of Client from the corresponding field of Contact, finally commit the record. I *think* this is straightforward; e.g., Copy [ Contact::ContactID ][ Select ] Go to Layout [ "Client" (Client) ]…

Hello I'm newbie with filemkaer, and I am developing a systema to manage personal in my office, well the question is how can I make and script run when one of the radiobuttons is selected, I have to round buttons Yes and No I want that when you select Yes and script runs and when you select No another script runs. I had read a lot in this forum but I couln't find the answer I'll try putting a button over every radio button but in browse mode when I select the NO button the Yes button keeps checked could you help me?? tnxs

I haven't had any problems creating buttons until now. I have created a main page for my database, with buttons sending the user to different layouts of the database. Now when trying to create certain buttons that would send a user to say... a website you would think that all I would have to do is edit the task of the button to "Go to URL"...what do I do if that option is grayed out? is there another way? a script? one that would allow me to load the application internet explorer and then load a URL? YES I am a newbie! graduated from Do it yourself University! filemaker pro bible as my text book! lol.. please help me... also is it possible to take this database web based?…

I have designed a database for use in research the purpose of which is to organize all of our past data. We have data in many different formats and I wanted to put it all together by importing it into a filemaker database. the problem is it is possible to have repeating data. I need a way to find and delete these extra records. If I do a search using rat id and date I should only get back one result since each rat only tests once a day. So how would I write a cleanup script that would search all rats and all dates and return repeats that can be deleted? Is this even possible?

My goal is to be able to create a search or find request that search multiple fields within one layout for text entered once. If it were done without a script, one would enter text in one field and then extend the find to the next, and again to the next and so forth. I'm jumping the RTFA option and not having luck. I have Help, and I have Tutorials and neither are answering my question, so I looked to the trusty forum that's helped SO much. Specific situation: I have a database for documenting around 200 concerts per season. Ten composer fields exist for the works performed within one performance/record and with a simple search of "Beethoven" in [Composer 1 Last…

How do I setup the find script to check a specific field in the current record and return a found set based on that criteria?

I need to get a total of the number of times a certain word appears in a feild. The feild is a value list which has the words Active, Canelled in it. I just need to know how many records are set to Active. Whats the best way to go about this? thanks.

Products sold (as appearing in LineItems) are listed as a positive number (of course). Returns are listed as a minus. To write our sales to Inventory, I use a join on: ProductID = ProductID AND date = date and MoveType = MoveType. I use Set Field [ Inventory::Quantity ] directly (which creates a new Inventory line if Product/dateMoveType doesn't exist). Originally written, I had become confused on converting these numbers in my script, 'adding together' multiple positive (actual minus) numbers and 'adding subtracting' multiple negative numbers. I feel like a multiple-dork for finding this confusing. I'm reviewing my write process and I can use clarity in my thinking pl…

Hello, Say you have a paper route database. You have a related database that has the current day's itinerary. Each stop is identified with a stop number. How would you write a script to place the first stop and the last stop in two other records, first_stop and last_stop? To rephrase that, the record with the first stop number (always going to be 1) goes in first_stop, and the record with the last stop number (could be 10, 20, 62. . ) in last_stop. I think it's possible to go to a layout, enter find mode, go to the stop layout, find all stops related to the day we're looking at, sort them by stop number ascending, take the first record and put in recor…

I need a way to automate the Start date and end date to autofill out the database form I have included. I have set up all I need working. Do not worry about zones and add size at this time just get it to fill out month and year. As I already have Zone and add size working. I have tried several approaches with no results. Hope you all can help me out Thanks All Tony D. FIXME.zip

Does anyone know a way for a script to set the cursor position within a field to a specific location? What I need to do is have a button that adds a note with attribution to the top of a notes field. So, if the field says "8/23/05 foo: this is weird", I need the script to add "8/23/05 bar: a new note" followed by a couple of line feeds. It's easy to add the attribution and line feeds to the top of the field, but how do I then set the cursor to the end of the newly-in serted attribution so that someone can start typing there? Thanks in advance.

Dear FM Forums, I am a small level above notice to FMP with a basic understanding of scriptmaking. I have a question about printing a found set of records. I am trying to automate this task with a button. (as apposed to finding set, goto list and print) I have a radio button field EX: O Blue O Red O NA Can I set a script that will find all Red, Sort then print. I can only seem to set the script to find last criteria. any help would be greatly appreciated.

I am having a problem closing files, I know it sounds ridiculous, and I'm sure I'm doing something stupid but here goes... I have 4 databases and they need a high level of security for multiple users on multiple terminals, so I have included a lock script which closes all open windows and goes to the 'master' db and re-logins under a limiting password, which then makes the next user open again with their correct password. This works fine, but... one of the databases is still available via 'show window' under the window menu. Even if I try and close or hide the database without using a script it still is available with incorrect access rights. This doesn't happen…

I am a psychiatrist and have written a file to manage my office. I have nearly brought my office management project to the point where I can use and depend on it except that a couple decisions I have made resulted in a problem I have not been able to solve. In short I have split the transactions into current transactions and previous (prior months) in order to make picking up the prior balance easier. However, this has complicated a script which runs through all the patients (a loop) and prints only those statements for patients with a positive balance. The script does strange things when it does not find a record in the current transactions table, specifically it winds …

I have two global fields called glb_Filename, which is a radio button and populated by a static value list, and glb_Year, which is also a radio button and populated by a static value list, and a button to execute a script. The idea is to be able to open and view archived files that we save from year to year. The button executes a script that looks like this. If glb_Year = "1998" Perform [sub-script "Select 1998 Files"] Else If glb_Year = "1999" Perform [sub-script "Select 1999 Files"] Else If glb_Year = "2000" ...End IF End IF The "Select 1998 Files" script looks like this If glb_Filename = "Referrals" Perform Script[sub-scripts, "Open Ref…

I need to be able to change a record simply be viewing it. I use Filemaker as my email client (using SMTPit/POP3it), and I want to be able to distinguish between records I've looked at and those I've never looked at, as you'd get with a regular email client. Any suggestions are welcome. Thanks! John

I have a script that generates a time based on a calculation. Could someone tell me how to have the script convert it to the format A.M./P.M. instead of the 24 hour format that it is ending up in. (currently it's resulting in 14:30:00 instead of 2:30 P.M. which is what I would prefer)

can you do this with out a plug in and if so how? thanks

This is a problem with passing a parameter to a script to tell it which layout to use. I have created a script that opens a Layout and Sets a field in that layout. Simple. Now imagine a Layout with a half-dozen buttons. Each button runs this same script, but the Layout it goes to is different for each button. I could make 6 copies of the script, modifying each one to change the name of its destination layout. But I’d prefer to write the script once, then have each button pass a parameter with the name of its destination layout. The Script step “Go to Layout” accepts a parameter to tell it which layout to go to. The Script step “Set Field” does not.…

Hi I want to export a file in scriptmaker. Is it possible to send it to the users desktop rather than a specific place. I tried file:~/Desktop/export.txt but that didnt seem to work. Thanks

Hi, I have some data external to FM into the clipboard. I need to paste this data (text) into a temp field for parsing it. the problem is to paste text into field , I must go to the layout and pasting it there into the field. I need a function like SetField(Temp,Clipboard) (SetField don't request that the field is into the current layout) Any help ?

Hi everyone, I hope you can help me again. Is there a way to duplicate a record but only parts of it? Actually only contents of 6 fields. Or is this a copy function? Thanks, jean

Ok I have 2 lists of Customer Names I need them to match exactly. So I decided to do this I would design a calculation field that would check to make sure they were identical if they were it would show a 1 if not a 0. Ok works like a charm so I think I got this in the bag. I write the following script but it hang and never does a thing. Loop Go to record/request/page [First] If [Record::test = 0] Set Field [Record::Company;Current::Company] End If Go to Record/Request/Page [next;Exit after last] End Loop

Is there any way to loop through repeating fields without having to specify each one individually using the [n] suffix?

I'm not having any luck satisfying Dev 7 (MAC OSX). I would like to run another FM7 runtime solution in the background by starting it from a script step in an 'active' runtime solution. I've tried various forms of 'send event' and am about to conclude that's not the way to do it. How do I get the other runtime solution to run from a script step? TIA

Any time the FM help references word functions there is this statement: Note The ampersand (&) and hyphen (-) characters identify the beginning of a new word. What does this mean? I am trying to breakdown a phone number where the elements of the number are separated by hyphens, but wordcount returns a value of 1. I find the help confusing especially since I would assume that spaces identify the beginning of a new word.

I need to write a script that performs a find based on inputs from a dialog box. I can get the dialog box to pop up but I don't know how to perfom a find based on the inputs. Someone help!!!

Help Please! I am trying to create series of reports to show production waste from a two printing presses sharing the same database log. I would like to provide a menu with buttons for the user to choice from. All searches would need to search between certain date ranges along with other criteria. I have two global fields for start date and end date then would need to search for a certain press number, press and customer ect.

I am familiar with looping through a found set of records to find a duplicate entry but am baffled when trying the opposite - looping to "mark" the unique entries. Can anyone advise?

i have a script that copies information from one field to another but the field copied to may already have information in it and if it does the paste is right next to the current info with no spacing...how can i get spacing there and maybe even a date on each paste

Hi gang, I have a script that creates a pdf file from a Job record. the last step of the script is to e-mail this pdf to a client. the problem I have is attaching the file. The user has to attach the file manually. Is there a way to use a dynamic file name to attach. It is named for the Job number filed. I know if the file is always the same name in the same place it is easy. But the file is named after the job number. But I have found no way of telling fmp to attach the file named after the job number field. I don't think its possible. Am I wrong? Please tell me I am Thanks

I have an application that uses the following run string: 'run c:/Program Folder/application.exe /s' I would like to use 'send event' to launch the application from a script but have been unsuccessful in figuring out how to pass the ' /s' parameter through 'send event'. Is there a way to pass a parameter to the application using 'send event'? TIA

Here's one for you all. I've created a database that records all of my webpage hits. The data is imported via the Troi URL plugin. This being said the user enters the previous Saturday's date into a field and the script implements that date into a URL address and that entire week is brought into Filemaker. What I want to do is create an automation script: - to run anytime after the last update - And that inserts any of the missing Saturday's dates since the last update. I guess what I really need is some sort of calculation that can determine the Saturday's date (perhaps based off of the week number) ANY help or information you can provide wo…

how do i, or can i at all when 1 user under a restricted username and when ever they edit the one field they have access to send a message or some kind of notification to someone on another username with more access the situation is that have employees that work from the fmp7 program and outside client useres that can submit requests via iwp but i want some kind of alert to the employee who checks hte requests for when one is made

Need to generate a random dollar amount between $1000 and $2000 with the cents on the end. Have the following formula but how do you limit the cents to two numbers and stop the number going below $1000 (Random * 2000) + 1 Also is there a way to format the result so a comma shows at the thousands mark and to put a $ symbol in the result like $1,387.90

I have a found set of 1900 records (from a dataset of over 4000 records) which all need to be updated in the same way--they all need to have the same value in a field defined with a radio button value list. This value-list field is now blank (i.e., no radio button is selected) for all of these found records. How can I automate the process of updating all 1900 records at once?

i have a script that if 1 of 2 parameters are met the file is kept if not it is omited and it works wonderfullly i am actually very proud of it, but....if no records meet either one of those 2 then it goes into that never ending loop what can i add to it that if the sort, sorts out all the records i want a msg to be displayed "no records found" and then it perfroms a show all

I have a button that takes the user from LayoutA to LayoutB based on the script Go To Related Record. But, when there is no found set, it doesn't do anything. I tried using IsEmpty and RecordCount = 0 to try to catch the error so that I can bring up a custom dialog box but can't seem to get it to work. Is there another way of making the dialog box popup when there are no records in the foundset.

Up until now I haven't had the use for scripting beyond what is mildly complex, but as I get tougher projects I'm wishing I had a better knowledge of it, and especially since I've been reading Moyer & Bowers' "Advanced FileMaker Pro 5.5 Techniques for Developers". I thought I had a handle on most of FileMaker, but this book as revealed that I am horribly lacking in general scripting techniques, and it becomes clear that it's a pre-requisite for understanding this book. (I do like this book, especially for the two chapters devoted to relational database theory). One problem is, the boss has let us get passed by the whole FM Community and while most people have move…

i have layout a that is records in list view or requests and it has the option to accept or deny...when either is chosen i have a script run and it is supposed to take all the information from that request and make a new record on a layout from a seaperate table and then display accepted or denied...i was going to use set fields to carry over the info but that didn't work how do i transfer current info to a new record in a different table is basically what i am asking

I've got a looping script with a subscript that creates a duplicate record when certain criteria are/are not met. My problem is when the first record in the found set is duplicated, I'm on the last record created (the duplicate), which is *not* the right position to go to the next record. As you can see below, I've tried omitting records, but that doesn't work either; I wind up skipping the second record when the looping script goes to the "next" record. What would be the most clever/elegant/appropriate way to loop through the found set of records, duplicating some/all records along the way? Thank you in advance for your consideration. Here's the …

I'm working on a script to export images and rename them but I've noticed a really weird thing with the Export and Send Event steps. No matter what I specify as destinations or locations, FMP subverts it by somehow sending the location of the last folder I from which I imported an image. In other words, I import several images from an "imports" folder, then try to export and rename them in an "exports" folder, but my scripts either don't work or do work but send everything to the imports folder. I've tried it with command lines and batch files, always with the same result. The only cure I've found is to artificially import a file from the exports folder first t…