Calculation Engine (Define Fields)

I have a number field "Copy Cost" that gets filled in based on a selection from a pull down menu. Question: The user now wants the "Copy Cost" field to have a 0 amount if a particular selection is made from this pull down menu no matter how many words are in the "Ad Copy" and "Name of Individuals in Ad" fields. How would I incorporate this into my calculation? //get the total word count and set it to variable "C" Let( C = WordCount(Ad Copy & " " & Name of Individuals in Ad); //Check selection in pull down menu and apply relevant value to field "Copy Cost" Case(PatternCount ( Photo Size ; "Text Only" ); 50; //Check selection…

Hi there, I have a bucnh picture of my product, i want to make a database for my product with picture. Is that possible to make a script that allow me insert my product picture in product field (container) after input product code in code field ? so i can sort my work insteed input code and insert picture as manual work. Thank for your kind attention and sorry for my english...

I am trying to create a calculation that gets all field values of a related record and combines them into a single field with a carriage return after each one. I have tried to use the "GetNthRecord" function to achieve the desired result but I have to string a bunch of them together to get it to work. GetNthRecord ( ASSIGNED_MENUS::MenuID ; 1 ) & "¶" & GetNthRecord ( ASSIGNED_MENUS::MenuID ; 2 ) & "¶" & GetNthRecord ( ASSIGNED_MENUS::MenuID ; 3 ) I am sure that this is not how I should be doing it. Is there a single function that can do this?

I thought I had figured out how to generate a random birthdate, given an age using a random generation for day and one for month and then combining with year. My purpose is for instructional use, to keep the patients the same age, no matter the year being used. Now, when I use the field in a layout in more than one place, the date of births are different. Is there anyway to get it to 'set' and not change? Thanks to all who peruse and ponder my problem! I appreciate any help.

hopefully this is posted in the right forum, anyhow here goes: ive got two diffrent problems: 1. ive got a checkbox list which is linked to a portal. when i check the boxes the result shows up in the portal all good and well, but everything goes into the same field! i want the different checks to end up in diffrent fields, how do i do that? 2. if i want to add checkboxes to my list by manually entering values into a field in a different table, how do i do that? preferably i would like to have a button next to the new value that said "add", which in turn added the new value, is this possible?

Hi folks! Problem: I need to import JPGs into a container field using a calculation to set the filename to import. Is this possible. Hope someone out there can help, this one has got me scratching my head a bit. I have created a database to import emails containing values posted from a web form processed by a php form processor. One of the values in the email contains the filename (i.e richard.jpg) of a file that also gets uploaded/attatched to the email from the web form. I have setup an applescript used by Mail to save down the email attachment to a specified folder. Is there anyway to script in filemaker the ability to import the attached jpg (bearin…

Is there a database size consideration when deciding whether to use Text or Numeric auto-enter serial numbers? In designing a database that, potentially, could contain hundreds of thousands of records in each of several tables it occurs to me that I could be wasting a lot of space using Text IDs for those certain tables. "Old school thinking" leads me toward numeric (e.g., 1 to 999,999) instead of text (e.g., A000001 to A999999), even though I prefer to use Text if the ID is ever displayed to the user. But is that reasoning valid or does FMP store Text IDs in a compressed form that makes space requirements a non-issue? (For readablity, I even have a few IDs like T…

Hi, I am having a little problem with my calculation of expiry date. I wanted to do base on date of invoice and then calculate the expiry date of the invoice base on given number of months. How do I do it ? Thanks in advance Fei EXPIRE.zip

Hi, all. Still in the design phase of my project. In our neck of the woods, we prefer to format phone numbers, for human consumption, in this way: (999) 999-9999. Postal codes: A9A 9A9. QUESTION: Is there a consensus as to what the "best practice" is with regards to storing these data in the database? Should they be stored WITH the formatting (validated at input time) or should they be stored WITHOUT any formatting (and edited every time they have to be displayed/printed)? Thanks for your input!

Hi, I am fairly new to FM8A. I wanted to know if it is possible to have a button which will open a new window and display the photo stored in a container. I want the user to be able to look at the photo on a larger scale. Thanks, Jim

I'm not sure if I'm missing something here but I'm having a heck of a time with a particular global field. Everytime I open the database it is empty. I enter a number and it stays until I close. When I open it I find it empty again. Never had this happen before. Any thoughts? bryan

If I apply TextColor to a calculation that returns a numeric value in a field that is formatted as currency in the layout, the color doesn't appear. If I change the calculation result to text, the color appears but the currency formatting doesn't. result= // maximum_value is the numeric result of a calculation // actual_value is numeric field entered by user Let ( DELTA = maximum_value - actual_value; Case( DELTA < 0; DELTA; RGB(255;0;0)); DELTA ) ) How do you set the color of money? Duh! After I posted this I realized that the number format provides an option for coloring negative. How do you retract a post?

Hi, I have a movie in a container field, but I want to be able to click off of that field, select another field to enter text, and then reselect the movie..... but everytime I select outside the container, it goes back to the beginning of the video... is there anyway to stop it from always going back to the beginning? Vandy

I have a simple calculation field that is only calculating on some of my records, aprox. 3 out of 20 records. The calculation is: "Annual cost" / 2 * "billing weeks" All fields are in the same table.

I am using FileMaker Pro 7. I have a database now for books. This dbf is used for catalog listings. I am needing to limit the # of characters in the field I have created for the description to 128 characters. Is there a way to do this? Thank you Allene

Hi All, Is it possible to display repetitions of a field dependant upon a number field which would be displaying how many repetitions should be shown and then using a calculation? I have a maximum of 12 items per job...although jobs have differnt number of items. Each item reprasents a repetition...therfore if i have a job with 3 items i only want 3 reps if job has 12 items i want to view 12 reps. Thanks in advance

Hi, all. Still designing an order entry system (Customers, Products, OrderHeaders, OrderDetails tables). I was initially looking at using the pk_Order_ID (automatic, serial number) as the OrderNumber (the "human-readable" number). But that doesn't make much sense, does it? The ID (and therefore the order number) would get assigned fairly early in the process, as soon as the Header record gets committed and before all the details have been created. But then, what happens if I decide, halfway through the process, to simply abandon this order and not create it? (In our environment, this does happen regularly; we do this for training purposes as well). …

I need some help. I'm still in 7 but I think you all can still offer some advice. I'm creating a solution for the coaches of my daughter's swim team. I need a time field that will record the swimmers times in minutes:seconds:hundreths of a second. I need to be able to sort by this field from slowest to fastest etc..., So far, I can't figure out how to do this. Any suggestions would be greatly appreciated. Papa.

Ok, I am migrating an biding database from 5.5. In the old version I have a calc field the references discription fields in the same table and gives me a paragraph that is printed with the dollar amount for that"Area". In the new version, I have made a join table that holds all the line items making it much more flexable, however, how do you summerize text fields from a related table and show them in a paragraph?

Ok. I have a database I am designing for a police officer/department (possibly). I need to have a button that will pop up a calendar showing the names of the arrested/cited on all calendar days. So it needs to have 7 days x 31 days calendar with the names in the day boxes. The fields I can use are "LastName", "FirstName". My problem is making the calendar popup and the names show in the day boxes. Any advice?? Thanks

Ok so I have a container field that basically contains a colour based on a calculation. For aesthetical reasons I would like this container to resize (sliding/print) to the same size as the other text fields in the same layout. Hence giving a preview of a report with all the boxes the same height.

Hi, I am trying to create service call database as following: Table1:Service_Call Field_1:Service_Call_ID Field_2:Service_Call_Assigned_Enginners Field_3:Service_Call_Status Table2:Assign_Task Field_1:Service_Call_ID Field_2:Engineer_Name Field_3:Task_Date Table3:Service_Visit Field_1:Service_Call_ID Field_2:Service_Visit_Status Field_3:Service_Visit_Date The Problem is:(in screenshot2) How can I define the caculation to make Service_Call_Assigned_Enginners="Ben+Ken+Jason"? And Service_Call_Status="In_Progress"? (if there's a "Finished" status in "Children", the status of Service_Call will be "Finished", otherwise it's…

Hi, not sure if this is in the correct forum, but please help: We have been using Filemaker 6 to learn FM and are upgrading to FM8 this week. My problem is that I want to assign client specific abbreviations plus job numbers i.e. RFS001, RFS002 etc. and ROT001, ROT002 etc. Am I able to do this with FM6, or is there a much easier way to do this with FM8? I am aware how to set up a field to identify consequtive job numbers but so far I am unable to introduce the client unique job numbering. Any help very gratefully received and I'm sure I'll be asking more!!! Many thanks.

I have these fields: Property Name, City, Phone. I need a field to calculate the first 5 letters of Property Name, City and the last 4 phone. This will give me a unique id for this contact. Thanks

I have a situation were I have 7 fields that the user chooses to show what days a newspaper runs (Mon through Sun). Is there a way to have a field that summarizes those 7 fields? For example: a newspaper runs Mon, Tues, Wed. I would like to see that say Mon-Wed or if it was only 2 days list those days. Any thoughts or help is appreciated. Thanks

Hi, I try to develop a custom function in order to distribute a number based on a sequence, with separators. An example - the number is 17 - the sequence is 5 - the separator is "X" --> the distribution should be 5 X 5 X 5 X 2 The total of the numbers is 17 and each sequence is separated by "X". The distribution ends by the Mod(number ; sequence) This is the recursive function I developed, without success : Distribution(numbr; rythm) Let([ M = numbr ; R = rythm ; RI = Mod(M ; R) ] ; Case( RI = M ; RI ; R & " X " & Distribution((M - R) ; R)) ) Doesn't work... Find attached my test file : you will see that…

I have two seperate container fields located in the same database. Everytime I insert a small jpg logo file into each container field, the images are gone when I go back in the database. I leave unchecked the option "Store only a reference to the file" being I want the image stored IN the database. Each jpg is only 4k. What gives? There must be something I'm missing. Each container field has Use Global Storage checked off. Please help. It's not do or die, but man it's frustrating.

Hi, Does someone know how the FileMaker Random function works internally and if there has been a change in its behavior between FM versions 7v1-8v3? I'm having the following problem: last year we deployed 200 FMP7 runtime solutions in which random unique IDs (random combination of 10 characters/numbers) are generated for transactions. The transactions are gathered back and imported in one central database. We never had problems with these IDs until we deployed a new version of our solution created with FMP8v2 last month. Since then we received already 5 newly generated IDs from 3 different runtimes that have a match. Consider A, B and C, then B and C now produce…

Hello FM lovers, I use a portal to display values in a related field. The problem is the field could have multiple repeating values of each of the values I need to display in the portal Sample: MyField--------------------------Portal should display A123---------------------------------------A123 A123---------------------------------------B753 A123---------------------------------------C147 B753 B753 C147 C147 Can I use a calculation to accomplish this? Thanks in advance.

I am trying to take a date, that could be any day of a particular month, and use a calculation that will determine the first day of the month that the date falls in. For example if the user enters 6/16/06 the calculatin will result in 6/1/06 (the first day of the month). Please help if you can...

Hello, I have a calculation that shows Active Jobs in a portal... here is the calculation. Case (jb_date_end ≥ ( Get ( CurrentDate ) );"Active") It works, but we have found out that some employees' jobs don't necessarily have a job end date (jb_date_end)... so how do I add if jb_date_end is null - job is also active? Thanks in advance

My head isn't working well today. I've tryingto modify a current calcualtion to show me the time remaining of a 3 year EOL (end of life) on a computer. right now i have it just displaying a word Retire or Serviceable depending on what side of 3 years it falls on. here is the current calc. Case ( Get ( CurrentDate ) ≥ Date ( Month (Date Purchased); Day (Date Purchased); Year (Date Purchased) + 3) ; TextColor ( "Retire" ; RGB ( 55 ; 0 ; 0 ) ) ; Get ( CurrentDate ) ≤ Date ( Month (Date Purchased); Day (Date Purchased); Year (Date Purchased) + 3) ; TextColor ( "Serviceable" ; RGB ( 0 ; 153 ; 0 ) ) ; " " ) i want to replace the "Servi…

Hello, I am new to the FM world. I have build a DB that is working perfect so far. There is only one thing I would like to see it do. Is there any way to get a container field to insert a picture based of a serial number I have a field set up to calculate. Maybe with a button using a script to make it happen. Thanks, Donnie

I am a relative FileMaker newbie, and so far I have mostly worked with web interfaces using CDML. I have a need now to provide some slightly fancy behavior in the actual FileMaker interface. What I'm looking for is something like a JavaScript rollover. Basically, I want an image with a number of 'hotspots' which, when rolled over or perhaps clicked, expand to to provide some informational text and perhaps another image. I can set up a button which pops up a confirm dialog, or I can set a field as a dropdown list which pulls text from a value list, but those are both kludgy and unattractive. Does anyone have any ideas for me? TIA!

I have a "LineItems" database with the following fields: LineItemID Qty LastModFlag (global number) Whenever the "Qty" is modified I would like the "LastModFlag" to lookup the record's "LineItemID". Is there a way to trigger a lookup that would do this?