Script Workspace and Script Triggers

What could cause : Seconds( Get( CurrentTime) ) to return a "?" on either OSX or windows xp and filemaker 7?

Is any-one able to help me i am currently making a database for a restraunt and I am trying to get a price to display when I select a type of drink followed by a size both these values should correspond to give the price any help on this matter would be greatly appreciated

I am a fairly new user. I know this is a simple question, but I'm looking for an easy way to omit certain records from a layout view. I have a field called "Status" and in one layout I want to be able to automatically omit records that Status="Cancelled" or "Closed". I know I can manually do this using Find, but I'm sure there is an easy way to script this? Thanks in advance for any help.

Hi, I apologize in advance if this is repetative. I tried to add onto a string which I think was done. I need to parse out a field into different records. I have a field that is as follows: xi xi 215 226 I need to make new records for each of the values. I can figure out how to enter the first value "xi", in a new record: Left( text;Position (text ; "

I have a field of Names formatted as Last Name, First Name(s) (e.g. Williams, John) Some of these contain more than one Author and I have formatted these with an ampersand (e.g Lennon & Paul McCartney, John). I have used the Substitute function to replace the Ampersand and the Comma with the Return Character which gives me Lennon Paul McCartney John What I want to do now is somehow get the entry between the first and second return characters into a new record for some further editing so that I can then put these into a related table. Hope you can help

(The platform option is a bit spooky. Client uses NT4/Citrix - not in list.) FileA is part of a large (20 file) db. FileB is just a hanger on. FileA runs a script which finds a set of records and then calls a script in FileB which imports the found set from FileA. The FileA script then finds a subset of the previously found set (Find(Constrain set)) and repeats the call external script in FileB to import this lot of records. All fairly straightforward, I would have thought. Note that the second import might not happen (in fact usually doesn't.) So we have Import A and, maybe, Import B. After the import, no matter which is last, FileA closes. Any ideas? Pl…

I just started a new job. The data was previously maintained by a list of emails in a folder in a mail program and someone at one time had the bulk of the data in an speadsheet which has since be lost only a pdf of it is in my possession. At any rate I'm creating a db to really maintain this info. We are getting users from events so large lists of people are coming in as well as people are signing up via the web site. So while I'm keying this initial info in I'm getting live requests to add from several sources. Problem: I would like a script to help streamline this projects. Most of the time my db's are pretty simple and I can handle the scripting. But this is …

Is there a way to convert an ascii value to it respective decimal value?

Hello everyone, I need to find out if there is a way to generate a report that will be run overnight (due to the size) by customer# and month. The report will be generated from invoices, and will show what the customer ordered and in what month it was ordered. Can a print button be assigned a script to run this report once a month?

Hi, I need to do a calculation that compares two fields, and if the contents of one field are included in the other field it performs an action on them. I only know how to say if A = B exactly, not if A is part of B. What command do I use to represent a wildcard, like if A = *B*? Thanks! Andrew

hi, i was wonderin if it is possible to lock the CAPS-LOCK "on" at startup of FMP, i know there is a way of checkin if it is "On" or "Off" (getmodifierkeys or something like that) but how can i switch it "On" ?:?: Any help would be much aprecited.. Thanks

Hi, I have a script that needs to go to a specific field depending on certain criteria. I am using eventscript and the script triggers when exiting a field. I want the script to end with go to next field depending on which field triggered it. I have a global field that captures which field triggered it but I don't know how to go to that field when the script ends. Thanks in advance for any help

I have a text field and a portal. While typing in the text field, I want to click on a portal row to insert a text at the cursor's position. This is not working. AFAICT, the problem is that the button activating the script is in the portal, so the focus on the active field is lost as soon as the button is clicked. I tried to pass the cursor position to the script as script parameter, but even that seems to be too late. The same script, if called by a button NOT in the portal, is getting the parameter just fine. So how do I go about this, if at all possible?

Hi ! I have upgraded to FM7 and now I am in trouble... In older versions I made a date range find simply with Enter find mode Set field(date;Start_date...End_date) Perform find In this new version I just cannot figure out how to do it... What should I put to Find requests box. If I click "Symbol" and "..." FM only looks for "..." with no Start_date or end_date. I am sorry for this stupid question... Arttu

I have a search that ask you to put in a vin# if I put in the right number then the search performs nicely. Some of my database entries contain an "&" in their field. When someone enters the vin# they don't normally input that "&" into their find. So if they do a find without the "&" then the find returns a no match. What I am asking is their someway to make the find look for the exact match and if it can't find it then do a search for the vin# containing the "&" character? The "&" is always located as the fourth entry in the data I.E 5GZ&Z43D

hi, another complez script, i now know how you guys think so i know what info to supply! Firstly I need to display the number of turkeys left to order. I want to create a field which displays how many left their are in order to inform the user. This could be done via a script or calculation. ok where we go, First count orders where WeightNeeded is not null (or in other words filled in) from tbl_orders then compare to value GlobalTurkeysLeft. put result in box.

Would anyone know how to create a script that would uncheck a checkbox field in all records? In addition, a script that would check a checkbox field in all records? I'm using a yes/no value list checkbox as a print query field. I would like to be able to reset this field to 'unchecked' in all records after printing the selected ones. Thanks!

I have trying to set a script that when the user is sent to a layout and it is set to pause, and the user wants to cancel, he/she will be sent back to another layout. I set a script with an "if" if get (lasterror)=1 go to layout else print end if I must have some order wrong. Any help would be great. Thanks

I don't suppose there is a server-side solution that allows for the running of scripts at scheduled times? I'd rather not have to install something on every single desktop to achieve this.

Hi, I am making a solution for recipe conversion. I have a script that will convert the amounts when the number of servings is changed. The basic conversion is easy. Just a multiplying calc. The problem I have is that if a recipe calls for 4 fluid ounces for 4 servings and I convert it to 12 servings I get 12 ounces and I want it to say 1 1/2 cups. I have a script that basically tries to take into account every possible scenario and rounds off as well. I convert everything to milliliters or grams and then converts. But I am thinking there is a simpler way to do this. Any suggestions would be greatly appreciated Thank you

I am looking for a way to start a script each time a given layout is selected via the layout menu, not a button. For example, I am building a custom search layout, so I would like the page to automatically default to "Find Mode" when the visitor selects that page, and then upon exit reverts back to "Show All Records". Is this possible, and if so, can someone point me to some instruction? Thanks, Brad

I have a script that takes data from a form that the user fills out in one layout, converts the completed form into a standard block of text, then creates a new record in a different table and stores that data in the second table. The idea of this all is quick references based on ID numbers corresponding to a client between the two tables. As of right now, the data is transfered from table to table using a simple copy/paste job. I know that this can't be the best way to do this. Any suggestions?

I'm working on a database that uses LaRetta's field factory. This database keeps track of tasks that remain for each of the cabinets we build. If a task is complete, the font turns gray on one layout and disappears from another. I would like to add a third layout in table format. If this layout was a view of the disappearing tasks, it would present a grid to easily identify current status of a project. I would like to complicate this with a GO TO RELATED RECORD script and have that script activate via a transparent button. IE, I want to be able to click on any cell within that grid and go the the underlying record that supports that cell. Does …

Hi, I am working on an advanced solution for photographers. Could someone tell me if it's possible to script from Filemaker to run an action in Photoshop? I do not want to use commercial plugins, looking for some tips or an open source solution. Thanks Darren Sweet www.PictureChasers.com

Is there any way to identify scripts with a certain keyboard shortcut? I know that if you make the visible in the script menu it assigns a Cmnd-# shortcut to the script. Is there anyway to not have your scripts visible in that menu and still assign a shortcut to them?

Hi, suppose that you have a field, say it's called Amount and you are doing your own validating of the field - not using filemakers built in validation features. Your user types ? in the field. Is there a function which you can use to look at the fields to see if it's really a number/currency? Something like if [isNumber ( projects::amount ) = 1] ?? I looked through the help and did a search on this forum and I didn't see a solution. thanks for the help in advance, sincerely, J__

I have a script calling up a dialogue with several choices. When one of those choices is selected I want the script to end and another file to open. I have that step as the last step in the script ie the last lines of the script are: If status(currentmessagechoice)=2 open(filename) endif. But the script finishes itself in the original file, no matter what I do or try. Can someone help me with this?

Can somebody please help me with a (presumely) easy script: 1) Open another (second) database OR IF ALREADY OPENED, bring to front 2) switch to a certain layout in the second database instead of the last viewed... Thanks Maureen

Hi I want to make a list on every active users on a given file. The function should probably be something like: Get( ActiveAccounts) But I can't find it. I don't want to make a workaround. (Set value in field on login e.g.) The FM Server retains a list on current users. It's a similar list I'm looking for. Anyone got a clue ? ;-) Claus

Hi there, I need a script which can take into account many factors, Firstly the script is going to calculate a bill total, but its not just adding up totals it needs to firstly check the difference between two values, WeightNeeded and WeightGot. Then if the difference in weight is (weights recorded in KG) 1kg either way more than the customer needed a discount is applied. Then this repeated 5 times as the table can hold 5 orders. But I also need to make it so that it doesn't count orders which have the field Cancel? set to Yes. But it needs some kind of loop to do all 5.

Not sure if this is the right forum in which to ask this question but I have come to a grinding halt yet again after a few very satisfying recent breakthroughs.. I am trying to create a script on my simple flat database which will perform a find on membership expiry dates and publish the results in a report if the date contained in the target field is less than or equal to the current [today's date] plus 30 days. So far I have managed to get the script to work up to a point if the find is: [Licence epxiry date] less than or equal to // but this obviously only provides me with results up to the current date and previous, whereas I would ideally like to…

hi there! I basically have no idea how to create scripts but i think it is the only way to solve my problem! I have a database in which the user selects a turkey from a drop down list. But along with the ID is a weight. This weight needs to be transfered into the table which the user in using. I need a script to find the weight for that turkeyID and place it in a field in order so that i can later create reports etc. summed up: Script to find a value by a unique ID. Place value in field. Would be very grateful if anybody out there could help! run when user changes ID field.

Hello. I have a script, which I call with a script parameter, say Task_New is the name of the script. I pass the parent key into the script so I can create a new task, which will be associated with my Parent Project. (psuedo code here) Perform Script [ Task_New ; GetAsText (Projects::prj_ID) ] In my Task_New script. I set the prj_ID_FK of the tasks table to whatever the script param value is I passed in above. Like so: Set Field [ tasks::prj_ID_FK ; Get (ScriptParameter) ] as you can see above, the number passed in via the param is text (ex: "050001" Must I ? say instead of this: Set Field [ tasks::prj_ID_FK ; Get (ScriptParameter)…

How do I automate creating 1 month of records at 7 days apart from the last record in the database? Thanks,

I have an Applescript that creates a new record in a db, and invokes an FM script ("Edits") to do certain edits on the new record. It has worked fine for months. Today I created a new sub-script, ProperCaps: >> If (Exact(Status(CurrentFieldContents), Upper(Status(CurrentFieldContents))) or Exact(Status(CurrentFieldContents), Lower(Status(CurrentFieldContents))) ) >>>> Proper(Status(CurrentFieldContents)) >> End If (which simply applies the proper name capitalization function if the text is either all upper or all lower case) At the end of Edits, I added a series of steps like this: >> Go to Field["firstname"] &…

We have a script that is used to find certain clients. It goes to the find layout and pauses so that you can enter your criterea, once the criterea is entered you then click a button named find and this takes you to another layout with the results. The problem is that users commonly hit enter rather than click the find button, it there a way to disable the enter button or to have it perform the script rather than the find in it's current layout???

I have a client who is running MAC OS 9.2.2 and FMP 5.0 v3. There is a print script that sets the page to print LANDSCAPE for a particular report. I have saved the page setup options in the script and it works fine switching between landscape and portrait print outs. However, when the machine is restarted the script defaults back to portrait printing. I have recretaed the script from scratch and it still happens. THe printeer is an HP Color Laserjet 1500 and has the latest drivers from HP. Any ideas?

Attached is a solution to finding and omitting duplicate records. dupRecds.doc.zip

Hi! I am trying to use the sendmail script to send batch emails to a found set using XP, FMP7 and Netscape Mail 7.1. The script creates a new email, populates the subject line and body text, but NOT the to: line (which I want it to use the email address field from the FMP database). In the "Specify Mail" part of the script I am checking the box so that it will "Get values from every record in found set" but to no avail....I've even tried just putting in one email address as a test and it won't even bring that over to the to: field in the newly-created email. Any ideas?? Thanks! --Paul

I am after a script which denies access to a database if users log in as "Guest". In particular, I would like the script to display a dialog box telling them that they cannot login as Guests. Alternatively, is there a way of disabling the Guest button at login? Frank

In Filemaker pro 7, how would I trigger a script after the user hits return, or enter from a field ? Thanks for the help Travis I do have the eventscript plugin by softs4humans

Hello everybody, I'm trying, for a set of records to create, NEW, related ones. Briefly, I have a SHOPS file (containing 2 fields: shopID and shop name) and a second one MISSION with tasks related with those shops (having as fields missionID, shopID, product, client, aso.) My objective is to be able to create a new mission for each shop in the current found set. I activate the "make new missions" script from a layout in the Shops file which includes a portal with related fields from the mission table. My script looks like this: go to record/request/page [first] loop go to portal row [select;last] set field [mission::product; a value] set field …

Hello everybody, I'm shaking my head in the last two days with no result. It is about this example made by John Mark Osborne, made in FileMaker 3, which works well in FileMaker 5 or 6, but not in FMP 7. I don't know what I'm missing, but it seems to me that there are some scripts which are not executed till the end, even though I don't get any error. The main problem is that when saving a set or when trying to restore one it gets stuck in one layout of the saved sets file instead of returning to the main layout containing the found set. I'm sure it is a minor detail, maybe some differences in behavior of certain script steps in FMP 7, but I cannot figure it out…

I have script with a Show Custom Dialog allowing the user to change a date. The actual date being changed in the dialog is a global date field, which I will set to the final date field when the date has been validated. I have already detected if they try to enter nothing - If IsEmpty(gDate), then fail. But I don't know how to detect an invalid date. I tried inserting an If Status(CurrentError) = 500, but it doesn't trigger when it should. Any ideas?

I have a script that runs automatically every time new records are imported. It does the job well enough but is getting slower as the file size increases. It would speed things up if the script only had to loop through the records of one year. The problem is, I can

I am trying to create a script. In the attached file there are fields that list the location names and inspection dates. In some cases there are muptle dates for one location. I want to count Location Names as one inspection and show a total of all inspections. HELP 1-6-200.fp7.zip

I am fairly new to FileMaker Scripting and would like to generate a script which would search a field containing people's last names, and have the script remove any hyphens, apostrophes, spaces etc., and replace them with nothing. e.g. find "De La Cruz" and replace it with DeLaCruz, or O'neil to be replaced with Oneil. Any guidance would be appreciated.

Hello, I have a table that is really just a temporary catch all for several records. This table will usually have 1-12 records in it. Once these records are edited (by hand or script), I want to be able to, by script, copy all of the records in this table and paste them into another table (the table has the same field names). Then I would like to clear all the data/records in the temporary table. How can I do this? A person could copy all records, but there isn't an option to paste all records. Greg

Hello, I have three tables: Customer, Equipment, and JOIN_Customer_Equipment (the join table). From a layout tied to the Customer table, I have a portal to JOIN_Customer_Equipment. This portal lists some of the Equipment characteristics from the Equipment table plus a start date and an end date from the JOIN_Customer_Equipment table. I want a script to go to the JOIN_Customer_Equipment table, find all the records WITHOUT an end date listed (...aka blank). What I have is: Go to Layout ["Customer History" (Customer) Enter Find Mode [] Perform Find [Restore] Go to Layout ["Customer_History" (Customer)] The Find part omits records with "End Date = " …

Hi, I've set up a script for a user to add another record (unique) in a related db. What I want to amend the script to do is throw up a message if the field is not unique. I'm trying to use the Get(Last Error) = 11 but i suspect this is SQL only??? I know I could script a search and if result = 1 run it, but was wondering if there was an easier (shorter) way to script it??

I have a field with radio buttons from a value list, The values are 1, 2 and 3. What i want is when 2 is selected, an other field in the layout can't be empty, if 1 or 3 is selected the field is allowed to be empty. The script/Calculation has to work in the web publishing engine (browser)

Does anyone know a way to go to, or choose a field, based on a script parameter?

I'm using a "send event" step to open BBEdit then load the file in a container field. BBEdit opens fine but the file is never loaded. I checked the integrity of the container link by using the export step which successfully exports the file to where I designated. The file will also load fine into BBedit if I use an absolute file path. How do I get the container field info to load into BBedit?

I have a database holding information on advice given to cutomers and their personal details. I want to generate a script that can be run from a button that copies all of the clients details to a new record. However the client ID (number field) is auto generated in serial and i do not want the old client id to overwrite this when the copy is done.(im presuming this will happen, correct me if im wrong!) The number of fields is large so i do not want to set up individual steps for each field. Is there a way to copy the whole record except for that one field? Any help would be appreciated. Thanks

Can anyone answer this question: How do I make a FileMaker database send an email each time a new record is created (notifying a user that a new record has been submitted)?

Im trying to use a button that will open a external networked folder that contains *.pdf files ...and they numbered with records in my Filemaker DB. any hints to get me rollin'? Thanks

I know how to preform predefine finds in my scripts but I would like to find based off user input. I have a very basic customer database listing address, city, state...I would like to create a button that will pop up a dropdown list of all the states and then preform the find based on the user selection. Any help would be greatly appreciated.

I am having a problem with the following script. I only want the first occurance of duplicate records to print. Show All Records Sort Records [invfile::PartNO]Restore/No Dialog GoTo Record/Request/Page [first] Set Field [invfile::DupCalc(Global); invfile::PartNo Loop Go To REcord/Request/Page [Next, Exit after last] Set Field [invfile::DupCalc; invfile::PartNo] If [invfile::partno=invfile::Dupcalc] Omit REcord End if End Loop

Hello All, Sometimes I get stuck in conceptual boxes and I suspect this is one of them. Let's see if I can put this clearly. . . In order to simplify common searches for my fellow workers, I've created bunch of "canned" searches so all they have to do is click on a button. In doing so, I suspect I have created more repetitive and redundant scripting than I need to. Let's say I am searching on two fields: a letter and a number. Each script contains a "perform find" script step that checks three different letter fields (letter1, letter2, letter3) and a single number field (number). Here are the perform find steps for the first 6 buttons: BUTTON # / ACTI…

Hello, I was wondeirng if someone can help me out. I want to verify that email addresses are correct using script before i send the email. Right now i am trying to send email newsletter and the people who input the email address sometime mis-type something or add extra space when there shouldnt be any. i am using fm 6 on the mac. thanks victor

Hi everybody! I'm an university student and not very expert of filemaker unfortunately but I have to help my dad solving a problem and I'm not able to do it... We just upgraded from filemaker 4 pro to filemaker 7 pro (a big jump I know) in a small office (one mac and 2 pc). Now everything is fine (or better fixed ) except one problem with multiple fields very annoying. there's a table with code as primary key, some others single fields and some multiple fields... Now working with it gives no problem, but we have to import its record from another table! The problem is that filemaker pro 7 (4 were working "fine") import records, but put just once the si…

I have two files, WTLB & MediaOffers. WTLB contains scripts from a program that we produce and contains programs for the past 3 years. MediaOffers is supposed to contain only 1 years worth of WTLB programs. When I run my import script it is importing all the WTLB records into MediaOffers. Here is my script: Enter Find Insert Text (MediaOffers:Program;WTLB) Perform Find Delete All Records --I am wiping all WTLB records and reloading the entire year Perform Script ("FindRecordsForImport from File:WTLB") Enter Browse Mode Import Records (No Dialog;"WTLB") Do I need to add an open file script step to open the WTLB DB before I do the first per…

I have seen several posts on this topic but none that really resolve the problem. Using FMP7 (v3) under Windows XP I am unable to select a printer via 'Print Setup' or 'Print' script steps. I have tried various plug-ins that elude to resolve this problem and have even written an application that switches the System Default Printer on the fly (via a SEND statement). Alas, nothing seems to work in a solid way and I still find my Databases cannot reliably print to one printer (such as a networked laser) and then switch to a PDF printer for example. I have tried breaking this down in to seperate scripts to keep each Print config apart but this also fails. …

I have a script added as a picture to this post. It works 100% when I'm logged in as normal but when I log in as a guest it doesn't work (everything else works). I changed the guest account so that it had full access to everything, but the script still didn't work. It's something with the paste (klistra in) that doesn't work, it pastes the old values instead of the new ones. Has anyone experienced the same thing? // G

yes, we are still on FMP6. No, they wont pay for the 200 client update for at least another year. Sigh. Anyway... I have a little solution put together that tracks responses to post seminar evaluation forms (How useful was this class [1] [2] [3] [4] [5])... exciting stuff... anyway, my big weakness is figuring out how to export a summarized report out to a text or Word file for "The Powers That Be

Searched the forums for this to no avail. I'm upgrading from 6 to 7. One annoying "feature" in 7 is that the Go to Related Record step no longer displays a found set of 0 if there are no related records. This has completely screwed up several of my scripts that rely on a found set of 0 in order to dertermine if a new related record should be created. In 7, if there are no related records, the script step simply takes you to the related layout and shows whatever found set was there previously. Egads. Any ideas on a workaround? Thanks.

I have a file that has duplicate part No's and I would like to print out a list showing only the first occurance of a Part No. I have tried a couple of scripts using omit but just can't get it to work. Need some help. TIA Ivan

I want to export all data using a script once a week. I want to use a differant filename each week. An embedded Date or a sequencial number would work. Is there a way to automatically use a differant filename in the export feature in a script? I could use a DOS batch file and call it up from Filemaker. I would like to do it from Filemaker. Larry

Thanks for reading this and helping out. I have about 2500 folders with unique names,(lastname firstname Dateofbirth), and I would like to now access those folders through filemaker. I have the firstname, lastname and Dateofbirth in field names, and I was hoping I could tell filemaker through the URL command to open a specific folder in my root drive using those fields . I dont want to have to type it in everytime with a different record to get to the patients folder. Since I have the fields in filemaker, I would like to have filemaker open the folder that has already been created that is (lastname firstname DOB). Any help would be appreciated. Thank…

I would like to have a script insert a date into a field, and have that date be the last day of the current month. So for example, if the script was run in January of 2005, it would insert 1/31/2005 into the field. Any ideas of how to do this? And conversly, is there a script that would insert a date that would represent the first day of the current month? Larry

I am really getting confused, here is what i did in 2 different databases. Allow User Abort[off] Set Error Capture [on] # This script just restore a value for an actor flag # Perform Script[Restore Actor Flag] # Go To Layout [search Actor] Enter Find Mode[pause] Perform Find [replace found set] # # Sets g_CurrentError(global, number) field value # Set Field[g_CurrentError, Status(CurrentError)] # Show Custom Dialog[Title:g_CurrentError:g_CurrentError: "OK",","] # The rest of the script just checks for the value of g_CurrentError and displays the value if not 0 in an message and sends the user back to main menu. # If the value …

Still learning so please bear with me. I was wondering if there is a way to capture the "text" on a button, and then use that text to set a global text field. Ex: I create a button and give it Text "Dog". Is there a way to capture the Text "Dog" to be used in a script and assigned to a global field. Forgive me if this is a ignorant question but I am still learning. Thanks in advance for any help. Dan

The script runs prior to the file closing. It no longer functions reliably in FMP 7. I have stripped out all of the steps leaving only the basic "Save a Copy as" step. The file location is set as relative. Yet when I run it manually I get the following message: <

Once upon a time I discovered opener files. That made me very happy as it avioded a number of mouse clicks for users and allowed them to look in the file system for the file they wanted rather than using Open Remote or the Hosts button. But now I discover that the opener file passes a full set of credentials along with it... I was having even more fun using external authentication to access the user's NT User Name; using it to validate which record they modified or created or were allowed to access, all without having to maintain 90 users in two places. Anyone know if there is a way around this credential passing?

I am running filemaker 6.0. Basically i want to create start up script that will check the username in the preferences and route that user to specific layout. Let say james go to Enroll layout and David go to Inquiries layout. Thanks victor

Hello all, I'm a bit stuck... I have a database of pupils and a related database of scorecards. Each pupil in my pupil database is related to a number of scorecards detailing their scores in a particular subject. Since most pupils take the same basic subjects, I would like to have a script that automatically adds common scorecards. It needs also to check if they haven't already got a scorecard for that subject. I stored a list common subjects in a repeating field (perhaps a list is better?) and I want to be able to do something like this Loop (for each subject){ If pupil doesn't already have score card for this subject{ Add new scorecard, set studentID a…

I have a script that opens a related record and spawns a new window. I give the new windows a smaller size than the orginal and place it in the centre of the screen. Strange thing started happening though.... and I don't know why. This was not happening originally. The original window and the new window BOTH shrink to the new size. I have tried to freeze the original window as the first step and this did not help. Any ideas?

Can I make a custom dialogue message display a value from a field? For example can I put <<Products::Product Name>> in the message? I tried it and it dodn't work so I assume the answer is no, unless I did it wrong. Thanks guys.

I have a nice inventory solution in Filemaker 6 that I am rewritting in 7. In 7 I have two databases in one file, Computers and Software. In each of these I have two layouts: Computer Computer List Software Software List The interface in each of these is tabbed. Click on the Computer List tab and that layout appears, etc. In Filemaker 6 I made separate scripts for all of this. In 6, in the Computer file I had two scripts, one that went to the Computer layout and one that went to the Computer List layout. Similar situation in the Software database. Associating the script with the proper tab graphic and all worked fine. In Filemaker 7, I want to cut dow…

I'm not sure if I need a calc. or a script for this. I have three fields from the same table on a layout. The first field is called "target date". The second field called "schedule" has radio button options 0, 30, and 60. The third field is called "completion date". I want to make sure that "schedule" has a value selected in it before someone enters data into "completion date". If there is no value, they need to be alerted by text. The reason I'm doing this is because I'm going to try and create a script to automatically create a new record that has a target date of x number of days from the previous completion date. Greg

Hi! I know I can have a script launched at startup, I searched for some information about it in the forum, but found nothing... Anyone know anything? Thank you for your time. jca!

I'm still using an old version of FM (v4), however I still find it very powerful for what I need. I

I imported a bunch of data into a FMP file. I then ran a script to move data from the imported fields into various elements of a repeating field. I imported over 20,000 records, which only took a few seconds, but then it took about 18 hours to move the contents of 8 or 10 data fields into their corresponding element in the repeating field and set a corresponding value in another repeating field via the script. Wow, that was hateful and I don't wish to repeat the episode. The script I set up looked like this. Set Field(Costfield, ImpField1) Set Field(CostType, "Cost Field 1") Set Field(Costfield -2, ImpField2) Set Field(CostType -2, "Cost Field 2") Set Field(C…

Oddly enough, after a recent long discussion about repeating fields, I have been given the task of maintaining a FMP 5.5 database that someone else wrote a few years ago and it contains a repeating field with 35 elements.The people who use this database were told to entered was a specific date in the repeating field. There are 42000 rcords on the db and about 4500 records were affected by this change Now, of course, they have been asked to change the original to another date, so they have to update all 4500 records again. Its called job security. The problem is this. The date was not entered into the same element on each record, it was entered in various elements of…

[color:"blue"] Hi! I want to be able to change the fill color of object by click a red button, or a blue button... I saw textcolor( text rgb ) but I dont know where to use it, I cant write in the action script, and I only see that function in the help. Thank you.

I'm seeking a way to open a FP5 solution and bypass the opening script. What I wish to do is have the solution open without running the opening script at all. Is this possible?

Hi , I have an Execute SQL item in Script with connection to Database and then a "Select * from table" I want then to say "if table.field=1" then Do something... Im able to click a field within the FM table and I get Database::Field But i want to be able to query the returned Recordset from the SQL? Any ideas??

Hi All, I am having a very strange (to me) problem in filemaker 7.0v3 on Mac os 10. I am creating a recipe database to keep track of ingredients and foods which go well together. I have created a script ("Create New" on the Ingredient Edit Layout of the "Recipe Interface" file in the attached files) to add matching ingredietns to a join table. All is working great except for the validation step. I seem to be having very weird behavior. I have created an auto-enter field which is supposed to concact the ingredient1 primary key with the Ingredient2 primary key. The field is to be validated unique. What I want to have happen is for the script to check that valida…

I need to come up with a list based on Month and day excluding the year. For example, list all loops establised in June (regardless of what year) and sort by day. In my current Excel sheet, I have a column with a number manually inputed based on month day - 102 for Jan 2nd and 1212 for Dec 12th, and sort on that number to get the set of records I need. However, that is not very, well, cool database design, but my knowledge of scripting is still on chapter 5. I do not mind swimming up stream to figure it out, so any help would b appreciated.

Hi everyone, I have a script that has a custom dialog in it and it has a lengthy message. the problem is that the user has to manually make the dialog box larger to read it all, is there a way to do this in the script. I know that if I make a dialog box larger then all the ones from that point on seem to be the same larger size, but is there a resize window step that will work with custom dialog boxes? I would appreciate any help, it is very frustrating. Thanks

I have a field which has a list of Consultants, every record in the db is assigned to one consultant. I need a script that will go to this field and count if consulatnt is Mr X and ignore all other consultants. Can anyone help?

I have two tables List and Mix List has two field ID (number) and Name(text) . It lists Contracts by ID and name all records unique. Mix has four fields (ID1, Name1, ID2 Name2)which state which contract can interact with which other contract...... when ID is entered then the name fields auto enters via lookup relationships to the List table For data entry and checking I have a layout for List as a form which contains a portal showing records from Mix related to the current contract ID to show which contracts have been designated as combinable with the ID in the current record. But these portal records only show based on one relationship.... thus if …

I am using Matt's calender that he used on that article about scheduling. And it is designed with mainly only two fields and one script. The script just has a set field function and a parameter to add the day you click on. I was wondering if anyone would know how to add to that so I could make diffenent buttons that would tell it to add that date to a different field rather than the one set in the actual script? here is the setfield function in the script: Let( [ md1 = Date ( Month ( Calendar_Tool::caltool_date ) ; 1 ; Year ( Calendar_Tool::caltool_date ) ); d0 = md1 - Mod ( md1 ; 7 ) - 1; n = Get ( ScriptParameter ) ]; d0 + n I would …

Please could someone tell me if it is possible to write a script to carry out this task? I would like to hide multiple records if two separate fields in the records meet a specific criteria ( "No" in both fields). I did manage to create a simple script but it only omitted one record at a time and it may involve omitting anything between ten and twenty records. Many thanks in advance.

1/4/05 Just upgraded from FileMaker Pro 6 to 7, and suddenly, one of my scripts does not work. I get the following dialogue box: ... "could not be opened. (Not found.)" Elipsis is mine. I have written half a dozen scripts in at least half a dozen files, but only this particular script doesn't work in some of the files. After that dialogue box, I click "okay," the file is opened and no problem. I have redone the script and still it does not work. I did not have this situation in version 6.X. Any suggestions would be much appreciated. Thank you very much. [email protected]

So I'm trying to write a script (which will be run at login, or manually run...I'm not sure yet) that exports all records who ordered on a given day of the month (If today is the 20th of the month it will export every record with an order date of jan 20, feb 20, march 20, etc...). However, I run into problems when combatting the issue of months without 31 days. If someone orders on March 31, they will not be exported in April because there are only 30 days. Now, I came up with a potential solution where I just export all orders from 28-31 on the 28th and include a command at the beginning of the script that cancels it on 29, 30, and 31. But this got me thinking if…

This should be a quickie... If a user selects a choice from a value list, how can I trigger a script to run based on the user's choice? Much thanks! -Scott

I have a Batch Tracking database that I just upgraded to FMP 7. The actual database is living on a FMP 7 Advanced server. This one particular script is running significantly slower now in FMP 7. There isn't much to it so I don't understand why. The database tracks mail batches that are assigned to processors. This script allows the users to assign multiple batches to 1 person without manually creating each new record. Here is the script: loop Exit if[isEmpty(NoOfBatchesToCreate)] Exit if[NoBatchesToCreate = 0] Duplicate Record/Request Insert Calculated value(NoBatchesToCreate;NoBatchesToCreate -1) End loop Does anybody have any ideas what might b…

Hello, 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 records via a portal. I thought I could call New Record/Request within the loop but don't see any way to sp…

Hey Folks, Here's what I'm trying to do: It's a Real Estate Database holding listings which include street, city, state, zip etc. What I'd like to do is put the mapquest code there so that if I enter the address it'll open the map with that selected. I can do that. What I don't know how to do is make a button with a script (?) that will enter the address fields into mapquest's form fields, so that by hitting the button in a record it will open the map of that property. Any help would be appreciated.