Calculation Engine (Define Fields)

Hi all, Thank you for helping me here. I am creating an asset db for the company I am working for. I have an Assets table containing a field called Model Number and a Computer Types table containing a Model Number and a Model Name field. Asset::Model Number = Computer Types::Model Number, and the "Allow Creation of Records in this Table via this Relationship" is checked in this relationship. I put the Asset::Model Number and Computer Types::Computer Name in my Asset Details layout. The Computer Types::Model Number field is NOT shown to the user at any place. I validate Asset::Model Number against the Computer Types::Model Number (as a value list) when t…

Hello, I have two files in FMP7v3. In file1, two fields : reference and tick, both text field. In file2, the text fields are : reference, criteria1, criteria2 and data. The two files are linked by the fields "reference". The tick field in file1 is filled by a user several days after a record is created : it means that the record is released and available. Another user perform a search in file2 : he searchs on criteria1, criteria2 and on tick in file1 (file1::tick). All is well apart from the time the first user remains on a record in file1 after filling the tick field : in this case, the record doesn't appear in the found set. The second user is of course …

is there a way to check to see if a calculated ID is unique within the calculation? Or do I have to bring it to the script level? Is there a way to check the uniqueness of a value within the script other than going into find mode and searching for it?

I have a text field for ages, where specific age ranges are marked (e.g., 7 -17, 18 - 28, 29 - 39, etc.). I now need to calculate the percent of records in each age range. How do I do this? I'm assuming I need to sort and use subsummaries, but what fields do I define that will get me the percent? This should be easy, but I'm not sure how to do it.

Hi! I'm new so forgive me if I'm breaking a rule right off but I have a problem that I would really like to get solved. I would like to be sure that FieldA contains a value, any value, if FieldB contains only a certain value. I think this could be done with field validation but I'm not sure how to do this. For example if the two fields were Fruit and Color, how could I make sure that the Color field contained a color (red, green, yellow) if the Fruit was APPLE? If the Fruit field was BANANA then the Color field could be blank. I don't know how to do this. Can anyone help me? -Becky

Hi, I have a field called numbers which contains a set of numbers in text format. 145 156 233 455 What I would like to do is add a prefix and an underscore to each of the numbers, i.e. 2_ so the data reads as follows 2_145 2_156 2_233 2_455 I thought I could use the Extend function, but I guess that really reserved for calculations. Is there any one with some advice on how I can do this? Im using FMP6 Thanks all Jalz

I want to have a summary field, called total_stock that shows a summary of all occourances of a part number in a database. Unfortunately, what it does right now is show totals for ALL part numbers in the group of found records. basically, if I search by part number it works perfectly, but if I search by some other criteria, say, a PO, it'll display the total of all units in that search.

On each layout of my inventory database there is a Cost Value for that particluar item. I want to do a total of all items, and then create totals for categorized items (Equipment, Furniture, Computer, etc.) I'm a newbie at this so bear with me. To get the overall Cost Value I created a Calculation field named InventorySum and its value is =Sum (Cost Value). I then created a Summary field named CountRecord and its value is =Total of InventorySum (running). When i throw this foeld in the SubSummary part of a layout is gives me the value of one item. Where am I going wrong and how can i get this to give me totals based on my criteria I have setup in the db for…

Hi, i'm doing a calculation field but i want to add conditional steps in the calculation. This is for bibliographical references. My calculation is this: TextStyleAdd ( AuteurNom; Uppercase) & ", " & AuteurPrenom & ", " & TextStyleAdd (Titre; Italic) & ", " & Reference & ", " & Annee My problem is that if I don't have data in all the fields, it looks something like this: LASTNAME, , Title, , Year. I'd like to find a way to add a comma only if the field before it is not empty. So the same exemple will look like this : LASTNAME, Title, year I pretty sure I can do something with the isempty function, but, i'm not exactly su…

Am I correct in assuming that - all other things being equal - solutions with images referenced rather than imported/imbedded general will perform better (i.e. faster?) Also - I am developing this solution for someone who wants to use it as I progress. I give him a new version on a regular basis. The umbrella folder for images (mentioned in an earlier post) which resides on both mine and his computer - needs updating less frequently. What would be the simplest / most reliable relative path to the folder so that the images can be found on both computers? (Macs) Many thanks in advance. FMForums rules!

We recently upgraded to Filemaker 7.0. We have about 10 users. We currently save the name of the modifier and the date and time of the last modification. Now we want to have a list of 1.Modifier names, 2. Fields modified, 3. Date and time of the Modification. Having a button on the layout and having the user click that is not an option. We want this to be done automatically. Thank You in advance.

Thanks as always for your help. I need to get a total for a field. Here goes my best to try to tell you what I need. If (field) "Date Signed" is NOT empty then I want to get total for (field) "cTotal" I'm drawing a blanc on how to write this calculation. I know it is real simple, but.........

Hi, (Roster) I have a simple task to do but do not know where to begin to set it up. The idea is that i need to categorise a list of people into set categories according to their skill level. (There may be up to 10 levels). Then there is up to 10 different tasks to do. What the solution would be is to be able to have a layout display each set task each week to certain people, that are skilled in that task. EG. On WED and SUN of each week there is at least 5 jobs to be done on each day, but the same crew for WED as SUN of that week. Not all people can do all jobs. So i want to be able to create a new record each time and have the NEXT pe…

I am putting together a calculation which is trying to calculate a cost if the number of sites is in a certain range. The following code is what I have come up with and it does not seem to be working. Eventually once I get this basic function to work I need to add a equation to the output. For example (385+(Campground Information::# Sites * 1.55) Thanks. Case ( Campground Information::# Sites = 0 and Campground Information::# Sites <= 25 ; "385" ; Campground Information::# Sites >= 26 and Campground Information::# Sites <= 50; "400" ; Campground Information::# Sites >= 51; "405"; "no dues" )

I'm writing a script that creates a number of 15-min periods (Timeslots) over a period of days. I have been successful with the First Day (e.g. ((Time( 24, 00, 00) - CalItem_Start_Time)/60)/15) and the Next Day(s) but have run into a dead-end when trying to get the Timeslots for the Last Day. I have an End Time and want to take the End Time from Midnight but cannot get my head around it. Can anyone help?

Hi, I'm a newbie FM_DEV 7 user. Im trying to figure out how to repeat fields on command. I'm making a CD/DVD archive, and I want the fields to repeat only when theres more CD/DVD content to add. (e.g. if I burn a cd with only 2 files, there should be only 2 fields. 3 files, 3 fields etc.) Can somebody help me out with a solution?? ------------------------------------------------------------------------------ I've been reading this forum a bit and have figured out that there might be a couple of ways to solve this. Repeating fields or Tables. Maybe someone can tell me why one would be a better solution than the other?? Thanx a mil…

Hi folks, Is it possible to have a container field which shows the icons of the various documents inside of a remote folder? How would I do that? Each of our projects which are tracked in FMPro also has a folder on our server which contains documents related to that project. I'd like to be able to have a container field in each project view which shows those documents as icons, allowing them to be clicked to open in their native aplication Thanks, Evan

Hi there, I am trying to make a field calculation using the TextStyleAdd, TextColor, and TextSize functions. So far I have gotten the size and style in there ok, so it seems, but now I need to add color to one specific part of the calculation...and I need help! Here is what I have so far: If(IsEmpty(AreaofSpecialty1); ""; TextSize(TextStyleAdd("Area(s) of Specialty: "; Bold); (12)) & AreaofSpecialty1) & If(IsEmpty(AreaofSpecialty2); ""; ", " & AreaofSpecialty2) & If(IsEmpty(AreaofSpecialty3); ""; ", " & AreaofSpecialty3) I want the "Area(s) of Specialty" part to be in black as well as 12 point font, and bold. The rest of the field will sho…

Hi everyone. I am having trouble using a calculation to try to attach a value to a set of records found within a specific date range. For example, all records that were used in 2005 get assigned a 1, all other records get a 0. I have been trying to use the "If" function: If(Date Field >= "1/1/2005"; 1 ; 0) and: If(Date Field >= Date(1,1,2005) ; 1 ; 0) but neither seem to work. Can someone please tell me what I am doing wrong? Thanks in advance!

OK lets say for example that I have 3 text fields that all contain different strings of notes for their specific department. Now we need to combine all of those notes into one field so that all departments can see exactly the same thing in one field. To me, the simplest way to do this would be to create a new calc field that concatenates all three text fields. Then go back to each layout and replace the individual text fields with the new calc field. I am thinking ahead and forseeing that each department will not want to go to a centralized location to add their notes. They are going to want to type directly into the calc field that is placed on their layout and …

I have moved from ACCESS to FM and learning more about formatting field. I have a text field where users can enter a phone number only with no dashes or "( )". I want to validate the field where they must enter all ten number (areaCode phoneNumber) with no other characters. Then I want the field to display, but not store, the data as (xxx) xxx-xxxx. How can I do this?

Hello I'm developing a timesheet system and have it pretty much sorted (some teething troubles but help from the forums has mostly sorted out weird and wonderful problems!). However, I'm bemused by my lookup fields. I have one database with 3 tables: staff data, time data and weekly summaries. Staff data holds people's names, how many hours they're supposed to work each week (as we have some part time staff), how many days annual leave they get, etc. Time data holds the actual data for each day - it's actually viewed through Staff Data which is where people enter information through a portal. Weekly summaries - this exports the information at the …

Is there a way to show a field with a calcuation that shows time elapsed based on two fields? For example there is a "Start Time" field and "End Time" field (so say "1200" to "1315" military time) and the calcuation field would show "1:15" for the time elapsed. Hope that makes sense and THANK YOU in advance for anyone who knows how to make this calculation!

Hi, lets see if someone can guide me. I would like to use two tables. The first table will be used for data entry and the second table will repeat the information of one field of the first table to make a calculation. I need a feature that if i add a record in table it automatically adds a record in table two. how is this possible avoiding entering the info twice ? thanks,

Hey. I am an amature and am working on an evlauation database for work. Any help would be appreciated: I have a whole bunch of fields that have the same value list: "Completely Disagree", "Maybe", "Agree Somewhat", "Agree Fully". I need to be able to create reports with these fields where the fields can be evaluated as numbers, so that there would be able to be percentages of each different value, etc. I assume I need to do a calculation field coverting the values to numbers. I can't figure out the Case function in calculations. Can anyone provide help? What I have guessed so far is: Case (I can plan a research evaluation project from beginning to = "Complete…

Hi, I never really got this question resolved although it was posted in this forum in 2001. Here it is again. In a text field, when old records are being entered into an archival database, the records (in Australia, that is) previous to decimal conversion, (and that is over 100 years worth of records in our case) need to be entered as they originally were written. This is, in pounds shillings and pence. It is the pound sign (an L with two lines through it) that is needed. Just that , and nothing more, no calculations are involved with it, purely a text entry. Looks easy, and it must be, but the answer escapes me on our modernistic decimal keyboards. Rex

This seems like a simple thing but I can not figure out how to limit users from entering returns in fields. I have some applescripts written that do not work when there are returns in a field. How can I either limit users from entering them or how can I create a script to remove them from a field when exporting?

I am trying to use the DOB to work out the age from the current date I can't seem to get it right!! For example [color:"red"]DOB (6/22/1988) = 17 Yrs, 0 Mths, -16 Days is not right! The calculation I am playing with is as below [color:"blue"](Year(Today) - Year(Date of Birth) - If((Today) < Date(Month(Date of Birth), Day(Date of Birth), Year(Today)), 1, 0)) & " Yrs, " & (Mod(Month((Today)) - Month(Date of Birth) + 12 - If(Day((Today)) < Day(Date of Birth), 1, 0), 12)) & " Mths, " & (Today- Date(Month((Today) - (Day(Date of Birth) > Day(Today))), Day(Date of Birth), Year(Today))) & " Days" Any help w…

I am importing data from another program into a data base The basic data is the same, but it is contained in long strings which I have to break down into various fields and tables and reformat Most of the work is done but I am struggling with one issue I have one set of data strings which use one of two separators between values. All the data in this string is going into one field in one record II have cut it out from the long string and am down to the last step. The rules for the string are values are 3 characters separated by either a space or a "/". Each value is either a three character uppercase alphabetical value, or a "/" followed by two…

I am creating an order entry system. The items in the system MAY have a predetermined price, some may not and require the user to enter a price. Orders are entered through a layout using fields from a 'TunnelInvoices' table, and the items are recorded in a related table 'InvoiceLines'. I have the price field in the 'InvoiceLines' table set to auto-enter the related item prices from an 'Items' table (I don't use a calculation type so that the user can change the final value if there isn't one). There is one case where, if the ItemID = 100, the value is actually pulled from a field in the current 'TunnelInvoices' table. As a result, my auto-enter calculation is: If ( I…

How do I get a count for the total number of records with the same data in a field, in a subsummary? For example, I have a field called Interests, where some people have checked skiing, and others have checked swimming. I'd like a count of the number who have checked skiing and the number who have checked swimming. I've tried Count and Status(CurrentFoundCount) and both returns the total found (which includes skiing and swimming). I just want the count of the items in the subsummary. Thanks.

Is there a built-in function that will return the total number of records? If so, can it be used in calculations? Does it vary when it's used in subsummaries by giving only the total number of records for the subsummary? If so, is there a way to get the total number of records for the whole database, even when the calculation is made within a subsummary?

Hey everybody, hope you're all having a nice friday. i'm trying to share a bunch of files (references) with remote users in my office. i understand that they all have to be "talking" to the host computer but am not so clear on the different "volumes" that they need to mount. I set up a username and password for everyone to use to access the host computer but then that gives each person a separate volume when really all I want is for them to access one folder on the host hard drive that holds all the documents associated with the database. Is there a simpler way to pull this off? or do you know a place that explains the process of mounting different volumes?…

I have a problem with a calculation / relationship setup. Basically, I have a table full of lawsuits, and partes are joined to the suits table. The problem is in the display of the party names. The display can only have one plaintiff name vs one defendant name. If there are multiple plaintiffs or defendants, the name of either will have "et al" on the end of it. I need to figure out how to calculate if there is more than a single plaintiff or defentant involved in the suit. I have a lawsuits table, a partiesInSuit join table, and a parties table. the partiesInSuit table is setup like this: suitNum - sequence - partyid - partytype 1400 - 1 - 2…

I have a field, RP_Status, that is a radio button set with a custom value list. There are two options, "Open " and "Closed". I am attempting to bring those into a calculation field, RP_Status_In_Color, with this calculation: If ( "Open" ; TextColor ( RP_Status ; RGB ( 0 ; 255 ; 0 ) ) ; TextColor ( RP_Status ; RGB ( 255 ; 0 ; 0 ) ) ) This is not working. Can someone tell me why this is not working? And could someone point me in the right direction? Thanks!

Hi Everyone! I use TrimAll( field; 1; 1 ) because ... well ... because I saw -Queue- use it (and he's XP and American and just knows mostly everything) so I figure it's correct for me. But I'm not satisfied with basing my understanding on ditto-behavior. I've studied everything I can find on this issue (and re-read Help a hundred times) and my confusion remains. You ever do a Google search for Unicode? It's a lateral universe. Code charts don't even list Verdana. And the Index doesn't even list FONTS. From FM Help, I deduced that I am non-Roman (simply because my fonts didn't appear in the list qualified as Roman). Help says "Any character whose unicode…

Is it possible to allow data entry into a field in Browse but prevent it from printing? Reason: Our company requires that we enter our initials on each transmittal that is sent out of our office. We do not want the initials to show up when we print the record.

I am very much a newbie to filemaker and am using the FM7 trial version at the moment. I am working on a plant (as in garden) database. In each record there is a pic of a specific plant and various fields with information on the plant and its growing culture. There are also 2 small pics (thunbnails) that will show a couple other plants in the database that could be used in design with this plant. I want to be able to click on one of the thumbnails and have it act as a button that opens up that plant's specific record. I came across a script to.. go to a first, last, next, etc record - but couldn't find a way to go to a specific one. Would appreciate very much yo…

Hi I am making a kind of document management. I insert a file reference to a container field. I would like to copy this files name to a normal text field as all the documents are named so I can autofill other fields and the user do not have to write in those. My problem is that I cannot find the way to copy the file name to the text field. Do anyone know how to do this. Thank you, Jens Peter

Hello, I have a report I need help on. I have a table of part number transactions that has a part number and the amount used for that transaction. I am generating a report which is sorted by PartNumber that correctly shows the Usage, StandardCost, and UsageValue. My fields are defined as such: Usage is a Summary of Total of AmountUsed StandardCost is just a Number UsageValue is a Calculation = GetSummary ( Usage ; PartNumber) * StandardCost I am having trouble defining a grand total for all the UsageValues at the end of the report. Is it possible to have a grand total of a field defined by a GetSummary? Thanks,

This almost goes in a miscellaneous section. It's a speculative question ... In vs. 7, both Case() and If() short-circuit In vs. 7, both produce null on false results In all versions, both are boolean tests. The only difference, as far as I can tell, is that If() only allows two options. If this is true, why did FileMaker keep both? It seems that conversion-time would have been perfect to streamline and eliminate one. They could have kept Case() and just re-named it to the logical 'If'. Are there reasons both were kept that I don't understand? LaRetta

This may be pretty simple, but I'm new and not seeing how to do this. I have a calculation that I would like if the result is a negative number, change the text color to red.

I wish to create a serial number based on this calculation... The authority prescription number is eight digits in length. The first seven digits are the base number, incremented by one for each subsequent prescription, with the eighth digit being a

I am working in FM 7.0 and am creating email templates through calulations. I am trying to style the text with bold/italic/underline etc. I have attempted the instructions provided in the help menu but nothing seems to work. Ordinarily I am creating calculations like: ("Hello " &data::first name & "," & "

this is very strange. Up untill last week, my system was fine. I have a layout that has a summary field (total paid)on it. But most of the records are done on a different layout (payment). When I add a new record, on the payment layout, now it starts summarizing the field on the total paid layout. It never did that before. I guess if that is supposed to be normal because it is on the same table, then I should create a script that will set field to the total of the found set. But how would it go? Or is there something wrong with my system?

I am creating a database for inventory. The first field is bar-code, which will be scanned in. Apparently, this field will be unique since each item has a unique bar-code number. Right now, when I am trying to add an item whose bar-code id already exists, a message will pop up saying that this field must be unique, and then I can choose to revert the field or not. Is there a way to show the existing record instead of just showing such a message when adding an item whose bar-code already exists? In a word, if unique, add a new one. If not unique, show the existing one. Thanks. Jie

Hi Everyone, This is a hard problem to explain but I will do my best. I want to make a field not only reference another field, but also be conditional upon another field. Here's the situation: Dept. A enters a Piece # and other info Dept. B then references the info through piece number, makes piece, then marks complete through a radio button. This info then is referenced back to Dept. A as completed. Now when Dept. B looks for open jobs, all that is listed are the pieces marked "No". Hope it's not to complicated to understand.

Is it possible to use a table with more than 2 columns to feed a database? I have a salary table with 130 Range and 6 Step combinations. I would like to put in the employee's Range and Step and have it pull the hourly rate of pay from the salary table. I can make a relationship between the ranges but that does not address the steps. I am a very basic filemaker user. Thanks in advance for any help you can provide.

I am trying to step up a auto entry calculation that gets the first letter from the FirstName field. I can get all the text that is written in that field, but I only want the first letter. Does anyone know of some way to do this? I am pretty new to FileMaker, and I cannot figure this out. Thanks everyone -mushi

I am making a patient visit database where each record has two important fields. I need to keep both fields in the same record as they are both associated with same visit date. I need to track the date each field is modified independently. I don't think I can use the modification date field as that would only tell me if either one was changed. Any ideas are greatly appreciated I am relatively new to developing databases and this site has been such a great resource thanks to all of you!!!

I've got some quickly shot .MOV files from a small Kodak digi camera that I hold on my mac... unlike other .MOV QT files filemaker 7 will not show the first frame of the movie in my container field... seems to me something a little askew with the movie... any quick solutions?

A field has Validation during data entry = required to be not empty (Display custom message on error). While creating a record but before entering anything in this field, a user tried to quit FM. The validation message popped up as usual. Clicking OK does not return the user to the invalid field. It just causes the dialog box to disappear and immediately reappear. We had to force quit FM. (Fortunately this was on a test file so no data was at risk). Any suggestions as to ways of avoiding this or at least getting FM to let us put something in the field? Lynn

Can you please help me! I have 5 numeric textboxes in total. Textboxes are called testone, testtwo, testthree, and testfour. They should give me a sum on textbox 5 which i called "sum". The sum textbox should only be totaled if 1, 2, 3, and 4 have a numeric value. If any of the 1, 2, 3, or 4 textboxes have an empty value, then the 5th textbox (sum) should remain empty. In other words, My 5th textbox should only sum up if all 4 textboxes have a value!!!Thanks. How should i write my calculation and where?

Hi, how I calculation the leave below: 1. This year leave (18)days. 2. This year leave taken (10)days, balance (8)days. 3. Next year my leave at to (20)days, (8)days carry forware to the new year, so total is (28)days. Ok! any advice for me? Thank!

I'm pretty sure this is a define fields question and not a layout question. So I thought I would start here. I'm trying to produce a set of dynamic buttons which change their titles based on changes to the records in a different table. I am developing a bunch of scripts for task management and I am trying to minimize button maintenance. I'm thinking about using LaRetta's concept of holding graphics in a script parameter. If skippy is in the building (I call this the Elvis button) his face shows up and you click on it. If he's not, you take him off the list till he shows up again. My idea is to create individual fields and use them as buttons …

I understand that the date format used for entering dates is the US format. I have changed the date format for displaying date on a field (I thought) and all date fields changed to the same format ... as far as I could determine. My main question is ... given that other countries use different date formats wouldn't it make sense to allow for other entry formats ... for example in the Preferences? Why should other users have to use complex calculations to do this ... or is there some plug-in or function that will do this?

What's the secret to getting Global Calculation fields to update themselves? I want to display the current AccountName on a layout. I have a global text calculation field where the calculation is set to "= get(AccountName)". But when I change accounts using the Re-Login script step, the global calculation field does not update, even with a layout refresh, or any number of other things I've tried. This is also the case with other displayed Global Calculation fields, like one I have for displaying the the Get( PrivilegeSetName ) and Get( PrinterName ). These values must be global variables, because this is a multiuser solution, and the info is distinct for each client.…

hello the title speaks for itself: Is there a script or calculation that can display random images from cantainer fields from another table or file? Thanxs

I have a file with one specific standard text field blank. All other fields show correctly. CTRL-I shows a very long (correct index) of what SHOULD be in the field. Define Fields shows the field is indexed. But performing a manual find using * produces no records. There is (and always has been) only the original layout FM created. And yep, text color is set to black. I tried running Replace Contents = thatField through it but it didn't make any difference. Can I force it to reindex the field? I don't know if the data is gone and the index is wrong - or whether the data won't show because the index is wrong. I just want to understand it. It's not logical. …

I need a field to Enter a # starting with 1...no big deal huh. So I have two feilds. Job_number and Change_number. Change_number is the feild that will need to change on creation of the record. It needs to look to see if there is a record or records with the same job # and add 1 from the higest Change_number of the same job #. If there is no other record with the same job # then it needs to be 1. Example =============== 1st record Job_number = 100 Change_notice = 1 2nd record Job_number = 200 Change_notice = 1 3rd record Job_number = 100 Change_notice = 2 4th record Job_number = 100 Change_notice = 3 Thanks Devin

If I have a simple one to many relationship, how do I get a total count of related records from the master table?

Hey...I'd like to create a field that will show a timestamp that is updated only when the user manully pushes a scripted button. In others words, I want the user to be able to control when the timestamp should be update based on the fact that only certain fields on a layout have been changed. Any suggestions how to create that field and corresponding script? thanks

Hello Is there any way to show a specific set of records in a portal with a script or calculation. For example if today is Jan. 15, I would like to see how many orders are specified for Jan. 15. Thanxs for any suggestions

Thanks for any help in advance. I'm still pretty new to FM7 so this may be an easy question. I am trying to make a Layout that "looks like" a spreadsheet. We have a program now that runs on a spreadsheet but is way to jumbled from years of entries. I'd like to keep the format similar so it is easy to use, but easily searchable by a unique code we assign. I entered all the fields i want and then tried to "copy" them by using the field drag option in layout view, but all this does is copy the data from the first field. I would like to make it so that each entry is unique. I thought I found an option like that before, but I can't find it anymore. Thanks again for any…

Hello, I have a large amount of records that have HTML in them, and I'd like to strip out all of the line ending charaters. Any suggestions on the best way to do this? Thanks, - dstefani

The following works but, there has got to be a better way. What can be done to incorporate this into a Custom Function that can be used in other fields in this table or in other tables? Any suggestions to improve this calc would be apreciated. ------------------------------------------ //Combine address fields into a label like field without any blank lines if data is missing Let ( [ FN = FirstName_t ; LN = LastName_t; MN=MiddleName_t;CO=Company1_t;DP=Department1_t;L1=Address1_t;L2=AddressLineTwo1_t;CY=City1_t;ST=State1_t;Zip=Zip1_t;CT=Country_t] ; Case( FN="" and MN="" and LN="";"";// No name FN="" and MN="" ;LN &

I am trying to create a job ticket solution. I have a Job_Ticket table and I have an Archive_Manager table. The way I have it set up is after the job is done, the user goes to the Archive Manager to close the ticket and archive the job. In the Job_Ticket table I have: A serial number field. (Job_Number) I have a text field. (JT_Name) In the Archive_Manager table I have: A popup menu to show all jobs from (JT_Name) that inserts into a field (AM_JT_Project_Name). A radio button field (JT_Status) where the user selects Active or Closed. In another layout I want to have two popup menus: 1) That shows all jobs with their job number. I got this work…

Hi folks, After thinking I had set up what I wanted, a container filed into which I could throw links to all documents related to the project, just now I realized it will only accept one at a time. What do you all recommend as a method for showing a collection of icons(links) in a single view? Thanks, Evan

Hello. I've been scouring these forums and everywhere trying to do something that I believe is very simple, and yet I can't seem to do it. I have calculated some file names of image files. I have several fields that use those calculated file names and then put them into container fields. Basically this a database to show a main view of an item, plus alternate views, so the image file names are calculated as follows "<productname>.jpg", "<productname>_reverseangle.jpg", "<productname>_top.jpg" and so on. In some cases I don't have pictures for some of the variations, and so filemaker will put a message into the image container field: "The File Canno…

I am trying to display on a layout the date 3 days after the current with little success. Any thoughts?

Hi, I have created a solution whereby it involved a max limit a person can see. This is the situation. User A is having a max viewing value of 10000. So all the records within the range of 0 to 10000 can be displayed out. Let say I key in a new record where by the value is 20000. How do I make the system where by I can only view the records of 0 to 10000 and the records which exceed the limit that created by my ID ? Thanks.

Hi, Anyone outthere has a tool to translate a number value to word value? e.g. $500 translate to "Five Hundred Dollars" Thanks, Garry

Over the years, I have bemoaned Filemaker's apparent lack of a truly unique serial number field. Imagine my profound surprise when I found that FM has a hidden unique serial number field. Filemaker uses numbers, just like the rest of us, and they're hidden under the Get(RecordID) function. Setting up a key field using this field is as simple as auto-entering the Get(RecordID) calculation in a numeric field. It is NOT possible to create duplicate entries using this number; FM manages it quite simply. There's no need to worry about re-sequencing Auo-Entered Serial numbers and overlapping IDs. Now, I know that importing new records into a relational structure usi…

Greetings! I am working on my Filemaker Solution (backbone to a Photography Studio). On my Order Page, I currently have the following Calculation for the Total: ((((Invoice::Subtotal - DiscountDollar) - Invoice::PercTotal) + Invoice::TaxTotal ) - DiscountCredit) Subtotal/Tax should be self explainitory... The Dollar Discount is just that - an option to take $X dollars off of the total. The PercTotal is an option to take a percentage off of selected items. Discount Credit is the new part I am trying to Add (everything minus that has worked great up until now). Based on my business (or maybe just my nature - I tend to get into a lot of 'Barter'…

Hello there. I''ve created a checkbox field of client names on my layout of single publications which they run ads in; meaning many clients for one pub. When I run a report by client to show the list of pubs for that particular client, the client name is defaulting to the first client name shown on the checkbox field rather than the name of the individual client I've found in my found records set; even though I've made sure to set up the field in my report as an edit box field. Any suggestions how this can be corrected? thanks!

I want users to be able to change labels of certain fields by a script (There are several fields with a ckeckbox set and they are used temporarily. Whenever a certain period of usage is over, the tags can be claered and used for another purpose and therefore have to be re-labeled). I did this with global fields what worked fine in the first point, but - In a hosted DB environment global fields can't do the job anymore as the react individually for every user - means the new name just appears on this user's screen who did the change. And whenever the database is closed and opened again the global fields are set empty. - So plan b was to use text fields and replac…

I have a database that has a table "Projects" related to a table "Issues." Each project has a project number (ex: W4012). Each project has multiple issues. Each issue then has a reference number, which is a numerical count of the number of issues concatenated with the project number. So the reference number for the third issue in a project would be 3-W4012, for example. The problem comes in counting the number of issues per project. I previously had a calculation field in the projects table that counted the number of related issues, but that caused problems because it didn't always update and so I would get duplicate reference numbers. The system now works wi…

We have a database which Management wants to track by Time how long work sit in each Department If Start Time is 6/20/2005 7:37 AM and Stop Time is 6/22/2005 7:37 AM then Wait Time should be 48 hours. But If Start Time is 6/23/2005 7:37 AM and Stop Time is 6/27/2005 7:37 AM then Wait Time should be 48 hours after substracting 48 hours for the Weekend. Also would be nice if Holidays were substracted, too Examples: Field: Start Time Format: TimeStamp Field: Stop Time Format: TimeStamp Field: Wait Time Format: Time Any ideas ?

Ok here is the 3 files of my program that use to work like a charm but now they do not work. I need all my transfer files in billing1 and Monthadvopt to work like they should. The way they are set up now they use to work in Dev6 but now in 7 nothing is working and it has got me stuck big time. I need to finish the Monthadvopt but since none of the transfer files are working nothing is working like it should. Thanks in Advance Tony C. Decavalcante MonthAdvopt.zip

I have a database and two of the fields are repeating (14 repeats). One field is called Code and the other one Number. If there is an entry in the Code field there is always a corresponding entry in the Number field. However, not every field is used so it happens all the time that in one record Repetition 1, 3, 6, 7, 10, 11, 14 are used but that this is totally different in the next record. Entries do not always start at Repetition 1. What I want to achieve is this: Say that a record has an entry in the Code field in Repetition 1,3,6,7,13 with the value of T101,T105,T101,T110,T105 and the correcponding values in the Number field of 10,20,30,40,50. I want to add all …

I've been trying to find a solution to this problem so this is my next big idea. I've got 3 main fields for this problem. Filed A, Filed B and Filed C "Filed A" and "Filed B" is a user input filed, while "Filed C" needs to be a auto-enter calculation I think.. "Filed C" is a serial Number So in english this is what I want it to do. If "Filed B" has a value then use that vaule and find the Record for "Filed A" that matches and input the Value From "Filed C" of the found record. If filed B is blank then enter the the next serial # value and it must be unique. So what I wanted to do is to be able to find certian jobs that our common. It's more…

I have 4 steps in my production process. I have a Step field and and a Status field. Example: Step 1, Ready; step 1 complete: Step 2, Ready; Step 2, Complete and so on. The Steps are listed in a pull down menu next to the Status field. As I moved through the production process I use those two field to indicate the progress. As I complete each step I want to stamp with the date a seperate field to indicate when each step was completed. My field calc is as follows: If(Step="Step 1" and Status="Complete", Status(Currentdate), "") So once those 2 fields equal the step being complete is stamps the time. How do keep the stamp once I go to step 2. Once I move from Step 1 …

Hi, I have a calculation that is looking at a numeric field (NUM): if(NUM <4; "ok"; "not ok") (The calculation is actually more involved, but this is the part causing problems...I've simplified the results - "ok" and "not ok" - just for ease of explanation here.) The problem I'm seeing is that if NUM is left blank, the calculation evaluates it as zero, thus causing the result to be "ok", when I need the result to be "ok" only if NUM contains 1, 2, or 3. I would imagine that the simplest way to resolve the issue is to put an additional "if NUM is blank then" condtion into the calculation, but for a variety of reasons I would like to avoid this. Doe…

I have to run mailing labels for several different titles (fields). This produces multiple duplications (Sales Manager is also listed as General Manager or Owner). I don't care if the which title (if any) appears on the label but I want only one label per individual. If I export records into a new database, it takes a long time (about 10 fields involved). But, I'm OK doing that as long as there is a simple way to dedup once I have them together. OR, is there a more mature way of handling this? Like can someone be paid to write a script that will give me the output I'm looking for? Thanks.

I have a field called "Paid By" everytime a customer comes in i have to determine what they usedd to pay, mastercard, visa, cash etc... At the end of the day is there any way of determining how much money was made by each payment type. Thanxs

Hi, I am really new to filemaker pro, and i have one question. What must I do to convert data (english) to data in another language (french)? For example: If i am inputing data in english, is there an option to convert the english data to french? Sorry if i'm not too clear. Thank you

Found value count and word count functions... is there a way to count characters in a field? What I want to do is give a field a max num of characters but do this as a calculated validation so I can display custom message. (I have some other validation criteria also so I don't want default validation error msgs here)

Hello I'm trying to create a timesheet system. I have one table that is where time data is stored for each day for each person (one record for each day for each person). I have a table where information on each member of staff is stored (Name, how much holiday they get, how many hours they work each week) and I'm trying to create a table that pulls the information together for each week. Each member of staff has a unique ID and I'm using the week numbers to identify weeks. The time data table works fine. I can enter a week's worth of data for myself for instance and it calculates how much work I've done, how much overtime or not, how many days annual leave or sic…

Hi, I am somewhat new at using FM6 but not a complete "newbie". I have a field that needs to be exactly 10 digits (no more or less) and the number can start with leading zeroes (ie - 0000123456). I cannot figure out how to set up a field like this. I've tried to do it using calculation but cannot seem to get it to work. My application has two fields in particular, one is 8 digits and one is 10 digits and my end users occasionally put the 8 digit code in the 10 digit space thus causing some reporting problems. Anyone done something like this before? Thanks in advance!

OK I want to be able to set up a calculation field in fileone that goes and get its data from filetwo. Like cust id=Filetwo::Cust Id. If there is anyway I can make a field grab its contents from another file 100% of the time fill me in plz!

I have a calculation field that concatenates some literal text with some numbers. I'd like to get the numbers formatted to include commas and two decimal places. Does anyone know of an easy way to do this. This text will end up in an email using the send mail script.

Hi All, Sorry for the noob question, but can someone tell me how to do the following? I have 2 tables: Image ----- Image serial (number) Image Name (text) image thumb (container) Print ---- Image serial(number) print serial(number) Print Size(text) Print is linked to Image via Image Serial. I would like, from the Image layout, to be able to tally the total number of prints in the print table for the currently selected image. I would also like to tally the number of prints with the current selected image number for various sizes, simultaneously. So for example, I want to know how many 16x20 prints I have with image se…

I'm adding on to a database for a law firm. The main file has one record per case. The new sub-file will track pleadings filed in a case. One case - many pleadings. I would like to create a container field in the pleadings file and use that to link references to .pdfs. The .pdfs are saved on the network on a shared drive in each individual case file. I know how to build the relationship, create the container field and link the object as a reference. But, here's the rub. I tested the solution and works great on my machine, I click on the image field, the packager.exe thing comes up and asks if I want to open the adobe file. The file opens in adobe, and I can see th…

Is there a way to write a script that will take text from a tabbed .txt file and create field names with the text. Or am I just being cheap and should buy a third party software

Dear Folks, I am probably getting ahead of myself as I'm just now getting the bugs worked out of a basic contact/client/staff/project management DB. However, I'm already dreaming of the next step. Please let me explain. My office, part of a state agency, provides our clients (cities throughout the state) inexpensive graphical advice on architectural/planning/historic preservation issues. Most projects are done by a single employee, using a variety of graphics applications as well as some hand drawings. Our method of storing the files, both when in progress and when completed, is not well organized. Currently, an employee will keep all work-in-progress file…

New to FM, I have figured out a lot on my own and created functioning solutions for our uses, however I'm frustrated here (may be a very simple step I don't see). Help would be most appreciated! Need to auto-generate serial ticket numbers for each series (theater). I have a series table and a subscription table in addition to the main contact table. There are about 15 series records. To be consistent with current usage, subscription (ticket) numbers should read "abc05 001", "def05 001", etc with the first set of characters corresponding to the series. I set up a field in "series" named "series_code" for that. Tried using a look-up and a calc but I'm doing somethin…

I oversee a department that uses procurement cards (AKA VISA credit cards). When the statements come in I collect the info (description of purchase, what program should be charged, and the receipts). I have to enter this information into our financial database. The primary key is each purchase. Secondary keys are who makes the purchase and the statement due date. Additional fields are the description of the purchase and the program code. What I need is something that takes the information that I need from each record (in a found set or portal - I have to submit the information in the financial system by card holder and statement date) and places it all into one…

Hi Everyone, I have an Inventory portal displayed on a Products layout. They are (of course) joined on ProductID. We view this portal descending by MoveDate. I have a summary field in Inventory set to Running Total. However, this running total only displays in ascending order (by record creation) it appears. My Users only view the top entries of this portal (latest entry). The current inventory balance listed next to the latest date does not match. I know I could place the field outside the portal to display the current balance; but the running total (back through time) is also important to view. I've tried sorting via Relationship, portal, Reor…

I want certain fields to be "starred" out like a password input would be. I currently am using a password font that I downloaded, but not all systems have this font. Is there a way to have FMP6 star out the fields without having to use a special font? If not, is there a way for me to embed the font-face that I want to use in the database itself??? Thanks in advance.

I have a field that usually contains a dollar amount. But sometimes I'll want to be able to put in text instead. So I created a field with a type of Number, and allowed the user to override. I then set the number formatting of the field to currency. When I type numbers in, all is well. But when I type text in, it does not appear in the field on my layout. The data is there, you just can't see it unless you select the field. What am I doing wrong here? What I want is a field that will automatically format to currency any number I input, but also display text if I input somethign else.