Calculation Engine (Define Fields)

Can any body help me with a calculation to extract the middle character/s of a long number or a text string, eg, the 5th character in the number 12345678 or the 4th letter in stephen In both of the examples I will not know the contents of the number or text string, they will be different every time. Steve

I am trying to work out how to extract characters from a text string and paste them into separate fields from a calculation. The field data I am working with is 00:0D:93:6C:0C:7C which is actually a MAC, I want to extract each section into it's own field eg, 00 into field 1 0D into field 2 93 into field 3 6C into field 4 I can figure out the pasting bit myself, but what I'm struggling with is how to extract each part of the text string using a calculation? Any help is appreciated. Steve

Is there a way to put leading zeros onto a number. Say I want a number to be 5 total digits and I need a decimal point. No number would be larger than 999.99 Examples of numbers desired: 004.00 050.25 007.75 127.00 I just need the left side filled with zeros to complete the 5 digit number. Thanks Lester

I have a simple text field on a layout that I want users to be able to type into, but I want to control how many lines they can write. I don't want them to be able to press return many times as that would make the text box too big on the printing layout. Is there a way to control this? I do see that I can control how many characters can go in a field, but that's not exactly what I'm thinking. Thanks.

I have a layout used for printing that has a header. It has 6 pages. On page six I do not want some of what is on the header to print. It would also be okay if the whole header didn't print. Is there a way to do this? Thanks

I'm building an image cataloging system and have a container field that houses a linked file. I'd like to have a field display the path to the linked file, so we can track where the image file is stored. I've looked and only been able to find reference to the database file path, and nothing about a file in a container field. Likewise, having a field display the files name would be wonderful too. Suggestions? Thanks. -wing

Hello again, I am trying to make it so that I can click on any of the field labels and have the find go to the field next to the label and not have to have a script for each field. Any suggestions. Thanks.

Hello, New here. Am trying to figure out how to use the page up and page down to go to next record or previous one. Any suggestions. Appreciate

I am running the latest version of FMS Advance and my clients access through IWP. I also have another "slave" set up, which is perpetually accessing the application through an FM8 client, to perform a few non-IWP functions. This setup has been working fine, until lately. On two occasions now, after the user has performed some simple actions (nothing much more complicated than creating some new records), one of my entire tables has lost all of its data. I have stepped through all the scripts that are used, to make sure none of them somehow get caught in a Loop, calling Delete Record over and over. I've tried going through logs to see what has happened, but I can…

Hi, I want to setup so that when i press tab on keyboard the cursor move to a specific field. can someone let me know if this possible

I have 1200 people who have to do 4 tasks. I want to create a modification date for each of the tasks. I created 4 date fields with different names with the option of modification. Of course when I change one of the event scores all the dates change. I want to link the each date to one specific task. When I update the task for one person, I just want the date to change for the one task and the one person who retested the task not the entire group of 1200. For example, I do 15 push ups today. When I record that score for me, I want the date to modify to today's date (nothing will happen to the dates in the other three tasks) and I will be the only one the date will ch…

Hello, i was wondering if someone can help me out with this. basically i want to get total all percentage of all the program by status. if you look at the example file i have include you will see what i am trying to do. i am using FM 6. databasereport.fp5.zip

I understand how to create an append of the data from multiple fields into one using &..., but now I'm tyring to create a field that will append the data of one single field for all related records. My attempts thus far aren't working. Any guidance as to what function I should use? thanks

I can use a calc to round figures off to 1 whole number or to 2 decimal places using Round(fig1);2) or Round(fig2);0) But how can I round to the nearest 10? i.e a number of 459 will find 460 likewise 454 will find 450? Anyone with any ideas?? B

How do you force a field to retain it's formatting? Example copy from word or a web page and paste into FM Pro V7,8 & Advanced and it retains the font from the source. The Synchronise with field font option DOES NOT WORK!! Considering Filemaker Pro is all about data in and out there must be a solution without having to write a script for this. Any ideas?

Case ( UntilNextChange ≤ 3000 ; "Good" ; UntilNextChange ≥ 3001 ; "Service Soon" ; UntilNextChange > 4501 ; "Schedule for Service" ) The above is the function I created - it is to alert a tech when one of our support vehicles needs to be serviced. Problem is I need to make the second result calculate using a span of miles - 3001-4500. What is happening is when the miles are over 4501 - the text result still says Service Soon instead of Schedule for Service because the result holds true seeing the number in UntilNextChange is greater than or equal to 3001. How do I calculate a result using only a span of 3001 - 4500 and get Service Soon so that if the resul…

Hello, I'm wondering if it is possible to have an auto serial number that covers two fields on two tables. I'm building a database to track the inventory in our lab. My database is has two tables with information of materials: Raw Chemicals and Biological Supplies. I have an "Auto-enter Serial, Can't modify auto" on the chemicals table and I was wondering if I can extend that to my biological supplies table. By this I hope to have a unique identifier for every object in the inventory. If anyone has any ideas it would give my tired brain a rest. thanks js22

I have searched the forums unsuccessfully, so sorry if this has been discussed. I have a list of Suppliers, I wish to have a system set up where you can select the supplier and it will set a field to that supplier you clicked (basically a purchase order form restricting where you can order from), easy enough, done that, however I want the suppliers sorted into categories, e.g. Lifting Gear Hire Office Stationary Crane Hire example, if you hover over/click one of the categories it will show you all the suppliers from that category, then clicking the supplier will insert into the correct field.(my coding knowledge is basic/average and i learnt most o…

Hi All, I've got a couple of portals where I would like the fields displayed to be read only. This would allow the user to copy the data without any chance of accidentally altering/deleting the original data. Is there any easy way to achieve this? Thanks Pedro :-)

I want a secondary function on a button by right clicking. I used the modifier key for 'cntrl' as I thought it was the same as right clicking, but it didn't work. Can anyone help me to right click a button. Thanks.

Hello, I'm working on an inventory database and I'm trying to get my summary fields to work. In the database are two tables. One is inventory transactions and the other is inventory summary. Inventory transactions is a list of everything that has been ordered. Date, Quantity, Stock Amount and the Name of what was ordered. Inventory summary is where the problems are. I would like to have a summary with total quantity (how many bottles are on the shelf) total Amount (quantity * stock amount, it is just an approx but that is good enough) sorted by Name. When I do the summary fields it tells me that I have circular references and won't let me finish. I kno…

I am working on a solution for my school. In it, most fields have up to 20 repetitions. I have all the repetitions on the layout. However, I don't want the repetition (or the label for the field) to print if there is nothing in that specific repetition. Additionally, not all records have information entered in the same number of repetitions. For example, record 1 may have data entered in 5 repetitions while record 2 may have data entered in only 1 repetition. I know this is the matter of a simple calculation, but I'm going nuts trying to figure it out. Thanks so much for your help!!!

I have "Subtotal" defined as Sum(product line items: Item Total). My problem is, when I am entering an invoice the subtotal will not calculate until I click out of the "Product Line Items Portal" Any idea what I am doing wrong?

I have attached a file that I am making (or trying to). I know what I want to do but haven't got my "missing manual" in the mail yet. I want to have three tabs that show fields that are specific to the order status. For example when I go to master list tab, there will be all fields. When I go to the current orders tab, it will show the first 20 fields from left to right, but not the four to the far right. In the shipped tab, there will be the first ten and only the last four. How do I specify the layering (photoshop-style didn't quite work)? How do I make it so that the tab background extends down as I create a new record (CTRL + N)? FM.zip

In MS Access I can create a table of dates. I then join this to my bookings to give me a subform (portal) which dispalys free and booked dates. Using this method makes it very clear what dates are free and what dates are booked. Is there a way to do this in Filemaker?

First of all thanks everyone for the help so far. This is my first stab at FM. I think it is a great program. Now for the problem. I am making an invoicing solution that is very specific to my business. Probably could have done it in M$ Access, but believe that FM gives me more options and looks like one I become a little more familiar with it, should be faster to finish with. attached is a clone of my solution. as you can see, I am having a problem with the summary's in the printed invoice. I cannot figure out how to get the previous balance, overdue balance and total balance on the printed invoice. this solution started out as the joinprint solution (th…

I bet this is a common one, but I'm a self-taught novice and new to this forum thingy. I've learned about using "show only values from 2nd field" in value lists, and placing two fields on top of one another, (one unable to be entered) in order to enter the serial/id but see the meaningful data about a record. It's great stuff but I think my data entry screen sucks for my users because I have to stand over their shoulder and say things like.. " Now hit enter" and "Now hit enter again" and "no don't type in that field with a strange number showing, click somewhere else then click on the field again to get the menu.." and "Type faster, if you stop it starts again.." (ref…

Hello Team, I have a database with a table for "absences". Each absence record has a field for the absence date, and a field that displays the week of the year that the absence is in. So a given record would have the following fields; Absence Date: 10/13/2006 Week Of Year: 41 Of course there are hundreds of absence records, and they will be from various dates and weeks of the year. I need a calculation that will identify the week of the year that has the most absences for the found set of records. I'm hoping for something along the lines of "the week of the 6th of November" or "the week of 11/06/2006 to 11/11/06" Something along those lines.…

Does anybody know why GetField("FieldName") returns the quoted field's value but GetField($$globalvariable) will not, even though $$globalvariable contains the exact text string "Fieldname", quotes and all?

Does anyone have any suggestions on how to solve this problem? I want to create a database to inventory liquor bottles. I want to scan the barcode on the bottle, and enter a count for full bottles, or weight of the bottle for partial bottles, and have the total amount tallied in a report of all bottles at the end of the counts. I have the liquors all entered in a table with their barcodes, full weights, and empty weights. The idea is to scan the barcode, perform a lookup to see what the bottle is, and if it is a full bottle (or multiple full bottles) enter the number for the bottles. If it is a partial bottle, set it on a usb scale and enter the weight of the b…

Hi I thought I was getting too big for my boots and now I know it -I set up a script to export a found set of records and formatted a button so that it exports the found records with the fields I have nominated into a csv file on my desktop - it runs perfectly on my computer - however it's a shared database so when other users try to use the button - it just doesn't work - we get the error message saying file is locked or in use - can anyone help me discover what I am doing wrong please - it's probably somethign really basic that I have missed very grateful for any help thanks Carol

I have a field that is the date a job is sent away, I need to keep track of the total length of time a job is away for. I've currently got a field that is a calculation, TimeAway=If(Date Returned>0;Date Returned-Date Sent;Get(CurrentDate)-Date Sent). So if there's a date in the date returned, it gives the number of days it's away for, that works fine. If there's no date in the "date returned" field it the calculation works when I manually change the date sent field, but it doesn't update each day. How can I force it to recalculate the field every day?

Hi all I can't figure why it is possible to check both DATA and CALCULATED VALUE... If I enter something into DATA, no calculation will be performed ! Or am I missing something ? For example: My field's name is: AutoEnter Into Data there is: 1+3 Into Calculated value there is: Evaluate ( AutoEnter ) I was thinking that when a new record is added, that field contains: 4...but no.

Hello, I am trying to create a schedule builder that will display a schedule when given various college classes. So far, I have the database structured as follows: 2 Databases: Schedule and Courses. The Courses database contains a record for each course offered. The Schedule database is where I would like to assemble the data in such a way as to build a weekly schedule. Currently, I have eight fields to choose courses in the Schedule database - the idea being that six to eight courses represent a typical semester's load. I then created a relationship for each of these eight fields to the Courses datanase, matching records using a unique CRN (Course Req…

Hi everyone! In first place, I know that is a lot of invoicing systems topics and examples around, but none of them have a simple functionality that I'd like to add to my company's system. I need to do the following: everytime an item is added to the invoice, the stock level is decreased by the quantity sold. I've tried some solutions like Sum(quantity) but it do not work as I expected Anybody has a simple solution to do this? I do not want to run a script triggered by the user, to avoid errors... This is a small example of the tables and fields. Any suggestion is welcome. invoice_stock_example.zip