FileMaker Interface Features
-
I am having some problem with flashing... FMP blanking parts of my layout and redrawing them (rather than just redrawing over the existing such that you don't notice it). For example, as I step from record to record in my list layout, the majority of my layout does not get redrawn... it looks nice and stable. In contrast, my tab bar flashes... it gets blanked and then redrawn each time. In my List layout, the body and the column titles are stable... except the sort buttons in the column headers flash (along with the tab bar). Q: Anyone know what causes such flashing (blanking and redrawing)? Note that this is NOT a problem of scrolling fast, as anot…
-
- 4 replies
- 1.6k views
-
-
I need to print the items in a portal to a pre-printed form. The pre-printed form has 14 rows for information on each page and my portal can have any number of rows. Therefore, I need to find a way to print only 14 rows at a time from the portal. The information to be printed will be entered via a portal. And since each portal of information has a unique ID, could I sequentially number each item when entered and then have items with numbers 1-14 show initially to be printed? Or is there a better method? Thank You [email protected]
-
- 5 replies
- 976 views
-
-
Hi, I hope someone can point me in the right direction on this one. I have files A and B. File A contains a portal showing related records from file B. So far so good. What I want to achieve, is to select a portal row so that I can see all the fields of that related record in a second (single row) portal on the same layout. Hope this makes sense. Any help greatly appreciated. Thanks Boyd
-
- 3 replies
- 822 views
-
-
I have two fields First Name, Last Name. I defined a value list called Names and it will use values "Last Name" and "First Name" then I created a popup field that plainly displays the valuelist of those fields nicely, However, after selecting the name you are looking for and moving on the the next field the pop up value list field only displays the "Last Name"? at first I thought the layout of the field was to small to display the "Last Name" and "First Name" so I expanded it but it still only shows the "Last Name" any on how I can make that display both? KKalvin26
-
- 9 replies
- 1.1k views
-
-
Silly post, but irritating. The Text Formatting Toolbar seems to have disappeared. When selected in either Layout or Browse mode, the tick appears in the vie [color:"blue"] [color:"blue"] w menu, but no toolbar ! I've looked outside the print area, but nothing there.
-
- 3 replies
- 890 views
-
-
I've got a big database spanning over several files, those files has different fields. All this is linked together via a menu system. But, how do I do a search function that finds the criterias in more than one file? If it was so that every field was unique, this would have been no match, but now, I've got some fields that is unique, and some that isn't. I want this search function to both contain a "multisearch" that seeks for the inputted criteria in every single field in every file, and a "normal" search function that let's you input one criteria per field. The matches should be displayed in a list and then the right one to be choosed of the user. If I ne…
-
- 5 replies
- 906 views
-
-
Portals can only be used with related file(file with relationship)? Is this true
-
- 2 replies
- 835 views
-
-
I have a label layout in which I deleted the footer because I thought I didn't need one. Now it turns out I do need the footer. I have repeatedly gone to part setup and tried to create a footer, but for some reason it won't let me create one. I have also tried to drag the part icon on the the status bar onto my layout, and selected footer as the part I wanted, and that also is not working. Anybody have any thoughts?
-
- 4 replies
- 918 views
-
-
I have a DB that has, let's say, 10 records. I would like to create a portal in that same file that lists a particular field of each of those records within that file, so that I can have a clickable list. While viewing record 3, I can see the list,click and be taken to record 8, etc. I have tried creating a self relationship on a global file to no avail. Is this possible? Thanks
-
- 3 replies
- 752 views
-
-
Is it posible to change to a new layout when a person select a value in a value list ? I need to hide some field that they dont need to fill in if they dont select just a special field in they value list?
-
- 2 replies
- 775 views
-
-
I have a layout that has a sub-summary that is sorted by a field. The part appears before the records belonging to it does. I don't have 'allow part to break across page boundaries' checked. I interpret this to mean that if the part can't fit on the current page, FM starts a new page. Instead, the part is displayed across 2 pages. Is this a known bug, or am I misinterpreting what this function ('allow...') does? Steve
-
- 6 replies
- 954 views
-
-
Hi. I've been scouring this forums, and I'm getting that there are issues with value lists and calculated fields. Basically, here's what I need: I need a pull-down menu of customer names (calculated based on various text fields) on an invoice so that the user can select the item, and have it auto-fill in the address. Right now, I have the "left value" in the value list as the ID number, and the "right value" as the calculated name. So, the pull-down menu isn't showing all the records from the customers table. How can I get it to do this? I assume it's related to "indexing"? Alternatively: Is there any way I can just have it build a value l…
-
- 1 reply
- 742 views
-
-
I have a problem with portals (as you guessed) but for me it is easiest to learn by example. So since I can't find any portals in the templates from filemaker 6, can anyone tell me which template might have a portal or point me to a filmaker database with a portal in it? Thanks
-
- 2 replies
- 811 views
-
-
First, I have to say this board is a terrific resource; I got a long way on my problem just reading through prior posts. Many thanks to all. But, I got to one issue I couldn't seem to resolve. I'm creating a Value List from related records, using the formula I cobbled together from prior posts here to form a text result that concatenates the related values from the "History Items" database: Substitute( ValueListItems( Status( CurrentFileName), "History Items Value List" ) , "
-
- 6 replies
- 1.5k views
-
-
Hello everyone here's my dilema The db in question is basically a flat file setup The group only wants to add a particular feature. I'm not sure if it is possible. The end result is to be able to select a file from the portal and create a new record with most but not all of the fields automatically ! 1. When they do a search on the form view layout the request is this; to have a portal that will display the found set of records...(simple enough) 2.a couple of the fields required are pop up lists...(here I run into the problem that these 2 fields w/n the portal's list of records the data on them is that of the record being viewed and not the file(s) being shown i…
-
- 1 reply
- 803 views
-
-
Hi, I have set up a layout in a file called orders which has a portal on it, the file also has a relationship with a line items file. When I enter a id in the portal the other fields are filled in via a calculation, which is great. The problem I'am having is when I create a new order the data is still shown in the portal (line items). How can I clear this?? Thanks for you help, this forum is a lifesaver!
-
- 1 reply
- 658 views
-
-
Hello! I have a CDML-based form that displays a master record along with related portal records from a secondary table. Ideally, I would like to be able to edit both the master and portal records from the same form at once. When I submit the form for the master record, I get a 102 error (field name not found). When I remove the portal fields, this error goes away. This must mean that the 102 is generated because FM looks for those field names in the master table? Is there a way to edit the related records? If so, can anyone please lend assistance? Thanks! Kevin
-
- 3 replies
- 790 views
-
-
Hi, I would like to know how to enter a id in a field on a portal and then all related data shows up automatically in the portal ie; I enter "111 (ID)" and one hundred and eleven (Title) Numbers (Description) etc.. shows up in the portal line. I want to scan items via a barcode reader that would add them to an order. should this be done within a portal or not?? Thanks in advance
-
- 2 replies
- 863 views
-
-
hello i have 2 databases, one which has user,level,mid and another database (say db2) has only user.So i setup portal relation between those 2 db's using user. The field 'level' takes only 3 values say "1,2,3". i have three portals in db2.What i want is all which has level=1 should go to portal1 and level=2 goes to portal2 and so on. how to do that? Hope this makes sense bye geethanandh
-
- 1 reply
- 831 views
-
-
Is this possible??? To have the main file maximized on your screen and to have your related file(s), not minimized at the bottom and under your main one, but completely out of sight, working "in the background".?? I'm looking for a way to avoid users to edit records on an appendable related file. This is the actual situation: In the "Access privileges / Define Passwords" window I am establishing the following privileges ONLY: -- Browse records ALL -- Create records -- Print records -- Export records -- Available menu commands: NONE -- Disconnect from server.... This user needs to allow records to be created onto the file via main file scr…
-
- 3 replies
- 844 views
-
-
Hi Everyone, For some reason, I can never access the Toolbar display option in the View Menu. It's always ghosted out! Surely I'm missing something obvious here. Can anyone help me??
-
- 4 replies
- 1k views
-
-
I'm new to Filemaker. It's got great tools for creating a really elegant user graphical interface. But as soon as the user clicks into a field, all that's destroyed by these pesky dotted boxes around every field in the layout (apart from pop-up lists, strangely). So my question: is there an easy way to suppress all this?
-
- 5 replies
- 1.1k views
-
-
I have a layout with 2 different portals. In portal "A" I want to select specific row to show information in portal "B". I can get this to happen however the row in portal "A" that I select should remain hightlighted. Have seen post in the past covering this but am unable to locate. Any help would be appreciated...
-
- 1 reply
- 1k views
-
-
Hi every body... Maybe this question is so easy, but please I need your help. Ok, How can I create many fields in a portal from a payment field, with just a click? For example: In my DB I have a option to create the payments, in this layout I have a field (num_payment) in this field the user indicates the payments for a patient (i.e. 10), ok, how can I create the 10 records in the portal just with a click (I think this should be a script), but in this Portal I have a date field, how can I make the 10 records with a month of difference between them. I hope you can understand my english, pelase excuse my bad english. Thanks
-
- 3 replies
- 832 views
-
-
I was hoping someone could offer me a solution to a problem I've been having with a record keeping database I built for my 6th grade classroom. Our district uses a standards based grading system that Use "O S G N" instead of "A B C" for scores. I created a script attached to a button that allows me to sort based on a custom value list so that O is first, G is next, and so on. The problem I run into is when I try to sort the list after I've added "+" and "-" to those scores. Even when my value list looks like this... O+ O G+ G G- S+ S S- N N- it still does not sort properly. I have tried many different things, read many different books, and…
-
- 4 replies
- 824 views
-
-
A cryptic subject but I will try to explain the problem. I have two fields, say "x" and "xcode", where I have a value list connected to "x". When you choose a value in the value list the "xcode" is set to a numeric value for example "1" if you choose the first value. This is performed through the calculation LeftWords(x; 1) Now I want it to work both ways because when I import data from another file to the database it usually only contains the numeric code. Is it possible to do this and how? //Henrik
-
- 2 replies
- 831 views
-
-
Is it possible while in list view to have every other line an alternating color??? Please say yes...
-
- 2 replies
- 946 views
-
-
I have a portal with a pop-up list. Depending which selection is choosen in the pop-up list, I'd like to have a small graphic display in that portal row. I have a container with the graphics. Thank You.
-
- 5 replies
- 981 views
-
-
I am having a problem with my value list. It is conditional and works when entering a new item. My problem is that I have a different form for crating a find request, the same value list will not work on this file. Why not? I can see no reason. Has anyone any experience of this?
-
- 12 replies
- 1.7k views
-
-
Using FMP 5.5, on OSX and Windows. After adding a new record in a daughter file, the entry is not visible in the portal of the mother record until the mother record is closed and reopened. Any clue as to what might be happening? It does not appear to happen in OS9 or Classic mode of OSX.
-
- 3 replies
- 721 views
-
-
Hi, I've tried searching threads for this, but really, I have no idea how to phrase the search. * I have 2 files, one with images and the other representing their sales. The sales file draws a related image into the Sales file via a normal relationship (uniqueID) and that's fine. However, I also want to view the related images via a *self relationship* in the Sales file (for a sales report). Is there any way to view a field's content which is related from another file via a relationship, via a self relationship in the child file? Maybe I should be bringing the image into the sales file via a lookup...but it seems a bit cumbersome to have to have the im…
-
- 4 replies
- 842 views
-
-
I just inherited an interesting project. One of the things it does is bring out a 1 to 8 page report.... Using about 20 portals. The good thing is that the author made most of portal share one lineitems database (using dynamic keys method, and not using all fields) so in theory I could print from the line items, but there portals from other databases. so it won't be easy. As well, the author made it so if the portals are empty, they do not print (and shorten the report). I havn't really figured out how he pulled this off. I think he is using print sliding. Almost everything in the print layout is a calculation the is something like: If(IsEmpty(field), "",…
-
- 8 replies
- 1.1k views
-
-
Can someone tell me if it's possible to have submenus in a popup menu. I have a popup menu in a layout with about 50 items and it becomes somewhat awkward to use and would be much more user friendly if I could break up the list with submenus. I considered a conditional value list but I would prefer not to add extra menus for the end users convenience. Thanks, Cliff
-
- 1 reply
- 932 views
-
-
I was happily doing my thing with portals until I started reading this forum, and now I've gone into complete panic mode. Here's my situation: We have an interview that's administered to students every three months. So far, we only have two of these interviews administered, so each student will have two interviews associated with him/her. I have a file called Student for student demographic information, Questionnaire, and Scoring Profile. The Scoring Profile is a file that takes the values from the questionnaire and scores them. I need to display a summary of the differences in each of the question from the first time the test was administered, to the…
-
- 1 reply
- 748 views
-
-
I'd like to have the first value in a pop-up list automatically selected when the list is selected by tabbing or have the first selection in the list display automatically when a new record is created. Thank You
-
- 1 reply
- 880 views
-
-
Is there a way to have a value list only show the "FOUND SET" and not the entire database? Example: Value list (from fieldA) FieldA: Adam Mike John Andrew Perform Find for "Mike" & "John" Value list: Mike John Catch my drift?
-
- 4 replies
- 881 views
-
-
I have a multi-table solution running off of FMS 5.5 (all clients are FMP 5.5 too). Multiple platforms are accessing the server. The solution utilizes dynamic value lists based on relations. Everything works great, _except_ on NT clients. The pop-ups show blanks. You click on it, and a single row of nothingness appears. This only occurs in NT (v4, sp6). 95, 98, XP, Mac Classic, and OS X are all fine. Any ideas, solutions, experience? Many thanks.
-
- 0 replies
- 703 views
-
-
I have a one to many job_header to job_items. I have a field setup in the job_items db called 'category' which is either P, L or O. I have a calc field of: If(Job Header to items::CATEGORY="L",Sum(Job Header to items::CHARGES)*.6,0) and also If(Job Header to items::CATEGORY="P",Sum(Job Header to items::CHARGES)*.35,0) I finally add these two calc fields together with: tot_com=L_com+P_com to display the total of the fields in the portal out on the form. Problem is that the calc is ignoring the condition of testing the value of CATEGORY. Any help appreciated.
-
- 1 reply
- 754 views
-
-
Okay, I'm an idiot. I am trying to set up a portal to show in list view the inventory from the database (there is only one database). I drag out the portal, select "Item" in the show records field, click okay, drop a field on there, and nothing. The portal shows a list-type box and nothing else. I doesn't matter if the field is relational or not or if i group it or not, or any other the options for the protal format are different. I have been using filemaker help and the Filemaker Pro Bible (the greatest series of reference books on earth!) and they describe the exact procedure I am telling you about right now. The relationship I am using is set up like this: the …
-
- 13 replies
- 1.2k views
-
-
Has anyone any experience with touch screens? I am about to invest in a unit for a retail application, but am unsure which units to look at. At the moment I am looking at ELO touch screens. Does anyone have any experience with them? Does anyone know of any pitfalls with using touch screens? All help and information is gratefully recieved.
-
- 5 replies
- 1.1k views
-
-
I have a portal that displays a list of documents and has 2 buttons: one to move a document up one row, and another to move a doc downone row. The portal is sorted based on Sequential # (number field). The scripts work for a number of moves and then one or the other screws up, but not always the same one. I can't figure out why. Could the portal rows get changed (resorted) by FM before the script terminates so that I'm not on the row I think I am? Does anyone see what I'm doing wrong? _iloc and _ipos are global number fields. Move Sale Document Up: Set Field [ _iloc, Status( CurrentPortalRow) ] If [ _iloc = 1 ] Halt Script End If Go to Port…
-
- 1 reply
- 1.4k views
-
-
Hello, I'm hoping someone can help me with this issue. I'm trying to design a report based on the answers from a questionnaire that we administered. Each question is given a weight, and then all the results are tabulated and calculated to give a percentage of the total scores. The questionnaire is given every three months with the same person. I'm trying to design a report that would show the results from the current and previous questionnaires. The problem I'm running into is the layout design of the report. Here's what I'm doing: I have records sorted in a grand summary by ID. Each ID will display a number of records. I'm printing the report in …
-
- 0 replies
- 730 views
-
-
All, I have 2 databases - FileA and File B. I have succesfully created a simple conditional value list in File A. I now want this list to be used in File B So far.... I have created an external value list in File B linking it to the conditional value list in File A. I have then assigned this list to a field in File B. BUT this doesnt work. I have checked and re-checked all assignments. No values appear in the value list in File B :-( Am I missing something? Any help would be greatly appreciated Thanks Chris
-
- 2 replies
- 899 views
-
-
I sure hope there's a genius out there to help me with this one... I've got a classified database, producing ads for a newspaper, and I'm trying to work on an efficient way to enter and export these ads to go into Quark. Sure, I know, you're all saying XTags, right? That's what I'm using now, and I have two small problems with it... First, what if an ad has two paragraphs in it? Well, when Filemaker exports the ad text to a text file, it has to remain all on one line - no carriage returns, so it changes all the carriage returns in the text of the ad to (for some strange reason) column breaks. Now, I've been running a script that will search for these column breaks and…
-
- 0 replies
- 936 views
-
-
Not sure which forum to post this is, so I'll start here. I'm trying to find out if/how well Filemaker supports voice recognition. As in data entry via voice commands. If anyone has any suggestions that might point me in the right direction I'd appreciate it. Thanks! Lori
-
- 2 replies
- 871 views
-
-
[color:"purple"] Has anyone seen a product or template possibly called NavBar! ? I have seen it in a solution where it appears u set up colors and icons and such to be used in an application and it puts or uses those colors etc... in the interface. The interface is made up of a bunch of tabs across the top of the screen and they are all different colors. The final solution appears to be missing some files which i assume are used for development only. I'm not sure if someone just came up with this for their own personal use in development or if it is available from someones website.
-
- 1 reply
- 927 views
-
-
You'll have to let us in to the secret of what each record in your file represents. It's hard to tell you how to summarize when we don't know what we are summarizing. It sounds like you need summary fields and multiple subsummaries on the layout. First a subsummary by month, then another by doctor. Wizards are great if they solve your problem, otherwise you'll have to dive in and understand how it all works. -bd
-
- 4 replies
- 956 views
-
-
Hello, I am creating an attendance solution for a school. I have 3 files, Students, Teachers, and Attendance. In an attempt to not have to scroll to the bottom of the portal window to create a new record (automatically), I have created scripted buttons that create a new record from the student database into the attendance database and sets the status of attendance. This works just great. I am running into problems displaying the info in a portal to give some sort of feedback to the teachers about which student status that have completed, or where they are in the list. The first records work just fine because it only has the one related record to display. By…
-
- 3 replies
- 1k views
-
-
Is is anyway to show unindexed values (from a related unindexed calc field)? Any work-around way? Thanks
-
- 2 replies
- 783 views
-
-
Each one of my records refers to a specific auction number. When an auction doesn't sell, it is duplicated, and the previous item # is put into an "old item number" field. I'd like an easy way to show how many times an item has been put up. I think i would need to "loop" a portal, but not sure how to do this. Of if you have a better idea, let me know. Thanks -j
-
- 7 replies
- 928 views
-
-
Hi Everyone Is there a way to turn off the FMP5.5 startup spalsh screen? We would like the name of our solution to be displayed instead of the FMP5.5 splash. Thanks in advance for all the help. Stuj
-
- 4 replies
- 1.1k views
-
-
Any ideas on how I can include the plus in A+, B+ etc in my dynamic value list based on the raltionship A+, A, B+, B, C+, C etc?
-
- 3 replies
- 915 views
-
-
The desired capability: To have portal records resorted by clicking on portal column headers. I've already implemented my own solution. The reason I'm posting this is because I'm confused by all the solutions to this problem I'm seeing out there in Filemaker land. I haven't seen anything as elegant as what I've done and I'm just wondering why some of the solutions I've seen are so complex and bulky. My solution: 1) Create a field called 'portal sort number' in the file that your portal looks into. 2) Define your portal to sort on 'portal sort number'. 3) Attach portal header text for column X to a script that sorts your file on field X then l…
-
- 2 replies
- 932 views
-
-
I'm working on a receiving db where I'm getting the raw info from an old DOS accounting system (so I can't set everything up right the first time!). I'm currently importing two files into two dbs. I have a header file (PO #, date, name of vendor, etc.) and a line items file. The line items come to me flagged by a status field as either Open or Complete. Typically, a 100 line PO could dribble in from the vendor over several months, meaning any given line item could go from Open to Complete without affecting the status of its neighboring line items. I've set up a layout in the header db with a portal that shows all line items associated with a PO#. What I'd li…
-
- 2 replies
- 823 views
-
-
I have been using portals for a long time. But - never think of the connecting files as Parent and Child. I just want to make sure I have each one labeled in my head correctly. For this example - I will use Invoices and LineItems. The invoices db has a portal to the lineitems for individual line entry. The parent file would be the LineItems database and the child file would be the invoices databases. Correct? If I am thinking backwards - please let me know and help me to understand why it is the other way. Thanks
-
- 3 replies
- 839 views
-
-
If I create a lable layout the merge fields from the wizard will be middle (between top and bottom of text box) how can I format this without having to go through the wizard?
-
- 2 replies
- 815 views
-
-
Hi, I am a new FMP user and am actually starting out developing POS and Inventory software for my friends/employers. I am an interface designer (one of the reasons I chose FMP, interface is given equal credence) and HATE "modes." They are bad and they are evil and they will suck you soul. Anyway is there any way to display the "list" view and the "form" view at the same time? Like have a "form" view on the left hand side and have the "list" of things on the right? Or do I have to have them in seperate windows?
-
- 1 reply
- 801 views
-
-
Hi guys, long time since I've been in here - no it's not that I know everything now - just been away and now back to the grime stone! Here's the problem - mmmm You know in Outlook you have a SCHEDULER/CALENDER/PLANNER section? Yes? Well, you'll notice there is a nice graphical way of showing when you have appointments and when you are free. I am writing a database for a medical centre which will also involve booking appointments to see doctors. Although a list will surfice, I would like to have a graphical representation of their time free and allocated time. So, I have an appointment date and time field. I have a duration of appointment field and th…
-
- 10 replies
- 2k views
-
-
Hello folks. I've been using FMP for over a year now, and have recently started using FMP 5.5. When I have a field that is definded by a value list, I don't get any pop up menu when i want to enter data! My questions are this: where did it go? Is it something obvious that I'm missing, or does it have to do with the newer version? It's just getting really hard (and tedious!) to enter the EXACT value without being able to select it from a pop-up menu. Thanks. Jackson Hewlett
-
- 2 replies
- 741 views
-
-
All, I wonder if anyone can help me with this one! I have 3 databases - Timesheets, Timesheet Data & Projects Timesheet Data is referenced to Timesheets via a Portal that works beautifully! In the Portal I have a field called Project No. I currently have a pull-down value list of all projects numbers contained in the DB called Projects. This works fine! However I would like to refine this value list. I would like to limit this value list to project numbers contained in the Projects DB that are 'live'. This 'live' information is contained in the Projects DB in a field called Status. Any suggestions? Any assitance will be greatly appreciated! C…
-
- 3 replies
- 864 views
-
-
Situation: In my layout I have a nicely sized portal with a number of fields inside, each field has some space around it for legibility sake. Problem: When someone clicks on the row without clicking inside one of the fields, the whole row turns black to indicate it is selected. Similarly, if I change the fill color of the portal to a dark color (it is currently white) a lighter contrasting color will appear. Question: Can anyone suggest a more refined way to handle this, for instance a lighter gray on a white background. Or is this built in and unchangable?
-
- 5 replies
- 997 views
-
-
can anyone suggest a way to do the following. I need to be able to create "x' number of related records in a portal where x is the total months between 2 dates. Basically i have a date range from 1/1/2002 to 3/1/2002 which equal 3 months (anyone know how to calc that to reach "3") and then create "3" related records starting with January and ending with March. The end result would be that i select employee A in the portal from a value list, FM would then create 3 records with the same employee name which auto incremented months ending on March. does this make sense? Thanks!!!
-
- 3 replies
- 896 views
-
-
When using a portal to create new records, is it possible to include other fields outside the portal (but in the same record as the portal), in every newly created record? Thanks
-
- 3 replies
- 812 views
-
-
OK ... so all you supergeniuses out there, see if you can help me with this. I have a calculated field showing in a checkbox format in a cell. Shows up beautifully. But, I wanted a button to sit over each checkbox, for when the user tries to check the boxes (as a calculation, it won't let them, of course). So I have a database, the relationship lists out in exact parallel to the list of checkboxes. I set up a portal, and layered it, just inside the cell for the calc field, and I adjusted the row, at 400% so that it is perfectly aligned with the rows of c heckboxes. Perfect right? Well, it should be. I zoom out to 100%, and the rows are off. IT isn't that they we…
-
- 1 reply
- 774 views
-
-
I have a field that is formatted as Checkboxes, from a value list linked to another database, that may dynamically grow or shrink. What I'm worried about, is what happens, when there are two many checkbox choices to fit in my box? Is there any way to make a scrollbar, so they can scroll through the checkboxes?
-
- 4 replies
- 1.2k views
-
-
I have two database files. "Contacts" and "Projects". The "Project" database is using two portals to display related entries from two relationships from "contacts" called "primary" & "secondary". For each "Project" Record there are several primary contacts and each primary has several "secondary" contacts related to it. The number of "secondary" contacts for each "primary" is not known but i would like each to be displayed associated with the proper "primary" contact. Theoretically placing a secondary portal in each line of the primary portal. Any help would be appreciated.
-
- 2 replies
- 729 views
-
-
Hopefully an easy one for everyone, except me! Simple Notepad file with Portal plus related Notepad Line Items file. Items are dealt with and then deleted from portal but how can we retain the items (archive them) in the Line Items file when they are deleted on the portal? We have not clicked 'also delete . . .' in the relationship box. Thanks for any comments.
-
- 8 replies
- 990 views
-
-
I posted this message in the Define Fields area - but I really think it needs to be in here. I am duplicating invoices - that have a portal on them. When I duplicate the invoice - the general information duplicates, the date is increased via my script, and the inovice number is increased. But - the portal information (line items) does not move over as well. I have tried to create a realtionship between my Line Items and Invoices using the Invoice # in the Line Items and the Original Invoice # in the Invoices - hoping this would pick up the information - but I have had no luck. Any advice you could give would be muchly appreciated. I will keep trying in t…
-
- 4 replies
- 982 views
-
-
It's time for me to do a "visual" upgrade to the FM database. I'm looking for ideas and was hoping that some of you would take a screen shot of your databases and post them so i can take a look. Don't worry, I'm not going to take them and sell them, Just want to make my DB's a bit more pleasing to the eye. Thanks -j
-
- 6 replies
- 1.3k views
-
-
I have a checkbox in my related record. All my other fields show up in my portal row, but the checkbox field does not show anything. Is there a way to have it show the checkbox and also have it where it is selectable? LR
-
- 2 replies
- 1.1k views
-
-
Hello, Let's say i have two databases. One called view and the orther called graphic. In the graphic databases I've got al kinds of graphics in a record with one text field as the name. The view database is related by the graphic names trough the name. This makes it possible to switch graphics on the fly. But is this a good solution when working trough a Filemaker server over internet??? thnx allready:) Jeffrey
-
- 5 replies
- 954 views
-
-
I thought I could do this then found I could not! I have various linked files, one is 'Contacts' containing various individuals' details. Main file is 'Meetings' at which records will be created for each meeting with varying numbers of individuals from the 'Contacts' file attending. What I need is to be able to use a pop-up list of 'Contacts' in the 'Meetings' file which will be the basis for a mail-merge function so that I can send invitations to the 'set' of 'Contacts' attending, with these invitations printed out automatically, with all relevant personal address details added. I suspect this involves a portal or lookup of some description but I am not sure exactly how…
-
- 2 replies
- 697 views
-
-
I'm making a scheduler in FileMaker Pro 5.5 where you can select a procedure (input list using the field procedure in the procedure database). There's a second field called steps in the database Procedure, in that field you write down the different steps needed for that procedure (every step on a separate line). What I want to archive in the scheduler is the following: The steps needed for the completion of the procedure will be listed in the steps field, the field is formatted as an input list with select boxes. The input list in the field steps must be linked to the procedure, so that the list used are the steps for that specific procedure. In other words: I…
-
- 3 replies
- 1.1k views
-
-
I use a drop down menu that lists the name field from a different database. The problem is that this database has about 20,000 records. The result is that when you try to drop the list down it takes 15-20 seconds (sometimes longer!) to appear. Does anyone have a solution for speeding this up or narrowing the list that is displayed so that I can find the required name faster etc. Thanks Nick
-
- 7 replies
- 1.2k views
-
-
I have a production workorder for an item that has several attributes. Example: a pendant that can be gold, silver, brass, aluminum. The shape can be: flat, curved, semi curved. The attachment can be: pin, ring, clip, none The color lettering can be: green, red, blue. etc... I currently use drop down boxes to select the attributes for each pendant. That means 4 or 5 drop down boxes. I would like to number each attribute and make a single entry to come up with the final set of attributes. For example entering 1,6, 8, 12 would give me gold, curved, ring, red. I know that I can concatenate every possible combination o…
-
- 4 replies
- 903 views
-
-
I am updating a solution created by someone else. Here's my problem: I have three related files: Departments Staff Projects Departments and Staff are related such that for each Department there are multiple staff members, and each staff member is associated with more than one department. For each Project, A staff member and a Department need to be selected from a pop-up value list. I would like to use a conditional value list, so that once a Staff member is selected, only that person's associated Departments would appear in the Departments pop-up list. This seems elementary - but since there are three files involved, I haven't managed to make it work. …
-
- 4 replies
- 777 views
-
-
I'm working with a database that has pop up lists in it. One of the pop up lists, when not being used (waiting for an entry) shows a title, i.e. Select Sport and then when u click on it all the different sports show up, but 'select sport' does not. How does one title the pop up list so it's not blank without actually putting a text box over it cuz i don't believe that's how it's done in this case. The actual field that is being used is a global field pulling in a value list from a related file. I hope I explained this clearly. Thanx in advance.
-
- 7 replies
- 1.2k views
-
-
I think that this is the correct forum. In layout mode on my computer if I click on the Layout pop-up menu, it brings up all of the layouts but they go off the bottom of the screen. This gets a bit annoying if the layout I need is the last one on the list. On other computers though if the list goes off the screen it shows up in a second column and makes my life a lot easier. Is there any reason for this. A bit petty I know but does annoy me!!!
-
- 1 reply
- 733 views
-
-
Hello, I've just tried porting a runtime solution to Mac and most everything works okay. One odd behavior; in a portal that shows only one row at a time, the "go to next row" and "go to previous row" scripts do change the row number but the field data remains what appears in the first row. If you click in the fields, they update to what should be in the row navigated to. The full version that I brought to the mac, navigates the portal rows as expected, only the runtime appears not to update portal row data. If I click in the scroll bar area, above or below the scroll bar, the page up, page down effect does switch portal rows with updated data. FMPro Dev 5 Mac 8.5. Tha…
-
- 1 reply
- 912 views
-
-
Any tips on why a portal scroll bar would not be visible. It is in the area to the right of the portal and can be clicked on...but, It is not visible...
-
- 1 reply
- 1k views
-
-
I run scheduled scripts with the oazium events software. At X time it sends a "open script" command and the file opens. Upon opening of a file, as specified in the file, it runs X script. Unfortunatly, at random times it doesn't execute when the file was opened. Any ideas why?
-
- 3 replies
- 798 views
-
-
Using a Pop-Up-List or a Pop-Up-Menu, is there a way to get them to show the value selected? In other worlds if I have 10 names in a Pop-Up and I click on one of them, I want
-
- 5 replies
- 834 views
-
-
Hi! I know this is a little anal, but it really makes my data entry interface UGLY, so here goes. I made this lovely little data entry form, with fields scattered all across it, many of these fields are the same color as the backrgound so that they are invisible if they don't have data. However, if I start entering data in a field, all these semi-transparent highlight borders appear around random fields across the layout, usually every field at once. Is there any way to stop this?
-
- 1 reply
- 737 views
-
-
I have a database with about 10 files, several users, and several automated tasks. I'd like to create an "event log" wich keeps track of items such as "user ID, script name, file name, and results such as: email successfully sent, email successfully received, script executed normally, script error occured, etc." Since i want a centralized file, i figured i'd use a portal. But since i want to do this wish as little adjustment to the other files as possible, what would be the quickest and easist way. I'm not against using an "error code" system that later translates into an error message. Thanks -j
-
- 1 reply
- 830 views
-
-
Quite similar to the last post! but anyway... I need to put data that i have stored in one of my FM Pro databases in to a graphical format.e.g bar graph, line graph etc. The data in the database i need to show is recordings of job times. e.g average job times per customer. 1. can this be done in the same database i.e. on another layout? 2. Does it require a plugin? 3. is it difficult? Thanks in advance.
-
- 6 replies
- 1.3k views
-
-
I currently use a set of overlapping fields for the description display in an invoice file. The top field is t_Description- a text field that the user can type into. The bottom field is c_Description= if(is empty(t_Description), t_Make & " " & t_Model..., t_Description) and the user is not allowed to enter the field. This works great- the user can leave the auto entered description, or type in their own wording (also formatted the field as a button setting t_Description to c_Description so they have the original text to start with...) My problem is that when the user is in browse mode and clicks on any field, all enterable fields on the layout a…
-
- 2 replies
- 948 views
-
-
I have a set of 3 databases: Clients, Interface, Files In my interface, I have a client search field which triggers a list of client names with matching string in a portal ("client name portal"). By selecting the relevant portal row, this will bring up the files for each client in a separate portal from the files database. I have a cbackground container in the client database which is a calculation: if(ClientNumber=Interface:tClientNumber, gBackground, "") The cBackground sits in the ClientNamePortal in the Interface and highlights the selected portal row. No Problem. However, in a multi-user environment. If two users are looking at the same list o…
-
- 3 replies
- 889 views
-
-
I have 2 database tables: The parent database table (Contract) displays related Contract Logs, from the Child database table (Contract Logs) via a portal. From the parent database, I can use the command Goto Related Record to select the relevent record in the Child Database. Is there anyway that once a record in the Child Database is selected, the relevent portal row in the Parent Database can be selected. Everytime I try to highlight a SPECIFIC portal row (by file contents for example), only the first row gets selected. The other portal row option (first,last,next etc) aren't specific. Any Ideas? thanks
-
- 8 replies
- 2.2k views
-
-
-
i have built a splash screen for my DB, that basically has a graphic that simulates a progress bar and a global text field below it that shows progress text. the script that runs has a series of actions and before each action, i run a sub script that sets the global container field (that shows the progress bar) with the progress bar graphic and also the next text to appear below... problem is that it only updates the screen every so often even though i have Refresh Screen at the beginning and end of the subscript and even a goto Field (with no field listed) at the end of the script.
-
- 2 replies
- 1.5k views
-
-
Thanks to this forum I can now travel between databases and layouts by selecting a desired location from a value list then clicking on a button to execute a script based on the value selected. I'd like to eliminate the button and be able to initiate the script by merely making the selection from the list - much like can be done in a web page. Any thoughts or suggestions will be appreciated.
-
- 1 reply
- 742 views
-
-
Is there a way to lock a column in a layout? I have a layout that extends off the screen on the right and want to be able to lock two columns in place on the left side so they are visible as you scroll to the right. Mobile v2 can do it. Can FM 5.5? I already have the Header "locked" so I can scroll down the rows and have the column headers always visible. TIA Richard Mossman
-
- 1 reply
- 828 views
-
-
I have a file of Companies with one field Company ID. In the Companies file I also have a field for Company Type (with three choices, Vendor, Client or ShipTo- check boxes). I have a value list Pop-up in my Purchase Order database to choose from all the Companies, but I want to show in my list only the Companies where the Company type = Vendor. Can I do it?
-
- 3 replies
- 1k views
-
-
I was going to post this as part of the "hierarchal conditional value lists " thread, but then thought it was different enough for its own thread. I have found many posts with similiar questions, but none seem to address this specific problem. here goes: 3 files- invoices products items I am having a hard time concocting a conditional value list schema for entering heirarchical data from products into the items file through a portal in invoices. sticking with a car analogy, lets say we have fields: model make year color I would like to have a value list displaying all models (from product…
-
- 8 replies
- 1.2k views
-
-
Is it possible to use a selection from a value list pop up to jump to another file? It would sure beat having a specific button for each db you need to navigate to. TIA for feedback EasyEdE
-
- 5 replies
- 1k views
-
-
I have the following problem with Pop-up menu: 1. Using FileMaker Pro 5.0 and 5.5 2. Operating system is Windows NT4 (Service Packs 4 and 6) 3. In Layout Mode, I have chosen for Field Format for a particular field, under Style for a value list: "Pop-up menu" 4. When in Browse Mode on this field where Pop-up menu used, the list does not appear vertically with the ability to use the up and down arrows to scroll up and down the vertical list 5. Instead the list is presented vertically to the depth of the screen then further columns of the value list are presented horizontally until the value list runs off the right hand side of the screen. The…
-
- 0 replies
- 739 views
-
-
A value list that I am creating is a choice between several lengthy phrases being inserted in a formatted letter.. In ten years of using FMPro, I had never run into the fact that there is a 255 character limit for each value. And, since I was exceeding that number, the phases would truncate. I have found two tech bulletins (101491 and 102388) which advise that the workaround is "use a code value in the value list and set it to trigger a lookup into another file that contains the actual data to be entered." My thought was that this meant to use the "use values from field" choice and have the appropriate text over in the chosen field. That doesn't work (or I'…
-
- 5 replies
- 876 views
-
-
I just recently had a need to print a list through a portal. I noticed that it only prints the shown part of the list. I was wondering if there was a way to have it print the entire list, similar to how a columnar list/report does. I tried making a columnar list and placing related fields in it, but it only shows the first related record, not the entire list. Also, I dont want to just extend the length of the portal because the potential for the list to get longer is high. Thanks in advance for the insight. Ken
-
- 2 replies
- 689 views
-
-
I am using FM 4.0v1 and have made a value list from another db to display in my main db. The value db has fields that list the type and grade of material. Since is it hard to determine what type of material is being chose by just looking at the grade I have check the box that says show information for other fields. But only the first matches showup in the value list in the main db. Example: Grade Type SA234 Pipe SA516 Plate SA106 Pipe Value list will only show SA234 and SA516 (along with the type) put not SA106 could someone suggest what I am doing wrong?
-
- 9 replies
- 1k views
-
-
Hi All, Hopefully, one of you have done something similar to this. I have an online form that is registering students for placement exams at a university. For any date and time, a maximum of 30 students can register. When a given date and time exceeds 30 registered students, that date should be removed from the value list that holds the available dates and times. The thing is that I don't know whether that kind of capability can be facillitated over the web using CDML in combination with Java or JavaScript or if it is even possible at all. Do any of you you happen to know how value lists are stored and can be referenced in s…
-
- 2 replies
- 890 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online