The Left Brain

I have attached a report I created that shows how many sheets of a colored material will be needed to create a specific number of cuts of a certain size. What I can't figure out is how then to create a report that shows the total number of sheets per color for all sizes. The "# of Cuts" field is a summery field and the "Sheets" field is a calculation based on the "# of Cuts" field that does the math to find how many sheets are necessary. Hope this makes sense. 2.pdf

Hello All, I have a quick question. I have a layout in which I want the user to HAVE to click on my 'save' button. Currently all you have to do is exit the record or click somewhere outside the fields and the record will be saved. I have a 'save' button and it works but it is not mandatory... I want to make it mandatory. All help is appreciated.

I’m working with the Insert File script step for the first time. When I specify “Store only a reference” and then Insert File, a subsequent GetAsText(:: brings back the following: [color:orange]file:Example.txt filewin:/C:/TestDir/SubDir/Example.txt When I uncheck that option and then Insert File, a GetAsText(:: brings back only [color:orange]Example.txt What I want is the actual text contents of the file to be saved away in the container. With the option unchecked, is the file’s text actually in the container? If so, what calculation can get it out in order to display it? BTW, with either of the above options, a right-click “Export Field Conte…

I need a button to perform a task. I want it to create a new record but only have the content from a single field from the previous record be populated. It must be done from a button. Any advice on the way to accomplish this?

Hi to everyone, I would like to make database of newspaper subscribers but I have one big problem and I was wondering is it possible to do it with Filemaker. So problem is with printing labels for packages. Let say that Jon Doe is receiving 160 copy's of newspapers but maximum number per package is 100 pieces so, whan I print labels it should be two labels with name Jon Doe, one label for 100 pieces and another for the rest of total number of Jon Doe order (60) so the total will be 160 copy's. In this case it is not necessary to print number of copy's on label but just two labels with the same name Jon Doe if his order is 160 and maximum number per package is 100. …

using a technique to sort portal items if i want to move an item up or down add an decimal to the sort order, like 2.5 will place item between 1 and 2. Then I run a script trigger after that to perform an operation that would re-serialize the sort order. Option A GTRR to the portal records, sort, go to the first then replace 1 increment by 1 then go back to original layout. (or use off screen window { haven't tested on windows may create window dancing } ) Option B Loop thru the portal resetting the sort number incrementing accordingly. Which would be cleaner and most efficient? thanx S

I'm putting together my first FM project and I've designed an audit trail based heavily on Nightwing's superlog system (http://tinyurl.com/bcdvqv) and a Filemaker Magazine tutorial (http://tinyurl.com/d2t8nh). The way my variant on these two techniques works is: (1) Every time a change is made to a record, the details of that change are added to an "audit_log" field in that record. This is all done via a custom function. (2) When the record is committed, the DoScript plug in triggers a script which cuts the contents of the "audit_log" field and pastes them into a "log processor" table. A script then parses the audit log so that it is recorded in a table. Thi…

I'm trying to figure out how I can convert a payment amount to an amount in text as shown on a typical check. Has anyone tried to do this? The problem I'm having is if the payment is 5012, 5012.1 or 5012.02, I can't find a number calculation or calculations that can force the amount to always have 2 digits after the decimal. Any suggestions?

I would like to add a sound file to a button to give the user better feedback that the button has been clicked. I can't find a script command to do this though. Any ideas how it might be done?

This thread seemed to die a painfull death, so I'm trying again! I've investigated some results on things like "Finds across multiple tables", "Reports from mulitple tables", and the vast majority of results come from very sophisticated developers using vast scrips and cryptic field names. My Goal: To have a seperate layout where my cleint can go, put in a beginning date and end date....either hit a search button or have the system dynamically show the search results (in a portal?) and have the system automatically do a sum calculation. If the results from the invoice and expense table have to be shown seperatly, so be it, as long as I can do a calcu…

It's me again folks, hoping I get some advice before I dive into the next section of my database here. My client wan't to be able to print out a report of his expenses and invoices to take to his accountant. I have an invoice table and a expenses table. I know I preform a find function, but I was hoping I can get this to generate a form of some sort where he puts in the beginning date and an end date, and the search pulls records from BOTH databases, sorts them by data (both records togethor) then finally does a tally at the end. Where would I start?:

Would anyone happen to know of a simple way to test that a field actually has some printable characters in it -- and not just blanks, tabs, carriage returns and the like. I'd like to be able to set a Yes/No indicator when the field is "occupied". Thanks for any help.

I am looking for someone to coach me through building my first recursive CF. Scenario... Text field 1 record 1 contains "refste231" cf returns "refste" which is everything left of the first number in the string. Text field 1 record 2 contains "1q2w3e" cf returns null because left most char in the string is a number. Text field 1 record 3 contains "r324" cf returns "r" which is everything left of the first number in the string. Any thoughts on how to get this to work?

I'm currently trying to build a costing database for the family business. Although I started with great ideas for the database, I'm now beginning to struggle with my knowledge of Filemaker!! I'm normally very resourceful with this type of thing and very thorough, unfortunately I do not have that luxury on this project due to timescales!! I am fairly new to Filemaker but have had past experiences with database design at Uni and am confident that when I get going, all will bloom! The struggle is getting going!! I'll explain the database that I'm trying to make and maybe someone could give me tips on the best way to achieving my goal. Please be weary... the li…

Have a simple database where the solution could be in English mode or Metric mode Have a few fields height, width, length, depth, weight If the solution is in "English Mode" then all data entered is in "inches" for dimensions and "pounds" for weight. If we switch to Metric then the data should reflect "cm" or "kg" trying to do this with as few as fields as necessary - was thinking of one field for each "mode" and using auto enter on each field. And when the solution changes mode ( depending on where it's deployed ) was going to update the preference field and then run a script to re-evaluate said fields. Thoughts or existing examples? Thanks St…

Question: Does anyone have a solution for sorting the contents of a text field? I have a field that is populated by a checkbox... since the boxes can be checked in any order, the text field itself is populated randomly. When I export the contents, I want them sorted alphabetically. I could write a script that pushes them out to a shell command, but I was hoping for something more cross-platform. Any ideas? Thanks!!

Hello All, I am currently using a modified version of dacons mail.it plugin with their sample file. I have about 10 accounts in the file. I have contacted their tech support and they can not offer any explanations as to why when it gets to about 1 gb in size the file gets corrupted and I have to recover it about every 2 weeks. I need a solution to accomplish this as we have customer service reps who use the email system constantly during the day. i need something that will not get corrupt, or if there are certain practices I can do for this not to happen. Any recommendations on the current platform or a new platform would be welcome.

Alright, thanks for the help on the Conditional Value list! I managed to make one that worked with my exsisting database, but for some reason, I cannot duplicate my results in the area I need it. I tried to duplicate my relationships to the OrderLine table, but the same set-up would not work. Please, if anyone could, download the database file I have here and you'll see what I mean. The example conditional value list is Layout #7, and I need it to function line it does there, but on a line in the Orders, OrderLine portal. LJCT_1.0.fp7.zip

Hi. I have an old address book (.cwk) that clumped the first and last name together. I am hoping to create a new field that trims the last word off of text value in this field so I'm left with everything but the last name. I've tried a few calcs but I can't seem to get this working.

Does anyone know of a simple method to obfuscate text strings with something like the XOR encoding method? Could it be done with an XML style sheet? This will primarily be used for "soft encryption" of email contents of a few hundred words. Thanks in advance for any advice.

My Client works with a variety of different manufacturers, each with their own CSV file that I need to import into a master Filemaker Database. Because the fields are different from each manufacturer, I have to manually rename the fields of the manufacturers to match the Filemaker fields. Is there a script to rename Filemaker field names?

Hi all, I am creating a system that logs bookings for staff members and would like to know how to calculate the amount of time between START and END fields. This would then be rounded up or down and used to calculate billable hours. Has anyone here done anything like this before? Kind Regards R

ok I have been distracted so I haven't had a chance to fully think this thru so I thought I'd ask one of you mathematicians : ... Trying to calculate the true APR for a Truth in Lending Document. here is the data I have Rate 18% ® Amount: 20,000 (a) Fee: 1,800 (f) Total Loan Amt: 21,800 (l) interest only payments is 15 (iot) months at $125 (io_min) amortized payments is 120 (at) months at 447.40 (a_pay) Capitalized interest is 3,030.00 © Adjust loan balance is 24,830 (adj) Total Interest paid is 30,732.98 (ti) Total Paid is 55,562.98 (tp) Total Finance Charge 35,562.98 (tf)

Ok, here is real hard one...granted the last one wasn't! I figure this is going to involve Logic Functions. This is a basic invoicing system that has a table for the invoice, line items, and products. In the products database I have a feild for Category, Sub-Category and Manufacture. In the invoice layout, I want the user to select Category (which will be an auto generated value list) choose an option...that will then eaither open, or simply reduce the number of available sub categories available in the next menu. Once he selects a sub-category, he'll then be able to do the same to the Manufacture...untill finally he is presented with a list of products from t…

I am doing up a simple product database for a cleint that is selling cofee. He gets his products in grams and ounces, but need to feed it into a single feild so a further calculation can be run to calculate costs per pot and per cup. I would like to be able to the amount of the weight in, then select the type of weight (oz or g) then have it auto calculate that into lbs, but the key is that the result is to end up in the same feild. The calculations are easy, but setting it up to use one calculation when oz is selected, and another when g are used is what I'm having trouble with! Please help!

I am working on a Meeting Minutes Database. It will: - Have a list of members - Create the Agenda - Keep minutes from meeting - Task list tracker from each meeting - Email Agenda and Minutes to members - Print PDF copies At this stage I have a table "Meeting" and "Members" table. I also have a table called "Attendees". The Meeting Table has fields: - Meeting ID - Purpose - Date - Venue - Start Time - Organisation I want to be able to choose from the "Members" table those who will be attending the meeting and have them displayed in a list under the "Meeting" details. I have no real idea how to do this (although I would say a portal wo…

I am trying to trigger a java program using the Send DDE execute script step and I cant seem to wrap my head around how to do it. The program is triggered by a .bat file that is located in a local folder that is listed in the Windows XP path statement so I can, theoretically, execute it from anywhere. The required command line entry is xml-dir-listing -o MusicList.xml "Z:Songs" where "xlm-dir-listing" is the program, "-o MusicLIst.xml" specifies the output file name, and ""Z:Songs"" specifies the directory to list. Any thoughts on how to get this to work via FM script?. PS The file is not multi user enabled in any way

Hello all, This is probably the hundredth time someone has asked this question, but I couldn't locate it on the forum. Maybe I just didn't do the proper search. My apologies in advance, if that is the case. I want to implement a dynamic "hyperlink" in a Ver. 8 file to open a URL in a browser. This is to use on a contact's form to get to their company's site. I assume it will require calling an Applescript, which I am not really conversant in. Can someone point me to a ready made resource for such? Thanks much.

Hello all, I'm building a new system to look after a hire inventory. I'd like to ask the room how they would approach this as a solution. I will have a "jobs" table which will relate to an "equipment" table. There should also be an "inventory" table detailing what items are offered for hire and how many are available for hire. I'd want to compare what jobs occur simultaneously and return a how many are left free for hire. Returning qty available for a specific date would be ideal also. Many thanks in advance.

Hello, I have recently learned that starting in September thanks to a joint venture I am going to have a couple dozen Windows XP users connecting to a database that up to this point has only ever been used by Mac OS X users and all the externally linked files are on AppleShare servers with links that are unintelligible to Windows. My first blush impression was that this could be accomplished with Samba - unfortunately Mac OS X appears to want the link formatted smb://10.0... while Windows seems to be looking for 10.0... as it is any other Windows share. I was thinking I would make a toggle so the user could select Mac or Windows and adjust the path automati…

I need to create a found set report the tricky part to me is. I cant create a script or calculation because well im not that advanced.(my reports come out endless) My problem is i have fields 1-10, On some records there is text in field 1, and none in the others. on some records there is text in field 5 and none in the others. On other records 1-10 are filled in. i need to create a report but only pull from the fields that have text in them! any help would be much appreciated! thank you for taking the time to review this!

Hello everyone! I am working on a database for an artist's estate containing information about all of his artwork. There are two related files. Lets call them "artist_main" and "artist_owners". In "artist_owners" information about the artwork's current owner, like name, address etc., is stored. As there are owners who do not wish to appear in any listing or publication, I have a field called "owner privacy" that has two options to choose from: public or private (value list, radio button set). In the future, art historians will come to the estate to look at the database. They will only be allowed to look at the "artist_main" file. What I am trying to do now is …

Hi everyone, I am building a forecasting tool for the horticultural industry and part of the problem is that the week I forecast in sales is not the week I need the production data for, so I have developed a global field which gives me the field name I need the script to paste into. I cannot find a way to change the contents of the field name to a proper field name in scriptmaker. Or is it not possible to do? I would really welcome some extra help. Here is my example. GLOBAL WEEK NO 1 = 4 GLOBAL FIELD NAME = QUANTITY WEEK GLOBAL FIELD NAME = QUANTITY WEEK 4 now I want to paste into QUANTITY WEEK 4 but can I use "Set Field"? or Insert text? I cannot see …

Setting up a field to store IP address. I want the field to require a unique value except when its set to the value DHCP. I'm never really dabbled with Validation other than default options when defining a field. I'd appreciate any help in getting me started in the right direction on this one. TIA.

Hiya again guys and girls. I have encountered new problem in my database. Anyway here is idea again: I have project list of project that I have done. Now I have let say 40 different projects in my database and when I use find to search projects what I have done e.g. 12.12.2008 and I could see a list of projects that contains that day. Problem: I have no idea is this possible or not. So I seek your guidance in this problem: How to make list of project names that I have.

Hi, FM9A, X.5.6 I have a first name field, and want to parse the value as lowercase into a variable (which is then used for a pdf password...) e.g. Chris >> chris I have tried numerous variations: TextStyleAdd ( name ; Lowercase) TextFormatRemove ( name ) TextStyleRemove ( name; AllStyles ) as well as setting a global as an intermediate, but the $ insists on returning Title case (Chris) Any suggestions?

Sorry if this topic is in the wrong location but I wasn't sure where to post it. A couple years back on FileMakerMagizine.com Matt P. posted this very useful file for Auto Formatting fields. However, it stopped working I believe with the 8.0v2 update. Link to article: ( http://www.filemakermagazine.com/videos/auto-formatting-filemaker-7-fields.html) The basics of the feature was to have 2 fields, one for entering notes (NoteEntry) the other to display the notes (NoteLog). Clicking on a button triggered a script that put in the in the NoteEntry field, you typed your notes, then when you exited the field your notes and a time stamp would be appended to the Note…

I have several email merges to send, using 360Works FYI, but that part is fine. What I'm having trouble with is making it childsplay to use tags within the body to replace with field values. Here's what I'd ideally like to do: Substitution_Tag field contains the tag names to be searched within the body, each separated by a carriage return. Substitution_Fields field containing the names of the table fields to be used as the value to replace the tag, again separated by carriage returns to match the tags in above field. I can do the loop, using GetValue and could use GetLayoutObjectAttribute to identify each field of the database, but that'd take forever and…

I'm starting some research into a solution and thought I'd throw out the problem here for comments... The goal is to automate what is now a HUGELY manual task. I NEED TO CONTROL A SCANNER. I will be scanning multiple page 2 sided documents (file format is TBD) and storing them as references in the target FMP record to a shared volume. These will be in a DOCS table related to an APPLICATION record. Environment will be networked FMP 9 on Windows XP. I will be buying a new scanner, plug-ins and/or custom scripts can be used - no limits in that area. I NEED A CONCATENATED PDF. The end result is an US standard letter format multipage PDF of all of these scan…

Hiya all again... More problems to be solved. So anyway my guestion is this: I have field let's call it background. Idea is that I write background information in that field and when I print it all what I have write will be printed. Problem: I create field, but I cannot make it to resize itself when I write text in it. And it looks stupid if I make that field height like two papers just because I need to be sure that all I write will be printed afterwards. And there is other fields after this one so I cannot make this field take two papers if I only write just two lines text, but again it needs to be large enough that it can take like 50 l…

Hi How would you to extract a string between "TxtC" an "TxtA" ("TxtB") with a function like this one Function ( "TxtA TxtA TxtA TxtB TxtC TxtA"; "TxtC" ; 1 ; "TxtA" ; 1 ) -> "TxtB" ? Thanks!

I have a Job table, and a related activity table. On the job layout I would like to have a side bar showing the most recent activity for any job. But... I would like it summarized. So if job C had a few activities added to it, and job E also had a few activities added to it. I would like the top two lines of the sidebar show job C and E.

I have a file that relates a list of template descriptions to a field in a second layout. I would like to set the template text up as a button and when activated have the text placed in the field of the second layout. This much I can accomplish but where I get stuck is if I want to add more information from the template descriptors to the layout field. (eg.) Blue Eyes, Blonde Hair, Pierced Ears. I can only transfer one, when I click on the second it replaces the first. Any help is appreciated.

Hello, I have a small, simple database of organization members. I'd like to have a field (Paid_Year) that shows the following: If the paid date (PD_Date) is equal to or after October 1st of the current year the field shows the following year. If it is before that date but after the previous October 1st it will show the current year (and, of course, will update as time goes by). Any other paid date would return an empty field (or perhaps "not current"). I apologize if this is really obvious. I've been playing around with it and haven't found anything that really works. Thanks in advance for any help! Deborah

I'm trying to help a nonprofit streamline its workflow for handling and processing donations. I'd like to set their database up so that a user can generate and print an acknowledgment right after recording a donation. But I'm not sure of the best way to incorporate this into the design of the database. Some relevant points: I assume that the acknowledgement letters will contain text generated by a script. The script will be drawing on data from at least two tables (donors and donations), and certain elements of the text will vary from letter to letter, depending on the donor's locale, the nature of the pledge, etc. Also, some letters will contain Hebrew text.…

Hi all A script takes the user into a layout and enters find mode The user enters their search criteria then clicks the FIND button The FIND button is linked to a script that performs the find and takes the user to a different layout to display the find results The problem I have is if during the find, the user presses Enter/Return - this performs the find and keeps them on the Find Layout rather than the script running and taking the user to the results layout. Is there any way to make Enter/Return to run the script or to disable these keys whilst in Find Mode? Many thanks for any advice!

Hi Everyone, I have a DB with 2 Tables. One is the staff list. Each record his a person with contact information fields: Name, email , phone etc . . . The other one is base on (Job) that we are working on. Each record is a job. The fields are mostly to describe the job ; duration, location, description, status, etc. Also I have few fields about who are assigned to work on it and what task they have to do. These fields are "Drop-Down List" that uses the values of the other database ( the staff one).So a list of all the people appear to chose from so i can i assign them to the job. Here the question: I want to add a "button" that would lunch a script that …

Has anyone seen a calc or custom function for converting a number range into a return separated list? 1-4 = 1 2 3 4

I am a beginner with Filemaker In reading the forum, there are answers that have attachments. When I save/open the attachments filemaker comes up and I see the sample, but when I try to dig deeper to see what is being done I get this error This action cannot be performed because this file is not modifiable. How can I change the file so that I can look at the button setup or field controls that were defined in the samples. Thanks in advance for all help.

Hi Guys, I've been trying to do a calculation field about if a certain job is overdue by -5days, show me an alert. If its overdue by -10days, display another alert. I've been trying to do it with the following calculation; If ( IsEmpty ( paid date ) and days left ≠ date global > -5; "Your Late"; If ( IsEmpty ( paid date ) and days left ≠ date global > -25; "OverDue"; " ")) It only works for 'your late' .. and I'm completely lost. Any help would be much appreciated.

What would be a good database design strategy for something like a road trip planner? One starts with data in a LEG OF TRIP table whose fields are: START LOCATION, FINISH LOCATION, DISTANCE BETWEEN START AND FINISH. When a user inputs an overall start location, an overall finish location, a minimum and maximum number of trip legs, and a minimum and maximum distance of travel, the database would display a list of possible acceptable itineraries connecting the overall start and finish locations, perhaps sorted based on some user-specified parameters such as by number of trip legs. Let us suppose that the number of trip legs and combinations thereof are too large to simp…

Hi all... I am just getting started with portals and have a question.... Currently I have a Portal setup that displays the results of payments from customers.... Payments are divided into 3 groups... "Dues", "Contributions', and 'Events'. When my portal displays the information I have learned that I can sort this information in order of Dues, Contributions and Events... BUT.. I would like this portal to display ONLY 'Dues' and NOT the others. All help appreciated.

See Attached… don't think i can do this even with a recursive but if anyone has any ideas i would appreciate it. best Stuart DIRECTORY.fp7.zip

Hi, I was just wondering if someone could please point me in the right direction of how to design a database I need. We have this thing in Australia called the Melbourne cup and work sweepstakes are very big on this day. The key points to the database would be 1. horse names 2. staff names 3. share values Each person can have as many shares as they like. The types of shares will be $1, $2, and $5. So for example if there are 15 horses running, and there are 3x$1, 2x$2 and 1x$5 there are effectively 45 x $1 records 30 x $2 records 15 x $5 records Lets say someone purchase 3x$1, 1x$2 and 1x$5 being a $10 payment. I wou…

I have a rather messy tab-delimited text file that I'm importing into FMP 8.5 I've done the best I can to format it for reasonable import, but I still have data mixed within fields. Basically, quite a number of one particular field (in >3000 records) looks like this: MAINFIELDENTRY (wrongfieldentry1) MAINFIELDENTRY (wrongfieldentry1, wrongfieldentry2) The proper field contain the proper entries, but they may then be followed by additional data--contained within parentheses--that belong in a different field. How can I automate--script, I suppose--cutting wrongfieldentry and pasting it into the correct one? Bonus if I can automatically get rid of the e…

Hello all and thanks for any help you can give. I am working on a FM database that I am creating. I am still new but a fast learner so again any help is appreciated. Here is my scenario: I want field 'X' from table 'A' to be automatically entered from the results of field 'Y' from table 'B'. In other words: Upon entering the data "DUES" in field 'X' of table 'A'..... I want field 'Y' of table 'B' to be automatically filled with data "CURRENT"... Thanks again...

This shouldn't be rocket science, but i can't locate a solution anywhere. i want to force users to enter the proper upper/lower case while doing data entry. I can't seem to find the correct solution. Anyone have the answer?

Is there a way to name an exported file via a calculation or merge field? thanks

how do you get a text field to read a repeating field with text....i cant get a result of 1 or 2 Example: I have a text field-A with text in it "M-01" Then i have Repeating field with text in it "S-01", "W-01", "M-01" I need a calculation that says that Text field A has something in common with the Repeating field...the "M-01 is in both fields"....need a number result of 1...meaning yes If the Text field A does not match the repeating field then i need a number of 0...meaning no

What is the best way to calculate the following incrementing results in to a repeating field using the Get (CalculationRepetition) function Rep 1 = 1 Rep 2 = 2 Rep 3 = 4 Rep 4 = 8 Rep 5 = 16 Rep 6 = 32 Rep 7 = 64 Rep 8 = 128 Rep 9 = 256 Rep 10 = 512… I am sure i have done this simply before but can not remember how or locate it. many thanks Stuart

I am making a database program to automate game turns for a proportional movement game system, and cannot figure how to have FM sort the units moving each turn. Each record is a different unit, saving the unit's speed, information, etc. There are 32 separate moves per turn, with some, none, or all of the units moving during each of the 32 segments. Whether a unit moves depends on its speed, i.e., something moving Speed 32 will move each segment, something moving Speed 16 will move every other segment, something moving Speed 4 will move every eighth segment, etc. I have it set up by a separate field for Segment 1, Segment 2, etc., to calculate whether a unit moves …

I need to calc a field based on the current date. Here is the criteria: If the date_active > today then "preliminary" If the date_active < or = today AND the date_owo = 00/00 then "active" If the date_active < or = today AND the date_owo > today then "active" If the date_active < or = today AND the date_owo < or = today then "inactive" Here is what I have, but it's not working right. Case ( date_active > Get ( CurrentDate ) ; "preliminary" ; and ( date_active ≤ Get ( CurrentDate ) ; date_owo = "00/00" ) ; "active" ; and ( date_active ≤ Get ( CurrentDate ) ; date_owo > Get ( CurrentDate ) ) ; "acti…

I need to create a script to import a file into my database, that is not tab delimeted (a flat file). Its records are defined with a return, however each field is a designated number of characters long and not separated. Eg: field 1 = 9 characters field 2 = 30 characters field 3 = 10 characters etc. There are no tabs, commas or semicolons separating the fields. Thanks for any help!! Much appreciated.

I've got a table that has records of stays by individuals at a homeless shelter. Each record has value for an admit date and may or may not have a value for the departure date (if the person hasn't left yet). I've also got two globals that feed a report. I'm trying to calculate the total number of nights during the two dates in the globals. Here's the calc: Let([ today = Get(CurrentDate); startReport = Report Globals::Start Date; endReport = Report Globals::End Date; admit = Individual Admittance::Individual Admission date; depart = Individual Admittance::Individual Departure Date; depart = Case(IsEmpty(depart); today; depart); en…

how do you get a text field to read a repeating field with text....i cant get a result of 1 or 2 Example: I have a text field-A with text in it "M-01" Then i have Repeating field with text in it "S-01", "W-01", "M-01" I need a calculation that says that Text field A has something in common with the Repeating field...the "M-01 is in both fields"....need a number result of 1...meaning yes If the Text field A does not match the repeating field then i need a number of 0...meaning no

Hi, I have a little problem and I'm sure the solution is simple but I just can't figure it out. I want to generate emails to my clients and include their names, etc in the email. I'm not sure how to call the data from the field. If using a simple calculation I'd just put <> but that doesn't work if I just type it into a textbox. Any ideas? Thanks! - Randall

Anybody have any techniques that get around the fact that when you click on another field or a portal, the element gains focus and the selection in the present element is lost. I am inserting text into the selected point in a field. I'd like to do it from a button in a portal but the selection is lost the second its clicked on. right now I'm using buttons over a repeating field (because making the field the button has the same problem). And I did try the same thing with buttons over a portal which did work (requires the button to extend past the portal). but these solutions are quite inelegant and prevent any scrolling as the buttons are static. Any though…

Any ideas on multi-level sorting? I've got a client who wants to be able to sort on one or more of 7 different fields. Right now the data is in a portal, but I don't mind popping up a new window. Tab sorting is too drastic, I'd need 7! (that's 7 factorial, not 7 oh-my-gosh) tab panels. Oh, actually it's 14! sort states if I include ascending/descending. Just typing this out makes me realize the best answer I have is to open up the native Sort... dialog but I'm a little shy about the user having access to all the fields of the table and related tables available and the dialog itself is scary. The client is an elderly woman who wants the interface as simple…

I am am a filemaker beginner who is also learning databases in general for the first time as I go. I have completed a couple sucessful multi-relational databases (simple ones) so far and am trying my hand at another. I work for an archaeology company and am trying to design a database for our faunal bone collection. Right now I have three tables: Sites-->Specimins-->Cuts. Both of these relationships are one to many. What I would like to do now is create a calculation that automatically fills in taxonomy when you enter the common name for a specimin. So when we enter "Cow" under common name (specimin table) it automatically fills in the kingdom, phylum, orde…

I have a field in a Sub-Summary Part that is creating a list of totals when sorted. If, for example, this list (when in Preview mode), is five totals long, how can I create a calculation that will give me a sum of only two of the totals? For Example: Green 5 Blue 6 Red 1 Black 2 White 2 The above totals appear in sub-summary fields when sorted by Color. I'd like to create a field that shows the combined totals of Blue and Red in a different sub-summary field. If this were a repeating field, I could choose which repetition of the field to use in a calculation. Perhaps I'm going about it the wrong way? Is there a calculation that will giv…

I have the attached field that I need to run a few calculations of off to validate the size of the field. I have a calculation set to calculate the size of various characters and present a total size of "Character Units" used. A character unit representing the size of a lower case character (Upper case = 1.304113 units, commas and periods, etc = 0.5454545 units based on the font I use) My goal is to validate based on 2 criteria: Character Unit count and number of text lines. The field can not be more than 300 characters, and no more than 10 lines of text (not all lines will have full 30 characters, and some will be have carriage returns to break the line). …

But there are no other windows open. If I open the Data Manager (accept, do not save this record on the way) , and close back out (without doing anything), then it will accept the data. weird. any help is appreciated

situation; Two accounts and a privilege to limit the records access. if i ask for a complete list or omitted records i get all the records, part of the records are accessable and part no. then the question is: How to get only the complete list and relative omitted accessable records? By Franco

Does anyone know why a summary field would not always give me a result? client_id => foreign key count_cls => count of client_id CountByClient => 1 / ( GetSummary ( count_cls; client_id) ) sum_clients => total of CountByClient As expected: count_cls works all the time. CountByClient works when i sort by Client_id however sum_clients only works after i redefine the field to do exactly the same thing as it currently does (i.e. edit, change nothing, save = works). I have used this method in 6 other tables in my system, however in 2 tables it refuses to work. anyone any ideas?

Hi, I'm a Filemaker noob. I hope this is the correct forum to ask a technical question, it seemed like the right one. Anyway I'm in a position now where I'm having to learn Filemaker. I've got a few books, but a lot of the time I can't quite grok what I need to do to make something happen. My current problem is that I'm working in a fairly complex database, and for one of the reports that runs it references a calculation field to determine which data to include in the report. The calc field uses a Case function, and it looks like this: Case( ItemType = ""; " "; ItemType = "Ads"; "Yes"; "No" ) So it looks at a field called ItemType to see if the value i…

pls can anyone help me with this script, the script is below, i need the script to get the previous month result every new month , the problem is that the loop has to be automated to always calculate for previous month . a=`date "+%Y"` #this year to be used b=$(date "+%Y%m" --date='49 days ago') #previous month with year to be used for i in 49 48 47 46 45 44 43 42 41 40 39 38 37 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 do g=$(date "+%Y%m%d" --date=''$i' days ago') # n days ago to be used h="lic"$g*405*.txt #the file name cd /home/file/lic$a/$b #the directory #---------- Count information----------# cat $h|awk -F '|' '$4 ~ /^700[0]/ &am…

I've been considering this problem for a while and just can't get a handle on a good approach -- so I'm looking for suggestions (I'm on Windows). Here's the situation: I have a text field that may or may not have a file path/name somewhere in the field. For example: "This is a remark entered by a user. The user might make note of an associated document with a comment like BTW, I put the notes in c:tempnotes.txt if anyone needs them." What I would like to have is an Auto Open function on a button associated with the field that could locate the file (if any) within the text field and use SendEvent to open it. Ideally, it could be made to work exactly the …

I'd like to keep track of the totals, which seems easy by using a simple script to set a few fields like Date, Report Name, and total, in a Log Table. As I think about it more I kind of like to know a little more than how the Total changes. I like to be able to capture all the Contact_IDs and store them in a field along with the total and date. (Can I avoid creating some kind of record for each Contact ID?) I imagine someone has done something similar, if so I like to get your input on making this work and maybe even a few tips for going beyond what I've considered so far.

I have a problem with a field changing number value. Calculated field = $round & "." & $match If the result is 1.1 no problem If the result is 1.10 big problem. It needs to keep the 0 in 1.10 Any ideas? Thanks

Hello guys What is the best approach for evaluating a Path so that it’s a valid Windows file name? The following character are not allowed: / : * ? " < > | Cheers

OK , here goes... A printer can output a print area of 1cm X 10cm in 25 seconds 1cm X 20cm in 35 seconds and 1cm X 40cm in 55 seconds How long will it take to print an area of 20cm X 60cm? I am trying to write a calculation for this and haven't an idea where to start : Calling on the help of any maths geniuses out there!

Hi Guys, I havent been onto this forum in a very long time. I need some help.. How can I stop two clerks adding the same job type twice? The data they are entering is employees who worked on a specific date and the hours they have worked and the division they worked at. The fields used ; Date Worked, Hours Worked, Division, Employee Names. Would I have do to a merge field for all these and do a calculation step? Thanks.

how do I extract the decimals in a number. I want to convert meters in feet and inches. The result should be in the form: 25'8" First I multiply meters x 3.28 = feet and decimals I have to convert those decimals Decimals x 12/100 To achieve this, I have to extract the decimals. How do I acheive this Thanks benicg

Is there any way you can prevent a record to be created/added unless there's a specific field that is entered? If not, is there any way to prevent a field from being entered unless a certain field is entered in first? We have a QUOTE database for our sales people, and we are trying to limit the number of quotes that are being sent out, unless the sales person enters a delivery date for our product. We're seeing way too many quotes being generated, and we are not sure those quotes are valid. We'd like to add a "required date field" to be entered in first, before any of the customer information is entered beyond that. Thanks for any help in advance!

I have a dropdown using a value list based on a dictionary table. It autofills to help the user. Is there a way to prevent typing anything in the field that is not in the value list? We need to limit the choices to words that are in the dictionary only. thanks

What is the best current paradigm for insuring accurate data has been entered. I remember in the old days of high volume keypunch, two keypunchers would key the same data which was then compared at the end of a job for discrepancies. Once the discrepancies were found and corrected, the job was considered validated. Is this still the best strategy in an environment of high volume entries using FM? Thanks. Dave

Currently one of my database system requires the capture of the current date and time. The main problem is that I need accurate dates and time. But the filemaker function to get the current date and time can only get it from the current host PC. There is already an issue where the host PC's date is wrong which results in all the data captured to be inaccurate. I've already installed a software to the PC to sync the date and time from an NTP server. However for some reason the software didn't sync the time. I was wondering if there is any way to implement a data/time verification in filemaker? Or maybe is it possible to get filemaker to query the server for …

I have an old FM5 being upgraded to FM8. As we move multiple related files into tables in one database, we need it such that when you "find" on one layout, moving to another layout constricts to the same "find" as it did with multi-file FM5. I can't seem to find anywhere to look for how this was or should be done other than to use scripting which seems odd if FM5 did it without it.

I have an idea that I could use some input on. I set up a departmental To Do list for a group of users in FileMaker 9. I'm going to have these same users perform a backup of their hard drives every 2 months. So I want to set up a record for that task within the To Do list. In order to mark that the task is complete and have it not show up on their To Do List for the next day, they have to check off a box indicating that the task was completed and enter the date it was completed. What I want to do now is set it up so that when they check off that they completed the desktop backup, FileMaker will automatically create a new record for that specific user with a due…

Hi i am having problems using repetitions, i have a field that you enter a product code in to and the next field looks up from another table but i can only get it to work on the first repetition. Any ideas what im doing wrong ??

Hey Guys - I have a database that serves as a rental system, and there's a field that counts the number of time conflicts with each new reservation. I want to create a new field that will check the conflict field for all existing records and enter "Yes" if there is a record with a conflict number higher than 5, and "No" if there is no number higher than 5. Any tips on what function/calculation to use? Thanks a lot.

I am using a script navigation system based on one from JMO. It is working great! It uses the table name plus a portion of the layout name in combination of a strick layout naming convention to navigate. ie, Get (LayoutTableName) & "_list" in the Sample table navigates to the Sample_list layout. The system has really helped simplify my db. I have introduced various validation scripts and previledge checks. There is one that works when written specifically to the layout, but doesn't when trying to call that layout table name in order to "build" the correct layout name. I'm pretty sure my syntax is off. This portion of the script is to allow…

I have a pref table with a global calc field, that returns the variable; $$title I have done this to display the project name on all layouts. The problem is when the user switches to another project, which changes the $$title variable, the global field in the prefs table (single record) need to be refreshed to display properly. any suggestions on the best way to fresh the prefs filed?

Greetings... I am attempting to build a database, that imports images based upon a relationship of a field name. For example.. I am trying to take a field name "ImageNumber", and use it to refer to the import of an image named the same (with a .TIF file-extension.) e.g: User clicks: "Click to import images" and the script might go through each record, determine the value of "ImageNumber" and use it to import a relative file named [imageNumber].TIF into a container filed on that record. I have tried numerous ways to do this, and I am thinking I am going to have to script it, but I am unfamiliar with the syntax or protocol in which to do this. Has an…

I've searched but had limited success. So I ask, any tips for generating a 10 character alpa-numeric string randomly?

Not sure if this is the right forum for this, but here goes. I know how to make a record conditionally editable by using Custom Privileges in the Privilege Set dialog, but how can I make only one field conditionally editable? For example, I have a text field (Field A)and a numeric field (Field . I only want to allow editing of Field A when, say, Field B > 10. How can I do this? Thanks in advance ...

I apologize for all of the recent questions. This will be my last for a while. I have been working through the FM Training Series. On page 9-6 is a section on Filtered Selection Lists. I cannot get it to work correctly. Attached is the file. The basis is a dictionary of terms. The filtered selection needed is only the colors from that dictionary. I know I have something messed up, but can't find it. Any and all help is welcome. thanks. Filtered_Selection_List_-_06.24.08.zip

I have layouts using global fields as data input tools. When the user is ready, it creates a new record in the correct location and popluates the various fields from the globals. The rub is that I need to validate (unique value) the global against the existing data to prevent duplication. Is there a way to set the global's validate from something that will look at the existing data? I am thinking of something like this (but don't think this syntax is right) isValid (global::abbr_g ≠ data::abbr) Would that check for a unique input? thanks

I have problably changed something, but can't find it. Over the last couple of days I get the following dialog window and a slow response: Sort Records remaining to sort: (then a count #) It has really slowed things down. Can I turn this off? It didn't used to do this. thanks

I have a 3 fields 1) Cost 2) Profit Percentage 3) Retail Now when you put in the cost and the retail in the proper fields the Profit Percentage will show you your profit margin in percentage. Works beautifully, but I also want to have the Profit Percentage be modifiable so if you want to make your profit margin .18 you type that in the Profit Percentage field and the Retail will reflect the change. Basically making a calculation field modifiable. Is this possible?