FileMaker Interface Features
-
Hi everyone, I work for a real estate company and am trying to get a buyer matching system working. I have all the property records in one database and them i am working on a new 'prospects' Database. I am trying to display the matching properties records in a portal in the prospects database I have 2 match fields... property_type and property_area that i want to be able to search by I have a calculation field to concatenate the fields then i use that as a relationship. Then a similar calc field in the property database so the fields match up. (i got that part working from another post here..'using multiple match fields, is this possible?') Well it works…
-
- 3 replies
- 838 views
-
-
Hi All, I would like to display a large field on a form (requires the vertical scroll bar), but in order to "have" the vertical bar the field properties must allow to enter the field... I want to have scroll bar and NOT let the user access the field. Don't want them to change the data... Do I have to create my own up & down buttons to have script do the scroll?? Or did I miss something?? thanks, Dan
-
- 3 replies
- 1.6k views
-
-
Hey guys, i am using a portal for data entry. each line item that is added gets validated as you leave the field be a script. at the end of the script i have go to layout origianl layout so that my users end up where they stated. the problem is that they end up at the wrong layout. it ends up at a layout that directly shows the contents of the portal instead of the original layout which displays the portal. i have also tried passing get(layoutname) into the validation script as it runs. it also passes the name of the layout that directly shows the line items instead of the invoice layout that shows line items in a portal. any ideas? to make matters worse this…
-
- 1 reply
- 742 views
-
-
I'm currently working on a FM7 solution and just something strange happened...In almost every file I got several portals showing whatever and somehow when you create a new record, in two of all these files 1 certain portal appears already with 1 or more filled rows instead of empty as it should! I use to copy the whole database from time to time and work on the most current version. This strange reaction did not appear in any of my drafts until yesterday - but I don't want to go back to an older version, as a kind of workaround for this problem...I can't neither see a reason nor a way to "fix" it...can anybody explain?
-
- 1 reply
- 610 views
-
-
I've just converted a FM4 file to FM7 for testing and some minor modifications before we do a company-wide upgrade. I'm finding that one of my pop-up lists no longer allows a keyboard shortcut to go to a certain part of the list... i.e., in the pop-up list of about 800 client projects, in FM4 users could type a single letter (or 2 or 3 letters if you're fast enough) and go to that part of the list. In the FM7 converted file, this is no longer working. I have another pop-up list (of employee ids) with only about 40 values, and I can still "go to" in that list with a keystroke, but it's not working in my big list. I'm wondering if there's a property or setting tha…
-
- 6 replies
- 1.1k views
-
-
I use a value list with some 6000 values that show all names of the people in a certain database. Actually there's the record's ID and a second field that calculates the full name. Both fields are indexed, the value list is sorted by the calculated name-field. By clicking into the field that holds the list and type-ahead it takes a while to get the right alphabetic character highlighted. I know, the list is quite long and so on but it was much faster in FM6 than it is now in FM7 (7.0v3). Any next time you use the same field it works much faster. Another strange reaction of the type-ahead is that sometimes first the very last value of the list gets highlighted and by typ…
-
- 0 replies
- 680 views
-
-
Hi there all! I have a db (one file), a value list (from field, so the field may contain duplicate values) and need to have the unique values for that field in a portal for further operations (i.e. finding). Example: values in field: a, a, b, c, d, c, a ... portal should show: a, b, c, d only! Any suggestions for building the relationship(s) or solving that general problem? Thanks in advance !! Norbert
-
- 4 replies
- 688 views
-
-
I have two departments that report to me that I must track in my scheduling database. My schedule is viewed in a Portal. Occasionally I need to view only the jobs in one specific department. I have a script which identifies each department with a hidden text field. I am trying to perform a find (via script) so that I can view a specific department within the portal and I am still getting all records. It sounds simple, I think im missing something thats right in front of me
-
- 1 reply
- 603 views
-
-
Will a portal relationship not work if its linked to second occurance of a table? If so, is there a way around it?
-
- 6 replies
- 965 views
-
-
What's the best way to compare the values in a portal? Specifically I want to know things like: is the numerical "amount" of a given portal record higher or lower than the previous "amount" (w/records sorted in portal by date).
-
- 0 replies
- 809 views
-
-
Hi Everyone- Here's my situation. I am creating a searchable catalog for a customer. To make a long story short, I need to have a value list be dynamic in "Find Mode" so if "company name" has been chosen as a search option, it will come off the value list so they cannot add another search criteria with the same field. To throw another wrench into the problem, I need to only have this happen if the user chooses the "and" option. I have found similar postings for this, but they do not work in find mode as far as I can tell. I just can't seem to wrap my mind around this one! I am running in OS X Jaguar and Developer 6. Thank you all in advance! -Ren…
-
- 4 replies
- 1.4k views
-
-
I did a contact database some time ago where the name of the contact was used in a layout as text in the heading <<name>>, I have to use it again but i want to modify the size of the font used. I have tried to select it and change it, it appears fine on layout mode but doesnt change in browse mode. Help please Marco Bahon
-
- 5 replies
- 1k views
-
-
Working in an old database (v4.1)... There are 3 or 4 subsummary parts at the top of the report layout--to allow for different groupings (report grouped by school, by gender, etc). Is there some quick and easy (i.e. drag and drop) way to rearrange the subsummary parts? TIA Abbe
-
- 0 replies
- 682 views
-
-
The app I'm building will be a kiosk mode interface to a database that will run on computers with a variety of screen sizes. I really want to assume at least 1024x768, but I know that some users will only have 800x600 - and others would love to take full advantage of their 1280x1024. I've been looking over books and FileMaker docs and it's beginning to look like managing layouts and windows is going to be a real pain - if I want to try to optimize the app's behavior to all these environments. Can anyone point me to a good discussion of layout design and window management in the presence of various screen sizes? (It doesn't have to be specific to kiosk mode, but it would h…
-
- 2 replies
- 1k views
-
-
Right now I have a layout with a ton of fields--which means you have to scroll down down down to look at all the information. I want to create a layout that will have different pages or tabs for each record so that it opens with a section general information and then can click over to more specific info like contacts or background, rather than scroll down forever. How is this done? thank you in advance.
-
- 1 reply
- 739 views
-
-
Hi all, I'm creating a timesheet database that I can use to track the hours for employees of my consulting business. I've enclosed a copy of my database to illustrate what I'm trying to accomplish. An employee can select which project they're working on (from a pull-down menu) and then enter their hours for that project. The problem is that as we do more and more projects, that "Projects" pull-down menu is going to grow very large and an employee will have to spend 10-15 seconds scrolling through hundreds of projects in order to select the correct project and enter the hours for their work session. Not only will this be inconvenient for them, it will no doubt lead to er…
-
- 1 reply
- 836 views
-
-
I've got a layout with three different portals. There are three different tables that contain customer information, the main layout contains the customer's name and contact info. I've related everything together with unique ID numbers, and my layout with the portals works fine. The problem is when I go to print. The portals don't print well, especially when they break across page boundaries. I can set up a layout with sub-summaries that will display the records from any of the three related tables, but can't seem to figure out how to get all three on the same report sorted first by customer, and then by table.
-
- 1 reply
- 740 views
-
-
I'm new to FM Pro - have a database with prospects by year (text field). I want to create a report which auto filters on the current year, and then displays field details for records which pertain to only the filterered (current) year. How do I do this?
-
- 1 reply
- 777 views
-
-
Hi everyone, I'm working with multiple windows more in vs. 7 than in prior versions ... much more. I've only been opening new windows over the top of each other, using straight layout switches or closing the prior window as I move a User through their process - never minimizing. But I still occasionally get a User trapped with the error "Can't modify because it's being modified in another window" in a few places where I've forgotten to add a Commit Record/Request. Oh dear. I'm reviewing my window-handling processes for several reasons (including many new features in vs. 7 that I'm just now figuring out how to take advantage of) But I have a few questions: …
-
- 3 replies
- 1.2k views
-
-
Hi, I had an idea that in FM7, Portals would no longer be 'refreshed' so that we would no longer have to go through hoops to force Portal Rows to maintain their positions in the Portal. I'm currently altering a Layout and implementing a 'Go To Record' script from a Portal and the Portal is refreshing back to zero each time, which is pretty annoying. Is there some way of implementing this 'feature'? I note that even clicking outside a Portal causes it to 'zero' back to the top? (I know how to work around the problem, so no need to spend time answering that aspect). Thanks, Grant
-
- 7 replies
- 997 views
-
-
I have a database that I have developed for a small transport company. One of my portals shows runs that are pending waiting to be dispatched. I use a calc called IsEmpty=(Dispatch).It shows all runs that are pending no mater what date the run is assigned to. What I need is to only show runs for the current date not tommorow or next week just for todays date, Hope I haven't confused anyone. How can I do this? Thanks in advance.
-
- 1 reply
- 612 views
-
-
I have been tracking donations in a set of repeating fields (date, amount of payment, type of campaign, etc) for the type of campaign i have set up a value list. individuals can donate to more than one campaign so have a lot of folks who have a number of different items in the repeating fields. how do i perform a find request on only one type of campaign without having the other types show up in the found set? ultimately, i want to be able to do caluculations or summaries on how much money has come in from each different campaign in the value list but when i do a find on people who donated to one of the campaigns it also displays any other campaign they do…
-
- 2 replies
- 1k views
-
-
I have a file with basic student information (name, address, city, state, zip, etc.). I
-
- 4 replies
- 800 views
-
-
I was just writing a script that I intended to use to drop the user into a new window and step the window into Layout mode, from Browse, and can't find any way to do that. Strange that there are script steps to enter all of the other modes (and views) except this one. Thinking that I could just do this as an applescript step, I opened FM's dictionary and darned if there isn't a way to do it there either. Yes, it's easy enough to get there by command key, I just wanted to make the user explicitly aware that they were in layout (it's to fine tune a print layout). Anyone have an answer for this? Much appreciated! Tony
-
- 11 replies
- 1.3k views
-
-
good day! i'm on the steering committee for a new non-profit group in the pacific northwest, and trying to teach myself FM for our membership database. i've used it before for really basic stuff like mailing lists, but this may be out of my league. i learned some simple script/query writing years ago, but don't really remember much. for our trade directory, each member has four listings, each listing belonging to one or more of 16 categories in a value list(some listings will belong to several categories). i need to create a columnar table for each different category with all the corresponding listings and the contact info for the member. these tables wil…
-
- 7 replies
- 1.1k views
-
-
I have a subsummary report. Because some parts that are summarized don't have many line items, it would not look nice to have a page break for each part. Some of the parts have quite a few line items, and continue on to the next page. Problem is, the column headers that are in the subsummary part don't print again at the top of the next page. Is there some way I can get the subsummary part to print again at the top of the next page (in an ideal world, with a "Part (continued)" note).. Like so: ------------page 1 Invoices for My Company Invoices for Acme 1 2 3 4 5 Invoices for Baxter 1 2…
-
- 6 replies
- 926 views
-
-
Have 5 Tables: People,Product,License,Catalog and Cataloglineitems To create a Catalog, info is pulled from pull downs from People and Product. One pulldown from People (for Client selection). One pulldown in portal from Product (to add product to portal) One pulldown in portal from People (to add person to portal) the rest come from Cataloglineitem table. Catalog is now created on to the License. Then in License I need to get the exact info created in Catalog + or - a couple of fields to create a license. User first chooses Customer from pulldown coming from People. All of the above working fine...no problemo! NOW...I would like the user …
-
- 0 replies
- 798 views
-
-
I've been trying to make a traker for the finance company i work for. The database holds information on customers who have applied for a loan with us, each application will have a status of Pending, Not Paid, Paid, Declined or Cancelled. I am trying to make it such that each record is colour coded to the state the application is in. I have had some success in making colours appear depending on the state by creatin 5 fields each named as one of the 5 possible states and containing that state. then creating 5 relationship each from the status field to one of the state fields. Then creating 5 portals, one for each state and putting a different colour box in each portal.…
-
- 7 replies
- 1.2k views
-
-
I have a DB based around a table called
-
- 0 replies
- 651 views
-
-
On a file I have used for years, when I am in Browse mode, only one newly created (and not the most recent) field will show me the pop-up value list. This is a file with 12 pop-up value lists. This occurs in all layouts. Any ideas anyone?
-
- 3 replies
- 673 views
-
-
I have a portal set up in a first file to create records in a second file with a relationship where: "When deleting a record in this file, also delete related records" is left unchecked. I have also scripted where a third file will receive the data of the second file in portal with data appearing like that of the portal of the first file. However, if I use a script to clear or cut the fields of the portal, the related records of the second and third file get its corresponding data "cleared" or "cut" too. I would like to use the portal of the first file over and over (without relying on creating a new record in the first file, if possible). One idea …
-
- 4 replies
- 881 views
-
-
I have a database with many layouts. For example, I want to fill the color of blue to the header and footer of all layouts but don't need to do that for each layout individually. The same thing, if I want to change the color, I want a way where I only need to change once... Please let me know if Filemaker Pro has such a feature! Thanks very much! Jie
-
- 1 reply
- 727 views
-
-
Just formated a field with text baselines and was surprised to see that the baselines were displayed over the top of text in the field. Not a problem when the text and baseline are the same color but I need the baseline to be different and I certainly don't want the text obscured by the line. Any ideas?
-
- 31 replies
- 3.1k views
-
-
HI, I have one text field that has one word in it. (this is a global field) I have another field which has a value list in it set up as checkboxes. I have a third field that holds the result of the comparison. Each record will have at least one box checked, but may have more or even all of them checked. For each record i need to compare the text field to the value list field. If the word is checked in the value list field, i need a third field to be marked with something (yes or 1...). If the word is not checked in the value list field then i want the third field to be empty (or produce a 0). I hope i have explained this properly. I have tried vari…
-
- 3 replies
- 772 views
-
-
Hello Experts, I'm stumped. Working in FMP7 on Mac OS X. Bear with me... SHORT VERSION: I would like to create a value list showing only related records, but the underlying relationship needs to be based on a calculation field which references related fields, and so is not indexed. An unindexed field (correct me if I'm wrong) cannot be used as a match field for a relationship. Is there a workaround to create this value list so that it shows only field values from a subset of records in a table? DETAILS: In my business, I sell hours of work to my clients. I have contractors who perform the work and bill me by the hour. Each pairing of client and co…
-
- 2 replies
- 952 views
-
-
I have a contacts database that mainly consists of a pair of tables: Contacts and Contact_Notes. The Contact_Notes database has (3) fields: a Timestamp field, a Contact_ID filed (which is the key field that relates the aforementioned tables), and a Notes_Content field. The idea is that any time a user has communication with someone in the database, they click a button on the main Contacts layout that activates a script that is supposed to create a related contact note record, enter the timestamp, and jump to the Notes_Content field of that record, ready for the user to type their note. The timestamp and Notes_Content fields are displayed through a portal on the main Cont…
-
- 2 replies
- 700 views
-
-
Can we copy the value of a summary field that we have in our portal to a different field? If yes, can anyone tell me on how to do it? I've tried to copy the value to another field using a calculation function, lookup and or get field function but unfortunately, none of them works. Also, is it possible to edit/override the value inside a summary field? Thanks all, I appreciate any kind of your help! Rgds, Ren
-
- 1 reply
- 743 views
-
-
I have a layout that has thirteen other tables portal over information into the layout. Quick example. Thirteen tables indicating shipping violations. One layout, combines all the information based on the date who shipped. I am trying to figure out a way to get the information for only a month and then generate a report showing how many violations each lab had. Is there a way to calculate a result based on the portals? Thanks in advance, Brandon
-
- 5 replies
- 847 views
-
-
I've got a few layouts that are unavoidably long. I'd like to add navigation buttons that allow the user to scroll up or down. Any experienced FMP people have a simple solution? Thanks in advance for your input, Mark
-
- 3 replies
- 694 views
-
-
I have been experimenting with highlighting portal rows according to certain conditions Mostly it works well but I have one problem in portals where a user can create records in related tables. For example I have a table Routings which holds the ID name and notes for an airfare routing. The routing is specified in a number of related tables. Vias, Segments, Direct flights, and Stopovers What I am trying to do in these portals is to validate data as the user enters it. So that if he has entered data in a portal row but it is invalid then the field or row is highlighted acording to the error. I set up a calculated check field to validate the data... if i…
-
- 1 reply
- 619 views
-
-
Greetings! I posted this under Printing Issues, but maybe somebody in here knows what I need: It took me awhile to figure out the ins and outs of a line items file, but some of the posts in here have helped me get out of the "repeating field" and it's confusions. But now I can't figure out something else: To make this as easy as possible, If I can find the set of desired items in a line items file, how do I set up a print layout that is based on other criteria in the items? For example, in a vendors file, sorted by item number, I need to display the status of different orders and inbound shipments. I can find for the vendor and sort by the part numbers, b…
-
- 6 replies
- 905 views
-
-
-
hello. I have a text field in a table, which has information the user can type into. It's about 4 lines high in the data entry form. However, you can put a lot of text in there... obviously if you print that form, you only can see the first 4 lines of text. is there a way to create a report, which will expand the field - or grow the height to show all the text in that field? It could be the text is only 4 lines - but it could be that the text is many lines and there should be a way to adjust that dynamically.. is there? how do you do it? thanks for you help in advance, sincerely, J__
-
- 12 replies
- 1.7k views
-
-
I was wondering if anyone has done something along these lines: A user enters the variable data # of rows and # of columns. Click on a button that would create the records and label a text field for each record. For example, the user enters the following: Number of Rows: 12 Number of Columns: 8 96 records are created, with A1,A2,A3,A4,A5,B1,B2,B3,B4,B5,C1,C2,C3,C4,C5 Etc... TIA, Charlie Abrams
-
- 3 replies
- 758 views
-
-
I have a file for staff which has input for first name, last name, 5 checkboxes (each a different field and value "1"), and 5 fields based on whether the checkboxes are checked or not. For instance, if the person belongs to the custom department, the related checkbox is checked and the persons first name is copied into the "custom department people" field. This is done by Define Database/Field=Calculation. I can then create a value lists in separate files based on the fields in my staff file. So if someone belongs to the custom department, that checkbox is checked and their name will be copied into the "custom department people" field and listed in the value list in …
-
- 2 replies
- 649 views
-
-
Hello, I was wondering if there is a way to stop scrolling with the mouse wheel in windows. I have a Project->Tasks relation (1-M). I have the project data at the top and a portal at the bottom, which shows the descriptions of the tasks. I then click on a Task in the portal and (using go to related record) it takes me to a tasksDetail_Layout, which shows all the good details. The problem is, if i have a mouse wheel, while in that view, i can scroll the wheel and it will take me to other tasks. I'd like to have a way to keep from going to any other tasks when using the wheel. Once i have finished viewing the task and maybe editing it, I want to jump back to…
-
- 8 replies
- 1.2k views
-
-
Hello, hopefully someone can point me in the right direction with this one, I have two value list of times, start time and end time and I have another field that's a calculation field based off of my two time value list when I subtract end time from start time I get and whole number for instance 1, 2, 3 and I would like a more accurate calculation for instance START TIME 4:00 AM END TIME : 5:15 PM RESULT : 13.15 HOURS USED IS THIS POSSIBLE?
-
- 9 replies
- 953 views
-
-
I have a table (not created by me) that has one field (referrals) that has from 1 to 4 inputs. IE - from 1 to 4 persons names. There are other fields with the same problem: address, city, state, zip. I am trying to make and print labels from this field, but so far all I have been able to get is one label, the first name in the field. I have searched and so far have not found an answer. I could redefine each field (refname1,refname2,etc,etc) but then would have to make 4 label layouts for each one. Is there a way I can print each name in the field on a label without going through hoops?
-
- 10 replies
- 1.1k views
-
-
Hi Everyone. Newbie here. I'm having a difficult time understanding filtering records from a portal. I'm using a many-many relationship with a join table between the two related tables. Here's the easiest analogy I can come up with to describe my situation. I have a school. In that school, I have student records and I have class records. Students can be enrolled in multiple classes and classes can have multiple students. I've created a join table to handle this many-many relationship. Now, when I enroll a student in a class, I create a join table record linking the student with the class. I can go to a class layout and, in a portal, see all the students enro…
-
- 17 replies
- 1.8k views
-
-
I need to create a fairly complex database system with a variety of related tables, and am having some issues with the main contact management part of the database. Here
-
- 4 replies
- 804 views
-
-
holas i created a photo data base, which contains a media container (for the images thumbnails) and some text fields (for the metadata). i've already organized the records in a form- and list-layout, but i'd like to view the thumbnails in a layout similar to a photo-gallery on the web (rows AND columns). i tried to rebuild FM's solution (photo catalogue), but didn't get through. does anybody know how to do the gallery-layout or knows how FM's solution work? thank you, mil gracias.. patolujolimone
-
- 0 replies
- 816 views
-
-
I'm trying to find a way to color text in a pull down list. Does anyone know if this is possible? Or is there another workaroud for this? i.e. a way to type in a specific work like "Active" and it turns green based upon a calc in another field. Any suggestions are welcome. Thanks!
-
- 2 replies
- 627 views
-
-
how can i duplicate the records that is inside a portal? for example, i have 4 tables. the first one is transactions, with fields: recID(autoenter serial), name, date, amount. 2nd one is transItems, with fields: recID(autoenter serial), transID, item, qty. 3rd is duplicates, with fields same as transactions. and 4th is dupItems, with fields: recID(autoenter serial), dupID, item, qty. transactions::recID is linked to transItems::transID transactions::recID is linked to duplicates::recID duplicates::recID is linked to dupItems::dupID now in the main layout, im showing the fields for transactions (recID, name, date, amount) with a portal showing the relat…
-
- 2 replies
- 737 views
-
-
I have modified the Purchase Order Template that comes with FM 7. I will use the modified form to fax or email to our suppliers. I am able to get 25 repetitions on the first page of the form. How can I make a second page print if I need to order more than 25 items and still keep the same PO number? The entire form is contained within the form body. There is no Header or Footer. Thanks, Phil
-
- 4 replies
- 1.7k views
-
-
Hi, I have a DB that I am going to be using on the hospital floor as a Resident. It has several tables: Problems: Each problem is a new record and is given a "problem #" Then linked to each problem # are other tables like: - Medications: What I'm going to treat the problem with - Tests: What I ordered to diagnose each problem etc. So, what I would like is a summary form that I can print a daily note from. It would look like this: Hypertention - Medication A - Medication B - EKG Asthma - Medication C So basically it's like a project manager in a way. Each problem has several components linked to it. I can just go to the med…
-
- 2 replies
- 965 views
-
-
i am trying to create a value list that lists the values from the field that I require plus an "ALL" value. I thought I had it worked out, but find that when I add a new value in the table it does not update my caculated list. I have a table Zones which contains zone ID (unique) airline to which the zone belongs (which can occur many times)and a list of city codes that apply to this zone. When viewing the records through a portal I want to be able to show zones listed per airline plus the ALL to show all zones regardless of airline What I am trying to do is to creae a value list that lists all iairline codes in the table plus the "ALL" value... and that i…
-
- 1 reply
- 761 views
-
-
I can enter data into the first field of the first row of my portal but I cannot enter data into the first field of the subsequent rows (although I can enter data into other fields in the subsequent rows.) I have also tried this in a script and the behaviour is the same. Any idea what causes this?
-
- 8 replies
- 1.5k views
-
-
Ok. I have too many layouts. Is there a way to organize layout? Trees, folders, ect..
-
- 2 replies
- 790 views
-
-
I really want to use something like the dynamic portal by Ugo. Except is there any way to create the value list selection from user input (now these have hard coded field for each item ie. Gender, Hair, Eyes, Member, BirthYear, BirthMonth...)? I have tried a file with a table, but then I need individual fields with field names. Help!
-
- 0 replies
- 791 views
-
-
I have 6 categories Artist,Client,Contact,Customer,Payor and Writer(s) in People table. In a Catalog table and a License table I need to pull up each People table category seperately. One pullup with Artist, One pullup with Client, etc. Have category field in people table. Have a Category table using categoryID for relationship to People Table. User clicks button that enters "Artist" value in category field then enters namefirst then namelast. What would be the most efficient way to do this and how? Thanks to all the people who support such a great site!
-
- 26 replies
- 1.7k views
-
-
I have created a series of 4 conditional value lists based on music categories showing entries from 2 fields(e.g Code No & Category - sorted by Category). In the first value list, where each Code No is prefixed with a letter A, I can type the letter P (e.g. P for Piano/Keyboard/Organ) and I get the expected result. In the second value list, where each Code No is prefixed with a letter B, I can type the letter P (e.g. P for Piano) I get the same expected result. However, in the third value list, where each Code No is prefixed with a letter C, I type the letter P again (to try and get "Piano Duets") but the entry offered is the last entry in the value lis…
-
- 2 replies
- 680 views
-
-
I have attached a basic file to try and illustrate what I am aiming for. I have a table "ZONES" containing zones of citiy and aiport codes as specified by each airline... a zone may consist of anything from one to unlimited number of these three letter groups. Fields are zone code (unique) airline (two letter code of the airline for this zone record) name (free text0 TLC'c (the three letter codes within the zone) Notes (free text) g_id for creating the relationship to view zones. g_airline for the view by airline relationship It is setup so that clicking on a zone line in the portal displays the record on the right In the file I hav…
-
- 6 replies
- 1.1k views
-
-
Haven't figured how to record the date in a date field when someone clicked the checkbox "on:"
-
- 4 replies
- 772 views
-
-
Anyone know of a way to display the current found set of records in a portal? For example, my layout looks at the table "students". When I search for students in grade 8, i get a found set of say 10 records. I'd love to also show that found set in a portal, on the SAME layout. I'm developing this solution for the web, so a new window won't work. TIA, Heather
-
- 4 replies
- 949 views
-
-
Hi there Wondering if anyone can help me get back on track with this - I have hit a bit of a block! I need to include Statements & Invoices that will get info from sales and Job Sheet but maybe I just need either sales or Job Sheet rather than both - Am I over complicating? Also need to have the VAT work out amounts quarterly but can't figure out how to do this... Also where I have email and telephone as portals do I need to include any other info fields in the telephone and email table? File attached - can it be rescued? Any advise would be greatly appreciated. thanks, diane MINE_FMP.zip
-
- 1 reply
- 763 views
-
-
I am trying to to view a related record in a new window, but I can't seem to get it to work. Concept of what I am trying to do: I have a file that have two tables, 'Customer' and 'Address'. I have a layout in form view that is based on the customer table. There is a portal on this layout that is related to the address table. I want to be able to click on one of those addresses listed and for that address to open up in a new window filled with the address I clicked. What is currently happening: I click the portal row and the new window appears but not the correct the address I clicked. I either get a blank record or the first record in the portal …
-
- 9 replies
- 2.9k views
-
-
Hi, How can i make things (text or even record) changed there color base on a what is type in a field ? ex: I have a field "Priority" wich is a Value list : High, med, Low. So, if i select "High" I would like the record to appear in a red tint, or at least the text "High" becoming red. thx guy
-
- 1 reply
- 745 views
-
-
I just started to use Filemaker 7 coming from access, and directly ran into the problem of not being able to dreate a new record in a portal. The helpfunction says just to type the information in the last line of the portal, but typing is not accepted in the next empty space. choosing "new record" just creates a new record in the main database... I've spent hours looking through the program and this forum, but to no avail yet....please help me to be a good convert!
-
- 3 replies
- 740 views
-
-
I've got a portal on my accounts page with orders in it, and I've got a button on each row to duplicate the record on that row. Right now the script for that button looks like: Go To Field[field_in_portal] Duplicate Record/Request Now sometimes it works right and the order is duplicated, but if a field in the portal still has the focus, it duplicates the account record instead of the order. In case I made no sense here's a picture of my portal: The little "D" button is supposed to duplicate the row it's on. Thanks for any suggestions.
-
- 1 reply
- 799 views
-
-
I am making a Database for staff people, so we can entered our working hours. Each record content the following: Name of the Staff - Custom VL of the current staff Date - Auto entry today Date Department - Custom VL of the different department Task - Custom VL of different task Start - Time you did start working End - Time you did End working Total That's it. Here the question : I would like the Pop-up list to showed different "task" depending on the "departement" you did select. How can I acheive that ? thx guy
-
- 1 reply
- 845 views
-
-
How can I make a value to perform a desired script when selected from a list?
-
- 1 reply
- 740 views
-
-
Hi. I'm not sure if this is the correct forum for this but here goes... I have an Invoice Status field which the user can change by means of a dropdown box. What I need to do, is to write to a log file every time the user chooses a new status. How do I do this? I've been trying out a test script (I set the field as a button which performs the script) as follows... Allow User Abort(Off) Go To Field[select/Perform, "Status"] # add to log file using the new value of the "Status" field Exit Script However, when trying to add the new status value to the log it doesn't work. It applies the addition to the log using the old value of the "Status" field…
-
- 1 reply
- 717 views
-
-
In the portal to "sales line item" in my Client database I can view all the sales records for that Client. I can see the total sales figure as well. Any idea how I can break the total sales into Year to Date Sales, Last Year Sales, Two Years Ago etc... I haven't been able to figure out the calculation or if it shouldbe within the Portal or not. Thanks, JK
-
- 3 replies
- 774 views
-
-
I'm working on a multi-file db with several portals in different files. To avoid duplicate entries I use a calculation field set to unique as validation. This seems to work pretty well in every single portal except these ones related to a file with all the clients' data. In this case, afer pushing the revert-button the validation error-message provides, the portal seems not to refresh again and the sort-order is turned upside down... The protal is originally sorted by last names. If you try enter the same record twice you'll get the error message but afterwards the portal appears sortet in the order of creation. All portals have the same setup, also all relationshi…
-
- 0 replies
- 628 views
-
-
It there a way to show that ugly scroll bar only when needed in a portal? Will
-
- 10 replies
- 1k views
-
-
I have a question about using match fields in portals. After searching the forums here I can't see than anyone has talked about this before but I could have missed something. Its really a simple problem but I just can't see any way to accomplish this so any help would be greatly appreicated. I'm somewhat new to FM but am fairly comfortable with its complexities, so bring it on! I have 3 tables in different files, one called Items, the other called Orders, and another called Customers. In the Customers file I have a a portal showing all of the orders for that customer. In the portal I have several fields showing the items and those items are actually fields from the o…
-
- 1 reply
- 576 views
-
-
I have a basic customer database. Each customer has specific related departments and products available for order. Within each department there are related products. Also each product can appear in more than one department. I have created a layout that has the customer information and a portal for the related products to that customer. The problem is when I try and perform a calculation of products ordered minus products shipped, any calculation I enter shows up for all the products in the portal. How do I limit the quanity ordered, shipped, and calcualted difference to only relate to one product in the line items portal on the layout? Thank you in advance for the assista…
-
- 10 replies
- 927 views
-
-
here is a doozy... I am creating an system that allows me to pay royalties to writers on specific albums. So I am creating Royalty statments. Each statment will have multiple writers on it. Tables are: ALBUM WRITER STATEMENT LINE ITEM I have set up the relationships as follows. Each ALBUM has multiple writers. Each ALBUM has multiple STATEMENTS. Each STATEMENT has multiple LINE ITEMS. I have a Popup menu on the STATEMENT layout that allows me to choose what ALBUM I am doing a statement for... there is also a portal to show related LINE ITEMS. What I am trying to do is have a pop up menu in the LINE ITEM portal row that will display a list of…
-
- 2 replies
- 647 views
-
-
So I have a system of tracking the progression of orders. After so many steps it is considered completed. I currently have a portal showing that progression of all the different orders. The question: Is there a way so that when the final step is marked off as completed, that order will no longer show up in the portal?
-
- 1 reply
- 640 views
-
-
I have a table called Diagnosis; it has fields for Diagnosis Code and Diagnosis Description. I'd like to use a check box to populate my Patient record (Patient Table.) My reason for a check box is twofold: 1) It lets the doctor "study" all the available codes without need to scroll down a pop up list. 2) It will allow the doctor to easily choose multiple codes. Since there are a lot of Diagnosis Codes
-
- 4 replies
- 743 views
-
-
What am I doing wrong? I have a layout that contains a header and body area. If I try to increase the size (vertical) of the header, then if I try to restore it back to the original size by sliding the line that delimits the area (not sure of the correct name) back to where it was originally, it refuses to do so and leaves white space around the graphics ... this layout uses coloured rectangles behind the fields. The only way (that I could find) to recover from this was not to save the layout. I had this happen on another layout. I made the mistake of saving it and was not able to restore it to its original condition. (Perhaps I could have by copying it from a backup…
-
- 2 replies
- 928 views
-
-
I have two databases providing data to a "line item" file. I have a portal in one file which enters data via a dropdown list. Is there anyway of checking that the "line item" record is unique. I have tried creating a combined calculation field in the "line item" (name_id & event_id) and setting the validation as unique but that doesn't seem to work. I have tried using a count and self join relationship, to enter "unique" or "duplicate" into another field, but not only does the combined field only contain data from the first field entered, it doesn't change when I edit the record. If I remove the data from the combined field and reenter either name_id or event…
-
- 2 replies
- 717 views
-
-
Friends, can you help me obtain a running count of records under a subsummary? I've tried summary fields, the GetSummary function, &etc but no luck. Under each break of the subsummary I want to number records starting with "1" and on up to the number of records. Then start again with the next break. What am I missing?
-
- 6 replies
- 965 views
-
-
I have some portals that show only the existing records from a particular table. Then in another portal it shows existing records (different table/different portal/different layout), however it also shows a blank row for a new record below the existing records. If I click a check box in that row it makes yet another record... This is not ok - how do I stop this?
-
- 1 reply
- 647 views
-
-
I'm building a database in which I'll have to calculate a Revised Trauma Score, that takes ranges of values into one code. For example: values, for a variable called Glasgow, of 15, 14 and 13 must return a "4". Values 12, 11, 10 and 9, must return "3", an so forth. In SPSS I would use the "recode", but as a newbie in FM I'm quite lost... Can anyone help in with that? Thank you!!!
-
- 2 replies
- 609 views
-
-
Hello I'm new to version 7 although I've been using Filemaker for over 10 years. There seem to be some fundamental differences and I wondered if people had advice on the best way to do something. It seems I'm not the only one out there with this idea but several people have said that copying tables isn't the best way to go about things. I'm using a solution from Queue that allows you to count how many times an option is selected in a repeating field. (http://www.fmforums.com/threads/showflat.php?Cat=0&Number=134738&an=0&page=0#134738) However, I'm having problems getting it to just evaluate the results for a found set of records. So I was thinking …
-
- 13 replies
- 1.2k views
-
-
When I use the New Window script item to create a pop-up type window that is smaller than the full screen window, Filemaker automatucally takes the old window and changes its dimensions to match the new window. Is there anything I can do to prevent that behavior? Thanks.
-
- 1 reply
- 846 views
-
-
I am creating a research database using medical records. You should probably also know that I am extremely new to FileMaker Pro, so I'm not quite sure what I'm doing. I have a very long value list of medications in alphabetical order that takes a long time to scroll through. Is there any way to just type the first letter of the drug and have it jump to that section of the list? Thank you! Newby
-
- 3 replies
- 689 views
-
-
I have created a new layout. One of the fields is telephone numbers. When I go to format and click on the fields The name field and phone number field will change colors, text whatever I want, except for the size of the text. When I specify a size on the phone number field (set up a a text field) some of the records will change and some will stay the same. The ones that won't change - if I change them in browse mode to what I want it changes the font size on those particular records back in the original layout as well. What makes the records respond different and what do I do to make layouts with the font size I want?
-
- 6 replies
- 974 views
-
-
I have 12 check boxes one for each month I need a way to get a count on the number of boxes that have been checked.
-
- 2 replies
- 653 views
-
-
Hello, I've seen this problem in both 6 & 7, and I don't know if it's a bug or a feature LOL Anyway, suppose that, instead of specifying a background fill color for a particular layout part, you insert a graphic that isn't solid. Now if you add a field on top of this background graphic and specify a background fill pattern as transparent, everything looks good, until the screen refreshes (like when moving to the next record). What you see is a white "screen flash", which isn't very attractive. Is there *any* way to work around this, short of removing the background graphic and specifying a background fill color? Regards, Sean Mills
-
- 2 replies
- 801 views
-
-
Hi We use FileMaker 5.5 and 6 I've noticed this problem before and it's really irritating! When designing a layout that I intend to use for print purposes I align all the fields and their labels so they look fine in layout/browse/preview mode. The layout consists of a logo, field labels and merge fields. The field labels and the merge fields are different fonts and different sizes. Then in this case I'm using Adobe acrobat to print to a PDF file. When I print to the PDF the merge fields are not lined up correctly with their field labels. The same happens when I print the layout directly from preview mode, so that eliminates the problem being…
-
- 1 reply
- 762 views
-
-
I have asked a similar question about a year ago. Like most of us, I love Filemaker - except for 2 key issues. Firstly, unless my field borders are set as 50% black I find the "jittery" edges of non-calc, unlocked fields highly annoying. Surely there must be something that can be done about this? I am so opposed by this built-in functionality that I virtually only design with 50% black borders which is understandably very limiting. Has anyone got any idea how I can get around this (and I dont mean writing multiple scripts that go to the fields - especially since you have to write this with Scriptmaker as it can't be defined directly with the "format button" - which is ano…
-
- 7 replies
- 1.5k views
-
-
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…
-
- 10 replies
- 2k views
-
-
Somehow I believe this will be a "no-brainer" for an experienced FMP person: I have a file of medical staff in my application - it has fields like Staff Member Name. Staff members also have a Type field - which can be P for Practitioner (ie. Doctor,) R for Registered Nurse, T for Technician and A for Administrative. I'd like to use the Staff List as a drop down list to get Practitioner Name on the Patient record. Right now all staff members show in my drop down - but I only want the "P" records to show on the list. What's the best way to achieve this? Much thanks in advance, Mark PS - I'm using FMP 7 Developer
-
- 9 replies
- 1.2k views
-
-
I just created a portal - with the "Show Vertical Scroll Bar" box checked - but can't see the scroll bar - although I can "feel around" for it with the mouse and if I grab it - it does work. I tried deleting it and re-creating it - same problem - any thoughts on why I can't see it? Thanks, Mark
-
- 1 reply
- 661 views
-
-
I have a report that requires a lot of the detail in the child file and the header information from the parent file. I have setup a Global field in the child file to link to the key in the parent file. I have two issues: 1. I cannot change the value of the global when it is placed in the header. 2. Randomly (it seems), the global is set to one value but the information in the header is from a different linked record (e.g. the child file Global value = 1, but the information returned in the header is from record where ID = 8). Very baffling...any help is much appreciated.
-
- 2 replies
- 727 views
-
-
hi all, any idea why a multi-criteria relationship in a portal wouldnt work? it has 3 criteria. a similar relationship using 2 of the 3 works perfectly. i have double checked, and there are correct values in all 3 fields on both sides for it to bring up at least 3 related records but it's not showing them. if i try to enter data in the portal (as i have got it set to allow creation of related records) it says 'the operation could not be performed because one or more of the relationships between these tables are invalid. it doesnt explain why though! i am really stumped, because it is basically identical to the relationship with 2 criteria, and the additional one i…
-
- 3 replies
- 867 views
-
-
FM7 is driving me nuts!!! On some of my layouts, fonts seems to sink by 1 pixel. While this doesn't affect useability, it sure is irritating. I'm running 7.0v3 on a Mac. Anyone else having this problem? Any fixes? I've tried recreating layouts but the problem persists... -Rob
-
- 0 replies
- 701 views
-
-
Hey guys, I have a portal in my Invoice for Product Transactions (Invoice Line Items). No problem there. What I need to do is separate out two types of Products - Physical Products and Shipping Costs - and make two separate portals to display each of these respectively. It wasn't making sense that shipping upgrades be displayed in the same list as the normal products, but for accounting's sake, these all must be considered transactions. So far, I've created two new relationships - ProductTransactions and ShippingTransactions. ProductTransactions is linked by UniqueInvoiceNumber, the same as the original all-inclusive Transactions, except that there's also a…
-
- 2 replies
- 705 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online