Calculation Engine (Define Fields)

I have a layout with a pop-up menu based on data from another table (tblCCadd: containing company name/address etc) When the user selects the company name from the pop-up menu I want to insert the company address into an address field on my layout (this field is in linked to a different table) Must also be able to manually enter an address (not just bound to info in the address table) (hope that I’m making sense?) Thanks John

I have a purchase order file that I need a multidirectional look up in. I have two fields, an item number field and an item description field. When the information is being input I would like the user to be able to pick the product by either item number or item description. When one field is chosen I want the other to automatically populate with the correct value. I've tried everything I can think of, but can't get it to work. If anyone can help me out I would appreciate it. Jess

Not sure I'm posting in the right place, so feel free to move me around... I'm trying to create one field, from two calc fields, inclusive of an "." in between, for the purposes of creating a realtionship with another FM database. As an example, independently I have: 03 12345 What I need in order to create the relationship is: 03.12345 I'm sure it's simple, but for the life of me can't get it figured out! Any assistance would be greatly appreciated!

I have standard paraphrases set up that the user can select via check boxes to construct a letter to a client, the number of inclusions might vary drastically and then take it into a second/third page. Is there a way to set up a letter so it will flow from one page to the next using a single field as the body? Or is there a calc to determine no of pages and dynamically choose a layout with that many pages set up on it? Or is there a way to export to a Word template?

HI all, I know this has to be possible, but I'm having trouble with it. I have a single table for programing panels being held for a convention, and each recored is for a different panel. To make it easy to add and delete speakers for the panels I use several fields (Panelist1, Panelist2, Panelist3, etc.) all attached to a value list of the possible guest speakers. These fields feed a calculation field so all of the people on the panel are listed in one place. What I need to do is make a layout that will list the number of panels that each guest is doing, but it has me stumped. I am attaching a test version of the database below. Any and a…

I have a layout that uses a plug-n called MMEmail. I have three fields I have set as Required but users can still use the MMEmail function to email portions of the layout even if they haven't filled out the required fields yet. The plug-in simply calls up an email window which is populated with merge fields and emails it using a local email client as support. When the user clicks on the button to summon the email window I would like to see that script validate those three fields. The fields are a Date filed, and two Text fields. Any ideas? Let ( [ To = Purchase::SendToMail ; Subject = "Purchase Request Approval Needed" ; Body…

I've searched the forums, and tried for hours on my own, but I'm having no luck creating a calculation field which gives the result of when another field was last modified. Basically it is used to automatically determine when a certain task was completed based on when they entered data into a certain field....without having to force the person entering the data to use a script with a set field included. I thought there would be a Get(Field Modified) type function, but I'm not seeing anything. I feel like I'm overlooking something. Any suggestions are very appreciated.

Hello Forum I need to know how I can add two values in two seperate boxes into a total box. I have attached a PDF to show what I am trying to do. Hope someone can help. Martin total_box.pdf

I have a join table (Enrollment) between Students and Classes. I then have a join table (Assignment) between classes and assignment results. I have tried to get an average of the scores from the assignment results for every student in each class. I have a field on the Enrollments table named gradeAverage. This field is an average of AssignmentResults::Score. All I have gotten it to do is either average all the scores in the table (so everyone ends up with the same average) or all the students scores in every class (so a students average is the same in every class). The latter was done using a second occurence of the Results table related to the Students table. Ho…

I have 2 fields 1) Date 2) Quarter I need the "Quarter" field to reflect the quarter of the date field. Any advice?

I am trying to import an excel document but it wont import over the calc fields is there a way to do this?

This should be another easy one, and I even found a reference on google to a sample file that does this, but its a dead link. Anyhow, I just want to vaslidate that the content enter into the "email" field is valid. I don't want it going out to the mail server to validate, or anything like that. I just want it to say, yes you've got am @ sign and a . and a "com" or whatever. Any help is greatly appreciated. Thanks!

I have fm server (server 8) running on a separate machine and several client machines connecting with fm 8. I have several global fields used in a relationship to filter records. when I put the data in the global field it shows up in all the records and the relationship works great. Everytime I log off the database and reconnect the global field is blank and the relationship no longer works. any ideas?

Hello, This should be an easy one....I am trying to setup a mapquest link into an existing FM8 database. The address are entered using spaces, I need to replace spaces with the "+" so I can create the correct URL string automatcially. Any help would be gretaly appreciated!

Hello all: I don't believe this will be a problem but I have a WINDOWS FM8 SERVER machine that will host a database applcation and Macintosh clients connecting to it. The Macs will be saving files (quark, excel, word, JPGs etc.) into container fields that will be stored on the Windows machine. Are there any issues as far as the file names go when putting these files into a container field where the database will be on a windows box? Thanks. DJC

The following 2 script steps work: profession= Case ( PatternCount ( Profession;"¶" ) > 0; TextStyleAdd (Profession ; Bold ); TextStyleRemove (Profession ; Bold ) ) profession= Case ( PatternCount ( Profession;"¶" ) > 0; TextColor (Profession; RGB( 0 ; 0 ;255)); TextColor(Profession; RGB (187 ; 0 ; 0 ))) However, when I try to combine TextStyleAdd with TextColor into a calculation field, it doesn't work. It changes the text to Bold, but it doesn't color it. I've tried various combinations, including 2 case statements, '&' and '+' to no avail. I don't get a syntax error, it just doesn't do it. Does anybody know what th…

Hello, Whenever I try and delete a field I get a "Scanning for References" progress bar. I did notice some old file references, so I removed those, but the problem persists. Any ideas? Regards, Sean

How can I make a checkbox that is auto-checked based on another field having been filled out (and conversely, not checked if that other field is empty)? Any help would be appreciated.

... i want a calculation field that will take a text field and filter out every second line... or any particular line... sorry to be asking so many questions lately, but i do try to work these things out myself for at least an hour before asking... anyway, cheers genx

Hi I created 3 fields, DateExpire, DateCreate and DomainName in List view. I create an additional 2 fields called year[Year(ExpiryDate)] and month[MonthName(ExpiryDate)] to group all the domain expiring on the same month and year together. E.g. Date Expire Date Create Domain Name 2006 January 01/01/2006 01/01/2005 abc.com 2006 February 02/01/2006 01/01/2005 def.com 02/02/2006 02/02/2005 ghi.com And now i having a problem, if i sort by month it may give me 2005 jan then 2004 feb then 2006 march. And if sort by year first it also having this type of problem. How can i sort by year and month together?? Thanks a…

How do I create a calculation to evaluate the actual time spent on a project. If I start on 01/12/06 at 12:00 and end on 01/13/06 at 12:00 it should show 24:00 but instead it shows 00:00 because the date is not included in the calculation, just time. Any advice??? Thanks

How do i make a button open up the default email client and send an email to a customer from a form? The email field is named email in the form.

I have a pair of fields, "Phone" and "Fax". Now on all of my forms this works except a few. The calculation is exactly the same in all forms but some will show up with a "?" instead of the number conversion. This is the calculation I use. "(" & Left (Fax ;3 ) & ") " & Middle ( Fax ; 4 ;3 ) & "-" & Right ( Fax ; 4 ) Most of them work fine, it is just a few that do not. Any advice?

Ok I have a status list. Which is a list of Radio button of the status of a particular document. The list has O - To Complete O - Faxed O - Approved I have a 2 fields below the status box which are both dates. Whenever the user selects Faxed I want today's date put into the field. I've got it working with an "if" calculation: If(Completion Stage = "Faxed", Today, "") but then when the button moves from "Faxed" to "Approved" the date is deleted because my second result in the "if" statment is just "", I was hoping I could get the date to stay there. My second date field serves the same purpose but I want today's date to appear the day the person click on …

I'm sure there is an easy answer for this, however, I am a real newbie, and am struggling with what to do. I want to change a letterhead on a form letter layout, based on the contents of a field in the main database layout. The field contains the letter writers name, and is either "user a", "user b", or "user a & b". I think I need to create a calculation that will take one of the 3 graphic letterheads (each of which is stored on the main database layout in a global file labeled "user a letterhead" "user b letterhead" etc.) and insert it into a container on the layout. Can anyone help me with this??

I have two fields, one contains currency sign ($, Euro) and the other contains the amount. I merge the two fields as a calc field. I found that the number format was changed. For examples, 0.5 was changed to $.5 1,900 was changed to $1900 How do I keep the number format unchanged?

Can anyone help me; I run a one man band repair workshop where I repair customers units (TV’s DVD’s etc.) and need some advice on setting up a database. My idea was to have 3 tables 1 for ‘Customers’, 1 for ‘Units’ and 1 for ‘Fault and repair’ details with them linked by ID fields in each table i.e. ‘Customers’ to ‘Units’ (one to many) and ‘Units’ to ‘Fault and repair’ (one to many). I would like to create a layout with the customer’s details on it, a list of units the customer owns and as I select each unit the fault and repair details come up. This information also needs to be added to when new customers come along or if the customer buys a new unit or reports a fault o…

In my file, I have a "parts" table that contains records for each part of a letter. Each part is named and is keyed to a part number for that component. The "component" table holds the finished component's name and key. The "parts" table has fields for each letter part along with what page it is found in the finished component. For example, letter #13 has five parts: four of which (signature, salutation, etc) are on page 1 and one on page 2 (Offer). In the past, I have built an excel file that has for each row, the name of the component (letter 13) and an appellation (letter Front). The next row has (letter 13) and its appellation (letter back). I still mus…

I have a validation by calc fora field that works fine: cat_key = "Video" and Length ( firstslot ) = 7 or cat_key = "Info Board" and Left ( firstslot ; 3 ) = "IB_" or cat_key = "CID" and Left ( firstslot ; 4 ) = "CID_" or cat_key = "SID" and Left ( firstslot ; 4 ) = "SID_" or cat_key = "Promo" and Left ( firstslot ; 4 ) = "PRM_" or cat_key = "PSA" and Left ( firstslot ; 4 ) = "PSA_" or cat_key = "Raw Feed" and Left ( firstslot; 3 ) = "RF_" or cat_key = "Artist Feeds" and Left ( firstslot ; 4 ) = "AFD_" or cat_key = "Tosses" and Left ( firstslot ; 4 ) = "…

.. I'd like to know if theres a way of posiitoning text at a specific position along a line using a calc field...? i.e. 10cm from left... or 20 standard spaces from left... ... i need it to be from left in the case that there is text prior to it... i.e. i cant just gap it using " " ... cheers, genx

I want to have a date that is chosen by the user. It needs to be validated by being greater than a date in another field. however, every time I try to do some calculation like date = date if date is not < otherdate or something, I get an error that the function wants to return a number or "(" Either that or it lets me choose a date that IS before otherdate and then changes my date to something like 12/10/0001 What is the deal with that 0001? My Filemaker book is no help. Can anyone help me with the syntax of this? Thanks

... righto, i want to get the filepath of the picture stored in a container field as text... the problem is when i try it gives me something akin to the following.. file:file.exe filewin/c:/documents and settings/file.exe .. where as i just want the filepath.. why does it do this, and whats the work around... p.s. the calc field that gets as text will be storing the filepath for multiple files... cheers, genx

... Ok ummm... feel free to kill me for this... i have been working with filemaker for over 6 months now... and still have no idea what the point of a repeating field is... i just figure if it has a practical purpose it may be useful to know it... Cheers, genx

I have a claculation field. I need to put over 100 conditions using Case(test1, result1, test2, result2,...) (unforuntally, there is no "regular rules" for these and I cannot use a formula.) After I put in all the possibilities, a message "too many operators...". I guess the program does not take that many conditions. What other options do I have to make this work? Thank you.

Has anyone got any suggestions on this one... I need to build a database that will contain mileage driven by our drivers (trucking company). The mileage would be input weekly for each driver and it is broken up into loaded and empty miles. What is the best way to define a database to hold all of these various data items. There would be the unit number (driver #), the weekending xx/xx/xxxx loaded miles, and the weekending xx/xx/xxxx empty miles. We would then create various reports to use this data.. example YTD miles, individual driver miles, etc. Hopefully this makes sense Thanks in advance for any help

i trying to make a calculation in a auto enter serial number. what i tried to solve is how to split the serial number in the auto serial that was create by different location or different district. example..if person at district A enter the record the serial number look as A0001 then person at district B enter a new record, the field's number looks B0001 and person at district C enter a new record, the field looks C0001. When person at district A again enter at new record, the field looks A002 and so on...that means the serial number should be the same numbers at every district but with the different character infront the number. hopefully everyone can understand my eng…

i have read a few different posts about using dates, but I haven't had much success understanding or implementing the best way to do this... I have a database with different construction jobs, each job has a list of all material needed for the site with the dates needed, and the vendor it is coming from. I have a seperate table with all the vendor info and their respective lead time in weeks. What I would like to do is flag the items that wont make it in on time based on the current date and the vendors lead time, then incorporate it in a script to email the appropriate project manager.(i pull the email addresses from another table with all of the job contact infor…

I have a date field called date_recall (date for which the sales rep recall the prospect). My validation is that. Recall date must be within 3 months of the Insurance Expiry Date (which is called date_effective). date_effective is set to increment by a year if it's expired. Something I should also mention is that, date_effective can be empty. When that happens the recall date can be anything. Now my problem is that I need to have date_recall auto-enter the date 3 months prior to date_effective and at the same time modifiable so that the rep can move it closer to the expiry date. (situation: He calls the prospect but prospect tells him to call back next week or whe…

This should be a dumb question, but I have inserted a file in a container field, and I don't know how to open it. I have double click on it, but nothing, what is the trick?

I have a database of our city's youth who attend our church's community outreach functions. 90% or more of those kids all have the same city/state/zip. What I want to be able to do is to input ONLY the zip code and have the fields for city and state fill in automatically, but only if I enter ONE particular zip code. I'm basically looking for an "if/then" function. If zip code A is entered, then city B and state C are entered automatically. If any other zip code is entered, city and state are filled in manually. I'm brand new to Filemaker and would greatly appreciate ANY help. Thanks. <>< Cliff

Hello, I am trying to figure out how to insert a picture into a container field. I have built an XML/ XSL style sheet that imports the HTTP picture location from Amazon. I am struggling at figuring out how to get the picture JPG from the HTTP address into the container field. I can Open URL on my imported data field and I see the picture come up. I have tried Insert Picture using a variable (with HTTP JPG location) in the file location field, but it keeps giving me unknown file location. I must be missing something. Any suggestions.

Hi! We have a FM6 database in which we "draw" up a layout with numbers and drawings in Excel. On a PC, we can copy the rows/columns/drawings we need, then paste into a container field in FileMaker. The problem is our Macs don't recognize this, we get a "Windows OLE object" icon and that's it. (I actually have the same problem when coloring fields via the getrepition calc, Macs can't see it.) However, doing it on a Mac and then pasting works on both platforms, unfortunately that isn't an option for us, we need to do it on a PC, and our Macs don't have Excel. Any ideas? Thanks!!

Currently I have two tables, Clients and Jobs. Clients is related to jobs through ClientID. Both tables have an auto enter serial field, ClientID and JobID. In the Jobs table ClientID is set as a pop up list, listing the clients entered in the Client table. Eventually though there will be 300 + clients to choose from in that pop up list. Rather than scroll through that many, I want to be able to manually enter a client name and have a function that will lookup the correct clientID. Right now that only works if I specifically select it from the pop up list. If I simply manually enter the name and tab through clientID field in the Job table, it creates a new ID, and d…

I'm trying to manage a file of media assets. What I'd like to set up (and can't figure out) is a field that will automatically fill, based on the file extension of a file that is batch imported (Import:Folder). So that when I pull in a new batch of images/files, I will have the full filename in one field and then somehow trim or query that filename and fill a second field with just the file extension of that file. Hope that makes sense. Basically I'd like one field with "file.ext" for the name and another that would just show me "ext" as the extension of that file. Thanks. {edit} - just to be clear, the file names are obviously going to vary greatly, s…

Hi Guys & Girls, Is there a way to get the path of a file in a container field in FM6? I know the GetAsText in 7 does this, but this function is not yet available in 6 Thanx

Hi all, Hope I found the right forum. I'm lost. I've looked for "contains" and "unique" but so far all I have found refers to between records and I need within a record. I have a repeating field for artists' names. There are 16 repetitions. I want to be able to set a second field on the same record to the unique names in the artists' name field. If this is what is in Artists' Names field in record 1 repetition 1 =Bob repetition 2 =Sue repetition 3 =Sue repetition 4 =Bob repetition 5 =Jack and so on up to 16 I want Assigned Artists field in record 1 to be: Bob Sue Jack Is there a contain function? I think more like an AppleScript perso…

... umm righto, heres the question right... i want to store only references of images... but i want the filepath to be evaluated in the context of the file thats hosted... i.e. on the server... i dont want a user to have to have a genericly mapped drive to the correct folder... Anyone help? this is a fairly crucial thing that would be great if i could avoid it... (p.s. ive got a backend front end split not that it should matter)... Cheers, genx

Hi everyone...have an issue I just can't seem to find an answer for: In our database we have a table that has the employees 'employment' history (department, area, etc.). In the main table/layout this is viewed as a portal (we keep a running history). Our human resources area provides an excel list with the employees CURRENT assignment. Now when I try to do an import from their excel list I can never seem to achieve this: - I want to import and if the employees assignment has changed (based on the table and the excel file) it will add a new record with the new assignment. So far this does not work in all the ways I've tried....has anyone had exp…

Hello, In my database there is a field for notes. How can I keep the field fonts from being altered in size by the user. When a report is generated the font size is altering the size of the field.

I'm sure there will be a way but I can't figure it out. I have a field (STATUS) that has Radio buttons. The Selections are either "Ready", "To Fax", "Approved" I need to make a summary on my Main Page layout that counts how many records in field (STATUS)have "Ready" selected. I'm a beginner and can't figure it out. Count(field...) just seems to count the number of records with anything in the field, this does not work because the field may contain "Ready", "To Fax" or "Approved". I need it to count the number of records with "Ready" in the (STATUS) field. One option was to make a script that performed a find of "Ready" in the (STATUS). and then a simple Count(ST…

I have tried everything that I can think of, but I am new, so that isn't much. I have a text field from which I select a specific item from a value list (a specific school name). Depending on the school that I select, I want the next text field to display a value list specific to the school identified. I have tried calculations, scripts, just about everything that I found with no success.

Hello, i am having problems with a page on the db. When i click the new purchase order button it should bring up an empty form, but often it doesn't, it already has products in it...i can't figure out why. What i would like to do is clear all the jobs that have been previously created so i can eliminate that from being the problem. But i can't see how to do this.. I am used to working with mysql and being able to empty a table...how would i go about doing something similar in filemaker... thanks. RF

Has anyone come up with a sentence case function ie formatting sentences for say a notes field?

Hi, just getting to grips with FM 7 - but have come stuck on the dumbest thing. I have a field (Organisation) that is normally populated with Organisation titles. When it is blank I want to polulate it with three other seperate fields (Title) (FirstName) (Lastname) with spaces between each field. I have tried many combinations but can't get it to work! I tried this: If IsEmpty GetField (Title) and GetField (Firstname) and GetField (Lastname) I am frustrated as I know what I want to do but can't express it in terms that FM7 works with. Thanks in advance.

I imported a FM3/4 DB into FM 8.2 and I've hit a snag. The file has a Summary field with the Min function, and it returns the lowest integer just the very first time, but does not update even as records with lower values are entered. This holds true whether the Summary field is in the footer or the body. I have to believe this worked in FM3/4, but I'm baffled why the field isn't updating in FM8. I've also tried Max and Average functions with similar results. I'm out of bright ideas what I might be doing wrong. Help!

Which is preferred in this case? I want a field to display an image. Each time we go to a different record, a calculation is performed to determine which image to retrieve from a global container field. I can create my display field as (1) a Container field with the "Auto-Enter" option "Calculated value", or (2) a Calculation field whose result is a Container. Which works better? Why?

Hi all I have two questions. I am trying to find the last date a welder has welded in one process using the "max" function. I am not understanding something about the "max" funxtion because i cannot get it to work properly. I can det the "min" function to work. The second question is it possible to find the last date a welder has welded in more than one process using the "max" function. Example: last day welder welded using the GTAW process Last day welder welded using the FCAW process Can this be shown at the same time on the same screen. I hav attached a file showing that i want to do maxdate.zip

Kinda new to FM so I dont know what I would search for for help. I've been going along making things up and figuring things out on my own but this one problem I cant quite get. Heres what I got so far: I have 2 seperate FM files. One called, Expenses. One called, Purchase Orders. Inside 'Purchase Order' I have a field that calculates material costs based on X number of colors (supplied from another field in the purchase order file) with a total calculated number from a field inside the 'Expenses' file. So what I would like to do is, at any point be able to update the material cost in 'Expenses' and the calculation in 'Purchase Order' update also with t…

I am trying to show the the record navigation with the get functions but something does not seem to work. I use the Get(TotalRecordCount) function in a field which correctly shows the total number of record, but in a found set, the other two calculated fields that have the functions: Get(RecordNumber), and Get(FoundCount) function, display the incorrect answer. I have submitted the example, what I want to show is the correct number of records in a found set and the corresponding record number in that found set, in other words duplicate the information that is on the status bar. What I am doing wrong? Get.fp7.zip

Hello All, I could not find a forum that sounded like an exact fit for this. So I picked what seemed like the closest option. I am experiencing something strange. When I select "Delete Record" from the "Records" menu, ALL of my records are being deleted. It does not matter if the records are found or not - they all get deleted. Anyone heard of this or know what might be causing it? I am not deleting a record that is in a different table. I am not deleting via portal or a relationship of any kind. I am not in a list view. I am simply viewing a single record. It contains a tabbed interface and some of those tabs have a portal in them. But I don…

I have attached a file that explains what I am trying to achieve. I want to insert through the press of a button the [color:red]time, name and user into the notepad field in a different colour than the main text. Please help. I am a new user to Filemaker so please be gentle when explaining. Thanks in advance M PS - If there are other ways of doing this then that would be OK notepad.pdf

Have another solution I've been working on whereby a large volume of phone numbers is either individually entered or are imported. What I am looking to due is allow the auto completion of field from the entry into another field example as follows phone # x when entered will auto enter the name and address for the phone number for the rest of the entries (times when phone number x is entered) Hope this makes sense not sure it does to me sometimes :qwery: as a side note is there a consensus on the best reference guide available for version 8?

I'm using Filemaker after becoming proficient in MS Access and am having trouble implementing boolean records. As far as I can work out they don't seem to be provided. What I am trying to do is add four records to a simple table. These records are characteristics that can be either true or false. In my past experience these values are called boolean values but there doesn't seem to be an option for this when you define new records in a f.m. database. It seems that to accomodate this I am going to have to define a value list which contains the entries true and false. After doing this I am going to build a form which has some tick boxes. If the box is t…

Hello, Help please I have three tables with the following fields in them. Quarter 1 days, Quarter 2 days, Total days for quarter. I would like to get the sum of qt 1 and qt 2 and have it applied to the total days for the quarter. Your help is appreciated and thanks in advance.

Need some help implementing an auto-enter field. When a user enters a product number or a catalog number into a item number field of a order form's portal, I need the field to replace the catalog number that was entered with a product number (if a match is found in inventory) I have attached a sample file that I got some help creating in thread 173418. The file demonstrates how to do lookup from the product's table or the catalog's table, when a item number is entered. Goal I need some kind of auto-enter function or custom function that will replace any catalog number entered with its corresponding product number. But still leave any number entered alone th…

I need to be able to validate a field based on two others. I have a vendor database listing (in a portal) all of the items that my company buys from that vendor. The vendor database lists the vendor's name, and the company information. A portal displays all of the product information. In the product database, I have set the item number to be a unique field. I figured that way there would be no repeats in product entries. However, I have run into the problem that there are duplicate item numbers for different vendors. Meaning Sears and Kmart may have a product with the item number 11111. I need a way to keep the unique item number while makeing sure it is…

Hello forum - Novice user (be gentle) I have attached a file that shows what I am trying to achieve. I want to be able to click on a button so this then displays the popup help file that describes the condition of the car. Thanks in advance. Martin popup_box.pdf

I've created and exhaustive script that validates the entry in a particular field.The validation forces the user's entry into a standard form. I've now decided that I need repetitions for this field because users are inclined to enter multiple values in this field for expedience which will only standardize the first value. There are a maximum of 5 repeating fields. So to make a long story short.... I want to edit my validation script to loop through all repetitions, if they exist. What is the quickest way to change all the references to that field to now include a repetion number fieldname[n].

I am working with a database of 100,000+ property records. The file contains numerous fields of data and each record is anchored by the parcel number. Previous grantees and grantors are in the file so when I sort the file by parcel number, I get anywhere from 2 to 6 of the same parcel numbers, each with current and previous owner name. Each record also has a date field with the dates of previous transactions. I want to be able to do a "find" with this file that will give me only the records with the most current date (current owner) for each parcel. Looks like this: 105-20-33-090 Smith John 02/09/1984 105-20-33-090 Davis Sandra 11/10/1989 105-2…

I've taken over an existing project. I'm having a problem fixing a bug in a quotation system. There are 2 files involved, sales quotes and price list. In the price list, there are three fields, price, member set price and member price. If member set price is empty, member price is set to price, if not, member price is set to member set price. That way certain products have a member price, others don't. In the sales quotes database, there are fields for unit price and another for member unit price, both are lookup fields from their respective fields in price list. When a new line item is created in sales quotes (repeating fields, not my choice) the prices…

Is there a calculation that will find a common term in two fields? I have a TO for a "DrugLibrary" that contains three fields: Name, Synonyms, Reactors. In a another TO "MedList" I have also have fields for Name, Synonyms, Reactors. (in adition to others). when a drug is added to a patient's MedList from the DrugLibrary I want to check the for drug interactions by comparing MedList::Name and MedList::Synonyms with DrugLibrar::Reactors to see ir the MedList::Name is contained in the field DrugLibrar::Reactors (easy using pattern count as the name is one term) but also (and here is the hard part) to see if any term in MedList::Synonyms (which can contain any number of te…

I am displaying a field from another database with Student ID being the relationship between the two. All my data from the linked record displays properly in the portal. However, the ID field is blank. When I click on the field the text shows up. Never saw this one before. I have an identical screen with a different database (these are all types of test scores)and that works fine. I am drawing a "blank". arrrgghh Thanks in advance!

I have a solution that needs to auto-fill certain fields. For example - a medical record: The first visit a patient answers YES to a question about smoking. Then several months latter the patient returns and the same assessment is completed, the smoking field defaults (look up) and fill in YES in the smoking field, but then the patient says they stopped smoking so it needs to be changed to NO. Then several months latter, same patient returns, same assessment, and NO is now the default (look up) for this question. I've got lots instances of this type of issue... does anyone have a simple, straight forward solution.

I have to create 7 tables which are extremely similar in regard to the fields within each table. Is there no way to simply "duplicate" a table and then modify the few fields that are different?

Dear All, I come again with a problem in my mind. I've create Purchasing Order Layout, it will display PO_Tabel and ItemDetil_Tabel. it runs well until yesterday I found that some of records in ItemDetil_Tabel doesn't have "PONumber". Is there any script step or something to automaticaly fill "PONumber" in ItemDetil_Tabel with "PONumber" from PO_Tabel. PLease, I need this thing to be solved. Thanks before.

Can a calculation open a dialog box if there is an error in the validation of that calculation to let the user know what he did wrong?

I am working on a database to generate scholarship award letters. I have the caluculations working correctly (i.e., award amount, number of semesters awarded, housing scholarship, etc.) and have the figures (via the numbers format) adding "$", "," and "." decimals. This all works beautifully until I try to merge the resulting calculations into my award letter. Intead of getting "$16,000.00", I'm getting "16000". I notice when I click on the field, I see "16000" as well, but I cannot find a way to have FMP take the formatted number and merge it into the letter. If I try to place fields in the letter, the resulting appearance is not aligned, and would not be feas…

Hey gang. Sorry if this is posted to the wrong forum. I have developed a File maker 8 solution running on Win XP Pro to track the inventory and maintenance for a fleet of vehicles. When a vehicle is entered into a record it is tracked by the VIN (vehicle Identification number) and a car number. (ie license plate) The problem being when we receive new cars the license number is then removed from the old car and put on the new car (currently a new record with the old license number and new VIN is produced). I would like to be able to set the old records to be inactive, in others words not allowing entry or changes to the old records (so that it is available…

Is it possible to create a field that expands to accomodate the variable content that may fill it, without having a vertical scroll bar or using a repeating portal. eg. a Notes field. A film program, Movie Magic Scheduling, does this, expanding, contracting or just not appearing depending on how many cast members and so forth, are entered.

How do I copy data from one field to another field within the same file?

Thanks for the assistance up front. I'm new. I downloaded FM8 for MacOSX today. I have been editing from sample databases trying to do my on setups. This is probably very basic but I have not figured out out to do it: I am trying to design my own invoices. So far so good except for the following: I have a text field: Customer Acct. - (ex. of data is BHE006) Another text field: Customer Billing Address Another field: Customer phone number How do I set it so when I choose the number BHE006 from the customer Acct. pop-up menu the Address fields auto fill in with the customers info. Thanks for your assistance. Please be simple as possible …

Client of mine want a couple of fields to auto number themselves 1-40 each time a new record is started. I have the repeating fields(Input, Split) set up and they are showing up as 40 vertical spaces but no numbers are appearing in them. Any help would be most appreciated. -Chris

I am using this calculation to determine the age of an individual, but what I need to do is to compute the age using the Date of Birth from the Date of Death.. I replaced the [color:blue]now = Get ( CurrentDate ) ; with the DATEOFDEATH field, but an erronous answer. Just can't seem to put my finger on what I am doing wrong. Let ( [ now = Get ( CurrentDate ) ; b = DOBdateField ] ; Year ( now ) - Year( b ) - (( Month ( now ) + Day ( now ) / 100 ) < ( Month ( b ) + Day ( b ) / 100)) )

I work for a printer. I have a database that tracks the print jobs that come into our office. I'm trying to figure out a way to get some kind of flag (like a large red square) to appear in the layout if a particular check box or radio button field is selected. The scenario is this, I want something bright to indicate this client ordered a proof sent to him before we print the job. An ordinary check box is missed too easily. Thanks in advance, Kevin

I need to do a script that will assign a background color to a specific field (or container) based on a selected item in a value list. Is this possible (in FM6)?

Maybe someone else has had a need for this before but I can't find it anywhere. I'm needing to either print an index list from an indexed field (or) be able to import the contents from the indexed field from all records into a global field. Any ideas?

Is there a way to specify the field you want to modify by a calculation (if you have the name of the field stored in a variable for example) ? Thank you

I am not sure whether I am phrasing this correctly, but I hope some of you understand what I am trying to ask. I define a variable within a script (local or global variable), basically is to capture user input, once the user has entered the information, I want to be able to display the value of this variable on a layout, but I can't get it to work. Any idea how to go about doing this? To make this clearer, an example is to request user to enter the name of City where the customers reside, searching and displaying the found records is not a problem, but what is the easiest way to display the City on the layout where the found information are displayed? NotP…

This is a problem I've been working on for a while and I can't seem to figure it out. I'm trying to do a report that will track our profit margin for sales and give me totals based on each level of summaries. We're got a database with all of our order items and each item has the sale price and our cost. A simple calculation gives us the profit margin for each item. 1-(Item Cost/Item Price) When I do the sales report we list out each sale and get a sub-summary by Product, Vendor and a Total. I get totals of each of the sub-summaries (i.e. Total of Item Cost) but I want to be able calculate the sub-summaries to be able to see the profit margin like we do for ea…

My FM solution has a field containing amounts of different currency, e.g. A$100, US$200, C$500. I want to convert all of them into US$ by creating a calculated field. Any ideas?

I have a dialog box that asks the user if he is sure that they want to create a new record. What I am trying to do is have the dialog box get the current user and display "Are you sure 'CurrentUser' that you want to create a new record?" Is this possible?

Hi, Anyone know how to create a Unix timestamp that I can use for importing into my SQL server? (10 digit number, i.e. 2147483647) Thanks!

This might be the wrong place to post this, but I did not see a forum dedicated to calcs. If Field A is populated and Field B becomes populated, how do I delete the information in Field A?

Is there a way to auto enter alphanumeric characters for newly created records instead of numbers? For example, instead of auto entering serialized numbers i.e. "0001, 0002, 0003" etc... for each new record you create, you would get "A, B, C" etc. This seems like it would be easy but cant seem to figure it out. Any help is much appreciated!!!

Hi all, I am having problems with inserting pictures into my database. I am sure I am doing something wrong as the database is getting huge. I am inserting .jpg files from a photo file. Directly, by a right click of my mouse (in the container field) then finding the file from its location. I thought by doing that it would actually still be storing the memory in its contained folder and not in the database?? Am I talking Sh*te? Is there a way to store the pictures in a better way. The way I am doing it is a nightmare and making the database processing extremely slow...

Test file and screenshot attached. Why doesn't FM8A recalculate the Total? It recalculates it only after changing the layout (twice) or changing the window size. Why doesn't it recalculate this field? Thanks. test.zip

I would like to log what different users do in different fields. Today I have to attach button with a script to the field, that triggers when the users click on the field. This is not a good solution, since the field cannot be included in the taborder and you can easily forget to apply this button if you have several layouts with this field on it. Is there a plugin that can solve this, or any other good suggestion?

I have a date calculation with result type number. I am subtracting todays date to a due date. Get(CurrentDate)-Due Date, but the result is a very large number. I imagine that it has to do something like date to number format, but I don't find the DateToNumber function. I am in FMP7.

ahh! i set a global calculation to a text string, but it never loads when i open the database. the funny thing is that i have another global caculation in the same table and it seems to load perfectly fine. whats going on?!! help? using filemaker 7 not 6. edit: i'm trying to use the global calculation as an interface relationship

Hi all, I have to create a field with a default reference calculated value, but this value has to be subjected to modification. The field is a due date of a task based on a starting date of a project in a related table. I tried with auto-enter calculated value, but it doesn't work, since some of the fields used in the calculations might be empty at the moment that the record is created. I tried a self-relationship in the task table to try to lookup the calculated value of the due date to be looked up in a date field so it can be modified later, but it doesn't work either. Any suggestions?