Calculation Engine (Define Fields)

Hi guys, Attached is a small example of a problem i have. 1) I a repeating field called designation that has a value list entry. I want to be able to validate that no two repeats of designation is the same. Also i need to validate for the record the retail and commission can never be together in the repeating fields. 2) Secoundly if at all possible that if a use picks retail for the designation for the first repeat of designation that the first repeat of sub designation will acquire the the value list of SubDesignation(retail) - VL this can be any number of the repeat. so if designation(3) = "trade" subdesignation(3) will have a pop menu of S…

I've set up a container field that displays a picture. I'd like another field to display the attributes of the file referenced in that container field. I'm after the resolution pixels tall x pixels wide, and other information if it is available. Is this possible? Thanks for any advice. -Keith

I'm trying to do something very simple (I believe with FM Pro 7 on the Mac) and I think I need containers. I've inserted images into containers manually, but I'd like FM to do it 'on the fly'. I have a directory of 'tif' files at the same level as the current filemaker pro database file. (I could easily convert these all the jpgs or PICTs if necessary) The names of the files match a field called 'product_id' in the filemaker database, with a ".tif" or optionally ".jpg" at the end. Example a value in product_id might be "sample" and there is a corresponding image file called "sample.jpg" in the relative path path ../catalog/images/ I would like to simply hav…

For the past few months I've been working to move several users on an all-Mac FMP 5/6 system to PCs (XP). One of the biggest stumbling blocks I encountered was the use of linked EPS images in several files. Macs and PCs don't play nice with EPS previews, so we made a decision to use GIFs (exported periodically from EPS originals) instead. All the images are stored on a Mac file server and inserted as references by the Mac users. The PCs are conencted to the file server via PC Mac LAN and display the linked GIFs. However, now I'm getting complaints that the GIFs do not maintain adequate detail on-screen. I'd like to use PNGs because they retain more detail when displaye…

I have about 3300 records in a FMPro 6 DB and I would like to migrate this to another DB manager such as Access or MySQL. About half of the records in this DB have an image associated with them, in a Container field. How can I extract these images at little or no cost (except for my time)? I have found FMExport, a program for exporting/extracting the images (and other binary data) but it is 99.00 USD per license. Can anyone help? Thanks in advance.

can't seem to make the Get (RecordNumber) do what it is supposed to. I have a calc field defined as a number Get (RecordNumber). from everything it says this field should change as the record is included in a found set or sorted in one. I set up and attached a test Db that has an auto enter serial field and a calc field as I described. Of course when I created 26 records in a row the numbers were the same. BUT if I find one record the calc field should show 1 regardless of the value of the number in the other field, isn't that correct? So if I find four records and view as a list the calc field should show 1,2,3,4, right? It doesn't, the calc field is not indexed but the …

How do i create a typeahead feature? thanxs

Hello all, How can I convert a field in my layout to text from a number? I am trying to convert a customer # to the customer name and have the name populate the field...Is this possible? I guess I am trying to have the report grab the customer # and then convert the number to the customer's name and put that in the field name "customer name".....please help.....

Hello, Working on a FMP7 server, I have imported pictures from a folder (only file links) in a DB in a multimedia container. When I looking the DB on from the server, images are well displayed but things go wrong when I use a FMP7 client to look at the pictures: instead of pictures, the multimedia container displays something like "unable to find the file...". So is there any way to display pictures stored on a server with file links? May be with a plug-in? Thank you for your help!

Hi world, How to define multiple value lists (not just 1 value list) for the same field used by different records? is it possible at all? thanks

Basically I have attendance DB. This DB keep track of all the classes the student Attend. I want to get the total of credit hours for each class a student attended. I have two fields, one is call Class_id and the other is Class Number, each class already has assign how many credit hours it is. Also each student has its own StudentID and they are part of program so there is field for program call ProgramID. T1 could 3.4 hrs or A1 could be 4.0 hours here is example. Class_id=T Class_Number=1 Classes go like this: T1, T2, T3 to T64 A1, A2, A3 to A64 H1, H2, H3 to H64 The end result, i want to do is: James has T 35 Hrs A 25 Hr…

Hello I have a calculation field that adds together some time fields. (a+b+c=d) At the moment the answer of d is always hours:mins:seconds Im struggling to find a way to round up or down the result to the nearest minute, 10mins, or hour. (Ive tried the Round, Ceiling and Truncate functions without effect). Any ideas?

Hi Is it possible to use the or operator in in calculations? So if you have a calculation like this... If( Status(CurrentUserName) = "James" or Status(CurrentUserName) = "John", "True", "False") I've just tried it and it doesn't seem to be working. I realise I could use Case() rather than nested If() statements, and I am doing so in the meantime. But I just wondered why I couldn't get it to work. Any ideas? Thanks Batfastad

Is there an easy way to keep someone from accidentally deleting a file from a container field? Right now if you click on the field and hit the delete key on the keyboard the contents will be gone? Can i script an "are you sure you want to do that" dialog or just make it harder to delete with out protecting with permissions?

I some help on how to auto format a field. I would like to be able to enter a 3 digit number such as 203 and have automatically formatted as 2.0.3 when I tab to the next field. I found a template on how to do something similar to this for a phone number field but am unable to adapt it to what I need. Any help would be greatly appreciated. Thanks!

Experienced FMP People will probably spot the problem in a minute 1109202737-Calculation-GlobalIssue.zip

this might be an easy one but I can't seem to hit it on the head. I have an invoice DB and I want to email the tracking numbers to the customer. The message is mostly the same but sometimes they need to modify it. So I made a global and typed in the message. However, It is only temp. When I shut down and open it again, the field is empty. However, I have another set of globals that do the same thing. I had put text in it about a month ago and the text is still in it. But I found a typo. I changed it, but when I open it again, it is the old text. So,I am guessing that some are stored and some aren't. HOw is this doing it? What am I not seeing here?

Hi All: I'm suffering a total brain freeze on this, and I know it's simple. I've got a checkbox field, and when another field is filled in, one box should be checked - that's simple enough. But I can't think of a graceful way to check if the box is already checked. It's embarassingly simple, I know, but my mind is elsewhere (probably due to a tight deadline and/or hangover). Thanks -Stanley

Am trying to use the text color function to Display Red when a person is under 18 yrs old. Having some questions about setting up the calc to achieve this. Help would be appreciated. Thanks

I have a portal showing a set of repeating fields. I have a repeating field in the same layout. I wish to create a script which will enable one to enter the portal field at one of it's values and cut and paste the value to the second field. This works just fine when I paste the first value into the first value; however, when I try this with the second value, I can't get it pasted into the second value using a script. Thank you for any help. George

This is an aspect of filemaker that I've always wanted to know how to do but don't understand how it works... An example is the "People management" template that ships with FM7. Each record shows the person's name, and then shows several subrecords that show jobs associated with that person. Can someone give me the basic concepts behind this functionality? Thanks! Andrew

All, I am trying to figure out when (in FP7, single user environment) to use global fields in general, and when to use globally stored calculations. FP7 Help only gives information for shared files; this does not seem to fit my problem. Couldn't find a related topic in the forum or FAQs- pardon me if I missed something. Here's the problem: In FP6, I used to put global values into a dedicated table. To use this value from other tables, for example as a match field to create a relation, I created unstored calculations "copying" that value. (Example: global field in user config table holds a language name like "en"; many other tables need to use that value to find…

I have a large text filed (multiple paragraphs) that I want to format the field text alignment using "FULL" from the FORMAT menu. When I choose the "FULL" option the right edge of the text is clipped (partial characters) on the right side of the field. I've tried eliminating all borders, nothing seems to effect the clipping. I see this both on the layout displayed or when printed. I've tried a separate a layout using just a merge field, same issue, right side characters are clipped. Any thoughts?

This should be rather basic, but I can't figure it out. I'm defining repeating fields. I format the field in the layout to show only a limited number of the repetitions. I check "use vertical scroll bar", but no scroll bar appears in the layout for that field. What am I missing?

I could use a hand with this...I'm kinda new... I'm trying to pass a GetSummary result from one table to another. Is this possible? I thought i could set-up a GLOBAL field in the same table, then look it up from a field in the other table. I the look-up field is always blank, even though the GLOBAL has a value. Any help would be appreciated.

Hi guys, I have a repeating field called Type with a repition of 3 i also have another repeating field called sub_type with a repition of 3 both on the same layout. Now what im getting stuck on is : 1 i obviously dont want any of the repeating types to repeat themsleves Example Type (proper validation) dog cat mouse type (Should tip validation calculation) dog dog mouse if the user picks dogs twice i want it to revert back to blank until he/she picks something that doesnt repeat dog. 2. If the user picks dog for the first repition of type (type[0]) i was w…

This is a very simple problem... I just do not know how to do it. How do you add years (in a number format) to a date (Date Format) Example: 21 (Years) + 2-14-05 = 2-14-26 Help Joseph

Good Morning Everyone: Can someone help me write a calculation (If Possible) whereby when a record is created the creation date is auto entered in the field called "order Entered" and then in the field named "Order Due" The calculation figures out date "order entered = order entered + 5" (easy, then the tricky part for me) but if that "order due" date falls on a Saturday or Sunday the calculation pushes that date to the next Monday? This would be very cool and helpful to this data base I am writing and give a much more polished solution for the person I am writing this for. Thanks in advance for any help you all can provide. As an aside, is the a way t…

Is there any way to print a report using records for a month (0X/01/XXXX...0X/31/XXXX) and have only the month of the records print on the header of the report?

Can anyone help me better understand "SET FIELD"? I feel like I am going the long way around to get some things done, but I do not understand what SET FIELD truly does, but I see it used all the time by toher developers. I know this is pretty pretty basic, but if someone could HBO (help a Brother Out) I would really appreciate it. Thanks, Steve

Hi, i'm trying to set up an Auto-Enter Serial number on a field, and my problem is i want it to have a different format depending on which value i choose in an other field (with value list DV, PV, ST, AUDIT) I tried to do a little calculation but it obviously didn't work... Do i need to set a calculation and still have the Auto-Enter Serial number ticked?? Any help would be much apreciated!! THANKS !!

I need some help here, I

Please forgive my igorance. I'm still teaching myself. I'm taking an old mailing list and trying to integrate it with a new one. The new list has a "FirstName" field but the old one doesn't, however the old one DOES have a "Saluation" field containing the info I need to copy. I tried to define a calculation for the "FirstName" field: FirstName= Salutation But this only seems to work when I'm entering in new records. How can I make it go through the existing records and fill in this new field? Any ideas?

Hello, im using filemaker pro 7, and I just want to know is there anyway I can set the field to auto-complete like when you use Internet explorer and if you have been to a site and if you press the letter it will look up the closes match of sites that you have been. So in this case I want the field to look up related records saved previously. I realise that you can do that by drop down menu but I want it to show with out the drop down menu. EG. if in the record field "product" contain "filemaker". Next time when you entering data for the field "product" simply if you type "f" the word will display with some like this this "filemaker" the 'ilemaker" will be highligh…

Happy Valentine's! My use of FMP likes repeating fields (or some version of them) because, in an invoice, I can put one color of an item on a line and show it in all its available sizes. The layout is very readable and data entry is quick as you only need to input the color when and order is placed. The size fields appear automatically. However, I've heard and read that repeating fields are to be avoided. Can anyone tell me how to avoid repeating fields and still: a) enter data quickly, without needing to define each color and size for an order item? show all available sizes of a particular color on one line? Thanks! p.s.: This post is sor…

I have a repport with a calculation field. When one of the referenced fields are empty the field is filled in with a "?". What can I do in order not to have this "?" in the field ? I have already checked the check box that says do not evaluate if all referenced fields are empty, in the calculated field and the "?" is still there. Can someone help me please. LVA

I'm fairly new to filemaker and creating an inventory db using and modifying the template in FM. I want to be able to count reoccurring values in a "Model" field so I can generate an "On Hand" field. Suggestions?

How do I get my database to add a new line automatically when entering information in a record. What I'm trying to do is add a new line like the Time Billing database that comes with FM 7.0. I want to enter information like date and notes about a client and as soon as those fields have information in them, a new line below it is created for a new entry. I have tried to have a look at the Time Billing database but cant make much from it besides that they are using a portal, is this reqired for what I am trying to do? What would be the way to make this work?

I have a portal with two fields: Years & Date I would like a function that would return the longest time in years along with the date associated with it. Example: PORTAL: (Years) (Date) 2 1-5-05 4 5-6-05 Would like 4 & 5-6-05 Returned on the main page. Help please Joseph

I have a database which I use in my shop for POS. There are 3 main files Invoices Products (holds prices, product descriptions) Stock (holds all products booked in . inc serial number for each record) I have set it up so that when a products serial number is entered (in an Invoice), it checks to see if the serial number is one that has been booked in.If it is not, then a dialog box pops up and tells the user to try again) I would like to go one stage further and not let the user sell a product with a serial number if there is an older one thats in stock. I have tried creating a field in "Invoices" that looks up a calculated result using the Min f…

I have a file with field "Category" (categories are Recieved, Started, Pause, Restarted and Ended) and a date field "Date". I want to calculate the number of months of activity (between Started-Paused and Restarted-Ended), and not the periods with inactivity (Pause-Restarted). Anyone have a solution? Ive tried many things, but not solved it.

I need a rounding equation that rounds up to the nearest whole number. Example: 7.00 = 7 or 7.01 = 8 or 7.12 = 8 or 7.65 = 8 or 7.95 = 8 The rounding equation does not do this... Thank you Joseph

I need to make a calculation only once when I import records. After that, I want to keep the calculated values and use them for Finds, so I would like to change the calculated field into an unmodifiable number field that is indexed. Is there a simple trick to convert calculations to values? I can do it with a script, (copy the information to another field for each record), but wonder if there is a simple trick to do it faster. Thanks for any help.

Hi, I have a database containing 100 records with each record containing a container field.Each container field is required to contain a PDF.This application is required be accessed using PHP code (using FX.php) and it is required to provide a link to each record and on clikcking a link the corresponding PDF should open up.But what is happening is on clicking any link the first PDF opens up. I am not able to use image_proxy.php file and open up the desired PDF. Any help is appreciated.

Is there a way to create a field that combines all the values of another field in all of the records in the found set? For instance, a field that contains the value of PhoneNumber for all the records in the set. So if there are 12 records the field would combine all twelve phone numbers.

I am working on a db that users will create records in. After all records are created, there is a script button that sends me an email with all of the information for those records. For each record they create, they will need to send a seperate attachment. Is there a way for them to select the attachment in each record and when they hit the send mail script button, it automatically includes all of the attachments? I have not found a way to do this. If anyone has a solution it would be a GREAT help. If anyone needs more clarification please let me know. Thank you.

I have two databases with many same fields. I have changed a lot of fields definition (such as calculations) in one database (which contains about 1200 fields). Now I need to do the same with the other database (which contain 800 fields) so they can match. Is there an easy way to change(or import) the calculation fields in the second database? Or I need to compare and copy/paste them manually? I am using FM Pro 6 (or developer) on Win XP. Thanks.

I need to create a script that find all records whose Created By field are equal to the value of the Current Record's Created By field. Am I overlooking something obvious? Sorry, I am fairly new to this. Thanks!

I have a lsit of clients who are on a waiting list for services I have a field "today" which changes every day I have a field certification date I need to calculate the time on the waitlist so I did los=today-certification date I get a very long number like 739910 How do I get it right

I am using FileMaker Pro 6 and was wondering if it is possible to have a pop-up menu where the value list changes depending on a selection made with in another pop-up menu or pop-list(preferably both). I'm not sure if that makes sense, so I'll try to rephrase it. If the user picks option A on menu #1 I want the value list A to be used on menu #2, and if the user picks option B on menu #1 I want the value list B to be used on menu #2. Thanks

I am trying to design a rental system with automatic invoicing based on the date such that: if the rental start date is in the current month and the start date is not the 1st of the month then Rental/Number of days in the month*(number of days in the month-Rental start date)+commision. And conversely if the rental end date is in the current month etc. Can anyone help construct this formula please Chris

Ok i have built a billing sheet table. one of my fields is rep (which pertains to sales person) I want to make a calc on my monthly stats page that will add the amount field to the specific name only. I tried carol=repp + amount but it does not work I want to be able to tell filemaker that the amount in this record should be added to a total for this rep. Plz some small help would be great!

I'm trying to build a payroll module that tracks total hours based on calendar days and work weeks. I would like to have record 1 date field to be January 1 and have each successive record add one day to the calendar. Day 1 = January 1 Day 2 = January 2 Day 32 = February 1 Day 365 = January 31 Etc. I am hoping to total payroll hours per day and per week, with the year broken into 52 weeks. Is there a function that can add one day to the preceeding day and keep the month and date accurate? I don't if I explained this right but I still hope someone understands what I am talking about and can aim me in the right direction. Thanks, …

Ok, this may be asking a little too much. I have a single table with several fields containing grades pertaining to a student's performance in a single course. I want to have a calculation field that determines the student's average said course. The catch is that I want the calculation field to be defined by the user, on the data entry side. Example: I want to be able to create a single table that I can use as a template. This would allow me to reuse the template on as many courses as I need to. But, I need the instructor of each individual course to be able to able to specify the calculation used to define the students' average. However, the instructors aren'…

Hello. I have four fields: -A ("total") -B ("correct") -C ("incorrect") -D ("blank") I want to validate fields B-D (always, no over-ride on data entry). I've asked for an error message to displayed any time the validation fails (i.e., B ~= A-C-D). I have two problems. First, the validation doesn't always work. How can I trouble-shoot this? And is there a way to "trigger" the validation for a field with data that were entered before the validation was set up? Second, I would like to validate field D, but it should not be flagged as invalid if the result (D=A-B-V) is 0, since 0 is a possible value. Thanks in advance. gwen

Is there any way to take input that is in a repeating field and make each instance its own field? For instance if I have a repeating field with 4 author's names (allauthors), and I want to seperate each author into their own field (author1, author2, etc.) Any help is greatly appreciated.

Hi, In one of the field of my database, a need to enter a specific path were some related files (other then FMP) to that records are located over our network. EX: /Volumes/Projects/BlueRocket/BR052_001/doc/BR0052_001_eval.doc I want the user who browse & Search the Data, to just click on that link and then OSX will open that location in the finder. Is that Possible ? thx Guy

Hi all: It's been a while since I've actually developed in FM, I come back and they got this new fangled FM7 out...dang it was comfortable under my rock. Anyways, I have 7 but I am still working in 6. I know I have used Troi file plugin to get the name of a file that I have specified. Well I want to be able to do that without the plugin. Is there a freeware plugin or some fancy external function that somebody has come up with? Say I insert a reference to a .jpeg in a container. Can I get the name of the actual image file by means of a calc field or script, and without the Troi plugin? Thanks for your help!!!

Hi, I am creating a Database that help me doing the bidding of projects that i could work on. (if i get the job!) I have 2 Tables : One being about the "project" (each record is data about a specific project) the second table is about all the different "parts" that need to be acheive in a "project". In the "Project settings" i have 4 different Rates : Rate A, Rate B, Rate C, Rate D. Each of those rate are for a entire day of work. So, i put a number for each of those Rate: 100$(RateA) , 200$(RateB), 300$(rateC) 500$(rateD). I could change later those -Rate- if i need to. After that, i would like to go on the "Parts" table and just puch a "Day number"…

I hope someone has done this before.....I have been asked to add something new to the invoice layout. I need to have my layout show pictures from Corel Draw, the pictures are the finished product of the line items on the invoice. How can I print this picture on the next page after the invoice prints? What would be the best way to insert the pictures from Corel Draw? I am using FM6..... [color:"pink"]

I've created a very basic logbook (in list view) for which each entry is timestamped. Because there will be a lot of entries, I want to be able to discern when a new day's worth of entires is started. Is there a way I can bold the first timestamp of each date (there will likely be many log entries on any given day, and I only want the first one to be highlighted so as to indicate it's a separate day from the previous entires)? Any suggestions on a better approach - creating a "date" heading for each change in day, perhaps? Thanks!

Hi i want to add a file to my db called staff rota but im a newbie and am not sure of the best solution,i want a field with the month begin date say 1/10/04 and then fields for working/not working and the days of that month, i can then call my drivers and as they give me the days they are available i can click that day to show their availability???

I am wondering if anyone knows how to mask the data being entered into a field? I have a script that looks to a field for a "password" before running the script. I would like the data that is enetered to not be seen. I know I can change the text color to white and then it's not visible, but you can still see what is being typed as you type it. I would like to to show up as *'s or something is possible. Any ideas?

I've finally figure out my little referencing and inserting image problem - FM5 can't insert .tiff file as Image. So I switch to Object and viola! Now I have a slight problem before I'm home bound - modifying a container field's link. I need to change each of the container field link to its respective image new destination (e.g the image used to be in C:Incoming Fax, now it's D:Incoming Fax) Is there a script or plug-ins that does that? I'm looking at TroiFile.28 and I couldn't find exactly what I'm looking for. Thanks in advance ~rich

ok ive gt a field coded like this Date &

Hey. I've got a portal where you can enter in payment tender (checks cash credit etc) I want entering the information to be nice and smooth. But I'm trying to make Filemaker prompt you if you try to modify it. I was thinking I could do that with a calculation validation, but my brain can't seem to figure out how. Am I on the right track? Anybody know of a way to do this? Thanks.

I tried to import imaging files from a folder and every file made it to the contain field except .eps file. It simply shows as blank. If I used insert picture, I can insert the file in the container file. Dose anyone knows why and how to fix this problem. I am using developer 7. Thank you.

Sorry I'm new. I need to create a History field. I need to populate this field with the date, time, the name of the person logged in and what fields they changed. Can someone point me in the right direction? Thanks!

How can I reference a summary field / can i reference a summary field via a relationship in file 1: lab id expense summary of expenses for lab in file 2 i'd like per lab record to show the summary field from file 1 is this possible either via relationship or calculation ???

I'm attempting to define a field where I can type in say, "120399" and when I tab out it will read "12/03/99". What do I need to do this with.? Thanks, R

I have an audit trail for field modifications system incorporated in one of my databases. I'm using what appears to be the standard method of doing this type of operation in FM. The trigger for the generation of the audit trail is as follows: A unique serial number field A calculation field that has a case statement which includes all the fields you want to track. A self join relationship between the two fields above. A current info field. Which is a calculation using the status(CurrentDate), status(CurrentUser) Status(CuurentFieldName), Status(CurrentFieldContents) etc.. A history (log) field that is a does a look up on the field below. A calc…

I am trying to create 4 check boxes on a search page. I cannot get it to be a switch where it is either checked or not. I can get it to do it from a popup menu but that is not what I want. So if someone could tell me howto do this that would kkick butt!

Hi All, I am writing a script which populates a field at runtime with Set Field step. I want to make some text bold. What is the method for doing this? is there any command that can be written in the Calc of the Set Field step? Pease let me know. Thanks. Yogesh.

Q. I want use a number field to auto fill other number and text fields. For example: I would like to type in a location number and have an address, phone# and fax# fields fill out (as separate fields) automatically. Can this be done? And how? I'm very new to FM. Thanks.

I have inserted a Flash file into a FileMaker 7.0 v3 Container field on a layout. I would like the file to begin playing when the layout is loaded. A button on another field runs a script that does run the Flash file, but doesn't actually let you see it happen. If I use the following script steps; when I press the button, FileMaker waits for a moment, then navigates to the other layout where the Flash file has already finished playing. IF the Flash file has sound in it, I can hear the sound playing during the "wait." Go to Layout ["tryFlash"] Go to Field [select/perform; tryFlash::flashContainer] If I use the following script steps; when I press the butto…

I can't figure out how to get the rounding feature to work. The caluculation is working fine: Percent of probability * $ scope of project = Weighted Expectation 100 375 37500 need for weighted expectation to display only (000's) result should be 375 How can I get the figure rounded properly? Thanks for your help.

Hi i have a list of records conatining a roomnumber, area & condition (rated 1 to 5). I need to summarise the records by the total areas for each condition. I cant think of a simple way to do this other than 5 calculations eg case(contition=1,area*1,) and five summary fields. Is there a better way? There are other categories in the record that may come into play later on. edit: Im guessing I need to use the getsummary calc but am not get very far with it thanks

I have a repeating calculation field that is used with another repeating calculation field. The result of calculation field 1 is a number which is then used in calculation field 2. There are times when I need to override the number in calculation field 1. This might be a simple question but I have not figured out a way to do this. I would like to do this without using a script if possible. I am using FM6. Thanks for any Help

I have a solution with about 1800 records in it. I have just recently added a validation to 10 of the fields so that they can each have only 8 characters. Is there a way I can go through the existing records and find/remove the extra characters that were there before I created the validation? Does the Trim function do this? Thanks. Susan

I'm trying to devise a script for a button that would "lock" the contents of a text field and prevent the user from editing the contents after the text had been entered. The field starts out blank, text is entered and then clicking the button will make it unalterable.

Ok, this calculation worked fine with FM3, but we recently upgraded to FM7 and now it doesn't work right. This calculation is used to validate the infomation entered into the "Work Order Number" field (a text field). Calculation: If(New Projects::Project Complete = "Project Complete", "", "complete") Background: Three relational databases - Timesheets, New Projects, Work Orders. Timesheets is for employees to enter in the work they've done on projects. Timesheets is linked to New Projects through "Work Order Number" field. New Projects lists information on client projects, such as status, project start and finish dates, and a "Project Complete" field (set…

Hi all. I've been reading posts all day and although I have solved a couple of problems I was having, I can't quite get my head round the final hurdle in a databse I'm making. I'm fairly new to all this database/FMP stuff so your patience is much appreciated! I currently have the fields in my table populated by importing tabbed data out of another piece of software (video editing), one of these fields is a

I have a script that lets the user import a PDF file using "Import Image", I actually import the file not the link. After they have imported this I would like to check the size of the file in the container field because I don't want it to be over 150k. however I can not find any functions or script steps that seem to offer this. Any help would be greatly appreciated. Sean

I am hosting a questionnaire using a form in a web page. I have a number of required fields in the database which when not completed should trigger a required field message in another web page. Problem is, it was working when i started the questionnaire but now it allows all information posts whether the required fields are poulated or empty. I am pulling my hair out. I've tried everything I know but to no avail. Anyone come across this problem?

Is it possible to extract data from 4 individual text fields and place that data into a 4 cell repeating field in repsective order? (i.e. field1 into repeating field cell 1, field2 into the same repeating field cell 2 etc).

I know there have been some discussion about extracting text but i couldnt find anything relating specifically to this instance I have a string with two underscores beyween 3 variable texts eg abc_yayay_mmm the length of the texts vary I'd like to extract "MMM" part. thanks

In lieu to my existing thread (http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB36&Number=145978&fpart=&PHPSESSID=) I'll most likely have to modify my existing links for my image file to its new location. Is there a more automated methods (e.g plug ins) that will does just that? I looked on FileMaker's (http://www.filemaker.com/plugins/File.html) and didn't see any that fits the bill. Any suggestions or words of wisdom?

Is it possible to use a calculation, to return the number of non-identical posts based on one field. To explain what I mean, I have a db with posts relating to clients. Every post have a client number, and in the cases where a client have multiple posts, that client number will be used over and over again. I do need to know how many clients are in the DB, but not how many posts. So let's say this is the db: _________________ Posts Clients 4 North 1 Smith 9 Roberts __________________ Here I want the number 3, to reflect that there are 3 clients. Can I get that? How? Regards arvids I wanted to search for an an…

First post here so hopefully someone can help me! I track machine downtime at my facilty here and Im having trouble getting a calculation to work. I have a field that is for determining what shift a machine went down, either first or second. My boss wants me to make 2 fields that count how many occurances each shift had, (one for first, one for second) on the bottom of my report. Example : 2/1/2005 We had 20 Occurances between the 2 shifts. 12 of them were first, 8 on second. I want filemaker to sort thru the shift field into 2 seperate boxes typing them automatically. Ive tried a few scripts/calculations but it wont add up the shifts, it only counts …

Hi guys appologies if this has already been discussed, I have read through some of the old posts and whilst they are similar(ish) to what I need, I am still lacking the information I require as a lot of the other post refer to Mac and I am using a PC. In the past we have used Troi Grabber to take students photographs and store the pictures in Filemaker next to the students details. This system works fine unless the file is stored on a server, with this in mind our IT department has decided that the photographs are better stored on the server so that they are accessible by more than just Filemaker. The IT Dept are in the process of setting up a photograph system that…

Hi, I have FMP 7.0 on XP and am developing a magazine ad sales tracking system to tally monthly sales actuals vs budget as well as variance and variance%. I am looking for a way to do this WITHOUT using a report in preview mode/sub-summaries, I'd want to display it in browse mode WITHOUT the underlying detail. The layout will look like a spreadsheet and have 4 columns C1:BUDGET, C2:ACTUAL, C3:VARIANCE, C4:VARIANCE%. Each column will have 12 rows, 1 for each month R1:Jan-R12:Dec. I need the value for each column/month budget stored in a different field on the layout. The easy one was BUDGET which I have stored in 12 fields as a global value. The ACTUAL w…

Hi- Can someone please help me figure out how I can limit the number of times a certain field value can be created for each related record? I have no idea if I'm making any sense, but I'll give you an example: I have two related databases. One is a "Users" database, and the other is a "Football Picks" database. The user makes multiple team picks thoughout the season, but the user should only be able to choose each team 4 times in total. How can I limit that? Basically, the calculation or validation needs to be able to stop the entry of a value entered into a field belonging to an individual user to only a limited amount of times. Anyone have any ideas…

Maybe my brain is just throwing static this week, but I'm having trouble with a couple of date fields. I'm hoping this is as easy as breathing for someone here who can help me. Things have been working in v6, but v7 is different enough that I'm having trouble. I'm keeping track of paid membership in an organization. There are different payment options that end up changing MonthsPaid (it's either 12 or 15). I want to add MonthsPaid to DateLastRenew and get the new DateNextRenew. All subscriptions expire on the 15th of the month - so if you join (or renew) in January 2005, any day in January, your DateNextRenew would be either 1/15/06 or 4/15/06. in FM v6, I had …

anyone know of a way to make PatternCount case sensitive? seems like it ought to be possible to combine/nest the Exact and PatternCount functions, but I can't figure out a syntax that works...

Hello, I'm converting to FM7 from FM6. I have a script that is run to determine the oldest of a set of dates. This is later used to sort a found set. The script I wrote a LONG time ago, before I knew what a case() function was for is this: If ["IsEmpty(EX FUD) = 1"] Set Field ["gl_DateCompare", "Elmer FUD"] Else Set Field ["gl_DateCompare", "EX FUD"] End If If ["IsEmpty(EQ FUD)"] Else If ["EQ FUD <= gl_DateCompare"] Set Field ["gl_DateCompare", "EQ FUD"] End If End If If ["IsEmpty(TU FUD)"] Else If ["TU FUD <= gl_DateCompare"] Set Field ["gl_DateCompare", "TU FUD"] End If End If If ["IsEmpty(FS FUD)"] Else If ["FS …

I have fields: Supergroup, Group, Subgroup, otherfields I need to extract one max Subgroup number for each Group, sum these highest Subgroup numbers, and divide this sum by the max number for Group. In other words, I need the average of the highest Subgroup number in each Group across the whole Supergroup. I can get the Subgroup high number in a subsummary for Group, but how do I get the average all these subsummaries maximums for each Supergroup? Thanks for any assistance.

Hello...I got no response to my previous post, but here it goes again. Someone tell me am I unclear, is it a stupid question, is there no anwswer to my query? I need to figure out how to define a field that will sequentially number subrecords that are created through a portal of a main related record. For example, I have a table with a field that sequentially numbers records created in a log of images. In another table I have a field that I want to sequetially number the revisions to that original image. Example: original main records are sequentially number 1, 2, and 3, then I want the subrecords for original main record to also track 1,2,3. I create another field…

Howdy All: I am have a small database that tracks and hold image library information for another program. I insert the data into the database and add a picture to a container field. I have a field in the database that tracks file size and file location from that container field. Something is going amiss though. I can't seem to get the two fields in question to display anything but "0" once i enter the other data. I need to get the file size and file location(path) to display that data. I tried using the Get FileSize function and Get FilePath function but i am doing something wrong. Can anyone shed light on this issue? Thanks, Lakota

I have a field in date format. Date moved into current address. I need to calculate from that date how many years and months they have been there compared with another/current date. ie 3years 4 months

How can I extract the metadata from an image and use that data to populate fields? I have looked at the sample "Photo Catalog" where you click on their "import images" button from there you select what metadata you want to import and what fields in your database they should populate, but I can't find the "keywords" section as an option to import from. The "keywords" section of the metadata is the same as if you were to open a file up in Photoshop CS and go to file/file info. The data displayed in the "keywords" field is what I want to get at. I am new to Filemaker Pro and I am looking into database solutions for our companies' image database. Thanks for any h…