Calculation Engine (Define Fields)

I'm working with a table view for the first time. I can't seem to get the footer part to show up at the bottom. Thanks, Mel

I have my DB set up as multi-user, and up to this point three of us have been able to share it. We've recently replaced our useless idiot assistant with a delightful qualified assistant, but now, even tho the DB -- from both her computer and mine -- is set up as multi-user, it cannot be shared. Once one of us opens it, anyone else trying to get in will have that dialog box saying that the DB is set as single-user and cannot be shared. We will be moving to FM8 soon, but it will take a while to convert everything, and these DBs need to be shared by all of us at the same time until then. Any suggestions as to what this might be? Thanks!

i dont know how to use function filter plz anyone help me with example file thz

I have an advertising database for classified ads. I have it calculated to figure out the income each month. However, some of the ads that I have do not actually run. Is it possible to create a field to make the ad active or inactive? IF so, please instruct - I am very very new to FM Thanks in advance!

In my table, I have three container fields. I have a fourth Calculated field, which using a case statement and numeric values in other fields, will set itself equal to one of the three container fields. Eg: Case(Value=1; Image1; Value=2; Image2; ...etc) This seems to work fine when the application is accessed through FileMaker. The probelem arises when trying to view the calculated field through IWP. I just get the "broken image" icon. Can you not use a calculated field set to return a container type inside IWP? Any help would be appreciated.

I have a field that can take text values from a predefined list. I would like to count the number of times that each value of that list is selected in all the records in the database. Basically, it is like getting a histogram of the values in a certain field. Any suggestions will be appreciated. MD

My "city" field in my contact database obviously has many cities. After creating a found set of records, I want to be able to show the name of each city represented with the number of records that match each city. Such as Scottsbluff - 13 Gering - 7 Chadron - 9, etc. How would I accomplish this? Thanks! David

I need to find out how many records have the value "Walk In" or "Repeat Customer" in my T_GuestType field that is populated by a custom value list. The goal is to produce my salesperson report and show how many transactions came from walk in guests and so forth based on the values in the Guest Type field. This is a Count [color:blue]( Transactions::T_GuestType ) function is it not? Only, how do I get the calc to sort out the items in the field and then return a count based on that info? I tried this with no reward... [color:blue]Count ( Transactions::T_GuestType )= "Walk In" Do I need to do a Case calc? Appreciate the help. PF

hello! i want to know how can i, when i click a radio button some text will show and when i click it again to uncheck it the text will hide or get disabled, even if i can do it with a button, how can i do it? thanks!

hello! i have a "members" table and a "team" members. I want to make a layout for each team showing the members that are in that team. And if it is possible a button next to the name of the team member so the person can go to that team member layout. How can i do that?! it would be of a lot of help! thanks!

Hello! i have one field called "studied" that has a value list called "subjects", i have another field called "completed" with a "yes/no" value list. I want that when i click on "yes" on the "completed" field, all the checkbox in the "studied" field to be checked, and if i click "no" nothing to happen. How can i do that?! thanks!

Hi - I'm trying to do something that seems like it should be easy, but I can't quite get it to happen. I have a layout/table for a form that combines visits to doctors that are being submitted to insurance. It has a portal to a visits table that is related by the id of the claim form. Works fine to show the specific visits on the claim. I'd then like to show a breakdown of the visit expense subtotalled by doctor. As far as I can see, you can't do subsummaries in a portal. So I tried creating a new layout based on the visit table, and use GTRR from the claim form table to find all related records - ie all visits that are tied to that claim. This also seems t…

I have a reference check form in my app that currently has 20 questions (fields) that are pretty much standard questions. I have this set up so that once the data is entered I save it to a PDF and email to the client. No problems here. Every once in a while a client will ask me to get very specific information while I am talking to a reference. Generally no more than 2 or 3 extra questions. Is there a way for me to set up 3 extra fields where I can customize the label at data entry and only print those fields if they are not empty? I thought of setting up a secondary table with the custom questions, add a flag to the prinary references table and if it is che…

Hi, I have to move some fields to a new table, but i use them in scripts and layouts before. What is the efficient or easier method to do that. Or how can I find field missing messages instantly. Thanks cabi

I'm trying to copy and paste data from an existing field to another for a specified found set, basically trying to "fix" a database that was not set up correctly in the beginning. I've set up a script that works - but only for the first record of the found set; not the others. I think I must be missing a basic step somewhere but can't figure it out. Here's a simplfied version of what I'm trying to do. Field 1 (an existing field with data, e.g., "x") Field 2 (an existing field with data, e.g., "y") Field 3 (new field that will contain either "x" or "y" or be empty if fields 1 and 2 are empty) One of many different script versions was: se…

I am sure the solution is simple but couldn’t figure it out. How to go to invoice# 1827 in an invoice table?. I tried GoTo record script By Cal with Invoice::InvID but did not work. It seems that FM uses its own numbering.

This should be easy. I have a Field called "Team Record Checkbox". On my layout, I have assigned a single checkbox value "Team Record" to that field. Now, I want to do some calculations based on a record that has the checkbox enabled. How do I formulate the if statement? if(Team Record Checkbox = "Team Record"; do this ; else do that) does not "do this" when the checkbox is enabled. Nor, if it is set to "True"

I am stumped (as only a self-taught newbie can be) by a simple field question: I am registering guests for a small retreat, with overnight room charges. I have very simple fields and summaries set up: room charge, deposit received, balance due, etc. It works very nicely except I don't know how to make the room charge negative without having to include a negative sign on entry. I'd rather enter the charge, and have all the fields add together and the final balance negative if balance due. Seems to me there must be a way for the field to automatically make the entry negative. I've experimented with various number and finance functions, calculations, but none have …

I'm stuck. I am trying to get a "target" Field to display the field value in red, if the target is a client. Otherwise display in blue. I created a test field to test it below, and it works great; [color:green]Field Name = Targettextcolor Type=Calculation Options=Unstored, from URL Stagina Area,= Case ( IID Client? = "YES" ;TextColor (Target; RGB ( 200 ;0 ;0 ) ) ;TextColor (Target; RGB ( 0 ;0 ;200) ) ) But, when I try it on the actual field, it is displaying the field in blue, as the records are coming in, but can not get it to ever display in red. Got an idea that it's due to it being indexed, but not sure, and how do I get around it? [color:green]Fie…

I need to fill in a field using a calculation based on the difference between two date fields - if greater than 60 days then "No", if between 1 and 60 days, then "Yes". I wrote the following script, which works so long as both fields are filled in. The problem is one field (Date Permission signed)is filled in first with the second field (AR Date)at some point in the future. With the AR Date field empty, the calculation returns "No". I tried adding an IsEmpty (AR Date)"" function, but that always returns a blank. Is there a way to leave the calculated field blank until the later date field is filled in? If (AR Date - Date permission signed ≤ 60 and AR Date - Date perm…

Is there an easier way to filter a field so that it contains only letters and numbers other than using Filter (field ; "A...Z 0...9")?

I am new to FMS of any sort, and have been slowly implementing FMS 8Adv., with limited help from my IT Dept. I am trying to use calculations to display images for individual records, using the different field info to nav to folders to find the correct images. Worked P2P fairly well, both with relative paths and absolute. Got it to work with FMServer looking at a remote location on our network here, but when I relocated everything onto the FMS machine, relative paths did not work, and I am having trouble getting any absolute paths to work. Due to the way that our network is segregated, the servers with external access cannot interact with the local network…

I am designing my first database and have a field called OjtOnTime that has the following calculation: Case (OjtComplete <=90;"Yes";OjtComplete > 90;"No";"NA"). I want to calculate the percentage of "Yes" responses. Would the following calculation do it? (Count"Yes"/Count"Yes"+Count"No")*100.

Looking for some advice from seasoned FM veterans about the best way to handle updates, upgrades, and version changes to a client DB that will be hosted on a web server. I'm developing the DB and need to know the best way to set myself up now to make changes in the future as the development process moves forward. Do I create a reference to the file with no data or do I make changes to my file, take them off line at night, import the data and re-upload? What is the best way to handle this? I'm sure there must be a solution since 'versioning' is the way to continue a relationship with the client. Thanks.

FMP 6 I have a number of pull down buttons with pre-entered text. When I scroll through my database, using the tab key some will automatically open and I can select the entry I want by using the arrow keys, yet others do not open and I need to use the mouse to open them and select the entry. I have been looking at this for two hours but do not seem to be able to fix it. BTW in the tab order they are next in line and should open after the previous field. Any suggestions? Thanks

I have decided to eliminate the status area on my next database project. I have buttons to move forward and backward through the records. I can see that I can insert the record number onto the layout, but can anyone tell me how to display the total number of records and after a find the number of records out of X. I have been displaying fields <> but can't seem to find record information. Thanks

Is it possible to prevent a user from being able to enter spaces or tables into a field?

Hi all! I've got a number field where I want the value to be incremented by 1, but with an added "-06" or "-07", depending on what year it is. The result should look something like "102-06". Is it possible?! thanks in advance Anders

When entering calculations is there a way to replace the action of moving the mouse and clicking on the OK button with a keyboard command since the return key is tied up doing carrage returns in the calcuation dialog box? Just seems like there should be with all the time I waste doing that. I guess I am just used to photoshop where you gain speed by learning the keyboard commands. Thanks Drew

In my educational Database I have a related table of how many days a student was absent. I do care for how many days the student was absent and not present because this has no meaning for me. The table fields are: Attendance: AttendanceID Attendance:: StudentID Attendance:: Date Attendance:: KindList: Excuse or no excuse I need to count all the records that a student has to this table in order to know how many days was absent from school per school year. As it is well known there is a limit of absenteism to promote the student to next grade. But to know all the records that a student has to the table of attendance is not enough because there is a dif…

I'm very new to Filemaker, I have at my company several large datbases. Some of them have increased to 10gb in size as we are scanning a lot of information for past employee files. I have noticed that these files are getting corrupt often and I have to restore from backup. The problem being is that I don't know when they became corupt. I have tried to rebuild the db through filemaker which takes a long time and says that it is too corrupt to rebuild. Should I not be using FM with such large files. I'm trying to convnince my employer that we should just use folders withing Windows instead. Any help or information regarding file limitations is greatl…

Hello all, I have a problem wend I access my file from FMS8v4. The problem is the following: I have a text global field in a table that is not related to any other table in the file. If I open the file local from my C: and edit the field the next time I open the file the changes don’t disappear. However If I open and edit the field and then close the file from FMS8v4 the data in the field disappear Please help.

How can you highlight a text in a text field? I know you can change the font colour but I would prefer highlighting. Thanks and Merry Christmas.

I'm having a problem figuring out how to have my status indicator break down how many records are in "status a" and how many are in "status b" on a report. I'm trying to eliminate having to search all the time. I want to know everything at a glance. How hard would it be to do in FMP5? Everything is on one table right now.

If anyone know how can we create a field to display simultaneously the field name + the field value. EXAMPLE: FAX(The name of the field) 210-896-7895 (the value of the field)= [color:red]FAX:210-896-7895(the default value of the field).