FileMaker Interface Features
-
I am building my first fp7 database, a photocatalog with two tables, Image info and Artist Info. The two tables are related by the field Artist. I am trying to build a layout that shows the some fields in the Artist info with a portal to the Image info table that shows all the Images that were created by that particular artist. However, I keep getting the error message Field Missing, for the fields from the related image info table. I get this error whether I try to display a text, number, or container field in the portal. Please help.
-
- 2 replies
- 849 views
-
-
Forgivce me if this has been covered before. I have a situation where a table called invoices has a portal to sales line items. One of the fields in this portal row is governed by a validation calculation. The problem I have is when data is entered into this field (valid or not) unless I click away from the portal row, it does not come up with my custom validation failed message. Is there away round this as I would like it to show as soon as the tab or return key is pressed while in that field. thanks
-
- 0 replies
- 651 views
-
-
i've been trying to solve it for some days and still no idea how to do it. i would like to copy all the records from portal-1 into the other one, portal-2, within one record. then i need to be able to adjust the records in portal-2, but keep the original ones in portal-1. has anyone idea how to do that? thanx in advance!
-
- 21 replies
- 2.3k views
-
-
In my solutions, most graphical elements occur many times across all the layouts. I mean, buttons, backgrounds, arrows, etc... This increases file size but, more important, increases network traffic. Every graphic element can be substituted by a global container field, containing the image of the element, properly placed on the layout. When the file is loaded, the startup script takes care of loading all the graphic elements from a graphic-elements-table into the globals. Of course this requires more work when developing the solution and the layout design is more complicated. But there are several advantages: 1)Since globals reside on the cli…
-
- 12 replies
- 1.8k views
-
-
Now that i have your attention. I have established a series of categories and sub categories for data entry to reduce typos. each category has specific sub categories. the category value list is a simple user defined value list, but the sub categories are a conditional value list referenced from a related table. this part works fine, when you select a category the correct sub catergories display. unfortunately the feature takes over during data entry. when one selects a new sub category filemaker changes the subcategory heading for every record in that category. not a desirable result. what am i missing? how can i make the value list so that it will display only those sub…
-
- 8 replies
- 1.1k views
-
-
Hi- Does anyone know of a way to remove the last empty portal row (which can be used for data entry)? I would like to move the user out of the portal for data entry. Thanks.
-
- 1 reply
- 1.1k views
-
-
Hi--I've wasted a morning trying to get a dynamic portal filter working, I'm hoping I might get a solution here. I want a dynamic portal that will filter according to the criteria set forth by the global gt_CurrentFilter... BUT, if nothing is selected in that filter, I want everything in the portal. Preferably no scripts/no layout changes. In the example, I have a bunch of characters in the Harry Potter books marked as either "Active" or "Inactive" according to whether or not they're still alive (no book 6 spoilers, this is strictly book 5 ) When there is nothing selected in gt_CurrentFilter I want every name to appear in the list, but if either active or in…
-
- 4 replies
- 1.1k views
-
-
I am trying to create a filtered value list of students who are boys, boarding and do not have a rooming assignment. Since I cannot seem to create a filtered list with any calculated fields that cannot be indexed (ughh), I need to have more of a dynamic lookup field. The problem is when you assign a Student ID to a Bed (in the Bed Table), the Bed_ID does not automatically populate in the Student table. In order to show a filtered list of students who do not have a Bed_ID (student table), I need to be able to auto-enter this field when someone adds the student_ID to the corresponding bed. The field does not automatically look itself up because it is in a different ta…
-
- 1 reply
- 745 views
-
-
Hi, I have an invoicing db i'm trying to write. What I would like to do is generate a list of fee types which includes approx 10 standard choices, plus whatever else the user has added to their personal list. So far I have (in short) Table 1 - FeeList; fields: {Type} (radio choose GST or NONGST) {login} (text) {Name} (text - name of fee) {join} (type & login) Table 2 - Invoice; fields: {glogin} calc field (get(accountname)) {GSTJOIN} calc field ("GST" & {glogin}) {NONGSTJOIN} calc field ("NONGST" & {glogin}) I have then set up two table occurrences between 1) GSTJOIN & join 2) NONGSTJOIN & join I have …
-
- 2 replies
- 697 views
-
-
I need quick help or a suggestion on what I should be looking at todo this specific task. I'm working out a simple many-to-many relationship and in a particular screen where I put an unique object into a specific group. There is a dropdown box that lists all the values for Group_name. When I hit ok, I would like to reference the group name against the related group_ID and use the ID to store the grouping, not the name. This way, if the name of the group changes, it doesn't ruin all my pairings. For this relationship I have 3 tables, one is an object table, one a group table and one a object_group table.
-
- 1 reply
- 649 views
-
-
I find it interesting that in FM7 you can define a sort sequence when defining a relationship and then define another when use the relationship in a portal. I would like to take advantage of that latter feature and change the sort sequence in a portal somehow within a script. Otherwise I believe I would need to have a different layout for each sequence I would like to display the data in. I want the user to be able to toggle through different sequencing options of the portal with the click of a button. Is there a way to change the sort sequence of a portal from within a script (without user interaction other than the 'toggle' button)? TIA Tomp
-
- 20 replies
- 1.6k views
-
-
Greetings, I have a solution for my photography studio. In it I have a portal that shows all of the sessions. Within each row there are check boxes to track its status 'in house'. Editting, at the lab, etc. Once the photos are picked up by the client, I would like for us to be able to click a 'hide' option within the portal that will simply drop it from the list... Is there any way NOT to show all of a related record set? That you could somehow have a field that would trigger it NOT to show up in the portal?
-
- 2 replies
- 658 views
-
-
This is too strange so I think I'm either overlooking something obvious or there's a bug in FM7. I have two files: FileA has a value list that includes values from related records that are also within FileA. The relationship is from a global field to a regular text field. FileB has a value list defined to be the same as the ValueList in FileA. NOT values from a field in A, but the actual FileAValueList. I have a field in FileB that uses a Popup menu displaying FileAValueList. The value list (FileAValueList) displays fine in a field in FileA. But when I apply the value list in FileB to a field in FileB, I get "" when I click in the popup menu field.…
-
- 3 replies
- 1.3k views
-
-
Has anybody else experienced alignment problems where on various records the alignment of a field jumps ahead a space, randomly, in one record and not the other? This file was converted from FMP6. It had these problems in FMP6 and we were hoping FMP7 and an update would fix it but it didn't - comments, suggestions, what on earth? I'll attach a screenshot of two consecutive records. Look at the top of the layout with the name "Don Roth" and the venue and concert title, and also the alignment jumps in the fields for the song itself. Inexplicable corruption?? Thank you!
-
- 7 replies
- 881 views
-
-
Hi I am new FM user and I am moving my excel database projects over to a more logic format. In this example I have 10000 + contacts that chose between 40 different fields of interest. All yes or no. In FM7 I would like to convert those interests into a value list with yes/no radio buttons. Is there a way to combine defined fields into a value list? They all share a yes/no answer. Thanks! -Derryl
-
- 1 reply
- 755 views
-
-
I have a layout where i want to show different results from the same table in portals. so I have a portal where it is showing all records that relate but i want another portal showing records from the same table that relate to different fields is this even possible?
-
- 1 reply
- 703 views
-
-
Is there a way to partition a field into columns and rows?
-
- 1 reply
- 809 views
-
-
Need help with script for button that scrolls though portal records. The portal displays one record at a time and has an up and a down button. When the down button hits bottom, one more click brings you back to the first record. That was easy, it just recognizes the empty fields of the bottom record. What I want is for the UP button to work the opposite way - that is, if the first record is in view, a click on the UP button brings you to the bottom record. Thanks
-
- 2 replies
- 1.1k views
-
-
How do I open a file without performing the File Options? I need to change the script which I stupidly entered. I set up a script to close the file which it does perfectly, so that I can
-
- 8 replies
- 932 views
-
-
I've decided to post a working file which eliminates scrolls. I dislike them. In addition, many times it's difficult to restrict a relationship sufficiently and, if I need to sort the relationship or portal, or if there are a lot of related records, portal re-draw, find and sort can slow it down - particularly when jumping from one main record to another. Simply restricting the length of the portal doesn't restrict FM's need to find, sort and calculate the related set for display (and Lord forbid I have unstored calcs in the portal). Scrolls are simply ugly (sorry FileMaker). I believe clicking an arrow (jumping in groups by the total number of portal rows) is much q…
-
- 40 replies
- 7.6k views
-
-
I hear Macs are more friendly in this regard - the annoying flash produced when moving through records on a form layout. It bothers me and it bothers several of my Users. What can I do to reduce/eliminate the flash effect? Here are some specific things I've wondered ... 1) Buttons vs. rectangles - are they different as far as resource use or flash or are buttons simply a pre-defined format to make things easy on us? BTW for those with FM7 - Embossed buttons placed in containers no longer lose their great look! 2) Does grouping text with rectangle (or button) reduce or increase flash? Or grouping text with graphic? Or doesn't it matter at all? 3) I ha…
-
- 12 replies
- 4.8k views
-
-
I would like to create a report of clients that are 30, 60 and 90 days past due on their payments. I could easily create 3 different reports, but could I combine them? A section for 30 days a section for 60 days, etc. Not quite sure how I would do this. Thanks
-
- 1 reply
- 722 views
-
-
My doc. has 11 layouts. Is there a way to make it so that when I add a record to one it does not add a blank record to the others? Thanks Phil
-
- 9 replies
- 976 views
-
-
Hi- I have a portal with too many fields. I have read of a solution where you can select a row in a portal and more information about the item (or person) appears in related fields next to the portal. I am not that fluent with FMP and the instructions were not laid out step by step in the book I read. Would anyone be able to help me with this solution? Thanks in advance.
-
- 7 replies
- 1.5k views
-
-
I have 8 regions all titled their respective region. I would like to be able to create a serial for each record according to what region the record is in. For example, North - 01_1, O1_2 South - 02_1, 02_2 East - 03_1, 03_2 Ultimately I am trying to use the serial number to get a image from a folder and display it in the layout. Any tips on how to do that are also appreciated. Thanks.
-
- 4 replies
- 713 views
-
-
Greetings, I have done a bit of searching and some manual browsing, but I cannot find the solution to my current problem... I am creating a related database involving a table of members, a table for event dates, and a table that keeps track of who attended each event. I would like to be able to "control" and automate input into the event list and attendance tables solely by buttons on my member list. I have a button in a list layout that is linked to a script that is supposed to add a record in the related attendance file. I have tried a couple different methods including one involving portals. I don't understand exactly how portals work so it is needless to…
-
- 9 replies
- 1.1k views
-
-
I have created a portal based on a date_calc for month and year; for example, July 2005 reads as 72005 in "sales records" and a "montly sales listings" each with their respective tables. And it works fine: if I enter in say, 72005, in the date_calc field in "montly sales listings" all the sales records for July 2005 show; for 62005, all records for June and so on:) What I would like to accomplish is a bit out of my expertise such as it is. Is there a way for FM7 to notice the passage of time such that when the creation of records for sales move from 72005 to 82005, a script will trigger the creation of a new record in monthly sales? And then again a…
-
- 2 replies
- 671 views
-
-
Hi there, I'm trying to create something like a "condition list of value list". Basically, i'm creating a value list of everything in certains fields (no problems yet). What i'd like to do, is to have a list of every element of the list that are in one particular record, and omit the elements of the list that are not in. Example: I have a value list of about 100 books for ALL the records in my BD. I'd like to to see every book that are listed in only ONE record (let's say there is 25, the list would only show these 25, and not the 75 others). Basically, it means that every record would have a different list of the books comming from the same value list. Is…
-
- 4 replies
- 826 views
-
-
Hi, Thank you all for being part of the forum. Having searched through the archives, I put this potentially forehead smacking question to the collective wisdom of the group. I'm printing out a database of instructions. It basically looks like this, 2 fields: Instruction_Title Instruction I trying to get the page layout to print like: -Title -Instruction....text text text text text text... -Page # of intruction (restarted at each new record) The instructions can be up to 4 - 5 pages so sometimes they break accross pages. The part slides up. My part setup is simple: a body, which "breaks after 1 occurance, restart page numbers after 1 occuran…
-
- 0 replies
- 765 views
-
-
I have a vaule list that is from a seperate table. I need to run a script when a vaule is selected from the list. Also need it to be conditional based on what they choose. Example: list have values 1, 2, 3, 4, 5. When choose 2, run script x and store "2" value in value list field when choose 2, run script y and store "1" value in value list field
-
- 14 replies
- 1.9k views
-
-
I'm currently trying to create a portal where I can view calendars for objects in a portal so that I can get it to scroll horizontally (infinitely preferably) to check the object status - i.e. in use. I've managed to generate a calendar for an object that shows 1 year + 4 weeks in a horizontal repeating field but cannot work how to get this into a horizontal scrollable portal. Does anyone have any ideas?
-
- 2 replies
- 728 views
-
-
I am trying to make a warning note for a portal populated with registrant names for an event. The warning should show when the same participant is entered in the same event. The portal is in the event file, and links via a many to many join file to a registrant file. How can I set up a script so that a warning notice shows up whenever a registrant is duplicated for the same event? Registrants have unique IDs, and so do Events. I'm thinking of searching for duplicate "reg ID + event ID" in the join file, but am unsure how to launch such a search from the event file registrant portal. Thanks in advance. Kirsten Masse
-
- 1 reply
- 685 views
-
-
I have a table with 3 layouts. In 2 layouts, I have a merge field in the header section to display the value of a particular field. The value is the same for all the records in the table. In layout A the merge field data appears correctly; in layout B, nothing displays in Browse/Print mode and the error code -44719999999 is displayed when I show sample data in layout mode. The FMP file I created is designed to create a set of forms for particular events, and with each new event I duplicate the file from the previous event to make changes. The weird thing is that the merge fields have worked properly in previous iterations of this document. Does any one have…
-
- 8 replies
- 906 views
-
-
Hi I have an FM database of 400 items containing codes + descriptions to print out onto labels. I have set up layouts of the 2 x Avery labels required. I have set a field containing a size code so I can search for all the items with large and all the items with small labels. Now I want to print them but some items I want 50 labels off, some I only want 6 off. Anyone any idea how I set this up so each item has a code, a description, a label size and a number of labels reqired. I hit print and out they come. It's all there apart from the printing problem. If I can't solve it I'm going to waste an awful lot of sheets of labels. Regards GBM
-
- 8 replies
- 1.4k views
-
-
is there a way to configure filemaker so that when you switch to a different layout that's much smaller than the previous layout, the window itself shrinks to fit the new layout better?
-
- 3 replies
- 1k views
-
-
I have two fields in my database which are calculation fields (First Name -calculated as the first word of a field called First Names, and Sign Off - calculated as a concatenation of ManagersName, paragraph mark and Job Title). I want to incorporate these into a letter, but using Merge Fields (CTRL-M) I get First Name appearing twice (as in PatriciaPatricia, though it is fine on another layout when displayed as an ordinary field) and the Sign Off only gives the first line,. not the paragraph and second line of display (though again this displays perfectly when displayed as a conventional field). I have not encountered this before. Is this a bug in version 7, have I go…
-
- 3 replies
- 845 views
-
-
Hi! Could someone point me in the right direction with this? I've brought it as close as possible and attached an example (pick one, .zip or .sit)... Two tables: Workers and Tasks. Workers (field initials) have multiple Tasks. Tasks have a status of A, B or C. I want a portal that displays all of a worker's records with a particular status. In the attached example, change the value of the valuelist (the yellow field) in workers.fp5. The calculation in tasks.fp5 (the blue field) changes appropriately, but can't be used in the portal relationship because something won't index. How do I create a relationship based on a calculation that contains a global? …
-
- 2 replies
- 629 views
-
-
I have a portal that has records shown in order of "edition #." From 1/25 (1 of 25) to 25/25. It is set to sort by the #: 1 first through 25. Unfortunately, when it sorts - it puts everything with a "1" first so it looks like this: 1 10 12 13 14 15 .....and then goes to 2, 21 - so obviously it is sorting by the first # - how do i fix this? Help! Thanks, Sarah
-
- 1 reply
- 697 views
-
-
Please help!!! I have 3 textboxes: txt1 and txt2 and txt3 I also have a checkbox with values of Red, Blue, and Green. Problem and Question: When the user checks Red, Blue, or Green in the checkbox then txt1 and txt2 and txt3 should remain empty with no data. How do i do this? Do i create a calculation in define database or do i have to create a script and if so what do i write? Please help help help. I am new to this.
-
- 5 replies
- 954 views
-
-
Hello world, I'm building a dvd/cd database and so far it works pretty well. I keep running into trouble when trying to get data (numerical) from the portal I've used. My portal contains disk: content, content type (movie, music etc.) and content size. I used a calculation to "sum" the content size to create a "disk size" field. That works really well, but I also wanted to sum up the size of all the disks. I used a summary field but that doesn't work straight away. I have to re-open the DB for it to re-sum all the disk sizes. Maybe theres a better way to do this?? I'm also trying to restrict data entry within the portal. I used a validation on the co…
-
- 5 replies
- 912 views
-
-
I think I may have found something Filemaker just cannot do. Perhaps I need to change the way I'm approaching this to get what I want. Have two tables: Invoices and InvoiceLines. InvoiceLines contains individual records for each line item in an invoice. It is related to Invoices by a unique InvoiceID field. Invoices contains general information about the sale: date, time, cashier, and payment method. InvoiceLines are entered through a portal in the Invoices layout. Want a report that shows end-of-day subtotals from InvoiceLines by: ItemCategory and ItemName. For example: subtotal of cars, then subtotals of each car model; subtotal of trucks, then subtotals of ea…
-
- 1 reply
- 712 views
-
-
I have a series of buttons that pull up different subsets of the same data. If a button would query a null set, I want its color to be gray-out. Is this possible?
-
- 9 replies
- 2.3k views
-
-
How to put this most simply....hmm.... I have a in consecutive order right next to each other, a text object "CD," a field "A###" and a field "A/B." The "CD" and field "A###" are always full, but the last field "A/B" is full only when there are two CDs. My problem is with how to keep it centered on the layout with AND without the occasional "A/B" field. It is mandatory that this layout not be edited in anyway - all data entry is done on a separate page, so this must be an automatic occurrence. I've browsed calculations and looked it up in Help and tried a bunch of things but cannot nail-down the correct formula. Is this possible? Thank you SO much for your …
-
- 3 replies
- 728 views
-
-
Hello there. I'm stumped with a little bug that I can't seem to resolve. Here it is: In a Standard Form Layout, I am using a lot of justified text (not in a field, just text on the layout) and some Merged Fields. In Layout Mode, the text is fine and within the boundaries. But in a few lines in Browse and Preview Modes, the right side of the last letter is incomplete.. Picture this: what should be the letter 'O' comes out looking like a 'C' instead. To top it off, it also prints that way. So, text wanders off the print margins in Browse and Preview Modes, as well as on the printed page. Has anybody bumped into this problem before? Hey, thank you.
-
- 2 replies
- 807 views
-
-
I created a calendar of work days with the help of another of the forum's gurus, comment. In it the calendar is represented by a concatenated string of letters (X for non-workdays and W for workdays), the numeric position of each letter in the string, when added to the start date of the calendar, produces the representative date. The calendar is built in a script loop that starts at a defined begin date field and stops after an end date field to create the string of calendar letters. There is also a function to change a date from an X to a W and vice versa. Weekend days are defaulted to be non work days when the calendar is built. Now I want to take it this concept o…
-
- 6 replies
- 1.4k views
-
-
Hello, I am working on a solution with a lot of images in the layout. This is just to make a pleasing interface, all printing is done on seperate layouts, no images. . Anyway, my question is: What is the most optimal way to use images? Obviously, keeping the images as small as possible is one way, but beyond that - is it more efficient to import directly into the layout or store via reference? If an image is copied, does it just load the image once and display it twice (like on a webpage) or does it actually load it twice? Is it more efficient to have one larger picture or many small pictures? Also, I think I might have found a way to make high q…
-
- 4 replies
- 1.3k views
-
-
I have a sub-summary report that sorts by the year of a date field (Year_date_rec) that works fine in most cases. I have a client that would like the report generated by his fiscal year (July - June). I cannot seem to figure out how to do this. Can anyone help? -Tony
-
- 2 replies
- 722 views
-
-
I'd like to supplement the Status area of a layout with an alphabetized list of all the records - in this case, the people in our mailing list. Clicking on a name would take the user to the related record. I thought I could use a portal with a scripted button, but FMP won't let me create a portal to the table that the layout itself references. Any suggestions? Thanks!
-
- 7 replies
- 918 views
-
-
Hi-- I just converted some old 6.0 files to 7.0 and now, in one of the layouts, the main graphic and several of the fields are coming up as bitmapped -- no matter what font I choose. These are reports -- what am I doing wrong? Thanks All My Best, Jeffrey
-
- 0 replies
- 609 views
-
-
This solution is for a school. There's a STAFF file and a STUDENTS file. I am working in FM7 on a solution I originally created in FM5. I want to create a value list where certain staff show up on a student's record. Ten of the 100 staffers are instructors. I only want to see those ten on the pull down. I created a field on the STAFF side that's a radio button. It enters "Writing Instructor." On the STUDENTS side I created a global field with the same value hoping to create a relationship then basing the value list format on that relationship. Zero luck! Stumped with this one as I used to know and can't for the life of me figure it out now.
-
- 2 replies
- 832 views
-
-
Hi, I would like to know if it is possible to be able to double click on a portal item and have it perform a script (to go to related record). If i make the portal fields buttons they work on a single click only. Thanks
-
- 5 replies
- 817 views
-
-
Hi, I have 2 tables: a "transact" table to record every payment for a "Customer" table. I created a portal under customer layout so as to view all the transactions for a particular customer. Question: How can I create a sequential number next to every portal record to show how many transactions there are. Currently I can only view the records but I have to count the number of records. Many thanks in advance.
-
- 5 replies
- 969 views
-
-
Can I do something to prevent changing button colour (when click on it)? TIA
-
- 0 replies
- 753 views
-
-
Recently in a different post http://www.fmforums.com/threads/showflat...true#Post167239 I described a difficulty I had with a value list and S
-
- 15 replies
- 1.4k views
-
-
I am trying to create a form in FM7 (Which I already have in Word) and it is a bit troublesome trying to make it look identical or as close to as possible. Is there anyway to copy and paste the format?
-
- 1 reply
- 645 views
-
-
First, thanks to all for the great information on these forums. I'm using OS 10.3.9 and have two FM 6 databases, Stories and Pix. The two are related by a field-generated value list in Stories whose values can then be selected from a popup field in Pix. So far, so good ( think). But the problem arises further down the road when I'm trying to generate a different value list (in Stories) of values from the related records in Pix showing up in a portal. Stories contains a field (:PicPath) in the portal, which displays data from a field in the related Pix records. It is the ::PicPath data that I'm trying to feed into a value list and can't. My ValueListItems fi…
-
- 2 replies
- 760 views
-
-
I have a layout with one portal. When a button is clicked to add a row to the portal, a duplicate portal shows up on my layout that is above and to the left. This ghost portal does not appear anywhere in layout mode. I have gone as far as duplicating the original layout and deleting all of the fields as well as the portal. I then go back to the original layout and select the fields one by one and put them back into the copy. I recreated the portal because I had a feeling that the problem was with it. No such luck, the ghost is still there. One of the main problems with it (and the reason it was discovered) is that the scroll bar for the ghost portal goes straight d…
-
- 1 reply
- 628 views
-
-
Here's my situation: I have a colon as a text object (not a field) between two text fields. If there is not text in the two fields on either side of the colon, I do not want the colon to print - is it possible to write a script or somehow make it so that the colon will not print if there is no text in a surrounding field? I'm new at this so I am still learning - but the sooner I can find out whether this is possible or not the better, which is why I'm jumping to a forum. Thanks for your help! SC
-
- 3 replies
- 799 views
-
-
I am having an issue creating a checkbox value list in FM Pro 7. Well, it's not really an issue creating the checkbox list, is how limited it seems to be as far as display options. Unless I select a dark blue, dark green, or black background, I cannot see which option is checked with the light yellow background I have for my layout. I don't want to change the layout colors because I already have several layouts with the same format and the color represent the organization I am doing this for. So is there a way to set preferences on a checkbox list such that the item(s) that is/are checked show clearly that they are checked. It can be that they bold and show the check…
-
- 2 replies
- 706 views
-
-
I'm having trouble creating a layout for what I need to model: each CUSTOMER has any number of ORDER, and each ORDER has any number of ITEM, and each ITEM has any number of CONFIGURATION. Here's a picture if that doesn't make sense: What I would like is to have a layout that shows the customer name & info (from CUSTOMER), along with any orders they have (from ORDER). Then, for each order, all the items in that order (from ITEM), and for each item, all the configurations it could have (from CONFIGURATION). I was going to handle this using portals, but I just learned you can't have a portal within a portal (I'm a FileMaker noob). I don't know of any way…
-
- 2 replies
- 720 views
-
-
To Anyone out there, I was wondering if there is a way to design a layout with "Thumb Tabs." I don't know exactly how to describe them but a good example is when you Define Database, the "tabs" that let you switch entries. If I'm not being detailed enough, please let me know. Thanks for any help.
-
- 15 replies
- 1.2k views
-
-
Is it posible to create a database in multiple languages? What I want is that the field label names changes after there is made a language selection. Example: Fieldname=field01 After selecting the language english the FIEL LABEL field01 should be replaced with NAME and when the language Dutch has been selected the field label should be NAAM English NAME: field01 Dutch NAAM: field01 Is there anyone who can tell me where to start? Greetings, Jukkie
-
- 6 replies
- 1k views
-
-
I have a common situation - a value list to choose an ID and also showing a sorted name field. I type in the first letter of the name I want and the list always jumps to the final name on the list, I repeat the intial letter and carry on typing and there is no further problem. Do I have an incorrect setting somewhere? Is this a know problem with FMP7 (I am using v7.03). It is going to be a real PIA when this solution goes live if the problem isn't solved.
-
- 4 replies
- 747 views
-
-
I've been fiddling around with a database for a while, and I've figured that if you make a value list using match fields in related tables you can create new records in the "daughter" table via pop up menu. But I've also discovered that this can only be done if you have fields in the "daughter" table in the layout of the parent table. But what if you wish to create a value list that only affects one field (the one in the list) and allows permanent addition of new values? Joel
-
- 2 replies
- 707 views
-
-
I am developing a 'Job Tracking System' for a print department. We number our jobs as follows MMYY.001..002..003, etc. For example the first job recorded in July 2005, would have the job number '0705.001' Corresponding folders on our server are named likewise. Currently I have a 'Serial' counter that just starts at, for example, 0705.001. This works fine but I have to update it at the start of each new month. Is there a way to create a 'Serial' counter that will extract the MMYY so I don't have to update this every month? Regards, Johnny
-
- 8 replies
- 1.2k views
-
-
HI everybody. Forgive me if this is too obvious for words but I just cannot get it. I want to show all the records in a table so I have a portal based on a self relate to a constant. I want the user to be able to add records as well as edit the others. I have all this working IF records exist within the table. If there are no records I get a message asking me to create a new one (I expected to be able to just add records through the portal - cos I can if there are already records there). Once I create the new record then I can enter new records within the portal and for some reason I end up with a blank record at the top of my portal. I assume I am doing …
-
- 10 replies
- 1.2k views
-
-
Is there a way to create an unsorted value list? How about sorted based on unseen field?
-
- 5 replies
- 1.8k views
-
-
how do i set up a field so that whatever a user puts into it, typing or pasting from the web, that it ALWAYS stays the same font?
-
- 2 replies
- 714 views
-
-
I'm not sure if this is where this belongs but hopefully it is. And hopefully I'll make sense. ----------------- I'm creating a card game and I need a way to simulate multiple piles of cards. I've not had alot of experience using tables with value lists in FMP7 so any help would be greatly appreciated. My concept is this: Table: (cards) Fields: Card_ID - holds the id for the card (1 through 4 for suits, 1 through 13 for value, separated by a - ) Card_Pic - container holding the cards picture dealt - this and the fields below would hold either a 1 or a 0 played - see above pickup - see above discarded - see above Table: main Fields…
-
- 0 replies
- 850 views
-
-
Okay, i remember that this was a problem in earlier versions, but hoped it would be fixed by now. Simple layout with text boxes as field labels aligned to the left, with accompanying fields to the right. All are set to slide up and reduce size of enclosing parts. Now, the layout goes over one page long. Everything works fine until the text boxes after the first page. In preview mode, these text boxes disappear completely, although the fields next to them slide just fine. Gone. Just gone. I've tried every different way to set up the body part, to no avail. Also, having the problem with a text field that flows over a page break, where the lines are chopped …
-
- 5 replies
- 1.1k views
-
-
I am new to the FM7 World and am having some difficulty with a portal setup. I have created a portal based on Owner information. But the way it is setup I cannot add another owner without going to the owner layout and duplicating the record and changing the owner name. Also one of the standard templates that came with FM7 is the People Management template. On this template once information is entered into the "issues" or "goals" portal another field is opened automatically. I was wondering how that happened. Thanks.
-
- 1 reply
- 584 views
-
-
I am compiling some questionnaires, and need to calculate the percentage of each item in a value list out of the total number of records. For example, radio buttons for ages: 13 - 17, 18 - 28, 29 - 39, etc., I need to create a script that will calculate the percent of total records for each age grouping. Another example, using checkboxes for interests: outdoors, art, music, fitness, etc., where more than one box may be checked. Again, I need to create a script to calculate the percent of total records for each interest. Also, how do I deal with the "other" items? I'm thinking there must be a relatively easy way to do this, but I don't know how.
-
- 0 replies
- 1k views
-
-
I have a value list built from records in a related file. The relationship to the related file is sorted based on an 'order field'. The value list in the parent field (based on this relationship) appears in alphabetical order. I can get it sorted, but only if I display the second field, and select 'Sort By Second Field' (kinda stupid looking to display a set of sequential numbers). Using FM6, does anybody have a clever work around? Note: I found Nightwing's Menu Simulation, which displays a valuelist in sorted order without displaying the second field, but it is a portal, which I can't use...my valuelist is attached to a field that is already in a portal. Stev…
-
- 0 replies
- 768 views
-
-
Hi I am using FM7 as a database for references of books/papers for my masters. I catalogue them in this way: Name: Year: Title: Publication: Reference: Publisher: I use a layout to display this information in separate records - I also have devised a layout that displays the information as a bibliography by using the merge field command like this: <<Name>> (<<Date>>)
-
- 14 replies
- 3k views
-
-
I have an esixting database that I am working with trying tomake some changes to. I have a table called "time sheets" that has a value list pop up menu, populated by a relationship to a "jobs table" job number field. Where each employee can choose a job number to track their time against. What I want to do is, once a job is complete, keep the record, but remove the job number from the pop up menu, so that there are not so many for each employee to have to scroll through to find the correct one. Is there a way to do this without having to remove the record from the database? Thanks.. Kim
-
- 18 replies
- 1.8k views
-
-
I have a field in a portal in which the length of text can vary considerably. Is it possible to extend the portal/field size and have them slide up if the text is short?
-
- 2 replies
- 637 views
-
-
I'm using a calculated field (FMD 7) as the source for a value list. Here is the formula for the field: LayoutNames(Get(filename)). The field is stored with indexing set to automatic as needed. But when I change the name of a layout, the value list of layout names does not update because the field is stored so that it can be indexed. Is there a better approach to this? I just want to populate a value list with layout names and have the value list update if I change a layout name. Any suggestions will be appreciated! Brudderman
-
- 10 replies
- 2k views
-
-
Hi all, First off, question is pretty straight forward. It is probably answered in another post but I either didn't find it or couldn't really understand what was going on in the others to figure out a solution. I am trying to sum a line from portal into a field. The item is "Total Weight." I found a formula in a post that I thought would work like this; "Sum(Portal_Relation::Payments), but it doesn't. Again, maybe I just don't understand it or how to make it into the results I want. If someone could please break it down step by step, as I am still new to FM7, I would really appreciate it. Abomb
-
- 2 replies
- 632 views
-
-
Greetings all, I've got a new FMP7 database that includes a table for DONORS, MAILINGS, and MAILINGSRECEIVED. The last table manages the many-to-many relationship for donors and mailings, and includes fields for the DonorID and the MailingID. On a layout based on DONORS, I'm looking at a portal of MAILINGSRECEIVED and see the list of all mailings that have been sent to that donor. I can add records to this portal. This all works just fine - so far, so good. My question is whether I can use a script to add records to this MAILINGSRECEIVED table, one each for a group of donors. The problem I'm trying to solve is this: I have a group of, say, 400 donors…
-
- 0 replies
- 742 views
-
-
I have a portal in which I display an image. I've protected the image to keep the user out of the field, but when the user clicks on the field, the colors in the image invert. This has startled more than one user, but I'm at a loss as to how to prevent it. This only happens when the graphic is in a portal. In layouts where the image doesn't need to be in a portal, the behavior is as expected. This, to me, is a FileMaker shortcoming. Does anyone have a suggestion on how to get around this? Thanks, Rick
-
- 10 replies
- 1.1k views
-
-
I have a button that the user can click to add a new line to a portal. The portal is used for entering comments related to a specific store. The fields are DATE, STAFF NAME and COMMENT. The Date field is set up as a regular date field - not auto-enter. The Staff Name field is a value list from another file. and the Comment field is a text field. When the button is clicked and a new line the cursor takes the user to the date field in the last record. But when they tab out of the date field to the Staff Name, the cursor jumps way back up the first record and opens up the value list/pull down. Another tab takes them to the Comment field on the first record. Here is th…
-
- 4 replies
- 661 views
-
-
I apologize completely if this subject is covered elsewhere, but I searched and couldn't find it. I have two problems that are very basic and would love some help. 1. When I insert a button I would love to customize the highlight colour when the button is selected - how do I di this 2. Similar question - I have a layout with a portal in it and the user selects one of the portal records and is taken to the detail. I do this by declaring the portal record as a button, and again would like to specify the color when the button is 'pressed' Any help gratefully received
-
- 2 replies
- 946 views
-
-
I have a Patient table and a Visit table. In the patient table, there is a portal to display this patient's visits. So, if a patient has 10 visits, the portal of this patient will show all 10 records. How can I make this portal only show the visits whose status equals "failed", for example ?? Thanks very much. Jie
-
- 1 reply
- 691 views
-
-
Say I have a value list with 5 entries and use that value list in a check box format for field x. I would like to find all records where field y equals one of the checked values. Is there an efficient sequence of script steps to do this?? I'm envisioning a loop of 'extend found set' using 'middlevalues' for each of the checked items. There's got to be a better way! TIA tomp
-
- 5 replies
- 1.1k views
-
-
Hello I would like to be able to find portal records and have just those returned in the portal - the find function works on the main table rather than the portal table for me. Thanks G
-
- 2 replies
- 769 views
-
-
I'm attempting to sum a text value for a specific field in each record appearing in a portal. The aggregate function "SUM" works wonderfully for numeric values but no luck for text. I can add values from two text fields by using the concatenate operator "&". Doing so from record to record is not clear to me. Is there a way to add values from a previous record to the present record to form a running total (or list as I wish to do). My ultimate goal is to this within a portal. Searching these forums has yielded nothing regarding text values in this way. Maybe I should post this after the holiday, but like all things that naw at the old gray matter it just wont go …
-
- 7 replies
- 927 views
-
-
Is possible to have horizontal scroll bar in Portal? Native options are not providing horizontally scrolling...but my hope is that here is someone who knows the trick. Thanks!
-
- 5 replies
- 3.6k views
-
-
Hey, I'm new to this site so firstly want to apologise if this is in the wrong place! I have just started using Filemaker at work and have encountered some problems whilst changing the layout. My database contains architectural photographs and fields detailing their information such as project number, description, project title etc. I want to create a record which looks like a form for people to fill in the missing information. I want the project number and title to be at the top of the page with subsequent photos and info for that project underneath one heading rather than every photo having the project title and number above it. I also want to be able to spli…
-
- 0 replies
- 645 views
-
-
I have a list of records (in a list layout). I want to sum a related field for these records and see the total. However, when I create a calculation field using the aggregate SUM function and the related field I only get the value from the first record in the list. What should I do to get the total for all the records displayed in the found set?
-
- 1 reply
- 781 views
-
-
In Kiosk mode, under Windows XP, when I give the user a text block to fill out, Cntl-C & Cntl-V (copy/paste) and similar keys are not recognized, and instead generate invalid characters. Is this another "limitation" of Kiosk mode? (I am targeting Dacons Menu Control for a future release, but I'm about to ship this version.) Thanks, Rick
-
- 2 replies
- 2.2k views
-
-
It seems like this is a simple problem, but I just can
-
- 2 replies
- 752 views
-
-
Question. I am planning on purchasing FMP7, but I had a question first. Does it come with Avery label templates I really need to know this b4 I purchase it. I downloaded the trial version and it did not come with it so I'm not sure if I will purchase it if it does not work with it. I need the avery template for the business cards (5371, 5372, 5376, 5376, etc). If it does not come with it, I need someone to tell me what the dimensions are for the custom label for the business cards (for name tags)... THANK YOU VERY MUCH! I would appreciate a quick response, it's kinda urgent!
-
- 7 replies
- 1.9k views
-
-
Is there a way to sum items through a portal, but only if the match field meets specific requirements (i.e. a specific text string and its associated number). In plain language it might look something like: If the contents of the field in the portal "x" are "Expense", then add those contents and put the result in a field call "Total Expenses". Any help appreciate. Just can't seem to get my head around a conditional sum within an If statement, which is referring to a portal field
-
- 1 reply
- 659 views
-
-
I am constructing a file that includes several tables, including these: 1) an Events table, and 2) a Client table. The purpose of the database is to construct a life-history database which is made up of events (records from the Events table) in a client's life, arranged chronologically. The file will contain data for several clients, but I will only be working with data from one client at a time. I want to tag the individual records in the Events table (each record is one event in a person
-
- 8 replies
- 1.2k views
-
-
I have a portal populated with potentially thousands of rows, and I want to print it out for the user. I tried forming a new layout (just for printing) consisting of a very large body part, cramming as many rows in as possible - but it's much too limited, and I can't take advantage of "sliding". I've hit upon something that works, but it seems terribly clumsy. I'm hoping someone can tell me something more direct and elegant using FileMaker as it's supposed to be used. Basically, I defined a new table consisting only of a key field, relating this table to the portal's underlying table using the key. I insert rows in the new table for each portal row in the underlying …
-
- 6 replies
- 1.1k views
-
-
Hello, I have a value list set up from field size in table "sizes" which only has 3 fields (size, rate, idnum) and when I choose one of the size values i want it to look up a value from that same record, but it doesn't seem to do so... i have idnum and rate set to look up from "sizes".... is this making any sense, i'm a newbie. thanks for any clues. Dan
-
- 3 replies
- 739 views
-
-
Hello All! I'm totally new to FMPro. Having a bundle of fun and very pleased with myself until I tried to define a value list with images in a folder on my hard drive. I'm trying to get a container field to offer a choice of 5 jpeg images. I have tried every variation under the sun with that file path and get "...snytax/can't find file..." error message every time! Arrggghh! Thanks for your assistance! Lisa
-
- 3 replies
- 610 views
-
-
I'd like to grey out all but the first portal row.. so that the most recently created record is the active portal record, and the rest are considered to be inactive. I attempted this by creating a container field that would show a grey graphic if the portal ID of that portal record was anything other than 1. So... I have a MASTER table that shows a portal of records from the RELATED table. 2 of the fields in the RELATED table are Portal_ID which is a calculation (get(portalID)) and color which shows a graphic container based on the portal ID the problem is the portal_ID field doesn't seem to be working. It shows 0 for the first row and a "?" for the…
-
- 3 replies
- 715 views
-
-
Hello, apologies if this has already been answered but I have searched and not found the answer. I know that there is a problem with the Pop-up lists being slow in version 7 - they were much quicker in my older version - in my older version if you typed in the first letter of the search it moved straight away to the names beginning with that letter but in this version I have to wait until the list comes up then type and wait. Is there a workaround or way of improving this? Thanks a lot Grace
-
- 7 replies
- 1k views
-
-
I've got a conference database, with 4 tables: Contacts Events ContactEventsJoin Activities There is a many-many relationship between Contacts and Events with ID fields through ContactEventsJoin and there is a one to many relationship between Events and activities (Many activities at 1 event). Each activity has a cost so in the Activities Table, there's a Name Field and a cost Field for each record (and an Event ID field providing the relationship to Events). In the ContactsEventsJoin Table, there is a field for activities. I've made it a checkbox set using a list of the related values in the Activities table so that I can check off what activities…
-
- 1 reply
- 689 views
-
Recently Browsing 0
- No registered users viewing this page.