Calculation Engine (Define Fields)

I have a database that is held in 2 locations and data is entered in the same table. Following data entry the information is then exported as Excel, emailed and imported in a third location. As this table is then related to a recipients table by a unique ID I have defined three field for ID purposes. The first is an auto enter number field, the second is an alpha field which gives a single letter determined by the user name and the third is supposed to be the ID field by combining the information from the two other fields. The problem I am having is that the ID field is just showing 0 when the Alpha field is showing I and the number field is showing 0006. I have define…

I give an example file below: FM calculates two consequently years two days less... In real time a year begin 12 a.m in 1/1/xxxx and end 12 a.m 12/31/xxxx. No I did not post this thread two times. Pascal test_dates.zip

I know this should be very simple to do , but I can't make it work right. I don' want 9.99 showing up in the "Total Buy with Comm" field when I'm using "Sold" field & likewise I don't want 9.99 showing up in the "Total Sold with Comm" field when using the "Buy" field. Please tell me what I'm missing. See attached file Stocks_.zip

I wonder if we can transform calculation fields into regural edit fields by a button or anything else. This will help the users to by-pass automatic processes and complete the fields of their own. It is very usfull in cases that user or client already know time or expenses and does not want to complete fields in order to get a known result. Pascal

I have an Inventory table. In the main view I have a QOH_store that is a calculation of Count and Sold. When I make a new layout that displays the QOH_store and the Sold Fields, the QOH_store field isnt updating automatically. I have to click in both fields to update the info. HOWEVER, just clicking one of those fields doesnt update both of them. I thought maybe using the Relookup would help but it says that there are no fields that lookup values based on the Sold field, which is not true...

I have a calculation field that returns text. This text being simply "Yes" or "No". I wish to find all the records with "Yes".... but when pressing a button that enters find mode and enterering Yes into that field. The find will not perform... this happens for all my calulation fields.... How can I overcome this?

Dear experts, I have to put a problem again although I will try to give solutions of my own. I make this because I always seek for my huge I confess educational database to run smoothly and without problems. THE PROBLEM. Let us supppose that a teacher taught to five different schools from a DateStart to a DateEnd per year in last five years. We want to calculate the total number of years, months and days that the teacher taught to the schools in the last five years. But also we want the total number are not only in days but have the format xyears, vmonths, zdays. I hope you understand if you do not I will give an example but I think it is relatively easy…

I am trying to find the difference between the creation timestamp and the current timestamp, then if the difference is more then 20 days to set that record to inactive. Timediff :[color:blue]Calc, unstored = Let ([ time = Get ( CurrentTimeStamp ) - Timefirstshark ; days = Div ( time ; 24 * 60 * 60 ); time = Mod (time; 24 * 60 * 60 ) ]; days & ":" & Hour ( time ) & ":" & Minute ( time ) & ":" & Seconds ( time )) Active:[color:blue] Calc, unstored = Case (Timediff > "20:0:0:0" ; "No" ; "Yes" ) It seems to work at first, but then for some reason it thinks 10:0:0:0 is less then, but 4:0:0:0 is greater?

does anyone know where I can get a filemaker 8 tutorial video that is explained in the windows format and not the apple. It would be much appreciated......

I have a client who wants one field on their data base to be required only if another field is populated with certain information. Is this possible? I know this syntax is incorrect but, Basically: If (Field_X = "Condition_A") Then Field_Y ; IsRequired) Else Field_Y ; Not_Required) If anyone can help I would greatly appreciate it. Thanks, Steve

Hi I want to add Bold & Underline buttons beside a text box. Anyone know how? Thanks Trevor

I know this is very simple but I can't seem to figure it out today. A system that I'm working on has an orders table and a commissions table. Commisions are related to orders by an order ID and a single order can have multiple commissions attached. Each commisions record also shows a SalesRepID. From the orders table I need to show the SalesRepID from the Sales rep that has the highest commission on that order. Any suggestions would be apprecaited.

Each of my layouts are designed to be printed, but is there anyway I can create a non-printing custom navigation bar along the left-hand side of the screen? I currently have all my buttons along the right, off the printed page, but I have two different types of buttons I'd like to categorize -- navigation (between table data) on the left, and action items (ex.: launch script) on the right. For each layout the items on the left would remain the same, but the items on the right would change depending upon the actions particular to that data. I could swear I've seen others DBs like this, but don't have an example ready for me to see how it was done. Thanks! Lisa

Ok here is my problem. I have a field that when the record is created displays the date and time. It does this using the Auto-Enter/Creation/Timestamp/(Date and Time) setting. Now I have a second field called "Due Date" I want this field to display the date 14 days after the creation date of the record. I have tried "Due Date = Creation Date + 14" but that displays just a jumble of numbers. Is there something I am missing? A calculation command or Field format? Or am I just taking the wrong approach to this? Thank You, Eric G.

Okay, I've got a database (table?) with almost 1000 contacts that I have been accumulating over the years. Now after reading the "White Paper for FMP Novices" I see the value in having an ID Field as described therein. I want to write a script that will accomplish this after the fact and another script that will perpetuate the autoentry in the future. Am I being clear, I hope? I have called my new ID Field ContactID. I want the serial number to begin with 1001 and each record to have its own unique number. Also I am curious why we cannot just create a field that will reflect each record's record number that FMP seems to generate anyway? Wait, I think I know the ans…

Hello can i create a summary by 2 search dates. Let me explain jobs are entered every 2 weeks from the 1st to the 14th and from the 15th to the 31st, an invoice is then created for both these ranges but on the last period 15th ---31 the invoice is created on the 1st. here is where i have the problem. i am breaking a summary by the month, via the invoice date but i am always a job period behind so for example i have Jan 200 feb 400 march 410 april 415 etc........ but if i do a manual search by invoice date lets say 5th of jan to 5th of February the result is correct. but now i cannot list the summery as Jan Feb March etc........ …

AddressList.fp5 includes a multi-value field with BookIDs in it. People in the AddressList may have 0, 1 or multiple BookIDs. BookList.fp5 has a multi-value field listing the PersonIDs of everyone in AddressList.fp5 who has that BookID listed. The multi-value field in BookList.fp5 will apparently only read in the first value it finds in any multi-value field in AddressList.fp5. Any way to accomplish this? Thanks.

Need to know the most efficent way of doing something close to this: If table::field is in the records of 2nd table::field then etc. would work just as well if not member of... We are inputing websites into a database and doing a whois data capture on the base domain. So URL table one has all the websites and Whois Table has all the domain info. The URL table can have multibles of the same domain, but with different websites. So, was looking for way to flag the user that that URL while may be new has a domain that has been catured already so the user does not have to spend time doing a search on the second table.

I've got two databases, projects (PRJ) and employee names and email addresses (EMP). I'm trying to compare a last-name field in PRJ with a last-name field in EMP and, if EQUAL or even SIMILAR, put that employee's email address in a new field. I tried: If (PROJMGR = Employee Table::Emp. Last Name; Employee Table::email;0) But the comparison between the two text fields doesn't work. Thanks for any help! Steve

I have a container field in my layout where our users can drop files, pictures, etc...the problem I'm having is that the container data is automatically downloaded when user is seeing that particular record . Is it possible to have the container not downloading until the user actually chooses to download/save the file? Thanks

I'm trying to set up a calculation field that counts the number of a certain type of related record in another table. For example: employee table is linked to the Absence table I want a field in the employee table called "Count Sick" to count the number of related absences in the Absence table that were coded as sick for each employee. (I have a reason code field in the Absence table where I select the reason code from a value list. Here's a psudocode example of what I'm trying to do. Count (Absence::Employee ID) WHERE Absence::Reason Code = "Sick" Any help is appreciated, thanks.

I need to sum values from a field (A) based on the value of another field in a different table (X). I can do this by "finding" X=1, sum A but I want this in a calculation. In fact I need to show three values in one place if X=1, Sum A if X=2, sum A if X=3, sum A can someone show me a calculation that will do this?

Hello! I just created a database for our HR department showing CURRENT information. But I need to be able to keep a track on the changes that I have been made in the previous months. Especially for salary, I need to be able to print salary reports of the previous months. Can someone help me with an easy solution?? My idea (quite complicated!!) is to transfer automatically at the end of each month the info into the next month. Is this the right way? Thanks for your help!

Hi Can anyone help me. I am new to this forum - but I am confident someone maybe able to help. I am running a modified version of the Business Productivity Kit and I want to generate a report that will give a break down of how many of each product (from the inventory) is sold each month. I can do a total, using a calulation sum(), but I can't slpit the data into months. Can anyone help? Thanks

Hi In one field there is a pop up calander where a date is entered. What I want to do is when this date is exceeded by 3 months some kind of wanring is displayed in a field. Anyone know how? Thanks Trevor

Does somebody know how I could parse a 12 digit number that starts 16 digits in and ends 4 digits before the end? For example the string of numbers 9761243631002561 724686727627 2019, the numbers that are in the middle are the ones that need to be parsed from the entire string. How would I specify that in a calculation? Thanks for the help.

Hello fmp community! This is my first post--have been trying to figure this calculation out. It seems like it should be very simple, but can not find a post that deals with same issue. I have a field that calculates TOTAL RECORDS in entire db. I need another field now that calculates Total Records since Jan. 1, 2007 (YTD). I have a "Date Initiated" field to pull date from. Can anyone give me any guidance? Thanks!

I use calculation fields to dynamically display content from 2 different fields depending on the scenerio. I would like to be able to preserve the formatting from the original fields so that they still display with their original formatting in the calculation field. Is there a way to do this? or am I stuck with the fact that my calc field will strip formatting no matter what?

Greetings Is there a way to import VCards directly in to FMP 6? If not direct how does one import them most conviniently? Thanks

I have a table within my database where the user will create a record and a field called "record number". For other calculations and relationships to work within the database it has to be a two digit number. If possible I'd like to have it setup so that when the user creates the records it starts with auto-entering 01 then moves to 02, 03, 04 etc... I'd also like to make it modifiable by the user but make it so that it has to be two characters if they choose to change the auto-enter number. Ideally the auto-enter number would look at the previous record number and always go to the next sequential number even if the user created a record and then delete…

I need to put restricted data in a field using an If() statement in a script. Basically it comes down to those 4 steps, and it is working well: if value in numberField1 = 400 and value in numberfield2 is higher than zero set field numberField 3 to numberField2 if value in numberField1 = 400 and value in numberfield2 is lower than zero set field numberField4 to numberField2 if value in numberField1 = 440 and value in numberfield2 is higher than zero set field numberField 3 to numberField2 if value in numberField1 = 440 and value in numberfield2 is lower than zero set field numberField4 to numberField2 Now I have to add an additional …

Greetings Fellow FileMakers - What is the best way to calculate FICA for payroll, taking into consideration the FICA Maximum ceiling? Thanks for the help... Royce

I've got a field with a character that repeats itself throughout "%". I want to pull data from between these occurances into separate fields. So "field l" would be all data up to the first occurance of "%". "Field 2" would be data from the first occurance to the second "%", and so on...

Hello, wondering if someone can help me with this. i am running FM 6 pro on a mac. here is my problem, i am trying to find the total of hours a student has done for each subject. There are break down T for Technique, A for Anatomy . This is where it gets complicate a little bit because the subjects go from T1 through T25. Each Subject get assign specific amount of hours. So i want to know what the total hours are for all T (Techiniques) and Anatomy. i thought of doing a case to fine all T and A. i am not sure where to start. any help would be appreciate it thank you vic

Greetings FMers: Is FM8.5 the first version to VIEW PDFs? Thanks, Royce