FileMaker Interface Features
-
Hi all, I am trying to create a columnar list report with grouped data. Something like: CATEGORY 1 Question 1 Question 2 Question 3 CATEGORY 2 Question 1 Question 2 Question 3 CATEGORY 3 Question 1 Question 2 And so on. I am able to see it happen on Preview mode, but I can't get the same result in Browse mode. Anyone knows how to do this? Thanks in advance Erbium
-
- 2 replies
- 852 views
-
-
I have a product_sales database with a portal to a product_inventory database. It works perfectly _IF_ you press 'Enter' before entering any data. If you create a new record in product_sales and start entering data in the portal, it does not retrieve the data. It doesn't do anything wrong, just nothing. I'm new at Filemaker, but everyone here says 'That's the way it is.' Fine. My question is how to generate that 'Enter' in a script. I need to create a new record and populate it with parts and have the portal work correctly. Hope that's clear. Thanks,
-
- 4 replies
- 883 views
-
-
I am trying to figure out how to get Filemaker recognize when different lay outs should be used. I work for a missing childrens org and we've created a searchable DB so that our web site visitors can browse through all the missing children in our Database and print out posters of the ones they choose. It works fine but we can only use one lay out "Child photo, case info and contact information" but sometimes we need to have use a different layout, like when there is an abductor photo or information, or if there are multiple children missing and an abductor. So my question is, would there be a way to have filemaker "know" when to show the different layouts if the info…
-
- 0 replies
- 794 views
-
-
Hey, I have a layout that when in browse mode is displayed as a list of records. I want to create a button on the list that will allow the user to print / preview, the related report. I set it up so there is an icon on the list (meaning that the icon appears repitiously down the screen... not a big deal). But when I write the script to have it go to preview mode and print... it always previews record 1, not the record from which I selected via the icon. I was trying to modify the script but I didn't see a "select this record" type command... can anyone help me? or give me a different method of choosing from teh list view to print? Much Thanks... Va…
-
- 9 replies
- 1.2k views
-
-
So i have some tables Table_1, Table_2, Table_3 Table_1 contains ABOS (A Bunch of Stuff) and speicfically a dropdown to choose a Category based on the categories in Table_2 (that was easy enough to do), what I need to know how to do (in dummy terms) is make Table_1 display only relevant options from the choices in Table_3 right now, I am doing the Dropdown by relating Table_2->Category_ID to Table_1->Category_ID and then using a valuelist from Table_2->Category_Name What I need (trying for explicivity here) is to now display checkboxes from Table_3->Choices Table_3 contains the fields Choice_ID, Choice and Category_ID Presently my…
-
- 0 replies
- 841 views
-
-
I got a problem with the scroll bars on my Labels layout. They randomly appear/disappear: When I first visit the layout they don't show up but if I go to Labels then another layout and come back to Labels they are there! Is there a way to control these scrolls bars at all?
-
- 0 replies
- 682 views
-
-
I have two databases Attendance and Class List. There is a relationship connecting them based on [color:"blue"] Student Name . A drop down menu in the Attendance database defines if the student is "tardy" and a check box defines if the tardy was "excused" (0=not excused, 1=excused). The Class List database uses the following "If" statement to count the number of tardys and subtract 1 if the tardy is excused: If(Attendance::Excused=1, Sum(Attendance::#Tardy1)-1,Sum(Attendance::#Tardy1)) This formula works for the first occurance of a student but if there is a second tardy it doesn't subtract. When I check off the box, the sum stays at 1... Thoughts? …
-
- 2 replies
- 908 views
-
-
Hi.I am a newbie so please bear with me. Using FMP 7 I want to create a billing layout for CABLE REPAIRS. Each record contains fields relating to the company, cable type, employee/technician, hrs billed, rate, etc... It also includes an area that calculates the charges incurred when replacing commonly used connectors and materials on these items. I have 4 groups of fields. Each group has a "Qty" field next to a "Connectors" field. Each field in these groups is a separate occurrence. The "connectors" fields are named "A" "B" "C" and "D". I want each these to utilize a drop down value list to select one of the connector types. (Probably 20 types) The user can choose to …
-
- 0 replies
- 719 views
-
-
-
Hey! I have two questions. Question 1: In a portal: line 1: Blue $100 line 2: Red $ 50. How can I create a total ($150) for the layout where the portal resides -- preferably outside the portal? Question 2: In a portal: line 1: 5) Process 1 line 2: 3) Process 1 How can I create only one line showing: line 1: 8) Process 1 Thank you!
-
- 8 replies
- 941 views
-
-
I've created a value list from a calculated field using the following formula which produces the string showing the JobNumAssignConc at the front. How can I make it sort alphabetically, like other value lists do? Case ( StatusDue != "99 Closed" ; JobNumAssignConc & " " & ClientName & " " & JobTitle) Help please from anyone in the know!
-
- 3 replies
- 857 views
-
-
I have a database with two fields. Field One = ANIMAL Field Two = FAVORITE FOOD Both fields are populated via value lists which draw their values from the respective fields. The second field, FAVORITE FOOD is constrained to using only related values from the first field. IF: ANIMAL = Bird > FAVORITE FOOD = Birdseed IF: ANIMAL = Dog > FAVORITE FOOD = Kibbel This is pretty simple so far. When you select the animal name, a list of possible food presents itself for you to select from. What I would like is to have the value for FAVORITE FOOD automatically selected as a default choice (Not as an option to pick from) so that when you c…
-
- 2 replies
- 703 views
-
-
Hi all, I was wonder if anyone has any suggestions to this problem I've encountered. Perhapse the solution to this is rather simple, please point me to a direction. Thank you for any inputs to this matter. I am working with 3 selection portals - A, B, and C. Each built on the relationship base on global fields equal to a row that was click in the other portals. For examples, when user clicks on a row in A, a global field is set to equal to the value of that row then B portal is populated base on the relationship to that global field. Same method is done so C portal is populated base on the row clicked in B. Each portals has 15 rows on the layout. Some …
-
- 3 replies
- 792 views
-
-
How can I number my lists in reports that are created? I want to use Record Number Symbol, but when I have multiple lists on the same page, the second list continues with the next number rather than starting from 1 again.
-
- 6 replies
- 1.1k views
-
-
I am (trying to) replace a bunch of Excel spreadsheets that are manually updated with info stored in a FM database. We currently have a report by location, with a supervisor listed in each column across the page, and the employees that report to the supervisor alphabetized and listed below each supervisor's name. Is this possible in FM?
-
- 0 replies
- 616 views
-
-
Hi, I have a portal at the bottom of my layout. It contains detail items. Well, up until just recently, those detail items have never been enough to go past the length of the portal. The portal will show 8 items. But when I added some new items - so now I have 16, the scroll bar on the right doesn't display. I have in the portal setup "show vertical scroll bar" checked. anyone ever have this happen to you before? If so, what did you do to fix it? thanks, sincerely, J__
-
- 10 replies
- 1k views
-
-
I have 2 files - one of these with a portal which summurizes input of the other one. When I am trying to create invoices (using my portal) for a certain period ( I can do this using the Datafilter - plugin), I become all records (patients) who had treatment during this period. The problem is that some patients paid some treatments (but not all) already cash within the selected period. I indicated this in my input field by a seperate field (list) (paid/not paid). Now if i do the search for all patients within a gving period and indicate that the field must be not paid, I still become all records (paid and not paid), since the my portal summarizes per patie…
-
- 6 replies
- 931 views
-
-
I'm a newbe to FM. I need your help Please. I have 3 employee's 2 work part time through the winter plowing snow, all 3 work full time in the summer. Here is my questions: 1. I tweeked this time card solution but I need to track hours worked for each Employee ID seperate. ( I bank thier hours until they have 40) so it will span over a few weeks. Then I want to print out their report to send to my accountant. 2. I need to make a report of just the weeks that they haven't been paid for. (not all hours in the database) thats how it works now. Everything you put in will show up in the list view, which will be too much over time. Can someone give me advice on how to do …
-
- 3 replies
- 1k views
-
-
I would like to make a layout with each record displaying in a column, and the field names displaying to the left, as in the example below, where "||" separates the field name (which should only display once on the left side) from the fields, and "|" separates each record: Record number||123|456|789| Time||2.5|3.5|7| Date||10/12|2/3|6/7| Of course in the layout I would want each record's fields lined up neatly, which can't be done here. I could do this in about 2 minutes on a spreadsheet, but I can't seem to figure out how to do it in Filemaker! Can anyone help me or tell me if Filemaker has that capability? Thank you!
-
- 3 replies
- 932 views
-
-
I'm building a time clock The first layout you see is a switchboard that takes workers to their own personal screen. When they get to this screen they select a task and then have two options: If they are not currently working on something they can hit the START button. If they want to clock out they can hit the STOP button. I would like to have only one of these buttons visible at a time. The START button already inserts current time into a start field. I would like it to also direct the STOP button to go to the back of the layout. Conversely, I would like the STOP button to insert current time into the stop field and chase the START button t…
-
- 2 replies
- 835 views
-
-
Hi, I hope this is the right place to post a question like this? I
-
- 1 reply
- 983 views
-
-
Hi, Do you know of any way (or workaround) where I can produce a ValueList from a calculation field which is set to "do not store calculation results". I'd appreciate any thoughs Thanks Giles
-
- 4 replies
- 827 views
-
-
I have a DB script that is doing some data manipulation. In my script, the db leaves the current layout to do some manipulation in another table. It's triggered by the value that is in a field of the original layout. When it comes back to the original layout, I would like the script to start at the field that it left off at. I am having trouble geting the script to go to the next field. When I come back to the layout, it starts at the first field. I tried putting in a temp Global variable but the Goto Field step does not allow for variables. Any help would be appriciated. Thanks.
-
- 1 reply
- 761 views
-
-
I am working on a task list manager for my cabinetshop. I have three fields: PART NAME and TASKS and COMPLETION STATUS. PART NAME is populated from a pop up value list. This value list contains the custom values: Door ---- Drawer -----Faceframe TASKS are also generated with a pop up value list but this value list contains only related values. If you pick Doors your available TASKS only contain Door activities. If you pick Drawers, all subsequent tasks choices are germane to Drawers. COMPLETION STATUS is a simple radio button: Finished -----Not Finished What I have so far is a simple conditional value list. I would like to com…
-
- 1 reply
- 919 views
-
-
I am using a portal for data entry, and would like to limit the number of records created through the portal. Is there a way to do this? [email protected]
-
- 2 replies
- 789 views
-
-
Hi there, Feeling still like a newbie, so bare with me. I'm having problems setting up a simple invoice/invoicelines system..... To my unbelieve, the only templates, as far as I found, that come with version 7 Developer, show this solution with only 6 fixed lines.... I can't believe that something so trivial as a master / detail form is turning out to be such an headache.... or am I mistaking ?
-
- 1 reply
- 722 views
-
-
Hello all, edit: seems i did not explain clearly, thats why nobody looks at my post. i know how to make a value list based on another field, the question i have is how to make a valuelist minimum 3 level (possibly unlimited) levels deep? im stumbling to find out how to make Valuelists displaying only Values i selected in a prior Valuelist. It seems i have a mistake in my Relationships, but i cant fins out where. The first one Valuelist is easy and displays as it shoud. All Field Contents from the type table. The second one works as well, but the third one wont function. It picks up Beer, even though i selected Dark Spirits. Can anyone help me fix this file i pos…
-
- 8 replies
- 1.2k views
-
-
Hi guys, I having some problem in sorting with filemaker. I playing around with People Management and using the features List View, where I can sort by First Name, Last Name etc, which I will use, but I also want to sort by Nick Name, Email Address and Phone Number. I copied sort by last name in the scriptmaker and also in Define Database section. I only changed the field I want to sort by as the other seems to be that way. however it wont move, I feel its because it's [email protected] can someone tell me how to fix this? I want to sort by the first letter then second etc like any program that sorts. Thanks in Advance.
-
- 6 replies
- 1.2k views
-
-
I have a standalone solution created for both Mac and Win with two levels of user groups. I set the access permissions so that Group 1 can see all 9 layouts and Group 2 can only see 3 of the 9. However, both can see all the buttons that take them to certain layouts. My problem is that when people in group 2 click on a button that is supposed to take them to a restricted layout, a completely gray screen appears with "<<No Access>>" in boldfaced and italics. They cannot navigate anywhere else after that and have to quit and come back into the solution. Anyone have any advice on how they can just return to the previous layout?
-
- 3 replies
- 787 views
-
-
When I select a customer from a value list I set it up so the customer's ID is shown in addition to a second, more meaningful, field. Is this the only way to do it, as the numbers in the drop down list make everything look untidy? What I really need is a way of just showing the meaningful names, but still allowing the ID field to be called upon. Is this possible?
-
- 2 replies
- 638 views
-
-
Am I missing something here? In FMP 6, if the user tries to tab from one portal row to another without having filled in all "Not Empty" fields, the validation-error dialog box will stop him and force him to fix the empty fields before moving to the next row. In FMP 7(v.3), "not empty" validation isn't checked until the user clicks out of the portal and commits the master record. The dialog box alerts him to the error, but the cursor simply returns to the relevant field in the first portal row, instead of to the row that actually contains the error. This is very confusing for the user, particularly if the error exists in a row he'd have to scroll down to find. Ho…
-
- 0 replies
- 673 views
-
-
Hi All, I want to display a specific word in a field in different color. Is it possible. How it can be done? I request to help me with this. Thanks. Yogesh Agte.
-
- 1 reply
- 704 views
-
-
I have a list of customers based on their company name. However, I now need to display the company's contact name along with the company title in the value list. To do this I created a calculation field, based on the various details, and set that as the field to populate the list. Instead of getting a more detailed listing, I get some company names in the list and the rest blank. What am I doing wrong?
-
- 1 reply
- 720 views
-
-
Hi, please help me with this: (dev 7) i have 1 file with products, like ford - focus ford - contour gmc - suburban gmc - silverado in other file or table (invoice) i want appear only i want, i have 2 popup list, manufacturer and model; if i choice ford manufacturer in my second popup list i want just the two models i have in ford for example. I has this in 6 version, but now i am really confuse. I am thankful.
-
- 5 replies
- 1.1k views
-
-
I'm working with FileMaker Pro 7.0v3. I have a table 'Customer' that has the name, city, and state of many businesses (which are customers). I have another table 'Equipment' that contains information about a piece of equipment (specs, etc.). The 'Equipment' table also includes a field for "Customer Name". When I'm looking at the 'Equipment layout' I would like to find a way to type in part of a customer's name (in the "Customer Name" field) and bring up an automatic sorting view/portal of the closest options (including the ability to view the associated city and states for those customers from the "Customer" table/layout). Then I would like to be able to select a…
-
- 2 replies
- 712 views
-
-
I am a Filemaker Pro newbie, and I am hoping one of you experts will have mercy and tell me what mistake I am making. I have spent the better part of a day trying to solve this problem, and I'm getting desperate. In the layout view of a report, I have created a title header. Unfortunately, that title header does not show up in the preview mode, nor does it show up in the printed version. The report is just a table of fields chosen from the database. The table prints nicely, but without the title. What do I need to do to get the title header to appear in the preview mode? Thanks.
-
- 3 replies
- 2.1k views
-
-
Does anybody know how to eliminate the dark line that appears where the header and the body meet and where the body and the footer meet when in the list view?
-
- 2 replies
- 933 views
-
-
Hi, folks. Ready for the holiday? First off, here is a screenshot. It will help me explain what I mean. On the left, under "Staff" is a portal using a self join relationship. It's meant to be used for navigation; click on the name and see the related info on the right. There are about 100 staff members in the database, so some quick find/elimination is in order. This is for a school. Let's say I want to display only the staff for Classroom 1. What I'd like to be able to do is type "cl 1" in the Search field below the staff portal (there is a field "nameWorkLocation"), click the "search" button and have the resulting found set display in both the port…
-
- 1 reply
- 762 views
-
-
Is it posible to see multiple list views (from 2 different tables) in one layout? For the invoices I am creating I need to show 2 different lists of data (items & services) on the same invoice. The two lists do not contain the same type of data, so I can't combine them into the same list. I hope this makes sense Thanks
-
- 6 replies
- 1.1k views
-
-
Does anyone know how to create a new window that doesn't have the blue banner at the top (Window Title Bar) and scroll bars at the side. It is so that I can create a database transport Nav tool with purely icons on it. I want it to be as small as poss without all the edges. I would like it to look abit like the size toolbox. I'm using FM& and have seen this type of window created on FM6 when I looked at a demonstration database. I know it's possible. Also, How do you get Filemaker to check if a certain window (by window name) is open before either selecting it or creating a new one? For a script step. If window [invoices] is open, select window [i…
-
- 2 replies
- 1.1k views
-
-
I have a repeating field that contains an ID but they can be entered in a random order like 2, 5, 6, 1. Then a portal to shows me related record for each ID number. But the portal only sorts in oder so it would be 1, 2, 5, 6 or 6, 5, 2, 1. How can I force the portal to sort in the same order that the id number are entered in the repeating field. Or can I have the repeating field automatically sort itself?
-
- 8 replies
- 748 views
-
-
Hi Everyone, I've got two questions: the first relates to the font size changing depending on what percentage the files are looked at - am i going mad?! I've got a bit of type, size 9 when viewed at 100% and size 8 when viewed at 150% ... go figure! Anyway, onto the real question ... The second question that i'd be glad of some help with, is that i'm trying to paste the contents of one text file in a portal, into another text file (by script) where it can be read better, ie the font is bigger and you can see more of it. When i paste in, the format of the portal type overrides that of the viewing field - something that i don't want to happen. There are lots of f…
-
- 3 replies
- 1.1k views
-
-
I hope there's a solution for this problem. I would like to be able to show the result of a calculation using information from the current record and each related record appearing in a portal. The problem is its a many-to-many relationship. The problem is biology (genomics) related: Two tables (sample data) INSERTS name location (1000, 2000, 3000) GENES gene start/end (500/1500, 700/2500) relationship location >= start and location <= end (this isn't exactly how I do the relationship since non-identity relationships are astronomically slow, but the net effect is the same) So the first record in INSERTS is related to bot…
-
- 14 replies
- 1.2k views
-
-
Hello, I have a button on my layout which takes the user back to the main form. I have turned off auto saving of data and do ti all under this button because the validations in the fields sometimes trigger in a field which my user is not in. so, my plan is to detect if the record has changed under the button in a script. If the record has been edited or is new, then Validate it, if not, my user is only viewing it, so just go to the the other view? is this possible to do ? I took a look at the Get() functions and none of them seemed to fit the bill. thanks in advance, sincerely, J__
-
- 2 replies
- 802 views
-
-
Is there a way to seperate repeting fields on a layout? I have 12 storage units & I want to keep track of who is renting, date payment is paid, unit # and amount short. I have all on seperate fields such as Shed #1 Shed #2 Shed #3 and so on. It looks pretty messy in the define fields, I was thinking there must be a cleaner wat to do this? My wife checks these people in so I wanted a flat simple record for her, Is there a better way of doing this?
-
- 2 replies
- 951 views
-
-
I have this database which I want to use in several languages. A different language = a different layout, but this doesn't change the values of value lists of course. So I have this example database (attached to the post) where when I select in -> table Main field Language the value -> Dutch the -> table Main field Country shows only the values of -> table Translations field Dutch which have -> table Translations field Active Status showing as -> Active I'm sure it is easy and right under my nose, but can't figure it out on my own.
-
- 4 replies
- 797 views
-
-
Is there a way to import a picture into the background of a particular layout in Filemaker Pro 5.5. If so how can I accomplish this? Thanks in advance. Pete
-
- 2 replies
- 905 views
-
-
Hi A user insists that they be able to pick a contact using a small popup layout. I have looked at the Business_Tracker solution from fm7 and it uses popups. However, they are not modal and I see my user clicking on the main layout (unintentionally of course) and then going "hmm, the popup window disappeared, let me click the button again"... resulting (potentially) in a number of popup windows all behind the main layout. Is there a way to do this modally? or will 'bad things' happen? what's the forum members opinion on usage of this? .. and how have you dealt with it? thanks for your input on this in advance, sincerely, J__
-
- 12 replies
- 1.1k views
-
-
Hi, When I am writing text to a text field and the text is about to go off the bottom of the page, I scroll down (as you do). However, I get horizontal lines appearing where the base of the window used to be. Also, if I carry on typing (so the window scrolls itself), some lines of text seem to disappear (they haven't actually gone anywhere and you can click outside the text box to make them appear again). Is this a known problem ? Has anybody had it before ? Thanks, Roger.
-
- 0 replies
- 640 views
-
-
Currently i have a filemaker 7 database with 3 layouts 1) Data Entry 2) Search results 3) Portal View all How do i control or point the using to the correct layout using Web? When i http://localhost/mydatabase -> i can only go to my default layout. Is there away to add which layout to go to in the URL?? All my users log in as Guest. Thanks,.
-
- 0 replies
- 632 views
-
-
I have a value list that is based on a calculation field. My problem is I cannot get the calculation result showing on the value list instantly. Instead, the user has to click on outside of the filed to complete the record in order to get the calculation result appeared on the list. I noticed the reason of causing this delay is that the value list turns the calculation field with index on even I've set it off in the beginning. Can anyone get me some tips to resolve this problem? Example: FY is a calculation field; V_FY is a value list based on FY The problem is V_FY doesn't show any the value until the user completed the record.
-
- 4 replies
- 683 views
-
-
I've changed my system around so that all primary keys are now autoentered, not modifiable. So this way I have a ProductID for each product. There is a related table , Resources, which lists resources required to produce each product, and a join table, ProductResoureces, with ProductID, ResourceID, and qty. Now, I have a ProductResources portal on the Products layout. This allows me to view and add/delete resources needed for each product, via a value list to select the resource. Here is the problem: I need to select the Resource ID (and then the resource's title will pop up of course in that field)... BUT - I don't want to display the ResourceID (just a numbe…
-
- 2 replies
- 656 views
-
-
Is there a way to restrict the records that are viewable in a layout based upon set criteria? For example, if I have a table that contains records which contain an employee's ID number that correlates to specific transactions, so that when the employee navigates to a "My Transactions" layout that the only records that can be browsed are the ones that relate to that employee. I know I can set general limits on records based upon privelege sets but that leaves the "<No Access>" in the unavailable records, I would prefer those records to just not be shown. Or, is there a way to make a script atuo-execute upon navigating to a specific layout?
-
- 2 replies
- 928 views
-
-
I have this problem but I think I'm just missing something very simple. I have a core table called "clients". I have a related table called "fleets". Related to fleets I have a table called "units." It is possible for a client to have more than one fleet. Each fleet can contain more than one unit. I have a layout based on "client". On the layout I have a portal based on units. I want to see ALL units related to the client through the fleet relationship. As of today, all the portal displays is the very first unit record of the very first fleet record. Any suggestions?
-
- 10 replies
- 1.5k views
-
-
Can I make a script that runs after selecting a value in a drop down list then base the script on the result of the drop down selection? Thanks
-
- 14 replies
- 1.9k views
-
-
I am not sure I am in the right place to ask this question. If not please direct me to the right place. Situation: I have a field formatted to access a value list via a pop-up menu. The value list has several hundred entries sorted alphabetically. I have also opted for the "other" and "edit" options and they appear at the end of the value list. Since the list is so long, it takes a bit of time to access a value list item located at the lower end (or anywhere below the A's) of the value list as FMP scrolls from top to bottom. Question: Is there any way to utilize dynamic data entry with a field of this sort? By dynamic data entry I mean by typing in the le…
-
- 1 reply
- 722 views
-
-
I am working on a time tracking and billing system for my company in FM7. Can anyone help with this: Projects are contained in a Projects table. Projects can have Status=Open or Status=Closed. Each project is broken down into components contained in a Components table. Each component can have one or more staff members working on it. I have a Staff table for staff. Components, Projects, and Staff are linked in a linking table which I call BillingUnits (eg: Project ABC, Component XYZ, Staff LMN). Here's the problem: When someone enters their time into an Hours table they need to choose a "BillingUnit" ID to allocate their time to. I want to create a Value List t…
-
- 4 replies
- 764 views
-
-
Aahhh ... what's going on in FM 7? I have a portal with a number of records, sorted by a sort number in a separate number field. When I deselect the portal, the sorting doesn't work anymore... I use this portal for navigation, so the sorting must be accurate ... Anyone any ideas?
-
- 7 replies
- 909 views
-
-
I'm sure there's a very simple solution to this, but it's not coming to me... I have a portal that contains in each row a small container field with a pic in it (a thumbnail if you will) and a filename field. Next to this portal I want a larger scale preview of the "current" pic, and some way to select which pic would be that current selection. As far as selection goes, some kind of mouseover would be VERY cool, but I don't think there is a way in filemaker. But perhaps clicking each one would select it somehow? And then how to display that pic next to it but larger (obviously a larger container field, but how to relate it through the portal, while still keeping my…
-
- 2 replies
- 666 views
-
-
I have a calendar solution with a value list containing 3 choices. The choices represent 3 differnt layouts in file B. When I select a date and goto the related record in file B, I'm using an external script from file B to goto one layout. I need it to go to the appropriate layout depending of the choice of the value list. How can I script this?
-
- 5 replies
- 826 views
-
-
I have a job record with a portal revealing the perfomers who worked on the job. Some of the perfomers will not get paid ontime and will have a late payment, which I have fields for on the portal calculating the amount due. In another file I have the late payment letters. I'd like ONLY the perfomers who have late payments to show up on the portal in the late payment letters file. How can I just choose those people and not have everyone show up from the original portal?
-
- 30 replies
- 2.9k views
-
-
I have as an example a Car database with two fields one is called "Manufacturer" eg Ford, Porsche, etc and the second field is called "Model". When I Have a drop down menu highlighting "Porsche" I want the second field to automaticlly let me select the model as being "Boxster" or Carrera", etc. If you have a demo file I can look at that would be great. Anyone help me - thanks
-
- 1 reply
- 666 views
-
-
Hello, I have been using FileMaker for 12 years at least. We recently upgrades from versions 5 and 6 to version 7 (3 licenses on Mas OS X 10.3.5 and Windows XP home). I experience in various layouts and in different databases (upgrades from version 6) that letters are partially cut, alway at the right side. This happens as well with normal fields thans with the fields of envelope type (within brackets). For the last one, even if I add a space after the closing bracket, the layout and print problem is still there. The problem did never appear under versions 5 or 6 nor under previous versions. Can somebody help me? NomsProjets89.pdf
-
- 0 replies
- 684 views
-
-
FileMaker Dev 7 Vers. 3 Whenever I try to scroll through the records in a portal that I created, it seems to slide the frames of the first record in the portal over the rest of the recoreds. It is hard for me to explain, but I can provide a screenshot(jpeg attached). I have setup many portals in my app with no issue; however, no matter what I do to this portal, the first portal record in "drag-framed" over the rest of the records. Any help would be greatly appreciated.
-
- 2 replies
- 944 views
-
-
Hello there, I have a portal with 6 rows and I would like to have two buttons (previous/next)to jump six rows by six... like an internet page. I really appreciate if somebody could help. I'll be happy to receive all your suggestions. Sorry for my bad English. Thanks. French version: J'ai un portail avec six lignes et j'aimerai ajouter deux boutons (pr
-
- 6 replies
- 835 views
-
-
The problem I have just encountered is this. I'm creating a program to track my opinions of movies, actors and studios. I have a table for the movies, one for the actors, and one for the studios. I want to be able to enter the cast through a portal in the movie table. I can create entries in the actors table through my portal from the movie table, but the problem is that if an actor is in more than one movie there is more than one entry in the actors table. Anyone have any ideas as to how I should proceed?
-
- 6 replies
- 839 views
-
-
This seems like a basic problem, but I've spent hours trying to figure it out without success... Consider a basic invoice presented as a table with 3 records in it. Each record has several fields (name, quantity, price) separated from each other by a small vertical line, so as to have it look like a column. I would like to have the vertical line fill out the rest of the page all the way down to the footer (even thouth there are only a few records)... The more records there are the shorter the line... (in preview mode obviously) The strange thing is that I converted a friends FMP 5.5 file that did just that to FMP 7, and it does not work anymore... A…
-
- 8 replies
- 1.2k views
-
-
(Note: FMP6) I would like to build a layout that will put a sub-summary section at the bottom of the page like a footer. I am trying to make a form like report that has a list of items in the middle with information at the top and the bottom of the page. I would like the records in the body section to fill go to several pages if that is required, but on the last page put the sub-summary section at the bottom of the page. I have tried using portals, but portals are a joke for reports. They are fixed size and only print what ever shows. On the other hand using sub-summaries you get variable sizes but all the records get printed. I want my cake and eat it too.…
-
- 0 replies
- 859 views
-
-
Hi, I'm a newbie here, it's my first (and stupid I guess ) post... I have a list with names, the user must check the checkboxe(s) near these names. What's the simplyer way to grey out the non-selected names and checkboxes after the user leaves this field ? Thanks for your help
-
- 5 replies
- 841 views
-
-
There are 5 SETS of the fields shown on this capture (Excluding "TOTAL DUE THIS INVOICE" and "THANKS FOR YOUR BUSINESS) The intent is to let the user make an outline of costs using pull-down lists in the (Underlined) heading ("Creative and Production Services"), then entering a description of the costs in the text field below ("Agency consulting fee for Dec...") A row of repeating fields on the left (1000...) will be used to enter a Job Number where appropriate. A row of repeating fields on the right ($ 300...) will be used to enter a cost amount for that entry where appropriate. At the bottom, the (bold) heading now marked "accessible pow…
-
- 2 replies
- 1.1k views
-
-
Using MacOS X, FMServer Adv 7.0v2, connecting with FMDev 7.0v3 on MacOS X(different machine). I have a Name table and a Gift table. On my Name table's main layout I have a portal to Gifts. I want it so that the user does not see their own gifts. So I have the View privileges set to GetAccount(Name) != Name in the Name table (with the proper "doesn't equal" symbol) and I have GetAccount(Name) != NameTable::Name and IsValid(NameTable::Name) in the Gift table. If I view a layout from the Gift table, it works fine. The user sees all of the records except his own. But if I look at the Name table's layout, the portals are blank for every record. Here's the …
-
- 2 replies
- 630 views
-
-
Hello ppl, I need a Quicktime player on my layout which I can play a sound on. When I click in another field, where I want to put my data in, the sound stops. I don't know if I can still hear the sound while I am inserting my other data into the layout?? I found out that the sound will keep playing on a layout, even when I open another layout (where I can insert my data also). Is there any way to get the two layout in frames like html or something similar? Any other solution is also welcome. Greetings, Auditiaan
-
- 2 replies
- 885 views
-
-
Apologies, I'm new. I have a database in FM7. I would like to exclude some records from showing up in a portal, but have those records that don't show, appear in a portal on the same page. Basically, we send out STUDENTS assigned to a SITEGUIDE to make VISITS to different SITES, one table for each. Anyway, there are different kinds of visits, but they all are recorded in the VISITS table--each record has a VisitID, StudentID, SiteGuideID, SiteID (pulled from SITEGUIDE). What I want is something akin to 'Show all Visits except attribute:TypeOfVisit="Special" in the first portal; in the second portal show ONLY Visit records where attribute:TypeOfVisit="Spec…
-
- 2 replies
- 731 views
-
-
Hi, I'm working on a program for quoting. Whenever anyone quotes a product thats been quoted in the past I want to have a portal showing all the previous quote numbers for the product. I made a self join table and it seems to work great except that it shows the current record as well as the previous ones. Also even if a product has never been quoted in the past the table shows 1 entry with the current quote number. eg. Someone is working on quote 18050 for product X. Product X has been previously quoted in quotes 17865, 16555, and 18001. In the table I made to show previous quotes for the product it shows: 17865, 16555, 18001, and 18050 (but I want to exclude 1…
-
- 3 replies
- 704 views
-
-
Hi, I have a little database, which I run on Mac OSX - on a Powerbook.. i think it's 1168x9 - sorry can't remember the rest not near my pbook right now. Then I have a pc which i is 1024X768. Everything on the windows side appears bigger. to the point that what fit nicely on the mac os x screen in one page, now requires scrolling. how should I handle this so that I do not have to write a different layout for each platform? thanks, J__
-
- 0 replies
- 634 views
-
-
I am looking for a way to generate a value list based on the selection of a value from another list. Here's an example: Table::VEHICLE INVOICES Field::Vehicle_Type (Records=Focus; Escape; Ranger, etc) Field::Vehicle_Model (Records=ZX3 S; FWD XLT; Tremor, etc) Table::QUOTES Field::Select_Vehicle_Type Field::Select_Vehicle_Model When a user in a QUOTES layout selects a Vehicle Type (eg. Focus) from a value list linked to the VEHICLE INVOICES table, I need the Value List for Select_Vehicle_Model to populate itself from the Vehicle_Model field in the VEHICLE INVOICES table (eg. ZX3 S). Have I provided enough information for someone…
-
- 7 replies
- 1.5k views
-
-
I have a form type layout that I put fields on that align themselves with lines of text. They look and print great unless I print from another computer with possibly a different zoom level or if I print from a window platform. Is ther a way to lock the layout together so all the items stay in the same alignment regardless of zoom or platform?
-
- 1 reply
- 1k views
-
-
Hi, Me again In my filemaker 7 app, I need to manage shipping boxes and the content of these boxes. I want to display on a printout a list of Boxes and inside each of these Boxes, display all the Products that belong to it. I know the List part but it's not possible to have a List part into a List part (what I would want to do). Has anybody already encountered this problem? Can you give me hints to solve it? Thanks a lot!
-
- 3 replies
- 877 views
-
-
I'm designing a layout that is a sales sheet for real estate properties. Each property is unique regarding the content that I want/need to show on the layout. So, I've come up with a list of fields like: ACREAGE, PARKING, HEATING, ZONING... and so on. I want these fields turned on or off depending on if they are being used or not for that record. BUT I also want the TITLE of the field -- which is in a bolder version of the same font -- to be turned off also, PLUS I want it all to slide up accoringly and always look good. AND have the ability for the fields content to be long or short depending on the content. Please help. I'm new at FileMaker.
-
- 0 replies
- 742 views
-
-
I have a report with a header, body and footer. Header and footer work correctly. The body has a long text box and 2 picture containers at the bottom. The pictures slide up to adjust to the size of the text. The problem is that the pictures are sometimes split accross 2 pages. The user usually has to insert carriage returns to put the pictures on to the second page. Is there a way to put a page break right before the pictures so that the picutres show on the next page? Thanks. I'm using Windows 2000 with FM5.
-
- 1 reply
- 956 views
-
-
I have a transparent field with white text. The field itself is a pull down menu, but I notice that the pull down menu is always WHITE, meaning the text cannot be seen (white on white). I cannot color the field background, because it is on top of a gradiated image that needs to show through. Needless to say, the background image is dark. Am I missing something mighty obvious, or is this a rather slack piece of programming on FM's part? Thanks for sharing your expertise with me!
-
- 2 replies
- 807 views
-
-
Hi. I have a couple of different tables which have lists of items (records). I want to create one mega-report as a month ending summary. I am probably going to script the find that will return the period of time I want. But how do I make that happen for 5 separate sub-reports and then combine all those one-month results into one? I figured at first I could portal-it into a new layout but in order to do that I'd have to somehow create a relationship to a central table (which one doesn't exist). In MS Access I just inserted the sub-report, but I'm new to FM so I don't have a clue how to do it. Thanks.
-
- 0 replies
- 726 views
-
-
I have a self join table called banking which has two layouts, one layout is called "transactions" which lists transactions like a bank statement and contains and another layer "transaction detail" for modifying details. The portal displays correctly in transactions layout but I have added a button which has the value of go to related record. The problem is when clicking this button it just goes to the transaction details layout but it does not go to the record selected from the portal in transaction. I know this problem is related to the fact that this is a self join but im a little stumped on how to put it right. Any help you could offer would be very we…
-
- 2 replies
- 692 views
-
-
Hi, I have a field, which I need to have on the layout, but don't want my user to see. Is there a easy way to do this. ideally it would be nice if it only was hidden when the user is working with the layout at 'runtime' - but in design time (where your editing the layout ) have it display. what's the trick? thanks, sincerely, J__
-
- 8 replies
- 1.3k views
-
-
I still can't get my head around this. Could someone "cookbook" this for me? I get confused going to Define DB, Relationships, Value list, Field behavior, etc. I want to script/calculate which values of a ClassID (table of classes) will show in a drop down. Sometimes it will be only for a specific grade, sometimes All, sometimes, not yet assigned classes. [i've read most of the posts, here, but when I try it, nothing happens - I must be omitting some step] Thank you
-
- 1 reply
- 753 views
-
-
Hello everyone. I am a newbie so please bear with me. Here is my problem. I have a db called actor. It contains the actor name and gender (male or female). My goal was to display 2 portals (one male) (one female) where user could select actor or actress and then go to the corresponding record. Reading other post on this site i found what i thought was a great example of a self join that even i could not mess up (but of course i did). I created a field called gender with a selection of "Male" or "Female". I then created a g_male calculation field ="Male" and a g_female calculation field ="Female". Next i created a relationship Actors( i thoug…
-
- 3 replies
- 762 views
-
-
hi, I'd like to find out if it is possible to automatically select the next value in a value list through a looping script, in a similar way to the go to record (first/next - exit at last) options. I'd like to use this for my room bookings database. I have relationships set up to show if a particular room is unavailable at a certain date/time period and I would like a script to loop through the list of rooms, and copy the names of rooms that are available into a global. Thanks, PJ
-
- 1 reply
- 2.8k views
-
-
Post deleted by quillpro
-
- 2 replies
- 649 views
-
-
I am having a problem with a filtered portal in an app I'm developing. When a user creates a new record in this portal, FM over-writes the user-entered value in one of the fields (a field involved in the filter). I understand why it's happening, but I need to find a way to beat it, if I can. Here's the situation: I have a portal which users may filter by selecting a value from a pop up. That selected value is then used in the portal relationship to select only matching records. The pop up values are from a user-defined vocabulary, let's call them UserValue1, UserValue2, UserValue3, etc. I allow the user to select any one of those values or to select "All". …
-
- 2 replies
- 749 views
-
-
Hi Guys, I'm pretty new to FM and I know this subject has been discussed many times in this forum but I still can't find a clear example for FM6. All I want to be able to do is make a selection in List1 and the options in List2 change depending on what was selected. I can't find examples anywhere and i'm going crazy! ta in advance, Steve K.
-
- 5 replies
- 1k views
-
-
I have created a portal which shows details of ads booked for specific clients. ie the portal is based on a client relationship. I want to be able further filter the portal to only show records for each client between particular dates.
-
- 2 replies
- 698 views
-
-
Hi, Is there a way to remove the dotted lines around fields when they are modified with a script (or when you click on a part of the layout that is not a button)? I know that setting the fields "allow entry" option to off removes those lines, but I need the fields to allow entry.
-
- 1 reply
- 767 views
-
-
Hi, Am using GTRR script step, open layout in new window. While my issue has probably been addressed previously, I can't put together an adequate solution. I want my new window to open smaller than and in front of the existing window and have the existing window remain maximised. Does anyone know an appropriate script to work around the problem? Thanks
-
- 2 replies
- 1.1k views
-
-
I've an Order table with several Lines related to it. A Line belongs to an Order by using a relationship. I would like to make a print of this Order. I tried with a layout related to Order with 3 parts : header, body and footer. In header is all the information about the order (customer name, order number etc). In the body I want to see all the Lines related to this Order. I want this body to grow with the number of Lines. The footer contains the total price, rebates etc... This is really basic but it's not easy to do. But I'm unable to get that. Can you tell me how to do that? Thank you for your help
-
- 2 replies
- 867 views
-
-
Hey all: I want to allow a user to select a month, day and year from popup-menus to create a search date for a find. I want to display the month name as the selection choice, but want to pass the month number as the actual data entered into a global field for my calculation. I know how to display a second value in the list, but that
-
- 4 replies
- 731 views
-
-
Hey all, this is my first time posting, this is a very cool forum. my question is as follows I have a relatively large list of text items. (delimited by returns) and I'm trying to print as many as possible onto cd labels. is it possible to some how get two columns of the same text field? I've included my (2DAYS AMETUER)applescript I'm recieving the text from for giggles. if anyone could help, it would be greatly apprecieated. thanks matthew aidekman -- choose folder to index on open these_items set theFolder to (item 1 of these_items) tell application "Finder" -- get the name format---------------------- set theName t…
-
- 1 reply
- 846 views
-
-
I'm developing a system, have 2 portals on a screen, and need to copy data from one portal to another (Purchase order request Line items (POR) to Invoice Line items). I have a global field to input all the POR portal data into which I then parse into the proper fields for the Invoice line items. The first row goes across properly. I then "Go to field" in the POR portal and try to set the proper portal row by a calculation, but the Invoice Line item portal remains active, and the set field calculation for the global parser reads the first line of the POR portal. Any ideas are GREATLY appreciated. Systm info: Mac OS X.3.5 FMP 7.0v3
-
- 4 replies
- 967 views
-
-
Ok...on many of the sample files that I have looked at here at FMForums I have noticed that sometimes the part name of the layout is vertical instead of the standard horizontal. I like the vertical style much better (provides a cleaner looking layout in design mode) but how on Earth can I set the part names to be vertical? I am most likely missing something very simple.
-
- 2 replies
- 834 views
-
-
I love the FMP7 feature of layouts that do not immediately save, but hate that it prompts you every time you click outside a date entry box, instead of just when you try to leave the record/close the window. Basically, when a user is about to leave a record, I need to offer three options: Save, Revert, and Save with Version Update. The last option has some housekeeping routines attached, and rely on a user choice to know which to run. Easy enough to script, but the problem is that REVERT only works when the layout is set to *not* save immediately, but then the problem is that whenever the user clicks outside of a data entry box, Filemaker automatically offers up…
-
- 0 replies
- 747 views
-
-
FMP 7, Mac OS X: I am trying to create a value list that is made from field "source" in table "a", which is then sorted according to field "sort order" also in table "a". I have created a self-join relationship "SELF_CONSTANT" from a global field "gCONSTANT" in table "A" that relates to "CONSTANT" field in table "A" and ensure that gCONSTANT has the same value as CONSTANT in all the records. The relationship has BOTH "Sort records" checkboxes checked and "sort order" field selected as to how to sort. Then the value list is created from he field "SELF_CONSTANT::source". Most curious is that a resulting popup menu using this value list has the values from "source" f…
-
- 2 replies
- 681 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online