Script Workspace and Script Triggers

Hi All,, I have a script to check 2 fields if they are empty then user goes to that field and fill data . My script is loop if isempty(field1) go to field1 ...endif if isempty(field2) go to field 2 ...endif exit loop if field1 <> "" and field2 <> "" end loop but it just run very fast ..does not pause for people to fill in and go to next fill to fill in ...Some people have an example or an idea about checking empty and go to that field to fill in?? Thanks Anh Tran

Hola mi FM_amigos! is it(topic) even possible? I have a script that calls a MSG box that has...well..choices to run some other scripts. The problem is if user clicks on "close" [x] (wind0z) the message box does close but the initial script (that called this MSG Box) continues running...is there a scrit/way of "IF MSG Box closed THEN quit all this and GOTO Layout_X"? thanx_ para todo!

IS there a way to tell other script meet condition or run correctly in order current script continue to run? ... Because I use other script for many other script that is why I don't want to include other script each time. Let's say i have a script 1. In script 1, I want to check if script 2 work fine? how to do that? ...is there a function to check script 2 is working fine or last case is I have to inlcude script 2 in script 1??? Anyone has an idea? Anh Phu

I will be emailing my bosses so daily info 'summaries' Problem... if I copy from a field and paste it into a field (that the email will grab) $1,025,284.25 pastes in like 1025284.2512789 how can I paste in so that it is properly formated?

Hi Gang! Another one: 1. User Enters Preview Mode -IF user is not browsing or printing or doing anytihing send him.her to a layout_X after X amount of time!? as always, thank you!

I am importing a field containing an eight digit number (with four preceeding zeros) from a pc database (using excel spreadsheets) and need to knock off the zeros once in filemaker. Is there a script I can use to get rid of the four preceeding zeros? My experience with scripts is limited - have never written one myself, only selected from a list. Please help. Thanks.

I am working on a FileMaker solution and have come upon a snag. I have a screen that consists of many fields from a related file. I want to be able to mouse click on a field, automatically select the contents of that field, and have those contents set into a separate field. I have made each of these fields a button, but have not found a way to accomplish this goal. FileMaker does not select the field that the button is associated with, so instead any implemented functions use whatever field the cursor is in. There are many fields so I do not want to have a separate script for each field. How can I select a field and have a button on it at the same time? Please a…

I Nedd a script that will allow me to assign a unique number to a record from a pool of numbers, let

I have a text layout/letter which has merge field inserts. How do I email an individualized letter/layout to each person?

I have a script that performs a find via a date field. The field searches for all records with a date greater than today. How do I include titles without a date in that search. I also want to make sure that the fields with "null" are added to the end of the records list. Do I need to add some type of value to the field? Paul

Hi People! I was just wondering if it is possible to set the Dialog/MSG box without really "accepting" input into any (temp or global) fields? all I want is to do is give the option to user to run different scripts. =============== click something [RUN][yes][no] =============== --------------------------- if [RUN] go do script_1 if [yes] go do this script_2 if [no] exit this MSG box script ----------------------------- thanx 2 ALL of you!

Hi all, I'm struggling a bit with this one... I have a script which: Opens up a custom dialog: "Please enter start reference number" User enters for example: "1093345" This sets global field g_Start to 1093345 Opens up second custom dialog: "Please enter end reference number" User enters for example: "1093446" This sets global field g_End to 10903446 Now I have my range. What I need the script to then do is create records in this database, each record has a field - "Reference Number". The script will take the first reference number in the range enter this into the field "Reference Number" and this will be the first record it c…

I am trying to create a db with a running total. I have a field in each record that holds a number representing a persons percentage of involvement. I have a script that raises that value by .5%. What I would like is to have a field displaying a running total of how much of tht total percent is left. (If Tom gets 25 and Liz gets 20, there should be 55 left.) How do I add fields in differnt records togther and keep a running total that I can subtract from 100 and have a remaining percentage displayed in a field that would be the same no matter what record I am looking at?

Hi People! I know this post has be discussed already but I am not "good" (=bad) at scripting and missing some conecepts...so if you can help/advise/explain it would be greatly apprechiated. The scenario: Find all records in a date range eg. 1/1/2002...2/2/2003 my field Date is a calcualtion field defined as: Date Unstored, = RELATIONSHIP::Date --- so I spent some time on the forum and found this post by a Bob W. ========================= Enter Find Mode[] Insert Calculated Result [Date,DateToText(g_StartDate) & "..." & Date To Text(g_FinishDate)] Perform Find[] Go To Layout [Whatever layout you choose to display the found records] =======…

Hi all, I was reading some messages on the forum & find reference to "Quit" application. That is a script step I don't have in scriptmaker (FM 5.5v2 on PC). I figure it must be available on MAC? If that is correct, to design a cross-platform application will I need to finish the design on MAC to add different script steps that are platform dependent? Something like If current system = Mac do Quit else do Exit? Thanks --Dan

Hi all... I have the following problem: I have two databases which are related to eachother. DB one contains 5 different fridges as items. DB 2 is my main DB to record new entries for leasing one of these fridges to a new client. The fridges are linked to my main DB with a dropdown menu to be selected. My question is: How can I prevent selecting a fridge that's currently allready leased to someone. Is there a way to do that? Perhaps by locking the leased fridge and diplaying a popup message? Any help would be greatly appriciated!! Thanx!

How could I have a rolling 5 day [color:"black"] date (03/07/2003.....) value list that would perpetually change

Hello there, I am working on this databank where I try to organize the chores of a family household. I have it full of buttons and scripts but I find myself in front of one tiny problem! I do not know how to create a button that takes me to the records (i.e. "what did I need to do yesterday?") from YESTERDAY or a button that shows me THIS WEEK. Does anybody have a suggestion? [color:"purple"]

How do I create a script that puts tomorrows date in a date field

Hi People! I am sure this is easy for those with higher left-brain development than me -I am looking for a step-script to exclude 1st record (every field is empty so I do not need to mark it as 1 or 0) in Preview Mode.....when the records are considered "pages" so in other words "Goto Record Number 2" before sorting does not work Any thoughts?! many thanx_

We just bought a 120 GB Iomega NAS (basically a hard drive with an ethernet connection.) We plan on organizing our work files, organized by part number, on this new file server. The path would almost never be the same, because the script would be activated from different records in our parts.fp5 database. I think this can be done, but I'm not sure how. This would have to be a cross-platform script, so I'm wondering about Windows vs. Mac file paths as well.

I appreciate all the help with my question and have come closeto solving my problem. I have been working with the calculation that was posted on this site Max(Self::Order#)+1 This works but it does not search for the highest number in all records it searches for the highest number in the selected record and adds 1 to it. can anyone help me??? Warren

Hi All I'm a Filemaker newbie and I was wondering if filemaker could examine the fields in a databases records. Compare them and condense the ones that are the same while keeping track of how many there were originally? i.e. Name # pasta 1 pasta 1 pasta 1 turns to Name # pasta 3 this is probably a simple question, but I'm new to databases. Is this something that has to be custom written or is this something that is built into Filemaker? thanks SJSLovechild

Hi all, I have a script that has on step. It says "go to field "location" with the perform option turned on. That field is placed on the layout twice. One for viewing and the second one for selecting data out of a pop-up menu. When i trigger the script, the field that the script goes to is the viewing field. But the script should go to the pop-up field. I've tried putting the field on top of all the other layout parts, changing the TAB order but it doesn't go to the correct field. Any solutions anybody? thnx allready... Jeff

Can someone help me. I am working on an estimating database that once sold will convert the information to an order. My problem lies in that I cannot figure out how to serialize the work order # field with a script. I can easily serialize the estimate # when the record is created, but as we all know we write 10 estimates to get 1 job. so I need to have a script that will check the last order number and add 1 to it. I know it's probally simple but for now the answer eludes me. Warren

Quick question: Is there any way to make a drop down menu appear in a custom dialog box?

Hello, I'm new to using Filemaker (but not to database programming). We've purchased an application written in FileMaker (multiple databases with defined relationships and lots of scripts). I took a data collection that we purchased from another institution and created a Filemaker database(s) (multiple databases with portals in the central one to show the relationship between the different metadata). I'm trying to understand how scriptmaker works to determine if I can map the data collection into the purchased application. I'll need to be able to "open" the multiple databases and read records and write records without necessarily closing one file before working …

I've got a script that's called from the web. It has FileMaker printing to pdf, and then sending out an email. I've noticed that if FileMaker is in the background, the script goes on hold until FileMaker is put in the foreground. Is there anyway, within a script, to make FileMaker move to the foreground? (using FileMaker 6 and Mac OS X) Thanks!

Hi everybody, I have a database and want to make a search layout with 3 global fields to search. - search key name - search key title - search key type They are global fields (text). I made a script to search: ------ Enter find mode [] Set field ["Name of the Plant", "search key name"] New record/request Set field ["Tiltle of Paper", "search key title"] New record/request Set field ["Process type", "search key type"] Perform find [replace found set] But I cannot find exactly name of the plant or title of paper I need when I typed in field "search key name" or in field "search key title". It showed the message "There are no valid cr…

I am trying to repair an existing set of scripts. Here is what I have. On one computer the script looks for a file being ftp'd in. It imports the .dat file into a small db containing just the SSN which is all that is in the dat file. It then does a COPY command on that field. Next it calls an external script from the main server. In that script it PASTES into a page in FIND mode, then tells it to export the data. This has stopped working with the latest round of security patches. So what I am trying to figure out is another way to pass the data back and forth. How can I tell a remote script to insert specified data into a field and do a find on it and then pas…

Hi People! I was just wondering if it is possible to create a script that will show or hide an object in the portal row (eg. image) based on some condition? eg. records that do not have a field (eg. Date) populated ==============portal====================== record1.........1/2/2002 { ----NO RECORD IMEGE.jp----------------} record 3.......1/3/2003 record 4........1/1/2002 ========================================== Thanx for all the comments and advice!

Hi all, I know I have same question with people before but i try to search but no answer for me. What I want to do is someone clicks in the radio button and it execute the script ...I don't want to use a button to execute script. Anyone has an idea how to achieve this without plug-in Thanks Anh Tran

Hello People! I was just wondering (Hopeing) to find a script that will allow or prevent a user from enetering data in to a Portal. I would like to have a button trigger this script so that onClick it will set the portal to be "Editable" or better said Entry Will Be Allowed but if not clicked it will remain "locked" from data entry! Is this evern possible? Thank you all for taking your time!

I have a number field. I'm trying to use a script to change the field font to Red and Bold if the value is under 220. Of course this wouldn't affect the actual data in the field, just the appearence of it. I know how to evaluate the value but not how to change the font color and style of the field. How would I do this? Thanks! Corey Martin

Hello, I've got FileMaker 6 unlimited running on a Mac with OSX. I'm trying to automate the printing and emailing of pdf documents. Right now I have FileMaker print to PDF, Troi rename the file, and SMTPit mail the file as an attachment. My problem: at times, FileMaker doesn't print to PDF quickly enough, and Troi (which is next in the script) has no file to rename. The user gets no attachment. Even worse, the next user gets the attachment belonging to the previous user. I could split up the printing and and renaming, leaving some time between them, but I'm afraid the files might still end up going to the wrong people because this is a web application, and a nu…

Hi there, Now i need to have a program that allow people to attatch a file, then i will set a button to let them click and open the file using their own application, after that it will jump back to my program. The attatch file is just like have a browse button to let user browse the file then the path of the field will display in a text field. How can i do this. Regards, Henry

hi there, With the example file i have attatch, i have some question about the field or button entry. In this case, i have set 3 field with 1 button, the button only will come out when the 3 field is not empty. It just put the button into the portal with a self-relationship. Now i need to set another button in the same position which come with no finction and design with engrave(i have put it in the file that i attatch) , so that it will look like the button become engrave while there have some field empty, and when you click, it will no perform any action even change color(like normal we click a button). After we fill in all the field, the button will become emboss an…

Ok, I was new to FM and when I was doing data entry, I simply dragged my images into the container field. Not the greatest idea I found out when my file is topping 280mb and loads painfully slow on the web. Is it possible with a script or plugin to export and reference all the images to a file?

I have a layout in which I need to print in three columns the names of students enrolled in certain classes. Problem is, I don't want FileMaker to run to the bottom of the page for the first column, then come back up to the top to start a second column and only have a couple of names left to print, because that looks 'not-nice'! I would prefer to have FileMaker see how many names there are in total for that specific class, then divide them by the number of columns (ie 3) and figure out how many to put in the first and second columns, then dump the remaining names in the last column. Then there is some symmetry on the printed lists (since all columns have the same numbe…

Hi all, Has anyone any ideas how to do this one. I have 2 databases. DB1 is addresses DB2 is personalDetails The user is working in DB2 They receive a custom dialog asking them to enter PostCode and House number. This sets the PostCode field to whatever and the house number to whatever I then have a calc field which joins the 2 as follows: 1, M227LG DB1 contains or will contain all UK addresses This database contains the same field as above At the moment I have this set up so that once the user has entered the PostCode and House number the rest of the UK address is filled in using a relationship to DB1. If the Postcode and house…

Hi there, now i have 2 file, one is to keep customer record and the other one is keep the sales/order record. In the order form, i set it into 2 part one is customer information and the other one is order information. In the customer information part, i will let user to key in detail, if they type the company name or customer name which already exist in the customer file, the other details will display out. If not found, the user can still key in the details like tel no, address.., and i will set a button to let them click then add the customer information into customer database. At the first time, i'm using look-up field but it only can work by either one, cannot b…

I don't know FM at all, but I need to do this for a client. FM Pro 5 POS app created with four databases (roster, inventory, sales, line item) inventory database doesn't have a quantity field so every item is a separate record. The inventory database is getting very large. I need to find all the items in the inventory database that have been sold (have matching barcode field data in the line item database) then delete all records found from the inventory database. barcode is a number field - I think this is what is screwing up my find. find view in inventory database, placed this in the barcode field. ==(line item::barcode) Where can I…

I have a database that compares required materials with inventory on hand. I would like to have this database be able to produce a purchase order and automatically fax an order to specific vendors. I am using Filemaker 6 on an Apple G4 running OSX. The filemaker help file indicates that the auto dial script is not supported with OS X. Is there another way to accomplish this? Could I automatically email this work order? Would a developer's version of filemaker make this happen? Thanks in advance

Hello folks, old trick new twist. I want to color the whole row based on values in C_fieldA, for instance. I seem to remember, that I need to create global repeating container, paste colors into it, and create C_fieldA calculated container to grab the colors. Here's what I did: G_colors is global container with 7 repetitions value list with 7 different options Notes is text field formatted for the above value list C_Notes is calculated container, something like: Case(Notes=*option 1*, GetRepetition( G_colors , 1), Notes=*option 2*, GetRepetition( G_colors , 2), etc) Then I position C_Notes behind the whole row in form view, make …

Hi there, now i want to ask how to set a field enable entry from from false to true (like in visual basic). For example, i have 2 field, temp1 and temp2. Temp1 is a list with 2 selection, true & false; temp2 is normal text entry field. The field temp2 cannot by entry by user unless they select the value "true" in temp1. Regards Henry

We have a part database that we have linked to a support document database, in the support file we have a container field used to hold such things as spec sheets, application notes, etc, all in pdf format, these vary greatly in size so we import reference only. In starting this we used the folder import command from the menu (mac FM6 menu command folder import)...not anticipating we could not perform the same operations via scripts. That is now our problem, during folder import the select field window automatically shows file name, file ref, pict, and thumbnail as import option fields...ok this is great, we set up fields corresponding to these import option fields. Im…

This may be a stupid question but for some reason, when I use DateToText(Today) it returns 6/20/2003. You might ask, what is wrong with this but it said in the filemaker pro bible that it would return in the format 06/20/2003. of the format MM/DD/YYYY, having a "0" before single digit numbers for the month and day. This is the exact format that I would like it to be in. Is there a preference that I need to change? Thanks.

Hello I have a test field -Field "A"- that has faulty data entered into it. ( it is not always in the same structure) The problem is : Sometimes the 10th paragraph return has a parenthesized 5 digit zip code at the end of a phrase --like County : Madison : (13421) and In this case I would like to add a BLANK SPACE as the 11th paragraph return and move down everything a single paragraph return If the 10th paragraph does NOT have a parenthesized 5 digit zip code at the end of the phrase i would like to do nothing Example (this is what I would like to script IF the 10th paragraph contains a parenthesised zip code at the end of that line -just add a spac…

Hi all, How can i "create" blank records to fill holes in printing?? I am ready to print a time card for a workweek, i need to print 7 days. If however the employee has only worked 5 i want to create (in the proper place --> date order) the blank record with the mention " OFF " to say this was a day off. I could create those blank records in the database but it seems like a waste of space to have blanks in a workday file. I thought of making one dummy record (with a date outside of any usable) then find a way to include that record in the print range. Any ideas? Thanks --Dan

Our company is upgrading to FMP 6.0 from 5.0. Can someone tell me if a database is upgraded or created in 6.0, can it be read in 5.0? I know when we went from 4.0 to 5.0 once the database was converted to 5.0 it could not be read in 4.0. Any information is greatly appreciated. Thank you

Hi, I am trying to use a script to perform a find on a number of records each with a creation date. In another Filemaker database i have two global fields (date) from and to, so i want to use these from and two fields to specify a date range in which to perform the find. i wanted to use: Enter Find mode Set Field (external::datefrom) & "..." & (external::dateto) Perform Find But i just get a ? in the creation date field. Any Ideas?

Hi there, now i have a system that have a customer database and invoice database. I need to add a aging function to the system that can process an aging report base on a customer. This report will write down how many invoice is given to the customer and which one is paid by customer. There will have a debit and credit column which state the amount of invoice and the payment made by customer. After that it will calculate the total amount that need to be paid by this customer. Is that got someone have some example of this type of aging report or script.

Is it possible in a db. that if you have several records in the db to change there order of entry around, like record 1-jim 2-joe 3-susan, I would like to chang this order if possible like 1-susan, 2-jim 3-joe. thanks

I must be missiong something... I run hundreds of scripts at night and inevitably I hit the max 50 databases open... SOOOO ... I fire off close such and such a database scripts in my master script... but maybe I'm blind BUT I just can't find a close all open databases command OR 'Close all but front' Vanna can I buy a clue? Fritz

I have an Employee database and 26 employees are also salesmen (designated as SALES in Employee Type field. I have created an Activity database which will track dates and customers contacted. I want to create the sales records ahead of time - at least one for each 'working' date for each salesperson. If sales contacts a customer, they would use the existing record and can create more, but if they don't use the one date record, I want it to display "no compensation" and if they have more than 6 sales calls that day, I want it to display "wage". If a salesperson doesn't perform at least one sales call, they don't get paid for that day; if they do 1-6, they get salary an…

Hi all, I am using Fm 5.5v2 I have a file that contains all workdays for all employees. in an earlier post i asked for help on getting unique employeeID for a date range. This would then give me a list of what staff worked on a given week. With that i can now "build" a time card with 7 days. OK so far!! Problem i need to solve is: the timecard (the company standard) requires that the Finish time of the last day of the previous week be written on the current time card. But i only want the previous end time if it is 56 hours or less from the 1st workday of the current week. Now that i've gone thru all kinds of looping and searching to eliminat…

My goal is to loop through some variables and set them to zero when a button is clicked. What I want is the FMP equivilent of: for (int i = 1, i < total_questions, i++) { g_questionNum [ i ] = 0; } I figured out that I can do Set Field [count = 0] Loop Exit Loop If [count = total_questions] Set Field [count, count + 1] *****This is where I have problems . I want to use Set Field [g_questionNum(count) = 0] but obviously that isn't working.************ End Loop I can set each question equal to 0 seperately but that's a waste of space and my time when I have 50+ questions on a questionnaire. (Not to mention carpel tunnel from…

Perhaps someone her can help me with an oddity... Every morning I run say... 12 'report' scripts (some with multi print copies via duplicating the print script set) This from fmp6 over a win 2000 network printer... Oddly, They don't run in order AND I even see 3 reports from script one AND the other 2 reports from script one later in stack. IT doesn't actually MIX one report into another... BUT just the copies OF the reports... anyone else terrorized by this? Fritz

Ok I hope you understand this question. I have a "due date" for something as a field, and I have a "completed date" field. I want if the due date is < completed date , print LATE. Is that possible?

Hello FM Fans! Here is another ? that I would rather ask before getting in too deep. The Goal: -Interactive/Custom dialog boxes that can be assigned to a script in the background - NO plugins please...I am trying to learn...not trying to test my spending power Why? u ask..well I have some users that are (they got the mouse part) rather confused with the FM interface...so to make their life easier and prevent error I would like them to use these "dialog boxes" (common confusion error eg. Form view to Enter data vs. Find) so how about it? anyone..... thank you all!

Hi all, Just a quick question Rather than using the menu item Application Preferences to change the Username I was hoping to set up a global field which when scripted would set the current username to whatever was in the global field. I cannot find the set CurrentUsername function anywhere, does anyone know a way to do this please? I'm on FM 6 on Win2K Thanks all Ed.

Greetings, I've been assigned a project, where I need to find duplicate customers and merge their info into one record. I am using 5.5v2. I took care of finding the duplicates without any problems. I created a new calculation field (DupCombo1), which combined the customers' street address and zipcode (those were the criteria I was told to use), then did a find with ! in the DupCombo1 field. What I need to do is merge some of the sales information (like total sales & year to date stuff) into one of the duplicate records, and delete the rest. For example, say a company has been placed in our database twice, because whoever ordered used the company name one time, …

is it possible to create a script that will export data to excel, AND automatically open it after it has been exported? currently i have a script that will export data from the fields into a comma seperated file. what i'm stuck on is getting filemaker to open up that file with excel. is that possible? thanks

I can manually set the auto-enter serial numbers to 001 and the placeholding zeros will remain. When I use the Set Next Serial Value script, it doesn't accept the placeholding zeros. Instead of 001 I end up with 1. Does anybody know of any way around this?

Hello, I was wondering if someone can help me. it is possible to build a database login system using fm v3. i know, it be done in latest one an seen sample like the gateway. I seen other one but they have function which are part of the lastest one. if anyone seen sample out there using fm v3 and doing scripting let me know. thanks, Victor

Hi, I am trying to call an activeX object within my FileMaker pro 5.5, can anyone give me a clue how to do this within FileMaker PRO 5.5. I am presuming that this is possible with parameters in the call. If not can somebody please give me some recommendation on how to call external applications or webservices. Thanks in advance, Michael P.S. can you please also send a email to my person email address on reply : [email protected]

I have a portal that lists out the related items the record of the particular database is related to. When they click on a record in the portal I want to bring to front the database that actually contains the records in the portal. So in my script I have: Go to Portal Row ["Summary_::recordID"] Perform Script ["Sub-scripts, External: "LettersInv_"] and the External Perform Script in the LettersInv_ table simply toggles the window to zoom and sets the zoom level to 100%. The problem is the record that is being shown is always the first one and not the actual record. This seems very simple and I can't seem to figure it out. Thanks.

Excuse my newbie ignorance-I have 3 FM files, all large, which I need to update once a week with an updated text file (new customer records etc). At the moment I manually do this-File/Import etc. I use Scriptmaker to automate the subtasks within this to quicken it up. Problem is each file takes about 2 hours to update and I'd like to be able to let the PC do this at 2am, 4am, 6am each week by itself. Do I need to write some sort of external batch file (ideas welcome :-)) or can it be done within FM? Thanks Sandy

Hi, I'm trying to set up what I thought was a simple script that imports from one file, does all the auto-enter calculations, and then opens a new file. The script works like this: Import ["File1.fp5"] Insert Text [select, "completed import","1"] Open ["File2.fp5"] Now here is my dilemma: The script works flawlessly but only when the checkbox is cleared for "Import auto-enter options while importing" If the auto-enter checkbox is checked the script will import the data correctly but will then open File2 which immediately closes and then reverts back to the original file within which the script is hosted. I assume that the script works f…

I have a FM db that creates medical claims for insurance and I need to create a duplicate claim while creating a new record #. My record # is calculated based on the date, time record ######-######-######. How can I duplicate the record but generate a new record #?

filemaker server 5.5 on linux windows 98, windows nt, windows xp, mac ox x fmpro 5.5 clients all photos jpeg I've been using the troi file plug-in to create an image database whereby i have imported over 4,000 photos from the linux server using windows xp fmpro 5.5 as client. Thus, I have the pathnames to all the image files saved in a field and the images are saved as a reference in a container. However, now I need to make the MAC see the images as well. For the longest time I couldn't even figure out how to insert images from the linux server to mac but with the help of a posting on the applescript forum I was able to figure that out. Is there …

Hi, I have a database that has 3 different date fields: received, initiated, and completed. Is there a way I can produce a report which has a count of all the requests received during a specified period, all the requests initiated during that specified period, and all the requests completed in that same period? Thanks, L

When you sendmail with outlook on Win xp... you get a snag in your script. "another program is trying to send mail..." - YOU can SAY YES and the mail will send BUT this blocks any script automation per say... Has ANYONE found a way around this or should I go with third part PIs like smtpit??? thanks Fritz

Hi, I just know the filemaker for few weeks and I need to make a quick database program for my company. Now I hit a problem. I want to do the function like shopping cart. User search the data in Portal 1 and select the record and record will copy to Portal 2 . I try to use setfield[] , but it only copies the data into first row. I want the data ADD into Portal 2 from Portal 1 instead of just replacing first row. Have anyone has any idea ? Thanks !! Henry

Everyone's 2 for 2 with my questions, so lets see if you can make it 3. Im figuring the answer to my question will involve a script, so I figured this is the place to post. Im looking to add a button to a page on a set of records for trying to cancel a record. Example follows: User will enter in information and there will be 2 buttons at the end. One is to accept a record (OK button) which will run a script to use the information in another file's field, or user can hit a second button (CANCEL button) which will basically cancel the input. This cancel part is the part Im having trouble with. I figured its gonna take something deleting the record that is currently ope…

Hi, I downloaded an FM example file and some of the fields have << fieldName >> on the various layouts. Anybody know why, what it does? Thanks --Dan

Does someone know how to use windows scheduled tasks to start a script in a filemaker file ? I need a good tutorial. I know there is a plug -in called events, but the company I work for decided to use windows scheduled tasks. Thanks

Hello, I wanto make menu items in Filemaker. They don't have to be part of the real menu bar, they just have to function like a menu bar. I basically just want a pop up menu that whatever you choose fires a script. What is the best way to do this? -EMC

I would like to make a check box that will allow me to make that record read only once the box is check. Can anyone please show me how Lostboyca

I am scripting a Find function that closes off all behind-the-scenes elements (in other words, the Status Bar is hidden, among other things). I want the users to be able to use the Omit feature as part of their search, but they can't see the checkbox in the status bar. Can I duplicate that box in some way, in the layout itself? Of course, it would have to work in Find mode. My only solution is to add a new text field and build some sub-scripts to mark it appropriately along with toggling the real Omit checkbox, but that seems large and unwieldy, and would not accommodate using Alt-O instead of clicking the correct button. Any ideas?

I have a system for a school, and I need to print a multi-column report sheet showing all pupils per class. I need to format the layout so that the pupils' names appear in three columns, but after the end of each class I have to go to single-column again to print a footer with sub-summary results showing end-to-end on the page. Then switch back into 3-columns and so on. If I simply define the report layout to be multi columnar, printing down then across, then the footers are limited in width and only occupy the width of one column. What I need is the pupils' names to appear in three columns, ie a class with only 3 pupils will print one line with three names on; a…

I have an administrative database from which I can open and close other databases by way of scripts. The way I currently have it set up is each database that is going to be accessible via admin.fp5 has a record in admin.fp5. I want to be able to have a single script that will open a file based on the contents of the field. For example: admin.fp5 contains the field DATABASE which is the name of the database to be administered so let's say records one and two in the db have the entries in the field DATABASE orders.fp5 and customers.fp5. I want to be able to have one script called OPEN and one called CLOSE. Running the script will open or close the datab…

I have a popup list called

Hi, I have a report layout on which i want to show several sub-summaries for different fields. For example i have a trailing sub-summary for Gender (3 options) and a sub summary part for Axis 1 disorders (several options). The problem i am having is when i go to preview it is separating the axis 1 and gender options and combining them. E,G, Instead of having: Gender 'Male' Count '2' Gender 'Female' Count '1' Axis 1 'Dementia' Count '1' Axis 1 'Substance abuse' Count '2' It gives me: Gender 'Male' Count '2' Axis 1 'Dementia' Count '1'…

I have a filed in my db. called message, i want to be able to court how many time a new message is entered. I need to be able to print a monthly report for each record with a total count in message field, and also to be able to reset the count to 0 when starting a new month. thanks

Hi, How one filed can be automatically populated with the value of the field from a record from another table? I think I can use a lookup but I

I am building a database for kitchen cabinets. Part of the description is context, ie, what is the adjacent condition on the left and right side of each cabinet. A cabinet can either terminate into another cabinet, terminate at a wall or have an exposed end panel. I would like to link an object ( colored rectangle) to the side of each cabinet and have this object change color based upon a selected value from the adjacent condition value list. Can anyone tell me how to accomplish this? Thanks.

Is it possible in fm5.5 that you can put a color in a field, that the color will only be for that field in that record. What i am trying to do is color code the name field in different records that does not put the color in all the records name field, just the ones i need. thans

I manage a small Fpro dbase for a nonprofit, and am have created fields to that "calculate" other fields so that, for instance, the address field will be one text field containing address&city&state&zip. I can set up and execute this script, no problem. However, my client does not want to click a button to perform the script, but rather wishes to have it force update through tabbing into a field, or some other hidden method. Suggestions? Solutions? Funky work-arounds? I could use some help urgently. Thanks!

Hello Gurus! Here is another of my ignorat posts .... I hope you can advise. The scenarion: -layout MAIN: has 3 fields (Field1, Field2,Field3) that will "take" some text. -Layout 1: is a tab based navigation but I would like to generate these tabes based on the content of the Fields 1-3 so: eg. (in some crazy theory) ----------theory -------------- Loop For as many fields (3 in this case) IF Field_1 is Empty THEN write nothing (don't create a tab on the Layout 1) ELSE Go to Layout 1 write/make a button- "tab with a label that = content of the Field_1" End Loop -------------------------------- so If I enter a text "Joe" in the field_1 …

I know I have done this before but it has been a while since I scripted anything and know I am going crazy trying to get this to work...here is what I am trying to do... I want to write a script that will find me only records that have no date in a certain field...unapproved records. and I want it to omit all the ones that are cancelled. I have tried numerous ways but it keeps omitting records with the same name and member numbers even though they are different records or it doesn't find them all just some. Like it will only find 35 out of the 50 that are actually unapproved. I had written it so that it would look at the unapproved field and omit any that were …

I have a field in a record (a "customer complaint handling form")that is in the second layout and must contain a value before the record can) be closed(or Archived) but this field might not be entered for months before closing (Archiving) the record. I need a script that will allow filemaker pro 6 to close without this field having a value, but the record (customer complaint form) cannot be closed (Archived) until this field contains a value. Is this possible and if so can someone give me an example script. Thank you for any help. Josh

I have a simple database that I'm using to keep track of photos I've taken and collected. All of the files are stored in the same directory with sequential serial numbers that match the record ID where the photo information is stored. I'm trying to expidite this logging process as much as possible, because I take far too many photos to click through the Insert Picture dialog everytime I want to insert a photo into my container field. I have a calculation field that displays that proper path to each photo. How would I go about automating the Insert Picture process using the data stored in the calculation field? I've tried a script that copies the contents of the calcu…

I guess this isn't a script but a formula question. I'm fairly new to Filemaker though so I am not sure. I need to write a formula for a shipping rate calculation based on weight. The starting rate for anythin 1 lb or under is $5.95. I need to add $.50 per additional lb over that. The following is what I have so far: If (ShipMethod = Ground and TotalWeight <= 1,5.95,If (ShipMethod = Ground and TotalWeight > 1,5.95 + .5)) I am stuck on the adding .50 per additional lb. Any help would be much appreciated. Thank you.

Hi all I have a form where i insert a sketch of a weld detail used in qualifying a welder. Everything works perfectly except went the operator picks the wrong weld detail. The operator picks the weld detail by value list. The joint details are storged in another db which has only one field define as a repeating global field. There are seven sketches. The value list is attached to another field. The container field is formatted as an unstorged auto-enter calculated value as follows: case(joint="Single bevel",get repetition joint:joint,1), (joint="Double bevel",get repetition joint:joint,2) and so on for the seven sketches. When the operator pickes a wrong desc…

Hi, I have a field called "ID" of type calculation. ID= GetField( "site" ) & "-" & GetField( "code" ) I noticed that ID's value doesn

hello- i would like to find a formula to determine all the zip codes in a radius. i have a database of zip codes and their GPS (lat/long) . i have these fields 'zipcode', latitude, longitude', zipcodesinRadius, RadiusMiles just trying to find out how this is done Thanks Dave

Hi, I have a table with a field called

Is there a way to store values in repeating fields using a variable index? All of the InsertXXX script steps require the me to put a constant index dictating the element of the field to insert into. I need FileMaker to decide at run time based on a value of a variable which element of the field to insert into. How do I do that? Thank you. -ilya

Anyone have an idea for inserting a linked OLE object from an existing file into a container field without a dialog box? I have a filemaker script that creates a new file in another application with a specific path and filename and I would like to insert that file as a linked OLE object into a container field. Right now I have the path and filename on the clipboard at the end of the script so the user can right-click the container field and insert the object through the dialog box by clicking 'from file', pasting the path and filename into the box and clicking the link checkbox. I would like to eliminate these steps and I need the object to be located in the path that I d…