Calculation Engine (Define Fields)

I have my db set up as one record is an expenses(invoice or credit card purchase) and I have a container field that holds the pdf of the invoice or credit card receipt. The user will be accessing this db through the internet. I have it set up when the user opens the pdf file, it is saved to their desk top. Is there ANY other way I can have the user open a pdf file without having to save to their local computer? Please advise.

I have expenses that I approve. Our financial dept. will have a separate File Maker db. On their opening script...I want them to only see "approved" records. So far I have the following... Perform Find [] If [not IsEmpty ( IsAdminApproved );:;""] End If I don't know what to use for logic for result1 ( and is result2 correct? If there is NOT a value in the "IsAdminApproved" field, then I don't want to show the record. Please advise.

I do not know how to get this Case to work. Anyone know how to make this work? I'm trying to round time up to nearest quarter hour, but only if the time is not divisible by 15min. My laymen calc that obviously does not work. Case ( time_field = divisible by 15; time_field; (Truncate(time_entry / 900; 0) * 900) + 900 ) I don't know how to check if field is divisible. Any help will be appreciated, THANK YOU!

Hello gang: I'm looking to acheive the following and would appreciate any suggestions. My current database has a main screen which shows all current years records. When a record is completed it is labeled as closed (check box being checked) and or a field with a drop down box which has closed, pending etc listed). I am looking to be able to exclude or hide all closed records from the main screen when the database is opened. Not sure how to accomplish this. Bryan

I have an FMP9 db that is served on FM9Server. Everything seems to operate normally, except one calculation field (shown repeatedly in a list view) that doesn't show data to some users when more than one user is logged in. Its not a user priv issue, because if only that user is logged in, the data is displayed. Is there a known reason why a second user would not have a calc field display? Its possible that I, as the first user, may have been in a record involved with that field, but that would have only related to one record, not every record in the list.

Hello: I´ve got problems with a database with a container with quicktime movies.If you open the remote in the field container it does not appear the quicktime,object not found. I´ve inserted the movies and I´ve located in a share folder but if you access to the database you can´t see anything. Thanks a lot

I'm a very beginner, so warning if this super simple. I have a table (Items) with 2 fields, "Item Name" and "Item Code". In another, related, table (Orders) I have the same fields. On said Order table, I have a pick list that references the "Item Name" from the Items table. I would like the "Item Code" field to read the "Item Names" field and choose the "Item Code" that matches. As an example, in the Items table, if I enter an item as [Widget] (Item Name) and as [rt657] (Item Code), when I chose [Widget] as the Item in the drop-down list in Orders, it should fill in the item code.

Not sure if this is the correct forum. I have several number fields that are used for inputting Money Figures? ie. $24,500 How do i get Merge fields to display the format as above. When i place the merge field on a report for this field, i am only receiving 24500 with no Currency format etc.

Hi there, So many posts talk about how to get a count of related records. I think I have that figured out, but I also want a count of the subsummary field. I have a contact management database that has a Contacts table and an Activity table. The activity table has a relationship to the contacts table, so that contacts may have one-to-many activities. I have created a report that uses the contact name as the subsummary field, and provides a count for related activities. What I want in addition is a count of the contacts. The scenario is this - the activity table is a list of the different activities that occur for a contact, along with a date/timestamp, …

Global fields seems to be related to the client using them and adding to the field stays as long as the file is open. On reopen they are reset to blank. I have some global fields that I wish all users to see/edit the same all the time. The only way I have been able to partly get around this is to set them on the host file first. Now that I am trailing the server version this is not possible as the host isnt accessed directly. Is this a limitation of globals or is there some other way? Thanks

Here's the calculation LineValueNett = Sum ( QDETAILS.QLineID.QLINES.QuoteID.QUOTES::ValueNett ) This works fine when LineValueNett is a calculation but fails when LineValueNett is a number field (auto-enter by calculation) QLINES is the parent of QDETAILS in the relationship and they are separate tables but in the same file. I replicated the same calcs using a relationship using the same source table (ie a self join) and it works!!! So, is this a bug? Why would it work when the related data comes from the same source table but fails when the related tables are different. More curiously why work for a calculation field but not a number field …

Hi, I am trying to achieve following: I use a field as a button. I want to attach a script to it that will take the value of that field and set it as a global variable. I want to be able to attach said script to couple of fields but I do not want to hard code the field names into the calculation. Something like: Name: $$Field_Name Value: Get (ActiveFieldContents) I need that script to set the value of the field as a variable. Basically I would like to do this if it makes sense and if it is possible. Script_I Set Variable [$$Layout_Name; Value Get (ActiveFieldContents)] Script_II Perform Script ["Script_I"] Go to Layout [$…

Dear Forum! Okay I have a REAL Goodie question that I would love the forum to tear its hair out over. : I have the following need. In my FM File I have 5 Text fields. They are used to print a report. The report is given to the boss 5-10 hours later, and if all is okay on the report, the boss signs it. The report MUST remain editable during this time because there may be changes and the report may need to be reprinted. When the report is finally signed and all done, the secretary must "seal" the report and "generate a PDF from it" (that part is easy). Problem: I must guarantee, that "what is sealed by the secretary" is still ****exactly*** what…

Hi, I have a list of fields, but some of them have no information. I wish to auto enter when there is no data. For example under the field 'Connectivity:" I wish to enter USB 2.0 and under 'Weight:', I wish to enter 'Not Known' . I would only wish t do this when I don't have the data/info I know I'm being thick, but have tried using the calculation under options and can't get it to work Thanks in advance

Hi this might be tricky to explain but here goes I wish to produce a number result which is probably easiest if I use a graph as the example. y axis (rating) steps 0 to 4 x axis (years old) 0 to infinity but realistically say 100. I have the x axis numbers and require the y as a result. If the results were plotted the graph would look like a log curve with 0 years="4 rating" and 100 years approaching "0 rating" 25 years would represent the mid point (ie rating 2) view example of graph Anyone know how to code this? thanks in advance

Hello, I'm trying to use GetValue( list ; num ) in an auto-enter calculation where num equals a number in the field's name. For example, let's say the following calculation is in a field named log2_data: Let([ val = Filter( Left( log2_data; 5 ); "0123456789") ]; GetValue( otherField ; val ) ) What I want is for this field to get the second value as indicated in the field name, but the current calculation is looking for the contents of the field. Of course I could just put the field name in quotes, but then I'd lose the flexibility of that text updating itself should the field name change. Can anyone show me how to mak…

I have a typical auto-enter unique serial number field in a table that has data copied and erased at the end of the day. The new day starts with a new record and I need to set the serial number back to 1. It would be better if this were done via a script but I could live with doing it manually. Thanks for your help

Hello, I'd like to concatenate the contents of a field from all the records in a found set so I can use the concatenated data as the body content for an automated email. I'm unsure of where to start for creating the calculation in the concatenated field. I can apply it to the email once I've got the calculation/script but need some direction on the creating the concatenation. Any ideas? Thanks

Not sure if this belongs here - could not find a better place to put it. Would this be a good way to Void records? Have a script copy the entire record to an unrelated table and then delete the record from the table in which it was Voided. After deletion the script would make a new record with serial number of the voided record and append Void at the end (Serial_Number & "Void) so that when regular records are browsed through a user can see that a record was Voided and then they can look it up in Voided records table if they need to. Reason being - when record is Voided it should not affect any calculations when checking all of the records (Show all re…

I am importing data to a revised solution. Whilst doing this I'm also converting all the relationship keys to strictly numeric, whereas the first version had text/number combo - so I'm just going to use the number part. After import a re-assign the serial fields with a GetAsNumber to strip the text and use a proper number. The last step, to reset the next serial value: Set Next Serial Value (serial-id; Max (serial_id) + 1) does not work. In fact it persists in returning the serial_id + 1 of the CURRENT RECORD. The workaround is to go to the last record of course (as shown in the help system) but the syntax for the calc is correct - FMP just won't do it…

Hi. I'm trying to work out how to add a 'simple' three-state button to the top of a layout, using a container field with three repetitions. I'm trying to glean the technique from various threads here, but I'm getting nowhere... I've attached a couple of the 'states' as graphics. I assumed I'd be able to call up a repetition with a script attached to an invisible button, but... Any help appreciated

Data Base tracks contract payments. Displays payment schedule in a portal. I need to sum the total where The Date paid is empty as we do not track the payment amount to use in the calc. Lets say there are 12 payments scheduled. The first 3 have been marked as paid by entering the date in the date paid field. I would now like to count the number of Empty Date paid fields and multiply that by the payment amount field to arrive at a balance due. Hope I made even a little bit of sense. What I can't figure out is how to count the number of records that have an empty date paid field.

Is there any way to include a return character in calculation text strings that browsers won't choke on? There's the pilcrow, of course, but this resolves to a "gremlin" as far as BBEdit is concerned. When exported to text, it's not considered a return at all but some sort of non-standard, unreadable character. Simply including a return inside the quote leaves a single space, and backslashing one doesn't seem to work either. I'm thinking some kind of ASCII character code or HTML entity, or perhaps there is a way to encode the exported output?

Here's a little bit of background on a section of a FileMaker solution that I'm working: I have a table that holds all loan-able equipment (like a library but not with books). Some equipment has serial numbers, like external hard drives. And some equipment does not, like chairs. (Don't ask me why. I think they should have serial numbers for everything, even if they need to make them up, but I'm not in charge.) In order to accomodate such different equipment in the table, I have two fields: Serial Number, and Quantity Now, here's what I want to figure out how to do. Since the Serial Number field isn't mandatory, I can't make it a unique ID. BUT, …

Hi: I have an SQL table I am pulling data from. I have multiple values in single fields I want to export as seperate records. I have created a calucation field to make a tab seperated text string. The idea is to export this single field for each record and this field would export as if it were 2 records. The tabs are recogized when the exported but the carriage returns (pilcrow in quotes or without quotes) appear as square blocks in the TAB file I am creating when a return is needed. Calc Field: Case ( RepCounts = 2 ; SplitRep1_Name &" "& Round ((dec_sizeValue * SplitRep1Percent);2) &" "& Round ((Net * SplitRep1Percent); 2) &amp…

Hi, I have a valuelist with 10 names of staffmembers. Each member has it's own button with some script attached to it. I would like to when i change the valuelist, the names on the buttons change too. Is that possible?

My wife uses my solution, and she has an annoying habit of typing an extra space after every single entry to a field. I would like have the validation calculation give a message each time a user does this. I've tried the following, but it does not seem to do anything and I have always validate checked: Left(My Field Name; 1) <> " " Any ideas (besides marital counseling -)) ?

Hi everyone...lost on how to resolve this. Using the GetAsNumber ( P# ) to convert (for example) 012345 numbers ("P#" field) to 12345 or 001234 to 1234. This works great. The problem comes in with some (P#) that are three digits 000123 and GetAsNumber removes all zeroes and shows 123. We need to *always* have 4 numbers (so it should be 0123). So anything that has three zeroes needs to return 0xxx (to make it a four digit number from six) and everything else just needs to remove the one or two zeroes (xxxx or xxxxx)from the six digits. Any ideas how to resolve this? Thank you in advance!

I have 2 databases linked together, one is a calendar, the other a contact manager. I want to have a field called "Reminder_c" show the data in field "Title" located in the calendar, but only when the current date is equal to the date set on the calendar for "Title". So when it is Feb 28th 2008, if there is an appointment in the calendar for that date, it will show up in the field "Reminder_c". Any advice?

In my database, I enter demographic information on individual customers based on data they supply. The database contains the fields "age" and "birthdate." I am aware that "age" can be set up as a calculation field based on "birthdate." However, I do not have the date of birth data on all the customers but I do have each person's age. I therefore set up the field "age" as a number field with auto-enter calculation (using "birthdate" to calculate the age of the person). In this way, the field can still be entered and the age entered directly if the date of birth is unknown. (obviously, can't do this if the field "age" is a calculation field.) My problem is that the f…

i have a contact database, it has leads, clients and referrals. when you are in the referrals section, i would like a count of all clients and leads that have the referrals name in their referral section say im in 'tommy' and he is a referrer. it will show 24 people he referred based on everyone who has 'tommy' in their referral field. it would be awesome if i could do it by a month to month basis, based on their creation date. and have that data go into a portal.. yea?

We have a sales order system. The Sales Order Numbers are Serial Numbers. Somehow there are times that the Sales Order Numbers will have gaps in them, ie Serial Numbers will disappear. I have a feeling that the records are not being saved or undone. 1) Anyone know how this might occur? 2) Any way to prevent this from happening? Thanks in advance. I will follow up any additional questions.

Hi. Can anyone tell me if it's possible to create a field that contains a list of images (icons), as opposed to text? Example 1: I have a record layout that needs to show the "status" of a given record between the values "open", "pending" or "closed". I'd like to offer the user a pop-up list of green, amber or red dots, rather than the words themselves. Example 2: Instead of choosing between value "Buy" or "Sell", I'd like the user to choose between a green [color:green]UP arrow or a red [color:red]DOWN arrow icon — and have the result be the only icon visible (as opposed to some radio button solution... Does anyone have any wisdom for me? Many th…

is there a way to set up a calculation to get two values of text from two fields into one. for example field a + field b = field c fast + ball = fastball any help would be greatly appreciated.

ok heres my problem... I want to display the total number of days absence one staff member has had, each staff member has an individual ID and in the table and I have a column called days taken (which shows how many days were taken when that person was absent) I've tried using a summary to do this but so far its summarizing the entire number of days absence instead of for each staff member despite sorting the summary by staff ID does anyone know how i could possibly achieve this?? thanks IA for your help :

A couple of months ago, comment helped me out with a custom function for calculating the next work day given a start date, interval and list of holidays. My goal is to add the interval and then push the date until it results in a non-weekend, non-holiday date. Unfortunately, I just noticed that the custom function doesn't count weekends and holidays. I would appreciate any help modifying the CF so that it counts weekends and holidays and then pushes the date as needed. Thanks. NextWorkDayTest.zip

Hey guys I was just wondering, in the database that I have attached, how would I make the RATE(P/H): field change depending on what is selected in the MACHINE: field at the top. So for example: Excavator - $300 in rate field Tractor - $200 in rate field Hummer - $150 in rate field PCI-200 - $100 in rate field Honda - $180 in rate field Telsa - $200 in rate field Can someone give me step by step instructions on how to do this as I'm kind of a newbie in Filemaker. Thanks Runsheet.zip

Hi all, I have a database for scheduling panelist at a multi-day conference that consists of 3 tables (Panelists, Events and a Join table) Each panelist lists the earliest and latest panels that they can attend on the various days of the conference using 6 fields (FridayEarliest, FridayLatest, SaturdayEarliest, SaturdayLatest, SundayEarliest, SundayLatest). I want to use a calculation field to give a warning when a panelist is placed on a panel that is not within the range of his acceptable times, but I am having difficulty coming up with a calculation that will work. Any and all help will be greatly appreciated.

The personnel table includes a repeating field where up to 6 required training courses (Courses Taken) that have been completed may be entered by dropdown from the course name field from the Training Courses table. In the Training Courses table, there is one record for each course and each course has a unique name (Course Name) and also a field for frequency required (e.g. once, annually). In the Personnel table, I can't seem to get the repeating field Frequency to pick up the frequencies from the Training Courses table, although I do have a relationship between the two tables linking Courses Taken and Course Name. The desired result in the Personnel table …

I am trying to calculate the number of specific work days for a given month based on scheduled days off in a week for employees. Input: normal days off (tuesdays and wednesdays) Month: February Year: 2008 Result: Number of work days in month for employee Any help appreciated...

Hello everyone I am a complete novice trying to design a database to control the distribution on stock between 7 locations. One field in the database, which is there for my benefit, is a sequential number which increases by one with each new record. Each location also needs their individual stock allocation to be numbered sequentially. How do I design a second field, which will take the last number used for any location and add 1. Any help, advice or a pointer to a specific url or tutorial would be gratefully received. Thanks in advance. Milt

Please can someone clarify this for me: What's the difference between setting a field as a lookup to a field in another table AND Making that field a calculation (in a text type) to be = to that other field? Here's my problem. Initially I need the field to lookup the values from the other table, but I only want that to happen once, once those values are in the new table I want users to be able to change them without risking loosing the changes when the original field is reselected. e.g. When an activity is selected from a list (TABLE:Program), the activities default resources are stored in TABLE:Program from TABLE:Activities. The users can ad…

Hello everybody. I wonder if I could do this: Sample: 1) I have a found set of 10 records 2) With a calculation field I would like to write the contents of the 10 found records in to a field. Is there a way to do that? Any help would be appreciated. Thanks, Greg

Right, I have data that will becoming into a database form 2 csv files. (basically 2 distributors). They both over lap on supply to customers, but don't use the same name scheme. So one could be Fred Bloggs Hospital Birmingham The other could be FB Birmingham. What I need to do is to add a second field that pics up certain aspects and creates a field that is then common to both. Say it pics up F B Birmingham, and looks up and know that is Fred Bloggs Hospital Birmingham, and writes it into the new field. This would then allow me to search both sets of data in the filemaker file, using a common refference. But I can get it to work. Chee…

I have built a 4.000 pictures database (the pictures are only referenced, not stored in the database). If I move the referenced container field image to a new folder it obviously disapears from the FM container field. I would like to edit the link in order to be able to move the pictures from my local disk to my Lacie external disk. avoiding to re-attach the file by navigating to its location in the appropriate dialog, picture by picture... I have made a test using ALIAS but it seems that the so called pointers bypass it. Is there a way to access and then globally edit (with a script ?) the referenced external image path to allow for the images to reappear …

I have a project start date and end date, and I'm trying to calculate the remaining time (based on the current date). Not much success yet -- any thoughts? Thanks, Jason

I have a portal that is based on a self relationship. When I click on a field in the portal, I would like two things to happen: 1. Go to related record and stay in the same layout (this part I get) 2. Have the field in the portal change color (is this possible?) Thanks, Jason

I have two layouts, one is an "Address Book", and one is a "Job Log Book". In the Job Log Book I select the owners name from a drop down list with the owners name from the address book. It also brings the Address, Stae, Zip, and phone number. When I select a an Owners Name, It is to bring the other fields over as well. My problem is that it won't bring the other fields over until I select the Owners name a second time from the drop down list. How can I get it to bring all of the fields over at the same time? Thanks

Hello. I'm using FM 9.0. I'm not sure if this question should be in the Value Lists section or not, but here goes… I'd like to create a form that will let me put a different photo in each record. So far, I haven't figured out how to do that. Is this possible? If so, can someone tell me what the procedure is, or perhaps point me to a tutorial or demo on the web? Thank you! Jd

I am trying to use a single serial number sequence for two things. When I create a new record, I want a Dec_id number to auto enter the same number as an auto enter serial field (job number). No problem. Then, I want to be able to set the next serial value from that sequence in a third field. I have tried every way I can think of with the "GetNextSerialValue" function I can think of with no success. I suspect I have my syntax wrong, but have not had any luck finding my mistake. test.fp7.zip

The setup: I'm in the process of building an invoice system for a computer repair company. On the actual invoices some products are covered under warranty and have a custom code for the total. Some products leave the shop with no charge, which also has a custom code. Everything else has a dollar amount. I have a Total field which is defined as text so that the custom codes can be entered. The majority of time there will be a number total in $, but sometimes there will be the custom code. Thus the text field definition. The problem I'm having is that I can't seem to get the calculations to keep the trailing zero on amounts like $89.50. I don't want to write a huge c…

I just noticed this when I add a calculation reference in another calculation: Case ( ${ALERT: Test Due}="True"; "Test Due"; ALERT: Paper Due="True"; "Paper Due"; ) So that ${ appears in front of some but not others...any idea what it is? If I remove it, it won't work. I couldn't find an answer searching quickly...thanks!

Hey guys. I've got a field which is used to pick a machine, and when a user picks a machine from a pop up list, I want to automatically put the rate per hour into the rate field. How would I do this step by step?

I have a drop down menu 'CharityChoice'. If user chooses 1 of the options, I'd like to populate 'PaymentName' (text box) with a name and address. Here's what I have but FM is giving me an error that says " the field 'SalvationArmy' is not found" It would also be nice to add carriage returns in the address. Thanks in advance for your help Substitute( CharityChoice = SalvationArmy , Salvation Army 123 So First St SLC UT 84111, CharityChoice = RescueMission , Rescue Mission 555 2nd st SLC UT 84372 )

Hi, forgive what must seem a newbie question, but this is driving me insane! In FM4 I had a load of databases which quite happily worked with dates in the European format (dd/mm/yyyy) instead of the illogical US system (mm/dd/yyyy). But having converted to FM Pro 6, all my dates have reverted to the US format! I have looked in Preferences to reset to UK defaults - there is nothing there. I have tried Field Format - no, nothing there either. It will allow me to format the date field any way I like (e.g. like the OS X System Preference pane) AS LONG AS it is in the US sequence. Then I tried a Custom format, where I specified the date should be "28" "-" "01" …

Hello everyone, I need some help here. I need to force the user to enter "4 characters" (no more and no less) in a field. How can I setup a calculated validation for the field? Thxs :

Hello, and thanks in advance for your help. I have a template file I'm modifying and there is a field that can't be modified. It is linked to another table (contacts) in relationships. It is not optioned to not be modified. It is a contact number that is created for each customer and a new contact is created. I do not want to create a contact for each customer. I WOULD like to enter a contacts number and have their info populated though. Thanks

trying to sum a bunch of repeating entries of the same field. should be simple but I can't get it to work...

hello, I have a portal set up in my client bank that shows invoices and their totals. one client may have several invoices so the portal displays that. I am now trying to add up how much this client has been invoiced. so in other words I am trying to get a sum of a certain field, depending on the client ID. Am I looking for a "conditional sum calculation"?? : Not sure... Can anyone help?

I have a drop down list on my layout however it's a bit naughty and doesn't behave as you'd expect it to. Here are the settings I want to apply to it: * The user cannot enter something into the text box, he can only pick from the value list I have set up * If the user tabs to the drop down list, pressing the down/up arrow will cycle him through the options available (like in Windows drop down lists). This will be much quicker for the user.

This should be simple enough but I can't figure it out. I want Field A to be Checked against Field B and changed if it is a lower number. If A is lower then it automatically becomes B. I'd like to do this without any popups or error messages... IF (A > B; :

HI All, I'm working on upgrading a FileMaker 2.0 flat file solution. The company has been using it for 14 years and have always had a problem with duplicates. I'm using FileMaker 9 Advanced to upgrade the system and would like to be able to catch possible duplicates during data entry. I have created and indexed, text calculation filed that combines last name and zip code. I used this filed as a self relationship, but am stuck and am not sure how to proceed. If a dup is found, I'd like the user to get a custom dialog message telling them that the current record could be a duplicate and that they should do a search to be sure. This way they will only have to search if …

My database has an age calculation field, which works fine. I enter the DOB: 8/1/2007 today it will display 1 Y, 0 M I need the calculation to display the age that the person will have in October 1 How can this be accomplished? GetAsText(Year(Get ( CurrentDate )) - Year(DOB) - If(GetAsNumber(Get ( CurrentDate ))< Date(Month(DOB); Day(DOB); Year(Get ( CurrentDate ))); 1; 0)) & " Y, " & GetAsText(Mod(Month(Get ( CurrentDate )) - Month(DOB) + 12 - If(Day(Get ( CurrentDate )) < Day(DOB); 1; 0); 12)) &" "&"M" I appreciate any help Thanks.

Hello, I figured I would ask the experts this question. I thought the scroll window function would be simple, but I have run into a problem. Example - Layout A is set in form view, Layout B is set up as a columnar list/report view. Layout B extends 6 pages with various test questions. I want a script designed to take me to a particular question on Layout B. I cannot get this to work. I do see a calculation option in the scroll window step, but cannot figure it out. One other note, I have an existing script in place when layout B is opened, so the current record is in view, the script is set as the following, "show all records, omit record, show omitted only." Your …

Hello. I put to an icon the action of "delete portal row". It was working in the beginning but is not working anymore and i dont remember what i did. Can somebody tell me the reasons why maybe is not working? thanks

Is there a way to prevent FM clearing my Global fields when I exit the application?

Greetings I am in the middle of quoting for a potentially massive deal. The project, thus far, has 7 very extensive quotes. My first quotes were submitted in November and since then we have experienced changes in the exchange rate as well as changes in product pricing. I have a huge meeting on Wednesday (which I was only told about today) and I am hoping that there is a simpler way to duplicate my quotes instead of copying and pasting each line item into a new quote. I specifically do not want to make the changes to the original quotes so that I have a "Quote History" to fall back on if and when needed. Can anyone assist with guiding me through the process…

My question is very simple. How, (step by step), do I embed a file into a container field. I don't wish a reference since the reference is dropped if I move the files. Thank you in advance. Perhaps I am not being clear. After the insert with no reference I can see an icon of the file, but how does the user open the file?

I created a graphic representation of data using a container field. It shows up quite nicely in the browse mode. When I go to preview, and print, no graphic. What am I doing wrong, or not doing that I should? I'm using FMP pro advanced 9.0.3 Thanks for any help.

Hi. I am completely new to FileMaker as I have just moved to a new working environment. I am not very sure if I am posting at the right place but here is what I need help when trying to learn more about FM. I have created 2 simple tables: 1) Product Catalogue 2) Invoice I have 3 fields in Product Catalogue: 1) Product Name (text) 2) Product Number (auto-generated serial number) 3) Price In invoice, I have: 1) Product Number (text) 2) Product Name 3) Price I am hoping that I can key in the product number in the invoice, and have the product name 'appears' on its own, based on the table "Product Cataloge". I have tried to apply relations…

Hello everyone Here's the challenge, I need to be able to add numbers together within a field i.e. "27" = 9 or "11.2 11.7" = 4.9 basically reducing the value to it's simplest number. I'm not that well versed in math calculations or formula's but there must be a way to do this in FM?! FYI, This will be used in a Lab for determining patient results, but there will be many values (that need this calc done on them or the whole thing is a bust) within a table. Thank you Arthur

Hi! I've put global containers for each menu title, that captures the corresponding icon in the graphic table, but they dissapear when in Find Mode. Does someone know the way to keep them visible when you go to Find Mode? I'll appreciate any help on this. Tks.

I have a layout that I get Name, address, city, state, Ect from another layout. When I select a name from a drop down list it doesnot refresh the other fields until I select it a second time. How can I get it to work just by selecting the name from the drop down field?

I'm creating a table to track "Mailing" Mailing can be several types, so I have a field for "types" and this is set by a specific value list ( Letter, Cards, Brochures) Another field is the number being sent. So far it been really easy for me to get a Total of the Mailings:Sent field but I want be able to break this down by their types. This is were I'm struggling. Please point me in the right direction on this one. It seems like it should be easy but it passing my by. All suggestions are appreciated.

Hi Everyone, Do you have any suggestions as to how to create a voting or rating system in FIlemaker? I'd like to have users vote for or rate certain entries (Jokes, actually!). Then at the end of the day, send out the winner with the most votes. Any suggestions welcome, thank you!

Hi, I am trying to create a summary of items that are marked "OK for Press" during a certain time frame range. Ideally, I'd like to be able to view a summary page that would tell me how many items were approved for each week. I tried this calculation that is then counted in a summary field, but it's not working: If (approved = "OK for Press";1;0) & (approval_date = Date ( 2 ; 11 ; 2008 ) & "..." & Date ( 2 ; 17 ; 2008 ) ) Thanks in advance for all of your help! I appreciate it! These boards are great.

Hello all, I wonder if someone can help me with this. I have field1 that has text like "The shiny red car went fast" I have three other fields that each have a word like: 'shiny' 'car' 'fast' Since those 3 fields match words in field1, I would like to do a calculation that assigns points based on the amount of keywords in field1. In this case each of the 3 words is worth 10 points so my calculation field would equal 30 points. What I'm not sure how to do is to match the keywords with the line of test. Hopefully I explained this right and thanks in advance for the help. William

Hello I have a field called " startdate" I would like my database to automatically delete the record containing that date one year later. without any dialog. What is the best way to do this and not involve the end user. Kind of a hidden function. Thanks

I'd like to change a field colour with conditional formatting if possible by using a calc on Date Fields that will flag weekends (Sat/Sun) and Bank Holidays as Colour Red etc. Is this possible? Thanks

I have a calculation which counts the number of days End Date - Start Date I need the calculation to ignore weekends. If the number of days is 8 but two of the days are on a Saturday and Sunday, the calculation should return 6

I have a FM system for reserving multiple calendar days for a single workshop. I would like to generate one field that displays the title of the class as well as all the associated dates, this way I can insert that total value into an email body field and send workshop reminders. It should look like this: Workshop 1 Jan 2, 2002 Jan 8, 2002 Jan 12, 2002 I can generate portals, I can do complicated copy and paste scripts to get it all, but I there just has to be a simpler way. Any thoughts? Thanks so much!

I have a database with 2 primary tables – People and Apps. A person can apply for Round 1 and Round 2 or just Round 1 or just Round 2. A persona can apply for Round 1 two times with different details, etc. My dilemma comes around with this logic- if a person submitted for Rd 1 and then again for Rd 2, we need a report on file for Round 1. If a person only submits for Round 2, we don’t need a report as there is nothing to report from previous rounds. So how do I do a calculated field that says is Rd 2 the first round applying for? Thanks in advance.

I have a GlobalField where users type in a project number and then all associated project records are returned. Example A user types in 99112 in the globalfield and this returns all Project 99112 records. The Project_Id assosciated with this Project No. is 001. I now want users to be able to create records. When a user creates a record i wish to have the project_id number inputted automatically. So if a new user creates a record, i'd like the project_id field to check what project number was inputted in the Globalfield and return the correct project_id value in the field. Is this possible? Trying to work it out here with Set Fields etc. but can't get i…

I hope someone can help me with this. I have two tables, People and Complications. Each person could have a varying number of complications. Besides viewing each person’s complication information through a portal I will need to also show the FIRST time a person’s complication grade is at its highest level (range is 1 – 5 and Type is irrelevant). For example the portal data would look like this: Grade..Type....Start.....End 2........4.......3/1/00....6/1/00 2........5a......1/1/02....2/1/02 1........3.......5/1/02....9/1/02 4........1.......2/1/04....3/1/04 2........1.......3/1/04....4/1/04 The returned result would be Grade: 4, Type: 1, Start: 2/1/04, …

I have a date field called CNTDATE and I require a field that displays the following: if the day of CNTDATE falls between 16th and the last day of the month ,it shows the day as the 10th and the following month ie (CNT DATE = 18/1/2008) Result = 10/2/2008 but if the CNTDATE day is between 1st and 15th (January, for example) Result = 25/1/20008 here is what I have so far for my "calc" field: If (Day ( CTNDATE ) ≥ 16 ; Day ( 25 ) & Month(CTNDATE +1 ) & Year ( CTNDATE ) ; Day ( 10 ) and Month ( CTNDATE ) and Year ( CTNDATE )) Calc result is DATE can anyone show me where I am going wrong and should I have the field as a da…

I have two tables that have a "1 to many" relationship by an "ID" field. In the "1" table, I want to have a field that will display all the "name" fields in the "many" table, seperated by carriage returns. I cannot use a portal for my case. I believe I have to create a calculation field but I am unsure about which functions to use. Thanks in advance! ~ Chris

Hello. In my company we have meetings, every tuesday night and three times on saturday.I want to know how can I record if the members that are in my database have come to every single meeting in a fast and comfortable way. Thank you.

Hello, I'd like to "force" users to finish entering data in fields in a secondary window, that was brought up through a script. I would like to keep them from activating/going to other FM windows. The only way out would have to be through an "OK" button. Is there a way to achieve this ?!

My calculation is as follows: GetAsNumber (Appointment Type). I cannot figure out why my GetAsNumber function keeps returning negative values. For instance, the following text: Diagnostic Interview (90801) returns the value of: -90801 and I want it to return: 90801 Any ideas as to what I'm doing wrong? Thanks in advance!

I have a field called GraphicAlerts with 5 repetitions. This field does not contain any 'usable' data, its sole purpose is simply to display graphic 'red flags' to the user when certain criteria are met. Q: Using a calc formula (not a script), is it possible to specify which repetition to put the graphic into? For example: If( IsEmpty(Date); get the arrow graphic from gGraphicsContainer and put it into repetition 4 of the GraphicAlerts repeating field ; "" ) Hope that makes sense. Suggestions greatly appreciated.

I want to know if there is any way to have an organizational chart in FileMaker. I am using filemaker 9

I have a container field that I inserted a PDF file (reference to file) however when I click in the container it does not open the file (or short-cut to file) what am I doing wrong?

I have a week number that I want to convert into the (monday) date that week begins on. Like next week is week 8 so i want to generate Feb 18, 2008, like it looks at the top of a quickbooks web entry. Its easy to go from date to week but this way isn't clear.

I'm in the process of splitting a table containing images and their descriptions into two separate tables (for performance reasons). In looking at design alternatives, I've come up with these considerations: Parallel Tables (pure, no links) Depend on GetNthRecord(Image)::GetNthRecord(Description) Requires meticulous record-level operations on adds/deletes Parallel, but singly-linked Include associated image record number in description Both tables substantially "ordered / sequential", which would enhance performance After-the-fact processing could confirm and restore proper relationships Parallel, doubly-linked Same advantages as above, but w…

I am having a problem getting jpg or png images to appear in a container field, but only on a PC. They appear fine on a mac, but on the PC the container is field with a message regarding a Quicktime decompress that is needed. This is not an issue with just one PC, but every PC that I have tried. Is there a standard that works on almost all PCs? Note that when insert a jpg or a png into a layout it works just fine, it is only when it is inserted into a container...again it is fine on a Mac. Thanks in advance.

Hi I have layouts that a different size. I wondered if I could somehow script a calculation that dictates the size of the window whenever I go to a specific layout? If it can how can I do it. Say I have 2 layouts "layout1" and "layout2" When I go to layout1 I would like the window to be small when I go to layout 2 I would like the window to be big. It must be something like If Layout = "layout1" then. kind of thing Looking for an answer

I hope I've posted this to the correct forum. I have inherited a database. It is a contact manager. The main table contains People. There is a related table to show contacts (any activity related to that person - phone call, email, meetings). Each activity record has five subject fields - Subject 1, Subject 2, etc... These fields are populated with codes. We have a third unrelated table of Codes which contains the Code and a description. So, an activity can have up to 5 codes - one per subject field. I would like to generate a report that summarizes the codes that have been used during a certain date range, or by a certain staff member (each activity i…

As a relative novice, I would like to request help. What is the syntax of AND/OR functions? I am unable to find this in the help directory. crkorrol

Hi all, New to this forum, I have a question that I would need an answer to, in order to proceed with my project. Is there a possibility to block data entry/modification of a (text) field, conditioned by the content of another (text) field. Say, if field A contains the value "no", field B becomes unmodifiable ?! I hope the question is clear, and I thank you in advance for your help. Amicalement, Jan Bayer

Hello, I would like to create a calculated field where it is the current date "-" serial number starting at 1 and incrementing by 1 through the day. ie. 02/23/08-1 then 02/23/08-2 etc through the day. next day it would be 02/24/08-1 .... I cannot figure out if you can re-initialize a counter for each day... or is there a different way to approach this? thanks in advance,