Calculation Engine (Define Fields)

Hi, I am using version 8 on XP. I am trying to build a small DB to keep track my son's swim meet time results. The problem I have is that how do I define the TYPE of the field to hold time from swim meet. The data look like this 1.34.02 or 34.54. How do I compare which number is fatser than the other. Like on 1/1/2005 50 yard Freestyle. His time was 1:36.54 on 3/1/2005 50 yard Freestyle. His time was 55.36 How do I tell FMP that 55.36 is faster 1:36.54 Please hlpe. Thanks ;)

I have sent a sample of this and tried several hundred things I am at my wits end and need your help. Thanks Tony D Figurethis.zip

Hi all, Simple formula that I do not know how to wright. I am tring to come up the a formula that will put the date modified in a cell when a certain feild changes. IE: I have a Broker Field when a user puts or changes this value a new date (the current date) gets added to the date field called broker date. Can this be done? Joseph

Hi, I have a field that contains time displayed in 8 digits (01:02:03:04) that represent Hours:Minutes:Seconds:Frames. I currently have to manually enter the colon between each set. I'm hoping that there is a way to have the colons automatically entered so that I could simply type in 01020304 and have it automatically display as 01:02:03:04. However, I still need to be able to paste a time value which already includes the colons. Does anybody know of a way to implement this? Thanks!

Description: Last year I created a form document in Word. I saved the file as something (PDF I thought) and then placed in in FM layout. I just tried to repeat the process with an updated form, but every time I print, the resolution of the Word part of the document (which I saved as a PDF) comes out in very low resolution. I have set the printer to the highest resolution. Can anyone tell me what the best way is to convert a Word document to a format that will print out neatly in FM. I am using Word 2004 and FM 7 on a Mac with OS 10.3.9. BC Working Under: 7 Solution Status: Beta Pre-requisites: Author(s) wtc Date: 10/31/05 C…

Hi, I have been constructing a database for my daughter which tracks orders to her suppliers. When she puts a personal order in, some products are for personal use and others are promotional. I want to identify these graphically when filling in the order. This would work similar to a radio button but without two buttons. That is she clicks on a button and the field changes from a green to a red graphic. I have three fields; one holds the graphics, one displays the graphics and one indicates the type of purchase numerically (1 or 0), all repeating fields. The order pages consist of fields with vertical repeating values so as an item is entered, the button is clicked t…

Hi List, I have a DB with several thousand records that I would like to add serial #'s to, and update the old records. Is there a simple script or function I can write that will run through the records and add an incremental serial # to each record? Thanks for your help, Steve

Hi Everyone, I've got 2 fields - the first (CARD) i want to be coloured depending on the date of the other (DATE). I sorted it out, making the first field Card a calculation - but then i found the problem that i'm stuggling with ... i can't then entere info into it. The calculation is: CARD= Case ( DATE ≥ (Get ( CurrentDate )-180) ; TextColor (CARD ; RGB (255;0;0)) ; DATE ≥ (Get ( CurrentDate )-365) ; TextColor (CARD ; RGB (255;150;0)) ; DATE ≥ (Get ( CurrentDate )-545) ; TextColor (CARD ; RGB (0;255;0)) ; TextColor (CARD ; RGB (0;0;0)) ) I thought i'd got round that by making CARD a text field, and having the calculation in define f…

i want to have calc feild that is a key number for plans in my office....and every time a new one is put in it is given a key number that is the most recent key number + 1...how would i use a calc feild to reference the previous recrod to calculate a number on the current one?

I've discussed this with two Gurus and unfortunately was given two answers neither of which I have been able to implement. This is what I'm trying to do: I have one file with two tables. I have a layout that uses the second table to house pages(records)which are displayed and edited in the first table. Ie, think of it as Word. So to recap: on this layout you type in one portal, then go below to next portal to create a "NEW PAGE" of your "multiple page document." This works great however, Now I want to put a portal in a completely seperate file that shows how many letters exist for each "patient", "Company" whatever it is..but I need to see in each of the seperate…

Hi there, I have dragged some *.png graphic files into a container field so that if I copy and paste the field into other layouts the graphics should automatically show up. I want this particularly as the DB will be published as a web site. I am using FMPro7/8. But the graphics do not show up in the copied container field when it is pasted into other layouts. Is it the file format? The graphic is actually a composite - a number of *.png files that have been grouped and then dragged into the container field. Do I need to create a single graphic from these files in Photoshop first? I have experienced the same problem using single *.png files too so I doubt it. I a…

Ok, so my problem is this. I am trying to create a simple relationship within a table so that I can look up multiple values. My database is full of plant scientific names, and the problem I am encountering comes up when I reach a field that does not have a subtaxon name (empty field). So my fields are: Family Genus species subtaxon nativity My goal is to automatically produce a value for nativity once the plant name has been entered into the record. I currently have my base table linked so that it breaks down each level hierarchally. If I create the relationship through the subtaxon, then empty fields will not produce a value when I attempt t…

I have this calculation: PatternCount ( ValueListItems ( Get ( FileName); "Rel_Company" ) & "¶";"¶" ) It counts companys in a portal... But it displays a "1" count when there is nothing there. When I add a company it still shows "1", when I add another company it shows "2". So the question is what is it counting when there is nothing there. I have uncheck do not display when feilds are empty and that does not help. Joseph

Hi this is a two part question. 1. How do repeating calculations exactly work. I dont understand them 2. If I have a global calculation field that shows the direction of a sort, asc / desc arrows, and I want to show it for a few different portal fields, do i gotta have seperate field for each one? Right now I have seperate ones for each of them. I want to see if there is a better way. like 1 big case statement or something. Right now the code looks like this for each field where f and d are global number fields [b]Arrow1[/b] Case( f = 1 and d = 1; cgArrowUp; f = 1 and d = 2; cgArrowDown; cgArrowUp ) ) [b]Arrow2[/b] Case( f = 2 and…

Hi, I have a small Bar & Restaurant billing and stock system designed in FMP 5.5. The item sub total on the Invoice is in a portal from the line items file and should be modified by the account type determined on the invoice. i.e. If the account type is cash or account then the item sub total is just the item price * the quantity, if the account type is spillage or social then the item sub total should be zero(0). I have defined the calculation for sub total in line items as: Case(Acct Type="Cash";Qty*Price; Acct Type="Account";Qty*Price;0) The Account Type field, which is a value list, in line items is from the invoice given by the relationship Invoice numb…

I am trying to set the color of a container field or the fill/background color of an edit box based on the rgb numbers. Fields RGB - text field contains rgb number (84:00:17) should I split this into 3 fields Color - storage or text field. I need to set the fill or background color of Color field with the rgb info from RGB field. Thanks

I would like to find a way to enforce a type of entry in a field. For example, if a field is designanted for a file name with a naming convention such as IP_xxx (where xxx are number values) and I want to ensure that the user follows the convention, can there be a pop window where this requirement is prompted?

I have created my first contact database but I am stumped on one thing. I have created a "company initial" field to to group my companies by their first letter, but now I would like to sort my List View so that ONLY those companies that have that initial are shown. I can get the list to sort by the initial but it is still the entire database rather that each letter of the alphabet. The next thing I would like to do is to add alpha buttons to the layout (pix attached) and define them so that when clicked on the appropriate companies with the letter are visable. I can't seem to get there. Can anyone please help?

Hello everyone. Using FileMaker Pro 5.5 I have just built my first database and the posts and sample files on this forum helped greatly in this. However, I am stuck with one problem I hope someone can help with. The database records and processes daily food orders for lunch. Clients can choose up to 5 items from a selection of 17. In the database there is a layout with 17 number fields, each for a particular food item, so if someone wants 2 pieces of chicken and one portion rice, 2 is entered in the chicken field, and 1 in the rice field. The database produces a summary for the kitchen and delivery notes, which work a treat. It also produces a print out label f…

i have thousands of previous data to be submitt in the new file. i select one group contain 5 persons from diferent district to finish the task. So i need help how to use script or calculation to make sure the serial numbers entered are control by year. for example person at district A entering data for the year 1991 and person at district B are entering data for the year 1997. the serial nombor must be split and squence year. Hopefully understand my poor langguage.

I may have missed this feature or plugin but.... #1. How can I do a SETFIELD( "samplefieldname", calculation) ? IE I want to do a setfield NOT with a direct link that FMPRO uses but using just a simple string. The reason I am doing this is I want to assign 100s of fields to 100s of others with similar names that I could store in a DB or Repetition Field and have a script extract and then do the actual assignment. #2. Import and Export text files easily. I am currently using tab files and am running into several issues. I have to do an extensive parsing routine to place the data into fields and then the opposite when I want to export. I know I could …

I set up a script to insert a PDF into a repeating container field. When I kick off the script it inserts the file however it gives me an OLE error. After I click off on the error the file (whether it displayed as an icon or not) is in the field. Any idea why I'm getting this error. anyone else had any issues like this? BTW running on Win XP 512mb RAM Pent 4 2.8 ghz.

date1 & " " & ref1_1 & " " & ref2_1 & " " & charges1 & " " & credit1 & " " & ref3_1 & " " & C & " " & SYS & "¶" & date2 & " " & ref1_2 & " " & ref2_2 & " " & charges2 & " " & credit2 & " " & ref3_2 & " " & C2 & " " & SYS_2 & "¶" & date3 & " " & ref1_3 & " " & ref2_3 & " " & charges3 & " " & credit3 & " " & ref3_3 & " " & C3 & " " & SYS_3 & "¶" & date4 & " " & ref1_4 & " " & ref2_4 & " " & charges4 & " …

I'm having trouble getting a calculation to occur. Here's what I'm doing: I have a table called "design_elements" with a repeating field "button_images" of containers (images) for some different buttons. There are 7 repetitions for the 7 buttons. I have a global number field "selected_button_num" in design_elements that holds the current button number (1-7). I have a global calc "button_shown" in design_elements that grabs the particular button image from the repeating container field based on the value in "selected_button_num". Now, by changing the "selected_button_num" via a set script step, I can change the button graphic. I am doing this from a layout s…

How do I create a field and insert a pdf that can be opened by a user in browse mode? I've created a container field and inserted a pdf by clicking on the container field in browse mode to select it and then using the insert file from the Insert Menu. I then navigate to the folder on my hard drive that contain pdf's and select a pdf. I've tried this both with and without clicking the check box: "Store only a reference to the file". When I go to browse mode and double click on the container field with the pdf showing as an icon, nothing happens (the pdf does not open). Any suggestions? Thanks

Hi all, We run a rent-a-car company. We need to know how many kilometers were driven by our employees between rentals to retail customers. In order to do that, I need to deduct "km in" from the previous contract with "km out" on the curent contract. It sounds easy but for some reason I cannot manage to create a calculation that does that...having two different records to compare is were I hit a snag. Can someone light my way? Thanks in advance -) Luc

I have an email form that is currently not being input by a filemaker web form, therefore, I cannot break up the fields on the way in. How can I break them up once they are imported? I have a field called "raw" that this form is pasted into. I then want calculations to automatically populate the fields that correspond to every carriage return in the field. Please help! example form attached below: New hire setup information has been entered for the above job requisition. Click the link below to view. http://webserver:6001/servlets/iclientservlet/hp80/?ICType=Panel&menu=ROLE_MANAGER&market=GBL&panelGroupName=TW_POSITION_INFO&JOB_REQ_NBR=0…

Hi all, We try to keep contact with our customers on their birthday. To create a list of the customers we should call during the month, I created a calculation using "=month status(currentdate)". The problem I am having is that it brings out 2 as a result instead of 10 (we obviously are in october). I checked the date on my pc running xp pro and on the linux server and both are linked to the atomic clock so that is not an issue. What could make this calculation bring this erronus result? Thanks in advance for your suggestions. -) Luc

Can anyone point me where I can find such a calc? There has to one out there...this is such a common tool for DB's...I don't know why FM just doesn't provide it...

Hi everyone, I have a field that is set by a calculation. It depends on another field. Currently the field looks like the following: case( recipes::serv_Unit = "Ounce" or recipes::serv_Unit = "Pound"; "Weight"; recipes::serv_Unit = "Cup" or recipes::serv_Unit = "Gallon"; "Volume") the problem I have is that I have many more measurements in each category. I thought there was a way to enter the recipes::serv_unit = part once and nest the possible entries. How can I do this or did I just dream it? Thanks in advance

I was wondering if it is possible for me to have a window pop up when a certian field is set to true. (E.g. if( get (CurrentDate) > 89 > oil change date ; Pop up ; "" ) ) or somethinjg like that. My calculation is probably off, but I was just using an example and a quick one at that, but the basic idea is still there. Thanks in advance.

FM6 user with 'extensive limited' experience. I.e. I don't know much but I'm fast at the simple stuff. So here's two things: What I want to do, and how I think I want to do it. I'm open to being told that in my approach, I'm barking up the wrong tree. DESIRED EFFECT: I regularly send out a bunch of freelancers' contact information to clients who are looking to hire labor, so in my new phone book, I want to be able to grab as many phone numbers as I feel like, then paste them to an email or word processing document. So, one from Column A... two from Column B ... there, there's a list of 6 guys and their phone numbers. Plop. WHAT I'VE GOT SO FAR: I've …

Hi all, I am just in learning the ABC's of FM. I created 3 tables with a fp7 file. I will slowly connect each table later. I am stuck with a little thing right now. 1. How do I calculate the number of letters in a text /field and show that in a separate field? It is variable with each record. 2. Is it possible to have a all word docs, graphics in one table and relate that each record. If so, please let me know how to do it. 3. Is it possible to open the graphic or word with a record / browse mode? Thanks, drb

Does anyone know how to create an accurate age calculation or function in Filemaker? I need to calculate a person's age accurately in years, months and days to compare this with an age in years, months, days that is stored in another table. Simply subtracting the person's DOB from today's date isn't accurate. Cheers.

Here is the deal, I have a database of advertisers who have purchased magazine ads. I want to be able to do a find for an advertiser and in the found set have a field that will show which magazines they have purchased an ad in before. I did this with a portal which I think worked very well however this ridiculous overdemanding boss of mine didn't like it because the portal showed every ad they had ever bought, meaning that if they bought an ad in one publication 10 times then that same publication showed 10 times in the portal. She wants the field to show only one occurance of each publication even if they bought 10 ads in the same publication at different times. A…

Hi Guys, Just have a really quick question. I've drawn my layouts using the FileMaker tools (i.e. the rectangle lines and oval) so that it uses the minimum amount of space.(Im trying to avoid using "proper" graphics as I've been told its what slows my applications network performance down) Once I finshed my design, I thought I'd place them in my preferences table and store them in container fields, so I then cut and pasted the objects into global fields. The problem is I "think" the cut and paste has converted my graphics into "normal" graphics instead of vectors. (Im not sure but when I go to do 400% layout my lines started to look jagged around the oval shape …

I have a data base on Filemaker 7 and a large folder on my server with over 20,000 photos that i need to insert into there coresponding record in filemaker. i want there to be a way for my employees to drag the file from the folder in windows and drop it in the container field in filemaker. i have tried to do this on my own and what i wind up with is a link that opens the file in windows. any sujestions?

Ok, This might sounds simple to you, but I have been tring to figure this one out: I have a field on my database called "Date_Created". This date is on every record. On every record I have fields like Purchased / not Purchased. I need to make a report that groups each record by month: Janurary Feburary March April May etc... On each month it has a count of how many records were purchased. How do you get the report to list months? Can some one help me figure this out. Joseph

I 've been trying unsuccessfully to extract the word "ERROR" from a field that contains a email transmisson log. I hoped to find a way to transfer the word "ERROR" (should it be present) to a different field using a calculation field. Since these messages are variable in length, using "Right" "Middle" "Left" don't seem practical. Is there a way to search or filter the field (without entering Find Mode) for the word and cause it to appear in the another field by calculation? Otherwise, how would I extract the word if I felt certain that it were the 19 th word from the end?

I have a simple question: If I have a checkbox lets call it "Incomplete". And I want to make a script that is an IF statement that says if checked then do something then uncheck it, if unchecked do something and check it. How would I do this? If the checkbox is defined as a word "Incomplete" does a "1" or "0" check and uncheck it? I know how to set fields but how do you unset feilds (Clear)? Joseph

Ok here is my problem, I've got this calculation that places a few feilds into one text feild some of the feilds in this feild are prices, so i have a $ added date1 & " " & ref1_1 & " " & ref2_1 & " " & "$" & charges1 & " " & "$" & credit1 & " " & ref3_1 & " " & C & " " & SYS & "¶" & date2 & " " & ref1_2 & " " & ref2_2 & " " & "$" & charges2 & " " & "$" & credit2 & " " & ref3_2 & " " & C2 & " " & SYS_2 & "¶" & date3 & " " & ref1_3 & " " & ref2_3 & " " & "$"…

Hi, I am currently using FMPro/FMServer5.5 (win domain), and plan to update soon to FM8. I have a design problem that I would like to solve and implement in v8. I need to calculate and show to the users some numeric field totals. For instance, in a client-invoicing database, the user chooses a client and needs to know the weekly, monthly and annual invoicing totals. My problem is not how nor when to calculate those totals, but to find the best way to store the calculated totals, which I think is compulsory (I need to avoid having to calculate this data when the user request it). Currently, I calculate these totals during idle hours (when the database i…

when you have a script that uses global fields...do you have to put the global feilds on the layout or can you just define it and never place it anywhere?

I have seen scripts in some of the FM solutions for importing images (which can include QT movies as well) -- when you use the script, it calls for an import of all records in a folder (rather than only a specific file) and prompts you to decide whether to add by the file reference or the actual file. When you use "Insert > QuickTime ..." it imports a specific file. I want the best of both worlds: is there a simple script for adding a particular file reference instead? as an added treat: is there a way to display the actual file reference in a seperate field associated with the QT movie container field?

How do i get rid of spaces (blank spaces). example: Corona123 =123 is for extra blank spaces. budweiser123456 =123456 is for extra blank spaces.

hi, I have 2 fileds in the same database. Field1 is a calculation field. I would like to auto-enter the value from Field1 into Field2. I tried 2 different ways -- 1. in Define Fields, Field2, Options, Auto-Enter, Check “Calculated Value” box, put “Field1” in the calculation area. 2. I set up a relationship from the database to the database itself (linked by the unique field) in Define Fields, Field2, Options, Auto-Enter, Check “Looked-up value” box, select the relationship, then select Field1. neither works. Can anybody help?

Now here's the situation, I made this database for a company (that I'm attaching at the end of the post), basically it allows you to enter in multiple lines data about customers's invoices: At the end of the page it displays: My problem is, per page there's room for 50 lines where to enter data, BUT I actually don't know in advance how many "lines" will be needed per month (could be less than 50 or more than 500) and I was wondering how to make it work properly. Solutions I've been evaluating so far: Does anyone have an idea on how to do that? Is it possible? If yes, how? Thank you in advance for any help I will receive. Yours Faithf…

Does anybody know how to limit the results on a field depending for example on the creation date... The result í want, is (ex) to konw de number of sales made between two dates... Thanks for the help, my job depends on it... :

FMP 7 (OSX and winxp) I have a text field that is based on the filename of the image in the container field: text_field_1=Product_Image. Works great in osx. It gives me the file name as soon as I place an image in the container field. My problem is that it doesn't work under winxp the result of the exact same field is: ? It doesn't give me anything, just "?". I have tried exporting the data and it just exports a "?" as well. Any ideas. The text field is a calculation so it updates automatically when I change the container field contents. Thank you in advance. Jeffrey Duncan [email protected]

I have a large database. I do my editing in the database and then upload the products along with their images to the website. Everything is working fine but Batch exporting all of the images (1 image per record) takes forever because it asks me for a filename/location with each image. Is there a way to just "suck" all of the images from the database and automatically keep them with the same name without having to hit enter every 3 seconds.

Is there a way of creating an external function to allow the user to select a text file, and have it inserted into a text field? Unfortunately, FM8 will allow a text file to be inserted into a container, but the text cannot be manipulated once there. Regards, Charlie

We currently use a portal to show 'training history'. It has training date, training type, Training location and Training hours. We are required to retrain these people every two years based on their last training date. So I was using this calucation to display their 'training expiration date': Training Date + 730 The problem is we are now adding other types of training to this table such as specific training and directed training which does not require training every two years. SO...because the portal sorts showing the most current training date first, the calcluation uses that date instead of the correct training date (say one or two portal ro…

Hi, I am trying to figure out how to keep a running count of certain records. I would like to have a global field that keeps a running count of all the records of "Type A" and another global field that keeps a running count of all the records of "Type B." So far, I've tried a portal and another method that counts the Number of Like States. Both methods provide a running count of all the records of "Type A" and "Type B." However, the result changes depending on which type of record is selected. What I'm hoping to find is a way to keep a running count of "Type A" in one global field and a separate running count of "Type B" in a second global field that are INDEPEN…

What is the best way to use URLs in a database that is web-published? It doesn't seem that you can right-click the link and choose "Open URL" like you can when the database is local. I'd like to be able to include URLs in some of my text field entries (ie, "Click Here to view the site"). Can this be done? Is there an effective work-around or add-in that makes it easier? Thanks.

Hi, Wondering if anyone has any idea how to do this; I have a simple database in which each record can have one of 2 or 3 possible entries from a validation list in several fields. For example one field entry could be "chocolate", "vanilla" or "strawberry", and another could be "cone" or "dish" and another could be "cash" or "credit". I am trying to make a unique code for each possible combination that would auto-enter, based on the values in the other fields. So someone ordering chocolate in a cone and paying cash would be "1", and someone ordering vanilla in a cone with cash would be a "2" etc... I am hoping this can be done by calculation, but at the momen…

Hi Everyone, In one of our new databases I *have* to use a timestamp in a portal instead of a date. For some reason I can't get it to sort correctly. For example if all the portal records are created on today's date, it will show the first record first instead of the most recent record. Is there a way to sort by timestamp showing the most recent entry (in the portal)? I've tried various ways via the relationship with no luck.

Hi all friends this problem is related with the trick to change tab of a "Tab Control". I wish to have two fields, both editable, exactly the same(as if the field was duplicated), but with different names. It seems simple... With 7/8 you can define a field as an autoenter calc replace existing value; so I thought to solve with: Field1 : autoenter Field2 and Field2: autoenter Field1 but this didn't work (or worked partially). Any other attempt to solve was without resolution. (and I'm trying from two days) Has someone any ideas ?

Does anyone have a good calcualtion or solution for determining a persons age by comparing currentDate with a field containing the persons date of birth. Seems like a simple solution that I can't seem to make work.

I have been sent a file with last name and first name in a single field. How do I separate them into 2 fields

I have two fields. Field 1 and Field 2. I want them both to be calculation fields that check to see if the term "P-" shows up in the other field. If it does, I want the computer beep and display a message that says you can only have that term in one of the two fields. Then delete the contents of the last entered field. Is this possible? It sounds easy, but like many things it easier said than done. Any Help you can give is much appreciated.

In my web site, users can submit text along with the bold, underline, and italics html tags. i.e. [b]Some[/b] text like [u]this[/u] I need to create a calculation field translates the html tags into actual formatted text. I propose to use: Substitute( text ; [b]substring[/b] ; TextStyleAdd( substring ; Bold ) ) However, I do not know how to isolate the substring, particularly when there might be multiple instances within the same text field. Any advice would be much appreciated. Thanks in advance! DSW

Hi all, Does anyone have any sugestions for this? I need to make a unique code out of a SSN. What I would like to do is this: Example: 249-65-4465 I would like to take the first 3 numbers of the SSN and convert them into letters 2=B,4=D,9=I this then would equal BDI I would like to keep the next two digits then I would like to multiply the last 4 digits by 9 So the final answer would be: BDI-65-40185 Can someone show me how to do this in a calculation. Or can someone show me how to make a identifier out of a SSN. Thank you

I am trying to use a set of Radio Buttons to determine a future date for customer service, based on the previous date of service. In other words, if the "Weekly" Radio Button is selected, and the last service was 10/7/05, then the calculation should return 10/14/05. If the "Monthly" Radio Button is selected, then the calculation should return 11/7/05. I have done extensive searches and have found multiple example "templates" that appear to do the above (once properly filled in), but I haven't been able to get any of them to work. It is additionally confusing because the templates are all very different from each other, so I haven't been able to combine the bits of k…

I would pull my hair out but little remains from some of my other FM battle scars... I need to have field in each table that stores as a global value the current record count of that table. This is referenced in a number of ways throughout the project. I have been using the function Get(TotalRecordCount) in a global calculation field. The problem is that although it updates when a record is added, it does NOT update when one is deleted. Why is this? My other attempt was to include a script step that used set field and set a value with Get ( TotalRecordCount ) to the global field nthis works very well. Since I am using a set of custom scripts for record cre…

I have a host machine A running FM7 and guest machine B accessing the app via Open Remote. When I insert a file from B (using File Reference), it is not available from A and visa-versa. Do volumes need to be mounted. I am running on OS X

Today's driving-me-mad problem is... I have a calc field with the calculation result as 'text'. "Closing invoice period: " & FirstOfLastMonth & " to " & Rental ended & " ~ £ " & Round ( EndCalc ; 2 ) The field consists of text; a 'date' calculation field; a date field; and an external number calc (which is itself rounded). All works fine when the result comes out as, say, £56.25, but if by some misfortune, the number is £56.20, it appears, concatenatedly as £56.2 ... I've truncated, setprecision and rounded and done these in both the external calc and within this calc field, but nothing works... Can some kind person put …

I have a database that graphically tracks completion status of projects. When you are done with a task you select it's repetition and hit a a delete button. When all of the tasks are complete, grid is empty and the job is done. This graph could be used to keep track unsold seats in a theater or unreserved rooms in a hotel. It's pretty simple. Right now you must delete each repetition one at a time. I would like to be able to select a range of repetitions and delete several at a time. Is there any kind of shift/select type gizmo to allow me to select more than one repetition at a time? Thanks for any guidance, Jarvis task_grid.fp7.zip

Hi Guys I have a FM solution which has been upgraded from version 5 - 7. In this solution I have always used container fields to store graphics which are referenced by other calculation fields. When defining a new container field in version 7, when I quit FM it clears the content of the container field after i've added something - this is different!? I've checked perferences to see if there is an option set to store the graphics locally (RAM) on may machine but can't find anything. My DB is a mutiuser solution & at no point after adding the graphic, does it appear on other users layouts - has something changed or is it me? Any Ideas?

Hi Everyone, Modification date, timestamp etc. changes whenever data changes in any field. It tracks records changes. That's great. But I want more. I want a modification Timestamp which I can tell to ignore (at the start of a script, for instance) the following script data changes, ie, set a global field called ModFlag (number) with 1 to stop the TimeStamp until end of script when ModFlag is again set to 0. Or activate/deactivate depending upon Privilege Set or AccountName. I'll use a regular Modoficiation Timestamp also but I have certain fields which I want to EXCLUDE from the 'record change' tracking. And a simple maintenance script, import, etc. ca…

I have a call logging database & I need to pull out some reporting information. I have numerous calculation fields that: Get(Curentdate) -1 -2 -3 -4 Etc I then have further fields where: if(logdate) = ;1,0) A summary field then gives the total of each calculation field giving me call numbers per day. The only problem I have is that the more summary fields I add, the slower the calculation time is (as I have 2000 + calls in which it's summerising). I need to get these figures idealy without performing finds/scripting. Is there a better way? Sorry if i've missed an obvious one.

I have a problem reducing my fraction to there lowest denominator. the calculation I found returns 2/64 instead of 1/32. I found this cal from earlier postings and I am a novice. the user are setting up equipment with the script and results should be in 64th,32nd,16th,8th,1/4th, and 1/2th,I need the fractions to break down to their simplest forms. Case( GetAsNumber(Cut 1Adecimal)<.015625; ""; Mod(Cut 1Adecimal*2;1)<.015625; "1/2"; Mod(Cut 1Adecimal*4;1)<.015625; Round(Cut 1Adecimal*4;0) & "/4"; Mod(Cut 1Adecimal*8;1)<.015625; Round(Cut 1Adecimal*8;0) & "/8"; Mod(Cut 1Adecimal*16;1)<.015625; Round(Cut 1Adecimal*16;0) & "/16"; …

Hello... I´m new, and noob with filemaker...probably u will joke but..... How can I take (for example) just the second value from a repeating field to a singular field

I'm going to ask a question that I know will cause most of you to cringe. Please don't kill the messenger because believe me I have tried to get my point across regarding primary keys. My company saves contact information based on a First Name + Last Name calculation. We have been doing it this way for 10 + years and it works pretty well for us. Like I said I tried to change their minds but at this point its hopeless. The first name, last name (lets just say NAME) calculation is used to set up relationships to pull in the address, phone, fax etc. data to other layouts. So my question...Is there a way to also make a calculation result be unique? Like whe…

Hi, I have completely hit a creative brickwall, and I'd like to get some opinions about how any of you would layout this particular field(s). The idea revolves around "100%". If any of us work 40hrs/wk, it can be considered 100% time (also, 30hrs = 75% time, 20hrs = 50% time, and so on). Basically, there are people that work on projects here; however, some could work from 5% time to 100% time on any one or more projects. The thing is that--no matter what--their hours have to equal 100% (aka 40hrs). Basically, I thought about creating two fields: one with the name of the project and another field with the % of time doing it. The thing is how many fields d…

Hello again... The Question now is...: How can I make different serail numbers, in the same fiels, deppending on the Customer´s Country (for example). The Ideia is to create in the same field, this result: PT-00001 PT-00002 CH-00001 FR-00001 CH-00002 PT-00003 PT-00004 FR-00002 CH-00003 ............ Sorry for the basic question.....The Rookie apologize

I have a list of records in a "child" database, for which some data is repeated. Think a list of students where each student may have multiple records, one for each of her classes. I need a field which says basically "which portal row the record would appear on in the 'parent' record." If David has seven classes, I want his first record to say 1; the second, 2; etc. I don't want a summary field. GetSummary() is not of much use in my opinion. Is there a way to hard code this field? I have seen others do cool things with GetNthRecord, and I have adapted it to my own use (i.e. replacing GetValueListItems). I feel the answer is close. I would value and…

Hi I have a time field set to 24hour time. This supposed to represent at period of time. ie 1 hour and 30 minutes. (entered 1:30) Sometimes a user enters 1.5 and this ends becoming 0:0:1.5 ie 1.5 seconds. The field is entered via a display dialog in a script. Any ideas what I can do about this? thanks

I think this will end up being a field definitions problem, but there might be some other voodoo involved. I have a database where I need to display the total value of some related records. The value of each related record is the sum of some child related records, so I have 3 tables altogether. Something like this: Project - Tasks - Items In 7, this works fine, although sometimes I need to refresh. In 8, when I update the child "Items", the "Task" records update, but the sum in the "Project" record does not. If I close the database and re-open it, all the values in the "Project" database display correct values, but when I make the ch…

For the life of me, I can't seem to get my head around how to apply calculations/summary fields to get the results I need in this database. I am attaching a sample database in which records are created to represent art requests. Each request is associated with a Grade and a chapter and has a certain "spec type" (or "art type") and status. Given this, I want to create a report that shows, for example, what percentage of each "spec type" is in each status stage (values of the Status field) broken down by grade level. I've included a mock report in the database. Can anyone help, or point me in the right direction? Thank you. Simple_Status_Summary.fp5.zip

Hi! I have a text calculation field based upon two other field. the calculation is the following If( Pref::Global_Language=1; spread_imperial & " " & spread_imperial; etalement_metric & " " & spread_metric ) basically, it checks if the application is French or Ensligh, then display the spread length in inches/feet or cm/meter. First, I think a calculation value can't display a combination of value, but why doesn't it update? I have another calculation field that is basically the same (based upon two different fields) and it updates as soon as the reference field value is changed. This one won't update, it always keep the …

Hey guys, Im new to Filemaker and am stuck with a database I'm trying to design. Basically, I need to record dates that adverts were placed along with the details of the adverts (size, price etc). I then need a simple report, so that I can choose a date, and the report lists the details of the ads that were placed on that date. I've tried the help file, and the Filemaker Bible but I'm not sure what I should be looking for. I can design the layout fine, but Im not sure what sort of field I should use for the dates, and hw to make the report. I hope this describes the problem okay. Cheers

Hi there, My database has essentially 3 tables. Table 1: holds company expenses (not individual job based expenses) Table 2: holds job details (client details, hours worked on that job portal with expenses etc.) Table 3: job expenses (petrol, transport etc.) I have a portal in 'table2' to show the jobs expenses which almost works fine. The problem that I have is that I want to see a running total of the job expenses. I have created a summary in 'table3' that displays this fine. I just can't seem to get it to display in 'table2' though. It only ever seems to display the total of the current record. Any ideas?

Any suggestions on alternatives for repeating fields? I use repeating fields for contact histories, as well as a history of when a newsletter was sent and which newsletter was sent. However, I would like these to be searchable, as well, I would like to eventually use individual repetions for summaries. So if I need to make multiple entires, for example this date - inquiry this date - response this date - info pack this date - response How could I do so without using repeating fields, especially if the order is always changing so I can't just have an inquiry field, response field, info pack field, because it changes for every individual. …

is it possible for a summary field to view any negative numbers that it is adding up as zero? i want to show negative numbers in the fields that are being added up, but i do not want them to be deducted from to total. also, if there was an occasion to have a certain negative number deducted from the total, then is there an easy override? if you only know the answer to the first part of this question but not the last - please help with one or both. thanks the field that is being browsed and added up by the summary field is a calculation field - what am i leaving out of the calculation to make the answer ignore negative numbers?

Hello I am very new to Filemaker so I'm sure there is a simple answer to this, but I just cannot figure it out. I have 2 tables: Jewelry and Sales In the Jewelry table I have the following fields Name (Text) - example "N 042" Short Description (Text) - example "Garnet and Pearl" Category (Text) - example "Pendant" Price (Number) - example "120" In the Sales table in addition to basic sale information like order number etc I have a list of each piece of jewelry that was sold as part of a particular sale. Name (Text [10]) Short Description (Text [10]) Category (Text [10]) Price (Number [10]) What I would like to be able to do i…

I would like a thumbnail to be generated upon inserting a file into a container field. I've set up two container fields, one for thumbnail & one for image - I'll be inserting PDF files in the image container. Any advice would be helpful.

I am having a problem with a calculated result displaying when it shouldn't, obviously there is something wrong with my argument. This is a relational database. Three fields are involved. "Estimated Cost" (number field with a dollar figure entered that is the estimated cost of a project) "Total Jacket Cost" (a calculation field from the related database (Calculation Result is a Number)) "Approaching Estimate" (Calculation Field that should appear as the result of a calculation (Calculation Result is Text) I have tried the following arguments: Case( Total Jacket Cost > (Est. Cost * .85), "Approaching Estimate" , IsEmpty(Est. Cost), "", "") …

For data quality assurance, we decided to enter hundreds of data records twice and compare them if there is any discrepancies between each. I would welcome any tips how to do this. Can anyone suggest plug-ins, scripts, or methods for this purpose?

I already asked this question but since I piggybacked it onto a previous non related post I'm hoping no one saw it, rather than not having any advice for me. Eitherway, I'm having some major trouble with my database surrounding multiple last names from completely different families. Comment suggested I incorporate a new table called ownerships where I link the last names to the properties and that is what I am trying to do. But the problem I am having is incorporating autoentered serials. If I have a _ClientID (auto enter) and a _PropertyID (auto enter) and I'm linking them together in the ownership table no one will remember that Smith = 1178 and his property 6 h…

Hello! I wounder if there is a way to get out what diffrent kinds of values there are in a filed? If I have 4000 Records with either 1 or 2 in a field called "number" then I just whant to get a list with 1,2. A list with the different types of numbers entered.. Regards Jocke

Is it possible to have multiple (as in not related) calculations in one field? For example. I have a field that displays a number based on a calculation. I also need the text of that field to change color to white if another field has white text. What would be the best way to combine these two calculations into one?

I need a calculation field that is supposed to change its text color if the text color of another field is white. I'm not quite sure how to do this. This doesn't seem to work: Case (TextColor ( Att15 ; RGB ( 255 ; 255 ; 255 ) ) ; TextColor ( Att15 Card ; RGB ( 255 ; 255 ; 255 ) ) Plus I also need this calculation in this field. Att15 + PAtt Container I'm not sure how to make the first calculation work, and I don't know how to combine the two calculations. Any help you can give is much appreciated.

OK, I've probably been staring at this too long and overlooked the obvious. How do I count the number of related records within a found set? I've set up a calc field with the count function but it returns the number of related records for the entire database. Thanks!

(1) I am trying to create a field showing the path to an image I placed in a container. (2) Ideally the path would be a button opening up the exiting file. Anyone who could help me?

I was wondering what the easiest way would be to create a simple script to calculate the age based on the DOB and the current date.

When I choose Insert Quicktime, the mp3s are dimmed. I can, however, insert AIFF files. Does anyone have a clue? Greatly appreciated.

I couldn't figure this one out so.... We have several databases I'd like to relate to each other...however to open them all up at once (like you can do with the filemaker 8 business productivity system) I have to have file options set for logon with 'admin', otherwise the client will have to logon to each DB as it opens with the 'open' script. This is fine however we have certain portals which record the name of the client (such as in notes, etc.) automatically. Is there a way to grab the name of the logon name the client used to login to the main database for use in the others databases? Wow sorry that was so long!

I have two tables, Client and Vendor. They can each have an indefinite number of addresses. Therefore I decide to make an Address table. In this table, each record is an address (tuple of street, city, zip, type ("Shipping", "Billing", etc.), etc.). One of the columns is a foreign key, whose value is the primary key of the entity whose address this is. Now the question: How do I have the primary key field of the two tables Client and Vendor share the same space of unique serial numbers, so that no key is used in both tables? Otherwise I have to make two address tables, ClientAddress and VendorAddress, which is annoying for a variety of reasons. More generally, h…

I have defined a password to be a member of one group. I have a calculation field that is defined as "group = status(currentgroups)". This calculation returns all the group names and not just the group the password is a member of. Does anyone have any ideas as to why this is happening. I did this because I wanted to use the group in other calculation, but if it is not returning the expected results I cannot use it.

I have a basic solution for calulating the time it takes for a task: task_begin (insert current time) for login and task_end (insert current time) where (task_end) - (task_begin) = total time -- with some calcs for rounding, etc. Where I need to refine this is when the task-end crosses over midnight and I start getting negative numbers... I could really use a calc to deal with this eventuality .... thanks in advance:)