Script Workspace and Script Triggers

Happy New Year, everybody! Please refer to the attached .pdf for the script. The hang-up is the highlighted script instruction under Get(LastError) for some strange reason, the Set Field command won't change the text in the Record::Incident_Tab_Message text field to "No Records Found." I pulled highlighted line of code out and just made a quickie script button out of it and it works fine that way, so I suspect it has something to do with the Perform Find request, but I don't know. I bet the answer will be sooooo simple I'll slap my forehead silly. TIA for your help! File_Error.pdf

I am trying to get my head around what is needed for a standalone app to reach out to an FTP server and download newer tables then export/import present data into those new tables. Has anyone done this?

In the midst of a lengthy scripted printing routine I'm issuing the Page Setup command (to enable a choice of printers). However, if the user clicks that dialogue's Cancel button the script halts and the user is dumped on an unexpected layout. How can that Cancel button (coming from the OS itself) be trapped? Recommendations for handling this? Assistance appreciated.

need help with one script … I am working with a file/database w/3000+ clients … I need to create a button w/password (I know how to create this) for the following script … which i need help setting up ... find all records / show all records export the following : customer name, address, city, state, zip (as tab, since excel export just doesn't work in FM 8.5 and windows xp) create folder on desktop export go back to original layout … I already know how to do all of this without the script, but our database is set up with security, so I need the script so that certain people can perform this duty without logging in as the administrator with access to all…

I have a container field with an embedded file in it. I host the database via IWP. Now the users can click on the text of the filename in the container window, and the file will download to their machines and open. This is the behaviour I want. I would like to be able to trigger this via a script, so that I could make a button the user clicks on, and that gives the same result as though the user clicked on the file/container field. Thanks Manuel

Is there a syntax available for the Send eMail script step for adding multiple attachments? In my experiments using $Attach1¶$Attach2¶$Attach3 (three lines, each separated with a return) only the third attachment is actually sent. Assistance appreciated.

What is this character, how is it used and what keystroke do you use to create it? "»"

I'm preparing a scripted routine for generating PDFs and I'd like to offer users a field to identify the file name plus a button to identify the location for storing the file — anywhere on their drive. Is there an available routine within FMP9 that will open up a "choose location" dialogue where they can navigate to their preferred folder for saving the PDF? Or is this something requiring a plug-in? Assistance appreciated.

I have student records belong to groups A, B, C, D, E, F. I need a script to do all the follows in all the records: Delete all the F students. Delete all the grades of classes that students took with promoted grades. Promote A to B, C to D, D to E, E to F students. Pascal

Does anyone know of a way to implement rollback/commit type transactions in FileMaker with a client script? Any 3rd party plug-ins or anything? I have a complicated script that touches 3 tables and takes a "while" (several minutes) to run, but gets run many times a night. The problem is, if one of the Client machine's Internet connection goes down, or if one of the client machines crashes while running the code, only part of the process is completed, leaving the data in a mess that takes hours to identify and fix. It won't rollback on its own it seems. A perfect (in my mind) solution would be to begin a transaction at the start of my script and commit it at the…

The ScriptMaker window at different times opens all the folders on its own. Is there a simple way to: 1. Prevent opening all? 2. Or to close all the folders except the selected folder? It's using the filter that somehow generates this unwanted clutter. What do you do?

Are there keyboard shortcuts to open and close the script debugger?

Is it possible? I tried using a container with a .jpg in it hoping but it didn't show. I want to (easily) show a dialog telling the user where to look for the info with an image example. I know i can create a layout, etc. but was curious and the custom dialog possibility........

My employer has asked me to create a database for his entire business. I have no prior experience with FM, and now I've hit a wall in my database creation. I currently have one database with three tables: Employees, Departments, and Time Cards. I have these three tables functioning in the ways I expect; however, I need to create a button to run a report based on data found in the Time Cards Records. There are three fields that I have to match when I run each report, but the value in each field will change from one report to the next. These fields are as follows: DeptType, EmpCode, and PayPeriod. I have set up a box of tabs in the report layout to specify which value…

I'm using FM 8.5 In the script that I wrote I do a find and pause. Why is it that sometimes I can press Enter and the Script will continue while other times in a different part of the Script pressing Enter won't continue the script. What are the rules for pressing Enter

Hello members, Is there a way to control the location of a dialog box? I'd like it closer to the button that creates it rather than the center of the screen. Thanks

Hi, I have a container field that contains a PDF. As it is right now, I have to export this in order to open the file. I want to script a button over the PDF image of the doc that will auto open the document when I click on it. I know I have to export and then open so I created a script but I'm confused about the temp file name. I just want it to go to the Windows temp file. I set up a script with Export (field name) and for the specify output file I put "filewin://%25temp%". (I didn't type 25 there but it added it automatically). I checked Auto open. It's not working. Any ideas? Thanks!

The compnay I'm working for mails a newsletter to about 2000 members. They have it scripted to put all these names in the TO field of an email. This causes multiple problems for them. What is the best practice for doing a mailing like this? Thanks

I use a script to create a backup file for test purposes. It inserts the words Test Copy at the beginning of the file name for easy identification. For example: Test Copy Clients.fp7. A startup script runs when the file opens. It tests the FileName and sets a global for display purposes: Set Variable[$filename; Value:Get (FileName)] If [LeftWords($filename;2)=”Test Copy”] SetField[issues::gTestCopyAlert; “TEST COPY”] Else SetField[issues::gTestCopyAlert;””] End if If the words Test Copy appear in FileName, gTestCopyAlert displays the words TEST COPY on the layout. The problem is that when I create the test file and open it for the first time …

hello guys, I'm new on FM scripting and I don't understand how, having a field value, I can refer to an other field of the same record. Let us say I have a table called friends with 2 fields: ID and name Now I pass as a parameter "name" and within my script I need to use the ID. Do I have to perform a find in order to get the record and after saving the ID of that record in a variable or there is a easiest way? Thanks and have a nice weekend THANKS

Not on the layout to be used for printing, the user is presented with a large global text field into which to compose a letter. I've successfully provided a scripted tools to let the user select text and change colour, typeface, point size, bold, etc. Now I'd like to let the user select a segment of text and centre it, make it flush left or right or justify it. Are there tools for doing this?

This is a part of the script I have for a Notes field. It enters the date, user, time in blue. Insert Calculated Result [Contacts::Notes; TextColor (--- " & Get(CurrentDate) & "@" &Get(CurrentTime) & "by" &Get(UserName) & "---"; RGB (0;0;255))] I want it to go back to black on the rest of the information the user enters. Example. [color:blue]12/15/2008 @ 1155 by Bob Smith The quick brown fox jumps over the lazy dog. As it stands now, everything is blue. What step do I need to change back to black after the time date heading?

Hello guys, I have a bunch of buttons that perform different scripts and I would like to organize them within a single script (looks neater to me) so my idea was to pass as a parameter the name of the subscript to perform. Basically the button "create" performs the script "button manager" passing as a parameter "create a new record", the button "delete" performs the script "button manager" passing as a parameter "delete a record" and so on ... Within "button manager" instead having a bunch of if else if I would like to perform the subscript with the same name of the parameter. is it possible? something like perform script [Get(ScriptParameter)]. Thanks…

Hi Everyone....Happy holidays... I can use some help if someone is available. I need a script that will trim the last 3 letters from a string of text in a specified field and replace them with 3 letters from a target field. It will always be 3 letters and it will always be the last three letters that need need to be swapped. Any help would be greatly appreciated. Thanks, Steve

Hello folks, is there a way, through a script, to check out if a table exists? I need to perform some steps only if a table exists but I can't find how to make it works. Thanks

Hi all I would like not to dispalyed the records that are marked "Updated" for a chosen date range. This what I have ritten so far Enter Browse mode go to layout name enter find mode set field (expiration date; get(currentdate)&".."&get(currentdate)+30) perform find[] go to layout list view go to record/request/page [first] loop If[welder: update = "Update"] omit record end if Go to Record/request/page [next; exit after last] end loop The problem is, once a record is omitted than the "Go to record/request/next" skips a record. I tried repositioning the steps but it only check every other record. Any help will be greatly appreciated. …

I need to step through a series of portal rows and fetch a value from one of the fields, progressively. To simplify things I've set up a layout with just one portal and am running a "get next portal row" loop. At each iteration of the loop I set a global variable using the TO-of-the-portal::fieldname. Unfortunately, either the loop isn't advancing or I need some other calculation to fetch the field contents. Assistance appreciated.

Hello guys, I'm looking at Matt Petrowsky's screencast about setting up a developer environment and I have noticed he uses in almost his scripts something like SetVariable [$var; Value.script.parameters ( _ )] and he calls the script passing a parameter. Which difference there is between his method and the "regular" Get( ScriptParameter ) Moreover. is that a custom function? If so can someone explain to me how it works? THANK YOU and HAVE A NICE DAY

I'm moving up from FMP6 to FMP8.5, and am rewriting a lot of old code to take advantage of new functions. If I have a stack of records with ID numbers 1-6,8,9,10, and I want to create a new record with an unused ID number, it is trivial to just keep an incremental ID and add one with every new record. However, I want it to see which numbers are unused, so if I create a new record it assigns ID number 7 in this case. Any suggestions or links? (Yes, I have been searching though these fora but haven't found an answer yet.) Thanks for your time

Hi, I'm in Filemaker 8. I'm trying to set the script to just open a static directory on a server. I do not want to open a file. I want to open the directory so the user can choose the file every time. Thank you.

Maybe I can post this question within this thread and get a response, it is totally unrelated to creating a new record through, just didn't want to create another thread. I have scripted up a script to assign a number to a record (a comp number to a person). I have the Max function (hopefully, which it is not) grabbing the last number used and incrementing it by one. However when I hit the button on the record with no comp number assigned to it the script never works. However the script would work if I ran the script from a record that already has a comp number. I think it is not working because the new record with no comp number does not have a relationship with the…

Hi, Is there any way of using a variable to drive the sort command? I presently have a script which takes a script parameter and works out things like how the list is currrently sorted etc. This is all done through one piece of scripting and I don't need to rewrite the script every time I add a new sort criteria. What I currently have to do though is put a separate piece in for each sort criteria when it comes to the actual sort: pseudo code if$scriptparam="Week" Sort Records by week Ascending elseif scriptparam="Date" Sort Records by date Ascending I have to do that because in each sort you seem to have to select the sort criteria and …

I have a invoice table with a unique ID. In the same table I have a field for invoice reference number. What I'd like is to have this populate as a default with a sequential number. That bit is dead easy - I could just use the auto serial function. However, I'd like the number to be made up of the first letters of the jobcode plus the serial numbers. (The jobcode is stored elsewhere). This means that a group of invoices would be say HM0012 and another might be GH0001. Maybe on loading the sheet I need to auto populate it with the serial number (0012) and then run a script which adds the first two letters of the jobcode to it... is that the best way? Thanks…

can you set the field of a specific record number through the function "Set Field []"?

I am designing a script that will allow me to query the user what type of object they want to store and based on that, give them a choice of conditional locations/storage units in which that type of object can be placed. Then, depending on their selection of storage unit, the script sorts another table for available spots in the selected storage unit and assigned the object to the first available spot. Using a suggestion in the FM Pro 9 Missing Manual (p. 571), I am querying the user using a window, a layout, and a script. The problem is that when the user enters their choice of object type and storage unit, the first record in the table from which the "dialog" lay…

Hello everyone, as the topic says, I am looking at creating a new record via a script. Is this possible? I cannot seem to find the functions to do this. Thanks so much!

I have a need to make a button for reports. I want to have a screen pop up and ask "Date Range" and show records in that date range. Any advice?

I have a problem with script steps occaisionally being skipped (on various scripts). Hitting the script a second time always performs correctly. I can't repeat it with debugger or on demand. FM9 cross platform users. FM9 Server Advanced Windows. The WAN connection is very slow and occasionally disconnects users, but LAN users have experienced this as well. Is it possible for a bad network connection to cause this? Or is it really possible to write a script that can misbehave (aside from obvious issues with record locking)? I have found three scripts that have been reported as occasionally not working as expected (the italics portion fails) Script A, Print: Ne…

I've got a script set up in two of my FMPro databases to send out an email daily for calendar reminders and appointment reminders. The script runs automatically each morning on a Windows XP using a Scheduled Task. Usually it works ok, but every week or so, it runs the script, but doesn't send out the email. If I manually run it and make the email part of the script require a dialog, then it works. Any suggestions? It's running on FMPro 7 on Windows XP.

I've cobbled together a Work Order system to track trouble tickets and am running into an automation issue. I have a button that "closes" tickets, and I want to compare the contents of two checkbox lists before allowing the ticket to be closed. One field is "AccessoriesIn" and one is "AccessoriesOut" (both using the value list "Accessories"). When clicking the "Close Ticket" button, I want it to compare the contents of both lists and, if they don't match, stop the script and display a dialog telling the user to check the accessories and try closing the ticket again. I'm sure the Case() and FilterValues() functions will be involved, but can't wrap my head around …

I don't get why this script isn't working. Is there a better way? Set Variable [$scriptP;Value:Get(ScriptParameter)] I have several buttons that would use the same script other than a value unique to the button so I am trying to modularize my scripts and use a script parameter instead.

I have a very simple Filemaker solution called ChurchMusicPlanner. Each record can have up to 20 hymns drawn from a hymnal index table (600+ hymns) listed in twenty different fields - Hymn1, Hymn2, Hymn3 etc. where each of the twenty fields accesses the hymnal table from drop-down menus. What I need is a way to list all the hymns used from a found set of records by the number of times they were used. For instance, "Like a River Glorious" used 4 times this past month. So you could have any number of records with twenty different hymn fields in each record with each field having the possibility of having that hymn listed. I don't need a "search" function where I look f…

Hi, I need to have a feature in our fmpro file that can show a message on an other computer. If I for example, make a new record, then there would come a popup, or a message, on the display of an other computer running the same database/fmpro file. But not for all four accounts/computers, only for one specific. Could be depending on account name (login name) or an IP-address... I use FmPro 8.5, and the file is operated remotly by four accounts/users.

Hi there, I have a problem these days. FileMaker 9 crash while executing send mail script step on winxp sp2. Anyone have same problem before?? The rest of the story: FileMaker 9 Advanced used to running for send mail script. We uninstall advanced and install FM Pro 9 (Central Europe). After this change problem was started. When FM Pro 9 executing send mail script it crashes. I have update FM Pro from 9.0v1 to 9.0v3 but problem still occurs. Finally I tried some examples on a sample file to determine problem exactly. I have created a file with a text field and a script with only send mail step. I configure "to" field to the text field I have crea…

I'm looking for the most efficient way to update a field for all found records. For example, I have a field called orderStatus. I already have a script that searches for all records whose orderStatus = "New". Now, I want a script step that sets the field for all of the currently found records to "In Production." I understand how to set the current records status, but how do I set them all?

Sorry if this is not the most appropriate topic area for this question, but my solution keeps asking for my username and password upon closing, and I do not have any scripts assigned for shutdown under the options. Any ideas on what could cause this? If I type in my username and password, it does shut down, but this extra step is annoying and perplexing. Thanks ahead for responses.

I've got a field on my data entry sheet that I would like to lock and not allow users to enter data in it. No problem with that, I have done that in the field behaviors box. However, I would like the ability to unlock it occasionally using a script but can't find the command. Any ideas?

Hi all, Not sure quite how to go about this one, I'm sure it is quite straight forward to someone here! I have 2 tables: DataToday DataHistoric At the end of the business day, someone will run a script which takes the data from DataToday (100 records) and adds these 100 records into the dataHistoric table. It is only about 100 records, maybe a few more, maybe a few less but not exactly 100. Would a script be the best way to go about this? Many thanks Ed Edit: Should have mentioned that a script runs the following morning deleting all records in DataToday to clear it ready for that day Thanks

I have a database with product names and serial numbers. I need a script that will keep the user from erasing the 2 fields above. So if the user changes the serial number and closes the application or moves to another record FM will ask "do you want to save the changes made to product serial number" And a Yes/No option Any great ideas?:? Thanks!!

Hello everyone, I am looking for advice or a freelancer to solve a problem I have using the FP7 template lending library. I am working for a outdoor-play lending library and want to use this template for controlling/lending/monitoring our stock. If any freelancer is reading this and want to send me a quote or if you have more questions you can drop me an email to [email protected] so here s the brief Desciption of problem I used the template 'lending library' which comes with filemaker pro. Problem here is that there is no reservation option (I call this booking!). The 'check out' option doesnt work for booking because you cant set a date for the outgoi…

Hello If I am on a layout with portals and need to create a new record in the portal through scripting (and the portal has required fields in it), is there any way I can create it without committing the new portal record and not get any errors for not completing the required fields? Joe

We have a timesheet input file that sorts chronologically (ascending) and we want a record number for each record (from 1 to 25 records) starting with the first record, automatically entered in +1 increments and ending with the last record. I have created the script below to do this but it does not work. Suggestions welcomed. Thanks. L.

Both Microsoft Access and Excel have a very useful Rank function which returns the rank of a number in a list of numbers. Duplicate numbers are given the same rank, which affects the ranks of subsequent numbers. For example, if a number appears twice in a list and has a rank of 3, then the next number in the list would have a rank of 5 (no number would have a rank of 4). FileMaker doesn't appear to have an equivalent function, so attached here is a small example file containing a script that does the same thing. (FileMaker 7 format!) It's simply a list of names, with scores, and an empty rank column. Sort the Scores in ascending or descending order, then run…

In the FileMaker Pro 7 Help, Loop structure example, the Exit Loop After Last example includes the step, "Go to Record/Request/Page [Exit after last; Next]". Does the "Go to Record/Request/Page [Exit after last; Next]" calculation exist in FMPro7? If not, is it possible to select another step or calc to do the same thing? Your suggestions, please. TIA, Leonard

I created a database to keep track of a couple hundred FTP accounts and it works well enough. I created a script in that database to generate an exported file that, with minimal tweaking, becomes an XML file that FileZilla can import as a bookmark list. (The "minimal tweaking" is basically doing a global search and replace in a text editor to insert line breaks, since FMP won't export a line break.) To accomplish this I created a new table with three fields: XML Header, XML Body, and XML Footer. There is only one record in this table and that record contains the XML header and footer information. The script I created is to fill in the body field with the information …

I was wondering if there is a simple way to automatically invoice all of my customers at one time. I have a database with two tables, CUSTOMERS and ORDERS that are joined on the ACCT NO field. Is there a way of scripting that when I click on a button it will automatically get the ACCT NO from the CUSTOMERS table and fill them into the ACCT NO in the ORDERS table and then go through all the customers and make new orders for them and stop after the last customer. I think using the loop function somehow would do it, but I don't know how to do it. Any help would be appreciated.

Hello I have to populate a table with many fields in it(probably 150) with a data value for each field. Is there any efficient way to do this using a script? The only way I know of is to use Set Field and set each field individually with the appropriate data value. However, this means I have to do this 150 times. Are there any better ways?

I use Filemaker 8.5 to create invoices. After completing the invoice I have a script which prints two different invoice layouts. I would like to interupt the script if the date field is empty. Any ideas. (I'm sure it's simple but I can't figure it out

Hi. Using the Send Mail script step, how is the outgoing email account chosen. I have multiple active accounts. Is it a system function (i.e. it defaults to the first account listed) or is there a way to select a specific account in FM. So far it looks like it may be a matter of the system listing. Can anyone confirm this? I'm running OS X Leopard using the Mail App. This doesn't seem to be covered in the filemaker documentation. Thanks

In a new database< i have 20 tables, none linked with any other at this point. I am cleaning them up to delete blank rows. I can do this by hand: go to layout "Single", say, click on find mode, enter an = in a field, click find, and delete records in the found set. However, a simple script to do this usually hits the error, "The operation could not be completed because the target is not part of a related table." I say usually because once in a while it works! Anyway, the script is simply: Go to layout[single"] Enter find mode[] Perform find[Restore] ... note below Delete all records[] note, the script for perform find has the specifiy find requests…

Here at our office we use magicjacks for phone use, it comes with a plugin so you can click on a contact in outlook and dial it, I'm looking for a way to send contact phone and maybe address info from filemaker to outlook, like an "export to outlook" button i could link to a script to that would create a vcard or the like, any suggestions?

I have two lists of students (list A and list and want to compare them to find out which students from list A don't exist in list b. These were excel lists that have been imported into separate tables in Filemaker. Any advice would be greatly apprecaited.

One of the weirder thing of switching from Filemaker 6 to FM8/9 was how fields refused to yield the status of being currently selected. Hence, all kinds of scripts I had would break because the users were still selecting the current value, hence it wasn't "accepted" by the system yet. I did all kinds of things like go to the previous record and back again to simulating clicking out of any field, but is there any better way of doing this? I tried Flush to disk and that didn't do anything meaningful. Any help would be appreciated.

Need help syncrhonizing data between 2 tables automatically. Table A and B have the same data both have the same PK, I want to automatically do the following 1) If PK in A but not in B, automatically add record to B 2) If PK not in A but in B, set the status flag of record in B to inactive 3) If PK exists in both A and B, check a date modified field in A and B and update record in B if appropriate. A and B hold employeeid, name, department and date fields.

I have an employee table with First name, last name columns. I want to write a script to automatically concatenate the first name and last name and write it to a new column. Any ideas. Using FMP 9.0 on windows. thanks

Hi all, I am a newbie to FM. I need some help please. is there a function that converts figures to words (25 = twenty five)? thanks very much in advance

I have a database accesses via IWP, I want to make a button launch an ichat session by opening the following url: aim:goim?screenname=(ichat username) Now when i type that URL in a safari window, it does open ichat and a session connected to username. But when i use Open URL [No dialog; "aim:goim?screenname=" & username the Open URL script adds "http" to the URL, thus sending: http://aim:goim?screename=(ichat username) which fails. Any way to tell Open URL to not add "http://"? Thanks Manuel

Greetings! A problem I have noticed in our stock system is that very often the shipping costs of items are not allocated to the invoice for the product shipped in. This obviously pushes up our overheads. What I'd like to do is flag those records in stock that have a shipping cost attached to them. The common denominator will be the Order Number. My logic thus far says: find the records related to shipping/courier fees (as these are entered into the system when booking in stock), extend the found set of each shipping record so as to show the matching product records and then flag them. My script so far is as follows (I'm just trying to get the loop to w…

Is there any script steps or plugins I can utilize to enable tab switching? I have a tab control and I want to place a "Next" button to switch to the next/previous tab... Please help

I have a database where each record has an email address and a calculation field formatted as a container. I want to create a script which will send out emails containing the file referenced in the container field to each individual recipient. (I'm a teacher; the records = my students, and the container field references their essays, which I have graded and want to return to them.) The system works fine so far as the email part goes, except that Filemaker's email script step only appears to be able to accept a single file for attachments—that is, you're forced to choose which file to send while editing the script. That strikes me as a useless feature, but maybe I'm m…

Hello Has anyone scripted a process that creates/duplicates records, but bypasses the database required field constraints with the commit records-skip data entry validation option? I may need to do this, but am concerned about bypassing the above constraints. Joe

Hi, I have a text field that the user enters information into. I also have a series of button that inserts text into this field. The problem is I have only been able to have it insert at the end of the field. Does anyone have an idea how to have the insert done where the cursor is located? Thanks,

You may be sorely surprised at your results when using [color:red]! to find duplicates ... In reality, the following will match as duplicates ... [color:blue]¶ Always [color:blue]Always ¶ [color:blue]Always [color:blue]Always Never [color:blue]Never [color:blue]Never Always We are not warned anywhere in Help that I can find that each LINE in a field is treated separately. I would not expect the above 6 records to match on [color:red]!. A field's entire contents should be counted as ONE value, matching character by character. The reason a User would use [color:red]! is to find EXACT DUPLICATE VALUES within a…

Hi all, I was just wondering if there was such a thing as the right click action of "find matching records" that you could use in a script? I'm after something like: Go to Field [target field] Find Matching Records Any ideas how to script this? Regards, Taig McNab

I have a button on my layout that opens a new window with a new layout but same table. When clicked the layout in the new window does not display the same record. How can i change the script to fix this?

I have virtually zero experience with Scriptmaker, and have tried many times over the last 8 months to fix this. Hopefully a no-brainer for many of you. I don't know if it broke somehow, or if I did something to break this, but it worked for many years just fine. Someone else created the original files for me in version 4, I believe. Converted long ago to v9 Advanced.

I'm trying to pass the cc type to a field based on the first character of the card # which is swiped into a temporary global field. If the first character begins with "3" it equals amex, 4 = Visa, 5=MC and 6=Discover. Can you help with the scripting - especially to find the first character. Thhanks in advance.

Stupid question, but it escapes me. I have a FileMaker 7 database on line through instant web publishing. It is searchable by the general public but I have been unable to successfully create a script saying no records match the search terms. This has to be drop-dead easy and I am embarrassed to ask but am compelled to. Just get me started. Thanks.

Hi all, I have an FM9 database (OS 10.5) that I'd like to include a script step which will reset the serial number in the field definition to 1 (and increment by 1). The file is made of up several related tables and is used for quarterly report data. The main db is a customer info db and then the main related file is a transaction db. Each quarter would get a new customer info record and I'd like transactions to restart the auto serial number at 1 for each quarter. Right now, it's up to 250 or so and instead of manually going into the field definition each quarter to reset, I'd like a script that creates the new customer record and resets the serial # for the tra…

The script step is to bring a record, with a particular field occupied, to the front of a set of records with the selected field empty. TIA, LEOnyc v7 Pro back to the Nashoba days (infrequent but loyal user)

Is there a way to write a script that authenticates a login and menu options change, and most of the toolbar options are grayed out? Is there a way to create custom menu and toolbar sets with filemaker pro 9? There is a custom menu set but is there a way to edit the menu sets?

Hi, i am a beginner in FileMaker Pro 8. i have to write a script in a FM file which takes backup of different FM files.. m using openfile command to open a file but whn i create a copy using save a copy as i creates backup of file containing the script not the file that i opened in it... plz help me out... :)

I need to automatically enter a file name into the "insert picture" script step... Is this possible? I can't seem to grab a file name from a field using this option.. Bacially I have a field with the exact same description as the "file name".jpg so I was trying to scroll through all my created records and automatcially insert the related pictures. ie from loaction C:Documents and SettingsbenDesktopfileName FYI. I am using Pro8 advanced TIA

I am working on a database that is mostly mouse based, meaning all boxes are drop down menus or calendars. All input can be done with the mouse. There is one field, Serial Number, that I have to go to the keyboard to enter data. I am wondering if there is a way to enter the numbers into this field using a 10 key pad in the layout. Button "1" would enter a 1, button "2" would enter a 2. Thanks in advance for any help on this!

Can you help please? I have a sales statement from itunes now in Filemaker. I have three different songs, SONGA, SONGB and SONGC. Each record has a field "Track Title" with one of the titles in it, and a "Net" field which has a numerical (cash) value. There are other fields which are not needed. I need a script to calculate each specific songs total added Net amount and display it after searching the 200 or so records. Any ideas musch appreciated or if anyone knows of a similar script I could look at that would be great.

First - Been gone a while with my real job and am trying to find a solution to this.. Second - I'd rather not use a plugin although I guess I could use my Troi Short version - I'm using the "Open URL" script step at the moment to send info to a web site and create an address for shipping... something like: www.website.com?name=john&address=1234 1st street&city=myhometown&state=mystate..... well you get the idea. It works fine and the address is added to my address book. However..... It has to open a new tab in my browser for each address. Any ideas on how to just send it without opening all the browser tabs? Thanks in advance

Hello FM Dber's, I have an issue that I find puzzling. When using the "send mail" script there seems to be a limitation on the amount of text that Outlook email will create. I have the following Message setup and the Contacts::CONTACTlog will not display when the Outlook email is created if it is too long. Is there a text limitation? "Notification by: " & Contacts::CONTACTnotification &"¶" & "Contact Name: " & Contacts::CONTACTname &"¶" & "Contact Phone: " & Contacts::CONTACTphone &"¶" & "Address: " & Units::UNITaddr1calc & "¶¶" & "----------------------------------------------------"& "¶" & "…

My interface is a single main window but for certain functions I "open a pop up window" for actions such as data entry in portals, entering search parameters, etc..." I like the way the pause button prevents the user from getting out of the active window and locks out the window close buttons. Just a thought, would it be a good idea to add a pause script step to the end of ALL scripts so that after an action is completed, the user is forced to stay on the window and to prevent the user from using the close a window button?

Does anyone know how to send mass emails pertaining to the field contents. We have different showrooms. We need to send to all showrooms. We have a showroom field. I would like it so it opens up my Thunderbird email application with all the email addresses of that showroom in the BCC field of the email. And if there are no email addresses it just skips that record and goes to the next until it has all of the showrooms in there email addresses. Please help thanks. I can do a search and pull up all records i want to mail to. then i need to know how to get fm pro 9 to open up my default email program and insert all the email addresses from my email field from…

Hi, I'm completely new to the forum as well as to FileMaker. I'm just starting to learn it because a friend of mine need to do an application with it. It has some requirements for its application. Most of them are normal features, such as storing informations, querying a database and so on. But he asked me about the possibility to open from the application a directory on the hard disk. He needs to open some files (pdf or doc files, I think) so he would like to have a button or a link that opens the normal browsing window. I think it should be possible to do such a thing, but I'm not completely sure and I don't know how to search, so I'm asking here. Maybe…

I am using: TextColor ( blah::woof ; RGB ( 0 ; 500 ; 0 ) ) Refresh Window [] ... which works, but when I add a loop later in the script -- setting a global variable to the CurrentTime, loop, exit loop if the variable + 1 < Get (CurrentTime) -- the formatting doesn't show up except for a flash, as if the loop is executing before the color is drawn to screen from the earlier step. I have a TextFormatRemove ( blah::woof ) as the last script step, which works. Ken

I'm familiar with "tab order" and pressing the tab key to move my cursor to the next field but I'm looking to automate the process. With a telephone area code field and a telephone exchange field, (set to a max 3 characters in each), while performing a find, as soon as the area code field has three numbers entered, I'd like the cursor to move to the telephone exchange field. I'm looking to type six numbers and have only three in each field. I'm told that almost anything is possible with Filemaker, so perhaps Filemaker Pro Advanced 8 can do this?

Doing some disaster preparedness work, I saved a PDF copy of all my Scripts using the Script Editor's Print Button. I was browsing through the printout, when I noticed a problem. Several of my scripts has a Import step, and the Printout does NOT match the actual script step. For example: The Actual Script Step: Import Records [ Source: “file:XXX”; Target: “Events”; Method: Update matching; Add remaining; Character Set: “Mac Roman”; Field Mapping: Source field Serial import to Events::fkImportSerial Source field WorkerID match with Events::WorkerID Source field HireDate match with Events::Date Source field kHired match with Events::Ev…

What is the proper way to set a literal character value into a text field from a script? I need to insert an extended character code (e.g., Wingding Up Arrow = 0233). I can enter it into a display field using "Alt+0233" from the keyboard (field defined as Font = Wingdings, of course), but I can't come up with a SetField equivalent. The help file doesn't provide anything on literals or on special characters, which seems strange. Thanks for any help.

I am writing a script to allow Employees to print out their worksheet for a given day. We are supposed to do this every day, but inevitably people will have forgotten and want to print out yesterday's or one from last week. The script moves the user into a layout called 'Timesheet' based on a table called 'Timetracker'. It enters Find mode, successfully pastes the user name into the Name field. Then I want to display a dialog which prompts the user for a date. I'd like it to display today's date as a default. I created a field (within the Timetracker table) to hold this date, and made it a global. The script inserts today's date into this field, then shows the c…

I want to do something pretty simple, and I am sure incredibly common: get FM to request input from the user, then use their answer to do a search. I've created a script that uses Show Custom Dialog. That requests the input OK, but how do I access the answer? Where does FM put it? What do I put in the Perform Find step? Specifically: Show Custom dialog ["Number"; "Type a number"; Main Data::Num] If [Get (LastMessage) = 1] Perform Find [Restore] .... In Perform Find [Restore] the formula is Main Data::Num:[="Type No."] where "Type No." is label given to input field #1 in Show Custom Dialog definition. Am I missing something here. Do you have to create…

I thought I used this piece of code successfully in a Filemaker 8.5 script, but I can't seem to get it to work in Filemaker 9. I'm trying to flag records as being new (imported into the database that day). If [Get (CurrentTime) = assets:creation_date] Set Field [assets::status; "NEW"] Else Set Field [assets::status; ""] End If Where assets is the table with my records and creation_date is the record creation date. I hit run and nothing happens. Any help would be appreciated. --jon

I'm confused : about when to use the script steps Printer Setup and Print. Both are very similar, except Print allows you to select the current record or browsed set for printing. However, it also has the same printer options that appear in the Printer Setup step. So why two? Any suggestions on when to use these script steps?

Is it possible to output the results of a value list and somehow import those into a field of another table?

Is there any way to use a filemaker script to act as if you went to a webpage, hit ctrl + A (select all), ctrl + C (copy) and then paste into a text field in the database. it's always seemed that i'd have to do the 'select all' and 'copy' manually. seriously, i would love to know how to do this, even if it requires using something in addition to filemaker to make it work. alternatives that might accomplish the same thing would also be appreciated