FileMaker Interface Features
-
Hey everyone I am a newbie feeling my way around Filemaker Pro 13. I got a database I am working on and I need some help with something. What I want to be able to do is have a number of check boxes with labels next to them and whenever I put a check in the box it will add digit one to another field on the same layout adding up as each time it's checked. So for example, having students who come and attend a class I want to track how many times they came to class by clicking that checkmark. Having it add the number of times I checked the box, totaling the days. Hope I've explained it clearly enough. Thank for your help!
-
- 13 replies
- 1.4k views
-
-
Dear lovely experts, Sigh. Several years ago I volunteered to help an artist friend by setting up a graphically complex database which made central use of a specific dingbat font (for musical symbols). Long story*** but... Now, on a much newer computer without the font, faced with a request to re-generate the printout, I don't even see how I can find out what the font name WAS, since FM only shows me the substituted-in font when I [convert and] open the file. (And, to be clear, there's no way of even approximating the desired output with a different font.) Somewhere in the file itself must be the name or other ID string for the font actually specified by my la…
-
- 2 replies
- 1.6k views
-
-
Is there any way to rotate a portal horizontally accross the page instead of vertically?
-
- 48 replies
- 15.8k views
-
-
Hello, could you help me? I wanted to undo something in layout mode using cmd+z, but i pushed something other key and i changed somehow the background to grey. In every other mode can i see the theme perfect with the background except in layout mode. do you have an idea, how can i change to the normal view? Thanks very much, Csaba
-
-
- 22 replies
- 3.8k views
-
-
I hope this is in the correct section. Â Hello, I am having trouble printing portals which are in sub-summary fields. I have a contact database where each person input their information in different tables. For example, medicine information, their emergency contacts, their Allergies, their physician information. All in different tables. What I'm trying to do is print it out. The first image attached is what it looks in layout mode, 2nd picture is in browse mode, 3rd is in preview mode(which is how it should look when it prints), 4th picture is how it actually prints. It is only printing the header. I am sorting all the sub-summaries by the contact_ID which every table …
-
- 1 reply
- 1.1k views
-
-
Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled…
-
- 6 replies
- 2k views
-
-
I've been utilising slides and pop-overs for data entry to try a minimise the number of layouts needed. Working lovely so far. I have a 'Company' screen, that upon entering shows a 'view only'. It has buttons for 'Find', 'Edit' and 'New'. Clicking these reveals buttons pertinant to the button clicked. When you cancel find mode, you go back to the record you were previously viewing. These seems to be default behaviour...fine. When you cancel edit, you obviously go back to the record you were previously viewing...fine. When you cancel new, you go to the last record in the table/found set...jarring for the user. So, when cancelling the entry of a new record, ho…
-
-
- 5 replies
- 1.4k views
-
-
Dear FMF Community, i have following Problem. Sometimes the content of my TextField/Portal is to much for the TextField/Portal, is it possible to show my customer a sign that there is more Data? This time FileMaker only doesn't show the content anymore, but you don't recognice that there is more. Sincerly, 51m0n
-
- 2 replies
- 1.1k views
-
-
Web viewer object uses google maps to display job location, brings up this error and user has to dismiss. I've seen some suggestions about makin it a static map. If I use map quest it's fine but the customer wants to use google maps. Â This error is making me nuts! I've searched and still not sure what the solution is for this error. Â I've attached a screen shot. Â Thank you!
-
- 6 replies
- 2.5k views
-
-
Hi, I'm trying to achieve something I expected to be straightforward, but after banging my head on a brick wall for 24 hours it's time to aask for help. I have a fairly straightforward company table and a contact table. Related one to many as you'd expect. When browsing a layout based on the companies table, I can see all the related contacts via a portal. I've never really done any reporting, but I wanted to create a report layout that gives me the company details at the top, and lists the contacts underneath. I expected this to be relatively simple, but I can't get it to work. I have the folowing report layout based on the companies table. Parts: He…
-
-
- 4 replies
- 1.7k views
-
-
I have moderate understanding of Filemaker, so I apologize in advance, but I'm a quick learner! I have a database with thousands of records. I need to create a layout (though I'm not sure that's the best option) that allows me to choose specific records and insert them based on their unique ID. Ideally I'd like to type the record in and "add" it to this new list. Additionally, I'd love to display them as "boxes" both horizontally and vertically so I can see all of my chosen records at once. I'm just looking for any advice on the most efficient way to create this. Thanks so much!!
-
- 5 replies
- 1.1k views
-
-
We've just completed updating to FM 12 from FM 11. Some of our report layouts have a very tiny subsummary part, so that the client name (which is how the layout is sorted) appears next to the first project, instead of above it. This was just to make our reports fewer pages, as printing a report with every project can be a real tree-eater. I believe I read something about how FM 12 handles this, but I can't find it now, and it looks like if I have a field on a layout which overlaps between two parts - it just doesn't appear at all. Is there a way I can make that field appear in full without taking up so much space? To summarize, I'd like the report to look lik…
-
- 4 replies
- 1.8k views
-
-
I have a layout with an imported picture(container field) and want the USER to be able to add an object on top of the picture at the position they click with the mouse. i.e. Place a Cross or X at the mouse position. I believe I can create the script activated by a script trigger, but can't seem to find how to determine the position of the mouse when clicked ?
-
- 2 replies
- 935 views
-
-
I have multiple tables in my database, my main table which holds most of my data, and may other smaller tables that hold various other data and link to the main database such as my smaller To Do List Table. I'd like to show the full record count of the To Do List Table as a (running count/number) on my main database table. However, I'd like it to display different counts for different users and specifications, such as Get current user: if matt then show a count of all records that have producer code 3. Whats the best way to do this? I have this count through various portals and filer on the main To Do List Layout, but I can't get it on my main table
-
- 1 reply
- 1.1k views
-
-
I have looked and I want to duplicate the default menu set and then change just a few things on it. But it will not let me. Do I really have to create a new menu set and copy all the menu items again into it?
-
-
- 5 replies
- 5.1k views
-
-
When clicking on a popup menu in MacOS version, you can type a letter on the keyboard and the list will jump alphabetically to that part of the list; however, this doesn't seem to be working on a Windows workstation. Is this a missing feature, or am I missing a particular configuration?
-
- 4 replies
- 2.2k views
-
-
I have a portal in my main database that displays records from the table (TDL) with a date and text field. I'm trying to write a script that copies the customer number from the main database, goes to the PLD table, creates new record, pastes the customer number (this is the key field in which my database is kept together) then goes back to the portal row from TDL, copies the text field, goes back to the PLD table and new record just created and pastes the text data into the text field. Currently my calc looks like this (see attached) but I'm not getting accurate copies. 1.tiff
-
-
- 10 replies
- 1.5k views
-
-
I compiled a runtime solution with Pro 12 for a mac user and all the fields that have a value list (radio buttons or checkbox set) are not modifiable. However text fields can be edited. On my mac, every things checks ok. Any idea?
-
- 5 replies
- 1.3k views
-
-
I have a database with orders, and per order there can be added items... Database works fine and all, but now I need to print it and it doesn't seem to be possible (I seem to need 2 bodies). Here's a sample of how I need it: ORDER 12345 12345 Product A $99.25 23456 Product B $24.38 34567 Product C $48.78 98765 Module 1 $5.98 87654 Module 5 $2.77 76543 Module 9 $9.18 45678 Product D $15.93 56789 Product E $36.55 98765 Module 2 5.66 87654 Module 3 3.88 Here's a sample of how I get it: ORDER 12345 1…
-
- 1 reply
- 1k views
-
-
Hello, I was wondering if anyone knows if its possible to have a list view that fills a column, but when it gets to the end of the window in that column, instead of a scroll bar it populates a second, third, or forth column. If it fills all four columns it would go onto a new page. You would be able to filter the results by last name by clicking a letter at the top. I made a mock up describing what I was hoping for. Thank you for you help!
-
- 7 replies
- 5.2k views
-
-
Hi all, I'm new here and new to FileMaker Pro and I need a bit of help. I'm creating a call management system and I have three table that I need to interact with each other. The first is the main table called Job_Details which includes a field called Client that is a list based on the table Clients. The third table is Job_Updates which is basically the updates against the job in the Job_Details table. In the Job_Updates table there is a field called Amount which is the rate to be charged for each client. What I am trying to achieve is that when I select the Client from the drop down list in Job_Details it automatically adds the rate into the Amount field on the Jo…
-
- 4 replies
- 1.3k views
-
-
Re a portal I have set up: in some instances when I click a record in a portal, it resets to the first record in the portal while in other instances, the portal will "stick" on the current portal - which is what I want - and not reset to the first record. Am using Filemaker 12. Anyway to stop the reset? Note: in the portal setup, "Show vertical scroll bar" is selected and "Reset scroll bar when exiting record" is not selected. Any help is appreciated! Frank
-
- 7 replies
- 3.3k views
-
-
Hi- I've always made FP layouts from scratch, but this time I decided to use the layout wizard to create a themed layout. I'd like to unlock all the elements in the template to customise it, but I can't select items such as the background panels in order to unlock and move them. Is this possible? Thanks, Jon
-
- 6 replies
- 2.7k views
-
-
Was trying to find the right place to put this, hopefully I will get some answers here. So basically I am trying to create a matrix style inventory database. The basic idea is that we have about 200 products and 700 or so customers. For the 200 products, each customer may pay a slightly different price. For invoicing purposes, I would like for FileMaker to know what the price of a product is once a customer is selected. Now I am looking at this in two ways, there could be more, which is why I am here! I figure that one approach is to have a table for each customer, with two columns: product # and price. Second approach is to have a table for each produc…
-
- 2 replies
- 1k views
-
-
We have a portal in a layout for scanning in items for wholesale invoices, displaying records from another layout 'Wholesale Line Items'. Everything runs smoothly when scanning and entering items. A sorted packing list is printed, and we use this physical copy to pack the goods in boxes for customers. Many times, it would inevitably be necessary to change the item numbers of some items on the packing sheet, as we do not have some of them in stock and other items are substituted. For example, we scanned in the following items: Item No. Description 32249 Remote Control 01207 Coloring Book 12745 …
-
- 4 replies
- 1.7k views
-
-
I have a buttons that only appear in the Find mode using the hide feature in layout mode. My customer doesn't like that the continue button is in the upper right when the script is paused. I have a button called continue. This might be a stupid question but is there a way to have press enter and it activate the button on the layout (PC or Mac)? Any help would be greatly appreciated! Caroline
-
- 1 reply
- 1.1k views
-
-
Hello, not sure if this is the right forum part, sorry if not. I am displaying a portal on a report but simply want to the portal to show the last 25 records, but currently it shows 25 records but starting from the very first record, so basically it shows the first 25 records, not the last. Can anyone help please. Thank you
-
- 7 replies
- 1k views
-
-
Hi!  This is a stupid problem but I just cannot figure out how it works.  I've created a small calendar where each day is shown in it own field. Each month the contents of the fields are calculated and placed to correct field so that if the first day of the month is Monday, it is placed to the first field. If the first day of month is wednesday, it is placed to third field etc. (please see the picture). Each of these boxes are named objects.  Then I defined each "box" as a button which starts a script and copy the date in the field to a variable $date (Set Variable [$date; Value:Get (ActiveFieldContents]). But for some reason I get nothing out of it.  …
-
- 4 replies
- 1.1k views
-
-
We currently have a FM12 Database that’s used as an appointments system for a local community transport charity and was designed to allocate and book volunteer drivers time and vehicle from a pool of volunteer drivers in order to take residents of the community to medical and private appointments. We also run Minibus Hire, Club Bus And a Shopping Bus Service, which are also entered onto the system in order to record the bookings. In order to enhance the current Shopping Bus Service the system has to be able to allow multiple clients, (passengers) to be booked on a specific Bus Route and Service. These minibuses run on set routes everyday collecting the clients and tak…
-
- 7 replies
- 1.6k views
-
-
Hi guys, problem here. I'm working with a web viewer and I'm familiar with triggering a script from within the web viewer using the fmp:// protocol. But, what I need is kind of the opposite. I have a 2000 records list that I need to display in my webviewer. As one may find, that is lots of html data, what makes my solution very slow. What I want is a webviewer that displays the first records and, when I scroll down (my first option) or I click a button (second option, but also ok) it displays more records. I'm aware that I could do that using the url protocol, calling a script, rewriting the html code for the webviewer, but that seems as a dumb solution So, i…
-
- 2 replies
- 3.9k views
-
-
Hi all. Hopping a guru can enlighten me. I have a field called "Service Performed" next to this field I have bottom with the below script. TextStyleAdd(TextSize(ticket::Service Performed" & "- " & Get (accountName) & "- " & "" & Get(currenthosttimestamp) & "Enter" ; 12 ); Bold) The basic idea is as users are typing and a new event needs to be entered a users would press the bottom and a time stamp with the username is inserted. It works find except the formatting. Now what I would like to happen is to either bold or change the color of the inserted line. but what I get is the entire field in bold. Is this possible. thanks R…
-
- 1 reply
- 1.6k views
-
-
I need to create a value list for a drop down to be able to choose the Graduation Year for students. I'd like the list to include: this year, this year +1, this year + 2, and so forth. I don't want to do fixed values since list will advance each year. Thank you
-
-
- 3 replies
- 1.7k views
-
-
I am having a problem in showing data from a second level relationship (not sure if this is the correct term). Here's the scenerio. Every year, I need to create new funds and expenses are created (PO, Direct Payment, Credit Card, Travel Expenses, etc) However, PO and Travel Expenses can be split funded by multiple funds. So when an expense is created it's not tied to the Fund, the Expense ID is created, and with in that the Expense Line. The Expense Line will contain a Fund field to tie it to the Fund Table. So my table relationship looks like this Fund --< Expense Line >-- Expense Now I want to show all the Expense related to the Fund table and Sum up al…
-
- 9 replies
- 2.6k views
-
-
Hey guys, I have a database that has a address book in it. In the table I have 2 fields one for customer and one for vender. If they are a customer I have the customer field set to Yes and the same for if they are a vender. Is there a way to have a list that only shows the customers or venders. Not all.
-
- 5 replies
- 990 views
-
-
Hi, I've been looking on the forum for this, but i didnt find something that matched my 'problem' I am working on a booking/reservation database for a small hotel. I want to prevent rooms to be double booked. So what I am trying to figure out is how to create a conditional valuelist based on the information in other records. Let's say I have a field called: "date booking" with the data "23-07-2014" and a field called: "room name" with is filled in using the conditional valuelist (bullets) and has data "room 1" Now if there's a second ot third booking on the same date 23-07-2014 the valuelist should exclude the rooms already used: so room 1 or any other room is not …
-
- 3 replies
- 1.4k views
-
-
I am trying to use an interactive container to preview a PDF file, except it is giving the expected result. When I navigate to this layout it opens the PDF in Adobe Reader, rather than previewing it in the container field. I used the Insert PDF function. Previewing of video files works as expected though. Am I missing something?
-
- 0 replies
- 1k views
-
-
I have a file in filemaker with a specific view. The problem i am having is that when i am on that view/layout and click on a button that saves the entire view as a pdf it cuts off most of the layout. Only part of it will fit on an 8.5 X 11. I have to make the print layout be A3 sized and landscape to fit it all in. I can set my print options on my local system and it works fine every time but if someone accessing the file remotely (since it is on filemaker server) tries to print it, it cuts off the layout and they have to change their print settings locally. this is problem because there are potentially 100's of users that will print from this layout and they…
-
-
- 2 replies
- 2.9k views
-
-
Hi, I have a need where the list of values in radio button format has text values that exceed approximately half the width of the screen. (I know you may see that as a little silly, but it's part of a questionnaire and the text needs to be what it is.) I want to resize the box so that the lines with the long values wrap around to the next line, but cannot see how it's done - if it's at all possible. Does anybody know how/if it can be done please? Cheers, Greg
-
- 9 replies
- 4.1k views
-
-
Hi all, I am having trouble with what I assume is a basic portal function, to use it as a button to goto the specific record selected in the portal on a related layout. For example; Student table and classes table Student layout contains the student name and a portal of related classes. When I click on the portal I want the classes layout to be presented displaying the record clicked on in the portal. It does not matter what record I select in the portal, the first matching (student) record is always returned. What am I missing? Thanks!
-
- 7 replies
- 1.7k views
-
-
Hello all! Â First time poster here. Â I've built several Filemaker databases over the years, but have never had this issue. Â By the way, using Filemaker 13 on OS X 10.9. Â Background: I'm building an inventory database for my wife's company. Â Her business sells retail widgets. Â She usually has several thousand times in stock. Â The unusual aspect (for my purposes) of this business model is that every widget is unique and has it's own serial number. Â The serial number contains data with related info for that particular widget. Â I am trying to create this solution so that as an invoice is created, the widget's bar code is scanned and entered into the line item por…
-
- 3 replies
- 2k views
-
-
I'm trying to put 3 related portals on a single layout to drill down data to specific records. Â In particular I have tables for Insurance Companies, Explanation of Benefits (EOBs), and Details. Â Each Insurance company sends us multiple EOBs explaining payments made on the the behalf of one or more patients. Â Â I would like to click on the Insurance portal to select an insurance company. Â This will show the EOBs received in the EOBs portal. Â The final portal should show the list of patients with claims on the selected EOB. Â Â In my relationship graph I have Insurances primary key linked to the insurance foreign key in the EOBs table. Â Then I have the EOB pri…
-
- 2 replies
- 1.3k views
-
-
Hi Is it possible to have two sub summaries in a report. I have two in my report layout but only one shows up. I am trying to get the crowd report all units to sort it by date and then under the date display some information that is then sorted by unit. Is this not possible. I did think about putting the unit section in the body above the scene details, But I don't want it to repeat the date and unit several each time there is a scene. Thanks Sarah Crowd Breakdown Template.fmp12.zip
-
- 22 replies
- 1.6k views
-
-
I have a table containing the names of about 12 mailing lists (number of lists may change later). I need to allow the user to select which mailing lists are to be used for sending a message, And I'd like to design the layout in such a way that it will automatically adapt when the number of lists change. It would be easy enough to show the list names in a portal, with a checkbox for each list name. But I'd really like to have the list in three columns so it takes up less vertical space on the window. Is there a way to flow my list of names into three columns along with their checkboxes? My goal is a final format that looks something like this (whether the list…
-
- 3 replies
- 1.2k views
-
-
I know I've seen it demo'd someplace, but for the life of me I can't recall how to insert an image with a 'watermark' effect -- a pale rendition that can act as wallpaper behind the fields on a layout. Searching for 'Watermark' in the Filemaker Help resource yields nothing . . . . I can't even recall whether you have to use an Image Field (preferable), or whether you do this via "Insert > Picture" as an object on the layout . . . I see that I can use a 'Graphic' for the Fill for a Part --- but that's not quite giving me the placement flexibility or the pale-quality I'm looking for. Any help?
-
- 1 reply
- 1.6k views
-
-
Hi Is it possible to add cell padding in table view? https://www.dropbox.com/s/9ouf38xuv80fz1d/Screenshot%202014-07-15%2014.49.02.png Thanks in advance Graham
-
- 7 replies
- 1.9k views
-
-
I have been struggling with this one for too long, and I believe that it should be simple, so I'm here to ask for help. I have an Employees table. The user can mark an employee "Inactive" when they are no longer with the company. It's a number field with 0 if they are still employed and 1 when they are no longer employed. I am trying to show only active employees on my drop downs. I can only get it to show ALL employees and I'm not sure what I am doing wrong. Here's what my TO relationship looks like: InactiveKey = 0 Here is what my Value List looks like: What am I doing wrong? Thank you, Ryan
-
-
- 6 replies
- 986 views
-
-
Hi There, I need some help with performing a calculation on a field in a table based on the contents of another field in the same table. The field I want base my calculation on is call Status whose content comes from a radio button set in a layout. The radio button set has three options Outstanding, Won and Lost. So I created a field called Outstanding set Type to Calculation and inserted the calculation: Case(Status = "Outstanding";1;0). When I display the field in a report all the rows show the value as 0 when at least 50% of the should display 1 and the Status field displays one of the three options. Then when I modified the calculation to use a di…
-
- 4 replies
- 2.1k views
-
-
My application generates a report to a new floating document window, enters Preview mode and displays the status bar. The status bar has buttons for navigating through the report, printing, saving to Excel or PDF, etc. All that's just what I need. But below the button the status area includes controls to change the layout, switch the view, or exit preview mode. I don't want any of those capabilities available to the user. How can I eliminate this portion of the status bar? Or is there some other approach I need to take? And, is there a way to add a "close window" button to this status bar?
-
- 4 replies
- 4.1k views
-
-
Hi Make an object visible upon Mouse enter: Want to show an object (a background panel) when the user enters its area https://www.dropbox.com/s/raky9y585xgng5s/Screenshot%202014-07-15%2009.34.45.png In the above case, whenever the user enters the Product, Project, or Contact area, it's background (a gradient box) becomes visible. How do I do this? If it's a script trigger, is there an similar example I can see? Much appreciation in advance Graham
-
- 2 replies
- 1.4k views
-
-
Hi, I've tried for some time now to install the VirtualSort module from Jeremy Bante and I am asking if someone familiar with this module can help me. I have followed the steps to the letter but when I click in the header buttons the portal won't get sorted; the only thing that changes is the function value that changes (VirtualSortFieldSorted ( Beleg::SortID ; "" )) => returns True for the correct column names. Here is my setup: Enclosing table/layout: Jahr Portal table: Beleg Unique id fields (both UUID): Jahr::id Beleg::id Default sort field: Beleg::SortID Optional sort fields: Beleg::Text, Beleg::Betrag My installation: 1.1 I imported the…
-
-
- 7 replies
- 1.8k views
-
-
Ok so I have I am having a problem with my Google maps multiple location map everything works perfectly if I have 10 locations or less, the map appears in my web viewer with the pins but any more then 10 locations and my map wont load, Ive tried multiple different locations and the magic number is 10. I do have a Google api and I am filling my Variable locations with a script all the works. but any more then 10 locations I get nothing any ideas? API Removed & Locations removed data:text/html,<!DOCTYPE html> <html><head><meta charset='utf-8'><title></title> <meta name='viewport' content='initial-scale=1.0, user-scalable=…
-
- 1 reply
- 1.3k views
-
-
Sorry if this question has been posted, but I can't find the answer. I have a summary report showing a list of vendors, and the amount paid for a defined period of time. We have 2 fields in this report "Vendor" & "Purchased" (summary field) in the report. We didn't purchased anything from some of the vendors, but they still show in the report. I would to only show vendors that have an amount in the "Purchased" field. Thank you.
-
- 3 replies
- 1.1k views
-
-
Hi All Win7, FM12 Advanced. I'm having issues creating shortened URLs and bitmarks using bit.ly's API. (http://dev.bitly.com/links.html#v3_user_link_save) I set the required URL as a variable in a script (mainly for debugging) and then use that to either "Insert from URL" or set the URL of a web viewer. The response of either is the same error e.g. <?xml version="1.0" encoding="UTF-8"?> <response> <status_code>500</status_code> <status_txt>INVALID_URI</status_txt> </response> Sample URL (api key omitted and line breaks added for legibility): https://api-ssl.bitly.com/v3/user/link_save?access_token=my_api_key&for…
-
- 2 replies
- 2.5k views
-
-
Hello all, I'm trying to embed videos from Vimeo into a filemaker layout using the Webviewer functionality using FMPro 13 Advanced. All my users are Mac based and have the latest flash player installed. However, when the web viewer loads, I'm getting "Missing Plugin" errors. Does filemaker support flash video? I would have preferred to use HTML5, however, I can't get vimeo's HTML5 player to play video. When I attempt to play, I only get a black window and audio Thanks for the help!
-
- 1 reply
- 3.1k views
-
-
Not sure what the right forum for this question is, but here goes. I am developing a home owner association solution. I have tables for homeowners and addresses, each with uids so I can relate them. That's all working. Now I want to add support for mailing lists. An address may be in one or more mailing lists. The relationship between addresses and mailing lists is many-to-many so I have created a join table containing address uid and mailing list uid. When I display a homeowner I display all their addresses (may be more than one) in a portal. For each address I want to display a list of mailing list names that address is on. E.g., "ListA, ListB, ListX"…
-
- 1 reply
- 1k views
-
-
Could someone please tell me why my portal isn't printing correctly on the Print_Itinerary layout? Â Â Even though there are two flights listed in the portal on the Trips layout, it insists on printing the first record twice. Â The file is located here for download. Â Â
-
- 17 replies
- 3.4k views
-
-
Hi, I've searched and it may be an oft known thing, but can the length of the dropdown be altered ?
-
- 5 replies
- 1.4k views
-
-
See attached images. Its only happening when the value list is in a checkbox.Â
-
- 1 reply
- 916 views
-
-
I have created a virtual list and I would like the variable fields to have a fixed length so that they align to give a table appearance. Is there a way I can do this? Is there a way to implement tab stops to effect this appearance?
-
-
- 1 reply
- 1.2k views
-
-
Hi, I want to do a conditional format of a button based on a self TO which the relationship is based on a get(currentdate) field .. but it's not working ie Table::datedue < [self]Table::Get(currentdate) I do tons of conditional formating but it's always been TOs which are not based on any calc fields .. so maybe it's a fundamental thing... or I'm missing something thanks Cate
-
- 5 replies
- 1.8k views
-
-
For all intents and purposes I have two tables. 'tblCompanies' is a straight record of company details (UID = CompanyCode), and 'linkBusinessAreas' is a table containing business area codes stored against CompanyCode as the relational field...so one to many, tblCompanies to linkBusinessAreas. Now, as a company can have multiple business areas, I have it set up so when entering a new company, there is a portal to 'linkBusinessAreas' and records can be added that way. This works fine. What I can't figure out is making it mandatory to have at least one business area entry for the newly entered company record. At the moment, it's perfectly possible to enter a new comp…
-
- 10 replies
- 1.8k views
-
-
I'm trying implement a feature on a list view using FileMaker Go that works similar to the iOS Mail app. When you swipe to the left, a Delete button shows. It's nothing super fancy, but what I've noticed is that when I swipe, the control slides for all records rather than just the one I want to see the delete button for. Is this normal behavior? A bug? Is there a way to force the slide control to only slide for the active record?
-
-
- 3 replies
- 2.6k views
-
-
Hi, I haven't found a way to use my onRecordLoad script with a portal. You know, whenever the active record of a portal changes, some actions need to be taken. Is there a way? Thanks a lot, Gary
-
- 2 replies
- 2.4k views
-
-
I must be overlooking this horribly, but how do I adjust the space between each letter in a field? In graphic design terms this would be called kerning or letter-spacing. Any help appreciated.
-
- 1 reply
- 3.9k views
-
-
In my solution I am applying custom menus based on a calculation, using the 'specify' option for 'Install menu when' The basis of the calc is Install menu set when [isEmpty (GlobalField)] My GlobalField is definitely a global FIELD (not $$var) and I use this to track whether a script is running or not. If a script is running then I want the custom menu to be removed, so I set the GlobalField during the script execution. Unfortunately the menu does not disappear as intended, however the calculation is correct. I tried manually entering data into GlobalField and still the menu does not remove. If I change window mode then the menu responds and is removed…
-
- 11 replies
- 5.4k views
-
-
I plan to make extensive use of modal windows in my application. When opening a modal window, I want generally to center it over its parent window. I do that by calculating relative window sizes and positions and then using Move/Resize Window to get it to be the proper shape and size. However, I have a "window flicker" problem--when I first create the window and assign the layout, the window is the same size as the underlying window. I cannot compute the position of the window until after I do a Resize to Fit so that I know the size of the new window. But by then the window is visible, so moving it results in it flickering from its created position in the upper le…
-
- 7 replies
- 3.8k views
-
-
Hello I am having some trouble with conditional formatting. In my database i have a table with the fields entry type, start date and end date These fields are in a portal on the main page and it displays the info perfectly and the way I want it. However, I want to change the colour of some fields based on the Start and End date. For example, If I set the field (entry type) as lab with the date the lab work was done, and another entry (record) with the entry field set as chemotherapy with a start date and end date, I want the lab row to change a different colour if its date falls in between the start date and end date of the chemotherapy. Is this possible? Pl…
-
- 8 replies
- 1.7k views
-
-
Hello I have datas in Columns (Fields) A, B, C, D, E. How do I transfer these datas to a single (Fields) "Column F," without using the import option. I need the datas in the same order as they appear originally in Fields A,B,C,D,E. Many thanks. Lawrencex
-
- 1 reply
- 862 views
-
-
Hi When i get my database to generate a crowd report it seems to make random page breaks, sometimes it will go right down to the bottom, then some times it will leave a massive gap, even though the next dates information will clearly fit on the page. I cannot see that I have set up any accidental page breaks. It seems very random and I have made sure the boxes that don't have information in them auto shrink to fit. Can anyone see why when you generate the crowd breakdown report it leaves gaps where the a date group would fit. thanks Crowd (9th edit) 2.fmp12.zip
-
- 0 replies
- 620 views
-
-
Hi, I have researched but did not find, so I would say I am not good at searching.. I have a database with several tables, and each table presented in a Tab. When I have a note I made a new window open with only the note field to be filled. Everything works good but the layout with the tabs returns systematically to the first tab when the note is in the fifth tab for example. I tried to set freeze window in the open script for the note window, but it did not work. What can I do to have the tab return to the original tab I was in when I close the note window. Any help will be appreciated
-
- 2 replies
- 1.7k views
-
-
Hi, I have a customer who has requested a default font across their solution layouts. Now I've tried to default Filemaker's Font in the past … unsuccessfully I must add; but since I was the only one interested in doing that, I just accepted whatever Font Filemaker provided. Which is perfectly fine for me. However, I am trying to understand why I can not set a default "Font" to a solution file even after reading this link ... http://www.filemaker.com/help/html/preferences.26.7.html I am I missing the secret decoder ring ?? I can understand when a "THEME" is applied, that whatever is the "THEME Font" is the default … makes perfect sense. However…
-
- 4 replies
- 3k views
-
-
Good afternoon, Does anyone here have any experience with the Music Library Template. I have it in front of me and am having trouble importing records into it. When I do, the tracks don't show. Any ideas? Thanks in advance.
-
- 3 replies
- 2.1k views
-
-
Thank you in advance for helping me out. I need a text (calculation field, text only appears when it's on the last page of the document - size of text varies from 1 line up to 15 lines) to appear on the bottom of the last page of my printed document. I've been testing with the different parts: - footer: seems to be the correct part but the footer part won't slide, even if my field does, so I have this open space in the footer of all the other pages. I also have a fix text address line in the footer. I looked for a way to make the footer part slide but even though Filemaker's documentation mentions the sliding of parts I can't figure out how to make the footer p…
-
- 6 replies
- 2.1k views
-
-
Hello Everyone, Just registered to the forum and this is my first post and very new to Filemaker. I was watching a video on the youtube about popover as data entry by Martha Zink, but theres no sample file on that video so what I did while watching Im also taking note the scripts steps she used, but as Im implementing its been a challenge to me because I cant make it work. Any help that you can extend is highly appreciated. Please find attached sample file. Please also move my post if I posted it on the wrong section of the forum. Thank you so much. Popover.zip
-
- 2 replies
- 1.8k views
-
-
Hi I have a database that was showing a field in the report, but suddenly it will not display it. It has information in the field and it is there in the layout of the report, but will not show up in the report suddenly for some reason. The field that is causing trouble is the one labelled description. I have tried deleting it and reinserting it and still does not work. I made sure it was to the front in case something was hiding it. Any help on why it will not show up is greatly appreciated as I am sure I didn't change anything on the field. Thanks Sarah sorry forgot to put that it is the crowd report that is having this problem Crowd (8th edit)-5.fmp12.zi…
-
- 8 replies
- 1.2k views
-
-
2014-06-19 UPDATE --  I made a new blank file in FMP 13, created a sample radio-button field at 9 point and it works fine / normally. I then copy-pasted the field to my current solution in FMP13 & used the style-clone tool. Despite not seeing any differences in attributes in the Inspector pallette, it fixed the problem.  ---Original post & question ---- I need to use radio button and check box value lists at small font sizes -- 9 points, in some cases even 8 points. At these sizes, FMP 13 Advanced is using a *single pixel* in the center of the selected target to indicate that it is "checked". This is crazy & unusable, yet I need to keep these butt…
-
- 1 reply
- 1.6k views
-
-
Using FM 13.1 Pro Advanced on Windows 7 Pro. Fairly novice user. Using no scripting at this point as I'm just trying to use FM native UI to see more clearly what I'm doing. Yes, this screams for a script, however... I have a TO containing 'individuals_TIMESHEETS'. This TO has two fields called zs_HoursWorked (a Summary field) and date_Timesheet (a Date Field). I'm using a sub-summary section to tally up total hours worked for each person. On my layout, list view mode, up in the heading I'm in Find Mode, looking at 'date_Timesheet' attempting to enter a range that will give me timesheets between two dates. In Find Mode I enter "6/2013...6/2014". FM inserts auto…
-
- 3 replies
- 2.4k views
-
-
Can anyone point me towards a more clean solution for sorting and show sort order in a list view? I've been using the technique that is included with many of the older FileMaker free templates. This requires a global field 2 values to hold the icon. A calc field for each column you want to sort like, hilite_Status, hilite_City, hilite_State etc... It also requires 3 scripts for each hilite indicator. (So for the 3 columns hilties i mentioned I'd need 9 separate scripts). Can anyone point me towards a more clean solution for sorting and show sort order in a list view? If I could get this down to maybe on script per column it wouldn't be so bad. This…
-
- 5 replies
- 3.9k views
-
-
Hello All! Love using FM's grid tool. But, the grid does not show where there is an object! The grid becomes useless in some situations, especially where there is objects on top of objects. Wondering if there is a simple check box, or something small that I'm over looking to show grid over top of all objects.? Thanks!
-
- 1 reply
- 827 views
-
-
Hi all... I am going to change our method of displaying High-ress Tiff-files, 22.000,stored on a Apple server, in Filemaker. Right now we use a import-method where Filemaker server grabs the (new or altered) images from a dropbox-like directory. This works okay but it's a lot of hassle and takes quite some scripting. In the new workflow i want to do this: - i know the max. number of product images - i know their exact name - i know where they are stored. I calculate the URL ( based on a static path, productcode and the imagename suffix) and show it in a web-viewer: this enables us to dump the images in the central server directory and not to worry: if it's t…
-
- 3 replies
- 1.5k views
-
-
I'm trying to create a 2-page invoice. I currently have a layout that includes a large Header, Body for line items (list view), Sub-summary for invoice total and notes, and Footer for payment info. This is the first page, and it will always only be one page long. For the second page, I will have a few fields and lots of "small print." It will also always only be one page. Is it "better" to somehow include this second page on the same layout as the first, or just create a new layout and script the printing/saving as PDF? Thanks! Michael
-
- 14 replies
- 2k views
-
-
Have a passenger list and next to their name it has 'adult', 'child' or 'infant' in a drop down list. At the bottom I wish to summarise the booking schedule so the person reading the report can see how many times 'adult' was selected for example. The following is in a portal: Age Bracket, First Name, Last Name, etc etc (Adult, Child, Infant), (First Name), (Last Name) etc etc At the bottom of the screen I wish to have: Adults: x Children: x Infants: x Thank you in advance. I love using this forum to learn!
-
- 5 replies
- 2k views
-
-
I apologize if I'm posting in the wrong folder, but this seemed closest. I know that when I set up custom colors and then log out, those colors are not maintained. I created a layout that has samples of each color that I need to use regular in other layouts, however I'm having a hard time with how to add those back to custom colors each time I log in. (I feel like this is a REALLY dumb question, and I've just come back from a vacation, so I'm probably just missing it.) I can add the first color to the first custom color box by right-clicking it on my layout, opening the "other color" selection under fill color, and then choosing "Add to Custom Colors". But when I …
-
- 4 replies
- 1.7k views
-
-
I frequently create contracts for customers that are signable on Go, then convert them to PDF's. Frequently these contracts have bullets and/or numbering. Is it just me, or is there no way to add bullets and numbering when directly writing text on a layout? Or is there maybe some work-around? I would appreciate any help. Thank you!
-
- 3 replies
- 2.7k views
-
-
I'm wondering if there is a way to get more metadata values out of image files than what FM 13 can currently get. I do know about Troi, but I'm hoping maybe there's another way (because I'm making run times), or that Filemaker might expand the set at some point. It would be great to get exposure, and other settings and maybe Timecode for video. It's pretty darn nifty to get at the metadata! I'm pulling lat and long and made a button to pop up a Google map.
-
- 3 replies
- 1.1k views
-
-
This should be an easy one, but could people tell me what the simplest, most efficient means of enabling a user to type a Heading for the top of a sub-summary report? What I have in mind is text that would go in the Title Header section. I've got the report all laid out with sub-summary parts, and a button that takes the user from the main data entry / search layout to the Report okay. I want the user to be able to scroll around, look at the report data and then Type in, say a 50-character (or whatever) heading that goes at the top of the first page. I'm figuring a global text field . . . but where? I'm finding that Title Header sections don't appear in Br…
-
- 7 replies
- 1.1k views
-
-
I have a field "Status" = If(EndingDate < Get(CurrentDate); "Expired"; "Current") Then I have a relationship which is set to match "Status = kCurrent" where kCurrent is a calc field "Current". This works great, except... As the date changes, the value of Status doesn't change, since it's an indexed, stored calc field. If I change Status to an unstored field, then the calculation updates in real time. However, the relationship breaks, since you can't have relationships that terminate on an un-indexed field. Is there any clever way to have a value list which works the way I want it to? I suppose I could change the field to a Lookup, and then run a …
-
- 6 replies
- 1.4k views
-
-
In Filemaker 13 I thought there was going to be an easier way to determine screen resolution and automatically resize accordingly. I have layouts that are designed for different resolutions. I suppose I can use a Get function to see what resolution is used on startup & point to a specific layout for that device (i.e. desktop, iPhone, iPad, laptop). BUT I thought in 13 there was an easier way so the layout auto resizes. Any help or explanation would be greatly appreciated. Thank you!
-
- 1 reply
- 2k views
-
-
OK, my last question turned out to have an idiotically simple solution, so I'm hoping this one does too. I have a Funds table, listing the various pots of money which can be used to purchase a given item. Each fund has a fund_name. There is also a fund_active field indicating whether the fund is still open for use, with values YES/NO. I have a Purchases table. When a record is created for a new purchase, one of the fields is "Fund" indicating the fund used to purchase the item. This field is a drop down value list, which is set to "Use values from field Funds::fund_name". Currently, this drop down shows ALL the fund names in the Funds table, and the list is g…
-
-
- 2 replies
- 4.2k views
-
-
Hi I would like to know if there is anyway to disable the highlight function when I click on a button? I don't want to see that highlight whenever I click. Is there a way to remove the highlight somehow? Thanks
-
-
- 6 replies
- 1.6k views
-
-
I have a database with a number of layouts. Each has the same logo at top left, a title in caps, and then a 1-pt line box surrounding the fields. For consistency's sake I want all these things in the exact same location on each page. In Layout Mode I have used the Inspector to check the location of all these items (for example, the logo is at 0,0) and they are identical across all layouts.  However, when I'm in regular mode and I click through the layouts, on ONE layout everything is shifted about 2 pts to the right, and there is a tiny gap all down the left side -- see screen caps (hope they're big enough). This gap is NOT visible when I look at it in Layou…
-
- 4 replies
- 1.4k views
-
-
I'm trying to make a UI element that would mimic a search field with dynamic results being displayed in a popover button below the field, sort of like http://www.seedcode.com/fm-search-results/ However, I'm unable to get the popover button to display if anything outside of the popover has focus. I assume this is a feature of the way that popovers work, but is anybody aware of a workaround that would enable me to have an active field outside of the popover while maintaining the active popover state?
-
- 4 replies
- 2.2k views
-
-
Hi all I have started using FileMaker about a month ago, and before then I haven't even heard about it. I've done a lot of reading, watched videos, went through training materials... Since then I normalized the existing database and am working on making things work properly. I managed to get filtered portals work and used ExecuteSQL to perform a count for which I didn't want to create another relationship. So far so good. But now I am stuck. It might be easy but I just don't see a solution. I want to create a layout that is not based on any table. It will just be a layout with a bunch of buttons that would open various reports. How can I do this? The way I…
-
-
- 8 replies
- 2.1k views
-
-
Hi All, I am trying to hide a button unless a certain privilege set is used, however, when I try to enter a calculation ( I tried to use Get ( AccountPrivilegeSetName ) ≠ [Full Access] ) it comes up with errors. Clearly I am doing this wrong, but I cannot find anything that gives me a guide as to what I am expected to do. Can anyone tell me how I can achieve this? Cheers
-
- 1 reply
- 2.6k views
-
-
I have a database that tracks jobs.. Under each job I select which employee worked on that job using a Value list of my Personnel table. The personnel table has 200 names.. but only 50 still work for me. the Table has a Current employee field with values "0" for former employee and "1" for current employee. I want to only be able to select from employee in that table that has a value of "1" What is the best way to do this? The Jobs table is linked with my Employee table Via "Employee ID#" After reading some of the post on this site I have decided maybe the best way to do with is to create Calculation field in the table to Calculate and Full Name only if the Current Em…
-
- 2 replies
- 1.7k views
-
-
Fellow developers, a question I must ask (I'm sorry if this seem so unusual; my filemaker development is not the most common) I have a database of paragraphs. The idea being, each paragraph is a record, in a Table named Reference. The whole idea of this database, which has more tables but could work with just one, is to make a manual, a handbook for the company I work for. Let me give a example: we have a specific instruction on how to deal with taxes at importation. We create a record named: taxes at importation, and we related this record to another record in our self-related table (taxes, or importation). So: RecordID_pk FatherID_fk Title R…
-
- 2 replies
- 2.2k views
-
-
I have a script I would like to execute with a button click. The script works fine, but I would like to pass two variables into the script. I'm not sure how to do this, but I've been trying to use the Specify Calculation to do this. The following is the script: I would like to replace the fun and the 000000 with information from the database. Could anyone point me in the correct direction, or provide a hint for me. do shell script "osascript NewFromTemplatePlaceImage.scpt fun 000000" Regards,
-
-
- 12 replies
- 3k views
-
-
This is a follow up to my recent post "Go To Related Record From Sub Summary Report in Browse Mode" but it's also a multi purpose question so I figured I would start a new post. First, please be aware that we are running windows and opening a new window is an ugly user experience on Windows that I simply don't find acceptable. So I don't want to open a new window. Just wanted to save time not having to respond to that suggestion because it is always the first and most suggested solution. I went through that when I was looking for a way to restore a portal position. I have a really good technique for restoring a portal position, but it doesn't translate to list vie…
-
- 2 replies
- 1.1k views
-
-
I have a sub summary report based on payments, related to invoices, related to customers. The basic invoicing structure. It's built to view in browse mode with multiple options for sorting and grouping. To simplify the question, let's just use the basic scenario of all payments grouped by payment method. So I end up with a grouping of payment types ( check, cash, money order, credit card, etc. ), number of payments and amount. What I would like to be able to do is have a go to related record button next to each payment type that will go to a found set of that group. I've tried using the Go To Related Record function but it doesn't seem to work in that way. Any Ideas? …
-
- 7 replies
- 1.6k views
-
-
Before FM 13, we have to display close to 100 fields on the layout. With FM 13, we can now 'hide' most of the fields either in Popover or slider. I called this "display-on-demand ".. Questions: Does 'hiding' fields in FM 13 improves the performance against having to visibly display all the fields in the layout ?
-
- 0 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online