Script Workspace and Script Triggers

I am try to write a simple script to set a field to itself to remove the text formatting before printing. Basically, I want to be able to select any field, run the script, and it will replace the text in that field. Does anyone know if it is possible to to do this without having to create a unique script for each field? Is there a way to write the script so that no matter what field I select the script will be performed on the field selected. Thanks for the help. -Kevin

I have written a script to omit duplicate records, but for some reason it is not working correctly. What I want it to do is do a find on the field [invoice_id] and omit empty records and then omit any duplicate invoice_id's in the list. This is my script: Enter Find Mode set field [invoice_id, "*"] perform Find Perform [sort] go to record [First] set field [g_invoiceid, invoice_id] loop if [g_invoiceid = invoice_id] omit record go to record [next, exit after last] Else set field [g_invoiceid, invoice_id] end if end loop What's happening is that it omits the records even if they don't have duplicates. It omit every other records plus …

Hello FM People! As most you have dealt with this issue I will ask you for the help I was wondering, if possible at all, is there a short script that can grab a reference to an image (fromcontainer field) and and chage it on the fly. eg. from location c:folderimages ...........to some other letter (mapped networked drive) g:folderimages If any of you have an answer I would really apprechiate it! The Goal: alow users to use Predetermined local folder for image storage and manipulation and then execute THE SCRIPT to adjust the DB ones images loaded to a network drive (everybody mapped to the same letter)! So there it is... I hope you can help! Tha…

Hi All, I have a field named Name_Student: record 1 : Bob record 2: Chris and so on.... so I have a layout which have a global field named Check_Name ...when I enter : AnhTran.... how do I know that the name is exits in the field Name_Student or not and how do I check if I enter is correct? ... Do I need to go through each record to c check??? ...that takes long? ...or do I use a valuelist to check it? Anyone has an idea? Thanks Anh Tran

Hi All, I am trying to access a layout based on calculation result. Actually I have app 50 layouts and I want to access them based on users name and few other conditions which I have stored in calcualtion field and have named layout names in that way. Is there any way, I can access layout like "Go to Layout(Layoutname)" where Layoutname is a field not selected from drop down list. Thanks in advance Aditya

hi, I am using Filemaker 5.5 on Windows 2000 Professional. I have a form that contains a button to print the form.What I want is to print the form to a specific network printer without getting the printer dialog box . Note:The printer is not the default printer in the end users profiles. Thanks

I am trying to get my script to open a very small visual basic program that has been written for me but I can not work out how to do it. Please help me!!!

Mabuhay! I made a database launcher for my two databases and I coded a script that will open 2 FMDB at our FM Server Host computer... the code is: Allow User Abort [off] Set Error Capture [on] Open [Filename: "eglossRe.pkg" (Error-404)] Open [Filename: "Equipments.pkg" (Error-404] Both of these databases have the same password and they are runtime solution.... Question: How can I add a script step into my code such that I'll enter a password and both databases will be open without asking another password for the other database? I appreciate ur help... -------------------- ritchie

I have a compiled filemaker solution that I need to have contact another filemaker on a server. What I would like to do is in the filemaker solution is to click a button that will contact another filemaker on a server to perform a script. Both machines are running on OS X and I wanted to know if there is way to do this without using remote apple events. Thanks

Hi! Is it possible to have a script be activated by pressing the "return" key? I have a search page that I want my users to be able to just hit return after they have typed in their criteria which will then run a script that will take them to a list page.

I am building a database for kitchen cabinets. I have drawn some images of cabinets and pasted them onto a layout. These images act as a button to launch scripts that are germane to each type of cabinet. For example: I use a picture of a four drawer stack to start the script that adds 4 drawers to my cut list and orders 4 sets of drawer slides for tommorrows fabrication. I would like to be able to include a copy of each button image on each record. If the record was about sink base cabinets the picture of sink base would show up. If the record was about a 3 drawer bank the picture would indicate a 3 drawer cabinet. All of this is to provide an imm…

Hi, I am new with FM. Can anyone help me with this problem? I have a field that is basically a list of categories. Each record belongs to one of the categories. I have a button for each category. When the users click on a button, it finds and shows all the records for that category. Now the problem is for some categories there are no records. It is very annoying for the users when they click a button and get "no found records" message. I want to display the number of records for each category next to the button for that category so that the users don't have to go in if the number of records is 0. Does anyone have any ideas on how to do this? I…

Hi, I have a find routine set up for the user to search for records based on the "status." I am using the Show Custom Dialog option which allows the user to type in the status. This is kind of a pain because I already have a value list set up that has all of the possible options. How can I set up the input field in Show Custom Dialog to give me a drop down box listing the members of the value list? Hope this makes sense. Thanks for the advice.

I'm importing records into a phone number database that will be connected to my rolodex database via a portal. I'm importing each phone number, extension and type (Fax, Main Company, Direct, ext..) into a record with the contact's ID number. This works fine except for when a contact doesn't have a Fax (for example) and a blank record is imported, gumming up the portal with blanks. I wrote a script to go through each record, see if the phone number field is empty, and if it is, delete the record. Here it is: Go to Record/Request/Page [First] Loop If ["IsEmpty(Phone#)"] Delete Record/Request [No Dialog] Else Go to Record/Request/Page [Exit After Last, N…

Can I use scripts to control the properties and presence/absence of layout elements such as buttons, fields and text? For example say I needed to have "SendReminder" button to appear only when overDue>1. If overDue = 0 the button should not appear the layout. How would I go about that? -ilya

Hello everyone, I have a list of part numbers. The warehouse adds two zero's to the end of these part numbers. I need to trim the last two zero's for my DB. I am not having any luck creating a script to do this function. Can anyone give me a script that can cut off the last two digits of the number? Thank you very much for the help. Reggie

Hello, I just found a tech article on filemaker.com and they have a solution to make a demo solution that will make the database unusable after so many records. The script steps are as follows: Unsort New Record/Request Go to Record(Request (No dialog, 1) Omit Multiple (No dialog, 10) Delete Found Set (No dialog) The problem is i cannot find "Delete Found Set" option anywhere in Filemaker 6 Developer. I looked on filemaker.com and searched the forums and i do not see that option in Script Maker. Also here is the link on Filemaker.com if anyone is interested. http://www.filemaker.com/ti/102212.html Thanks for any help you can give me.

I'm sure this is a very basic thing, but I can't quite make the script do what I want. It's simple: I've got a list of records, and I want to compare some of them to each other. I've created a field called "Compare" where I can check (radio button) the ones I want to compare. All I need is a script that will skip the manual Find process and return those that have been marked. Any suggestions? Thanks, Brian

Im trying to create an importing script than would make it easier for the users to import records from one file to another. Every time I try I get the error "File is locked or already in use", of course I realize it is, but I do not want them to have to close one of the files each time they import so I am looking for any advice on the matter. Thank you

Hi Im new on here, I didnt know this forum existed. Its brilliant, If i knew it was here it wouyld have saved me so much time. Anyway, I wondered if any of you could help with this: I have 3 dates date1 = date new job recieved date2 = date job started date3 = date job finished I want to be able to perform a calculation that, finds the later date out of date1 and date2 then with that date find the number of WORKING days between that and date3. Im not bothered about bank holidays I just want the calculation to miss out Saturdays and Sundays. Any help will be much appreciated, Im quite new to filemaker and at the moment I keep getting asked to do t…

Sometimes a 'find' within a series of linked scripts will not find any records, and the dialogue to that effect pops up. In that event I want the current script to cancel and go on to perform the next script - the one linked by the 'perform script' as the last step in the current script. Is there a way to make this so?

Hi all, Anyone know if it is possible for a script to change the width of a text field in a layout? I can't find any evidence that you can but just maybe....! Thanks Ed

I have a script which Enters preview mode and pauses for input (continue or cancel) If the user hits continue then i simply carry on with the script, but if they hit cancel i want them to go to another layout rather than just return to same layout in browse mode. I have tried using if (Status(CurrentMessageChoice= 2)) but it goes nowhere just into browse mode as though it was not there. I am not sure exactly where to put this line to make the thing work. Any help please?

Just want to ask how to set the mouse over function to the button, for example, if the mouse cursor move over the button, the button color will change or become another shape. Regards Henry

We are running FM server. Each user creates new records. One user, "User A"- who does not create new records- looks at the records, sorts them, prints them, multiple layouts and modes. This user will, however, modify and add data to exisitng records... The problem is that users who create records will stay in records and "UserA" will get a message which states that someone else is modifying a record. I have tried creating a "process record" button which will exit the reocrd and I have also created a script which will exit the record based on time... Is there a better way to make it easier?

How do you create a loop where the loop is based on a value list. What I'm trying to do is create a script where I perform a search based on each of the values in a value list that is assigned to a specific field. For example, suppose you have a field with a value list assigned to it of value 1, value 2, value 3 and so forth. Then in my script I need to perform a search on value 1 then export the results. Then loop again to perform a search on value 2 then export the results, then loop again to value 3 until all values have been searched for. Thanks.

I maintain a club database and I'm trying to automate attendance taking. Each member record has a month field and I enter either an "o" for officers, "m" for members and "v" vor visitors in the month field if they have attended the monthly meeting. How do I count the "o" + "m" + "v" and end up with a total attendance for the month. Is this a calculation or a scripting function.

I have two files, a source file and a receiver file. The members of the source file may change periodically so I want to allow the user to select from a pop-up list of names and copy the record contents of the selection to the receiver file (for a history of selections). I have a more extensive description of the problem posted in the value list forum but maybe this pared down piece belongs under scripting. I know I am missing something easy here but, after some hours, can't seem to accomplish what seems to me should be a very simple task. Help is much needed and will certainly be much appreciated. Thanks in advance. Mike Griffin

hi there, Now i have a file customer.fp5 which keep all the record of customer including email address. I plan to send an email to all customer with email address in the same time. I don't want to send it one by one. So, is there got any way to do it ? Henry

Please could someone help me figure this out: I need to be able to establish how many records are showing the selection of a certain option from within a value list. For example, if i have a value list of states, I want to be able to find out how many records have 'NSW'' selected from the state value list, how many have 'QLD' selected etc. Basically i think i need to be able to work out how to extract the selection of a item within a value list for a number of different fields which may use pop-up lists or radio buttons etc. Ultimately I am aiming to be able to extract these deatils for a found set of records. Any Ideas?

I have a very old file that accepted and prints out a list of ten names, addresses and phone numbers on a single sheet of paper. This was developed by creating 10 first name fields (first name 1, first name 2, etc) and ten last name fields, etc. I have since created a more typical file in which one name, address, phone field is used and a new record is created for each person. Here is the question. Is there a script that can be created to transfer or import the old data of ten records on one sheet with different field names into the new data base? By using the same field names in the new file I can only import, of course, just the first person because the remaining 9…

This is probably easy to do, and I'm not thinking about it correctly. I have a field called s_Zone, which ends up having a value "Zone 1" thru "Zone n". What I would like is a way to display, via field, the count of each Zone. That is, something like this: Zone 1 : 100 records have s_Zone containing the value Zone 1 Zone 2: 65 records have s_Zone containing the value Zone 2 ... Zone n: 1200 records have s_Zone containing the vlaue Zone n easy right? do I need a script to populate n global fields? I know it's very easy to obtain this info by doing finds, but I'd like to have a seperate layout that contains this info. Thanks all

Hi there, I have a FMP database which is created last time and already have a number of record inside the database, i create this program in runtime solution with kiosk mode, so right now i have design another updated version(also in runtime solution with kiosk mode) and want to move all the record to the new version. so i need a script that can help me to move them automatically when i run the script. Can anybody help me? Regards Henry

Hi, I am trying to develop my first report but am starting to tear my hair out! I need to script a report to give me calculated results in a report layout. I need the script to generate results such as average age (i have an age in years field), number of males. females and transgender clients (this is info is recorded via radio buttons in a gender field), and i also need to be able to script it to look for what choices have been made from several pop-up menus. For example, in my 'area' field i would like to script it to produce how many records show a certain area from this pop-up list. Is this possible? I hope i haven't confused everyone with these questions an…

Not sure if this is the appropriate forum... I'm relatively new to FileMaker, but have a fair amount of experience in application and database development. I'm attempting to make certain objects/fields visible based on values in another field (in this case a simple Y/N radio button). So far, the most 'elegant' solution I've found is to create a self join portal on record_id::c_visible_key, and place the conditionally visible objects within the portal. However, I then had to overlay each radio button option with a transparent button which calls a script to set the field value (One script for Yes, one for No). Otherwise, the portal objects don't become visibl…

Hi guys, The scenario: I have a database of people's cv's. CV's are updated continuously, so what I have done is made a field of the "filename" with the path + name of person and created a script to open the file. e.g """" & "P:BCV - Brisbane CVs" & Author & ".doc" & """" This works beautifully. Problem: On my script i have the error capture turned on, but what i would really like is a conditional statement that would open the file, or if null, send a message saying it doesn't exist. I know I can do conditional statements when a field is "", but how do i do it when the thing i am looking for is external to filemaker?? i.e …

orderlineitems.db5 related to products.db5 by product#. Each product has a list of "parts.db5" that make up that product (related by product#). I'm trying to get a sorted (and grouped by part type) "parts" list for an order. Logic would be FOR each product entered in orderlineites.db5 of a given order list all parts.db5 that would make up that order. (parts sorted by sortcode in parts.db5 and grouped by product type). Thank you for your help everyone (esp Ugo,danjacoby,pupiweb,lee,Peter,broberts If this keeps up I'm putting you on my Christmas card list)

When using Filemaker Pro 5 and printing labels, is there a way to direct FMP to begin printing on a specific label on the label sheet? Of ten I do not use all of the labels on a single sheet, but am unable to reuse the remaining labels on a sheet because I can't direct FMP to begin printing on a specific label on the sheet.

I'm using Filemaker Unlimited 5 with the web server connector to serve pages via IIS. I've noticed that as users use the site, the found set on the server screen keeps updating. The problem is that if a user on the Internet does a search while a script is running, the script just stops without warning. Also, I think the found set in the script might be getting mixed up with the found set of the Internet request, thus causing unpredictable results. EG We have a filemaker database of products for serving to the web. The prices actually come from the SQL datbase of our separate sales system. Each filmaker product is marked 'no' (this product has not been updated), …

Hi! I want to trigger a script when I go to the next / previous record, how can I do that? Or how about a "GotFocus" function like in VB? I want to make a popup screen or warning message whenever a user goes to a particular record. Can Events plugin do this? I'm thinking of putting a calculation on field validation to run a script (using Events plugin). But a record must be modified first before it works. Thanks!

Hello- I am just wondering if any one here has a script that they trigger with applescript which launches a quickey and it works? WHEN I LAUNCH a quickey from applescript using quickeys backgrounder it takes 45 seconds to shut down and I don't know why. Basically, I am just trying to find out if others out there have used quickeys with filemaker that work and don't shut down filemaker. Thanks Dave

Hi All, I have a Global field which is validated by means of a button. The filed contains the day of the month ie; 1-31 Is there anyway in which I can script to accept ONLY numbers 1 thro 31 and NOT any alphas. I know I can do this if the field is not global, but that will defeat the purpose for which we are using it Many thanks, Benzie

I created a database that has a script that exports the records to an HTML using a XSLT file. The problem is when I run the database locally on my machine and run the script, everything works fine, the file is created fine. However when I open the database remote from the server and run the script, the file is not created for some reason. The setup on my machine and the server is exactly the same way.... Is there a difference in terms of running scripts particularly exporting the records to a file. Thanks.

I have several fields in a column and if the field is empty I would like that field not to show and the next field with data in it to be moved up. Sort of like this Field 1 125487 Field 2 (empty) Field 3 (empty) Field 4 258791 Field 1 125487 Field 4 258791 Is this possible?

Hi guys, I want to have a button on my layout, that enables entry into a field. However, if people click into the field, entries should not be possible. I have a huge note field, that I don't want people to edit manually, but I want to put a separate script button on there, so that when people do have to edit something (Murphy's law), they can click the button. Any ideas?

Hi Filemakers, Does anybody knows how to add a button to the TAB order and have it activated by pressing ENTER.

I am very new to this so please bear with me! I am trying to create a script that will function in different ways depending on the selection made in a field containing radio buttons. I have a field 'Consent' in which you can select either Yes or No. What i would like to do is if 'yes' is selected have the script take the user to a different layout within the database. If 'no' is selected i would like it to remian on the same layout and display a message. Is this possible and if so how? I know this is probably simple but i am new to scripting! Thankyou in anticipation

Ok, another newguy simple question. I am creating two solutions to be used by two different sets of people. One solution will be used by my customers' sales people and the other solution will be used by their sales Manager. What I am doing is attempting to "flat file" the sales person information, and e-mail it to the sales manager. when the sales manager receives the e-mail they can "import" the information into their solution. It is easy information like "salesperson","Project","projectValue","closedate" kindof stuff. The problem I'm having is that the sales manager doesn't need to see the import dialog I.E. map fields. I want to do this in a script and jus…

I am looking for a function or script step, that will allow me to go to a record depending on a value in a field. Example: I have a portal. There are entries I can click. Depending on which entry I click, a field called "selectedentry" will be filled. At the same time, I want to jump to the record that contains the value inside "selectedentry" in his primary key. It's sort of a browsing solution I'm trying to develop here. I guess I'm looking for a function, that will return the record # for the value I'm looking for in a field. Then I'd be set, because I could use the returned number with the script step "go to record by field value"... Any ideas? Tha…

Is it easy to create a script that recreates the sort funtion like Excel or just about any windows program's column. You know, when you click on the title of the column and it sorts by that column. I have a list of a few items that I would like to allow the user to click on the column (specify button) and run a script that does this. Any thoughts?

Need to start in Ordermain.db5 and have button that will take info from here and create a new customer record and customer# in Customer.db5. : I'm experimenting but can not quite get it to work.

Can somebody try this file on his Win2K machine? Since I am using mainly AppleScript, I don't know if the WSH script works on other machines.

I have a script that prints using a certain Page Setup configuration, so in my script I've got a Page Setup Restore step, and that part works great, but depending on the button that is pressed (there are 5 different buttons), it makes the printer process the job to a different tray. The bug is that FileMaker does not store the tray in the page setup restore so I have to do it manually anyway... Is there any way to store the tray used in a script and script it?

Hello I have some data that I imported into filemaker. I have extracted the fields I need from the text but there is a hitch. Sometimes there is a different number of lines in the second group ( you will see below) in which case it throws off my other formula. What I would like to do is somehow keep the number of lines in the second group the same. You see sometimes they take away the second line in the second group which throws everything off. This data is in a field called "A" which is where I pasted the original data. Below is the form it is in using x's xxxxxxxxxxxxxx xxxx xxxxx xxxx xxx xxxxxxx xxxxx xxxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxx…

Anyone know how to activate a script to automatically execute when a user enters a certain field on a layout? Thanks for your help!

I am looing for a program that will bring a Filemaker window to the front if Filemaker is not the program open. I am using Keepitup to make sure the program is open but incase the program goes to the back I need it in front to work.

Hey guys, this is fun. Anyway, I'm trying to execute a script as soon as someone leaves a field. Is there a way to do this? Also, what script step do I need to use, to deactivate all fields? For example, I have a script that clears out a field. It just inserts nothing into the field. However, I want to get out of that field, I don't want the cursor to be flashing in there. Any ideas? Thanks so much!!!!

Let me clarify. I'd like to enter a number into a field. As soon as I hit the enter button, I want to execute a script, that'll take me to the record number that I just entered into the field. Do you guys have any help for me on this? Thanks!

Guys, I'm trying to put a field on my layout that is supposed to hold notes. I have a button on the layout that says: "Add comment". When a user hits that button, I want to insert text into the note field on top, with the current username, the date, and a ": ". Then the person should be able to type whatever he wants in there. My problem is that when I use the "insert" script text, the whole note field gets replaced. I guess my question is, how should I go about doing this? How do I avoid replacing text, and how do I make sure the text is inserted *before* all the other text that may already exist? Any ideas? Thanks!

I did a site-wide search for 'modifier key' and didn't find an answer to my question... Is there a list of modifier keys and key combinations with the corresponding number? I'm using OS X (10.2.6) and FileMaker Pro 6.0. TIA (thanks in advance). Abbe

Hello People! I was wondering if this is possible with some script or perhaps I am missing a conecpt. Here is the scenario: Some Table Layout: Field 1- Container = Image(not reference) Field 2 - Text/number = RecordID is there a way to sort asc. or desc. based on existance of image in the field? eg. IF filed Image ="" THEN list it on the bottom of this "sorted list". Basically I would like to have those records without image to be listed on bottom of my Table View. Sorry but I have not used much of ScriptMaker and I do not know if this is ever possilble. Thank you guys for all the help!

From my previous post, alphanumeric paging can be added to windows fm using PageMaster software. I have been testing it the last few days and it works great with filemaker. just thought you like to know.

I am trying to send alphanumeric pages using dde function in fm to another application www.omnitrend.com, what I am trying to accomplished is to send text messaging from my db. using sendmessagi i am able to open the pagemaster program, then i get lost on the dde command to send my message out. you have to have contact name in pagemaster set up, which i have. but i am unable to send the name and message from my db. Have i got everyone confused, the download from omnitrend is a demo so if someone is in a good mood, maybe they could download the program and might be able to help me. thanks

Hi all, I doubt very much that the following is possible - but you never know, and if it is it would save me several hours of work so I would be very grateful! I am creating a database with thousands of fields, now these fields are have very repetitive descritions and each one is a calculation containing the same calculation with a couple of didgits changed. I will give an example: Field 1: Name: S1A1Mark This stands for Section 1 Answer 1 Mark Calculation: Case( S1A1 = "", "", S1A1 = S1CA1, "1", "0") If Section 1 Answer 1 is blank then the score is blank If Section 1 Answer 1 = Section 1 Correct Answer 1 then the score is 1 Else the …

Hello, I'm trying to figure out how to load a related database with default data each time a parent record is created. To be more specific, I have two related databases, "Projects" and "Tasks". Each time a new Project record is created I want to populate the Tasks database with a number of default tasks. I've been considering a couple approaches however I'm not quite sure how to implement. I'm assuming I need 3rd database which will serve as the source from which the default tasks will be copied...: I'm a FileMaker newbie and would appreciate if someone could point me in the right direction. Thanks!

Hi guys I have two databases, the master database, and the line items database, linked up in the usual master::order_id <> line_items::order_id relationship. What I need in my master database is a calculation field(?) that loops through related records, and take a field's contents and puts it together. Example: four records in my line items db. With a field called product name. the product name field in the four records contain "Pen", "Pencil","Ruler","Eraser". What I need is my master db calc field to loop through the field and have the contents: "1) Pen, 2) Pencil, 3) Ruler, 4) Eraser" Is there anyway of doing this or is it a scr…

Does fm 5.5 have a command line or is there a way to do a command line function

Hi, I have two files related - one to many. The master can see all its children via a portal. At present, to create a child record I type into a field in the portal and this creates the child-parent relationship, I can then go to the related child and carry on adding data. This is not ideal, I would rather have a button in the parent above the portal which can be selected and thus creates a child relating correctly to the parent. What's the best way to do this please? - 2 scripts? Step-by-step answers please as I'm not quiet used to the FileMaker lexicon. This site is good. J.

I have a database with 5000 records. It is a flat file with a field called style. For each different style there are between 1-5 records. I want to write a script that will go thru all 5000 records and number the corresponding records with the same style example if style=b234 and there are 5 records with B234 I want B234-1, B234-2, B234-3, B234-4, B234-5. Thanks for your help Jeff

Hello- I have a script which I am using to try to gather single record information from Select phone. I made a quickey to paste the information from a field in filemaker and then the quickey would bring back to filemaker. The problem is filemaker isn't playing the quickey . I don't know why. I was unsuccessfully trying to do the same thing with applescript but that is even harder for me. Has anyone ever tried to extract data from Select phone ? I am trying to make a way to get this quickey to work by an apple event. Any suggestions would be very appreciated Thanks Dave

How "translateble" is the following C++ code into a script? Is it possible to make a script that functions this way at all? Many thanks in advance!

OrderMain.db5 has Orderlinedetail.db5 related by order#. OrderMain.db5 related to CustomerMain.db5 by Customer#. All I want is to start in OrderMain and print out an order with customber.db5 info and OrderMain.db5 info in headers and footers with all the Orderlinedetail.dbt lines in the body. Downloaded samples are so complex for a beginer and book has NOTHING. HELP! JW

hello i have a piece of software that contains a lot of data which i bring into filemaker. The problem is that i need to tell the software through a quickey to look up the next value. i am not sure how to make a field in filemaker that will; get the next value of the alphabet in other words i need it to calculate the following values , i am just not sure how to script it to go through the numbers and the alphabet. a1,a2,a3,a4,a5,a6,a7,a8,a9,aa,ab,ac,ad,ae,af,ag,ah,ai,aj,ak,al,am,an,ao,ap,aq,ar,as,at,au,av,aw,ax,ay,az,b1,b2,b3 etc So when filemaker reaches the last record from the other database of 'aa' it then takes the next value to be calculated in a f…

My customer is requesting the ability to notify all users on the fmserver that a sale has been logged - to build team rapport. Is there a way to utilize the Send Message to all feature found in Remote Administration from a script? Or a way to play a sound on all users PCs? Windows environment.

I have 45 records, and I have a field name "selected number". How can I make a script that can tell me which one got selected first? Let say my first record came up randomly is 'C', then in the field "selected number" should have number'1' in it. If the second record came up to be 'T', then the field "selected field should have number '2' in it. And so on. Please help me, I appreciated it.

I need some help ... I need a script that basicly gives the user the option to cancel the button that they have just clicked on.. Like ... A message pops up that says "Are you sure that you wanted to do that" with a yes or no option ... I know that there is an easy way to do this ... I guess that I am just having a brain fart.

Hello, I am developing a help form and there is a field call date resolved that i want find out if it is empty. This is the script i have right now: Enter Find Mode [] Paste Result ["resolve date", """"] Paste result ["assign to", "Status(CurrentUsername)"] Perform Find [] Enter Browser Mode [] So i just want to display those record which have the empty field resolve date for the current user. Thanks, victor

hi, I am trying to automate a script using task scheduler, so far i have it working by running the script on opening of filemaker, however the file requires a password, not to begin with as the file is empty but when the script ends and the file is full it must have a pssword, is this something to do with script step "change password" ? any help much appreciated.

Hi, Could someone please explain to me the implications of unstoring the calculation for Status(CurrentDate)? I thought the idea of this function was to set the current date of when the function was called, therefore what would the difference be whether the calc was stored or unstored? Surely it would not be recalculated either way until the function was called again? Many Thanks Ed.

Hi ,i want to write a script that deletes all duplicate records (duplicate by one field) the other fields do not matter, however i want to leave one of the records from the duplicate set, whats the easyest way of doing this? Thanks

I am developing a DB that has a To Do/Reminder list. On start up it checks the records to see what is "Due Today", "Past Due" or "Not Due Yet" and displays this in the "satus" (I know, a typo and have not fixed it)field. Script follows: Go to Layout [To Do main] Show All Records Go to Records/Request/Page [First] Go to Field ["satus"] Clear[select] Go to Field ["Date Due"] if ["date due = Today"] Go to Field ["satus"] Insert Text [select, "Due Today"] Go to Field ["Date due"] Else if ["Date due < Today"] Go to Field ["satus"] Insert Text [select, "Over Due"] Go to Field ["Date due"] Else if ["Date due > Toda…

Hi, I'm running FMPro6 on W2K and cannot find Open Hidden, is this only available on Macs? Thanks Ed.

Hi all, thanks to Russ (and Ugo, and Peter, and ... ) my default image portal is working just perfectly - all the images for a property can be seen in one place and I can make any image the default for that property. Now, I want to be able to add images (to the images DB) from a button near (or in??) the portal in the properties DB --- but as usual I am confused --- The script I am working on looks like this so far: GTRR (Images) Perform external script (the AddImage script in Images) (are these 2 things backwards?) the external script: Go to Layout [Admin] Set field[g_LastRecord, PropertyID] ?Copy[g_LastRecord] New Record/Request Paste[PropertyI…

After searching the posts I couldn't find this topic covered previously. I want to insert and/or remove text in a specific field in a selected list of records. EX: After creating a mail list via FIND I want to put a notation in each record of the mailing I sent them without having to paste the information in each record individually. On other occasions I may have inserted information to help narrow a search, but now want to delete this information in each of those files. Any ideas how to automate this? Thanks, Scott

I need to create a script that can randomly select 15 records, but I don't know how. Please help me.

Hello, I have a container field DB that holds items like Webpages, word doc files, sounds and pictures. I'd like to be able to make a button that will automatically launch the proper program for each type. I can't see a way to do this yet. And double clicking on the field can have odd effects. As an example. The word file opens IN FMP and attempts to edit it directly! Not good. However, if I right click on it and select open it opens in word and allows editing and saving. This is perfect but my users get confused having to do this. Hence the bright shiny click me button to open it up. Any ideas? Thanks

I'm trying to devise an easier way to do a logout script for my database. Basically all I want the script to do is set the g_user field to blank (easy enough), and close all open files except one. This will allow the user to login as someone else if need be. Aside from writing a script that has close steps for every possible file that may be open (which I'll have to change once there is a new file added into the mix), is there someway I can do this easier? If not... No problem, but it would be nice to know either way. Thanks!

How should the syntax of the AND operator be used in a conditional test. I want to format an if statement to return true for two tests. One of the tests is a NOT isblank(fieldname) test and the other is Status (Currentfieldname)= "phone1number". Both these tests tied together with an AND operator. Ive tried various ways to syntax this and cannot get it to work. Any ideas?

I have a button set up to email information. I call to the SendMail[] in the scriptmaker to email. The dialog box appears and the "Send" and "Do not Send" are the choices. I want to capture the actions when the user chooses either one of the buttons. This is in order to change a flag on the screen showing yes it was sent or no it was not. When I use Status(CurrentError) I receive the same number 1-User Canceled Action when each button is selected. Is there a better way of capturing the users actions? Thanks for any help.

Sorry if this is basic, but Im coming from a SQL background. What is the equivilent in filemaker - either a script step or in a calculated field of the SQL SELECT DISTINCT statement? I cant seem to figure anything out, or find any references. Thanks

I have a script for my login file that checks to see if it is a valid login, if it is, then it performs a certain external script depending on what 'unit' the person is in. I have a custom dialog popping up to fill in 'Username' and 'Password' fields in the login file. The login file has a relationship to the user_db by the field 'username'. The script looks like this: .............................................. - Go to Related Record (user_db) - if (user_db::password = password) - set field (g_username = username) - g_username is a global set when someone is logged on. If g_username is blank, then they are not logged in... An open script in every fi…

I am trying to use the dial function to dial a pager. I can enter the pager number 000-000-0000 and it works, but i need to put pauses after the phone# in order to send additional # 000-0000 followed by a # to tell paging company that i am finish with the call. any suggestion, can it be done. thank

Hi all, I have a DB containing only about 700 records. I need to create a script that will do the following I enter some search criteria and perform the search this will bring back about 70 records on average. Then I run the script. It gives each found record a number starting at 1 and going up in increments of 1 for each record. It then generates x number of random numbers not greater in value than the current found count (x = 33% of currentFoundCount) The random numbers it has generated then relate to the records in the current found set with those numbers The field "Selected" is then set to "Yes" for these records The numbers are then removed f…

Hello anyone, I am a beginner DB developer and I need some help working with already created sophisticated DB's. I have a faculty DB that has over 100 files in it and there are only 30 faculty and staff members. I am trying to create a script that will export or delete all faculty records that are inactive. I have been trying very hard to create this. Can anyone help please?: Thanks Geeker

hi there, just want to ask can we change the screen resolution to 800x600, because i was create a solution with kiosk mode in full screen, but after i run in computer with screen 1024 x 768, all the screen will move to top left site of the screen, so i need a script to change the size to 800 x 600 and after close the program, it will change the size to original size. Or maybe got another way to solve this problem ? Henry

what would be the best way to copy a record to another db. I tried importing but cannot get it to work. Is there another way i can do this, so i can go to that db to look up my messages. thanks, jim

Is there a way to stop a user from using the close command in the file menu and or the close button on the head of the template can you trap that somehow and display a message which tell them to use the button supplied on the template. i have a backup script that runs and i dont want them to circumvent it by doing a end run by just closing the template Thanks for any help in this matter

The Plot: I have a database where records are exported individually and merged with a document in Word97. The Dream: I understand I can set a script to automatically export a record to a pre-defined filename. However, what I would like to do, is script it to export it to a filename which is the data in the field "{fileno}.mer" for each record.

I have a portal that contains 3 fields. two standard text fields and one field that is a check box for "yes/no". This too is a text field, it's just based on a value list [Yes:No]. The portal itself is based on a self join relationship of a calculated field. No biggie all is displayed well. The goal is to be able to loop through the portal and find the first record with the radio button checked Yes, then grab the text from one of the above mentioned text boxes of the same record and copy it onto the current or master record (the one containing the portal). I'm not sure how to do this, although my gut feeling is that I will need to do some sort of loop on…

Hello, I want to compare some dates in a script, and then perform an action based on an IF statement. Here's the pseudocode: IF (date is between date1 and date2) ...perform action... How would I do that in a Filemaker script? Regards, Evan