The Left Brain

I would like to create a calculated field that can give me the date for day 10 searching through the related records. Example: Jon Doe has worked for 20 days. There are several records that have a start date and a stope date. Let's say that record one has a start date of 1/1/02 and a stop date of 1/5/02. This gives me 5 days worked. The next record has a start date of 3/1/02 and a stop date of 3/15/02 giving me 15 days worked for a grand total of 20 days worked. The calculated field would need to return a date of 3/5/02; day number 10 of the 20 days worked. Any help would be appreciated.

Here's an interesting problem. I have a calendar I made from scratch in Filemaker 5.5 . The calendar has 37 spaces named day1 to day37 (in case the 1st on a month with 31 days lands on a Saturday). All of the days adjust fine in the calendar except March 1st 2004 (a leap year) and 2009 which are supposed to appear in the box after the 28th. March 1st 2004 lands on a Monday (because of the leap year) and March 1st 2009 lands on a Sunday. The formula is for the day of March 1st. I also in the formula have the variable day1a and dayofweek1. day1a is used to convert the date in the form mm/dd/yyyy (variable day1) to a single day by the formula day1=1 and put the d…

I need to create a Employee Holiday board in FileMaker. At the moment it's set out like Microsoft Entourage (Calendar view). It needs to contain traps so if people from the same group clash, a message will appear!! I have had no luck anywhere. Is this possible to achieve and if so HOW!!! Are there any sites I can go to???

I have a script that will import a mass number of records(400-500), included in the scripts are loops and Calcs. This will take a long time on a low spec System. Are there any tips someone could give me for speeding up a script. I know the obvious ones (Reduce number of records, run import more often etc).

Use global fields for the prefs -- that way, they work with all records. Heck, they keep their values even if you delete all the records.

I have two fields. When an item is selected from field 'A' and autofill calc is applied to field 'B' but when I go back and change 'A' , field 'B' remains the same. - Help

What is the script?

Put a non-printing button in the header to go to record/request first. You can also put buttons to go to next, previous, last etc.

Is there a way to lock a field after an entry has been made? Actually, what I really want to know is if the field can be locked and unlocked based on the contents of a separate field? Does that make sense? Thanks Ken

Is there a way to determine which portal is active, when there are multiple portals on a layout?

Is there a way to close related files only if they're hidden? I've got seven database files that are related in various ways. If I close one of the main files, say file A, I want it to close the rest of the files so they're not left hanging open in the background. However, if I also have one of the other main files, say file B, open and _not_ hidden, I'd like that to stay open when I close file A and close any of the other 5 files that are not hidden.

Can I move fields I've created in one database to another database? I appreciate the help!

Greetings... I'm searching for directions in translating numeric money amounts into spanish text: $250 = doscientos cincuenta Any help would be appreciated!

Is it possible to have a calculation initiate a script?

I need to have text change to either blue or red depending on if a task is past due (red) or due today (blue) Stumped...

I have a database that tracks work during the day. When a job is started, the time is inputted into the time field, each job is allocated x amount of time. My problem is, that becuase the Database is in real time, if I start a job at 4 o clock and leave at 5, the time through the night would be recorded. It's unreliable to make people click a pause or stop button??

I need a small popup calendar or one that can be inserted directly into a layout. Any simple ones out there> Thanks! Michael

I have a date field and I want to create a script that returns all records that contain "today's date" and all dates prior. I appreciate your help! Michael

Use a layout that *looks* like the pop-up message.

Can I remove the separating lines in the portal? cuz im using it to print some records and I dont want to waste more INK

Hey guys! I had a script step that I want to set a field to the date a year from now. I made it look like this: If [ PatternCount("Certain Field", "12 Month Contact")] Set Field [status(CurrentDate) + 360] Else Set Field ["Certain Field", "select"] It won't work. The date that shows up is only one month from now, not 1 year. I have similar steps for finding dates that are 2,3,4,5 and 6 months from now, and they all work fine. Its just the year one that won't work. Any Ideas? Thanks, Ken

Hi. We've created a database containing customer contacts and notes about those contacts such as when last contacted and when to next contact. Anyone know of where I can find some plug-in which alerts the user on a specified date to call their customer back? I've found many calender pop up plug-ins but none of these seem to have a call management feature. Yours hopefully, SG.

Hello Can someone help with what should be a simple calculation? I sell material by the square foot. Any amount greater than a whole number needs to be rounded up to the next whole number. If the result is 10.1 I need the result to be 11. Thanks alot.

Hello Everyone: I have a little experience in scripting, but I am not to good at calculations, and what functions to use. Here's my problem: Basically, I am trying to set a field to a certain date based on a radio button that is clicked. I have a value list field with 7 values in it. They are: 2 Month Contact 3 Month Contact 4 Month Contact 5 Month Contact 6 Month Contact 9 Month Contact 12 Month Contact Then I have a date field called Projected Contact Date. If the 2 Month Contact button is clicked today, I want the Projected Contact Date field to read March 25, 2002. I also would like the same action to happen if the other radio buttons are clicked (e…

hi everyone, ok i have created a solution that keeps track of our sales reps daily amounts. it will be a summary of the week. on monday afternoon i want it to start over, a count of 0. i also would like to paste the the final total into a field. the big question is can i automate it? Peter. i have taken a course in cdml and i just realized how easy it is!!!

To all that help, I have a field labelled "Qty" which serves two purposes based on the selection in a field called "Code" if the field "Code" is Time then the total will be "Qty" multiplied by the "Labourrate" field to give me a total. If I select Material the total wil be "Qty" multipled by "ItemValue". My problem is this I need to show a summary of Hours but because the Qty field is used for Time and Material I need to some how only total those in the "Code" Time. Any ideas folks??

i have a cloth inventory file im working on, and we need to report consignment to our suppliers, but i need to find only the pieces the lay within the first day(sunday) of the third week in the previous month to the last day(saturday) in the second week of the current month. confusion help me! -Snuggster [ January 18, 2002: Message edited by: snuggster ]

Two related files, call 'em Master & Related. For aesthetic reasons, I'm hiding and locking the status bar. Problem is that when viewing the portal in the Master file, the Related file opens hidden -- without running the preset "Open" script. As a result, the user can click on the Windows menu and open the Related file ... and see the status bar. I can employ a "Close" script on the Related file that hides & locks the status bar, but it unlocks when it reopens as a hidden file. Any way to ensure that it stays locked away?

Here's what i need; Simply Stated: A Shopping Cart, Internal to Filemaker (no web is necessary) for mulitple customers with items being customer specific Here's what i envision for the customer. Comes in enters Customer Name and a Password. This takes them to a list type view of all of thier items available for order. Each item includes a Thumbnail picture, the Item Name, a quantity field with set quantities that they must choose from, and descriptions etc. . . Problem is i can't find a reasonable, effecient way for both the customer side and the admin side to be user friendly. . . if someone knows of a previously made solution that i can take a look at or if you …

I converted an Excel spreadsheet used as a contact database. The author lumped the entire contact's name into one field. My master DB has these split out First Name, Last Name as most people prefer. This has got to be an age old problem. Any scripts floating around?

I am perplexed! I have a video database for which I'm trying to concoct an invoice. And for the most part it works. I have a Catalogue DB and reservations are kept in a Reservations DB (also related to a NameAddress DB, etc). My problem lies in the Reservation DB. I have the following fields: Fees (number), Late Fee (Calc), Misc. Fee (Number). Then I have an Item Total (Fees + Late Fee + Misc. Fee). Another field is Amount Paid (Number). Finally, I have an Item Balance (Item Total - Amount Paid). And all that works fine. It is in the Body part of the Invoice Layout. Next, I have a Sub-Summary field sorted by date. Here I have a Sub-Total Field (Summary = Total…

What I'm after is a calculation which will give me all the combinations of 5 fields... Eg. Field 1 = A | Aa | aa or A - Field 2 = B | Bb | bb or B - I need an output which: A, B Aa, B aa, B A -,B A, Bb A, bb, etc Does anyone have any ideas? TIA Tony P

ok we have a database the was created 2 years ago. it houses our agent information. the information is personal and for office use. this database has multiple duplicate records. most of the information is the same... name, address, phone. but the agent number is different. for example: there may be 5 records with "BOB'S" info, but each record has a different agent number. what i need to do is create 1 record that will have all the agent numbers. i would like to export the info and then put it into the new data base that has fields for each agent number. this is a hard one for me.

I have a schedule with 24 events to it. These events have a due date. Job initiated:<date_1> Files to client:<date_2> Final due:<date_3>...etc. What I would like to do is have the entered dates show up in a calendar layout of Daily Tasks, Weekly Tasks, Yearly Tasks. This is still in development stage, and with 365 days I want to approach it the correct way. This is what i was thinking but, looking for different ways of attack. z_container=global container (2 reps), red box and white box. For day 1: If(day(date_1 or date_2 or date_3)=1, GetRep(z_container=1),0) For day 2: If(day(date_1 or date_2 or date_)=2, GetRep(z_container=1),0) My…

Hi, i am new to filemaker, and forced to use it. My question is, is it possible to execute SQL statements in FMpro 5.5, and more particularly PSQL as well, to execute scheduled task, such as inventory updates etc..

Try checking "unstored" under storage options in the field definitions dialog. Tom

You need to make those calculations UNSTORED, by turning off indexing.

I have a weekly report with lots of records based on individuals work flow. I want a script to copy the first 9 records for the next week so key information is repeated. I am looking for the simple action to make this all happen but it looks like I might need more of a calculation? Looking for some help! Thanks in advance, -Morning Man

In December I posted the following: quote: We have a field called "1stReviewDate" another called "ReviewFrequency" (with defined values of annual, 6 monthly, Quarterly, Monthly) and another called NextReviewDate Can anyone help me with the following: For example if the 1st review date was 1/10/2001 (UK date format) and someone chose review frequency of quarterly, I want the next review date to show 1/1/2002, until that date, and then it would show the next review date of 1/4/2002. I know how to add certain numbers of months to dates, but can't get my head round the bit where the review date stays the same until that date is reached, then rolls over to the n…

We have a field called "1stReviewDate" another called "ReviewFrequency" (with defined values of annual, 6 monthly, Quarterly, Monthly) and another called NextReviewDate Can anyone help me with the following: For example if the 1st review date was 1/10/2001 (UK date format) and someone chose review frequency of quarterly, I want the next review date to show 1/1/2002, until that date, and then it would show the next review date of 1/4/2002. I know how to add certain numbers of months to dates, but can't get my head round the bit where the review date stays the same until that date is reached, then rolls over to the next date. Can anyone help - PLEASE!!!

I have created a portal showing a few fields from a related file. Everything works great, but I'm now trying to write a script to iterate through the portal rows - to do this I need to know when to stop! The FM function

I just want to test this system using Japanese. Apologies if it is not appropriate. 日本語の入力テスト。

I'm using FM 3.0 on a 400 MHZ TiBook and designing a small business database. Part of the database involves tracking hours worked, bill and pay rates for employees and customers. From this it's a cinch to create invoices, but is there an easy way for FM to create payroll or is it better to output the data to another program, such as QuickBooks or MYOB? FWIW, Completing payroll requires tax tables, and knowing the required data for the employees (# of exemptions, hours worked, rate of pay, etc). It looks to me like FM can do everything needed, it's just a matter of setting it up. Am I right about this? The other question is about printing payroll checks. Let's say someo…

...aaaaaaahhhhh!! This is an invoicing system with an invoice file and a line items file. The invoice is printed from the line items file with a reverse relationship to the invoice file in order to display the invoice data etc. Now here's the catch. Every product (from a product file) that is entered as a line item, will have several additional charge/credit items. Some will be optional, but most will be mandatory. For example a widget may have these subitems: Set-up fee $10 Store rebate -$20 Shipping charge $5 Optional leather upholstery $30 There are hundreds of different possible subitems, and the user will be adding or deleting them to/from products regular…

Have chosen this category as my mind is totally boggled. I put an audit feature in my order processing system. I defined a fairly complex concatenated calculation field in my ORDER LINE file (to capture a number of field and Status values at that time)and an audit field in the parent ORDER file.Let's call these FIELDA and FIELDB. I defined a sript in the ORDER LINE file Set(FIELDA, FIELDA&FIELDB) This became a subscript in other scripts to update FIELDA at required times. It worked inconsistently (sometimes perfectly and sometimes not at all)and I posted a topic in Scriptmaker for some help. But this is not now the problem! The problem is that the file has …

This seems like it would be a classic filemaker problem: I have version 5.5. I have a complex contacts database used by 7 people. They often need to perform complex finds, then mark the records, and then assign a category to this new group. The category is assigned by entering a category number in a multi-key field. It is scripted to enter this number for all records in the found set at once. MY DILEMMA: What if someone is editing "John Smith's" record while another person is adding a category number to a whole swath of records, one of them being John Smith. The add-category script will of course miss john smith b/c the record will lock, right? What are the work…

hi there. ok here is one... i have tried to do this with no success.. i have a contact list with people from around the world. what i want to do is create a calculation for each field that will show the contents and the number of records for each content. so if i have a state field with the followong states... PA, OH, NY. i would create a calculation field for each one.. PACalculation (and it would show) PA 250 records i would do the same for each field content. this more for a complete record screen so i can show to a client. they would be able to see all that is available. thanx for the help..

I need to show percentages in a subsummary part The example is as follows: I have an appointments database that uses the following fields Appointment_Date (Appointment_Year) Appointment_by Appointment_Result1, 2 & 3 (Success, Fail, & Open) So, I use the sort: (Appointment_Year) and Appointment_by And thus display, e.g. ________________ Subsummary1: Year: 1999 /Appointments 75 / Success 49 / Fails: 20 / Open: 6 ________ Subsummary2: Mike: Appointments 20 / Success 15 / Fails: 5 /Open 0 Dave: Appointments 25 / Success 10 / Fails: 10 / Open 5 Mike: Appointments 30 / Success 24 / Fails: 5 / Open 1 Etc. What I need, however, is to also show …

Is it possible to check if auto spell check is set to on. If not, then set it to on, all through a script without the users knowledge. Thank you

posted December 07, 2001 01:45 AM ------------------------------------------------------------------------

Hi ! I have this problem I'm working with Windows 2000 professional and Filemaker 5 / 5.5, I'm using the Azium Variables plugin (2.0.3). I enter to the plugin section in application preferences to register the plugin but when I return to check if it was registered or close the application and open it again the plugin is not registered. This only happens if I logged in as any user, if I login as administrator works fine, the pluggin keeps registered. Some body come across this problem? Ernesto

I read that other stuff about the chiropractor (or whatever) and have a similar situation. I'm automating a silk-screening shop, where they've got 8 presses. We've got a db for production orders which holds two items relative to the printing process - number of items to be printed and the type of item (so, say, 1200 t-shirts or 500 pillowcases). I've got another db for the presses themselves, the key info for which is the machine's capacity. What I now need to do is make a system where the manager of the shop can schedule his jobs. The problem I'm having is how to make sure that he can't overschedule a machine. Until I solve that one, I can't really wrap my head around…

Is it possible to get a list of the users who are currently using a database? We're using a Helpdesk callregistration database and I'm going to put it online with web-companion. On the helpdesk-site I want to enable the users to see which employee is in the house/online. Thanks in advance! Greetz, Jorick

While using FileMaker 4, the following age calculation worked: Year(Meeting Date) - Year(Date of Birth) - If(Meeting Date < Date(Month(Date of Birth), Day(Date of Birth), Year(Meeting Date)), 1, 0). In FileMaker 5.5 the same calculation is only calculating by the year, so if I use a Meeting Date of 11/7/2001, and the Date of Birth is AFTER the Meeting Date, such as 12/14/1986, the age is coming up as 15 instead of 14. Any suggestions? Becky

Hey all, I am interested in archiving a few databases that grow into infinity as time goes on, databases like "orders" for example. The issue I'm having is currently we just make a copy of the database, rename it with the date, and stick it in an "archive" folder. This works, kind of, but then we have to know which archive records are in if we want to go back and check them, and trying to look for trends and such over the years is obviously hampered. What I'm wondering is in situations like this, how do you guys handle the need for speed vs. the ability to still conveniently access and use old data? I've been toying with the idea of a "master" file and a "working cop…

Hi there folks.. I am new to the FM Forums ...but I thought this would be a good place to get some help on a tricky project I am starting Story so far: I have created a little database with over 200 entries. This database is an inventory of video tapes ...it has fields such as title, tape number, format, location, and a notes section (detailed listing of programs on each tape). What I would like to create is a simple sign out/in template that would work with this database to I can have fellow workers and students be able to sign out, and back in the tapes they borrowed...is this possible?? The fields I would only need for this new template would be...name, student…

I have two reports which can include data on a single job or multiple jobs. Currently the Find ans Report request are perfomed in the time and material DB. The final calculation requires the system to divide the final total by a number value defined in the Estimate database. "TotalSKU" to give a "ProfitBySKU" value It works fine on a single job report but when I try to use this against multiple jobs it is incorrect. How can I get the total os "TotalSKU" from the estimate DB and transfer it to the T&M database so I can use it in the "ProfitBySKU" field?

My system imports from an Oracle Database via ODBC every 1.5 hours to get new pending orders. When it imports it erases the entire pending database and imports new entries. Just before it imports I would like to send a message to the users stating that in 1 min the database will be imported then another warning in 10 secs. I don't need it to go to every user just particular ones. Is there a way to send an individual a message popup like when you are needing them to close out for some field editing? I looked at 'Send Message' script step and it looks more like a commmand line instigator rather then a message sender. Any ideas? Thanx, Thomas Lepkowski [ November 14…

Howdy folks! I would like to use FileMaker to create a scheduling system. For arguments sake, lets say I was a chiropractor, and I needed a system in which I could schedule my clients for different times. Obviously, there would have to be layouts/reports to provide an overview of what time slots are available, what's taken, and so on. I am quite famiar with most of the technical aspects of FileMaker databases, I just can't seem to develope in my mind how this would all fit together. I would think that I should have one database file "Appointments" and each one would have a date and a start/end time. Now how would I report on this in a calendar format so I could see an …

I want to create user help screens that can be accessed by just clicking on a button in the layout. That's the easy part. Each layout will contain a unique Help button. The Help screen will contain a combination of text and graphics so I will be using Container Fields. The Help information will be created in Word or a AppleWorks and will be a graphic. I have an approach in mind but I am looking for any suggestions before I go to all of the work that my solution will require. I am willing to share my solution so if you have any ideas or have done User Help screens before I would appreciate any suggestions. The solution will need to work in a server environment.

Howdy folks! I would like to use FileMaker to create a scheduling system. For arguments sake, lets say I was a chiropractor, and I needed a system in which I could schedule my clients for different times. Obviously, there would have to be layouts/reports to provide an overview of what time slots are available, what's taken, and so on. I am quite famiar with most of the technical aspects of FileMaker databases, I just can't seem to develope in my mind how this would all fit together. I would think that I should have one database file "Appointments" and each one would have a date and a start/end time. Now how would I report on this in a calendar format so I could see an …

Hey hey If I'm running a database on a server which generates an invoice number as a serial number, how can I guarantee that another computer running the same database is not generating the same invoice number as me? Also, what is the best way of running a database on a server without having to load the entire database on each computer which would slow down the system? I do have bridge files holding information but cannot think of a way of writing to an empty database which writes new records in another one on the server. Cheers

I'm having a problem with rounding to nearest quarter (.25) I have a number times a billing factor which then needs to round to nearest .25. Hope someone has an answer 'cause this is making me nuts. Thanks

Thanks in advance for your help on this dilemma! -- MY GOAL: I am designing what should be a simple contacts database and we need to be able to assign contacts to multiple categories, such that: 1- users can continually add categories 2- users can change the name of categories (e.g. from "donor" to "giver") and have filemaker automatically update this name for all entries that have this category 3- Each contact can have many categories, and each category can have many contacts (obviously) 4- It is easy to get together a found set of records and quickly add them all to the same category. THE PROBLEM: I thought I would do this using 3 files - contacts.fp5, cat…

Thanks in advance for your help on this dilemma! -- MY GOAL: I am designing what should be a simple contacts database and we need to be able to assign contacts to multiple categories, such that: 1- users can continually add categories 2- users can change the name of categories (e.g. from "donor" to "giver") and have filemaker automatically update this name for all entries that have this category 3- Each contact can have many categories, and each category can have many contacts (obviously) 4- It is easy to get together a found set of records and quickly add them all to the same category. THE PROBLEM: I thought I would do this using 3 files - contacts.fp5, cat…

Calendar program: I need to create a new record for each day of the next year. If it's a leap year I need 366 days or records added instead of 365. How can I determine whether it's a leap year?

I'm embarassed to admit that this isn't in our repertoire right now, but does anyone know how to define a field that verifies credit card numbers, preferably using the LUHN-10 standard?

hey hey everybody I am currently working on creating a layout that will total several things onto one hcfa (health insurance claim form), currently i have done it by: a. person b. pick up date c. pick up time that would yield one form for each claim submitted. in addition i need to allow authorization numbers and billing codes to apply to specific hcfa's however i want to create a layout that would allow various claims to be submitted onto one hcfa form. can anyone start to point me in the right direction.

Ok, I'm sure this is simple, but I am having a hard time coming up with the proper calculation to add feet & inches. Any help would be great. (We don't allow duplicate posts. I'm closing this thread, please see "Define Fields". -bd) [ October 15, 2001: Message edited by: LiveOak ]

I am creating an order entry piece for a client and they requested that all of the options for each item be displayed in a checkbox list so that the order takers can see all the options and check the ones that the client requests. I know how to display the list but I do not know how to use the selected options to create a new subtotal (e.g. If I select an item and two options, I need the price of the item to increase based on the price of each option. Cost $100, Option A=$10, Option B=$8, Option C=$15. User selects options B & C, price should reflect the new cost of $123 ($100+$8+$15). Relevant Info. Order Entry DB where this functionality needs to be implemented.…

I'm doing a hotel database with the types of rooms in one file and a transaction file and other file that aren't important. i have in the transaction file five check boxes with extras like TV, VCR, etc. in the type file i have these as well. i want it so when the user selects the room type in the transaction file it will come up with the right ticks in the check boxs as well as being able to add other extras to the room during the customers day without effecting the types file. HELP

Hi Everyone, Hope someone can help. My question is this. I'm trying to set up a file for checking out a/v equipment. So, there's an equipment list, name field, from date, to date, from time, to time, returned?, etc. My problem is how do I keep Jerry from checking out hte same equipment as Tom when Tom already has it? ie: LCD Projector - Tom - 10/5/2001 - 10/5/2001 - 10:00am - 11:00am - No How can I keep Jerry from entering data that would show him having the projector during the same time? In a similar problem I'm trying to set up a room reservation system. How can I keep someone from reserving a room during the same time as someone else? Presently I'm us…

Hi! I would like to create an application to visualize drawings related to my items in FM. Does anybody know how to carry it out? Must I program Windows API? Best regards. (We don't allow multiple posts of the same question, I've deleted your other posts -bd) [ October 03, 2001: Message edited by: LiveOak ]

Tricky. . . I have 2 files. File A -> File B based on KeyField; Allow Creation of related records. In FileA i have a layout which contains a Portal for File B. Within this portal is FieldB [Number field]. I need to be able to restrict the user to only entering a number once. After FieldB is exited, it must "lock" itself, so that it cannot be re-edited without the Admin's intervention. I have seen this done in a single file solution, but i lost my hard drive about 2 weeks ago and know not where to look to get any ideas from. . . any workarounds for a relationship solution? TIA Jeremy

I am writing a database to handle the circulation department of our company. We are needing to figure the calculation for printing carrier top sheets. Our fields are: Standard Size (Global) Maximum Size (Global) Minimum Size (Global) Draw (Number) Standard Bundles (Calc) Loose Papers(Calc) Need to get the calculations for Standard Bundles and Loose Papers. Example: Standard Size=100; Maximum Size=125; Minimum Size=20; Draw=116 Answer should come up: Standard Bundles= 0 Loose Ppaers=116 2nd Example: Standard Size=100; Maximum Size=125; Minimum Size=20; Draw=156 Answer should come up: Standard Bundles=1 Loose Papers=56 I tried making the a calc…

Forgive my ignorance, but I need just a little bit of remedial help using the Set Field function. Vaughan once told me to use it, but the calculation aspect threw me off. Which functions in Specify Calculation do I use so that my end result in the script is [select, "Letters2", "1st FollowUp"]? Vaughan told me to look up SetField in the FM help, but it seemed of little help. So what I guess Im asking is how should the calculation be to make it look like [select, "Letters2", "1st FollowUp"]? Once I get past this, I think I will be well on my way, and I can stop pestering everyone (Then I can pester you all with something esle!!) Thanks again for all your help!!

This is a difficult one to answer without having the exact setup. Firstly, I don’t buy what this so-called “expert” is telling you. I tend to do all my programming on a PC, but have to develop for clients running Macs, so I have a small network here running two really ancient power Macs. The reason I’m telling you this, is that between my 64 MB RAM Power Mac with only 650 MB hard disk, and a Pentium III 800 with 512 MB RAM, there is very little difference in searches, as this depends very much on the following: The server – not the client The size of the files (i.e. indexes) And more importantly, the network (this involves network speed, 10 or 100 base, cards and of …

There are two things I would like to do.. 1) I have a list of 20 Yes/No Radio buttons (textfield1, textfield2, textfield3, etc), next to each I have a list of corresponding Notes fields (notefield1, notefield2, notefield3, etc). If you click

I have a set of records that contains a field for each user to order a standard item. I also have a relationship that ties each user to a person. What I am trying to do is a calculation that looks into that users record and check to see if the standard item is a yes or no. Here's what I tried. If(user 1="yes", 1, 0) But what I need is (if user 1 "record" {field} = yes then 1 else 0). What I ultimately want to do is get all users orders (either yes or no) then total them. But I am not familiar enough with filemakers lingo to pull it off. Any help would be greatly appreciated. Thanks in advance, Don Dmacman

Well folks, I’ve now posted over 30 answers but only asked one question…. So I guess I’m entitled to a little help now! LOL I don’t have a problem as such, as I’ve already found an answer. However, if someone could help me to do this a better way I would be very happy. The situation: I have an address File with over 130,000 company names and addresses. I get these names and addresses from CDs, which are imported into the DB. The problem is keeping out the double records. If every Company address CD manufacturer used the same formats, this would be easy – but they don’t: So for example: Mueller & Mueller GmbH Ring Strasse 6 46789 Munich Deutschland Is identic…

I will give much background to hopefully help in understanding my problem. I have two db's ESTIMATES and PRICEDATA. PriceData contains many types of steel rule (products) and prices per in. We allow 3 tiers per rule type based on linear inches used. one record contains five fields, PerInch, PerInch Over, PerInchOver2, Overlimit, Overlimit2. RuleType1 1.20 per in 1.15 per in over 80 in. 1.10 per in over 150 in. In the Estimates db the fields are looked up based on RuleType chosen. We allow up to 5 types of rule on each estimate...RuleTypeA, B, C, D, E. That means I have to allow 25 fields for potential looked up data. …

I have never used a radio button before and would like some clarification of its potential use in a calculation that I am thinking of using. What I would like to do is this: have a radio button that if clicked on would be the true part of a calculation, therefore not adding the data from a field to another one for a total. Specifically it relates to remitting taxes in a vendor/seller situation. In most cases I (or my clients to be more exact) remit the sales tax themselves in sales of merchandise but as my clients sell merchandise in different locations all the time I am finding that the nifty calculation I did to separate the local taxes for their records doesn't work wh…

FM newbie needs help ;-) I need to generate and print out a deposit report which lists contribution info (contributor name and contribution amount). Currently, the layout is set up to list this info and a summary field reports the total deposit amount. When the records spill over to a new page, the same total contribution amount is reported on each page, rather than page totals. Now, I need to limit the number of records to 25 per page and then have each page totaled individually. I imagine I'll need to use a calculation to achieve this but have no clue where to begin...any help will be greatly appreciated - thanks!

Our custom picture department uses different colors for the slide number depending on location of slides. How I was going to do it was create a field called "itemcolor" and give it a value of 1 to 4, we use 4 colors. Then I was going to create three more fields called "Slide_green, Slide_blue, Slide_Red" (Slide_num is there already they change the color by hand)and these would be set to that color in the layout. They would be calculations (ie Slide_Green would be (IF itemcolor = 1,slide_num,"") ect.. And place them on top of each other. This is a lot of work because they show up in many layouts. I really would like to change the text attributes within the field by p…

I'm looking for a plug-in to calculate or recognize video or film time code in the format hours:minutes:seconds:frames (in this case frames being either 24, 29.97, or 30). I have created an extensive set of calculations to do this, but it has slowed down my database quite a bit. Can anyone help? Thanks in advance.

Hi All, What I'm trying to accomplish is a script, that when run will clear certain fields in that record. I have cost, quantity and total fields that I want to be able to have the user clear, without deleting the contens of each field individually. I tried this: Loop Goto field (field1) Clear Goto next field Clear If getfield (total cost) End If End Loop Beep But, of course, it doesn't work. Any help would be greatly appreciated. Thanks in advance, Don Dmacman [ September 07, 2001: Message edited by: Dmacman ]

Hi everyone, I am hosting a file over the web with web companion (I know its not the best way to go, but until I'm more confortable in GoLive, Ill begin here). My question, I believe, is more "caculations" related, then relationship related, so I posted here. I have what seems simple, yet is baffling me. I want to "relate" users to their sponsor, and then total ordered tape items up to their sponsors. For example: Me / joe fred / / tom jim jeff tim So, if joe orders 2, and tom and jim each order one, then joes order to me is 4. Also, if fred order 6, and jeff …

really i do Jeremy (who asked a long question, then found the answer in another forum, stupid me) [ August 29, 2001: Message edited by: yafreax ]

So I started learning filemaker pro. I got decent at it and my users now realize how wonderfully functional a filemaker database is. Of course they now want reports, lots of them. Now I'm not asking for specific help but I am wondering if anyone can recommend a book or a training course in New York City. Thanks

Does anyone know how to set a tab within a calculation field? I am exporting data for import into Quark Express using xpress tags. I have set my tag for a tab but I need to physically set the tab. I have set up a calculation field for my tag information which contains a zip code and phone number that I want separated by a tab with fill dot leaders. Hope this is not too confusing. Thanks http://[email protected]

I have a quotation system with a script that Duplicates related items in a Line_Items db by first exporting the original items out, then performs a replace with new Quote Number, and then re-imports the original items back in. My scripts work ok running it locally, but when I Serve the databases via FMServer it fails to work. Any ideas folks?

Don't use repeating fields. A related database can contain all of the info. Just include a field that identifies the type of communication such as fax, home phone, email, etc. You will have a lot more options for searching, sorting, and reporting than you ever would with repeating fields. Repeating fields are relics of the old pre-FM3 flat file days, and have very limited utility in FileMaker any more.

Ok, let's try this again. I have a text field that is generated by grabbing website URL strings from a referenced file. This ensures that the contents of this field are entirely unknown beforehand. What I want to do is create a Top 10 (or 20 or 30 etc.) list of the results from that field. I mean if 345 people visited www.yahoo.com, and that's the number one site, I want to create a report that says something like: 1. http://www.yahoo.com (345 hits) 2. http://www.lycos.com (211 hits) 3. http://fmforums.com/ubb/cgi-bin/ultimatebb.bgi (205 hits) etc. Help? Please? Thanks.

Let's see here... I'm given a log from a proxy server and have extracted URLs from it. What my employer expects is to create a list of the top 10, 20, etc. URLs in the database. The URLs are in their own text field and are entered automatically from another file. They are NOT known beforehand, since this covers ANY site visited. What I would want to do would be to show which webpage was visited the most, second most, etc. Something like: 1. www.yahoo.com 2. news.yahoo.com/example/bs.html 3. www.lycos.ca/search/filemakerpro/ ... etc.

I am trying to make a marketing contact manager with FMPro 5. This program would take a selected group of prospect clients and mail them intro marketing letters followed by phone calls, based on a certain strategy. The strategy would be something like this: 1)Print Introductory Letter. 2) Four days later a follow-up letter prints. 3) Four days after that letter prints, a message would appear that reminds the user to call the prospects he/she has had all these letters mailed to. All these events of a strategy would be part of a campaign that the user has selected. I have created the interface for the directory where users can enter the prospect information, but I cann…

I am still in trouble! 1) I would like to know how to create this multikey field. 2)What kind of field is (date, time, number

I have a schedule database. I have date, start time and end time fields . When I create new records I need to be able to find repetitions and overlapping records for I can't allow anyone to have more than one activity happening at the same time the same day. The start time could be different and still be overlapping. I tried using global fields and scripting but it didn't work out. Anyone can help? Thank you in advance for your cooperation

I'm currently writing a new part of our databases for remote users (laptops) which on occasion must connect into our system and syncronise with the master database. Ok so I have got to rename my "remote" user databases, to something else (to stop filemaker opening the wrong files), however all the relationships and scripts (of which there are lots) obviously refer to the old filenames, which I don't want. Now I'm aware that if Filemaker can't find the file in the relationship or script it will ask to locate it, and I can link it to the new file but when you close filemaker it throws these changes away right, and again if the laptop is plugged back in the network it wil…

Filemaker sorts numbers so that 10 comes before 9 etc: ID: Record: 10 Record C 8 Record A 9 Record B I quess this isn't a big problem but if I only have <20 records it bothers me in list view those rare times when I sort something by their IDs. Is there a way to easily make FM sort numbers properly? I know that I could manually add a zero before the nine, but I would rather hear a different tip.

Hi to anyone, and I hope this question won't fry up your brain... I just want to do a simple calculation... We keep a record of the items we send, and very often, it's all sent in one shot... But we realized not so long ago that if the package was, let's say, splitted in two and sent at two different times, FM will not add 'QtyAlreadySent' and 'QtySent'. The script used is quite light. It starts from 'Products.fp5', then goes to 'LineItems.fp5' and comes back to 'Products.fp5', counting everything... except that. But...! If I insert a 'Pause' when the script is at 'LineItems.fp5' and if I go back to 'Products.fp5' myself, it works!!! I hope someone is brave enough to he…