Calculation Engine (Define Fields)

Is there a way to insert many pictures into their respective records all at once? My coworker is looking for a shortcut from inserting pictures one by one into their records. I can explain that better, please let me know.

I am new at FM, and can't figure out why when entering a new records in a Portal it keeps scroll from the first-to-last record each time. Any idea that might help me solve the problem. Thanks

Hi, When you have images in your records, what file size and file format do you use? I am wondering because it was pointed out to me that once we start to get a lot of records in the database, it may slow down if the image sizes are too large. TIA!

Hello I wondered if there is anyway through script or plug in to copy and paste the contents of the web viewer into a container field with a script. I noticed I can drag and drop the contents of the web viewer to a container field. I wanted to know if anyone has any info on this problem. Thanks Dave

I have run into a problem developing a solution and i ve kind of hit a brick wall but before i tell you more about my wall let me first say that the Troi File Plugin is truely an amazing product. My Problem: I have created scripts to copy and move image files to a folder on the database drive and I have gotten it to create thumbnails to populate those containers. However, I have found that i need to write the file extension in the save dialog otherwise it wont fill the container. Is there a way for it to read the File extension and append it in the save dialog when i copy the file to my database drive. I have pasted the script steps i have used mb you can see wh…

What is the best way of locking a record so it cannot be modified(text field) that is made on a different date than today. I want to be able to edit and change records made today but not to accidentally modify records made on previous days. This data field is a text field(s) that contain patient data that should be "locked at midnight". thanks, john

I am currently developing a timesheet database that allows employees to time in and out twice each day, as well as manually enter holiday, sick/personal, vacation, and other time off. To make the rows necessary for a six-day week [Monday through Saturday--office is closed Sunday], I have set up a table with repeating fields: TimeIn1 TimeOut1 TimeIn2 TimeOut2 ... as well as other calculation fields designed to take a total for that day's hours. My question is: How do I select a particular range of repetitions in order to calculate overtime? The way my office prints its timesheets, overtime needs to be listed for each day it is earned. For example, …

Hello, I'm new to FMP, and would like guidance on the following: I am working with a database created by someone else, that contains a list of patient names. In browse mode there is a field called "Team," and in setting the value for this field, it has been set up such that when you click on the box, it has two options: "Team A" and "Team B" to which you can set the value. This allows you to assign a team to each patient. I would like to create another field, say "Team A total" in layout mode, that would sum the total number of "Team A" values for all of the patients in the "Team" field, and then another field "Team B total" to do the same for all …

Hi everyone. I am new to filemaker and these forums. I was going to ask a pretty basic question, but after looking around for the answers a bit, I realized that I might benefit by asking some general questions. Here's the situation: I work for a company as the IT coordinator. I do hardware and networking, not database work, but the record-keeping this guy is currently using is staggeringly inefficient. I remembered using FileMaker at another job a long time ago and thought I would take a crack at streamlining the processes in my spare time. The point is, I'm in no rush to set up my database. I downloaded the demo and started tinkering. Well, I have the bas…

I have 2 lists of stocks stocklist1: a,b,c,d stocklist2: a,b,c,d,e,f,g,h I want to eliminate the duplicates from list 2. Then I want to sort the stocks that are left e,f,g,h. The lists are actually very long. Any ideas which way to start would be appreciated!!

Hello! I have a calc field that determines a discount based on a global field that represents the registration fee of a "league type" and the actual fee paid. It is unstored, and in a table called "financials" I have a "players" layout with a portal for financials. Now here's what's driving me bonkers.. The calc works fine when I open the app and use it on a windows machine. However, on a Mac it will not work. If I go directly to a financial layout(not to the portal) and enter data, it works just fine(on the mac)but not on the players layout. Can someone make a suggestion as to what might be the problem, or where to begin trouble shooting. Thanks.

Hi, Hope you can point me in the right direction.... I want to display in my line items file the commission % based on the criteria of - Employee and Type. I have setup the types (Product 10%, Services 15%) on the employees table. At present it displays on the line items table the employees name and the type (Both via Calcs from the appointments table) - what i need to do (I think) is build up a case statement.... But how would that work if you add a new employee??? If i can get the % number in a field in the line items table, it should be easy to calc a employees commissions based on what they have sold? (Is this the best way to go about this?) Thanks…

Hello! im stuck again, having problems with some parts of a status layout im making. There is one member layout, and in that layout i write in a radio button if the member is a new member or not, and with other radio button if is an active member or not. I want to do a status layout showing how many member we have, how many new members, how many active and how many non active members. Can somebody help me with that?1 thanks!

Hi, I've got a calculation field that is running the following calculation: If ( field one = "x" ; field two) This achieves the desired results. But, I also want to check field one for "y" and return a different result. I assumed I could add another "If" statement or an "else if" or "else" but can't seem to get this to work. Is there another way to get this done? Thanks!! -Wing

I have a calculation field which is a SUM of several other fields (all numbers). I would like to compare this calculation field to another number field, with the result of either GREEN or RED number, depending on whether or not this field has a higher numerical value. In other words, if field A is smaller then field B, I want the field A be in RED, etc. How would you write such a calculation and how can it be added to the existing calculation ? Many thanks !

I have a field that is either a yes or no. If someone selects yes, it creates a record into another related Table and that part works fine. But what I want to do is that if they had selected yes and created the record and then go back and select no that the related record is deleted automically without dialog. Stumped yet again... Thanks

I have a requirement for three seperate parts of a database to reside in four locations, one in Bulawayo, one in Houston, one in Illinois and the master In South Africa. The date formats for input will then be UK format in Bulawayo and South Africa and American in the other two. As the whole database is mastered in South Africa is there a way to set the input format correctly for the various sites and then have the date converted automatically when the input from America is imported

I have a telephone number field in many of my layouts. I would like the phone number autoformatted to (xxx) xxx-xxxx after its entered. Preferably in whatever way its entered to have the numbers formatted as above. Sorry if this is simple and I'm missing it. I'm new to FM.

Hi I want to create a basic finance entry database for income & Expenditure. I was going to create 5 tables for 5 years and then each table layout having 12 tabs for each month. Each tab would have 5 columns for the 5 weeks of the month. Anyone know if its possible to not have to create the same fields dozens of times for weeks 1 to 5, months 1 to 12 and years 1 to 5! Much appreciated! Trevor

I have records in a table and one of the fields is a date. I want to be able to count the number of days for the records that I have selected. For example, in the 6 records below there are 3 days. Is there a calculation that will determine this or do I have to loop through all the records to figure this out. As simple as it seems I cannot come up with a solution. Thanks for your help! 1/12/07 1/12/07 1/12/07 1/15/07 1/16/07 1/16/07

I have multiple records that contain a field "status" with values such as "Status 1", "Status 2", "Status 3", etc and also contain a date field. The primary key for the database is a concatintion between of "Item ID" and "Status". I want to calculate the number of days it took for a particular item to chang from Status 1 to Status 2 and I'm oping to do this in a field definition rather than a script, any ideas?

Hello! im having a problem. Im making a file of invitations. For example. In my layout i have to write who invited me, and down to be displayed every person that i have invited. The problem is that one person can be invited by one or more persons, how can i do that? please, somebody help me.

Hi, Im completely new here and struggling with what should be a simple thing. I have a database with 2 layouts - 1 info 2 financial. When I tick an Invoiced check box (in layout 2) I want to display a graphic on layout 1 which says invoiced in big red letters - any Ideas?

I'm trying to get multiple modification boxes stating the name of the person who modified it, the date, time, and reason. I've got the name and the reason figured out, but I can't figure out how to make multiple modification boxes. I know filemaker can create one easily but I must need a function to make more. What I need basically is a modified by 1, with name date time and reason, then a modified by 2 with name date time and reason, a modified by 3 and a modified by 4 with the same information. Is there any easy functions to do this? I'm a beginner and really don't know a whole lot about this. I was thinking I could just have it check to see if modified one had any…

I'm a fairly novice FMP user. I'm trying to create a field that will display all the entries from another field within a found set. Can someone enlighten me? i.e. this is for emails. To search for a set of email contacts and then have a cut & paste field in which I can copy them all at once. Thanks!

Hi - I'm having a problem I've seen posted elsewhere but none of the solutions suggested seem to do it for me. I have a list view with summary fields in a trailing grand summary (Simple Total of type summaries). They start out correctly. However, after a script goes through and makes changes to the records in the list, the summary fields do not update. A calculated field which is on this layout but comes from a different table and is the same as one of the summary fields DOES update after the script runs. Changing modes does not help. (ie preview and back). Clicking on background of layout does not help. Adding "commit record" steps in script after each…

Greetings, its been months since i have been on here, but i have a new task and need to clean up an old database. The first and foremost thing i need to do is to delete old records but i cant think of a good way to do it. My Scenario: I have about 30,000 records and only 10,000 are useful (therefore it would be tedious to go in one by one and delete the unused ones). My criteria for deleting the records is that if they dont have a call history of any kind i may as well delete them. The call history is actually a portal "Contact Calls" which is related to the "business info" table. I want to delete all records that have zero information in the "contact …

Hello, I am trying to create a field that will sum data from another related table. I have 5 tables, one for event info, one for daily individual costs by event and date, one for daily totals by event and date, one for event totals by event, one for accounting totals by event. The daily individual costs have a department field and various other financial information. In the Daily totals table I would like the department field to calculate the total of the individual costs broken down by department. (for ex: all operations expenses for the specific date would total in the daily operations field in the daily totals table) I am not sure how to do this an…

Hi Guys, This belongs either here or under scripts, I'm not fussed as to the solution but would probably prefer calc based. What I essentially want to do is have values (percentages and dollar values) removed or added to / from an initial value to produce an end result -- Given that percentages are used, order matters here and I can't quite wrap my head around this. The deduction set is user specified. Custom Functions for this would also probably be useful. I've attached a simple sample because my wordiness usually lacks sense To add an entry to the deduction set just go to the deductions layout, I've just used a Cartesian here sooo.. Any help is ap…

I cant seem to get this to work. i have 3 seperate calculations. one being current date - date of birth = age and date field + 2 weeks = projected date field and date field + 45 days = projected date field. i know it probably simple as hell but cant figure out the parameters. Thanks in adavnce.

I have a field with three possible entries: U, M, or ALT. I would like to have a count of each of the three entries--for example, 10 U's, 15 M's, 8 ALT. Is this possible? I am using both FMP4 and FMP6. Thanks in advance for your help.

Hello, I'm creating a database for a laboratory that I work in to keep track of our chemical inventory. Each year we have to print reports of our hazardous chemicals and an approximate amount of what we have in stock. My problem deals with the different number of units that we use. Mostly its grams, milligrams, or kilograms. (or liters or milliliters for liquids) Is there anyway to have a clause in the calculation to look at the units and multiply it by a factor? Since we only use metric units we should be able to just multiply by a power of 10. I've attached what I've come up with so far. I would appreciate any help into this problem thanks …

I have a table "Payments" that is displayed in a portal and set to have records created via the relationship to the parent table. I need to validate all of the payments (records in the "Payments" table) made but they don't validate when the record is first created but they are validated when the record is updated. I am trying to figure out why this is happening and if there is a way around it. Is it possible the problem is because the validation refrences a related field? It also looks like if a payment is deleted an unstored calculation using Sum() still counts it as well as a summary field. Is there any way around this? Running FMP 8.5 Advanced on Windows …

If someone clicks on a button to go to a specific layout, I want a Dialog to open and redirect them back to the original layout if a specific field is populated. Thanks, Stumped

Hello I have a two table file. I would like to write a script that would pull the data from a field called "url" in the table "backgrounds" and place the text in a field called "web". The part I am having difficulty with is getting it to go to the next record the next time I acctivate the script and doing so with each click of the script by a button until it has copied and pasted each bit of data from the field "url" so that the related table will perform a lookup. Can someone help me. I simply want to click on a button and have the data from the next record copy and paste into the table "Customer" field "web" coming from the data in the table "Backgrounds" field "url…