Calculation Engine (Define Fields)

I'm trying to create fields that auto-enter using a calculation, so I can allow user to override the calculated results (in this case to change a shipping cost ) When I enter a calculation that worked fine when used in a calculated field, nothing happens - nothing is entered in the field. I can't seem to find anything in my reference books or the FMP manual. What am I doing wrong? Thanks. Alan Rock-Blake

Hi all, Lets assume today is Monday June 10 I have "Monday" "Tuesday" etc.. in a radio set. If I clicked "Tuesday" in my magnificent radio set could i get "tuesday June 11" in another field Thanxs for any help

I have someone who has referenced a lot of photos. They now want the database to move to a laptop. Is there any way to embed these referenced photos. (I know there are a couple of recent similar threads but i think this is different) Thanks

I use FM Pro databases to store and display photographs of plants. It is apparent that the image color displayed in FM is more washed out than the original image stored as a Photoshop JPEG file. The images display with no color degradation in TextEdit, Mail, Preview and iPhoto. Does Filemaker have a hidden setting that overrides the embedded colr profile of the image (sRGB IEC61966-2.1)? Attached is a screen grab of the same file being displayed simultaneously by Filemaker (left) and Photoshop (right). Can I do anything about it?

For example, we have a report listing student exam information. Is there a way, let's say, to make the grade appear in red color when it is below 60 ?? Your expertise in appreciated. Jie

Well my logic breaks on this one and I know it can be better also. LineItems holds Quantity (number) of 'eaches' sold. Products holds QtyPerCase (number) of how many are in a case. Joined on ProductID. Packing Slip requirements: Currently we just display eaches (only the Quantity field). Owner wants it changed to display total 'cases' and 'eaches'. What I have (yep, ugly) ... Let( [ cs = Div(Qty; Products::QtyPerCase) ; ea = Qty / Products::QtyPerCase - cs ] ; Case( ea > 0 ; cs & " Cases, " & ea & " Eaches"; cs = 1; cs & " Case"; not cs; ea & " Eaches"; cs & " Cases") ) If Quantity is 1 and QtyPerCase …

Hi all Need some more help here as this has me stumped. OK in dev6 all I had to do is have a relationship between the files. Take the the field I wanted to have Synchronized with the field in the other file, and make it a calculation field where it basically read field1=2ndfile::field1. Now in seven all these links are dead and I cannot figure out how to restart them. So if you could help me yet again I would be much appreciative. Tony D

hi all, i'll make this quick and simple. I would like to create a field (named status) that would display either the following: "Unpaid" "Paid" I would like to make this into a calculation field, so that if a specific field is not filled out, field status will return either "paid" or "unpaid" thanxs

Hello, I'm having trouble modifying a database. For some reason when I go to Define fields, I can't delete any fields or change their type. I checked and none of the fields I want to delete are used anywhere and they are not related to any other scripts or anything like that. Any ideas?

Is it possible to have a field auto-shrink (reduce to fit) text to fit the allocated text box? The container field does this with images, but I haven't seen a way to do this with text fields.

Hello I have a calc field called. (colors) and there is a list of codes. 1=red , 2 =blue , 3+ yellow etc. what happens when I want to use 2 or more colors. what would then be the calculation if the answer which triggers the calc were as follows' 1, 3 and the colors then would be red and yellow or 1 would just be "red" and 1&2 would just be red and blue I am not sure how to write this and furthermore I would like the colors bold and the actual color I am naming. Is that possible. Thanks DAVE

I have a few phrases that have to be in Bold only when they are being uses in a a certain sentence. In other worlds. If the "mary had a little lamb" comes up it should be bold. but if the phrase comes up "the dish ran away with the spoon" that should be plain text. Is there a way to make the style change to bold when having a certain phrase or answer and having it return to plain text style when that answer is not being used?

I have a database with 100 photo references, I'm getting a "This file cannot be found" error message on about 1/4 of the images in the container field. When I right click the container field in Filemaker, select 'insert picture', the image is not showing up as an option to select (I can't see it). When I manually open the folder where the image resides, it is there. I've tried converting to tif, pct, jpg, cmyk/rgb, etc. the image still does not show up when I right click in Filemaker. How can I 'reconnect these images' or at least make them show up in the folder?

If I memorize a path file from a windows client I have a path: filewin.... If I memorize a path file from a mac client I have a path: filemac.... So from Mac I cannot reopen the filewin... and from win I cannot reopen a filemac... Somebody has resolved the problem without plugins? Is it possible to create an absolute path or a double path for both the platforms? Thanks in advance.

Hopefully this is the last major problem on this project. I am building a database of books that I want to examine (basically a want list) and would like to sort the title on the first relevant word in the title. An example: The Great Raid on Cabanatuan I would like to sort on "Great" rather than "The." I figure the easiest way to do this would be to have the "The" moved from the front of the entry to the back after a comma. The end result looking like this: Great Raid on Cabanatuan, The This would be my ideal solution, as I can use that field in other places in the layout. I have fought with this off and on for quite a while now, and…

Hello I have a field with is called priority code. "PC" I have another calculation field which is called "TEXTCODE" the numbers are sequential from 1 to 7 and then they are ranges like 13-15 I have statements to be calculated to the field "TEXTCODE" and I need help writing them because they are lot. The table is this 1= "RED" 2= "GREEN" but 7-10 = "BLUE" So if the user enters in 8 it would be " Blue " in the text field I have to write this formula and i need help Thanks Dave

OK, I'm starting to redisgn our company database. But thur my research I'm finding one road block and I hope the forum could lead me to an answer. Here is the problem I have 3 fileds for this problem. Jobs_current_number Jobs_ previous_number Jobs_previous_list We have certain jobs that need to see all the previous jobs that relate to it. Example. job 100 has no previous number Job 200 has a previous number of 100 job 300 has a previous number of 200. job 400 has a prevoius number of 300 Now with Job 400 I would like the filed "Jobs_previous_list" to show me all the jobs that have a link to 400. So it should show 300, 200 and 100. Of cour…

I would like to be able to attach a related individual Excel file to inddividual records in my database. Is there a way to do this?

This is probably very simple , but I can't seem to find a way of creating a date field that shows either the creation or modification date of another field.

I am trying to setup a testing enviroment for an image library. I have the thumbnail working but with I click the path below in my other container field I get an error. I did an import. What am I doing wrong? I want to be able to click on the path or image to bring up the bigger picture. Look Below at my example: Thanks!

Problem: I have a file that uses a global field as a container, and also for calculation scripts. If I have the file set to Multi-User [On] and two users have the file open....will the two users using the same Global create a conflict? I'm afraid this will be the case. Solution: I know that I can give the user a variable unique ID depending on Status( CurrentUserCount ). Then I can have the calculation use GetRepetition( Global1, Unique ID ) . . . BUT: Will this in fact create a problem and should I implement my solution?? Thanks in advance!

in a list of numbers (found set), is there a way to count how many are unique?

High school problem (I'm the teacher). A table contains cub no, date and badge no. Students have correctly identified compound key of cub no and badge no (e.g. 99-47 and 05). They know the key has to be unique when implemented in Filemaker pro. The problem - how to make a compound key unique. Have created a calculation field concatenating cub no and badge no but this does not allow validation checks to be applied. Have created a new field with content created by calculation much as above, and with unique validation applied - does not work as duplicate values are simpy ommited in new field. Students MUST implement the solution using cub no and badge no - it is not …

How can you make a field append a text phrase to a number you just entered in the same field. eg... If I were to enter a 6 in the field, what you would see in the field is: 6 hrs. @ $25.00 per hr. I've tried making the field a calculation but it won't let me modify anything in the field. Thanks, Phil

I'm new to the world of FileMaker and have plodded along pretty well so far. i could use some help on one issue though. I have an inventory db setup and would like to calculate the cost, for example, of all furniture items purchased in a certain timeframe. I created a calculation field and have it set to =Sum(CostValue). However, when I run a find with a date parameter it only gives me the individual inventory item cost, and not a sum of all of them. Any help is greatly appreciated.

Hello I've just downloaded a Time Card file from the Filemaker Pro website which is almost perfect for my needs! However, I'd like people to be able to use the full-stop or period when they enter times as it's handily on the number pad. I changed the format for the time fields so that . was the seperator not : but it doesn't work. It thinks I mean 9.3 seconds not 9.30am. Anyone got a solution? Thanks

Hi, I'd like to find a way to import content of a field from every records but I don't want to see the same exact content more than once. My BD has a lot of bibliographical references here and there (basically everytime an historical information is inserted, there is also a "reference" field). What I want to do, is to have a Bibliography of every reference in one record, but I know that some references are used more than once and I don't want the same reference more than once in the bibliography. If i do a script with a copy and paste, is there a way to tell the script to verify if that reference is already in the bibliography and not to copy/paste it if it is? …

I'm creating a database and would like to import pdf forms and store them in the db. I'm looking for an example of using container fields. I may have multiple forms for a given record. I need a way to move between the repetitions - right now I only see one repetition. I also need a good way to open the pdf file. I know I can export the file then view, but would like to automate the opening. thanks

Please excuse my English I am very new! I have much experience with mySQL and Oracle on Windows. In March 2005 my new Powerbook and Filemaker! Beautiful! I build two database: 1 for logging items outside laboratory, 1 for logging items in laboratory. Now I want 1 database only, with two layouts: 1 for logging outside, 1 in laboratory but want to auto-match records. Auto match essential. When logging item outside, I need to be made aware it exist in laboratory. Can Filemaker do for me? Thank you for help! Sorry if wrong forum!

I have developed a client / job tracking system for our graphic design shop using FM 7. When a new job is created, the user selects a client from a popup list which is related to the Clients table. This works very well, but since we have well over 100 clients, the popup list is getting a bit cumbersome to navigate. What I'm wondering is this: Is there any way, instead of having a standard popup menu, to start typing in the Client Name field and have FM return a list of values containing the letters you've typed. The behavior would be very similar to how an email client might retrieve a popup list consisting of "David", "Dan", "Darla" when you type the letters "Da". …

I have many fields on a form layout. My users are complaining that it's difficult to determine the location of the cursor. In other words, the users are saying that it's difficult to tell which field is active. Is there something simple that I can do to easily tell which field the cursor in on? highlighting , color or something like that?

Hye I'm creating a form letter to be used by my company.It'll be use over and over again as a template. The prob is I don't know how to use the lookup fields in order to import the contacts into the letter. I have two databases. One is for the letter itself, Form.fp5 and the other is for contact, contact2.fp5. -How do i import from contact2.fp5 into Form.fp5? I have this fields for Form.fp5: To: Address: City: State: Attention: CC to: Re: Content: I have this fields for contact2.fp5: CustName: (link to To) CustAddress: (link to Address) City: (should be link to City) State: (should be link to State) ContactP…

Does anyone know how to set the color of a field based on its' value? Basically, I have a schedule. I have due dates. As the due date approaches, I would like to have the color of the due date filed change. Green if I have a week, yellow 3 days, red 1 day as an example.

I've got a summary field on my timesheet file to indicate total number of hours in the current lookup. I'd like to show the user how many hours they have entered for the day (based on the date field of the record, rather than "today's date"). Obviously, I could create scripts and add buttons to perform a find, but is it possible to do this with a calculation? In other words, can I write a formula that will say "summarize all records where date field matches the date field of this record"? ~Courtney

Just thought I would share a discovery which took a while for me to sort out. (About time I repaid the favour to you all) If you want to VALIDATE a field by an exclusion i.e. "must not contain a comma" here is how it's done. "In the calculation Validation section - Use this function" If (Filter (fieldname; ",") ≠ ""; 0; 1) Happys days Bye for now. Mike Roberts www.getonit.co.uk

Say I have 20 records, each with the name of the record and a field with the name of some fruit in it. Of the 20 records only 5 have the word Apple in the field. How do I get the names of those 5 records into a calculation field?

Instead of individually importing images to a container field, I would like to have FM auto enter the path/filename to the container field. All my images are named using the key field value. So what I think I'm asking is for Fm to look at the key value of the given record add "/photos/" before that value and .psd after that value and then have FM use this as the file reference to the image.

Hi, I am trying to create a text string using fields from a

I thought this would be a simple thing to do, but it's not working as expected, so I'm looking for a little feedback. I've got four "levels" of staff for billing purposes, stored in a staff table with other HR type information. Each client has a designated rate for each of those levels, which is stored in a client table. My "timesheet" table looks up the billing level for each record based on the employee code. I'd like it to lookup a billing rate for each record from the client table based on the billing level. (I have a relationship from the timesheet table to the client table, based on a unique identifier for each client/project.) I have tried a calculation f…

How do I go about it??? I have the following three fields " Week number, Clock number and Trip number" when a record is created and week number and clock number are the same, In trip number field enter the week number and a increaseing letter A,B and c for each time this is done. fp7.zip

Can anyone give me an idea of how I can use a calculation field in FileMaker to produce an encrypted password field i.e The user has to create a password in a normal text field. The user then has to give a 3 digit number. Using these two bits of information you calculate an encrypted password that you store in a normal text field. i.e. user password x 3 digit number = Password stored in FM When the user logs back in they have to type in their password and 3 digit number to decrypt the password and give them access to the system. Not ideal but it might get us out a hole we're in at the moment. Thanks in advance for any help Andy

We would like to automate the process of assigning codes to book pages. Presently the codes are entered by hand (gasp). Our vendor uses these codes to produce a CD that contains PDFs of the book pages in a folder structure that replicates the outline structure of the book; i.e., on the CD, chapter-level elements like chapter tests would be in top-level folders; section elements like section quizzes would be in sub-folders. I have basic Filemaker skills and will probably need to hire a consultant. Can this even be accomplished using FileMaker? If not, what type of programming skills should I look for a in a consultant? Thank you! Example: Chapters and sections …

We have a database which Management wants to track by Time how long work is in each Department. Found sample for calculating the Number of Workdays but nothing in Time. Example fields: Files Here TimeStamp Done PF TimeStamp Time in PF Calculation in Time excluding Weekends Any suggestions ?

Hi! Here's my problem: I need to subtract a person's birthdate from another date in order to determie how old that person is in Years, Months and Days. Example Today:--------------- 2005-06-15 (YYYY-MM-DD) Child's Birthday:-----2003-11-14 (YYYY-MM-DD) Answer should be:----- 1-07-01 (1 year, 7 months and 1 day old.) HOWEVER, I keep getting this answer from the existing code: 19 Months 9 Days (translates into 1 year, 7 months, 9 days old) Wrong Answer... Here's another example of the weird dates it is outputing: Example Today:--------------- 2005-06-15 (YYYY-MM-DD) Child's Birthday:-----2003-11-07 (YYYY-MM-DD) Answer should be:----…

Hi everyone, Is it possible to display an Autocad drawing in a container field (or any other field for that matter) I have in the past converted them to jpegs to display them but I would like to insert them as a reference so when they are edited the changes show. Is this possible?

I have a table with a related table containing the following fields: the link field with the main table, the title and a miscellaneous field. Through a portal I add more and more records to the related table. However, I do not want the same title to be allowed to be entered more than once in each portal. It seems simple, but maybe i am too simple! I have tried creating a field that combines the link field id and the title and then validate it by uniqueness. It doesn't work. Any help greatly appreciated.

I tried to use the status(currentrecordnumber) as a calculated field and it doesn't seem to work the way I thought it's supposed to. I thought it gives the current record number in your found and sorted records so that whichever way you sort ti the first in the group is 1, the next 2, etc. It seems to only give the originally created order. Any help? Mike

I built a calculation that results in text much like this "XXXX pieces inserted". Where XXXX is a variable number, the problem is the thousands separator does not show. I've placed the entire field in a merge field. Any ideas? Thanks.

I have been given 200 free hotel rooms every year for ten years by vendor ZZ and 100 per year for ten years by vendor YY. I want to see how many remaining rooms i have by vendor by year. I have: Database: Vendor/free offer information Table A: hotel rooms used or reserved (includes date) Table B: hotel rooms remaining (one record for each of 10 years) I have a calculated field in table B that subtracts used and reserved from total available and gives me total left, but if I have reserved rooms in the next year, it is included in the record. What I think i need to do is find all records in Table A whose year matches the year in the record in Table B and then …

Greetings. I am trying to do what I believe is a simple task, which I have not been able to accomplish to date. I have a database the contains several fields with drop down lists. Each quarter I need to be able to deternmine the number of records in that date range that contain each of the list options (e.g. "outpatient", "inpatient", etc.). A quarters worth of data generally conatins about 3000 records. I want to be able to determine the frequency with each each of the possible choices in each of the fields with drop down lists occurs. Does anyone have any suggestion (PLEASE!)? Thank you in advance!

if i have a global field and multiple users logged in over the network can i make them all have different values in the same field. if globals wont do it can someone point me in the right direction with some other ideas? for example if i have a global called username and part of my startup script is to set the username = get(accountname) thanks, Anthony

I fear I may already know the answer to this question but here goes anyway. Is there any way to format a field in a custom dialog box as a pop up list?

Hi, I came a cross a situation where by the particular field. Let say FIELD A. FIELD A = NUMBER User A = Access from range 0 to 10000 User B = Access from range 0 to 20000 User C = Unlimited. How do I set for each users can see their own range that we preset for them ? Thanks.

I have a field that is formatted with a list of names, each name appearing on its own line. The number of names varies. Is there a way to seperate each name into a repeating field line? Example of one field (field A): F013 Satzinger, John W. F013 Jackson, Robert B. F013 Burd, Stephen D. Would like seperated into repeating field (field :: FieldB[1] F013 Satzinger, John W. FiledB[2] F013 Jackson, Robert B. FieldB[3] F013 Burd, Stephen D. Can anyone help? Thanks!

I just picked up FM7 Dev this weekend and have hit a wall of ignorance already. Im working on a simple fleet maint. database. I have all the fields and tables setup. Its very basic. There's a table for vehicles that gives a vehicle ID, along with make model and purchase date. The second table is for workorders for repairs made to vehicles listed in the vehicles table. The association is made by vehicle id to the workorder. I would like to have a seperate layout where i can enter the vehicle ID and it will return the sum $ ammount of all the workorders that have been entered for that vehicle id. Essentially i need a field that will execute the followin…

Has anyone come up with a calculation that will turn an amount (like 40.90) into a text line that can be printed on a check (such as "forty dollars and 90/100 cents")?

I have 2 portals with 3 container fields (for pictures) per page. And I have 10 pages in my layout. I sometimes (well most times) dont have all the container fields being used , as I dont always need 60 pictures. My question is this: how do I Not print all 10 pages (other than every time go to print setup and choose print onlt 2 pages for example?) Is there a way to automatically only print pages that contain pictures?

Hello all, I have this tiny problem, and been looking for couple days but can't seem to find the solution for solving the decimal calculation. So if there is a post on this issue, I apologize for re-posting and please post a link for me if possible ... I hope I could describe this as best as possible I am implementing a payroll check writter on my database but i faced a problem with the decimals. I don't know how to put it in words so please see this example: Shown on the Record: Gross Pay: 800.00 Fit: 73.62 Fica: 61.20 Sit: 14.37 ----------------- Net: 650.81 The real result (not shown on the record Gros…

Hi folks, I'm attempting to adapt this component of the free Filemaker Creative Pro Starter Kit to my needs. Though I am struggling with many things as a total novice, I have a specific question tonight. This database has a table called "zUtility" which contains two fields: gSolutionName and gBuildVersion. The gSolutionName field is used on all the forms to show the application name "ClientTracker." What mystifies me is that I cannot find anywhere in the program where the value of gSolutionName is set to be "ClientTracker." Where is the field getting this data? I feel like I'm missing some concept here. Thanks, Evan

In FM 6. I import a folder of images into a container field. I just import the reference. If I log on to the file using sharing from another computer, I do not see the image unless the reference has the host computer in the path such as //host/d/image.jpg. But when I import the folder from the host computer the referance path is only //d/image.jpg. If I import the images using the remote computer, it does add the host computer in the reference path and then the remote computer can see the image, but that's a pain. Is there a way to edit the reference path once it has been imported, or better yet, write a formula for the reference so I can add //host/. Can it be done …

hi everyone, i have a Case calculation to provide a shortcut to writing out cities. Case ( city_1 = "TO" ; "Thousand Oaks"; city_1 = "MO" ; "Moorpark"; city_1 = "NP" ; "Newbury Park") i have read about defaultResult. but am having trouble putting it into the calculation. all the examples i have followed come back with errors. i want the user to be able to type a city withOUT a shortcut and have the defaultResult show up. thanks so much in advance...

Hello, I have defined 2 repeating fields as number. Miles_begin and Miles_end. Now, I copy (by hand) Miles_end from field(1) into Miles_begin Field(2) How Can I do this automatically in Filemaker? Thanks in advance Johan

We use the computer for task/time tracking but the crew still punches in and out for their pay with a manual timeclock and cardboard time sheets. The specific start/stop times are keyed into an excel spreadsheet for calculating total hours for the week. I would like to convert this process from excel to filemaker. I would like to know if there is a way to enter this data with just using the ten key part of the keyboard. The movie in my head makes it look like this: 0345P = 3:45 PM 1057A = 10:57 AM What I am trying to avoid is having to hold down the shift key (while searching for the colon key) in order to separate the first two numerals from …

I am trying to paste a calculated result into a a date field The calculation is the following 1/next month/current year..endday/next month/current year in other words I need to find all records from the following month I hope that makes sense. thanks

Hello again, my guiders of FM. Thanks in advance, you guys always come through. And I can't tell you how much I appreciate it. This week's issue: I have several fields with 'amount due.' (this is not an invoicing program). But still, i have several fields with amount due. and a Total Due field at the bottom. this all adds up perfectly. however, next to the 'amount due' field. i have a "fee waived" checkbox field. i would like the check mark of that field to remove the corresponding 'amount due', out of the equation. so that the 'Total Due' reflects the 'fee waived' checkmark. I know there are a lot of 'if's' involved. can somebody maybe …

Remind me to wash all of your cars or something...for all the help you guys have given me. I have a field -- Visit Date I have a field -- Last Visit Date I would like Last Visit Date to automatically contain the field from 'Visit Date' in the last related record. more specifically, a patient has a visit. and we want to know when their previous visit was in a field. i would love to have this as just a calculation field rather than a script... is it possible? Thanks so much in advance.

I have a solution that stores 128x128px images that are pasted via applescripts into container fields. I'm experiencing performance issues after converting from FM6 to FM7 (2 sec/record to delete on fast hardware, etc), that do not seem to occur when thumbnails (same pixel count and bit depth as my pasted images) are imported from a folder of .jpgs. I need to get down to what's different in the way these are stored, got a customer site that's going to take several days of processing to upgrade to FM7 unless I can figure a way to optimize my images. Any insights are appreciated. Paul D. Sprague [email protected]

I want to merge 12 fields into. I don't want to use Merge Field, because from what I am aware, this isn't a cross record field and will only work on the layout it is in. I want to develop a number where each field creates the UPC code to look like 0-12345-67890-6. Each digit is originally in it's own field for calulation purpose and now I want to merge it and make it automatically appear as the pattern above. How would I do this?

We have a timestamp field for each record created, however the format shows mm/dd/yy 00:00:00 so searching is impossible (can't search by just date) does anyone have a solution where you can just search by 'date' even though we are using a timestamp or is there a way to just have the timestamp show a 'date' in FM7? (we were able to do that in FM5). THANKS!!!

I have a FileMaker Pro 7 database with a "Date of Birth" field formated as a date (7/5/1985). How can I calculate their age?? So that I can have a separate field that would show: 19.3? Please help! R.J. Gravel Park and Recreation Employee in need of help!

I'm attempting to make a fairly simple database that allows the client to drop in images throughout the printer-friendly layout for his reports. But if the container field is empty, it does not shrink or slide. This seems to be the same in FM version 5 on up. Mac or Windows. And it's driving me a little batty because other FM databases I've seen have been able to either do this or use some trick to get it done. I've tried making a test layout to avoid any complications, but the problem remains. Text Field Empty Container Field Text Field #2 Sliding up based on all above and shrinking enclosing part. Can't get this to work on 7 or any relatively…

This is a field question, but relates to portals as well.. so bare with me!! The part of the database I am trying to work on has 4 tables. Company Contact Event EventContact I'll try to explain what I'm tryign to obtain. I need to generate a report of all contacts, and if they have either been invited, or have attened an event. I can't produce the report from the Events/Contact table (which would be easy) because it will only display only those contacts which have been invited/attended an event. On the contact record I have a portal which displays the events the contact has been invitd to and their current status (i.e attended, declined, yet t…

Hello all, I am working on the payroll database. I could not find a way to convert the $ amount into texts... can someone help me tnx in advance ryleg04.zip

It is not clear to me about when FM validates a field or invokes a script. (I have posted other questions in the forums along these lines.) My problem is that the user would like things to happen when he tabs from a field. I think that it is not possible to intercept tab keystrokes and that validation does not happen until the user hits ENTER (or RETURN.) So far, I have been unable to find this clearly defined. Can anyone clarify this for me?

Hi. Does anyone know how to sort text within a field? Thanks!

Hi all, Pretty busy and lazy to think of it.. Knowing a starting date and ending date of a Project, I want to determine the starting Quarter Date and Ending Quarter Date, based on the classic Calendar, whatever the day is. So if project starts on feb 15 2005 and ends on November 11th 2007, I want the start date to be Jan 1st and end date to be Dec 31st 2007. If it starts on Jan 1 2004 and ends on Jan 15th 2007, then start date is Jan 1st and end date is March 31 as the quarter was initiated on Jan 15th If it starts on Dec 31 th, by default I want the start date to be Oct 1st even if we're just one day before end. Thanks for the help. I h…

I am trying to create a formula using the and operator and the IF function. I would like the formula to state something like this: IF(RBC Mass>36,and IF(WBC Count>92,and IF(Blastophil= "Yes","Positive for Polycythemia Vera","Not Available"))). Can this be done in Filemaker Pro?

So i have a Invoice with line items, I currently store the sales tax in the invoice file and the transaction reports runs out of the line items file. I have summary fields for total list price, total discount givin, total selling price and want to show total sales tax. Since sales tax isn't in my line items file, I can't make a summary on a related field, I'm looking for suggestions on how i could include it. I'm calculating sales tax on the invoice as a total, not on each line item and if I did place a lookup field in the line items file my tax value would be off. Any suggestions are welcome because i'm not seeing any way to get the sales tax in as a…

Hey everyone... as always, i'm completely thankful for everything you guys have already done for me, and all the other beginners out there. you guys are awesome. so here's my issue... I need to generate an id number based off of several fields. the code would be the first letter of the first name, the first letter of the last name. the date of birth. and male or female. i have fields for all of them. but need to pull only certain letters from each. and put them all into one 'calculation field.' ex. Steve Guttenberg 08-02-70 Male = SG08021970m any direction would be greatly appreciated. thanks again.

Since it is possible to link to a web address (in full form http:// ....) from a field, I wondered if it would be possible to send an email by open a field containing an email address. I tried it in the correct HTML form (mailto:[email protected]) and it did not show any email option in the context menu. So I tried with //[email protected]" target="_blank and it did invoke my mail client but the address was: //[email protected] not [email protected]. Has anyone got this to work?

I have several users using my database. Is there anyway to keep track of how much time each each user uses my database. like a built in clock/timer. Thanxs

I am trying to automatically figure miles per gallon. I have several records (state line crossings) of which some contain fuel purchases for that state. I have created a trailing grand summary part which contains totals of fuel purchased (gallons, etc) which works fine. I have also created a total miles field which is a calculation of the EndingMileage-StartingMileage fields. The AverageMPG field contains a calculation of TotalGallons/TotalMiles which also works fine. Here is the problem. If I enter a fuel purchase in the first record only, it places the correct MPG in the AverageMPG field. If I do not enter a purchase in the first record but enter purchases in oth…

I have a container field to store different kinds of documents (.ppt, .xls., .doc, etc). Is there any way that I can drag a file from my desktop and put it into the container field. Then by double clicking the file icon open the file automatically?

Hi Is it possible to have a calculation that looks at several fields to determine a answer such as: Field 1= Artwork Field 2 = Stereos Field 3 = Premount Field 4 is the calculation. Each has a pull down menu of "Yes" or "No" What I would like is if: Artwork = Yes Stereos = Yes Premount =Yes the answer to be " Artwork-Stereos-Premount " Artwork = Yes Stereos = No Premount = No the answer to be " Artwork Only " Artwork = No Stereos = Yes Premount =No the answer to be " Stereos Only " and so on. Any ideas

Working with the Photo Catalog db solution from FM -- I would like to superimpose a graphic over a image in a container field (so that the image is visible beneath it) -- and then remove it at will. The graphic is a classic symbol of a red circle with a diagonal line through it. At first I tried two different layouts but realized right away that when fliping through records the symbol was always there or not there at all depending on the layout chosen. I am new to FM 7; is there a way to have one layout be a default as one goes through the records except when the graphic is deployed? Or is there another a solution where one can script a graphic to move in and …

Hi to all friends, it's possible to get the calculation of a given calculated field ? Thanks to all

School busing database for busing fee based on address distance from school (one database) Fields: student name school grade whole address (calculated field based on #, street name) distance fee_required "Yes" or "No" calculated field based on distance from school and grade Fee = $225 for each student who lives less than 2 mi from the school and is in grade K-6 fee_Total - HOW DO I WRITE A CALCULATION TO TOTAL THE FEES FOR EACH ADDRESS? One address may have 3 students going to 3 schools; 2 require a fee and 1 does not. How do I get the total for that address? THANKS - very new to FileMaker and using version 6.0 DISTRICTClone.z…

I trying to create a database and I find this forum to be helpful in many ways. I was wondering if someone could help me again. This is what I would like to accomplish. I have an "inventory database" (using Filemaker's template) and using a "purchase order" database (using Filemaker's template) and I would like a way in which when I sell a product when a serial number, my "inventory database" would list it as sold. I'm currently using a "radio button" to mark my products as either new, sold, return. Could someone help me with a script or some sort so that I may accomplish this task. Thanks

I am trying to allow users to save word perfect documents in their filemaker records. I want it to be simple enough so that they can drag the document into the container, and then be able to double click the document to open it in word perfect. The default action is set to edit, which causes this ugly, confusing edit window to pop up in filemaker. Is there a way to change the default action to OPEN the file instead of edit it when users double click on the container field?

Just wanted to know if it is possible to create something like the rating option you see on websites like netflix / blockbuster, where if you click on a row of stars, you can enter the star rating for a movie. Wanted to use this feature for a multiple choice application, where by I can ask reviewers to rate the question or can ask students to rate the questions. I believe the rating on html pages is done using javascript. Can we use javascript in filemaker? Are there any other options to enter the same kind of data in the same visually pleasing manner?

How do show numbers as a dollar amount in a calculation. The calculation contains text and the number so I can't use the Format::Number option. I need: Project 1 - $1,000 I am getting Project 1 - 1000 I know I can get the $ by using "$" & Number, but this doesn't add thousands separators. Any easy solutions?

I need to extract the city portion out of an address text field. The field has data enters as such: 123 Main Street, Yourtown, NJ 07000. I was assuming the "Position" function would possibly be used with either LeftWords or Middle Words, but I cant seem to get it right. Does anyone have a solution that might help. Thanks, Ron

this is probably a dumb question but here it goes. i would like to be able to print the total quantity of items on the bottom of my invoice. i have a field call "qty" that can be 1-999 items. all i want to do is keep a summary of the total qty and display it on my invoice. thanks.

Hi Eveyone, It's my first time posting here, hopefully one of you kind people will be able to help me. I'm trying to set up two related databases. The first has contact details, the second has purchases. I would like to display the number of purchases that a contact has made, defined by type. The products are selected from a value list. In other words, if the choicees are bananas, apples, or pears, then I would like to display in the contacts database, how many of each item each contact has purchases in the past. I would like this field to be a running total. I have tried using a calculation field but I can't work out which formula to use. Can anyone help? …

newbee warning**** i have two files with difrent functions. I want to track my projects, and i have created a project id number, this number i want to use when i add hours for the project worked on, so i can use that to make calculation of price, payment. i manage to add the file nr 2 in the definition database and linking them, but if i define the box to choose project id from, to list the project id nrs from file 2 it wont list them up. it appear just as ablank box without function. hope somebody have a clue and time to tell me a little bit. thx, .t

I am a novice Fm 7 user. I am developing a solution for my wife. She is a hypnotherapist and wants to store her patient notes, billings, and audio hypnosis files she makes for her patients. I have finished the notes and billings. I can't seem to figure out a way to store audio (up to 15 minutes) for later burning to Cd's. I have a program recorder.xhead from xhead software which is a simple audio recording program. It makes clean audiofiles and can export them to iTunes, so I can burn the CD. I figured that I would store the file in Filemaker and if my wife needed to burn a replacement CD she would double click the file. But I can't seem to automate this. I was thinking …

I'm setting up a database to record attendance at board meetings. I've created two tables for this: 1. A table with fields for each person's name and whether they were present or not (attendanceflag), as well as a global field for the date of the meeting that I'm recording attendance for. 2. Another table with one record per meeting with fields for the meeting date and a list of attendees. The list of attendees will change every time. In the second table, would it be better to store the attendees in a single repeating field or in separate fields (A1, A2, and so on)? I've also writing a script that copies the names of attendees from table 1 to table 2. …

I'm working on a database where a single company might have several contacts. Each contact has a serial, generated automatically (ID-10000 +1 etc.), and I need each company to have a single serial. In other words, the company serial can't be generated in the usual simple automated manner known to me, because then I get a new company serial for each of the contacts from a single company. Any help would be appreciated. I'm a graphic artist being misused for this, I'm not the programming/math type, though I can think logically in a pinch , so keep it simple if you can. Also I'm using the German version, so bear with me if my terminology isn't quite correct.

Hi- I have a field that will contain a string of characters such as TK58, Z35, QA765, etc. I need to distinguish where there is a letter next to a number and add a space so that it becomes TK 58, Z 35, QA 765, etc. Note that there isn't always the same number of letters so I dont think a Left( type funtion will work. Is there a way to distinguish where the letters end and numbers begin? Thanks in advance

Hi everyone, Although I refer to Custom Functions, these can be regular calculations so I decided to post here instead. They are: YearMonth. This produces 200505 and is used for sorting and MANY columnar month portal relationships. Year(date) & Right( "0" & Month(date); 2 ) Fiscal. I've been using Fiscal on reports as merge "Fiscal 2004" but it is now confusing to some staff since it's 2005. They see 2004 and think it's from last fiscal. It is also used in some of my joins. gFiscalStart is global number (from host) indicating the start of our Fiscal; in our case 10. It is called num in the CF. Year(datefield) - (Month(datefield) <…