FileMaker Interface Features
-
I have a similar problem to the recent threads on filtering information in a portal. I have an 'invoices' table that contains a portal showing 'extras' that are in a related table ("Extras ID = Invoices ID") but different (remote) fm8.5 file. All the 'extras items' show up as expected in the portal. However, I need the portal to show only the unpaid 'extras items' for each client. Using a 'date received' field in the 'extras' table, I have set up a global calculation field ( 'gfilter') as follows: Global,= isEmpty (extras: Date_received) My question is: How should I proceed from here? Because 'invoices' and 'extras' are in different files, will a globa…
-
- 10 replies
- 1.5k views
-
-
So far I have always used summary reports where sub groups are added together. In my current situation I need to get partial results ie subtract a subgroup from the preceding subgroup like this: 5 3 6 2 16 ---> subtotal sg1 2 2 3 7 ---> subtotal sg2 9 ---> Net1 (sg1 – sg2) .... .... 5 ---> subtotal sg3 4 ---> Net2 (Net1 – sg3) ..... etc... I can’t figure out how to do this in a columnar report with subsummaries.
-
- 0 replies
- 1k views
-
-
Hello to all, I'm finishing the design of a FM database that holds hotels, prices and services. One of the fields has to hold an image of the hotel. As there are hundreds of hotels to be feeded into the database, I've created a button to insert an image into the field. It worked a few days ago and doesn't anymore. I tried several solutions but must be missing something. Even when I transform a container field into a button with the "insert picture" function, it doesn't work either. I know this is a very basic question, and I'm sorry about it, but it gets me very angry as I've managed to put together the whole db with currency calculations, scripts and am stuck with…
-
- 5 replies
- 1.7k views
-
-
Hello to all, I'm finishing a small internal FM9 database of hotels, services and prices (I have a tour operator business that organizes tours to Chile and Argentina). At one point, our operators ahve to use several drop down lists with the services that hotels offer (pool, internet,massage, etc). But if they make a mistake and want to leave the field empty, they just can't. How can I do this? Can I somehow create an "empty" value that would appear in the drop down list? Thanks for the help, Mark
-
- 4 replies
- 1.3k views
-
-
I had a question that I had been wondering about for a little while now... How does the tab panel load the information for the end user. Obviously if you take a tabbed layout and open it in FM7, it will display all the fields overlayed ontop of each other. So does the data load when the fields on each seperate tab is displayed or does it load when the layout itself is displayed? I started thinking about this and how it would effect performance on lets say something like 20 tab panels with 50 fields on each panel.
-
- 4 replies
- 2.3k views
-
-
Is there a way to show the record number within a sub summary? I have created a report with this type of layout: Type A Company C, Avg: 5 Company B, Avg: 4.7 Company D, Avg: 3.2 Type B Company A, Avg 4.9 Company E, Avg 2.4 Type C ... ... The Type and Company are both sub summaries when sorted by Type and Company, respectively. I do not have a body; I wasn't interested in displaying each individual record, but they do drive the calculation for the Avg for each company. That report displays exactly how I wanted it, but now I would like to add a Company's "rank" by enumerating what order they show up inside each Type. So, I …
-
- 0 replies
- 858 views
-
-
var pos=location.href.split("?"); var info=pos[1].split(","); var lat=info[0]; var lon=info[1]; var latlon = new LatLon(lat,lon); // Create a Map object. Put your application ID in place of XXXXXXXXX var map = new Map("mapContainer", "XXXXXXXXX", latlon, 6); // Make the map draggable map.addTool( new PanTool(), true ); //Make the different views map/sat/hybrid available map.addWidget(new SatelliteControlWidget()); //Make the map zoomable map.addWidget(new NavigatorWidget()); // Create a POI marker object marker = new CustomPOIMarker( info[2][color:red].replace(/%20/g," "), info[3][color:red].replace(/%20/g," "), info[4][color:red].repl…
-
- 18 replies
- 3.1k views
-
-
I would like to create a layout which displays a little like an excel spreadsheet. However to show a list of records (Agencies TO) vertically down the left side of the page (List View) with records of Client Names along the top. Where an Agency row meets a client Column for whom they have worked (WorkDone TO), the Invoice total appears. See attached image. - What is the best way to create such a layout?
-
- 5 replies
- 1.1k views
-
-
I am recreating a database to replace a series of excel spreadsheets. The visual views available in excel that we use numerous times to look at our tables is to have customer’s listed vertically, and jobs listed horizontally, and then show their sales numbers listed in the grid area. We can have up to 30 or so jobs in a given layout, and excel allows you to split the screen to “freeze” the customers column while you scroll horizontally and view the numerous jobs. Does any one know how to recreate this freeze ability in filemaker? If it’s not possible, does anyone have any good examples or solutions where you can show a customer list vertically, and then list hor…
-
- 3 replies
- 1.5k views
-
-
I just read that title headers cannot be reduced in size. Does anyone have a suggestion on how to save space on an invoice where I need optional comments above the line items area (above the subsummary)? Right now I have address and contact info, two optional remarks fields, and then column labels (like Qty, Item, Price) in the Title header (all of which I tried to set as sliding up and reducing the size of the enclosing part). I get all this unwanted space when the comments are empty. Any suggestions? I just can't think of a way to make this document look the way the client wants it without that sliding and reducing capability. pz
-
- 8 replies
- 2.2k views
-
-
Hi, I want to be able to count records related to my parent table based on the field's value. The parent table is called 'group' while the related table is called 'individual'. The 'individual' table has a field called 'survey' which has integer values from 1 to 5. I want to create a summary field in the 'group' table which will count based on the value of the said field. For example, I want the summary field to count the number of 3's in the related field. I tried the 'count' function but this counts regardless of the value in the field. Can someone please help? What's a good way to make this work? : Thanks in advance! :)
-
- 5 replies
- 1.3k views
-
-
Hello, In the system I am creating I need the user the user to be able to see the history of information while creating new data. For example, for a given event, he has to update the probability and the impact each year. so I need him to be able to see the previous info in the new form and create new records. Previously the company was using a word table with last year's info and current info.I searched all the documentation I have for filemaker but can't find anything about this. Does anyone have any suggestions? Thanks in advance
-
- 4 replies
- 1k views
-
-
Hi everybody, I have a problem with check boxes.They are normally used to select multiple choices but I can,t check more than one box. I have to uncheck it to be able to check another one. Can anyone advise me about this? Thanks in advance for your help ;)
-
- 11 replies
- 1.8k views
-
-
Hi, Is it possible to dynamically change the "Initial Row" value in a portal through a script or something? Thanks in advance, Nick
-
- 5 replies
- 1.4k views
-
-
The web viewer example provides a hint at what is possible with web viewer but this really seems like it ought to be ground for techniques and examples almost as prolific as custom functions. For instance I have modified the Web Viewer Example to make it easier to configure, have multiple columns, etc and I will post it soon. Besides styles there are various javascript features such as table sorting and (seems to me) we should be building libraries of these functions.
-
- 22 replies
- 3.8k views
-
-
Good Morning, I have 2 questions, the first is more esoteric. 1. I am almost certain question 2 has been asked and answered on this forum, but I can't find it by searching. If someone reads question 2 will you please give me a suggestion for what is the proper way to search the archive(s)for these types of questions? 2. Main Question: Is it possible to change the background fill color of a field based on the result of a calclulation? basically: If Point total = 0 to 25 background color = white 26 to 50 background color = red 51 to 100 background color = Blue etc. Any help would be greatly appreciated. Thanks, Steve
-
- 8 replies
- 2.4k views
-
-
Hi, I have a portal set up with 6 rows. "Show vertical scroll bar" is checked, but no scroll bar appears. The weird thing is, I accidentally discovered that the scroll bar really IS there, it is just invisible. If I click where the scroll buttons should be, it scrolls up and down the same as if there was a bar there. In somewhat unrelated matter, the number of related records viewed in the portal isn't always the same. Is there anyway I can change the length of the portal so it is the same as the number of records? Thanks, I'm kinda new at this. If I didn't explain something clearly please ask.
-
- 3 replies
- 3.7k views
-
-
Hey! Just had a quick question above filtering portal content... I have a "case" page that needs to display data from a "contacts" table... the "case" table and the "contacts" table are linked via a joining table that contains simply a "case_ID" and a "contact_ID". The trouble is, is that there are many types of "contacts". A user needs to be able to look at the "case" page and see all the different types of related contacts in their own sections. To do this, I think I need to create a global variable in my "case" page that I can add to my portal table occurrence relationship (the linking table right?)... but [color:blue]how do I create multiple porta…
-
- 6 replies
- 1.5k views
-
-
Hello If I have two fields side-by-side on a form where each contains a pop-up list of values, and the value lists are related in a parent -> child relationship, is there any way I can dynamically create the second field's values based on the value list item selected in the first field?
-
- 2 replies
- 1.2k views
-
-
This comes up infrequently enough that I can't nail down why it's happening and often enough to be annoying. I find that sometimes, when I'm making text on a layout, either by typing directly onto the layout or using the text tool, the text gets cut off by the box. If I'm typing "Address" then click out onto a blank section of the layout, only "Addre" shows up and I have to manually drag the box larger. I haven't been able to find a pattern, it happened in 8.5A and is happening now in 9A. It happens occassionally, like a couple times a week in different files and different layouts. Can anyone shed any light on this?
-
- 23 replies
- 2.6k views
-
-
Here is my setup. I have a set of radio buttons with Case A, Case B, and Case C. If Case A is selected, I would like another set of radio buttons to become editable. If Case B, I would like a text field to become editable. Otherwise, the second set of radio buttons and text field should not be able to be edited, and preferably grayed out if possible. What's the best way to do this? Thanks!
-
- 1 reply
- 1.1k views
-
-
Just a quick observation that the web viewer does some very strange things when you load a page "say google maps" and then zoom in. ...150...200...300...400 Worth considering if zoom is unlocked.
-
- 0 replies
- 1k views
-
-
I think what I want is a self join relationship displaying information in a portal. I have a very simple database of committee members that I want to do one specific thing with. As I complete a record, one of the fields is "Committee Membership" and it indicates with committe the person is a member of. There are about 20 committees each with about 20-30 members. I would like to add a portal that shows all the other members of the committee when you are looking at a persons record. Ideally, i'd even like to be able to click one of the other members to go directly to their record to view detailed info. Is a portal the right tool? Thanks!!
-
- 1 reply
- 943 views
-
-
Our database has a portal displaying, among other things, a container field which holds images. This portal operates perfectly in FMP 8.5. However, the portal is not operational in FMP 9....no field content is displayed. Furthermore, when viewing the database relationships and fields, the container field is grayed out in FMP 9. If the database is viewed in FMP 8.5, everything works fine. Any ideas?
-
- 3 replies
- 1.5k views
-
-
Ok, Been scratching my head for awhile on this. Simply have a portal that i want to simple show me the calls with the status of "Open" I am serving this file, so my global fields arent retaining thier values...so what is another way to pull out this data?
-
- 2 replies
- 1.3k views
-
-
Hello Guys! Only a quick one: How can I make a Value list show a predefined language from a separate File? I've used this solution for the lables: http://www.fmforums.com/forum/showtopic.php?tid/183314/ Regards Ron
-
- 0 replies
- 1.6k views
-
-
I have a field price_per_pound. (total_revenue) divided by (total_weight) this gives me the price per pound. However in a subsummary preview it does nor calculate correctly. I have 3 other totals that work fine. Any ideas? I used GetSummary and it seems to work right. Thanks to all that looked at this post.
-
- 1 reply
- 1k views
-
-
I have a table with 20 fields. I want to eliminate 8 of them and add instead two fields to hold the data of the eliminated fields. Say my fields are: FirstName, LastName, PhoneNumber, Department1, Address_Dept1, Department2, Address_Dept2, Department3, Address_Dept3… I want to delete Department1, Address_Dept1, Department2, Address_Dept2…and instead add only two fields: Department and set it to be a dropdown where the options/values would be Department1, Department2, Department3… and an Address field to hold the address. This way data entry person can choose Department from the dropdown and put the address in the Address field. My problem is that I need to …
-
- 12 replies
- 1.7k views
-
-
Hi, is it possible to shrink the size of the footer by use of the sliding/printing function ('also reduce the size of the enclosing part') I can't get it to work for the footer. any ideas? TIA
-
- 15 replies
- 3.4k views
-
-
Hi! I would like to hear advices or recommendations about using global fields for the icons of a solution, instead of just pasting them in each layout. The database is intended also to be share in a network. The idea is to change an icon in only one place, not in all around the database, and also to keep it in good size. Tks.
-
- 15 replies
- 2.1k views
-
-
Greetings. I have a vlaue list that users contribute to, and would like to see this list automatically sorted alpahabetically - how can I do this please? Greg
-
- 2 replies
- 1.6k views
-
-
hello I'm new to filemaker pro and I need some help with my database. I was wondering if it is possible to create a value list than contains the current date as well as a few of the dates after it. If it is possible I would appreciate anyone showing me how to do it. :)
-
- 3 replies
- 1.2k views
-
-
Hi there, I am having trouble with a field highlighting when it gains focus. I have a layout with a black background and white radios (easier to see at on-site events) and when the radios gain focus, they become highlighted white. When this happens, you cannot see any of the tags or radio buttons. Does anyone know how to turn off highlighting or, at least, change its color? Thanks, PerryL7
-
- 2 replies
- 1.4k views
-
-
Hi. Ive found no mention of it so thought I'd ask... Is it possible to have Flash plugins or the like that would add greater graphic capabilities to an FmPro application - such as an opening screen - even animated GIFs? Greg
-
- 2 replies
- 1k views
-
-
I'm trying to clean up someone else's data and they have created 10 fields with 10 different values lists each value list has one option. I'm going to make it one field, one value list with 10 options. Creating this is no big deal but I wondering how I'm going to get their data to transfer. Any suggestions on how to go about doing this?
-
- 2 replies
- 1k views
-
-
Newbie question: I'm developing a solution for kids to track the environmental effects of certain waste items. Each item will have many "choices": recycle, send to landfill, etc. Each choice will have many impacts: energy, water, mineral resources, etc. Please see attached PDF. Ideally, I'd like to enter in all this information in one layout: the waste item, it's choices for disposal, and each choices' many impacts. I've been successful in using a basic portal for entering in an item's many choices but not attaching the many impacts to each single choice. Any help would be greatly appreciated. Thanks! ElementsOfWaste.pdf
-
- 1 reply
- 852 views
-
-
Can I disable the apple-D command in 8.0 v.3? I'm having trouble with workers duplicating records accidentally, not being aware they have done it, and then we find redundant records later, with info added on both records. I just want to disable the command and don't know if I can do it without advanced fmp. Any help is appreciated. Mitzi
-
- 5 replies
- 1.6k views
-
-
Hi There I am trying to develop a script to see an field on portal row and create an new window I can only get the script to only select to first row of the portal. Not the individual rows fields looking forward to your thoughts and ideas Cheers D
-
- 4 replies
- 1.4k views
-
-
Seems like the "focus" is lost on mouseup, and so I can't grab the button's object name. Hopefully, I'm missing something obvious...
-
- 6 replies
- 1.5k views
-
-
FM 8.5 adv. I have a calculation GetSummary field in a subsummary part. I need to total it in the grand subummary part. I've tried summary and getsummary calculations but nothing works. They don't total properly . Is there any way I can do this?
-
- 2 replies
- 988 views
-
-
I am trying to post encoded information in an address to get information for each member of an organization. When I copy the posted information in the web address and paste it into another web browser address it brings back the appropriate page. However, when I post the same information in the FM Web Viewer, I get the URL code in the body of the resulting web page because the URL code has been converted during the post process. Is there some way to ensure that exactly what I type is posted to the web site? I have included a sample address to be posted below. Thanks, David http://www6.samplesite.org/member/private/memdetails.cfm?encrypted=%28%25O%5E5…
-
- 1 reply
- 1.5k views
-
-
Hi, I have just created (manually) new records in a "contacts" database. This database has a relationship with a "projects" database. Any previously-existing records display properly. The new records don't display, although it appears to run the script as it should. How do I get portal relationships to properly display new records? Thanks. Seattleflo
-
- 2 replies
- 1.1k views
-
-
Hi, I want the user to be able to select records from a table through a drop down menu.So I have created the recrds in the table and created the drop down menu that shows the items but the problem is that when I select the item it creates a new entry of it. for exemple if I select "client", it creates a new entry with client as a type and a new serial number. Does anyone have an idea about what makes this happen? Thanks in advance
-
- 3 replies
- 1.1k views
-
-
Hi: I've inherited a rather cumbersome database with one table, 1400 fields, and hundreds of layouts. I'm trying to eliminate unused fields. I'm familiar with the Functions: FieldNames and LayoutNames. Is there a way to get Filemaker to tell me every layout a particular field is used in? Thanks
-
- 8 replies
- 1.2k views
-
-
I want to be able to have a tabbed control in a layout that when you click on a secondary tab, the controls for things like next record, previous record, etc. will control a different table than the first tab. In my case, I have a layout that handles administrative tasks for "Employees", "Companies", "Customers", "Vendors". The problem is that when I go to say Customers, any record control is based on the "Employees" table (the one designated via the layout setup. Is there a way to have each tab independently control navigation, data? Thanks in advance!
-
- 2 replies
- 2k views
-
-
Hi All, I'm relatively new at FM Pro and have been struggling a bit with how to set up queries. The below is a little long-winded. But I want to give examples of what I've throught and worked through up to this point. I put it in the portal forum, hope it's in the right place. Anyway... ---- What I want to make: Timesheet DB What I want the user to see: User will create a timesheet for a given week, say July 1-7. They can enter new lineitems to log work done, where the select project, client etc from lists. Then they have 7 date fields labelled mon, tue, wed... where they can put a number of minutes. Relationships: 1 "Timesheet" can h…
-
- 8 replies
- 1.1k views
-
-
I have a database that manages all my clients plus all projects plus other items. On the home page I have a portal that is currently showing me all active projects. There is a relationship in the home db in s field called gStatus to the project field called status. I'd like to create a second portal on the home layout that can show me all pending projects. I've tried creating another field but how do i tell the new portal to use the new field for its view. Any advice on how I should go about this would be great.
-
- 2 replies
- 958 views
-
-
I have a db that uses a series of hierarchical portals (or filtered portals). The portals are different tables and they relate to table called CS (Content Standard). The hierarchy works fine. It goes through Grade, Subject, Area, Topic, Subtopic, Benchmark, and Benchmark Component. The CS T.O. is related to a T.O. (based on a separate table) called "People." I want to show the results of the hierarchy in a portal on the "People_Form" layout. This works fine except for one thing: the subject field always show the first item in the subject portal (which is "English-Language Arts"). The rest of the hierarchy is fine. The file is too big, even when I put it in…
-
- 6 replies
- 1.8k views
-
-
I'm trying to create a table of contents page for my database. There is a print in colums option in Layout setup that does something very similar to what I want, but I need it in rows, not colums. Is there a way to do it instead? This seems pretty common sense, so I'm sure it's there, but can't find it in the manual. I'm trying to have each record take up a row, not a column.
-
- 2 replies
- 989 views
-
-
HI, Running Server 8. I'm on a Mac 10.4.10 Just finished a letter layout with 9.5 adv - looks fine and prints fine. But the same layout on another Mac running FM8 has huge line spacing like an inch and a half between lines, but the "paragraph" settings are the same - 1.00 lines. Font is Optima an is on both machines... Any Ideas??? Thx
-
- 1 reply
- 952 views
-
-
:bang: I have a database that manages all my clients and current projects. I would like to create one layout that holds on navigation that I could then include in each layout. This way if add a module or remove one the navigation would automatically be updated to all layouts and it would not require me to edit all 100+ layouts. Is this possible and if it is how ?
-
- 4 replies
- 1.1k views
-
-
Hi, Is it possible to make a portal inside a portal in Filemaker Pro?
-
- 3 replies
- 3k views
-
-
Is it possible to set up a list type layout for printing, where a "notes" field will "expand" to accommodate the printing of the field's entire contents? Other records without contents in the "notes" field would still print on a single line. I believe that is is a feature found in Excel. Can it be done in FileMaker? Thanks, Dudley
-
- 3 replies
- 1.2k views
-
-
I didn't see an area dealing with attributes so hopefully this is the right place. I've placed an auto-enter serial no. attribute in the header of a report layout. With each new occurrence of the report a new serial appears in the header but when I attempt to print this auto enter attribute does not print. The 'do not print this element' is not clicked in the format menu so I know that's not the problem. 'print/sliding' is also not clicked just in case there might be some issue with that. Am I breaking some basic DB rule by having an auto enter in the header? The auto enter criteria creates a new record with each report I pull up. This is a batch report th…
-
- 5 replies
- 1.1k views
-
-
Hello I am stuck on finding a way to highlight changes. I have a database that changes often and every once and a while I need to write out a report detailing the changes. What I have currently been doing is just changing the text color on the fly so that it is red. It is extreamly time consuming but better than having to compare two whole copies of a printed database. I have been racking my brain to try and find a way so that filemaker can do it automatically. I want everything that I change to turn red and then when I hit a button everything returns to it's original color. I tried an Idea with duplicate fields for each record/field that kept track…
-
- 5 replies
- 1.2k views
-
-
I think I should give an overview of what I am trying to accomplish. I have an inventory table that has maybe 350 sku's. These skus are a part of a product line, maybe 3 or so different SKUs for different colors of products that are in the same product line. I am attempting to make a quoting module that asks for the customer name, to quote this to, and then display a list of ALL of the Product Lines, prompting the user to choose yes or no for each line, if they mark yes then the SKUs that belong to that product line will be included in the PDF that is generated. I can't seam to display the list of product lines as a portal. Is there a recommended way I shou…
-
- 5 replies
- 1.2k views
-
-
I was wondering if there was a way to organize layouts into folders or seperate lists. I am starting to built up databases with way too many layouts mostly for sending letters out to clients and it is becoming unorganized. Also, I was wondering if there is a easy way to copy layouts from one database to another. Right now I only have the client version of filemaker. Do I need to purchase the advanced version? Thanks for the help, Kaduby
-
- 3 replies
- 982 views
-
-
Now that I'm almost finished I can tell you what a stupid job I'm doing here. I do catalogue descriptions in both French and Dutch. Some of those descriptions (e.g. for jewelry) contain often the same words and parts of a sentence. I thought I might click them from a portal in stead of typing them over and over again or copy and adapt them. I came up with a tabel containing (for the moment) nine records with each 12 fields. Thus I can make a portal of 84 fields. To make it easy to use I covered each field in the portal with a button. You click it, the contents is pasted in the right spot in the right field and a sentence in reasonable Dutch or French grow…
-
- 8 replies
- 1.3k views
-
-
I have two layouts, and I would like to be able to combine them into another layout that will list information from both. In one of the tables, teachers are able to evaulated the student's attitudes about various topics, in another table it holds the grading information, for each level, and the individual classes. since each teacher is allowed to input their opinion of the student's attitudes I have created a summary field, which takes the average of the opinions for each level. The layout shows the class, the teacher, and their scores and at the bottom the average scores for that level. On the other layout it shows the overall grade for the level, the in…
-
- 0 replies
- 889 views
-
-
I have a text field called Customer_ID_String. It appears on a layout formatted as a drop-down value-list field, with Auto-complete. There is another field, Customer_Number, defined to Auto-enter a calculation based on Customer_ID_String (via a simple relationship to the CUSTOMERS table) Ordinarily it works fine when the user does the typing into Customer_ID_String. Then I tried to give a default value ("indiv") to Customer_ID_String, using auto-enter calculation. If the user chooses to accept the default value (tabbing to the next field without entering some other ID string), Customer_Number does not automatically recalculate itself! I've tried using auto-…
-
- 10 replies
- 2.4k views
-
-
I am required to use a Word file for our estimates. I am trying to create a layout so similar (in FM) that my boss will let me use my database verus word to write the estimates. The problem is we have a lits of possible iproductes in a list in the word file and most are not used in every quote.. is there anyway to create a field with a large amount of data with the ability to edit it on the fly? look at this word file - it will help with my question
-
- 6 replies
- 1.5k views
-
-
Hi, After the creation of my database, I have figured out that I need an additional field in one of the tables which I did. but the problem is that the new field does not show up in the layout of that table and new records are not created for that field. Any suggestions? Thank you for your help
-
- 4 replies
- 1.1k views
-
-
I have a navigational problem !! When I use a script to go back to a layout with multiple tabs, it is not possible to go back to where I was before executing that script. So is there a way to know what Tab is the front most or active ? Xoomaster
-
- 15 replies
- 3k views
-
-
Hi. I'm new to this forum and a novice to Filemaker. I have build a few simple database solutions but now am trying to expand my skills by creating a Knowledgebase, to be used in a business environment. First off, have any of you ever developed or seen a knowledgebase created with FileMaker? I have searched the web, looking for an instance where FileMaker was used to create a knowledgebase, and hopefully look at a screen shot or two, but I can't seem to find any examples. Secondly, I have already created the input form where the user can input a question or statement, and the same user, or others via Instant Web Publishing, can contribute to the answer or exp…
-
- 0 replies
- 977 views
-
-
Hello, Can any one tell me what I'm doing wrong or if indeed it can be done. I'm going to describe it in it's basic form but of course I have lots more field in the database I'm using, just removed all the field name to make it easy to see what I want. OK, I have tables as below with the fields in them as shown: customers: cutomer_ID customer_name customer_company bookings: booking_IDfk booking_type booking_date The "customer_ID" is a serial number created on any new record. I then have two LAYOUTS, one for CUSTOMERS and the other for BOOKINGS. What I would like to do is have a button on the CUSTOMERS layo…
-
- 3 replies
- 1.1k views
-
-
I was thinking about how to create a custom community per se and then map all locations within a particular radius of the starting address point of location where the end users would enter. I would like to build this radial community with Google Maps. In other words, lets say we have a db of various categories of merchants in areas, such as lodging, restaurants, entertainment, shops, etc as well as the addresses. Has anyone messed around with API enough to mark up a custom community? What I would like to end up having is the end user putting in a location and it finding all the various mechants in the vicinity and of course be able to filter it by category.…
-
- 8 replies
- 2.8k views
-
-
I am trying to generate a Dynamic layout based on the data people have entered, the layout is a report where sections will be added or removed based on what info they entered. I can parse the data fine I was wondering if anyone knew a good way to add or remove fields from a layout?
-
- 3 replies
- 1.2k views
-
-
I made some form letters in different layouts with merge fields. They are great for printing. But I would like to email them, is there a way to do this? Thanks
-
- 8 replies
- 1.2k views
-
-
Hi does anyone know how to create a simple list of numbers that dwindles as you choose them. I have one number field with a drop down list of numbers 1-10 and I want the end user to allocate a unique number to a small amount of records. 14 records max. Yes I have seen some of the examples on here, but they seem overcomplicated for my requirement. In other words far too complicated for me to understand. Thanks in advance
-
- 3 replies
- 1.4k views
-
-
Since this "subforum" is just sitting here with top google ranking and zero content, I may as well point you to a couple of our articles that deal with conditional formatting: http://sixfriedrice.com/wp/filemaker-9-tip1-hiding-something-on-the-layout/ http://sixfriedrice.com/wp/filemaker-9-tip2-disabling-a-button/
-
- 1 reply
- 1.6k views
-
-
Hi, I've done a database which contains mailing adresse with streets that belongs to city. Here's the schema: Mail (pkMailID, fkStreetID) Street (pkStreetID, name, type, direction, fkCityID) City (pkCityID, name) The question is how can I select the right street in the good city? Let say the user enter the street and after the city. How can I make fkStreetID be entered automatically?
-
- 0 replies
- 969 views
-
-
I have recently taken on a project which has introduced me to FileMaker, though there is no one with much experience on the program so the minimal knowledge I do have has come from the User's Guide, the Help section in the program itself, playing around with the program itself, and reading old topics in this forum. The User's Guide is not much help as I am not terribly computer savvy. At present, I am trying to create a layout/table (not sure which word is accurate here) in my database for donations. On this layout/table I need the top section to have information like the Purveyor, Donating Organization, etc, then the bottom to have a table (not in the FileMaker sen…
-
- 2 replies
- 929 views
-
-
I have this report layout built for one of the Doctor's I work for but I am stuck. Most of the report fields are averages but for margin% field he wants a percentage from margin field. The margin field data is either a 0 or a 1. I thought this would be simple enough. I want a total of all the records in the database. Then add up all the 1's in the margin field. Divide the record count by total of 1's in the margin field to populate the margin% field. This sounds simple but I rarely have to do a calc of this nature and it is making me crazy. Am I making this harder than it should be? Any advice appreciated. I am still trudging through the fm…
-
- 3 replies
- 835 views
-
-
I wonder if this is possible: I have a image db solution that is used on Mac and PC. Management want users to login automatically. Is it possible to send the user to a Mac or PC specific layout based on the system platform. Or hide layouts based on which platform the db is on. I know how to do this with specific accounts and have the user login.
-
- 2 replies
- 895 views
-
-
Hello, We have a portal that could have any number or rows so we won't know if there are 3 portals row or 10. The thing is that we want a tab within our portal, is this possible. I thought it was but when I place a tab in the portal it only shows up in the first portal row. Please let me know if it's possible to have a tab show up in multiple portal rows. Thank you, Dustin
-
- 3 replies
- 1.2k views
-
-
Hello... I've recently been asked to create an employee database which includes each user, their computer models and service numbers, windows version, etc., and a notes field. I figured everything out, except how to create a notes field (or Table) that includes the date is was created. I would need to be able to add a new notes section for each record periodically, and would really like the date to be stored also. These notes would need to be viewable on the main window that contains all the other user info. It would be preferrable if the new notes would appear at the top and "push" the old ones down... Am I out of luck, or is this possible....It's similar …
-
- 6 replies
- 1.2k views
-
-
Hi, I have a native Filemaker tab set on on of my layouts. Using FM 8.5 and the GotoObjects, I have created a few buttons to go to the tab that I want it to go to. All this works fine. But I want the tab to look hidden so I changed the font size of the tab itself to 1 pixel to shrink the size of the tab. When I put the buttons on the layout, I need them to go over teh tabs. I played with the arrangement of the object layers but still no good because whenever I go to click the button, if I click the button in the spot where whatever part of the tab that it covers is, then it activate to another tab. I thought by putting the button or another object on top of th…
-
- 11 replies
- 5.1k views
-
-
Can't really add to the subject ;)
-
- 3 replies
- 1.2k views
-
-
Good morning. When it comes to Filemaker, I am not even a beginer, I am for the lack of a better word, totally ignorant. I just registered at this forum and when you register you have to answer certain questions as to what version you use etc. Since there was no option for "none", I put the lowest version. Please disregard that. I don't even have Filemaker. Never did. The purpose of my thread is two folds: 1-How does Filemaker compare with alpha? 2-I am a long time user of alpha. I have recently designed a development module that solves many of the most daunting problems with alpha. I had a feeling that the same problems are common to both programs. I was…
-
- 8 replies
- 2k views
-
-
Hi, I am a MAC user using 8.5. I have a layout with fields each containing their own value list. Everything was working fine until today I entered a new record and one of my fields containing a popup value list will not display the list. The other popup lists appear for other fields just fine. My previous records all work fine. The problem only appears in my new records in this one particular field. I checked the field formating and can see no problems. I have recovered the file hoping that would help. Can anyone please help me? BTW, I have also had trouble sorting by last name (a field which is linked to another file). I can sort by date and other fields…
-
- 1 reply
- 939 views
-
-
Hi. I am having difficulty printing acceptable quality from Flash graphics in a Web Viewer. I have enclosed 2 screenshots of PDF's printed on Mac OS X. One is from Filemaker regular printing, the other is from Flash using the contextual Print command. It looks like Flash is using the full quality available for the printing, while Filemaker only uses the visible data in Web Viewer. Does anyone have any ideas how to increase the print quality from Filemaker? I have several of these charts on the same report and I need to print them on the same page, therefore I can not use the Flash printing. Cheers, Andreas FM_print.pdf Flash_print.pdf
-
- 0 replies
- 992 views
-
-
Hey all, sorry if this is a dupe question.. I did try to search for it first, figuring I can't be the first to run into it. assume I have only two databases: Parts, and Contacts. Parts have a field called "part types", where I can indicate if a particular part is a tool, pipe, or a fitting. (in the real world, there are many other options). In contacts, I want to show what tools a contact owns, what pipe, and what fittings. I would LIKE to use relational value lists for this, where in contacts, there is a checkbox set for each category (trust me, it is workable from a data entry standpoint). I set this up, and found that the relational value …
-
- 10 replies
- 1.6k views
-
-
Hi, I'm creating an invoice system for an entertainment agency based on relationship tables and databases. I have a database for clients, performers and events. Within events, I have two tables. One for the event, and another for the invoice. What I want to do is for an invoice to be automatically generated when certain criteria are met. I think this may be a portal, but I want to include information from another database that isn't in the event form. I hope that wasn't too confusing Thanks for your help Hayden
-
- 1 reply
- 802 views
-
-
I have a portal in one table showing address information. I would like to click on the record in the portal and then click on a button that would be scripted to take that information and put it into the correct field of a current record in another table. Can anyone help me with this? I am not sure what that script would look like.
-
- 2 replies
- 968 views
-
-
Yup, another newbie! I'm running a solution for my police department containing over 30,000 records. The solution has roughly 20 tables and is used for everything from keeping arrest records and traffic ticket information to reports and general complaint information. My problem is this; I have a layout which has around 50 summary fiels which keep a running summary of statistical information. When going to this layout, it takes a rather long time to summarize and dispaly the results. It wasn't bad when there weren't so many records, but it's taking more and more time as the number of records increase. Is there a more streamline way of using summary fields…
-
- 1 reply
- 1k views
-
-
Value List looks like this: 1 = New 2 = Used 3 = Collectible ..but only enters the number, not the rest of the line. The rest is there only for the user to know which number reflects the quality.
-
- 4 replies
- 1.1k views
-
-
Hi, I'm not sure if I am posting in the right place but I'm very new in the form so forgive me if I do a mistake. Tha database I'm planning is a relational database and I would like to create a form to enter that data in different tables for creation and updates. Is it possible to have this with filemaker 8.5?
-
- 7 replies
- 1.5k views
-
-
Hello and thank you in advance. I am using Filemaker 6 Dev. I have a global Field for the relationship and i have a field in the target file that has all of the keywords for the entries seperated by a return (they are on seperate lines.) What I want to do is enter more words in the Global field and have it Narrow the entries intead of expand. Right now if I enter "Lobster" and a return and then "Johnson" it finds both "...Dave Johnson...","...Devil Lobster..." and "...Lobster Johnson..." when I want it to only bring up "Lobster Johnson" in the Portal. Is there a way?
-
- 3 replies
- 1.2k views
-
-
Ah, what's the easiest way to check if a web viewer has loaded it's content?
-
- 10 replies
- 1.9k views
-
-
I've got a Filemaker solution that I'm working on and I've run into some difficulty. I'm trying to create a timetable matrix report for a school information system - but it seems pretty difficult to do what I want. The report will have columns representing each term, which are managed by adding/removing records in the tblTerm table. The rows in each table are the individual periods that appear in the schedule, these are managed in the tblPeriod table. The information that needs to be displayed in the rows/columns comes from tblCourseEnrolment, and contains information such as CourseCodes, CourseNames, CourseTeacher, CourseRoom, CourseTerm, etc. The t…
-
- 1 reply
- 3.6k views
-
-
In a database that I am currently developing, I have text boxes that should be able to grow as the user types.... but I want the contents to grow and the field provide a scroll bar. Currently the field is growing and covering up the lower fields. I have attached a screenshot to show the issue. Thanks in advance (when I type in this box.... at a certain point a scroll bar comes up and the box doesn't grow, but I can scroll to type more and more and more).... that is what I want to do in Filemaker. Any advice will be greatly appreciated
-
- 2 replies
- 845 views
-
-
I am sure this has been covered, however I am working in FileMaker 5.5 and I sometimes run into trouble using FileMaker 8 calculations. I have two date fields "Target Launch Date" and "Launch Date". The Target Launch Date must be less than the Launch Date. If the Launch Date is greater than the Target Launch Date I need for the field or Text to turn red. Any suggestions? Thanks for your help.
-
- 6 replies
- 1.1k views
-
-
Hi! I have a newbie question. I have a long layout that goes across multiple pages. I want to set up a button so that on page one, I can automatically be taken to the start of page 3, without scrolling. How do I do this? I've tried several options, but can't figure it out. Thanks!
-
- 3 replies
- 1.1k views
-
-
Hi, I am pretty new to Filemaker and I am programing a database to store my to-dos and appointments. I have one table that stores the To-dos, one table that stores the work times that I have to do the tasks, and a 3rd table that combines them so that I can have a many to many relationship. I also have a table that holds appointments and a table for the calendar. I would like to be able to show all of the appointments and worktimes (with included tasks) in one portal (or at least in the correct order sorted by time of day) on the layout for my calendar table. I may have made this too complicated, but I would love any help I could get. Thx! Hailey
-
- 0 replies
- 952 views
-
-
How can I modify the properties of a textbox, input field, etc using a script? I'm trying to do 2 things: Having my print script delete the header labels for some text fields if the fields are empty, and having a button disable input into certain fields. For the second one, I know you can do this with behavior property, but I can't find this in the script menu. To get rid of the header labels, the most elegant solution would be something like "If IsEmpty(table::field), delete label1". Alternatively, it could change the text value of label 1 to "", or set the color to white. Is there a way to do any of these things? edit: I can't even find unique identification f…
-
- 2 replies
- 1.4k views
-
-
Is there a way to change the setting for layouts "save record changes automatically" globally or do I have to change each layout seperately?
-
- 1 reply
- 881 views
-
-
I am trying to get the colors in my FM layout to match certain CMYK colors. Everytime I enter the CMYK colors, FM changes them significantly. I know FM runs of RGB but does anyone know of a way around this besides randomly guessing colors - I need them to be very close to exact.
-
- 12 replies
- 2.1k views
-
-
Is there a way to insert tables or images in a text field? Maybe something that involves importing document files (PDF, Word etc) into a text field? I know it's possible since I've seen a (secured) filemaker file that has this. Thanks.
-
- 1 reply
- 1k views
-
-
I have a database where the go to related record work on one layout and not the other. It works in a T.O. relationship between Organization and Individual (a one to many relationship in my case). In the Organization layout I have a portal with all the employees of that organization. A button within the portal takes be to that particular employee's record in the Individual layout. The button runs on a script. I also have another layout where it does not work. And it does work. (Yep, confusing, I know). I have a portal in an layout called Invoice. The portal shows all the individual line items and, like to Organization/Individual relationship, the Invoice/Line …
-
- 9 replies
- 1.6k views
-
-
I have Two fields named location. Location_1 and Location_2. Basically when an address is entered a location type needs to be assigned to it. Location field has a value list assigned with 4 possible location types: Main, Billing, Shipping and Other. So when an address is entered the location is chosen. I set up one more calculation field (Location_calc) which calculates Location_1 & Location_2. I made one more value list which displays values from that calculation field. In my invoice layout a new field which has a value list assigned to it (value list that shows values from Location_Calc field). When a value is chosen the address fields on inv…
-
- 1 reply
- 929 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online