Script Workspace and Script Triggers

Is there a way to use the find command to find when two fields equal each other. ie. return all the records in which Quiz1Score = Quiz2Score ?

I'm trying to setup a DB using FMpro to do a search based on a date range; it could be from 1 day to many days. I have 3 columns of basic data. A date column, price column, and volume column. I'm trying to collate each price level and sum all of the volume associated with that level w/in my search range. A quick example of what I'm trying to do: 9/10/04 1050 590 9/10/04 1051 100 9/10/04 1052 330 9/10/04 1053 563 9/10/04 1054 455 9/10/04 1055 52 9/10/04 1056 244 9/10/04 1057 50 9/10/04 1058 100 9/9/04 1055 100 9/9/04 1056 20 9/9/04 1057 32 9/9/04 1058 54 9/9/04 1059 666 9/9/04 1060 325 9/9/04 1061 548 9/9/04 1062 52 9/9/04 1063…

Is there a way to automatically alphabetize my scripts in the Scriptmaker Define Scripts window rather than viewing them in the order they were created? I use FileMaker Pro v.6. Thanks in advance for any help.

I need to make a Find script that allows the user to enter 1 item "Widgets" then is returned all widgets that are not discontinued. If there are no items found, the script displays the widgets that are discontinued. I am trying to avoid having users have to sort through discontinued items every time they do a find, but still be able to find the discontinued items if needed. I tried the following, but I just can't get it to display what I want. Can anyone help? # "omits records with "Discontinued" in Product Status field" Enter Find Mode [ Request 1 (Omit): Productstatus Discontinued ] [ Restore find requests ] # "User enters find criteria" Enter Find Mode …

I currently have a script to set the view of a window: Set Zoom Level [150%] Is there anyway to set the value to 125% or some other value and not use Filemaker's presets?

I have a date field on a record (a timesheet). In the footer I have another date field and a button to function as "show records with this date" and it should list them in another layout... any help is appreciated! riky

I would like to: 1) save the current record as a .pdf via the print dialog 2) attach the pdf to an email 3) send the email to an address in the current record. (Hmm, If I had a big email database, I could do spam. But actually I want to send my students an individualized grade report.) I think I can do all this, except that I don't use Mail.app for email. I use a school email address and the client is a program called FirstClass. Can I set up filemaker to email out other than via Mail.app? Thanks Drew

I'm trying to figure out if I can run a FM script made with scriptmaker on Server to perform regular maintenance tasks of the database. For example, perform a automated export to email every 2 weeks etc. (This is just an example there will be more things coming up). There is a "Scripts" section in the scheduler of FM Server 7, however that appears to only perform OS level scripts such as appletalk or perl etc. Heck I don't even know if Server 7 CAN execute scripts.. Anything you could throw at me would be great, at the moment I'm banging my head against a wall. The documentation is lacking and no amount of googling seems to give me an exact answer. Thanks …

So I should most definitely know this by now, but its 4:30 and I'm burnt out right now so I'm having troubles. I wanna script something that includes using the substitute function to get rid of field names that were imported into a record. However, I can't even figure out how to use the substitute function as a script step. Any help? Thanks

I am trying to open a Microsoft Excel Template on our server using a script. The script sorts the records and exports them to a .mer file. The scrip then uses the send message step to open a Microsoft Excel template, which contains a macro to import the data from the .mer file. If I run FileMaker on my machine with the template and .mer file also local the script works beautifully. However when I place the files on our server the script does not find the template file. If I change the send message step from either machine on the network the script will find the file from only that machine (as expected). I have also tried the open URL step with a slightly diffe…

Hi, I am toggling a container field within a portal which changes from a 'tick' to a 'cross'. This consists of 2 jpg images of 10.7K in size. The script works perfectly on the host computer but shows "Ran out of memory while trying to translate the file". This occurs on ALL guest computers! TIA Paul The script is as follows: Toggle Tick If [ Upper(Job Items::Valid Symbol) = "Cross" ] Go to Field [ Job Items::In Stock Tick ] Insert Picture [ Filename: "Tick.jpg" ] Set Field [ Job Items::Valid Symbol, "Tick" ] Set Field [ Job Items::Sort, "0" ] Exit Record/Request Else If [ Upper(Job Items::Valid Symbol) = "Tick" ] Go to Field [ Job Items::In…

Is there a way to get a script to run automatically every 10 minutes or so without user intervention? What I would like to do is have a script export a certain set of fields from all records in a particular database to a tab delineated text file every 10 minutes or so. I will then use windows scripting to import the data to a spreadsheet that is viewable and searchable on our web site. I suppose I could make my life easy and pubish the database to my web site, but my ISP does not support FileMaker DataBases and I don't want to buy FileMaker Unlimited so I can get more than 25 people accesing the data at any given time. I suppose I could also self-host....H…

I am new to Filemaker. I am the executive assistant in this Company and we use Filemaker as our database. There are several things I know you can do with Filemaker but I dont' know how to do it. 1. I want to link a scanned PDF file to a button. 2. I want to set it up to do email blasts to clients 3. I want to create a layout that will become our billing side (long and detailed need lots of help with this) it will include being able to print invoices, Envelopes and link to a master billing spreadsheet 4. I want to link our most comonnly used letters to our layout and enable us to print envelopes as well. any help would be great Thanks

I have an invoice file (table), an invoice items file and an exam file with 5 procedure fields. The exam file is related to the invoice by exam#. The invoice is related to the invoice item file by invoice#. There may be anywhere from one to five procedures per exam. I would like to create an invoice from the exam record while automatically entering each procedure as an invoice item. What is the process by which i can identify the number of procedures and enter them automatically. i thought maybe a loop checking if Procedures1-5 were empty and if not create a new invoice item setting the invoice item description = procedure.

Hi, For the sake of simplicity my problem is that I want a "forced" lookup to find a specific record in version (7). What I am trying to accomplish is to complete a find from the results of 2 pop-up lists. But I want to constrain the second pop-up list to be the results of the first. For example - the first pop up list is all the last names in the database. Once I select a last name - I would like the second list to only display the appropriate first names. I thought to have the first list force a find, figuring that the constrained find would force the second pop-up to list only the first names from the find - but I do not seem to be able to make this happen. …

Hello All: Here is another attempt at a question that I can get info on. I have a databases set up with a few portals in it. All seems to be working well with the database, but I need to move the "selected records" (with a check box selected by the user) those records to another table where they can be modified without altering the original found set. This found set will be searched over and over again, so data integrity is a big issue. Any thoughts? Thanks Lakota

I have created a field that we will use a barcode scanner to enter items (such as headphones, zip drive) that students check out for use in the lab. The barcode scanner enters a return after each scan and I have it all in an "items out" field. Clicking on a "Check Out" button commits the record. When you click on the "Check In" button a script is called that brings up a dialog box. Here, we would scan the items back in. I modified the dialog so there is no default button, otherwise the return signal from the barcode scanner would only be able to enter one item. This enters the barcodes as one continuous text value. I need to be able to break the barcodes apart and compare…

Hi, I use "open url" to open picture files, specifiying "file//: & (filepathfield)". It works perfectly for files stored in the hard drive, but it doesn't work with files that are stored in the server. What do I have to put instead "file//:" in order to open files stored in a server? Thanks a lot in advance!

I have a script in my parent file that "Goes to related record" and then runs a script in the related record that "Perform find" with constrain turned on. Here is my question: I have about 1000 records in the related file. When the script runs, it goes to "Related record" and shows 5 related records. It then runs the "Perform find" script. But even though I have set it to a constrain found set, the script still seems to be doing a find in all 1000 records. I know this because the find it is performing is on a field that can not be indexed, and it takes forever to run the find. If it was only searching within the found related 5 records, it should go pretty fast. …

Hello all, I am trying to create a button that goes to a specific layout on a related record. Can anyone help with the script (detailed....) Thank you

I need to automate the duplication of a record a fixed number of times, advancing the unique ID number only each time. The context for this is the recording of multiple copies of the same book title/object within an inventory.

I want to be able to highlight a portion of text in a field and then run a script that would change its attributes, perform other scripts and then return to the original scroll position of that field with that same text still highlighted. Any ideas?

Is there a pointer that I can access that says "END OF LIST" or some such? I want to loop over all found records. I know I can do it with a counter and checking for when the record number equals the counter but it would be easier just to check for an end of file or list or something.

I want to edit an import records process in a script. I am not certain I really understand how this works. It seems like the mapping goes away after the first time this script runs and any subsequent time I run it the mapping is lost. Is mapping permanent in a script? Can I somehow edit this part of my script to verify what is being mapped? Is it possible to do something to cause mapping to be lost?

I need to do the following type of logic: IF AAA = "XXX" AND: IF B <> "" then X = B IF C <> "" then X = C etc. ENDIF IF BBB = "XXX" AND: IF B <> "" then Y = B IF C <> "" then Y = C etc. ENDIF Is there a good way to nest IF statements? If so, please give an example of the FMP code needed. TIA

I am trying to use the 'Go to Related Record' script step with the 'show record using layout' option set to 'Layout Number by Calculation...'. My calculation is simple, and I have confirmed that it is in the correct 'context'; If ( Borrowers::Type = "Individual" ; 9 ; 8 ) But, it does not work. I always end up at the layout 8, regardless of the value of 'Borrowers::Type' If I use the Go to Layout script step and and specify the same calculation it works fine. So there is either an issue with Go to Related Record script step, or something I am doing wrong... Does anyone have any ideas on this one? Thanks

Does anyone know how (if at all) you can have a script run automatically at startup?

Hi there, I am trying to develop a company project database and i have this problem. I have a database that contains projects within each record it holds information about that project including project manager, sponsor, start date and end date etc. It also holds the documents relating to that project i.e. a project mandate (document used in meetings to define the project for approval). What i am trying to do is creat a seprate table called 'meetings'. I want to be able to link from a record about a project to the meeting that it was approved in (So the meeting table will hold meeting documents like minutes etc). I can get it to create a table that contains the minut…

I am creating a script that will pop up a new window so I can see something on another layout. I want it to leave the previous window maximized so I can go back to it after closing the new window but I can't get it to do it. I tried the following: Maximize window Freeze window New Window (smaller size) Go to layout This doesn't seem to work. This is probably something very simple but I haven't come across it yet. This is my first project in FMP 7. Thanks! John

Since yesterday all scripts cantaining the scriptstep Send Mail do not work properly anymore. (WIN98 SE) All scriptsteps are executed except Send Mail, just nothing happens, it doesn't bring up a window with a new mail. I checked the scripts, all fields in the send mail scriptstep are filled, so that's not the problem. I had the same problem one year ago. I performed a complete new installation of Windows, problem solved. Before i do that again, maybe somebody knows whether this is a registry problem (or filemaker problem) which can be solved in another way. I checked the settings in the Internet Explorer, Outlook express is my default mail-program, so that is OK. …

I have two fields (field1 and field2). I need to write a script or something that checks to see if field1 and field2 are blank at the same time. But if field1 or feild2 is filled out then it SHOULDN'T throw a red flag. But if neither of them are filled then the Red flag should show.

How do I lock a number field that has an auto enter calculation so it is un modifiable, either by user tampering or changes in the calculation after the first value is set?

Hi All, Normally, we can execute an external script of a file that has no password to open. What If I want to execute an external script of a file that has password to open , I tried it but it does not work... it says no permission or something like that. Thanks Anh Tran

Hello _ I understand that the return key cannot trigger a script but are there any keys or combinations of keys that can trigger a script at all? THanks STAN

I've been developing FM databases since v3 and have never encountered this - wondering if anyone else has seen it or has an idea what's going on. I have 2 simple scripts - one to backup a database and another to restore from the backup. The Backup works fine - no anomalies. But when I restore, the scripts that are set to show in the scripts menu disappear from the menu. The scripts still work fine if invoked by clicking on a button but are gone from the menu and their associated quickeys also fail. If I open Scriptmaker and close it, the scripts reappear and the quickeys work again also??? There are 2 files in the solution related by Customer ID. I restore the Custom…

Is it possible to add a "Ctrl" + "R" (Windows) script step to repeat the last manual find? I want to be able to repeat the last manual find. (The restore options of the Enter Find Mode and Perform Find will keep a preset find value not the last find performed.)

Is there a script for automating a Find request on a text field to find all records that match a value in another global field, which is updated from another database? Can't seem to see how a field can be specified in a Find request. Thanks!

I'm trying to overcome limitations of FM Mobile using some scripting - here goes what I want to do: 1. Run a script automatically after sync (I /think/ this is easy!) 2. Which will - find any records in a couple of fields that have been modified since last sync. (no idea how to do this!) 3. Create a new record in a different table. (not sure how to do this, must have some information from current record). 4. reset the original fields to null so I can do the same again. (easy?) 5. tell me that some records have been created when I next open the database. (haven't tried yet!) Any ideas?

Is it possible to write a script which will reset a count summary field to "1" at startup? D

I would consider myself an intermediate user/designer. What I am trying to do is beyond me and I need the code or calculation for it. I am creating a jobs table. The job number field can't be just a serial number field. We have multiple jobs per customer. What I am trying to create is a field that uses the customer number and appends a sequential job number to it separated by a hyphen. When I paste the customer number "0001" into the customer number field I want a script that will take that number, paste it into the job number field, find how many records that number occurs in and appends found number of records + 1 to that number seperated by a hyphen. …

Is there a way to format a text field that has more text than is viewable in it's original border format, to automatically expand the borders and slide existing fields and objects in the record layout onto another page if necessary? I need this so I can print the entire contents of the field.

I am using the email (Send Mail) script step attached to a button. Occasionally, the resulting email address is a "double" address, like this: <[email protected]><[email protected]> This happens irregularly. Almost always (but not every time) the problem occurs when the person's email address contains two dots as in the example above -- that is, it contains the usual dot in (dot)com plus one other. In the example above, the person's name is john(dot)smith. Or, in another case, the extra dot occurs in the company name, like this: [email protected]. Rarely, this behavior also happens with a name that doesn't hav…

Developer 5.5v1 - The main layout serves as a menu for the data file. The user chooses one of several scripts from the scripts menu. When the script is executed and it returns to the "main menu" layout the text in the layout does not display. When I switch to layout mode it is there just fine. I have tried to bring to front just in case it was somehow moved to the rear but that didn't work. I changed the font just in case there was some kind of glitch there but no change. I changed the fill color of the layout but no change there either. Any thoughts would be appreciated.

I am upgrading from FM3 to FM6 at the moment and within a few weeks to FM7. I'm using 6 as a jumping off point just to clean up some of the crap in this app I inherited. Anyway, this is a db for a hospital. The first layout is the "FIND PATIENT" layout. The search can be done by a number of fields such as last name, first name, ssn, etc Now what I need it to do is have like a check box that says "SEARCH ARCHIVES". When the box is checked then the archived (ie closed) patient files are searched as well as the active files. If the box is empty, then just the active files are searched. I'm leaning to possibly doing buttons that go to different layou…

hi...once in a whiloe when I'm testing script with a loop I'll goof and miss a step and create infinite loop, one that has no end. Is there a way to halt or exit the loop with keyboard commands? When this occurs I have to reboot the Mac to halt the loop. thanks in advance. pcourterelle

I have a application that includes 6 files. When I open one of the files I want some of the other files to be displayed and others not to be. What triggers which files are displayed and which ones are not? Thanks, Ray

Is there a keyboard shortcut to "open" the layout pop-up menu in order to view and select a particular layout?

[color:"green"] Thanks for the help! I am writing a script. I have a set of radio buttons on my layout. When I do a find within the script, I want to set a default value for the radio button (like Y/N). But I can't figure out how I would set that from a script. Any thoughts or direction on this one would be appreciated! --gloria

Okie, have recently upgraded my fm 5.5 solution to fm 7 and among some of the sillyness that i've been able to fix, I'm having trouble with this finding script. My application is intended for dual platform and will be a bound solution for ethier mac or windows. Basicly the script starts on one form where one of 4 global fields can be populated to help narrow the report down. the compile report button triggers a script in the line item file (cause it's an invoice with lineitems thing) and that script has the steps to: switch to find mode If the globals are not empty will set the respective fields to the contents of the globals (So i have 4 if's checkin…

Hi Guys, Is there a way to tell FileMaker on an opening script to look into a specific folder for a file. I have two databases in my studio one in a folder called Local and another on the network(both have exactly the same databases within the folder but different data). When a local user opens up filemaker, I want to create a shortcut that will open up my startup database from my local folder. However when a network user logs in, they will need to access only the network files. Can this be done with FM6. Cheers Jalz

Hello, I was wondering if someone can help me out. I am trying to create script that would allow me to export to wks. I want to create a button that all the user have to do is click on it and the file exported out automa. I was wondering if someone can give me some idea how to go about this. Thanks Victo r

Hi! This is my first post (but certainly not my first "That's EXACTLY what I was looking for!!"), so, hopefully, I will do it properly. Here's the situation: I have desinged a database for the school at which I teach. The main database only needs to have each student's ID number, and then relates that to a number of other databases. Obviously, the student population changes quite a few times over the course of a year - new students, students leaving, etc. The people who use the database need to have it updated about once every two weeks (they probably wouldn't mind more often, but don't like to ask, because, as of now, I have to update "manually"). They e…

Hi I was just wondering if there is any way to drag text to an empty field of some type and trigger a find based on the information being dragged there. So if I drag the word "pineapple" to a special field and dropped the text there it would cause the execution of a find script that would see if pineapple exists and bring you to the record where pineapple resides.

I have a file that, open opening, always puts up an alert saying "This script cannot be found or has been deleted." (How I wish the author of that message had been willing to reveal who or what was asking for the script, or what script it was asking for.) No scripts are defined. I've found no layout with a button that invokes any script. How else can I determine what's causing this message (and fix it!)?

this maybe a simple question but I am very bad at scripting. I leave out "," and other things that are important. So, I come to the best place for help (even better than FM support). When I enter in payments for a student, I have two fields (well more than that) the hold the month paid for and year paid for. What I was wondering if someone could help me put the coding together for it to bring up a dialog if the two fields match with a previous record. I want to try and limit double entrys. There are a lot of students so I know my code has to incorporate the relationship of itself to determine if a student has two entries. Any help would be great. thanks

I have created a relation between two files contact information and project information. Each individual project title is now in a portal on the contact file. I'd like to switch back and forth between each project/line item on the portal and the related (project)database using buttons. I used the "go to related record" command but there are multiple projects for each contact. I understand script making, but not how define which file to pull the next script set from. I would like to create a button next to the portal to open the related file (project), create a new record, copy/paste the organization name (which is my match field). I also need a button on the related (proj…

I'd like to have a user click one button and automatically recover the file. I realize that the script must be run from an external file, because the file to be recovered must not be open. I can select the damaged file of course but the problem is with the name of the recovered file: FileMaker will not allow the same name as the damaged file. So I have a script which creates a recovered file which is not the same as the original. Of course, I can instruct the user to check the byte sizes of both the original and the recovered files; if they're the same, do nothing; if they're not, copy the recovered file to the original file name. But I'd rather have FileMaker do al…

I have a text field (TextAll) containing multiple lines separated by a

Hopefully someone has discovered a more elegant solution to this problem. I have a database that makes extensive use of multiple windows. When finished, I want the user to be able to logout, closing all windows and returning to the login window. My first solution was roughly like this: Loop Exit Loop If ( ValueCount ( WindowNames ) ? 1 ) Close Window [ Substitute ( MiddleValues ( Get ( WindowNames ) ; 2 ; 1 ) "

Post deleted by mcbain1212

I'm trying to automate with a scipted button in FM so that I get the creation of a new record in a related table/layout and I'd like to have the new record get the job number from the originating table/layout. What's the best way to accomplish this in a script? I'm trying to copy the job number field in the originating record and then pasting in the the job number field in the related record, but it isn't working. Any suggestions? Thanks! Jana

Basically what I have is a Notes field, and some formatting buttons along the top. (Plain, Bold, Italic, Underline). I use one script for Bold, Italic, and Underline with the style as the script paramater. This is what it does... TextStyleAdd ( Middle ( text field ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ); Get ( ScriptParameter ) ) The problem is, If I've selected styled text (and only styled text) I can't get filemaker to remove the style from it. It does work, however, when I select the styled text and a single (or more) character(s) that is not styled. (Script paramater "AllStyles") TextStyleRemove ( Middle ( text field ; Get (…

Hi everyone. I have a portal working, global date joined to invoices on InvoiceDate. The global date field is presented above the portal (as edit box) with forward and backward buttons. Script for backward button is: Set Field [ gDate - 1]; forward is +1. I would like to always skip weekends when moving through the dates - we never ship on weekends and an empty portal looks weird. I have a startup script which sets the global to the last working day, so those invoices display when first opened, then people can enter any date they wish - or use the buttons to move. It is: Case( DayOfWeek ( Get(CurrentDate) ) = 2; Get(CurrentDate) - 3; DayOfWeek (Get(Curren…

Your thoughts on how to resolve this issue... (I am new to FM development.) I need to provide the ability to drill down within a portal. For example: This application tracks redsox players, games and performance within each game. Each is related. Player -> Games -> Performance Pedro is the player in the form view, there is a portal to the multiple Games that Pedro has participated in with the fields: Game_id #: 102 Opposing Team: Blue Jays Result: Win Graphic Button (to go to related view for additional detail) I have added a button to the line with game_id (102) and want to script the button to drill down to another form la…

I'm trying to get a script to perform 2 find requests for a date range and output the number of records it finds for the combination of those 2 finds. Doing this manually is simple but tedious, and "..." is a valid operator. Why isn't it a valid operator for a script step?? But I'm having more problems than that. I can't even get a simple "find this date in this field and give me the number of records you found" script to work. Here it is exactly: Enter Find Mode [] Set Field ["Date In Listed", "8/22/2004"] Set Field ["Amz 70K", "1"] Perform Find [] Insert Calculated Result [select, "Weekly Listings", "Status(CurrentFoundCount)"] This find doesn't e…

Hi there...I've attached a screen shot of the the script I've written to automate a find that will then take the user to a report. I need to figure out why the previous find data is remaining when I run the script, as I want the user to be able to enter fresh find data each time the script is run. It's is pausing to allow the new find data to be entered but the final report shows the old. Please help me find the simple thing I'm missing Picture1.pdf

Hi, Can anyone tell me how I can specify which layout to go when switching from one database to another? I have four main layout views that are duplicated in two different but related databases and I want to be able to specify which layout to go to when jumping back and forth between them. I'm new at this and haven't had any luck searching for an answer on my own. Thanks j

I have written a script connected to a button in an entry layout that opens a new layout in preview mode to show data organised with two leading sub-summaries. It sorts ok and gives me the display I want But as I add various navigation scripts to my original layout then test them, the script relating to preview layout does not always sort correctly giving me a preview without sub-summary information. I'm pretty sure that it relates to the Sort command in the Preview script... Am I correct and what can I do about "concreting" the sort command in the Preview script??? TIA Stephen K

I have text field in Contacts which must be unique - well not truly unique because it is case-sensitive unique. I have this text field set to Unicode for any necessary joins so it doesn't match other IDs (pa4600 shouldn't match PA4600). This is not the real ID of course but we must maintain the 'uniqueness' of this ID because this code must be entered back into a PeachTree accounting system for now. I created another TO of Contacts called 'Contacts Peach Dups' joining PeachID = PeachID. Upon new record creation in Contacts (on Contacts layout), User must enter data in three fields and then insert (make up) an ID in the field then click the button to 'continue'. Sc…

Hi, I am having problems figuring out a solution to this. I have an event database where some events have the same date. I would like to find a way to take my non-available dates, run a script, and have it set a checkbox I have labelled "available" to true on only the available dates. Sorry if this sounds confusing, as I'm a bit confused myself at the moment. I can add the dates that I am not available to the database by creating a new record for each. I've tried a few different ways to grab a hold of this problem, but it keeps slipping away from me.

After converting my FM6 solutions to FM7, the scripts in one of my database files take a long time to open or don't open at all for editing purposes. I went through and eliminated all missing field and missing file references, but still not much improvement. Any ideas as to why this script to so long to open for editing? Thanks in advance.

Hello! I have a file with three tables: First Names | Middle Initials | Last Names I am trying to output every combination of one field from each table. Specifically, formatted like so: <record> <first>John</first> <middle>A.</middle> <last>Doe</last> </record> I believe this should be done using the null relationship (X) between each table. Then, using a script that loops through each record set and inserts the result into a global field in the first table. I've also thought about using counters and a layout with two portals to do the looping. I can successfully loop throught the first name…

OK! Let me date myself. I started developing on Nantucket Clipper Summer 87. Any one remember that? I worked through CA-Clipper 5.3 on into Visual FoxPro. I then left computers for a while and now want to start again. I evaluated several software packages and decided to purchase FileMaker Pro 7.0 Developer. I have had it for a couple of weeks. I am enjoying the adventure... Now my question, I have been reading the documents, experimenting etc. but have not found any serious tutorials or references to script writing. Does anyone want to recommend a good tutorial, reference or other training that I might look at? Script writing seems to be the real power in Fil…

I know people hate frames. However, this web page that I'm working on is in frames. This is a code example in an html page of mine: <FORM ACTION="../resume/FMPro" METHOD=POST target=b> <INPUT TYPE="hidden" NAME="-DB" VALUE="coulogin.fp5"> <INPUT TYPE="hidden" NAME="-format" VALUE="resumeopt.htm"> </FORM> As you can see at the top of the code, target=b which means the web page "resumeopt.htm" will be sent to frame b. My question is: When I click on the "submit" button on the web page to submit the form and do the operation above, can I make two different web pages come up on two different fr…

Hi. I am trying to write a script that will take me from my form layout and print a report for today only. The problem is that when I use scriptmaker and enter the 'today's date' from the menu, as my specify from the print, it doesn't work. I have to manual go into find mode to get it done.... Even better, can anyone tell me how to make a script that will allow the user to enter a date at run-time for printing Vandy

Can I print out the script commands and functions on one or two sheets of paper.

I'd like to thank AndyGaunt for helping me with my empty email field worries. My next email woe is that I would like to regularly email students who have had one unexplained absence to warn them about it. I have set up a field called First absence warning sent, and I would like the script to input the current date into that field if they have not already been sent this warning, but if that field is not empty the script should just skip that record and move to the next one. I've been racking my brain trying to figure it out but I can't. The main script that I have worked out is below. I'd be grateful for any help. Perform Find [ Specified Find Requests…

Hi, I have a script that reads barcodes from the serial port. When performing the script, is there a way to choose whether to use the data coming in from the serial port to a global field and getting parsed into the record where I want it, or is there a way to use the data from a value list? How do I test the condition for using the value list instead, ie a radio button in the value list is selected and the data from this field is parsed into the record instead. Thanks for your help. Ian

Is it possible to set up some sort of a pop-up in conjunction with a create new record button? Basically , hit the button, a dialog box comes up that says "Enter your administrative password to create a new record:" The user enter a password, and hits the either the continue or cancel button. If they hit the continue button and the password they entered equals the correct word, a new record script is run and a new record is created. LR

Hi, I'm glad that FM7 now includes bcc emailing, which means that I can now use it to email our students without making their email addresses public. The only problem is that not all students have given us their email addresses, and I've found that if there are some blank email address fields the send mail script won't work. Is there some way of getting the script to ignore the blank fields? Thanks

Hi, New to FileMaker but very experienced in other DB's and am trying to help a friend here. I need to print tickets for multiple events. I have basically a customer table with name and paid amounts for each event. Very simply, assuming a ticket price of $5, if a paid amount is $20 I want to print 4 tickets for this customer/event. Each customer may have ordered 0 to "n" tickets per event. They must also print together (continuous forms) for each customer. I have made a script to loop through the records and determine how many tickets to print. But "print" is not a record level operation. It prints every visible row. It doesn't appear that it is possible to selecti…

Hello! I have a table(X) with a list of names with values. (say a = 1, b = 2, c = 3) in another table(Y) I want someone to select the name (from value list a, b or c) and I want it to look up the value from my tableX. So I've used the case calculation like so: Case ( name = "a"; tableX::a ; name = "b" ; tableX:: ; name ="c" ; tableX::c) can someone tell me where I'm going wrong? I know if I replace the "tableX::a" with a number it works but I want it to look up the field value. Thanks for your time!

i am running mac os 9.2.2 & fmp 6. i need help with

When I run this script it only paste the last thing copied to the clip board in the field (Prevs Pymt). It does paste it where the (RSRVN#) are matching. But I can't make the script copy the correct numbers from Old Data. I have tried changing all the different boxes in the relationships menu and it didn't help. Example Script New Payments & Reservations Go to Layout [ "Data" (Unearned Rent Data) ] Go to Record/Request/Page [ First ] Go to Field [ Unearned Rent Data::RSRVN# ] Loop If [ Unearned Rent Data::RSRVN# ? Old Data::RSRVN# ] Go to Record/Request/Page [ Next ] Else If [ Unearned Rent Data::RSRVN# = Old Data::RSRVN# ] …

This is a weird problem that I can't seem to get around. I don't what stage of the process is not doing it's job. Anyway - I've got a date field that is set to validate as a four digit year date, and also strict validation. This works great as to be absolutely sure what century the date is refering to. I set up a Show Custom Dialog script step, and the beforementioned date field is one of the input fields. It doesn't validate this field, so I could type in "Blah, Blah, Blah" in the input field, and it'll put that in the date field on the layout. If I click in and out of the field (on the layout) THEN the validation comes up. Is there something I'm missin…

Hi, I'm trying to figure out a way to open an external Windows application (Download.exe) from a FM solution with no luck so far. Download.exe is an existing windows application that downloads data from flash memory cards etc. I just need to find a way to open download.exe with a script. - "Open" script step seems to be working only with FM database files. Since ActiveX is completely unknown territory for me, I'm hoping there would be a simpler way to achieve this. Any help is greatly appreciated. Jari V

Hey all, I've got a fm database I use in my role as editor at a magazine. I built a db to track all my contacts with companies, as well as track and format articles that go online, or in the print mag. Our emedia Content Management System sucks, and chokes if many standard characters are present in a field when filing a story using the web interface. Generally I just screen out the trademark symbols and reg symbols (the most common offenders) by hand, but the volume of work has increased, making that harder for me to do. I made a simple script that searches for the trademark and registration symbols (using find/replace), but I'm having some trouble thinkin…

Is there a way to conditionally put items on a report? Let's say that I ask a person 5 questions and the responses are Yes, No and Maybe. I want to print a report that has the items which were NO. Table 1 -- ID, item1, item2, item3, item4, item5 Table 2 -- item_number, descriptive_text Something like if Table_1::item1 = N then print Table_2::descriptive_text where Table_2::item_number = 1; if Table_1::item2 = N then print Table_2::descriptive_text where Table_2::item_number = 2; if Table_1::item3 = N..." you get the point. I can't find any scripting that will accomplish this. Can someone lead me in th…

I'd like my front desk staff to keep track of phone calls and inquiry at the desk. I thought I would just create a field that was a serial number, and then create a button that would 'set next serial value'. But this does not work. Each day is a new record, and in this record, this value would be updated by just clicking on the button for the number of calls etc. I suppose that on creating the next days record, I would need to reset the serial number value back to 1. Can someone point me to an article or thread here that might help me? I looked for 'counter' but... Thanks!

Hi, I am trying to write a script and I'm half way there.... I three layouts... a form for the screeen, a 'printable layout', and a layout that has the list of all records. I'm tyring to create a script that will be executed from the list of records (a button on each record) and the script should take the current record, go to the printable layout, and then back to the list. The problem is that when I run it it always prints just the first record. Now I should say that in the print specs I have "print 1 of 1" but I don't really mean record one of one, but rather just the current page. If I set it to all, it'll print all 1000 + records. I don't see in the scr…

Hi LIst, After upgrading to FMP 7 one of my more complex scripts is no longer working. I'm looking to see if anyone can help me rewrite it. What I need to happen is when the script is run it need to find all orders due in the next 5 days. Simple enough, but if the cript is run on friday (or thursday for that matter) I want FMP to ignore saturday and sunday. So if activated on friday it would find fridays, monday, tues, wed and thurs orders. Below is the calculation that USED to make this happen in FMP 6. THis is the FMP 7 version though. GetAsText(Get(CurrentDate)-design information::Days Past Today) & "..." & GetAsText(Get(CurrentDate)+des…

I am trying to write a script to alert me when a person orders more then one widget so that I can combine shipping. So far I have the script written so that it sorts all the records and marks all the duplicate ship to names. What I need to do next is figure out how to have the script combine the widget name with the persons address. It is best explained by example: Record 1: widget: widget 1 Ship to name:Dan Smith Address: 555 f st City:Folsom Zip: 95855 Record 2: widget: widget 5 Ship to name:Dan Smith Address: 555 f st City:Folsom Zip: 95855 Record 3: widget: widget 3 Ship to name:Dan Smith Address: 555 f st City:Fols…

Ummm, can't figure this out. I'm writing text calculations and cant seem to get my quotes inside of the "quotes" function. For example if I wanted to add "<xml version="1.0">" to a calculation, how do i do this without filemaker thinking I am terminating the quotes at the first quote. IF it helps in a perl script you would make it "xml version=/"1.0/">" Is there a similar way to do this so FM doesn't terminate my strings prematurally??? Thanks -confessed and utter newbie

Hi All, I've just come across an odd problem. I have a script that (simplified dramatically): Loop starts at record one in the found set copy's from field Text_A paste's into field GlobalText_B (without selecting) Goto next field End loop In this way I end up with one global field containing text from every record. I need this so that I can copy and paste into a dos batch file, and exporting won't do the trick because it drops some of the characters. Anyway, the problem is, every now and again, usually somewhere around record 10 to 15 (out of 25ish), it seems as if the paste step is done but the clipboard hasn't been updated by the copy step.…

Hello. I'm also new to this forum =). I hope somebody can give me some little hints how to solve my problem. I want that I can easylie jump between my records. If I'm pressing the button "D" I want to jump to all record start with a "D.." I'm from germany so I don't knwo how you call this funktion in a normal DB. thx for help. wbr Rocco

Everyone knows the ad hoc portal needs to be on the current layout in order to have Go to Portal Row to work. What I seem to have just learnt is the option needs to be reachable on the current layout as well, not only the portal. I mean: if you use Go to Portal Row [Last] and the last row is, say, the sixth one and you have only 5 rows in the portal design, scriptmaker actually goes to row number 5 (last reachable one). Of course you may want to add a scrollbar to the portal and everything goes well. I understand the portal needs to be on the current layout (and first one in stacking order) because it is the only way you have to teach FMP what sort order you want…

I am trying to write a script to identify duplicates in a FMP6 file. The purpose of this script is massage the data so that an import using a unique sku number can happen. With multiple items with the same sku I need to make each duplicate sku serialized. For example one file has 6 items with sku 2020 but in the other fmp6 file there are 12 items with sku 2020. I need for the first file to match sku on only 6 of the items and then map over the data only to 6 of the items in the second file not all 12. It does not matter which six items of the 12 it maps over. I have the script written so that the duplicates are shown and marked and serialized but the serializa…

Well, I decided not to go with the separation model. I have a file with 26 tables which is networked. Problem is ... I'm not finished with it and need to work on it. I realize I can't work in design while it's hosted, right? So from 7am to 6pm it is unavailable. So I'm limited to evening work now. Server 7 purchase won't happen for another month. I have been downloading the file at night and uploading it every morning but I'm wondering if scripting an import into a clone would work better - so I can also work on it during the day. The file is 415mb (414mb is straight data). But with auto-enter calc keys etc, I'm nervous about the process. Has anyone done this yet?…

Hi all: I have a question regarding what FM means when they say 'Exit Script Step exits sub/external scripts and returns control to main script.' Do they conside the 'Main Script' to be whatever script is one-level outside the currently running script, or do they mean you jump back to the 'outermost' level? Here's what I mean: '---- Level #1 --------- Do Something Cool Do Something Else Cool If [something happens uncool] ...'----- Level #2 -------- ...Make it better ...Make it even better ...If [it's really better now] ......'----- Level #3 -------- ......Wow ......great ......Exit Script ************** ...End If Else ...Sorry, …

I know this has been resolved in FMP 7 but I have a FMP 6 Solution that I need to omit records in a scripted find. I can't seem to make it work. Let me explain the find...First their is a find by date range, then a number of products to be excluded, each requiring a new request. I am sure it is just sequencing in my script... Thanks!