Calculation Engine (Define Fields)

I want to remove everything left of @ from email address field. I'm having trouble figuring out the calculation. I want my end result to be @domainname.com.

Hi, How can I validate a field to avoid duplicates. i.e. CompanyID 1 = ABC Company CompanyID 2 = XYZ Company And if ABC Company is entered again, it will link to CompanyID 1, etc. Many thanks for your help, Andre

If you want to call attention to something on a layout for instance?

Hi, have a little problem and can't seem to find the answer. I have three different project report's (column). 1- Enquiry 2- PI 3- Order Each report shows different fields but the most important and repeating field is the Status field (E, PI or O) As soon as I go to layout Enquiry Report I would like Filemaker to only show only the E values in the Status field, without having go through a search mode or button. How can I do this? Dutchy

I’m trying to create custom Field Labels that the user can specify and choose with the category. But I have problems getting a value field from fields or one global field. Maybe there would be a easier option? Please have a look at this sample. Dynamic_Field_Labels.fp7.zip

Hello. I think i will win the prize of the newbie of the year! im encountering other problem. I want to make a photo directory. The photo directory will be a layout with the pictures of all the members, when you click the picture it will link you to a main layout where you will fill the other things of the record. The only part that im missing is how to make the list of pictures, not only vertically but also horizontaly. Can somebody help me with that? thanks!

Hello, i have some icons in the layouts to make it look nicer, i have a question, if i put the picture in a container is it better than if i go to "insert -- picture"? i want to know cause i have the same pictures repeated many times and want to know what would be the best for the performance of the database. Thanks!

Hello, im making a layout that is going to viewed in "list view". I want that when you click the name of the field that appears in the top that group of field will be sorted ascending, and if u click again it will sort descending, like if you were clicking in a "Table view". Thanks!

Hi Anyone know if it is possible to enter and save data using the same field(s)? For example, if you had 100 weather temperatures to record, so in the first field you enter the time of day, in the second field you enter the temperature then click a button to save this information. Then you enter the next figures in the same fields..? Thanks Trevor

I'm trying to use colors held in a container field to colorize large areas on layouts. As shown in the screen image file below, there is a strange effect showing up along the bottom edge of the displayed results. I've tried various combinations of Enlarge settings with no improvement. A sample file is attached. Would anyone know why this is happening? Is it an "undocumented feature" that serves some purpose? Thanks in advance for any help. (I'm running 8.5 Developer under XP) ContainerTest.fp7.ZIP

Hi, I'm working on a work time tracking solution. Currently the work time data consists of begin and end times (timestamps) and four breakdown fields, where the elapsed work time is distributed according to its time slot for calculating corresponding time bonuses (normal hrs 6-18, evening hrs 18-22, night hrs 22-06 and sunday hrs). These all are static fields (they come from a tracking device), which means that when the user wants to edit the length of a work shift (begin or end time), the breakdown values don't change automatically. I've been trying to figure out calculation fields for these breakdown time slots, which would use the begin and end timestamps, an…

Hi I am trying to change the Time Card solution supplied with Filemaker 8.5 to calculate overtime worked in the morning. We officially start at 8:00 AM. That's when we get paid from. If we are asked to do overtime ( Come in early ) we must clock-in before 7:34am before the overtime rate starts. ie: Field "Start Time" = 7:00 am........Field "Morning Overtime" = 1.00 Field "Start Time" = 6:30 am........Field "Morning Overtime" = 1.50 Field "Start Time" = 7:35 am........Field "Morning Overtime" = 0 Can anyone help me with the calculation?

I use fmpro8.5 on macosx. i am trying to duplicate the value of a calculated field in my 'contacts' table into another field in the same table. the field i want to duplicate is the "fullname" which is calculated as "lastname"&", "&"firstname" Because i want to be able to add a new record using the fullname field, i need to have a text field (call it fullnamelookup) that looks up and stores the value in the fullname calculated field. I have been able to create a self-join of the table,using a second occurrence of the 'contacts' table and joining the two table occurrences by the unique contactid. i then made a field fullnamelookup with autoentry lookup of the …

Ok, I'm somewhat new to FM. I run a short-term rental business. I have two tables, one with my inventory, one with rentals. What I want to do, is create a field in my inventory table, letting me know whether that item is in stock, or out on a rental. I have a field in my rental table indicating whether that rental is still out or whether it has been returned. I want to create a calculation that looks at all the rentals I have had for a particular item, and if any of the rental records say that the item is out, then the field in the inventory table will say "Item Out". Any ideas?

I am managing a large inventory database in which each item, jewelry, is photographed and imported into FM 8.5. The imported photo is darker as displayed in FM than when it is viewed in Photoshop or in any other application. We're tried making the photos lighter before import but then we also use the photos to post on a website so we have to make two versions of the same photo. Does anyone know why this is happening?

What's the easiest way to work out the nth "working day" of a month given that a working day is Monday-Friday?

I keep getting an annoying dialog box on entry of a field (defined as check-boxes); The only way to stop this is delete the field and start-over again, re-defining the list values... Frank.

How do I create a Field that will tell me the total of Records there are based on a single field containing certain data. Example: I have a Field where the user can select Level 1, Level 2 or Level 3. I would like a Layout from another table (Related) that will populate the Total of Level 3's, Level 2's and Level 1's have been reported. Thank You

I am building a legal database, where we have loan summaries. All the calculations for giving us the totals etc work just fine. The only thing is that the lawyers want details, as well as the totals. So, the total would be outstanding amount for range 06/01/06-12/01/06 is $600.00 ...should read: 06/01/06 - $100.00 07/01/06 - $100.00 etc.. Is there an easy way to do this in filemaker, or do I have to try and incorporate excel in some way? Please let me know if I need to elaborate any more than the above. (working on this for a few weeks leads me to believe that everybody are on the same "page" as me) Thanks!

So, I am trying to recover, and any ideas would be appreciated. I have a database with about 7,000 records in one table. I created a calculation that was supposed to "catenate" two text fields. The calculation was (from memory) something like Let ( [$value1 = field1; $value1 = Trim ($value1); $value1 = $value1 & If (Right ($value1, 1) ≠ "."; "."; ""); $value2 = field2; $value2 = Trim ($value2); $value2 = $value2 & If (Right ($value2, 1) ≠ "."; "."; ""); $value = $value1 & " " $value2 ]; $value; ) So I typed this in, hit return, and suddenly FMPro says that it is taki…

Hi I have a database where i need the total activity time of a staff member but adding only the records where the staff's time allocation equals "stage 1". When the staff member enters in there activity time, they enter in what stage it was aswell. So in another database i want to show the total activity time the staff member has done according what stage field equals. There is a activity database, staff database and management database. Basically how do you calculate a total sum of a field but only where another field = x? Sorry if this is not understandable, i'm a newbie to filemaker. Also this is in FM6.

Hi, I need to change the color of a field (City) base on another field (Country) that contain a value list. EX: My value list is different country; USA , Canada, UK , France , etc. This Way, if I set the country field to USA the city field become Blue. or is I set it to France the city field would become green. Not the text, the actual color of the field . Right now, I am using multiple container field with global storage to get color from a picture wich is a solid color. Then in a calculation field (color_city) resulting in a container, I determine wich color will be use. It work pretty good, except that every time I open the file I need to restore…

In my database I have a couple of fields that are set as drop-down lists. The values set in these fields are the only values that need to be filled in. Meaning I don't want the user to overwrite these value's unless they are added with the edit item. NO other values should be able to be filled into the field. How can I do this? Dutchy

Hi, I need to do a statistical calculation in a table. I need to calculate the selling price variation of the same house over each sells. By example we have a sold table which is related to himself with a field called fullAddress. A house can be sold many times. I want to calculate the price fluctuation from the previous sell of this house. By example: House on 123 Fake street Date Price Fluctuation 2006/12/10 125 000$ 25% 2004/06/06 100 000$ 25% 2000/02/13 80 000$ N/A Need help please... Thank you

Hello; I've tried the Let Function many times, but I always get strange errors, so I end up doing it a harder way. I have read the Filemaker Help, many times, and modeled my calcs after it. My newest one looks like: Let( [ H = Int ( Latitude ); M = Int((get_lat_long3-H)*60); S = Int(( Int((get_lat_long3-H)*60))-(Int((get_lat_long3-H)*60))*60);]; H&" Degrees"&M&" Minutes"&S&" Seconds) I keep getting "List Usage Is Not Allowed in This Calculation" When I remove the "[]" I get an error regarding "M" not bieng a field. Any help would be apperciated.

I have 3 files(Job Type, Count, Price) each with 5 repetitions. I have it to where Price is auto entered using a calculation. The problem im having is this: When I enter the Job Type, and Count in first repetition, it works, Price is good. When I enter the Job Type, and Count in the second repetition, it stays blank. Even if i use the same info from as in the first on. The price field does show "?," while im typing in the Count. But once it matches the right count for the price to show, it goes blank. I even tried making a script, and using SetField. But it only works on the first repetition, not the second one. Any Ideas?

I did do a search on the forums and couldn't find the solution to my problem, so sorry if it has been answered before. In this example I have two tables, with related field Work Order #. The two tables are Work Orders and Invoices. When an order is complete, its Work Order # is added to the invoice table and an invoice is generated based on the Work Order info. An invoice can have multiple Work Orders on it, but these Work Orders MUST have the same PO#... basically how do I validate the entry of the Work Order #s so that only Work Orders of the same PO# can be entered. Heh, I hope that all made sense. Attached is a sample I've made. Thanks in advance …

Hi I want to be able to enter information on one record of "name" and amount" but want to use the same fields over and over as there will be many entries. (Each record represents one month). Is there a way of doing this so that the user types in a name and amount and then hits a "save' button, saving the info so its not over written when you type the next 'name' and 'amount'? Thanks Trevor

Hi, I've been looking on the net for a while now but I can't find an answer. I'm looking for a Custom Function to create an SHA-1 or MD5 hash in FM7. Does anyone know where I can find such a custom function? Or does anyone have such a custom function for me? (I've found some plugins but I want to do it without a plugin!) Thnx for all of your help!!

Is it possible to use a container field as a sort of single radio button? What I mean by this is; I currently have calculated fields to show a 'star' rating - 0 to 5. I use a drop-down for the initial number and this is then translated via a container (6 global) to show a graphic of corresponding 'stars' What would be cool is to just click the container and let the 'stars' advance until you reach the desired 'rating' - any ideas? Thanks in advance! Frank.

Hello, if a record has a "photo" field and a "name" field, is there a way that the "photo" field will be filled with a picture that i name with the same info as the "name" field. Thanks!

I have two tables, one of Event information another for allocation of tickets for the event. In the allocation table, some tickets are gratis and don't count against the total available to the purchaser. I am running a sum of those that do count against the allocated number, but when I try to use that sum it won't instantly recalc., it does at some point after I click around here and there. Is there something I am missing?

Hi people, I started my FM career just about 6 weeks ago - progress started well - but since looking at all the wisdom on this site I have become decidedly less confident in knowing the right way to do something - my question on this occasion is to find out whether there is a correct way to ... to achieve the following: I have an "activities" table that stores, amongst other things inbound telephone call details. I have taken the decision that all activities must belong to a "task" and all tasks must belong to a "project" (and all projects to a company). However our company gets any number of calls where we would not wish to create a project etc f…

Hi I want to move a database from Excel to FileMaker. I have most of the conversion sorted out, but one thing that I want to do is convert a field of up to 5 characters to morse code. I have this working well in Excel using the following formula: =IF(MID(S2,1,1)="","",IF(MID(S2,2,1)="",VLOOKUP(MID(S2,1,1),Code!A:B,2),IF(MID(S2,3,1)="",VLOOKUP(MID(S2,1,1),Code!A:B,2)&" "&VLOOKUP(MID(S2,2,1),Code!A:B,2),IF(MID(S2,4,1)="",VLOOKUP(MID(S2,1,1),Code!A:B,2)&" "&VLOOKUP(MID(S2,2,1),Code!A:B,2)&" "&VLOOKUP(MID(S2,3,1),Code!A:B,2),IF(MID(S2,5,1)="",VLOOKUP(MID(S2,1,1),Code!A:B,2)&" "&VLOOKUP(MID(S2,2,1),Code!A:B,2)&" "&VLOOKUP(…

Hi I made a database for a friend with a container field for photos. Im on a G4 and he's on an Intel, we both run 10.4 He reports that when he drags and drops a photo from his container field to the desktop, it creates a picture clipping file. Same for me. But in his case he cannot open, move or delete (but can rename) the picture clipping file. I can treat it just like any other file including deleting it. Has anyone come accross this before? Phil : B)