Calculation Engine (Define Fields)

Hello everyone! Its nice to find a good Filemaker pro forum! (my first post) Ive created a simple script to basically add up the isEmpty of 3 fields are filled out. The reason I created this is to make sure that all 3 fields are filled or nothing. Else it will give a generic message. ---------------------------------- [color:"green"]Problem: Is there a way to add "and >0" after the >3? I get a error when I try (this is in a if) If( ((If( IsEmpty(LBS1A) , 0 , 1 )+ If( IsEmpty(LBS1B) , 0 , 1 )+ If( IsEmpty(Price1) , 0 , 1 )) < 3) , 1 , 0 )

Hi all I have a calculation field that has a possibility to return a minus number, but i want it to return only "0" for any minus numbers. Can anyone please help many thanks

Hello I am new to filemaker but i have to make a database with it. I am interested in making a file that will keep track of people who attend our classes ( they are free) and I am trying to figure out how to locate the people who don't come for 4 weeks. There are like 400 possible people but most don't come. That's where I am having the problem. I am staring at 4 fields. "eventDate" , "name" , "attending" "30days" - People who have attended once but are not there for 30 days. How can I track those people? Please suggest to me. I am all ears. Thanks Cindy

Hello, I am stuck! I need to calculate attendance by half hour increments. The scenario is that within a 24 hour period, folks can have a shift starting and ending at any time. How would one count attendance for that 24 hour period by half hour increments? Any help would be greatly appreciated. Elizabeth

Hi all I have a database that we use to record customer info, sales date ect along with a scan of their contract in a container field. What i am having trouble with is a way to bring the scan, it is currently jpg, up to a viewable size. it is setup as a link to the file. what i need to do is either be able to have the link clickable and pop up a larger image or set up a button or layout to dothe same thing. have looked in help files but don't see what i'm looking for, any one help??

Hi all, I'm wondering if this is possible, what i would like to do is to append all the email address from my list to a global field so that i can mass send emails to all addresses in the field. I know using the sendMail script will enable me to send to many, but i needed a bcc field therefore has opted to use this format to create my send mail script. Anyone please explain (or better still show me ) how does one append all/multiple email addresses from the list into the global field. I'm also thinking is using global field the most appropriate choice? My email addresses will change time and again due to the increase of customers, so the values in the g…

Hi Can a container field that doesn't hold an image be made to say "no image posted"/ How can this be done. I am copying pictures from one file to another because I haven't figured out if filemaker can lookup a pic from another file. In any event I would be satisfied if I could get it to say no picture present when I get an error " no records match this request" . If that is possible. Not sure. Stan

I'm trying to make a table layout that shows all of the data I've entered from a form, but the table only shows about one-third of the fields that I've created (maybe around 35 out of the 100 or so in total). Is there a limit to how many fields a table can display? When I try to export the data, which is my goal in the end, I get data exported from more fields than are displayed, maybe 50 or so, but still not all of my fields. I realize that's a problem for the Import/Export board, but it's all related. I'd really appreciate any insight into this problem. Thanks! Brian

This is a really stupid question. Is there a maximum character length for a text field that is being used as a key field to another table? I have a field that is made up of about 8 fields concatenated together. The resulting calculated value is over 63 characters long. I noticed if I make it 62 characters, it works and relates, but regardless of the characters afterwards, the values still relate, and they shouldn't. Example Value in field A/Table A (position 60-70)... abcdefghij Value in field B/Table B (position 60-70)... abc1234567 These are the related fields. They show up as being the same. Any help would be greatly appreciated. -P…

Hi My friend has an event which he gives out nametags to. He wants to give everyone a unique nametag in a range from 001 to999 and at that time it needs to reset back to 001 again. How can this be done in the specify calculation area of the options in define fields? Thanks

Hey All, I am currently using global container fields for most of my UI graphics. These are all coming from a preferences module. When I put this on a network served up with FM Server, will this hinder performance? Would it be better to either just use the graphics on the layout themselves, or use global container fields from within each module? Thanks.

I have a situation where I need to combine 3 fields, day, month, and year. I 've created a calculation to do that, but now need to evaluate if the result is less than or equal 3 months/ equal to 4-7 months/ equal to 7-12 months or greater than 12 months. I have tried several different combinations of calculations, but am not having any success.

Assume this situation: A repeating text field with 10 cells. A unique alpa-numeric is placed (barcode scan) into each cell. What I want to is to prevent the dulpication of an entry that currently exists in this field. In other words I don't want the same barcode data to be used twice within the 10 cells. Can't quite fiqure out how to do this via field validation and scripting would inpracticle for the specific user. Any suggestions?

I feel like I'm on quite a roll with all the help I've gotten from this forum lately, so I think I'll press my luck with another question. I'm working on a module for my cabinetshop database that makes it easier to pass work orders to the back. It starts out at the front end with a SHOW CUSTOM DIALOG script and ends up with a series of scripted find statements. In the middle of all this is the part where you capture elapsed time on each work order. I have introduced a summary field that totals all of the elapsed times. It works just fine as long as every work order that has been started is complete. The problem is that if somebody has hit the START butto…

Hello I need to flag if a field contains more than 11 characters. The field is called "number" and it needs to be 11 characters or less, if it is more I need to show a dialog box to indicate it is incorrect. How does one do this? Thanks Stan

Hello I have buttons for dates about 30 all with dates on them then I have a button with "..." (the range find symbol) Is there a way for filemaker to go to find mode and when the user clicks the first button puts the result in the find field then and only if he puts in a second button places the "..." symbol there? In other words if I click just one button it finds that date only , But I want to be able to click 2 buttons and have it insert the "..." and even perform the find after the second button is clicked if possible. Thanks STAN

I created a Calc that is suposed to display today's date. The problem is that most of the time the date only changes when the datbase is closed and re-opened. How's is the best way to make this work. I am running FM server on an OSX server, with both Mac and PC users. RET

Hello I need to make a formula that gives us a unique number with a range. The fields are "lownumber" highnumber" and "RANDOMNUMBER" SO if the low number is 001 and the high number is 999 it needs to pick a random number that hasn't been used , I was thinking of adding a field called "USEDNUMBERS" and wondered if somehow it could probe that field and choose. I need help with this one. Thanks Stan

Hello. I'm defining a new file and I would like to have two fiels as identifiers (unique fields) for that file. How is that possible. I don't want them to be unique separetely, but that their association is unique. I need your help. I'm thinking about some calculated verification, bit it really looks like a "trick". Is there some other ways ? Thanks.

I've been searching the forum and still can't find a solution to change the text with-in a text field. Example: FLD Name( Desc) FLD contents( United States of America - Midwest Region) I'd like to change the contents of Desc when it has (United States of America) to just plain ol (US) so the contents will now look like ( US - Midwest Region). I've tried the Replace and Subsitute function with no luck..

Hello outthere, My question, is there an internal filemaker limitation on the numbers of nesting in a subsitute function? Example below. Is it wise to limit and to split up, or is there no known limit to the number of nestings? Thanks Harry (example below) -- Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitut…

I've come back to FM after years of web work using MySql and PHP and can't figure out how to do something that should be dead simple (and I could have done in 5 minutes in mysql and php). But I've been away from FM for so long, I've no idea how to go about it! I've set up a student database at the school where I just started working. I've got a main menu nav page setup with links to the other layouts. What I'd like to do is show a count of students by grade level on the main menu page. Something like: # of 6th graders = 31 and so on through 12th grade. Can't use a simple calculation field because it only works with the current record. Perhaps there's som…

Does anyone have a simple way to validate a field so that entries are only in the format letter/number/letter number/letter/number. I am basically trying to confirm that a valid Canadian Postal code has been entered ?

Is there a way to calc how many days are there in the last week of month by using a date field? i.e. 3/29/2004 is the forth week of the month but how many days are in that week for that month? Answer is 3.

I've just imported a few thousand records from and FP3 file which seems that the data entry was in year 2 digit form, and all the dates of birth have changed to 20** instead of the expected 19** form. I've been trying to find a way revert it to it's original form but as easy as I thought it would be, I can't seem to do it. Is there an easy way that someone can help me with? Much appreciated. Cheers, Murray

I have created a container field in my database with all my customers. The reason is that I want to have my customers logotype in filemaker showed in their record. It works, but when I print the record from filemaker the image turns out to be really bad. The image I import are of perfect vektor grafic quality but when I print it looks like a gif-image from the internet. I have tried to use eps and pdf images. Is there any other fileformat that is better to use? I want the quality to remain the same as the original vektor grafic image if possible.

I am working on a database that captures elapsed time for activities in my shop. I have three fields: START -- STOP -- ELAPSED TIME. The START field automatically enters the creation time when a new record is born. The STOP time is generated with a script that inserts current time into the stop field. ELAPSED TIME is a calculated field: (Stop-Start)/60. Everything works just fine until I cross the midnight hour. At this point values which should be positive end up being negative. For example: If you start working at 11 PM and work until 2 AM you should record 180 minutes. The result I am getting is minus (-) 1260 minutes. I know …

I have two files. One has a record that relates to various records from the second file. There is an ID for the first file that

Hello I would like to change the color of a word in a field because the field contains a specific word. So If I have a field called "color" and the word ORANGE is in the field, I would like the text to become orange. and if the word BLUE is in the field, I would like the text to become BLUE. Is there any way to do this? Thanks STAN

Help! I knew this before, but old age must be setting in. How do I convert a date to a numeric value that can be used in a calculation? (ex. Case(Test Date<= 731573, "Fall Semester 2003",Test Date>= 731574 and Test Date <= 731707, "Spring Semester 2004", Test Date <= ""). I need to know how I converted a date to 731573, for example. I have forgotten. Thanks!

I tried searching for this, but couldn't find anything. It's probably not difficult, I just can't see it. Anyway, I want to limit the input for a field to alphanumeric (letters and numbers) characters only. No spaces, punctuation, slashes, dashes, etc. Any help would be greatly appreciated.

Hello I have a situation where there is a date scheme my predecessor used. For example if it was the date of 12/9/2003 he had assigned a "DATE NUMBER " of 0347 meaning the year is 03 and the week of that year is 47 . I can figure this out but there is a problem I am having ... If the week is in the first part of the year ( the single digit weeks) how can I get the zero placed in a calculation? for example the date is 1/4/2004 I would need the date to calculate to 0401 meaning the 1st week of 2004 but instead I get 041 I could use some help here Thanks Stan

Hello, My problem is, I have 2 time fields, "Begin Job" and "End Job", I also have a number field "cost" I want to calculate (End Job - Begin Job) and * (cost)... But I don't know how to calculate number and time field?? I need help!!! Thanks! Bruno

In one of my databases I have one date field that no matter what I do, displays the date as dd/mm/yyyy. I have tried to change it in Date Format to mm/dd/yyyy, nothing works! Has anyone else had this type of problem? What did you do? -Kate

Hi all I have three files that are used to generate entries for the Examination Dept. The first is Teaching Sets the Second is Student Quals and the Thirds is Entries. I have set up a screen so that in teaching sets via a portal all the students that have been allocated to that teaching set can be viewed. In Student Quals I have set up a Global field called Exam Code that is modified via the relationship to Teaching sets. I have also set up a field called Exam Entry in the Student Quals file. The Exams department run a script that will select all the students in a Teaching Set with a Y in the Exam Entry field (the Y is entered by Exams in the teaching set file v…

A simple problem: I have a field A and a field B I want to create a repeating field (A,: So I create a field C and configure it to accept 2 repetitions Question: How do I set it to (A,:? Tx Alan Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

My database is a list of attendance. Field 1 is the key from the 'type of class' related database and field 2 is from a value list defining if they were 'booked' or 'attended' the class. I have to generate two fields with the result to use in a portal in a related 'student' database. I'm trying to get a count of the different contents of a field (field 2 in the example) only when this field is either "a" or "b" but this count is only to occour when another field (field one) is the same. i.e.(field 2&3 are the result) record 1 - field 1="a01" / field 2="a" / field 3="2" / field 4="1" record 2 - field 1="a01" / field 2="a" / field 3="2" / field 4="1" re…

I have 1 database, with a few fields defined. Date Paid, Amount Paid, Charge, Total Charge, Monthly Charge Date Paid is the Date Charge is a calc of x % of amount paid Total Charge is a total of all the Charge(s) for the date Monthly Charge is a Summary of Total Charge. On the layout I have a Sub-Summary which lists the Date, Amount Paid, and the Total Charge. Everything works fine here. There is also a trailing Grand Summary where I have the Monthly Charge. This is where my problem is. The monthly charge is adding not only the month (Jan) of 2004, but also (Jan) 2003. If I go to another layout and look at the records found, it has only …

I need a priority field for my project to do list that will only allow unique values. I just received marching orders from my client with 17 of 22 projects set to the priority "1-Extreme Rush". (I can't work with this kind of pressure!) I need something more like the rental queue in Netflix where each project is numbered from 1 to whatever the number of records is. AND that can be modified, so that if Project number 3 suddenly is needed sooner, it can be changed to number ONE and project 1 will change to 2, 2 will change to 3, but 4 and all remaining projects do not change. Any ideas anyone? Thanks!!

Hi, I want to configure a number field A to be set automatically to: value of field A in last record + 1 How can I do that? Tx for helping! Alain

Hi guys, i have a rather confusing problem which i would greatly appreciate to someone who can help me solve it. I have a registration ID which must be in this format DPSmm/dd/yy__00001 and so far i have manage to make it work with this calculation method: Prefix &DateToText(test)&" __ " & numberId numberId is an auto enter serial number. The date is retrieved from the date text field and then appended into the ID. This calculation worked perfectly fine if the date is manually entered, but if the date is imported the ID gets cranky, instead of appearing in the describe format the id only manage to show "DPSmm/dd/yyyy__" but the numberId is no…

I have a calculation in File1 based on the comparison of two related values in File2. So, the calc, which returns "1" or "", can't be indexed. I want to get the result into an indexable field in File1 whenever the calc changes. I think I remember a discussion here about a way to automate this using modTime, a calc built on a Case() statement and a Lookup. But, for the life of me, I can't remember the setup, and I can't find the thread here. Can someone point me to the thread or, if not, describe how to set this up? Or, maybe I'm dreaming? TIA

I have a lineitems file which contains both invoices and payments. Payments are PA (payment) and Invoices are SA (sale). It also contains the client account number. When viewing this file from my clients via a portal, it is difficult to tell which invoice has been paid. I want to flag invoices as paid if Invoice# and Type PA and Amount = Invoice# and Type SA and Amount. I assume I need a self join but I'm having trouble separating the PA from the SA. The left should be the SA because there are sometimes several payments against one invoice. Maybe I should have had payments in another file for one to many. Is there an easy way to isolate payments for an invoic…

Is it possible to lockdown a record after a specified time period? For example, a record could be modified until the end of the workday, and then it would be locked, with no further changes allowed to all fields.

Hi I have a calculation field in my Invoices file which I use for my relationship. The calculation field is called jobnolink and contains an If statement. The Exact code is If(Sum(INVOICE_SelfJoin::LocationID)>1 and INVOICE_SelfJoin::InvoiceNu = InvoiceNu; JobNum;JobNum & "_" & InvoiceNu;JobNum) The calculation, seems to kick into place when I click off the record, is there anyway I can make it calculate immediately without having to click a refresh button or go off the record. By the way the Invoice_SelfJoin relationship is based on a field called JobNo and the LocationID is a Number field which has 1

I would like to be able to insert a picture (jpeg) into a container field and have the image show up with a transparent background. Right now when I do this the background shows up white and clips the preceding image if I stack them too close together on a layout. To keep oversize file size small, I would like to insert a reference to the picture rather than the picture itself. I am running Filemaker 6 on a Macintosh G4. I prefer OS 9 but could run OS 10 if needed. Can anybody shed some light on this topic? Thanks. Jarvis :

this might be a stupid question... but... I have a field that is calculating the age of my students. It has "(todays date - Date Birth) / 365" so it always comes up with a remainder. then the feild then rounds it up or down. I just want it to calculate the age only... any remainder is ignored. Any ideas would be great.

I am having trouble converting seconds to hours:minutes:seconds. Does anyone know how to calculate this and save it as a duration in a time format? For example, how to convert 200 seconds to 00:03:20 or 4000 seconds to 01:06:40. Thanks for any help that can be offered. I really appreciate it as I am in a bind. Kirk

With one file, in Browse, I can scroll using the wheel on my mouse for a layout with more than one page. In another file, using the same FileMarker Pro 5.0 application, the scroll using the wheel does not work. What am I doing wrong? Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

I have a category dropdown list which is also editable but the problem is that a number of the options on the list need to be multi select i.e they can belong to more than one category. How can i change the drop down so that it can handle multiple selections? (without having to have mulitple dropdowns or having to add in names with cover more than one category) Any help would be great! Thanks Simon Platform: / Version: XP Pro FileMaker Version: Developer 6 Platform: / Version: FileMaker Version:

Hi all I checked on prior posts by other members but subject appears not to have been covered in the past. We run a rent-a-car operation and I'm trying to find a way to bill the customers using our pricing menu. We have daily, weekly (discounted rate compared to the daily rate) and monthly rates (discounted rate compared to the weekly rate). If someone has used the vehicle for 26 days, which calc should I use to get the rate to be 3 weeks and 5 days and get the total amount that is owed to us by the customer? thanks in advance for your help on this subject Luc

I ask this a couple of day ago, but my post is gone. Strange. Anyway, I have a table and I would like it to show the number with a percentage sign. Instead of .23, I would like to see 23%. How can I do this. I know with a form I can just put the % sign over the box with a clear background. But with a table it seem to be different. Any ideas? Can I set % somewhere in the define field portion? I am sure this is an easy, but I can't currently figure it out. Sorry for by so basic.

I want to be able to allow a user to save a word document, image file, or pdf into a field related to each records. I also have a function where users can send notes to people via email. I have the subject, body, and email address auto entered but I also want to be able to send the attached files from the record as well. Any suggestions on the best way to accomplish both of these tasks?

This is bugging me! I am trying to set up a calculation field for my invoices module. I have a field 'invoice date' and 'today' field. I want to calculate the number of days between the two, but can't figure it out. Any one out there help?

Greetings. I have an FM database with about 1400 records in it, but my I have a field reqNum (request Number) that is 1500 or so, due to record deletions (some users can delete bogus requests). The 'reqNum' field is a Serial number and I want it to reflect the current count. In MS Access, you can compact your AutoNumbers so they all go in order. Can one do this in FileMaker? Go through each record and reset reqNum back, so that each record is in numerical order?

Hi Guys, Need some advice from you experts out there. By the way, im working with FM Pro 6v4 on Mac OSXv3, I have a database that contains the fields StartTime and EndTime. The user can enter 9:00 as a start time and 10:30 as the end time from a dropdown list I have defined. I need to define a calculated field which has the starttime and the endtime and also the increments of time in between by 15 minutes. In our example starttime would be 9:00 and endtime would be 10:30 so hopefully the calculated field would display 9:00 9:15 9:30 9:45 10:00 10:15 10:30 Is this possible wihtout the use of a script? Thanking all in advance …

I can't figure out how to apply a compound interest calc to cuming late fees for overdue invoices. If I could apply a calc to a previous balance, it seems like it would be simple. Problems: While the period is 1 month, not every client is billed every period. Also, payments come in willy nilly and may or may not apply to the most recent invoice, and may not be for the whole amount. I've searched the forum for compound interest examples and come up with a wonderful post by zincb from a couple of years ago, here. This thread also offers a good solution, but it doesn't work for my circumstances. To illustrate, here is some sample data ------------ …

I thought I was smart. I'm not. I wanted to allow each person to select their background color. I put a Graphics file and set up a field called Background as global container with 10 reps. I set an key field as calculation 1, index on and then put same calc in main file but not indexed. My plan was to have the user enter a number in a global number field in main file called gBackground - which would match the repetition number. Then a calc container would actually be on the layout. Something like: Case(not IsEmpty(gBackground, Get Repitition(Graphics::Background, gBackground) I thought I was smart, trying to use the global number in gBackground to get …

Could someone please help me with a calculation. In my database, using FileMaker Pro 5.0, I created four fields, UNIT COST, QUOTE COST, INTERNAL, EXTERNAL. What I want is if INTERNAL is true, than I need QUOTE COST to calculate the UNIT COST + UNIT COST * .13. If EXTERNAL is true, I need QUOTE COST to calculate the UNIT COST + UNIT COST * .30. I was able to create a very crude calculation that worked except if I originally have INTERNAL true and then I change my mind and make EXTERNAL true, the QUOTE COST field will not recalculate. How can I get QUOTE COST to either clear or recalculate when I change the values in both INTERNAL and EXTERNAL fields? Am I…

Hello We have a database file which our members sign in on when they attend our seminars. We are trying to find a way to quickly locate those not coming , and report those not coming in a long time for followup. Probably many of you have done reports like this. I would like to get some feedback on how to go about doing this. So far I am thinking of a grand list of all members and they are automatically marked absent until proven in attendance by signing in . I have thought that the members have a plus or minus. But I am not sure what is the most efficient way to do this. Any and all feed back is very much appreciated Thanks Stan

I have a field that has for example this: 2 Regents Wharf, All Saints Street, London N1 9RL Tel: 020-7837-6433 Fax: 020-7520-8100 Email: [email protected] Web: http://www.gratte.com I want to seperate out the tel, fax, email and web to another field, my trouble is that they are not always on the same lines, I know that I need to use the postion command and "Tel:" but cannot quite get it right. Any help would be most welcomed. Thanks.

Let me explain what i want to do: convert a integer to a string 1 -> A 3->C 28 -> AB 60 > AD 360 -> MV This is easy : dived the integer by 26: this is X and the remainder of (integer-X * 26) is Y. As long as X and Y are less then 27 i can translate both to a character between A and Z. The problem starts with integers larger then 26 * 26 = 676. I have the feeling that a need some kind of recursive procedure. I do not want to create a script because i need this calculation in a Web bsed environment. Could someone suggest a solution to translate integers to sequences of characters. Many thanks Jitse Schaafsma

I'm looking for a program that makes animated gifs. I used to have one that doesn't install and worked great but I have accidently deleted it and don't remember the name. It was a freeware. What do you guys recommend? Preferably freeware but will consider to purchase one. Thanks Resepctfully, TejanoRey

Hi guys, Any ideas how i can convert this date format "2 Feb 2004" to the format of the Filemaker (ie MM/DD/YYYY). I have been pondering all afternoon about how should i go about solving this problem. What i already did was to separate the date, and made it into this format "Feb/2/2004". Please suggest some methods which i can use to change the alphabetical "Feb" to a numerical value "02", and do so for all other months in the year as well? -Pris-

I am an in-house FileMaker developer in a multi-platform (Mac/PC) company. We have an Ethernet network and the Filemaker server is located on the Windows NT 4 server. We still have a few Mac OS 9 and the only way that I could run FileMaker solutions from those machines without using Dave software (we don't own Dave) is to run them via "Open Remote". The solution heavily relies on images and unfortunately, everything works fine except for images. Instead of showing JPEG pictures, it shows an error message inside the picture frame: "Unable to draw picture: picturename.jpg". The images are located on a series of subfolders on a different folder other than FileMake…

Hello and please help..I am so frustrated, I am in tears...really! I cant figure this out and I have been working on it for a week and I have tried everything I know..please help. I am really at my wits end.. HELP?? INVOICES is a database that uses LINE ITEMS database to store all the information ordered on each individual serialized Invoice. The LINE ITEMS database stores the styles ordered in the Portal In INVOICES, related record by related record. In the INVOICES database, the totals for each invoice are summarized, such as tax totals and shipping totals. I have to make a REPORT Database that summarizes the line items ordered by each invoice…

I have db where the users have to choose from 15 fields, each a dept. (dept1, dept2,etc) for each record they choose a dept field, they also have to choose a corresponding field of which there are 9 choices. The records are related by company id. I am unable to combine these fields,dept and level, and have to keep them in their current format to match back to an existing solution. What i need to do is "score" the choices. The user must select 3 of 4 pre- determined depts for a company, and a level to match, as well as 4 more remaining choices. I need to summurize the choices for a company, to show that the required 3 of 4 are met, and 3 addtional, in order to close o…

Is it possible to create a calculation or summary field that will combine the text values in a particular field in a found set? In other words, if record 1 has a field "letter grade" with a value of "A" and record 2 has a value of "B," can I create a field that will return the value "A, B,...etc.")? I already know how to do it with a script, but I was just wondering if there were other alternatives.

Hello all. I've got a simple DB program, and I need to be able to do something, but don't know how to do it. It's developed as a runtime solution. I have some static text with a merge field in it. What I need to do is allow that information to be selected and copied...if I create a global field with the static text in it, is there a way I can insert a merge field into that global field? The end result is the end user being able to copy the entire field to paste into a text document. Or, perhaps a script to export the static text and merge data into a text doc? Example: static text static text <<related::related_data>> I'm pretty certai…

Hi guys, I have a problem, i have this chunk of information below in which i have to retrieve the value of the 'Drive Model Number' & 'Drive Serial Number' and split them into their respective field textboxes. Is it possible that i skip the first line and go to the 3rd line of the passage below and retrieve the details after the semicolon? Any help is greatly appreciated! Thanx! ---------------------------------------------------- Primary Controller - Master drive Drive Model Number________________: QUANTUM FIREBALLlct10 10 Drive Serial Number_______________: 872008050170

i have a master record, which has several smaller workhistory records associated with it. so far so good, a parent and child relationship is fine, allready set up in fact. on each day i want to produce a report of all the work done for a day along with various bits of data from the master record. i underatand a lookup could return the field i want from the most recent record, but i want all the work records for that day, and i want to concatenate those fields into one string field. is a portal the only solution or could i get a script or calculation for retrieve the data??

I have a field with two lines of text in ie Red Cars Yellow Cars How can I remove just the second line of text (Yellow Cars) and put it into a different field still leaving the first line of text (red cars) in the original field. Thanks

Hello I have a text list that I need to turn into fields in a file. Is there any way to automate this. I would like the name of each field to come from the text list I already have. Just asking Thanks Stan

Hi every body... I have a little problem with my DB, I have a Photo DB, and all the photos are reference to a folder which is in C hard disk, but now I shared my DB and the guest users can not see the photos. How can they see the photos? I hope you can help me with this, Best regards Jorge Soriano MEXICO

Is there a way to have a dialog box, where a user can input in to the box itself?

Hi, Is it posible to include a "perform script" option as part of a calculation field? Thanks in advance

hi all, I'm working on a system in which the bankaccountnumbers of customers are entered. To check if the number is correct (actually, if the number is possible, it won't check name with number), I need to make the following calculation (I live in the Netherlands, I'm guessing it only works for our accountnumbers so you might have seen different calculations) the number is 9 digits. first digit * 9 second digit * 8 third digit * 7 etc. The sum of the results needs to be divided by 11. If that number is an integer (a number without a comma) the accountnumber is correct. I've made my calculation in the following way, but I don't know how to check on th…

Hello People! Perhaps this sould be under scripts but I have feeling that right definition of fields might do it. Here is what I have so far: Fields: VendorID ItemTypeID CatID Prefix_ItemID= VendorID&""&ItemTypeID&""&CatID No_ItemID = autoenter serial 1...1 ItemID =Prefix_ItemID&""&No_ItemID This approach works only for the 1st item eg. ItemID = "ABC1" and ONLY IF I want to create another item made by the same A B C (vendor,item type,category) will correctly increment by 1. How do I get arround the fact that I might be creating itemID "CCC1" many records later? Thank you for the help!

I am in the process of creating a database that contains approximately 45 calculation fields. When I define the calculation and hit "Ok" my computer takes about 15 seconds to process the command. What is this a sign of and should this concern my database performance down the road when I have 200 calculated fields. cheers!

Hi, I have two fields that I am triying to put together: "Prefix": 3 letters text "Primary code": auto-enter serial number I have defined "Secondary code" as a calculation field as follows:"=Prefix & Primary code" The problem is that "Secondary code" doesn't show the zeros on the left of "Prefix". E.g. Prefix=ALP Primary code=00100 Secondary code=ALP100 (and I want it to be "ALP00100") Any ideas on how can I solve this problem? Thanks a lot in advance.

Hi, Running a shared solution on a Win XP peer-to-peer network. I want to find the network name of the computer that opened a file. Status(CurrentHostName) will return the network name of the computer hosting the file, and I can parse out the name of the computer on which the file is stored from Status(CurrentFilePath). (Yeah, I know, it should be the same as the host name, but hey, this isn't a perfect world. People do dumb stuff.) Status(CurrentUser) will tell me the windows logon name of the user. But I need the name of the computer, not the user. How can I get this? Thanks, Dan

I want to calculate quarters for a series of date ranges. The following does not work. All records are reported as None for the field. The orginal field "Date" is a date field. Any suggestions? Case( Date >= 09/2/2003 & Date <= 10/31/2003, "Q1", Date >= 11/01/2003 & Date <= 01/16/2004, "Q2", Date >= 01/20/2004 & Date <= 04/02/2004, "Q3", Date >= 04/05/2004 & Date <= 6/25/2004, "Q4", "None")

Hello I have a text field with a date in it I.E. 12/30/1987 I would like to have a field called weekahead with the date of 7 days ahead in that field (also a text field) I would like to have a field called weekbehind with the date of 7 days back in that field (also a text field) When I try to do it I get a no formatted number instead of a date. I need help please Thanks Stan

I previously posted a question about this, but for some reason the thread seems to have disappeared. Here goes again, and I'm attaching a couple of generic sample files. If anyone can solve this one for me, I will reward them with...well, glory and praise. It seems to me like it should be incredibly simple, but I just can't solve it. In my two stripped down sample files, Clients.fp5 and Services.fp5, I've got 10 clients entered in Clients, with unique IDs. Services references these clients by ID, but some clients have different funding over time; in other words, client #1 may have three services paid for by Medi-Cal but then switches to Self Pay. The report (set up …

I have a contact DB and a related DB that holds company specific data. Currently my company has a project in which we are verifying contact information on 500 hundred companies. Each company has multiple contacts. The main objective is to identify certain job functions (Director, manager level functions) What I need to do is after one of the staff has identified 3 out of 4 "Top" functions and any of the three remaining functions is set a "status" for the company as "complete". The related DB carries one record for each company so I'm thinking that I should be able to achieve what I'm after using it. Any suggestions would be greatly appreciated. Thanks

Here is my question, I hope that I ask it properly. I have a related db, 1 file has many records and many of the records have the same information, however, I only need 1 occurance of each counted. I am at a complete loss as to how to accomplish this. It is probably quite obvious, but I am lost.

Hi. I have a system with many related files. A number of the files have a field that calculates whether records have been modified in a given period of time based on the current date. This field is unstored but does appear on the main layout. Each day when I first start up the system, I get a message saying that a date calculation is being performed. This process is long-winded due to the large number of records. The only time that the modification date calculation field is used is when a script is run (infreguently) that does a find on this field. Is the reason that the unstored field seems to be calculated every day at start-up is because the field appears on the a…

I have 2 databases. One database has scores for 800 people. I have a summary field which averages the scores for different groups. I have to know how to round the numbers in a summary field to get a result from the second data base. My other data base has groups of numbers. For example if a group would get a 275 the raltionship with the other database should return 91. I have all the numbers in the second database, but they are all whole numbers. My first database always returns an average score with a decimal. so when I get an average from database 1 of 275.51 it will not return the desired 91. Do I set another field to round the average before the summar…

Hi I'm a novice with Filemaker and I've been having some problems with an existing database containing data. I have an existing film database with a field called 'Characteristics' that contains check boxes with a number of options such as: colour black & white tinted sound silent negative postitive etc. But I really want to have two separate fields, one called 'Sound' and one called 'Colour' and copy or display only some of the values in the 'Characteristics' field so that the field 'Colour' would display only the values 'colour' or 'black and white' or 'tinted' and the field 'Sound' would indicates if a film is either: 'sound' or 'sile…

I have a database with a container field with links to some photographs. I would like to be able to display the link to the file in a text format and was wondering if it is possible to do this with a calculation field. if anybody knows of a way of doing this then please help.

Hi: Im stumped on adding 3 years to a date I have stored in a database. I used the model in the FMP 5 help file and it doesnt work for me at all. Fields are : QualDate (Date Field) and the one I need to calc 3 additional years to is named QualDateExpires (which I made a calcuation field that should add 36 months to the date in field: QualDate and return the result into the Calc field: QualDateExpires. From the example, I've tried this in the calc field: Year(Date(Month(QualDate) + 36, Day(QualDate),Year(QualDate))) I test using 1/1/2004 in the qual date and it returns 6-30-0006 ?? Can someone show me where I've gone wrong?

Hi all, Just curious to see some other options than what I'm currently using. To keep it simple. Product File holds a List price Items are entered through portals in both Quotes.fp5 and CustomerOrders.fp5, related to the same Line Items. Portals set to allow creation of related records. An Order (or an Item in this Order) could reference either a Quote or a Previous Order. 1. How would you set these relationships (QuotesToLineItems and OrderToLineItems), so that even if auto-entered, the new record could be affiliated to an Order and somehow also related to another existing ID. 2. What kind of structure would you adopt into the Line Item to…

I have fields as such: Ticket Number Date District (and others not pertinant) Ticket Number field is auto numbered, cant change, every record is unique. Date field is auto inserted, can change if needed. District field values are selected from a fixed list (CGSD, CASD, JMSD, SEGSD). I would like to keep a running count of days worked at each district and a grand total of all 4 districts. There could be several entries for each district on any day, example: Ticket Number Date District 1 11/03/2003 CGSD 2 11/03/2003 CGSD 3 11/03/2003 CGSD 4 11/04/2003 JMSD 5 11/04/2003 JMSD What I would like to see is that I worked 1 day at CGSD and 1 day at JMSD …

Hello I have a situation where my client has a meeting every Tuesday. In my database I would like to have the field calculate the date of the last meeting until the actual date of the next meeting. Is this possible. In other words if the last meeting was Tuesday 1/27/2004 - everytime I perform the script with the calculation it remains 1/27/2004 UNTIL 2/03/2004 Then it would remain 2/03/2004 until 2/20/2004 So the formula would be based on today. Can Someone help me with a calculation for this baby. Thanks Dave

I have created a REPORTS database that links to an INVOICE database. In the INVOICE database, there are many invoices that use a portal to call upon information from the STYLES database and information that is ordered by making choices in the portal in the invoices is stored in the REPORTS database. This is the problem. I can make summary Reports in the REPORTS SYSTEM of the TOTAL of the LINE ITEMS, which is a calculation that is made in the portal and is stored in REPORTS, but when I need to make a Summary Report that Sumarizes the Totals of each invoice, and tax and shipping, etc..Information that is stored in the INVOICE database, the SUMMARY reports in …

Hi all FM Dev5.5 on WinXP pro I want to be able to set a field to a field value, the users name, when a record is modified, but I do not want to use the modifier name which grabs the username in the FM Application Prefs. I have a login system which the user has their own login and password which is linked to their full name on sign up to access teh system, this all works well, and I have a series of globals to set the current users name in a global field upon login in a Globals file from which to grab the modified record username from when a record is modified. All that seems to be working fine, but I am not sure how to define a 'modified by' field to auto…

I have a database that contains a field that is restricted to exactly 17 characters. There now is a requirement for it to be restricted to either 17 or 18 characters. How do I do this? Thanks a lot for any help...

I have repeat customers and would like to track what they spend each year. I want to create a report that has totals for each customer for 2001, 2002 and 2003. The present fields are: order_count (the number of orders the client has placed), order_amount (how much each order is). I would like to create a calculation field that gives a total amount spent each year so the calculation field would be called "year_total". Thanks in advance for your help - Sam

I need to create an indexable field (lets call it childNumber) in a child file that returns a number indicating the child's position among its siblings (Is this the 1st related record, the 4th related record, etc). Example: Say I have carMake.fp5 and carModel.fp5 databases. I create a carMake record, Toyota. Then I create related carModel records, in the following order: Camry, 4Runner, Celica. In this case, Camry should have a childNumber of 1, 4Runner is 2, and Celica is 3. I've tried creating a number field with an auto-enter calc, count( self_by_parentID::constant_field ) + 1. HOWEVER, that only returns the correct number starting with the second related r…

Hi, Do you know how I can prevent unused blank space from showing up in normal mode. By this I mean the window is always bigger than the database and there is plenty of blank space , i'd like the layout to be as big as an A4 page only and do not need all the blank space...hope you'll understand me!!! Thanx in advance!!