FileMaker Interface Features
-
I created a file path field so as to access my quicktime movies via the web viewer. I set the calculation to the filepath field and I'm getting nothing. Do these movies automatically load like a web page. Is there additional scripting required? Is there a sure way to determine whether you have the correct file path? Thanks for any suggestions.
-
- 0 replies
- 1.2k views
-
-
I am attempting to display a variety of dates which are entered through fields with drop down menus. I want the user to be able to select certain date "types" select the date and time, and then press a button which displays a list of the entered dates and related types and times in a portal which Is sorted by date. I have managed to write a script which creates a new record in a related table and displays the info correctly, however when you then change one of the drop down options it changes the item in the portal. I guess I'm missing a final step in the script which includes a "do not edit" from this field (I'm hoping you could still edit the portal field in the portal …
-
- 0 replies
- 902 views
-
-
I just learned how to relate the same table occurance allowing me to create a portal on a form layout within the same table, but after thinking about it I thought I had read somewhere that portals would not work in a web published enviroment. I started out with a separate list view layout and had a header containing a couple buttons, and then later read that the header would not work properly in a web published environment. If both of these things are true is there another approach to accomplishing my objective. I would prefer having a list type view contained on the same form layout if that is possible. Thanks for any suggestions.
-
- 0 replies
- 801 views
-
-
I have been an MS Access user and am trying to move to FileMaker 8.5. I have alot of yes/no data type fields to allow me to print various reports. In Access this is so easy. Can someone help me figure this out please...in a simple step by step fashion? Thanks!
-
- 3 replies
- 1.1k views
-
-
Is it possible to click on the column field label in "View as List" mode and have it perform a script?
-
- 2 replies
- 843 views
-
-
Is there a way to set a repeating field with each value in a value list? Thanks!
-
- 2 replies
- 815 views
-
-
In FMP 8.5 does using a portal still lock (flag as in use) the current record and therefore keep other users from accessing the same portal? Edit: Clarification If 2 users are on the same record of a shared database and one user accesses a portal (activates the portal by scrolling or clicking into the portal), does it keep the other user from accessing the same portal with the new version of FMP 8.5? I know this is the case with earlier versions of FMP, I'm just wondering if this is still a limitation in v8.5 of Filemaker
-
- 1 reply
- 778 views
-
-
This is a great forum, I have been able to create and modify my database with all of your help. I have simple question. I have a portal which pulls records from a product table. I need the "description" field to wrap the text if it doesn't fit in the portal field. It seems like a really easy thing to do but I can't figure it out. Thanks, Sharon
-
- 3 replies
- 1.6k views
-
-
Using FP6. Last year I created a labels layout of 40 labels, 4 across and 10 down, which I need to do again. According to Avery website, this should be label L7654. I have US, UK and AUS labels in the FP program files but when I try to create the layout, this label and its inkjet equivalent are not there. Is there a way of checking the layout I created last year to confirm the Avery number or, even better, a way to copy a layout from one file to another which has the same fields? Any suggestions gratefully received.
-
- 6 replies
- 1.3k views
-
-
Just upped to 8.5... besides the ability to end a script in such a way that you are at a button or tab rather than a field, I'm wondering what can be done-interfacewise-with the new functionality. Seems like that GetLayoutObjectAttribute function should have been half a dozen functions! At any rate, can't figure out how it's useful. Is there a "guide to using objects in 8.5" somewhere?
-
- 3 replies
- 985 views
-
-
Hello, I'm sorry this is such a simple question, but I have tried to find the answer and I just can't. I have a table with 60+ fields. When I am browsing records and I choose to view my records as a table, I can only see about 50 of the fields as I scroll horizontally. Is there a preference that determines how many fields are displayed in the table? Thanks
-
- 1 reply
- 742 views
-
-
i have a portal that is set for 25 records. Most of my portals want to show more that 25 so I have to scroll through them. Is there a way to print the portal and all the record it contains. I presently only get what i see on screen.
-
- 4 replies
- 902 views
-
-
Hello, I'm a new filemaker user, trying to set something up that will allow me to enter, browse and analyze the data from a rather large and involved survey. Each record has a rather large number of fields: thirty questions each with five parts, plus another fifteen independent questions. The amount of data that will be in each field will range from nothing or a few words to several paragraphs. Right now, I'm designing a layout for data entry and printing, and am having considerable whitespace issues. For the independent questions, I've figured out how to use sliding and everything is dandy. For the five-parters, however, I'm having trouble. What I'd like to do …
-
- 0 replies
- 764 views
-
-
I am working with an order entry system that I have designd and am using a protal for the first time. The order entry pages has all of the basic customer information and the portal is linked to "Line items" for which an individual order may have 2 or 30. I'm trying to make the printed copy show all of the related line items regardless of the number, but can't figure out how to expand or slide the protal (or the information below the portal) to do this. It seems as if the only way to adjust the "View" is by specifying thhe number of rows in the portal set up box. I would like the portal to show as many or as few line items as are related. Help!! Thanks!
-
- 1 reply
- 747 views
-
-
Hi all - Is it possible to trigger a script when a new value is chosen from a pull-down list? I tried making a transparent button that sits over the list box (like you do over a portal row), but then I could only click the button and had no access to the pull-down list. If I put the button only over the arrow for the pull-down, then I could pull down the list, but the button wouldn't work. I would like to have the script triggered every time a new value is chosen from the list. Any ideas? Thanks, Jeff
-
- 11 replies
- 1.9k views
-
-
I need to know how to calculate a total / subtotal of a revenue field summarized on the value of a second field. For example: Summarize total dollars based on blue, green, red orders. How can I make a running total field or script / report to gather this info? Can provide v8.5 sample file if necessary.
-
- 1 reply
- 797 views
-
-
I have a layout setup with all of the data that I want in it. However when I changed the view from form to list or table I don't see everthing that I want. How can I change the layout of those particular views?
-
- 2 replies
- 844 views
-
-
For some reason my pop-up menu only shows the first record of a list vales derived from another field in another table. I selcted roleID and the second field is RoleName. I have Include All values selected and show only second field. There are two record in the table. But only the first displays. Anyone know why? Thanks
-
- 2 replies
- 1k views
-
-
Is it possible to make a value from a relationship that has a many to many join table. 1stIngredient Table ID BaseUnitTypeIDfk Name BaseUnitIDfk 2ndJoin Table: For Ratio of different Types ID IngredientIDfk BaseUnitTypeIDfk TypeIDfk Ratio (between Type of Ingredient and a second type) 3rdType Table ID TypeName 4th Unit Table ID UnitName TypeIDfk Each Ingredient has a baseunit and a basetype. You can define ingredient specific units like clove (garlic). In the many join table you can create a ratio to other more standard types like mass in g or to other ingredient specific types like head (garlic). There you create a ra…
-
- 0 replies
- 557 views
-
-
I am trying to create a purchase orders database. I am new to filemaker and I am struggling with certain aspects of it. In MS Access I created a subform and allowed the users to select the item and the rest of the subform populated then peformed calcs on the items chosen. The purchase orders where then created based on the orders table that was created. I think I need a portal to do the same thing in FM. I have managed to get the portal and do the lookup but I can not get it to go to the next row. Our pricelist is 10000 records long and some orders will have only 3 items others will have 30 items. I don't want to do a lookup because each line has to be in…
-
- 1 reply
- 769 views
-
-
I have a container field in a table (using FM 8.5) which holds a document. I can set up a button to display the document, but I'd like for the button to only be visible in the display if there are actually contents in the container field. I can't quite figure out how to optionally manage the presence of the button in the layout. Does anyone know how this might be done? Thanks!
-
- 2 replies
- 1.1k views
-
-
I noticed that when I create a field with "create label" selected, the text-object created for the label automatically fits the size of the label text. Is there a way I can set text-objects to auto default to the size of the text contained as I create and change text labels? Thanks.
-
- 0 replies
- 722 views
-
-
Hi everyone, I'm having problems with ## for page numbering. It shows "1" for all pages printed. Any suggestions? I don't know if it matters, but I've set up a global for last page and put in my script. Go to record/request Last insert page in global Go to record/request first The last page insert is working correctly. In layout i have "page" ## "of" g_lastpage
-
- 5 replies
- 971 views
-
-
I hoping i've got the right area to post this query. I'm trying to get it that when my solution opens a new window from a button click that the new window in front is the only one selectable and if you click on the back window it stays in the back until you have clicked a close/commit button on the front layout. I've had rough success with this through the pause script step in the button script that creates the new window, but doing it this way needs the operator to click the cancel/continue button in the status area. My solution doesn't use the status area in any of the layouts so i was hoping there is a script step that i'm not seeing that may achieve my goal. …
-
- 7 replies
- 1.5k views
-
-
I have a portal where I have two fields Brand and Total Spend. I get the correct total spend but when it displays each record instead of just the brand name and total amount. For example: Brand $100 Brand $100 Brand $100 etc... How do I get it to just list each brand once? Thanks for any help.
-
- 2 replies
- 849 views
-
-
I need a simply way to get a count of the portal records in my layout. The portal is part of a reporting module. It is linked to my main job tracking db. I have various portals that show me jobs printed on a certain day, shipped on a certain day and whether or not they are late based on a comparison of due date and ship date. I would like to have a simple counter at the bottom of my layout showing me how many of each I have in a given day.
-
- 4 replies
- 1.4k views
-
-
I can't find a way to do this: create a value list using the contents of four different global text fields from within the same table. I have tried creating a new table for this purpose, but cannot design the relationship to allow each field to create a record in this new table. Can someone point out my error?
-
- 5 replies
- 1k views
-
-
I know my answer is somewhere in this forum, but after looking at 10 or more posts and sample files I cant seem to find my answer. I have 2 tables, a Company table and a Employee Table. The employees are in different categories. What I want to do is have 3 PopUp menu fields that return the Employee Number back to the Company Table. Those three popup menu fields should only list the employees from a specific category (Admins, Directors, and Associates). I created 3 calcs fields with the 3 categories names... after that I fiddled with relations on the table map and nothing seemed to work. Can someone take a look at my sample file and figure out I'm doing wrong. …
-
- 4 replies
- 1.1k views
-
-
Hello I'm designing a database where I'd like to have some fields hiden on my print layout if they're empty. The fields in question will rarely have info in them. Is there a way of hiding them (or more specifically their labels) from a layout if the fields themselves are empty? I can't think of any little tricks to achieve this. I thought they'd maybe be a script that would use the sliding/printing control but I can't find that option. Any thoughts? Thanks
-
- 1 reply
- 934 views
-
-
This is definitely the smallest file i've ever posted ... someone noticed that in 8.5 os x updates the window dims in real time ... so here is a mac tested file which resizes an image in the fly ... sure this will be useful ... obviously if you only set it to resize height or width it would be to scale ... but can't work out how to test for size of web image. Tip: Change window size to resize image pretty cool anyway ResizeImage.fp7.zip
-
- 11 replies
- 3.4k views
-
-
OK so im planning a purchasing layout and have no idea on how to do it. Basically i have fields for Vendor, Manufacturer, item#, and description (that need to work with this layout). I want to find all unordered items, sort them by vendor and make a new page (to be printed faxed or emailed) containing all of the items associated with each Vendor. Can anyone give me some hints and ideas? Thanks!
-
- 2 replies
- 1.1k views
-
-
I created a webviewer field that displays the directions (using yahoo maps) from our office to whatever address might be in the current record. It works great but i dont know how to print the directions. I created a layout where i resized the webviewer field to fit a Letter size page (even if it's multiple pages long) but the width of the web page showing the direction doesn't fit a letter size sheet of paper... So erm... how do i print the content so it fits?
-
- 1 reply
- 1.5k views
-
-
I'm trying to filter portals with checkboxes. Each record in the portal can have 1 of 5 different status's. Above the portal is a checkbox for each status. I'd like the user to see only the records that match the status of the checked items. After working on this for several hours I'm beginning to think it can't be done in Filemaker. It seems I need an "OR" instead of "AND" operator when creating the multi-value relationship. I've attempted several workarounds with no success. Has anyone solved this or have I ran into a limitation of Filemaker?
-
- 3 replies
- 1.3k views
-
-
I currently use a pop up menu to display a number of items from a value list. When I select the menu it displays a long single column list that I have to scroll through to reach the bottom. Is it possible to change the format so that it is displayed in perhaps two or three columns? This way all the values will fit on the screen at the same time. I have tried a pop up list but this takes a very long time to display.
-
- 3 replies
- 1.1k views
-
-
I have two fields, "forename" and "surname". They sit beside each other on my layout like so: FORENAME[color:white]....SURNAME Sometimes a guy might have a very short forename, so I end up with this unsightly mess: ANDY[color:white]............SHAW Is there any way to make this look more like: ANDY SHAW ...without having to resort to using a third field to display the combined values?
-
- 2 replies
- 810 views
-
-
After quite a bit of searching and all, what I'm trying to accomplish is for an auto body repair shop, but I need to allow for selection of the year (which is in the vehicles table and a field called years with two digit values separated by a space ie: '00 01 02' but I need to be able to select a year for instance, 00, then it'll allow me to select a make, so all the makes (makes field within the same table) availible under year 00 will show. Then, the same with models (models are under models field under vehicles table). Is there a way to do this? login.zip
-
- 3 replies
- 1k views
-
-
Is there any way to do conditional value lists without referencing other databases? Is it possible to combine the content of 2 fields into one value list? Thank you! Moosh
-
- 2 replies
- 1k views
-
-
Several places in our in house solution I have layouts with a portal that has conditional graphics calculation fields to highlight a particular row or rows in the portal. If the value of one of the fields in that record matches some value of another field, it uses one graphic, if not, it uses another graphic. Often it is highlighting a row that the user has clicked, which in turn has filled in a field in the master table which controls what is shown in another portal. In FileMaker 6 and previous, I could do this and the row in the portal that is in essence where you click to get a new record would be using the graphic which was for the no match condition. In 8 it …
-
- 2 replies
- 1.1k views
-
-
I have a database that relates to another database that contains 5 competitors and their monthly spending. Each competitor has their own record in the other database and their names are contained in the same field. I want to be able to bring each competitors spend into a single record on a TAB layout and show each comeptitors spend. I can bring in one competitors spend but am having a brain freeze on how to get the other brands in. Any thoughts? Am I being to vague? Thanks
-
- 5 replies
- 817 views
-
-
I am have a strange problem where the cursor appears to be out of alignment. The cursor is 5 or 6 spaces to the right of the characters being typed. Hence, if I am typing here[color:FFFFFF]..........|<--the cursor is here. I have tried changing fonts and recovering the file with no luck. Has anyone else ever heard of or had this problem?
-
- 2 replies
- 808 views
-
-
Hi, im new to using Filemaker. I was wondering if there is a way to make a master layout? Say I have a set of standard buttons that appear on every layout in the same place, do I have to create (or copy and paste) them everytime. Copy and pasting them is ok, but getting them in exactly the same place everytime takes a lot of time (unless there is a easy way I dont know of yet). Help in this matter would be greatly appreciated. Thankyou.
-
- 6 replies
- 2.7k views
-
-
hi, please help me.. i need to be able to create a calculation that counts the number of different items purchased.. the count function doesn't work since it counts the number of items purchased and not the different types of items (based on item number).. Can someone please help? Thanks!!
-
- 3 replies
- 818 views
-
-
HI I made a checkbox value list eg 1,2,3 After a number of records had been populated i realised I need to change the valuelist to 1a,1b,2,3 Is there anyway to delete the "1" from the records that are already entered? I obviously cant use the replace option as some records may have 1 and 2 entered and other 1 and 3
-
- 2 replies
- 804 views
-
-
I am working on a small (10 K records) database, and have encountered a problem that I hope is a programming oversight, and not data corruption. There are two files, with a many to many link created in a third. File one: people. File two: events. File three: join file. In the events file, to add a new person to an event, I have created a value list made up of the letters of the alphabet. When I want to enter someone whose last name begins with 'a', I select 'a' from the value list, which drops it into a NameFilterGlobal field. I've made a relationship between the NameFilterGlobal and a calculated field in the People file that parses out the first letter of the last n…
-
- 2 replies
- 906 views
-
-
I have an order entry database in which each record originally had a container for the artwork that is to be used on the order. The quickest method I had of inserting the artwork was to simply copy the elements in the Illustrator file and paste it into the container. Now that I've been doing this for over a year and the file is getting rather large, I've decided to move the artwork to a separate file and put a portal with the artwork container in each record. This will keep my order entry file smaller. Ideally, I'd like to set it up so that the portal would show all the artwork for that customer (I could have it show only one portal record and then scroll throug…
-
- 6 replies
- 1k views
-
-
Hello - I've got a puzzler, at least for me... Here's my setup: I have a data-entry layout ("Certs") that allows the user to associate an inspector with a part. There *should* be only one record which links an inspector and a part, but it's the record ID field that FileMaker checks to see if the record is unique. A user can click the New Record button and FileMaker creates a new record. The user then selects a part and an inspector. What I'm looking for is a way to not allow the newly created record to be committed if there is already a record that links the inspector and the part. I created a self-join relationship based on the inspector and the part,…
-
- 6 replies
- 1.2k views
-
-
So I have a (necessarily) fairly complex form with lots of fields. I would very much like for the user to be able to mark some of those fields in [color:red]red and some in [color:green]green. I'd like them to be able to do this on the fly. So, regardless of the field's content, the user can mark it red or green. What's the most elegant way to achieve this?
-
- 2 replies
- 897 views
-
-
Hi, I have an invoice, which contains a portal, which brings in the orders that have the same 'invoice number' as the current record in the invoice layout. It has multiple pages, which are basically duplicates of the first but the portals are set to display the next records, so 1-3 for the first page and 4-6 for the second etc. I have read that it isn't proper database practice to print portals though, but I can't think of any other way to do it. I also need another way to do it because the portal method seems to be playing up. The best way to describe it is that its like the portal is showing one more row than it is supposed to, but this extra r…
-
- 10 replies
- 1.9k views
-
-
I have made a database to track my client's invoices. Each client may have many invoices and each invoice may have many line items, each with a value. I wish to be able to see a list of a client's invoices in a portal with a total for each invoice and a running total showing the balance of their account increasing with each incvoice listed. The problem I have with the way I have set it up is that when a line item is modified in an invoice, the running total in the portal in the clients layout is not being updated. Changing layouts and going forward and back one record does not update it, but quitting and reloading the file corrects the running total. Could …
-
- 6 replies
- 1.4k views
-
-
Hi-- I'm replicating a layout where I need to be able to find a range of dates, then have subtotals for all transactions within that range, hence: Transactions Processed and Closed between and including March 01, 2006 and September 11, 2006 Sale Transactions:77 Return Transactions:3 Total Transactions:80 Totals Visa Sales:$2192.43 MC Sales:$628.05 AMEX Sales:$191.70 Discover Sales:$34.95 Total Sales:$3047.13 Returns:$(104.85) Total:$2942.28 Averages (194 days) Sale Transactions Per Day:0.39 Amount Per Sale Transaction:$38.21 Amount Per Day:$15.09 I've tried setting this up, but can't get the…
-
- 9 replies
- 1.1k views
-
-
I have a field consisting of two check boxes for the two choices in the value list. I have the field validation set up for "not empty" but how do I allow only one of he checkboxes to be selected? Thank you.
-
- 8 replies
- 3.4k views
-
-
How do I do this? I have an ID and a Persons name. I want to show the the names when some selects the drop-list BUT use the related ID stored to the field. I set up the drop-list with the ID then show Lname. I see the Lname in the drop. Whe I make the select I see the ID. how to I still show the Name after it has been selected? Using 8.5
-
- 3 replies
- 1.1k views
-
-
How do I make a field that will show the portal row number like this eg: 1 of 7 In other words it has to show the current row number and the ammount of rows?
-
- 2 replies
- 876 views
-
-
Hi, Hope someone can help me and explain in laymans terms... I am setting up my first database and trying to use a value list to sort data into a new layout which will also hold a relationship section of data. I'm just not sure if this is possible to create. 1. My radio button set value list is simply "sold" and "unsold" - what I want is for all records with the checked "sold" button to be listed in a new layout showing all sold items automatically. 2. As well as that I want to correlate the buyer info with contacts layout, using a relationship but not sure where the original data needs to be stored or how it should be stored to transfer. I'm not very…
-
- 3 replies
- 1k views
-
-
I am Previewing an Invoice-LineItem layout that is based on a List View of the LineItems table, and uses subsummary parts (breaking on Invoice ID) to print the top and bottom portions of the Invoice. Usually it works: more often than not, as I page through the previewed page images, everything looks right. Every now and then, however, I come to an Invoice where none (or almost none) of the fields are filled in. Here's the kicker: if I page forward, and then page back to the blank invoice, usually it's properly filled in. It's as if FM Preview mode displayed the record before it was able to chase down the related fields, but eventually caught up. And th…
-
- 2 replies
- 847 views
-
-
Hello, Does anyone know the proper formatting for putting a mapquest link into FM and pulling the address fields from FM to insert automatically? Thanks for any help.
-
- 1 reply
- 1.3k views
-
-
Please take a moment to look at this post and download the file. http://fmforums.com/forum/showtopic.php?tid/180252/ It incorporates knowledge gained by posts from: Daniele Raybaudi The Shadow The Bridge best Stuart download file from original post You need 8.5 to view this file 8.5 Free Trial: http://www.filemakertrial.com/nskto/form/formA.aspx
-
- 2 replies
- 1.3k views
-
-
Hi, im new to using Filemaker. I was wondering if there is a way to make a master layout? I know I can duplicate layouts, but say I have a set of standard buttons that appear on every layout in the same place, and I want to add or change a button, I have to create (or copy and paste) them everytime. Copy and pasting them is ok, but getting them in exactly the same place everytime takes a lot of time (unless there is a easy way I dont know of yet). Is there at least away to get them on exactly the same posistion as on the other layouts? Help in this matter would be greatly appreciated.
-
- 7 replies
- 2k views
-
-
Hi people, 3 days ago I started learning FMP, so if this question seems a drab, then 'xcuse me. I want to create a hybrid view; form and a list on one layout. Portal seems perfect, but the problem is, it "wants" to show data from related tables only, not the same table. How is this layout can be achieved? Thank you.
-
- 3 replies
- 911 views
-
-
How do I populate a pop-up menu with values pulled from a field or database, and generate a top empty line in the Value List or the pop-up menu. Is there a way to set ValueList Items? J. Kazoun
-
- 1 reply
- 860 views
-
-
Is there a way to display only the checked boxes in a field? I have a field that may have ten items that could be checked but I only want to display and print out the items that have been checked. It could be zero to all of them checked.
-
- 8 replies
- 1.1k views
-
-
I have a portal in which values are automatically entered via a script. I just went in and resized the portal, moved a few fields around, and now when I go back to browse mode, I suddenly can't edit any records in the portal! Previously, if I wanted to edit one of the automatically-entered values, I could click on the field in the portal and change it. I have no clue what I did to make those records suddenly not accessible--anyone have any ideas? Thanks in advance for any help...
-
- 1 reply
- 890 views
-
-
Hi All I'm new to filemaker and having problem creating a payment system. Basically I’ve a table for customer order which have it own unique ID. Customer will leave deposit and pay balance on pick up or lay-by the order. I’ve another table recording all customer payment with unique ID. What I’m trying to do is create a payment system such that payment is link to Order. The problem arise when customer have more than one order but one payment. How do I go about sort out this problem? Please help!!!
-
- 1 reply
- 777 views
-
-
If I want to have a user click on a record displayed in a portal row and go to that record on another layout, how do I do that? I'm a bit stumped on this one. I know it is probably simple, but any help is greatly appreciated. Thanks.
-
- 2 replies
- 1.2k views
-
-
Hi, Is there a way I can patterncount for exact values in a value list.. so.. from John Johnny Johnnia Johnnagain how can I patterncount(valuelistitems(); "John") so that it = only 1 and not 4 ? thanks..
-
- 2 replies
- 757 views
-
-
I'm using the tried-and-true technique of printing Invoices (and their line items) using a layout with a leading and trailing Subsummary parts and a Body part containing a single line item. The layout shows records from the LineItems table, which is sorted by Invoice_ID. When the layout is shown in List View and Preview Mode, I expect to see a leading Subsummary part (containing customer name and address and other stuff from the Invoice record), one or more LineItems, and the trailing Subsummary part (containing totals, shipping costs, and more stuff from the Invoice record). The leading/trailing Subsummary part definitions both specify Invoice_ID as the sort…
-
- 3 replies
- 1.1k views
-
-
This approach appears in the latest issue of Filemaker Advisor, and was contributed by Scott Love of Soliant Computing: Up until now, I created a calculation for each tooltip in the file that needed the tip. Some of the tips were dynamic abd changed based on what record ther user was on. Scott's method involves creating a Custom Function to handle all Tooltips in the current file. Pass the CF 2 parameters: ToolTips( Type; Value ) Case( Type= "Print"; "Print Information For This Transaction"; Type= "MainMenu"; "Return To The Main Menu"; Type= "Email"; "Send an Email to: " & Value; ) To use this CF, enter the CF…
-
- 8 replies
- 4.4k views
-
-
Hi, I saw/heard this somewhere (maybe maybe matt petrowski???) that if you rename a layout in 8.5 the change to that name will no longer automatically propagate throughout your the file. this is a 'gotcha' i think. I am going to call this 'auto renameing'. In in previous versions if you renamed the layout, it would be renamed everywhere in the file. I actually liked this and couldn't believe it worked (reliably)... but it did. Worked for scripts too and so on.. If I understand this right, it seems that this new 8.5 feature(?), while giving the developer more control/power, it also opens the door to making more , uh, mistakes. Unless they've added somethi…
-
- 2 replies
- 1.1k views
-
-
I have a list of users and each has a field for either director or vp. I want to built a value list for both. In otherwords, I want one list with only those whose value is "yes" for vp and the same for director. I was assuming I could use some sort of self relationship, but I don't see where to make the relationship that specific. Ideas? Thanks! -- Chevell
-
- 4 replies
- 1.1k views
-
-
Superior knowledge requested! My Portal allows creation of new records, and this works fine - enter data in fields on last portal row and the record is created in the related database upon commit. However.... ...can I 'shuffle' the order of these Portal records? More specifically, all I want to do is click a button (in a row), which adds a blank record above (or below) the row with the button in it. Make sense? I guess some kind of sorting might be the key. Currently records are NOT sorted in the Portal, which is fine (records appear in the order they are created). Possible??
-
- 4 replies
- 1.5k views
-
-
I'm printing a report with Sub-Summary parts in the layout. I would like to have a summary of the subsummary parts, the same way a trailing grand summary would work except multiple occurances on a page. Example: Office Supplies 25.00 Internet Provider 50.00 Phone 30.00 TOTAL EXPENSES 105.00 Sales 200.00 Subscriptions 75.00 TOTAL INCOME 275.00 I suppose I could use a Trailing Grand summary and print each one on a seperate page, but is there a way to do this all on one page?
-
- 4 replies
- 1.2k views
-
-
I am a newbie so forgive me if I have posted in the wrong section. I have a database I created to manage incoming orders. When an order is complete I would like to be able to click on the complete button and have it put some kind of stamp across the front of it that says "closed" I know I have seen this done before. I often have repeating customers so when I search for customers orders I want to be able to easily see the ones that are closed.
-
- 6 replies
- 1.4k views
-
-
Hi, I assume someone has does this before. I want to add a column to the portal that will show the line number. This will allow me to do a quick count of items. Thanks, Skip
-
- 2 replies
- 902 views
-
-
Hi all, I have a IWP database i'm building to tie into our main database for our UK partner. I'm trying to put in icons to make it easier to use for the end user. I found that video on filemakermagazine.com that shows you how to create a database with thousands of icons - its great - i could really use those icons. Only one problem Most icons i downloaded - look great in fmp, but when i log in to the IWP through the website - the graphic looks like crap! not smooth, or it has a black background instead of transparent. I missed out on the fmp graphics pack freebie a few months back - so now i'm trying to find some. I found a few old .fp3 files - but no…
-
- 6 replies
- 2.3k views
-
-
hi Is there any way to permanently change the order of records in my database? I know I can sort them by right clicking in a field but I want to change the order that they are in when I open the database - at present they are in creation order, so if I create a record for a journal volume 9 issue 3 then create volume 9 issue 1 afterward, my database will always show issue 3 before 1. I've been told that's just the way it has to be but would appreciate anyone's advice or confirmation of this many thanks Carol
-
- 2 replies
- 804 views
-
-
Hi I have got an invoice layout, with a trailing grand summary that has the totals and some text. Is there any way to only make it display on the same page as some data? in other words so that it is never on its own on a page. thanks
-
- 0 replies
- 687 views
-
-
Hi all, This is a bit off topic, but not really (OK this is my justification...). I want to get some data mined from the internet into Filemaker. I feel comfortable parsing the HTML myself but the problem I am having is this... I need a way to automate entering a form and pressing a button to get the data I need. Now, I tried using cURL, but there is no way to get the data to post the web page that I know of because the page is an active server page, so I can't see the POST data. You just see the same .asp request going to the page but the page changes to find that person etc. I was wondering if anyone knows of any Macintosh software that automates ent…
-
- 1 reply
- 1.4k views
-
-
OK so I recreated the nav buttons onto my header along with a record count field. But I have a script that is a goto and come back script, in which to come back you need to click continue or to stay there you click cancel in the status area. Is there any way to get these onto my recreated nav area in the database? If not is there a work around to only show the status area when the script requires it? I assume that show status area then hiding it will solve this issue?
-
- 3 replies
- 882 views
-
-
Is it possible to grab a highlighted selection in a Web viewer then have FM 8.5 pass that string to a search engine. I've got this working fine with FM's own fields but can't seem to make it happen with Web viewers. FM's Get(ActiveSelectionStart) and Get(ActiveSelectionSize) both require a field as a starting point.
-
- 2 replies
- 1.3k views
-
-
Does this option store a relative or absolute filepath to the location of the image? I'm pretty sure its absolute, but i thought i'd ask anyway.
-
- 2 replies
- 798 views
-
-
Greetings folks! I've got two tabs set up, each containing fields from two separate tables. I've placed a button on each tab and have assigned the new record script to each button. When on "tab a", I want the new record button to enter a new record for the table represented on "tab a". When on "tab b", I want the new record to enter a new record for the table represented on "tab b". However, when clicking the button on "tab b", it starts a new record on "tab a". Any idea how I can fix this? Thanks in advance for your assistance! - - Jeff
-
- 4 replies
- 1.6k views
-
-
First I'll lay out the context of what I'm trying to do (although I've approached this problem several times before on other projects only to abandon it when it became clear I wasn't getting anywhere). I am tracking meter readings and consumable levels on about a dozen or so printers, approx. 5 different models. Periodically I'll do a full audit on the status of the consumables in the printer and it's meter readings and what we have in reserve stock. What I'd like to do is define the consumable set (different across each model) and then build the layout automatically based on that. eg If printer = model a then display only fields relevent to that model r…
-
- 4 replies
- 1.4k views
-
-
Hi All I am having a weird problem. I have a date field named "activityDate". This field has been formatted to display date as "dd/mm/yyyy". I use this field in a Portal. The problem is when I click on this field and enter a date and then exit out of this field, it changes month to day and day to month. Eg: if I enter 11/12/2006 for 11th, dec, 2006, then it gets changed to 12/11/2006 when I exit the field. It works fine if "dd" has a number greater then 12. Any help would be greatly appreciated.... Thankyou
-
- 1 reply
- 729 views
-
-
Here is what I would like: A portal showing one row that has a number of fields, and a button that will move the user from one portal row to the next. I can do this, if I choose "Show Vertical Scrollbar." It works exactly as I wish, and I just don't use borders, so the user never sees the scrollbar. In IWP however, the scrollbar is visible. What I need to know, is rather or not it is possible to use the Go [Next] Portal Row script step when the portal does not have a vertical scroll bar. I can't seem to maek the portal change rows if the bar is not there. Thank you.
-
- 4 replies
- 1.1k views
-
-
I have found the calender that you can use and it is grand, but when it comes to filling in time is there a clock? Or do anyone have some clever suggestion how to design it? Thanks Frida
-
- 3 replies
- 2.1k views
-
-
I have read several FM books, read every forum thread and downloaded the samples, I even understand the CONCEPTS, but dang it, I cannot get this to do what I want. I am aware it will take you seconds, so I defer to your judgement: I have a list of Courses and ClinicalParticipants. Some of the ClinicalParticipants are hospital employees (TJUH), and some are not. I want to filter the Course portal to show the course expense based on all records in the portal, employees only, and non-employees only. I can't get the global filter in the right spot to be related to the right field. I know I'm inches away from the solution, and I dissected so many other databases to …
-
- 6 replies
- 1.4k views
-
-
I am having troubles finding the right way to add database field info into the middle of a web url. Example - some websites use their search criteria in the middle of the url. It works great to add fields at the end of the url but I can't get it to work if the search is in the middle of the url. What can I add such as brackets and such to the field names in the middle of a url so that filemaker will change the url line to reflect the data in the field?
-
- 2 replies
- 1.4k views
-
-
I have been using portal filtering for some time but came across a potential error that I am trying to resolve. When my portal filter is empty the calculation used in the relationship defaults to "0" (zero) which shows all of the related portal records. The problem that this creates is that any filtered fields that contain data starting with a non-alphanumeric character do not show up in the portal when the filters are blank which is not the desired result. To put it another way only items starting with 0-9 and a-z will display when the filters are blank. So I need to switch from using "0" to using some other chacter that is lower on the indexing list. I …
-
- 2 replies
- 839 views
-
-
I want to have a "Duplicate order" button to duplicate a purchase order. Since the ordered products info was from a portal, it only duplicate the order info like PO#, date... the product info would be left blank. Is there a way to carry over portal records from the last record? I tried Go to Portal Row (last) then duplicate record. That only duplicate one portal row within the same PO. Not what I want. Thanks a lot for any help. -- MTG --
-
- 1 reply
- 844 views
-
-
Hey FM addicts, I'm tossing around the idea of building a forum style solution for my work. Was wondering if anyone out there had an idea where I might find a good template? I've looked around the FM site and in here, but haven't seen anything. I'm wanting something to run from FM server 8 on a private business network with about 12 computers or so.
-
- 2 replies
- 970 views
-
-
Hey everyone, I have a Customer Quote report that totals line items I have quoted. Everything is just how I want it except one thing. Most quotes contain 4 items or less and I have had no problem keeping it all on one page. Because of this I put the totaled summary field in the footer so it will always print at the bottom of the page. Well I just did a quote that needed 2 pages. As you may know, now the "grand total" is not only on page two(where I want it), but on page one. In these situations, because it will happen again, how (if possible) can I make the Grand Total only appear on the last page at the bottom.
-
- 4 replies
- 897 views
-
-
hello everyone my first post is very basic - I want to add a field which only has YES or NO options - but I want the default set as NO so that I only need to click to YES on the few occasions this is needed - is this possible please?
-
- 6 replies
- 1.1k views
-
-
One of the Gallery examples, , says: "Web Viewer objects can be drawn smaller as this resource will resize." How? There are no format options.
-
- 3 replies
- 1.7k views
-
-
in an early post, it is noted that the stock dashboard images scale based on web viewer size. Even in the example it mentions 'Note: Web Viewer (WV) objects can be drawn smaller as this resource will resize.' If I am creating a web site with images that will end up being viewed in FMP via WV, how can I set-up that site so that the images will scale to the WV field dimensions?
-
- 2 replies
- 1.4k views
-
-
I know this has been discussed before but I can't find the posts... I have a table HISTORY in which I would like to place a portal to show certain records in HISTORY. I want the portal to be filtered by three different global fields. FILTER FIELD RELATING FIELD gContact_NameFirst <===> Contact_NameFirst gContact_NameLast <===> Contact_NameLast gContact_IDnumber <===> Contact_IDnumber (g meaning the global fields that I'm using to filter the portal. gContact_IDnumber and Contact_IDnumber are both number fields, while all others are text fields) Basically the portal is not working. If I eliminate 2 o…
-
- 5 replies
- 2k views
-
-
I have a database (one table) that is used to monitor our facilities - the attributes (15) are summarized and a percentage is calculated. Two of the facilities have fewer attributes, requiring different calculations for the percentage. I have created three different layouts to accomodate the different attribute/calculation scenarios. My question: Despite these differences, is it possible to create a summary report using one layout?
-
- 0 replies
- 789 views
-
-
Is there a way to make a series of conditional value lists? By that I mean, if I pick a term in the value list attached to the primary field, can all the related values pop up in the second field? And in the third, fourth, etc? Basically I am trying to create a hierarchy of keywords...so if the top field is my "Facets 1" field and I pick the facet "materials," I want the field below it, called "Facets 2" to display all the corresponding materials automatically, upon my selection of the primary facet "materials."
-
- 2 replies
- 1.1k views
-
-
Hi, I am about to start my own database from scratch. I am pondering over the following. I want to have client contacts, supplier contacts, affiliate contacts, other contacts. Do I create one big contacts table and filter them out to different layouts using a contact type field. or Have 4 Seperate contacts tables (one for each type). At the moment I am leaning towards one table for ease of use but am wondering the possible advantages/disadvantages or pitfalls of both methods. All comments and suggestions appreciated.
-
- 1 reply
- 704 views
-
-
hi there I am building an EPOS system and i need to have portals on screen. Problem i am having is the fact the scroll bar for portals is small and cant for the life of me work out how to make it bigger and this is causing problem using touch screen to operate it, is is possible to make it larger? withough having to use the zoom function! Cheers Ben
-
- 7 replies
- 2.4k views
-
-
I have created a subsumary report. I have field called Disbursements that shows the amt disbursed for different projects. The summary field is DisbursementSum which sums the total of Disbursements. Disbursements is a numeric field that is indexed. The sub summary part it is sorted by location. The summary field of DisbursementSum is not showing any data. I am viewing it in preview mode. Any ideas what I did wrong? Thanks in advance for any assitance.
-
- 1 reply
- 783 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online