FileMaker Interface Features
-
-
I'm trying something pretty basic but can't get it to work. I have a Table of Artists and a child Table of Paintings. On a Layout devoted to Artists, I have a portal displaying a single line of data about each painting by the current Artist. Fine. Now what I'd like to do is have a second portal that displays an image of a painting that corresponds to the row in the first portal, selected by the user -- so you can click on various paintings in the first portal, and the image would change correspondingly. So, I'm figuring I have a Global field in the Artists table, say Display_g which I use to build a relationship to a Paintings TO (or in a filtered portal) w…
-
- 8 replies
- 1.6k views
-
-
Hi all I am trying to store an image inside a container field. If I right click on an empty field, I am able to insert an image in the container and the image is displayed in the container field. I would like to drag 'n' drop files into the container field. If I drag the same image that I inserted using the method aforementioned, I am diplayed a generic image that seems to indicate the file type, but also displays the image name. However, if I drag a document such as an Excel document into the container I get what seems like a preview to the file with no filename displayed. How do I get the image to show? If I use the right-click method of inserti…
-
- 0 replies
- 1.3k views
-
-
I need the text in any of a certain set of fields to appear red if the field has been modified after a given date. Every two weeks or so, the formatting is wiped and all text returns to normal, and the tracking begins anew. Currently, I've accomplished this (in FM8) using an audit trail that tracks which fields have been changed. Each field has a corresponding calculation field, and if the name of the field is found in the audit trail, this display field changes color. This works perfectly, but now that we've finally upgraded to FM11, I'd love to know if there's a better way to do this without hard coding the field names and/or needing to have the slew of correspondi…
-
- 1 reply
- 1.7k views
-
-
The background we use on our local database was created by taking screen-capped slices of another application, and then piecing together in the proper dimensions to fit our needs. It's something I have to stare at 5 hours a day, so I thought it might be nice to give it the look and feel of my other Mac apps. However, after the last upgrade from FM10 to FM11, the slices have different shades, making the whole layout look like a jigsaw puzzle. It doesn't prevent us from working, but it is annoying. Is there any way around this? I've looked through the preferences, and can't find one for "make the image files in your layout look the way they've looked for the past 4 ver…
-
- 4 replies
- 2.4k views
-
-
Need to create a custom menu script. So I don't accidentially create a new invoice. For example if I want to create a new invoice i would like a box to come up and say something like: "create new invoice" [Yes] [No] if I click yes then creates a new record, if I choose no than it ends the script. Seems pretty simple just need a little help, Thanks everyone, Jay.
-
- 4 replies
- 2k views
-
-
I've just come across a problem not previously encountered. I've just started using FMP11A 11.0v2 and, only for the first record in the database, a couple of value lists do not appear. They appear for all other records. If I duplicate the first record they work OK on the duplicate. If I delete the first record the problem transfers to the new first record. If I make a small change to another field on the layout, the value lists work until the file is closed. Opening the file in FMP8.5A doesn't display the problem. The file is hosted on FMS10 and I've opened it with a full access account. I'm also having problems with these VLs not appearing in PHP CWP. An…
-
- 1 reply
- 1.1k views
-
-
On an Event Entry screen, users type in the description of new events, much like keeping a journal. The resulting entries are kept in a single table, which can grow to several hundred entries. To help avoid duplicate entries inadvertantly being made for the same event (by different users), I need to show the "description" field from the previous two or three entries at the top of the layout for their reference. Since I create a new record only when entered information is fully validated, the entries at the top would be Last and Last-1 from the table. I'm having a mental block on coming up with a simple way to do this without using a portal. I could use a script t…
-
- 16 replies
- 2k views
-
-
I have several fields in my table that all should be selected from a master list of options. In some cases the fields should only have one selection from that list, in some it might need more than one selection. So I've set up a second table which is the master list. I know that I can set a filed to have to select from that list, but what about when I need more than one value? How do I have a field select multiple items from that list? Once that's done, when I want to present the information, how do I output the multiple selection items in a comma-delimited text string? Thank you.
-
- 6 replies
- 1.9k views
-
-
I created a Calculation Field (stored), and added it to a layout; however, it doesn't display unless I have the cursor in the field! And once cursor focus leaves the field, it again becomes blank. What have I done wrong? The calc is nothing more than Year(ReceiptDate), where ReceiptDate is a Date field.
-
- 3 replies
- 1.6k views
-
-
From a script, is there a way to test to see if the Web Viewer has finished loading? I know I can simply build in a pause to the script but I was hoping for something more precise. Thanks.
-
- 5 replies
- 2.2k views
-
-
Hi all. This has got to be the most basic question but it's got me stumped! I have two tables: "Buildings", consisting of two fields: Building_Id (the key, numeric, auto-enter serial) and Building_Name (text). And "Units", consisting of Unit_Id (key, numeric, auto-enter serial), Unit_Description (text). A building consists of one or more units. I want to relate the two files so that when I'm looking at the "Units" layout I'll see what building a unit belongs to; I've added, in the "Units" table, the field Unit_Bldg_Id (number) and created the relationship to connect Buildings::Building_Id and Units::Unit_Bldg_Id. On the Units layout, I've …
-
- 2 replies
- 1.1k views
-
-
I'm building a database for a high school sports team. There are various related tables for personal information, practice performance, team information (ie varsity, JV, jersey number, position), and competition statistics. I thought creating a new layout for printing rosters would be easy to do since all the information is already in various other tables. However, for some reason I can't make it work. I'm pretty new at database design so I could be missing something very simple. I tried creating a portal with the requisite fields for the roster print sheet (number, name, position, grad year). But the portal isn't populating with all the players, it only sho…
-
- 1 reply
- 3k views
-
-
Hello .. having a bit of a problem here... I have a portal that represents products for an order. There is a validation on the field "Colour" such that it will not allow the user to have more than 1 colour (done by Count Values) Now the validation works... but upon pressing ok after the validation warning, I am dumped back to the first portal row and NOT the portal row in question... (the last one) Any ideas?
-
- 5 replies
- 2.2k views
-
-
I developed a solution that is being used by others. On the top bar (tool bar? Menu? I'm not sure what its called) are default buttons. Show all, new record, delete record, Find etc, I want to deny the users via privileges or whatever, the ability to use these buttons, commands, tools, whatever they are called. I want to prevent all other users (except me) the right to delete records. How is this done? I have set up an account for each employee with a log in. so whats next? I'm clueless mostly because I don't know the nomenclature.
-
- 6 replies
- 3.1k views
-
-
I have a simple list view of records set up but I am having a problem with it. Sometimes when I click into a record it jumps from the top or the middle to the bottom of the list. why is this happening it is very distracting behavior. Is there some way to prevent it?
-
- 8 replies
- 2.1k views
-
-
Hi, This should be an obvious one, but I can't see the solution right now. I'm trying to alternate the filling color of a label in a portal row. The label is transparent and is used to hide a button when a certain condition is met. Using conditionnal formatting, I tried with "Get (RecordNumber)" and "Get (ActivePortalRowNumber" without success. Here's my calc : Mod (Get (recordnumber); 2) = 0 or Mod (Get (ActivePortalRowNumber); 2) = 0 Any clue on this one?
-
- 2 replies
- 1.9k views
-
-
I have a portal that is used solely to display some information, and I would like to make it so that users can't interact with the portal at all, meaning that even if they click on a row, it does not highlight/select that row. Is there a method for doing this built into FileMaker, or will I have to trick it by, say, placing something invisible over the portal?
-
- 1 reply
- 1.1k views
-
-
Hi all I have used a technique that Mr.Vodka documents to capture mouse button presses outside of field boxes. I have used an empty web viewer to do this. The idea is to stop filemaker from auto-saving the field contents that have been modified. All works well to an extent. I have anchored the web viewer so that it auto resizes when the window is resized. The problem I am having is that when a click is performed at the bottom of the screen when the window has been resized vertically larger than its default setting, the click is not captured by the web viewer and field contents are auto-saved. However this is not the case horizontally?? I have checked that …
-
- 9 replies
- 2.1k views
-
-
I have a PDF being displayed in a web viewer. I would like to download that pdf to a specific location via script. This is on a mac and plugins are an option. History and caveats: This file is generated by a servlet. The servlet tracks the session of the web viewer and prevents opening the URL from anywhere but the webviewer. I cannot send the URL to Safari, use CURL (if that's even possible normally), scriptmaster's get URL, etc. because they all make their requests outside the webviewer and so the servlet refuses the request. I can, using the acrobat plugin, download the file manually using the save to disk, but the point is to automate this. I can also change …
-
- 2 replies
- 1.9k views
-
-
I've got a layout with three related tables displayed in portals. Two of the portals are five lines long; one is seven lines long. I can only create five new records in each of the first two portals, and seven in the third one. Is there a way to get scrollbars on portals, or in some other way make it so I can enter an indefinite number of new records in each portal?
-
- 1 reply
- 1.2k views
-
-
I am trying to create a script that takes a value list, loops through each item in the value list, gets the value of the item, and then performs a find for that item. I am having difficulty find the functionality or a custom function that will accomplish this for me. Basically, what I want the script to do is get the total amount of items in a list (done this, this is easy), go to the first item, get the value of the first item, loop through and get the value for each remaining item, and then exit upon reaching the last item. I found one CF on Brian Dunnings website that seems to be what I want but I can't get it to work; it just returns a 0 value no matter wh…
-
- 1 reply
- 2.5k views
-
-
I am working on a project containing employees and projects. I have a portal displaying a list of projects related to each employee. My goal is to create a checkbox next to certain projects in the portal and then have the capability to export the project information along with the employees info to an XML file. I have attached a barebones version of both tables with several records and a portal to display as an example. Would someone be able to point me in the right direction? After I find a way to mark certain items and then export I will try to find out how to change the order in which they will be exported portal_example_01.fp7.zip
-
- 1 reply
- 1.4k views
-
-
I was wondering if it is possible to have a text box (in the footer lets say) that the user can just edit like they would in a word processor and not have it related to any table or field. Sometimes we have to put notes on different reports and if you have a text field it changes with what record your on. I don't want it tied to the current record, rather just to the current layout.
-
- 4 replies
- 1.3k views
-
-
There's probably a really easy fix for this but I'm just not seeing it. How do you resize the page width in layout view? On my mac its at 12 inces whereas on a windows computer its shows up to be about 8 1/2 inches which cuts off my report. What gives?
-
- 2 replies
- 1.3k views
-
-
I'd be lost without this forum, if for no other reason that I got honest to goodness outstanding answers. I have 3 tables... Customers Customer's Products Products I've created a layout for Customer's with a portal for the Customer's Products that lists all the products that that customer has purchased from us. I now want to have a separate layout where they can either add new products or edit an existing one. Typically, new products will get added through invoicing, but sometimes, a customer will call and say they have a product that we don't have a record of. This happens when they purchased from a reseller and they didn't send in their registr…
-
- 1 reply
- 1.1k views
-
-
I have 6 web viewers on one layout Each has an object name numbered 1 through 6 The script uploads images from a folder on the local machine to a web server. When the upload finishes I use the following script step: Set Web Viewer [Object Name: $$image; Action: Reload] The $$image variable has the number which corresponds to the object name of the viewer that I want to refresh. The problem is that it does not refresh. Any ideas???
-
- 1 reply
- 2.2k views
-
-
Friends, I am finishing a wonderful project, the catalog of the Baroque Music of Moxos (Eastern region of Bolivia). I´m acting as IT specialist, the real investigation is being done by experts in Music with admirable knowledge in this field. FileMaker was used and everything went as expected, the database runs perfect the scripts do exactly what´s needed and the layouts for the experts to analyze the partitures (images containers) worked great. The idea is now to produce a Layout with the data for each composition along with these image containers. The Layout has a Header, a leading sub-sumary by signature, a body and a trailer sub-sumary again for the same field…
-
- 6 replies
- 1.7k views
-
-
I am importing a spreadsheet into FMPro 11 that looks like this: HAR HA ADM TX PX 67824 ZC 04/06/2009 36854307 4452820 67824 CC 04/06/2009 36854310 4453541 67824 TC 04/06/2009 36907581 6801000 87298 TC 04/14/2009 37057448 6007600 87298 PR 04/14/2009 37057629 9012500 87298 CA 04/14/2009 37057684 9012500 I would like to create records that import like this: 67824 [Record] ....ZC 04/06/2009 36854307 4452820 ....CC 04/06/2009 36854310 4453541 ....TC 04/06/2009 36907581 6801000 ....[these are line items within the form/layout] 87298 [Another Record] ....TC 04/14/2009 37057448 6007600 ....PR 04…
-
- 6 replies
- 1.6k views
-
-
I am a new user to Filemaker looking to move my training diary into a database. I have my tables set up and am now trying to build a layout to view and edit the data. I've done a lot of searching online and made some progress but am now stuck. The basic structure of my database is: Training Diary which contains multiple training days which contain zero or more workouts which contain zero or more swim workouts. What I want to do is display a training dairy and let users add / view training days and from there select a day and show the workouts and select a workout and display the swim workouts. So far I'm managed to display the workouts for a given day by using a b…
-
- 5 replies
- 2.4k views
-
-
When moving objects they do not always snap to the object grid. I find them about a pixel or so off. Is this normal? That is, is the snap to feature not exactly accurate?
-
- 2 replies
- 1.2k views
-
-
Is there a way I can stop people from resizing my columns? I have their privilege set so that they can't edit layouts, only view them but they are still resizing the columns which screw up my header placement.
-
- 4 replies
- 1.2k views
-
-
I've got a preliminary set of sorting fields, called, let's say, LISTsort1 and LISTsort2. A third field identifies (via text serial #) a record (LISTserial), a fourth describes it with a text label (LISTlabel). I need a drop-down to display a calculation of LISTserial & " " & LISTlabel, but be ~sorted~ either by the text-serial value in LISTsort1 or LISTsort2. Trying to obtain this now, can have either LISTserial & " " & LISTlabel in my drop down, alpha sorted by LISTlabel, or something even less useful. Any thoughts? Selected drop-down LISTserial items are part of a portal
-
- 3 replies
- 1.5k views
-
-
I have a layout that includes 7 text fields, each of which could be empty, or contain up to a page in length. I have them serially placed on the layout and each marked for 'sliding up', so in layout mode 7 pages are shown. If, in one case, all fields contain a single line,and I show the layout in 'preview' mode, all fields properly slide up onto the first page, but there are still 7 pages that are 'previewable' and 7 that will print - the last 6 of which are blank. Is there any way, in this case, to get just the first page to print (or, in general, to omit printing of any trailing blank pages)?
-
- 3 replies
- 1.5k views
-
-
Hi. I was wondering if anyone could offer me some help on a layout/report I am trying to make. Well, it's a report I guess. I have attached both my database and a generic layout sample on a word document for what I'm looking for as it's easier when you see things rather than read them sometimes. Basically what I want it to do is generate a report from the Service Hours layout that lists all of the clients, not just the one particular record you happen to be looking at. I would like it to put all service hours for providers grouped together, and sorted by month. But to put a header for each. It's probably best to just look at my word document…
-
- 3 replies
- 1.1k views
-
-
I have a portal that I am displaying on a layout that has close to (and growing) 3,000 records. I want to only display the first 100 found records of a related set in this portal, however, using the new filter portal command in FMP 11 seems to only limit the number of portal records displayed to the user, not how many records FMP applies calculations to, and displaying a large found set in a portal takes a very long time on slower machines. How would I go about limiting the number of related records that not only are displayed in a portal, but also have calculations applied to them via the portal?
-
- 37 replies
- 9.2k views
-
-
My old version would show all the files that were open under the windows menu. Just switched to version 11 and only a few of them will show up even though they are open. I am running them remote so I have to go under file> open remote and open them again. The macs show more than the IBM but each computer is a little different. Is there a setting I can change so I can jump from file to file via the windows menu, and have them all show there?
-
- 2 replies
- 1.1k views
-
-
Curious about what you can see with a Mac and if you can modify the object ( for example adding a new color to a cell ) Object.zip
-
- 5 replies
- 1.5k views
-
-
I have a database that shows name and date enrolled. The names are in one table and the dates in another. When I do a report the date field shows the earliest date for each name. I need it to show the latest date. Thanks
-
- 2 replies
- 1.2k views
-
-
Hi, This is my first post so hopefully this is in the correct forum section. I've developed a DB for my business to track time spent on projects along with actions etc, however I'm having a little trouble on the timesheet entry screen. The issue related to muli users using it over a network (hosted on a local machine) The file has two tables - one with the information on the current user, dates etc to calculate the date for Monday, Tuesday etc (Al Global Fields or unstored calculations based on global fields) and the other with all the data to be stored for each time entry such as the hours work by who on which project on a particular day. The issue a…
-
- 3 replies
- 1.4k views
-
-
Is it possible to open another window while one is still open in same database? Basically I wanted to create a report menu and to add radio buttons that open a specific report when selected.
-
- 2 replies
- 1.4k views
-
-
I am making a report to show products supplied by a supplier. When I create the report, I select the different fileds from both the reports table and the suppliers table but when in browse mode, the fields of the relating table are never populated. It is as though the relationships are not working in reports but work elsewhere in portals etc. what am I doing wrong? See the attachement for relationships.
-
- 10 replies
- 1.6k views
-
-
I have a database full of fields where people are typing alot of content. The content fills the text field and you need to scroll down to see the text. Works fine, till you need to print. The person who made the database has it so that if the text is bigger than the box, it won't print the "hidden" text. I'm sure there is a way to do this, but it's been 2 years since I was in doing code and my brain is rusty. Can you help me figure out how to make a layout base the field size conditionally on the amount of text within the box?
-
- 3 replies
- 1.9k views
-
-
Hello all. I have a line items portal, and I would like to be able to give a total price of all items in the portal on a per-item basis. It's easy enough to total up all the extended costs to show a Unifid total, but I would like to show a total for just "ICE" and a total for just "SHOVELS" and so on, all on the same layout. How could I go about doing this?
-
- 0 replies
- 1.2k views
-
-
FM 11 advanced, Win Vista Iâ��m having trouble with summary data in FM 11. I have a layout that sorts by the correct break fields, but 1) the summary totals in the subsummary part are incorrect, (they display the last value in the column, not the total), and 2) an extra â��totalâ�� shows up in browse and preview modes near the below the last subsummary part. Iâ��ve attached a file showing views of the preview and layout mode. The break field â��categoryâ�� is a related field. I donâ��t know if this is the problem. The body part contains the cost data. I know that in FM 11 you can view the subsummary data in browse mode. Could this be responsible for â��totalâ�� appe…
-
- 6 replies
- 1.5k views
-
-
I am not good at writing scripts and I need help. I have 3 tables. The first is Inventory which contains vehicle description and ID No. The second is MileageFuel Use. The fields are Vehicle ID No., Date, End Mileage, Destination, Purpose, Fuel Type, Gallons, and Cost. The third table is MileageFuel Report. It is set up as a portal which has the related fields from MileageFuel Use. The relationship is based on Vehicle ID. I want to be able to show the records from the MileageFule Use table for a specific time period (7/1/10 ...7/31/10) for a specific vehicle. Right now I can show all travel and purchases for a given vehicle, but cannot break it down by time period. …
-
- 1 reply
- 1.2k views
-
-
I'm switching over from Access. In Access there is a switchboard feature that lets you make buttons for people to access different parts of the database. You can have the switchboard start automatically upon opening the database. Is there a feature for this in FMP 11? If so, does it carry over to IWP? How can I change the default starting page in IWP? Thanks!
-
- 7 replies
- 6k views
-
-
Hiya, FMP11/Win7. We have 8 tables (.fp7 files) and each have their own layouts. A script in one of the tables needs to use a layout (using the Go to Layout command) from another table. Is it possible to share layouts (or import like you can do scripts) between different tables. If this is the wrong way of doing things, what is the correct way? Thanks
-
- 13 replies
- 2.5k views
-
-
Can anyone tell me why/how when you click on the buttons at the top of my pages it turns pink briefly before turning to the selected fill color? I would like to change it to another color, anything other than pink! ha. Just I only selected the only fill color not sure how it is doing that. Thanks in advance for your help!
-
- 8 replies
- 1.9k views
-
-
Ok...I've been staring at this way too long now I think. Could someone please look at the attached and help me with a few things I'm having problems with? I think it's pretty simple stuff I'm just clueless at this point. It's still in the very early stages, I'm trying to make a database from scratch and I'm new to this so forgive me if it's a mess. I would like to do the following: 1. Service Hours Entry Form - Why does the field for "Returns For:" look different from the others...like a shadow on bottom and right or something. 2. Service Hours Entry Form - on the portal - service name, why isn't it looking up the services? Do I have the loo…
-
- 5 replies
- 1.5k views
-
-
Hello everyone. I am creating a few production reports. All goes well as long as there is something to find in the search criteria. If there is no record available, my report shows a blank page in preview mode, but a normal page with no record otherwise. There is a header with useful information, like how many projects for the months there was. It's not because there is no record found that the report is no good. I can have a 100% efficiency if there is no trouble found in the search and I need to see that data, print it and send it to my boss. So how do you people do with that sort of problem? I was thinking about creating a blank record within the tabl…
-
- 2 replies
- 1.5k views
-
-
Hi folks, I want to set up a value list, so that when I select items on the list, it appends to other items in the field, instead of that item being exclusive for that field. e.g. value list contains (VERY simple example here); Red Blue Hat, Shoes, From this list, I want to be able to sequentially select certain items that build on each other, such that my field might, after the selections, read something like; "Red Shoes, Blue Hat," I've seen this functionality in an ipad program (Handbase) and hoped I could replicate it here. Chris
-
- 7 replies
- 2.1k views
-
-
I'm new here so if I have stuck this question in the wrong place then please accept my apologies. I have just organised a layout in landscape screen view but have decided that i need it in protrait view as i will be displaying the data on a large screen which is mounted on its side. is there a simple way of changing the screen view orientation or do I need to recreate the layout turning each field individually? the big problem i have is that there are probably 300 fields on the screen; its a multiperson (20), multi day (5), 3 slots per day solution; kind of a large grid if you like. help please
-
- 4 replies
- 1.4k views
-
-
How do you add a little X box to a line item so that the user has the option to delete the line? Like in the invoices template. I've tried figuring it out from there but I'm missing something.
-
- 5 replies
- 1.7k views
-
-
Hi, I have 2 windows open, one is in form view which shows the content of the current record. The other one is a list view which is displaying an overview of all the records. I want to use this 2nd windows to quickly find and select other records. So when you click one it opens in the form window. (this i have done with a script) Now when i am browsing through the records in the form window, i want the list window to scroll along. So when i mousescroll down, from record 15 to 19 in the form window, in the list window also record 19 should be selected. Right now it does not "refresh" the selected record, it will stay on record 15. I hope my explanation makes…
-
- 2 replies
- 1.5k views
-
-
I've been chugging along merrily on a solution to track payments to our accounting department, but I seem to have hit a wall. Hopefully it's not a dead end! We receive payments from customers and need to track the multiple line items that a single payment can cover so that the money gets distributed to the correct accounts. I've got a table that contains information about the receivable (check #, total amount, date received, payer, etc.) Another table contains the accounts with their account numbers and descriptions. And I've got a join table called (perhaps confusingly) "payments" which connects an account and an amount with a receivable. For example, one record the…
-
- 4 replies
- 1.4k views
-
-
Hey guys. Hopefully someone can help me out here... I am looking for a way to have my records sorted by default. I can press the sort button but when I go to a different layout and go back again they go back to the way they were before. How do I get my records to stay sorted by default automatically. Many thanks!
-
- 1 reply
- 6.6k views
-
-
Hi I have a simple layout list... Which displays all records How might I filter certain records from my list... sample layout and script attached jpg.. Like would search blanks and other calc filed and omit do the trick? Thanks..
-
- 1 reply
- 1.1k views
-
-
Hi there, I have been using Filemaker for a few weeks now and am still blown away by how powerful the system is and what one can achieve. I have been reading so many posts here to get up to speed but can't seem to find the answer to my current query - Intro - We deal in shoes, and have a shoe database and another database that has all the components that make up the shoes (laces, soles, inners, etc...). These are linked by ID. I have a purchase layout where I create top level purchase orders. Each order gets it's own ID. In each order, there can be several underlying orders that have their own ID's that reference the shoe being purchased in the order. That…
-
- 0 replies
- 1.1k views
-
-
I am a bit confused between look up fields or just referencing another table. On my database I have a client form where I enter name, address, phone, etc. On another form, similar to an invoice, I enter services for a client and have the clients name and address fields referenced. I have a value list for the client name, its a pop up and you select from the list of clients. It automatically pulls up the address info. I've got this working fine. But basically, there is one field from the client page that could change periodically. So I want to be able to change it in the Service hours form but for it to not change in the customer form. I've attach…
-
- 2 replies
- 1k views
-
-
The layout parts have small buttons called "part labels"...I think. "Header," "Body," and "Footer," for example. Sometimes these part labels are horizontal. Sometimes they're vertical. How can I control that? Thanks in advance, Stan
-
- 2 replies
- 1k views
-
-
Hi, I need to extract some text in the date format. For example in my text field as below, every line looks like this, starting with a date part which does not have consistent format. 3/09/2009 - text text more text here... 4/9/08 - etc etc The year part sometimes is in 2-digit format and sometimes is in 4-digit format. I would like to have the format set as MM/DD/YYYY in the final product. I've already set a date field comment_date and plan to extract the date part from the comment box to this field. Wonder if anyone has a good idea on how to do so? My current method uses GetDate() function but does not return valid output for some dates..
-
- 16 replies
- 3.2k views
-
-
OK. I am willing to start over from scratch. Trying to create a database that tracks training attendance and gives credit hours to each attendee. I figured most of it out, but I could not get multiple training items in one record to credit hours to multiple attendees. For example; I will have one record to input multiple persons attending multiple training on one day with hours for each training item. I searched the forums like crazy and didn't find what I need. If there is a sample database that does this I can dissect and copy it. Please help.
-
- 3 replies
- 1.5k views
-
-
I would like to stop certain related fields that I display in layouts from being modified. I just want to display the data in list view along with the new data but I cannot figure out how to keep it from being modifiable. I am very familiar with the manage accounts privileges but there is no way to disallow certain fields from being modified in specific layouts. It either has to be in the record or for all records in the layout. I hope I am clear enough. If not please let me know. Thanks.
-
- 3 replies
- 1.3k views
-
-
Hello all, I'm a little bit new to FileMaker and have been tasked by my employer to make several updates/changes and additions to many of our clients' databases. I was wondering if there was any possible way to have conditionally expanding/contracting field or object sizes (or even conditionally visible/click-able) based off of a calculation. I have seen that there's a sliding/printing option to constrain them but that's only helpful for Print/Preview mode, rather than for what I need (Browse mode). Essentially, I have a container field used for special purposes in a Portal which I need to be of certain sizes based off of the entries found in another, rel…
-
- 0 replies
- 1.4k views
-
-
Hey All, I've run into a strange problem i've never seen or hear of. I have a layout that I select via button or drop down... for instance "Layout". When I select the word "Layout" form the drop down box, it goes to a blank screen and the word "Layout" disappears from the drop down box leaving no text (but the check mark still appears). I freaked out thinking something got deleted, but the records are still there (I know because it says in the tool bar viewing 12,000 records or whatever). I thankfully had a back up copy so I imported the layout objects and just created the new layout... .but when I went to delete the messed up one, i can't. It always appears in …
-
- 0 replies
- 1.1k views
-
-
Can anyone tell me how I change the fill color of a button to have two colors? Like the area behind the navigation button in the invoices template, it goes from grey at the top to black. I can't figure out how to do that using different colors. I'm assuming it's a button that was used because when I right click on it in edit is says button setup
-
- 3 replies
- 1.4k views
-
-
I'm currently trying to create a value list that shows only active products. I would want it to work where when I click the checkbox that makes the product inactive in its detail record, a value list created based upon products would show only active products. Thanks
-
- 1 reply
- 1.3k views
-
-
Hi folks, My patient consultation notes table is set to display as a portal on the patient's main information layout (different file). One of the fields in the consult notes contains an image. I want to be able to click on that image in the portal so that it can be viewed as a larger object so I can see the detail of the image (and then be able to close that new window to return back to the patient info screen). Can I do this? Thanks Chris
-
- 2 replies
- 4.8k views
-
-
Hi! I'm trying to develop a solution that will track work productivity. Our company tracks a certain fixed set of activities, which each employee must account for throughout the work day. Currently, when the activity has been completed, the employee makes a tally mark on a written shift report. At the end of the quarter, our supervisor counts the tallies for each activity and reports to headquarters. This is a total pain! Hence, the FMP solution... So far, I have set up the solution so that if the employee performs a certain activity, they click on the corresponding activity in a portal. This action activates a script trigger that adds a "1" to a numerical column n…
-
- 4 replies
- 1.5k views
-
-
I have a client that needs nearly the exact same information for two different programs. The client wants to use a an existing layout (master budget agreement) as a template for this new second program. I can duplicate the table and the layout but what I would like to know is if there is an easier or faster way to assign the new table fields to the new duplicated layout. All fields change to related fields when I duplicate the original layout and change the "Show records from" pull down to the new table. All the field names are exactly the same...there has to be an easier way than going through field by field and changing them to the new table.
-
- 2 replies
- 1.4k views
-
-
I have a table with 12 subjects. The user can go to a layout where they can select, through check boxes, any number of these subjects to create a found set of records. At any time they choose, I would like the users to be able to go to a layout, where using a dropdown list, they can select one of the subjects in the found set only, and go directly to the first record that contains that subject name. I don't want them to see all 12 subjects - only the ones that they originally selected. I also want to keep the found set that contains the selected subjects. I know that value lists will always show all the subjects available, not just the ones in the found set in a circumsta…
-
- 4 replies
- 4.2k views
-
-
Hi! Simple question: Is there a way to prohibit accidental record commiting a record in order to be able to revert a record while editing?
-
- 4 replies
- 1.2k views
-
-
I have a table, territories, which has 40 entries. The user can select 1,2,3, or even all all 40. Once selected I need the entries to be in all in a field separated by a comma. I am not sure how to address this. thanks, Jim
-
- 2 replies
- 1.2k views
-
-
Can anyone tell me what I have done to cause all my fields, while in layout mode to word wrap?. If the field description is longer than the field length, the words wrap and write on top of each other. It's hard to read anything.
-
- 1 reply
- 1.2k views
-
-
Hi. I have a script that adds several records to a table via a portal. I want the script to only add records if the related table is empty. If there are any records in the related table I want it to come up with a custom message. Thanks!
-
- 1 reply
- 1.3k views
-
-
Yes, I have searched the database for an answer to this. Clearly, I didn't find one. I need to highlight the active record in a list by giving it a different color. Old people like me view this database and the small vertical bar at the left of the screen is difficult to see. How do I do this?
-
- 3 replies
- 1.6k views
-
-
Hi all, I'm using portal to show data from related table "Tasks". One of field in task table is taken/related from another table "Contacts". How to make contact field in portal always up to date when data in contact table was changed. I was thinking use contact id instead contact name but I want to visualy operate with name and no id number. I must admit I'm total beginner in FM so if my question sounds silly be patient with me please:-) I would prefer step by step description. thank you.
-
- 9 replies
- 2.2k views
-
-
My goal is to have the field color (company) fill in a different color based on the value. I have a customer database I have a job database and I have a calendar view database of the jobs using portals. When the job appears in the calendar view, I want each customer to have it's own fill color so that you can identify the company by color as well as name. Although each portal is it's own relation based on day of week. I have the basic idea of a transparent field and using a global container, but the portal is throwing me. Thank you
-
- 6 replies
- 1.6k views
-
-
Hi, I'm writing a script to retrieve the record in a portal with the most recent date with it. I have sorted the portal in the layout with the correct order, but just don't know how to retrieve this related record.. I have a household table which relates to a comment table. So in the household layout, I have a portal to contain all the related comments, and they are sorted with most recent first. Now how can I retrieve the date of that most recent comment? Do I need to sort the records in the portal? If yes, how? Please advice. Thank you!
-
- 6 replies
- 1.3k views
-
-
I have a portal with a number of related records. One of the fields in the portal is a calculated text field which shows the name of any user currently using that record, if any. If no user is using that record, the field is empty. I would like to sort this portal so that all the records which are in use by users are listed at the top of the portal in ascending order (A, B, C...). However, when I sort the portal in this way, FileMaker considers the empty records to come before those with values in them, and thus all those records appear at the bottom. Might anyone have a suggested solution for this? Thanks in advance. (Note. One thing I have tried is…
-
- 3 replies
- 3.5k views
-
-
How do I go about changing the order of line items in an invoice? Let say you start adding items to the invoice and you you suddenly want to move line #3 to the top instead. If you only have 5 lines then you can just delete everything and retype them but what if you have 30 items? Is there an easier way to move line #27 to go under line #4? The only possible method I can think of is to add an autogenerated number field "sortOrder" and auto sort the portal by that field. To change the order of the line items, you would just change the number in the sortOrder field. But this complicates the process a bit for the end-user because a decimal has to be used in order…
-
- 2 replies
- 1.5k views
-
-
I have a solution with separate data and interface files. The interface file is linked to the data file through external data source. I accidentally deleted the external data source in the interface file and the interface file is totally messed up. All fields are missing and can't be recovered even when I put back the external data source link. What should I do? I can either manually remap all fields (too much work, hundreds of layouts, scripts and TOs) or start from backup files (lost a few days of work). Any other suggestions please.
-
- 0 replies
- 1k views
-
-
Hi everyone, Please bear with me if I am missing something obvious, but I can't work out how to display the final - rightmost - characters of the items in a value list for which I can only provide a narrow field on my layout. It needs to be a pop-up menu, which will display the full 60 character contents of each item on the value list when the user is making or changing a selection, but which will only display the * last * 20 characters of the selected item when the menu has popped down again. I should be most grateful for any help with this. Peter
-
- 2 replies
- 1.2k views
-
-
Hi, If I am going to make pages suitable for FmPro client, browser and iPhone alike, I need to be able to determine what method they are accessing the service - through HTTP, PHP, FmNet. I cannot see where to get this information so I know what layouts the client can use. Anybody help me please? Greg
-
- 3 replies
- 1.4k views
-
-
Hi everyone, I'm trying to design a "Help" section for my database that houses procedures lists for how to use the DB and accomplish certain tasks. My hope was to place a button link on each layout in the DB which would transport users to this section where they could choose a Help Document from a List layout and then display the text and images of the document itself on a form Layout. That's the problem though. The help documents that I've drafted in TextEdit (mac) contain both text and images and now I can't figure out a good way to display both text and images together on a layout in a way that makes sense. I can have the text field to hold the …
-
- 4 replies
- 1.1k views
-
-
Hi, I'm wondering if it could be possible to create a value list in relation with another one. I mean, for instance, I have my first value list, which is the specie, and I have the second one, that is the breed. If I choose "bovine" in the first one, I would like to have only bovine's breed in the second value list, instead of having ALL of the possible breed of bovine, horse, pig, etc. Is this possible?
-
- 1 reply
- 1.3k views
-
-
Hello, I would like your opinion on this "thing" I call a "malfunction" and not a normal behavior. What do you think ? Thanks Agnès MenuTest.fp7.zip
-
- 5 replies
- 1.8k views
-
-
Hi, I'm trying to classify my datas into 3 categories: 1. no. of doses by year 2. no. of doses by species 3. no. of doses by breed the problem is that I tried to do the exact same thing than into the CD, the file called Demo 07_2, which consist to have a name and a number. Only that. For instance, I would like it to appear like this: 1. 2006 (number of doses) 2007 (number of doses) 2008 (number of doses) etc etc. 2. Bovine (number of doses) Horse (number of doses) etc etc. 3. Polled Hereford (Number of doses) Colonial Horse (Number of doses) etc etc. But when I tried it, I still had 500…
-
- 6 replies
- 1.5k views
-
-
I have fields that I need to fill with a specific color. I am trying to use the color picker from within FM11 to sample the color that I want from a background image. For some reason whatever I sample is coming out a few shades darker than it should. This is really messing me up with my current project. Any suggestions? I tried changing the color profiles but it did not impact the colors at all. (this is not an issue where I am trying to sample from an image with noise or JPEG artifacts, I am trying to sample from a solid color that I have used many times) I had this problem a few years back and I was able to correct the problem by deleting a beta Fi…
-
- 4 replies
- 2.3k views
-
-
I have a graphic and some text in a header part and they will not print. I have some other text in the header that I have marked "do not print." However, in preview mode or when printed NOTHING in the header part will print. I have no idea why. It has in the past and I have made no changes to this report except to upgrade to FM 10. Any suggestions would be most helpful!! Thanks, Michelle
-
- 2 replies
- 1.5k views
-
-
This is driving me crazy: I allow for the layout shift between List and Form views (3 pts.) so the buttons between layouts--with differing views--all line up, but when I change the zoom level the shift rears its ugly head. Is there a way around this problem or no?
-
- 0 replies
- 1.7k views
-
-
I need to give my users the ability to horizontally scroll a layout (ideally, part of a layout). I have found bits and pieces about this, but no single, coherent explanation. The help menu tells me to create a button with a script that does the following: "Scroll Window (if the layout objects are wider than one screen)". However, 1) the "scroll window" script command does not give me the option to specify that I want a horizontal scroll 2) I don't know how to create a layout object "wider than one screen". I would greatly appreciate any help on this!
-
- 3 replies
- 2.3k views
-
-
Hi all, I am new here so if I post this in the wrong group, please point me in the right direction. My question is about moving files that are linked in a container field. Our company has recently purchase a new server that will be file storage among other things. I have moved all of the linked.pdf files to this new server, the link in the container field still points to the old server. Is there a way to update the container link to the new server? Thanks Steve Filemaker Server 5.5 Filemaker Pro 6.0
-
- 1 reply
- 1k views
-
-
Hello. I'm working with a portal that displays dates from a separate table. There are several records that have the same date but only want to see each date once. Is there a way for a portal to display a value only once? Thanks
-
- 2 replies
- 1.6k views
-
-
Hello, Can someone be kind enough to tell me what I am doing wrong with my graphics? I don't understand why they blurr in the lower corners. I set the anchors this way in other DBs but this is the first time I made my own. Graphics.zip
-
- 2 replies
- 1.2k views
-
-
I have a simple problem, but is hard to find the solution. I have a report that use subsummary and grand summary. I want to count the number of the subsummary part, ignore the records of the subsummary, focus on the count of subsummary part itself.Next I want to display the count of subsummary part in grand summary part of the report. I'll try to explain the problem as clear as I can. My report have more than one subsummary part, each subsummary part of my report has several records, each record has the same Reservation_ID and I sorting the subsummary use this field, something that I want to get is if there are three subsummary parts on my report, then the grand summar…
-
- 1 reply
- 2k views
-
-
Strange one [color:blue]Couldn't wait... so i uninstalled and reInstalled FM9pro again.... tested and it fixed it... but why the bug? And why didn't the control panel/ add/remove FM Repair work? Any idea's here ALL my layouts.. even a completly different applications... using my FM9 only IS - WAS corrupted in testing my ver 8.5 and 11 work fine with my code. [color:red]ProblemIF I RIGHT click the item or button.... and clicked Button Setup ...It freezes my layout goes un focus... If I hit escape.. that brings my back to forcus.. Ran a REPAIR from the control panel add/remove on FileMaker ok but its still happening? Any…
-
- 0 replies
- 1.3k views
-
-
Hi, I have encountered a strange problem with FM 11 on Windows (any version). While on OSX when I open a pop-up and start typing it moves the selection to the position of the letter I have typed. Same action does nothing on Windows, which is a problem, since I have fields with 50+ values in the pop-up and scrolling to the needed one is not an option. Any ideas? Thanks!
-
- 2 replies
- 1.3k views
-
-
So, first time posting, hope this is the correct format. Here's the problem I'm running into. I've got a members table that that has the fields member ID, Member Name. I've got a events table with the fields event ID, Event Name I've got a registration table with the fields registration ID, Member ID, Event ID Basically what the Registration Table does is register a member for an event via a pull-down menu that pulls data from value lists created from the Member Name and Event Name. Problem is coming when I want to create a portal that groups all the members that belong to a specific event together. If you can help, I'd really appreciate it. …
-
- 15 replies
- 9.5k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online