Script Workspace and Script Triggers

Greetings Fellow FileMaker-ins, I was recently snooping around one of the other FileMaker forums (I know, I know, show shoot me already) and I saw a post asking the question, "Do you know of a database called Helix"? There were no responses to the query, although someone did post a link to a Helix web sight. I

Is it possible to make a link on a webpage run a script when clicked? thanks.

I have this script that checks to see if a certain value is in a text field(test field). It will run 1 of 4 scripts based on whats in the test field. Essentially the script just goes to a container and copies the contents and paste it into another container. There are 15 test fields titled MovTest1 - MovTest15, and 15 container fields for the scripts to paste in, with names that corispond to the test fields ie. Mov1 - Mov15. Here is what I have. If[Data Files::MovTest1 = "OLD" Perform Script ["OLD"] Paste[select; Data Files::Mov1] end if If[Data Files::MovTest1 = "NEW" Perform Script["NEW"] Paste[select; Data Files::Mov1] end if If[Data Files::Mov…

I'm having no success updating a script that I moved from FM6 to FM7. Previously I used AppleScript to copy and paste a QT track into a container field. Not anymore. The problem I'm having is that the Insert QuickTime command only seems to open a file locator window - rather than letting me indicate the file path from a field. So, I'm trying to do this: Insert QuickTime [clip_location] and the command won't facilitate that. Help...

Hi, I'm not sure this is the right place to ask. Please let me know if there is a preferred forum for this question. I would like to find a list of records from a table and the last_name field I would like to apply the Proper function to. The Proper function changes text from FRED to Fred is there a script around which does this? I figure I have to go through each record and then some how say Set field [ myTable::Last_Name, Proper( myTable::Last_Name) ] the thing is I don't think this Proper() function can be called unless it's part of calculation right? thanks for any tips in advance, Sincerelry, J__

Hi All, In a project i am working on, i plan to use the a UI_file (front end) linked to DATA_file (back end) via the File Reference in FMP 7. If i want to distribute my front end on many computers(let's say 6) and have them all access the data file. Is there a way to "look" for the data file automatically?? or at least open the File Reference menu if the file is not found on the local computer? What would be great is to allow the user to point to where the software was installed, have my project find the file it needs, then update the file reference so that next time the software knows to look at the new place. Hope this is clear enough... than…

Hi all, I am wondering if someone found out a way to trap the "save record" event within an FM script. What we are trying to do is to change values in another database system depending on whether the user chose to save modifications he made in a given record in FM. Using that specific layout option FM lets you prompt the user if he wants to save his modifications but up to now I did not find any way to trap that event, i. e. to branch an FM script into whether "trying to leave record after modifications made" / "leaving record unmodified". Any suggestions? Greetings from Germany Tom

Does anyone know if FM7 has any command line parameters for launching a script at startup? I know this is definable in the preferences but I'm looking to launch a database and have FM automatically do a find operation to locate a record based on a command line parameter. Example: "filemaker pro.exe" c:databasemydb.fp7 -script dofind[####] The #### portion of the above example would be a record ID to search for by the script. Once FM was launch and the database loaded, the script would be executed with the specified parameter. Anyhoo, that's my pipe dream (probably). Anyone know if it's close to being a reality? Thanks

Hi, first - i am a bloody beginner... i am trying do write a script that exports the content of the container fields of all my previously searched records. the problem to solve is, that fm asks me for every container field to give my "ok" to the chosen destination path which is "very amusing" for 120 or more container fields. is there a way to automate this process, so i have to validate the destination path just once ? thank you

I have a script that refers to Go to Layout ["Report"]. It was made for me, and I want to use it again in a different layout. How do I find the layout "Report"? It is listed in the Layout menu on the status bar, but I did not make this layout and have no idea where or how it was made, or how to copy or revise it. Is there a way to find it and edit it? 135SEATCopy.zip

To anyone who is interested, I finally figured out how to do this. Here was my original problem: <snip>I have written a script that loops through a selection of records and sends out an email (using value of global fields as subject and body). I would like to keep a record of what email was sent to whom so I created a related table (related via an auto-generated, unmodifiable number field) to hold this information. Each time an email is sent I would like to automatically create a new record in the related table and fill it with the sequence number of the current record in the loop, the current date, and the subject of the email. I would then display these recor…

I want to create a database for ebooks. I want to be able to open each book by simple pressing a button. Each book has a different type like txt, pdf, html etc. The file should open with it's own creator application. I am grateful for any idea. Thanks.

I been having some odd behavior using the Send Mail script step. Basically I have some scripts that automatically generate reports, turn them PDF files, re-name them, move them, and then email the reports as attachments to a group of manangers. This has all been working fine for a few years now. Lately however, I'm finding that Send Mail is adding the recepient name into the To: field in Outlook Express as many times as there were records found for the report. If ten records were found, the each name appears 10 times in To: or cc:. The message still only gets sent once to each recepient. It is like it does not recognize that the global field holding the email recepie…

Ok, I've scripted FMPro to print a file as a PDF, it does so and saves it onto my desktop. The name is the name of the file, ie "Sales Line Item" I want the name to automatically be my field "invoice ID#" If I could put text infront or behind that great, but the key thing is the name being the invoice number. Then I want to script it to save that file, not to my desktop but to a folder that I designate. I spent a day search different plug ins and script but have not found anything yet and beleive that FMPro can do anything. If I can't do this I might have to start using QuickBooks, UGH! Joseph

I am using FMP 6 on Win 98. I have created a student record database for our church's religious ed program and have several volunteers who have managed to enter data into backup copies instead of the original database (lost and fragmented data!). I would like to make my database file managment as fool-proof as possible. I plan on using a startup script to test if the file they are opening is the original version by testing if Status(CurrentFileName) is correct and then forcing the script to open the correct version. I would like to 'save a copy as' to a version that includes the date in the filename. Can I specify the path and filename and include the da…

Someone please help me! I made a stupid fro Filemaker to close the active window at startup which effectively closes the file. Therefore I can't even open it anymore! Is there any way to open the file without the startup script executing, or am I out of luck? Thanks, Mark

According to the help file I am able to create a button to perform as a resume buttom like that in the status area. Am I missing the step somewhere I would like to turn off (hide) the status area and be able to control scripts with buttons.

I am trying to write a script that will put a check in one value of a checkbox field. I have tried the Set Field (Orders::OrderStatus, "Paid") step and that works but it clears any other value's that have been set. Any Idea how to get around this?

I am trying to automate a script which will print a PDF for a set of records, one PDF each - like a catalog layout, one page each. I can get the Print to PDF to work, but I don;t know if Filemaker can rename the file so that the PDF does not overwrite itself each time. I would like to use a field to capture the saved PDF filename, but I am not sure if I can do this without third party or using applescript. HELP! - and thanks!

Hi. This is my first post to this site.Not sure if I'm in the correct thread for this post but here goes... I am trying to get the user to Input numeric information into 2 global fields, say Global1 & Global2, by using the Input Fields option of the ShowCustomDialog feature. Howver, the information does not seem to be saved to the fields after performing this script step. Eg. Set Field (Global1, 0) Set Field (Global2, 0) ShowCustomDialog("Enter the 2 numbers:", using Global1 & Global2 as the input fields) If I choose say 65.7 for Global1 & 33.9 for Global2 in this dialog, when I subsequently check their contents, they both stay as 0 instead of 6…

Hi, I have a button that executes a script that will bring up a dialogue box to enter a couple of search variables... then it performs the search, goes to preview mode, and prints out the report. Yeah! The problem is that what if the search yields no results? Then it continues the script going to preview mode where nothing is displayed and unfortunately the user thinks there is something wrong and they want to close it down. How do I script for errors so if the search yields no results, then i could put up another dialogue box...? Thanks Vandy

Would it be possible to implement mouse context menus in FMP7 somehow? I'm planning a machine scheduling system and would like to be able to right click on a job that's booked and have options such as "Move Forward", "Move Back", etc to reschedule/move the job around. I guess I could use a portal and put a invisible button under the record for the menu and a button/image beside that invisible one to get more indept information but it would be extremely nice to have a way to define mouse context menus.

Hi all, I have developed a small application in which I've built in a "save copy as" feature when the user exits. Is there a way to have have a script save a copy of the database as as filename+today's date? The Save copy as script step doesn't seem to allow this. I'd appreciate any help on this. Rob

Goal: click on a field (a field designated as a button) and copy its contents to the clipboard. Technique: for efficiency and simplicity, use a single script that is called by any designated field. Problem: How to pass the name of the "target" field that is clicked without hardcoding a script parameter for each and every field? The field is not actually entered so you cannot use get(ActiveFieldName), and neither the Copy nor Go To Field... scriptsteps allow you to calculate a target field anyway - the field must be hardcoded. Am I missing something obvious? Is there no way in Filemaker to just pass the name of the clicked object, such as HyperCard's "get th…

Hi All, is there a way to find out if a particular db on the fmserver is open? basically I want to do the following... if (dbtest.fp5 is OPEN on the server) then .... else msg="the db is closed for repairs"... Please Help Zeina

The only thing keeping me from activating my migration to FM-7 is the seeming inability to open remote files via script. The "Open Remote" script function doesn't offer any parameters for specifying which files to open. In addition, "Open Remote" only allows one file at a time to be opened. I have upgraded two copies of FM-6 to FM-7 but am reluctant to force my assistant to have to deal with this problem. It will ultimately get dumped in my lap. I need to find a solution. I have checked all the logical web sites and have found that this problem is discussed, but no solution is offered anywhere.

Hi, Sorry if this one is really basic but I can't figure it out... I have a calculation field that returns a date in the format mm/dd/yyyy so it might look like this 12/12/2004 or 1/3/2003 So the number of digits in the month and day vary, which isn't a problem; I want to display the year as only the last two digits though. How do I get rid of the "20" in 2004? Thanks, Andrew

Simple Question. What is a script trigger and how does it work?

How do I do a patern count for an empty field in an if statement? Here is what I have If[PatternCount (Data Files::Mov1 ; "" ) > 0 But this doesn't seem to be working. Is there another way I could represent an empty field other than ""

I am importing data into a new database from an old database. The text in some of the fields doesn't match the new database. I know I can do a Case script, and that works to a point. The problem I'm running into is sometimes the data in the specific field is not wrong, but the case script still changes it. Am I missing something. Here is what I have Case ( Data Files::Mov3 = "Old" ; "

Help! I am a bit baffled about how Filemaker handles calculations with time/duration variables. Does anyone have suggestions regarding the easiest way to these variables in caculations (or scripts)? In particular, I would like to find a way to calculate something like the following: 3:10 * 5 (that is 3 hours and 10 minutes, times 5) to yield 15:50 or (EndDate - StartDate)*(EndTime-StartTime) to get a total duration of some daily activity for the specified time Does anyone have a custom calculation or script that does something like this? Or perhaps does FileMaker have some functions I haven't found yet? (The only thing I've figured out so far…

Greeetings, I have a heck of a time printing large, complex "reports" so as a bandaid fix, I created a script to save what I want to a pdf. This is acceptable, however, it'd be great if I could get a dialog to come up that asks the user what they want to call the report. It currently saves the .pdf to their Desktop as "FileMakerPrintout.pdf" and will overwrite the last file if it is not renamed. "Printing Problems script" Print Setup Print (as pdf) [Restore, no dialog] Custom Dialog: "Your print job is on the Desktop, called "FileMakerPrintout.pdf" The PRINT command needs to be no dialog because my users will not remember to save as PDF, too many step…

For the life of me I am stumped. I want the user to press a button to add a new record to another layout. Then when completed have a choice to add another record or return to the original layout. I scripted most of it and all works, but I do not know how to loop the choice to add another record. I tried an exit loop but that did not work. Thanks all

I want to put a text value in one field and depending on that value have another value automatically fill in another field. Is this possible and if so, how? I have been trying to figure it out with scriptmaker, value list, relationships - but don't see how. Thank you.

I have a bit of an emergancy. I have a script that uses open url "mailto:.." that worked great under OS 9. We've moved to X and now the mail message is no longer decoded (I encode the ?body="..." in filemaker, replacing returns with %0D, etc) Tried it with entourage and Mail. Any thoughts? Thanks, Jeff

Hi, I'm a novice and I hope someone can help me with my troubles. I'm trying to create an applescript which downloads a file to the desktop, then opens the file and reads it into a string: ------ set the target_URL to the clipboard set the destination_file to ((path to desktop as string) & "maptemp.htm") tell application "URL Access Scripting" download target_URL to file destination_file replacing yes end tell open for access destination_file set filedata to (

Hi all, I'm quite new at FileMaker, and I've been having some trouble getting it to do something which is really simple, but which I can't figure out. I've been asked by a friend who runs a charity (a free language school for kids in Slovakia) to do a small database for him. All is OK, except he wants the kids attending this school to be attributed a separate number, which looks like this : ABCC, where A is 1 to 9, according to the year they first attended, B is either 0 or 5 (1st or 2nd semester), CC is 01 to 99 and is the individual kid's number. Don't ask me why, but he wants to keep this system, as he says it's clear to him. So 1521 means it's the 21st pers…

Hi. I need to make a script where i can find and count the number of record, where two specific values from two field in a file is used as criterion, in the query. If the number of records is > than 0 then do.... else do.. Thanks

I am about wiped out trying to figure out the easiest way to do this. Here is what I am trying to accomplish. I have a layout that is for scheduling appointments and I want to view dates that are available by viewing the schedule from todays date, on forward. I want the user to find open dates even if they are scheduled up to 6 months later. They view the schedule in a columnar report that lists dates/times. How can I setup a script to where when they click a button, that it will run the script and show all dates/times that are scheduled and not leave any out and display the results in a columnar report? Many thanks! Chris

are there any ideas out there about how to auto add a date to the beginning a note field? I'm a former MS acess user and on that platform had a "double-click" macro attached to a form field that automatically moved the field's contents down a line and auto-added the current date to the top so that new notes always appeared dated and at the top. Is there a script or some other way of doing this in FM?

I have Text field in the file. This text can content words in different Languages. My goal is to create script or calculation that sets English_Words in this text red color. Thanks advance.

When sending confirmation emails to customers, I apply Titlecase to the leftmost word in the name field, resulting (previously) in a standard-formatted first name, regardless how it was entered in my shopping cart. But about 2 weeks ago, even though I made no changes at all to my Send Mail script, Titlecase just stopped working, leaving greetings like, "Hey CHARLES" and "Dear earl". I've tried it both as a Calculated field, as well as just using the calculation option in the body text of Send Mail. As a field, it shows up properly Titlecased, but when it exports to an email, it's back in its bad formatting. The weird part is, it worked just fine for several months before …

Hi there, I want to know is there a function which can return the temp folder path? I want to use this function both in windows & mac. If not in filemaker, is there a plugin available which does this? I am using FMP6.x Thanks Hameed

Hello, How do I represent a null value in a script (e.g., null date, empty string, null time). Thank you, rlbryant

I have a relational database (currently FP6 but could move it to 7) that needs a join table that needs to be created dynamically (by a script etc). The purpose of the database is to track items that go into boxes, and boxes to be shipped to each office. Some boxes contain multiple items. Some items are split into multiple boxes. Three main tables: Offices, Items, Boxes. Two join tables (office-item and item-box) since both relationships are many-to-many. I have all of that working fine, with an office record showing what items are going to that office. I need to generate a shipment page, showing an office and what BOXES are going to that office. FP6 ha…

I have a production roll file which contains a portal to a finished roll db. from the production roll db i call a script in the finish roll db which asks for the number of finished rolls i want to create. In FM6 the script then looped through and added the appropriate number of finished rolls. In FM7 it just adds 1. when using debug, on the second time through the loop it pauses on the New Record/Request script step for a moment and then continues without adding a record. any ideas? this is driving me crazy!

I

Hi, I have just finished developing a plugin for Mac OS 9 and Mac OS X. I need someone to test the plug-in on an OS 9 box. If you would be willing to test the plug-in, I will make sure you receive a free copy of the plug-in. I am including a database with the plugin. If you would install the plug-in, and run the test script, and let me know what the information is that populates the fields in FileMaker. Please email me at [email protected] if you are willing to test this plugin. Thank you very much! In Kindness Stephen K. Knight www.fmwebschool.com 1-800-353-7950 Professional FileMaker Web Services

What would be the easiest way to import a list of FileMaker 6 field names into FM7? I need to be able to populate a field in FM7 with the field names of an open FileMaker 6 solution. This has to be XPlat Thanks!!

Hi all: I have an old FileMaker Pro 3 application, which only contains one button to link to a script: Open["OPSC.fp3(fmp1)"]. There is no detailed file location information, and I can not find "OPSC.fp3" file any where in my network. Is there any way I can get full file path from that fp3 file? Thank you so much! realdummy

Still learning Filemaker Pro 6.0 so please bear with me. I have created a script that performs a find on a Actor DB (This appears to work find). If there is no data found then i have it do the following: Show all records sort go to layout (original Layout) perform script(GoToMainMenu) exit script endif * The GoToMainMenu Script is a simple script that calls an external script (in Movie File) that takes you to the MainMenu of the Movie File * Here is where my problem lies: The best i have been able to do is get a different layout in the "Actor" file to be displayed. I am at a loss for the reason for this. I have tried mimi…

When I create a custom dialog box, I have the choice to label 3 buttons. The default is "cancel." How do I tell the script to do something different based on which button the user selects?

I have a button specified using the "Open URL" feature. The link I am using is http://xeno.ipaustralia.gov.au/tmgoods.htm if i paste that in, for some reason when I click on it to go to the page it enters in an extra / before tmgoods i.e xeno.ipaustralia.gov.au[color:"red"]//tmgoods.htm If i go in and check it it is correct (namely no extra /) and yet when I click on the button it mysteriously adds an extra / I know I could create an ugly global (i.e a superfluous field) and link to webpage, but I just want to understand if there's something I am fundamentally missing, or if it's just a bug?

To aid users of my database i am trying to create a simplified date entry system. When the user presses a button adjacent to the date field it opens a window containing the current month and all the days in it. clicking on any of the days automatically enters that date into the field. Problem being that when the calendar window opens the original window shrinks to some predefined size. I can't seem to stop it doing it. Any ideas? I know a plug-in already exists for this function, ut i'm not prepared to pay for one, and would like it customised and in the style of my current database. Plus i'd like the experince of creating my own. Anyone got any ideas?

Hello, I have a field (let's name it : usermail) and a button that when i click on it, i want it to open my email program, new mail, and put the field usermail in the To: i tried via open url and sendmail but it doesn't seem to work the way i want to. what kind of script could i use ? and how to use it? Thanks for all

Greetings, I'm trying to write a script that will export to an excel spreadsheet(accomplished) but where I'm having the problem is that I'm trying to save the file to a server location and the script keeps saving it to the local harddrive rather than the server. Any ideas hints or suggestions? Thanks, Ron

I have a Relational DB that has 5000 contacts with email addresses. I need to fiqure a way to automate the validation and USUBSCRIBE of my email addresses. Is there a way to do this all within FMP or do I have to export everything out into another program then import the addresses back into FMP? Anyone know how to do this?

Hi everyone, I am trying to create a sort script that offers options. I have a basic list view layout with sort buttons above certain fields (first name, last name, address, city etc.) Right now, I have each button sorting by that field. What I would like is to sort by the field then if another button is clicked it would sort by the new button first and the last button second. i.e. click last name it sorts by last name. then click city and it would sort by city and last name. I was trying to figure out a way using a global field and script parameters but have been unsuccessful so far. Any Ideas? thanks

Hi All, What is the fastest/most efficient way to update related records?? Let's say i change a flag (active/closed) in my "Purchase Order Header" table and i want to update the same flag in the "PO Lines" table for the speceifc PO being viewed. (Header & Lines are related on POnumber) Thanks --Dan

I import a text file that contains more records than I need. I want to make a script that will delete the records I don't need before FM performs any calculations (to speed the process); but I do not find that functionality in the script steps. My script will find the unwanted records, but I can't seem to delete them through a script, but only manually, after the Find script step; and, by this point I have waited through FM performing the calculations on the unneeded records. Any suggestions, please?

Hello...I'm new to FM and have only a rudimentary grasp of scripts, etc. Is there a way to record activities to found sets? say I have a list of clients and mail merge them a late-payment reminder -- can it be reported somewhere, automatically (and easily!), that this reminder was sent? Or say I send a press release by bulk email, can it be reported somewhere that it was sent? (by subject, client or recipient? I have tables for each.) Thanks!

I have a database that creates job numbers for my business based on the client selected. I have a script that pauses to wait for a selection of which client from a value list pop-up. The problem is that I would like the script to automatically resume once the client is selected and I can't figure out how to do it. Can anyone help

Hi, I learned yesterday (post #138056 - 12/16/04) how to test fields and then set one field "dynamically" (thank you again -Queue-, it worked like a charm). This is a related question, but I thought it would be best for it to be in a separate post... Like I said, it worked like a charm... Then I thought, "hey, this could work for another script where I also need to test fields to get the value of an specific field (by parameter)", but it didn't work. It looks like the script doesn't even "go to next field". The fields are different this time, they are calculations (even a manual "tab" doesn't go to the next field). Here's -Queue-'s code once again {with…

I am looking at a way to call a DOS batch script from within Filemaker 7. I believe that I can do this using "Send Event". However, I also want to send a variable to it from one of the fields on the layout I am using and am not sure how to do this. Any help pointing me in the right direction would be greatly appreciated. Thanks, Jeremy B

Hi all, We have a v5 database and need a script to update a field value. The field (Page_Numbers) has been entered as 10-14 for example, but we need it to list all the page numbers like this 10,11,12,13,14 Could someone suggest a script for doing this, kind of new to FM scripting so I am not too sure where to start. Thanks

Hi All, I have a starting script that uses the Set System Formats script step... It is set to OFF, which I thought would mean that I force the users into using the formats that were saved with the file & not the current computer systems formats. The problem i encounter is that when i copied my file to another machine to test this...i get a pop-up message asking me to use the file or system settings!!! What did i forget to do?? The step is the 1st line in my start-up script that runs when the file is opened. I have also included the same step in a related file in case that the pop-up message is generated from that file. thanks for your help. …

Hi, I want to avoid long "If/ElseIf...ElseIf/EndIf" sections in ScriptMaker by dynamically set a field. Please, let me explain... I have (among other fields) un-editable date fields (simply called date_01, date_02, etc.) and I don't want the users to edit these fields manually (to avoid month/day vs. day/month errors). Each date field has a "calendar" button that calls a script (with the field number as parameter). This script stores the parameter value in a dummy field then goes to a calendar layout where the user clicks on a day button (user can change year/month of course). This will trigger another script that brings him/her back to the original …

I have some recuring tasks I would like FM to manage for me. Does anyone know how I can trigger scripts based on the contents of a time/date field?

I created the script and everything worked fine with Entourage but it will not work with Mac Mail. actually, it only worked some times with Entourage. Can anyone help me trouble shoot this?

I have a REPORT table with ReportID; ReportNAME. I have a SUPPLIER table with ID; Name; etc. I have a SYSTEM table with globalRequestedReportID. When on a form: SupplierDetail based on SUPPLIER, I have a print button to print the current supplier info. Thru a series of CustomDialogues, I generate a reoprt id that is set in globalRequestedReportID. Then later in my print button script i use GoToLayout Name by calc... I use a relationship between SYSTEM::globalRequestedReportID and REPORT::ReportID to get the ReportName to use for the printing of the supplier info. AND NOW THE PROBLEM... This only seems to work for the 3rd record in my suppliers ta…

Hi Everyone - I'm relatively new to clever Filemaker scripts, and I can't seem to figure out a problem. I am making an invoice database. I need to update information in one window based on what is in another main window. I need the secondary window to figure out which customer I'm on in the main window, and lookup their invoices based on the customer info. I can manually punch numbers in, and it works fine, but I want to be able to write a script and assign it to a button in the main window. The script should pop open a new window and lookup whatever is currently open in the main window. I don't know how to "grab" a number out of a window - if someone coul…

I need a script that change the color of a rectangle made around a field box (or better the border of the field), when this field is filled. The reiterative message urging for that action becomes annoying when refers to a lot of fields. The idea is to see, when first open a form, ALL the fields whith a red rectangle, changing this rectangle to green when filled.

Hi, In a script, what's the maximum number of characters you can have in a 'set field' script step for a text field? What's the maximum number of characters you can have in text field anyway? Just wondering if I'll have to do this with more than one set field script step. I might have to set the field, then do another set field to append more content to the end of the field. And possibly again. Hopefully though I can just do it the once. Thanks Ben

This will have been asked about before, but I can not find the answer. How do I tab out of a field and automatically run a script. Tab is the only way out of the field because tab is programmed into a bar code reader. Presently a button is used to start the script, but it would be nice to have it run automatically. The layout has only the one data input (text) field and the script button on it. Any suggestions ? rex

I have a simple problem!!! I have a 4 field database (complex...ha!) student_id student_name activity activity group All I want to do...when I get to any student record is to insert a new record with student_id and student_name. I set up a script New Record/Request Go to Record/Request/Page [Previous] Insert from last record(select,"student_id") Insert from last record(select,"student_name") But when I run it it gives a new record and then deletes the student_id from the record its copying...with no student_name. I've tried different commands within each step but I can't fix it. Can someone help please Tia Step…

Techie

Hi All, I searched the forum for an answer but was not successful ( found a bad link to a plug-in). I would like to run a filemaker script early each morning to take care of some housekeeping chores. How can I set up a script to run at say 3:00am each morning?? Any assistance will be appreciated.

I have a script created to open Palm Desktop in my FM database. I would like to add to the script a way to copy the content of three fields on the current record. That way when Palm Desktop opens I can choose new appointment, then simply paste the Name, H. Phone, and W. Phone into the new appointment that was copied to the clipboard. Any help would be appreciated.

I am creating a record that needs to relate to other records. My portals do not allow creation, only viewing. I have now learned (thanks to this forum) how pass along one variable using the SET command and GET (ScriptParameter) where the GET (ScriptParameter) contains the data to enter into my new record to make it relative to my parent record. My problem is that there are more than one parents who need to have their field content dumped into the new child record. I have three variables that need to be copied and pasted into the new child record. How do I get more than one variable into the Get (scriptparameter) and then back out into three appropriate …

I'm using Filemaker Pro 7, and made a database with custom dialogs on error's etc. However, I'm sharing this database over the internet, other Mac's arround have OS 9 running, so it's not possible to have FM7 running. Is it, in some way, to generate custom dialogs in Instand Web Publishing? So, if a field is empty that should not be empty, the user will get a message after pressing the 'finished' button?? thanks for your help. greetings, Michiel

I have a script that works fine except for the feild selection that is used with the export dialog. I want it to run unattended and use the same fields everytime. I have about 200 fields in the table but I only want to output 35 or so. It is very time consuming to select them all and get them in proper order and not be able to save them in that order. script looks like: Find Export Find Export ....... Please help. Thank you in advance. Greg Hill

has anyone ever solved the problem where the send mail script sometimes places duplicate email addresses in Apple Mail's To: field? I've seen it happen in different configurations of FM and Mail and OS X. Can't seem to find a pattern. I saw an old post where it was assumed an Apple Mail bug as opposed to FM. They mentioned the issue is solved if the address was a previous recipient. Doesn't seem to hold true. I have a client now that sees some tripled emails.

I have a field that calculates a google search which I then open using the Open URL script step. Problem is... the actual URL that is posted to the browser contains and extra "/" after the ".com/" portion of the url. Very strange and frustrating. Anyone have any ideas on this one? Thanks. ~GM

Hi, I am trying to find a way to pass a parameter with a sort. In other words, lets say i have fields, "l_name", "f_name", "age". Is there a way to write a sort script that by pressing a button, can set the parameter for the key sort field? Press the button and is sorts on last name etc. I can always write 3 different sort scripts, but when it becomes like 20 different scenarios, it canget redundant. -John

First of all, you guys rock! Fast and friendly feedback on my annoying queries. Here is another design element (I do actually try to find these answers in my QUE Filemaker 7 book first) that I want to incorporate: I would like to have a date field that can accept the following and return the calculated date as a result... t = today's date +1 = tomorrow's date +7 = Next week's date etc... Any thoughts on a script to do this? Would the field still be a date field? Thanks!

Hi Everyone. I am on the verge of being an Intermediate FileMaker user but am having a problem on one simple script: I have a client database listing all of my clients. Sometimes I need to duplicate a client record depending on certain aspects of their account. Is there any way to duplicate a record using the ScriptMaker? For instance, if I had field called "copy" and, entered a value of 4, is it possible to duplicate that record four times at the touch of a button. Also, say I have 5 records that each need to be duplicated a different number of times. How can/would I accomplish this? Thanks very much for your help. Any guidance is much appreciated.

I am stumped why this isn't working. I hope someone here can help. I have 2 tables. Table 1 has a field named "Value". Table 2 has fields named "Total set value", "Value used", and "Value left". I have a simple script that checks to see if Value in table 1 + the Value used in table 2 is > than Value left in table 2. It looks like this If[(Table 1::Value + Table 2::Value used) > Table 2::Value left] Beep End If My problem is that the computer continues to think that Value + Value used is always > than Value left. Even if Value is set to 1, Value used is set to 2, and Value left is set to 100. Maybe I'm missing something. Any help given is much apprec…

I've attached a script. LineItems lists a product, then the sample is listed as 'sample' on the next line. As you will see, it doesn't show product the sample is for ... which is my job tonight. Business has no idea which products are being 'sampled' out!! If a sample was given, it's dollar and quantity was added to stock quantity and price instead and then sample line deducts the dollars back out. NetTransAmount is currently static field. Once conversion is complete and invoicing begins in new system, it will be extend using auto-enter (Replace). I need to isolate each invoice - convert any samples, damaged etc. to 'real products' and then minus the stock line …

I do a lot of scheduling. Is there a script that can be used with filemaker 6 or 7 that will automatically identify conflicts within records of date, sport, time, and facility? I need away to show a conflict exists automatically or within a short period of time.

I have a portal that shows (cannot create records in it) related records from another table. I have made a simple GTRR (Show only related records) script that is called on each line by clicking on a field. The strange thing is that no matter which record I click on (using my embedded button) I can't get it to show me the specific record from which I call the script. I get the first record that relates to my person list instead of the selected record (which could be the third etc.) Any ideas? The data is related to my person but is not the record that was selected in the portal row. Duh?

Need Help Filemaker newbie here. I have a music CD database which has the following feilds, track title, track number, and CD title. I need to add the track number to the track title. For example: Say the track name would be Punk. I need to have show as track title with the track number at the end, for example "Punk_01". The CD has a catalog number so I can seperate the tracks on a individual CD. Thank in advance

Okay Two related databases. Database1 (composed of portals to show DB2 infor and other DBs) has button script to go to Database2 and create new record. At this point the user is prompted to fill in all fields. I cannot have fields empty since it is important information. Problem is, sometimes users go to DB2 and generates new recordby accident. Can I make a script for a button to allow them to go back to DB1 and either deleting or overriding the Validation, WITHOUT giving the user ability to delete records NOR change the field validation?

My Go Back script attached to my back button is almost working as intended, thanks to everyone here who helped me. The only problem is the Layout [color:"purple"] mode . If I am on a layout in preview mode then go to a layout in browse mode, when I hit my back button, it brings me back to the appropriate layout but it stays in browse mode. I have a globallayoutmode field (Global number), inserted in the appropriate layout change scripts [color:"purple"]Set Field ["globallayoutmode", "Status(CurrentMode)"]. And here's the script attached to my back button: [color:"blue"] Go to Layout ["globallayoutnumber"] If ["globallayoutmode = 0"] Enter Browse Mod…

basically I am trying to figure out all the filemaker functions available from "outside" filemaker so I can call them from VBA or VBS In a nutshell: I want to write a vbscript to open and launch outlook from Filemaker (I am not using the sendmail function, because I create a temp field in outlook which will enable me to track the email ID and link it back to my filemaker DB) Now the problem is from my vb code, what filemaker functions are available? (without ASP since it will be running on multiple workstations where IIS is disabled) is there a get field? Thx Z

In my Company table/layout I want to have a button for "create new project" that takes you to the Projects table/layout, creates a new record and copies the corresponding fields over. So far I came up with this: Copy Record/Request Go to Layout [ "project summary" (projects) ] New Record/Request Set Field [ projects::company_name ] Paste [ ] Exit Script Hmmm it copys ALL the data into the one field - DOH! help me....thankssomuch

I am new to Filemaker Pro 7 - I was using Q & A 4.0 for Windows. On that application, when doing a report, if the text exceeded the field window, the report would expand to show all text data in that field. In Filemaker, the application seems to allow the report to close the gap between records in a report if the data does not fill the Window, but it will not expand to open the window to print the data if it exceed the window size - or will it - if it will I haven't been able to figure it out except by doing a new layout with a huge Window...not really what I want to do...any ideas..

I am new to Filemaker 7 - was using Q & A for Windows - on that application I could program the form so that when the cursor went onto the field where there was automatic data entry, it would be placed at the beginning of the field. I have been trying to do this on fielmaker without success...Any ideas...

I have a database of widget orders. The problem is that when a customer buys four widgets I get a record for each widget with the customers name, address, and widget ordered (I cannot change how I get this data). For shipping I need to combine all the widgets ordered for each customer into a field or multiple fields but into one record. Any help would be appreciated!

Hello- Here's an example fo what I want to do. Say I just mailed a letter to 800 people who are all checked as "vendor" under the roles section of the communication tab. Now I want to enter "letter sent 11/07/04" under the communications recieved area of the communications tab. How the heck do I do this? Prior to this mailing I have manually pasted the note into each record, but given this high volume there has to be a better way. Help!

Hi everyone - I'm building a customer info database with invoices. I currently have a customer info databse linked to an invoice database. The customer info databse generates a unique customer ID for each customer. When the invoice database window is open, I would like it to automatically update based on the record that is currently open in the customer info window. In essence, I'd be copying the customer ID # from its field in the customer info database, into a field in the invoice window, causing the appropriately related information to appear on the invoice. I just don't know what script commands to use to do this - please help! Thanks everyone, …