Script Workspace and Script Triggers

Hi - I have a layout with a few different portals. One of them won't refresh unless I click on a blank part of the layout. The script that alters which data are related does a commit records and a refresh step at the end, but you still need the click to get all the data refreshed. What am I missing? Thanks! Michael

I have a database where the user logs in and can then brows through their own records, these records are brought up by a search when they log in. I can display the number of records found... i.e. their records but cannot find a way to show a live count so each record they click through show's record 1, 2 3 etc so they can see how many there are and which one they are on in relation to the total records. Without the Status area (which I do not want for ordinary users) how do I do this is it a simple Get and a calculation ??

Hi Guys, I have attached an image showing the interface that I want to use to add new dates to a related table (this is part of a larger layout of information from a different table). I am having two problems at the moment. 1) When you try to click on the fields in the "Add New Date" area, they are not selectable at all, stopping you from entering data. At the moment they point directly to their table (e.g. Dates::internal_id), should that be linked some other way to do this? 2) How do I learn about scripting the "Add New Date" button so that the details in the fields above are entered into the Dates table and then are displayed in the dates portal to the …

I would greatly appreciate anyones input on this issue I'm having... I have multiple layouts using the save record as a pdf which uses the email option. The user that creates the PDF can view it just fine, but when it's emailed it's a different story. Here is a list of the issues: -Windows based machine can't view the pdf -Windows based machine can't print pdf -Leopard based machine has a weird font that you can't read. -Tiger based machine can view the pdf, but it crashes the viewer shortly after it's open. The font I'm using is Verdana Thanks you for reading this post and I look forward to hearing some ideas :

Ok I would like a custom dialogue comming up with a question and depending on the button pressed run either script 1 or script 2 however there does not seem to be a way of running a script from custom dialogue : which can't be right....

Happy Friday all, I'm working on a project and i want to be able to take a few fields from my solution. Wrap them into a nice mailto:url and compose an email. The reason I am using a mailto command over say the send mail script step is because when using send mail the email window is model. This is an issue because my users want to be be able to copy and paste various other bits of info from inside filemaker (This info varies). Now the issue. My mailto line is as follows: "Mailto:?body=%0A%0AREQUEST:%0A" & PROJ::Request & "%0A%0APROBLEM STATEMENT:%0A" & PROJ::ProblemStatement & "%0A%0ADISPOSITION: " & PROJ::Disposition & "…

I have a database in which I keep track of medication of patients that are in our system. I have 4 columns (Medication Name, Dosage, Route, and Freqency) each with 45 repetitions. They are lined up next to each other so as to look like a chart. We enter the information manually from a hard copy that we receive at admission. We show a portion of this list on a cover sheet and if there are more than 11 medications a button will appear that says to look at an addendum (continuation of the medication list) that will list the medications that do not fit on the cover sheet. I have calculating fields set up to check if there is any information on repetition 12 throug…

Hi, I have attached the database that relates to my question. I have 4 records. Each record has tabs (address, project/topic, publication, etc.) that correspond to applicable info for that record. If you look at the Publication tab, you will see a drop-down field that uses a value list for selecting a publication title. I would like to "apply" a publication field value to only a select set of records, rather than everyone in the database. While looking at the Publication tab, notice the "Core Audience" radio buttons at the top of the database. How can I select a specific publication value to be assigned to only a specific core audience? …

Hello, To start I'm really sorry if this is in the wrong forum : I need some help with some pseudocode. My client has a filemaker database filled with business records, with fields labeled "phone number" "business address" "city" "zip" etc. I have an excel file filled with other records with the same named fields. I need to compare these two databases together and figure out which entries are NOT already in the filemaker database. Problem: Matching records do NOT have the exact same information. For instance: "Joes Pizza Parlor" and "Joe's Pizza" are in fact the same business, but the records are slightly off. "1156 N. Willow" and "1156 Willo…

I have a table of "teams" and there are two members to a team, each with their own record. If I change the status of one member on a team, I want that status change to occur in the other team member's record as well. Each record contains a team name field so I assume I am correct in making that the relational field since both team members have the same team name. I've duplicated the teams table and created a relationship between the team names in both tables. My script changes status via SetField but it only changes the status of the current team member, not the other.

I need to import updated records information from an excel file to update records in a Filemaker file (with 2000 names & addresses & donor info). I can choose which fields to match, and which not. So far so good. However, the excel file is the correct file and some records have been deleted and others added. I can't figure out how to deal with this problem. Do I create a clone with no records and then import the excel file into the clone? and then do a comparison? if so, please guide me on how to do a comparison between files that would delete & add records. I have never done a comparison before. Many thanks.

Hello all! Have you seen this behavior? I'm running the only copy of FMP Advanced 9.03a, running hosted files under FMP Server on a Tiger server network. When attempting to import scripts between files (already open on the net and hosted by FMPS) I get the following message: [color:red]"The maximum number of licensed users are currently using this copy of FileMaker Pro. Please refer to ... documentation for further instructions... License Key conflict occurred with user "Istanbul". All files will be closed and the application will quit." WTF? "Istanbul" is my laptop. How can I be in conflict with myself? LOL. A question for my therapist fo…

Hi all. Forgive the newbie question. I have a found set of appointments for which I need to know how many unique dates occur for these appointments. For example, I might have 40 appointments during the month, but they're spread across only 20 unique dates. I need my script to count the number of total unique dates which contain appointments (in this case 20, not 40). Any ideas? Thanks very much in advance for any help.

I am creating at database that will automatically assign seating in an auditorium. The layout of the auditorium is configured in sections, rows and number of seats. Each section does not have the same number of rows nor the same number of seats in each row. Question: Is there a concise way to script this? The long way is to create global fields to tell what is the maximum number of rows in each section, then one for each row to tell how many max seats. Then create a looped script to go through each section. I am assigning seats to 400 elementary students. I have a table with all their names. All kids in grade 1 need to sit in Section A. All kids i…

Is there a way to run a script when a particular layout is selected. I need a layout to be in 'Find' mode, Ive created a script with just "enter find mode" in it. Unless there is another way round this

I have encountered what seems to be an inexplainable failure of the IF statement. Case I have a script I want to have act differently depending on which Layout is displayed. However, the IF Get(LayoutName)= "xxx" refused to evaluate. I know the Layout name is valid as that is how it got displayed. But the IF statement will not evaluate as true even though the Date Viewer shows the correct value for the Get(layoutName). I can make it work by which window is displayed, but not by the Layout displayed. This seems to be a little strange. I have tried deleting the statement and then adding it again after making sure the script runs ok otherwise but no luck…

I run a daily data import procedure that involves several calculation fields, sorting, data mapping, etc. on 65,000+ records. I have found that when Filemaker is doing these calculations (which take several minutes), it is only using 50% of the CPU. I deternined this by opening the Windows Task Manager and looking at the "Performance" tab. The CPU Usage History maintains a very flat line at 50% during this calculation time. In looking at "Processes" I have confirmed that FM is using only 48% to 50% of the CPU power, never any more. Is it possible to tell Filemaker to use 100% of the CPU when it needs it? Other program routinely use 100% processor but FM never does. …

Hi all, I am a novice user, but I'd like to create a script in which: If a date is entered into a field, an e-mail is sent (or some sort of reminder window or notice) on that date telling you that you need to call whomever or take whatever action. Gotta say scripts are not the most intuitive items- for me, anyway. I've gone through my book, this website, and lots of trial & error (obviously,mostly error). Can you Fab Forum Folks out there help me? Many thanks in advance- doc00

I've created a database to keep track of a letter mailing campaign. I have 8 Fields for 8 letters set up as Letter 1 Letter 2 and so on... I put the start date I want to begin mailing in the field "Letter 1" I then want to mail out the remaining Letters in two day increments, so I have a simple calculation set up to produce a date 2 days later from the previous letter. Letter 1 12/31/07 Letter 2 01/02/08 and so on... Now, I'd like to get a little more complicated, but Im not sure how to approach. When i have actually completed one of the mailings, I'd like to have some way to show that particular letter has been sent. Maybe a completed …

Hi All, We've got a solution that is fairly large and intensively scripted. Recently I noticed that all of the GTRR script steps have "Using Layout: " as the selected display layout. Oddly, the scripts all work just fine. We never would have noticed this problem had we not been in to look at some other issues. I know this can't be good, and yet there are NO issues with the platform at all. Any thoughts? Clients are all in v8.5 and server is v8. All clients and server are Mac Tiger.

I probably stated this wrong but I have a records table based upon meetings and a documents table based upon ind. docs. I created a relationship between the two tables based on record number. Each record has several associated docs. I sometimes have several docs stored in different formats. I want to speed up the data entry process by copying all the data from several fields from one table to another. How do I do this? I'll have three docs with same title and same info in three formats say .ppt, .pdf, and .rtf. all associated with one record.

Hi all. I have a script that performs finds across records in several tables and sets foreign keys to allow summing at a higher level, using several self-join relationships. the script works perfectly when i have the file stored locally. once i put it on the FM8A server, it does not seem to update the records every time. although if i walk through the debugger while its on the server, it will update the records and works perfectly. I have no idea what would cause it to act differently on the server. its almost as if it is running too fast to update, because if i step through it in the Debugger it works fine. Does anyone have any ideas?? Thank you!!

I have a file with a script that works on internal HD , but not on a external USB flash drive. (You can guess where this is going) I spent a hour trying to see the difference in the scripts... IDENTICAL! I finally solved the problem by inserting a PAUSE/RESUME in the script. The reason it did not work on my machine was because I have the file on a USB flash drive, too slow for filemaker scripting. When the file is on internal HD , no need for pause/resume. Keep in mind for future problem solving!!!

Greetings I hope I can describe this correctly... I want to (and am in the process of) creating a script to analyse Sales Consultants billings to earnings. For this I have to run scripts in two different tables: the Invoices Table (to get the sales totals per sales consultant) and then the Salaries Table (to get the salaries and commissions for that particular Sales Consultant). I start in a Table called "Scorecard" and then go to Invoices and run a script. I then set the required fields to globals, go to a layout in Scorecard and post this data into the correct fields. I then leave Scorecard again, go to Salaries, run a script to find the correct salary s…

Is there a way to use a variable in find mode?

All I want to do is perform a script when the Enter or Return key is hit (a commit of record). I've defined the script I want to perform and have made a button that invokes it, but I also want to accommodate the user who simply uses the Enter/Return instead of the button. How do I do this? Thank you!

Hi all I was under the understanding to you could push or pull information using the set field function. I have a table called printing and a table called information. I would like to run a script from printing that would set the set fields in the table printing from information stored in the table information. But the script does not work. I attached a file of what I am trying to do. Thanks in advance. Lionel setfield.zip

Hi! Could somebody tell me how many scripts can FMP 8.5 handle? Tks.

I have created a row of buttons listing A-Z and 0-9 to place in either a City, State or Zip Code field. I have placed A,B,C....... as the script parameter. I've been playing with this all day and have not been able to come up with the right script so I went to 3 scripts and 2 rows of A-Z and 1 row of 0-9. (See Layout JPG.) This looks rather sloppy and I believe amateurish. I feel pretty certain that there needs to be some combination of get( Activefieldname) and variables and get( scriptparameter) But try as I may I have had no success. I also tried setting up a global field "G_ActiveField" and couldn't get that to work either. Any suggestions, guidance will be …

I have a portal with a single field in it. That field is defined as a button. I want to be able to return the contents of the clicked field when I click on it. In other words if the portal list looked like this: Mary Sally Bob ... and I clicked on the word Bob, I need a function that will return the word "Bob". I have tried get(activefieldcontents) with no luck. Any help? Thanks

Hello everyone and Happy new Year! I have quite a similar problem and i really don't know how to solve it. i read this thread and it did help me a lot. but i was wondering how i could share files from a FMP server over the network. so here's my situation: the calculation i have in my database works just fine. the problem is every time i try to export the content of the field onto, say my desktop from a filemakert client on the network, the software tells me that the file could not be found, therefore the export cannot take place. what kind of script can i write that will allow me to download a file that's referenced in a database, and that's also residing on a…

Hello all, Here is my question: I have Perform Find [Restore] Script. For the "Action" is Find Records, the "Criteria" is "Import::Number: [<100]". So, basically it will search record under Number 100. It performs well. My question is, when I changed to $Variable, then it performed nothing. Is there a way that I need to plug in the number, e.g: 100 or 200 in variable, but I still can find it using Script Perform Find? So the criteria would be: "Import::Number: [<$Variable]" Thank you.

Using the Create new user script is it possible to "Grab" the new user name and create a blank record ? This would enable a new user to login first time and have a blank record already there, otherwise on a login where only the users records are shown they will get an error first time they login as there will be no records. I'm sure this is really easy....

When saving a record layout as a PDF I would like to specify the file name of the PDF produced. I would like to use a field from the record as the name so that the invoice produced has the name which corresponds to the contents of a field. that way I don't need to name each file as it is saved. Is this possible ?

I am trying to organize my script groups but when I try to moving a group outside of the group it is in, it puts all group scripts inside the one I just moved. Example Scripts List (the dashes do not appear in the script list, they are here to maintain the correct format in this post) Group 1 Scripts (Folder) ----script 1.1 ----script 1.2 ----Group 2 Scripts (Folder) ----Group 3 Scripts (Folder) Groups 2 and 3 should be not be inside Group 1. If I drag Group 3 Scripts above Group 1 Scripts I get the following Group 3 Scripts (Folder) ----Group 1 Scripts (Folder) ------script 1.1 ------ script 1.2 ----Group 2 Scripts (Folder) W…

Trying to save myself some tech support time here. Is there a way to script "go to this page in the filemaker help" Maybe by opening the filemaker help file and passing some parameters? any ideas?

I can't seem to figure this out (and i'm sure it's some easy solve). I have a button that opens a file. But I want an error to popup if the File is not FOund. I tried using the Get(LastError) but I think I might be doing it wrong. Can someone let me know what to do and how to script this? Thanks in advance

Hello, I'm pretty new to Filemaker Pro and could really use some assistance here. I've got two scenarios I can work with, as I'll explain: (1) I have two tables in a database which contain wine cellar data (they were done originally in excel on two separate computers for speed). The fields under which they are cataloged are identical in the two tables. I now need to take these two tables and merge them. Ideally, I'd like an automated solution that can basically merge the two tables, where duplicate entries (based on the fields "Winery", "Name", "Vintage", and "Size") are combined in such a manner that the "Bottles" field from both are added together and then onl…

Here's a toughy: Is there a way of changing the behavior of a field via a script? My goal is to prevent a user from changing a field's contents--that's inside a portal--when the record is scripted to "lock." Because of the structure of the runtime, going the Permissions and Privileges route isn't an option. The nominal way to change the behavior of a field is to go into Layout mode, select the field, go to Field Control-> Behavior-> then uncheck the Browse and Find mode permissions in the windoid. If I could do that, via a script while in Browse mode, then I'd be one happy camper. TIA for your help! Rich

Filemaker 8.5. I would like to create a script that saves a clone of the open file, automatically inserting the file name from Get(filename). The script step Save a Copy As does not seem to permit automatic insertion of a file name. It wants the user has to type one in.

Greetings I am busy developing a scorecard incentive programme for our sales team. I have created a database "Scorecard". In this database are various tables, one of which is "Margin". The only data I need in the "Margin Table" is "Total of Subtotal", "Nett Sales Less Support", "Total GP Sales" and "Total GP Sales Percentage". I have placed this table in the file that houses all of our company's databases. What I want to do is create a script which goes to the "Invoices Table", goes to a layout which finds the sales for the specified Sales Person and imports the data to my Margin Table. Thus far, I have managed to create a script in the "Margin Table" whic…

I haven't ran tests; I probably should. But I'm working on a looping script which is quite complex in setting fields in different relationships, or (sometimes) creating a new record if it doesn't exist. I wonder which is more efficient (using this simple piece of the script): If [ [color:red]relatedTable::Type :notequal: "CHS" ] Set Field [ relatedTable::Type ; "CHS" ] vs. Set Field [ relatedTable::Type ; "CHS" ] I mean ... if the field already says CHS, it can be skipped so setting the field would have been unnecessary but the test itself takes time. And if the record doesn't exist, the relationship (with Allow Creation) will create it when the f…

We have a database with ~ 400,000 records. I am trying to purge (delete) some data based on a found set of records. Did a ctrl F - entered single criteria - the letter O --- Clicked find records -- found 325,000 matching records. Records were found in 10 seconds. I next elected to delete the found records. It is incredibly slow. It's been running for 2 hrs and so far, i've only deleted 35,000 records. Is there a trick to making this delete process run faster?: I see the same slowness when importing records. Yes there are calc being done as part of the import, but in other applications I use, the delete and import run in under 5 minutes. In File…

I'm sure this is a FileMaker 101 question but could someone tell me what the font is that FileMaker uses in their custom dialog box? I've tried matching it but no luck. Of course I've still got about a thousand to try. Thanks, Mel

I use Send Event to launch a file conversion utility. Currently, I'm looping in the script waiting for a Done.txt indicator file to exist (i.e., wait for file to import without error). Here in the year 2008, this seems to be a rather primitive way of communicating with external processes. Without using a plug-in, is there a better approach? Thanks for any suggestions.

Is there a way to say, open a new window or perform some other event when a given field has a certain value entered in it? Mark

Hi - Seem to have come across another change in behavior between FM8.5 and FM9. I was successfully using a Pause/Resume Script Indefinitely step to make a windowed layout act like a modal window, until closed by a button connected to a script. Worked well in 8.5, but now in 9, it no longer seems to work. Any insights? Have they changed this script step in some subtle way? Thanks, Michael

I see how to define and use "Set Variable" within a single file... but is there a way to use "Set Variable" to pass variables to different files? Am I missing something here? Many Thanks to all the FM Guru's out there! Dave

I have a DB with ~35,000 entries, each entry has 60 fields. I am trying to automate a process to delete or omit duplicate entries based on three fields. my problem is that even with indexed fields, it is taking too long to run an automated script, since it tries to compare each record to all 35,000 entries. Does anyone have any suggestions as to a script or method to speed up this process.

I am trying to make a script that will create a new record for each image in a specific folder. Is there a way to do this easily? I have a container field and would like to insert the image file into the container, creating a new record until all the images are imported.

I have a custom dialog with a global input field. I cannot get the input field to update. I've tried committing the record, tried creating many different test global fields in different tables but to no avail. I even created a global field in a related table and still nothing. From what I've learned so far, if it's a global it shouldn't have to be related. Any Ideas? Thanks, Mel

Hi Guys Filemaker doesn’t give me a 301 Error when trying to Insert an Open File, instead it just brings up a Error Box saying: "File is locked or in use". But shouldn’t I be able to stop this with Error Caption Set on and Get(LastError) ? Maybe a Filemaker Bug Thanks Ron

I have created a custom web viewer that pulls an xml file that I need to extract information from. I need help making the script that pulls the numbers that are from 6-7 numbers in length and they appear in the xml as follows "[color:red]503998< /amount> These numbers change with each file, and I need to set the portion in [color:red]red to a field. I added the space to the amount tag. Any help is appreciated I just cannot figure out how to refer to these numbers in the scriptmaker.

Hello all, I've set up a script which includes an email notification which will send an email to an existing Group I have set up in Entourage. Even though I type the group name in the to: field in the script box, after the script runs and it sets up the email in Entourage in my drafts folder, the group name has carats around it . An thus, Entourage doesn't recognize it. Any suggestion how I can make sure the Group Name shows in the emails To: while still having the individuals address recognized? thanks Jana

I am new to FileMaker and have received excellent answers to other questions today. The answers I have received have opened new doors to my understanding FileMaker. I am a digger, so my questions come after beating my head on the wall : What I need to do is to add a new record to a table when a user tabs past the last field in a List View. Thanks in advance, Lewis Howell

Hi Still learning the FM ropes any advice would be much appreciated. I have a layout where users perform a find on a date range from a custom input dialog. I need to go to another layout from here keeping the same date range, how would I do that? Many Thanks

Hi all, If you unzip the attachment and ... 1. Open the "TestMe.fp7" file (FM9 pro). 2. Click on the first red field 3. Click on the second red field The result is not the same. Actually I get nothing with step (2). Is this a bug you think ? Thanks, Thomas Discrepancy.zip

Hello! Please forgive a question from a novice, but I just can't find a way to do this... I have a script with a Send Mail step. I want to address it To: any employees who are found by the following criteria: the "Position" field matches "Vice President" and the "Office" field matches an $$Office variable. For employees who match these criteria, I would like it to return the value from their "Email" field to the Send Mail script step. I have some ideas how to accomplish this, but none that are even close to elegant. Thank you very much for any assistance.

I have a script that runs in the background background that updates records from an external mySql database. To get it to update I have it loop and I put a "pause for 300 seconds" command in the loop. Works fine, but I set up a toggle script that will set a global value to 0 to signal the looping script to stop looping. In theory this works but FM does something unexpected: when the loop script is paused, if any other script runs, it will no longer resume without having to push the continue button (the timer stops functioning). Why is FM forgetting to resume the script if a different script runs? is there a work around?

I have a field that on new record creation data is auto entered. That data needs to change from time to time but not often enough to warrant a drop down menu or something similar. Is it possible to script a change to the auto entry data so the user would not need to "define" the field to change the information in the auto enter area? thanks, Steve

I am trying to create an email field, in which the user can enter their username without entering the domain portion, since all the users will have the same domain. However when I want to email them or create a list, I want it to be able to see their complete email without having to input the domain. How is this possible?

Hi, I am a novice, but this problem seems like a genuine bug. I created a database on a Windows XP machine using FMP 8v1. My home and laptop copies of the same FM program are on Macs, an iMac and a Macbook. I sent the file to the Macs via email. Everything worked well for awhile, but now after the second time through a particular script the window will freeze permanently until quitting the file. I took out all Freeze Window and Refresh Window steps from the script and went through and put a custom dialog in between every single line of the script, up to a point, so that I could pinpoint when the freeze occurs. It happens between "Show All Records" an…

hi, at the moment we are using eventscript to call a script in a file. this works really well, except when we want to run a number of script steps after the called script has completed - filemaker moves on before the called script has completed. this is pretty much it: set variable "abc" S4HU_EventScript ( $_CurrentFile; $_ScriptName ) set field... set field... set field... so, it will execute the script identified in $_ScriptName, in the file identified in $_CurrentFile, but FileMaker will move onto the Set Fields before it has finished executing the steps in the Script. is there a different way of using EventScript so that it completes t…

I have set up a script to run daily that will import a .csv files that is sent to us by one of our customers (using scriptfire to run them on a schedule). This works great until the customer forgets to post a nightly file. In this case the system sits with an error message until it is manually cleared. How can I have FM check to see if the file exist prior to attempting the import? If it does exsist then it would continue and do the import and if not it would skip this step and continue. Thanks James

Does anyone know if there is a way to add a command line parameter when executing filemaker... or a filemaker db. e.g. I have a db named "process.fp7" I want to have scheduler run process.fp7 and pass it a parameter of "X12345" sometimes and "X99999" others. Is this possible? In other db's, I just added it to the command line. Thanks, Campbell

hello, is there a way to open a specific filemaker file that we have identified in a variable? say our variable $_file currently has JN_ABC.fp7 stored within it, how do we open this file, without actually using the 'Open File' script step? is there a plugin that will achieve this for us? i have looked into a few plugins, but no luck so far. we are running a routine, that will call scripts within a series of files, these files are determined dynamically, and we're EventScript to call scripts within these files, BUT the files need to open for this to work. ANY feedback would be much appreciated thank you, jd.

I am running FileMaker 9 Advanced on OSX 10.5. I have a image database which contains references to images stored on a network drive. Is there a script I can write which can export each record to a single folder that I specify? Mark

Hi, In a solution, I need a technique to identify when all related records have moved from step 1 to step 2. There are 3 tables involved: Projects, Invoice, Lines. The relationship from Invoices to Projects is one to many, so it is from Projects to lines. So, an invoice is composed of one or more lines, of one or more projects. The process is all done from the invoice table: - The user creates an invoice - The user selects from a portal of availabe projects. Only available projects are shown. - For each project the user selects, only the available lines are shown - The user selects one or more lines from the selected project. This lines are …

I have a container I've setup as a button which allows users to Insert a File. Is there a way of only giving them the ability to insert PDFs? Mark

I am a total noob to Filemaker and database design in general, so forgive me for basic questions. I have a DB that uses buttons to modify existing fields. For example, I have a button that adds 5 to a field. The problem is that it adds 5 to ALL the records with that field name and I onll want it to add 5 to the current record's field. I am using the "Replace Field Contents" script item with a targeted field and then "Replace with calculated result" which selects the field by name and then adds 5. What am I doing wrong? Thanks!

Trying to produce a system the shows me each step of an automated script and how long it has been running the particular script. But can't figure out why my test script is'nt working. If you run the script over and over it should not produce more than one of each window. Windows_Test.zip

i would like to include the contents of a .doc document when printing. the length of the file may vary from 1-3 pages. i presume i need to have a field that points to this file, which i don't know how to do either. your help would be greatly appreciated. bev

I need to create script that will open a Custom windows and ask for a number, that number need to be check in all the records first, if it do not exist it need to create a new reccord with that value that was entered in that custom windows. I am able to do a find in all the records if it don't exist the script creates a new record but the value that I have entered in the custom windows will not enter in the field Anybody have a idea how I could get the value from that windows into the record field ?

This question it based on concordance between Standard Industry Classification Code - SIC and equal european code, NACE. I have tableA (1700 records) and tableB (700 records). They both have a field with the same value, ValueA. TableB has ValueB, and it is empty in tableA. I want to export ValueB in tableB to ValueB in tableA based on the same valueA in both tables. TableB has several records with different ValueB, but the same ValueA. I want them also inside tableA with a new record based on the same valueA in both tables with all the other record values in tableA. Please, anyone?

Is it possible to script a button that takes basic text input from a field and adds it to a drop down list? I'm sure it is but I lack the skills to do this...your help is really appreciated.

Is there a way to surpress the "No Records Found" dialog that appears when a find fails? If I write a script with a "find" call, but the result of the Find returns no records I would like the script to continue with my own steps. Kind of like: Enter Find Auto Enter Criteria From Restore Perform Find if(GetFound)=0 Show Custom Dialog (blah, Blah) Halt Script Else Perform The rest of the script. When I try to write something like this the FMP "No Records Found" window appears, I must make a selection, then my custom dialog appears. I know there must be a better way. Any help would be appreciated. Steve

Is there a way to prevent users to close a FileMaker application with the little (x) in the upper right corner (Windows). I need to force the users to use a 'Close' button, so a script can run some needed routines at closing an application. TIA

I am trying to set a Print step within a loop that prints the current record rather than the found set. Unfortunately when I configure the Print settings and select Print Current Record, as soon as I close the Print settings dialogue it reverts back to Print Records Being Browsed which is screwing up my script. How do I lock the settings. Please Help! I am using a Brother HL1650 printer.

i created a custom dialog window using a script i wrote rather than using the custom dialog script because i need more than 3 buttons. I created a layout which i am opening as a new window sized to specific measurements using a script. I can't get the popup window to remain in the front while the main database page stays maximized in the background. As soon as the window pops up, the previous window becomes smaller. Is there a way to keep the main window open and maximized while displaying a popup window that is not maximized? thanks

Hello, all: I have a repeating field (DBCR Number) with 100 repetitions. In a second table, I have another repeating field (DBCR Mod), also with 100 repetitions. I want to write a script that copies the data from all of the repetitions in DBCR Number to the corresponding repetitions in DBCR Mod. I have tried using Set Field and specifying "100" for the repetitions of the target field DBCR Mod, but it only changes the value of the first rep. Can someone show me how to do this? Thanks in advance ...

I've got an application setup that uses the NetTools plugin to make HTTP POSTs to API systems. The response data comes back as a name-value pair string. Here's an example of what comes back: TIMESTAMP=2007%2d12%2d06T21%3a35%3a26Z&CORRELATIONID=e74307952e63b&ACK=Success&VERSION=3%2e200000&BUILD=1%2e0006&AVSCODE=X&CVV2MATCH=M&TRANSACTIONID=40F01918U88259749&AMT=8%2e79&CURRENCYCODE=USD I was shocked to see that FM didn't offer anything for parsing strings like this built in. I was able to find a custom Split() function that works, except that you can't pull data based on the paramater names. You just have to tell it which num…

i can't seem to get the "allow user abort (off)" feature to work. I am creatinga add record popup and don't want users to be able to exit the script . Here is the script: Allow User Abort [ Off ] If [ (Get (AccountName)) = "yalon" ] Adjust Window [ Hide ] New Window [ Name: "New Patient Popup"; Height: 350; Width: 320; Top: 100; Left: 100 ] Go to Layout [ "New Patient Pop-up" (hn database original data) ] ShowlHide Status Area [ Lock; Hide ] ShowlHide Text Ruler [ Hide ] Else Show Custom Dialog [ Message: "You do not have permission to perform this action!"; Buttons: "OK" ] End If Thanks Ok forget it I figured it out. I forgot to …

Has anyone heard of a solution or plugin that would fax a layout through a fax modem from FileMaker. I'd like to be able to fax orders directly from my solution. Thanks, Mel

We are using a set of files in stand-alone process (migration). This set of files contains (5) files used to process the migration and (5) files which are normally served. We want to run the migration from intermediate data to final solution without being stopped by the 'FileMaker cannot share a file ..." dialog. I believe the only way is to turn off file sharing on each file separately before the migration (then turn them back on after). But I just wanted to check if there is a way to handle it within a script because it stops the migration from running automatically. I've been clear through the Errors list and can't find anything which might help us. We can …

i have a MS Word template using merge from my filemaker pro database. i first export the data from filemaker into a merge file. then, open MS Word. then, do the merge. i wonder if i can do the process automatically via a script in FileMaker. thanks.

Howdy, all: I'm trying to learn how to implement variables but am unsure how to insert them and where. For a runtime solution I'm working on, the attached report-generating script is used for six different-named fields; the script is identical for each one save for the highlighted steps; that's where the different field names plug in but they all end up using the same print layout. For example, AC_Tail_Number is one field used in the attached script, Serial_Number is another field that would/could use the same script and so on for all six fields. If a variable is used I imagine it'll be a global one (?) Cheers, Rich

I have a feeling this might be a FAQ of sorts; apologies if it is (I tried to find it in the forums). Is there a way to trigger a script when a user tries to close a FM window (or, even better, prevent them from being able to close a window)?

I am having a problem with a quote form I am putting together. I have 14 lines which each line has calculations depending on each other. However in the description field, it will only hold 60 characters and I would like it to automatically move to the next decription line. I have tried to put together a script that would do this, however to no avail. Thanks for the help Scott

How do you script "go to layout" in a different file? Thanks in advance

Hi there I have a job for a client who is using fmp9. He has a Museum Catalog with a few hundred 'pages' of information. There are a number of feilds. It is a catalog for museum artefacts. There is a name, a catalog number, an illustration (image) field, some descriptons, size etc... We need to get the image out, which is possible by selecting the field, and exporting its contents. But we will need to do this 3,500 times. here is my question: Is it Possible to write a script, to start at page one, export the image and name it with the catalogue number. and move thru the whole list of say 500 pages and do this for every page. i.e. the script wou…

I have a database of approximately 10,000 records. Users do seaches for individual records and input changes to various fields. Need to figure out a way to detect when/if a change is made then call a script to export that individual record. Was focusing on the last modified field, but still not sure how to make it work. There is no script that currently runs to process record updates, so can't work it into that. Any thoughts would be appreciated.

I have several scripts that export XML in conjunction with an XSL style sheet to generate HTML. I would like at the top of each HTML file to have something like "(generated from the database on yyyy/mm/dd)" so that a viewer can easily tell how old the HTML data is that they're viewing (these are internal viewers only). The date of export is not in the XML that is exported (a surprise, that - seems quite a basic piece of info); for those of you familiar with XSL it will come as no surprise that XSL provides no built-in way to get current date; I have tried the xml-script element (to run javascript date functions) as well as the EXSLT date extension but apparently FMPro's…

Hello, When I use a custom dialogue box, I can either click on a button or I can hit enter to select the default button. However, I can use the keyboard to select the other buttons.Is there away to use the keyboard instead of the mouse in custom dialogue box? Thanks ahead for any help!

I have a timed script that runs on the server that calls various other scripts in several different database to do various import/export functions. Been trying to figure out a way to send an email out when the script stops for some reason. Was playing with the idea of creating a database specifically for that purpose, where it would run a countdown loop and the server's script would call it and reset it, so that if it's not reset then it would send an email out. But wary of the resoures used by a constant running looped script.

hi, i have a little problem I could use some help with. I am a new user (1 month) and have created a patient management database for the hospital department I work for. Its a simple one table database. I am worried that someone might delete a record by mistake or even all records by mistake. I know I can disable deleting but there is one user account I would like to give deleting privileges to. I thought a simple solution would be to remove deleting privileges for that account but create a script that would move that specific record to another table. That way the record would appear deleted but would actually just have been moved. How could I create a script to do th…

Very Novice...Hi I'm trying to create a script so that when I close the window of a particular layout in a related file, I will return to the layout that I can from. Is this done with one of the "Get" functions?

I would like to be able to perform a find and then import or copy the found set into new records in the same table while modifying a couple of fields in the process. I've tried exporting then importing but it's very slow. Any Ideas? Thanks, Mel

Hi, I would like to know how to open a specific document in the filemaker program either in word or excel. I am storing the docs in the database main folder itself in individual files. I am new to this. Can anyone helpme?

I have a database that tracks CEUs for teachers and have a question regarding how to script something. I have a Course table and a Student table. To bring them together I created a registration table for the purposes of placing students in their registered courses. I want to be able to check that a student is not registered for the same course more than once at the time the student is registered. For example, I have already been registered for Course X but a colleague of mine doesn't know that and tries to enroll me in the same course. What check can be run so that my colleague is notified of the duplication? Thanks!!

Is there a way to copying a field's contents to do a Google search in Safari? Thanks