The Left Brain

I am looking for a clean calc to get a string from an array, build from a value list. I have a id then a delimiter then the string. 001Ωthis is string one 002Ωthis is string two 003Ωthis is string three I would like a custom calc to get the string based on the choosen number.

I have a DB that has several thousand individual records that have the following fields defined: Start_Time End_Time In this DB I have to calculate for time elapsed between those 2 times. Easy enough and done. Now my bos would like me to give him the elapsed time between the <> of Record "X" <> of record Y. Visually Start End Elapsed Record X 12:34PM 12:44PM 10 Min record Y 12:47PM 12:58PM 11 Min Elapsed between record x and y = 3 min. Anyone have any ideas on how to automate this? I can't think of anything. Thanks in advance for any help. Steve

Is possible to truncate text i.e. Burman is truncated to 3 characters i.e. Bur. Also, whats the function for generating a random number between 0 and 9? Cheers for help, genx

my client would like to have a mask for date entry, either 0216 (month, day, current year) or 02sep (day, abrv month name to number) when I just try a simple mask on a date field it fails, so the first question is it possible to mask a date entry. second question if possible here is what I have. /* Let ( [ num = Filter ( Lower(dte) ; "abcdefghijklmonpqrstuvwxyz" ) ; txt = Filter (dte ; "0123456789")] ; Case ( IsValid ( dte ) ; dte ; // Is entry in valid date format? Length ( txt) = 0 ; Date ( Left (dte ; 2) ; Right (dte ; 2) ; promoY…

Is it possible to round up to a specific value, i.e. 6. if there are 10 units in an hour, round up to nearest unit. Cheers

i have a layout that i am completely stumped on... i need scripts to do everything show on this makeshift lay out: http://img18.imageshack.us/img18/7117/help7we.png i know how i am going to do the sorting to populate the production feet fields...but i don't know how to do the dates at the top, and i think i can handle the caclculation fields with the +/- can anyone think of a better way to do this or help me in doing it this way... btw i will be using chartmaker to make the charts...unless V8 has one in it

I need some help . . . I have 3 repeating fields of 24 each. One of these fields is the sequence number that the user prefers to have them displayed. These fields represent line items on an order and are entered, as you might suspect, in the sequence that the order entry clerk puts them into the field. However, the sales representatives want to be able to re-sequence them according to their preference. Hence the 3rd repeating field. I'm letting them enter the placement they desire for each line into the repeating sequencing field. Now . . I'm trying to find an efficient method of re-ordering the lines to they will be in the order the sales rep wants. I've …

Hey all, Thanks in advance for any help. I tried to explain this the best I can. I am trying to design a database for my company that will estimate prices. I am not new to FM but am to these more complex calculations. The pricing is based off a spreadsheet. Thickness on the "y" axis, Inches on the "x." (y)Thickness is broken down per inch in 1/4" increments. (x)Inches is cutting area of piece in inches. (x)Inches also has four price steps. Under 2 lineal feet, 2-5 feet, 5-10 feet, over 10 feet. (x) also another step for different amounts of pieces under the various feet requirements. 1-25,26-199,200or more. Now let's say you have 5 pieces…

Help ... I have a sales processing system that creates quotes which are then accepted. If a quote is accepted I need to be able to stop ANY UPDATE TO ANY FIELD including adding/deleting portal rows in a quote items table. Any Ideas :?? Best Regards, Peter

Is there a way i can put in a script step to check if a related record exists? Reply would be great cheers, genx

Hi all I want to choose the min date and max date when all welder were tested. Each welder may have four or five tests but i just want to know when each welder was first tested and when he was last tested along with the first process and last process he was tested on and i want to displayed this information on one line for in a view layout for each welder. I have tried various ways but have not achieved the results i was hoping to get. Included is a sample program of what i would like to do Any help or suggestion will be greatly appreciated Thanks in advance Lionel test.zip

FM7. Given: the developer keeps track of changes to a database solution inside the database in a table that includes a text field with a version # like 1.3.2. The table has the usual serial # field. There's one layout with a portal listing all records. A calc field keeps track of the highest serial# (Max( ChangeLog::ID )) A relationship exists between this calc field and the ID field. The idea is that when a new change record is created, the highest version # should prefill the field. The developer then has the option of changing to a higher verson or leaving it. A lookup only works if the current record on creation is the previous highest. Question: …

First sorry for my bad english I think I need A very strong calculation here Here is the problem. I made a self relationship in a table with artists names. The 1st Key "some_characters" is a text field. The 2nd Key "Calc_name" is a calculation field with this classic code: "All" & "¶" & "¶" & Full Name & "¶" & Left(LeftWords(Full Name;1); 1) & "¶" & Left(LeftWords(Full Name;1); 2) & "¶" & Left(LeftWords(Full Name;1); 3) & "¶" & Left(LeftWords(Full Name;1); 4) & "¶" & Left(LeftWords(Full Name;1); 5) & "¶" & Left(LeftWords(Full Name;1); 6) & "¶" & Left(LeftWords(Full Name;1); 7…

Hi, I have a hiredate textbox but i would like to add 35 days to the hiredate into textbox RevewTxt Can you you help.

I have a calculation feild which gets the first initials and last name. However there is no white space between the initials or name, can anyone please suggest how I would do this, thanks. Left ( LeftWords (Employee::First Name ; 1 ) ; 1) & Left ( LeftWords (Employee::Middle Name ; 1 ) ; 1) & Employee::Last Name

I need Your Help... I a Table With CD Albums (the Father) I have Also A 2nd Table With Music Tracks (childs) I have made a portal to see the music tracks for every cd All Want Is to Have A text Field In CD Albums table with the related music tracks in it. For Example Artist Aerosmith (field) Title JUST PUSH PLAY (field) Tracks (field) Beyond Beautiful/Just Push Play/Jaded/Fly Away From Here/Trip Hoppin'/Sunshine/Under My Skin/Luv Lies/Outta Your Head/Drop Dead Gorgeous/Light Inside/Avant Garden I want This Delimiter "/" for export work. Can you Help me?

with out using auto serial, I can create a calc that will get the max of the field and add 1 when creating a new record, which is great untill two users create a record at the exact same time and then I have a duplicate id. Can you think of any way to avoid the dup (no using the unique validation) but through a calc??? I am trying to allow the users the use of the regular menus items without having to use a button that I would create.

Having faith in FMPro and being reasonably proficient in FM5 I volenteered to design a college timetable. The basic components are rooms, lecturers, student groups and start & end times of classes. (Length of classes is variable). Maximum number of classes per day is 3. I have tried to replicate the look of the present timetables done in Excel which is logical, days down the side and hours along the top. There are room timetables, lecturer tietables and student group timetables. These are individual for each room, lecturer and student group. I attach my solution to date. It works fine to show room timetables though I realise that I should have one record…

how do i set it up so that in field 1 there is a value list, and depending on wich value i choose from that list, in field 2 a certian value list is defeined for that field, and if i pick a different value from field 1 the list in field 2 will change

Not sure if i'm in the right section of this forum, but hopefully someone can help me anyway. I'm having a problem with portals. Maybe I'm setting them up wrong. They work fine in displaying records, deleting records and creating new records. HOWEVER, when a new record is created, it doesn't get displayed until another is created (and then that one isn't displayed (Vicious cycle haha)). Also when deleting records sometimes 1 or 2 new blank records get created. Very strange if I do say so. Can't quite figure this one out. As far as I can tell, it must be to do with the relationship between the portal table and the layout table displaying the portal. As I mentioned, …

I am trying to come up with a method/approach to solve the following and would welcome any suggestions! I have a table that stores all of the dealers that I distribute products to. To get lower pricing dealers can put certain products on their display floor in their retail store. I track what they have on the floor in a related table that I show in a portal on the dealer layout. My question is that I want to run a report or have a screen that shows which dealers are meeting my dealer display requirements and I am not sure how to calc this. For example, a dealer may need to have three of one category of item to get special pricing and I need to have some logic to…

I'm trying to do a conditonal sum which i then want to use in further calculations. I want to get a value of "donations" in a given year. Its probably straight forward but.... Total = Sum of "donations" when "donation year"= "target year" What do i use instead of when? Thanks Simon

This should be easy but I'm not sure of the function to use: I want to define a calculation field to return one value if there exists one or more records with a specified string of text in a specified field value, and another value if no records have that specified string in that field. For example: " There are no records with 'John Smith' in the field 'Customer Name' " or: " There are one or more records with 'John Smith' in the field 'Customer Name' " i.e. something like this calculation but to search the field 'CustomerName' of EVERY record: If(CustomerName="John Smith", There are..., There are no...)

In a file I am working on are two fields I have combined into one because I can't figure out how to do what I really want. I have a list of "Areas of concern" grouped under four main categories, e.g. Academic, Behavioural, Early Childhood, and Health. Each main category has 3 - 10 sub areas. What I wanted to do was have one field to select the main category from a value list then have the value list in the second field pop up calculated based on the first value...select Academic in the first pop up and see Academic 1 - 10 in the second pop up, or select Behavourial fron the first pop up and see Behavioural 1 - 4 in the second pop up. Can I do this in Filem…

Hi all, We use Personal Serial Database (PSD), a runtime Filemaker database, to maintain serial numbers for our hardware and software. I recently purchased and installed Filemaker Pro 6 Unlimited on my iMac G5 (Mac OS 10.3.9). Now after opening the PSD runtime file on my iMac, it's modified the file association to open it with FileMaker 6, which causes a problem because not all of our techs have Filemaker 6. How to I change the file association back to runtime? I tried the get info dialog and also changing the file extension (to .fp5, .fp7) with no luck. Ideas? Help!

I have an incident records file that requires times and dates of the following: - start time - en-route time - arrival time - end time Each time value is manually entered, and the incident date is auto entered as the creation date (modification allowed). I am having difficulty with a calculation to apply into a calc field with a resulting date value, the correct DATE to each time (e.g. start-time date, enroute-time date, etc). Senario Event: As the en-route-time, arrival-time or end-time may advance into the next calendar day or julian date from the start-time (using 24:00 time), the date needs to advance as well. I've tried to compare ea…

Not sure if this is the correct forum, but I'll start here. I've had this happen on 2 different occasions in FM7. A relatively simple calculation that is the 'to' end of a relation seems to cause a very slow, prolonged sort of just a few records when going to a layout that has a portal that uses the relation. For the first occasion, it took as long as 30 seconds to 'sort' 9 records before displaying the layout. This second occasion takes several minutes to 'sort' about 400 records. You can count down the indicator - if you've got the patience - or go to the FM Forum to submit a topic like I'm doing now while it does the sort. Anybody else experience this? I…

Hi, I'm new to FM so please bear with me. I have a flat database which contains information about vehicles, specifically when they were recieved and shipped. What I need to find out is the number of days between the date recieved and date shipped. The table looks like this: VIN Trans_Type Date 1 ARR 1/1/2005 1 xxx 1/2/2005 1 OUT 1/3/2005 2 ARR 1/2/2005 ...ect... Where ARR is the code for when the vehicle arrived, OUT is when it shipped and xxx is any num…

Another question that I feel I should know the answer to...but can't seem to remember! I'd like to be able to clear all repetitions of a repeating field. I've created payment matrix grid using records (rows) with a repeating field (columns). I'd like to be able to click a button and clear all repeating field values. I can step through the records (rows) using a simple loop, but I can't seem to figure out how to clear every repetition of the repeating field. Thoughts? Thanks! -Rob

I have TWO fields 1.date of MRI scan 2.MMSE Score I want ONE of these fields to appear on a layout if a THIRD field (Diagnosis) contains specific words.... ie Diagnosis contains the term "multiple sclerosis" then the field ,[date of MRI] field appears, if Diagnosis contains the term "alzheimer's disease" then the field ,[MMSE Score field appears, on the layout. is this possible? thanks Graham

I'm working on an invoice project, I got three different tax codes:

I'm trying to get the content in the text field, TITLE, which has "I haven't" as text to calculate to the field, ADJUSTED TITLE, as "I have not" I'm trying to sort titles alphabetically rather than "computerly." Other considerations are "we'll" to "we will" "isn't" to "is not" "He's" to "He is" "We're" to "We are" and so forth If there's another post already like this one on this forum, I apologize, as I haven't been able to find it

Hello, I've moved this post from the Scriptmaker forum after 50 views and 0 responses. . perhaps you all can help me out! Thanks in advance. . . I have an order database and an itinerary database - In the itinerary database, I have a field called stop_order (as in the order of stops to make) and a foreign key field called order_number. What I have is a portal on the order layout that lists the related itinerary stops. I already have the create new stop button working using "if else" and "count" to count the number of stops and set the "stop_order" field to be the number of related records plus 1. On the order layout, I have the itinerary portal sorted…

I have a databse of 200 records which can be sorted in categories. I have all my totals working. The report can show the totals for a found subset of the records, say 20 records of the 200 present. I have five summary fields like the following: Tot1 = 8 Tot2= 6 Tot3= 2 Tot4= 0 Tot5= 4 Now I want to use these totals to generate a graph. My only problem is the summary fields are reading the totals for all the records when it comes to graphing them, rather than just the subset totals as shown above. Do I need to create five global number fields and set them to the subset totals using a script? I'm not sure how to do this step. Any help greatly apprec…

I'm stuck on a rather simple problem and I am hoping one of the pros on this forum can help me out. Keep in mind that I am just beginning to get used to Filemaker, having never used it before. I am setting up a database that will be used by some folks here is the U.S. and some folks over in China. In this database, we will include various measurements of sorts. Basically, we want to have the metric system and the standard U.S. measurements. We have two fields in our database. Cent and Inch. Basically, when someone enters centimeters in the Cent field, we want the Inch field to calculate a division by 2.54. Vice versa for the Inch field. When someone enters a val…

How can I make a simple formula in order to get abreviations from a field ("Task_days") with all week days? I was trying to made it with Let & Choose

Hi Everyone, I have a database of students ranging from years 1-15 approximately. Each year may have several classes. eg. 1/01, 1/02, 1/03.... All the students should be placed into 1 of 4 houses (Blue, Green, Red, Yellow) for PE competitions. As much as possible, the assignment of the houses should be as equal as possible. The script below is suppose to decide for new students what house assignment they should have - based on the numbers already present in the school. The algorithem that is needed is more or less as follows in priority listed: - House assigned should be in the least number of students of 4 houses (where least students…

Maybe is stupid, but I can't get it!! 4 Fields: Begin_time (time) Num_Hour_per_week (num) Days (num) Duration (calc= Num_hours_week / Days) Now I just need to calculate the END_TIME = (Begin_Time + Duration) Per exemple; 10:00:00 + 1,5 (duration) should be 11:30:00

Hi Does anyone know how to force FM to reindex an indexed field? I want to create a key that points at either the date in the record or if the record in over due to point to today. As today's date is an unstored calc, I had to use a getField() in the key so that FM will index it. This worked but now it won't update itself (ie today's date) as it is stored in the index. Any ideas? Thanks

Hello everyone, I need a little help with a multi-user schedule I've built. While it works quite well on my machine, it's SLOW AS MOLASSES when hosted on our FileMaker Pro 7 server. Each user has a record in the Users table. There is a preference to include the user in the schedule. The only schedule view is a daily timeline. User names appear down the left hand side of the window and 24 portals are used to construct the timeline (12 hours in 1/2 hour increments). When a user logs in, the system does a quick search of the Users table and finds all records with the schedule preference set to true. It then sorts these and builts a set of "timeblocks" for…

I have put together a little script to save requests (queries) but I am not sure if I can have the script see if a request is an omit request.

Ok, I have really beat my head about this, and I was trying to figure it out before boring everyone here with what will probably be a minor problem after all. I have a file attached called MWR Orders and one called MWR Salesman. When the saleman takes an order for our construction company, and it's under $10,000 worth of work, he fills out an MWR instead of big job project. As you can see, it's a pretty basic layout. Once "Create New" is selected, the next MWR number is auto-entered, then the other info is entered by the salesman. Last week, we had an instance where one of our estimators went in and highlighted all of the text in one of the records, delet…

A little calculation-related issue has me stumped. I have two related tables in my solution. The first is Users, the second Tasks. I have a "To Do List" view for the Users table with two portals. One shows "Open" tasks, the other "Overdue" tasks. The relationship between the two tables is determined by a filter. The user is able to set a date range for tasks to view. This information is stored in globals in the Users table. The relationship for the "Open" tasks portal is set up as follows: Users::UserID = Tasks::rUserID Users::gStartDate =< Tasks::DueDate Users::gEndDate >= Tasks::DueDate Users::gOverdue != Tasks::cStatus The relationship…

Hi all, I have been using FMP for many years, and am self taught to what I always though was at least an advanced level. Recently I started studying for the FMP Certification exam to lend some credibility to my credentials and I found out that in my DataBase Construction Models I may have been doing something fundamentally wrong, all along. But, I am not sure if it is just that there are always at least 2 ways of doing something, or if I am just flat out wrong in my thoughts. To start I have to admit an embaressing fact. Until very recently I did not know that you could have multiple tables within a single file. No laughing please! Whenever I have had a mul…

I think I already know the answer to this question, but wanted a more expert opinion from the forum. Is it possible to resume a paused script from within another script? I have a script that pauses for user interaction. The user is supposed to select a credit card from a portal showing all stored cards for the client. Each portal row has a little selector button in it. There is also a "Cancel" button at the bottom of the page. The "Cancel" button simply resumes the paused script. I'd like for the selector button (in the portal) to first grab the stored credit card record's ID number, then resume the script. ScriptMaker doesn't have a Resume step (such as …

FMP6 question... I have a script which sets a field to a particular character string with a length of 235 bytes on each record, plus one carriage control. The script then exports that field for the found record set. I export that to a ".dat" named file using tab as a filetype (as there are no other options close to .dat). It appears as though filemaker adds an extra byte to each record (237 bytes per record). This file is being fed into a very specific dos based program where the extra bytes cause errors. The same thing happens even if I create a .txt file, so I'm fairly certain something is occurring during the export step. Any thoughts on what FileMaker…

I seem to think that I've done this before, but now can't quite remember how. -) I'd like to be able to reference a field name via a calculation. I have a number of fields called Amount1, Amount2, Amount3, etc. I can't use a repeating field for various reasons. I'd like to write a script that uses a global as a counter. I'd then like to reference Amount1 in the script by generating the field name using "Amount" and the value of the global. Thanks! -Rob

I have a solution with a lot of separate reports. What I'd like to do is combine multiples of these reports together so I can create a single PDF document. Is there a solution other than creating different layouts for every combination of report options? Thnx

hello all, i am new to filemaker pro 7 and accidently came across this very interesting website. i have already tried to get some help to my problem at comp.databases.filemaker, but there's still no satisfying solution in sight. as there seem to be some pros out here, i have decided to bother you as well ;-) basically i have the following problem: i am building an invoicing database. it's already working quite neatly with customer, products, invoice and lineitems table linked to fill in data automatically. for fiscal reasons, i need to be able to print invoices that list different tax rates and amounts of different products seperately. i.e., i have to c…

Greetings; I have a field that marks an employee either Active or Inactive. Once Inactive, I have locked them out of changing the Hire/Exit date with this Validation calculation: EXIT DATE = STATUS <> "InActive". They can not override this error message. We don't want them changing back the Status back to Active so they're able to change the date either, but when I try that calculation, once I change it to Inactive, it won't let me do anything. I can't create a new record, do any finds, or anything on it. It is stuck there in limbo. Is there a work around for this? We also have in big red letters, Inactive Employee Record come up when th…

Could someone give me an explanation of how to use GetNextSerialValue() Whatt Im doing is: I Have a number field which is auto enter serial number A global number field a script which is set field global number GetNextSerialValue ( Get ( FileName ); test_table::serial number) what am i doing wrong or what is supposed to happen when i run this script Thanks Stu

Hope someone can help on this (basic) query. I have a timesheet function for 10 employees. Each employee creates multiple entries throughout the day as single records These entries have start_time and finish_time based on a 7.5 hour working day. I then have a trailing grand summary showing total time. I also have a calculation field in the grand summary which shows overtime hours based on the user doing more than 7.5 hours per day (total_time_overall - Time ( 7 ; 30 ; 0 )) . This however only works for a single user on a single day. I would like to be able to view time entry records for a given employee over a range of dates (eg 1/2/05...1/3/05) and see how…

I'm looking for a simple way to automatically place a checkmark in a box if the record has been edited. I assume the easiest way to go would be by creating a field that automatically enters the modification date. From this point I can't figure out how to automatically checkmark a check box. Any help you can give is much appreciated.

Here is a wonderful, chewy problem someone might be able to help me with. I am formatting chemical concentrations, and want to display them to a specified number of significant figures. I have a calc going back to the FM2 days that I am trying to update for a couple of reasons. First, there seems to be an anomaly in FM's Round function and so sometimes the output of this calc is not what we want. Second, I want to make the calc just right, so I can make a custom function out of it in Developer. So, the issue with the Round function. Have you ever noticed what happens when Round(number, precision) gets very close to a whole number? For example: Round (1.08;…

Newbie here.... I'm creating a student database and would like to keep students' enrollment history. One of my tables is an "enrollment" table with the fields: student ID, enrollment date, grade, teacher, school name, and departure date. Students in our district leave and come back multiple times during the year so I need to keep track of every new enrollment date, grade, teacher, school. What's the best way to do this? I've searched the forums but I haven't found anything. Help!!!

This the problem I desigh a mini database for me. I want to calculate the cost per print in my plotter I found that with 400% ink (CMYK) Field A Print on 0.10 Squear meter Field B my printer inkjet "3 ml" of my colours Field C I want to put values in Fields A and B to calculate the ml of printed colours (field C) Is that possible??? George

Hi, We currently use the following calculation (see "a") to display a month, day, and year date (and it works great). Now I want to add an option that will look for a certain customer number and if the result is true, then display only the month and year of a date. If the answer is false, then display the month, DAY, and year. Example "b" shows my new calculation, but it does not work. I've been racking my brain on how to make this work including different variations...case statements, etc.. Can anyone tell me what I'm doing wrong? a. If(LabSchedule="Monthly",Date(Month(Sample Date)+1,Day(Sample Date),Year(Sample Date)), If(LabSchedule="45…

What would be the best structure to offer the user a choice to use a template, or not? They start a new Estimate and are asked "Would you like to use a template?" Yes, and ?? The template contains all fields with data, where user enters quantities. Estimate Table Do I use; Template Table w/repeating fields? Template Table w/globals? No need for relationship? User needs to grab data from Template, and also be able to edit numbers on template as costs change. Tks

I'm using FM v7 and building an Estimate with layouts Phases, Steps and Details. The user begins at the details, which are the building blocks of the estimate. The details consist of fields; Detail Number = threedigitnumber(001=Labor[bricklayer],002=Labor[Tender]...etc Detail Type = Labor, Material, Equipment, Misc, Subcontractor, Overhead Detail Code = if Labor (Bricklayer, or Tender, or Operating Engineer) if Material (Block, or Brick, or Cement, etc.) When a user selects a Detail Number (from Pop up list[table detail template] the next field choice is Detail Type (this is wher…

Hello, Every record has it own unique Record ID. I want to show/use this unique Record ID in my filemaker solution. In CMDL I can use [FMP-CurrentRecID], but this time I need the current Record ID in my FileMaker solution to create a relationship to another tabel. I define a field called RecordID when I create a new record this field should show the record ID that belongs to that record. Can somebody help me out on this matter? Greetings, Jukkie

I can't figure out how to retreive data from a text field that contains data seperated by retuns... Help please... memberID: 23456 Status: Available StartDate: dd-mm-yyyy etc. it's all part of a plain text email boby.

Well this the problem I Have a color calculation programme It use 2 groups of Numbers 1st Group 0-255 (Field B the Result LOCKED ) 2nd Group 0-400 (Field A Enter value 0-400) It gives me one open field to ender a number betwwen 0-400 ( 1, 5, 80, 235 etc) And One Locked Field When I write "5" the Locked Field show me "251.75" Some RESULTS are: 255 < - 0 251.75 < - 5 248.50 < - 10 245.50 < - 15 223.25 < - 50 127.50 < - 200 0 < - 400 What is the relation between two fields? Can I white a calculation in my FM database To Enter a value (0-400) and have…

This is a true left brain problem that I don't have the capacity to sort out. Here is the right brain description. Our public access television center signs out equipment to members for several days at a time. Members get contracts that allow them to use equipment for up to so many full 24 hour days, we do not track by the hour. So if a member takes a camera from Tuesday to Thursday, then his contract is marked up with 2 camera uses. But since we are closed on Fridays, the members get a free day, so Friday to Sunday is counted as one day. So that is my problem. I need a calculation that will give me the number of days between Date Out to Date In -but- subtr…

Hi, After desperately trying to figure out and adapt Jason de Loose's calc posted on Experts some days ago, I went with my own brain with this calc. The purpose is to easily adapt it to meet situations where working days could be other than typical week-ends dates, what surely is possible with Jason's...but he's playing with a bit of science I'm missing at the moment. Case(not (IsEmpty(startDate) or IsEmpty(endDate)); Let([ extendedRange = (endDate+(7-DayOfWeek ( endDate )))-(startDate-(DayOfWeek ( startDate )-1)); tobeadded = (DayOfWeek ( startDate )-1)-(DayOfWeek ( startDate )>1)+(7-DayOfWeek ( endDate ))-(DayOfWeek ( endDate )<7)]; extendedRan…

I must be missing something patently obvious here, but I am having issues w/ sorting my client database. I want to track clients' birthdays and have a "birthday" field set up as type date. However, when I sort the records, my oldest client comes up first - not what I want. How do I set up a sort that sorts by calendar month and day, but ignores the year? TIA, AmyP

I am trying to make requested changes for a client to a very primitive database that I didn't design. The client is a carpet cleaning business and uses the database for point-of-sale and accounting and generating reports. It is unbelievably crude. One of the requested changes is to come up with the total number of "days" worked in a given period of time. "Days" is defined as any day in which ANY work was done for any customer. So, if no jobs at all were performed on Monday, then that would equal ZERO days. If 14 jobs were performed on Tuesday, that would equal ONE day. And, if 1 job was performed on Wednesday, that also would equal ONE day. So, the goal is to…

I have a Survey database that I created and there is simply 1 field per question that has about 4-5 answers. For example: Q1. How do you rate our customer service? And then a "radio button" value list of A, B, C, D, F, Don't Know What I would like is for FileMaker to take all of the "Completed" survey's and determine percentages for each answer. Using a calculation/script it performs a find of "Completed" and tally's the A's for question one, divided by Found Count and returns a percentage so that I can see basically: Q1: A - 9% B - 13% C - 22% etc.. Q2: A - 15% etc.. Any ideas are greatly appreciated!! Thanks, Nic

Hi, I'm racking my brains ... I remember seeing somewhere how to extract SOME text from a field. In this instance I have a field entitled "Email From" which contains the usual email format of { "[email protected]" <[email protected]>} and I want to remove the address that's within the <> marks. Trouble is .... I CAN'T REMEMBER. I'd appreciate any pointers Thanks Giles

All, I think I'm missing something in my current setup so any help would be great. I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file. KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2. My problem c…

I have a patient info db in FMP 5.5. Firstname, lastname, and a calc field for wholename. I want the user to get some sort of message if s/he enters a patient twice. I can't seem to figure out how to validate a calculation field as having to be unique. I tried a text field with autoenter data (wholename) validating it as unique but that doesn't work. You need to actually enter something in the field to make it validate. It isn't really practical to script it (although I wrote one that works) unless I can trigger the script upon exiting a field. Even then, the user must tab out of the "comparison" field. Double entries are a nightmare for us. Any suggestions?

Hi everybody - I'm about to get started on some synchronization scripts. We run FM Server in the office, but need to take a copy of the database on the road periodically, then update the version on the server when we get back. Both versions might be changed simultaneously, with new or changed records. This seems like it may get quite complicated as I'm dealing with at least ten tables that refer to each other, so I'm hoping to get some general advice on what works and what doesn't. Any insight would be greatly appreciated, as well as links to existing articles you may know of. Thanks a lot! Justin Kent

I gotta' be missing something here.. I have a repeating field of say.. 20 numbers. "Stack" And, I have another field holding the index I would like to write to. "index" How in the world, from a script, can I write to stack[index]? The setField deal only allows hardcoding of repeating selections. What am I missing here? Many thanks in advance! -jim lee

All, Probably a simply question.... Is there a text function that returns all the values [not summarise] of a field across multiple records selected by a given value? Thanks in advance C

Hello everyone, I've got a problem here that I just can't seem to solve. I have a database of things "A" that I'd like to choose something out of database "B" to link to it. Or, if thing "B" doesn't exist, create one and link the new one. An example would be to link a Drawing number from a database of drawings to a part in a database of parts. There's something like 10,000 drawings so that would be too many for a popup. I'd like the user to be able to just type in the drawing number he wants linked (looking at his part screen) and click a button to link the two. At the time of the cilick I can see if the drawing exists or not. If it does, I just grab i…

Can anyone tell me a source for free databases that people have populated are are allowing free access / downloads? It seems that there is probably thousands of "common information" databases that other could utilize if they could find them.

I have a string of css and I would like to remove all characters inbetween and including the opening and closing tags. '<code>'(code could be any length of characters). I figured there a reursive text substitution would do it. Any ideas?

This seams like it should be simple but for the life of me I can/t figure it out. Problem- Short version... I am entering a "1" and I want to return 001. The filed is a number field with a general number format assigned to it. In Excel you can specify custom number functions by using the ### which will return 001 if I enter a "1" Is there a calculation, operator, or number setting that will make this work. Thanks ahead of time. Joe T.

I have three tables tableA tableB (master join keyID) tableC C is relate to B (b keyID) which holds a foreign key to A. while in C I would like to see relationship to A via B, but after record creation (via server, commit record, all indexed) the relationship will not display untill all files are closed and reopened? is this how it should be? If I but the A_key rigt in C, no problem , but what a drag.

Hi, Here is an easy one (maybe), but I couldn't figure it out. In a list report, how do I number each list line entry with a sequential number, beginning with the number one? Thanks, Will

I do not have much experience with encryption, so when I made a system that had it's own Users, Groups, etc for controlling security in accessed tables, I slapped together a quick solution that I was never really happy with. It used unstored calculation fields which parsed and converted one character to another. It was just a simple substitution of one character for another. My question is this: Has anyone made public anything in FMP for password encryption? I know that FMP 7 has its own user/groups security now with passwords, but I am not going to be using the encryption for that purpose, so I still have the same problem of trying to find a better way of encryp…

Hello, I am trying to create a calculation in which a field is filled in according to its portal row in a relationship. Each record in the relationship will only show up in the portal once. Is this possible? J

I might be posting this in the wrong area, but no other area seemed right. For no other reason than to say that I could and did, I want to develop a yahtzee game in FIlemaker. Creating the layout/graphics/eye candy is no problem for me, but I feel that I'm spending a LOT of time trying to figure out the calculations and "background" stuff (for ex. - calculating if the 5 dice is a large strait) My question is this - has anyone ever attempted to do something simular to this in Filemaker? If so, could you share the source code with me? Or, at minimum, give me some ideas on how to build this?

My company is in the wholesale embroidery business. The way our pricing is based is by the number of stitches in a particular design, and the quantity of garments we produce. This is on a sliding scale. The way it works is "X" amount is charged for the first 3,000 stitches and then a factor is applied to the additional # of stitches based on quantity. Price list looks like this: (sorry I can't get this table to format in the forum) First 3K Sts Base Price 1-11 12-23 24-47 48-71 72-143 144-576 577-1,200 $5.50 $3.45 $2.90 $2.10 $1.90 $1.70 $1.50 Price per additional 1000 stitches .55 .35 .30 .27 .27 .27 .2…

A client just asked for an odd request. They would like to have the ablity to offset the page numbering. So they have found their set of records and before they print a script would prompt them 'what number would you like to give the first page?' (from there there the follow pages would go in sequence) There situation is that the FMP data is only in various sections in a number of binders.

I am looking for a way to store an email password in a datafile (for emailing of course) but after the password is entered (or while entering) I would like the characters to be replaced with asterisks (*). Upon saving the layout should never show the password in plain text. TIA, Jim

I have a simple table of name that I would like to create a random draw of 35 non-repetative names, where would I start with this?

Get(UserCount) function will do just the counting but can I get a list of user names?

OK, this what I need to happen. A user pushes a button to create a new record. A script checks to see how many records there are. If there are 5, a window saying "you can't have more than 5" pops up and stops the script. If there are less than 5 then the script will create a new record and quit. How do I write this script? I know how to create a new record and display a message in a window. How do you test to see how many records there are? Thanks for your time

I would like a custom dialogue set some globle fields yet it does not.

My real job is Graphic Designer (sorry for my bad English) Here is the Idea I have design (And Copy) the last 2 years over a 3.000 Graphic Elements (GE) with Over A 500.000 VARIANTS I wrote an automation with applescript Quickeys And Serious Photoshop Action to make the production of Defferent Colours and Sizes The reason is to have a table or a file with this Graphic Elements in and relation them with Global fields in any of my databases The format is PNG the only format that support tranparency. I seperate the Huge collection with these categories Arrows RadioButtons SquearButtons Windows PopUp Menus Down PopUp Menus UP & Down Chec…

hi, ive got a little problem here. what i have is i want a price distributed among 3 fields (that means i have 4 fields, the price and the 3 other fields). these 3 fields are like interest/discounts/anything. for example, the 1st field has a maximum of let me say, just 0. the second, 350 and the third, 9,500. so when i pay 9,850, it should show the values of the 1st as 0, second 350 and third 9,500. ok, now for some complications. for example i only pay 5,000. the 1st field must be 0, second, 350 and third, 4,650. so i still have a balance of 4,850 right? so the next time i pay, it must only add what i pay in the 3rd field. like when i only paid 1,000. 1st field = 0,…

Lets say I have 4 fields: 1: Job Title - Which is a text field with a value list of positions we offer. 2: Hour Type - Which is a calculation based on job title. If(Job Title = "Manager"; "Salary"; "Hourly") 3: Amount Per Hour 4: Amount Per Year Below these fields 1 calculations field named "Yearly Amount" looks at field three and does a calculation if true and does another if false. Everything is working great except I want to make this thing dummy proof. My goal is to have either field 3 or 4 show up on the layout or have the opposite blocked out (whichever is easiest) and show one or the other. Since I may have confused you here is what I w…

I have a field formatted to display checkbox's [about 25 values contained in a value list]and each time I create a new record in my table I want this field to automatically select a pre-determined set of these values. Once the record is created, the user can then decide to select more options and/or de-select some of the pre-determined options. Does anyone know of an easy way to accomplish this. Thnx

I am looking to create a calculation with a result that is based on 2 different text fields. For example: field one contains "Blue" and field two contains "Red", I want to show a result of "purple". Any suggestions?

Hi All, Quick question...how do I format or calculate a number field to add a $ symbol plus a decimal to the number? Example: number entered into the field 12345, when I tab out of the field I would like the number to show $123.45 Thanks in advance, Sheryl Update: I found RussBaker's Handy Bits file and was able to get the $ and decimal to display, but the number that displayed was $12,345.00. Does anyone know how to get the number to display without the zeros? Just display the actual number $123.45 thanks again, sheryl

Hi All, I am trying to import the MetaData from Photoshop image files (found at File>File Info) into a FM Database. And am having trouble with the ScriptMaker script. Here is what I have done so far. I am using the LOOP Script from a Troi plug-in <http://troi.com>, then put the MetaData sub-scripts (also from Troi) inside it. "#

I'm working on a day view schedule. I have a Schedule table with the schedule view. This table contains one record and is used merely for the interface. Globals fields are populated at login with date and time variables. When a user logs in, a set of time blocks is created for him or her. These act as a join between the schedule view and the Appointments table. One thing to note, the schedule shows each user's appointments for the day with user names down the right side and appointment time across the top (ie: time-line view). There are 20 portals on the view (from 10am - 7:30pm in 1/2 hour increments). Here's my question. Is it possible to construct the name…

OK, here's another suicide mission: User inputs text into textfield. The text includes some user-defined labels. User enters user-defined labels into a repeating field, say up to 10 labels. User enters corresponding values into another repeating field. Example: textfield = "Please contact me at address." labelfield[1] = "address" valuefield[1] = "100 Rodeo Drive" My job is to replace the labels with their corresponding values. Easy, right? Nested Substitute(). But consider this: textfield = "Please contact me at address, or at homeaddress." labelfield[1] = "address" labelfield[2] = "homeaddress" or, at the user's whim: labe…

I need to add the number of days between today's date and somebody's hire date. Currently I have a field that is not shown on the layout named Current Date. The other field is named Hire Date. The field I want to display the number of days is called Days Employed. I have it set as a number field with a calculation. The calculation is Current Date - Hire Date. What I want is to not be able to change this value and have it perform the calculation. I am lost. I am a newbie to this so please be nice.

I need a help please! (sorry for my bad english!!!! I have 2 tables 1rst "Words" and 2nd Synonyms In the first table I have The "Name of the word" field I have and a second field named "Synonyms Source" where I can paste the Synonyms of the active word. The source of synonyms (out of file maker where I copy theme) has the synonyms words in "comma delimited" Example The word "enter" has the synonyms access, arrive, barge in, blow in, break in, breeze in, burst in, bust in, butt in, come, come in, crack, crawl, creep, crowd in, drive in, drop in, fall into, gain entree, get in, go in, horn in, immigrate, infiltrate, ingress, insert, insinuate, introduce, …