Calculation Engine (Define Fields)

I am trying to print to a LaserWriter 12/640PS with an envelope feeder installed. When I try to print to it from within FM The option is grayed out. However I know the printer is configured properly because the envelope feeder is accessible in MS Word. I am using version 4.0 Any Ideas!! Thanks

I don't even want to know why you're doing this, but here you go: Max(Date used1, Date used2,..., Date used 10)

Okay, first I know "never use repeating fields” But I could not find another solution to my problem. I have one field for a contact and had previously defined a repeating field to store values, which each contact could have more than one, but no more than three. For example: Contact field = "John Doe" Repeating field = "M.track" "Football" Now everything worked fine at the start, I even used a portal based on the repeating field to show all records for say "Football" and his name would show as would if I had inputted "M.Track." The problem is when I go to print for a specific group based on a value in the repeating field, the other value is…

Not another Bass Guitar playing FileMaker developer !! Sorry - we don't have a website for "Major Groove" yet... Russ

I'm a complete newbie in FM-pro land, so i'm sorry if the answer to my question is too easy. I have a field with a calculation (case.. etc), now I want to have the option that if the calculation turns out to be the standardresult, I can just manually fill in the field. Is this possible, if yes, how?

Is this a bug? Excel tells me that the day before 3/1/1900 was 2/29/1900. Filemaker tells me it was 2/28/1900. I discovered this trying to calculate holidays. I found a web page with Excel calculations, and was trying to convert them to work in Filemaker. Excel (for windows) treats dates as numbers by counting 1/1/1900 as 1 and numbering each day sequentially thereafter (1/2/1900 is 2, 12/31/1900 is 366, 1/1/1901 is 367, etc.) (excel for mac starts with 1904, but I won't even go into that...) Anyway, I guess the real question is, does anybody have calculations for holidays for any given year?

Just a simple question (I hope!). How do I right justify number fields so that in a list all the decimal points etc are lined up correctly? Cheers Nick

I have a report card solution for an elementary school, and a two-part question... Part 1: Given the fact that a school year starts and ends in two different calendar years and I know Date(Today), how do I represent SchoolYear? Part 2: (maybe a variation of part 1) If I know a student's Graduation Year and Date(Today), how do I calculate SchoolYear and therefore the student's current grade in school? Thanks. Susan

I am trying to create a summary sheet with summaries, summing total work hours on a project, in one database pulling information from others. This should be simple but I am missing something. Database 1: Field <Grand Total work hours> Field <Project> Database 2: Field <work hours> Field <Project> Dtabase 1: Field definition of <Grand Total Work hours>: Case(database 1/field <project>=database 2/field <project>, Sum(<workhours>) I have tried summaries and other ways but no go.. Any thoughts?? Thanks!!!

I print my found set of records to a PDF file and then create a web link to that file. Data that's in one of the fields disappears and/or does not fully display when you open the PDF file. I have tried replacing the field, quitting and opening FileMaker, making the field smaller/bigger, etc. I can't figure out what's going on. The field is certanly big enough to accept all the data. What's going on?

I would like a global field to display the maximum value of a certain field of all records. Is there some way to define the global to reflect the current maximum value? I had tried a calculation field, but it saw the maximum of the current record (obviously a limited case.) (Filemaker 5.5)

Hello I've got two date fields for each record. On each record only one of them has a date in it. (Long story as to why) I've got another field returning which week of the year it is (using the WeekofYear() function). I can set up this field to look up either one or the other of the date fields, but how do I get it to look at both of them. In other words I want it to look at field (a) and see if it's empty or has a date in it. If it has a date do the function, or else look in field (: for a date. Thanks for your time Drew

The only way I have ever done it is the way you described above. I only used it in a situation where there would only be a single section of bold text. It's probably a lot of work, but you could set up a merge field like this: <<plain01>><<bold01>><<plain02>><<bold02>><<plain03>><<bold03>><<plain04>>[ b]<<bold04>><<plain05>> etc. Then use as many fields as necessary. [ April 05, 2002, 01:06 PM: Message edited by: BobWeaver ]

Hello, I've got a repeating field big enough for 30 items. Those items are coming off of a select menu from a web page. Now, since I have 30 items, every time I show that field on a format field with the [FMP-Repeating] stuff, I get the full space for 30 items. Would anybody have a script on how to chop off those extra spaces if they are blank? Would I test each line? Or could I loop through.... thanks!

I know this one is dead easy but... I want to convert number eg 87200 to Eighty seven thousand and two hundred dollars for printing on documents I had the code to do it (Apple in those days, about 6 years ago)) faxed it to me but I didn't use it at the time. I need it now and went to get the fax out of the file (we all know what happens to thermal faxes - They go blank over years don't they!) So dont know how to do it I'n not sure if it was a field or a scrip step help appreciated. Neville

Is it possible to have a script open and display the contents of a windows folder, perhaps through the send message command?

I have a field with a date. I want to create another field with the same date plus 1 year. Thanks Again Andy

Hi folks, I'm new to the forum, and purchased FM5.5 a few days ago. I own loads of sound effects and would like to audition sounds from the FM database. A few questions ... 1. I 've digitized the audio using Toast Audio Extractor, and want to insert the sound in the corresponding record's container field. Do I have to do this 1 file at a time using the "insert quicktime" menu command, or can I automate this process ? 2. Once placed in a container field, is there a way to navigate within the sound file apart from the slider at the bottom of the quicktime window [ which seems to respond rather sluggishly within FM ...]? Is it possible to enter a "go t…

I've created four fields that have imported calculated, totals of sales (for each part that we sell), for month, quarter, half and year. I would like to now multiply the month by twelve, the quarter by four, the half by two and then find the standard deviation of these four fields. Does anyone have a suggestion on how to do this? Thanks

I would like to be able to select a check box and have a serial no. appear in a field Thanks Andy

Not sure if this is the correct area of forum to post this question, but you all were so terrific in solving my AphaNumeric question -- so here goes In a Runtime application, would like to require user to register his/her runtime (input license # I supply). Have it only work on the computer user installs run time app on. And would like to set this registration up so that it will expire in one year, requiring user to purchase an additional one year license. Of course user would get 30, 15, 10, 5 and 1 day advance warings. Thank you.

I don't think there is a limit, other than exceeding the 2GB file size. I'd be worried if I had more than a couple of hundred layouts: it could be a flag for bad data design (like hundreds of fields).

Is there a way to create a unique sequential field (primary field) that uses alpha-numeric. Limit field length to say five characters. For example, AA001 AA002 AA003 up to AA999 and then flip to AB001 AB002 AB003 up to AB999 and then flip to AC001, etc.....

I've got a field (City) that should have a Value List of 200 cities (so far only have half that imputted - don't know if the value list will hold 200). Anyway, i have another field (ADI) that is a calculation to display a number that is dependent on the City field. (If City = New York, then ADI = 1, etc.) Case( City = "New York", "1", City = "Los Angeles","2", City="Chicago","3", City = "Philadelphia", "4", City = "San Francisco", "5", "") (etc,) This works, however, i don't know if the calculation box will accept a calculation that large (I have to type in a statement for each city). Also, the value is going to change frequently for the ADI …

Hello. I need help with an inventory system that shows reduces the number of products on hand as each one is sold. However, I don't want it to show "0" on the list that feeds the order file; I want it to show the actual number in stock. Here's the situation. There are 4 main files: "order data" where the actual order is filed. This file includes a field called "checked" that indicates whether the order was sent [3], was canceled due to credit card or whatever [5] or hasn't been processed yet [blank]. The second file is "products sold" and is a list of each product sold with order number, stock number, etc. The data in this file comes from the "product list" fil…

If I create a calculation field, and in the Field options set the repeating value to 6, and when I place the Field in my layout I set the Field Format Repeat to 6: In the calculation for this field I enter "1" In my layout the first of the 6 repetitions contains the 1, the other 5 are empty. If I use this calculation---- "1" & "2" & "3" Then the first repetition reads 123, the other 5 are empty. Can I modify the calculation so that the "1" shows up in the first repetition, the "2" shows up in the second repetition, and so forth. I know there is other simple ways to do this, but I need the field to be a single field with repitions with diff…

I have a calculation that is looking at the day from a date field. For example if the date field contains "March 1, 2002" Case(Day(FieldDate)=1,?,"") ? would be the result. In this case I want it to look at the field called "FieldDate" and if the day =1, I want it to change to color of a second field called "Today." Anyone know what code I would use in the place of the ? to acomplish this? also, can the same method me applied to making a field visible or hidden? [ March 31, 2002, 12:28 PM: Message edited by: Larry Ross ]

I have a standard date field. I have a second field that I am trying to get a calculation to work in by looking at the date field, and if it contains a certain day of the week, it shows that date. I have tried 2 basic calculations but cant get either to work: If(DateField = Day(1), DateToText(DateField), "") If(DateField=Day(1), DateField, "") No luck with either one of these. Any ideas anyone. LR

I have field which contains a uniqe primary key. When a user enter a value into this field in a new record I want to check for duplicates and show a message if the record already exist or better exit the create new record and show the existing. If the record don

Dumb Question -- sorry, but..... I'm trying to join (concatenate) two fmp fields in the same file (e.g. FirstName and Last Name) into a single field FullName (virtual field calculate or look up evey time). The layout field order is FirstName LastName FullName In define fields under calculate, I use (FirstName & " " & LastName) to generate FullName. I cannot get the LastName to display. I get FirstName and the space, but no LastName. What the $%#@&% am I doing wrong here?: PLEASEEEEEEEEEEEEEE

I would like to set up a field that counts the number of records I have that have identical IDs. For example I have a book the the ISBN 156740393x. I want file maker to count how many books we own with that ISBN. Is this possible? Mindy

I am creating a database to track equipment leases. I have the effective date and want to calculate the expiration date. The lease term length is given as a number of months and this is what I want to add to the effective date to arrive at the expiration date. I would appreciate any help you can offer. Thanks.

I have a database of employees which has a layout listing them by seniority. The sort is by a number field (manually entered). When a record is deleted, let's say #50 of100, how do I get the records from there down to move up one number? I,ve tried changing to a calculation field and using (currentrecordnumber) but can't seem to make it work.

I'm printing pre-defined thankyou letters through a script that enters today's date in a field. Today I want to edit my letters and continue using the script and same field (keeping a cumulative record of thankyou letters to individuals). Can I make the new date add rather than write over an existing date? (i.e. As subsequent thankyou letters are mailed to the same person, I will have a record of all dates.) Thanks. [ March 25, 2002, 08:12 AM: Message edited by: Maxwell Morlay ]

I have a database used to register soccer players. Two date fields included are FIRST_ENTERED & LAST_MODIFIED. Filling these with creation date and last modified is simple, but I need something else. Another field is REGISTRATION_STATUS. This is a text field who's values come from a value list (Registered, Pending, Drop, Refund, etc...). Registration Status is selected from a group of radio buttons. I would like to have a date field that is filled with the current date whenever REGISTRATION_STATUS changes from "Pending" to "Registered". Can this be done in FM Pro 4.0v1

Don't remember how to do this. Only want to see one record at a time in layout. Would prefer not to have scroll bar on the side. Thanks Andy

In MS Access, Alpha V, Delphi, etc.... there is a way to display long tables (a/k/a long pages) using a "tab" command. Basically this command sets up a new window (or frame) inside your main screen so that you can place additional fields for the user. The user then clicks on the tab to view these fields. The use of tabs helps eliminate the need for users to scroll pages. In fmp, I see there are tabs being used in many functions (e.g. define fields (options), there are tabs used for "Auto-Enter", "Validation" and "Storage". Is there an ability in fmp to create similar tabs to offer the user a different view of the data? Thank you. [ March 27, 2002,…

I know this should be simple but I just can't get it to work. I want a number field to require a value if a text field has an entry in it. I have been trying to use IsEmpty but can't seem to get it right.

Hello all I'm halfway there on this, and stuck. I want to be able to make up the following utility as part of a solution. It's to determine either the planting date or the picking date for seedlings. Say I've got two vegetables, capsicums and eggplant (in reality the solution has 20-30). If planted in January capsicums take 29 days before picking, February also 29, March 20, April 35, May 42. Eggplant take 21, 21, 26, 30, 32 respectively. Given that a client may give you either the planting date or the picking date so you want to plug in either date and come up with the other one. How would you structure a solution to take into considerati…

Is it possible to build a "tree" in filemaker? So that I can chose in popup menus in many steps? For example: I chose a country in the first menu and then the second menu dispays only the cities in that spicific country. When I then chose a city the thierd meny displays the streets in that city. Please help me anyone?!? Thanks!

I have a db with designs broken down into increments of 500. I need to be able to calculate the path to the file from it design number. i.e. Design 1050 is z:10001050.jpg, design 5900 is z:55005900.jpg, etc. I started out with if-then script steps to calculate the path, but as the number of images grows and I make mods to the db, it's a real pain to change all of the scripts. Anyone have a calculation or simple way of finding the right number?

OK, I have a prospects manager database and a customer database. The record identifiers Prospect No, and Customer No are the unique fields that I use for relationships etc. What I want to do? When I create a new record in either database I want it to be unique to both databases for example: In the Prospect Manager I have these records 01 Mr Smith 02 Mr Bloggs In the Customer File, I create a new record and it automatically is allocated 03 as the record identifier. If I then were to create a new record in the Prospect database it would be given 04 I hope this makes sense Thanks

Try searching www.databasepros.com. Also check out the filemaker solutions framework at filemaker.com

UPDATE: The PNG file type is now available in the "Insert Picture" dialog box. I can't explain it. Since installing FMP, I don't know what else I installed that may have made a difference. The only thing I can think of is that I recently updated my MS Office 2000 install to add Publisher and I installed all the graphic filters that were not previously installed. One of them may have been the PNG filter. ?? quote: I have FMP5.5 for Windows installed on a Windows 2000 Pro machine and a Windows XP Pro machine. The Win2k machine can import PNG image files, the WinXP machine cannot. On the WinXP machine "PNG files (*.png)" is not an option in "Files of Type" …

I have a Script which calculates amount based on decreasing the discount percentage based on years,say for 1 Yr the discount pecentage will be 5% for 2 yrs 10%,for 3 yrs 15% ... and so on.The output should be displayed in a summary page or it should print on a page with amount for 1 st yr then for 2 nd yr and so on. The output should be in the form of a result set or an array.How do I go about doing this? [ March 21, 2002, 08:35 AM: Message edited by: Jacob ]

I'm new to FM help would be greatly appreciqated. how do I create a "check box" when the box is checked a price will automaticly appear in another box? Thanks Andy

ok i need a calculation that, based on one date, will give me the date of the next saturday. basically i am just trying to find out the ending date of the week. so for today (3/25/2002) the new field would display 3/30/2002. thanks

I have a date field, Date, I want to be filled in with todays date if someone fill in a name in another field, Name. To do this I have made a calculation with one If case code: If( Name <> ""; Today; "") This worked when I had the date in a text field but now, when I changed it to a date field, it don't understand what to put in the field if there is no name in Name. If there is no name FM puts a "?" in the field. This most be because "" is a text command, but how do I do to say no date? //Henkan

I need to summarise by the first part of the UK postcode, which signifies the city, area or London postal area. Unfortunately, this is either 1 or 2 letters long (the postcode system was not designed with database designers in mind!)Examples of post codes are CW4 7QG, SY3 8UJ, S4 5RF. I basically need the first 2 characters if they are both letters and only the first character if the second character is a number. I first of all defined an intermediary field, call it PInter, as ; TextToNum(Right(Left(Postcode,2),1)) This should return a number if a number is the second character and be empty if not. This field would be used to define the PostcodeSummary field …

Hi! I have an events database which contains a file for speeches/sessions. Each session has a unique code called 'Session code' and each session can have a number of bullet points associated with it. The bullet points are contained in the 'Bullet points' field and there is also a 'Bullet point number' field which is where I'm having problems. This represents the order in which the bullet points should appear. I need it to be editable by the user so that they can change the order of bullet points whenever they want, BUT I want it to automatically fill up with 1, 2, 3 etc as bullet points for a particular Session code are entered. I have Bullet points number …

How do I set up a field validation that allows only the characters "a-z" and the dash "-". I have a text field but users can enter numbers and/or other characters because the field is text. Examples of what can be entered are: A-H AAA Where the characters represent a person's initials (first, middle or none, last) I'm on a mac using FM 5. TIA, Diana

I had a calculation that worked fine and now I am getting a "?" (Question mark) in the field. It worked fine before and now I get the "?" I thought I read something about this but cannot find it. Someone must be able to answer this simple question. Thanks in advance, -morning man

Hi, I would like to know if there is a way to track the field changes made. For example you can track the record by creating a creation date and modification date. Can you track and do the same thing to a field instead of record?

I want to perform a script depending on the content of a field. I have tried IF field1 ="xxx" or field1 ="yyy" or field1 ="zzz" End IF But I want the script to perform if "xxx" is also only part of the field content and not an exact match of the contents of the field Any Ideas?

Strange problem is occuring, where the whole record is sometimes duped when users are creating new record. This is occuring aproximately once a month. Mind you, they DO NOT go to the menu, there is a button specified to create new record/request. So no, they don't click on "Duplicate Record" menu by mistake. This database has Auto-generated unique PK field, on which it connects to other databases. But it also has a cancatination calculated field, on which it connects to other databases (this is just a nature of this solution). Has anyone ever experienced anything like that? Thanks for your input!

I am on my first major project with Filemaker. I am working with value lists in drop down boxes but when I am creating the list it comes up blank even though I know that the information is in there. What am I doing wrong?

Excuse me if this has been gone over already. I am trying to figure out how to change the format of part of a string calculation. Basically I want to write a script that will change the text color of the part of text that has changed set(x, x & w & Y & z) so that if y has changed since the last time the set function is called the y part of the calculation will be bold and red while the rest of the string remains normal text. I know how to make the comparison I just need to know what the formatting command should be. TIA

I have a question about using a field that uses Status(CurrentRecordNumber)? When I create a new record it places the current record number in the field. For example if I have 5 records and create a new one it placed 6 in the field. Now if I go in and delete 2 records records then my total number of records left are 4. Yet the field for my newly created record still reads 6. Is there any way to have this field update in all my records to always match the current state of records? The same problem applies to Status(CurrentRecordCount). Looking for a solution for it also. LR

I have a database tha have had three different developers before me. Unfortunately all of them has had their own standards regarding field names and none the strength to change old parts. What I want to do is give these fields new names and set a standard. In many of these fields I only want to change the first part of the name. Is there any easy way to do this to many fields at the same time? In a earlier post in the this forum I read about a external program, AUtoIT, that could give some help. But I would love if there was a way in FM to do this. I'm using FM 5 Pro and server, where the server is a WIN NT 4 and the clients both PC and MAC.

I've set up a real simple report that contains a sizeable notes type field that needs to slide up when it's empty. I've done this before, and it has always worked. For this layout though, when previewed or printed, not only does it slide up, but slides up over previous records if the contained text is particularly long. I've tried both sliding to only and sliding to all above, and the slide enclosing part needs to be selected to reduce the space. Has anyone else encountered this?

Hello. I use Filemaker 5.5 on a Windows 98 system. I have a database with container fields thats contain wav files. If execute the database from cd, the sounds not work. If execute de database from protectec dopy diskkette, the sounds not work. If execute de database from hard disk, the sounds works ok. Thank you, and excuse me for my poor English

I guess this is as good a place to ask this question...Is there a way to print a list of field names?

I have a web cam that I use to take photos of customers to make a membership card. I want to click a filemaker button that will using the insert object script, use activex and open a program that will allow capture straight into filemaker. I have tried setting the object to Miscsoft Picture Editor Scan. This sucessfully opens the webcam software, allows me to take the picture, but it for some reason won't update filemaker. Can anyone recommend a better way of doing this Many Thanks

I need to create a report that shows the calculation codes for defined calculation fields. Is there a simple way to do this?

If I have a key field such as an invoice number, how do I get the entire file to sort descending instead of ascending? I apologize for asking such a simple question, but I cannot find any place that has a default sorting order with the option to change it. I need the most recent record at the top of my database. Thanks!

Is there a simple calculation which can evaluate whether a number is odd or even?

Hello, I'm having trouble with a custom layout. I was adapting a previously created database I'd made for someone and happened upon a neat layout idea. I took a Table layout and stretched the Header part tall enough to fit all my 'detail view' fields in there. I shuffled all the elements around nicely and it was all going GREAT until I realized I couldn't edit any of the fields in the header area. Filemaker apparently freezes input to fields but not buttons there. I tried other Part types but had no luck. Is there ANY way to have list and detail information available and editable at the same time? This is a significant hit against workflow ease and commonsense. Has no on…

Capt Kurt recommended this version of generating a serial # that would be immune to problems when updating versions: Right("000000"&Status(CurrentTime)&"-"& Right("000000"&Status(CurrentRecordID)&"-"& Right("000000"&Status(CurrentDate) This works great, but the serial numbers are pretty long.... Anybody every try auto enter SerialID# = Next# and defining Next#= Max(serialID#)+1 Then Serial ID would auto increment based on the last serial ID without having to keep track of the last number entered for version update. Capt. Kurt, are there any disadvantages to this?

I don't know if my question fits properly into the "Define fields" section, but it was the closest I thought of. I have a discussion with a client on how to define a standard for article/item identifier. (They will not be used as primary keys). In this particular case it's a company who sells light sources, overhead projectors, and data/video projectors and accessories to these. I thought that some of you guys might have worked with systems where you deal with a lot of articles/items and might have some good examples? Some of my thoughts: It would be nice to have some kind of logical grouping within the identifier, maybe separated with dashes for …

hi... I had make an old software in DBASE III .. and we can set in an input mask like xx/xx/xxxx (for the date..) It's easy. You just type 10102001 and the you received back 10/10/2002. How can i use that function in Filemaker? Maybe with an Add? Thanks

Is there a more graceful way of using field validation to lock out changes to fields? I've heard this method of doing it, but it seems very ugly. You can still edit the text and it just warns you after you leave the field. As well the message is confusing to end users. What other methods of locking out changes use people dreamt up? (besides using 2 layouts of course)

What does this message mean and what do I do (or look for) to get rid of it? "There are too few separators in this function." thanks, Harry

i have a db with 1.5 million business names etc. unfortunately i have manageged to delete all the zero's off the beginning of the telephone field and fax number field, somebody must know of a way to help put them back in. Many thanks in anticipation. Bob

I have a networked database that has a container field that contains a link to TIF files stored on a server. The problem is that if I establish the link with one computer it is only accessible by some computers on the network. The catch is, if I establish the link on one of our other computers, it is accessible to ALL other computers on the network. We are running combinations of version 4.0, 4.1, 3.0 and I initially thought that it was a forwards compatibility issue, but links established in 4.0 don't open in 4.1 on some machines, but they do on others. There appears to be no rhyme or reason. All PCs are mapped to the drive with the images. Any help…

If I create graphics for buttons in Photoshop and import them, does Filemaker convert them to bitmap, or should I spnd time optimizing them prior to importing them?

Who can help me with this? I want to convert text from a Value List to a number to another field. Each textline has to have it's own number. For example: 8001 DTP > 75, 8002 Design > 100, 8003 Correction > 120, etc. The number will be used for calculation.

In a database i've a record with 2 people in each record, with her (his) own adress. How can I make a sorted list, with a subsumary leading, with the people thar lives in the same adress. In the form that I use the 2 people in the record appears

Hi all, I have a date field. I want another field to automatically be the date from this date field + 4 days. However when i do the calculation: new field = DateField + 4, I get a new date with 4 years more. I guess the date is considered as text. I would also like to add only 4 working days to the date, for example, if my original date is a friday, and i add 4 days to it, the new date field will be Thursday, if we omit saturday and sunday. Anybody has any idea on how to do that? Thanks David

Hello, I have this calculation that checks the date against today's date and then assigns the field active or expire. And it works . . . sort-of. The problem is I want it to check this on a daily basis so it could change the status when the date does expire. Any ideas? Kent If(Date( TextToNum(expiremonth), TextToNum(expireday), TextToNum(expireyear) ) >= Today,"active","expire")

I have never heard of this process, but that doesn't mean that it doesn't exist. Old Advance Man

Hello to all... It's my first date here... How can i set an input mask in FM 5.5?? Like DD/MM/YYYY? i used that in Foxbase.. it's more simply to input date in that way... Thanks... [ March 08, 2002, 08:33 AM: Message edited by: serge ]

Hi, I am struggling to build a relatively simple application for my father. Please forgive me if this is an obvious question. I would like certain fields to 'appear' or only become 'active' if a related field (in the same database) contains a certain value. So, if the field PASSPORT_CHECKED contains the value YES I would like another field PASSPORT_NUMBER to become active. I find it confusing when the PASSPORT_NUMBER field is active even if PASSPORT_CHECKED is set to NO. Am I missing something very basic here? Thanks James

Building a cross platform kiosk runtime solution (So can't use applescript) in which I'd like to have a Quicktime movie startup after a designated period of inactivity and loop until which time someone clicks somewheres on the screen. It would then display the proper find layout. I'm having trouble exiting the quicktime loop step immediately. I initially thought that I'd be able to make the container field (which would cover the entire kiosk window) a button scripted to exit the loop. I have the user abort on, this is ignored, why? Currently, if I place a pause at the end of the script I can exit the script at that time. The user has to wait until this pause to click on…

I bet this is so simple, but I'm just not getting there.... I have a dbase where the records are people. There is a field (Mail) that has 15 check boxes representing criteria I use to select records in order to generate mailing lists. Two of the values "FormerExec" and "FormerFirm" I want to be highly visible if they are checked. So I've created a text calculation field (Former) in 50 pt size that should pick up on this: Case(Former = "FormerExec", "FormerExec", Former = "FormerFirm", "FormerFirm", "") It works fine, but only when either of these values are the only ones selected. I can't seem to modify the calc so that it still works regardless of how many…

I am trying to conduct a lookup but I am somewhat confused about how it actually works because of the error message that I am getting. Let me explain. I have two databases, Item Master and Invoice. I am trying to conduct a lookup on Item# which is a unique field. When I type in the Item# in the Item# field in the invoice file I want it to look up the Item# and it display the Item Description and Price Ea from the Item Master. Item Master Fields: Item# Item Description Cost Price Invoice Fields: Item# Item Description Price Ea. My relationships between the two files are as follows. Item#::Item# Item Descr::Item Descr Price::Price …

I have a date field that I would like to be able have it auto-enter the requested date, but then I also need to be able to manually change the date as well, if required. The field is currently a calculation field and I know I can't enter the info in that form. But - if I change the field to a Date field and then have it do a calculated result - it gives me a blank field. The field I am working with is Date Due, which is currently the Invoice Date +30. When I change Date Due to a date field and set the calculated result to Invoice Date + 30 it just stares blankly back at me. I have some other fields which work fine - that are date fields as well. Da…

Hi everyone- This may be a question for the script message board, but I wasn't sure if a script was needed. I was wondering if it was possible to automatically change the background of a particular field depending on the data in another field. I've created a database that log information going in and out of our office. There are three fields; 1)date the question goes out, 2)date response is returned, and 3)the reponse. I'd like to make the response field automatically turn a different color when a response has not been received yet. Is this possible? Thanks in advance.

Is there a way of setting a limit on the amount of text that is typed into a text field? And a way of alterting the person that they have reached the text limit?

Is it possible to monitor the field, like who is modifying that field? I understand that you can monitor who is creating or modifying the records, but is it possible to find out who is modifying certain field or fields?

I thought I used to be able to do this but now it just won't work... Create a list layout of records, put a Global field in the Header section and be able to modify the field while it is in the header. All fields in the header of a list layout act as if I've prohibited data entry in the field although "Allow Data Entry" is clearly checked. Have I just never tried this before and I'm having some false memory syndrome of doing this along time ago or has something changed with 5.0?

make the calculation an unstored calculation.. -- go to storage options and check the box beside "do not store calculation results."

I have gotten the idea behind (conditional) valuelists and they work fine. Now I want to display the result, not in a pulldown-menu or checkbox, just as regular text. I must be missing something obvious..?

I have a field with this calculation: Case(IsEmpty(Time Billing::Monthly Commission),"",Case(IsEmpty(Override), Round(Payment Amount - Time Billing::Monthly Commission, 2),Override=0,TextToNum(""),Round(Override,2))) It works great when i put "0" in Override but when i put in another value it shows both the new value and the Monthly Commission value on top of each other. When i use it, i want the Override field to actually override the Monthly Commission so i only see the override value - even when i type in a value other than "0". Any suggestions?

Hi y'all. I'm working an inventory system, where I want to be able to see how many items with the same article number exist in my database. I assume this is a really easy one for you guys, but I haven't had the luck to find the solution yet. I presume is a GetSummary function or something like that... anyone care to explain how to do this? Thank you in advance!

I'm trying to sum a field in one database (CTA) in a related db (Reviewers). I only want to total the Primary Reviewers from a particular group: those that are marked "Review (send)." I tried the following, but it only adds up the Primary Reviewers if ALL of the records are marked that way, otherwise, it's blank. Case(CTAone::AppStatus = "Review (send)", Count(CTAone::Primary Reviewer)) Maybe it should be an If function? thanks for suggestions

Manually entering into a date field: < today's date in M/D/YYYY format gets me the record dates less than the date I specified. My problem is using a script and the set field step when I specify : "<" & statuscurrent date. I get the records only with the current date. Using a pause after the set field command before the perform find, it appears the "<" is not entered into the field at all with the set field command. Does this mean that set field will not enter "invalid" characters into a field even in find mode? Thanks in advance.

In my 'days past due field' I have the calculation: today's date - billing date - 30 The calculation (sum) can be a positive or negative number (and it works well). However, I want the number appearing in the 'days past due' field to be greater than zero only. If it's zero or a negative number, I want the field to be blank. How do I do this? thanks.

Does anyone know of a way (or a work around) to calculate a field only one time? I really really don't want to use a script or a plugin. What I want is for a calculation to get performed when a different field changes. But I only want the calculation to get performed once. What I'm trying to do is have email get generated once a record has been modified one time. The record will get created via the web and then modified via the web. Once that modification has occurred the record won't be touched again. I'm using the SMTPit plug-in to send the mail. Any ideas? FTR, FMP 5.5 running on Win2k pro, with IIS running as a webserver. Thanks, Carrie

Hi, I haven't used FM5 for a while. Help me out here, is this possible? I want to create little reading flash-card program for some students. I want them to see a screen which will display a single word from a list of words. They will use a NEXT WORD button to advance to the next word. The words will be selected at random from the list. The list should be modifiable by the students (ie. they can add to it when they learn a new word.) I know I'm asking a lot here, but if you give me some general pointers (eg. what function to use) I think I'll probably remember enough to get going. Thanks. Paul [ February 27, 2002, 11:01 AM: Message edited…

Hi I have this calculation that worked fine on my old computer: DateToText(Date(Month(Today);1;Year(Today))) & "..." & DateToText(Date(Month(Today) + 1;1;Year(Today)) - 1) The result is: 02/01/2002...02/28/2002 This field is called Current Month. This result is used to produce monthly report. On my new computer, the year comes first = 2002/02/01. So, my new computer cannot use the calculation because it is not a valid date. How could I get this result: 2002/02/01...2002/02/28 thank you