FileMaker Interface Features
-
<> Should I list my solution for others who might have the same question? Hello all, I have never had the need to try this technique so I don't know if it is possible, but I am hoping it is. I tried searching the archives but did not find anything that specifically addressed this question. Is it possible to set the contents of one portal to another portal where the relationship in that portal "allows for the creation" of records? I can get it to work for the first row in the portal, but not the next one down that does "not yet exist." Thanks if anyone can help. Steve
-
- 0 replies
- 753 views
-
-
Hello, Well I’m stuck again. I am still working on my “Victim” database here at work and have a question about photos. I have an area with a container for the victim’s photo. What I want to do is have the container that is not used for a victim’s photo default to a “No Photo” image in the container. I have the “No Photo” JPEG constructed, but I do not know how to make the Photo Container default to this image. Hopefully to clarify: when a new victim record is created, the photo container automatically shows my “No Photo” JPEG until the user adds a photo of the victim to that container. Can this be done? Thanks, James
-
- 4 replies
- 1.9k views
-
-
When I create scroll bar in my portal it is invisible. The scroll works but i just cant see the scroll bar. the portal tool makes room for the scroll bar, and the portal looks different when show a vertical scroll is selected, but invisible. Anyone seen this?
-
- 4 replies
- 1.2k views
-
-
As much as I have tried, I cannot find a way to get the 'Directions' option of Google Maps to work. The basic code I am trying to use is: http://maps.google.com/maps?f=d&hl=en&am%20p;saddr=/*source address*/&daddr=/*target address*/ The Google Maps page comes up, but only with a map of the target, it doesn't give me the directions pane.
-
- 1 reply
- 1.1k views
-
-
Hi, I spent so much time trying to accomplish this in a portal but I can't get it right. I would like to present an "on-screen" customer account as below: I have a customer file & transaction file and they are related via custid. Custid: 1234 Customer: ABC Company Reference.....Debit......Credit.....Balance --------------------------------------------- C/F......................................50 Invoice1....................100.........150 Invoice2....................200.........350 Pay1............100.....................250 Interest.....................10.........260 Any help would be highly appreciated. Regards, Garry
-
- 2 replies
- 1.1k views
-
-
Hello filemaker gurus! i am trying to use the "set next serial value" function. I have a field ,set as auto enter serial number. So why it does not work? Someone can check it? thanks! stefano trial.fp7.zip
-
- 5 replies
- 1.7k views
-
-
Hello, I have been using the "copy all records" method to capure the found set of IDs. I think i saw another method that avoids the pasteboard but can not for the life of me track it down. Think it used a List ( ) method. Anyone point me in the right direction. best Stuart
-
- 12 replies
- 3.6k views
-
-
Is there anyway of adding to or customizing the fill and pen patterns that come with Filemaker?
-
- 2 replies
- 802 views
-
-
Hi, I have an email address database with three layouts. All three layouts display the same name and email address but different qualifiers (e.g. layout 1 - Safety Committees -- name, email, position, name of safety committee; layout 2 - Mgmt Committee -- name, email, position, name of mgmt committee) I created my layouts to display in list view. Now, is it possible to selectively display records in the different layouts? the reason I'm asking is that there are people that occur in both, safety and mgmt committees, and I do want those to show up in each layout, however there are those, that only belong of the layouts, however they also show up in the other .. (…
-
- 1 reply
- 900 views
-
-
Is there a work around for this Valuelist showing as well as field 1 / field 2 example : 100 aaa 100 bbb When selecting in a dropdown I get only 1 possibility to choose: 100 aaa Kind regards
-
- 3 replies
- 1.2k views
-
-
I've looked around a bit and not found what I'm looking for, so here goes... For each Contact record I can have several phone numbers. The Phones are in their own related table and shown in a portal window on the Contact layout. What I want to do is allow one and only one of the Phone numbers for each Contact to be marked as "Main", thus making it unique in that portal for that Contact record. If I were doing this in MySQL I'd index the combination of "Main" and "ID", making the combination unique, but I don't see how to do this in FMP. I tried working it by creating a new field that combined those two fields, but I can't make a calculation unique (or can…
-
- 3 replies
- 952 views
-
-
Hello, Is it possible to enlarge a container image if this field is viewed via a portal? In my experience, portal fields are only large enough for alphnumeric characters which results in container images impossibly small. I would like to be able to adjust an image to about 1-inch in height and also be associated with the portal fields to which it is associated. Or perhaps there is a way to script a larger version of the associated image in the parent file? At the moment, the image has been inserted into the container field, but is too small to be of any use. To be clear, I sell a line of greeting cards and I want to be able to view the actual card…
-
- 12 replies
- 2.2k views
-
-
Are there any rules regarding amending fields whilst using multiple windows? We are using FMP over Lan network and several users have queried that information they thought they had added to fields has apparrently disappeared. The database is a "One File/Multiple Table" system. Is it possible that it is the use of multiple windows that could cause a problem?
-
- 1 reply
- 876 views
-
-
Hello, Since I want to hide the status area, I'm trying to show the record number of the found count within my layout. I'm using Get(Recordnumber), Get(Foundcount), and Get(TotalRecordCount)in a calc that looks like this: "Viewing Record: " & Get ( RecordNumber ) & " of " & Get ( FoundCount ) & " Total Records:" & Get ( TotalRecordCount ) When all records are showing it works fine, but for some reason when I do a find the record number remains the number it was when all records were showing, and the found count remains the total count. For example, if I have 100 records and Mr. Smith is record 49, when I find for Mr. Smith (assuming…
-
- 2 replies
- 852 views
-
-
I'm new with FileMaker and read some of the topics about filtering value lists etc. But I'm having a parent-child problem with my program: say I have a Category-table. I want to make a difference between a main category and a sub-category. When I create a new category, i need to select if it is a subcategory or a main category. In parentID I want a value list that displays only the category's that are marked 'main category'. For example (screenshot): The drop-down list should only display category's where CatType = mainCategory It's probably pretty simple..
-
- 1 reply
- 1k views
-
-
I want to be able to display something like the attached picture. I have a table with project names that are organized into categories and I want to be able to display them sorted by their categories with category name dividers between the items in the list. This is obviously possible, and quite simple when using a sorted column/list report and having things separated by layout parts. But I want this look when in a standard browse mode looking essentially at a portal. I can probably create a mockup of this by using some graphics and some cumbersome sorting algorythms with relational filters, but I'd think there should be an easier way. Any ideas?
-
- 2 replies
- 1.5k views
-
-
i have filemaker 8 on one computer,networked to 8.5 on another one, It has been working like charm for long time on my EMR in the clinic, now there is a problem, when you are typing inside a field and you hit enter to start a new line it prompts you to save the file and exit the whole think, that happens on both computers, if you restart the main computer it works fine for a while then that behavior happens again, any ideas?
-
- 2 replies
- 1.6k views
-
-
How can I execute a script whenever the person changes their layout? I want each layout to sort records differently. thanks, dave
-
- 4 replies
- 930 views
-
-
For months I've been trying to come up with a method to 'hide' the first field in a value list after it has been selected. I want to use a value list that draws from a table and stores the key field while always and ONLY displaying the 2nd field. For example, I have a table called reps that has a rep_id field, and a rep_fullname field. On an order table's layout, I have a field for 'rep' which is a value list that draws from the reps table. Everything works fine so far, I've got the value list definition set up so that only the second field is displayed. Except after the user makes their selection and moves to the next field, it is the value from the key field that …
-
- 1 reply
- 858 views
-
-
Hi, my name is Kellen. I am new to Filemaker and I'm making a database for a free medical clinic I work at. I can't figure out a problem that I've been pondering and researching for quite a while now. no posts here hit upon it: I have a layout that shows records of medical clinics in a list (maybe 15 per page). I have other separate layouts that display the same records in different manners, more condensed, different information about the clinics, etc. I want to be able to print a referral sheet for clients that will have major clinics listed in a more detailed way then right after that, more distant or less important clinics listed in a more condensed format (tha…
-
- 17 replies
- 2k views
-
-
Hi everybody! New here - quick question which I'm sure is asked a lot, but I tried searching under "list view wrap" "list view row height" and a bunch of other queries, but can't find the answer: Is there a way to set up a layout so that in list view, if the contents of a field are longer than the column permits, the field displayed/printed will automatically get as tall as it needs to to accomodate the data? Basically, the goal is to have each record take up one line if possible, and if any particular field (free-form notes, for example) exceeds the width available, then the record automagically gets as tall as it needs to without making any of the other r…
-
- 2 replies
- 1.1k views
-
-
I am not sure if this is where I should post this question but.... I have a script that finds the current events in a db (FM 8.5). Current meaning active events that haven't happened yet. The layout I view these events is in list form and I would like to be able to quickly spot the events that share the same date by having their displayed fields ( Artist, Venue, Start date, End date, and Engineer status) backgrounds change from white to a color. If anyone here has any ideas on how to do this I'd appreciate it. Chris
-
- 1 reply
- 972 views
-
-
Hi I have a date field in the header section of a report format that is not printing, but can be seen in both Browse and Preview mode. In the header section in Browse mode there are buttons, that are not printed, and a title field that is printed in the finished report. These are set appropriately. When it comes to the print out there is no date just the outline of the field. I have checked the font colour, background colour, sliding/printing settings, but can't seem to find the reasons for the problem. Any help is gratefully received Thanks :)
-
- 2 replies
- 934 views
-
-
FMP 8.0v3 Avery 5160 address labels 2.625" x 1.0" The automatically-generated layout for Avery 5160 is only printing 9 rows of labels per page. Should be 10. I'm totally confused by how to configure. The top left corner of the top left label is at 0.5" from the top and 0.375" from the left (of the physical 8.5x11 sheet). Each 2-5/8" x 1" label is separated from the next by a 0.125" gutter horizontally and a 0.0" space vertically. The automatically-provided layout for 5160 just looks wrong: for one thing it contains a header part that's 0.236" tall. The fixed page margins (in Layout Setup) are: top=0.25"/bottom=0.56"/left=0.19"/right=0.19". Th…
-
- 0 replies
- 2.8k views
-
-
Has anyone seen an improvement in the window redraw flashing using Vista?
-
- 0 replies
- 837 views
-
-
My layout has a field that uses a radio button set. I would like the field to show the No button selected when the layout is displayed, but can't find a way to do that. Any help would be appreciated.
-
- 2 replies
- 868 views
-
-
Hello All: I am new to this forum. Hopefully I am posting this in the right spot. I have a database with a field that is set to auto complete using previously entered values. I am using this field for the names of current client projects. I would like to delete items from the index when a project is completed. But when I go to the Insert Index menu and try to delete an item, it won't let me do this. Can someone tell me if there is a way to do this? If I need to just clear the entire Index periodically I am okay with that. It will get reloaded as I enter current projects again. Thanks Suzanne
-
- 2 replies
- 820 views
-
-
Hi! Can anyone give me a hint to get the FileMaker Themes Pack solution, as I understand it was available until Dec. 2006. Thanks in advance.
-
- 3 replies
- 2.3k views
-
-
Hey everyone, I'm designing a database that will have information in fields that may or may not be confidential. Rather than creating separate confidential and nonconfidential fields for each piece of info, I was hoping it might be possible to have a checkbox for fields that can be activated when the info is confidential. The question is, how can I do this without creating a checkbox field for every single field that I am making? Not possible?
-
- 14 replies
- 1.6k views
-
-
Hello all. I would like to know the best way to replace/update a layout without causing problems (as I recently did!) Recently I needed to work on a layout (add a few fields to the layout, shift some things around). I created a duplicate of an existing layout, named "Existing Layout Copy", and made my changes to my copy of the layout (while the dbase was hosted). Then when all users were out of the dbase (but it was still hosted), I changed the name of my layout to match the existing layout (since 8 allows layouts with identical names), then IMMEDIATELY added the word "OLD" to the previous layout. I also moved my new layout to the same position in the layout li…
-
- 5 replies
- 1.2k views
-
-
I want to create a value list of dates that will be chosen to view timesheets. I want to start with a date, have the date 14 days later, and so on, but not dates in the future. Today, it should look like: 2/19/2007 3/5/2007 3/19/2007 4/2/2007 But starting on 4/16/2007, it should look like: 2/19/2007 3/5/2007 3/19/2007 4/2/2007 4/16/2007 And I want this value list accessible from different layouts based on different tables. I'm having trouble because I can't base a value list on an unindexed field (ie a calc using Get(CurrentDate)) or a global (ie setting a global to my list of dates on opening). Any ideas?
-
- 3 replies
- 892 views
-
-
I am using 8.5 adv and I am trying to fill a field in my Assignments TO from a related Position TO. I am filtering the portal by programs. I have a dozen programs and almost a thousand positions all total. The filter is working. When I select a program from the filtered global field it enters that program key in the foreign match key of the assignments TO. It also filters the positions for the selected program in the portal of the Position TO. In the portal I have a button with an "Assign" script which is supposed to simply take a value from the selected row and enter it in a foreign match key field in the Assignments TO. But the Assign script is not working. It is: …
-
- 0 replies
- 923 views
-
-
Is there a reasonably forthright technique to populate a value list using the contents of a repeating field? I have a global repeating field that contains the current acceptable values for a particular user-entered field. The values in the global field can be modified, if ever needed, by a system administrator. There are only six repetitions in the field. I've searched, but haven't been able to find an answer to this simplest of cases. My own efforts have resulted in "this value list will not work because the field cannot be indexed". I really don't want to resort to a dedicated table for this one-field usage. Thanks in advance for any suggestions.
-
- 6 replies
- 4.7k views
-
-
I've been working (for some time!) on creating a personal accounts solution and I'm currently into my second revision. One table is given over to Petty Cash transactions. Petty cash has been isolated from two other transaction tables in order to produce two separate results. 1) Sending some detail along with other summarised info, via scripting, to another table. [Currently successful.] 2) Producing a monthly statement for printing, inclusive of running totals, brought forward and carry forward totals - and this is where the problem is. I have been able to create a working report from within the Petty Cash table utilising a sub-summary part and breaking …
-
- 2 replies
- 926 views
-
-
I have a value list (company) that has grown too big and I want to move it to a new table. I didn't know it at the time, but I should have created a separate company with a relationship and a pop-up menu from the project table to the company table. I know how to create the relationship but how do I move the company data to the new Company table and still keep it connected with each original project record. I tried auto-enter, calculated result, COMPANY::company = PROJECT::company but it doesn't seem to work across tables.
-
- 0 replies
- 982 views
-
-
Is there a way to create a value list using the values from as many as 10 different fields? If anybody can help me here I sure would appreciate it. Thanks, Jarvis
-
- 3 replies
- 1k views
-
-
Hello, Could someone please explain how come sorting and preview mode are needed for a subsummary to work? Is this intuitively obvious and I'm missing it? I've read pages 48 and 68 in FMP 8 User's Guide without spotting anything about this! Otherwise, I am just doing this mechanically without understanding the underlying logic. Thanks in advance and cheers!
-
- 5 replies
- 1.6k views
-
-
I'm working on a database for my babysitting business. Right now, I'm trying to create a portal in the Jobs page that shows what sitters are available for the given job time and date. I have successfully created a portal that shows available sitters but it uses a script to work. I'd like the portal to automatically populate availible sitters for the selected job using time and date criteria. Can anyone help? I've included the work-in-progress database. It has little formatting, and I have yet to include some of the more basic fields needed for full functionality. (Client addresses, etc.) Thanks in advance for any help or pointers. Sitters_5.zip
-
- 0 replies
- 1k views
-
-
Hi, How do you assign a script to a tab? Lets say I have a five tab panel. The user is in Tab1. Every tab is assigned an object name (TAB1, TAB2, etc). The user clicks TAB3. I need to execute several actions and checks before going to the selected tab. How do you do it? I do have a solution already, but I do not like it (because of aesthetical reasons). Please read bellow. The ideal solution would be to use the tabs itself or to solve the flashing and tab viewing efect of the buttons. Problems of using the tabs itself: - I have seen no way to implement a 2 or 3 line text in the tabs. - I do not know how to directly assign a script to the tabs …
-
- 7 replies
- 3.1k views
-
-
In searching the forum I see the recommended solution to making a multi page cover page is to drag the Title Header down past one page tall. I've dragged and dragged until now it's down to 46 inches. My cover letter text cuts off mid line at the bottom of page 1, and the body of the report starts at the top of page 2. Half the cover letter is cut off. Do I need to drag it further? or am I making a different mistake (margins perhaps?)? The multi page body of the report works fine. I've not tried the multi page bottom material of the report yet.
-
- 3 replies
- 1.3k views
-
-
I can't get a basic layout graphic to show on the web version of my database? A simple circle won't show (created with the FM tool) or any other pretty things I added "Unless I change them into a graphic in say photoshop" and cut and paste it in... Is it me or what am I missing... Have I lost my mind? Thanks anyone!
-
- 6 replies
- 1.3k views
-
-
I have searched all omit portal row's in this forum, but none of them work for what I'm trying to do, I need help. I want to omit the portal row in the Purchase protal if it has been "Sold" I have been working on this for a long time & I can't fugure it out. Stocks__Copy.zip
-
- 11 replies
- 1.9k views
-
-
I'm wondering if it is possible to open two tables at the same time from a single database. Is this possible?
-
- 1 reply
- 1.1k views
-
-
Hi, Being newbie is always painful. A very simple question - I use a custom dialog box with two INPUT fields. How do I read this values ?? thanx
-
- 1 reply
- 1k views
-
-
Hi all, Wow, this site makes me feel dumb...so I hope to learn a lot! I just bought FM 8.5 Advanced for a development that I am doing (having used FM6 in the past and liked it). I have, what is in essence, a real newb question - how to change the focus order of the fields during data entry? When I hit 'add new record' it seems to start at the bottom of my field input list and not where I want it. I've scanned all the documentation but this is not clearly mentioned. Any help would be thankfully received, and I look forward to becoming a member of these forums. Thanks Rich
-
- 2 replies
- 1.3k views
-
-
Do Tabs only work on a MAC? Or only with versions fm8 and above? Please clarify exactly what is going on since I just looked at something I did on someone's PC and none of the tabs were there. I would like to get an idea of what my limits are (whether platform or version) before I go and develop/upgrade my solutions and find out that no one can use them properly. thanks
-
- 1 reply
- 1.5k views
-
-
I am wanting to place a portal on my layout that contains data from the records that are created and stored in the same layout and table. What type of relationship do I need to make?
-
- 14 replies
- 1.9k views
-
-
this seems like it should be obvious, but i'm not seeing it! i have a layout in list format. i want to add a set of values in the list, for a given parent record. is there any way to have a new record created automatically when i tab out of the last field in the view?? i've added a button to the header to create a new record, but i'd rather have it happen automatically, so the user can just tab through a long list....
-
- 2 replies
- 858 views
-
-
Hi Folks, I have a contacts/events managment database. I have a layout for event information on which I have a portal that displays event materials - in this case files. I created a script to add files to this portal but all of a sudden it's not working. What happens is: 1) The script doesn't work if the portal is empty (i.e. a new event record) 2) It overwrites the last file added Here's the script: Set Variable [$eventid; Value: Events: Event_ID] Go to Field [Event_Materials::Title] Go to PortalRow [select;Last] SetField [Event_Materials::Title;1] SetField [Event_Materials::Title;""] SetField [Event_Materials::For_ID;$eventid] Instert F…
-
- 1 reply
- 920 views
-
-
I currently have setup an employees table with a unique identifier, first and last name. Visually --------------------- | Employee --------------------- | id | first name | last name --------------------- It has a relation to a Time Entry table which contains an employee identifier, a date, and the number of hours worked that day --------------------- | Time Entries --------------------- | employee_id | date | hours --------------------- Now I want to create a layout to summarize the data but at different granularities. Eg. One report would show how many hours an employee worked each week Another report would…
-
- 5 replies
- 933 views
-
-
Hello! We run our business from a Filemaker Pro 8 database we designed and built ourselves. It works very well for our purposes, and has been highly customized to make our lives easy (this is the truly magical benefit of FileMaker Pro). However, one aggrivating issue we haven't been able to resolve involves getting text that we paste into fields in our database (usually from a website) to conform to the size, color and font we use for the rest of the database. We've checked through the text formatting options for all of the fields, and eventhough they're all the same, when we paste text in, it maintains the color and formatting of the webpage we copied it from. The …
-
- 4 replies
- 1.3k views
-
-
Hi, I'm struggling with the fundamentals. I've got a layout that works for me but I can't find the solution for my next step. I want to make a nice-looking cover sheet which will be the first thing you see when you open up the PDF export of the layout. I can't work out what I need -- is it a new record that I then re-design, or is it a layout part of some kind? I really just want to put some graphics on an A4 page with some text and stick it at the front. Thanks for any tips. I've trawled help without success. Phil
-
- 7 replies
- 1.8k views
-
-
Does any body know why we can't insert EPS vector art file graphic files? My logo is currently in jpg and when i make a pdf the logo is very lo-res. any suggestion how to increase the look of my logo without increase the size of the pdf. 1 pdf is 10 KB. Maiton Vang
-
- 2 replies
- 2.6k views
-
-
hello. i have a database similar to an invoice system. 3 tables: (1) Invoice w/UID (2) Products w/UID (3) Line Items w/UID I have the line item table linked to the Invoice table via InvoiceID. I put a line item portal in my invoice layout. And I have both "Allow creation of records..." and "Delete Records..." checked on the line items side. But if I make a mistake and clear a row in the line item portal on my invoice layout and re-enter a product, the Line Item record is not deleted. This is a problem for me, because I have a separate PRINT INVOICE layout which shows blank rows for Line Items which I thought i cleared (and deleted.) How can I dele…
-
- 12 replies
- 1.8k views
-
-
Hi I have produced a layout formating a report for printing. Users add info to the two columns and they change the size of the column so there is not too much white space (as and if required). Unfortunately the resize option is not working for the user. I have checked the tick box for resizing columns, checked the priviledges of the individual, checked the page margins, but the user still has no access to resizing the column part of the layout. Am I missing something here? The full access user is able to resize columns in Browse mode but other users are unable to. Thanks for any guidance
-
- 0 replies
- 899 views
-
-
I have two layouts. 1st - Has a portal for rows 1-17 2nd - Has a portal for rows 18-50 1st also has a grand total field for rows 1-50. The grand total works fine. But how do I get a subtotal on the 1st layout for rows 1-17 only?
-
- 3 replies
- 2.6k views
-
-
Find via Tabbed Portals ... need a simpler method. The sample file below shows a very basic version of a technique I've been using to enable the user to specify three different groups of results and have them available as tab-selected portals. It has worked just fine up until now. The problem is that I now want to expand the layout to support up to 12 portals. Before I launch into a brute-force expansion, I was wondering if there might be a simpler technique that wouldn't require a dozen table occurrences and global fields ... or should I just stick with what works? Thanks in advance for any advice. TabFind.fp7.ZIP
-
- 3 replies
- 910 views
-
-
This goes along with some of my other posts. The application I am working on produces a book. In that book references to PDFs or the PDFs themselves are stored in container fields. Recently I am favoring just storing the references based on being able to obtain the path to the PDF in question. Here is the problem: I want to print this book. That is the whole purpose of my applications development. The portion of the book developed in FMP is a no brainer to get it to print in sequence. But then I get to these areas where parts of the book have been developed in other programs with the information saved externally as a PDF and I want to reach out to those PDFs and pr…
-
- 4 replies
- 1.8k views
-
-
Hi, I don't have FM 8.5, so I can't try it with beta version. Does the web viewer can be used in Instant Web Publishing? The new functions (relevant with the web viewer) can be used in IWP? Thanks Cabi
-
- 4 replies
- 1.6k views
-
-
I have a portal on my Purchase Order layout that shows all payments based upon the purchase order number on the main layout. The payment history table and the PO table are linked by the PO #. I created a summary that shows the PO total less payments = balance. The problem is the payments total that is a summary field in the payments table won't update when the PO number is changed unless you click in the field and then out of it. Please help.
-
- 4 replies
- 953 views
-
-
Those that have seen this project in it's several phases have made comments such as "That is totally insane!" : But I had fun making it! And now it's finished. I'll attach it here for anyone curious enough to look at it. I guess I'll consider it a proof that at the least I'm creative Would love to hear your comments and/or criticisms... SpaceInvaders.fp7.zip
-
- 15 replies
- 2.8k views
-
-
I want to recreate the drop down layout list that's on the status bar that only shows the layouts available to each user based on their access. I tried to find other topics but did not see any (probably there, just blind). Thanks for any help.
-
- 1 reply
- 874 views
-
-
I've got no problems with my portals but i have an asthetics question and mb someone has run into this? After i create the first record in the portal row Filemaker seems to automatically jump down and create a new row below and iam seeing the go to releated record arrow i created and some of the calculation fields show zeros etc even though i havent selected something on that row yet. Is this a bug? or is it something i just have to deal with if i want to use a portal.
-
- 1 reply
- 865 views
-
-
I can't seem to get the charting example to work. I keep getting the "The page cannot be displayed" message. When I open the WV.html directly, nothing is displayed. Any thoughts on where I might have went astray?
-
- 5 replies
- 1.8k views
-
-
Solution / Multi Page Layouts Description: HI There, We are using Multi Page Layouts using this format: ######################### Header Info ######################### (header part) Body Text ######################### (body part) Footer ######################### (footer part) I know that you can place a blank page at the start of the document, to use for a cover page. My questions is: How do I create a blank page (for terms and conditions) at the end of this multi page Layout. Thanks in advance. Working Under: Solution Status: Beta Pre-requisites: Author(s…
-
- 0 replies
- 985 views
-
-
Hello, I would like to view all records from a table in a small screen on a layout while entering a new record in the same table. I tried to use a portal, but we can only display on a portal, information from an other table but not from the table the layout is based. Any help is appreciated Thanks
-
- 2 replies
- 986 views
-
-
I've written a FMP Adv application that uses FMP scripting to generate HTML, then written the resulting HTML to a file in the webserver directory. I then want to use the "web viewer" to see the resulting web page in the FMP application. Everything is working, including converting the UTF-16 text making up the HTML to UTF-8. My problem is synchronization. I use perform applescript (thanks to another FM Forum member that provided this): copy cell "filename" of current record to fileName copy cell "Text_" of current record to exportMe do shell script "echo -n " & quoted form of exportMe & " | strings > /Volumes/WebDirectory/whatever.html/" & quo…
-
- 7 replies
- 1.6k views
-
-
Hi, I am a FM newbie. My database is a simple contact list, from which I create mailing labels. I have my contacts categorized for a main category ("category 1"), then a sub-category ("category 2"). I would like to not only sort but create a temporary, isolated or standalone list, so when creating mailing labels, only those relevant contacts are included. I do not want to just rearrange the whole database because quite a few records are irrelevant for certain lists. The sorted listed would only include A and 1, or A and 2, or A and 3. Or B1, B2, B3. Does this make sense? I have only been able to find sorting help (from "Help") referring to rearr…
-
- 2 replies
- 912 views
-
-
I'm experiencing what seems like a strange bug. I've got a layout that has a tab panel w/ two tabs, and a script that determines which of the tabs to activate, using Go To Object. This works fine. However, the script then continues to manipulate the window somewhat. Through debugging, I've found that the "Show/Hide Text Ruler [Hide]" step is causing the tab panel to revert back to the default tab, in those cases where the other tab had been selected. This happens whether or not the text ruler is actually showing when this script step runs. Is this just an obscure bug? Anyone else seen this?
-
- 1 reply
- 1.5k views
-
-
Hello! I want to generate 2 reports. The format is shown in the pdf within the attached archive file. Following the explanation in FM User's Guide, I created the fp7 within the attached archive file. The layout "aggregated monthly report," in Browse mode, scarcely looks like what I'm trying to achieve! In Preview mode, it is totally blank. I searched these forums and found a zip file named "Report_Date." It works perfectly. In comparing "Report_Date" with my file, I must be missing the obvious as to how come it works perfectly while mine flops. Additionally, I am totally puzzled by the following behavior of "Report_Date." 1. In Browse mode, the l…
-
- 4 replies
- 2.1k views
-
-
Hi, I'm using FMP 8.5 Advanced. Simple question: When I have a multiple layouts with the same perfectly-aligned menu buttons, etc. at the top, and I switch among them in "Browse" mode, the transitions between layouts are completely smooth. There is no "bounce" of objects left-right or up-down. However, when I use the same perfectly-aligned menu buttons (and entire layout for that matter) in a layout that is set to List View only, when I nav to that layout, a vertical white line perhaps 3 to 5 pixels wide appears, from the very top to the very bottom of the layout. This is annoying as it causes the entire layout to "bounce" right by 3 to 5 pixels. I nee…
-
- 2 replies
- 1.3k views
-
-
I am looking for a way to schedule appointments and view them graphically, for example something like this: How is something like this set up? Are these grids Portals? Any feedback or suggestions would be great, thank you.
-
- 1 reply
- 1.3k views
-
-
Just wondering, what I am calling dynamic layout. I mean, when you sort records usually for printing purpose we do configure a special layout with fields we would want included. This layout has sub-summary part and also a trailing grand summary, and of course head and footer. Lets supose we have product field named A and category product field named B. It is normal to want reports based on field A and another based on B. Is it possible to have a single layout for both reports? Could be possible to configure a script which would define the parts of the layout, or even change the field positions, change the header and footer? Thank you, Toni
-
- 5 replies
- 1.3k views
-
-
I have an entry layout with some numeric foreign key fields: Location, Client, Worker. How can I make it easy for users to enter the correct numeric key? Currently, I have value lists showing the key and the text name and drop down menus using those value lists but that isn't completely satisfactory. The Locations drop down is between 1-5 values (depending ont he Client). The Clients value list is about 40 values and the Worker value list over 100. That's a lot of scrolling. Then the field only shows the number key (which is really irrelevant to the end user), so I need another field to show the name (a non-enterable field direct from the related table). I'…
-
- 1 reply
- 1.1k views
-
-
Hi, Forgive me for being a bit dim this morning, but I can't remember how to do this. I'd like to be able to use a <> to display the current layout with each of my layouts. However, I can't seem to get the calculation correct to make it actually work. Currently, I've created a calculation field called "Current Layout" and I've set it equal to: Get (Layout Name). This isn't working, as when I jump back into Browse mode, all I get where I should have a Layout Name, is a question mark. I am sure that I did this correctly in one of my recent projects, but I'll be damned if I can find it to copy from my own work! If one of you can please remind me of how to do…
-
- 4 replies
- 1.3k views
-
-
Hi, I was wondering if this is possible: I have a field for a case number. I want to start the number off with the year and then an incremental number following it. I want to make the case number prefix (the current year) change with each New Year. Example (for 2007) 2007-0001 then the next record would be 2007-0002 etc. Then when the new calendar year starts...the number would change to 2008-0003… 2008-0004 etc. Or I could even live with the new year starting over at 200?-0001 I currently have the field set to Auto Enter a serial number incremental by one (2007-0001) but of course that will keep the 2007 plus the increments e…
-
- 5 replies
- 1.2k views
-
-
Is there way to change the display in a field to something less jarring?
-
- 1 reply
- 879 views
-
-
Trying not to print a portal, so instead printing a list view of the related records. But most of the data is in the primary table and I need that data to show up in the Title Header and slide.
-
- 4 replies
- 1.2k views
-
-
Hello, I'm trying create a script that will let me print all Work Orders that are related to a single Job ID, but I just can't seem to wrap my head around it. Right now we have have to click a button in the portal line to go to an individual Work Order. From there we can print just that current Work Order. Any ideas or scripts to do this?
-
- 6 replies
- 1.3k views
-
-
So I have searched the forum for answers and still can not find something that works. I have a print layout that contains a header, leading sub-summery, body, trailing sub-summery and footer. There is one row of fields in the body and when printed it should look like a spread sheet. The fields are two lines tall and are set for sliding when printing. I would like to have vertical lines between the fields in the body. I have tried to draw in lines and set the left and right borders but nothing works right. Anyone have any ideas?
-
- 14 replies
- 2.8k views
-
-
I am trying to log when a change happen on drop down value list. i have in the list Current, Withdrawn, Graduate, incomplete. i only want to log when the value list for the drop menu get change to Withdrawn, i was able to get it to work for all of the value list when the change but no the withdrawn one. i am using FM 6.0 on mac os X. any help would be appreciate it. Thank you victor
-
- 1 reply
- 972 views
-
-
Hello. I've been struggling with this for days, reading everything I can but still not being able to pull this off. :qwery: I'm creating a simple (or so I think) music collection database. I have the following tables: Songs - A list of all songs Artists - A list of all artists Albums - A list of all albums AlbumTracks - A table containing a SongID, ArtistID and AlbumID (since the same song may occur on several albums, and be performed by different artists). What I'm looking to do is to filter a portal of records in AlbumTracks based on a search string that could be a part of the song name (stored in Songs), the artist name (stored in Artists) or…
-
- 3 replies
- 1k views
-
-
I have done some searching around to no avail on how to do this. I am wanting one fields data to set the value list for another. I know that this requires a conditional value list but I would like it to be an editable conditional value list. Any Ideas?
-
- 1 reply
- 984 views
-
-
This one has me totally stumped. I'm creating a database for Matchbox cars. I have a table name Catalog set up that includes: Number, Letter, Variation, Name, Color, Interior, Wheels, Decals, Etc. I have a table named Car Finder. In this table the user can enter pertinent information to find which car he has. Example: If he clicks in Number he can select from any car number. Then he clicks in Name and only the names for that number appear, on down throught the line to where her can select the wheels and description. I've got that set up to work flawlessly. Now for my problem. This is what my fields look like: Number: (1) Name: (Mercedes Truck Lorry) Color: (Mi…
-
- 1 reply
- 875 views
-
-
Is the following scenario a feature or a design flaw in the dialog that displays when you include in a checkbox set the Field Setup/Control's "Other..." item to allow entry of other values? The scenario involves using Find mode to search for or count records that contain an "Other" value in the checkbox set. Disclaimer: I have used and believe I understand FMP's Constrain Found Set feature. Regardless, I think the following situation could be an artifact of the (mis)behavior of the dialog that displays when you configure a checkbox set to use the "Other..." item and you include "Other" values. I have a field configured as a set of 14 checkboxes (note: a rec…
-
- 3 replies
- 953 views
-
-
I have a layout that has no records created in it and in the status bar it shows "0" in the record field "0" in the found field as expected but, "2" in the total field. Any reason why this might be happening?
-
- 1 reply
- 873 views
-
-
I am new to Filemaker and I wanted to know if there was a way to have an edit box auto line format for me like Microsoft Word? I would like to be able to type and when I press enter it goes to the next line and automatically inserts the next number. Example: 1. 2. 3. etc.
-
- 28 replies
- 3.5k views
-
-
We're going to be using IWP as a school report card input, so I was excited about the possibility of using multi-line Tooltips to present grading rubrics, etc., to the teachers doing the input. Unfortunately, it seems that one's choice of browser affects the way the tooltip displays. On Macs, Safari shows multiple lines, Firefox does not, at least from my limited testing. Has anyone seen this? (Tooltip format uses pilcrows to separate lines)
-
- 0 replies
- 1.2k views
-
-
Is there a way to run a javascript on a page viewed in webviewer ? like Javascript:Close() As it is done in a address bar of a browser after a page is loaded ? Xoomaster
-
- 1 reply
- 1.3k views
-
-
The FileMaker Knowledge Base says this: In order to delete a record represented by a portal row (a related record), check the 'Allow deletion of portal records' check box in the Portal Setup dialog window. Select the row by clicking it and choose Delete Record from the Mode menu. The dialog will read, 'Permanently delete this one related record?' Clicking Delete will delete only that related record. I have allowed deletion of portal records, and when I select a row and hit Delete it says "Permanently delete this one related record?" and when I click Delete, it deletes the entire record, not the portal record. I have another database that has a portal in it a…
-
- 3 replies
- 1.3k views
-
-
Hi All, I have two databases, within one is a value list that provides preset timings for the start of a booking in the format 10:00 etc. This just fixes the start of the booking at half hour intervals. When i try and link to this value list from the second database, the link is good but the list has added and extra :00 ( i guess seconds indication) to the value list. ie i now get 10:00:00. I have tried all the different formatting options which only seem to affect the data after you have chosen the relevant option from the value list. How do i change the formatting when displaying the value list? It's bugging me but i'm sure it's something simple! Any idea…
-
- 26 replies
- 3.9k views
-
-
This is probably a dumb question, and one that I bet has already been asked, but I'm a beginner and couldn't find the answer in the search. In my file, each record has a field that generates an automatic serial number when a new record is made. But I want to create another field that if used will search for an old record and will replace the old serial number with the new serial number? Does this make sense?
-
- 4 replies
- 1.1k views
-
-
Hi - Hoping this is a good forum for this question. Is it generally acceptable to use free/open source elements such as icons in a filemaker app that may be sold commercially - eg shareware? For instance, the scriptology theme templates have all sorts of great icons, but I can't make heads or tails of the license info. Not clear to me if I'm allowed to use them as buttons, etc in an app I'm developing or if they are only for use in other free/open source applications. THe license info seems to relate to not selling the actual collections of icons, but I couldn't find any language that seemed to be related to using them in something unrelated. Thanks for any advi…
-
- 9 replies
- 2.1k views
-
-
Thank you all in advance for your help and comments! I have two related tables (1 and 2). I used the LIST function on the related table's records to make a list of all the docs in that table (2). I then used a FilterValues function to compare the related records list to a list in the context table (1). The filterValues function results were not correct. Before using the List function (which I thought would be a lot faster), I used a looping script to make a list from all the records in table 2. The filter Values result comparing the scripted related records list from 2 to the list in 1 WAS correct. But I think this looping script could take a long time once table 2 st…
-
- 1 reply
- 983 views
-
-
I have a layout in my email address table which has a contact id field and Contact full name that displays based on a lookup. The problem is when I click on the contact id field the drop down lists all of my 100K+ records. I would like to filter this dropdown list since not all of my records have a full name given. I would like to filter only on those records with a full name entered but not sure how. NOTE: The contact id field on the layout is set as a dropdown list and currently get the data from the contactid field in the table.
-
- 9 replies
- 2.6k views
-
-
Is it possible to number seguentialy the rows in a portal? Let's say you have a portal with 10 rows. Can FM number those rows automaticaly 1 Thru 10? Thanks
-
- 2 replies
- 1k views
-
-
I am currently use secure fm on developer 7 to manage what my users can do through the menus and am considering upgrading to 8.5. I have had a little hands-on with 8.5 to see how the custom menu feature works, and it looks like I wouldn't need secure fm on 8.5 for what I do if I upgraded. One thing I didn't remember seeing was whether I could manage what Secure fm calls the 'Sytem Menu'. In particular, I don't want users to be able to 'quit' or 'exit' my software any way but through my 'quit' script (I realize they can always do a 'Force Quit' or 'ctl-alt-delete'. But I want to be sure to be able to disable the exit and 'big red x' on my Windows applications and the…
-
- 5 replies
- 2k views
-
-
I have a layout with multiple portals. I allow the user to delete portal rows in one of the portals through a script. The other portals do not have the 'allow deletion of portal records' box checked. When the user clicks the 'delete item' button, a script executes the 'delete portal row' script step. This step will delete the selected portal row no matter which portal has been selected. This can create havoc in the database. How can I be sure the user has selected the correct portal before I execute the 'delete portal row' step? I use a custom dialog box to ask the user to verify the desire to delete, but they may discover that they can delete anythin…
-
- 4 replies
- 1.1k views
-
-
I'm am trying to find a subtotal from 2-tabbed portals. My SubTotal/Total/Tax/Discount/Shipping fields are in the Transactions table. TransactionDetails_Parts (related to Parts table)and TransactionDetails_Labor (related to Labor table)are related to Transactions by TransactionID. Each tab has a Part/Labor (respectively) portal for line items. Each line items totals properly in the ExtPrice Fields. I need to find the SubTotal for all ExtPrice Fields (parts/labor)to finish up the Transactions layout.
-
- 3 replies
- 1.2k views
-
-
In my application i need to view some xyz.pdf from a lan folder, I have created a calculated field to take to Webviewer like this: file://Macintosh HD/Volumes/192.168.0.2/xyz.pdf ,it works fine with Acrobat Reader 5.0, if I use Acrobat 8.0, the web viewer shows only a acrobat icon. [color:red]...Why???
-
- 4 replies
- 1.8k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online