Calculation Engine (Define Fields)

I work for a University, and I have a client who has a FileMaker database with about 750 records. Each record has a picture. While the client was using the database locally, she was storing references to the images, and all was well. Then she decided that she wanted to host the db on FileMaker Server (my department). She wanted to be able to see the images in: 1. FileMaker instant web publishing (on our Unlimited box) 2. Through the FileMaker interface when opening remotely off the Server box. She also needs to occasionally take a copy of the database out into the field on her laptop, far from internet access, to gather new data. She would then update the versio…

I want to create a report that print a list based on the rank order inputted by the user. Okay, simple enough, but I want the report to show blank spaces for the rank even if there is no text entered for that field. example: 1. blank 2. Joe Doe 3. Smith John 4. Blank

OK, please humor me, I own a sign shop and have worked in filemaker for about 4 years. I am not a FM developer! This year I finally got everyone to go along with the idea of using filemaker for all paper in our shop and to my surprise it is going very well! I do have a couple of things I can't seem to get to work(or i don't understand!) I made a database to write letters out of, that can be tagged with an order number so we can find them later. How do you set up a text field for multiple pages? If you set it up for 1 page then they can only type one page. How do I know how many pages they are going to type? Do I just extend the text field for as many pages as I can a…

Everybody has been so helpful I'll try another. I need to a calculation to determine which repetition of a repeating field holds a specified string. For example if a repeating field animals holds the values: squid, llama, wombat, gnut I want the result of "wombat" to be 3 and the result of "dodo" to be 0 or -1 or whatever. Finding the first occurance is good enough. Any ideas? I could 'if" each rep,but i'd rather not do that if I can avoid it, since the repeating field may be long. Thanks in advance.

ok. I have these two GLOBAL DATE FIELDS that i'm using to perform a find for a RANGE of dates. On a layout, i enter the start date in one field and the end date in another. My script goes to the find mode in another layout and pastes these dates in my Date field via Insert Calculated Result - which i set up as (field one & "..." & field two). When i perform the script it gets to the pasting and then tells me that the field has to be in a date format only (it's inserting other numbers that i can't figure where from) - It's not taking my calculated result . My global fields are both set up as dates (and have to be 'cause it affects date format in other layout…

I am attempting to create a file that will let me alter the text of a letter through the use of a text field. All is well but I would like to know if there is a way to insert "merge fields" (as in layout mode) into a text field so as to alter the text content of a letter. I don't want to have to go to layout mode and change the text of the letter. I want to to this via a field of information. Thanks for any help.

I am in need of a way to prioritize active jobs. A user will assign a priority to a list of active jobs like 1-20. When the record assigned priority 1 is complete and removed from the list I would like 2 to become 1 and 3 become 2 so on up the list. If a user get a new job that must be given priority 1 the rest of the jobs need to cascade down a number. Or if he assigns it a 5 the current 5 becomes 6 and on down. Any ideas. Thanks, Wayne

Is it possible to allow a field to slide or not slide on the basis of a calculation (in this case, of character length)? I have a columnar report with fixed column sizes. Most of my data fits in the column nicely, but a few entries are longer, and I would like only these to slide, so that my report would look like this :- xxxx xxx xxxxx xxx xxxxxx xxxx xxx xxxxx xxx xxxxxx xx xxx xxxxxxxx xxx xxxxxx xxxx xxx xxxxx xxx xxxxxx xxxx xxx xxxxx xxx xxxxxx xxxx xx xxxx xxxxxxxxxxxxx Only entries 3 and 6 would slide because they have data which is longer than the "default" field width. Thanks, Mike McHugh

I'm trying to build a database in which some of the fields need to be in Russian. I have both 1251 and K018 fonts installed on my computer, and have added them to the fonts useable to FMPro (I'm running a version of 4). But even after formating the field to use one of the Cyrillic fonts, the field still comes up in Times and not Cyrillic. Any ideas on what I need to do differently? Thanks SteveI

Hi, I want to make a summary of only related fields, how can you do that? example if this is my found set: product 1 - 30 pieces product 1 - 20 pieces product 2 - 10 pieces the result of the summary for product 1 should be: 50 pieces the result of the summary for product 2 should be: 10 pieces if this is my found set: product 1 - 30 pieces product 2 - 10 pieces the result of the summary for product 1 should be: 30 pieces the result of the summary for product 2 should be: 10 pieces Thankyou for helping me out!

Hi there, Is there a way to generate graphs with FMP5? I created a database to record student achievement on a quarterly test, and I was interested in having a report format that showed a graph of results by grade. Is this possible? Thanks, Paul

I cannot seem to insert text into a concatenation field. Whenever I try to use quotation marks to contain the text I want inserted, I get the error message that a field name is expected in place of the quotation. What am I doing wrong?

I have found that if I have a layout, a letter for example, with a percentage figure MERGED within the text, I can highlight the WHOLE text, and format number into a percentage. The problem is that any other numbers merged then become percentages. I have tried inserting a field rather than merging, but as is Filemakers want, it lines up nowhere near the possition I wnt it. Can anyone help??

Is there any way to group and summarize data entered in a repeating field?

Specific Question: In FM4.1, how can I produce html style line breaks within a calculation? I am using FM to produce static html pages. I use a text calculation to html-ify the data I need from each record. I would like line breaks (and indenting) within the html. If I put the paragraph symbol thingy in the text within the calculation: 1) If then, in browse I copy the html calculation field and paste into bbedit, things work properly. (I suspect bbedit converts the line break characters during the paste.) 2) However if I export the file to text, and then open the file in bbedit or a browser, between records I get proper line breaks but where I put the paragraph s…

I have an Orders database that is related to a Price List database by product id. In the orders database, when I enter the product id (repeating field), the wholesale prices (repeating field) and the retail prices (repeating field) should be entered automatically. This only works for the first row. I tried the extend function, but it doesn't work. I also tried using a portal which didn't work. What am I missing? Any suggestions? kristlek

Im sure this is very easy to do but, how do I create a total feild which will total one feild from each of multiple records? I have a database of students and they all have weekly points, for diffretn weeks. I want to total a students points from a set of weeks. I know how to do search to disply the right student records but how do I total all a students point?

Hello, I have to registers: Inventory and Deliveries. Inventory includes the fields Articlenumber and Amount (where Articlenumber must be unique). Deliveries includes the fields Ordernumber, Articlenumber and Amount. I have a relation between Articlenumber in the both fields. In the Amount field in Inventory i have this function: Sum(Deliveries::Amount) Some of the Articlenumbers that I am testing this database with include a dash (-), for example 97-683. Somehow this seems to confuse the calculation in the Amount field, which I find strange... So that the balance is not shown right in the Inventory register (that is it doesn't result in the amount that the deliveries …

Is there a way to lock a field after the data has been enter? Thanks for the help

Does anyone have a neat way of doing this? I have a table (SCORES) of university departments that have been ranked according to their research quality, from 5* through 5,4,3 and 2 to 1. There is a score for every department at every UK university. Each department is categorised into one of 69 disciplines ranging from Physics to French. The last field is the number of staff in the department. In a separate table of the 69 disciplines (DISCIPLINES), I want to calculate the total number of staff in all, eg, French departments rated 4. The function I'd like would look line this: Sum(SCORES::staff; quality = 4) This sums the staff values in records where the quality field …

Does anyone know how to change the field number from the format fn (f1, f2,...,f10, f11,...) to f00n (f001,...f099...)? Help is appreciated. -MJ

I have a calc field that works fine under fm 5 and OS 9. But when using it under fm5.5 and OSX, it doesn't work at all. Anyone have any ideas as to what is wrong? thanks

I have set up two simple FMP files with a single relationship linking them to enable data from fields in one file to be displayed on the coresponding record on the other. This works fine for some fields but erratically in another. In this case the data shows accurately on some records, but on others it is absent until the mouse pointer is clicked on the appropriate field, when it then displays. Once displayed it remains visible after browsing other records and then returning. I have a feeling that it is often the same records which display unprompted but it is not consistent. I have tried reinstalling FMP and I have tried creating an entirely new set of files and importin…

I have two files,the part no,description&price are in parts file and the order file has orders which is relalted to the first file by part no to get the price of the part.Now a person goes thru the parts file copies the part no and goes to the order file and pastes it into the order file to get the price.Now in the order file the partno is set to a particulair size,but when he pastes into the order file the size gets changed.How do I solve this problem. Thanks [ November 27, 2001: Message edited by: Jacob ]

OK, I admit it, I am a complete Filemaker Pro novice (working on version 5); I am setting up a job bag system at work and I want to be able to print out my Filemaker records onto A4. However, just under half the page gets cut off when printing (and it's the same in preview mode); the area where this cuts off corresponds with a sort of dotted rule running across the page, when in Layout mode I'm sure it's staring me in the face, but blowed if I can work it out.

Hi guys/galls, Sorry, but I have three unrelated questions, can you help? 1. How do I do a search for, let's say, a year's worth of sales for a tax report but the year starting in April until the following April? 2. To get how many hours within a start and finish time period, I know you can do a sum (FINISH TIME - START TIME), but when totalling a weeks amount of hours I need it to give me a figure like 40 hours. I am getting the result up to 24 hours giving me 16 hours without telling me it's gone around the clock once. Do I have to do Time to text, left(time,2), text to number, and then sum the number or is there an obviously easy way to do it? 3. Is there a way t…

I have three DBs, Clients, Events and TotalMonth some clients participe one some events and in TotalMonth db I want to have all month of year to sort clients by date of month Could I do it?

I am sure some of you have heard of the trick for sorting portal columns by creating a calc field in the related file where the portal relationship is set to sort on the calc field. The calc field uses Case to test the value of a global field, depending on the value of the global the calc is then evaluated to different fields in the related file. The global is set from a script in the main file. My question is how is this going to work in a Multi-user setting. Given that the calc resides on the machine running FM Server and each logged on user gets their own global. Does anyone have any experience as to how this will work and are there any problems that may be encounted. …

Here's a little idiot proofing workaround I just found and thought I'd share it. Again I'm a novice, so if this is everyday newbie stuff just smile and ignore it. you guys help me a lot so I want to give back. Anyway, I find that when I create layouts for users to create their own set of criteria for finding with certain fields, the user usually does OK until FM warns that there is no match for what they want to find. This is where the idiot part comes in. The dialog appears giving the user two options: Cancel, or Modify find. It happens too often that the user chooses cancel, and (seemingly unbeknownst to them, they have exited Find mode and entered Browse mode) continu…

Take a look at the Troi-File plug-in. It allows easy automation of image imports to container fields. -bd

I have a field which contains some ID's like SE, RT, and so on. These ID define the type of record. I have to obtain a summary at the end which counts how many occurencies of SE I have, how many of RT... Moreover there's another field which identifies the subtype of the ID. If the record is a simple communication it will have a progressive number in this field, if it's a complain it won't have nothing in it. So I have to obtain a table with a column which indicates the count of communications for a sector (a sector is identified by SE, RT...), a column which indicates the count of complaints and a column for the total. I've tried with the count() function, with summar…

Is there a way to round a summary field that is an average? (besides making the field too small to show the decimals?!) Paul

Hi, I'm working on a db to track results of a quarterly reading test given to students. For each student's record I have 4 layouts, one for each test, and a summary screen. On the test layouts, I included a text field in the form of a checkbox, which I have called "At Risk?" and it uses the set of values "YES". I didn't include no, because I figured an unchecked box would be fine to signify 'no'. On my summary layout, I have a calculated field which is supposed to case whether the value of "At Risk?" is "YES" or not and display the word "Yes" or else display "No". Problem is: if I check a kid off, 'yes' the calc. works fine. if I check t…

I'm Trying to get a field called "Percentage Improvement" to calculate percentage based on a total annual improvement / an initial test result and then *100 My problem comes because the initial test result is entered via a pull down menu the scoring scale starts out with "Emerging" and then continues 1,2,3...etc. If the initial test result is "emerging" then I need it to calculate the percentage differently than if the result is a number. I tried to use a case clause to describe the two possibilites, but it keeps telling me that there're too many separators. Can you help me out? Here's the calculation (I know the field names are long and ugly, sorry) Case (Benchm…

I KNOW THIS TOPIC HAS BEEN POSTED BEFORE ABOUT A YEAR AGO, BUT I WANTED TO SEE IF ANYONE HAS DEVELOPED A WAY TO SET THE ZOOM LEVEL TO NON-STANDARD ZOOM VALUES. MY CONCERN HAS NOTHING TO DO WITH SIZING FOR MONITORS OR LAYOUTS FOR DIFFERENT SCREEN SIZES OR RESOLUTIONS. I NEED TO BE ABLE TO SET VALUES FROM (FOR EXAMPLE) 50%, 51%, 52%, 53%, 54%, ETC... TO INCREMENTAL VALUES DEFINED OR REQUIRED BY FACTORS THAT HAVE NOTHING TO DO WITH THE MONITOR OR COMPUTER BEING USED. IF FILEMAKER DOES NOT ALLOW THIS, HAS ANYONE BEEN SUCCESSFUL IN USING RESEDIT (OR SIMILAR PROGRAM) TO CHANGE THE DEFAULT SETTINGS IN FILEMAKER PRO? I AM UNABLE TO MAKE ANY PROGRESS.

hi, in my multiuser database i have a key field and in The validation I checked de "unique" check box. How ever, I still can be able of entering duplicated records from diferent computers at the same time (that is not a good thing...) so, i do not understand the meaning of that "unique" check box. can any body please explain me how can i be sure that no body can enter a duplicated id in my key field? thank u very much [ November 16, 2001: Message edited by: JamedData ]

Is there a down side to always "evaluate when reference fields are empty"? Is the performance significantly affected?

In a table view, Is there a way to freeze the left column and to scroll the remaining columns. Similar to MSExcel Freeze Panes, so the titles are visible as the columns to scrolled to the right. I noticed that the column headings stay fixed as the rows are scrolled down.

I have an external data source that has a date format of YYMMDD as text. (do you know what this format is called?) Anyway, I'm converting this to a regular date format of DDMMYY (ie non-American). I've managed to do it in a complex formula. Is there a simple method?

I have a very long list of data. Client Date Amount. I would like to create a view that displays the information by month horizontally. eg Jan Feb Mar Apr May Jun etc Client $100 $110 $98 $120 $80 $130 How do I show this information as this schedule? Many thanks

When I create a export file from a calculated calculated field, which is really a number of fields concatenated, the price field amongst them shows up without the two decimal points, which the source field is formatted to deliver - where there is 50p, it shows up as .5 Thanks in anticipation Sean O'D

Hi, if someone can help me with this one, I'll stop teasing the office cat. I have the Address fields: Addr1,Addr2,city,State,Code And I have the Postal Addr fields: PostAddr1, PostAddr2,PostCity, PostState, PostCode If the client doesn't have a postal address, I would like to be able to enter the address and have the postal address auto-enter the same, but still have the option to enter a postal addess if the client has both an address and a postal address.

Bear with me peoples. About a year and a half ago, I started messing around with our software and hardware filemaker database. I tweaked the look and made changes to the value lists contained within. Simple stuff. Well, my new project is to rebuild it from scratch and I want to set things up properly using calculations, relationships, scripts, etc. Does anyone out currently have a similarly built database? I manage about 20 Macs, maintaining, upgrading, updating, etc. I have all the info within an Excel workbook and I want to transfer that info, logically into a FM database. I'm using 5.5 right now. Here is the first question: I've set up a few fields labeled for RAM …

I heard a rumor that you could lock indiviual records from being edited through scripting. Is this true? Thanks Alan

How can I automatically import an Image in a filecard using its name and path described in a field of this filecard. So, I want to display an image dynamically in a filecard. Can you help me please?

Does anybody know if it in any way is possible to define a wild card date, example: **.Nov.1980 for a record from November 1980 with unknown day?

Hi, Is there any way to know, after someone inserted a picture in a container, if it was either inserted as a reference to the file, or just dragged into the container? Thank you in advance

I have created a database that will use some of the same info from an existing file. Header type info. To start the new record and enable the lookups to take place (this new file will not be directly used it is just a storage file) I am currently copying and pasting 2 fields from the old file to the new file to beging the lookup process. This seems hokey to me and I am looking for suggestions.

Two quick questions: 1. I am searching for bar coding functionality that can be used by FM Pro. Is there a place I can search for that, either a plug in or some other way? 2. I would like to be able to create an Adobe PDF report from an FM Pro layout, but I can't figure out how to do it. Any help would be appreciated. Thanks, Bill

I'm trying to build a db system for signing up participants and scoring in an Observed Trials club (an obstacle-oriented form of off road motorcycle competition). The present problem (I'll have others) is in preventing a rider from accidently being entered twice during the rather hectic sign-up process. I want to have an AutoEntry field which automatically concatenates the Event ID with the Rider ID, and for which validation is Unique. Then, if the user accidently tries to sign up a rider twice (in two classes, for example), a message will alert him that that rider is already entered. However, I can't make this work. To try to figure out why, I tried a simple test: Ne…

Hi all, I have 16 fields, and have to write a case statement that says: Case(any one of these fields = some result and any other one of these fields = some result, 1, 0) There are 256 different possibilities right there, but what if you have 32 such fields, or more?? This could get maddening. Is there some function in File Maker to aliviate the pain of this? What is done in such case? Thank you

Can HTML tags be embedded in the definition of a calc field, so that (for instance) part of the returned text is underlined? Or is there a better way? Dan

Hello, I have a list of clients that I would like to sort by the most recent modification date, so that the most active client records are at the top. I can create a field and auto-enter the modification date, but what types of action cause "modification". Once that field is populated, sorting by it should be relatively easy, yes? Thanks in advance!!

Greetings My calculations do not work. I want to add price from each record in an invoice In Specify Calculations I do the Field1+Field2 etc & draw a blank. The Fields I want to add are look-up Number fields derived from a related file. I seem to be able to get this work on a dummy run, but not on the real thing. Thanks in anticipation Sean O'D London

I'm trying to substitute out some extra characters from a last name. Is there a way to use the Substitute() function to replace more than one character at a time? I'm trying to take out ', -, and spaces from last names, but when I do three substitutes, it gives me the name three times. Help! -Doug Dinneen

I have two related tables. The Master table contains contact information, the Donation table contains $ donation information, including the date the donation was received. Can I/how do I create a calculated field in the Master table which calculates the year to date amount of the donations?

hi folks, i am trying to set up a calculation field (fm4) that will change an amount due based upon the record creation date. the calculat[ion does not seem to care for the date in dd/mm/yyyy format. here's my calculation: If(required2002 Convocation Honoree = "Senior Associate 2001-2002" or required2002 Convocation Honoree = "Leadership Associate 2001-2002" or Date ? "11/30/2001", "195", "225") no matter what i do, the amount is still "225" even though the creation date of any record i enter is prior to 11/30/2001. please help! ezra

I know how to format the text of a merge field, but is there a way to format the number? In other words, I've inserted a merge field into my layout that is type Number. I've edited the font size/colour to what I want, but now I want the number to be formated by using commas to seperate the numbers (1000 becomes 1,000) Is there a way to do this without creating a calculation text field that would insert a comma after every 3 numbers starting on the right side? I want to minimize the number of fields I have since the database will be quite large. Thanks in advance

I have text in a field that I need to break apart at the commas in the field. Data looks like "White, 345 blue, black, 787 Gold" I need to get White into a field, 345 Blue in the next field and so on. Could someone help me with the calculation? Thanks, Wayne

I have a field that I would like to save the status on as the information changes. i.e. its a Trouble Report Status field, and has 'open', 'closed', 'work ing progress', 'ECP' etc. at the status pulldowns. What I want to do is keep track to a particular TR as it goes from open to closed and be able to display the info in a global. I can check the status of the field change but need to know how to store the change with a data associated with the change. I have the global up and working. thanks,

Is there a calculation or other method which will convert calendar dates into julian date format? Thanks, Todd Shays

For Global fields, Do I have to make sure nobody is in a db to update the globals? I have a global field that is set by me each morning. Sometimes, quitting and opening again, the field didn't take. Does a global field require that nobody be in the db??

Is there a way to write a script to find the records due on the next due date? I have a database of all due dates, and the invoice code that is on each record due that day (001 is due 01 Nov 01, 002 is due 04 Nov 01, etc) i want to create a script that would find the transactions that are due only on the next due date. If today is Nov 10th, and the next due date in the due dates database is Nov 15, i want to be able to run the script and have it find only the records due on the 15th. I am trying to automate my system as much as possible so the less experienced users will have an easier time using the software. Is this possible? if so, suggestions? thanks,

Is there a way to translate numbers into text as when writing a check? I would like to put a number into a FileMaker Pro field and have my file create the corresponding English words. For example, if I enter $11.38 in my number field then Eleven and 38/100 Dollars would appear in a text field. Thanks for your help.

Can someone help me with this one? I need a calculation that will cancel ont an entry whene a yes/no is entered. e.g. When the premium is paid "yes" is entered. We would like the premium amount to be cleared and the total to change. (I've got the total field working) Premium I.P Tr T.P.D Super Total Nett Prem. $5000. $990 $1180. $7170 Paid Premium I.P Tr T.P.D Super Total Nett Prem. $5000. $990 $5990 Paid Yes elfin Perth Aust

Can anyone tell me if this possible and how I can achieve this. I have created a database that will keep track of Finical payments for a school. It is made up of several fields that contain information about each student. Lets say I wanted to create a report about every student that paid with a check for 2000. How would I do this when each record contains several fields that may or may not contain information in it and it could be in one field and not the next. Example: Record 1 Jim Smith Field#1 7/26/2000 Check # 201 Field#1.1 paid $200 Field#2 8/30/2000 Cash Field#2.1 Paid $200 Field#3 10/20/2000 Check #202 Field#3.1 Paid $200 Record 2 Jane To…

Hallo all, I would like to do the following: (Windows, FMPro5) Create a new Word (or Excel)-document (create it IN the container) and display an icon in the container field. So far, so good, no problem. But how can i prevent certain users from EDITING the document? (i created a group and a password and set access to the container to read-only) When i set the security-options of the container to read-only, there is no possibility to VIEW the document, a double-click on the icon doesn't work. Any suggestions how to solve the problem? Or is the best way to link to an existing file and let the server (NT) handle the security? Regards from Holland, Erik [ Novemb…

I want to create some sort of summary field that will combine information from a given field from all records in a found set. I see where it's possible to create such a summary using numbers, but is there a way to create this for text. (I'm trying to create an e-mail list of all records or for a found set)

I've just started getting a message saying "Do you wish to save this change with the layout" everytime I alternate between Form, List & Table views. Any ideas?:??

I'm editing this company's "time card" application, I need to "Round" the minutes of this field to every quater, eg: if this employee start time of the day is: 09:07, I need it automatically turn it to 09:15; if it's 09:03 then I need it turn to 09:00. Is there any way I can do it? Thanks,

This is probably very easy calculation (I'm a relative newcomer!)but getting quite annoying. I want to know how to add a certain number of calender months onto a date. --> We run company pension schemes, whereby employees are eligible to join the schemes after say 6 months at the company. ie. Someone may join a company (DateJoinCo)on 22/6/2001 (UK Date Formatting) and I want the EligibilityDate field in this example to show 22/12/2001. The EligibilityDate must be formatted as a date field not text. CAN ANYONE HELP PLEASE!!

You are using repeating fields. Not a good idea. But, to answer your question, if you mix non-repeating and repeating fields in a calculation, you need to put an Extend() function around your non-repeating fields. For example, if Qty and UnitPrice are repeating fields, and the SalesTaxRate is a non-repeating field, a tax calculation would look something like this: Qty * UnitPrice * Extend(SalesTaxRate) I recommend that you look at replacing the repeating fields with a portal to a related line items file.

I can't seem to figure this out and it should be very simple. I have 2 DB's. First called PROGRAMS (title, ID, length, second called SCHEDULE (Start time, end time, date). These two are related. I put a program ID into the SCHEDULE DB and other info is inserted via a look-up. WHAT I NEED is a count of which "play" I'm on when I insert the programID into the SCHEDULE. In other words, each program is inserted a varying number of times. I need to look at each insertion an see which insertion that is. For example: ID number 200 is inserted 5 times. I need to know that when I look at the second insertion it reflects (2), the 3rd insertion (3) and so forth. I'm lost. THANKS

Hi, I'm working on a simple d-base to track some work in my office. I'd like to build a button that one could press when the task is done and it changes the background color on that particular record as an easy reference to anyone that this task is complete. Does anyone have any idea how to change make this happen? Thanks, Jack

Q? I have a textbox on a layout [Lets call it "Problems List"]. This field uses a Global field and text Option selected. The field source for the Problems List is a Checkbox using a Related forms value list [Keep all patients common problems in another database - maintain the values for the list there]. I would like to pick and choose items from the Problems List by checking their "CheckBox". I would like to then write a scipt to loop through the Problems List and identify the ones that are checked... One, ?How? do I loop through this field - and Two, ?How? do I determine if the field is checked or not checked? Is the value like a zero, or one if checked? Later - I…

I have a database (FMP 5.0) I want to store multipage tif images in. These images are scanned documents. I am able to drag and drop the image to a container field, however it only shows the first page. Containers cannot have scollbars, so I can't scroll to the next pages for viewing let alone printing the scanned documents. I welcome any idea's you may have. Thanks in advance.

Hello, I am using Filemaker 5.0 and 5.5 on windows 98/ME computers. I hace a file with a container field (audio note)that records or plays a spoken list of facts. The sound recorder that comes up will only record for 30 seconds. This is not long enough for some of the needed entries. Can this time be extended? Also can the sound file in this field be edited or added to from within Filemaker? Thank you for your time.

All - Just curious if anyone has a nifty trick or other method for relating records based on inequalities. For example, if I wanted to relate record with field Date of value 10/15/01 to all other records that have a Date value of 10/15/01 or less. I've toyed with trying to have a secondary calc field that gets all Date values for records, but the concept becomes circular. I still need a way of isolating the records that are "less than" the record in question. I have certainly found solutions to this, but they always involve isolating records and using a running-total summary field. I was just wondering if anyone had some magic bullet that would allow a relationshi…

How can I make two fields (i.e., "first name", "last name") fill in a third field ("full name")?

I am working on a photo database and was wondering if the size of the image impacts the database. I am using the original images as the source for the thumbnail (usually 1600x1200). If file size makes FM slow down, then I will just convert all of the images to smaller jpgs and link to the original image on CD. If I convert the images down to about 2-3 inch thumbs of about 5k each, would that speed FM up?

I have created a date field that calculates an expiry date based on the date of creation of the record. This calculation works but it will not calculate an expiry date for records created prior to the expiry date field creation. Is there any way to have FileMaker go back and calculate these dates? I am usinf FileMaker 4

Look at this formula for calculating a disabilty pay rate for injured workers: Case(DayofYear(Date of Injury) <= DayofYear(Date(10,31,1999)) and Average Weekly Wage * .7 <= 426.,Average Weekly Wage * .7 ,DayofYear(Date of Injury) <= DayofYear(Date(10,31,1999)) and Average Weekly Wage * .7 >= 426.,426.,DayofYear(Date of Injury) >= DayofYear(Date(11,1,1999)) and Average Weekly Wage * .7 <= 473.,Average Weekly Wage * .7,DayofYear(Date of Injury) >= DayofYear(Date(11,1,1999)) and Average Weekly Wage * .7 >= 473.,473.) Can somebody tell me why if the Date of Injury is 12/31/1999 and the injured worker's Average Weekly Wage was more than $473, the ca…

I used to be able to change field settings on a shared database (fm server 5 on win server). After I switched computers I can't find out how to install my PC so that I can do this. I need to turn off the server, change the field settings and the start the server again. What do I need to do?

I have a question? I have a databse with a field that has a popup list from a value list ....is their any way to only enter one of the choices from the list? In other words, they can only pick from the list and not enter anything else. Can someone help? RET

I'm working on a database for a client involving two files: a contact file and thumbnail viewing file. The thumbnail viewing file has two layouts: the main layout with 10 container fields for viewing of the low-res thumbs, and a Print layout with 4 containers in a 2x2 format. The files are related through jobs that are being performed with the client's customers. Through use of the Troi file plug-in, I'm able to get 10 low-res thumbnails per record into the thumbnail database. The user selects which thumbnails they wish to collect for output and selects "Print". This launches a print script, and the Troi file plug-in again does its job, this time referencing the thumbnai…

Sorry if this is in the wrong group but the problem is a combination of Global Fields and Scripts... I have a script that takes the user to a new layout where there is a global field (we'll call it gField.) gField is defined as a checkbox list based on values from a different field in the database. The script is paused to allow the user to choose their selection, and it is continued when the user clicks a button (which performs resume script.) There is only the one script running. After the user clicks the button to continue, I have an If Statement... If ( IsEmpty ( gField ) ) that shows a pop-up message telling the user that the field is empty and that it needs …

Does anyone out there use a pen tablet to insert signatures into databases? I want to go paperless, and the only way to protect ourselves legally is to have a signature (electronic or otherwise)that verifies everything we have on paper. I have looked at some point-of-sale hardware, but want to make sure that I can actually tie it into FMP before buying it.

I just installed Filemaker 5.0 server onto a brand new Windows 2000 server for a client. This client has a lot of image links in the database. I understand that these links include the name of the "old" server in the link. I CANNOT name the new server the same as the old server. Is there any way to run a script that would do a "search and replace" replacing the old server name with the new server name??? Thanx!!

I do registrations for a summer boy's camp. I have a number of related files. One file (History) keeps data on campers: Address,age,when they went to camp, church affiliation etc. Each record is a boy. Another file (Camp)is used to enter registration data for the current year. Each record is a boy registered for that year. It relates to the History file (via Name, Relationship is called History)for age,address, church etc. The church field is the problem. A boy may be affiliated with a church or may not. Also some of the churches have a unit number associated with them because they have a boys group in their church. Thus 3 possibilities: Boy with church with unit no…

Here's the problem You can pick up to 10 restaurants from a preselected list of 40 restuarants and/or fill in your own from 10 tezt boxes. So you could select all 10 from the preselected ones, or select 5 preselected ones and fill in 5, or simply fill in all 10. I have 40 checkbox fields (named chk1, chk2, chk3...) for the pre-selected ones and 10 text fields (named box1, box2, box3...) I use Javascript to make sure no more than 10 are selected/entered from both sets. I have a calculated field (rest10) that basically goes through each to see if the field isblank or not. If not, it adds Restaurant name otherwise it adds nothing. The problem is if I go back to the web …

Greetings I am trying to make a simple invoice in FP 5.5 I create a summery field in the footer, which sums up the prices. What I am unable to do, with my limited knowledge, is to create a postage field & then a Grand Total field, summery + postage. Thanks. Sean O'Donoghue London

Is there a way to get a calculation to enter text into a third field? i want my calculation to do this: if(field1=x, "y" & field2="y", If(field1=a, "b" & field2="b", If(isempy(field2), "q", "r" Field 2 is a regular text (name) field that has valid text entries and i want to display "y" in the calculation field and replace any text in field2 with "y" if field1="x". Same idea for the second "if", and if by the third "if," field2 is still empty, display "q"; and when i put a name into field2 display "r". is this possible? i hope my explanation isn't too confusing...if anyone would like a more detailed explaination, send me and email and i…

Short version: I need to create a field that concatenates info from a particular field in another, related file. Long version: Two files, Main and Related, with a relationship based on Name field in both files. A field in Main ("Concatenation") needs to string together the contents of the "Info" field in all the related records in the "Related" file. Any ideas? TIA, Dan

I'm embarassed to admit that this isn't in our repertoire right now, but does anyone know how to define a field that verifies credit card numbers, preferably using the LUHN-10 standard?

I realise that this probably isn't really that hard but I'm just not getting anywhere! I want an automatic date entry (today) when a particular checkbox in a value list is selected. Any suggestions for the calculation/validation would be most appreciated...

I have been creating a simple contacts/company database.for a design company doing logo's company branding marketing etc.. I have asked if i can perform an extra facility which has got me stumped. Quick explanation 5 layouts company details,contact,type of work/business,stratagy,reports this is all fine if you have one contact at a company and one type of business relationship. I have been asked to allow for multiple contacts at a company that may be large and may be doing different business therefore the 2nd and 3rd layouts/feilds contained must be able to be repeated upto 5 times. i need something on the main layout to give some indication of whether th…

when i create a layout the margins and borders are ok when i go to browse mode the form edges go on for ever to the right and below. when opening templates this does not happen and what you see is pretty much what I want. I have looked at the set-up/prefs but cannot see what to do please help ps i am very new to this but an experienced Mac user of 12 years

I am using FM 4.1 for printing labels out of a data base of info. For VHS, 3/4".... this has worked great. Now I need to print CD/DVD disc labels and need to print on a curve. Is this possible and how is it done?

I have a file that includes pages that insert images in to fields via a script. This is done for visual pleasure but an inherent FM trait displays the field borders (although none are defined) as the image is inserted. The border becomes "invisible" again when the next field is selected. However, this looks clunky and I would like to make this run more cleanly and seamlessly. Any suggestions??

Hi everyone, How do I, on an order form, allow entry into a credit card number field and then when the record is re-viewed the credit card number should be unviewable unless you are in the admin dept. and not in the sales (different security levels):? I need to be able to see whilst entering the number so that it is correct so changing the colour of the feild text isn't the answer. Cheers guys!