Script Workspace and Script Triggers

I have two files, "Rental contract" & "Inventory". In "Rental contract", I have a repetitive field where i can enter the serial number of a machine. I also have a (repetitive) description and a rate field that are linked to the "Inventory" file via a relationship to show the apprpriate item's information. When the contract is properly filled out, I have a Sign Out button that signs the contract out. Now, in "Inventory", I have a field called "Rental status". I want this field to reflect on the status of the machines in the contract. If the contract is signed out, the machines should be signed out as well. SO! My problem is, I can't seem to be able …

Hey there, Not sure if this should belong here (or in Define fields). Here it goes. I've searched the forums for this (but couldn't find an answer). I need to make multiple invoices per day, and it would be nice if FM could automaticaly fill in certain fields (such as Address, Phone, etc...) when it sees that the name I've put in the Name field matches a previously entered name. To do this manually, I'd issue a search on the name, then duplicate the file. This however copies the entire invoice, not just the custumer info. Any way it can be automated ? Also, any good books on FMpro you would recommend ? Thanks a lot !

Hello, How can I make a FM database automatically run a script everyone time it gets focus, moves to the forefront, or when it's opened? Thanks. EC

I frequently do 'finds' in a single file database. I find a record, make an entry, then find the next record. Occasionally I will make a mistake and realize it after I have done a 'find' for a new record. I want to be able to go back to the previous record without having to do another 'find'. I would like to be able to create a 'Back' button. Thank you for any help you can give me. Randy

Hi there, I've been looking at the posts regarding the multi-column sort scripts, and was wondering if that's what the sample databases use for sorting. In filemaker pro 5.5, using the sample "purchase order" database, there is a list view in which you can sort by clicking the column headers. However, looking at the scripts and values, there is nothing similar to what has been suggested here (using getfield). Anyone know how they work ?? Thanks !

Something odd is happening with my scripts ( FM 5.5, Windows 98). The Following works fine : Perform Script ( External:FileABC) The external script is a simple one that selects a layout. However the following doesn't work Show Message If ( Current(MessageChoice)=1 Perform Script ( External:FileABC) Exit Script EndIf Go to layout DEF With message choice 1, the script does change the layout in the ABC file, but the script continues to layout DEF in the original file. I've used this type of routine umpteen times and don't recall any problems. Should I reinstall FM ? I know the files have not been damaged as they are …

I just downloaded the "Photo Catalog" from filemakers website. It says you can specify a folder to - import images from - in a script step. When i navigate to a folder using "import records" all of the files in the folder i want to use are grayed out. I understand that if there were filemaker pro records in the folder that they would show up but i just want to import images into the database. anyone know how i can specify a folder to import images from? also it says in the not so helpful notes that in OSX you can have this database download the images directly from your camera! How on earth do you set filemaker pro 5.5 or 6.0 to do this? would really kike s…

Is there a way

I've seen a few other posts on this, but no answers yet. If anyone has stumbled on a solution, I'd appreciate learning what it is: Running FileMaker on Windows XP Pro. When I Save a Copy As ... I get an error saying "There may not be enough disk space to complete this operation. FileMaker will not be able to open the file if this operation fails. Proceed anyway?" I click Yes and it saves without a hitch. BUT, when I try to use the Save a Copy Script step, it does NOT save; even with error trapping on. I have oodles of hard drive space, memory, etc. Someone suggested bumping my cache up to twice my RAM. Did this; had no effect. I found no info at…

I would like to do a running inventory database. It would be helpful to advance the (calculated) current item's inventory balance from the "Onhand" field (x) to a balance forward field (y) that is used by the "Onhand" calculation along with credit and debit information when duplicating the record. Balance + Credit - Debit = Onhand When duplicating, I am using a script that dups, sets fields to 0 and I need to auto enter the old Onhand amount into the new Balance field. I have tried "Insert from last record" step without success. Any help.

Hi folks, I'm hoping someone out there can help a newbie. I've tried to use a FM template to help a friend with her business. It's almost done except that I can't get this one button to work In case I don't describe it well, here's what the layout looks like: http://members.cox.net/renny55/invoice.jpg I have a layout with Contractor and Client info - name, address, etc. and I want to have two buttons that will pull their info into their corresponding fields. The template button works to pull in Client info (it opens the people database so you can pick the person and then you click "use" and it sends the info back to the invoice database) and I've tried to m…

hey all first time poster here ive enjoyed reading all your solutions so maybe you could answer this for me as a new user is it true that calling an external script from the middle of a script will cause no pause from the parent script? ie i have a script like this line1 line2 run externalscript:childdb line 4 line 5 so my question is after it sets off the external script (which brings the child db to the front) does the parent script still keep running in the background? is the only way to get parent script to pause by breaking the script up into to pieces and then calling it from the child db? thanks in a…

This question relates to relationships also: For navigating through (related) files I use a script calling an external script, that goes to a layout in that external file, to switch from file to file. In some cases, the reference to the external script is deleted by Filemaker, when it can not be found I suppose. I wish FM did not.. My question is, is there a 'plan', or a system FM uses to delete those references to external files? In other words, what to do to avoid FM to 'update' the references to 'unknown'? Does it update references in a FM-file when you 'Save a copy as"? Or is it always obliged to have the related file where the script refers to, there? Hope y…

I have two databases / tables. We'll say database A and database B. Database A needs to create a new record in database B. This new record in database B must be contain information from database A. I can create a blank new record in database B from database A. But I don't know how to populate that new record with any info from database A. What should my script look like? Thank You Evan C

I know this has been addressed many times..but... I have a group of buttons each that has a date on it using <<status(currentdate)>> and the next 13 days. I guess I don't understand how to use this function or the Today function. I want these buttons to show today's date and the next 13 days. It works if you select a record that was created today. However, if I select a record that was created two days ago, the buttons change so that "today" has the date of the job two days ago... Ho do you keep these buttons so that they always show todays date, plus the next two weeks no matter which record has been selected.. On another note... If I have a …

Can i have a button appear if a field is blank .... and disappear if the field contains some thing.

It seems simple but . . . I can't get it to work I have a very simple 6 field DB (DB1) that pulls data from a relationship DB (DB2). What I am trying to do is when the job is complete a date is put in the 6th field of DB1. Then the job is complete and I need to purge the record. Here's my dilema. 1. I need to find the "completed" jobs (no problem, I scripted it) 2. Sort (no problem, same script) 3. copy the "found and sorted" records ( no problem, same script) 4. Place in "found and sorted" records in a 3rd DB (history file for stat analysis) and then return control back to DB1 to delete "found and sorted records. I realize that I could copy and then …

I have a DB running on Filemaker server. In order for a user to generate a schedule, quite a few scripts take place and it is slow. Is it better to create a loop which performs all scripts on each record or perform scripts each which has its own loop... or better yet... what is the best way to perform multiple scripts across the network... thanks

I'm working with a Domains database and an Invoices database. I need a script to locate the most recent invoice for each domain, then record the payment status (successful, declined, expired, etc.) in the Domains database. I understand Filemaker relationships pretty much, it's writing the script to find the most recent invoice that is baffling to me. This seems like it should be so simple. Shucks.

Hello, I am interested in getting a book on scripting for Filemaker and indeed also a book on Applescript ( i am a beginner ) any ideas anyone?? THank You Paul Apted

[color:"red"] As some of you have heard I had a loss in my family this week ... Her name was PC_Calendar_v2.fp5, and she died of "corruption" with 1500 plus records in her. I have had a hard time replacing her. How ever i do believe that I have found a fool proof way to prevent this from ever happening again. Here is the simple yet helpful script I am using as an "Exit Script" Save a Copy As (PC_Calendar_v2_BACKUP.fp5) As im sure all of you know filemaker doesn't really have a backup option. I just have this script set to run every time I close the database. [color:"blue"] I would like some feedback on what you think about it ... Let me know i…

hi, everyone ! i want to back up multi files to either Differerent Folder or to floppy disk or zip drive. can this be automated ? or should i manually need to copy the back up files to floppy or zip drive ? looks like i can't assign the destination path for the back up file to another folder or another drive by using " save a copy as" script step. it creates the back up files in the same folder where all my original files are. also i heard when i open my original files. sometimes back up file can be opened instead of original file by mistake ( i mean not human error but computer error ). is this true ? TIA... KYLE

I don't know if the solution is scripting, but after performing a find that generates a list of records on a different layout, I would like to be able to move to a specific record back in the original layout by mouse clicking on that specific record on the list. Help! Thanks, Scott

I need a simple and easy way to mark changed records. I have a layout with 20 or so fields on it. Any of which can be updated. I also have a "Changed" field which can be either Yes or No (obviously. I need a simple way to flag the record as changed (ready for exporting) if any of the fields have been edited. Am I missiing a very easy solution? Any advice?

I want to turn off "Allow creation of portal records" for one of my relationships. This way the user cant click in the empty portal row to create new related records. I would now like to create a button that the user can click on to create a new record in the portal. I can have the script run an external script in the related file to create a new record, but this does not show up in the protal. I guess it is because it is creating a new record in the related database file without creating the relationship. Is there a way to overcome this. Basically the relationship is based on a fields serial::serial. LR

I am making changes to my FM database ie scrips, formates. How do I transfer those change to my FM database at the office.. Using FM 6.4

Hello everyone. I was wondering if someone could point me in the right direction here. I want to be able to make dialog that the user can turn off if they want to. Here is what im trying to do. I have a button that sends the user to a layout and i want a dialog box to come up with them directions on how to return to the main layout. And i wanted to put in a like a checkbox or a something so that they can choose not to see that message in the future. Thanks for any help you can give me.

I'm in the middle of polishing up a system of 20 or so databasse that are all opened by a main menu. At menu startup, and have a script that opens all the files in the system hidden. The problem in that in every file's startup script, it goes to the default layout and zooms. This seems to cancel out the hidden part of opening, and they open in all their glory. The only way around this is to totally rewire how they open -- take out zoom and put it in a script that set the zoom and layout. Or I could risk not doing the zoom, but my layout(s) are very dependant on having the windows zoomed. Any suggestions?

I am in the process of creating a script that will delete the current record using a custom dialog box. I have searched the list of filemaker error codes, but cannot locate the code for delete record. I am looking for the code to use with the "Status(CurrentError=??)" statement to activate the custom dialog box. At this point, my script is laid out like this: If( Status(CurrentError) = ) Show Message("Are you sure you want to cancel this loan?") choices "Yes","No" If (Status(CurrentMessageChoice = 1) Delete Record/Request [No Dialog] End If Does anyone know what code I need to use?? Thanks in advance,

Has anyone SUCCESSSFULLY acheived the "Freeze Window" script step on windoze platform? I've got it working flawlessy on the Mac, it's just that pesky windoze again!

Argh, is there nobody out there that can help? I am trying to create hyperlinks between a fm6 field and pdf's. In as simple english as i can put it (i hope) here's the problem: I have a single text field which needs to contain multiple links out to pdf's These pdf's will not be the same for every record so i can define a button in the layout. i'll have users on both pc and mac so can't use OLE as i understand it. I think i need to do this using the open url script step but can someone send me an example of what it ought to look like? PLEASE help and explain in as simple terms as possible, i'm new to fma and don't understand most of the jargon. Many thanks

Hi, I'm a total newbie to filemaker, trying to learn my way through it. I have a few different tables/files/databases, whatever you want to call them. I have one layout in the 'contact' table that I would like to summarize most of the data from the other tables. I have portals assigned to the other tables, displaying the relevant information to the table all in one main layout. I have a client_master table that takes name, ssn, etc. portal, an address_master portal, and a significant other portal to try and track the client's 'significant others'. What I want to be able to do is have a button that will create a new record in one of these other files, and keep t…

I have the following problem. I have a people file with customers and one order file and one line_items. With this setup can I add one customer to one invoice, but I need to add more then one customer to the same invoice it could be 100 different customer in one invoice. For example, a hotel invoicing system: A group with a group leader called

I'm having troubles formatting a field to correctly send a mailto with a body and cc. It seems this Web-ToHTTP utility may help, but not sure where to find it? Is it a plug in?

Hi folks, The question is: How can I code for DYNAMIC movement to some field if something is true. Example: Say I have 5 global fields, in which I want to insert a value based on some criteria. There&#8217;s also a loop involved. The fields are G_1, G_2, G_3, G_4, G_5 Enter Browse Mode Sort [ Restore sort order ] Go to Record/Request/Page[ First ] Set Field [ FamilyCount, C_Family ] Loop If [A= 1 ] Set Field [ G_1, Yearof EarliestScreening ] End If Go to Record/Request/Page [ Next, Exit after last ] If [ A=1 ] Set Field [ G_2, Yearof EarliestScreening ] Else Set Field [ g…

If I have a group of tasks over a month, I want to be able to see tasks that are required for that day in the month... this I can do... However... I have a set of 20 buttons on my layout that correspond to M-F for (4) weeks. I want to be able to click on any day of any week (of the 4 weeks) and view tasks for that day. How do I dynamically update these buttons so that each 4weeks the dates reset for the porper date? thanls

Hey there FM'ers. I am trying to fill in a repeating field (MyDate repeats 10 times) with dates based on a date selecetd in a Pop-up menu. There are about 12 date values to select from in the DropDownDate pop-up menu. I have defined a script for the DropDownDate pop-up menu to do this. it is Set Field["MyDate", "Day(DropDownDate)"] Set Field["MyDate"-2, "Day(DropDownDate + 1)"] Set Field["MyDate"-3, "Day(DropDownDate + 4)"] Set Field["MyDate"-4, "Day(DropDownDate + 5 )"] Set Field["MyDate"-5, "Day(DropDownDate + 6)"] Set Field["MyDate"-6, "Day(DropDownDate + 7)"] Set Field["MyDate"-7, "Day(DropDownDate + 8)"] Set Field["MyDate"-8, "Day(DropDownDate +…

Does anyone know if there if a way of highlighting words in a text field that have been used as find criteria so that they can be easily picked out from text in the found records? I know that there are Java applets that will do this on HTML pages, but has anyone done it from Filemaker client? Regards,

merry xmas to everyone in this fantastic fm forum. most of us, at some stage, must have played (on grid sheets) the "X" & "O" game, ie whoever could continuously put all 5 X's or 5 O's in a straight line first will win the game. I used to play this so much in High School that it was like an obsession. i thought it could be a very interesting thing to do to turn this into a FM game, i'm sure that it would be possible with brains like Bob and Jason and blah blah blah...etc... if someone knows what i mean but doesnt think the post is clear enough could they please help explain & perhaps come up with potential problems... remember no pain, no gain, we all ou…

Does anyone have any documentation on how I can make a yearly calendar in filemaker?

I need to make a script which prints labels from a contact database, but the problem is some records have 2 or more contact persons per company, and a label with each of the persons has to be printed. Is there an easy way to do this? tnx, wim

Hi, I have 2 global date fields, MinDate and MaxDate, that I'd like to leave empty when my script is done. I'm using Clear [select,"MinDate"] <-- Select entire contents option is checked But they are never cleared. Trying to set them to "" doesn't work either. What am I doing wrong. Thanks for any help, Dan

The story: Mac Os, running 8.1 Filemaker 3 Two Apple Laser writer on ethernet network One old mac acting like server 3 mac's networked via ethernet The Problem: Printer A Prints on Letter head and Envelope Printer B prints related document. I would like to print all without choosing the printers manually. Scripts work Ok but I have to choose the printer manually. Is there a way to make the script to choose the printer. I have been using FMP for 9 years this is the first problem that I can not seem to resolve. Any body up to chalange. Toronto, Canada

I'm pretty new at this . . . but it seems so easy to create a button in Table A that goes to a related record in Table B, but how do I specify a particular layout in Table B? Thanks for any help you can give me, Julie

i would like to write a scipt that saves my files at the end of the day, and saved as filenameddmmyy or somethingto that effect. at the end of every month or so, i know i'd have to delete the files i'd saved as filenameddmmyy, just to empty up some disk space. the problem i'm having/afraid of having is that as i'm learning and implementing new things in fmp, i may update something and think i've got all the bugs worked out, until it's too late. i haven't done anything disastrous (yet, knock on wood), and the way i've set things up so far i've been able to reconstruct the lost/altered records one way or another. right now we have 5 or so files with 100 or so reco…

Question: Is there any way to make a copy of my database automatically with a script but also rename it with certain perameters. For Example: Let's say for each docket number I need a separate small database for mailing labels. Rather than just adding more records, I need to save a copy each time but rename it with the actual docket number. Is it possible to make it copy and rename each database without doing it manually? Any thoughts would be greatly appreciated!!

Is it possible within a filemaker script to do the following. I want to loop through a set of records for each record set a variable equal to the value of a particular field for each record So that afterwards I will have a set of say 10 variables (if there are 10 records in the found set) each one matching a value in a particular record Say for example Var1 = Feild Value from record1 Var2 = Field value from record 2 etc... In other places I would use a combination of for...next loops but how to go about it in Filemaker? Thanks John

Good morning all I am new to Filemaker. I just want to know in Browse mode . There is a question asked : Yes or No. If I type Yes then it will run the script. How can the script attach to what I type Yes or No? ...I don't want to use button to run the script ...Is there aother way to run script based on what I type or select? Thanks for your help Anh Tran

hi all, i'm pretty sure that someone must have done this before: i have a db that has 10 layouts, if a user is in layout #1 and move to #3, #4, #9, can anyone think of a way to make sure that if the user hit 'go back' button, he will be put back in #4, #3 & #1 consecutively but not #8 and #7 and #6...... in other words, it should be working just like the 'back' button in a web browser... it would be so useful for the navigation purpose, cheers...

Is this even possible...have a button for "Find." I want it so that when clicked on, the user goes to find mode, enters their criteria, and then perfoms the find. But the tricky part is this, is there any way to have that find ONLY be done on a predetermined found set that is somehow programmed into the script. Larry

I am trying to find a way to create a script that will display the range of dates in a found set. how can you do that? currently i am using a search page with 2 global fields to create a combined find for 2 dates - a (start date) and (end date).

I'm fairly new to FM, but have pretty much grasped most of the features in it. I am having one problem though. I need to write a script that when i hit a button it will bring up the Select Picture dialouge box, so I can insert the picture into a container field. The reason I need this is because I am running in KIOSK mode, and it does not allow the right click feature in the container box, or else i wouldn't care for the button script. Any help is greatly appreciated.!!

Hello everyone. I hope im asking this question in the correct section. Is there a way to limit how many records can entered into a database i have created? I want to make a demo of a solution i have made. And i thought a easy way to do that is limit them to oh lets say 5 records and no more. Can this be done? Thanks for any help you can give me. Take care. Dave W. Delphos, OH

I am fairly new to FM - I have been handed a system with many 'Print Setup[Restore,No dialog]' script steps. I wish to establish what settings were saved when the script was saved. How do I do this - all the documentation is silent on this point ?

Newbie scriptor here using "FileMaker Pro 5 Bible" to learn scripting. I have a database which has two portals, each related to a separate database. When I use "Go to Portal Row" in my script, it always go to a row in one portal. I want a script to go to a row in my second portal. The "Bible" states that this command "enables you to move to a particular row in the active portal. If a portal isn't active, the step is applied to the first portal encountered in the layout's stacking order (that is, the front-most, highest one.)" I can find no referrence to how one makes a portal "active" or "inactive" nor can I find any referrence to the layout "stacking orde…

I've just upgraded to FM6, and I am pleased to see a few modifications in the scripts realm (e.g., a resizable script window and custom dialogs), but am still deeply troubled by the fact that I can't see the stored state of the following script commands (among others): Perform Script: External Save Copy As Import Records I find it really problematic--especially when FM craps out so frequently and randomly corrupts these commands. The only way I can debug these errors is to go through one script at a time and reset the values for every one of these script steps, since I cannot trust the stored settings. Has anyone figured out a **sensible** way to view thes…

I have scripts with "set error capture on"... When I run a script there are times when there are no records to view. The script continues to run however until I manualy cancel it. I want to be able to have a "show message" step which when no records are found would let the user know.. (I thought this was done with "Status(Current Error).. but I can't sem to get it to work) thanks

I have a number field and also a collection of text fields. What is the proper function to use so that I can populate another field with the number in the number field + the number of text fields that have been filled in. ( i.e. there are 4 colors ordered on job two plus two of the special color fileds hve been filled in...so they order 6 colors)

This is probably quite easy to do, but....... Is it possible to design a script which automatically selects A4 size on a printer, regardless as to which printer a user chooses when hey print the page? Cheers Glennmc

I have just started using Filemaker Pro and Scriptmaker. I am trying to import a simple file with just 2 fields that I map to fields in FileMaker. I know that eventually I need to do data manipulation on the imported fields, but that is not my problem right now. What I am trying to do is get the manual steps in a script so that I can embellish from there. From searching on this forum I know that Filemaker's Import script step will memorize the steps for my most recent import. I set up a test script first, close Scriptmaker, then do the import manually (which works, by the way). Then I open my test script and immediately close it, but the dialog box does not allo…

Two scenarios I need clarification on: When you specify a button as "Perform Script" and set the "Current Script" to "Resume"... does it resume and complete the current script before activating the new script? And secondly, When a script is paused and you run a second script (this time from the scripts menu), what will happen to the current script? Can you have two scripts paused at once? Wouldn't that cause problems with determining which one you want to resume?

Is there a way to set a background color to field via script. I want a way to highlight fields based on values..so sometimes it would be one color other times another.. thanks

I need some layout help for a script/subsummary report.... I have 6 fields each with a popup menu that has dates for the next month (these dates correspond to tasks). I also have a calculation field that calculates total hours. Heres my issue... If I have records which have six tasks with assigned dates (some tasks have the same dates) how can I create a report which will (1) combined the dates in six different popus so that I can create a report based on a single date and inlcude records/tasks under (2) show a record in more than one date in the summary if tasks spread over multiple dates...

Goal: Import apx 2,000 Tif files into container fields of existing records. Given: Folder with 2,000 tif files named like unique_key.tif e.g. 01-19-01.tif all records already contain a field with unique code like 01-19-01 to match on. Like to hit a script and walk away while this happens if it even takes that long. Can it be done? Can you show me how? I believe we are running fm5.5 on OS X. Thanks, Barrett

I use FM Pro 5 for invoicing. I'd like to create a script that will print two copies of an invoice - one in draft mode, one in normal print mode, with one button click. Is this possible?

I now click on a button in one db to log a phone call in another db. This button click creates and new record, which contains a field called "call log." If I leave that screen/db without entering any text in the call log field, I would like to have that new record deleted automatically. How do I do this? thanks, Harry

Does anyone know a way to tell if there is a Guest connected to a database that is Hosted by FileMaker Pro(not FileMaker Server)? I know, I know...using FileMaker Server would solve this problem. But, I have a client who just won't spend the $$. I tried running a script with Error Capture On that tried to access the Define Fields, but the first thing that comes up is that FileMaker is waiting for a Guest to disconnect. Then, it doesn't return an error.

i'm having a little trouble with dates... trying to do a little script that takes a date from one field and then adds 365 (days) to that date and puts it in another field - it seams the calculation is working but the formating isn't.. (format date doesn't do it)... help...

Hi there I want to be able to control changes and keep a history of all changes to script steps. Is it possible to display script steps in a portal and update them while keeping a copy of the original steps? Michael

Does anyone know how I can get a db to close another db when it closes. I have tried putting in a script that runs on exit, with a close step but it is still leacing the child file minimised at the bottom of the application window even when the main file is completely closed. I can't see why my close step isn't working. Any help on this would be greatly appreciated. KT

Hiya guys im building a database for a client and im looking for a script that will allow me to hover my mouse over a button and a window will put up explaining what the button does, ive been told i might need a plugin for this, but im not sure. All the information you could give me would be great.

I have a number of fields that relate to the postal address of a company. But sometimes our contact at that company has a different address. So to the right I have identical fields, with slightly different field names. I occasionally use these alternate address fields, making the company address, which would be to the left, irrelevent to that contact. When I export the addresses, I would like the unique contact address, if there is one, to replace that company address in that individual record. How do I do this? In other words, "If the alternate address fields (on the right) have content, then use that content and not the regular address content (on the left)." Har…

I work with Filemaker 5 and windows. I have a script to create a new record and clicking on that script the user enters the new record data. Depending on the identification entered for this new record there is a checkbox that should be checked or not. The problem is that I have no idea how to check this checkbox because after I click the button that activates the script to create a new record there is no script after that one so that I can check the checkbox according to the identification number. This should happen automatically. Is there a way to do it either using script, or some other way ? Is there a way to activate a script by pressing the TAB key ?

I work for a college and the Student Data Database has been written in Filemaker Pro V5. All staff can access it from their User area on the network (Windows 2000) and the system is only available to staff. A member of staffs computer locks if ti has not been used within approximately 15 minutes but I would like to set up a script that will close Filemaker if it has been idle for approximately five minutes as this will ensure that no one unauthorised users have the opportunity to use the system. Any Ideas would be greatly appreciated

Hi again... I try to make a payments card, in this I created all the payments for a patient but this show diferent date cause I have a filed called (week)... But the question is I want to make all the payments at the same day number for all months i.e. If day number field is 20 all the payments will be January 20th, February 20, etc. Could you help me with this? Thanks for all .. BYE Jorge SORIANO

I have a checkbox and a 3 radio buttons. I want to create a script that depending if the checkbox is marked or not and the radio button selection a different script is run.

How do I set a default value in a popup menu through a script... One of these popup menus uses a value list from another file?

Hi, I have been trying to perform an email script that will email all the contacts in my FM database. The Problem is I have been trying to mail merge the first name and last name fileds into the message of the email. I have created a message field in the database and declared it as global. The mail merge appears in the browser mode, but does not appear in the body of the email when I send. What am I doing wrong? Is there any other way to send email with the merged fields and custom text. Thanks

Firstly let me explain my database I have a quotation database (QD), a job database(JD), a purchase order database(PO), a materials database(MD) and a products database.(PD) So basically a quotation is prepared by selecting products and/or materials in a portal from the PD and the MD. The important thing to know here is that Products are given a title and are made up of materials Example a Gizmo 2000 as a product is made up of 20 units Thingys and 18.5 Metres2 of Whatzits. These are given a cost price per products When a Quotation is accepted, it becomes a job in the JD. I have managed to successfully promote a quote to a job, but I now n…

Not sure if this is the right section, but here goes: Staff.fp5 - contains information about staff members Items.fp5 - contains information about items that can be assigned to staff members Transactions.fp5 - contains the transactions/links of items to staff members When you open Staff.fp5, you will see 4 staff members, each with an item or two assigned to them as shown through a portal. To assign an item to a staff member, you use the drop-down list from the first field in the portal. The drop-down list lists only those items in Items.fp5 that have a package type assigned to it. I want to create a script that will "assign" all items that are mar…

I have a layout which has 10 check boxes. If these check boxes are checked, I have a calculation field that summarizes these into text abbreviations (i.e. TLFBX, each which represents a task).. Why is it that if I uncheck a check box that the abbreviation field will not update.. It still lists the originally checked boxes... I need some serious help on this so that the calc filed will actualy represnt the checked boxes.. thanks

hi i have a problem doing a loop that deletes records; (btw - is there a way to copy stuff from the script dialog box!?) so the loop works fine but when deletes the record instead of going to the next record - it jumps one - i understand that the logic is that if deleted "this" one the "next" record is already there and you don't have to use the "go to the next record" command but what if i don't need the "next" record deleted but the fifth after that. like i need a loop that goes through a db and deletes only certain records - they might be consecutive records or not... i hope this explanation gives an idea of my problem...

I have a system in Filemaker 5.5 running on Windows 2000. This system has to be updated by importing a text file records that everyday is updated from the company mainframe system and is found always in the same folder. The problem is that there is an .exe application that has to be activated to get the updated text file from the mainframe and make it tab separated otherwise Filemaker won't be able to import the records. Is there a way to make Filemaker activate this exe application everyday at 7:00PM ?

Is there a way that to insert fields into a layout via script... I want to have records sorted by date so that I can see the entire week with one view then after each day within the browsed layout insert a Status(Todaysdate) +1 etc. so that the records within the browsed layout have the appropriate date above each date of sorted records... This can be in a report or preview mode if needed.. Thanks

I'm writing a script that substitutes certain words in a field for another word. i.e Substitute(Field1,"Yellow","Red") This is fine if the word is Yellow but doesn't work if it is yellow or YELLOW or any other combination of capitals and small letters. Is there a way to catch all combinations or do I need to do a SUBSTITUTE command for every combination? Regards Nick

I have 20 buttons on a layout.. each corresponds to a day of the week (m-f) for the next four weeks.. Is there a way to dynamically assign these dates autmatically to the buttons.. i.e. if on this Monday I assign the first button date and to all of the rest that the next four weeks will automatically fill in? thanks

Here is an example of scripts I use for sliding repeating fields. Adaptation of the solution given to me by Djogi for sliding portals with effect of a "Horizontal scrowlbar in Portals" (look at post with same name). Comments and corrections appreciated. Thank You

Hi, is there any way to script FM to go to a particular Portal on a layout? (The reasoning : I am initiating a script from a portal on a layout. It sets a 2nd portal to show certain records. I would like to finish the script by going to the 1st record in the 2nd Portal, but I can find no way of activating this 2nd Portal (a self) without actually physically 'clicking' on it.) As an aside... I've noticed that the 'Go To Portal' script step in FM6.x always goes to the same Portal on a layout... if there is more than one.... even if the script is activated by clicking in another... unrelated... Portal. Bug I guess. [color:"#666666"]

We have a Mac system. It has an old FM vs. 5. It also has an old program someone had written. To perform a find, the user had to select from a pop-up and the *current* User requested that I make it so that they could just type part of the Clients name in the field. So, I changed the field to calc ClientName and changed FieldFormat to a Standard field. Everything seemed fine -- clicked find button, typed name, find executed ... however, ... now, we keep getting "system out of resources" and the screen kinda just sits there and flickers It just dawned on me that maybe a script was attached to that pop-up. Could this cause an "Out of Resources" message? …

Hello, I have "Open URL" working fine, I'd like to add the parameter of target=_blank (which will open the link in a new window). I would strongly appreciate any help with this. I have checked post from 1year, but can't find anything. Paul

I am wanting to execute a script that sends an email message to email addresses in a found set of records. I can set up a loop to go to the first record, send email, next record, send email, (loop), but i can't seem to figure out how to get the loop to stop (Exit Loop if). Is there an easier way to execute the same script (sendmail) on a found set of records? thanks,

How do I incorporate a sort step in a script which will specify the sort by fields. I have three butons on the main layout. Each button sorts the same data in three different ways... thanks

I am building a database to track equipment loans to college students. I am planning on using their student ID (with a magnetic stripe) to lookup their info each time they check something out. The only problem is that the magnetic stripe is encoded with more data than just their student number. More specifically, the first 9 characters are the ID number, followed by other codes used by the university. I want to keep only the first 9 characters entered into the field by the card reader (the reader emulates typing on the keyboard - the computer doesn't know the difference). How can I tell FileMaker to remove anything after the ninth character, or to simply not al…

Hi, I want to implement code [color:"red"]93 barcode in my database. But i can's seem to find any information on it. I know it's not a font (like code 39) but a calculation...or something like that. Is there somebody that has worked with this before? tnx allready! jeff

I need help. I'm rather new to FileMaker and I'm trying to set up a program to create barcodes. So I have a set of instructions that look like this: 1. Create a script in the Code39 file that imports the data for a found set of records directly from your database. Make sure that you import the data into the same fields that you would use if you entered the data by typing. You can add additional fields to the Code39 file if needed for importing into and printing. You'll also want to set up a print labels layout in the Code 39 file and create an accompany print script. Note that you can copy a fully formatted bar code field from the Fonts lay…

I have a main DBase with a portal looking into a second DBase with multiple records sorted by a feild in that DBase called Margin, I want to make a script that enters a calculated result on the main DBase if their is a record in portal row 1 and the margin feild on this portal row is greater than 15 and Portal row 2 must also be empty. For some reason although this seems to be quite an easy script it will not work, does not seem to be able to tell when the feild is emply or valid, is this something to do with the portal, if there is no 2nd record in the portal does this mean you can not use an isempty statement?? Help!!

Currently my database has a field (number) for phone number area code and a second field for the actual phone number. I need to combine the two fields so that the entire phone number appears in one field only. Can anyone give me some hints? I intend to import data into another database for a specific user who has this requirement. Should I do this with a script or calculation? I am clueless.

We use a specific layout for finds, because in other layouts in our bespoke database the fields are non-data entry and we cannot search them. We use a find button in other layouts to take the user to our find layout and at the same time to put him in Find Mode. If a find is executed, he is returned to a regular layout for the found record(s), or of course the last record if the find was unsuccessful. My question is, does any kind person out there know how to return the user to another layout if he CANCELS Find Mode? At the moment when Find Mode is cancelled the user stays in our find layout, which has led to corruption of records because the user can inadvertently en…

If I have a collection of records.. each which has a job number is there an easy way then when a user selects the job number from a popup menu that the rest of the info will automatically fill in.. I can create the popup menu which shows all of the job numbers... however, when a user selcts the job number the rest of the related info does not fill in? Sorry for the ridiculous question...

hi all this is probably very simple but i can't figure it out.. have to update periodically 2 databases. i'm trying to do this script: "if there is no matching record in the "other" db delete this record"... any idea how to do this will be helpful thanks...