Script Workspace and Script Triggers

I have users who only need to be able to tinker with one particular layout in the FileMaker file. It is their report, and sometimes they will want less fields displaying than other times. I am trying to figure out how to keep the database secure while allowing this. I made a layout and gave this user group the privileges to modify the layout, but not change any records from this layout. At the moment, they can only see the layout in browse mode and not layout mode. I'm just struggling with how to give them a button to click from browse mode over to layout mode...

I need help troubleshooting a script. I am having intermittent errors with the script this section of scripting came from. The error is NOT re-producable by me; I just ran this script on 50 different records and all worked fine. In real-world use at our company the error occures approx. 5% of the time. The purpose of this script is to find all records released on the same day to the selected client (NameLink field). The problem is that even though a record with the selected client name and DateReleased exists - the script sometimes gives a 401 error - no records found. ------------------------------------- SCRIPT STEPS --------------------------------…

I created a script in a form that takes values from items that are selected and combines those selections into one field. The idea is that the selections automatically generate a file name that will be used for the name of the art file that we are creating. The script looks like this: GetValue( Post Pay Category; 1 ) & GetValue( PO Basics; 1 ) & GetValue( PO Getting Started; 1 ), etc, etc, etc. There are a bunch of 'GetValue' items with the '&' symbol in this script. What is generated is a something like this: PPA12345678B1234567C12345678D. Now what I'd like to be able to do is to take that long file name and truncate it. If you look at the struct…

Hi guys, Quite new to filemaker so please be gentle. I'm wondering if i can insert a script into a date field that will send a notification email if that date has been reached without another field being filled. Eg: field is for delivery date. next field is received. So if date = delivery date and received is empty can a script send notification that delivery is late. Hope that makes sense. Thanks hawkesi

I've created a database for potential sponsors and have a checkbox that when checked shows the potential sponsor has become an actual sponsor. I created a script and applied it to the checkbox so when the checkbox is clicked a new record is created in my confirmed sponsors database. I've applied the script to the checkbox and it works. The problem is it won't actually put a check in the checkbox to show they've become a sponsor. Is there a script action I can apply that allows a check to be put in the checkbox and also performs the script I've created? Thanks for your help.

Is there a simple way to script to check if a folder exist in a certain directory. I would like to use (if) function so I can have the script do something else if not exist. Thanks in advance

Hi everyone, I am scripting a recovery process. I've attached a file I have started (actually two files): One with the data and the other called GrabSerials. What I want to do is this: When I export recovered data from each base table (layout) in the Data file, capture that 'next serial number' in the GrabSerials file. Then when the .MER files are imported into a new clean clone, set the next serial with that matching serial number. This process should not relate between the files in any way; or, if it relates, it should only relate simply from one FILE to the other and not from the GrabSerials TABLE to each table in the Data file. Make sense? Is ther…

I'm trying to develop a good way to add shipments with around 60 new inventory items to my inventory table. I figured A custom dialog box with a script to create the new records would be a good start. Alright I need to delveop a custom script that will: First: popup with a custom dialog box that asks for how many new records and the invoice Number(it would be the same for every new record) and create those records. Second: Then it creates however many new records I put in and they are all filled with the same invoice number. If anyone has seen a better way to add bulk new records to a table then I'm open to suggestions. Any help would be appreciated. Than…

Good Morning all, I have 52 weeks in my database, and what im trying to do is create a script that will move 3 fiels from wk 1 to wk 2, and wk 2 to wk 3 and so on. I have been using the copy past clear, but this takes to long, and im trying to find an easier more effective way of doing this. The idea is to have 52 weeks of data that can be easily retrieved to create reports and such. each week there's new data and would need to run this script to copy fields to the following week and at the same time clear the fields in Week 1. Thanks in advance

"Save a copy as" > "Copy of Current File" seems to work fine from the menu bar, but not as a script step. Anyone else noticed this ? - C

I'm trying to generate a sub-total for my database. Currently I can sum the total value of every part ordered by every company. But what I want is to get a subtotal for the value of each part ordered by sales order (I hope that's not to confusing) I've included my "pseudo code", and i've commented with // Sales Container = Sales Order# // Sales Container just a generic variable// Project ID = 1 //Trying to start with the first project// Loop If (Sales Container = Sales Order#) SubTotal = SubTotal + Amount //Amount being the value of each part ordered// Project ID = Project ID +1 Else Sales Container = Sales Order# Exit Loop if Pro…

I have hundreds of [color:red]this is an item descriptions that need to port to the web with an alternative character for the space. So I need them to read [color:red]this_is_the_item or [color:red]this-is-the-item etc. I know there is a simple way to do this and for some reason I am just not getting it.

I am building a script to enter find mode, set field to "invoices" then perform find. Well now I need to also pull statements in that script. Right now in the calculated field I just have.... "Invoices" How should I include "Statements"? Thanks.

I'm trying to generate a field that will display the amount of days left until a project is due. Currently all that is set up is a simple calculation that takes the due date and subtracts the current date. But obviously the problems begin when the project is completed and the due date has passed (ie it looks like the project is overdue). I don't want to confuse this for actual projects that are overdue either. I have a drop down list that prompts the user to say whether the project has been completed/cancelled/defered etc. and what I want is for when a selection is made it updates my "Due In" Field I've included my script as it is so far, (it doesn't work at the mom…

I have a summarised report in an Event table displaying events grouped by VenueName. Each page represents about 10 -12 Events. I need to export the Pages (not records) as individual PDFs, what is the best way to accomplish this? I have tried Save Records as PDF and clicked All Records and then Options: Page 1 to 1 which works for the first page, what is the best way to automate page 2 to 2, 3 to 3 etc..? Or is it best to remove the first page (with a Constrain) and get page 2 to be the first record? Many Thanks

Hi there - I've managed to get the XML (well, XMP) data from imported images into a field labeled "XMP", but now I would like to parse that data into different fields according to hierarchical subject heading. The data in the "XMP" field looks like this: Nation|Germany Image Type|Photo - WW1 Era Original Aircraft Manufacturer|Friedrichshafen Aircraft Type|Biplane Aircraft Type|Seaplane Aircraft Seats/Use|Bomber Setting|In Flight My fields are named "Nation", "Image Type", "Aircraft Manufacturer", "Setting", etc. Obviously, the text string that I would like to parse immediately follows the subject heading and the "|", then ends right before the "". …

I'm trying to constrain a set to the results of more than one field. For instance, I have a list of client's names (composed of two fields: First Name and Last Name). I would like to script a find to constrain the set to include results from both the First and Last Name fields. Therefore if "John" was a first name, it would show up in the found set and if "John" was a last name, it would also show up in the found set. Any advice is appreciated. Picture_2.pdf

Hey everyone, I have a problem I'm hoping you can help with. I am trying to put a flag on my main layout that identifies if a constituent has purchased one (vs. multiple) tickets to our season of events. I've tried to use the "is empty" logic function but so far can't get it to work. For some reason it keeps "judging" fields names similar to the one I really want to use (i.e., "Adult Single Ticket Sold" v. "Adult Applause Ticket Sold").If the field "Adult Single Ticket Sold" is empty but the "Adult Applause Ticket Sold" is not, it returns a false response (i.e., that there was an Adult Single Ticket sold). Anyone know what I'm doing wrong? I've checked the fiel…

Hi, I'm new to Filemaker,and I'm trying to put together a simple system to keep track of freelance clients. I want to be able to enter a client's name into a 'client' field, and have the system automatically generate a job id in the form of a combination of the client name and a number. For example, was I to enter the first-time client 'John Doe' it should give me the job id 'JOHNDOE001'. Or, if I entered the fourth job for 'Peter Brown' it would give me 'PETERBROWN004'. Is there a way Filemaker can calculate this by checking for past instances of a job id, and adding a new one on to the end? For example, if the job id 'PETERBROWN004' already existed …

Greetings! Please help! We assist with the email send for an events company and we have been supplied with a database from which we extract each race entrant's data and send them a personalised email. Included in this data is whether or not the entrant has purchased a t-shirt for the race. The client has supplied us with an Excel spreadsheet which includes separate fields for small, medium, large, x-large and xx-large t-shirts. The fields contain the number of t-shirts ordered by the entrant. The extraction of data becomes more complicated as there are cases where one entrant will purchase multiple t-shirts of different sizes. In the event …

Hi all I don't know if it is possible or not but I want to run a script when i go to a different record but not necessary changing record contents (this means zippscript plugin with validation calculation is out of the question). This means every time i view a different record in a form view a script will happen. Is it possible Thx

I cannot seem to collapse/expand all the scripts in the Manage Scripts list with just a couple of key strokes. Is it possible?

I have a Send Mail script that populates an email message. Once you close or send the email message, is it possible to bring the database back to the front? Currently you have to click back on Filemaker in the Windows Taskbar. Thanks for any help.

Hi guys i'm a complete noob... I need a script that will run on startup to start a different program... timeline: FMP starts Other Program starts any ideas? thanks in advance

how can i check a value calculated within my script to see if it matches a field in any record, not just the current one?

I have a database that users use to keep track of contacts. Users Frequently go into Find mode and forget they are in there, then click the New Record button to create a new contact record. I have a script that runs when they click the New Record button that first requests an email address for a new contact record and won't let them continue until they enter it. If they are in find mode and this script starts to run, it won't allow them to save the information they enter because they are still in Find mode. Is there a way to check to see if they are in Find mode and exit out of it before continuing with the script?

hi... i know this is probably discussed before but can not find it in this forum and google doesn't return anything useful. i need to be able to update a database/table automatically when the data is available. basically need to import tabbed text files into a table at certain hour every day. using cron maybe? this has to happened on the server and the file is being opened remotely (workstations). one other issue is - although that can be resolved externally - the name of the file varies - it has the 'yesterday' date in the name. is it possible on the server 9 for this to happened while the file is being viewed/opened on any given number of workstations? …

I have a problem and the script is really simple. What am I doing wrong. I have a field called "comment" in a table. I want a custom dialog box to open and I want two options for the user. When the user hits button 1, the data from the input field enters perfectly into my comment field. When the user hits the second button it won't put the data into the "comment" field. I thought I was using the getlastmessagechoice function incorrectly, so I got rid of that part of the script as a test. Now I'm left with a two line script to just get the second button to allow the data to enter into the "comment" field. My script looks like this: - create new record - Sho…

I have a global calc in Table A showing a Max_serial ID field in Table B that increments up one number when a record is added to Table B. Although the Max_serial ID in Table B does increment up a number when a record is added to Table B, the global in Table A does not and remains the same. Is there a way to trigger the global in Table A field to increment up via a script or is there a better calc or other solution for this? TIA Win XP, FMA9

Hi All, I'm new to using FileMaker and am having an issue with a script I'm trying to write. Basically I've created a many to many relationship using an intermediary table because I need to store some information on the link. The association is between "Shops" and "Parks", with things like the distance between the two stored within the intermediary table. I was hoping to be able to add a button on the "Shops" page that said something like "Associate with Park". When the button is clicked the "Shop ID" is copied, and the user is taken to a new layout when the "Shop ID" is pasted into the foreign key field there. For some reason this doesn't seem to work, as …

I have two fp7 files. They are unrelated. I am wanting to copy some of the data from on file to the other using a button on a specific record. So I am thinking a script on the button that creates a record in the other file, copies data (loop) from the original file to the designated fields in the new record on the other file, then brings the other file forward so the user can fill out the remaining missing data. I am sure there is a simple way but I just don't know how. Thanks Thom

Hi say that I have a long script with repeating steps like : Print [ number of copies = 1 ] Print [ number of copies = 2 ] ... Print [ number of copies = 100 ] Print [ number of copies = 101 ] ... Do you think that there is a way to say: Perform Script Step [ 100 ] w/o creating a loooong set of If/else ? The problem is that you can't specify dinamically the number of copies. I know that it's possible to create a table based on the number of copies needed, but print 100 record need more time than say to the printer : print 100 copies of the same record. Or there is a plugin that can get a number from a field and put it into th…

Hi, I am a FileMaker beginner . I have a few questions. 1)Is it possible to use timer in a FileMaker Pro application. eg a script would run every day at 9 am.? 2)Can we have a script to download all .zip files from a given ftp site? 3)Can we unzip the .zip file in a FileMaker Application? 4)Can we read all .xml files in a given directory? Thanks in advance.

I know there is a script step that opens the Define Value List dialog. I would like to add a button with a script that would open the specific value list for me so I can start editing the list. I know the edit option is available in the actual list at the bottom - but I do not want users to be able to edit in this particular field.

I have a report that has four separate pages. I am trying to create a script that will either view or PDF all pages together for a subset in my database. The key field in the database is Symbol. There is a found set of records (called Current Holdings) for which this four-page report needs to be generated, so that each of the four pages are together in a single PDF. In other words, if the first record in the found set is ABC, then I want a PDF file for ABC that contains all four pages of the report. I want to do the same thing for the next record of the same found set. There are a total of 30 records in the current found set...the number of records changes regul…

Hi there. As part of a database Ive developed i had to include a field that summarized the information from a portal. I did that using the "List" Function to create a calculation field that looks like this: Substitute (List (tablename::fieldname);[enter symbol];",". The calculation gets the information, and presents it as a comma separated list. It works perfectly fine in my computer, im using FMP9. Ok, what i didnt know was that they wanted to use the database on FMP8, where it seems the "list" function does not exist... is there a workaround for this? maybe the list function had another name in older versions? help?

Need to make a change to a script that involves adding an argument to the Insert Object script command. At the moment ScriptMaker only allows me to double click the line and search for a file, but not allow me to modify the line manually. I want to do something like this: Go to Field [Table1::Field1] Insert Object ["Video Clip"] That example is from the FileMaker help, but again, I'm unable to add the "Video Clip" part by myself. There is any way to bypass ScriptMaker at all? Platform: FileMaker9 Adv, Windows

I feel like I've read about this somewhere but can't find it for the life of me: I have a script set up for printing a report, and everything is fine all the way to the final Print dialogue box. If the user prints, the script finishes up okay. If the User hits 'Cancel' instead, he gets one of those annoying sounds and a dialogue asking whether he wishes to continue or cancel the script. What technique do I use so he doesn't get that option? My impression its best to avoid letting users cancel scripts in the middle of things as a general principle, yes? Can someone clue me in on the guiding principle here and how to get from the Cancel Print right back to the orig…

hello, i have a curly one for you : we have a filemaker file in which we store inserted objects. this file has a container field, and files have been inserted using the "Insert Object" script step. the options specified in the Insert Object dialogue are: Create from File, a file is then selected (JPEG/TIFF/PDF/DOC), and Display as Icon has been selected. and here comes the curly bit... we want to export the files that have been inserted into the container fields. we can't use the export field contents step as we have used the Insert Object command, as opposed to the Insert File/Picture commands. we don't appear to be able to use Fil…

I'm running a start up script that is supposed to take the user to a certain layout depending upon his/her privilge set (Parent). The script is not working. When testing, I created a global calculaton set to equal "Get ( PrivilegeSetName )". When I log in under my account it returns [Full Access]. When I log on with Paret user account, my test field still shows [Full Access] when it should show Parent. What's up with this!!!

I would like to set serial numbers for a subset of records. First, I sort all the records with two criterias, so that the records with the same entry in the first sorting criteria are grouped together. I name them 1st-criteria-groups. Then I would like to set serial numbers (1,2,...) for each individual 1st-criteria-group. I know how to build a script that sorts with two criterias. But I don't know how to generate serial numbers, that always start over again.

Hi, I am currently working on a project for a company I am employed at, and was wondering if someone could help me out with a problem I'm having. I have 2 tables - ProductKit and Inventory. The idea is that 20 products are listed in Product Kit, with 3 fields: Serial number name quantity The table Inventory has the Exact same fields. I need the script to change the Quantity in Inventory to be the Quantity in ProductKit, and do this for all 20 products. I have tried looping through a repeated field with 20 repeats, but I can always only get the first quantity to change. My problem seems to be that I don't know how to reference …

Is it possible to add a new record to a table without a layout? One way I know to add a new record is using script steps like: Go to Layout New Record/Request Set Field... I have a many to many relationship with a connecting table. I don't want to create a layout for the connecting table, but still want to add a new record to the connecting table. Thanks

Okay, first let me say that this is not going to be an actual 'Find', and I expect all of this to be done in Browse mode (hopefully). Here's my situation: When a user creates an invoice, they have to specify how the entire order will be shipped. This is done by entering it into a SHIP field. There are many ways that the order can be shipped, such as by freight, UPS ground, ect... But the user needs to enter extra data if they choose to ship by UPS. The type of UPS shipment may be different, such as UPS ground, UPS air, UPS dropshipment, etc... I'm wondering if there's any way to create a script that will check to see if the SHIP field starts with UPS, and if…

We have a few stand alone files, where, at closing the file a backup (copy) is made with script: Set Variable[$Path;Value: Let( [ now = Get ( CurrentTimeStamp ) ; year = Year ( now ) ; month = Right ( "0" & Month ( now ) ; 2 ) ; day = Right ( "0" & Day ( now ) ; 2 ) ; hour = Right ( "0" & Hour ( now ) ; 2 ) ; mins = Right ( "0" & Minute ( now ) ; 2 ) ; secs = Right ( "0" & Seconds ( now ) ; 2 ) ] ; Substitute ( Get ( FilePath ) ; ".fp7" ; "_" & year & month & day & "_" & hour & mins & secs & ".fp7" ) ) Save a Copy as ["$Path";copy] This is working fine. But it saves the cop…

Hi, I need to develop some logic like. Enter Find Mode Set Field ["Multiple searching criteria seperated by some breaking characters."] Perform Find Must have got my requirement. I dont want to use separate, more than one set field script step to get data satisfying multiple search criterias. Is there any separators available, by which we can combine multiple searches in to one and get the required data? Is this possible in Find Mode?

Can anyone take a look at this solution and see if their is a better way? I have a field in a main table that can have zero or many values from a checkbox control/value list. I have to count the values in a report so I came up with a script that "parses" the many values and relevant one values into a temp table then reports on that. It works fine in my final solution but wonder if their is a way to do it without involving the temp table. TIA Kris test_value_list_stuff.zip

Hey, I got a problem with my scripts / layouts... First my QUESTION: Is there a way to create a script that closes all other running scripts but not itself? And here’s the PROBLEM behind it: I’ve created a search layout that can be accessed by the users in find mode only. At the top of the layout there’s a button bar, and when pressing a button a script takes the user to other search layouts. Except one case everything works fine: When a user enters one of these search layouts in find mode, the script pauses so that he can enter data. However, if he does not perform a search on this layout (so that the script would end properly), but goes via the …

In a script where multiple variable are used is there a way to clear them to nothing once the script is done. I'd love a way to clear all variables with about have to specify each and every one.

I am storing some word doc files and some text files in container fields to keep them part of a larger project. I would like to write a script or something that would automatically open up that file, and copy the text and put it into another field so that I can run some scripts on the acutal text. I have the scripts working to sort and pull data from the text, but I want to eliminate the manual process of opening the file, copying the text, and then pasting it into the other field. Any thoughts out there?

Ok, so I did something really dumb. I was working on a launch script and I hit test before I double checked it, and now, it is closing the current window, and opening another but no layout is programmed so when I launch, it is basically going nowhere and I can't seem to abort the script fast enough, is there a way to force the database to open in layout view? What are my options? Yours... feeling silly...

I am new to Filemaker (version 9), and have been ripping what little hair I have left out trying to do the following. I have two related tables, a parent and child. The parent table is fully populated, the child table is not, it is empty. I want to iterate over the parent tables records, and for each of them create a new record in the child table, relate it to the parent by setting the foreign key field, and then copy some other fields from the parent record to the new child record. Everything seems to work fine except for the iterating part - once I change layout to the child table (see pseudo code below) I cannot seem to ever change layout back to the parent table to mo…

I wrote a script that's supposed to export data as an Excel file and save it to a user's desktop. On any Mac I've tried, it works, but on any Windows machine, I get the error "filename.xls could not be created on this disk." I've worked around the error for a while now without finding a solution, and now while looking at the FileMaker Developer Reference (Que Publishing), I see that the result of this function is often cached on the server (along with several other Get functions) in multiuser settings. Is that what's causing my problem?

My database has a student order table, which is related to the main student table. I'm trying to "idiot proof" the ordering process. I've got scripts that check the relationship to see that aren't identical orders. I'm trying to come up with a script that will indicate if two orders that shouldn't be placed together are attempted. As an example, if a "pasta dinner with salad" is ordered, the user shouldn't be able to order "salad". In the order table, I have a field that indicates the product type (Dominos, SubWay etc), an additional field for the item description. I think I need a way to query all related records item fields and compare it to the order being placed.…

As I'm new in FM and this forum, I do have a question about a certain script. In my DB I do have three tables: "children", "sponsors" and "adoption". The children in my DB have a status "free" or "occupied" and an ID. My sponsors have an ID In the table adoption I'd like to link a child to a sponsor. I'd like to make a script that selects automatically a child that is "free", with the lowest "id". This value (child ID) should be placed in the tabled adoption. Can anyone help me for this script? Thanks

Hi peepz, I think you are going to laugh your heads off when you guys know what I am going through. Anyways, I did a start-up script which goes New Windows GotoLayout Close Windows and guess what! I cannot open my database because it closes. and to make matters worse, I didn't do a back-up! *bang my head* can someone please help me out here? regards, farah k.

Hello I have a script that is pasting contents from another table into a portal that has 6 rows. I want to have the script not overwrite the contents of the first row if there is something in it and paste it into the next row. I can already paste it into the first one, but I assume there is something in the scripting options to tell it to go to the next row if there is something in the first portal row. Any help would be appreciated, thanks - Jeff

hey guys i need help on making a script for a record with a field titled "Source #" I want it to be global if and only if a different field (with a drop-down menu) is set to "Open" how would you make a button/script to make multiple "Source #" fields global?

Is anyone else having the same problem as me??? I'm using the Save Records as PDF, to attach a pdf of the record I'm browsing to an email in entourage. It creates the pdf and attaches it to an email, but the pdf is unreadable. Ever sense I've upgraded to Leopard this has been happening. I've applied all updates and still have the problem. Any input or suggestions would be greatly appreciated.

Does anyone know of a way to run a script that updates every so many minutes / hours etc. automatically. I am running a script on each users computer that brings in Postgres data from a management system. I want to update the tables in Filemaker to avoid user having to constantly manually run the script.

I am new to filemake. Is it possible to copy script (or a few line of codes) between projects? I couldn't even open two script edit windows at the same time so that I can use one as a reference. The only thing I can do is to print the script on a piece of paper.

I have script that runs a grouped data report that is sorted into a page for each customer. Each customer has one or more items assigned to them. The script then enters preview mode. So the report is 10 pages if there are 10 customers. I want to create a PDF of each individual page, not the whole report and not a single record. I want the name of the PDF to be the name of the customer. Can I do this?

Hello, I have a list view layout with all my customers and I want to be able to press a button that will copy some fields from a selected record to my invoice table. I have posted a picture of what I'm trying to do. Any help would be appreciated. Thanks - Jeff

Hi! I am trying to use a field-variable in a script to open record-specific file stored remotely on a server but does not seem to find an "open" command for other than fp7 or xls or formats FMP recognises. I just want to open a file by starting its designated application, not import it in FMP. I kind of suppose this is a stupid question but I am lost. Nico

Hello I need to run a script that pre-populates some data in a table for future data entry in a particular layout. There are several required database fields in this table/layout that I do not want to pre-populate and I can't 'commit' the record within the script (to temporarily override database rules). Is there a way to populate a null value in a field that passes database required constraints, but does not really populate the field with anything? I know I can insert a blank space, but I don't want to even do this. Joe

I'm using FM 9 advanced. Is there a way to add a comment directly to a script step (instead of using the Comment script step).

I'm trying to generate a script to copy a price from one table to another, it would look something like this (my script lingo is not very good) If (Inventory[color:red]Sold::Serial Number = Inventory::Serial Number) then copy Cost from Inventory::Cost to Inventory[color:red]Sold::Cost Any ideas to get me started on a working script? Thanks - Jeff

I've got a question -] I have a client who does something odd, then FileMaker does something even odder. It's a printing script, in an older solution that still has an external child file (groan). The script goes to the child records, then presents them in Preview mode before printing. I allowed user abort, so it has the Continue and Cancel buttons. The trouble is, he doesn't hit either. If he doesn't want to print, he just closes the window. A strange thing happens then. The child window closes (then reopens in the background, since it's visible in a portal in the parent file). But the parent file loses the found set entirely, showing all records, and ending up on …

I have a script which inserts files into a container field based on a filename field. If the file name does not exist the script brings up a dialog box to choose the file. I would like the script to bypass this dialog box and leave the container field empty. Turning on the Error Capture removes the error dialog box but not the choose file dialog.

I have a script I'm in the process of writing. Here is the pseudo code for what I want to do. --- start of pseudo code ---- Go to first record of attendee list Does attendee have associated person record? If not import record from external database (Oracle- connected via ODBC) Go to next record until end of attendee list. --- end of pseudo code ------ My question do I have pause somewhere in the script to allow for the import to finish up or will the script wait until the import is complete before moving onto the next script step? I want to be able to loop this script and make sure that I don't run into timing issues. Paul

I need to create a script that will look at the field "Date" and if it is empty, then it will omit all those records and only show the records that have data. I am using this script in a report so if the data is not in the specified field, that record will not show up in the report. Then upon hitting the continue button it will return to the original layout showing all records. Any advice?? Thanks

Is it possible to upload files with IWP? Has anyone seen a plugin that helps (FTP or other)?

Is it possible to have a button in FM9 to open the Finder? I have a client file system and the client's files from iWork, PDF's etc. are there. It would be nice to have a button in a layout that would open the particular client's folder in the Finder. Possible?

Please help if you can. I am trying to bring in data from a different database that had a long list in a drop down menu. I am trying to bring this list into a table that has a record for every entry in the drop down list. I don't want to have to do this manually. I've got the field to display the list from the other file, and when I create a new record the field is auto selected and all I have to do is hit the down key to select the entry, but I can't seem to automate this. I'm guessing I can use the get value list function to pull up the list, but I can't get my head around how to automatically create a new record, and select the next value in that list and on an…

I'm not sure what the Print Setup script step is for. The Print script step lets you select the records to be printed (current or browsed) and lets you set all the parameters that can be set in the Print Setup script step. When would the Print Setup script step be needed in a script?

I'm looking for a way to relatively easily backup records from one table to another. Each table has the same number of fields (except calculation fields in the second table, which aren't needed) and all field have the same name as their counterpart. I want to make a script that looks for all records at least X months old, copy it to another table, then delete the original. So far, I've tried the actual 'Copy Record' action in ScriptMaker, but this just copies all the text, then pastes it all in the first field of the backup table. Preferrably, I would like to not go through each field and Copy/paste (or have a Set Field[] for every single one) and I was thinking a…

Has anyone discovered a way to send bulk email with multiple attachments? I work with a group that sends non-commercial information to charitable organizations. In order to advertise an upcoming event, I want to send them a pdf poster as well as a pdf volunteer application. Any thoughts?

Is there a way to make a script that will make a folder on windows and name it something custom from the database? ie: (Full Name) (Policy Number)

I need a way to hide the social security number so that the first 5 numbers are seen by the user with X's and allow the last four numbers to show. In other words when a record is opened the user enters 582-44-5432. Then the user user sees XXX-XX-5432.

I'm trying to get a found set of one single record of 71000, so i started a script that assigns a variable to the serial number of the record currently being viewed, then i wanted to have the script do a find for that variable so i end up with that record in the found set, i can't figure out how to specify a find for a variable.. any suggestions?

Hey all, I've been reading around and found no answer to this common problem. When my coworkers execute scripts that generate a send mail step, they can not access filemaker until they send the email. I could solve the problem by simply sending mail without dialog, however we need to be able to edit the emails first. The only solution i've found is to use a mailto script step. Since you can add cc, bcc, subject, and even body text via a mailto: open url step. This won't work for us since there is a limit on the length of the body text using that step. The strange (well not really) thing is that I myself use Mozilla Thunderbird, and do not experience t…

I've tried to use script variables in the ExitLoop If script step to no avail. For example ExitLoop If ($Count=$Num+1). The script does not exit the loop when the conditions are met.I see that the Set Variable step only lets you use text values. I'm using numbers for $Count and $Sum (1, 2, 3, etc.)

I have a script to send an email when a certain function is performed. My problem is that some calculated number fields give me a number with too many decimals. How can I restrict it to give me the number with only 2 decimals or none at all ? I have formatted the number to 0 decimals but it is not working on the email body. thanks

Hi, I am trying to export a registry file, from Filemaker, with a line or two being data that can vary. Does anybody know of any good methods to do this? The main problem is that exporting field contents does not include line breaks. So the closest I have come is to export a whole table, with each record becoming a separate line of the code. However, I am unable to include the variable data from the database, by a relationship. The closest I have come to this is by creating a script that creates a variable from the data in question, goes to the relevant record number in the code table, and copies the variable here. The problem with this is all the screen flick…

I have been experiencing random errors with scripts. It seems it is just randomly skipping script steps in different places on different client machines. Sometimes is works sometimes it doesn't. Like if I run it through script debugger it doesn't skip anything, but without it, it skips large chunks of the script. Does anyone have any insight on why this is happening? I have tried to rule out numerous things, like rebuilding the script, setting it to a different script, recovery, save compact copy, etc with no results. There is no connection or consistency to the error. Help... Please... Somebody?

hello i want to insert a value into a field of a record that is currently in view [listview] [using rolodex navigation only]. and when the user moves to next/previous record it not only inserts value into the then current record but also makes previous/next records fields blank [record which lost the active view]. i can do this through a script. but how can i link the script to rolodex navigation buttons only [status area]? thanx in advance.

Hi: My question is about the value of CurrentError after setting a field value in a script. I have a script that sets a field and the field is defined to contain unique values only. When my script sets the field with a duplicate value I do not get the expected error '504 Value in field does not meet unique value validation entry options' in the 'CurrentError' function and therefore can not handle the error condition in the script. Does anyone know why the Set Field script command would be successful in bypassing the validation rules set for the field? Here's my short script: Set Error Capture [On] Set Field ["Management IP Address",""10.1.4.208""] If…

I've been racking my brain trying to figure out this script for days and I'm at a loss. I have a table that has episodes entered into a field with episode numbers, dates, descriptions, etc. The episode numbers are entered as follows: 080609T 080610T 080611T ....and so on. We use this information to print labels for our media. Normally we'll print a single episode's worth of labels for multiple stations. I need a script where I can print multiple episodes for one station. So far this is what I have for my script... Go to Layout ["Episodes:Episode List" (Episodes)] Enter Find Mode [] Show Custom Dialog ["Enter the Episode that you…

Hi, You guys/girls out there probably know this easily but I am a little new to Filemaker. I have several scripts which produce almost identical reports (Just different Area's), so instead of running each one seperately, I want to just have one script which triggers the other scripts of one after another. HELP.... Thanks for any help...Cheers :)

I've a need to execute a batch file from within FileMaker Pro 9. using 'Send Event' method I'm able to do this. However facing some issues in specifying the file path for the .bat file. For example I need to dynamically create the batch file and execute it. I'm attaching a sample project which explains my needs. The catalog I create (sample) contains two fields. ID, Path. ID is autogenerated number. Path is a calculation field which will hold DOS command to create folder. I have a script which will export the DOS commands (the contents of the Path field) to a btach file. then I need to execute the batch file. Please note that there already exis…

I'm writing a small script to take my users to a website. The "Open URL" script step is a cakewalk. But I'm looking for a way to test if the user has a "Live" connection before I send them to their destination. This way if the user happens to have dial up I can inform them that they need to go online before they can continue. Any Ideas? Thanks, Mel

is there any way to save the field mapping at the beginning of an import so xml files with identical field names don't have to be remapped?

Greetings I am busy analysing our stock control processes and have written a basic script which alerts sales consultants when the stock that they have ordered has arrived. The problem is that one order can have multiple line items (or the parent can have multiple children). When creating an email, only the first record's data is included in the email. With reference to the following post: http://www.fmforums.com/forum/showtopic.php?tid/191192/pid/271786/ a) is there any way that one can send one email which includes all the line items (so as to avoid sending multiple emails per record)? with reference to the suggestion made to the post as menti…

Greetings Is it possible to run a script in Filemaker which accesses a SQL table, runs a SQL query and posts that data back into Filemaker? If so, how would one do this? Our developer has left us and unbeknown to us, converted our Filemaker DB to SQL... our online orders are now housed in a SQL table and while I have learned how to run a SQL query, it would be much easier to execute the script from FM so as to draw the data back into the system that our company runs on... Any help/advice would be greatly appreciated.

Hello all. I'd like to have a layout default to display a particular set of found records. Generally, how is this accomplished without requiring the user to click on a button? Thank you.

hello is it possible to capture the staus of rolodex [record navigation through status area] through a script? that is lets say if user moves to record # 4 from #3 [by clicking on rolodex <- ->/ by using keys]then i should be able to keep track of previous record # as well as current in a variable. for now i have customized navigation buttons and they work fine if user don't use rolodex. but they start to skip records when, lets say, user uses the Rolodex to navigate and go to record# 7 while stored variable in script through my navigation button shows record#2 [last record user went to by clicking next button. i want to eliminate this discrepancy by captu…

Hi all, I have an interesting solution that is almost completely finished except for this one last bit of integration I'm trying to create between a hosted database and a runtime. Here's the scenario: There are two parts to the package. One is a hosted database solution, the other is a runtime that will only be used by one user for one specific task. Basically the runtime is for logging shot sequences of video footage by offsite contractors. The log data is sent back to the production studio for import into the main database, after which that runtime is never needed again by the studio. The client wants to be able to create a package on their deskto…

I have a script that: Goes to layout Show all records Deletes all records (in preparation for a new import of records) This script is normally run once a week Using FM Pro 9.3 on the client with FM Pro server 9. This script has worked fine up to 30 May (date of last successful run of script) Now it just hangs - (coffee cup) with the working message showing the "number of records to delete (total count)" - ie it doesn't reduce at all - no matter how long you leave it) and no choices but terminate process. I have also tried doing it manually ie from the menus - with the same results... Any ideas what could have changed to cause th…

I want a script step that will open the drop-down list for the active field. I know that there is a keyboard shortcut for this (Esc), but I don't know how to incorporate this into a script. Anyone have advice?

Hello. My work has recently begun switching over their database systems to FMP9, and it's my job to get all the functionality running, but I'm new to FM and need some pointers. One of the things I'm struggling with is getting scripts to run at various points. For example (this is all in FMP9), say you have a list of parts, each of which has an ID number. On a related table, you enter the ID number, and it instantly enters the information about the parts into other relational Edit boxes. However, this uses references to the related database, and I would like the information received to be copied to this table, instead of just showing the reference to it. The data sho…