Calculation Engine (Define Fields)

My Tables: Main Policies Relationship MainID --> Rel_MainID Note: There can be many policies per main page Fields: Ins_Status - radio buttons (In House Review, Closed) Policy_Status - Active and Closed Is there a way to have a case fuction work between two different tables. I would like a case fucnction to do this. Here is an example: When In House review is selected on the main page I would like the policy_status to change to Active and when closed is selected i would like policy_status to say Closed. I have tried this: for the field Policy_Status Case( Main::Ins_Status = "In House Review", "Active, Main::Ins_Status = "Closed", …

I am trying to simulate a graphic bar chart to show a weekly changing value. To do this, I have defined a repeating field with a text simulation of a bar chart. The goal is to introduce the weekly value of ,say, first week in the repetition 1, the second in repetition 2, and so on. We can arrange the repeating field either vertically or horizontally, but,

I have a global field in a file on the server. When I enter data into it everything is fine. Another computer system with the same file open has the field blank. Why is the data I enter on my system not in hers? Cin

I have a db that summarises an Admin Area field. I have a report that tells me how many records for each Area i.e. Birmingham 690. What I want to do is create a field that will tell me how many unique records there are for each area. For example, Birmingham 690 might only be split amongst 4 Contacts. So, I want to have a report that shows the Count of Admin Area and also the Unique Count of Contacts for each Area. This will result in: Admin Area-Birmingham. Total Records-690. Total Contacts-24. Can you please help. Thank you very much from a VERY wet UK.

I've attached a file. I am trying to compare two text fields which, as far as I can tell are identical. I even ran Trim() through both fields. But the following number calculation says they are not equal. Case(Company = Contact; 1) I even tried: Case(Company Contact; "Not Equal") and it says 'Not Equal' on every one. I know I'm very tired but, for the life of me, I can't see why it doesn't produce 1 on 98% of them. It is driving me nuts. Any ideas please? LaRetta Strange.zip

I need to have a script or function that returns the date of the "next" week from the current date ... In other words, the date 7 days in the future. I can't seem to cobble together the right combination of calcuations...any date calculation gurus out there ;-) thanks..Sandy

Attached is an example of what I am trying to achieve. I want to change the value in a field but using the setfield. But this doesn't trigger the calc field to activate. Does anyone have any ideas? Audit.zip

I have a calculation field which I want to copy and paste in to a new record. one of the fields is If( (RightWords( g_FirstName , 1 )) = (LeftWords( g_FirstName , 1 )), "", (LeftWords( g_FirstName , 1 ))) But when I run a script which Adds a new record / then exits and then copy and pastes from one of the calculation fields it simply returns my old copied value. Is there a way to copy calculations? I tried to allow for field entry on the field as i thought that might of affected it but still the same? Any thoughts? Thanks

Working with a PC and FMP 6.0v4; I am very new to this. Question is I would like FMP to rank the data I find when doing a find and sorting it. I would like FMP to number the fields 1-200 automatic. This way i can see quickly who the number 155th person is from this list. Any help! very sorry if posted in the wrong forum!

My apologies if this has been covered already. I have a cabinetshop that builds things using metric measurements. Every now and then we have to order glass for the cabinet doors but our glass vendor uses inches and fractions. I would like to have a formula that divides millimeters (25.4mm per inch) into integers & fractions. To be understandable to the glass guys, the fractions need to end in common units you could find on a tape rule. Typical units of measurement would be sixteenths, eighths, quarter & half. We don't need to get any closer than 1/16 inch. Our metric starting point is millimeters. We don't use centimeters. For ex…

Can anyone suggest why my quicktime files play fine on the host machine but won't play appear on the client machine during file sharing (file not found error) ? I have imported the file and not a reference to it and both machine have quicktime installed on them? It is a mystery to me! Cheers Colleen,

Quick question. I am setting up a GetSummary and the breakfield is in another database. The GetSummary is not working when I sort by the breakfield. All my other summaries work. What is happening?

I have a timestamp field that auto-enters when I create a new record. I want to pull the date portion of the timestamp using a calculation, but it seems that timestamps don't evaluate as text, so GetAsDate doesn't work, and I don't see any function that would do this specifically. Anyone know how to get the date from a timestamp? I guess I could always change the field from a timestamp to auto-entering the current date, but really, there should be a way to do this.

I'm looking for some example code invoking FMP via Active X. I'm using Borland C++Builder, and have imported the FM Type LIB, which creates 3 objects - App, Document, and Documents. I've been able (by repeated trial and error) startup FMP via my application, and open an existing document. I have not been able to succesfully run a script within that opened document. Here is the section of relevant code: WideString arg1(FileName), arg2("bullshit"); status=fmp_Documents->Open(&arg1, &arg2); arg2="DummyScript"; fmp_Document->Connect(); fmp_Document->DoFMScript(&arg2); Can someone point me to another site, or som…

Hello We have a Field with a unique control number in it . This number acts as our invoice number Later we will print checks with this control number in it. I would like to make a field called " ControlNumbers" and have it store all the control numbers each time we print a check and flag us with a dialog when that number is already used. I would also like each invoice number in that field to a have a paragraph return so they all show up sequentially. Thanks Stann

Greetings, I have a container field that I'm calling "Work Order". I would like to be able to insert a PDF file of one of my work orders into the container field. The problem is every time I try, the PDF's image becomes very faint and when printed the page has terrible quality. What would be the best way to insert the PDF into my container field and have the quality stay as high as it is in the original work order image? Thanks Much, Business Model

I have a report setup with Sum Parts. I have a field "Market" that sums up a number of records for a number of markets per brand. I can't just add up the numbers for every market because they are not related. So I am trying to get an average for all markets but I am not figuring it out. Any Ideas? Thanx!

FM seems to use a very simple method to calculate payments on a loan. The formula as I understand it is: PMT ( principal ; interestRate ; term ) I need to include a residual value and type (ie. payment at beginning/end of term). In Excel I would use the following formula: PMT(rate,nper,pv,fv,type) Any ideas on how I can use all 5 variables.

Hello I am trying to find out a formula to turn a check amount from Amount to words. EX Amountfield = $3781 TEXTAMOUNT= Three Thousand Seven Hundred Eighty One Dollars & 00/100 Is there a calc to do this automatically Thanks Stann

I used a certesian join to find a single average (called ClassAverage) of another average (StudentAverage) over multiple records. However, if one of the records doesn't have a StudentAverage (if one student hadn't taken a required test) then the ClassAverage won't compute. Is there a way to limit the ClassAverage, either in field definition or in the relationship definition, so that the ClassAverage only uses data that fills certain criteria (IsEmpty or something else that I add later)?

I have attached a csv file of local area codes for the UK. The numbers vary in size from: 01130 - Leeds to 0113288 - Hareworod What I want to do is once a phone number is typed in to the database say for instance 0113 027381 it will return Leeds and like wise if some one was to type in 0113 288 300 - it would return Harewood. Obviously since I allow spaces in the phone field I would need to do a comparison with Trim(PhoneNumber). What I have done is to set up a calc field that contains the split of the entered phone numbers to 4 to 6 places (taking out the 0 and from the left). And then create a relationship with this and the table of codes. Attach…

I've played around with FileMaker 5 and have ordered version 7. I've been using another database system for 20 years and am considering a switch to FileMaker. So: I'm a rank newbie with FileMaker. Anyway, how can I use "edits" with fields? Suppose for a telephone number, I want the field value to change to the format (xxx) xxx-xxxx, regardless of what the end user types. Or, suppose for a social security number, I want the field value to change to the format xxx-xx-xxxx automatically. As far as I can tell, FileMaker lets you specify only whether a field is text or numbers (or one of six other categories) but doesn't let the developer specify the final format. Prov…

I want the text color of field X to be dependent on which of two values is present in field Y. It should be simple but I'm super busy right now and not thinking straight. Any Suggestions? Thanks

I would like to show, at the entrance layout of a file, a greeting text ("Good morning,...afternoon...evening") changing in function of the current time. I have tried to make a calculation with the Status(CurrentTime) function and the logical <, >, but it doesn't work if I put the AND condition.

How can I iterate through a set of fields both to read and write them? For example I have one set of fields (call them sourceFields) and another set of fields (call them destinationFields). I've placed the names of the fields in value lists. I want to create a script or custom function that allows me to copy the contents of all the source fields and put them into the destination fields. I assume I can use Get Field for some of this but I'm stumped as how to write into the field ...I'm just a confused (and this shouldn't be hard!) newbie...thanks...Sandy

At first I assumed it must be a piece'o'cake... I'd like to make a "commonsense key" for a biblio database by concatenating author's LName and the longest word in the title -- a pretty likely way to alert myself to matches between incoming pasted references and my existing records (given variations of citation style that would make a full concat unreliable). I know how to find *how long* the longest word is, but not how to get FM to return *it* (the longest word, or one among the set tied for longest) with a calculation (vastly prefer calcs to scripts, but colud be persuaded to bend here perhaps...). I can begin to concoct some convoluted and grizzly calcs, but …

Hi, I would really like to create a centralized document database/library for a small group of users (about 5 computers). Is there a simple way to make it so I can store a bunch of PDFs somewhere (on one computer) so that all the users can have access to the files and can edit the files without a complicated import/export process? Thanks a lot, Aaron

Hello I have a fee schedule for buyers fees, It is like if the sale is 1 to 99 dollars then use the contents of the field "feeA" and if the sale is 100 to 200 dollars then get the fee from the field "feeB" and so on. But all the prices are now set up as fields so it needs to be if the price is between " priceA1" and "priceA2" then the fee is "FeeA" if the price is between " priceB1" and "priceB2" then the fee is "FeeB" Can someone show me how to write this calc? Thanks STANN

For info, feedback welcome: I'm posting my calc (FM7 only) to clean up ISBN data entry. It adds dashes and verifies checksum. ISBN dash formatting is highly conditional -- and useful because the publisher code is the sequence up to second dash. Assume you have an isbn text field (must be text so as not to lose initial "0"), and you're working with English-language origin presses (though you can modify this for other ISBN standards). Have its auto-enter calc REPLACE existing value (uncheck DO NOT replace), and paste the following: Let(F=Filter(isbn;1234567890)&Case(Right(isbn;1)="x";"X"); If(Length(F)<>10;"10 digits req'd "; Case(Mod(Left(F;1)+2*Middl…

Sorry if this is a silly question. I'm pretty new to FileMaker. I am setting up a database to help academic advisors at a college. It uses multiple files, two of which are "students," and "grades." They are set up so that a portal in "students" displays all of a student's records from "grades," like a transcript, showing the course, the grade received, units earned, and semester the course was taken. Now I am trying to set up another layout that will track whether students have fulfilled their graduation requirements. For example, ENG 1A is a required course. If the student has completed ENG 1A and has a grade reported in the "grades" table, I want the "ENG…

This is a continuation of a previous thread but also a new concept: Thread Link Basically because the Audit field can only hold 64,000 chars (not that I expect that my audit to every get that big but nice to have it setup so that it doesn't need to be thought about) and due to the fact that I saw this rather cool demo from who else but Ray @ http://www.nightwing.com.au/FileMaker: The Rolling Log What I want to achieve is an audit log which captures the last 250 entries and deletes the old one (Rolling). What I was trying was basically having the audit trigger produce 1 line each time and that then gets added to the Name.log (field in rolling log)…

I put a PDF file into a container field. In layout mode I can double click on it and it opens. In browse mode it won't work. I have tried everything to no avail. Any Ideas?

Attached is my attempt at making the audit from http://www.nightwing.com.au/FileMaker audit example work. I have it working fine (and only on one field - Title) EXCEPT I cannot get it to return the From cell value. Has anyone else got knowledge of this set up? Attached is the original. Any help would be great Thanks Both_Audits.zip

I want to know how to enter data in repeating fields using value lists from a related file. In detail - I have two databases - one for invoices with repeated fields for Product Code, Batch No, Rate, Quantity etc. and another one as my Product Master with fields for Product Code, Batch No, Rate etc. and containing multiple records for Product Codes with different Batch Nos. Now in the invoice file I have a value list for Product Code from the product file. When I select a particular product code the other fields (Batch No, Rate) automatically get filled up based on the lookup. I want that the repitition of the Batch No field should show only the batch Nos for the Produc…

I can't find this anywhere. I have a state pop-up list with all the states. How do I have Minnesota be the default so people don't have to always scroll through all the other states? Minnesota would be the most common selection so I want that to show instead of a blank. Any help would be appreciated!!!

Hi, After a day of fruitless hunting I'm finally posting! I have two tables. Each has a tracking_usr field. In table_1 this is unique. In the table_2 there are up to 5 instances of the tracking_usr, i.e. up to 5 records with it, each with a different tracking_options field. I want to create 5 extra fields in table_1, then take the tracking_options data for each tracking_usr in table_2 and place it into the appropriate extra field. I can get a portal to work and the data shows up lovely on screen, but I need to be able to export this data to Excel in separate columns. I thought (having used FM since V1) that I knew what I was doing....

I have a point of sale system with two G4s networked, one as host the other as guest. On creation of a new invoice the invoice number is created through the auto-enter serial number parameter in the field definition. On occasion, maybe once every 50 invoices, and always when both machines are creating invoices at the same time, we will end up with the same number on more than one invoice. Thoughts? Peleka

Hello I am wondering if there is a way to automatically save a file with its name taken automatically from a field called "weeknumber" . I am just wondering if I can automate this? It seems like I can but I am not sure how to script this. Thanks STan

this is a little how to regarding this issue that has been talked about but there is no specific how to. THIS IS NOT COMPLETE. PLEASE ADD YOUR 2 CENTS!!! and i will revise accordingly. please see attached jpeg for refrence. thank you MK for helping me get this far. 1.) layout mode. filedefinedatabase make a new field (ex. resume) and set type to container. 2.) right click on container you created and select (under navigation) Go to Field. check Select/perform box. (someone confirm please) click ok. 3.) create button. (under fields) select Insert File. (someone confirm please) check Go to target field and select the name of t…

How can you make sure the data of a field is in a certain format based on another field? I have 2 fields: "Company" and "Employee ID". If Company=1, then the employee ID must begin with 3 letters. If the Company=2, then the employee ID must have 9-10 digits and end with one letter. Is there a way to specify the "Employee ID" field to make sure that the correct data is put in based on the "Company" field? Any help would be greatly appreciated. Thank you!

Is it possible to have a field which only takes number but allows spaces?

Hello, The "Get ( CurrentDate )" function I used in a calculation field should force to change the result (the date !) of that field when a certain date is achieved. But it doesn't do that. Is this normal or a malfunction ? We don't have the old "Today" function ... so I have to use a script to get to. Is this correct ? Any help would be appreciated! Thanks. (FMP 7 & MacOS X 10.3.4) Gil

In the notepad box. When a customer calls me with one keystroke or shortcut I want to insert "Time", "Date" and "Contact Name" into the notepad box also in a selected colour different from the text. Is this possible and can some one help me how to do this. Thanks in advance. Martin

I've created a rather simple grade database that computes each individual student's average and I would like to compare those averages and to automate some responses using them. For example: I would like an average of a particular field over all records. I have tried using summaries but I have found them to be useless because they only summarize the records that are in the current found set. Is there any way to accomplish what I'm trying to do? I can clarify this further if anyone needs it.

Hi, I am trying to define a calculation field that results in text. When another field, a date field, has nothing in it, the result would be "not vacant" and if the date field was >= today the result would be "vacant". Can anyone assist me on this? Thanks Greg Young

Hi Im looking for a way to calculate the number of records in a portal view. any ideas thanks?

Hello, Someone could tell me how to auto-enter data in all fields of a Repetition Field ? Thank you

I have a field that uses "

Hi, I have a table registering activities' logs with date and duration (stop time - start time). This log table is related to a main table. I would like to create a portal in the main table that makes a sum of the duration by week and by activity: Activity-1 |----------------------------------| |year weeks Sum of duration | |2004 15 20:35 | |2004 16 18:54 | | etc. | |----------------------------------| With Access, this kind of stuff is very easy to create (with a query), but with FileMaker... Should I create a new table that would be filled up by a script or do y…

what I'm looking to do is this. I have field "Finished" which is looking at a vlaue list of yes, no, and maybe. What I want to do is to have two other fields to be filled in with the current date and time when a value is selected in the "Finished" field, no matter what value is picked. Otherwise I want the date and time fields to remain empty. This is in FMP 6! Thanks alot

Hi All, I have a problem on date calculation. Let's say on given date (2004-July-03)always on Saturday, I create 7 fields calculated depend on (2004-July-03)...as followed .. Sunday = 2004-June-27 Monday = 2004-June-28 Tuesday = 2004-June-29 wednesday = 2004-June-30 Thursday = 2004-July-01 Friday = 2004-July-02 Saturday = 2004-July-03 If I do a find from 2004-July-03 to 2004-August-03, it will caculate hours from Thursday to Saturday and If I do a find from 2004-June-01 to 2004-july-03, i will calculated hours from Sunday to Wednesday. I don't know if you understand well my point. I got stuck big time here since the design is something different to …

Is it possible to change the colour of a field based on its contents RED - no GREEN - yes ORANGE - anything else ? Any ideas would be useful Thanks Simon

Hello Forum, I want to create a login from the first name and last name field. I want to pull the first initial from the first name field and first seven characters from the last name field to create an eight character login to be displayed in a login field. Can some tell me how to perform this calculation Thanks in advance Don

My problem is that I have a summary field that works as I intend on the parent file by showing the summary of found records only. However when that same field is displayed on a child file it shows all summary of all the parent records. Can anyone explain how I can have the display on the child file correspond with the display on the parent file i.e. just the found records on the parent file.

Hi I'm working with a developer at ihookdb.com on getting a decent PDA database solution. My problem is thus Procedure --------- 1. PDA is sync'ed with the database and retrieves fields specified 2. PDA is taken out of office and fields are updated 3. PDA is sync'ed back to the main database on return The problem is that there is no way of telling what has been changed exactly (without user remembering) and hence its also not easy to audit. So my idea was to use a PDA_Phonecopy field which is the field that is synchornised with the PDA and back and then a script is performed on applying this to the main phone number field from the main database…

When I use the ValueListItems(Status (CurrentFileName), "valuelist") calculation and the valuelist is using related records (using a valuelist) from the same file, the calculation field does not refresh when I choose another item in the valuelist. Anybody knows how to solve this problem?

Hi...I am very new to Filemaker and Claris Home page, but so far so (reasonably) good. I do not have CDML experience. I have been using HTML and HTML forms for years. I have a question about how checkboxes interact with the FM database. If you do have an answer for me, can you super-dumb it down for a very new user? -) I'm using FM 6.0 and have used Claris Homepage to create the Web interface to the database. I'm then customizing the HTML pages. When I created the interface with Claris, I instructed the one field (Editor/Designer Name) to appear as a checkbox and to allow multiple entries. So I did that and in the HTML file, for the checkboxes, this a…

Can any one advise how to integrate a graphic image (example files use a signature graphic) into a form letter that is printed, please? In other words, I am looking for a way to position graphics within the content of a text field in any location. Thanks

In a layout, I would like to let a user enter a number in a field. I don't want to store this number, but instead I want to store an ID, that relates to the number. I have a database with the tables "Zip" and "Customer". In "Zip" amongst others I have the fields: ZipID, ZipCode, City. In "Customer" amongst others I have ID and ZipID. I've made an relationship between ZipID. My problem is, that in the layout of Customer, I can only enter the ZipID and then show the ZipCode and City. But to the user, the only number that make sense is the ZipCode. I've been trying to solve this problem for at couple of days, so please help me...

I recently began work in an office with about 16 Windows computers, all of which have computer names of past employees. No one can remember who works at the various computers. When our FileMaker databases enter the name into the Creator Name field or the Modifier Name field, we would like it to enter the name of the person who currently uses that machine rather than the name of the person who left the company 5 years ago. I do not know how to change the internal name of the computers, so thought I would try to find another way to get our desired result, aside from having the current employees' names legally changed. Is there a way, with a plug-in or script or related …

i have 3 ifs i want to put into a calculation. If ( Left ( Subject;14 ) = "Sold, ship now"; "amazon") If (Left ( Subject;31 ) = "Alibris Purchase Notification #"; "alibris") If ( Left ( Subject;15 ) = "Abebooks Order:"; "abebooks") how would i put them into a calculation field?

Hi! Working in FM5, mac and PC... we have a database of a few thousand customers that includes an email address, each customer having it's own record. Is there a quick way to make those email addresses into a list, separated by a comma, so could easily copy/paste into an email program? Thanks for any help!

My textblocks in my letters extend off the bottom of the page, that is, the corners do. Why can't I remove the blank space from the bottom of my textblock? Maxwell Morlay

I have a pop-up list that selects inventory ID. I have a second field connected so when you select the pop-up field, you see the related "Name of inventory". How can I make the selected InventoryiD still show the related name of inventory when i am browsing the records? It is quite tedious to have to click on the pop-up list every time I want to see the name of the inventory, not just the stored ID number.

I have a database where users enter their monthly hours on various projects. I then want to transfer this information to a time sheet database where employees monthly hours are summarised by category, e.g. admin hours, project hours etc. It works fine in the original database and lists total project hours per month. But when I try to include that in the time sheet database it only shows the project hours for January, regardless of which month is being summarised. (The other hours are entered directly into the timesheet file so they work ok) I've set up a relationship between the two files using the Employee ID field. I'm using the following calculations: Total pro…

I have a problem with slow search results on a date calculation - today+1 or something like that on a multi-user system. Would it be better to store some of the date calcs as global fields? So it would be calced once and then used quickly in an indexed search? Also, when this script ran on a repeating field it returned results quickly, but now that I have moved the data into a related file, the return is slow, is there something I should be looking at? Thank you, Linda

I hope this makes sense to everyone: I have a lookup fuction that takes a entered Value and returns its related value from another table Ex:Type in 1 and it returns 20 Table used for lookup example: 1 - 20 2 - 44 3 - 67 4 - 70 5 - 80 6 - 90 This works great... What I need is a calc that will take my typed in value lets say this time I type in 4 and it return back 70...but I really need it to add up the values of 1,2,3 & 4. Is this a loop or is there another way... it has to be a calc that will change what it adds up depending on what is typed in....meaning if 200 is typed in it should add up all the values up to 200 including 200..…

This is a real brain cracker for me, but I'm sure there's a way out of here.. I have a numberfield with a number, say '7'. Users can change this number with a scipt to another number (no decimals). I need to make a calculationfield that will give a (whatever) result when the new number is not a multiplication of the original number (7). So when number '19' is entered, I should have a result, but when '21' is entered, the calculationfield needs to be empty. I was thinking in the direction of ranges in a globalfield, and then check the field with a PatternCount calculation, but the developmentscript took too long to make a broad range of numbers, and it's al…

Hi, I'm a newbie so forgive me if this is easy. I am trying to format the time field in a layout. I went to the options in the field property and set it to "hhmm" with a ":" separator. It is showing up "1535:00". I don't . I have the other settings to 'none'. I can't figure out how to make it look lik e"15:35". Got any ideas?

How can I make a field appear or disappear. I've seen a perfectly good example at http://www.jamesng.com/filemaker/downloads/index.shtml called "dynamic layouts" but when I re-enter everything on a new database it doesn't work. That solution was also based on FM3 soooooo anyone got a simple FM7 solution to this? I want to be able to make an arbitrary field (based on a calculation or script) appear or disappear...thanks! Sandy

I have a file , schedule-like, with one record by every working-day, and a portal related to a tasks file. I know the multiple solutions given for my question (calendars of every kind and complexity that I have tried to adapt) but, finally, this is the most easy solution. My question is :

Is there any way to script changing a button . Or fill a background with a solid color through a script. Just wondering if that is possible in any way. Thanks

Can I use a find and replace function to replace a word the SECOND TIME I click a button I would like to make and example here. If I press a button the first time - It inserts "monkey" into a text field along with other entries so the "isEmpty command doesn't work. If I press the same button a second time I would like it to replace "monkey" with nothing. Is this possible to do on a button without the IsEmpty command? Thanks

I was wondering (on any platform)if there is a way to have a piece of text appear when you roll over an object in Browse Mode in Filemaker (similar to the Alt Text on Web Pages) ? It would make it very handy for explanations of buttons etc.

I have a pop up menu value list. When the user selects one of the values i want the database to input something completely different. Main Sub-1 Sub Sub 1 Sub Sub 2 Sub-2 Main-2 So if this was the pop up menu i want too be able to select "sub sub 2" and have the database input the value "Main 1 Sub-1 Sub sub 2" Help please!

How can I reset on a daily basis, a field that is defined as an auto-enter serial number? Each day I want this field to start with 1 and go up to n, and then the next day start over again at 1 and go to n, repeat ad nauseam. This will be used in part of a calculation of another field to build a record ID number.

Hi all, How and what kind of field should I create where a user can enter data into it only once. And after the data is entered in the field, its not modifiable except by the administrator. Thanks for providing any kind of help.

I have a FM7 database with two tables, one for Teacher Info, one for Service Choices that teacher might sign up for. I would like the user of the database (eventually to be a web-based tool to allow teachers to request/track multiple services) to be able to type in their email address, have it compare to existing email address records (in the Teacher Info table), find the matching one and open that r teacher's record. If it doesn't have a match, open a new record with their address aready in the correct field. Any ideas for me? Thanks,

I am currently making a database and I also need to add sometimes some documents. I can add 12 objects/documents to every record. If I add a object to a record it does also add the document to all my other records, which I dont want. I want to add a specific object/document for every record.

How can I get round the fact that the server wont hold global variables. I want to setup some editable Text fields for email templates which ideally should be global. Any ideas on a way round this? I had setup a separate file called Constants which I was hoping to use text field but as such have only 1 reference. I seem to of set it up so that each contach ID is referenced to an ID of the constants file. So how can I reference every contact ID to the one record that is in the constants file? (i.e making them global and useable on the server?)

For our workshop database, I'm trying to write a calculation, using logical functions, that will fill in the lodging cost according to what kind of room was requested ($525 for a single, $375 for a double, etc.) -- but only for records whose status field does not read either "cancelled" or "waiting." Can anyone help me diagnose why the following formula does not work? If ( status ="cancelled" or "waiting"; "0"; Case ( lodging request = "single" ; "525"; lodging request = "double" ; "375"; lodging request = "commuter" ; "150" )) My intention is for the formula to return the value "0" if the status field says "cancelled" or "waiting"; otherwise…

Hello People! I am looking for an altertive approach to "next serial" wihtout having to define the field as "auto-increment". Here is the scenario: RecordID = text c_TotalRecords = Count (RecordID) c_NextRecord_ID = c_TotalRecords + 1 this works fine until the record is deleted....I was wondering if there is a way to grab the 'field value of very last record' + 1 to ensure increments even when a record "in the middle" is delted? I attempted a short script as a part of new record creation: - Show All Records - Go to Record [last] - Set Field [c_NextRecord_ID,RecorID] * set the value of the last - New Record - Set Field [RecordID,c…

i have 2 tables, tableA (aID, Name) and tableB (aID, bID, status). aID in tableB reference to the one in tableA. i have a layout based on tableA. On that layout, i want to diplay the total number of records that each ID has in tableB which has a status of "Approved". If using SQL, it will be: Select Count(bID) FROM tableA a, tableB b WHERE a.aID = b.aID AND b.status = "Approved" AND a.aID = 1 but how do i go about doing this without using SQL?

Hi all, is it possible to get the file name of an imported photo (linked) placed into a container thanks

I need to know how to give my records in multiple tables unique ID numbers. How should I do this?

This is weird: Create a text field, call it FieldA. Create a calculation (number) call it Calc set it = texttonum(FieldA) -- just for kicks, set it to always calculate Now, Enter "A" into the fieldA, calc is blank Enter "F" into fieldA, calc is 0 Enter "T" or "Y" into fieldA, calc is 1 I ran across this while testing for numbers in a string (if the string contains a numeric value, run scriptA, if not, run scriptB, etc etc ...) Anyway, I was getting strange behavior while testing since I had fieldA set to "test". Couldn't find it listed as a bug anywhere, not sure what the deal is. Just thought it strange. Jeff

I would like to create a calculation field that removes all Alphanumeric letters from the end of a specified field. Example... Current Field 12-12-34A 43-65-87C 23-43-433G 12-23-765 12-32-54R The results would look like this... New Calc Field 12-12-34 43-65-87 23-43-433 12-23-765 12-32-54 This seems like it would be easy but for the life of me I can't figure it out! Any help would be much appreciated, thanks!

How can I add a large text field that can be scrolled to view but not editable? Any ideas thanks

Hi there! I have a problem with validations... Since validations are not performed via a script, I cannot create my own custom dialogue box when there's an error. Sure, I can display a custom message, but I cannot change the buttons REVERT and OK, nor the title bar. Is there a way to change those too? It is not that it is so much of a problem, but I like things perfectly done, and that disturbs me... If there is no solution to that problem, maybe there is a way to tell FileMaker to run into a script upon changes in this field? In that case, I would know how to solve the problem... Any idea? Thanks for considering my request.

Hi! How can I calculate a date from the following three fields: current_year, week_number (fiscal) and day_type? Tried and tried but... Fridolin

how can i know count of any value entered in a field

I have this db with CustName and different products sold to them. Most customers are repeat customers and have records for each of their purchases. Weekly and monthly I need to summarize this to show how many individual customers have made a purchase (not how many items purchased just numbers of invoices or POs). I don't want to show the specific CustName just a total of unique customers' invoices (eg. May I had 23 customers that made up 144 orders; April I had 17 customers that made up 201 orders). I've been using FM for many years, and it annoys me that I can't figure this out. Am I missing something obvious here? Thanks for your time.

hi is there a way to format a date field as a "non american" format i.e. 25.12.2004 thanks

Post deleted by Maxell

Hi, I need a field to have more than one item in it. I have a basic record as one long line but at times some lines need to be broken up as separate boxes still in a records line. Much like an HTML Table and table rows and such. Can file maker do this dynamicly with tab delimented files? tablebreak.zip

I would like to import pictures or/and check if they exist by using a calculation. I know the name of the picture and the path but insert picture function does not work as i would like to. For example, i have a file which contains information about "apple" and the picturefile is "apple.jpg" which resides in "apples" folder, then we have "lemon" etc. Is there a way to write a script which imports apple.jpg from apples folder and lemon.jpg from lemons folder etc? I know, i can write an applescript for checking if picture file exists and write the result into FMP field but don't want to if there is a way using only FileMaker. Thanks

I have a database with a registers for a tasks (surgical procedures to be performed in a a given date). This registers have a field with the expected duration of the intervention (say 'dur'). When planning the activity of that day, we assign a order number (say 'ord') to every register of that day, and reorder it to obtain the surgical schedule. I have another field (a global one, say 'interglob') to introduce the time expected to be lost between procedures. There is another two fields in every register : the beginning time (say 'beg', empty) of each procedure and their end (calculated = 'beg' + 'dur'). I would like to have a script to populate the field 'beg' in …

I have added a calculation field to my layout. It works fine on all new records, but I need it to update all previous records. Pray tell how is this done? Hopefully this is the right forum for this.

I dove head first into 7, creating big solutions from the ground up. However, I haven't yet decided what the difference is between a true Calc field and any other old Text or Number field set to a Calculated value, especially when it's set to replace the exisitng value. I'm inclined not to use any Calc fields unless it's for interfac purposes to keep users from trying to modify them. -Hell, I can even have a previously "unstored" calc field as a "stored" field when I create it in anything other than a Calc field. If there isn't really any difference, is this just an evil plot by FMP to confuses us computer geeks? So what gives? What's the real difference…

Hi there! I've got a question which I figure will have a simple answer. I have a X field in which a user may enter a numeric value. I also have a Y field in which there already is a numeric value. What I need to do, is to limit the value of the X field to the Y one. I know that I could surely do this by creating a value list of some sort, but what I really need is when the user types in, for example, 28 in the X field and that the Y field contains 24, the X field will then be 24. On the other hand, if the user types in 13 in the X field and that the Y field still contains 24, then the X field will indicates 13. Thanks in advance and let me say that this is …