Script Workspace and Script Triggers

I have a client database with field ClientRef (unique). We have another field that directs users to other records. ie. Instead of having duplicate/similar details in 2 records it may say See ClientRef XYZ123. The only information that the 2nd field would hold is 'XYZ123'. Is it possible to create a script that would use the XYZ123 data, and go to that specific record? Hope that makes sense!!

spell-as-you-type is enabled but with no main dictionary, why? Is there a way to enable main dictionary. I have tried to do this through the edit menu check spelling and choose dictionary. But edit dictionary is under edit is greyed out. Cannot figure out how to enable dictionary of any sort. Please help as our business is based on letter writing campaigns. Thank you.

'While you were out' messages I would like to create a messaging system for the computers in my network. They all have filemaker 5.5 installed and will soon be using them to input their timesheets. I would like to be able to make a database for all phone messages for all employees so that 1. i no longer have to waste paper 2. i can or anyone can just write a message directly to computer while talking on the phone cause the message database will always be open I have tried the boardroom program and it doesn't fit all my needs and the developer edition is too much for me... Is it possible to have a database that will be able to clearly show new records and will be a…

I want to create a script that will perform a find on a particular field. The trouble is that the find will keep changing ie. I want the script to perform a find that will show all records whose review dates are in the current month. Obviously the current month will keep changing. I don't seem to be able to locate where you can specify a particular find in the Scriptmaker section Can anyone help?? thanks

i am using the list view to display all my records in my database as it is a timesheet for employees... however, whenever i create a new record, the new record does not show up at the top of the page but rather towards the middle... is there a way to create a script to have the new record be the FIRST record at the time? When the application is opened, it is scripted to sort by date but no matter what, the new record always goes in a place not at the top or the bottom... thanks

Hi everyone. I was wondering if anyone knew how to get a touch tone phone to send instructions to a FileMaker database. I want my user to be able to ring up a hotline number and type in their UserID and Password. This would give an instruction to my FileMaker database to run a script for that user's record. Is it possible to do this? Thanks a lot for all your help! Krishan.

Hi all. Please pardon my ingnorance, but I'm brand new to filemaker. Here is my situation: I'm a physician and I bought filemaker to help me organize my patient data. My intentions are to place all relevant data in one place, and to be able to send certain pieces of information to my patients via mail (ie, summary letters from recent annual exams displaying lab results, etc, information documents with data pertaining to individual health risks, etc). So far, I have set up a basic database which includes various layouts- a general "input data" layout where name, address, vitals, lab results, etc are stored, and a few different "letters" layouts which allow me to print…

I have tried to setup a good barcode scanning system with Filemaker but it does not seem to work well. What I am trying to do is setup a retail check out station system like at a grocery store. I want the cashier to scan barcoded items in quickly without any keyboard interaction between each item. Right now when a barcode is scanned the stock number is read into the field but the cursor just sits in the same field and does not move to the next line item in my portal. The only way to get the cursor to move is to hit the TAB key on the keyboard. This slows down the check out process majorly if 100 items are being scanned. Is this possible with Filemaker? Thanks

i have a timesheet database for employees... I would like the employees to only have access to their own records and also for filemaker to only list their records and sort based on date. There are 9 employees and i have assigned each to a group and have made the appropriate passwords for them... however, i have not been able to figure out how to create a script that will find and sort based on their groupname? It is my impression that the find command performs the last find you did and you cannot set it to perform 9 different searches in one script? for instance...if i have an employee field... i would like to say... groupname is Robert and Employee field is RM the…

I'm running my FMapp on a G4 17"flatscreen aswell on an Ibook. The application is made to match the 17" screen, so when I'm running on my ibook, I have to scroll to see all the features. Is there a way to shrink everything by starting up FM on my Ibook ?

I would like a script to run every time the selection in a pop-up list is changed. This seems obvious, but I can't make a pop-up list also a button. Any ideas? (oops - not sure if it matters, but that should read "pop-up menu.") [ December 28, 2001: Message edited by: jrp ]

I am trying to create a script to move from Field 1 to Field 2 when entering Field 2 if Field 3 equals "E", otherwise jump to Field 7. I can't figure out how to do something like: If {Field 3="E", GoTo Field 2, Goto Field 7"}

I am VERY new to FM Pro, and I've recently been handed a sophistocated set of FM databases to provide maintenance for. After searching the help file, and this site, my question is this: Is it possible to determine the criteria that is being used in a FIND step within a script? I have a script that performs a SetField[] on a particular field prior to executing a search, but I don't see a way to immediately find if it's looking for <, >, or = (or combination thereof). Example: if the IDnum for a table is set to 1000, how do I know if the find is searching for all records with IDnum <1000, >1000, or equal to 1000? I know, I could execute the script, however…

We want most things are done in file maker. At the moment I am setting up a database that has letter templates. This reduces problems of importing and playing around with word. So in this letter_db I have set up one layout for one of the letter templates. But I don't want to keep doing that, I want it so the sales people can go in press a button a new letter can be created that uses the same layout as mine so they only have to just change the body text and the name at the bottom. This reduces any problems with margins, where the address details etc... and they really not that good at filemaker... so I want it easy as possiable. I have it set up that our main_db with al…

Hi! I am not sure where to post this but this looks like a good category... I have a file that is a "questionaire" type of file. I have about 100 fields but each field is on a different layout. At the end when I am error checking, if a field has been found to be left blank or filled out in error, how can I get the script to take the user back to the layout that has the correct field on it? I don't want to write a lengthy script that check each and every layout by name. I have noticed that FileMaker won't let you use variables for fields, layouts, and scripts. Each time I want to write a similar script for a layout, I have to hard code 100 + scripts. I know there m…

I've tried an external file holding serial numbers, but I'm not too comfortable with that concept. All other serial # have been converted to ###### - ####### - ###### format based on time, record number and date, but this is too long for our inventory numbers that are hand written on 1/2" tags. Is there a way to use the auto increment serial number and update it with a script on solution version update?

My problem involves Importing, Defining Fields, and Scripting but since I'm trying to fix my problem by using a script I chose to post it here. I am importing records from an excel file into FM 5.5. One column of the excel file both contains text and numbers (the numbers designating years.) What I want to do is have the information imported into the database into a field called Year, but leave out the text that is not needed (without editing the excel file.) My first idea was that possibly FM would disregard the text being imported since Year is a Number field. Didn't work. Second idea was to use the strict data entry option on Year to allow only numbers to be used.…

Hi- I'm new to the filemaker pro scene, but have been working on a database for work. Right now the dbase I've set up will work with a single user, but when more then one person tries to use it through the multi-user function the scripts don't seem to work. Does anyone have any idea why this is the case and how I might be able to fix it. Thanks in advance.

OK, one more question from me today. In a job database I have a list of jobs with different priorities and dates. I want to write a script to sort the jobs by priority, then by date, and then by time. I can get that far just fine. I'd then like the script to go down the list and assign a field in each record a numerical value representing that job's location in the queue. Any suggestions?

Hello, Could someone help me with a, for me, very big problem. Im work with a solution for travel agencys and need a itienary. From our airline reservation system Amadeus (similar to Sabre/Worldspan) I take a screenshot which is pasted into a global Filemaker field, formatted with Courier News for fixed caracter widt. What I want to do: From the global field I want cut out one line, or many lines, at a time and past them in a field for use in the application. I know how to select all, copy and past and that work perfectly but I want it automaticly with a script. Today I must go to the end of the line I want to use, mark it and let the script to the rest: cut an…

Hi everyone - merry christmas!! 1. If I had office hours of 8pm-8pm, and I needed to print out a report for the office hours business in those times, then I think I have the solution. Check if I'm wrong please. I create a field that contains a number that goes up +1 at 8pm every day and I do a search of all records based on the number I've got which would be everything with that number up until 7:59pm when it was updated +1. But, I need to know how to get the Filemaker Server, which holds all Sales in a lineage format, to process a script at 8pm which #1 Prints out all current sales with today's number and then incriments +1 for all sales there after to look up. I a…

I am trying to script a way a user could go to layout mode. FileMaker, as far as I know has no way of doing that . Does anybody out there know of a way?

Hey All! As some of you may already know, I have numerous print scripts. Each scripts searches the database for certain qualities, and omits those that don't match the criteria of the script. I have combined all of these scripts (about 34 total) into one big script that executes them all as sub-scripts. I am pretty sure that all of the scripts work if they are run independently, but I am concerned that some processes might have been left out because of how close they are executed. Should I, and how often should I include pause steps? Are there other procedures that I should perform before executing all of these subscripts? Thanks for all of your help! Ken

Hello: Vaughan was kind enough to help me with a script, but I'm having a problem with one part: Set Field ["Letters P Date 4" , "<=" & Status(CurrentDate) - 4] While in Find Mode, this should set the "Letters P Date 4" field to read "<= 12/16/01" if it were ran today, right?? Instead, it appears to be excluding the "<=" sign altogether. I put a pause script step just after this step, and manually put the sign in. It then yields the results I want. Any Ideas as to why it's not working?? Thanks alot, guys Ken

I need help with a Find script. In a DB there are "loanable" items. There is a "Date Out" field, a "Date Due" field, and "Returned" field. What I'd like to do is find items loaned during a certain period (eg. Date Out: <10/1/2001 AND Date In: empty So far I've created another field called Date Out Text which is a calculation field which = Date Out with the result as a text. This allows me to do a wildcard find (*) and select omit from that layout. The problem is, I'm trying to do this through a script. It is part of our billing system and I'd like the secretary to simply choose a radio button (1st Quarter, 2nd Quarter, etc) and have the results. Any ideas?

Just a small question, Is there a way of incrementing the day of a Date field by 1? As in the contents of 23/12/01 becoming 24/12/01? Any ideas? Thanxs Steve Griff

Should be a nice quick easy question here for someone in the know! What is the equivalent Scriptmaker script step of pressing the enter key on the keyboard? It's probably very obvious but eluding me at present!

PLEASE PLEASE help. New to FMPro and I have a DB with a field called ID01 which is the product ID. Next to it is a field called QUANTITY01, for quantity. I have hundreds of different records all with those two fields in particular. I have to find out the total quantity of each possible product ID for all records. Advice? Help? Thanks in advance.

So I've seen the examples of putting fields in portals and making fields invisible that way, but I want the fields to lock, not be invisible. I want them always to be visible, just some times editable and sometimes not. I tried using the portal as an overlay, putting the editable one on top, but because the portal isn't truley transparent there's no way to show the group underneath when the function is complete. Sorry for the confusing description, Alan

Hi guys n gals, I'm sure I've seen this question up on the Forums before but I didn't need the answer and now I do. Situation: In an orders database, before confirming an order, I input the method of payment (ie: Cheque, Cash, Credit Card, etc) for a Mail Order Shipment. I later am able to print out all Invoices 'Sign & Return with Cheque' form for people who are paying by cheque. I can print out a report of all people paying Credit card with the number, issue number, exp date to be given to someone in the company to process on a PDQ machine and then later update the system to state PAYMENT RECEIVED or DECLINED. If it is PAYMENT RECEIVED then I can do a script t…

A year ago I created a massive program with 46 related database files. Some of the files have source data only in them and the source data is tobe upgraded each year by a download from the web. One file is causing me fits. The new file is different in many ways from the one created last year but the scripts that should link the two files is the same. The old file that excutes the Preform Script will not accept the new script. I have been sure to use the same spelling, case ect. as the old file. Anyone have any ideas how I can make the old file accept the new file? Two days later... Thanks for the help. I did an import of all the scripts from the new file into …

I'm trying to write a script to set a field to the current time. It completely escapes me what function one uses to get the current time! I know there's the today function for getting the date, but I'm completely lost with the time. Help?

Hi people Another question I have a line item database that is currently in "show only related records" type mode. But the thing I want to do now is to "duplicate" those line items into another line items database using a script. (I want the script to be automatic non-interactive). Let me describe the scenario. I have two databases. One Quote database and another Order database. Each database has a "line item" database. What I want to do is when a Quote "is accepted", information of the Quote record needs to be copied into the Order database. Below is the field Names of the databases: - Quote Database Quote_ID (Needs to be exported to Order Database) Custo…

I am VERY new at FileMaker (use version 4.0 for windows). I have a database which contains the fields "FirstName" and "SpouseName" and have created two different layouts for printing mailing labels. Layout #1: <<Firstname>> and <<SpouseName>> <<LastName>> <<Address>> <<City>>, <<State>> <<ZipCode>> is designed for printing mailing labels for records which contain data in both the "FirstName" and "SpouseName" fields and contains the word "and" to seperate the two fields on the mailing label. (i.e. Linda and Randal McCurry) Layout #2: <<Firstname>> <<LastN…

quote: Originally posted by Maxer: Does anyone use fmp for school attendance? I use it for student demographics but i need to set up an attendance record for specific school days that is cumlative by day, month, quarter and year. There are a number of commercial FMP based solutions that do this type thing, including the standardized state and Federal reports. I'll see if I can find some URL's and pos them. Old Advance Man

we place orders for customers in an order database. when the products to fill the order arrive at out store, we send the order to a finance database where a shipping slip and an invoice is printed. But, the order database still has the order, but it gets marked closed. I was thinking of having the order exported to finance, and then have the script return to the order database and have the order deleted because it has been filled. I have two problems: 1. i worry if the order does not export properly, and then the order is deleted, I will have no record of it. 2. I presently do not give rights to our sales people to delete orders in the order database, so can I have t…

Is it possible to check if auto spell check is set to on. If not set, then set it to on, all through a script without the users knowledge.

Another quickie Lets say I have a field, and when you tab out of a field, a prompt (window, dialog thingy) asking are you sure you want to edit that field? Yes keeps changes, No puts field back to what it was before user started typing. Any ideas? Any ways? Is this a scriptable thingy on exittField using the plugin? Thanxs Steve

Catch my drift? Is there a quick and easy way to retrieve the first letter of each word using scriptmaker? Thanxs Steve

I have a quote record and a line item record. Since I have a portal in my quote record of the line item database I have setup my line items database to print my quote from. My question is if I'm working on quote#1000 in my quote database, how do I run an external script in the line items database that will find only the lineitems related to quote#1000. I don't see a way to pass my find criteria from the quote database to the line items database. Is there another way to do this or am I over looking something? maybe pass the number in a global variable? Thanks in advance for the help. Dave

I've got a field called DATE and another TIME - simple I've got a button that updates these two fields using script set field(DATE, Today) set field(TIME, Today) the date works perfectly the time displays 205:20:49 Why? Does anyone know? The time field is field type TIME Thanks guys/gals

The field type is date and it is also Indexed (I don't know if that matters) and repeating. Eric

I am at my wits end on this one. I have 2 files that are linked with a "constant" relationship. One file is a "holding tank" for production numbers that are being entered in the main file. When the user clicks on "submit button" in the main file some of the information needs to go to the "holding tank" file. I have a set script that sets all of the fields in the "holding" file with information from the main file. The script resides in the "holding" file and when the user clicks on the submit button in the main file it calls for the external "set" script which is Enter Browse Mode Set Error Capture (On) If (Main:Hourly production >0) (This steps checks to ma…

I discovered that when looping through a portal, which has more entries than displayed, the loop is limited to the last displayed row. Increasing the size of the portal fixes the problem. Is there a better way? I have been using Global variables to keep track of the row numbers. I set the last row number by using the 'Goto Portal Row[last]' and 'Status(CurrentPortalRow)' functions. I could try using the Count() function! Thank you. Garry

I suggest that you try the SMTPit plug-in from www.comm-unity.net It gives you full control over emailing from filemaker including specifying attachement files. You can download a demo from their website.

Hi, just wondering if it's possible to write a script to find multiple duplicate records (ie. everyone with the surname 'adam' and 'bert' and 'cat' etc.), then delete all but one of each duplicate record (ie. leave one adam, one bert, one cat ...? Of a database of 3000 records, 1500 are duplicates (argh). Any help gratefully appreciated. In the meantime, it's back to the manual ... *sigh* Cheers,

I have two files of about 35,000 names and addresses, one before two months of "updates" the other "current" but due to computer problems some names (records) were lost, and some fields within records were lost (empty), about 2,000 records lost or corrupted. I want to run a "compare" to spit out a list of the lost/corrupted records to look at and determine which were truly lost and which were legitimately deleted. Is there a way to do this in Filemaker? I work with databases a lot but am not a database expert, I have never tried this. Any advice would be appreciated. THANKS - Jackie P.

I have a script where about half-way through I have the step.. Set Field[ Different Years, Status (CurrentFileName), "Year List")] So I'm trying to set the field 'Different Years' to have every entry in the list "Year List" If there are multiple years in "Year List", my script works perfectly. However, if there is only one year, the "Set Field" step doesn't work and my field is left blank (which completly breaks the script because I use that field for some finds.) If I cancel the script, and then run that step by itself (setting the field) the single year is properly copied into my field. There are no If statements in my main script that may result in that step bein…

Hi, Am trying to script a 'Back' button that works like an internet browsers' 'Back' button for a solution I've made for a non-Techy friend. Came across a problem that stumped me. The "Go to layout" command only takes a layout number, so I can't ask it to go to a layout by name. Using a 'Go to Layout' by number is fine for a "Back" script if I'm navigating in the same file. Trouble is, the solution is currently using 12 files. If I go to another file, even though I've got the File name and the layout name along with the layout number, can't work out a way to tell FileMaker which file to go to before it goes to the layout number. Would appreciate any help that could e…

Hi, i've tried to execute this URL: "C:SCRIPTFILESCOMMUTIL.TXT 10x3 200" It won't work because of the spaces in the url. How can i solve this problem?

Hello. I need your help on something. Can you please help me on telling me how to call or execute a program external from filemaker? Help me please.

Hello I

This should be an easy one for the Gurus: I have two simple databases: DB1 is a simple call log for a tech support team. DB2 is a simple knowledge base. I need to have the option to create a new record in DB2 from some (not all) of the fields in DB1 by using a simple switch in DB1 such as "Add record to DB2: Yes/No" Any help on how I can pull this off would be greatly appreciated. Thanks, Dave www.daviator.com

I have an ORDER/INVOICE parent file which has an ORDER LINE child file. In each ORDER LINE record, a specification is made using join fields from a FRAME file and a FABRIC file ( my company makes sofa beds), and also includes quantity and price fields. When the specification of each ORDER LINE is confirmed ( or later amended ), the script(s) include a subscript which updates an audit field in the ORDER/INVOICE file. (This field logs all entries and changes made to that ORDER/INVOICE's ORDER LINES) It's a 1 line script in the ORDER LINE file: Set field (Order|Invoice rder_audit, Order|invoice rder_audit & c_order_line_summary) c_order_line_summary is a concatenat…

Here are a few ideas: 1) Create an OPTIONS file with fields pupilID, optionName, optionLetter. Make a relationship from the PUPILS file to the OPTIONS file based on pupilID. In the PUPILS file, make a portal with this relationship. Each option is a row in the portal. You could then search for French in the portal, and any PUPIL record with French as an option would be found. 2) With optionA through optionE as fields in PUPILS, make a calc field that combines the options as a return separated list. Search the calc field: options(calc,text)=optionA & "

I am trying to create a script to bring me to a different database and then to a particular layout. opening the file is no problem but then how do I get to the layout? Mark

Hello Does anybody know if somebody has made a script that converts arabic numbering to roman? (Like 231 = CCXXXI). I have a javascript that does the job but would like to implement it directly in my Filemaker Database, so that when I enter the arabic number (231) the database itself converts it to the corresponding roman number in another field. [ December 05, 2001: Message edited by: Lange ]

I recently upgraded to FM 5.0v3 from FM 3.0, and noticed a strange glitch using scripted navigation. In both versions, if I tab to a field with a single checkbox, hitting "return" once changes the state of the checkbox and I can tab to the next field. In FM 3.0, the "go to field" script step exactly duplicated this behavior, but in FM 5.0, the script step takes you to the field, then you must hit "return" twice to change the checkbox state. It's minor, but really annoying when doing a lot of Data Entry. Is there some new setting in FM 5.0 I must change to recreate the old FM 3.0 behavior? Is this a known change in functions? BTW - checking "select/perform" in the scr…

I'd need to create a button that, when clicked, prompts the (Windows) user to specify a graphic file to insert into a container field AND pick up the name of the file and paste it into a text field. I can do this on the Mac with AppleScript but I'm at a loss with Windows. I've figured out the "insert picture" part, but I don't know how to also copy the file name into a text field. Any help will be appreciated. Thanks -- J. Anderson

I need to make a search script that will take the information from one field on a layout and search all of the records and display them on a different layout. Please help.

Hi peeps, Another question. I have this dropdown list (menulist) that has a list of delivery addresses. But the thing is I want a "As above" option somewhere that allows the user to select the same address as the address invoiced to. Ideally I want the as above option to be within the dropdown list as the default option. Anyone done this type of problem before? I was wondering how did people tackle such a problem? There is probably an easy answer to this. Thanxs, Steve Griff

a way of disabling a portal? And when you uncheck the checkmark the portal becomes enabled again? Is there such a method? Or will Filemaker thwart my attempts again! Or give me a workaround Thanxs Steve Griff

It seems that there is no way to call a script in another file from a script in the active file, except via AppleScript (on a mac). Feel free to correct me. Therefore, being the AppleScript Wiz that I am not, I tried this: tell application "FileMaker Pro" tell document "Pages" do script "Update All Pages" end tell end tell When I run this run from script editor, FM bounces off the dock, I click on it and "Update All Pages" runs correctly. When, I run it from a FM script in a file related to "Pages", it gives a error: FileMaker Pro got an error, Object not found (Error -1728) Any Ideas? Thanks in Advance.

I USE FILEMAKERPRO 50. BUT I WANT TO USE A FILEMAKER FILE WITHOUT FILEMAKERPRO50? HOW CAN I? PLEASE, HELP ME...

I'm trying to script my help button to play a HELP quicktime video specific to that layout on which the user is. I guess all the videos will be in the Help Video file, but how do I get FMP to start Quicktime and play that specific video?

I have a script that has a multiple find with 4 different records in the find mode. I have a pause at the find mode screen so i can imput the date i want to find on. The problem is, i don't want to have to type in the date (or even cut and paste it) four different times, one on each find mode record. Is there a way to have a "master" pop up window asking what date I want to find and then have it maybe copy and paste the date in each of the four find records that are preset with the other criteria?

I'm trying to find all examinations for a specific patient so I did a find on patients ID #. The found set included eg. ID# 511 exams and 5119 exams and 5118 exams. How do I script an = find? current script: copy patientID go to layout patient enter find mode paste patientID (need exact match on this field) perform find The solution must be straight forward and I'm just not seeing it.

I'm having a hard time figuring out how to build a relatively complicated function that will take an invoice record, loop through the line items and create Purchase Orders for multiple Distributors. If someone might be able to point me in the right direction I would be eternally grateful! Here's the setup summarized: Invoice_records.fp3 (The line-item file that holds the invoice order detail) Peek at the Invoice_records.fp3 file: Record ID DistributorID Item# ------------------------------------------- 1234 9000 ABCDEF 1234 9000 1234556 1234 8000 GGGGG To make a long story longer... I need to loop thorough each of these records, and create 2 PO's, 1 f…

Hi peeps, Question for you all, I have this button "send e-mail" next to my e-mail field, that onClick, executes a script that sends an e-mail using the e-mail script step. But I take it just having a "to" field pointing to the e-mail field is not enough. How do I have a window poping up asking someone to enter a topic and message contents for the e-mail? (I take that an e-mail client will be used for this part). Can anyone tell me what is the "traditional" way of doing this since I find that filemaker does things the "unorthodox" way. Thanxs Steve Griff

I have a Navigation file that shows users how to get to different related files. One of the Buttons Takes the user to a messaging file. I have scripted the navigation file to show a little red light by the message file button if the user has a message for which an action is required. This script runs on opening, and I have created a small button they can push to check if there are any actionable messages (turns little red light on or off). Is there a script step that I can add that performs this function automatically, say, every hour? Thanks a bunch Shane

Hello, I have a client list that is displayed in list form. I have a couple of different sorts that allow me to change the display order. I'd like to be able to "jump" to a specified letter of the alphabet, rather than having to scroll throught the entire list. I've have created buttons that perform a find for a specifed letter, but I don't like that it destroys the sort order and omits the other records. I'd prefer to just "jump" down the currently displayed list as sorted. Any ideas...?? Thanks, Randy

Hi experts - how do I change the text in a text field once I've assigned a button function to the field? The normal double-clicking always brings up the script choices such as go to related record, etc. Certainly you don't have to delete and recreate the field to change the label. The same situation occurs whether I'm using my own field or using one of the FMP-supplied button icons. Help.

I'm trying to clean data that was imported into a general text field. The field contains sentences of text, but many records have trailing carriage returns. IE: [Text String. Text String. ] Does anyone know an efficient scripting method for removing these extra carriage returns? I have over 4000 records and would hate to have to do it manually. ) Thanks for any input you can provide! -=>Chris

I'm trying to automate deleting records from appointment database. In my script I am using copy/paste to insert the contents of a serial number field from a related database into the related field in the main database during find mode. I want to delete any records in my main database that have that same serial number. The find part works properly, but when I try to create a loop deleting all the found records, it deletes only one. Any advice would be much appreciated! This one has me tearing my hair out! Loop Enter Find Mode[] Paste [select, "serial number"] Perform Find [] Delete Record/Request [No dialoge] Go to Record/Request/Page [Exit after las…

I am confused by the export/import script step. I have a found set of records in a main FMP5 file. I need the found records to be exported/imported to another existing FMP5 file(the archive). Is there a way for me to do this without manual intervention? When I set up an import script in the archive file and put a script in the main file with the external script function, it keeps asking the user to choose a file. I need the user to click on a button and have the found record sent to another FMP file and delete the record in the main file.

I have a navigation file that shows users how to go to related files by pressing a button that executes a script that takes them to a related file. I want to ammend the script to see first if they have access to any of the layouts in the file, and then, if not, abort the script and show them a message .

Hello, first post here. I am using FileMaker 5.5v1 on Windows 2000 SP2 I have a very simple test script with the following: Pause/Resume Script[] - Set To Indefinitely Show Message["Resumed"] I have a button on an empty layout that is set to "Resume Script" My intention is when the script runs, it will pause (and it does), then I either can press the resume button I created, or I can press Enter and it should resume. However, when I press Enter, I get the following message: "Before Typing, press Tab, click in a field, or choose the New Record menu command" There is one record in this database (it is only a menu database). FileMaker Pro built-in help says: Sel…

I have a new database that I'm trying to replace data in a field from within a script. It is a very simple replace-all function, or so I thought. The message is "The previous script step, "Replace", could not be completed because it restores an invalid request. Do you wish to continue?" The command completes normally if I use the manual method or the script method with dialog. It will generate the message if I try to automate the task with no dialog. Please help . . . Chris

I have developed a solution for my sign company that all the employees like, but there is one thing that they have asked that I incorporate into this solution and I have not been able to do it so far! I have created a database where people can write letters and create faxes but Filemaker does not act like a word processor. How do you get Filemaker to do things like tabs and keep the decimal point in the same place on a document when using dollar figures? Is there any way to make Filemaker act like a word processor? I don't want to use word or some program like that because the system I have developed is all contained within Filemaker and allows me to do a global search…

I want to create my own "Find Form" to validate some fields before submitting them in the actual Find layout... After validation, I'm not sure how to transfer the user input from the fields on my form to the actual fields to find. The user could perform a find on various fields: Date, 1stName, LastName, Dept, JobTitle. Is it best to use a loop and copy/paste each field to the find layout? Is there a better way, what is the difference between Set field, Insert Calculated... and Paste?? Thanks for the help --Dan

Ok guys another dumb novice question...As I said before I am working on a db that tracks discipline for a School principal. I need to develop several reports but do not know how. My files: student,teacher,rules,punishment,referrals. The reports that I need help with are ones derived from the file referrals which contain the following fields:Referral ID,Date,Time,Student ID,Teacher ID,Punishment ID,Primary Rule,Secondary rule,Incident Description,Punish start date,Punish end date,Return Date,Punish Days,Current Date. The reports I need to generate are of the following:# of referrals by teacher, # of referrals by student, # of referrals in day,week,month and average, top r…

(This is related to my previous post on trying to fire a script upon entering a field) This was my new idea to solve the bind I'm in: I've created a script that fires after any of my 20+ fields are modified. The Script works accept this status flag: status(CurrentFieldName). I want to create if/then commands in the script that does this: If ["Status(CurrentFieldName) = "BLAH""] Set Field ["gHistory", "History"] Set Field ["History", & "gHistory & ... so and so changed BLAH from 'this' to 'that'...] Exit Script End If If ["Status(CurrentFieldName) = "JUNK""]... ... Essentially, it would page through 20+ if/thens until the status flag hits…

Here is my problem. I need to be able to enter information into a field and have my script take that information and put it into several different fields in my script. For example, I would like to be able to enter a range of dates and then run my script. The script would then take the date range and place it into several different find requests. I have got the script working except that I cannot have the script grab an entered value from a field. The only way I can get the script to work is if I enter fixed date ranges using the insert text command. Eric

I created a file for users in my office to write memos. Each time a user accesses the file, they create a new record. The problem is that often they get distracted and have to return to another file, leaving a blank record in the memos file. We want to keep a log of memos but each time I go to the log I find myself having to delete all the blank records. What's the easiest way to avoid this problem? Secondly, how can I set the print option to print current record only so that it stays there. I have a page setup command in my script but after I set it to print current record only it seems to return to print records being browsed. I know these are very basic questions. P…

ok i have this script. it loops through a portal (relationship is based on a date) and send an e-mail for each record in the relationship. the script did not run thursday and friday (this is not the problem, just that we had the days off) well when i went to go back and run it to catch up. it runs the records for friday just fine. It does not send the e-mail for the records on thursday, it does do everything else in the script though. here is the script If[ NumofPortalRows = 0 ] Exit Script End If Set Field [ gPortalNumber, 1 ] Loop If[ PatternCount(hold,Orders_:Order ID Number) < 1 ] Go to Portal Row[ gPortalNumber ] [ By Field V…

Hi all: I would like to find a set of records, then loop through the process of inserting/pasting, or otherwise setting a calculation based on various fields within the found set to a Global Field. The goal is to create a loop which will go to the end of the Global Field, then insert/paste or set the calculation based on the first record, go to the next record in the found set and repeat this until the script reaches then end of the found set. At the end of the script, I need the Global Field to be set with information from all the records in the found set, separated by returns. At the end of the loop, I will obviously have to set a finishing calculation so that the f…

hi there everyone... i have a little project that i am trying to finish. i have a field that is a date. i'm trying to create a script that will create a random date with a range of the year 2000 and 2001. the dates can be duplicated just within these years. any help would be great... thanx

I would like to write a script that will enable the user to go to a particular layout based on the current date. In other words, if the current month is November, go to the November layout, etc. Any ideas?

Does anyone know if there is a way of using this script with Macs running MS Outlook??

I have the trial version of filemaker pro 5.5 and I have a code to upgrade to the full version. However, I don`t know where to put the code in order to upgrade my software. Any idea? [ November 24, 2001: Message edited by: Gringo ]

I have a script that calls an external script in another file. When this part of the script executes the other file becomes the active window until that part of the script finishes. How do I get the entire script to happen without showing the other window? Any help would be great. I've tried using Toggle Status and Freeze window commands but they don't seem to work. Thanks chood

After updating my solution, I get a "cannot find script or script has been deleted" error, but still carries out script. I reformatted the button to play script, redid the script with same error. Only set error capture on elliminated the message. Any ideas as to why I was getting the error? script read: Copy(Select, Record#) Perform Script(subscripts, Add Payment)

I've just about finished a system to send PO's (Purchase Orders) in EDI format. After pulling the necessary info. into one field for one single PO I need to script something to export the contents of that field with the PO Number as the text file name and drop it on an FTP server to be picked up. I.e 12345.txt. I'm running FMServer 3.0 on NT4 with FM 4.1 clients on Win 98 and 2000. Any direction would be appreciated! Thanks, chood

I have a user information database and I want to set up a button activated script so that I can access all the records in a repair log database. Both databases have a field named user and I have a relationship between the two fields established. In the user info database I have a script written to open the repair log database and execute a script that searches that database for all instances of the particular user that was in the field on the user info database. When I press the button on the user info database it opens the repair log database but acts as thought there is no find criteria. I'm using filemaker pro 4.1. I'm sure its something very simple but since I'm …

Howdy. I know zippo about server stuff and I was just informed that our server is not backing up our FM5 files because they are open all the time and the backup doesn't backup files in use. All the users are on Macs. The server is Windows 2000. (Don't ask me why.) The files have to be open hosting on the server all the time as the entire company shares these files. I desperately have to avoid having someone manually close and reopen the files every day, which is the only way I can find to trigger backups with FMP instead of relying on the server. I am not here all the time, not even necessarily every week, and the official network administrator is located at a head offi…

I have been using filemaker for some time, but in a simply way. We use it for invoices and so on. I now want to automate our entire order system with filemaker. So what i have done is modify our shopping cart to send an email in comma separated text. Now before I go any farther, I was hoping someone could answer a few quick question that may seem dumb. Since I need filemaker to automatically import the email and setup all the invoice feilds from the email. I also need to compensate for orders that contain multiple products. So if someone orders one item I can import this into one feild, but can I have filemaker create duplicate feilds for each item order unlimted, so I …

Hi everybody, Is there any technique to use the Tab key to select a button script and then hit Enter key to perform that script? My email [email protected] [ November 22, 2001: Message edited by: DucNguyen ]

Hello, I'm using Send Mail script to send an email of a layout with many fileds. I am unable to send all the fields as it allows me to send only one field. Please help me on how to send all the fields as body of the email. thanks, Shalini

Is there any possibility of replacing the tab key to go from one field to another wit the enter key ??

How can I create multiple find requests in one script? I want to be able to search the same field for the lack of multiple values. I have figured out how to do it from the browse view using the find mode but I need to be able to put about 19 different find requests into one script. Also, in a script how do I search for the lack of a value? When I use the form I just click omit and enter the value into the field. However what do I type in a script to cause it to perform a find on my records and search for the lack of certain values? Thanks, Eric Nelson