Script Workspace and Script Triggers

Can anyone point me to dynamic sort examples. I have a large number of tables and i need to script sorting for each. • I do not want to use the built in dialog as it is too open to abuse. • Performance is a key consideration. many thanks Stuart

I am writing a script to create a PDF, and I want to send this as an attachment. I am using the "Save Records As PDF" Script step, and checked the option to attach it to an email message...BUT there is nowhere to specify the TO and Subject fields for this email (like there is in the Send Email script step.) Is there a way to work around this and specify the recipient, because I am trying to avoid the user from having to look up the address and enter it in the email message every time. thank you

I have a db which can be opened with several accounts with different privilege sets. I would like to set it up so that it opens to a specific layout depending on the user name. Ie. Admin would log in and see the Master DB layout Tech would log in and see the Maintenance DB layout Is this possible?

I am using FM 8 Advanced v3 with Windows XP. After I was routinely modifying a layout. I exited the layout view and FM8 stopped executing any script beyond the first one. Deinstalled FM8, deleted all files related to it, reinstalled it, created a new file, created a new script with one command (show custom message)-> it worked. I Added a duplicate record command to that script, scriptmaker did not execute the second step it but showed the message. All my older files scripts are not working either. Any explanation for this behavior. How can I fix it? Addendum: The problem was fixed after reinstalling AND restarting. Thanks

I have been using Get (Account Name) on 8.5 and 7.0 for a long time. I upgraded to FM9V2 this weekend and now Get (Account Name) returns my name on all desktops. Get (User Name) works. What is new about FM9 that causes this problem. Talked to support and they have no answer.

I have always used Get(Account Name) to get the current user for scripting. In FM9 it will not work any more, it always gets my account when run. If I use Get(User) it works. Is this a change in the function?

I wrote a system in 4.1, which has been ported to 6, which includes a function to allow a high-line video camera to take pictures and insert them directly into a container field. This was done with Troi Grabber. I am getting ready to re-write the entire database and want this same functionality, but Troi Grabber is no longer supported. I had heard 8 and 9 had this built in, but I can't find it. Especially, I want to be able to automatically choose between the iSight camera, and a high level camera hooked up via a video capture card currently installed in G3 Tower. Will want to replace this with a modern (intel) machine. Any ideas of script steps or plug-ins that…

I was playing around on the internet and found this script to auto import text files. So far it seems ok except for one problem. The script is as follows: Go to Layout ["ImportToDo"] Import Records [###; Include all enclosed folders; Text files] Go to Record [First] Loop Set Variable [$currFile; Value:ImportToDo::filePath] Go to Layout ["Destination Table"] Import Records [No Dialog; "$currFile"] Go to Layout ["ImportToDo"] Go to Record [Next; Exit after last] End Loop where ### is replaced with the folder I have all my text files saved. ImportToDo is layout where the file names are stored. The problem lies here Import Records [N…

Hello Group, I set up filemaker file sharing between 2 computers which uses a script that I call Opener.fp7. What this script does is to open a specified hosted file & then immediately closes itself, leaving the hosted file open on the client machine. I set the file options on the client machine to run this script automatically when the Opener file is opened. The problem with this method is that one specific machine must serve as the host & have the database opened first. I would prefer to have the script search to see if the main file is open & if so to continue running this script, if not to open the main file. If there is no solution to this prob…

In the "Define scripts" window how can I display the scripts in alphabetical order?

I have two fields Startdate and endate. They are used to display all records for the current month. A script sets the fields. the start date is a no brainer but I am having a little trouble with calculating the last day of the current month. I have done it for another script that shows the current week with no trouble. Thanks in advance for the help again

Sorry for such a simple question but I am very new to FMPro. I have a new database where a contact can have many addresses, phones, purchase orders and etc. The thing I cant get it to do is use a portal to add records related to the current contact. I created a set of tabs for the related items above and if I go to the layout of each and manually enter the items they show up in the tab on my contacts page. I can edit them then but I cant create a new one? Any suggestions for the newbie would be ery appreciated. thanks, tonyh :)

It seems very easy to put a script or a group of script into a group (I did this by mistake) - but how do you take them out?

File 1 has a number of accounts with passwords. File 2 needs these same accounts and passwords. Can anyone tell me the except script steps required using create new account to do this automatically? I think if I don't have it step by step, I'm not going to get. Thanks.

Hi all, I am trying to run a script that will run automatically when I close the database. I want the script to delete all records that are empty. ihave succeeded in creating such a script by searching for blank entries in "last name" field. Then I followed that up with a "delete records" command specifying all records found. This works unless there are no blank entries in "last name" field in which case I get error message and "continue script?" option. I would like to set a condition whereby if find request returns 0 results, the script is terminated and no error message is displayed. Any help would be appreciated! Thank ou, Yalon

I am having trouble with a script. I have a layout that has a container field. I use the container field to reference to resumes located on a server. I want to be able to take a found set and export the resumes for each record. Ultimately I want to attach said resumes to a new email in OS X Mail client. I want to at least be able to export the resumes to a set folder. Which I can then automate further. At this point I can export only one record at a time.

I have a file that uses a bar code scanner - It goes to the propper field and pauses the script, waiting for an entry. Here's the problem - the scanner scans the bar code, then puts a carriage return (It doesn't actually put the symbol there, but it's like you typed in the numbers and hit return instead of enter). What should happen is after the scan FMP should resume the script. But since the enter key is not being pressed, it does not see this. I cannot reconfigure the scanners as they are also used for other apps on the side, and so far with FMP they work great except for this one thing.

Can you or how would you have a dynamic file name in a Save As script step? Currently my db is backed up daily to the same named file. I've come to realize this is REALLY NOT a good way to do things. If My back up is corrupted it is my only copy. So I would like to save a copy of my files with a changing file name e.g. contacts942007.fp7; contacts952007.fp7, etc. Any ideas, suggestions. Thanks.

I am trying to perform a greeting script wherein if the time is between the range of values, it would return as an afternoon, morning or evening. This is what I have done... If [Get(currenttime) > "6:00:00AM" and Get(currenttime < "12:00:00PM"] Goto Layout() End If The problem is it won't execute properly. Tried to use another If script step but it would just bypass it. Can anyone help? Tnx in advance.

I have FM Server 9 Adv. and want to users through the Instant Web Publisher, not through a local FM Client, to add document links from other repositories to a given record as needed. Please assume the record file name and their networked repositories are well controlled. Thanks!

The input picture script has 4 syntaxes (if that's even a word) available. I'm using imagewin:/driveletter:/directoryName/fileName and it works great....for PC's. But the Macs that need to see the picture get a can't find the file error message. I've pointed the PC's to a mapped network drive, and am thinking I need to make a 2nd layout just for mac that uses the imageMac syntax. Is there a simpler way????

I would like to Save Record As PDF with input fields and then email the pdf to customers, so that they can fill it in and return. Is there a plug in for this? Tore

Hi, all! In the current solution I'm working on there are multiple buttons for users to select which scripts they'd like to run. The problem is, how do I prevent a second script from running while the first one is running? I searched the archives here and found 2001 post where a virtual latch was used so whenever a script begins to run, it causes a control field to turn to "1"; when finished with the script it turns that field back to "0". (In the beginning of each script there's a command to check the control field; if it's "1", the second script is terminate using a halt command, if "0" it proceeds.) I tried using the aforementioned script technique and i…

Hi, I have an issue where sorting does not appear to work, either as a script or manually. Let me explain. I have an inventory table, line item table and a purchase order table. The purchase order layout has a portal to the line item table. The relationship from purchase orders to line items and inventory to line items works fine. I can add parts to the purchase order and adjust stock with the purchase orders. In the purchase order layout, I want to create buttons on the labels above the portal to sort the portal records by the label. Seems simple enough, but I can't get it to sort. Even if I go to sort, select the LineItem::Description field as the sort to field, selec…

An inspector dropped an application on my desk/computer to make changes and I don't even know if it is possible. I need to change the way attendances to events are registered. There is a table with attendees, a table with events (every week Monday and Wednesday, Tuesdday and Thursday). Attendees and events have all an ID. Attendees are assigned to events with a technique that seem to be based on a demo on the NightWing site. Two portals, left portal attendees to assign, right portal events. With a button the attendees are removed from the left pane to land in the right pane. How it is now: There is an attendance table. A portal to this table is…

Hey guys, I'm sure there is an easy answer to this, is their a way I can export scripts, or save only scripts to disc, I know I can print them, but I'd like to have a copy on a disc. thanks in advance

I am trying to learn FileMaker 9.0 for PC on my own after working only with 5.5 for Mac. Is there a way to keep the group of records I "found" within one layout when I switch to a different layout? It did this automatically in the old (very old!) version I used to use. I work in a school and I need my teachers to "find their homeroom group" and then switch to different layouts for each subject to enter grades and such. Right now when I switch to layout #2 I lose the records I was working with in Layout #1 and have to find and sort all over again.

I have a rather large product database where each item has an individual SKU. I have a separate field which is a picture container field where I have a picture of the item that corresponds to the SKU. The pictures are all titled the exact same name as the SKU + a .jpg tag. Is there any way to automate the population of the picture field with a script? I can't seem to figure this one out.

I have a script that runs to check fields to make sure that everything has been updated. If everything is correct after the script runs. I’d like an invisible button to become visible that the user can click on for the next step. Thanks for your help, Milo

Hi there – hoping someone can clarify this for me...... I'm working on some layouts for a scheduling solution. The desired end result is a looping 'one-week-per-page' view of staff member's diary entries. Having created the basic database, I created a script called "autoview" along these lines: 1. Set viewerStartDate to Monday of week 1 //calculated from today's date 2. Pause script for n seconds 3. Set viewerStartDate to Monday of week 2 //adds 7 – forces viewer to update and show next weeks entries 4. Pause script for n seconds 5. Run script "autoview" 6. Exit script My intention was that step 5 would basically run the script again, with st…

Hi, I am using a script to cause a new window to appear so that the user can fill out a form on a seperate layout. After the user is finished, a button triggers another script to close the window and resize the original window. However, the layout "flickers" really bad when it loads. Is there anyway to stop this? Thanks, Nick

Hello, I'm a beginner with FileMaker and I have been trying to figure out how to write a particular Script for almost 3 days now. I need the Script to search a column of my records, count all the instances of the number 1, and insert the result into a layout (with summary fields), THEN search the same column for instances of the number 2, insert that result into the next summary field, etc. etc for the numbers 3 and 4. "Perform Find" and "Insert calculated result" work when I only tell it to look for look for #1s, but as soon as I tell it go back and look for the #2s, #3s, and #4s, it seems to erase the results of the previous find and I end up with the result …

Hi Guys, The following is the message I first posted on the Café. The response I received is shown as “ErrorScript” and the person said [color:red]“I am sure others will chime in on this, but here is my fellow novice opinion.” No one else chimed in so I don’t know if that means, this is the way to go or not. I just thought if you guys took a look I at least have a confirmation. The above works and I now need to know how to add 13 more fields. The If statement is clear and I added the fields with no problem. But the Set Field after the Else statement is a whole other story. My main question is, is the above a good way to handle this? Thank yo…

Hi I have a contact databse in filemaker 5.5 I am trying to set up an invoice database to create all my invoices from. To save typing every invoice I wish to be able to select client from a pop-up list and their address and contact details automatically fill in from the corresponding fields in my contact database. This should be very easy but I can't seem to work it out. I think my brain's on the wrong side. anyone help? If there's a better way I'm open to options. GBM

Bonehead question here, but one to which I cannot find the answer. I can't find any explanation in any books or the Help pages. In some scripts, there is the option of [Restore]. For example: Print [Restore] or Print Set Up [Restore] or Perform Find [Restore] What does the [Restore] part of the script do? This is probably something so simple that everyone else knows it! Can anyone share some knowledge with this beginner?

Can I have records sorted by an ALIAS calculated field but summaries and recap still refereing the "original" field? e.g. [color:red]ALIAS (Calculated) = [color:green]SALESMAN SomeField total (Calculated) = Recap(somefield, [color:green]SALESMAN) In the layout i do have Subsummary by [color:red]ALIAS You'll agree that order is the same...

Good morning everyone. I am a fairly new FileMaker developer -- okay four weeks in -- and need to automate a script's execution every time a record is viewed, created, or edited. It's a simple script to populate a field with a URL generated from another field in the record. Is there any way to make it automatic? I've added this URL field and would like to go through the 4000+ records and have it generate the thumbnail URL automatically, and then be able to have it do so when new records are added on its own. I can't seem to figure out how to do it without running the script manually, though. Any help is greatly appreciated. thanks, Aaron

My IWP clients get a blank screen if they try to commit a record which another user has open, or has inelegantly exited from. I'm trying (step 1) to provide a field that displays "Record is in use by 'Jane Doe'" Get(RecordOpenState) is giving me no joy, either as a calculation in a field, or as a step in a script. Can someone point to a sample? Maybe once my mental block clears, I can move on to step 2, which would be handling this error. Many thanks in advance. . .

I am a teacher and wish for some help in writing a script that will show a list of files in a folder on the computer. Here is what I am wanting to do: Create a folder called student files. Have the script pull a list of files from that folder and display them in Filemaker as hyperlinks that could be opened. I would want the script to return files by matching the first 6 digits of the file name. Example 123456_Smith, John PR1.pdf as the file name and 123456_Smith, John PR2.pdf and not get 123457_Doe, Jane PR2.pdf. I need to show the list in a window in a filemaker file so that I can print the record and on occasion I will need to print some of the files t…

Hi I have got a layout which caputers Company Information. Now what i want to do is whenever a New Company record is created then enable the button "Add New Contacts". If the Add contact button is enabled and clicked it will open the layout to add new Contact Information. My Questions Are: How can i enable a button when a record is saved? How do i pass the new Company Id and Company Name that was created on Company Layout to Contact Layout so that i can save Company Id in Contact Table? Once a Contact record is created then i want to show that record in Company Layout. I guess this could be done by scripting and would really appreciate a…

FM 8.5A, Mac OS10.4.10 Script imports a folder of images, located on the desktop. In an import records script step, Specify Folder location, the returned path is unexpected; The source folder is on my desktop, yet choosing a folder in defining the script step, yields the first path. Which I thought was curious when I wrote the script. It worked correctly on my mac however. The import did not work on another mac (with the correct source folder on its desktop . Redefining the import step on the other mac yielded the second path (i.e. 'normal') file:../../../../../Desktop/ImagesToImport/ file:../ImagesToImport/ I am curious to know why the firs…

Gday all, I've been using my database for sometime now and ti's been running fine, however for the past morning it's started throwing up errors. I haven't made any changes that should effect anything... Anyway - the problem! There are two two tables: Vehicles and Servicing. I've had a script where when you click a button the following script is utilised: Go to Layout ["Servicing" (Servicing)] New Record/ Request Set Field[sERVICING::kf_production_number; Get (Scriptparameter)] I would have thought that this was straight forward, and that it would create the new record, and bring in all the customer detials. As I said, this had been working, …

Is there a way to sort data while preserving actual sorting order. e.g. sorting by SALESMAN while already sorted by INVOICE will give me records sorted by SALESMAN then by INVOICE for each salesman. I know I can specify both sort order in a single "Sort Records[]" script step but i want to sort them using two script steps. I probably have to get rid of the "Restore" in the Sort statement. I have built a huge sorter script that sort on a specific column base on its name (switch-case), and a string tokenizer that gives me in reverse order all names specified on a comma separated list, but I suspect new Sort script steps to sort as if data were not actually so…

I'm am trying to set up a simple navigation system that stamps local globals with filename, layoutname and current tab (using its object name), so I can return to it from other locations in my solution. I have created 3 fields, current_filename, current_layout and current_object. I created a script which sets these fields using the appropriate function, Get (filename), Get (layoutname) but Get ( ActiveLayoutObjectName ) doesn't populate the "current_object" field. Thanks

Hi there, I have a table which lists activities such as: 12/07/07 Admin 10.00 12/07/07 Onsite 20.00 15/07/07 Admin 5.00 15/07/07 Onsite 30.00 15/07/07 Admin 6.00 I need to combine (and total) the records on the same day to an invoice table. For example: 12/07/07 Admin; Onsite 30.00 15/07/07 Admin; Onsite; Admin 41.00 I have a parent table listing jobs, so these entries would be under a parent "job number". I am hoping that someone can point me in the right direction of creating a script which can do this. Thanks!

I have a little script to find student records. Unfortunately, when the script runs, the “cancel” or “continue” buttons in the status area must be clicked before anything else can happen. I obviously don’t understand what is happening after the “Perform Find” step locates the record(s) and displays them in the layout scripted for either a single record of multiple records. I’ve tried some script steps like “Allow User Abort on/off” and “Exit Script” step but nothing works. I don’t want to have to run this database with the Status Area open all the time – screen space is so limited that I covet that one inch on the left side! What am I doing wrong? Here ar…

I have a database with 2 layouts: "Tasks" and "Done". Layout "Task" contains one field called "task" which contains all the various tasks I should perform. Layout "Done" has the tasks which have been performed on any given date. The question: Is it possible to generate a new record in layout "Done" by clicking on a record in layout "Tasks"? The new record would contain the task and the date on which it was performed.

Hi everyone, Looking for a bit of advice on using a script to send emails. I'm using Filemaker Pro v8. The application itself is fairly simple, just a database of bookings for a band. What I want to be able to do is send a quick email listing all upcoming engagements to players. (So they don't have an excuse for forgetting about them!) Each engagement is its own record, and somewhat annoyingly the "send email" script command only sends information from one record. What I'm wanting is information from all the records in the found set. I've defined a text calculation field, the end product of which is a summary of all the vital details for each engagement. (…

Is it possible (maybe with an applescript) for FileMaker to record the coordinates of the mouse. I'm curious about this because I was wanting a small window to open up where the mouse is. I know that if this script is attached to a button I can just do a fieldBounds function on the button. That works great and all, but what if your viewing the records in a list view? In a list view, the fieldBounds function is the same for every record. I've also thought about coordinating the content height with the record layout height and the record count. But that opens up another can of worms. Any how, I thought I would just throw this out there and see if anyone has a idea.

I want to set up an example layout that a new user sees when they click the "Sample" button. The way I set it up is I made the first record the sample layout and the way I'd like it to work is as follows. • Go to layout: Order Entry (Invoices) Now here's the part I can't figure out how to script or even if its scriptable. • Select Portal Row "Show Products" in Vendor_Selected relation. (its on this layout in the Invoices TO) • Select Portal Row "ID#26557" in Products_Category relation. (its on this layout in the Invoices TO) In this way everyone sees the same sample page and the written instuctions showing how everything works. Is this possible or …

It's a quick question and just need to make sure its meant to happen: At the beginning of a script: Set error capture (on) Set $temp = header id Go to layout step - where the layout's underlying table is not linked to the starting TO Find command based on $temp Check its the right number of records to delete then delete records command It seems that the "set error capture on" stops the go to layout from appearing which is fantastic just i cant see that its meant to happen in any documentation is this OK?

I have an application where the contacts are stored in one file and tasks are stored in another. Within the "tasks" file, on creating a new task I wish to enable the user to search for the org id eg as follows: script in tasks: perform script "quick lookup" from file "contacts" Set field tasks::org_id; get(scriptresult) Scripts in contacts: quick lookup (abbreviated): new window go to layout "quick lookup" loop Pause/resume script(indefinitely) end loop select company triggered by clicking on an item in the found list on quick look up layout set variable $chosenid; orgid close window (current window) exit script (…

I have a very simple database with records containing only a reference number and a container field with a pdf (reference) in it. I want to use a script to search the file for the reference number, then when it finds it display the pdf file. It looks to me like the Open URL step should open the pdf file, but either I'm reading it wrong or I'm just not getting the syntax for the file path correct (I'm on a mac). No matter what I do it always tries to open a web site. Now, I know that's what you should expect it to do, but the Filemaker help file gives an example of using it to open Notepad to open a text file. I could just have them double-click the container fie…

some reports have "control break" structure while some others don't. Is there a way to enumerate dynamicaly in a script all summary fields used in the current layout in a hierarchical way. - - - 8< - - - - - - - - - - - - - - - e.g. SALESMAN: John Smith __MONTH: January ____SALE 1 ____SALE 2 ____SALE 3 __MONTH: February ____SALE 1 ____SALE 2 ____SALE 3 getSummaries() = "Salesman, month" - - - 8< - - - - - - - - - - - - - - - That way, i'll be able to kinda automate sorting on this layout without having to specify "SALE::Salesman ASC, SALE::Month ASC, SALE::DATE" Once more, it's an ACADEMIC example.

I know there is a way to write script to go back to any previous page by using a global field for the layout#. Does anyone know how I would write that script? I want to go to from one specific layout to any page in the file and then I want a button that would take me back to the any previous page I was when I chose to go to the specific layout. Thanks Lester

Please please please someone have the answer for this! Problem: When user click the button (to activate a script) to send an email (using the FMP 9 client) they get an error showing dialog: windows messaging "the action cannot be completed". I do not get this error on the host computer, but everyone else does. We never had this problem until recently. Furthermore the company uses Novell Groupwise so typically we get that dialog for the profile and we click ok then it sends the email. Now that results in the error. Any ideas? Help!

We have a database hosted with Filemaker server 9 advanced, we have a volume license for Filemaker 9 for the laptops in the field. We wanted to have everyone just work remotely using their aircards. The problem is their field work is done from hospitals, there is usually no signal. So plan b is that each user will have a copy of the database on their laptop and when they get home at night they can remote into to the remote database and run a script to update the records that have changed. I need to write a script to do this but I was wondering if there is some trick to synching.... is there a plugin or something to make this process simpler? I'm worried about data integer…

Just wondering if there is any way to insert a global field in the edit find request criteria, or if not, what is the best way to use global fields to perform finds? Thanks

Hello! If a script contains a non-web-compatible step, FileMaker doesn't skip it and continue with the rest of the script, right? Instead, it just ignores it and doesn't do anything. But you need that step when you are in the network side. What "If..." statement can you use to address the script to the right way depending on where you are? Any suggestion will be highly appreciated.

hello all- Can anyone tell me how to write a script that will allow me to click a button on a layout and a scanned signature then appears in a container field? I'm also trying to figure out how to tag or flag certain medications (psychotropics vs nonpsychotropics) so that only the psychotropics will appear in a portal on a report layout. Any ideas will be greatly appreciated. Thanks.

Hi, Say I have run a search and x number of records appears in a list view, the status bar is hidden from the user. How do I create a box that displays the number of records found? thanks Shaun

I'm still very new to FM and scripting so please bare with me. What I would like to accomplish is this: a simple IF step where: if the records found = more than 1 it takes me to a certain layout and if the records = 1 it takes me to another layout. Could someone please show me an example of this. Tks Shaun

Hi All I am trying to write a script that calculates the thickness and width of an reinforcement pad. I have asign one variables with the starting width and another varible with the starting thickness but would like to change the varible entity if they need to be wider and thicker. This is what I have done so far but it does not quite work. Set Variable [$dp; Value: Field a + Filed b] Set Varaible [$te; Value: .375 If[if(area_required > total_area; A5=($dp*$te);"")] endif loop If[case(area required > total_area; $dp=($dp + .5) and $te=($te+.125); A5 = ($dp*$te)] endif If[area_required < total_area] EXIT Script [] …

Is there any way to resize or move the custom dialog window via scripting?

I'm using a function from Nightwing to log changes in fields. The field that logs the changes is a text field with insert calculated result. It works fine if you click in another field after editing the field, or if you navigate to another record. But - This layout is set up to not automatically save changes, so my users like to use a Commit Record script. That's fine and dandy, except that the log field that tracks changes does not refresh when you commit via a script. I've tried throwing several things in the script before the commit step to trick the field into refreshing, but apparently nothing is the equivalent to clicking another field with …

What's the best way for me to UNHIDE all windows? Thanks, mvreade

I need to create one record in a second table for every possible group of records in the join table. To clarify, the join table contains multiple records with the same ID. I need to "group" these records (I assume by a sort). There are a couple things I need to do: 1. Gather the quantity of a field into a variable for the group of records which i will then pass to the single record created in the second table. 2. Assign a type value for the record in the second table based on type values in the group of records. For number 2, lets assume that the type field can be assigned one of two values (A or . If all records are type A, then the value is A. If al…

Hi, I have a database with create date and modified date. Create date is the date that is automatically entered when a new record is created and modified date is the date that is automatically entered if a specific record is modified. I would like to get/write a script that will send me a reminder email if a specific records modified date is >=60 days from the currrent date I run the script. Any help on this is greatly appreciated.

FMP 8.5v1 Adv , Mac OS X.4.10 This problem still persists, the using layout component of a go related displays completely incorrect detail: while the actual script definition is: Go to Related Record [ From table: “Letters_status”; Using layout: "Letters" (Letters - table) ] the display in ScriptMaker is: Go to Related Record [ From table: “Letters_status”; Using layout: “Prescriptions” (Prescriptions) ] While one has tolerated this for years, I had never noticed that the error carries over to print. This was brought to my attention by a client, who had requested a minor modification, and I had sent them a copy/paste extract of the print/previe…

Here's another one that I would guess is pretty common, and I hate reinventing wheels. So I wonder if you have one to share, or should I start from the beginning? I would like to have a script to recognize birthdays for my top layout. It would recognize that we have today's date, and a group of people who have birthdays, and upon opening it would say "Today is John Doe's 29th birthday," if in fact it is. (Otherwise, nothing.) Is this one already written, sitting in an archive somewhere? If not, would it be easier if the month and day fields were separate from the year? I'd appreciate any input before starting this. It seems like it should be simple enough,…

One more silly question: How can you prevent double sign in (same user used in both network and web) or same user in two computers? Sorry, if I ask is because I've exhausted all possible options. Tks.

Hello. I'm an absolute newbie to scriptwriting but I need to fix one problem with a database. It's a search db for a sound effects library. when one finds what he wants in it and clicks on the track he found the track is being played in media player. The problem is that it only plays .wav files. I need to make it play .mp3 as well. So I found this script in my .fm7 file (it's OPEN URL category in Edit Script window) GetAsText ( Hollywood_Edge_SFX_Win::Path to soundfiles ) & "/" & GetAsText ( Hollywood_Edge_SFX_Win::Set Code ) & "/" & GetAsText ( Hollywood_Edge_SFX_Win::Disc ) & "/" & GetAsText ( Hollywood_Edge_SFX_Win::Disc ) & "-" …

Hi everyone, I just found something I thought was taken care of but wasn't. When a customer selects a product from the Product pick list that products information is shown in a portal. After the customer reviews the product information they vote yes or no. If they decide they are not going to vote on that given product they click a button that deletes that product from the portal. The question is how do you handle a situation where the customer does nothing? When they don’t vote yes or no or click the delete button. We only want records where a vote has taken place. How would you write a script like this, that without a Yes or No vote the portal row is …

Hi All, I have a database that has several different tables. Yesterday, I was trying to tie all the tables into one report. I had copied some scripts and layouts to test and figure out how to do it. On one of my copied scripts, I created a Find with a specific sales rep name. I have since deleted that script. Now one of the standard reports I have (worked like a charm before!) only pulls the data for this one sales rep?!? I have deleted, re-written, followed every step to make sure that I'm not missing anything and I can't find the problem? Could it be stuck in cyberspace, a bug? Any help would be appreciated.

Hello Newbie here. I've come across this set field expression in a script from the free FM Business productivity solution that I'm dissecting to learn more about FM (v8.5) The expression is "set field (customers::temp data, customers::fullname)"; can someone please take the time to explain exactly what this does ( tried googling). I know it has something to with a relationship dealing with the customers file but I have no field named temp data- where does this come from? Thanks to all that take the time to enlighten me =) Jack

In my contact database I'd like to be able to set up a button that activates a script that can print a merge letter for any single contact. What's happening now is that the script merges the contact data for all the records in the selection. I can't figure out how to write a script that first selects only the current record before doing the merge and print. Any suggestions?

I have a field with is a auto entry field.. which has a relation to a unique serial number. The Serial number starts with P0000 and increments by 1. I have a script that needs to check for the existence of the P number... how do I do this? If the serial number is say P1024.... I just need to know if there is a P number there.

Hi I have a g_Date field in Globals table where I enter a date. This field is defiend as Date field and storage as Global. When I click a button, the data from g_Date is put into d_date field in timesheet table which is defined as Date also. This is done using Script Step Set Field Problem is this: g_Date value is 2/2/2007 d_date value is 2/2/2007 This is fine but g_Date value is 02/02/2007 d_date value is still 2/2/2007 I would like the d_date value to be whatever is entered in g_Date without any formatting. Please Help !! :)

Has anyone run into this problem? I have a 1500 person mailing list and if I use a script to send the email filemaker crashes with an unknown error. I've tested this on more than one system with the same results. I'm not sure what the exact number that will cause a failure but it's about 1000. I've had to split the email into smaller groups using 3 scripts with a constrain record set step.

Hi everyone, I have a weird problem.. occasionally, a user reports that they end up on an unintended layout. A few of the scripts that end these users up on this unintended layout are simple go to related records scripts pointing to other layouts. Has anyone ever experienced anything like this??? any ideas what I should look into, think about, etc... ?

Hi all, I am fairly new to FileMaker and I have been tasked with re-doing a GIS application program in FileMaker. So far all is working until now. My problem is that I have farmers who farm specific crops and a data file that contains information related to those crops. I would like to allow each farmer to create a value list on the fly of crops that he grows on the farm, and then add those fields to the table that contains the data via a script. For example: Farmer A grows tomatoes, corn. he enters tomatoes, corn in a portal (or something) to create a value list of tomatoes corn Then I have a base table called Materials - containing chemicals he mig…

Hi, I would like to check if a file exists before performing an operation on it. I have tried using the troi file plugin's example which modified slightly for me looks like this: Which unfortunately always returns YES. INVENTORY::ImagePath is a network path which looks like this "INVENTORYIMAGE.JPG". If anyone has any idea's, or even another way to check i would appreciate it very much. Thanks in advance, Jason

I am having trouble with the following script: I am on Invoice layout and have a button “New Customer” with script that should do the following: - Open a new window based on Customers table - The user creates a new record (new customer) enters data - The user clicks on a “Close” button on this “New Customer" layout to close it. The user is allowed to close the “New Customer” window only if Name and PhoneNbr fields are not empty. What I have so far is: New Window [Name: “New Customer”; etc…] Go To Layout [“New Customer”, etc…] Pause/Resume (Indefinitely) ------> (to allow the user to enter data) : -------> I don’t know what should come next …

Based upon how you logged in (via IWP or Filemaker client), can I direct you to a specific layout? What would that start up script look like? Any help/hints/clues would be greatly appreciated Thanks in advance

I have a USB Bar Code Scanner interfaced to my Mac for data entry. First a scan of an id bar code is made. Then the operator has to tab, return or enter using the keyboard to advance to the next field wherein the scanner scans the chemical or supply being checked out. I am trying to find a way that FileMakerPro will automatically advance to the next field once the data is entered.

I bet this is an easy one but here goes... I want to, through a script, go to a specific field that already has data in it and have the cursor move to the end of that data. help would be appreciated!

I have a database with numerous layouts including a layout called "Notes" I'm trying to write a script (Notes) which will let me open the "notes" layout from any of the other layouts by using a button make an entry, copy the record number and go back to the layout I came from and enter the record number in a field called "notenr". So far no problem---as long as I always use the same layout to start with. The problem is that scriptmaker forces me to write the "go to field" or "set field" command in the form: layout A::notenr meaning that whatever layout I came from, it will always return me to layout A, the layout written into the script. But I want to be able to …

I have a script in my primary file that processes records in that file and updates/adds records in a separate "log" file. The script finds an existing log record using a relationship between the two files. When a new record is needed, the primary script performs an "add record" script in the log file. While I was updating the primary script, I noticed a "Commit Records" step following the setting of several fields in a log record. I disabled that step because, at the point in the script, I did not want to commit changes in the primary file. Everything seemed to keep working as before ... until I opened the log file and attempted to delete a record. FileMaker…

I have a ContactsID in my Contacts Table and a ContactsID in my Orders Tables. What I want to be able to do is click on a button on my Contacts layout and go that ContactID in my Orders layout. Thank you, Carl

Hi, I got a simple database that include 3 layout (job info, submission and billing information). In the job layout i got 2 portals rows (1 for submission and the other for the billing) i just want to know how to copy all the portal row of submission of a job to the billing portal row of the billing of the same job. I don't want to rewrite each time exactly the same information. i'm sure that a simple script can do that. Thanks for your time MERLIN_ti

Hi All, I have a field called “b_number”, how do I write a scrip asking to find the biggest number at b_number field andafter found I will have the add from the b_number +1 added at b_number. Any help will be appreciated. Thank you in advance. ;)

That escapes me =( Trying to have the contents of one field ( contactid) in a contacts db copied into the same field in db called products. According to the function reference guide, the function to use is the set field. The syntax for this is "Set field[ product::contactid; contacts::contactID]. Here is the problem... no issue with using the specify target field to create "set field[product::contactid" portion, but cannot figure out how to add the remaining portion (the value or formula according the function reference manual). This is probably too obvious but it is late at night. What am I overlooking? TIA. Jack P.S. dbs are linked by a contact id r…

Hi! I've just made a ton of changes to the scripts in a development version of my file (one with test records that I've entered) and I'm ready to import the modified scripts into the live version of the file (the version without any test/debug records inserted). When I import a script, every button object in the entire database loses its connection to the imported script. Is this a limitation on importing scripts?!?!?!? If so, that's a pretty significant failure, if you ask me. It seems amazingly bad for FMP to be unable to retain a link to a button object for a script that's replaced with an imported one. If I'm missing something here, please tell me how …

Hi everyone, I am pulling my hair out trying to figure this out. I have to files that are related with a cartesian. If I create a button and attach the script step GTRR it works fine. If I put the GTRR script step into a script and attach it to a button, it does not work. I have even tested it in the script with only the GTRR step in the script and still nothing. What the heck am I doing wrong? Mike

Does anybody know if it is possible to run a script when a user moves out of a field. I have for example a global search field on and currently the user has to enter their search key words into the field and then click the search button which run the search script. What i would like to do is have that happen when the user presses enter which then exits the filed. Any ideas would be most appreciated.

Hi, Is there a way to pass the "self" function as script parameter? Will be great for lables...as I have 700 of them and each one needs to "tell its story"... So the self function can save me 99% of the scripting time... I tried with evaluate("Self"), but its not woking...

I've been trying to find a way to specify that the output file for a scripted export be sent to the user's desktop (or Documents folder). I need to be able to enter that path information but I can't find a way to do it.

HI Everyone I am wanting to open another file from the present location, but if it is already open i want to just goto that window is there a way of saying go to "A" window if the file is not open, open it the reason i need to do this is because there is a start script that clears some global fields and if its already been opened i need to be able to flick back and forth without the fields being cleared. hope i've explained it clearly thanks sarah

The duplicate record button almost does what I want to do. In my daily diary I have some fields which almost always are the same (like my location, how much I spent for another night in the hotel, and some others). I also have a date field which changes every day (what a concept!). What I want to do is create a button/script to add a new record with some of the fields already filled in and increment the date to the next day. Can someone get me started with this?

Is it possible to search a hard drive for files (ex: *.mp3, music files), and create a record containing the file name, database path, etc, for each file found?