FileMaker Interface Features
-
Hi All, Ok.. I want to make my new database easy for admins to add/remove value lists as products change or grow. Typically, I would just make Value Lists and enter in values there, but for future use, they are tough to edit add/remove items as things change, So this time I am making a "setup" layout that they can enter in values via portals of common items that can then be used later as value lists. My dilema is that I have roughly 20 values lists I would like to create.. so do I make 20 databases with the list items for each, or one database with all the value fields for everything and then in the setup page, just filter the records to those with the data…
-
- 1 reply
- 915 views
-
-
Hi. As part of my database, I have a photo field. My question is: Can i add a field that automatically shows to name of the attached photo file? Thanks
-
- 1 reply
- 1.1k views
-
-
I have a dwindling value list I created ( see attachment) which appears to work but if I make some changes the value list does update straight away (as least on fields where a change has be made). I guess it is an indexing thing. Any ideas around this? thanks the test file is pretty straight forward. cheers dwindling VL test.fp7.zip
-
- 1 reply
- 975 views
-
-
Fairly new to the understanding the web viewer. I have a website field on my customers layout, where a user can enter the website address. There is a button that launches the web viewer on another tab so that one can look at the customer's website. I just found out that Filemaker needs the "http://" to be part of the address for it to work on a mac, so I created a check to see if it is there, and if it is not it adds it, but why do I still get "http://localhost/" when trying to load it?
-
- 0 replies
- 1.9k views
-
-
Hi All My company are still in the process of migrating from FM6 to FM11. We are currently in the process of double entry testing - we have selected users in the office who are doing their daily jobs in FileMaker 6 and FileMaker 11 to test everything behaves as it should do. However there is one small thing which is causing our users problems... In the Window menu in FileMaker 11 it shows the name of the server the file is being hosted from in brackets. This means that most of the actual file name is obscured - this causes particular problems as we have a large number of files (125) a lot of which have similar names. This means that users may have to click on 3 …
-
- 2 replies
- 1.7k views
-
-
Hi Is there any way to link account details (set up in Security) to a layout form in the database so users could update their passwords and low level administrators could update passwords and usernames. Rather than go through the menu path. Also for full administrators to add new users. Thanks in advance Cheers
-
- 1 reply
- 1.1k views
-
-
Hi I have set up a tab panel with 5 tabs - Tab A, Tab B, Tab C, Tab D and Tab E I have 5 buttons running at this stage off 5 individual scripts (very basic) Scripts- (each individual) Go to Object [Object Name: "Tab A"] Go to Object [Object Name: "Tab B"] Go to Object [Object Name: "Tab C"] Go to Object [Object Name: "Tab D"] Go to Object [Object Name: "Tab E"] Go to Object [Object Name: "Tab F"] and so on for each tab. The buttons then reference each tab with their own particular script. However the navigation works fine for Tab A and Tab B but won't work from Tab C onwards. Also to further cloud the problem if I change the "Tab A" name to …
-
- 1 reply
- 2.2k views
-
-
I am trying to create a portal in a standard form view that shows a list of all the records from the same TABLE. Therefore I have a table called INVOICES. In form view I have my Invoice layout, and that generates new Invoices (records). I want to see within this Invoice layout a portal listing of all these records (Invoices). Obviously not all the fields, just a short hand reference like the kp_ID and the client name. Currently I have to 'go to layout' , list view, to see a list of these records. It would be more convenient to have this list within the form layout. Is this possible? My setup follows the kp and kf protocol. Thanks Matthew
-
- 0 replies
- 719 views
-
-
Hi, new to Filemaker and these forums. I'm using Filemaker 10 Advanced. I have a conditional value list in a drop down that works great in Filemaker; however, when I tried to use the conditional value list through the web published version of my database it no longer works (that is, the conditional list is just empty). I guess this is due to the selection being local to the web-browser and not sent back to the server, so a related value list cannot be constructed for the secondary dropdown. Is there a way around this in the web interface? Can I fire off a script or something to get the related value list? Thanks
-
- 1 reply
- 927 views
-
-
I know I have done this in the past but can't find my notes. Is there a simple method of displaying the running count of records grouped by category and resetting each time category changes. i.e. DVD's grouped and sorted by category and title. Want the count to reset to 1 each time a new Category is displayed. I realize I can create a Script to run each time I use the report and create a field which is updated with the appropriate number but wonder is there an easier way. The option of using "Restart Summary for each Sorted Group" on the Summary field does not seem to be available.
-
- 1 reply
- 1k views
-
-
Hi, Is there a way to get a list of what is in a portal that uses portal filtering? Relation ship will not wok because this is a calculated field that cannot be indexed... tnx
-
- 2 replies
- 947 views
-
-
I would like to create a list of documents (within an established database), similar to what would be seen in Excel, as follows: the first column would be dates, the second the name of the document (hyperlinked to the corresponding file on my machine) and the third column would be a memo field. See attached image. Can I do that in FMP? I would like the list to be sorted by date, if possible. Thank you, Norm
-
- 8 replies
- 2k views
-
-
Hello everyone, I 'm not quite sure if this is the appropriate section of this forum, but I have the following question. I have built a medical database and in the report layout it has various objects (rectangular boxes for different sections, such as history, medications, complications etc) which contain all the available information about a patient (either true or false). My concern is that this kind of report is too lengthy (e.g. it needs approximately 20 pages for printing). This is a kind of extended report which I want to include in my database. I also want to create an abbreviated report based on the previous report which will only contain my true values (e…
-
- 1 reply
- 878 views
-
-
Hello all, I am a beginner to Filemaker Pro and hoping for some advice. Also, apologies if this has been addressed already. I'm creating a survey database for school based health centers; this survey is meant to either be filled out by students on a computer, OR enable a research analyst to quickly enter the data from paper based forms. After reading several threads on this forum about survey design, I think I have a decent model (please see attached). As depicted in the diagram below, I have split the relationship graph into two components. The top half in yellow represents survey responses with unique combinations of questions and responses. The bottom blue-gre…
-
- 0 replies
- 1k views
-
-
Good Morning, I'm trying to put together a layout that will allow end users to select items to be printed in a report. The selections are laid out hierarchically, and there will eventually be several hundred choices, so the best format would be an expanding tree structure with checkboxes to allow someone to select an entire directory or expand it out and only select certain pieces of equipment. The structure may rarely require going down as many as six levels, although most often the user will only be drilling down three or four levels for the report. I did a quick Google search and came up with a few older postings referring to a Multilevels example found on fusi…
-
- 3 replies
- 2.4k views
-
-
Hello Everyone, I've got a question about value lists and haven't been able to find a definitive answer searching here or elsewhere. I've got a database for tracking the recruiting of research participants. Each participant gets screened to see whether he or she is eligible for a research study, so there are several tables: a Screening table, with fields for the person's answers to the screening questions, and several tables that allow for multiple answers to a screening question. These related tables are Medications, Medical Conditions, and Illegal Drugs Used. I'm trying to refine a system for tracking the reasons that a participant may be deemed ineligible fo…
-
- 4 replies
- 4.5k views
-
-
Hiya, I have created a Runtime running in Kiosk mode. When I run it, the rest of the screens (two screens) go black. This means the user can not access anything else on the desktop (not related to the Runtime Application) whilst they are using it. Is this normal? What I would like to see is the application in its "popup" window sitting on the desktop with everything else on the desktop visable. Am I missing the point of running in kiosk mode? Cheers
-
- 4 replies
- 1.9k views
-
-
Is there someone willing to help me figure a solution to get a report designed like the one I have attached. It is based on 4 tables and needs to be easily produced every day by novice users. It is a daily job sheet for my crew. The description field in the JobLineItems table is sometimes lengthy so I am trying to base the layout on this table so I can incorporate sliding. When I try to use the Jobs (parent table) with a portal based on JobLineItems I have to make ALL of the rows extra large to anticipate only a few lengthy descriptions. Other problems are how to easily produce the essential criteria for the report which is the SheduleDate field, ScheduleFrom field, Sched…
-
- 6 replies
- 1.2k views
-
-
I have built a calendar in one of my databases that needs to be in Preview mode with printing 7 rows across for it to layout correct. I would like a view it on my ipad through filemaker go and as we know you can't view in Preview mode with Filemaker Go. does anyone know how to layout records in Browse mode across and down. I'm guessing the answer will be with portals and record repetitions. I just can't get my head around it thanking you in advance (a template is the easiest way to explain to me but i'll take any advise)
-
- 1 reply
- 872 views
-
-
My users would like to be able to use the mouse scroll wheel to scroll vertically down the layout instead of scrolling through records. Is there a file option or a FileMaker preferences option to achieve this? I've read that this might be possible by hiding and locking the status area, but ideally the users would still have access to the Status Area and while being able to scroll down the layout using the mouse scroll wheel. Edit: I just tested the hide/lock status area. It does prevent scrolling to the next record but you still can't scroll vertically down the layout. Thanks
-
- 4 replies
- 3.1k views
-
-
I am attaching a sample file to try and show what it is I am trying to accomplish. In the sample file I have 4 tables. Vendors, Products, PO and PO Line items. The goal is to have the product id list in the portal on the purchase order show only the products for the vendor the po is being created for and not all the products for all the vendors. Currently the popup menu list all the products from all the vendors. Any help getting this correct would be greatly appreciated. PO_test Copy.fp7.zip
-
- 5 replies
- 1.3k views
-
-
I have a layout that has three levels of conditions. The first level is "related to", the second level is "job number" (which is conditional based on selection of the first), and the third is "hull" (which is conditional based on the second). The first and second work great, however, the third only works halfway. This is basically setup as a filter. There are four options in the first level: related to - "vessel", "overhead", "warranty", "facility". Once one of those items is selected, the second level "job number" is filtered into those four categories for selection. Once the second is selected, I need to third level to be a constant and not a selection. There is …
-
- 6 replies
- 2.9k views
-
-
The idea is that IF a field has content, its name does no longer appear in a value list. For example, if the field "Organization" contains a value, the string "Organization" needs to be omitted from the choices in the value list. Here's the stored calculation which I'm using to create this dwindling list: Substitute( "Location¶Insured By¶Main Artist¶Organizer¶Curator¶Other¶"; FilterValues ( "Location¶Insured By¶Main Artist¶Organizer¶Curator¶Other¶"; Case(IsEmpty(Location); ""; "Location¶") & Case(IsEmpty(Insured By); ""; "Insured By¶") & Case(IsEmpty(Main Artist); ""; "Main Artist¶") & Case(IsEmpty(Organizer); ""; "Organizer¶") &a…
-
- 9 replies
- 1.8k views
-
-
Here's what I want to do: I want to create a list of items for a user to select from. As an example, it's a list of pies: pumpkin apple rhubarb lemon key lime I was going to use a checkbox list for selecting them, but I want to be able to select one of them more than once. For example, I'd like to choose 'apple' twice and 'lemon' once. Naturally, a standard checkbox list doesn't quite work, since it only allows for each item to be selected once. Also, I'd like to be able to add an entry. I know there's an option for that, but the implementation is odd. I'm wondering if there's another method. Currently, you select 'other' and put it in the pop-…
-
- 12 replies
- 6.7k views
-
-
I am trying to toggle a color of a label based on if a field is active or not. If I made and edit I am fine but if just tabbing through field without any edits no luck, any suggestions
-
- 12 replies
- 2.6k views
-
-
Hi all, I have a question where I can't seem to find a proper solution. I have my fields: product item, quantity quoted, quantity worked. Now these product items can be selected by the employee on a per project basis. This works fine, however where there are multiple of the same product item and I link it to the selected item number, the quantity quoted will be correct, but the quantity worked will be the same number per line item. I hope this is not to confusing. So what I want to do is the following: - if a product item already exists in the portal (duplicate of the same item within that project), I would like to display the sum of the quantity. S…
-
- 0 replies
- 1.3k views
-
-
Hi Filemaker Gurus! I have an OutsourcePrice field, a MaterialCost field and a LabourCost field all on the same table. How do I set up a condition that if the OutsourcePrice Is not empty, then the text color in the other two fields changes from black to a light grey? I want the user to be able to see what our cost was (in light grey text) even if we end up going with an outside provider for the product, and have a price entered in the Outsource Price field.
-
- 20 replies
- 4.1k views
-
-
Hi there. I was wondering if it is possible to add two unrelated fields into one value list? I want to combine my supplier emails (Supplier table) and my customer emails (Customer table) into one value list, example value list called email address... Any ideas or comments?
-
- 1 reply
- 1k views
-
-
This is under FM 11 ADV When SET STATUS is OFF: When SET STATUS IS ON: When in LAYOUT mode: Has anyone experienced anything like this? The area in yellow 'expands to overlap the area below. Weird... What am I missing? Thanks
-
- 4 replies
- 1.1k views
-
-
Hi there, In my solution I'm working with several portals. In these portals the users can click on a little green + icon in a portal row to go to a new layout and add a record. But always is there an extra row visible in the portal. It is not a related record. The key field is the <Nummer> field. Portal Filtering (Nummer > 0) is not working either. I think thats because it is not a record. I'm confused. Is there a way to prevent this? Please advise. Kind regards, Adri
-
- 3 replies
- 1.9k views
-
-
My situation is as follows: Table A contains data imported from excel into filemaker. I then use table B through a relationship to add data to table A after which a script will run to export data from A into another table. The problem I can't solve is if the related field has no match in table B no data will be added to table A. I'd like to be able to show the records from table A which have no match in table B based on the relationship in a portal so I can then choose which of this I should add to table B so for future use these records will be related. So actually I would like to show the records which are not related, based on the related field. All help ap…
-
- 18 replies
- 3.7k views
-
-
Hey all, first post. I am a novice filemaker user since I had to construct a series of databases for my employer. I don't know too much but I learned enough to make databases that worked well. I come asking for help. On one of my layouts it needs to be trimmed so that multiple copies of the layout can fit on one page. However, some of the fields may have more entries than allowed. Is there a way to make the field spill over into another field right next to it, and if so, how? I guess a two column approach would work the best, but how do I get it so that it won't repeat the values, and instead continue from where it left off?
-
- 10 replies
- 2.7k views
-
-
I have 5 layouts. 4 of the layouts 'can' access layout #3. I want Layout #3 to have a "RETURN" button that when pressed, takes the user back to the 'original' layout from which they came. Seems like GOTO LAYOUT ORIGINAL should do that? I created a button and in Button Setup specified Goto Layout - Original. It does NOTHING. So, I wrote a script and put GOTO lAYOUT -ORIGINAL in the script and hooked it up to button. I tracked it in debug... it executes but goes NOWHERE. (Yes, all the layouts are checked in layout management) There are no error codes. Got ideas? Thanks
-
- 2 replies
- 1.6k views
-
-
Hi there, Again a little issue here. I'm sure that the solution must be simple but I was not able to find it. This is the case: I have a portal in wich documents (pdf files) are added for archive purposes. It is possible to open the document by double clicking the field with the program specified in the system preferences. The field must be in browse mode for this action. In this case it is possible to erase the field content and that is what I want to avoid. Users clicking the field must not be able erase the fieldcontent. I've tried to make a button out of it but then it won't open the document. Is there a way that users can access the field to double cli…
-
- 2 replies
- 1k views
-
-
On a given layout we have a tab tool with six or so tabs. Operators will often flip to a different layout (script driven navigation)and then come back to the original layout with the tab tool. Each time they return to the original layout the tab tool resets itself to the default tab. Is there a way to make the tab tool recall where it was left and stay there? Maybe setting a global variable by script somehow? Thanks for any suggestions.
-
- 8 replies
- 3.9k views
-
-
I have a file with about 1000 records. Upon going to certain layouts I get that hour glass icon while the records are being sorted... Also while opening the file or updating records via script I get a coffee icon. Could those be replaced with a progress bar? No idea about this, or how to go about it if possible. Thanks.,
-
- 9 replies
- 4.6k views
-
-
Ever put a web viewer on a layout and had users complain when they scroll thru the records. Does it bog down your system with lots of unneeded requests for web pages that you don't need (at least at that moment) Well, I have. This is the solution I came up with and I thought I would share. (It's only fair, It is peiced together from stuff I learned right here on FM_Forums.) The solution Uses a Logical function in a web viewer to either display, or not display the web page and show Custom Messages in the web viewer saying why it isn't displayed. (sample uses USPS.com to standardize addresses using an address, city, and st, included is a script that will update/enter…
-
- 2 replies
- 3.2k views
-
-
In the attached file, a project can have multiple machines and a machine can have multiple issues. I am using issues portal on project layout to collect machine issues data. But in project layout i can not select particular machine from machine list (or from machine list for a particular product). Any recommendation on relationship between project, machine and issues list table is appreciated. test.zip
-
- 5 replies
- 1.7k views
-
-
Trying to calculate the number of portal rows displaying in a filtered portal. Note that this is for a script calculation, not display (i.e. displaying a summary count in it's own one-line portal is not my answer in this case) The reason I am trying to do this is: layout has an instant search field for a portal of related records (uses filtering to search), and when a search returns only one record, I want to automatically switch to an editing layout. The many wise ones here may well have a better approach! Thank you! Juz
-
- 10 replies
- 5.2k views
-
-
I have a value list called PLAYERS that is populated with the following custom values: Architect Contractor Cabinetmaker Electrician Painter I have two fields: People who should be notified People who have been notified These two fields are displayed as checkbox fields using the value list PLAYERS I would like to have a third field that just displays a checkbox list of the Players who NEED to be notified. Any way to do this?
-
- 1 reply
- 1.7k views
-
-
Hello Everyone - Long time listener, first time poster. While I've been a Filemaker end-user for years, I'm just now getting around to developing my own custom solution. I'm self teaching via John Mark Osborne's (excellent) VTC video tutorials and I have a two part question that I hope someone can shed some light on. The project is pretty straight-forward invoicing solution with a few twists: I'm developing a solution for a bakery to help manage kitchen production. The bakery takes ORDERS from CLIENTS on a weekly basis. Each order consists of multiple LINE ITEMS, indicating a particular ITEM to be baked, the quantity, price per item, and delivery day (Mon, Tues…
-
- 2 replies
- 1.6k views
-
-
Hi all I am trying to replicate the native Filemaker status bar. Two reasons for this. My aunt who I'm developing the database for wants certain extras on the toolbar and I have used an archiving system that makes the found set and total record data inaccurate. I am having trouble with two things: (1) Disabling the small toggle status bar icon in the bottom left corner (2) Replicating the green found set pie chart I have tried creating a chart using my total live records calculation field and my total found calculation field. In value data I have specified the two fields aforementioned and set use data from current record. No chart displays, …
-
-
- 7 replies
- 2.8k views
-
-
I am new to FM and I have been reading tutorials and trying to learn how to build a database. I understand databases and the general workings of FileMaker, but I have a few questions. Attached is an image of the very basic layout that I am trying to create. I want to be able to organize all my clients, and to be able to access the different groupings of clients from a navigation menu. What I do not understand is how to create this menu. As I understand it I will need to create a different layout for 'Active Clients', 'Potential New Clients', 'Archived Clients', 'Wholesale Clients', and 'Media Contacts'. These layouts will display only records that fit that client sta…
-
- 8 replies
- 1.9k views
-
-
Hello, I have been literally beating my head against a brick wall over my portal! I have my main client layout and within that I have a tab and within the tab have a portal. I have made this so that my staff can enter payment information into each field within the portal for each client. So that if that client rings up we have infront of us thier payment history. I then want to export this into a layout I have titled 'cashbook' so that I can view all payments made on any specified (searched) day. Now this is where the problem is: I have created a client cal Non Account - for all payments made by non account holders. When I look on the client…
-
- 11 replies
- 3k views
-
-
I've got a single Filemaker database that contains tables for supporting three separate but business-related databases, Loans, RMAs and Rejects. (This also links to a number of other legacy databases which support other aspects of the business.) I present these to the user in separate windows, so they see them as three discrete databases. I set the windows up with a set of script steps which test to see if the desired database is "open" and if not, set it up in it's own named window, then select an appropriate layout for that database. This works most of the time, but now and again the window 'disappears' from the window list. In the attached example, yo…
-
- 1 reply
- 727 views
-
-
HI I was wandering if a portal or script could achieve the following, this is a cut down version of what i want to achieve. I have 3 tables Dongles, Product, Deliverly, From an excel sheet we import into dongle table which has an SN, and Sec and other options related which is no problem. The product tables is where we would list the create a product code and whats needed for that product, which is basically the information from dongle table SN and SEC and options. in this case its ive called this rip options The delivery table is where they should come together, by selecting a product code list the options needed are displayed under rip otions,…
-
- 0 replies
- 777 views
-
-
Dear All, I dont know whether it is very easy task but i am not aware about this fact so sorry if it is common and easy task. My query is when we create the custom menu how can we disable or grayed the submenu option. for more clarification please see attached screen shot. Here in picture i want to disable "Admin" submenu from file menu in certain condition like according to user type it should be disable or enable. Lots of Thanks,
-
- 3 replies
- 3.4k views
-
-
never mind. Question: "Isn't there someway for a poster to remove a posting?"
-
- 0 replies
- 763 views
-
-
Any ideas? It looks like a portal of two tables. How are the two tables displayed in one portal? Thanks.
-
- 5 replies
- 1.8k views
-
-
Using FM 11. Is there a way to filter a portal through a script so that I do not have to make copies of the same layout for different filter conditions. Example: I have student grades and each grade has the term (grade year) so that I can select each years grades separately. But, I have to make the same layout for each year because I filter the portal on the layout. I would like to script it and use one layout rather than so many layouts (as I am using now), if possible.
-
- 2 replies
- 3k views
-
-
Can anyone tell me how to control the width of a drop down list? I have a DD list that drops down from a semi hidden field (1px wide) that always truncates anything more than 7-8 letters long. I'd like to find a way to control the width of the list so it could display something like 20 characters. Anyone know how to do this in FM10Adv?
-
- 3 replies
- 1.8k views
-
-
Hi all, I recently saw a solution that enabled the user to create their own letter templates. The user could also add various merge fields from a list on the right hand side to the body of the text and then save the letter as a template. Then when it came to printing a letter to a contact in the database, the user has a choice of previously saved templates to send to them. Unfortunately this solution is locked and I can't see how it is done. We have a need to create different types of letters all the time and so have a huge list of different layouts for each one. It strikes me that using a letter template, you could have just one layout which changed according …
-
- 4 replies
- 1.5k views
-
-
Hey, In my database table, I have 6000+ records from four different years. I have created a data entry layout to display this data and also edit/enter new data. I would like to display only records of one particular year at a time. Very rarely a user goes back to viewing previous years' data. Hence, I would like to display 1500+ records of the current year and then if the user wishes (say changes the value of an input field) then I would like to display other records. Is this possible? Can you please tell me how can I implement this in FM Pro 11? Thanks,
-
- 1 reply
- 629 views
-
-
Hi there ! I have a database of items I have in stock with a reorder level field and a database of purchase orders. What I want to do is when I create a new purchase order, all the items that need to be reorder appears automaticaly in the new purchase order. Is it possible to do this with portals ? Thanks !
-
- 5 replies
- 2.3k views
-
-
OK. So I have been working on a db that tracks an event that my church puts on every few months. I have the basic structure set up thanks to "comment". And maybe you can help me with this one too. I have a table set up that contains all the people in my db (I called it tblPeople). I also have a table set up for the events (called tblEvents). Additionally I have a table that contains all the registrations (tblRegistrations). This table allows me to chose a specific event for each person to form a registration. This registration also allows me to pick a role that the person who I am registering. We have a role that is called guide and if a person is a guide, they have other…
-
- 1 reply
- 1.5k views
-
-
I am trying to create a relationship that is based on a partial text string match found anywhere in a word. For example, if I enter "in" I want to see the following results in my portal: begin inning spin winning Can this be done without using portal filtering?
-
- 0 replies
- 831 views
-
-
Hi everyone I am a verry big noob when it comes to filemaker pro 8 advanced and I need some help. The problem is: I have a table called hardware and a table called software. In my software table there is a field called: computers. I want the computer field to be a value list with a condition. My hardware table has records for not only computers but also for peripheral devices. So my question is how would I make a value list that does the following: if (Hardware::Category; "Server") or if(Hardware::Category; "Laptop") or if(Hardware::Category; "Desktop") then show the value list of Hardware::Name in my software::Computers field. How would I do…
-
-
- 7 replies
- 3.7k views
-
-
I have some funky behavior with the FMP 11 Advance icon. It often displays the icon from another app (see attached). I think it is quite bizarre. Anyone have any idea why this is happening and how I can get it to stop?
-
- 1 reply
- 1.6k views
-
-
For some reason, I cannot add borders. When I check the boxes left right top and bottom it doesn't show any borders. Also, when I click in a field in browse mode it doesn't show the cursor, text selection or anything I am typing in there. I have to click out of the field to see what I typed... Also also, when in layout mode, when I select a field to move I don't get the border and little resize things in the corners. Anyone seen these issues before?
-
- 10 replies
- 1.9k views
-
-
I just got Filemaker Pro 11 Advanced for my business. I have created three Databases: Inventory, Contact Managemet, and Purchase Orders. I need my purchase orders to take from Inventory and update the stock level. I need the bill to (address, city etc etc) information to be chosen form my contact management list. Can someone help me provide step by step instructions for these tasks. I have seen other topics relating to the same thing but for some different uses and I know there are steps i am missing. Step by step instructions would be very helpful. Thank You
-
- 0 replies
- 889 views
-
-
I'm working in FMP11 Advanced on a Windows 7 client, working on a set of server hosted databases. I'm using a generic print system where I put the page to print into a new window, and control page preview using a small preview control window with controls to browse pages, scroll, print and so on. The preview control window is presented with a pause/resume indefinitely script set in a loop construct with Allow User abort off; this means that this window will stay at the front and not allow direct interaction with any of the windows underneath until the user presses a button set to halt the current script when clicked. Well so I thought - it turns out that you can…
-
- 0 replies
- 910 views
-
-
I have a list of contacts and I have a portal that lets me enter the first initial of person’s last name into a global field to filter the results. This is fast and works great but if the field is empty it breaks the relationship. Is there a way to have maintain the relationship and show all contacts if the field is empty? I realize that there are portal filtering and find and replace workarounds but I am trying to find a way to do this with a regular relationship.
-
- 2 replies
- 1.3k views
-
-
Does anyone know where I can get a FMP reference file that provides the 'button corner's, ' box corners'....etc...? I have a memory that FM used to offer this but I can't find it now? Thanks
-
- 2 replies
- 1.3k views
-
-
Hi guys, Sorry if this is a stupid question.... Im one of those newbie guys that has designed some fairly cool databases but only from trial and error mostly. I look to you guys when I simply cant figure it out. I've searched around and cant find what Im looking for. What Im doing is a database for my photography business. I want to be able to have the database open while Im shooting school photos of students. Prior to shooting the photos, the students will be inputing information into the database such as name, address, phone number, etc. After shooting the photo, I would like to be able to go to the image file and somehow put it into the database as a referen…
-
- 8 replies
- 2.1k views
-
-
I have a database (OS X FM 11 Advanced) I am working on for a personal business and have a complication that I need some assistance with. Here are the tables: Customers -> stores customer contact info Prints -> predefined artwork prints with inventory for sale for any customer Custom -> artwork that is custom based on customer input that is tied to one particular customer Invoice -> invoice sent to a customer for artwork (both custom and prints) bought Invoice_items -> each line item to be added to the invoice total On my Invoice form, I have a portal tool that links to invoice items. In the portal tool I have a dropdown to select ar…
-
- 2 replies
- 1.4k views
-
-
I have two tables, WORD_FILTER and WORDS: WORD_FILTER: 87 records WORDS: 345,000 records The WORD_FILTER database has the following fields: id_word_filter max_length max_syllables filter_prefix filter_suffix found_count The WORDS database has the following fields: id_words fk_id_word_filter word length syllable_count I need to filter the "WORDS" portal by defining the following fields with something like this: max_length = 12 max_syllables = 2 filter_prefix = re filter_suffix = ing So in this example I need the portal results to show me all words that are: less than 13 charac…
-
- 2 replies
- 1.3k views
-
-
I have just made my first foray into conditional value lists which seem to be working ok when I add a new record. I select a value from the first field which then gives me the correct options on the second field and so on for five consecutive fields. My little problem is that in find mode when I select a value in the manufacturer field I am given the correct values to select in the model field but after that the next three fields have no value in the value list. Because it works fine in browse mode when I add a new record, should I expect it to work the same in find mode?
-
- 1 reply
- 1.4k views
-
-
-
Level: Beginner OS: Win 7 X64 (not listed in profile options) Hi everyone. This is my first post and I'm rather new to FM so I apologize in advance if my question is very basic. I'm trying to create a drop-down list with a value list based on IDs and always showing the corresponding name (not the ID). However the ID must be finally stored in the table. To do so, I created a value list with the first field referencing to the ID and the second field referencing to the corresponding name, showing values only from the second field. Back to browse mode, clicking in the field shows indeed the list of names (OK) but once one name is chosen it then s…
-
- 8 replies
- 15.1k views
-
-
Hello, I am trying to acess data from a table at one end of the relationship through a portal to a table in the other end of the relationship and I don't know how to do it. TABLES Action table: __kpActionID Action Staff table: __pkStaffID DepartmentStaff JobTitleStaff NameFullList ... Appraisal joint table: __pkAppraisalID _fkActionID _fkManualID _fkStaffID JobTitleStaff DepartmentStaff Manual table: __kpManualID _kfStaffID ... Procedure table: __pkProcedureID _fkManualID ... Relationships In the Manual table layout I have a tab named Appraisal where I…
-
- 0 replies
- 822 views
-
-
Hello, Basically, I want to use the same source of information in two places on the same layout but with different meanings. I have the following TABLES: Document table: __kpDocumentID DocumentTitle DocumentVersion DocumentCode .... Location table: __kpLocationID Location FunctionalArea ... LocationDocument table: __kpLocationDocumentID _kfLocationID _kfDocumentID Relationships: Location -< LocationDocument >- Document In the Document table I have two tabs one for Document Communication and another for Document Location. As stated before, my objective is to use the information in the …
-
- 5 replies
- 1.4k views
-
-
I have two tables in one file. I created a huge number of fields in table "b". And now, I need these fields in table "a", without records. I only need these fields in table "a", I do not want to create these fields again. Is it possible?
-
- 3 replies
- 991 views
-
-
In My Fm 11 version having no option to create a custom menu set. Please any one can share your experience to show this option. please refer the attach file.
-
- 1 reply
- 1.7k views
-
-
Is there a simple fix for a zero value that keeps displaying as "$1.00"? All of my fields are rounded to two decimal places, but when I type in a "0" in one of my fields this particular calculation field I have displays it as "$1.00." I have played around with the round function, to no avail. Any other ideas?
-
- 9 replies
- 1.4k views
-
-
Hi, I'm sure this has been asked many times, but I haven't been able to get my head around the answers in other posts. Here's what I need to do: I have a CONTACTS table with a client type field, eg. Supplier, Intermediary, Customer, etc. What I want to do is create a value list that only shows the Contacts tagged as Intermediaries. How do I go about doing this? Thanks in advance!
-
- 6 replies
- 2.3k views
-
-
Hi ! I'm editing an old FM database. I have done this originally with FM6 (or FM7). I had to add more "boxes" to the layout. You can see the window in this link: Each of the 20 boxes are portals showing data according the Call Sign on blue box. The setup for each is identical. I have just made the relations according the box number. You can see the layout here: For some reason some of the portals doesn't work. I have checked and again rechecked the relations and they are ok. Box number 14 doesn't show any information. The fields inside the portal 14 are brought to the front in layout. So is there a limit how many portals can be used on one layout ? Or w…
-
- 11 replies
- 1.8k views
-
-
Hi! I have a portal showing records of Contacts, where the filter criteria are: - The contact is specified as an Ongoing Pledge (OGP) donor; - The most recent donation from them was NOT received in the current month. This displays a list of all donors with outstanding monthly donations for THIS month. My filter criteria seemed to work fine and list the right people, however I saw that after I added any donation for someone in the list - even one that was not dated in the current month - their name gets removed from the portal. Yet the criteria for the filtering would seem to indicate that they most definitely should still be listed! And indeed I want them…
-
- 6 replies
- 2.3k views
-
-
Hi There -- I have a products table with a products detail join table, with a "product key" tying them together. I am trying to get a layout working where I can have multiple products on the page (six on a page, in my graphic example). I am very well aware of portals and relationships, but the hitch that I have is I want to have different positions for the record information. In other words (refer to picture for clarification) -- basically have a product name (heading) and then a portal to the product info, and have a picture on the (right) or (left) of the portal. I tried numerous variations on "GetNthRecord", but altough it would work fine with a full…
-
- 1 reply
- 706 views
-
-
I've created a really basic 'Gender' drop down list with custom values 'Male' and 'Female'. Why can't the user drop an item from the list into the associated field? I can highlight 'Male', for instance, but it won't go into the field. The field has a default setup, ie: it's marked to accept data entry in Browse and Find modes. Every drop down list, in this particular db (my first in v11), acts in the same way. I have tried switching to pop up menu (ppm) and, whilst that worked, it altered the look of the field. The fields are 1pt embossed, grey fill with black line applied – with standard fields and ddl, I see what I want, a grey field with 1pt emboss (no black…
-
- 15 replies
- 3.2k views
-
-
Have looked around but not seen anything that seem to cover this. Question I have is: I want a value list that has a bunch of titles that a user can pick to enter in info on that title, but I want that title to disappear from that value list if it has already been chosen. So only that titles that have not been chosen show up in the value list till they are all gone. Is this possible? Thanks in advance!!
-
- 2 replies
- 980 views
-
-
Hello, new to filemaker 11 and stuck with this: i have a LIST_orders layout here in are the fields orderid, productnr, productname, orderstatus, price what i want is that when i take a look at the layout List_orders that the complete records have a conditional format based on the value of the field Orderstatus for example when the status is backorder the whole row colors yellow, when it has the status send the whole row colors green i have been searching to solve it with a formule in the conditional formatting if(orderstatus = "backorder" ;0;1), but all the rows even with status send are colored yellow when i added another formule = "s…
-
- 4 replies
- 2k views
-
-
Hi everyone, Is it possible to use a portal to display all records on the same layout that the records are. e.g. Customer records, 1 per layout but the portal on this layout shows all customers. Thanks in advance Milton.
-
- 5 replies
- 1.9k views
-
-
Howdy, Can any one tell me how to get the total number of records on a form? I want the main page to have a text line that shows the Total Records in the database. I have found the Insert "Record Number Symbol", but, correct me if I'm wrong, that represents the current number being browsed, not the total number of records? Cheers
-
- 5 replies
- 2.2k views
-
-
Admittedly, I'm more autistic than artistic so designing a stylish, yet functional, GUI for my runtime solutions is beyond my ability. Short of hiring a graphic designer (meaning big $$$), is there a website or book that you know of that shows different database designs? The sample solutions that are included with FileMaker are too simplistic and klunky for my taste; I'm thinking of something more elegant. TIA for your replies.
-
-
- 4 replies
- 3.1k views
-
-
Hi there, I've started putting together a database that manages resume information for scientists. It is comprised of about 30 tables of various forms of resume information. The parent table is the person, and I'd like for the database to be able to generate a resume. The amount of information stored will total from between 15-80+ pages. How can I generate a Word doc or PDF resume that grows depending on the amount of information in the related tables, and is cleanly formatted? (no dead space after sections/layouts, etc.) My initial thought is that a script will need to run through all the related portals and concatenate the information int…
-
- 4 replies
- 1.2k views
-
-
I'm working on a simple database to keep track of workflow and invoices for my transcription business. I'm working on creating an invoice portal, very similar to the one in the invoice starter solution, but I'm having a lot of trouble getting it to work properly. In an invoice table, I want to reference the name of a typed document, and also bring up other relevant information about that file (file length, transcript cost, etc.) This all works fine for me when I put forms into my layout without the portal. I type the file name as a foreign key and all the relevant information from the other tables comes up in the other fields... But when I'm trying to do the same thi…
-
- 2 replies
- 1.1k views
-
-
I created a product catalog that has several categories of products (ie. audio, lighting, parts, props, etc.). Now in the report view I would like to have it with the category title and then the products in that category underneath it and then the next category title and so on. Kind of like this: Category title Product Product etc etc Category title Product Product Etc I am sure it's something stupid easy but I couldn't find the answer so any help would be greatly appreciated. I am leaving for a convention on friday and wanted to be able to take this with me. Thanks.
-
- 1 reply
- 634 views
-
-
how can we highlight the portal row by the mouse click.. Link the below image
-
-
- 3 replies
- 1.4k views
-
-
Apologize if this has already been covered but I've been looking for a while now. All I'm trying to do is to create a value list based off a global field of available unused numbers within a set range. I have unique serial numbers for each record but this is a housing rentals db and they are assigned key numbers per property. These key numbers are within a set range so I'm looking for the easiest way to pull up a list of numbers that are not currently being used. I created separate tables with say 1-200 auto entered serial numbers to compare my key number field to but I'm not exactly sure of the next step as far as the wording of the calc etc. If I can get lis…
-
- 0 replies
- 776 views
-
-
In the image below there are two CommNonComm fields. The one at the top is a standard text field. The one below it is actually 2 fields set up as one item radio buttons. Each one of these activates a different script trigger. As you can see, both comm and noncomm are highlighted. This could create confusion among employees. What I would like to do is place the upper (text) field over the lower fields but I need for the script triggers to activate when I make a selection. Is there any way for FMP to see-thru the upper field yet still show a selection? Or, is there any way to divide the upper field into two parts so whichever is selected performs the proper s…
-
- 3 replies
- 789 views
-
-
I have a pretty simple setup: Members is the ONE table Chairs and Dues are 'many' tables. Each 'many' table resides on a portal on a tab on Members. They work. In order to allow the user to print the portal information, I put a 'print button' on each portal. When pressed, it executes GTRR ... This works. The weirdness is as follow: When I am in "DUES" and enter 3 rows, for example, in the portal and then press the PRINT button, it opens a window, inserts the PRINT_LAYOUT and shows the portal contents. It works. If I goto the PRINT_Layout window I see the 3 records from the portal. If, I go back to the portal and delete a row it gets deleted i…
-
- 3 replies
- 1.5k views
-
-
I have placed a pdf in a container and use it in the background of a layout. This way, I can print out the pdf with my database fields populating various components of the pdf. It seems to be working well, but only the first page of the pdf is accessible. Is there a way to access the other pages of the pdf? Thank you, Fed
-
- 38 replies
- 8.4k views
-
-
I have a many-to-many relationship that is not producing the sub-summary sort that I expect to see. Basically, I can add a portal viewing the relationship that I want to sort and I can see all of my related records. however, when I switch the layout to a list view and add a sub-summary section using the same relationship that worked in the portal, I can only see the first related record after I do my sort. What gives? I've never had any problem with sub-summary sorts before but this is driving me up the wall.
-
- 0 replies
- 632 views
-
-
Hi guys, Sorry if this seems like a newb question, I have a time card data base keeping track of my hours, and now have come across a Stat holiday which I want to account for. I have a column marked paid, which is a value list, of (Paid,Un Paid, Carry Over,Time & 1/2) ect. I also have a column for work hours. Now what I want to do, is if one of fields in the Paid Column is selected as Time & 1/2 then the work hours field for that day which is directly besides it, gets re-calculated to include the time and 1/2. If that makes any sense. Also on another note, in My database, I have 3 sections for entering in "what time I started" and "what time I ended", f…
-
- 3 replies
- 983 views
-
-
Hi I have a problem with the fields and adjacent subtitles on the layout when I print out a report from Filemaker. It seems that whilst the layouts all look aligned and neat, when I print out the actual report, a subtitle and corresponding field seem ever so slightly misaligned. I have been through the sliding menus but this just does not seem to do anything and I still have the same issue. Does any one have any idea on how I can tie together both the subtitle and field so that they are always aligned horizontally. It just look a bit unprofessional and messy at the moment! Thanks
-
- 2 replies
- 854 views
-
-
I've noticed that in order to change the text on a button, I need to remove the action (like a script) on that button. Only then can I access the text on the button. Then I need to reset the action on that button. I think I am missing something. Is there an easier way to change the text on a button? Thank you, Fed
-
- 3 replies
- 2.3k views
-
-
I was attempting to put buttons over tab control tabs in an effort to seamlessly trigger a script when the tab control tab was pushed. This was not effective and now I can't delete the button object off of the second tab in the tab control without triggering the tab control. So I have no way to delete the button I added. Suggestions?
-
- 4 replies
- 2.6k views
-
-
Ok, so I'm pretty much completly new to FM. I'm using FM Starting Point as my well.. Starting point. The invoices that it generates only accept up to 19 Rows of line items then it won't print anymore. I'm in need of how to make it generate more pages if there is more line items. Sometimes it could be up to a couple hundred rows, so It'd need to go from 1 page up to however many is needed, with the totals etc only on the last page, and the header information etc maybe on all the pages? I've searched the forums, but I can't find out how to do this in more simple terms. I've seen something about having relationships with portals and printing from line items, …
-
- 3 replies
- 1.6k views
-
-
Everytime I think I have it I get confused. I have an EXCEL spreadsheet with 500 students listed on it. It has their grades by what period and who the teacher is. Not all students have all 7 periods. Some have one some have more than one. This report is only for failures. The periods are listed under the column Period. I am not sure how to set up the layout to be able to accept the import correctly. In other words I know when I import I am importing the column with the period but that stduent my have more than one period. How does the layout know? I have attached a sample of the EXCEL spreadsheet. It has two students, one has only one class failing the other on…
-
- 13 replies
- 1.5k views
-
-
Hello again. I have another dilemma. I hope I don't confuse things, but I will try to give you an overview of what I want this database to do for the user... I have a database that imports two excel spreadsheets. It then uses various bits of those spreadsheets in compiling a report that needs to be printed. I have four different reports that need to be generated for the print. Here is how I would like the thing to work... The user navigates from the main screen (see "screen shot main") They then have to follow various steps using buttons. Step 1 - Import Excel Spreadsheet. A script that does the import without dialogue or input from t…
-
- 3 replies
- 981 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online