Script Workspace and Script Triggers

I am trying to make it so that if a Field "Reversible" is set to "Yes" then it will display an image up the top. Now i have made the Field "Reversible" and also "Reversibleicon". I have typed the following into the Calculation on "Reversibleicon" and made it calulate to Container, however it is only saying the image location and not displaying the image. If ( Reversible = "Yes" ;(Get (DesktopPath) & "Donuts.jpg") ;"" )

Hey, Im working on a database that will help teachers grade. Its basically a rubric that allows you to pick from the rubric options and then spits out a total score and a summary. I have my layout ready to go, and I can save ALL my records in one PDF, but I need to be able to save each record as a uniquely named PDF. I know I need a script for this but I have no idea where to begin, or how it should look. Any body have some pointers/ideas/help?

I made a solution to increase and decrease a bar in a chart with drag and drop. It can also be used as a slider object. It also shows a technique to drag and drop between records in list view. Todd Geist made a challenge on his podcast to make a bar that you could drag to move and to expand and I took the challenge. If you have any ideas how to improve it please write a comment. BTW, please check out Todds nice solution to use conditional formatting and make simple bars. You find the drag and drop solution here. http://filemakerbloggen.se/post/Drag-and-drop-for-Gantt.aspx

Hi Hope I'm in the right place. Is it possible to have a Pop Up Menu or Drop Down List for an input field that is in a custom dialog box in a script? Right now i'm on Windows with FM 8.5 Advanced Thanks in advance.

This relates to post 202,791. I have set up 2 script triggers on a field. On the Mac when you enter the field script 1 is triggered which stores the current value in a $$Variable. A pop up list then appears and everything rests in that state. The user picks from the list and the 2nd script is triggered which captures the new value and does whatever. In windows the variable is stored, the pop up list appears and then disappears and the 2nd script is triggered as though the save/exit state has occurred causing the OnObjectModify trigger to act. Same for OnObjectSave trigger or the OnObjectExit trigger. Only happens in Windows. If I remove the triggers then th…

Hello Experts I am new to Databases, so please bear with me: I am looking for (or trying to develop) a script that will allow me to merge two similar records in the same table, and then delete one (or both) of the original records. This is a basic example of what I want to do: Record one Event: EV00162 Name: Jimmy Case: Ear Ache Time In: 12:00:00 pm Time Out: Record two Event: EV00162 Name: Jimmy Case: Ear Ache Time In: Time Out: 4:00:00 pm I want to merge these two records so the "time in" and "time out" fields are both populated in a single record, then I want to delete the incomplete records. ... Is this possible?

Hi, this script works only for the first of a 99 item repeating global field. The field A is a local field with 99 repetitions. I'm trying to get 99 values from a repeating global field named "A" to change the values of a global field with 99 repeating values named "B". set field [filename: global;filename::a] Data is the following: value of repetition 1 of field A papa Value of repetition 2 of field A quebec value of repetition 3 of field A : romeo etc. value of repetition 1 of field B ( global ): blank ( all are blanck ) After running the script the result is the following : Value of repetition 1 field B : papa Value of …

I'm trying to build a quick "simple" database that will allow me to write several XML files based on a template. The template has "smart quotes" that need to be preserved, and so far NOT escaping them has led to AppleScript errors (used to write the XML back out to a file) but escaping them actually puts "regular" quotes into the text file. I tried replacing the smart quotes with decimal numeric character references but that doesn't work for the application that needs to parse the XML I'm writing. Anyone have a suggestion?

I've added a script trigger to a tab panel to check a global variable. If the variable is true, then bounce the user back to the tab object they were last in and provide a message. However the message displays twice. Here's the script in two variations: If [$$CurrentTab.People = "Addressing.Edit.Uncommitted"] Go to Object [Object Name: "Addressing.Edit"] Show Custom Dialogue ["Error"; "Error message.] Exit Script [] End If Displays the Addressing.Edit object, then displays the message, then displays the message a second time. If [$$CurrentTab.People = "Addressing.Edit.Uncommitted"] Show Custom Dialogue ["Error"; "Error message.] Go to…

On page 4-5 of the FileMaker Training series book near the bottom it says: "With script triggers that execute prior to the event, you have the ability to cancel the event that triggered the script by using the exit Script script step to return False." I sort of get what is being said but can anyone clarify or have an example of this?

Hi I want to do a script which will put a certain number (eg 100) into a repeating field. I know how to populate the 1st repetition but is there an easy way I can program the script to put the number into the 2nd repetition if the 1st repetition is full and so on? I have 6 repetitions and I would prefer to not have to do a long winded script. thanking in advance

I have a FM file I made for purposes of Inventory, sales and purchases. While the file is working nicely and does what I needed it to do I realize that not everything was made in the best way and probably can be improved., I intend to do so as my skill hopefully increases... I have a script on Purchases layout which basically creates an invoice for all of the purchases. The purchase layout / table is made so that you can just go ahead and type in all of the items you want to order, once that is done you hit print button and it sorts the purchases by Vendor and prints out Purchase forms for each individual Vendor. I also have a script which then creates actual I…

If you set a variable within a script and then use perform script to call another script, does the variable carry it's value through the new script as well?

I have a situation where I need to save the current value in a field in case the user cancels the subsequent triggered script on save. I have a trigger on enter and the the save and this works a dream on Mac but fails 4 out of 5 times on Windows. Has anyone else experienced this sort of behaviour? To confirm - it is OK to have two triggers on a field - ie enter & save as I am doing?

Good Morning All, I have a field that holds a return seperated list of keys. Can anyone tell me how to go through a found set and remove a selected item from that list on each record. Thanks

Hello, i've created a database registrering surgery data. A patient will under go a certain surgery and will have certain techniques applied. I've created portals for each of these techniques. These portals have a script to add the selection to one join table. This works allthough for one patient this script creates for each technique a new record in the join table. To keep the number of new records down I tried to solve this by adding a "go to portal row" scripts step so each technique is added in the same portal row. This creates two problems: 1) when I don't make a selection in the first portal there will be no record at all in the join table. 2) …

I would like to create new fields using information entered via an entry screen. For instance, if "Bank of America Visa" is entered the script will create a field with the name "Bank of America Visa Amt" and a field with the name "Bank of America Visa Amt Sum" which is a summary field. I have not been able to find any information on this question so it must be too simple or is not needed by anyone else. I am using FMP Pro 9 Advanced on an XP machine. Thanks for any info. Jware1939

I have a relationship to filter a portal. I want to use OnObjectKeystroke to update the portal as I type. The script is firing, but the Refresh command (with and without the two switches) isn't refreshing the portal. The only way it updates is if I tab out of the field. What is the solution? Thanks, Will

Hi u all have seen this using OPEN URL script step of filemaker. "mailto:[email protected]?subject="helo">mail" I just want to know if we can add another attribute like the subject . I want to attach a file too that is on the client. once the mail button is clicked outlook is to be opened with to as [email protected] subject as "helo" and attach as "somefil.txt" which is on the client Is it possible? Please guide.

I'm working with script triggers and noticed that if I hold down the Command (Apple) key along with any other key, the OnLayoutKeystroke Script Trigger doesn't work. Does anyone know if there's away around this or why it does this? Also, does anyone know if the same thing would happen on the PC with the Control key? Thanks in advance!

When using the "set variable" function, is it possible to select the value iteratively from an external list — i.e., not from a table within the database, but from either an external text file or from a multi-line list to be pasted into a dialog box by the user? Such a list would, ideally, hold one item per line or else be comma separated. Thanks!

I find that I can correctly generate the function GetValue ( List ("text1" ; "text2" ; "text3" ; "text4" ; "text5" ; "text6") ; $$i ) (where $$i is an iterator). But when I replace either List (…) itself or the parameters of List (…) with the name of a text field belonging to another table in the same database (whose records contain the same values shown in the list above), the GetValue function is not correctly calculated. I am entering the name of the field as: other_table::name_of_field I have also tried replacing the name of the field with a global variable, but still no go. I'd be grateful for any suggestions as to how to fix this.

I'm wondering if there is a way, within FMP, to time the elapsed duration of a script and see the result with more precision than simply whole seconds. In order to time a script, I use the following as the first step: Set Variable [$starttime; Value:Get (Current Time )] and the following as the last step: Show Custom Dialog ["Done" ; "Time elapsed: " & Seconds( Get(CurrentTime)-$starttime ) & " seconds."] That reports elapsed time in whole seconds. Is there a way to see elapsed time with any more precision, but without calling Applescript or other external functions? Thanks!

When importing records from a UTF-8 file (which may have extension .u8 or .txt), I have no trouble getting FMP to recognize and display the contents of the records correctly when I do the import manually. But when I do the step as part of a script, for some reason the character set reverts to "Macintosh" every time I run the script. What ends up getting imported is therefore gobbledygook. I am specifying the data source as a file (have tried ending filename with extensions .u8 and .txt, to no avail) checking "add new records" when specifying the import order peforming without dialog. If I perform with dialog, I can manually set the character set to…

I'm trying to write a script that does a find and then generates a Invoice report based on the user inputs through a Show Custom Dialogue box, but I'm confused. How do you tell the script to take the date range that was given by the user to do a find within that invoice date field etc? Can an input fields be a button choice? I need the user input two qualifiers for the find. One is for the invoice date range and the selection of "Invoice" from a drop down list, that would also include values like "quote", "pending"... i.e. the dialogue box shows the input field for date range (button 1), the drop down list for "Invoice", "Quote" and the third button would be to…

Dear All, I'm wondering how you all create new serial numbers. Here is the background. We have a core service provider who require requests. Within the request is a list of histology blocks. A histology block (paraffin wax with tissue in it) can be sectioned like cheese. These sections are put on to slides for us to analyze or manipulate. These slides need the serial number because it tells you how far within the original block you cut into. Right now the button/script, From the histology block line item - GTRR to slides, sort by the serial field, capture the last serial number and add one and create new slide set field with new serial number. …

I'm working in Filemaker 6 and am getting this error message which I suspect is related to having to many files open. But I would like to know if there is something specific that is causing this. A Google search yields no results.

Hi, I'm looking for some help here. I've read posts and knowledge Base topics and the Help Guides and i'm stumped. I have a script in FMP9 that produces a PDF and emails it. I want to send it to multiple recipients. My Send Mail Options are Create One email using data from the current record. It says clearly (to me anyway) that I should be able to put multiple email addresses in the TO line of the "Send Mail" Options - separated by a semicolon or carriage return. But whenever I try to do that I get the error message "An operator (eg. + - . . . ) is expected here" and cannot add another email. Today I am at work on OS X 10.4.11 Any help would be grea…

I know this is probably silly but I want to make sure I'm reading this right. The Show Compatibility box upon choosing SERVER will tell me which commands the version of server I'm using will recognize so any greyed out commands are not compatible with that version of Filemaker Server. Is that correct? Dom

I am trying to write a script which will start at the first record of a found set and work progressively through all remaining records of that found set. While I have some idea of how to do this, I would like to know what script step I would need to write to compare a field from the previous record with the same field of the current record. If the contents of both fields are identical I want to perform a function, if they are not I want to perform a different function. It's how I write the comparison part of the script that I would like help with if possible.

Is there a technique available to detect the currently active tab on a tab panel? I'm not pleased with my workaround which requires high maintenance — using a global variable to achieve the same thing. What's the recommended technique? Appreciated.

Hi, I am on the SendMail issue --big time : So-I have a Sendmail script setup to work with SMTP and it seems to be operating just fine! I find "groups" of users, from 2-600< to send messages to and I ALWAYS put in my gmail account as one of the recipients to make sure everything works---i.e sending mail The problem: Sometimes when I send out a "batch" of emails, I get the "Can"t send Email(s)" dialog message from FM Server. Howver, each time I get that message I also correctly receive the email in my gmail account. I am making the assumption that the most/vast majority of emails are going out correctly ---and only improperly formatted or non-existing ema…

Hi, I am using FM 10 Send Mail. In the message box I have placed the following information: "Dear "&applicants::first&" "&applicants::last&",¶¶" & "Congratulations on your appointment as an ALC Elementary Nurse for Summer Session 2009. You will be working for the following program(s): " & applicants::SITE_ASSIGN1_NAME & applicants::SITE_ASSIGN2_NAME The applicants first-last fields are text fields and I am having no problems formatting a SPACE between them . The Applicant Site Assign fields are calculation fields and while I do see the field information when sending the email and I am having no luck trying to format 1SPACE…

A couple of variable questions: 1: I am trying to build a running list of actions completed by the user in a variable that will later be inserted into an email. I have a variable pulling data, but how do I "stack" the data? I have a loop built, but it seems to be overwriting not adding. the variable is $mfgrel_list the line in the loop is: set variable [$mfgrel_list; value:$mfgrel_list & ¶ The hope was that it would append the data by grabbing the existing variable data first, then adding the current record data to it. 2: What is the best way to view this variable in a layout? I would like to have a "status" window that displays this …

If[Filter(Job::Check Box Details; "Motor") = "Motor"] . . . . End IF It Never Enters Even When the check Box For Motor is Ticked. Any Help Would Be much Appriciated

I have a Variable Set equal to a job number then i want to search later in the script for that job again. At the moment i am using Perform Find [specified Find Requests: find Records; Criteria: JOB::Job Number: "$$Job_Number"] [Restore] However when I run the script it says there are no results with those find requests. I don't understand that because the variable is equal to the job number so it cant not be eqaul.

I am trying to setup a small database in FMP8 that allows FMP to generate a file, save to a location and then attach this to an email for sending, I am stuck as the only script option for doing this seems to be the SAVE AS option and create file as an email attachment, this works fine but I would like to populate the email to, bcc, subject and Body with some information from the same database, any ideas on available plug-ins etc etc as I am totally stuck.

Just picked up FM 10:) In a table, Contacts, in setting a date from the pop calendar for appointment with a date, say, for 3 weeks down the road, I want FM to alert me, when that appointment three weeks "later" arrives via a bouncing dock icon (as FileMaker will always be open) that I have an appointment. So far I have created an event script and want that to go off when the appointment date = the current date, but am not sure how to go further,if this is the right approach .... Does FM 10 has built in scripts that enable this feature?

Hi, I created a test DB to try and script a way to pass along a customized date into a new record when it is created, but it always creates the new record with a blank field. Can someone see why this script is resulting in a blank? I've attached the database, I'm using FM 10 for the Mac. Thanks for any help! date-script.zip

Hello and thanks! When my file opens a script is run which creates a new blank record and populates a field with the Date of creation. What I need is a second field to be populated a certain way based upon a time range from the date created field. example: If the record is created between 07:45 AM and 08:15 AM, then a field named "SHIFT" will be populated with text that says "Dayshift - 0800-1600". Is this possible? Thanks again.

Hello, I'm using a pop-up window that enters find mode as a method to search the database. I'm not very fond of pop-up windows, as they can get "lost" if the user accidentally clicks outside of them. So, I'm using the "pause script" script step to make the pop-up "modal". There are two buttons within the pop-up: "Cancel" and "Search". "Cancel" resumes the script and closes the pop-up, while "Search" performs the find and changes the pop-up layout to display the found set as a list. I also have keystroke triggers, set on every field within the search layout, to trap the return and escape keys. "Return" is supposed to be like clicking the "Search" button…

Hi, Is there a way to get the script stack or at least the script referer? Thanks

My clients are having trouble with a script that I wrote under FM7 that they are trying to run in FM10, and I am completely stumped. The script runs fine on my machine under 7, and it even works for me on FM10 trial version. For my clients, though, the script locks up in an endless loop (but only under 10). The script (listed below) is supposed to locate the next date whose day name matches the customer's delivery day (which is determined by which site the client gets their deliveries at). Once the system has found that the days match, it checks to see whether the date is found in a table that lists dates that my client is NOT working (holidays, etc.), and if th…

This is happening in two of my databases. The first is in my customer database. I have a button in another database that runs a script to open the customer database and allow the user to search for a customer. The window itself is probably only a few hundred pixels tall or long. The script is as follows: Select Window [Current Window] Show/Hide Status Area [Hide] Adjust Window [Resize to Fit] Go to Layout ["Find Customer Info" (customer)] Set Error Capture [On] Enter Find Mode [Pause] Perform Find [] Set Error Capture [Off] If [Get( FoundCount ) = 0] Show Custom Dialog ["I have a custom message here"] Show All Records End If When t…

I have a bowling database. What I want to do for speedy input is when the user enters a score in say game 5, then continues on to game 10, i want to have filemaker advance to the next record when it hits game 10 instead of going back to game 1. Any input would be greatly appreciated

I am working on a fairly complicated database that uses many parameters to set a fee structure. Most of it is straight forward and I have completed all but two input screens out of 50 or so. However, I am new to scripting and I need some help. Here is what I would like to do: I have a value list with 8 different text parameters. I would like the user to be able to pick one of the 8 and have that choice trigger a calculation (a fee related to the choice) that is put into another field which is then used in another calculation. So, right now I have two fields, one requiring a choice from the value list and one to which I need to point to a calculation that will provid…

I've been playing around with the OnLayoutKeystroke trigger. Interestingly, the trigger works regardless of any layout object having focus-- as long as the window has focus, the trigger works. While this is great, the pop up message "Before typing, press Tab or click in a field, or choose the New Record menu command." will still appear after the script runs, which is... weird, to say the least. Is there a way to prevent this pop up?

Hello! I´m working with a solution that works with dates, a date range for example May 1-7, May 8-14, the solution already gives me this range of dates and each day in some fields, the problem is that I don´t know how to do this range of dates for example when is May 29 - Jun 4 the whole week goes between two different months!! my question is if somebody knows how to do this in filemaker or if there is already a funtion in filemaker that has something like nextday function and with that is easier to pull it off. I´m working with FMP 9 Advance thanks people BluiSh

So I have a database that I use to order 'scans' from an outside vendor. Each scan has a unique name and also a 'scan length' in frames. I receive from the vendor a text file showing what they've completed (which shows scan name and scan length). I have imported this into a new table. What I want to do is compare the two fields and if they match have the field (or a separate field) turn a colour and if they don't match it turns a different colour. example Scan Ordered: [color:blue]Name / Length ml_076_010_pl01_v01 / 56 ml_076_020_pl01_v01 / 45 Scan delivered: [color:blue]Name…

I need four separate fields to change fonts when "no" is chosen in a value list in a fifth field. Is that possible? Basically I need the other fields to become bold, but using Arial Black vs. Arial works better than bold does.

Hi, As you can see in my demo, I have 4 entries (repetitions) I click on "preview" and it takes me to a layout with all 6 container repetitions. at this point i would like to create a script and be able to click on one of the 6 previews and have that repetition show up on a new layout(work Order big View) with only 1 (bigger) size. Is this possible without having to create 1 layout for each repetition? Thanks Demo.zip

I have recently upgraded from FP8.5 (pc version) to FP10 (mac version) I have scripts that send emails using my installed client which was outlook but is now Entourage, however now it no longer seems to work. Any ideas?

I am not new to filemaker but haven't used the scriptmaker in awhile. Need help on how to write a script: when a selection is made from a drop down menu value list, the script will populate the corresponding information in another field. Example: user selects 910A from a drop down list and the script fills in another field with the corresponding data like Panel is not labeled. I need this automated for a work task. Thanks for any advice in advance.

Can someone explain the basics of what I want to do here? I have a table called "Tools". I want to set each tool to a location which can be one of 3 places. A jobsite, a truck or a location in the shop. All of which have their own tables. I want to have a pull down menu 2 choose one of the 3. (Shop, truck or job) Once that's chosen, I want the next field to show options from the first. Example: From the pull down menu, if your choose job, the next field will be another pull down menu of the jobs. But if you choose shop, the next field will change to locations in the shop. I am picturing using a script trigger with this but not sure how to get the secon…

Is there a way I can specify some shortcut for Date entry? For example if I type "n" - to show today's date or if I type "t" tomorrow's date? Any suggestions ?

I am attempting to import data from a pipe-delimited text file, and since FileMaker still doesn't support that format, I'm trying to create a script to import the source data one full line at a time, and then use a multi-part SUBSTITUTE calculation to convert any pre-existing double-quotes into another symbol, and then convert the pipes to quote-comma-quote, which I then surround with quotes at the beginning and end of each line. I would then export the data to another text file, for FileMaker to import as a CSV file. My problem is that FileMaker is not properly importing full lines from the source file; it is truncating after commas. Apparently, FileMaker has only…

I have a field which is a check box compiled from a value list of 10 values. I am trying to write a find script that delivers only records that have no boxes checked - ie the field is empty I'm sure i'm being foolish here and the answer is simple Help much appreciated!

Hi all, i'm very new of FMpro. I've created a complex db to organize all my activities from an old one created by a friend. Now i need to collect the Sum of the money payed by clients day by day, grouped by Date. So the fields i need are Two, Date and Price, of about 4000 records of the table "Days Archive". Example records: Date 24/01/2008 - Price 34,00 Date 24/01/2008 - Price 55,00 Date 25/01/2008 - Price 15,00 Date 25/01/2008 - Price 25,00 etc. I need to create new records in new table/layout like: Date 24/01/2008 - SumPrice 89,00 Date 25/01/2009 - SumPrice 40,00 etc. I hope the example will be enough to understand. I've posted here becaus…

What steps do you take when scripting a delete record both in general and specifically when doing a go to related record?

This will put a smile on a childs face if you can help me... I'm the owner of a summer camp and I would like to have an email sent automatically to campers on their birthday. It seemed like a very straight forward task however then I realized the "Save as a PDF" function is to compatible to run on a server. As a work around I wrote a simple opener script in a seperate file that would run on a client machine at a perscribed time an run the script on the server. The problem is this file on the server is passworded so the script pauses to allow the user to input their password. Questions: Is there a work around for the save as a PDF or Is there a way to…

if i have a script that works for 1 item number that i enter. how can i make a portal the i can enter 2 or more items and when i hit a button it will run the script for etch item?

Hi people!!! I hope you can tell me which is the script step to save changes made in the record... I mean, I have set my layout up to DOES NOT save the changes made in the record automatically... So I want to set the script to automatically save changes in this layout... is there any script step? Thanks a really lot people! :waytogo:

I was using FM 8.5 to send emails via Thunderbird with no problems whatsoever. Today it stopped working. Any ideas for troubleshooting? Thanks, Bob

My apologies if this is in the wrong area...I am very new to file maker but have extensive database/data modelling/reporting experience with other larger platforms. I have a couple things that I am trying to do in File Maker, and not sure if they are possible, or how to do them: 1. I have a new related table that I would like to populate. In general I can do this quickly with a sql statement, but how do I execute this SQL statement against the File Maker database? I see that you can write a SQL to execute against an ODBC/JDBC source, but I just want to execute it in the database that I am working in. A sample of the SQL: Insert into (new table) select column1…

Hi all, i'm a newbie at FMP and the company i do my internship uses a very old FMP. FMP v5.0. now i have to export a few fields after a search has been done. this need to be automated. so when the press the button export ( i've created on the form) that they dont need to select the fields they want to export. so it need to automatically select the field and export it to a fixed name csv file. could someone help me with the scripting cause i dont know where to start. thanks in advance.

Hello All, I need a script for a numbering file that I need for tickets. I use to have one, but can't find it. Anyway here is what I need. The number needs to change after every 5, see example below. 1,1,1,1,1,2,2,2,2,2,3,3,3,3,3, etc... This would be for a single-user database. I would go into the script, set my starting number and it would run. I would export this out to a CSV file for our numbering machine. I can't remember what the script would be. Like I said I use to have one years ago, but that file went to LA LA land. Any help is much appreciated. Thanks

Context: A Button definition can invoke a Script AND specify how a previously Paused Script will be handled (Pause, RESUME, Halt or Exit) following conclusion of the Script invoked by the button. My Question: Can a Script Trigger somehow similarly RESUME a Paused Script upon completion of the Triggered Script? If so, how? P.S. I am in FMA 10. Under Custom Menus I see that I can create a menu to execute a "Resume Script," but I have not found a useful (or attractive) way to apply this to accomplishing my goal. Thank you in advance!

Is there a way to script the deletion of FOUND records? Periodically I need to purge records from the database. I currently use a variable to define which records I want to lose but have to use a drop down menu to delete the FOUND records. Any way to script this step?

Good Morning All, hope everybody is having a wonderful day in this sunny day in california. I have a problem with one of my script, hopefully its something simple. I have a script trigger on object modify. i have a wo status, and the idea is that if the user changes the field to "in progress" my script will check to see if the AD User is Empty if it is i want a custom dialog to come up. but if its not empty i want my script to send an email. The problem that im having right now is that it doesn't matter if the field is empty or not, but it sends the email no matter what. I believe my ((is valid function is that the right one to use, but then again i d…

Null finds in IWP Hi All I’ve created a database that I want to publish on the Web using IWP. I used FM Pro 10 Advanced to create the app. I want the status area of the database permanently hidden. I have supplied navigation buttons to carry out all the usual FM tasks and these buttons work fine, except for one: my custom-made “Perform Find” button. If the status area is displayed and I click the standard “perform find” button Internet Explorer displays an error message telling the user that no records match the criteria of the find request. But if I attach the “perform find” script to a custom-made button and hide the status area this error message is not …

In the Edit Script window I can create Go to Layout ["List"] as well as other layouts but I cannot see a way to create a script to go to Table layout mode. How can I do that? Additionally when that script does trigger (on button push) is there a way to make the FM window re-size to fit the new dimensions of the Table layout? What is the script command I would need to use to revert the window size when going back to the "Browse" layout?

Hi all I have a MS Access Database-file which I use a lot. I wonder if it is possible to create a FM-script which opens this specific Acces-file. Regards! Lasse

How come when http://it.toolbox.com/wiki/index.php/A_little_about_Filemaker_Globals says That in my project where I have a number of global fields in use, and the FM file shared from a host to one user, whenever the user changes the contents of a global field it is changed on the host's screen immediately? Have I misinterpreted the above?

Is it possible to clear all global variables simply? Or do I have to clear each one by hand?

I have a script developed that works as required only if there is a found set of records. But if there are no found set of records(Records=0) then i get a pop up message prompting for a modification, continue or cancel of the script. I placed a step [if]in the script to make sure there are 1 or more records found by using a [Count Records>0], if not then to [Exit Script], but i seem to still get the pop up prompt. Is there a way to Exit the script and avoid the prompt? Script below: Go to Layout [ “Register” ] Show All Records Enter Find Mode [ Specified Find Requests: Find Records; Criteria: Register::Days: “≤60” ] [ Restore ] Perform Find […

How do I get the cursor to start on a new line at the end of all current text? This is within a textbox.

I have noticed different behaviours between using PopUp field types and other field types (Drop Down, Calendar etc), especially as to the values which can be grabbed by the Get (ActiveFieldContents) script step. In all other field types - the script step grabs the previous field value, whereas with a popup style, the new entered value is grabbed. Also noted is that PopUp requires an explicit commit (either scripted or by mouse clicking) and therefore has a different result when using Tab Orders on a layout. The attached file may be of interest to those trying to use script triggers as it demonstrates the impact of different field styles and different scrip…

Is this possible. I am trying to trigger a script to run once multiple specific records are completed. I do have cal fields set to know when the record is complete but ho would I go about setting it up so that when record a, b, and c for (todays date) are complete will trigger the script to run? Anyone?

My client wants his users to be able to choose a hard drive location as their preferred location for outputting PDFs. Because there will be many individual computers, some Windows, some Macs, some with access to a network, some not, I can't really hardwire the code (or assume I can't). They're doing this on a budget, so don't want to fork over additional fees for a plug-in. I've looked at ScriptMaster but don't have enough coding chops to sort out what's relevant, what's not and pierce through its twists and turns. What would you do in this situation? Am I missing something that's obvious. I'm using FMP10 Advanced to develop this. Appreciated.

Hi I'm new to scripts in Filemaker and would like to start getting my head around writing a script to help me in creating a daily report. I have created a database where I record information for a film project to track shots that need effects work done on them. I have set up the database to so I can input various data based around the number of cameras used on a particular day. I need to create a daily report that pulls in all the shots for the current day that requires an effect. I fill in a field for each camera if the particular camera shot requires an effect. Camera's without effects I leave the field blank. My idea is that I perform a find …

My script has two steps. 1) creates a new window, positions it and goes to the required layout. And 2) before finishing it must also jump to a different layout, fetch a current value, and then return. To avoid window flashing I'm putting step 2 above off screen. However, no matter what I do, including adding Freeze Window steps all along the way, there's still a quick flash. Am I attempting the impossible? Or is there a better way? Set Variable [$WinTop; Value: Get (WindowTop)] Freeze Window Move/Resize Window [Current Window; Top: $WinTop + 200] Freeze Window Go to Layout ["Companies|Details" (COMPANIES)] Set Field [GLOBALS::Utility1; COMPANIES::Compa…

I want to create a script which simply does a search and displays records which are set to today and beyond, i have a "deadlinedate" date field set. I have tried a couple of ways but can't get any success, any suggestions are appreciated.

Hi there, I would like to start by saying "Hello!". I am new to the forum and am new-ish to Filemaker, particularly to scripting. I am trying to save myself time by creating a script to automatically enter some data for me! I will attempt to logically explain my problem here, and I have included an Excel file that hopefully makes things clear. I study chimpanzees. Every 15 minutes I write down who is in the group I am watching, both boys and girls. I am primarily interested in the girls who were present at all that day, and which ones were present at which times. I have these fields... date time individuals in group (multiple entries) females i…

I'm still trying to wrap my head around this new Script Trigger feature, hopefully someone can point me in the right direction. I need there to be some type of audible cue when a field value changes, whether it be some sort of audio file playing, or just the "beep" command. I'm not picky as to how it does it - as long as it does it. Cheers, Matt

I am trying to write a script to export a filemaker record to an excel template so that at a click of a button in filemaker it will bring up an excel template with the selected data in the write places on the template then can be saved individually. is this possible? not sure how to go about it, cannot just go save as excel as this just saves the data. need each field to be exported to a certain place on a excel template. Want a certain record to be exported into an excel template with individual boxes which i have already made up and not sure whether i need to write a script for it or use the export option. Cheers, Will

Hi, Is there a way to prohibit deletion of a parent record if there are any children records? I would like to create a generic script that goes like this $childFieldName = Get (ScriptParameter) if (count ($childFieldName) = 0) Deletion steps else Message ("You can't delete this record because there are some dependancies.") end if The only problem I have is counting the number of dependancies. Thanks

Here's the thing...I am well aware that when defining a button on a layout to perform a script, you have the option to act on the currently running script, if there is one running, by Pausing, Resuming, Halting, etc. I can't, however, figure out how to accomplish this from a menu item that is setup to run a script or from inside another script. In general, I stay away from pausing a script to allow user input. However, I found a situation where it was preferable to pause the script so that the user can't click into a different window, thereby sending the window to the back and essentially making it invisible to the user. It works great when the user u…

Another request for help, please. This problem could occur on a mixed-platform network where users habitually close their FileMaker window when it's not being used. If a user closes the window of the file they were working in, they may find themselves looking at the window of the shared address database, which would not be good. Is there a way to hide the latter automatically when the window of a particular file is shut, apart from forcing the FileMaker application itself to shut down when the window is closed? Apologies if the answer is obvious. The problem presented itself to me purely theoretically, as I don't have the opportunity to check it out i…

I would like to write a trigger/script that involves two (and possibly three) fields. The first is a checkbox set and the second is a date field (the third is a blank text field). I would like the date field to auto-fill (and be non modifiable) once one of the checkboxes was "checked". Also I would like to add a modifier so that if one particular checkbox was "checked" not only would the date be auto-filled but also the cursor would be auto-tabbed to the third field. I apologize if this is a naive request or an non executable idea. I am an absolute beginner and all of the scripts and script advice I have read on these forums goes WAY over my head.

Hi, Could I get a list of Common functionalities which are possible via apple scripts and not via FileMaker Scripts. I don't want to create any apple script application. I simply want to enhance my FileMaker Application with Applescript enhancements which shall remove my FileMaker Script limitations. I want to do this without any external tool or plugin. Regards

Hello again. Here's the deal...I have one form, user inputs order#, date, etc. Order# is passed to another form called OrderEditForm where you need to add customers. I have a button to go to CustomerTable...here's where the problem lies. Once I get to CustomerTable, if it is a repeat customer, how do I let the user select the Customer and pass that CustomerID back to the OrderEditForm (for population of that form), or if it is a new customer, add said customer to CustomerTable? I can't figure out how to make the CustomerTable selection pass from one layout to another. Is it one of those Get() functions or what? Thanks in advance.

in a table i have id number (serial) . how can i rub i script to get the biggest number (the last)? it is for a portal that i will have id 3,7,10,13,34 so i can get the number 34 . thank you all dani

I want to set up a FM database over a network, with a number of different terminals accessing the database. These terminals will need to be able to identify themselves to the database. I can't find a way that FM will do this natively, so I've had the idea of placing a text file in the root of the harddrive of each terminal; this text file would contain a number which would identify the terminal. How can I access this text file with FM? Or is there a better way to do what I'm trying to do?

What's the trick to finding time in filemaker? I have the following going into the field: >17:37:04.* Filemaker keeps adding the ".*' at the end. If I manually do the search and enter >17:37, it works. I've tried GetAsText, GetAsTime, Filter, Left; but the format changes and adds the ".*" after the set field step. Is there a way to not have that happen in a time field? Thanks, John

I imported my database to FM ( name, address, ect) and I need a quick way to assign a contact ID number to each file so I can add notes...ect.Is there a script for that?

i have 3 tables. table 1 is my Contacts, table 2 is my Storeroom, table 3 is my history. in history table i have a filed what will have or Contacts or Storeroom number. what i need help with is in history table i have a filed with the name os the Contacts or Storeroom name "C_S_name" how can i get the name from Contacts if it is from Contacts the line of history, orhow can i get the name from Storeroom if it is a Storeroom table?

A file of Job Sheet records (currently 440) with several added each day. Active life of a Job Sheet is normally a day or two but the odd one could stretch into a few weeks. When a Job Sheet is completed, it is retained in the file for reference and, more importantly, for its Bank Balance and Profit/Loss figures which are included with various Summaries for all the Sheets. So, in conclusion, my file is similar to a Bank Statement where each entry is a Job and where there is a running balance, plus various other analysis summaries. I have two problems which relate to delays when taking various actions - the progress bar is coming up and staying on more and more. 1…

Hi, I Am trying to use the "Send email" scripting function. Now let's say I am on a record that contains multiples fields that store email addresses. I want to be able to specify more then one fields in To: mytable::staffemail1 ? How can I do that without using CC: mytable::staffemail2. You know just the way you do it when typing regular email adresses eg: [email protected], [email protected], [email protected] ect . . . . but using multiple field contain ?

Hi, Perform AppleScript script step has 2 options. 1. Calculated Apple Script. 2. Native Apple Script. 3. (It should have something like this where we can just provide the path of an apple script, where it is located and the apple scripts gets executed) What I need is, I want to simply execute an apple script from my file maker script. Generally we specifically create the apple script code (either native or calculated code) in perform apple script, script step. What if I have a perfect running applescript available with me, just needs to run it using my file maker script. I tried using Send Event script step, to see if I am able to execute…

My client requires at least a dozen "slots" where they can store the current found set of contacts, give that set a name, and then later recall that set at will. I'm looking for an efficient way to do this. Here's my thought experiment thus far. Create a dozen "standalone" contact table TOs, nothing linked in or out, create empty layouts based on each of those TOs, then script routines to store and restore to and from these specialized layouts. (I've done this for a singleton TO and it works.) Then give the user an interface where they can choose and name each of these slots and the action of storing or of restoring. What's giving me pause is my feeling there is…