FileMaker Interface Features
-
I am having huge frustrations with conditional value lists. I have a very good understanding of how to set up the relationship and how to get the value list to work. Here is my problem. I have a Attribute Index and I want to filter based on attribute type. This works fine (both browse and find mode) if the layout setup is based on the Attributes Table and I get the values from the Attribute Index. However, if you start to go a couple degrees up the relational ladder, it gets funky. I want the layout setup to be based on People, showing a portal of their attributes, with the attribute index used as filtered value lists. This works fine in browse mode but in find…
-
- 1 reply
- 908 views
-
-
I'm trying to make a textfield combine the rows in a portal but don't get it to work properly. I'm working with FM6. A full description is below. Hope someone can help. I've made two simple databases to test the procedure. If it works I will implement something like it in a larger database. The databases are called 'Countries' and 'Hotels'. The database 'Countries' consists of 2 fields: - Country - Text The database 'Hotels' consists of 3 fields: - Hotel - Country - Url I've made a relationship based on the field Country in both databases. A portal in 'Countries' is showing the urls of the corresponding hotels from 'Hotels'. So far so go…
-
- 2 replies
- 805 views
-
-
I know there is nothing holding me back from adding more than one portal on a layout. However the database that I am working with is using one record for each layout. I am not sure I am even asking the right question, but how do I get the two(or more) portals on the same layout use the same data from 1 record? I can post screen grabs if needed. I am working on the interface portion of this project while another person is working on the backend functions. To make the project much easier to use I'd like to have multiple portals on the layout, while the backend developer is have issues with this. Any thoughts?
-
- 5 replies
- 1k views
-
-
I have multiple portals in one layout. Does anyone know how to group them (or equivalent alternative) so they can all be scrolled simultaneoulsy with one scroll bar? I need the cell contents to line up.
-
- 2 replies
- 784 views
-
-
I'm very new to FM7 & need help with my Value List. I have set up an inventory DB, I add new product through a purchase invoice by way of a portal. I have "Product ID", "Product Description" , "Product Cost" and Sales Catagory fields. The Sales Catagory field is based on a Value List called Sales Catagory which includes "Grocery", "Pop", "Confection" etc entered as a Custom Value List. My problem is, I need to sort & find the Total Product Cost of all the "Grocery" product, the "Pop" product, the "Confection" product etc. I also need to print this calculated information. I don't know if I can do what I require or how to do it, any help would be greatly appreciated…
-
- 5 replies
- 1k views
-
-
I can't even figure this one out through filemaker's own tutorial help function . . . . How do I create a relation? (and through which table to I make it/have it show through? Let's say I am creating a database with two tables: Company, and People. In the Company table I have a "name of company" field as well as a "ID" field with an auto-entry serial number, and an "address" field. In the People table I have the same "name" field and also with "ID" field. If say I want to have the name of the company each person is associated with and it's address to show what other fields do I add? and to which table? **I noticed that in creating a new table that a new s…
-
- 4 replies
- 922 views
-
-
I have several portals arranged in a horizontal way (same relation). Each should show only one row and the first record to show is set to 1, 2, 3,... . On a Mac the result is a horizontal portal showing me all the records 1, 2, 3,... of the given relation. On windows I always get an additional record showing outside the portal bounds. In the first portal I get record 1 and record 2 as a "ghost". In the second portal I see record 2 (and 3 as "ghost"),… Is this a known bug of FM 8v2? This makes my application useless on a PC (and I tried different machines) Maybe someone can direct me to a solution? Thanks, Martin
-
- 0 replies
- 727 views
-
-
I have a database of publications to which materials need to be sent on different dates. The main table is the list of publications; the child table is the dates on which items were sent; the matchfield is a serial number. The main table shows the publication name and address at top, with other specification fields, e.g. Fashion, Major Daily etc.). Each record in the main table contains a portal with the related records for the artist and the 3 materials that need to be sent out. Having found a set of publications, and entered the information in the first portal row on the main table, is there a way to "replace" this information in the remaining records in …
-
- 4 replies
- 810 views
-
-
Hi All I know you can now have 'sticky' portals in FM7, to stop the portal popping back to the top. Is there a option to stop a text field from popping back to the top when you tab or click out of the field?
-
- 2 replies
- 819 views
-
-
On the opening layout (Sent to Vendors) I am trying to make three fields populate through a portal by selecting a name from a popup list. Take a look at this and let me know why it won't work. Phil Bid_Application_Form_Copy.zip
-
- 3 replies
- 775 views
-
-
hello, I am creating a layout using an Avery template. With multiple fields to each record is there a way for me to have displayed/printed out onto a single or continous sheets of all those different fields but under the same record with the same info? Specifically under the avery label template layout I have 3 fields: Name of person, Company, Address . . . . . but with more than one name to each compnay I'm not sure how I can go about doing this. Anybody here get what I'm trying to do here? Seems like it could be a simple solution. -brian
-
- 3 replies
- 878 views
-
-
Is there a way to make a portal "auto adjust" to the number of records contained in it? I've got a report that is viewed as a list and is in one table, but displaying records, via a portal, from another table. There's an obvious problem in that when I print, if the portal only has 3 rows and there are 4 records, one record does not print. I've discovered no obvious solution. Making the portal 20 rows deep would be a waste of paper, considering each portal generally only has 1-5 records (but occationally, there are 20!). Does anyone have a creative way of dealing with this? Thanks much!
-
- 3 replies
- 760 views
-
-
Please excuse my lack of proper terminology, but this is my first day with FM and it will be a couple days before i can get to a bookstore to properly learn the application. im trying to build a simple database first, a comment card system. A poor little girl hasta sit with my laptop and enter 5,000 comment cards into this DB: 5 fields of Excellent, Good, Fair, Poor, or NA. I have it set up with drop down menus and tab completion, so she hits G tab E tab F tab N tab E tab Enter or whatever the ratings are per card. i havent yet figured out how to give the final report, but id also like to make the data entry for her easier, specifically removing all those tab …
-
- 22 replies
- 2.4k views
-
-
I'm developing a solution to be used by both WinXP and OSX users. I have begun inserting graphics (buttons and the like) using the jpeg format through photoshop in WinXP. However, when I open my database in OSX the graphics do not display at all. (I get the windows logo where the graphics should be) How should I be inserting graphics in to my solution to ensure cross platform compatability? Do I have to make 2 different versions? One for PC one for Mac? Any help is much appreciated. Pete
-
- 3 replies
- 872 views
-
-
I want to create a custom icon for my database template as opposed to the standard fmp icon. I am able to do this for my file on Mac, however the icon does not always remain when emailed or transferring to Windows. Is there a way to map an icon for my solution that will remain there permanently?
-
- 2 replies
- 1.2k views
-
-
I have two files - one is a 'service diary', the other is a part-catalog. I'd like to be able to display the parts in the service diary so I don't have to open the parts catalog to find the part, but I have them all listed in the service diary. I can't seem to get portal to display more than 1 item (one that is tied to a relationship) and show ALL the records in the parts catalog... can I do this? am I even making sense....
-
- 6 replies
- 1.1k views
-
-
I was wondering how it works with the creation of records through a portal. I have this set up in one instance where a invoice records are created though a portal by just entering information in the fields of the portal. When I tried to do this between two different tables I could not create records through the portal. I poked around to find something like "check here to enable the creation of new records" but could not find this. When I go to the layout of the new table and create several related records and return to the related table the records do appear correctly in the portal so I know the relationship is correct. But don't know why new records can not …
-
- 2 replies
- 901 views
-
-
I've had difficulties in the past with this, so I'm not surprised I wound up back here to get a hint. My organization sends students out to different sites to receive different types of training (TrainType). Where The TrainType is = "Nutritional Counseling" (for example), I can match up Students:studentID = TrainingSession:studentID AND TrainingSession:TrainType = k_NutritionalCounseling (k_NutritionalCounseling is just a text calculation = "Nutritional Counseling"). This is working. The problem I have is that I want to make a portal (table view) of TrainingSession that EXCLUDES students who have graduated (table_view_TS#NotGrad). The example file sho…
-
- 1 reply
- 948 views
-
-
Ok, somewhere along my development line I read that if you have multiple telephone numbers for your contacts (these days don't we all?)you should set up a separate table for Telephone Numbers. I also incorporated a Telephone Format custom function as well. Problem is custom function format doesn't accomodate international numbers. So, I set up a separate field for International numbers. My regular numbers are in a portal. Here's what I would like to do: Find a new custom Function that accomodates Intl as well as domestic numbers. That would be the easy way to resolve the issue for me. OR.... On some of my reports and layouts I want to just show t…
-
- 3 replies
- 971 views
-
-
I have created pop-up windows with scripted user abort off/hide status area/pause. This works fine. Users cannot do anything until they click one of the buttons on the pop-up. The close box is not active. However, the resize box is active, so the user can monkey with the size of the window. Is there some way I can disable this? Also, I've had a user request to "dim" or gray-out the close box since it isn't useable. Is there anyway to customize title bars? Thanks for any advise!
-
- 0 replies
- 723 views
-
-
We need to be able to quickly switch back and forth from a table (or portal view) to the form view while staying on the same record. I saw something a while back about programming this in Filemaker Advisor, but lost the article. How can I do this? ;)
-
- 4 replies
- 1k views
-
-
Hi I have been reading tons on this site and others as well... and can't seem to find "the answer". So I am going to post my question (and it may appear a no-brainer to some)... but I would truly appreciate some clear direction. Tabs-- I have multi tables and would like to create 1 layout for data entry for a person. I have tab 1 for personal info (off the people table) and tab 2 is for Job info (off the job table) and tab 3 is for Appt (off the contract table)... Job and contracts are related to people table. So do I do tabs? or fake tabs? Your recommendations will be greatly appreciated!
-
- 13 replies
- 2k views
-
-
I have a Companies table layout that has a portal for Contacts. This portal only shows one contact at a time with the scroll bar activated to enable scrolling to more contacts. A second portal on this layout lists the last names of the contacts that are entered in the Contacts portal. I want to be able to click the last name of the contact in the 2nd portal and have it display the correct contact information in the Contacts portal. Previous methods for going to a specific portal row from another portal on the same layout no longer work in FM8. I am referring to having a unique field in the first portal and using the Go to Field script step to get from the second…
-
- 6 replies
- 954 views
-
-
Hi there, I'm a beginner at Filemaker and am currently trying to modify an existing layout. I would like to make a new box that I can check to sort a list. Any help would be greatly appreciated!! please see jpeg file, it'll explain more than I can. :P
-
- 1 reply
- 739 views
-
-
I a many to many relationship with three tables, students, courses and registration. A portal in the courses table enters the registred students for every course with the help of a student ID Value list. I want to be able to filter the value list by the first letter of the last name, so I creat a calculation field that does this on the students table and a global key on the courses table. My pourpose is to base the VL on this relationship, but I am totaly stuck. I am adding an attachment of the file VL_filter.fp7.zip
-
- 12 replies
- 1.5k views
-
-
I have searched and tried all the things that make sense and know the solution will be easy ... but alas it eludes this beginner. In a portal I want a button that takes record data from the parent and inserts into that portal row. Kind of a 'same as' option when user is entering data. I have the button working but only on the first portal line, regardless which row the button is. I know I need to somehow check which portal line (get portal row) I am on, then do the work on that line but I don't know how to get that data into my script ... how do I do this? Thank you in advance for your patience.
-
- 2 replies
- 670 views
-
-
Hi, I've been asked to continue working on someone else's medical database. I'm just wanting to tidy up a couple of appearance issues on the main layout. There is a field called Eye Disease which sources from a value list (using checkbox) of several eye diseases. One of the values is: PDF(Prolif Diabetic Retinopathy) I wanted to change it to: PDF (Prolif Diabetic Retinopathy) That is, simply insert a space bewteen the 'F' and the '(' to keep the same spacing with other bracketed values. (I know this is a picky thing, but just wanting consistency). When I change the value name to this though, the checkboxes are no longer filled. The data hasn…
-
- 2 replies
- 707 views
-
-
Hello everyone, I have a value list displaying names. I want to sort them by a second field (sort number). Example: 1 Lisa 2 Ann 3 Ben But I don't want to display the number but only the names. Is there a possibility to do so?
-
- 2 replies
- 759 views
-
-
I am trying to create a letter layout that will accommodate short and long letters. Is it posible to have the letter appear lower on the layout if it is a shorter letter?
-
- 1 reply
- 1k views
-
-
I have two tables (contact and group) with at least two fields in each: group and sub-group. I would simply like to press on the down button on a layout on the group and sub-group fields connected to my contact table to select the group and sub-group data from the Group table. Not sure i need a relationship betweeen the two tables but if I did, I am not sure what fields to tie them together with. NOTE: Group and sub-group data always is entered in the Group table since it is the source. All other tables would retrieve data from this table. thanks in advance.
-
- 1 reply
- 807 views
-
-
Has anybody tried to create transparent icons in version 8 the way you could in 6 and earlier...rotate 90 deg, cut, paste special, rotate 270, etc? It doesn't seem to work for me anymore. The size of the pasted icon changes, and I can't remove the background. Steve
-
- 9 replies
- 2.5k views
-
-
I'm trying to construct a very simple summation-type report -- summing a designated account for a range of dates. I haven't found an example anywhere simple enough to get me past where I am. The ones I've downloaded haven't shed any light on what is obviously (to most) a fairly basic operation. I've attached my 2-table, 1-script example, but if anyone knows of an existing simple one, please let me know. Otherwise, I will certainly appreciate a little guidance. Thanks. SumTest.fp7.ZIP
-
- 2 replies
- 843 views
-
-
I need to place a graphic and need the white background to be transparent. I wouldn't have to do this if there was a way to rotate text 90 in the IWP interface, all rotated text goes back when viewing online.
-
- 1 reply
- 736 views
-
-
I'm developing a database for a small advertising agency. They use the Eureka typeface for all their communications. I can't find this typeface in the drop down menu for configuring typefaces - is there anyway to import a typeface suite into Filemaker 8? Thanks Debra
-
- 2 replies
- 1.2k views
-
-
I have a strange problem. I have a series of fields that are calculated results via a case statement for a field called trans_descrip. Well it turns out there was some odd data in trans_descrip that was throwing off the case evaluation, so I cleaned up trans_descrip using a series of evaluations and replacements. Now, all for all the trans_descrips I replaced the calculated fields will not re-evaluate. If I go into each of those trans_descrip fields and add a space or delete and re-add the last character the calc fields re-evaluate. Very puzzling to me. Interestingly, when I created a new set of calc fields, and pasted in the exact case statements f…
-
- 8 replies
- 829 views
-
-
A slip in good development practices forced me to go to resort to my FM7 runtime file as continuing point for development. It had custom About, Scripts and Help menu items. Is there any way to restore the Filemaker defaults? Also, does the fact that these were modified at one point rule out renaming them in a new Custom Menu Set?
-
- 0 replies
- 1.2k views
-
-
Heads up folks. Recently I did some work in FM7. Basically I had scripted entry in to the fields in a portal to allow editing of existing data but prevent new records to be entered at the bottom of the portal. (New entries were handled in a different way to ensure data integrity and the relationship had to support creation in the related table) The script tested the current row against the LAST value for the relationship to allow/disallow editing. Then I ran it in FM8... Each time I clicked on the fields the script would exit against the test. I discovered that FM8 does not get the current portal row number until a field had been selected, whereas prev…
-
- 1 reply
- 796 views
-
-
I have several variations of conditional value lists that work fine in browse mode (fm8.02) However, they do not work in find mode. The simplest one I have is this: I want to isolate class agents in my people database. I check a text field for "class agent". (indexed). I create a calculation called zClass Agent that is a text calculation with the words "Class Agent". I make a TO to filter these values and voila. I get a filtered list of just my class agents. However, you can't search on it in find mode. Is this a common problem in fm8.02 or am I missing some big lightbulb with filtering?
-
- 6 replies
- 1.4k views
-
-
I can't for the life of me create any more than one tab for a text field in layout mode. When I click "new", it just replaces the first tab. I hope I am just miss'n it and that it isn't a bug.
-
- 3 replies
- 842 views
-
-
I've done it before, but a couple years ago when I was learning FMP on my own. I've forgotten and the supplied text and help menus don't help me. To give me a good starting point, will someone first explain why we use portals/benefits of portals and how to make it. Basically how I would get started with the records in a portal. Please I need help as I am trying to figure out the simplest way to save some records.
-
- 1 reply
- 664 views
-
-
Hi all, I am desperately trying to get the items in a portal sorted properly but has so far failed utterly. I am trying to keep track of a number of images that are used in a number of documents, and therefore I use a Documents layout containing a portal showing the names of the images that are related to each document. And I would like to have this list sorted alphabetically. Each image can be used in several documents, so I am using a "link" table that connects the (unique) document ID with the (unique) image ID. Thus, my database consists of three tables: - one for documents - one for images - the link table that connects the document with the im…
-
- 1 reply
- 655 views
-
-
Hi, Please excuse my lack of ability! I have a "bookings" portal on the main "patients" page and i wish to do a find on this portal to look for any bookings that have not been invoiced, but only those relevant to that patient. I can make this happen in a separate layout no problem (try the show uninvoiced bookings on bookings layout script) but can't work out how to do this within the "bookings" portal on the "patients" layout. I've tried a few different ways but can't ssem to make it happen. Any pointers or a proper solution would be very greatfully received. Thank you Patient_6.fp7.zip
-
- 20 replies
- 2.8k views
-
-
I have a portal set up to track multiple presentation sessions by individual speakers (each record contains one speaker with the related presentations in a portal). What I need is to combine the session names from multiple portal rows into one field for printing purposes. Each portal row contains 11 separate fields, but I just need information from one of the fields combined. How would one go about this? Thanks in advance for any help provided.
-
- 2 replies
- 779 views
-
-
Hopefully some more experienced users can show me the way here... Basically, my file has 3 tables: events, stock and hires. The 'hires' table contains records which link stock items to events, i.e. each record has a stockID and an eventID field. Relating eventID between the 'events' and 'hires' file allows me quite happily to show all the items from stock associated with the event in a portal. Fine. However, I want to have a seperate portal on the same layout which shows ALL items from stock, but with a marker in each row indicating the status of each item, relative to the event record currently being browsed - in other words, indicate which stock items are avai…
-
- 12 replies
- 1.4k views
-
-
Just wondering if anyone can direct me to a publication which explains how to design a web site using Filemaker 7 - something which someone with mid-level rather than maestro experience of FMP could follow; and does FMP 8 have features which make it easier to publish a web site than FMP 7. Suggestions very welcome as always.
-
- 0 replies
- 1.1k views
-
-
O.K., I've figured out (finally -- on a 4th pass of the layout wizard) how to make my report group properly. MY REMAINING ISSUE is how to get the listed items to be separated by commas across the page -- rather than printed in vertical columns. In the accompanying database, the word “Clear” would show all synonyms separated by commas: Clear -- Bright, Transparent, Lucent, < . . . and so on> I've turned on the Slide Field option to no avail. This is my first attempt at a grouped report and I would appreciate it if someone could point me in the right direction. Thanks (An aside: I posted this question a few days ago under Printing, …
-
- 4 replies
- 884 views
-
-
I can't believe I'm entering this! My customer wants a list of customers sorted on contact name. No big deal. He wants those without a contact name to be last in the sort sequence. No matter what I do, I can't get them to sort with blank contact names last. I thought empty might be a problem so put spaces in the empty ones. I've set up a special Value List with the 'normal' alpha sequence and finishing with a " ". The " " still sorts first. I don't really want to put in an additinal calc field but that's beginning to look like the only option. Any clues?
-
- 6 replies
- 833 views
-
-
Hello, I have 2 new fields in an invoicing table that have been defined. I have an invoicing portal in my main layout, and I would like to add these two new fields to the portal, so that it doesn't mess up the existing portal setup. The only thing I can find that seems close is in the "Format -> Portal..." dialogue window. But, this only gives me the "sort fields" option, which I'm afraid to do, because I don't really want to sort anything....just add these two fields is all. Any help would be appreciated. Thanks. Nick
-
- 4 replies
- 1.3k views
-
-
Hi, I can't seem to be able to have a portal within a tab where the layout is based on table occurrence 'widgets' and the portal is also based on 'widgets'. Layout Setup Show Records from 'widgets' Portal Setup Show related records from 'widgets' When I try to setup the records which are related to widgets, widgets is greyed out. Leads to to believe this is not possible. Help/advice would be much appreciated
-
- 2 replies
- 614 views
-
-
Hi all, In the 1 record I have 10 portal lines, what I need is when I just click check box field (click about 5 portal only) and they only copy the 5 portal I'm click to the new record. Can this be done? I was think this solution about 2 weeks, hope anyone can help! Thank!
-
- 2 replies
- 910 views
-
-
Is there any possible way to keep FileMaker from placing the black outline around a text field when it's selected by the user for editing -- or maybe change the color of the line? Turning off Show Text/Field Boundaries doesn't work, nor does placing the field behind a white line frame. I'm starting to believe the answer is "no", but I thought I would ask before I abandon the idea.
-
- 0 replies
- 700 views
-
-
My layout contains a rectangle which surrounds a group of fields: [Name] [Company] [Address1] [Address2] [City] [state] [Zip] Company and Address 2 may be blank. I want the rectangle to slide upward, along with the fields it contains, but I don't want the fields within it to slide relative to one another. How do I define the Sliding properties of these objects? I suspect it's a matter of adding some "invisible fences" but I haven't found a solution yet. Thanks - Chap
-
- 2 replies
- 913 views
-
-
I have a client ID value list I'm using in a global field for a relational filter, when the user chooses it I tell it to show the second item, the client name, however the (long) ID is shown in the field after they click out. Any ideas on how to capture the name and have it show in a field? Thanks.
-
- 3 replies
- 738 views
-
-
I've inherited a wonderfully complicated database that I'm trying to patch. I have some summary fields for the entire Breeding table that are supposed to display in Colony. Due to the sort order for some other content on the layout, the first record in Colony does not have a matching record in Breeding. As a result, the summary fields for Breeding are blank. How do I setup my layout so that the summary fields are not blank? Or is it even possible...?
-
- 1 reply
- 867 views
-
-
Hi, I currently have a portal that is pulling sample text from other records. Unfortunately, the number of records it pulls from and the amount of text it needs to show varies. This results in the sample text being cut off, or not show in the size portal I have. When printing these reports, there's lots of empty space to account for all the variations. I thought a solution would be to have a field pull all the contents of the portal into one text field that I could then set to slide. I assume it's like a calc field, but don't know how to properly write the script to achieve this. Any help would be greatly appreciated. Thanks! -wing
-
- 2 replies
- 706 views
-
-
Hi, I duplicated a Layout and deleted all of the records in the new layout. It wasn't until after I had closed the database and reopened it that I realised I had deleted all of the records in the original layout too. Is there any way I can get these records back. (No, I don't have a back up). thanks in advance stephrocke
-
- 2 replies
- 816 views
-
-
Hello, How do I get a portal calculation to work. I need to get a sum from a field in a portal and place that number in a field outside of the portal. Any help would be great. Thanks
-
- 8 replies
- 929 views
-
-
Hello all I'm trying to imitate the replace function in a portal. I used to have a pop-up menu so everybody is used to just choose a value and replace it in the current found set. Now that field is a portal, because I need it to hold more than one value. How would I set a selected list of records to one specific value in a portal? The problem is, that maybe some of the records already have that value. The script should just add the value to those records that don't have it yet. If you have an idea, please let me know.
-
- 2 replies
- 710 views
-
-
Ok, here's the scoop: I'm trying to create a dynamic portion to my DB for what will eventually be implemented on the web. Basically I will have a series of drop-down menus where the value list of the second drop down menu is contingent on what is selected in the first value. So I imagine I will use the Case function... Case(Short_ID="JAZZ"; result is Jazz subcategories appearing in the Subcategory Drop-down list; Short_ID="BLUS"; result is blues subcategories appearing in the same Subcategory Drop-down list... and so on. Does this make sense? is it even possible? Thanks for your help, this exceeds my filemaker knowledge.
-
- 3 replies
- 813 views
-
-
I have made a value list to use on a field where the user selects an ID number (the PK for a related table). The value list is set up to contain values from a field. This works fine. I have 400 records, and the value list has 400 items. This is good, except the user has no idea what ID number is associated with which name. So I have also displayed values from a secind field (the name field). This still works fine, except there are 400 items in the list, so it would be nice to sort them alphabetically by last name. When I go in and tell it to sort by the second field, then the field with the value list attached to it only displays two items instead of 400. I hav…
-
- 9 replies
- 1.2k views
-
-
I have a text field that I have set up so that the user chooses a color and then the text field changes to that color. It all works great on the screen, but when I choose print, nothing shows up. Any ideas?
-
- 3 replies
- 786 views
-
-
I would like to know if there is a way to manually insert forced page breaks like those that can be inserted when using MS Word. I have a layout with a header and title header. the little dotted lines that are supposed to represent the page are severly skewed when those two parts are added. I have to flip back and forth between Layout and Preview modes and move the fields up and down and it is getting very annoying and slow. It's also very tiring to finally get the fields on the right page only to have the top margins vary from page to page. I am not opposed to a work around but I don't want it visible to the end user. Any help would be appreciated!!
-
- 7 replies
- 2.4k views
-
-
I have a data entry layout which includes a language profile (matrix) with 20 Language fields (popup menus) from two related tables. I’d like each Language field popup to offer a list of common values (e.g., Spanish, English, French…Other) that will grow when “Other” is selected and new language choices are added. This way, data entry would be a simple series of selectable choices with an occasional addition to the list (via “Other”). I’ve read several resources and consulted FMP Help about value lists from a field, and have tried (many times) unsuccessfully to get the 20 fields to cooperate. My sad work-around is to create 20 value lists – each linked to its designate…
-
- 4 replies
- 813 views
-
-
Iâ��m not really sure if this is portal problem or a relationship problem â�� imho I think itâ��s a little of both. So please forgive if Iâ��ve posted in the wrong forum. Iâ��m trying to create a bidding system that will allow me to create proposals on the fly. So far Iâ��ve got five DBs: clients, vendors, product categories, products, bid builder. I am using the client db as the main interface for contact info and for generating proposals. The bid builder db is the conduit for pulling all the proposal info together. The problem Iâ��m having is getting the bid builder to show up properly via a portal. I need to be able to keep multiple revisions of individ…
-
- 2 replies
- 776 views
-
-
I want to create an online database that will find a physician (from an unposted list) based upon city and state. or better yet all physicians within 100 miles of a specified zip code... Any suggestions? It should be a fairly simple solution. Thanks... Mark
-
- 25 replies
- 2.6k views
-
-
I am using FMP Advanced 8 v 2. I created a company database, and included a purchase order function. The purchase order page has a portal to a purchase order items table. We imported our list of items from quickbooks, since we are now using the filemaker database. However, a number of the quickbooks items have descriptions which are too long for the portal window. I wish the program would text wrap, but it appears it won't. If I make the field big enough to fit all the text, then all the fields become the same size in the portal, and it becomes too large to print. I have tried using merges, but that doesn't automatically resize the size of the portal row. I tried d…
-
- 12 replies
- 2.6k views
-
-
I have built a invoice report that list line items by category. The category is in a sub-summary part while the line items are in a "body" part. When the line items are broken up to the next page, I would like for the category label to repeat on the next page with an additional label "...continued". Example of Report Layout: Category A ------------- Item one Item two item three [color:red]Category A (...continued) ------------- Item four Item Five Category B ------------- Item one Item two How can I get the Category part to repeat on the next page and add a "continued" label??
-
- 0 replies
- 663 views
-
-
I am printing a 4 page newsletter, updating it monthly. I am using 4 layouts to create the look I need. I want to place it in a PDF. Currently all I get is a PDF per layout. Is there any way that I can get all 4 layouts into one PDF? Ideas?
-
- 6 replies
- 1.9k views
-
-
hi fmforum, here's what i'm trying to do: 1. create records of resouces that are assigned categories via valuelists (often multiple categories) - this would be seen as individual records in form view with detailed resource info, possibly images - (also includes a field that shows which categories have been assigned to that record) 2. search the resources in a new layout with the same valuelists in a header that would display the results of the selections in list view in the body (portal? - didn't seem to work). so multiple selections within a menu or among multiple menus would show all related matches that have the selected categories assigned to them. 3. se…
-
- 0 replies
- 817 views
-
-
Hello, I have a database of abut 4800 radio programs and 3000 radio stations. I am trying to do a drop-down menu of the programs, however FM8 is condensing it and only showing the first show by that name. For example, "Morning Show", FM is only showing Morning Show for KCTX-FM even though a show by that same name is also on 10 other stations in the US and in my database. How can I stop it from doing this? I added an additional field next to it, the program name and the station it is on, however that station has two shows in our database, so even if I sort by that station, I still only find one show by that station even though there are two. Any help wo…
-
- 2 replies
- 770 views
-
-
I wanted to add a conditional value list then a lookup to my database, but I have thus far been unable to get it to work. Here is the concept: I have a category value list. After selecting the category, a relational value list is used for the item. I then want a lookup used for description and unit price. However, the lookup happens as soon as I seect the category. Anyone know a way around this?
-
- 3 replies
- 1.3k views
-
-
Is there a file that can control the look of the layout? Something like CSS for the web page. Thanx
-
- 1 reply
- 784 views
-
-
A new collection (expanding in future) of tricks & examples for FM8's tab control has been published at 24U Software's web site. Demonstrated techniquest include: Dynamically calculated tab names Go to Tab by script (with dynymically calculated target tab number) Get ( ActiveTabNumber ) Unlimited nesting of tab controls to save even more space Please enjoy the free example(s) and feel free to e-mail me with any questions or suggestions. HOnza ScriptedTabControl.zip NestedTabs.zip
-
- 8 replies
- 3.6k views
-
-
Hi all, and thanks in advance yet again for answering another of my noob questions. I'm trying to create a simple report that shows total time billed for each staff member. I created a layout with one sub-summary part containing the standard fields "Staff" and "Hours Worked". The sub-summary part is set to sort by "Staff". What I get in preview mode however is a normal list view of each record for each staff member with the individual hours worked for each record. What I want is a single, cumulative line entry for each staff member that also totals the hours. What happens now: Joe Smith 10 hours Joe Smith 5 hours Joe Smith 10 hours Joe S…
-
- 4 replies
- 983 views
-
-
I need to use a value list in a portal, displaying the contact name, to enter the contact ID to establish a relationship between two tables. This VL might grow eventually to a fairly large number of records to be easily managed on a VL. What is the recommended procedure for this situation.
-
- 2 replies
- 797 views
-
-
My pop-up is long. Is there a way to have a pop-up presented in more then 1 row?
-
- 4 replies
- 878 views
-
-
I want to include a "Delete" button in each row of a portal (easy enough) but I don't want the button to appear in the empty row at the bottom (the one that's there for data input). I've found the 'visibility' techniques mentioned elsewhere, but I don't know how to apply it to a portal row object. Any hints would be appreciated! Chap
-
- 2 replies
- 787 views
-
-
Forgive me, I haven't been under the hood since version 6. I've a database of crew members, say three fields, type (clients, staff, or contract) Positions (what possition will they hold as a client, staff or contract person) and name. I want to be able to create a list of everyone associated with a particular job in a portal. The first drop box is easy, list the values in the type field of the Crew table. What I haven't figured out is how to limit the options presented in the next drop box to list only positions appropriate to the selection made in the first drop box. Then the 3rd will present only people who are say contract / Assistants or Contract /…
-
- 1 reply
- 744 views
-
-
Hi there, maybe someone can assist me to let me know what I am doing wrong here? --- I created a portal based on a relationship which allows me to create records. Creating the records is working easy enough when I enter the data so part 1 is a'ok. --- my PROBLEM is that a new blank record in the related table is created everytime I enter data, meaning I will end up with hundreds of blank records if it keeps going this way. a simple explanation of my file structure is this: file #1 - events file #2 - guests invited to events Its a simple one/many relationship, with the portal looking at the guests from the events file. The relationship is defined by ev…
-
- 1 reply
- 981 views
-
-
Am I really the only person to be losing sleep and patience over this ungreat new feature in V8? When setting tab order on a layout, I used to always leave out a few numbers in case of errors or subsequent additions. Now, with V8, I leave out the numbers and FMP just re-numbers them from 1. It is driving me crazy. Anyone know how I can FIX my numbers?
-
- 7 replies
- 861 views
-
-
please take a second to post a picture or sample file of you favoriate or only layout design. i am always looking to learn about layout design and what better way then sharing with your peers here is mine: my layout
-
- 4 replies
- 1.9k views
-
-
How can I show the window name in the header of the page? I tried to set up a global calc field using Get(windowname) as the calc, but it shows whatever the first windowname is but not the current window. What I am trying to accomplish is have the Window Name>layout name in the header so I don't need to look at the top bar. I find that when I'm navigating all over I wind up with multiple pages open which tends to get very messy. Any suggestions? TIA, Al
-
- 4 replies
- 900 views
-
-
am making a Contact Directory and want the first(Last-Name) on each page and the last(Last_Name) on the top of each page. I can get the first(last-Name) by putting that field in the header, but can not come up with a field definition for putting the Last(last_name) there also. If anyone knows how to do this, pls let me know what the formula would be.
-
- 1 reply
- 642 views
-
-
I have a 350-seat performance space. For each performance we ask our patrons to give their Zip/Postal Codes at the door when they enter. I need to keep a record of each performance and number of each Zip Code recorded. Most fall in the range of the 40-or so Zip Codes in our metropolitan area, but some happen to come, at random, from Zips we have never recorded before, perhaps from outside the state. I need some advice on the fastest and/or most efficient way to enter all 350 Zip Codes in an individual record for each performance, and have them, if at all possible, self-tabulate as to the number of patrons from each Zip Code. Can anyone point me in the right direction as…
-
- 5 replies
- 965 views
-
-
If the user is filling out a form, and clicks "YES" as a radio button for field 'completed', is there a way to automatically do a calculation and put it into field 'total' ? I would like it to do a different calculation depending on which radio option was selected. This without the user knowingly running a script.
-
- 1 reply
- 642 views
-
-
Hello - I have a repeating field of 10 values defined in a file, but on the data entry layout, I have only room enough to display maybe 2 of the values from the field. I thought that the user could just enter values and hit tab or Enter to keep adding repetitions, but it looks like you can only enter two values if only 2 reps are displayed. The field doesn't expand for entry, at least, not as far as I can see. Am I missing something that turns this on, or is it not possible? I'm thinking of something similar to what happens when you type beyond the bounds of a text entry field... it expands so that you can keep entering data. Thanks, Jeff
-
- 1 reply
- 603 views
-
-
I am creating an inventory list. There is a list of objects, their storage location and a notes section - all in a single horizontal line. I added a container field beneath the notes section so that I can insert a photo of certain items. Is there a way to make a container field recognize when it's empty so that it will slide up? This is my first time working with container fields, is there something special I have to do, or do they just not slide in general?
-
- 1 reply
- 564 views
-
-
I have some information I need to compute off 2 other fields in the table. It will only be used on the layout, and never referenced. Do I have to create a calculation field in the database, or is there a way to just create a field or portal on the layout that shows me a calculated result?
-
- 1 reply
- 656 views
-
-
Can anyone tell me if this is possible... Filemake newbie here... I'm in real estate and trying to produce a variety of reports, I have a good "detail" level report I trying and to get a one line summary report for example... Fields ListBkrCode ListOffice SummarySalesPrice SummarySaleCount TEXT TEXT SUMMARY (Total of) SUMMARY (Count) (salesPrice) (ListOffice) The current database covers seven adjoining zip code areas and has 5665 records with 17 fields per and I know there are well over 100 individual ListBkrCode when I group them in the report. What I want to do is remove the individual line items and just print the sub-totals w…
-
- 1 reply
- 690 views
-
-
I am constantly trying to find a webding or wingding to use (and sometimes other fonts). I have been using them for graphics (they are very resource-efficient). I want the results of each key-combination viewable on one layout (or each font on a separate layout) telling me the key-combination of each. Once I select a font picture, I want to be able to apply colors to it. I already have a ColorCode demo (of Comment's) in place. I would like to also be able to change the size but I'm not greedy (smile). Once I determined the font, color and maybe size, I want to click a button and capture this formatting. The question is of course how to then transfer the results. …
-
- 0 replies
- 761 views
-
-
Hello All. I'm a newbie to FM and I have a question about tooltips. I have no problem with the basic use of GetNthRecord() function so far. I figured out how to see the next record (person's name) in a found set and the previous person's name. My question is: When I reach the end of a found set, how do I get the tooltip to let me know that there is 'No more records'? I'm embarrassed to ask such a simple question on this forum. Thanks
-
- 4 replies
- 1.8k views
-
-
I know this is a bit of a vague question, but is it possible to have filemaker generate layouts based on scripts? The reason I ask is because I want to create a table called "preferences", and have the ability to turn certain elements on or off. On a related note, is it possible to have a layout reference/include another layout? The best way I can think to explain this, is that, with mediawiki for example, you can create "template" pages which can then be included as part of other pages. This would also be handy for having a boilerplate header/footer.
-
- 2 replies
- 730 views
-
-
Odd problem. I have a list of thirty or so teacher names. When filling out report cards, the teachers select their name and are automatically taken to their class lists. A few times over the past week-- say 4 or 5 times-- the value list has spontaneously changed. Visually it's the same, but when a teacher selects her name, she gets no matching students, even though the student lists show her name in the teacher field. Further investigation revealed that on the value list the name now has an invisible character padded onto the end of the name, so "Ms. Smith" has now become "Ms. Smith ", and a match doesn't occur. The character is either a tab or some…
-
- 1 reply
- 883 views
-
-
Is there a way to allow the user to copy a text box with merge fields so they can easily paste it in another application? Now, I know that I can create a calculation field and arrange these fields however I like and that would solve my problem. However, there's thousands of ways that you could want to format names, dates, phone numbers, addresses and creating fields for each way seems like it would quickly get confusing. I would be trying to remember which field has which formatting. In writing this it occurs to me you could have a global text field that you simply populate via a script and somehow export/copy that but then you still have a single scrip…
-
- 0 replies
- 655 views
-
-
I am trying to create a layout in FMP8 which is higher that the maximum that seems to be allowed: something around 111 inches high, according to the rulers on the screen. I need this layout to have another page or two, taking it to around 130 inches or so. Is there a way I can break through this apparent maximum layout height? Thanks for any help.
-
- 6 replies
- 1.1k views
-
-
I have a database for my work where i store data for appointments. I have a option where people are either "Renting", "Paying Mortgage" or "Own Home". Also a bit down the page there are other options if they are renting, for example if they are renting i need to find out household debt and deposit. What i was wondering was if there was a way of making so that; If radio box "Living status" = "Renting" then the other radio boxes (Household debt and deposit) are enable, else they are disable and grayed out so they cant be clicked. Is this possible ?
-
- 6 replies
- 1.1k views
-
-
I have a 1-row portal on a green tab control. When I click anywhere in it, outside the actual fields, the whole portal goes a disgusting purple. Any ideas on how to stop this?
-
- 3 replies
- 744 views
-
-
Is there a way to specify a Default Menu set based on a privalege set? I would like to a user to always get a menu set based on their original login. The only way I can see to to that is to include it in all the navigation scripts (ie, go to a layout, then change menu set). This seems burdensom. I would like to have something that would set a default menu set for each user type, then I can just assign the use file default menu set for each layout. I just don't see it. Is this possible in FM8 or do I have to manually change all my layout scripts? TIA jerry
-
- 1 reply
- 1.3k views
-
-
I have two value lists being generated.., let's call them "a" and "b" I'd like to create "c" by subtracting "b" from "a" like so: valuelist a bird fish cat dog valuelist b bird fish I'd like a way to create this valuelist: valuelist c cat dog Is there some relatively simple way ?
-
- 3 replies
- 1.1k views
-
-
This may be a simple answer (it seems like it should be), but I am having trouble creating a button that will return me to the last layout I visited. I have a couple of pages on my database that are accessible through many routes, and I want to be able to make a button that will take the user back to the layout that got them there. I have searched previous layout posts to no avail. Thanks for the help.
-
- 2 replies
- 847 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online