Script Workspace and Script Triggers

Sometimes Replace Field Contents just doesn't seem to work. For instance, doing [color:red]Replace Field Contents [No dialog; some_related_table::number; 1] will work. However, [color:red]Replace Field Contents [No dialog; some_related_table::number; some_related_table::number-1] will only work most of the time. No error is returned, and seemingly nothing gets replaced (on some occasions, one record at random gets changed. One of the causes I found is if one of the fields used in the relationship is global, then this behaviour is likely to occur. However it was happening for me today and I couldn't find any global fields. The only other explanation in th…

'Out of the box' FM permits live changes to fields and records. When you make the change, it happens. I need a process whereby fields are changed on a layout, but there is a button called 'Accept changes' which has to be pressed before records are actually updated. I'm sure it's easy to do (probably by some kind of script), but I haven't yet (being new to dbase design in FM) found out how. Any help appreciated.

Hi -- Does the following exists... a plugin that allows you to toggle a script step into a comment line and back to a script step. I guess I can use the following code ... Set Variable[$debug; 1] If [$debug] Show Custom Dialog[...] End If Thanks.

Hi there, was hoping for a little help, as I am stumped. I am using FM 8.5 and I have a field that I use to show a date, usually, 1 year from the current date. Right now, I have FM auto fill the field with the current date, then change it manually to 1 year beyond. Is there a way to script a button to automatically insert the date + 1 year? Thanks PS. we use 8.5 client and 9.0 server, any chance for corrupted data in my unique identifier? Thanks

Hi all, I'm new at this stuff, please forgive my ignorance! I have a email db with contact information for a group of people. I have a spreadsheet with 50 names who want to opt out. My main list of people is table 1 (T1) I was thinking of importing the spreadsheet into a table (T2). Run a script that would open the first record in T2 and look for the matching email address in T1. If found, update the record in T1 by adding 'opt-out' in the comment field. Loop back to record 2 in T2 Is my logic good? (I may be way off on how to accomplish this) How do I begin? Thanks very much, Tom

I've added a script trigger on entry to a specific field. If the user does not have permission to edit, they're provided with a dialogue and can't enter. However if they do have permission the field is selected and then exited. How do I let authorized users remain in the field and continue editing? Here's the code: If [ Get (ScriptResult ) = Null ] Show Custom Dialogue ["No permission to edit!"] Halt Script End If Much appreciated.

I have a "Notes" field on a layout that is a text box that could potentially have alot of text in it. What I want to achieve is a script that does the following: Place the following text string before the existing text "abc: (carriage return) (carriage return)" Place the cursor before the first carriage return for new input. Does anyone know of a way to achieve this with scriptmaker?

Hi, This might be the wrong Forum, but here goes nothing. I have a solutions running on FM Server 8.0 on a citrix box. I have about 10 users running FM 8.5 and another 5 running FM 10 accessing this solutions (adding/deleting records). Is there any way to create an auto refresh every 20 minutes to a found set of records. Meaning i have my window open and i have 35 found records, and i want the auto refresh to refresh my window so it can pick up new records created by other users. Is this possible? Thanks

I am trying to write a script that will duplicate data, but change which book it is for... Basically, If I have a set of data with the title field: "Book 1" I want to be able to run a script, and have it duplicate the data, though now titled "Book 2" So that both "Book 1" and "Book 2" are in the same table with identical records. So if I started with 2000 records each with the word "Book 1" in the Title Field... I would now also have 2000 of the same records with "Book 2" in the Title Field.

Hi All, I am working on a find in a script and I am not sure how to do a find and then omit a group from the found set. My script: Enter Find Mode [ ] Set Field [ Leads::_fk_dep_id; Build Sets::xdep ] Set Field [ Leads Assigned::_fk_ticket_id; "*" ] Perform Find [ ] I would like to omit the following: Set Field [ Sets::_fk_job_id; $$job ] Thank you in advance Ron

I have a table called Forms_2009 and another table called Forms_2010. Both tables contain identicle field names (Forms_2010 table was duplicated from Forms_2009 table). I'm going to duplicate the Layout Forms_2009 then switch the Layout Setup to Show Records From Forms_2010 and rename the Layout to Forms 2010. Here is the question: Does anyone have a script that will switch all the field in the new Layout Forms 2010 (these fields will still be coming from the Table Forms_2009) to the identical fields in the Table Forms_2010? I don't know how to begin to write this script and I'm sure there must be an easier way to do this other than manually changing all (ove…

I am very new to Filemaker. I am using FMP 10 Adv. I have setup a staging table to receive data from a flat file csv import. I am building a script to migrate the various fields from the import staging table into a appropriate application tables, but I am running into a problem the *next* time I run the script if there are duplicate entries in the second file (which is a valid use case) The first time I run the script with all new data, it works fine. The second time I run it (with duplicate data [the script *should* detect and bypass duplicate data]), I get the following Error: "ContactID" is defined to contain unique values only. You must enter a unique …

Hi, I am using several different tables including employees and contacts, the relationship being 1->1;0, and i wanted to create a button in contacts that will automatically go to my employees layout/table, create a new record and in the kp_id (the related field serial between employees and contacts) i want it to automatically insert the record ID of the related record i am coming from, i.e. simply create a related record. I have been told by many people that for each copy/paste there is a better and more logical approach. Can anyone suggest any? thanks in advance, Jim

My app runs really well except for this problem: There are 2 date fields: startdate enddate There is a portal field called TransactionDate There is a FIND button that searches the appropriate table for a TransactionDAte range produced but the input startdate...enddate. This works. However, [color:blue]if a user accidentally clicks inside the date field before clicking the 'down arrow' to produce the calendar, even though he clicks a calendar date FM produces this error: [color:red]"The value of this field must be a valid date in the range of years 1 to 4000 and should look like "12/23/2003". Question: It seems like there should be a …

I have a script that alternately fails to run correctly (see attached GIF). The Go to Field step will go to the proper field (Donation Date) the first time it is executed, but the next time it goes to the #1 tab field (Donor ID). If I execute it again, it works properly, then reverts to the other field. Can anyone help? TIA

Okay, this one is seriously bugging me. I have two portals one for Author/Editor Information and one for sending Advance Copies of particular titles. Both portals are on the same layout. I'm trying to set it up so that when you enter data into the author name field of the Author/Editor Portal, it will automatically populate the name field of the Advance Copies Portal. I have it set up for the OnObjectExit script trigger and have used both copy/paste and SetField, but whenever I try to get it to go to an empty portal row, it either still populates the first row of Advance Copies or does nothing. I've tried "Go To Portal Row Last", "Go To Portal Row Next", …

Hi there, I am in no way able to succeed in trying to set up sending emails via SMTP. I am using FileMaker 10 Adv. I am quite familiar with email servers so I am pretty sure I filled in everything correct (authentication is set to yes). I tried this using a server side script (FM Server 10 Adv). The error log shows error 1506. I tried sending an email from a local FileMaker file on both Mac and Windows still to no avail. I tried 2 different mail servers. I tried using values from database fields and manually entered values. I tried using a "Name" in the setup dialog of SMTP and tried it without it. Nothing makes any email to get out of FileMaker. The m…

I am looking for a script or custom function that will return the name of the frontmost tab. I have up to three levels of nesting, and by the frontmost tab, I mean the insidemost tab currently displayed. So far, the following custom functions have failed to work for me, consistently returning the wrong tab name: * SeedCode_FrontTabName (and the Faster version) * tabsFrontmost (with related functions). Does anybody have any suggestions for a more reliable solution? I'm amazed I can't get this to work.

Hi I have a "recDate" date field. If I know a specific date how would I go about finding the records that are in the week containing THAT date in a script? So if I know 6-24-09, I would like to find 6-22-09...6-26-09 (mon-fri). Thanks in advance. You guys are great! PS: I am at work on XP and FM 8.5 Advanced

trying to create a find in a script that result in records are 15 days less than current date. could on get all dates less than the current date /. however could not figure out how to write it to only get records 15 days less than current date. Plz help

Hi I have a script that triggers on opening the application, and goes to a summary screen. Now I want it to open 4 other windows, cascaded, so that the user is presented with a choice of which window she wants to work in. Any suggestion will be greatly appreciated.

Is there a technique for determining the foremost window? If there's a suitable Get function, I'm not seeing it. With kind regards,

In a one-to-many relationship, A is on the "one" side and B is on the "many" side. My goal is to have a button on A's layout so that it somehow takes the ID of the current record, goes to the B layout, and performs a find that returns all of the B records related to A. The script never works. I think my problem is the find criteria; I cannot get it to use the ID of the current A record. Does anyone have suggestions? If you need more specific ("real") information about the database, I am willing to provide it. Thanks. -Timothy Moser

Hopefully this is not a duplicate question.... I need to somehow search for particular code/text in the scripts of a FM database (almost 3600 scripts). Is there an easy way to do this - other than one by one? Is there a way to export all the scripts to word or notepad or?: - I could then search the code. I have access to FMDiff which produces a nice html report (and lists all the script steps) but the IE search feature does not want to search in the script steps found within the report. I have also tried to copy/paste all the script steps (from the FMDiff report) but that doesn't work either. Any sugestions would be appreciated. Thanks, John

Hello, I am working on a db for after sales service and now I have to make it more user friendly.. so I worked out my process of status' and wanted to always show a custom dialog when there is a decision to make.. the main problem is that I have difficulties combining Get(LastMessageChoice) with a lookup of my field ( so I can prefilter and only show the apropriate custom dialog.. ) Hopefully the description makes sense to you and you have a hint for me. Thanks

I'm working on a simple email system, where I have three tabs. One for Inbox, Outbox and Sent. Each tab has a portal inside, each with different fields, dependent on a related field that corresponds with the tab. I want to click on a tab, change one global value, and show the data in the corresponding tab. I'm avoiding script triggers since I want this to work in FM9 as well as FM10. So far the best results I have is transparent buttons over the tabs, that runs a script that changes the value and changes the tab. What doesn't work is that the tabs are triggering first, and I have to click in the same location a second time to hit the button. I'v…

I have a script look up old records past a certain day period and everything works great. It runs every time Fm starts up. However if I run FM more than once the second time it doesn't find any records due to already being deleted from the instance earlier in the day and gives me the un-found search screen. Is there a way to continue on the script without acknowledging it by hitting continue?

I have 2 number lists, list1 and list2. List2 is smaller that list1, and everything in it is also in list1. I want to create list3. Which is essentially List1 - List2 Any help greatly appreciated

So, I'm trying to use a script that triggers a printable layout... But I want to use a different layout depending on the input of an "identity" in a field (One layout is in Spanish and one is in English). Field name for Identity: "Identity" So: If "Identity 1"; use Layout1 : If "Identity 2"; use Layout2 But I'm having some problems with the 12th Line. I have attached a picture of the script. Sorry, I was too lazy to type it out. Thanks for any help

Can anybody tell me what is wrong with this script? It works just fine in one database but when attached to a different database generates the following error message: I have attached a stripped down version of the database in case this helps. Thanks, Jarvis testexport.fp7.zip

Hi, I'm a newbie. I would like to compare records between two files (FileA.fp7 and FileB.fp7) and update only FileB. I am writing a script that loops through all the records of FileA and asks if that person (LastName, FirstName, etc.) is in FileB. If so, update FileB; if not, add the person to FileB. I am stuck on a script statement in FileA something like: Perform Find [in FileB] LastName=... AND FirstName=... How can I get a script in FileA to find a record in FileB? The two files are not normally related (and not normally on the same computer) but occasionally this update is necessary and the files are copied to the same computer. Thanks, Tom

I'm working on creating a script for a mailing list report. The mailing list is for all the people the publishing company I work for sends advance copies of books to. Basically it has two levels: The first is for the standard group we send advance copies to: our archive, library of congress, etc. This consists of a check box, number of copies, and shipping date. The second is for book specific individuals, such as the author, the editor, reviewers, and so on. This consists of portal rows with needed information. Here is what the section looks like: Advance Copy Book Database Tab The issue arises when I try to create a report that will lis…

Hi everyone, I'm new to the forums and glad to be here! My issue: I've written a script (and attached it to a button) that goes like this: SetVariable Go to Layout New Record/Request Set Field Perform Script It's totally functional, but the trouble is, I have a field on the layout that I want to set as "required" so that the script won't run if the field is empty. I would ideally have a custom dialogue box pop up saying, "An e-mail address is required" if that field is empty. The user would then be able to click "OK" [thus cancelling this instance of the script] and go back to fill the field. I don't want to set the field as required i…

I'm making a database for a literary magazine that tracks our contributing authors, the titles of their work and the issue each title appeared in, how much we paid each author, etc. We pay authors by the page: $25 for the first page and $15 for every page after that. If every author had only one article per issue, "total payment for this issue" would be an easy calculation. However, many authors have several pieces in one issue. I'm giving each title its own unique ID, and currently I have a basic calculation that figures the subtotal paid for *that piece.* How can I write a calculation that will search the database for other instances of the same author's wor…

In our current database we have a table of contact information for our clients. On a shared network drive, we also have a filing system where each one of these clients has a folder with relevant documents inside. I've set up a script that can will take the user to the client's folder in windows explorer, given the file path. What I'd like to do is come up with a user-friendly way for a user to input that file path into the client table. Up until now we've just been copying and pasting the path from explorer. Is there an easier way to do this? I'm imagining dialog box similar to the way that you can insert files into containers, except in this case we'd be selecting a…

Hi, I am looking for a way to display to users their search parameters as they enter them in a number of FIND layouts. In my solution, users will perform searches by entering a number of search criteria (on different layouts) and "extending" the found set possibly multiple times (as they switch layouts, and as they "extend" the find criteria within a layout). But they won't go to a browse layout to view the search results until they are done "building" their search. I have scripted buttons to let them "extend" their search or "complete" the search and go to a browse results layout. I would like to display to them the criteria they are searching on as they are buildin…

We have need of a notification queue, to alert people when certain records have been modified. For instance, we used to have a shared spreadsheet (pre-filemaker) and when changes were made, someone would change the cell background to Red. Then when someone responsible for making the change in their particular project (not part of the spreadsheet), as they looked through the spreadsheet, they would see the red, and know they needed to change it. They would make their physical change in their project, then put the cell color back to normal in the spreadsheet. I am hoping to implement something similiar in filemaker. Someway for someone to see that a change…

we have a hub table that all of the list go into and then get worked by the first line of telesales. Once a record is qualified we then want it to be in the sales table... we have come up with a few ways of doing this and need advice as to which road is best. 1.we have a script that goes to a clipboard layout and goes down the line of 32 fields and copy and paste's the info to the new record in the sales table... we are concerned that this will bug out when two or even three use the script at one time and the OS's clipboard will be copying and pasting the wrong data all over the place. does filemaker que scripts or run them simultaneously? 2. A simple copy and pa…

Hi, My solution includes a set of conditional value lists for selecting a type and subtype for each record. Some of you have been a great help before with these value lists, but now I have a problem in find mode. For searches, I need to show the type and subtype values as checkboxes, because a search may include multiple types. However, if my search is for multiple types, I want to mask the subtype choices from the user. As an example, if the types are types of food, I might select fruit as the type and then strawberries and mangoes under subtypes. But if I select fruit and vegetables, then I do NOT want to show all the subtypes of both food types. This would be…

I have created a std price table that contains a matrix of prices for each client as follows: 'ID/HouseType_BedroomsID/House Type/Bedrooms/Cleaning Price' for each client When setting up a cleaning job I indicate house size and bedrooms and then wish for the std price to be automatically added to the job. I'm thinking I need to ID how many std prices there are in the 'std price' table for the client in question and then loop through them checking each one to the corresponding unique 'housetype_bedrooms' ID in the job table, until I find correct one and then use 'set field' to the show correct price in the cleaning job table. Would appreciate a starti…

I would like to resume a paused script. My challenge is that I wish to use a script trigger (rather than a button script) to accomplish this. This is because I am using a web-viewer to create an HTML system button with hover functions etc on a pop-up window. Is it possible to restart a paused script from within another script - or is there another work-around? Thanks in anticipation. Jim

I want FileMaker to perform shell scripts that use ImageMagick, the command-line-based image manipulation library. I installed IM on my machine using MacPorts and tested it thoroughly in Terminal. I also successfully performed some generic shell scripts in FileMaker, using both the Troi File Plug-in and the Perform Apple Script ("do shell script") script step. But if I try to call the IM "convert" command from within FileMaker via either the plug-in or AppleScript, it says "command not found" and "Unknown error 127." (Actually, that's what happens when using AppleScript, the plug-in returns no error, but still does nothing.) Is there a step I'm missing that…

I just read a FileMaker press release where it clearly stated that one of the possibilities for script trigger were to trigger a script based off of layout inactivity. I have a solution which needs this functionality for several reasons; however, I can not find a way to do this with FileMaker Pro 10. The boolean calc to determine inactivty is one issue, as not all my layout permit any access to the data; and the second issue how to trigger the script. I've searched the 'normal' venues, but have not found my answer. I feel that I'm very close, and I'm pretty sure I can do this with Troi Activator or Worqsmart Events, but I was hoping to avoid third party plug-ins…

Hi, I have an issue with a calculation I want to make. Let me explain. I have a table 'Staff' with all the employees. Under each Record I have a DateJoined and a DateLeft (empty if currently employed). I also have a MonthlySalary field and a LastIncreaseDate and LastIncreaseAmount. What I am trying to do on a Summary layout is to have the total salary paid per employee, and grand total, for the Current date. Where I get a bit confused is that there are a lot of parameters: - if the employee joined after Jan 1st, - if the employee left during the year - if there is a salary increase during the year All help will be welcomed! Z.

Hi - anyone knows if there is a way to lock the scrollbar on a list? I have a report with only 12 lines and it won't be longer. But I would like to 'fix' this report so no one scrolls down. Thanks, Z.

I have a script that imports records from an Excel file via a variable based on the contents of a container field. I am doing it this way because after the import I use other information about the file name and path for other things. Having the file reference held in a container field allows me to just parse whatever text information I need from it without the user needing to go find the file again. Ex: ContainerField (global) - contains a reference only to file called "contacts.xls" Variable "$$File" is set to: Middle ( ContainerField ; Position ( ContainerField ; Case ( Abs ( Get ( SystemPlatform ) ) = 1; "filemac:/"; Abs ( Get ( SystemPlatform ) ) = 2; "fil…

Hi, I would like to create a script that would perform a find whose criteria would be was is currently in a given field on the current record. Is this possible? Thanks.

Hi, I'm having trouble setting up ScriptMaster for Windows Server 2003. I have enabled plugin support on the server, but when I copy in the windows plugin, instead of just 360Works ScriptMaster show up, both 360Works ScriptMaster and xDBC show up - checking both new plugins results in the ScriptMaster one being unchecked, and the database becoming unstable and requiring a restart. I cannot find any log errors except the following event: Event Type: Information Event Source: Application Error Event Category: (100) Event ID: 1004 Date: 7/9/2009 Time: 12:05:54 PM User: N/A Computer: HOUSTON Description: Reporting queued error: faulting applicat…

Hi all I am building a proto-DAM database which needs to scan a folder hierarchy and create records for every folder and file. Additionally I want to record an MD5 hash for each file in order to find duplicates. I have purchased the FileManipMac plug-in which is great for determining the folders and files. My main questions is about how to traverse the hierarchy as FM doesn't seem to like recursive script calls. Perhaps it's script building technique or perhaps there's something new to FM Pro 10 Adv that I haven't utilised yet. Cheers and have a good day Craig

Does anyone know a simple way of entering client data from FM Pro onto an iPhone. I know we have Bento for the iPhone but this doesn't help if you have a few hundred clients in an FM Pro dbase.

Hi All I have 2 different scripts that use 2 different layouts with 2 different custom dialog boxes. Was wondering if there is a way to specify where the dialog boxes open on the screen in the script. If I manually move it during one script it also opens in that position when other script is run. Thanks and I hope this is the right forum. All you guys/gals are always much help. For this post I am working with FM 8.5 Advanced on XP

Hi, I am desperate to find some kind of a 'for each record' function but I can't find it anywhere. Ha anyone an idea how to to this? Thanks.

Hi, I am new to FM and am currently studying scripting. What i am trying to do is create a solution where records are automatically added from one DB to another if they fall under said conditions. In this case, i have a list of interviewees and a list of employees. They are separate databases and i want to trigger a script so that every time a record is modified to HIRED it will add that record to my list of employees, and furthermore add that contact to my address book under a group called employees. Can anyone guide me through this? Regards and thanks in advance, Jimmy

Hi, I am quite new to the script writing, I struggle trying to do the following: In a table, Invoices, I have for each record a field with the Payment date (Pay_Date). On a different layout, I am trying to get the total value of the unpaid invoices only. I guess I have to create a script that get this value into a variable that I can then use in my new layout. Has anyone an idea of how I can do that? Thanks, Z.

I am running Filemaker Server Advanced and trying to schedule a ScriptMaker Script to be run server-side. I have two databases: 1) testsRecords and 2) messagesDB. The testsRecords DB has a table from messagesDB in it (added as external datasource, fmnet). The script in testsRecords creates a new record in table from messagesDB and runs fine either on a client or through IWP. When I have the script run using a schedule on the server, however, I get a file is missing error (100) when it gets to the step where the record is created in the messagesDB. Is there any reason why server-side scripts can only access tables that are local to the database file that has t…

I would like to be able to peruse records, click into a field then dynamically set the criteria for finds based on whatever contents are in that field. Is there a way to: 1) click randomly within a record 2) set variable equal to field contents of selected field 3) enter find mode 4) set find criteria to be equal to variable 5) perform find : Any ideas how to do this?

I believe I have asked this before but now that the script triggers were added to FM 10 I was able to lock a record after it was Marked Done so that it cannot be edited again. I was wondering is there already is a better way then the one I used and I wanted to check if there are any big drawbacks with the method I used as far as it breaking depending on user actions. If anyone can take a look at the file and comment I would appreciate it. Thank you Kindly., T.009.zip

I am drawing a blank and know Bcooney has shown me this but was going thru old posts and cant for the life of me find it. When I have a check box and have another calc field If ( field1 ; 1 ) How can I set it to trigger the script if it is 1 in the calc field? Sorry BCooney I forgot how.

As i can find no current way to setup individual login scripts for each user, i wanted to created a global login script that specifies each user but i wanted to make sure something like this would be possible as i cannot find any examples anywhere for what i want to do. I have a field in a table called Case_Manager which contains a value list of all the case managers we have. The names of the case managers in the value list match the usernames of the case managers. What i want to attempt to do is create a login script that will allow the case managers to view only the records that have their name in the Case_Manager field, something like: If current user…

Not that much knowledge about calculations in filemaker, bit different to doing them in php scripts etc which I am more used to. Anyway need a calculation to be made IF a drop down box is on a certain answer. Basically my program takes data from one page and when I press a button it puts it into a invoice template and makes calculations etc. I have a Discount box which on the first page has a drop down menu of "Yes" or "No". I want it to calculate a discount when the drop down box is selected with "Yes" and not do anything when it is selected "No" . I am using the calculation option of each individual field on the database, this is not through a script…

what would be the script steps for this problem: lets say I select a item, and then I assign the qty of 5 to that Item, and after I run the script, I have 5 separate records generated for that item. thank you.

This is my first time attempting to use the Send Mail script and im having some difficulty. The script is functional and works except for the message portion. Iwould like to include some text of my own and have it pull some information from the tables. I wrote out my message and then went back and used the Specify Field Name option and it seems to overwrite my text. Is it possible to do such a thing or are yo limited to one or the other. If it is posssible, what am i doing wrong?? Do the field names need to be contained with special characters? Thanks

How can I direct my creation script to portal's most recently created record? In my database I have chosen to not allow user to create a portal record via click in next empty row. I have a separate "creation table" that is not on the user interface. So I have a script that does the creation for user. Currently the script will create record > then go to last portal row. The problem is, on most of my portals I have an alphabetical sort for ease of reading. So (go to last portal) will not necessary be the newly created record. I can make this work if I sort portal by modification timestamp, but then I lose my alphabetical sort which is a bad thing. NOT…

Hi I'm using the FMP Template Email Campaign as part of a gymnastics class registration system I've linked everything together and can produce and send emails perfectly. I am trying to modify the "send campaign" script as follows: The challenge is to keep a record of those individuals that do not have email addresses and to insert their details into a letter template for printing. The letter will contain the same subject and body text as the email. As this is driving me nuts I'm appealing for help -) Very best John

I have two fields for payments that can be filled by any of the three cashiers that work on my customers file. How can i keep track of the changes made on these fields??

Hi everyone. Thanks in advance for your help. I've practically given up at this seemingly simple script. I'm sharing a database over the FMNetwork using a Mac running OS 10.5 and hosting to other Macs running the same OS. I'm attempting to write a script that exports a referenced file (a pdf file located on the host computer) from a container field to the "Get(TemporaryPath) directory then immediately open. So far I have: Set Variable [$TempFilePath; Value: Get (TemporaryPath) & GetAsText (container field] Export Field Contents [container field; "$TempFilePath"; Automatically open] When I click on the button that runs this script on the [color:bl…

Hello guys, I'm writing a script and I need to go to a specific record but I don't know how to make it works. Basically the script receives as parameters 2 values ( Doc::Prg and Annex::Code), it performs a find using Doc::Prg (the find contains the annex record having the passed code) and after that I would like to go to that record. Is there a way to achieve that? Thanks and have a nice day!

Hi. I'm working on creating a script that basically performs the function of a photo slide show with music underneath it. How I have it now when the script runs another version of the window is opened and the container field with the soundfile is triggered. The script is written then to go back the the original window and run through a series of records with pauses in between. When I trigger the soundfile (~30 sec) the script seems to stick at this step (Go To Field[select/perform]). I can hit Apple period and it unsticks and continues on its way, but I'm not sure how to get around this automatically. Any ideas?

Hi. I am looking to achieve a realtime filtering process whereby I have a drop down list displaying records of a field, and as the user types something only records with contents matching that in the field are displayed. For example: 100 records with a field called "name" (very original I know). As I press "j" only records that have "j" in that field are displayed - not just the first letter but "j" in that records field. I then press "a" and the list shrinks as it finds "ja" etc etc. I have seen a plugin demonstrate this (Fusion Reactor) but Im damned if I can get it going. Whilst I now use FmPro 10 Advanced, many clients of mine still have version…

If anyone could it it would be appreciated... I'm using the email campaign file that is a standard file under people and assets when you create a new filemaker file. I put a large amount of contacts in my customer database but I want to be able to send one email message using a blind carbon copy (bbc). The way it works now is if I send to all my contacts it creates a separate email for each and every one of them. Is there a script that I can create to send a single email doing a blind carbon copy (bbc) with all my contacts either individually or from a group? If so, what would it be? Thank you.

I have a script that pops up a custom dialog and then saves data entered in it to a table when they press ok. The only way I could do this is to open the layout behind the scenes and hide it. Then pop the dialog up. The screen is grey behind the dialog. I think it looks bad. Is there a way to have the dialog pop up on the form I am calling it from and then save to the table? I have attached the script. Thanks in advance

Hello, i am trying to write a script that will delete several records at once, i have a database that tracks tool issuance to employees, (each tool has a unique serial number by which they are tracked) lets say I give employee robert 6 tools, and then he returns 3 tools to me, how can I design a script or a way that those 3 tools get taken form his record and placed back into my inventory ? thank you

Hi all newbie to filemaker. I have this script that I am writing to add the detail records to a separate table. It seems to work fine except it does not fill the key field with the proper value. I have checked the relationships and it is set to allow adds. It also works if I hard code it in the script. So it must not be pulling the value from the header table when it creates the detail. Can anyone help? Here is the code of the script. Thanks in advance. Jeff Williams

Hello everyone. Before i start, i have experience with coding apps and many many scripts for other things. But i know nothing about scripting on this program. IF someone could please outline what i would do below, and point me towards some documentation i have no doubt i could do the rest. I just started working at a real estate agent and have been using a modified filemaker 8.5v2. Basically we assign zones to the houses in town. (eg. Flood zone, high end, good area, etc.) I am looking to write a script to get the address, and if it lies within a range such as 140 george street, it is assigned a area code from that information. I was thinking some…

Can someone help me with a simple sript? I want to place button so that it will run a script to go to a container field and open the pdf file that I have stored a reference to there.

Sound file played when a count reaches a predefined value. We have gotten a sound file to play using an add on program and combining a button with a script based on predefined value. However, when the sound file plays filemaker pro ceases functioning until the sound file ends. So we really have two problems with this: 1. we don't want to use a button 2. filemaker pro ceases functioning until the sound file ends. Any ideas would be greatly appreciated.

Slow on Refreshing form. Occurs when clicking in different fields in the form, opening the form, and updating data in form. Have filemaker pro 8 advanced and tried filemaker pro 10 demo. Both were slow. Any ideas would be greatly appreciated.

External input to increase a count in the database. We want to use the database to keep records of counts and we want an external input to the computer to increase the count. The external input could be a keyboard with a combination of keys used to increase the count, but do not know how to do this. Button can be created to increase count but doesn't allow external input through a combination of keys on keyboard or an external input through RS232 or Parallel port. Any ideas would be greatly appreciated.

I am totaly new to FMP and am using FMP 10 on a Mac. I am looking for help with my very first database, what I want to be able to do is click on button on a date in a Calendar solution and have it bring up a and display in a new window a record from another database that is specific to that date. ie. There are 365 documents each specific to a calendar date and if I click on for example 25/07 I want it to display the relevant document. Will this be possoble to achieve? and if yes how?

I have a field currently set as a checkbox set (values such as maths, English, art, PE etc). Assume the options maths and art are chosen. I want to create a script that examines this field and if it finds a specific text string (maths), then a new record is created in the appropriate related table. Right now my script will only work if a single option is chosen (maths only say), because I am simply using “if field = art”. I need “if field CONTAINS art”. Any ideas?

I have a client database which has a number of layouts, each layout is accessed via one of the menu links along the top. These are linked to scripts. The picture below shows a text box with an "Update Status" button. This automatically inserts todays date and time, after which I can then type a note. What I would like to do is to change the script on the "Update Status" button so when I click again the contents of the text box is copied and then deleted. I would like it to then be placed into another text box in a different layout (see picture 2), and for this to be placed at the top of the text box, moving previously placed notes down leaving a two line ga…

I have a script that brings up a dialog box. The dialog box features a single field, an OK button (in Default position) and a Cancel button. The default button will not work. When pressing it nothing happens. The dialog box does not close. However, when using the cancel button, the dialog box does close.

We have an FM database to record records of PAT Testing. One of the layouts is a report that shows all of the tests carried out. I have a field named "Restest date" and another field named "Retest Due" I want to create a script that looks through the list of records, and adds 'DUE' the the Retest Due field on all records where the Retest Date is before todays date. Is this possible?

Long-term novice (well, long-term intermediate user)here, with what I think is a fundamental question. Over at the public library, reps from several departments keep events listings in a shared db. Once a month, I want to publish them to the web site. I've written some CSS tags that work neatly, so that (not actual field / CSS names, but you get it) Event_name Time_date Registration display correctly when popped into Event_name Time_date Registration What I want is for FileMaker to pop out that CSS, which I can paste into a page of HTML. (I know that I could have it pop out a bunch at one time, but I want these entries one a…

Can anyone give me a simple script which searches thru a given text field and strips out any character accept numbers (zero to nine). Leaving only the numbers in the field. Many thanks

I'm trying to create a report with the GetSummary functions. I figured out that this function can't use related records. To bypass this I tried to run a script which copies the related records into the table where the report is created. The problem is that this script doesn't work. (see the attachment) Does somebody have an idea to get the script working or another solution to use the GetSummary function with related records. Thanks Question.fp7.zip

A script that works fine on v9.3 doesn't work correctly with v10. This script, designed to delete related records in a portal, is also deleting the parent record when running it on a mac with v10. Any suggestions? Is this a bug with v10?

Is there anything magical about the "UNDO" script. I have a button that theoretically activates one but nothing seems to happen. The description reads: "Multiple actions can be undone by repeatedly executing this script step with the Undo option. The number of actions that can be undone or redone is limited only by the amount of available memory." My script reads: Undo/Redo [undo] Any ideas what is not working?

Hello, I am very new to FM. I am not sure if this is a scripting question or not. I apologize if this is posted in the wrong area. I am trying to create a file to collect member charge ticket amounts and then create monthly statements. I have set up 2 tables: Member and Transaction My statements seem to work correctly. But I want to specify a Start Date (month) for the statement and have the records for that month to be the only ones included on the statement. I do not know how to do this. Plus, I want to provide the Previous Balance (which would be the Total of the "TransactionMade" before the "Start_Date"). I do not know how to do this either. I …

Hello, I was wondering if there is a Get function that retrieves the names of all of the fields from a specified table and returns them as a value list. For example lets say you have a table of People with the following fields: ID FirstName LastName Address1 Address2 ... Then, GetFieldNames ( People ) would return: ID FirstName LastName Address1 Address2 ... A custom function could probably do this, but I am not very skilled at writing CFs. I did a really quick search of Brian Dunning's site, but did not see an appropriate CF.

Hi, I am wanting to create a script where by I have a new record created to sum up 'text' data per date. I have the main database of all the items sold and have another relationship database my date. Right now I create a new record in the date database and in the item field type in the item that I now sold that day. All the info comes up to do with that item. The problem is I have to manually create a record and manually cross-reference which items were sold in the main database to be able to go back to the other relationship database "date" and manually create a record per item in order for the data to appear in the portals. It is working well, but if I forget to cr…

First off, I am really intimidated by this site. You guys are sooo freakin smart. Anyway, I have a script that loops to create 10,000 new records. I want to return to the first record and renumber the found set from 1 to 10,000. EXAMPLE: 123450000.....1234599999. I cannot for the life of me remember how to script the renumber part so that when I click on the button to create the records, the whole process is done transparently and seamlessly. Thanks in advance. And BTW, no really big words. I'm kinda dense.

Does anyone out there know if it is possible to override the auto-enter settings for a field temporarily as a script step. Specifically, if I want to import some records and modify them witha few subsequent calculations, I don't want the Date Modified field updating. I wanted to avoid having to re-import the date field again afterwards. cheers - Anatole

Hi. As the subject indicates, I've run across an error that only happens with FM 10 client (doesn't seem to matter which server version), and that error is the famous "Record cannot be modified in this window because it is already being modified in another window" problem. We've used FM clients 7,8, and 9, and not had this problem ocurr, but once we switched the users to FM 10, it cropped up. Consistently. I was convinced we'd found a bug in FM10, but someone else suggested that perhaps a script step or two had its behavior modified in FM10, so I started looking into it, and really, I don't feel I'm any closer to an answer. The scripts in question are below,…

My client wants a pair of "Save" and "Rollback" buttons on some layouts. I'd like to share with you the logic I'm considering, to see if I'm missing something and/or if there might be a more efficient way. It's entirely possible in this networked solution that more than one user could be unwittingly editing the same record at the same time, so any system should provide for that contingency. There are several portals on these layouts and the user could be editing more than one record within a portal. The client wants a single pair of Save/Rollback buttons on the layout that requires a single click applying across the board to all the editing changes that …

I have some long scripts written by consultants. Once awhile, I need to make little changes to the scripts. Is there a way to do a search and find a field name, a value and etc from scriptmaker? Is there a way to copy a script outside of FM, like going to a word file? Appreciate for any help! -Sal

Hi all I'm having a problem getting my head around a script and hoping you people can help me. What I need to do is bring up all records where the date field is between today and 30 days time and then run the rest of my script but I can't get how I get my variable or another field with the date in 30 days time in to my field in find mode. Hope someone can help. Thanks -)

Using "Replace Field Contents" to replace with a calculated result works fine manually. But when I place it in a script and try to specify the same calculation, it always gives me the error "The specified table cannot be found", regardless of what table I have selected. What am I doing wrong? Thanks!

I have a script that will take each record and save it as its own PDF (with a unique name) I cant seem to figure out how to allow the user to decide on the file path. Currently the path is defined in the script itself, but I need to be able to decide each time where to save the files. Also is there a way to get the script to notify me before it overwrites a file (ex, Overwrite? Yes / No / No to All / Yes to All) Heres what I have so far: -Show Custom Dialog Box ["Export to Separate PDF's; Press Ok to continue or press cancel] -If [Get (LastMessageChoice) = 1] Beep Set Variable [$counter; Value:0] Loop Set Variable [$path; Value; "fil…

Hello All, I am looking for a little help on how to write a script to constrain a found set. I have a date range find for a report on sales person activities. So I do a find on the date range but I would like to omit the "House" records. Enter Find Mode[] Set Field [sets::date_ass;Admin_Reports::xdate_beg&"..."&Admin_Reports::xdate_end] Perform Find[] From here, how would I find all the records within the date range assigned to house and omit them? Thanks