FileMaker Interface Features
-
Hopefully someone can set me straight on this. I've got a checkbox set for a field, using a value list. I want to be able to predefine which items are checked off, based on other info from the record (i.e. Province) In order to do this, do I need to create seperate fields for every check box item rather then using a value list? Example... Poster types. Value List: Poster 1 Poster 2 Poster 3 Poster 4 etc... If the Province is BC... I want Poster 1 and poster 4 to be checked off. Thanks, Scott
-
- 2 replies
- 719 views
-
-
Has anyone tried creating a tooltip that shows data from the first, previous, next, and last found records? In other words on the button navigation panel, have the customer's name from the first record shown as a toolbar, on the 'first' button, customer's name from the previous record shown as a toolbar on the 'prev' button... etc etc.
-
- 1 reply
- 1.3k views
-
-
Hi, I've added new fields to a layout in form view, but when I switch to table view I can't see them. Is there a way to add fields to the table view? Thanks, Matt
-
- 2 replies
- 750 views
-
-
Is there a way to force the user to choose from one of the drop-down list options and disable his/her ability to type anything into the field? Also, is it possible to make the box that appears around the set of drop-down items size itself appropriately to the number of items in the list? Thanks.
-
- 3 replies
- 944 views
-
-
I created a 40 page user guide for my solution using the "Grab" screenshot feature new to OSX.(it creates .tiff files)the thing looks beautiful..until I open with a PC. Each of the 200 or so graphics displays, instead, "Quick Time and TIFF(LZW) decompressor are needed to see this picture" Please tell me I don't have to go in and convert all those gfx files to jpegs...there must be another way! Thanks in advance
-
- 7 replies
- 1k views
-
-
OK so I have a Contracts table related to a Company table by a CompanyID and the Company table is then related to a Contacts table by the CompanyID. I have a layout based on the Contracts table where I can enter a CompanyID from a value list and then have only the Contacts associated with that Company show up on the ContactID value list. However, it only seems to be working with values already existing in the list. I want to be able to include a button on the layout so that if the user finds the Company (or Contact) they are looking for isn't already included, they can click the button and go to a layout to add the contact, then return to the Contract layout and …
-
- 5 replies
- 873 views
-
-
I must be losing it! I know this is so simple that I am embaressed but I am mind dead about this. I have a portal that has worked perfectly up to now. It was originally a const1 type self join. The portal is now using a single key matched to a multi-value selector list of values delimited by a carriage return (so I can filter portal entries by a first letter in a name etc.). All the records show proper match field contents. The current problem is caused when I create a new record on a layout dedicated to the original table instance. The new record doesn't show up in the portal even though it has a proper match content. Switching layouts, sarting and stoping the program, s…
-
- 2 replies
- 686 views
-
-
i have a portal on a layout to display servers and their tipout amounts for a restaurant. Now, when I enter the servers into the portal, are they not automatically related? because the second I hit enter, there are no more related records showing. but when i go to the layout that shows all the server records regardless of relation, they exist, and the correct variabkes match up. i will upload the file here to show what i'm taking about. the ones i have in so far that aren't working are under the banquets tab, and then under banquet 1 on the lunch shift of 9/18/2005, 9/23, and the dinner of 9/23. bizarre! thanks! amber tip_share_Copy.zip
-
- 6 replies
- 707 views
-
-
Hi, The new new menu sets are nice, but I can't really use them unless I can specify different default menu sets for different user groups. For example, as a developer I need full access, but sales reps would get a limited access menu. Attempts to script menu sets are cumbersome because they return to the default as soon as you switch layouts. Has anyone found a better way? Thanks, Andrew
-
- 1 reply
- 1.1k views
-
-
Hello, I'd like to send a selected portal row's data to a field on another layout. Schema: 2 layouts ; 2 windows. Relationships: Table:Department Field:"Department" linked to: Table:Course on field: "Department" ------------------- Table:Student field:"special rec" linked to: Table:Course on field:"CourseID" The field "special rec" in the Student table is empty and waiting to be filled by a selected course. On the student layout, a button is clicked to pull up a window containing a layout which displays the departments with their respective courses in a portal. I then want to choose one of those course…
-
- 4 replies
- 872 views
-
-
Can anyone explain a fundamental method to using portals. For example in using two tables on a many-to many relationship one needs to create join table and then have the join table be the basic portal, though the fields can come from the other tables. I can't get my head around why this should be the case. I'm a novice and its not clear when and why you should use particular tables over others when using portals. Even though there are clear relationships by using a different table occurence as a portal often brings a completely different set of results. Is there a clear method to this?
-
- 3 replies
- 758 views
-
-
Hi everyone, I could not find a topic on this. Can I make a portal summarize my records? In other words, I have a descriptor field and a qty field. I have many records with the same descriptor (2pvc for example). I want the portal to show 2pvc only once with the summary field of the footages. How can I do this? thanks in advance
-
- 1 reply
- 696 views
-
-
Is there a way to translate in another language the edit and add that exist in a value list (or change the name....)???
-
- 1 reply
- 1k views
-
-
How do I get a list view to show whole page. I moved the body part line all the way to the bottom but it does not show whole page. only bout half. Thanks Tony D.
-
- 1 reply
- 705 views
-
-
-
This is puzzling me: Is it possible to have a portal within a portal? Alternately, how to I display only the values related to items in a portal row?
-
- 3 replies
- 771 views
-
-
A mini database for personal use with keyboard shortcuts The logic: The Field "Action" is Common For PC & Mac Then I have A field Shortcut for PC and A field Shortcut for mac. I just want to see the shortcuts in 2 portals (MAC -PC) filtered by the Keyboard Key and Then if this is possible filtered by application I try but I can't.... Download the File To see what I mean.... Can any anyone help..??? Keyboards_Copy.fp7.zip
-
- 1 reply
- 740 views
-
-
Is it possible to make a relation into a table with a literal value. I can do it by putting that literal value into a global field and matching on that field, but direct from a literal would be tidier. I want to put different product options into value lists, from the same table but selected by an entry_type (option) field value. I could do this with a table per option type, but then loading the data would be a nightmare. David
-
- 5 replies
- 838 views
-
-
I am in the midst of designing a specialized database of sorts ... One that will allow me to enter items and immediatly sort a list view placing that item or closest match (alphabetically) in the center of the list view. Then I can, if I want- select that record and have the data populate the form view that is on the screen at the same time and make changes to it or make it a new record. ------------------ (Form View ) [item Name ] [item Location ] [item Category] [item Description] [NEW Record] [CLEAR Entries] [sAVE Record] (List View) Item Name | Item Description | Item Location | Item Category Item Name | Item Description | Item L…
-
- 4 replies
- 937 views
-
-
Greetings! We have a subcontract form that we use at the office. The info is entered in an entry screen, then when Print Subcontract is selected, it prints out the contract. This form is 8 pages in length, with it being huge text boxes with fields inserted where they need to be. Is there a cleaner,(different) way to do this that you all have an opinion on? We are migrating everything over to 8, and I got to this file. Thanks. Donnie
-
- 1 reply
- 949 views
-
-
How can I use the mouse wheel to scrooll down the pages on Browse Mode???
-
- 1 reply
- 740 views
-
-
Hi all, I'm using the "Invisible Layout Objects" technique to hide some of my objects. It basaically use a portal and hides the objects based on a relationship. My issue is that this technique is not working in Find mode. It displays all the objects that are suppose to be hidden. I'm wondering if someone has found a a fix or work-around for this issue I'm having. I believe I have a work-around but it would probably take much work Thanks!
-
- 4 replies
- 907 views
-
-
Hello Again I Don´t know if it´s possible but... Can I make (if Yes, How?), the serial numbers return to " 0 ", in the beginning of every Year? (automatically, obviously) ex: 05-00001 05-00002 (...) 05-00789 05-00790 Happy New Year 06-00001 06-00002 06-00003 ..... Thanks....and sorry for another rookie question.... :
-
- 3 replies
- 811 views
-
-
I've been messing about for the first time with the new Custom Menus. A great idea, but there's a few snags. The fundamental problem is the same as what we've been facing for years. That is the blanket nature of the menu access in a privilege set. Taking a basic idea of a custom menu: change the single New Record menu command into separate table-specific commands; "New Contact", "New Company", etc.. I attached these to scripts. If I set the user's menu privileges to "Editing only", then (of course) they could not use the "new" record commands that I'd created; because they weren't Edit commands. I found a work-around, but it's kind of weird. Almost all the Edit…
-
- 2 replies
- 1.5k views
-
-
OK, Panic over... I discovered that for some reason, while Fm accepted my wonky TO name yesterday, today it does not. I tried omitting all of my non-alphanumeric characters from the name and the merge fields worked again. I narrowed it down to a colon in the name...just a single colon, not a double colon, and I am NOT having this problem with other T/O's that STILL have the colon in the name. I'm going to pull them all out just to be sure. PHEW! ...and NO, FM gave no warning that I could find of this issue. As far as FM is concerned, the single colon is just fine. In fact, it's still fine just as long as you don't use merge fields as far as I can tell.
-
- 0 replies
- 612 views
-
-
Whilst browsing the forum I came across a posting from Paolo entitled "Storing interface graphics into globals", which caught my eye. Post#148593 I've only recently started adding graphics to layouts via container fields, as a result of which it's been a new experience to discover globals dropping their values when a file is cloned, and finding a cure has been on my list of things to do ever since. Which is why Paolo's comment "When the file is loaded, the startup script takes care of loading all the graphic elements from a graphic-elements-table into the globals." How do I set about doing this myself? To my mind, graphics get stored in container fields and …
-
- 5 replies
- 1.6k views
-
-
Hi, please forgive if the answer is obvious as I am new to Filemaker. I have two tables - Invoice and InvoiceItems. The invoice items are displayed in the Invoice using a portal. When I use the 'sum' function to give an invoice total, a blank is returned. What's up?
-
- 5 replies
- 1.1k views
-
-
I have a relationship/portal question. I am currently using three primary keys: Contact ID, Company ID, and Request ID. A Company can have many Contacts. A Contact can only belong to one Company. A Request can have one Company, and multiple Contacts. The catch here is that because Contacts switch Companies so much, the Request can have one Company, and Contacts from different Companies. On individual Company pages, I created a portal using â��EstRequestsâ�� as the basisâ��it gives me a list of Requests (Requests ID) that a Company is associated with. HOWEVER, when I try the same thing on an individual Contact page, it does not work! The only Re…
-
- 2 replies
- 694 views
-
-
what is the easy way to get rid of the seconds in a timestamp field? Do I have to use a text field and calculate it?
-
- 7 replies
- 2k views
-
-
Is there a way to slid a portal in preview mode? I have a portal 20 lines long, I have made a report that utlizes the portal, but some records do not need so many lines for the portal, so I am left with a very big white space on my reports. Is there a way to slide a portal up when the other feilds are being used? Thank you, Joseph
-
- 12 replies
- 1.7k views
-
-
I am running 5.5. Is there a way to check for a particular value in a field. I am making a file which will be used for making Work Orders. I need to make it "User Friendly" because of the denseness of some of the users. Therefore, I am making a layout for each field that is required. I have a field called "Art Status" which has the options, "New," "Repeat," and "Change." I would like the button which sends the user to the next screen, send them to the "Art Due Date" field, only for two of the three possibilities. If the "Art Status" is "Repeat", they should be sent past the "Art Due Date" to "Job Description." I have only been able to figure out "isEmpty()"…
-
- 2 replies
- 772 views
-
-
For some odd reason, I cannot see data when in Table or List View in one of my Tables. It can only be seen in Form view. Any ideas? You can see the scroll bar and see some activity is going on, but just can't see the data. I've adjusted the font size and still nothing is there...very weird. It is a large Table, All my others tables are a bit smaller and show up fine.
-
- 1 reply
- 621 views
-
-
Hi, One of the least professional looking behaviors of filemaker, in my opinion, is the way that when you enter one field on a layout, dotted borders appear around all the editable fields on the layout. Any way to turn this off? Thanks, Andrew
-
- 2 replies
- 868 views
-
-
How can I produce a report in this sort of format where I have subsummaries for Contest, Year and Candidate: Contest 1 ......Year 1......Candidate 1 ......................Candidate 2 ......................Candidate 3 ......Year 2......Candidate 1 ......................Candidate 2 Contest 2 Etc. In other words, I'd like for the first candidate to appear on the same line as the year instead of beginning on a new line as is typical. It's also possible that I'd eventually want the first unique occurrence of each contest, year and candidate to appear on one same line as well instead of breaking to separate lines. Thanks! James McAlis…
-
- 6 replies
- 1.1k views
-
-
I want to set a button up in my database that allows end users to return to the previous layout. For example, they may be viewing some information they have just searched for but want to quickly view another layout. I need to place a button on the second layout so that they can return (back button) to the previous layout. Much like the back button on a web page. This is different from pressing a button to go to a layout, it needs to 'memorise' where they were before and take them back. Any help greatly appreciated! Many thanks
-
- 11 replies
- 1.9k views
-
-
I'd like to be able to print my newspaper articles in a two-column format. I know that there is a built-in provision for printing in two columns with the text flowing from column 1 to column 2, but I need for the columns to be "balanced." That is, I want the text in both columns to be approximately the same length. I have simplistically attempted to do this with two calculated fields (one to extract the left-hand text and the other the right-hand text) that break BodyText, the field containing the article text, into two equal parts based on word count. But the breaks need to be at the end of a sentence and not just where the word counts are equal. Plus, differing len…
-
- 7 replies
- 1k views
-
-
I have not been in the forums for a while now... sorry all. So I have a lot of catching up to do. I did not find this in a quick search, so if it has already been answered maybe I can be pointed in the right direction I have a value list which displays 2 fields side by side. I want to be able to put field A with a spacing between field B... giving the appearance of a tabbed 2nd field so everything aligns nicely. Currently the 2nd field is butted up against the 1st field with only a single space between it giving a very ragged look to the value lists. Microsoft Access gives the ability to display a 2nd field by a given width. Why can we not do that …
-
- 1 reply
- 730 views
-
-
I apologize for posting this problem which I realize has been posted many times before, however I am stumped as to why this does not work. On the table called "WO_Entry" I want to be able to select a brand from a pop-up menu. After selecting this brand, I want to be able to select a specific item from another pop-up menu, only displaying the items which relate to that brand. I have created the self-join relationship for the "Brand" field in the "Item_Entry" table. I have connected the "WO_Entry" table to the "Item_Entry" table using the LineID field as the match key. My value list is based on the "LineID" field in "Item_Entry" and only shows related v…
-
- 1 reply
- 842 views
-
-
I have a database of delivery tickets and a related database of customers. Every ticket shows delivery date, bldg delivered to, customer and number of widgets. If the above format is possible to generate, how do I go about setting that up? I am new to FM and appreciate any help!
-
- 3 replies
- 905 views
-
-
I use my database program to write checks. My current program converts the numeric field that holds"100.00", but when it prints the check it converts to "One Hundred Dollars and no/100". Any ideas? Can Filemaker do this?
-
- 3 replies
- 1.7k views
-
-
I have a runtime file using two values lists. Depending on which category value is chosen on one list then the other list displays a list of values available for that category. This works fine except I now notice in FM Advanced that the value list appears to drag, usually displaying what looks to be multiple copies of the 2nd value. Of course chosing it makes the copies disappear. I think this must be a screen refresh problem that has just crept into the new version. It certainly never happened in Developer 7. Any ideas how to fix this?
-
- 0 replies
- 863 views
-
-
What I'm wanting to do is have some kind of windows management(FM windows, not the OS). I'm building a solution that takes advantage of the multiple windows feature that started with FM7. I'm wanting to do things like - remember last size/position for each window for each user, run script upon window exit, resize window based on screen resolution/zoom, position a new window based off an existing window's position etc... While not really "necessary" to have these features, this solution is a 'shrink wrap', so users would certainly like it. I know that this can be done, but I can save myself a lot of time if someone else has already come up with these ideas an…
-
- 0 replies
- 738 views
-
-
In my solution, I have an In-Out Board where staff names are listed. There about 5 fields on it. These names are from the Staff table and are viewed through a portal on a layout based on a Home table. This home table is basically information about the company and has one record. The problem I'm running into is that only one person can edit one of the staff records at a time, since it is a one to many relationship (Home to Staff). All others are locked out until the user either clicks out of the portal or goes to another screen. Is there a way to allow multiple users to edit different staff records in the portal at the same time? -- Thanks
-
- 2 replies
- 718 views
-
-
I'm building a contact database from scratch that will allow me to enter as many address as I want for a particular contact by storing them in a separate table and using a one-to-many relationship between Contacts and Addressess. Entry and viewing of addresses are with a portal on the Contacts layout. Here's the problem. I have two requirements for how this should work. If only 1 address is entered, I want this to automatically be set as the 'Primary Address' (without the user having to do anything besides enter the address). However, if there is more than 1 address for a particular contact, I want to be able to choose an address to 'set as primary.' I can …
-
- 4 replies
- 1.2k views
-
-
I have a table of Students records related a table of their Grades. There is a one Student record to many Grades records relationship (e.g. a record in the Grades table for each subject a Student studies). Each Grade has a field for "year". I have a layout based on my Students table which displays related grades for that student in a portal. However, when I select the Grade year to be the current year in my find request (set in the portal showing the Grades), it displays all the Grades records relating to that student, including those from previous years. Q: How can I filter my portal to display only the student's grades from the current academic year? Than…
-
- 5 replies
- 1k views
-
-
Does anyone know what the calculation would be to change the color of a button when a field in another layout is populated? Thanks
-
- 12 replies
- 1.1k views
-
-
Thoughth this would easy but I can't seem to get it to work... I want to store the data a 0s 1s and display as No or Yes. Works great for data in place but I would like a Radio button that allows the user to use Yes No but place the number. I thought about using the "Show values from second Field" but then I'd need a table for that.... or is the solution staring at me ferociously? Any ideas? Thanks!
-
- 7 replies
- 3.8k views
-
-
I'm putting together a db to create contracts in selling air-time (broadcasting). Each contract includes the air-time purchase (called "Flight"), the fee for the purchase, and calculations having to do with the breakdown of where the material is to be broadcast. I need a way to be able to list an identifier for each flight, and have relevant info (air-dates, number of broadcast sites, etc) about that flight be pulled from a related table. I also need to be able to reference the air-dates that are pulled to include in an invoicing portion of the contract. I have been able to accomplish this to a certain extent using repeating fields, but was running into prob…
-
- 4 replies
- 743 views
-
-
using fm7 Pretend I have not been using since v1.0 I have an xl file set up as follows: style model xprice xaprice sprice saprice Arthur dining 75 100 na na Arthur pub na na 25 40 Arthur whatever na 30 na 39 Trevor dining 99 115 na 100 blah blah blah What I want to do is have an order entry database where when I select "style" it will give me the list of styles (easy) What I can't figure out is how to have a value list based on the model I just selected...i.e. to give me only "dining, pub, whatever" for "Arthur". Then I want to have a value list based on the 4 price co…
-
- 2 replies
- 820 views
-
-
Hi all. I'm sort of new to FileMaker. I'm trying to at a second level of "find" to a portal window based upon a pop up list or a another portal list. I have a relationship where ClientID shows me related records for all Order Numbers for that ClientID. But I want a way to choose an Order Number by clicking and the details of that Order Number show up in a portal of related records. I guess this is sort of like being able to look at the details of a client's invoices by choosing the invoice number. I've taken a screenshot to help explain this. http://www.studyusamagazine.com/downloads/Files/FM_Screenshot.gif I've been scratchig my head on t…
-
- 2 replies
- 696 views
-
-
How do you change the colors that the patterns use. For instance I filled the body with a blue color, then I chose a pattern. The default is to use white as the alternative color to make the pattern, how do I for instance choose Gray. Is this even possible?
-
- 1 reply
- 679 views
-
-
Anybody out there to help me with this? I'm trying to loop through a portal copying a field to a different database (not related). My problem is that Filemaker never makes it to the next row. It keeps copying and pasting the first row. This is the script: *********************************** Go to Portal Row[First] Loop Copy[select; pr::field] # paste contents via sub-script in external db: Perform Script[sub-Scripts;External: "db.fp5"] Go To Portal Row[Next; Exit After Last] End Loop *********************************** It seems the loop doesn't work because of the Copy command. Any thoughts on this anyone?
-
- 5 replies
- 2.8k views
-
-
this is all being done in fm 8 advanced, despite what the profile says. i have a file with a conditional value list. it is working fine, however, i have set the layout to auto save and still when i exit the field that the condition is based on which is the client field, the matter field will not show the correct matters until i click out of all the fields, sometimes it takes several clicks outside the field. the way the condition works is this: there is a calculation field that automatically names a record based on the type of client entered. if it equals that in a matter database, then those corresponding matters show up in a matter field on the main table. th…
-
- 2 replies
- 926 views
-
-
I am having difficulty getting a portal to allow me to create records, and also edit values. I have a people table, and I'm trying to associate children with their parents in a second table called people_parents. I created a second occurrence of people, and made my relationships from people to people_parents to people_for_parents. I then have a portal in a layout connected to people where I want someone to be able to create the parent record. I am able to make this work by pointing the portal at people_for_parents, and FileMaker automatically creates the join record in people_parents. The problem is that I have a couple fields from people_parents that also need …
-
- 2 replies
- 875 views
-
-
I am using the FM7 demo for Mac OS X and I've been trying to make a db with greek characters in the fields, values etc. Everything seems to be working fine for text input with the unicode greek keyboard and unicode fonts (eg Lucida Grande) except from the pop-up menus that take their values from a value list written in greek. When pressing the pop-up menu the values list displays only questionmarks " :?: ". Strangely the problem is only with pop-up menus and not with pop-up lists that show the value list perfectly. It seems like the pop-up menus cannnot display unicode fonts but only 8bits ones as was the case with previous versions of FM. Has anyone had any similar …
-
- 3 replies
- 815 views
-
-
Within a particular layout, I want to show only portal records that have anything in a given field - I have a many-to-many database: People [table 1] Organizations [table 2] Affiliations [table 3, links tables 1&2]. What I want is to show in a Portal within People only records in Affiliations that that have a value in a field within Affiliations called "special role". Doesn't matter what value is in role, just don't want it to be empty. I read http://fmforums.com/forum/showtopic.php?tid/170110/post/176995/ but this seems a little different... ideas??
-
- 1 reply
- 727 views
-
-
For repeating a field... i know that if you use the Last(field) it will repeat something. But is there a function that will clear a field if nothing is in it? So say on one layout you don't enter something and on another layout that keeps a history of that field, that it doesn't even show up on the layout because it is empty...? There has to be a simple way.
-
- 15 replies
- 1.5k views
-
-
I am back for my second posting on FMForums--the last one went so well I can't stay away. I have two tables that track data of inventory used on a job. I am using two tables because the two projects bill very differently, and I want to add dif projects in the future. I use the same value list for descriptions of all inventory. Both tables have a relationship back to the same customer. I also have a purchase orders table that adds inventory quantities. I am using subsummaries in a layout to show the inventory totals being used for each table. But I can't get the two tables or layout information together. I want to take the combined information and to compar…
-
- 3 replies
- 892 views
-
-
Im confused on layouts with summary sections. Lets say I have a database with company and contacts tables. They are related through a companyid match key. So when I print a summary report where the layout is for the customer table, summary subsection shows company::CompanyName, the field in the subsummary is company::CompanyName as well, and in the body I have the related fields for contact::First contact::Last. I tried reversing it as well where the layout was showing records from contacts and that did not work too. Does anyone have an example? I have lots of reports I need to do and the data is alsmost all related like this. I dont know much about how subsumma…
-
- 7 replies
- 866 views
-
-
Is this possible? I have a database of books and articles. I want to take multiple, separate notes for each, so I have created and set up a related DB (Notes SB). I can add notes in the main DB, and I can open a note from the main DB and show the full related record in the Notes DB. The portal in the Main DB layout shows only the first line of each Note, in a list form. But i would like to do the following: while in the main DB with the portal showing, use a script (command-1) to pop up the NOTES DB window, with a new record created. I know I can do this manually (go to last portal record, type something, choose open related record) but that gets rather tedious…
-
- 1 reply
- 713 views
-
-
Forgive me for not knowing the exact name of the part of filemaker on the left side of the form that shows the modes and record numbers, but is there anyway I can make a layout that does not show this? I'm making a reports menu which will basically be a 400 X 400 pixel window with a list of reports. It will open on top of the main form. It's soul purpose is to select a report, so there will be no records in it, thus no need to display record numbers or browse, preview and form views. Thanks in advance. Hopefully this makes sense.
-
- 3 replies
- 795 views
-
-
I have a rellationship to show a field in a value list from only some of all records in a table. If I tell the valuelist to show all values (7400) it goes fast, if I show the values from a limited rellationship then it goes dead slow, slow like we can go and take a coffe break wile we wait, and thats is just 3800 values! How can I make this faster?? Plz need help!! Regards Jocke
-
- 4 replies
- 804 views
-
-
Hello all, I have two fields in a portal (month & year)that are defined as a pop up list. The pop up list is defined with value lists, month(jan,feb,march,etc)and year (2005,2006,2007 etc). During data entry when you select the year filemaker puts this year in all of the portal rows below, but when you select the month from the list it only adds the value to that field. I need the month to do the same thing, but I can't figure out how the year is able to do this when both fields are configured exactly the same. If I can get the Month field to do the same thing I can save so much time and clicking during data entry. Any ideas??? Thanks! Example: Month …
-
- 9 replies
- 1k views
-
-
I have a portal (working perfectly thanks to mr_vodka) which filters and displays records based on their status (active, completed, canceled)-using global data. Can I define it through an additional value list "class" being (maintainence, electrical, plumbing, painting or all) The majority of the time it would be set to a default of 'all' but occasionally my boss would like to see if any one area is lagging. As you can see I tried to just duplicate g.activestatkay2 with g.activestatkey3 but ran into the problem of the portal only being able to be referenced to one table at a time? Thanks for your help
-
- 7 replies
- 909 views
-
-
Hello, I'm not referring to the options in the Sort Records dialog box. Hopefully, a simple example will illustrate. Suppose I have a table called colorTable, with one field called colorField, and suppose I have the following three records in it: red green blue If I define a value list called "Favorite Colors" and base it on the values from colorField, whenever I choose to display this value list (perhaps as checkboxes), Filemaker will automatically sort the colors alphabetically, so I'll have: blue green red How can I override this default sort order without having to enter custom values in the Define Value Lists dialog box? I'm going to h…
-
- 0 replies
- 1.2k views
-
-
How can the Tabs feature not be scriptable? How can I not use a calculation to name my tabs? Will there ever be a stock Get(TotalPageCount) function? Don't get me wrong, Filemaker 8 Advanced is great - but some of the simpler things seem to have been overlooked. A questionable Tab trick of using a Go To Field works, but at what cost? Oh well...
-
- 0 replies
- 1.3k views
-
-
Greetings, I would like to be able to have my value list sort by the most popular items. I have a solution for my photography studio, and as we make new orders for clients, it is a pain to sift through all of the products for every single line item. I do currently have it set up so that within the product area, I can see within each individual product which invoices have had that particular item on it. I am wondering if there is someway to 'count' these occasions. So basically any given product would have a number cooresponding to it that is based on total sales. And then to somehow have my value list 'sort' based on this number?
-
- 1 reply
- 747 views
-
-
Hello I create a columnar list with a portal in it. The portal I made in FMP7 shows also the empty rows. Is there a code to show portals something like this: <> Or a code like CMDL: [FMP-Portal: InvoiceID] [FMP-Field: InvoiceID::Product Name] [/FMP-Portal] which shows only the related rows.and not empty rows which I specify in the portal setup? Greetings, Jukkie
-
- 2 replies
- 707 views
-
-
I am trying to create a script that overlays a checked item in a field called Gap (Yes/No) if true then it checks another field called GapFee which contains a check box of 40% or 50%. If 40% then it goes to a calculated field that is based on a distance travelled. It would take the distance traveled (i.e. 20 miles and then plug it into the calculation (DistanceActual - 15) / 5) * 2 + 5). This formula is either multiplied by 40%. The result of this calculation is the fee a customer pays, which is displayed in another field FeeActual. If the GapFee was checked as 50% then it would loop back to the formula and multiply it by 50% :
-
- 6 replies
- 1.1k views
-
-
Here's a brain teaser that kept me awake all night yesterday: In my example, I have a simple order system, where you select your items by selecting the item number from a pulldown menu. Most items are for any customer, but some can be made expecially for one customer and are NOT availlable for other customers than the one it was made for. The pulldown menu now shows all the items in the items table. But... I do NOT want to show the items that have a customer-restriction in that list. But I DO want to show the items that are resticted to the current customer. AAAAAAAAAAAAAHHHHHHHHRGGGGGG I cannot figure it out! Any suggestions? Reg. Herri…
-
- 4 replies
- 972 views
-
-
My solution is designed for Windows. I was assured we would not be using Macs on it. Of course, I didn't totally believe it but it made my job simpler. We use script-fired popup menus which works wonderfully. We now have a new Sales Rep working remotely. He will be signing in to GoToMyPC and opening a licensed copy on a system only he will use. He will be clicking the 'Opener' FM file on the desktop. Two questions please: 1) Is there a problem opening FileMaker this way? I realize it will be a bit slower but this is just a temporary thing until we get him set up. 2) He uses a Mac. How will my popup menus fire for him? As if he's a Mac (thus bre…
-
- 7 replies
- 986 views
-
-
I have developed a runtime solution. Everytime I make a change, I do this: bring it to the client, install it, import all records from previous version. Now the problem...anything that was added to value lists is lost. Is there a way to bring these value lists over along with the new added records? Thanks!
-
- 4 replies
- 842 views
-
-
Hi everyone. i'm searching for a possibility to override the field menu (Right-click on text field Font,Size..Sort Ascending/Descending/Find Matching ...) I need to remove some items and rename/change others. I changed the Copy/Paste/Cut Item's names and it changed also in the filed menu. How can I do that ??
-
- 3 replies
- 1.7k views
-
-
I have people and organizations, and I need to be able to pull up a person and find out what orgs they're with and pull up the orgs to find out what people are members. Here's the problem: I want to be able to directly add organizational affiliations to individuals, by name, from organizations previously listed in the DB -- via a value list containing organizations. Also vicea versa, adding directories of individual members to records of organizations -- via a value list containing all records of organizations. I can get this working, but the value list won't show each name as a unique records. So if I have 2 "kevin Sloans" in the people DB, they are t…
-
- 1 reply
- 670 views
-
-
When I first started playing with Custom Menus, I found that Filemaker added an 'Exit Ctrl-Q' to the first menu and added 'Tools' to the end of the menu line (which couldn't be removed). I had been using Dacons Menu Control for the last 3 years, but its latest version won't run under v8, and Dacons can't give me a time frame for a version that will. New Millenium's version also won't run under 8. So I went back to playing, and here is what I've come up with: If you create a runtime (which I normally do) and remove Admin Privileges, the 'Tools' Menu disappears. I created the first menu with a single blank as a title that winds up creating a menu without text wh…
-
- 7 replies
- 2.6k views
-
-
I'm running into a problem in a certain portal in my solution: When I try to create a new record by entering data, the record will not commit merely by leaving a field. Say, I have portal fields f1, f2 and f3: I click on f1, and enter "foo". I click on f2, and "foo" vanishes! I continue typing "bar" into f2. I click on f3, or click out, or do anything to commit, and suddenly I have 3 portal rows! One with "foo" in f1, one with "bar" in f2, and the usual blank one at the end. I have compared this portal to other portals on the same layout that are also designed for record creation, and I cannot find any differences, yet the others all work as they ar…
-
- 6 replies
- 1.3k views
-
-
I want to represent information using charts and bar diagrams which I have never done in past. Please let me know where I can find any help on how I can create or use them and then I will modify according to my requirements. I need it for version 5.0. I may not be able to use any plugin. Although I was amazed looking at the charts using ChartMaker. Thanks for your help.
-
- 2 replies
- 995 views
-
-
I have to do this for my boss,but have no idea where to start. I need to build a packing list, and here is what i want to do. If we are sending 100 shirts, but can only fix 60 in every carton. how can i make it so that all i have to put is the Qty per carton, and the Qty that im shipping and the item number and have the program do the math. I want to able to see box 1 with 60 shirts for item number ASM001, and have box 2 with 40 shirts for item number ASM001. ANy Ideas.
-
- 1 reply
- 706 views
-
-
My apologies for such a low-intelligence question! We are developing a ticket-issue solution for our 'tourism attraction' and need to enter numerical data in a number of fields using an on-screen numeric keypad (which will be used in a touch-screen application). We would be most grateful if somone could point us towards a simple solution for such a keypad that can link its output to several fields.
-
- 0 replies
- 706 views
-
-
Hello happy FM hackers I have a little problem which that I have an address book that is in part culled from the net. When I copy & paste the info into the text field it keeps the web formatting. Does anyone know of a script or how I can make the text field formatting conform to the layout parameters that I initially designed?
-
- 12 replies
- 1.2k views
-
-
Hi All, Blink Blink, I guess I havent stopped by for a while, love the new digs! So, a new client of mine is requesting that they be able to print out invoices with 1-5 optional attachments. These would be, a personalized letter, a standard sales policy form, a rental agreement, a credit card form, etc.. basically, all of them generic templates (except the letter which could be one of any number of letters associated with the specific invoice). I am wondering if any folks out there had suggestions on how to do this in a single print request (because they also would want to fax the same info) without coming up with a dozen or so different print layouts. I am …
-
- 1 reply
- 736 views
-
-
I would like to be able to have a drop-menu that when you select one of the values from a list it will automatically run a script as soon as the selection is made without having to perform any other additional action such as clicking on a button or choosing a script from the script menu. For example, I have a database of furniture which includes categories of chairs, tables, beds, mirrors, sofa's, etc. I want to set up a field as a drop-menu of the above listed furniture categories and perform a find on the selection. So if I pull down mirrors in the drop-menu I want the database to find and show just those items that are mirrors. And I want the find to happen the…
-
- 1 reply
- 1.2k views
-
-
HELP!!! Whats up everyone. I'm trying to set up a file here. I have two layouts. One is a log to log material into, the other is a history of the logs for different vendors. Anways, I can't seem to figure out how to get certain fields to show up on my history log only if they have text in them. If nothing is entered, I don't want them showing up. How do I do this? Basically I've got a rejection form on the Log for each shipment that is only filled out when we find rejected material. I don't want the form on the history layout if there was no need for it to be filled out. Please help ASAP!! I'm hoping is not complicated where I have to enter in a bunch of …
-
- 5 replies
- 699 views
-
-
What do you do if you have a field that is empty and you don't want it to show up if it is empty. ? don't want the calic field to show up? The formula doesn't have a Clear(text), or Delete(text) Trim(Jeff) & " " & If ( IsEmpty (Jeff), ) , result two )
-
- 1 reply
- 673 views
-
-
I use a print-layout with a lot of fields (container with most of the time word-content) and I use the sliding possibility as "sliding up based on all above" + "also reduce the enclosing part". However, if this sliding happens, fields that are big are divided by the page break. I don't want this, because many times I have tables in some fields or pictures and breaking it in two over two pages doesn't look nice for a print-out. How can I use the sliding function without having the page break problem?
-
- 1 reply
- 708 views
-
-
This is another classic School Database setup - Tables: [color:blue]STUDENTS, ENROLLMENTS, CLASSES. From the STUDENTS table, I've created a portal which contains student enrollment data. [color:red]Issue: I've been sucessful in setting up and displaying data from this relationship, however I also need the capability to [color:red]MODIFY records for that student contained in the portal. [color:red]For example: from the STUDENTS table the user [registrar] should be able to [color:blue]ADD a new class to the students record. Currently, I can only [color:red]view those classes (via the PORTAL) which had been created in the ENROLLMENTS table. Any modification mu…
-
- 2 replies
- 964 views
-
-
Hello, I would like to know whether this is possible. My "client" wishes to have three fields: General Industry Sub Industry Job Title General Industry with be a value list with say 5 values (i.e. Music, Film, TV etc). Now, each value will have a sub industry value list (i.e. Music = Recording Studio, Mastering, Promotion, etc.) Each Sub Industry has a corresponding value list (ie. Recording Studio = Runner, Assistant Engineer, Engineer). He would like it so that when you choose the initial General Industry value, the value list for the Sub Industry field changes accordingly to match the General Industry value. So, if Music was c…
-
- 13 replies
- 1.1k views
-
-
why is fm doing this to my valuelists.....i never thought something so small could make me so mad..why is it cutting off my values cutt off vlist
-
- 7 replies
- 994 views
-
-
I'm new here. I've searched the forums and FM Pro 6 documentation for this answer, but I haven't hit on the answer, yet. We have a database with about 1000 records. We need to generate a report where some of the fields of select records need to appear bold and italic. The rest of the records need to keep the regular format. The records requiring this format change as the project moves forward. It's quite a few records and comes up often enough that we would like an automated solution. How can I bold, italicize the fields of these records? I can do a find to show the records I want to change, but I couldn't find an answer on how to add the formatting. …
-
- 2 replies
- 813 views
-
-
Hello, Many thanks to everyone who has tried to help me in past posts. As it stands, i've got a database which is going to be a membership database. I have a layout called 'Factory' which allows me to add/edit/delete factories on the database. Fields include Factory Number/Name, Address, etc... I need one field - the Factory number/name to appear on another layout in a dropdown list. As factories are added/deleted - i want the dropdown list to change to suit. I have created a Membership table (all the details to suit a member) and a Factory table. I can add and delete factories, but when i go to amend the member data - eg: change factory…
-
- 15 replies
- 1.3k views
-
-
I have created a database in FM8 to design a worship service for a church. I have 2 tables, 1 is the Service table and 2 is the songs table. I want to be able to view a list of songs sung in the past by 3 groupings. 1. Songs sung the least 2. Songs sung regularly 3. Songs sung the most By choosing a group such as the “least sung”, I want it to display the songs in the portal. My question is, how can I get the portal to display each song only once, rather than multiple times, even though the song has been sung more than once. Thanks for your help!
-
- 2 replies
- 723 views
-
-
Is there a way to create multiple rows in the tab pannel?
-
- 4 replies
- 1.8k views
-
-
Hi, Just got my copy of FMP 8 Advanced today, and I'm messing with custom menus and tooltips... Here is the tooltip calculation I'm using to show what the shortcut would be for a specific button Case(Get ( SystemPlatform )="-1";"Print Sample Label (Cmd+option+P)"; Get ( SystemPlatform )="-2";"Print Sample Label (Ctrl+Alt+P)"; ) Does anyone know how to display the characters for Cmd and Option keyboard modifiers as they display on macintosh menus? I can't seem to find those characters to type them into the calc dialog. Thanks in advance, Dana
-
- 2 replies
- 3.6k views
-
-
Hi, I need some help understanding horizontal portals. I downloaded the sample file that was so graciously provided by HOnza from 24U Software Company: ************************************** http://fmforums.com/forum/showtopic.php?tid/170001/ ************************************** The problem I am having is I am not experienced enough to understand how to make it work. HOnza said that it employed the new function GetNthRecord and involved creating a single repeating calculation field for every field that is supposed to appear in the portal. I'm hoping that someone can look at his example and show me how to do this with just one field at a ti…
-
- 3 replies
- 1.1k views
-
-
This is strange... It only happens when I am using the FileMaker 7 server version, connected to a remote host--not locally. When I click on a field that is set to display a pop-up menu with values from a value list, it works fine when all records are displayed, but if I perform a Find to limit the number of found records and do the same, it turns the cursor into an hour glass and I have to delete the FileMaker process. This happens on more than one pop-up with other value lists, so I don't think it's a problem with the lists. Ever heard of this before?
-
- 0 replies
- 736 views
-
-
Yesterday, I started experimenting with custom menus. I created a menu that I wanted everyone but me to use and set it as the default menu for the file. I then set the open script to set the [standard filemaker menus] as the menu set if anyone with full access logs in. That works just fine, and I get the regular menus. The problem is that as soon as I navigate or run a scipt, the menu set reverts to the default menu set. Is this a bug or am I doing something wrong?
-
- 6 replies
- 2.1k views
-
-
Any idea how I can convert a image in a container field to binary data for use in a text field? Also a way to lookup the image compressor type would be interesting.
-
- 0 replies
- 717 views
-
-
I'm pleased the FileMaker Pro 8 demo allows me to play with the new Tab Control. I'm less pleased with the simplistic visual appearance of the tab panels -- style-less/bland tabs, tab width controlled by label width, no space between tabs, permanent black shadows, ... I've been experimenting with overlaying the FM 8 tabs with graphic elements copied from an existing FM 7 layout. It appears I'll be able to mimic the visual appearance of my current FM 7 layouts as follows: 1. Create a Tab control with several tabs. 2. For each Tab panel, overlay all tabs with graphic tabs of my own design. 3. Carefully size the FM 8 tabs to correspond to the overlaid …
-
- 4 replies
- 1.9k views
-
-
Hello, could someone help me with a solution for this. I have a portal which shows various Films a client has purchased, the relation is based on the word "sold" in an "Actions" field so I have an "if" function to filter this, which works fine. Now for various reasons a Film may have the word "Sold" in the "Actions" Field more than once, so I end up having the same Film in the portal more than once. My question is how can I "filter" this, so that the Film in the portal only appears once. Thanks in advance Ian
-
- 8 replies
- 917 views
-
-
Hello folks, I have two Tables, Orders and Products. On the Orders Layout, there is a Portal going to Products, related by an OrderID key. I need to create a calculation field in the Orders table that stores the price of the Most recently added product in the list. I also need a calculation field that stores the first products price. What's the best way to do this? Thanks a lot! Andrew
-
- 4 replies
- 861 views
-
Recently Browsing 0
- No registered users viewing this page.