FileMaker Interface Features
-
Hi I have a problem filtering portal. My database is used to manage quality control records for products. The tables involved are: Products: Fields: Product_ID, Product_Name, Product_Number, Product_type, fk_Species_ID Species: Fields: Species_ID, Species_Name, Species_Latin_Name Seven different QC records tables: Fields: QC_record_ID, fk_Product_ID Like: One for fresh tomatoes, one for frozen tomatoes and one for canned tomatoes. The problem is that the qc_records are different for some species but others can have more than one species (Hope you understand my structure :-) What I am trying to do is making a relationship to ea…
-
- 0 replies
- 925 views
-
-
I have just returned to Filemaker after not using it for 5 years. My old filemaker 6 had great pages that connected to one another for a small business: invoice, contacts, payment info, monthly income calculations, estimate forms, letters.... in the FM 11 package I just bought there isn't even a place to enter payment info for invoices? I was hoping to start fresh with the new software, but I would lose so much from my old program. How is it possible that the new started solution doesn't have a way to track payments for invoices? I am not much for programming all this, so I wouldn't know where to start to set up monthly income reports and payment pages. Is there some…
-
- 3 replies
- 943 views
-
-
When moving from a Parent table layout to a Child table layout, for example using a button, the user has in sight all the records so far entered into the Child table layout. Is there any way, to hide all the so far entered records in the Child table layout from the user when he/she is just entering new records? For example, Parent ---< Child Let's assume that the Parent table has 250 records and the Child table has 500 records. We are in the process of creating Parent record 251 and once created we have to create 5 related Child records. The moment we move, through a button, from Parent record 251 to the Child layout, the user has in sight 500 Chil…
-
- 1 reply
- 728 views
-
-
I have a portal and I want to give the user the option to delete a portal row. So I have an [x] button that calls a script that uses the delete portal row script step, but it does not delete the portal row. It does not give me any errors in the debugger. On the same layout, in another tab, is a different portal that uses the delete portal row script step in it's delete script, and it works fine. I've compared the two to see what's different. Both have the same settings in the edit relationship dialog, both have an object name for the portal. The only difference I can see is that the portal that works is based on a join table, and the other one is not. I don't see w…
-
-
- 5 replies
- 4.7k views
-
-
Let me rephrase, I want to rotate left to right smoothly, I don't think 2 portals can do that but I am not sure.
-
- 1 reply
- 1.2k views
-
-
I have a list view layout that has a lot of find functionality that constrains and extends the found set. This functionality works great except when I am scrolled down the screen a little ways when the founds are preformed my scroll bar resets to the top. Any one know how to keep this from happening of at least be able to calculate the top viable record so I can return the scroll bar back to the position it was at before the find was executed? I have been able to do smiler things in a portal using custom functions to identify the top viable portal row and return that record back to the top of the portal so the records in the portal remain in the same position even i…
-
- 0 replies
- 776 views
-
-
I manage a small office network of 5 computers running FMP9.0 which I recently updated to 9.03 along with the SSL update to match. Two machines that have undergone the update no longer display embedded images in the database layouts properly. While the other three have no problems at all. The images are not in container fields (in retrospect that would have been much smarter) but placed right on the layout board. There is extensive use of auto resize to generate seamless borders and title bars. The images that show "gaps" have been linearly stretched from a single pixel width to the appropriate length of each layout object (three different lengths of a button for …
-
- 4 replies
- 1.1k views
-
-
I have a database for my music library in my band room. I also want to be able to list concerts and for each concert which songs were played. In that database I have a table for pieces in the music library, another table for concerts and another table for the selected concert's list of pieces. When I click on a concert right now it pulls up a list of related concert pieces in a portal beside the list of concerts. In that portal I have a field set up to display a value list from which I can select a piece of music from the library - the value list shows the Title only (but it is also based on the ID of the record for that piece of music) everything is working jus…
-
- 3 replies
- 1.2k views
-
-
Does anybody know if we can create pivot table with filemaker? This option is available in access and I'm sure it's as well with FM but I can't find it. Thanks for your help
-
- 5 replies
- 5.4k views
-
-
Hello, I have the following tables: DocP FormDocP DocS FormDocS Their relationships are: DocP -> FormDocP DocP -> DocS -> FormDocS DocP::__kpDocPID = FormDocP::_fkDocPID DocP::__kpDocPID = DocS::_fkDocPID DocS::__kpDocSID = FormDocS::_fkDocSID I have a layout based on the FormDocP table where I can pull out the fields from the DocP & FormDocP tables and generate a report. I have a layout based on the FormDocS table where I can pull out the fields from the DocS & ForDocS tables and generate a report. My goal is to have a report with the following fields from the 4 tables: DocP::Nam…
-
- 32 replies
- 6.6k views
-
-
Update: Got it to work. The problem was in my script that calculates the meter values. I have a water meter billing application. (It is for a non-profit LID so there is no money for custom programming) There are 2 tables: Property PK_Property BillingAddress Address etc,,, MeterReadings FK_PropID PK_MeterID ReadDate MeterReading Property is one:many with MeterReadings Looking at the METERREADING layout shows the situation. My problem is, for some reason, (perhaps this is where you can weigh in), the DIFFERENCE field only has the current calculation between the current reading and the prior re…
-
- 0 replies
- 749 views
-
-
hi everyone, I'm new to this forum and quite new to filemaker. I have not so many skills in developing databases except for the basical ones, so I hope you'll help me... this is not for my interests, I'm working free for a person who really need it. I've searched google for a lot of time but I wasn't able to find anything... I have to make a report of my database: I have two tables, the "registrations" one and the "buys" one. Both of them have got a "total amount" field. I want to make a report which tells me every registration and buy which has been made in the same day, adding a subtotal field that is the sum between the money entered and exited (I have set the "…
-
- 3 replies
- 1k views
-
-
I am using FM 11 adv in OSX I have a portal with 2 portal fields: Date Reading In the same table I have: Maximum, Minimum and DIfference (Maximum-Minimum) fields The portal is sorted in Ascending Date order. The problem: I have a water meter reading application. There are 2 tables: PROPERTIES and METERREADING (one to many) On a layout based on PROPERTIES I have a portal based on METERREADING. When I add a new 'row' to the portal, I enter the Date and the Reading. This puts the 'new' row at the bottom of the portal. I need to, in script, 'refresh' the portal so that the new 'row' is put in the proper sequence so my script can f…
-
- 3 replies
- 1.8k views
-
-
I want to be able to display text for a certain field but not let the user modify the text. I also want the text to be scrollable, since it will often overflow its object on the layout. I can't seem to have it both ways. If I unselect browse mode in the inspector under field entry, I can't scroll. If I select browse mode, the text of course becomes modifiable. See simple attached example. Is there a way to have it both ways? ScrollingProblem.fp7.zip
-
- 6 replies
- 2.6k views
-
-
Hi, When user1 is working on tableA, user2 is prevented from making changes to (a different record!) in that tableA. It is as if the full table is locked, instead of only the active record. This should not be (pretty basic i would say), but i can nevertheless not pinpoint the issue. - Can it be related to the physical setup? (i'm using a dedicated machine to host the dbase with FMPro 11, shared over FM-Network to service up to 4 users (no server-version!)) - Or is it the data-structure? (small dbase, occurred when working on a portal (based on tableA) in a layout (based on tableB)) - Or ...? Any help appreciated, rgds,
-
- 2 replies
- 1.6k views
-
-
I have a products portal on sort of an invoice program. It works fine. What I am trying to is I have another table called payouts that references values from the portal. In the payout table I have a field called EB1Sales. That value is the same value that is in say portal row 5 in the total sold field. I have many fields in the payout table that do this. Dave
-
- 2 replies
- 1.9k views
-
-
It has been awhile since I created an application in FM and I think I have forgotten something fundamental. Here is the situation (I am using FM 11 ADV): There is a non-profit association of homeowners. We need to collect property, owner, payment and water meter reading information. So, I created these tables: Owners Property Payments MeterReadings (the .zip file has the table) Everything works pretty well except the Rpt Payments report DOES NOT break when there is more than one property owned. (ie, Joe Schumfutz owns 2 properties: 11 Schumfutz Drive and 12 Schumfutz Drive. The report only shows 11 Schumfutz Drive despite the fact…
-
- 3 replies
- 1.6k views
-
-
So here's my situation: I created a textbox and I set up the formatting with a font, size, color, etc. Lets say Arial, 10pt, Black. Now my user comes along and wants to make the data in the textbox stand out. So the user enters data into the text box, highlights the text he wants and changes it to 18pt, red, bold. Now the box looks like: Don't forget this: I AM YOUR BOSS But now when I view a list using this textbox, or make a report with this textbox, that one record has 18pt red bold font. Is there any way to override this format change within the box? Or force it back to the original formatting Even if it just on this one layout. …
-
- 3 replies
- 1.7k views
-
-
I don't think it is possible but I like try again in this forum: I don't want to display the frame around a radiobutton field How to change the color (to the background for example) of the frame around a radiobutton field? or any other methode... Tia, Tol
-
- 9 replies
- 3.7k views
-
-
This might seem like a silly question, but I'm pretty new to filemaker. In the database that I am creating, users can only add records through the 'Add Record' layouts that I made. I was concerned with people canceling part-way through and leaving garbage in the database, so the fields in the 'Add Record' layout are globals that are set to the actual table when they click on the 'Add' button. Is this the best way to do this? If so, should I have a set of globals for each table where users need to add records (gName, gPart_Number), or a set of globals that are used for all 'Add' layouts in all tables (gAdd_Temp1, gAdd_Temp2)? Thanks
-
- 6 replies
- 1.6k views
-
-
Hi all, Is it possible to populate a portal from a series of drop down menus. What I am trying to achieve is to produce a quotation from five separate variables. There is a table of products that treat various crops for various problems. Each of the products has a repeating field with a list of crops and a list of problems that it treats. These products will treat the various crops at specific times of the year. It may well be that more than one product would be used to resolve a particular problem. What I am trying to do is to input the crop and the problem along with the area and the number of plants and produce a quote that gives the price for that spray program. The…
-
- 1 reply
- 1k views
-
-
I am trying to duplicate a portal record in FM11. I have come across a few questions. From what I have read I can have a button in the portal trigger a script which will: go to portal row[select; no dialog; get (portalRowNumber)] Duplicate Record/Request 1)Unfortunately when I try to create a "go to portal row" script I need to specify ("First,Last,Next,Previous,Calculation)", on a calculation of "get (portalRowNumber)" I get the error "This parameter is an invalid Get function parameter.". Can someone please tell me why this isn't working? Am I not allowed to call get (portalRowNumber) in a script? Also I used the work around: Go to Port…
-
- 1 reply
- 1.4k views
-
-
I'm new to FileMaker. My version is FileMaker Pro 8.5, I know it's kinda of old. Any help would be greatly appreciated. I have surfed through various forums and nothing has helped. Question: How do I zoom in/out on specific images? Whether it's just one picture or when it's a thumbnail such as in "Asset List View" ? Details: I'm using "Lending Library" as a starter template and reworking for cataloging artwork. Please be detailed and specific with instructions. I know nothing about scripts so if they are involved, it would be great if someone could provide step by step instructions. Below are some thumbnails: Asset Form View http://imageshack.us/photo/…
-
- 0 replies
- 707 views
-
-
Hello. Some background - I have fairly advanced experience in SQL language on traditional SQL servers such as SQL server and MySQL plus experience in dealing with programming / DB's through VB.net and others. I have been thrown into a project that requires that I use FMPro version 11 - nice, but need to get up to speed quickly. I have created a small demo program to produce functionality that I will reuse in this project. Here is the situation - just an example A simple many to many relationship with a join table with a unique key created by two foreign keys of the two joined tables. I have enabled cascading create (but not delete) in both direct…
-
- 3 replies
- 1.7k views
-
-
Hi all I am trying to work out how to add in a page to extend the layout of a report. Using the part setup up to create a sub summary, I find that a, I do not know what I am doing an b, when I do this, the text /fields above my new subsummary break whilst it appears in layout mode, doews not appear on the screen when I exit layout mode. I think the problem is I do not know what field to relate it to so when it ask what table and field I should use I have no idea. Any tips. screenshot attached Thanks PS I am beginner to novice! Attached again not sure if previous worked
-
- 3 replies
- 1.6k views
-
-
Hi all, Is there any way to remove the Status Bar but still keep the Quikfind facility. I don't want people creating new records or deleting records from the Status toolbar but keeping Quickfind would be really usefull.
-
- 1 reply
- 2.3k views
-
-
Hello, I have two tables: Process Document Process table fields: __pkProcessID ProcessName ProcessStepName Document table fields: __pkDocument ID DocumentName ... What I want to achieve is to have a portal on the Document layout where to put the processes and processes steps where a document is needed. For instance, Document 1 could be needed at: Process 1 step 1 Process 1 step 5 Process 3 step 4 Process 10 step, 2 Process 10 step 5 ... I surfed the web in search of help and I got an example that describes how to setp up conditional value lists both for fields and for portals. No issue on the fields part. …
-
- 5 replies
- 1.3k views
-
-
I have a solution I will be selling as a stand alone application. Part of it involves a section of the app to display images - somewhat like banner ads, and have them linked to the website associated with it. I know I can accomplish this via the web viewer and doing some scripting to get a random image served each time... however, I cannot figure out how to get the webviewer box to go away and just show the image - if there is a way to kill the boundary of the viewer, I think that will work for me. If you have any other suggestions for approach what would be essentially a clickable banner ad, that pulls the ads from a web location, Im open to ideas.
-
- 4 replies
- 1.9k views
-
-
I am wondering whether there's a practical way around problems implementing two features in a database I'm developing: (1) My database has data with names like workshop, series, program, topic, etc., but some users might want to call these entities by different names, e.g., they might think of a workshop as a session. I'd like to allow them to set these program-defined names to names of their own choosing, but many buttons on my layout incorporate these names (sometimes they line up side-by-side along a row). Is there a way to get the width of buttons to expand or shrink dynamically according to the content? On the face of it, this would appear impossible, and the id…
-
- 4 replies
- 1.2k views
-
-
Hi, I have a value list which is containing spare parts ID/Name How can I filter it an show filtered value list? Regards to all
-
- 2 replies
- 934 views
-
-
I can't get around that every time I want to use a field validation It is triggered at the beginning and not at the end of a new record. I want the validation to be triggered when I want to create another record or simply before I quit, so that the field is filled with the information intended for that field. This validation issue is quite an issue for me. I'll appreciate any help on this.Thank you
-
- 7 replies
- 2.4k views
-
-
How do I make the checkboxes visible in my checkbox dropdown list? I am using FMP 11 on a MacBook Pro 10.6.7. I can place an X beside each value in my value list but it would be nice if a blank box appeared beside each value.
-
- 2 replies
- 1.5k views
-
-
I'm hoping someone can give me a little more direction. I've searched for a few hours on this and downloaded some samples so I know it's pretty difficult or I'm missing something and complicating it. A little background. We place temporary staff and want an easy way to show when we have staff available (after they tell us). I'm after a little calendar that only shows the dates for a month within an existing layout. If staff are available for the day, it's formated to show as a different colour. Clicking on the day will show in portal those that are available. Developing this further, I thought for our staff layout screen (that shows staff details), the sam…
-
- 8 replies
- 6.3k views
-
-
I am very new to FileMaker so please bear with me. I have created a database off of a datapull from our job costing/accounting server. I am trying to duplicate a report that I create in Excel using Pivot tables. I know...the easiest way to get a pivot table in FileMaker is to do it in Excel So I have my data (having fun I must say with the functions) and I'm trying to create a report that kind of looks like this: My issue: the Billable, Downtime, ASA, Internal Job, etc, etc row on the top comes from one field in Excel. I have duplicated the same calculations via functions to pull that info in Filemaker and created one field called 'Time Breakdown'. …
-
- 1 reply
- 1.2k views
-
-
I have 2 textfields with a calander , and now was my idea to see al the records with the date between those 2 dates i selected Example: I have a record with : Date : 01-01-2011 Name : Project: And one with Date: 08-08-2011 And i select 01-01-2011 - 02-02-2011 in the textfields , then i only want to see the 01-01-2011 record because it's between those 2 dates. I hope you understand what i mean.
-
- 5 replies
- 4.4k views
-
-
Good Morning, I'm working on a layout which requires conditional formatting based on the value of a related record in a one-to-one relationship. When I add the conditional formatting in the layout which the portal is based on it works without a problem, but when I add it in the portal directly it doesn't work at all. The calculation dialog when setting up the formatting states "This calculation will be evaluated based on context determined at runtime." Is conditional formatting on portal fields evaluated from the context of the portal, or from the parent layout? If it is from the parent layout, is there any way to force it to evaluate from a different context? …
-
- 8 replies
- 3.7k views
-
-
I have an avery label layout with specific margins. The margins are set up "facing each other," so that there is always a wider inner margin on the pages when they're printed. When I go into preview mode, FileMaker correctly alternates the margins so that the larger margin would always be on the inside of the page. However, when I try printing this to a PDF, the labels shift, well, oddly. Instead of the records sliding back and forth (a result from the larger margin alternating between the right and left sides of the page), they instead shift right for the first page, then right again for the second page, then right again for the third, then alternates between the…
-
- 0 replies
- 1.3k views
-
-
I am looking to create a "part" on the right hand side which will display my extended help text. Is this possible? The idea is that user can scroll through my fields on the left-hand side of the screen and when active on a field an OnObject script will activate some extended help text to be displayed in this right-hand side "part" which is fixed. This must be IWP compliant and therefore if the OnObject script doesn't cater for the script I plant o create "Help" button which will activate the extended help text.
-
- 1 reply
- 1.1k views
-
-
First, an appology if this has been covered before - but try searching for 'save as pdf' and see where it gets you I have two layouts that give me a problem of creating a blank page when there are more than 6 records shown. The first layout has a header, footer and a body that contains 20 individual portals showing up to 20 lines from a parts ordering system. The portals are arranged so that they do not cross a page break. There are 7 portals before a page break occurs. Sliding and printing is set to slide up, and reduce the size of the enclosing part. The second layout again has header, footer and a body that has a singal portal showing up to 20 records. …
-
- 2 replies
- 1.5k views
-
-
Hey all, Anyone know of a reliable way of making a very large value list resolve correctly? Example: I have a table of data from an Internet source of network adapter first six MAC characters to vendor. Really simple. Two fields. First six of the MAC and the vendor assigned to that prefix. Ex: 005056 = "VMWare, Inc.". The table has 5630 entries. I have a field in a database to hold the full MAC of a device and a companion calc field to take the first 6 digits after stripping out any colons ( or hyphens (-). I have a double field value list of all the values from the Internet source table (first field is MAC first six, second field is the Vendor string). …
-
- 1 reply
- 1.3k views
-
-
Hello, Question that came up today. Can a layout be modified on a server. Here is what I want to do with all users off (we only have 6 so it will not be hard), I log in to the server from my workstation with full access and make changes to the layout, basically moving some fields around that I put in the wrong order. Will this work, or do I need to pull the db off the server and make the modifications and then upload it again? Thanks, M.L.
-
- 2 replies
- 1.2k views
-
-
Hello, i would create a value list that only shows the articles with belongs to the customer number (debiteur number) But i don't know how i'll create a sort of filter for it. Orderinvoer.zip
-
- 1 reply
- 1.2k views
-
-
I'm working on a report. We'll go with my widget schema again. I've generated a report where it's first sorted by WidgetColor and then Widget with a count of each widget (widgetcount). I've presented this report and am waiting the next requirement. In the meantime, I am anticipating that he is going to want it to be: Widget Color1 Widget1 Widget2 Widget3 Widget4 Widget5 Widget6 Widget Color2 Widget1 Widget2 Widget3 Widget4 Widget5 And so forth (you get the idea). I know this can be "easily" done with a single iteration of each widget by doing a loop in the script to omit duplicates (each Widget Color-Widget ha…
-
- 1 reply
- 1.1k views
-
-
Hello, I have a database for a summer music camp program. I currently have a table of all faculty that have taught at the camps over the last several years. The database I inherited had a Year field that would have "yes" entered into it when faculty taught at the camp that year. Most of the scripting and sorting would start with a find for whichever faculty member was teaching in the current year. I would like to be able to create a value list of all the current teaching faculty for this year. The value list would be used in several layouts for ease of pulling class rosters, contracts, assigning to classes (though a join table to the student table), etc. I've s…
-
- 13 replies
- 3.1k views
-
-
I'm new to portals. Just getting started. I have a table with three fields: number field: PRIORITY text field: DESCRIPTION container field: IMAGE On a separate layout I have a portal that shows the container fields, a dozen records at a time. I would like to constrain the portal to only showing images of a FOUND set. For example, if I perform a search for records that have priority equal to "2", then just those images (but ALL those images) would show up in the portal. Is there any way to filter the portal so that it only shows these records?
-
- 1 reply
- 1.1k views
-
-
I have a database that stores html code that gets uploaded to our website catalog. We also use this database to generate internal documents, so I am trying to use the web viewer to display the html code as regular text on some of our layouts. We also use a lot of Greek Unicode symbols in our text which has presented us a lot of cross-platform issues in the past with FileMaker. For example, if you insert a unicode alpha (α) into a field on a Mac, the PC would show it as a block or empty character. This is why I am trying to use the web viewer approach instead. Having the same problems with the web viewer; if I place the html code with Greek unicode into a filemak…
-
- 8 replies
- 3.8k views
-
-
I have designed my solution for the 'typical' laptop display - to fit a 1024x768 resolution without need to scroll either vertically or horizontally. This is great as a 'full screen' display for computers with 1024x768 maximum resolution. Users with larger resolution screens want to 'maximize' the solution with an accompanying scaling up of the objects on the layout. FM allows zooming only in fixed increments (150% 200% 300% etc) which helps only if the user has a larger screen - 20" or more - and zooming to 150% could be done. If the user's screen isn't big enough zooming to 150 requires scrolling to view all the objects on the screen. What I've done …
-
- 1 reply
- 1.2k views
-
-
Used instant web publishing to allow some folks on the LAN to add data to the dbase. However, I can't figure out how to add an image to my container field us the Web Viewer. All computers are Mac running OS 10.5 or later. Browsers range from Safari to Firefox to Chrome.
-
- 2 replies
- 11.4k views
-
-
Howdy. I'm a newbie when it comes to FileMaker developing. I do know enough to build myself some simple and useful databases that I know how to run, but I struggle in making them more usable for other people in the office. What I have is a simple database that allows several of us in the office to add customer accounts that are disconnected. (I work for an electric company) I have it set up to add, edit or delete records and then if the record is in there, they can check a box that it is reconnected and then later, i can go in and run a script to remove all connected accounts. What I would like to do is add a "screen" when they open the file that allows them to log i…
-
- 4 replies
- 1.4k views
-
-
Ok, I'm using FMStarting Point and haven't really modified it too much so hopefully your familiar with the layout. I have a field for each of the following: Date Name Subtotal Total We sell about 20 products, but are broken down into 4 categories (Product 1) (Product 1 Accessories)(Product 2) (Product 2 Accessories). Our accountant is wanting totals from each of the following categories which would also need sorted by date. I've gotten it to work with Find, but it's finding every invoice that has for example "Product 1" in it and getting a total from that, when Rather I need it to only take the price of "Product 1". I can try to expla…
-
- 1 reply
- 757 views
-
-
Hey All, I am working on a solution where each administrator has their own page. In order to keep the number of layouts I have to a minimum I was wondering if anyone had found a way to change visual objects, such as a menu, based on a field. Confusing Right? For Example SET- will be a text field, each time I click a button, the field would be set with the script parameter, ie. the word written on the button, signifying which menu set I would like to appear. MENU Students Room Manipulation Public Area Damage Lets say I select the Students button. Without the Layout changing I would like to bring up a students menu so that the user can decide wh…
-
- 5 replies
- 1.8k views
-
-
I've set up a portal with several tabs. There's a field which shows up under several tabs which is an irritation. Can't understand why. It seems to be related to its position in the tab where it is supposed to show - it is near the bottom. If I move the field up (problem is there's not much room) then it disappears. What am I missing?
-
- 2 replies
- 1.5k views
-
-
I can't understand why a field that displays a value list as a radio button does not show all the characters of each item in that list? I would greatly appreciate if some one has an idea. Thanks
-
- 1 reply
- 1.6k views
-
-
I have a NAME field on a layout that displays a full name that is a concatenation of First, Middle and Last names from a parent table. (Obviously, as a calc field, the data cannot be edited here.) I have formatted the field as a button so that in Browse mode the user can click it and be taken to the parent record in a different layout. However, I would like the field to be Searchable, so I have enable entry in Find mode. If the cursor is in a different field on the layout and I enter Find mode, the NAME field is not enterable -- the cursor becomes a 'hand' icon and cannot enter the field (the button doesn't trigger either, since it's a "GTRR" button. If th…
-
-
- 1 reply
- 801 views
-
-
I have a database the documents grant awards, grantee information, host affiliation, etc. in their own respective relational tables. I have been doing most of this based on the knowledge I gained from my previous thread. The layout that shows records from the Hosts table details all the Host's information and it includes a portal. The fields on this portal has a list of all the grantees who were affiliated with this host during their award period, (Grantee Name, Program Year, Academic Area). It's a great way to quickly identify past and present trends. I want to take it a bit further by attempting to do the following: 1. Create two calculations that would let th…
-
- 0 replies
- 998 views
-
-
Hello everyone, I have a new project. My company has a new contract and I'm setting up billing on FM 9 Adv. The fields necessary are simple: person who received service, date, customer #, and three more, BUT there are 30 different counties who will be billed about 22 of which who use one form and the others who have their own form, and just to make things interesting, those 22 each have their own unique information(address, telephone) that goes onto that most common form. So, my thought is to have a data entry layout with a drop down list for the 30 counties, and then have 30 layouts for printing the bills. I can program it the way I have describ…
-
- 3 replies
- 1.4k views
-
-
I am in the early stages of generalizing a database I built several months ago for setting up and managing workshops in a university setting, and I would like to get advice about a key design decision that I will be stuck with from here on. The workshops will belong to what I refer to as an organization, and each organization will be able to mount several programs. (Prior to now, you could think of my database as consisting of a single program, within a single organization.) What I plan to do is add an organization id field and a program id field to the records of most of my key types of data: presenters, locations, times, dates, etc. I want to offer flexibility for …
-
- 4 replies
- 1.7k views
-
-
I have a database I developed a ways back with tables ORDERS, LINEITEM, PRODUCT, and PRODUCTGROUP. Each Product belongs to a Product Group. Groups are essentially master products and the products are style variants of the master product or product group they belong to. So for example, master product Chair and product is Chair Red (style), Oak (material). The reason for breaking the products down this way is because of a draw on an inventory parts list that is different for each product variant. Till now everything has worked beautifully. I create LINEITEM records via a portal on the order page and currently have it working via a relationship between _kProduct(Produc…
-
- 0 replies
- 1.3k views
-
-
Hello, I'm a relative novice trying to create a basic timetable management solution for a suite of operating theatres in a (resource-poor) public hospital as well as a job plan for each anaesthetist. My main question is whether to display a weekly timetable I should concentrate on using sorted, filtered portals or or whether I need to manage the horizontal nature of the timetable by using 10 table occurences accessed by relationships using a global "Session in Question" field and 9 related fields incrementing by one each time to display the 10 sessions that make up a working week. The main parameters of the problem are: - we have a suite of theatres …
-
- 3 replies
- 2k views
-
-
I have been trying to come out with a summary field that totals i.e. "total amount owed" from another file or database. I could script it, copy and paste, but since files are related I just wanted to know if there is anyone that has tried to do this before. thanks in advance
-
- 0 replies
- 699 views
-
-
I'm sure this should be easy . . . he said, I have a table CLIENTS, each record has room for up to 2 people to be named. They start as LastName1, FirstName1, LastName2, FirstName2 Then there's a calculation for FullName1 and FullName2 Now in the SESSIONS table I want to be able to choose clients with a drop-down list So I want to have a Value List with both those names in it. I can't see how to do that in the Value List interface. I've created a field in SESSIONS that does a Lookup of the value in CLIENTS::FullName1(FullNameA) , and also CLIENTS::FullName2 (FullNameB) How can I put FullNameA and FullNameB in the Value List? Thanks, ji…
-
- 4 replies
- 1.8k views
-
-
I created a db on a Mac, OS X Leopard in FileMaker Pro 11. I used Lucinda Grande for the font. I thought that this font would be rendered through/as* Lucinda Sans Unicode on Windows (see chart). However, when I copied the file from my Mac to Windows 7 on my VM Fusion, it becomes Arial. In fact, I had to add Lucinda Sans Unicode to FileMaker; apparently it is on Windows 7 but not necessary available to FileMaker until it is added via Configure/More Fonts... in the formating bar in Layout Mode. So, I added Lucinda Sans Unicode and deleted the file. Then, I copied the master file over from the Mac side again, but the font still renders as Arial, even though Lucinda…
-
- 4 replies
- 3.3k views
-
-
Hi I am a user of Filemaker Pro 10, and I have a problem: I have a portal in a layout which has several rows, and each row has an id, and also a field called position. Sometimes there are a few portal rows with same id , but different values in position field. Now I want to have those rows of the portal which have a specific id (let's say 3) in another layout. How can I write a script so that I can just have those portal rows with id=3 in portal row format in my new layout? I will really appreciate any help. Best, Sepideh
-
- 1 reply
- 1.5k views
-
-
Hi, In a multiuser system I have a layout with a portal that shows Jobs of the current team. It is ordered by customer and, logically, appears the expected data: customer_1 customer_1 customer_1 customer_1 customer_2 customer_2 customer_3 customer_4 In this field of the customer that I would like to control its appearance. And I would like to have a conditional formatting option or trick in order to show the first customer_1 in black type and the 2nd, 3rd, 4th in grey; the first customer_2 in black, the 2nd in grey characters. Obvious reading confortness that I have implemented in list views thanks to the GetNthRecord is now the standard i…
-
- 4 replies
- 1.9k views
-
-
Hi I'm trying to implement a new feature in my database which involves two tables. the first is called 'salesline' and the second is called 'options' Options has a mixture of records of various options that are either 'inclusive' or 'chargeable' I am trying to get two value lists displayed in 'salesitems' table. one is for the inclusive options (i want to use radio buttons so users can only select one). the second is for 'chargeable optons' whereby users can select multiple optons by means of a checkbox set. the problem i am having is getting the value lists to correctly display the correct records - i've done this sort of thing before and not had a prob…
-
- 3 replies
- 1.2k views
-
-
I have the latest version of FM Pro 11 Adv, and running on a Macbook Pro with Snow Leopard. I am trying to create a report layout but I need more than the 11 page limit. It is a report that is populated from many fields from a number of different linked tables. It certainly would suite a mail merge into word as there is an enormous amount of text around the populated fields. However I seem to be having difficulty in word allowing more than one table to be referenced, also. The report layout in FM is limited to about 11 pages so this presents a problem. Do I have to do the report in 3 different layouts and then merge somehow? Why is it so long? It is for Buil…
-
- 6 replies
- 2.1k views
-
-
I am in a portal, go to related record in new window, need to close that window and have cursor in the QTY field of that portal record. I have the Record ID, but cannot seem to get back to it. Wants to go to that field, but to the first portal row. Can't seem to do a find for Record ID and get there. What's the solution? Thanks, SoCalMacDude
-
- 2 replies
- 1.4k views
-
-
Hi, I have a portal with 2 fields "Action" and "date" and this works fine. The user enters "action" from a drop down list such as "Contacted buyer" or "sent email" then puts the date in the next field. Underneath I have a notes field which is just a text box. I would like the notes field to be inndividual to each row of the portal, so if you click on a port row it shows the notes for that row, click on the next row it shows the notes for that row and so on but not in the portal itself, in the notes field below it. Can this be done? Thanks
-
- 3 replies
- 1.5k views
-
-
Hi friends! I have a field which holds a large number (ten digits). When I type the number, for example, 1234567890, and leave the field, the number in the layout converts to 1,2346+e09, and I don't want that conversion because the user should see the entire value. How can i fix this? Thank you very much!!!
-
- 2 replies
- 889 views
-
-
Is there anyway to get web viewer to correctly display "http://username%40company.com:[email protected]" in the web view? The web viewer wants to turn it the %40 into %2540.
-
- 4 replies
- 2.4k views
-
-
I want to get a certain block of text from a website. for instance on this website: http://www.crossfit.com/mt-archive2/007600.html i would like to extract this part of the text: Complete as many rounds in 20 minutes as you can of: 15 ft Rope Climb, 1 ascent Run 400 meters Max rep Handstand push-up Every day the WOD (workout of the day) changes and i would like to navigate to the page with the WOD I plan to use and set up a button to click to quickly copy and paste the WOD to the WOD field . So far my understanding is that I will need to create a seperate field and copy the html to it via GetLayoutObjectAttribute ( "ViewerObjectName" …
-
- 0 replies
- 1.5k views
-
-
Can I choose orientation vertical or horizontal a4 paper for each layout, because I need to print some documents in vertical and other in horizontal orientation?
-
- 1 reply
- 2k views
-
-
Hello - I have a report called "System Cost and Pricing" in which I set out to detail components making up various computer systems. Each system contains specifically detailed components such as graphics cards, internal hard drives, controller cards, etc... I have the following tables: Equipment - Lists general details for each type of equipment we keep in inventory. An example would be Hitachi 2TB Internal SAS Hard Drive, replacement cost for this type of drive, and what that drive would rent to customers for on a daily or weekly basis (we rent to customers) Inventory - Specific details for each piece of equipment we have in inventory. Serial number, …
-
- 3 replies
- 1.7k views
-
-
I have a database for a Resident’s association that charges an annual fee. If residents do not pay this fee the association places a lien on their property. The lien form has to follow a specific format set by the State. We can only place a max of 4 records on each form. Each record needs 2 lines to show data. See layout below. I can sort to a residents list that are past due. What I want to do is add a check box to this list and choose which records to transfer to the Lien form, so I can limit them to 4 or less records. Can this be done and can I use 2 lines per record? Portal? Can someone point me in the right direction? Thanks. NAME AND ADDRESS (space) LOT NU…
-
- 8 replies
- 2.6k views
-
-
I am working on a solution to fill out standard forms. I have these forms in PDF format. In order to ensure that my layouts will look exactly like the form, I have taken the PDF version and inserted it into my layout, as the background, and then just put my fields in the proper places so that it will print using the PDF as the "Template". This way I don't need to totally recreate the form in FMP, and it will be exactly like the standard format that we must follow. The problem is that the PDF consistantly prints out in a low resolution. I can print the PDF in Preview or Acrobat and it looks great. Insert it into FMP and it looks great on screen, even zoomed in all th…
-
- 2 replies
- 1.1k views
-
-
Does anyone know if there's a layout folder limit with FM 11? I seem to have run into one ...
-
- 9 replies
- 3.2k views
-
-
Hi I need a script to let me set a value list field in a loop, search related records and save it as excel. I don't know how to write the script. any help? Nader
-
- 8 replies
- 2.3k views
-
-
The example is inspired by The Bridge it gives a couple of examples that maybe useful with Web Viewer: 1. Resize an image 2. Refresh Content 3. Embed a flash rollover button You need 8.5 to use this The attachments named MacAndPC should work on PC although i only have a Mac so can't test it. best wishes, Stuart WebViewer_Example.fp7.zip WebViewer_MacAndPC.fp7.zip
-
- 7 replies
- 4.7k views
-
-
I have a text field that displays on a layout that is present for display purposes only. It is set to disallow entry. Data for that field is entered on a different layout. Often the data in the field is too long for the length of the display field. In this case it displays a question mark. I feel like in earlier versions it showed as much of the line as it could fit, which is what I need. The operator should be able to see the first few words and can click if he/she wants to be taken to a layout where they can see the whole thing. Thoughts?
-
- 2 replies
- 1.1k views
-
-
I have tried to find the answer to this and it appears to be answered in many different places, yet it doesn't work for me. I thought I'd try this: I have two tables- Table A: Includes items completed (fields include item, date, employee who completed) and Table B: Hours worked by each employee (Fields include, hours, date, employee). Always, employees have multiple records per date in table A. Occasionally, employees have multiple records in Table B per date. I need to create a summary report that will compute # of items completed per hour worked, break field: Date. Is this possible? How?
-
- 4 replies
- 1.3k views
-
-
Hi All. I'm looking for any and all links to solutions for maintaining a portal row when switching layouts. I have a need to switch between two identical layouts seemlessly and have the portal on the layouts retain the visible rows, or at least somewhere close. Any help would be greatly appreciated. Thanks Ron
-
- 4 replies
- 1.4k views
-
-
Hi Does anyone know if it possible to chart (bar or pie) the number of entries in a database based on a selected value from a value list? IE: I have a value list containing values of "Product A" though to "Product K", I would like to create a chart showing how many records with Product A etc. Thanks for any advise.
-
- 0 replies
- 1.1k views
-
-
Hi. I am looking for a method/trick to get around a small problem I am having. I have a splash sceen that uses an image of 800 x 600 as the background. The database is used over a WAN connection so, depending on the link speed, can take up to 3 seconds to load. I know that some of you are going to come back with the comment that I shouldnt be attempting this but I am looking for information WHY it does what it does so I can work on a solution that best fits. My problem doesnt seem to be too much different from http://fmforums.com/forum/topic/77847-freeze-window/page__p__364750__hl__image+load+order+layout__fromsearch__1#entry364750 but the topic went dead. …
-
- 1 reply
- 1.3k views
-
-
Hello As I am very new to Fm coming from Access and I hope I am asking my question in the correct area. Within my database I have included a tab which holds 12 container fields each of these fields (Container) is covered by a Jpg image of a filing cabinet draw-front, What I am trying to achieve is if the draw in empty then the image is displayed in front of the container and when the container field has content it moves or shows in front of the image. Then I can replicate this across the 12 draws. Any help you be appreciated. Regards. Ozzie Bruce
-
- 1 reply
- 2.4k views
-
-
I need to show summarized sales data for vendors and countries. The straightforward way that works fine is to create two summary parts: the first summarizes by a vendor's Country; under that are summaries for each vendor in that country. So I have something like this: But because I need to print this on one page with other information above it, I can make it fit if I can put the country summary on the first line of the first Company summary, like this: (I hope this shows up well once I post it.) You see this takes up about half the space of the first report. The challenge is to get the correct country summary on the same line as the first co…
-
- 3 replies
- 2.1k views
-
-
I'd like, when one of the four small images is pressed/selected, that it appear in the larger box. They are container fields.. it's just not making sense to me at all how to get that to happen.
-
- 0 replies
- 1.5k views
-
-
How hide tools menu in custom menu option, while apply the custom menu.. Please suggest me to hide the tools menu
-
- 1 reply
- 3k views
-
-
FM11 advanced. I want to 'freeze' the window on a 'promotional' layout in the script run upon file opening while the solution goes about initializing data etc. The first script step is 'go to layout(promoLayout)'. The second step is 'Freeze Window'. The 3rd step goes to another layout. FM immediately takes the screen to this other layout. Why doesn't the solution leave the screen on the first layout?
-
- 5 replies
- 2.5k views
-
-
Hi All, I have a drop down list on my Invoice table in a portal from my Line Items. The Line Items table looks up the information from the products table. I have had to create two different part numbers for the same product determined by how the product is stocked but when I create an invoice it only shows one item in the drop down list not two, any ideas why.
-
- 2 replies
- 2.9k views
-
-
This question addresses a larger issue, so let me start with that larger issue. I have made an FM database template that many of my colleagues use for specific events. Each event is different, so the users start with a clean version of the template for each event. Of course, the easiest way to do this is to provide a Cloned copy of the template. However, I would like to be able to add a User Preference feature that each user could set for their specific convenience. Unfortunately, I know of no way to preserve any "preferences" (values) in a Cloned database. One solution would be to be able to edit the Custom Values used to generate a Value List. I know one can …
-
- 4 replies
- 1.6k views
-
-
FMP10 mac OS 10.5.8... I have a value list in a file... that appears to have no name, no value list items and can't be edited or deleted. What gives? backstory: I was updating a file, added a field (number, global) and it needed a value list. So I set everything up from a client, added it to a couple of layouts, set the value list, then quit out so I could do some stuff with the host machine (compress copies, make backups etc.) When I reopened this set, that field came up as "value list missing". When I went to layout to reset it... there is an entry in the value lists (only two value lists in this file) but it shows nothing (blank) for a list …
-
- 4 replies
- 3.8k views
-
-
I am currently using Filemaker 9 to do this. I have been reading through many FFM forums and I am still a little stuck on my end. Basically I am building an export button to export pictures (targeted link from another field) out of my web preview. When it exports it saves as the "filename".jpeg in the targeted folder I want but I cannot view the picture because it is actually a text file. 1) Is this possible? 2) If no, is a targeted container workable? Note: I've tried this but the container doesn't fill the box with the proper image but gives me a icon of the picture instead and bombs out everytime. I understand containers has to have something in the container …
-
- 6 replies
- 2.9k views
-
-
I am using FM 11 Adv 11.03 I have a popup that shows these values: When a selection is made, an evaluation script is run: I can't for the life of me see why the last (high lighted) else if doesn't evaluate. All the other choices work. FM, in debug, just skips over (evaluates as false) this choice. Perhaps your eyes can see what mine can't. Thanks for looking...
-
- 4 replies
- 1.5k views
-
-
A customer of mine is keen to have "open access" to the database to create ad-hoc reports via new layouts which aren't built into the system. As a developer I'm obviously not keen to allow table level access and to date have never provided such an feature in any bespoke system I've written for obvious reasons. However they are a charity with a small budget and next year will need some new reports that they can't possibly know about now, and they can't afford my fees to keep changing the system for ad-hoc requirements. I've thought about creating an export data set, into a FMP merge file which they can then open in FMP and create custom reports themselves (they h…
-
- 3 replies
- 972 views
-
-
Can someone help me with this? I have several layouts with a "Zoom In" button and a "Zoom Out" button. For some reason I cannot get the Zoom Out button to work. I can choose Zoom Out from the menu and that's fine or I can hit Shift-F3 but the button won't work. I have discovered that if I open the File in FM10 it works fine but if I try any of the layouts in FM11 the Zoom Out won't work.
-
- 0 replies
- 801 views
-
-
Hi I have a table of users who are linked to a school table by a unique number called "DestNo". Each school has 4 users attached to a school. On a layout I have set up a network group with an attached portal where I add a school as a member of this group via a popup menu. At the same time in that portal I can add via popup menu the related user (from tblUsers) I have a direct relationship between tblUsers and tblSchools by the DestNo. Now the user field is filtering too well and picking only the 1st record of the 4 possible users. The other 3 do not show up. Any ideas Thanks in advance Cheers Peter
-
- 6 replies
- 2.5k views
-
-
I'm fairly new to Filemaker. I'm trying to add a Drop Down Calendar. I set up a date field and then formatted it as a Drop Down Calendar. When I see it on the form, it looks good so far - I click on it and see the month and can select a dat. But then the problems start... I get a beep and a warning message "The value of tis field must be a valid date in the range of years 1 to 4000 and should look like "25/12/2003". Now the date shows as 25 12 2003, so I go to Edit Layout, Select Date Format and select the layout that gives 25/12/2003. But the next date I try to select, it resets to 25 12 2003, beeps and I get the same error message.I then have to Revert Fi…
-
- 4 replies
- 2.8k views
-
-
Is there a simple way to keep my various related databases within a "window" frame - I know this can be done by calculating the position of the window from which one is navigating and making the new window take that position - but i was wondering about a simpler solution so that I do not have to go back and work out all the instances in my solution where such a calculation would be needed.
-
- 1 reply
- 1.6k views
-
-
Hi, I think this will have already been discussed, but I have not been able to find the thread. Happy to read another similar solution to fix my problem. Thanks for any pointers to previous discussions. I have three tables: client, computer, filepath. They are one to many links: One client can have many computers and one computer can have many file paths. I am trying to setup a layout that looks like this CLIENT INFO BLOCK [PORTAL1: fields from COMPUTER, records filtered to show only related to current company] [[PORTAL2: fields from FILEPATH, records filtered to show only related to currently select COMPUTER in PORT…
-
- 12 replies
- 2.8k views
-
-
I'm an absolute newbie to Filemaker. One thing that I can't quite figure out is how to display a table to a user while in Form View. I can get it to work with a portal, but isn't there a way to list information in Form View from the table associated with the layout? If a portal is the only way, how do you let the user search? I read that you are supposed to use tabs, with a different portal on each tab, but that gets cumbersome pretty quick. Thanks
-
-
- 8 replies
- 6.6k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online