The Left Brain

Once again, I am leaning on the forum to help me with a problem. I need to add a new field to my inventory database, that describes a costing category for each record. The categories are Raw1, Raw2, WIP1, WIP2, and FP. The categories are dependant on 3 other fields, Format, Status, and Supplier. For example, if a record denotes a product as being from Supplier "X", and it's Format is "Liquid", and it's Status is "Evaluated" then it is in Raw2. If it's Status was "To Be Evaluated", it would be in Raw2. There are 5 Costing Categories, each with a set of critera based on the three fields above. There is no overlap, meaning that none of the product could exist in two c…

I'm trying to automate a records export - from FMP 5 to Excel 97 - so that users can easily transfer information by means of a single button. I can do this with the 'Export' script step - but this leads me into problems with the destination file name. If a user is exporting data on a daily basis to the .slk file, I'll have to come up with a way of deleting the old file before creating the new (every day and for every user). I think a simpler way to achieve the result desired is to copy the data, then paste it into an Excel file (I think DDE should allow me to make a filename the product of a calculation; so I can make sure each file generated is unique). I wanted to h…

ok here goes... users enter username and password bringing them to a form allowing them to change information on their business record, which includes a unique account number(which is of course unmodifiyable).Is it possible to add a button to a new form in another database where the account number is is transferred from the first? ex. user enters and modifies a business record, from there i would like them to be able to enter their business events into another related database. is this possible on the web?

I am trying to figure out an IF calculation that will enter the amount of tax I need to charge in a certain territory. I was thinking that I could something like: IF Country (in thins case the US) = x then enter 0, and IF Country (Canada), and State = y,z (1 thru 9) then enter 7, and IF Country (Canada - maritimes), and State = y, z (10 thu 12) then enter 15 I am not sure how to script something like this in Filemaker, anyone out ther who can help me? Thanks...

I am a fairly new user to program. Moving over from Access. I have not found a way to mask or format a phone number automatically. Would like to type just numbers and have mask of (xxx) xxx-xxxx fill for me. How can I do this.

Thanks in advance to anyone who can help me with this problem: I am using FileMaker 4.1. I am setting up a videotape database with three types of categories, Masters, Show Reels, and Development Reels. I have a pop-up CATEGORY FIELD (text) for those three. I need to create a unique sequential serial number for each category; Masters starting at 100001, Show Reels at 200001, and Development Reels starting at 300001. I know that I need to create self-relationships to count the number of each separate category and add 1 to a serial number based on that. I have tried to use examples that I found from others on the web, but I just can't seem to get it right. Can anybody…

I have a sales summary report that is used in the following manner: In Browse mode they click on a button in the header labeled "Specify Search Criteria". This causes a script to run that puts them in Find mode and pauses. At this point the user can enter their search criteria for every field in the body of the report by selecting values off of pop-up lists attached to each field. I want this search criteria to be disaplyed in the header of the report when the report gets rendered so.......when the user clicks "Continue", the script copies this search criteria from these fields into a set of global fields displayed in the header using the Set command. Example: Set (Sal…

I've got 2 sets of name/address/phone fields in a db - one for callers, one for clients. A field with a value list describes the relationship of caller to client. Here's what I want: When "self" is chosen from the value list, I want (a script?) to copy/lookup or whatever caller's info into the client fields.

Is there anyway I can run a calculation which looks at a field and copies across the first letter of each word? In essence I have a field of names and I want to run a calc which will convert this into initials. Thanks

Hi, I'm trying to work out a way to display a list of how times a certain value is in a field. In essence I want to be able to display the data in a layout as follows: response A (no. times) response B (no. times) response C (no. times) response D (no. times) I'm looking for a way to calculate how many "A"s appear in field "response". Any suggestions? Thanks

Hi All, For our newsroom I wrote a 'planningsdatabase', containing all events happening in the world which are relevant for our radiostation. It all works flawless, and now I'm working on the archive-side of the system. I want to be able to keep the records/events which are expired, but not in the database our users can access at first. Due to the large amount of records, this will be slowing down the system to much. I tried to export all those expired records, but there is no 'append'-option, so every export has to go to it's own file. And that's not what I want, I'd like to have 1 archive-database. Is there a way to handle this problem, or does someone…

So here's my other question: I have a report that shows a subsummary with percentage of total count of names listed, utilizing Get(summary). I've read that this tremendously slows down fm due to calculations and is unreliable. Is this true? What is a better way to do the percentage? Thanks for your help. Jannah ------------------

hi- i'm wondering how i can solve the following problem: i have my database on the web, with it's main functionality being a search. i have one of the fields for each record set to be an image (a little icon). this icon is made linkable in my cdml: <A HREF="[FMP-Field: songlink]"><img src="[FMP-Image: speaker]""URL" BORDER=0></A> however not all records will need to have the icon, and therefore will not need to have a link. so, in fmpro, i've put a blank gif in that field for the records that don't need that linkable icon, and have left the url blank. the problem is, that when the records are pulled up on the web, the records that i've filled in…

Is there a way to create a menu of codes and code definitions next to each other in a menu that will allow the user to select the code without getting the definition as well? I am presently putting the code on one line and the definition on the line below it, This is clumsy. Access has this option. Any ideas? Thanks.

I have the following setup:

How can I convert a decimal to a percentage? I've got three fields, a summary field which totals all records, a field which checks how many of each option is checked in a value list and a third which calculates (checked / total) I get a correct decimal such as .25 if 4 of 20 are checked but how can I make FileMaker display this as 25%. And if I get an odd decimal such as .05 which should be 5%. Or if I could display the percentage as 25.0 or 5.5 for 5.5% either would be great. Any help appreciated. Rich ------------------ Rich

I am trying to automate an export function via script steps. After record are exported to Excel, an e-mail is dispatched telling users that the latest edition of the file is ready for review. I can handle all this. The thing I can't do is take the next step and fully automate the process (I want this cycle to run once or twice a week without any human intervention). I've encountered a problem: the script freezes when the file exports to an Excel directory because the filename already exists. Should I go the DDE route (and have the script queue a command that goes to the Excel directory and deletes the previous file prior to running the script that generates the curren…

Hi I'm fairly new to FM, though I do have some programming experience. I'm working in FM5. I'm trying to create a db that tracks different kinds of art in text books. Here's what I would like to happen: A user creates a new record (for a new art) and indicates the type of art (Figure, Photo, Table, etc.) and the chapter in which it falls. From that information, the db should be able to calculate and suggest an art number. For example, the first photo in chapter 1 would be assigned the art number P01-01; the first table would be assigned T01-01, etc. I can get the T01- part okay, but I can't get the db to find the highest value in the serial number field and add 1 to i…

I use the following calc field for age: NumToText(Year(Today) - Year(dob)- Case(Today< Date(Month(dob), Day(dob), Year(Today)), 1, 0)) & "/ " & NumToText(Mod(Month(Today) - Month(dob) + 12 - Case(Day(Today) < Day(dob), 1, 0), 12)) It works beautifully except for one thing, until the user enters dob, the calc field shows a nonsense year that is distracting. I understand the concept of "not IsEmpty" but since I didn't write the calculation I'm using, I hesitate to play around with it for fear of ending up with a mess that no longer calculates rather than the ideal situation where the age field waits for all relevant data before displaying. Can anyo…

Hey Folks, I have a tech support database that contains a Follow Up Date field. A small script searches for any follow-ups that need to be done on that day when a tech opens the database in the morning. The Follow Up Date field is a calc. based on the Date Created field. It looks like: Follow Up Date = If (Follow Up Required = "Yes", Date Created + 7, "N/A") The result is set to "Date" and it works great. But now the techs have asked that I make that field modifyable, so that they can change it if they can't get a hold of the client on that day, or the client says "Call me back next week." or whatever. For the life of me, I can't make this field both Auto-enter…

Hello, I am writing an inventory database where I need to have a running total summary based upon several variables. I am able to do a running total summary with no problem, and I can do the variables calculation too, but how do I perform both simutaineously? The field definitons don't seem to allow both a summary and calculation at the same time. Any info would be greatly appreciated! Thanks, Tom Bardenwerper [email protected]

you know how in internet explorer you start to type something you've typed before and the computer automatically fills in the word for you. how do you do that in filemaker pro? sincerely, brian

After a few years away from development, I'm doing pretty good with FMP (and really, really love fmforums!) but I wish I'd saved my textbooks on database design. I have FileMaker Pro-specific books. Would y'all kindly recommend your current favourite database design book(s), not FMP specific? Much appreciation. And keep up the good work! What a great community. Regards, Kay.

How could I create a database that allowed me to keep track of an IP Network. I want to create a database of IP addresses that demonstrate which is in use and which is available for use and I would like for IP's in use to not be listed in the available fields automaticallly. Thanks

I'm having problems getting data from one file to show up in another file based on a calculation. I have the following 4 files; Inventory Customers Invoice LineItem I need to be able to provide custom price based on my customers. My products(inventory) is compose of 9 different item number ranges each with 7 different size. Example: 1000 to 1999 is one range with 7 sizes. The next range is 2000 to 2999 with 7 different sizes. All the way to 9000. Ecah range and size has a special price based on customer. I created the following fields in the Customer file. Each field contains the price. For the 1000/1999 range the following are the fields for the 7 sizes, c…

I need to add 450 fields into a new FMP file. I set up a Excel spreadsheet but it won't let me transpose that many rows. It doesn't have enough Columns. Why doesn't FMP. Allow first column as field names?

Hello all! Does anyone know how to build an FM application for sports league administration? Thanx! Gipe

I need to click on a button inside of FMP 5 that opens a PDF file. How can I do this? The open file script only opens FMP documents. Thanks!

Does anyone know where I can find an auto exec program that I can install into my burned CDs (for Windows) that will open the CD so that I will not have to click on the computer's CD drive to open the disk? I will use this in my distributed runtime programs for Windows. Thanks.

I need help finding a way to track the amount of time a technician spends on each customer issue. the issues are separate record in a FP5 dbase. normally, I would just use start/end time field and calculate the difference, but the techs often revisit a case two or three times. Having the dbase track the time automatically would be a huge asset. I evisioned something like a count-up timer with a "Pause" command that the tech coul hit when he was not working on the file. Any ideas would be great. Thanks in advance to all who respond.

Yes, do a find on a date range. Enter find mode on a layout the contains the maintenance expire date and enter into that field (for the next 3 months 10/12/2000...1/12/2001. This should find all records that will expire in the next 3 months. HTH

I have two files. Invoices and Items. In the Items file I have a the following calculations... subtotal = price * qty extras_subtotal = extra * qty final subtotal = subtotal + extras_subtotal In the Invoices file I have the following calculations... net = Sum(items::final subtotal) sales tax = net* .5 final total = net + sales tax +shipping The calculations in the invoice file don't show up until I click in the field and then exit the field. Questions: Am I doing something wrong? If so, what would you suggest as an altenate method? Thanks, Graham Sprague [This message has been edited by spragueg (edited August 24, 2000).]

OK, here's my situation: Here is what my database looks like: Product List (filename) product ID (field) price (field) Order Form (filename) product ID (field) price (field) quantity (field) The two files are related by product ID. I have set up a calculation in the price field of the order form that looks like this: price = case(quantity < 25 , Product List: :price , quantity >25 , Product List: :price - 2, 0) Essentially what I need to be able to do is pull a price into the Order Form from the Product List according to the Product ID. I would then like to be able to change the value of Price in the Order Form according to the value of Quantity…

I'm trying to eliminate the quotes " (double) in a text field by writing a formula that searches for them and does a substitute. Here's the problem: Substitute(short_description, "*"*", "") Obviously that won't work. Any clues? TIA!! -zack

Can a record internally track the number of times it has been veiwed without the use of scripts??? Any insight would be greatly appreciated. Thank you, I.M.

I have created an attendance report program which imports student names into the attendance file on a daily basis, and enters today's date into the date field. From this daily updated list, teachers check the student present or absent. My formula to enter today' date into 100 plus date fields is: Go to Layout (attendance) Loop Go to Field (date) if(date=0) Insert current date (date) Go to ecord request/Page (next) Exit Loop if (Date=1) End if End Loop ___________ This formula enters all the dates into the empty date fields, but does not exit by itself. I have to press escape to stop the formula from working. What am I …

Can anyone describe the steps to be taken to export data to an excell spreadsheet? Or can someone direct me to a simple step by step descritpion of this process. The help menu does not help me. Thanks.

Is there a simple way to delete all records from a multiple file relational db without having to run the same script, individually, in each file?

This is the problem. I need to display a field from the last accessed record, regardless of time, at the beginning of the web browsing experience. I have no problem with this extraction in Filemaker Pro. The real issue is the web aspect. I cannot get the browser to pull up the working information that I need initially. The only way it works is if the user makes an entry to the database and then the calculations I have set up pass the appropriate information to the next page as a token. When a new browsing session is started up, no token can be passed because no entry has been made yet. I thought that maybe that this could be solved with CDML tags. To my knowle…

I was trying to follow the phone number scripting in email 6/6 ( left Brain re: phone number formating ). It worked when the fields are not in a portal. When I put the Phone_cal field and the phone text field in the portal it only allows me to put in a record. When I go into the netx phone record, it says" field is not modifiable". Also, the appearance of the format were not consistent, the brackets and dashes disappear, and I have to click a few times to have them show up again. What's wrong here?

I'm not sure this subject belongs in The left brain. Then again: it's mindboggling to me, so I'll give it a try. I need to be able to search in surnames, so I made a relation between Person and Projects. This works fine, but obviously there are more people with the same surname. So I made a portal to show them all. And this works fine two. But how do I select the right person from the portal? I believe I need to do this with a script. I tried Set Field, but the data does not appear in the fields I tried to set it to. Is this because these are related fields? Could anyone outthere help me out on this?: Thanks ------------------ Yeti

I would like to search for records in multiple databases, and have the results from all the different databases displayed in one porthole. Any Ideas!

I needed a calc field that determines a student's age in yrs. & months as of December 1 of the current school year. I managed it in 3 fields: half yr = (MiddleWords(cur sch yr, 1, 1)) followed by dec.1 = Date(12, 1, half yr) followed by age 12.1 = NumToText(Year(dec 1) - Year(dob) - Case(dec 1< Date(Month(dob), Day(dob), Year(dec 1)), 1, 0)) & "/ " & NumToText(Mod(Month(dec 1) - Month(dob) + 12 - Case(Day(dec 1) < Day(dob), 1, 0), 12)). My problem is, the "age 12.1" calc field currently yields an entry of 2000/0 as soon as I enter data in the current school year field. It registers correctly as soon as the student's dob is entered but the ap…

I am creating a Customer Followup database that generates future contact dates for salespersons based on a single Start Date. From the Start Date, we calculate 21 days, 3 months, 6 months, 12 months, 18 months, 24 months, etc. to get the future contact dates. How do I ensure that the calculated future dates do not fall on a Saturday or Sunday (when the salespersons are not in the office)? Sample: Date NP Start + 180

How can I calculate and show the age of charges on billing statements? I. e., the amount due that is less than 30 days old, over 30 days but less than 60 days, 60 to 90 day, and over 90 days. ------------------ angelo

I have created a script which has about 60 Find Requests to look for any instances of a certain date (Today - //). This works fine, but it would be ideal if the user could input the date to be looked for - my script only works with "today". How can I let the user enter yesterday's date or another date and then have that script run all of those Find Requests?

trying to create a database that will auto enter info which has already been entered before relating to an id number. after typing in id number want all other info to be auto entered based on that id # also a running calculation for that id # of how much time was spent on that project for each of the projects assigned for that id # any suggestions

I want to export one record at a time and name the exported file based on a field value. Anybody know if I can do this? Thanks,

Here's my challenge. I work for a travel agency and we are creating a system for looking up the lowest cruise fare pricing. The pricing table I have created has these fields: SailDateID, Category, Price (I'm oversimplifying, but these fields are involved in my challenge) What I need to do is identify the lowest price per saildate per category. What I've done that works is this: I created a calculation field called "SailDateIDCat" as follows: SailDateID & "-" & "Category" which returns, for example, "34-AA", "34-AB", etc. (It's likely that more than one record will exist for each category as multiple promotions can apply to each category.) Anyway, I …

I would like to be able to filter out records in a portal so that only records which fit a certain criteria appear. On a layout I need to have two portals displaying information from the same database. One portal needs to display records with a creation date prior to a given date (this is not fixed like today's date or something like this but is determined by the user) and those which were created on that date. I'm not to sure how to do this. I've figured out how to display the ones which were created on that date by creating a global field which combines the master records ID with the date and relating the portal on this. Can I do something similar for the other…

quote: Originally posted by dianamosca: What is the best method for displaying the sysem date or current date in a report header in FileMakerPro 3.0 v6 (Windows)? The date field appears in the header of the layout. The date should represent the date the report is published such as the current or system date. We are not sure how to set this. We have tried to manually enter the date. But this has failed. Use the Paste Special on the Edit menu to insert the date symbol "//" onto your layout. You can then format this however you want. This will display the current system date. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant D…

I'm still new to FMPro. I'm currently using ver 4.1 & still deliberating upgrading to 5. Anyhow my problem is like this: In each record there would be 3 fields: ( for example ) Field A : 20 Field B : 30 Field C : 50 (calc field) For the next record, I want to bring forward the calculated Field with value 50 into Field B as an opening balance. So the next record would be like this : Field A : 35 Field B : 50 (brought froward from 1st record ) Field C : 85 (calc field) Sound very simple to do but so far, actually being more than 3 weeks, but I'm still lost. Please help me. TIA.

I'm looking for a plug-in that allows Filemaker to calculate or recognize video time code. ie- 30frames= 1 second in the format hours:minutes:seconds:frames. I heard a rumor that it existed, has anyone else come across this?

Hi, This is my first posting and hope that you guys can help me. My knowledge of FM is reasonable but not at a professional level - I think! I am building a database to take bookings for a theatre that I am involved with (London's famous 'Magic Circle'). The database will store information about the various magic shows and register customers bookings. I envisage so far using three databases. One to store information about the shows (title, curtain up, show finish, artistes, ticket prices, etc); one database to store information about the bookers or customers (can also hold credit card/payment details); the other database will show the seating plan of the theatre (onl…

I am going to create a series of staff access codes (initials and a number series, eg. MC123, RS754, etc.) in each record, By requiring a find command, each staff member will be able to pull up only their records ensuring confidentiality for the other records. To achieve this, I must require the user to request an exact match of the acces code. This is usually accoplished by preceding the find request with two equal signs (==). Does any one know how I can script the find or set up the find to require an exact match. Or does anoyone have a better idea for encrypting each record to the staff member responsible? Thanks for your ideas.

Help! I have an ordering program that I am having trouble with in regard to creating reports. Each order sometimes contains a backorder. These are contained in one record. The order has an Order Number and the backorder has an Order Number as well (separate field). I want to create a report that will compile the order and backorder amounts by ship date and give a total. Because the order and backorder are in one record I'm not sure what to do. To compound the problem, the reports are done by month, and sometimes the ship dates for orders and backorders are different. Any help or suggestions is most welcome!! Thank you!!

Is there a way to search for and highlight particular text in a text field?

I haven't given this problem a shot yet because it doesn't appear until my next solution that i'll be working on, but it may be soon. I need a field to trigger the "creation" or the illusion of creation of a specific amount of fileds. For example, FIELD_A asks "How many different names will be ordered?" If answer is, three, then i will need three following questions (fields) such as "Qnty for name 1?", "Qnty for name 2?", "Qnty for name 3?" I need as many "Qnty?" questions as specified by FIELD_A. Another problem, this is a solution done as a thread,(only one question per layout, depending on the question go to next layout). So, ideally i would need each qnty fiel…

Sorry for the double post. I have two files. Invoices and Items. In the Items file I have a the following calculations... subtotal = price * qty extras_subtotal = extra * qty final subtotal = subtotal + extras_subtotal In the Invoices file I have the following calculations... net = Sum(items::final subtotal) sales tax = net* .5 final total = net + sales tax +shipping The calculations in the invoice file don't show up until I click in the field and then exit the field. Questions: Am I doing something wrong? If so, what would you suggest as an altenate method? Thanks, Graham Sprague [This message has been edited by spragueg (edited August 24, 2000).…

I want to calculate a date - for instance - date A + 180 = date B. Date B then appears as a serial number. I can use Date to Text to format it as date, but then I cannot find dates in the calculated field using a date range search. I want to be able to calculate the date as above, to search for a date range against the calculated field, and to be able to override the calculated date with a different date. Any thoughts.

I have a database which calculates times for a motor race. The unique fields are passing time and car no. I calculate everything from these. Some calculations (eg time between two cars) I do by subtracting a value in the current record (eg passing time) from its value in the previous record. What's the best way to do this? Can I use the "AutoEnter from Last Record" feature? I'm importing 100 records at a time, so I'm not creating new records here. What I've done for now is to write a script that works through all the records and cuts and pastes values from one record to the next. This works well and gives correct results. However, I would like to speed it up. For a 2 h…

I want to enter a date, add a set number of days, and produce another date. The second date must be searchable as a date. When I have tried this I have received a date serial that I have not figured how to convert back to a searchable date. I have used the date to text function and received acceptable formating, but then the date range search does not work as it is text (or the underlying serial.) Example: 4/7/00 is date A. Add seven days and get 4/14/00 in the second datefield. I can now search the second date field as a date. How do I do this.

I am having a problem with a button that I have made for a new screen. On other screen I used the step: Go to Layout [original layout] after performing short calculation or such things. Yet now I am trying to use this step again and having problems. When I try to select this step from the pull-down menu of layouts, it is no longer there. The menu moves directly from last layout to 'layout number from field'. There is a space where 'original layout' used to be but if I click there it is still chooses 'layout number from field'. I am wondering if I have accidently chosen some other step or mode that precludes use of this step. Perhaps this is why it is no longer …

I am currently running FMPro5 Server Mac. on OS9 (Server). 3 LocalTerminals (Mac OS 8.6) 1 Local Terminal (W98. We Have 2 Clients which connect to D.Bases Via Remote access (Mac). My Problem is that From home I am running W98 and running FMPro 5(W98) and I cannot log on to the host. I am using PCMaclan 7.2 and I can see shared files on Mac server but when I try to access databases I get nothing. I am able to log on to server using dial-up with server IP Address set at 192.168.0.1 (SNM)255.255.255.0.. All terminals are set sequentially with the exception of Mac Client used to check e-mail, which is connecting via Apple talk. When I attemt to access host from home (…

I am trying to configure a layout for letters (correspondence). Is it possible to place a large text field and have merge fields (for name and address of addressee) within it that move up or down with returns

How do I configure a calc that will automatically insert dashes in telephone numbers when only the numbers are entered. I have downloaded tech support instructions - but keep getting circular reference response. How do I get the calc to enter the result in the same field I am configuring the result for? Thanks for any assistance

I have created a layout with several fields defined as check box value lists. Each having at least 6 boxes. What I want to do is display to the user only those values(boxes) that have been checked and not the whole list. Is there a script or solution around? I searched the scriptology and FMP5 Bible and can't seem to find a solution.. Thanks,

Each day I track System Task start and end times, as well as keep notes in a text field. I need to find an efficient way to deliver these times and notes to those interested every morning. The obvious option would be to have a script that would update a web page to point to yesterdays records at 07:00 every morning. Is this possible? Another option would be to have a send-mail script on each days layout, which creates an email containing the notes in the body, and a link to a document containing the times(since FM only allows the entry of one field). But here again I run into the problem of udating the link to the records I want to show, which are always yest…

I'm having difficulty scripting a solution that takes a "Months" field: Jan-Dec , copying the first choice: "Jan" pasting into a field, and then moving on so forth via loop until all choices are exhausted. Help would be appreciated. I have it scripted already and feel one step is not written properly. Thanks.

I have 3 related files: (1) Projects, (2) Elements (which are the deliverables for each project), and (3) Tasks (which are the things that have to be done to accomplish each element). To capture last-modified info, I am defining the following fields in each file: LastModDate = Auto-Enter Modification Date LastModTime = Auto-Enter Modification Time LastModUser = Auto-Enter Modifier User To capture true last-modified info in the Elements file, I am then: LastModDateAll = If(LastModDate>Max(Tasks::LastModDate), LastModDate, Max(Tasks::LastModDate)) so that it also considers modification in the related Tasks records... and using similar logic for the last time…

Is there anyway to send mail from FMP without having to use an external mail program? Thanks, Anita

First of all- Thanks to everyone who helped with my last problem back in May. Rude of me not to say earlier, I know, but... Anyway, I have a bound product catalogue soloution of all my products, specs, and prices for a specific customer. They run Win NT and want certain departments to have access to it from their server.-BANG- filemaker stopped 'free' networking of bound solutions with FMP5 and Server 5!! okay, we can run directly from the cd I supply- this much I know works well-- PROBLEM is - How do I prevent unauthorised access to the contents i.e. if my competitors got hold of the cd and password...... QUESTION: Can I write a script that automatically interoga…

Is there a way to execute a FileMaker Pro script from outside Filemaker such as using VB or Access ? Thanks.

When I select "import Records for a script, the process defaults to "view by Last Order," when what I need is "View by Matching Names." Is there a way to solve this problem. Thanks. ------------------ Bob Sherman [email protected]

I have created three fields and use the calculations that give me a persons age by year, by month and by day based on the date of birth I type in to the DOB field. This calculation (I assume) works off the computer's internal settings. What I now need to create are the calculations for a year, month and day age field that is based on a future date that I type in. For example, I know how old I am today, but how old will I be on November 11, 2005. Thanks for your help

Hi, I am new to Filemaker and to programming in general. I am trying to define a very complex field and my brain is fried...hope somebody can help figure this out. I have a database containing serial measurements of a pulmonary function test called FEV1, for a number of subjects defined by medical record number "MRN". The layout looks, in part, like this: MRN (text, unique for each subject) PFT number (auto-entered, unique for each FEV1 measurement) Date FEV1 (number) Each subject has a variable number of FEV1 measurements in the database. I would like to define a new variable called BOS score. Here are the rules for defining BOS score: 1. Determine the base…

I dropped an Excel file into filemaker pro 5. It created two fields. The file containes 452 records. How can I display in layout and browse mode certain records? For instance I would like to use the first 12 records in a particular calculation. How do I show those 12 on a layout and subsequently use them for calculations? OR Should I create 542 fields to read in the records. They are all unique and used in quotes for pricing. Thanks, Jim

I have created three fields and use the calculations that give me a persons age by year, by month and by day based on the date of birth I type in to the DOB field. This calculation (I assume) works off the computer's internal settings. What I now need to create are the calculations for a year, month and day age field that is not on a future date that I type in. For example, I know how old I am today, but how old will I be on November 11, 2005. Thanks for your help

quote: Originally posted by GarrettD78: I have two databases that I am trying to sum up. One has the summary field and in that table it works fine. But in the relational table where the report is, I simply put that summary into a sub-summary when sorted by a field. This does work on the first page of the report. I get the correct numbers on everything, but on the next pages I loose this field. The computer quits printing this field. What do I do? You cannot use summary fields on related fields or summary fields from related files. This is just not possible. In general reports need to be in the same file as the data that they are summarizing. I am sure tha…

I'm composing a leaderboard for a motor race. This will be published live on the web, as the race happens. My source data consists of 2 fields. I process this to produce 9 fields (laptime, position etc). For a completed race, processing takes 2 minutes (even on a Powerbook G3/400). Obviously this is shorter for the beginning of the race, when there is less data to process. Raw data comes from transponders on the cars. This is exported from a decoder as comma-delimited text. It gives me the "passing time" past the decoder every lap. I can do a "grab" for the data at any time, but it will only export data for the whole race. At present I am replacing all my data every ti…

First off, calculation may not be the answer but this is what I'm trying to do. I would like to set a field ("approved date" field) with the date when certain criteria are met in another field ("approval" field). I've created an "approval" field which has been formatted with a checkbox value list. Once all of the boxes have been checked, I would like to add the date that it occured in my "approved date" field. I'm assuming this should be simple but I'm stumped. I've only managed to create a calculation that adds todays date in "approval date" but it always shows the current date, not a fixed date when the criteria was met. Any help would be appreciated.

I have another question. I would like to know how is the most simple way to make a button that allow me to narrow a previous find. I want to make first the find and then take the information from found set and perform find only on this. Is the best way to do this for the button to automatically paste previous find information and give the interface to add to find? I hope I make the question clear. Thank you very much for any help. ------------------ Mikhail Petrovich Vimov

Hi all, I have recently set-up a layout where I have a portal that filters out only portal rows that have a purchase order number or a purchase order number recieved value. This causes me to have a relationship to filter out this data. This is fine and it works great. Now I would like to fix those portals. I have successfully done that as well. But by doing that you need another relationship. My question is can you set-up a portal to have 2 relationships? I would like to have fixed and filtered portals. If anybody has any ideas please help! I'm open to changing my design as well. Thank you to everyone. ------------------ Ryan [email protected]

I have a loan form where there are five separate fields to fill in the loan item information (because they can loan up to 5 itmes). I would like to be able to show the history of the item by doing a search and then displaying it as a columnar report, but how would i go about searching for that one item so that it would find all the records with the item in any one of the five fields? Thanks, Anita

we're trying to figure out how to callup the dialup networking in win9x from filemaker to get online and email us some db info, does anyone know if this is possible,thanks, scott

I would like to create user names that simply takes the user's first and last name and put them together. My problem is, if there are duplicate names, I would like the field to automatically calculate it so that it ends up being FirstLast2, FirstLast3 etc... How would I go about doing that? Thanks, Anita

I need to create a formula that calculates a 7 day average for the month. That is the total of the first seven days 1-7 then 2-8, 3-9, etc. Can anyone help me?

Hope this isn't too much to ask, but can't you put hyperlinks into a FileMaker Pro database? Is there a work-around? I just want to point to local HTML documents and PDF documents that will reside in the same directory as the FileMaker document. To see an example of what I'd like to have see: http://www.fatdisc.com/filemaker/sample.jpg This needs to be Macintosh and Windows. Many thanks to whomever can provide an elegant solution. -pete

need to find a way of dividing a single two or three line text field into separate fields on the points of the returns: "divide this field with two lines" into two fields, one with "divide this field" and one with "with two lines". These are not fixed word or character lengths, so I need to find the returns to break it up. Any thoughts, FMP wizards?

I've put together a 'discussions' db to keep track of talks I have with various co-workers etc. I've setup 4 sets of fields of first names, last names, extensions & emails. I'm using lookups to fill in the first names, emails and extensions, once the last names are added, and the last names are in a pulldown from another username db. That all works fine, *but* what I'd *like* to do now, is to search all lastname fields with without having to fill 4 find records. I'm trying to write a script that goes to find mode, lets me fill in a last name, and then automaticlly creates 3 additional find requests duplicating the given lastname into the additional fields of la…

I have two layouts in the same file and I would like to set a different sort order for each layout, but it does not appear to be possible. Is there a script command that allows one to set the sort order? Any suggestions?

FM and printer Star SP200 works fine but i can

I've got an interesting problem. Here's the setup. FMP 4.0v2, G3 Mac/os 9 I've got a database that tracks the different services provided by various vendors (we use this to publish a directory). Each category (Photographers, Graphic Designers, Printers, etc) has anywhere from 15 to 60 items (that are yes/no) identifing what specific services they provide. Here's the problem. I want to create a list of each one of the vendors that performs a specific service (this is to go on the web, I've already got the printed solution down)... In other words, I want a list of all of the Photographers that handle digital photography, and then another list of folks that annual report…

I'm using FM Pro 4.0v3 on a Mac (though the answer to this shouldn't necessarily be platform specific). Here's the scenario: My file has about 10k records. I'm in List View with about eight fields running horizontally across. In the Header I've a tricky button labeled "Find" which (duh) enters "Find Mode." It's tricky because, once in Find Mode, it changes itself to "New Find" and enables me to make multiple search requests before I hit Enter to perform the Find. When I've made a search and have a Found Set, I click on a scripted button which prints out the results via a different (unseen) print-only layout (b&w, optimized for size, smaller font, etc.)... so far,…

Have been trying to use the Send Mail script step in FMP5 on an iMac which uses Outlook Express, and although the Goto URL step works fine with MS IE, Outlook does nothing when the Send Mail command is issued by FileMaker. I've made this work on PC before, but never managed to on a Mac yet... What could be wrong? What?

i am creating a database for the sale of a land development. I want to create a layout that will display the status of the individual units in a map of a site plan. Any ideas?::?:????

i am creating a database for the sale of a land development. I want to create a layout that will display the status of the individual units in a map of a site plan. Any ideas?::?:????

I am trying to design a database to provide me some sales comparison feedback on four restaurants I own. I have four years worth of daily sales for my four stores. I

Does any one know if this is duable? I have 4 FileMaker db's 1)Invoice 2)LineItem 3)Inventory 4)Customer Items in the inventory db contain products that come in 3 different sizes. Problem The price on the items I sell are different for each customer. I'm attempting to have the invoice automatically give the correct price base on the customer. Any ideas??

I need to create a job schedule. I am given a final delivery date and have to count backwards 8 working day, then 4 working days, then 6 working days...blah, blah, blah. Any ideas?