FileMaker Interface Features
-
Hi Everybody I wish you all a very prosperous 2016 and may all your wishes come true. I have been using some of my holiday time to update my FM solutions, so far I have managed most of what I wanted to do and learned a couple of tricks on the way. Now I have found a roadblock, using different value lists on the same field. I have many value lists based on relationships and they work fine, but in this case the situation is: a) It is a checkbook solution, if there is a relationship it displays certain values (List of debtors/creditors in one field, invoice numbers with balances > 0 in the next and Invoice value on the next). b ) However payments …
-
- 8 replies
- 1.8k views
-
-
I don't even know where to begin.  I have a db...In every layout for every tableâ��in spite of the fact that their parts all have a white fillâ��the background turns red in preview mode. I'm using 12, so if I change the theme, this doesn't happen, but if I change the theme back to classic, I get the red background again. I put white rectangles covering the layout parts and that helps; except at the part boundaries, you can still see red and there's nothing you can do about it.  Any ideas where to being troubleshooting? I found out that if I remove the white background fill, the default color is red...in classic...So what that seems to mean, then, is that in previe…
-
- 4 replies
- 5.3k views
-
-
I have added an additional TO to sum the withdrawals in a set of financial records by year, Withdrawal YTD column. I would like to show the yearly Withdrawal YTD sum in the last record of the year only and be blank in all of the other months in the given year, it may be Dec 31 or may not. All of the records would still be there, only some the values in the Withdrawal YTD column would be blanked. In this example only these values would show in the Withdrawal YTD column. Dec 31, 2008 $8,000 Dec 31, 2009 $9,000 Dec 31, 2010 blank Dec 31, 2011 $10,000 Dec 31, 2012 $11,000 Jul 31, 2013 $12,000 Before data below.
-
- 10 replies
- 1.6k views
-
-
I have a solution with a text field that has a varying amount of text stored in it for each record. I am working on a print layout using two columns to print the records found set of this text field. As it is currently designed, if the text in the last record in a column is too long to be displayed in the column, it gets chopped versus wrapping. I have found multiple postings regarding this topic from 2008-2009 time frame, but don't see anything current. If I compiled the information into a variable and then split it up based on a character count, would that work or does anyone have suggestions on how to print multiple column layouts for large text blocks across …
-
- 0 replies
- 1.3k views
-
-
I remember a while ago looking into creating a desktop shortcut to a file hosted on a server machine and it was a little more complex than I expected it to be. Has anyone had luck in creating a desktop shortcut that opens a FMP file over the network? I'd also like to use the icon I created rather than use the FileMaker default. I would need to create a shortcut on Macs and Windows computers.
-
-
- 1 reply
- 2.7k views
-
-
So i was cleaning up some user data entry and noticed some fields had errant returns in them - which of course is bad when the field is used in a relationship or value list. Managed to clean up the set of records - and thought the easiest way to prevent this is at the point of entry by making the return and enter keys also go to the next field. However today I discovered users were getting a bit frustrated because when they perform a FIND and enter a value and hit return, it advances and doesn't perform the Find they have to click the button in the toolbar. I could have a separate set of fields ones that HIDE in browse and ones that HIDE in fin…
-
- 3 replies
- 1.5k views
-
-
Hello All, Apologies for basic questions. I really wish that there was a FMPUG within driving distance... I have a DB to track our farm animals, and have the recurring issues that us newbies have; how to track parentage. Issue # 1: when I enter a sire or dam on an individual record, that animal (the sire or dam) also needs to be included in the database. Issue #2: getting portals on a record to work properly. The individual should be listed as a parent in the 'matings' portal, and the offspring should then be in the 'sheep' table. I tried to use TOs to make this happen, but I think I have not linked them properly. Issue #3: getting only male…
-
- 2 replies
- 1.2k views
-
-
I've searched through some other posts about this and it seems to be a Windows problem. We're using Filemaker Pro 14 and I didn't have this problem when I was on Windows 7, it only started after upgrading to Windows 10. *shrugs* Anyways, the scrolling through records is beyond annoying. We keep up with our customers purchase history in this program so the pages can tend to be long and we need the vertical scrolling (not scrolling through records.) The only thing I've seen in the other posts is using a program called KatMouse. I downloaded that, but I can't figure out how to get it to scroll vertical in filemaker (it still scrolls through the records). …
-
- 4 replies
- 1.3k views
-
-
I am trying to display the preview from a dropbox file in a webviewer, but it doesn't display it as it does in my web browser. When navigating to an image file in DropBox via a web browser it has the URL www.dropbox.com/home/FOLDERPATH?preview=FILENAME where FOLDERPATH and FILENAME are variables. I copy this URL from the web browser into a web viewer and it doesn't load the same.. it says the folder/filename does not exist. I then paste it back into a web browser and it goes to the preview of the file as expected. Has anyone else experienced this, do I need to adjust something to make it display the preview in the web viewer? Or is there another way to display t…
-
- 0 replies
- 1.5k views
-
-
I need to have a solution to update my inventory list. In my example I have a table to produce with four legs and one table surface. When 100 tables are produced on day one it means 400 table legs and 100 table surfaces are used. I know I can add also new transactions in the transaction table but then it means the actual stock amount might not be always up to date when users forget to update the Amount_out in the transaction lineitems. How can I add transaction_lineitems for both the 400 table legs and the 100 table surfaces when I add the amount 100 into the amount field in the production line-items Thanks in advance for the answers. Inventory…
-
- 7 replies
- 1.3k views
-
-
I’ve got a bit of an analysis task coming up over the next few weeks. The idea is that we’re going to be sifting through a database of orders, and essentially tagging each order with assorted variables. At the moment what we have is a fairly basic invoicing system, there’s a table of orders and a related table of line items for each order. The plan is that we’d add field(s) to the Order table for the variables we want to track, and then it’ll be a process of manually reviewing each order. The variables have to be added manually, there’s nothing there that could be derived from a calculation or summary on other fields unfortunately. It’s t…
-
-
- 10 replies
- 1.4k views
-
-
Hi Everyone! I have a problem with something that works fine in FM13, but does not work in FM14. I am using a web viewer to display a *.dwf file, which is an Autodesk file we use commonly for displaying drawings. For those who are unfamiliar, think of it as Autodesk's version of a *.pdf. I'm running Windows 7, and I have the Autodesk Design Review Software installed. When I access the file in Filemaker through the web viewer in FM 13, it displays right in the web viewer, which is what we want. If I do the same thing in FM14, however, it wants to open in the outside application. To demonstrate this, I created a stripped down version for FM13, and one fo…
-
- 8 replies
- 2.7k views
-
-
just curious what people prefer when developing a multi device / platform design for Desktop / iPad / iPhone / WD Do you prefer to essentially create different versions of the solution inside one file and treat each target device as an independent solution? Duplicate scripts for each device, so that navigation is targeted only to layouts for that device. On startup establish the device solution is open on and navigate to that portion of the database. - or - Create separate layouts for device dependent context - but reuse common layouts between various devices. Maintain one set of scripts for function and navigation but always testing for device / platform to target …
-
- 2 replies
- 1.5k views
-
-
I'm using a web viewer to display a html webpage that allows the user to interact with it via java scripts. The web page works on a Mac running FM13 and FM14 with Mac OS X 10.10 and 10.11. When I try to view the web page in a web viewer on Windows 7 running with IE11 installed, the webpage doesn't allow any interaction with the java scripts, and the web page renders incorrectly. I'm running FM13 and FM14 in Windows 7, and they both render the webpage incorrectly. When I copy the HTML out of FileMaker and paste it into a file and open it directly in IE11, I get a security warning on the bottom of the window that says "Internet Explorer restricted this webpage from run…
-
- 0 replies
- 1.8k views
-
-
Hi all Since upgrading to FM14 we've experienced crashing (errors 1000 and 1026 in the error log). I thought perhaps it was to do with version 14 or .net or my scriptmaster plugin. However it appears to be to do with a filter that I had in place for a portal. It was probably just a coincidence that I had so many records that it was referring to by the time I did the FM14 upgrade. I can probably do without the portal altogether really, but was just curious as to what the problem might have been. The filter formula was: Cases Closed::Closed_TimeStamp > (Get(CurrentDate) - 30) The Cases Closed table has around 22,000 records. Any ideas what's…
-
- 2 replies
- 2.3k views
-
-
Hi, I have a design idea in mind that the only way I can describe it is nesting a portal within a portal. In my solution I have a case or ticketing system. I have a customer record in the customers table, and a case record in the cases table, and then a case notes table which holds multiple notes that can be added to each individual case. As a customer can have multiple cases, and one case can have multiple note records, I currently use the customers layout to go to the cases layout. This works fine, but I would like to streamline it so I can view all cases and notes on each case from the main customer page without having to navigate to another lay…
-
- 2 replies
- 3.4k views
-
-
im trying to copy portal to portal with a loop but only the first record is copying . my situation is when i type the item on orders, it shows the colors the item is available inside a portal ... so i need to copy those color that shows in portal to the orders line items .. please let me know what im doing wrong ( attached file) the loop im doing is this : Go to Object [ Object Name: "colors" ] ( this goes to colors portal) Go to Field [ items_line::color ] Go to Portal Row [ First ] Loop Set Field [ order_line::color; items_line::color ] Go to Portal Row …
-
- 3 replies
- 1.2k views
-
-
How can I set and change the font of a merge field that will appear in a mail merge letter? Especially when it is a different font from the font as used in other layouts? I am having special difficulties with merge field numbers that are dollar amounts. I cannot get Filemaker tout commas in the right places of the merged 5 or 6 figure number.
-
- 1 reply
- 3.7k views
-
-
This is a very basic demo for portal filtering including an "All" option for those that have asked backchannel. * Edit - made a modification to file. Portal_Filter_Basic.zip
-
- 17 replies
- 5k views
-
-
Hello, Currently customizing a FM 14 invoice starter solution; I've added a new field "service fee" to the invoice details layout- when FM is in layout mode it shows properly aligned i.e. where I want it. However, when switched to browse mode it does not (shows to the very left of the "service fee" field label- you can see the tail end of data entry in the field "00" on the very left.. I've tried moving the field to reflect properly when in browse mode to no avail. Any thoughts on what might be causing this odd behaviour? Please see attached. TIA. Jack
-
-
- 4 replies
- 1.1k views
-
-
We recently upgraded from FMS 11 to FMS 14 and we noticed different behavior in our drop down lists. say we have a value list of the numbers 1 to 100 and we have a drop down list that uses that value list. If you have Auto Complete OFF you have this behavior: click in the field - scroll down and choose 50 - click out of the field - click back in the field and the drop down list will already have 50 selected and you can easily click on 51 as it is next in the list. If you have Auto Complete ON you have this behavior: click in the field - scroll down and choose 50(or type ahead) - click out of the field - click back in the field and the drop down…
-
- 0 replies
- 1k views
-
-
Hello, maybe somebody can help me with my portal problem. I have a Contacts Layout "ContactsLay" with a table "Contacts" and in that layout I have a Portal "Reminder" table "Reminder" where i can create task for the contact person thats showing up. Now my goal is to have also another Portal in the Layout "ContactsLay" which shows the reminders of all contact. I am fairly new to filemaker.... I am working with FM14a Thank you Portal.fmp12
-
- 0 replies
- 1k views
-
-
When upgrading from FM12 to FM 14, we are having a problem with the font size on our dropdown fields. Even though the field is set to a font size of 12, when the field is clicked and the the dropdown list appears, the font size very small, a 8 or 9 font size. I tried changing the field to a popup, but with the same results. It worked fine in FM 12. We are using Win 7. Has anyone else experienced this issue?
-
- 2 replies
- 3.7k views
-
-
FM 12. When I click in a portal, all the fields (in all the rows) are outlined with light dotted lines. I have the field graphic line set to none (in inspector) and Text and Field boundaries set to off. What causes this and how can I turn off the dotted lines?
-
- 3 replies
- 1.1k views
-
-
Before I make several design changes that impact end users data entry methods I am trying to decide the best approach to accommodate the changes that are being made: Currently: The user enters a Date in a date field and a time like 8AM-6PM into a text field. One set of fields for an Event and another set of fields for Setup. Development: I have normalized this event data into a separate table and parsed the time field into a its key parts mostly the start time and then also introduced a duration field so the intent is the user just enters the date and start time and a duration (from a pick list) I have a calculation that will resolve to two timest…
-
- 16 replies
- 3.5k views
-
-
I do not know what to call the tab which reads BODY or HEADER. Sometimes it appears to the left and sometimes on the bottom of a layout but if I have a field label in a report and that tab is at the bottom so I can not move the label to even select it. Do people know what I am talking about? Also that tab changes the width of the layout and it is confusing. I want to set it to default stay in one place which is on the left. If you need I can provide picture of it. What is it called and where can I read about it in help and how can I set it stay on the left please. I thought it was called tab control but that is not it either.
-
-
- 6 replies
- 1.7k views
-
-
Hello forum! I have an issue I'm trying to solve. I know why it doesn't work, I just don't understand how to make it work. I have a button, 'Show All', which basically performs a show all records. I want to hide/show this button (FM ADV12) on a layout depending on the obvious condition-hide when all records showing, show when not all records showing. The layout is based on products with a self join portal (Products_Self). The portal is filtered for basic type ahead. When I type into the search box, the portal filters. As the portal records are filtered, I want the 'Show All' button to appear. The expression being used for conditional formatting…
-
-
- 8 replies
- 3.2k views
-
-
I'm trying to setup users of RTL (Right-To-Left) alphabets such as Hebrew and Arabic to use a database the same way as current users. Current users are worldwide, using Roman, Russian, Turkish, Chinese, Japanese, Korean alphabets, and more. All those alphabets are LTR (Left-To-Right) reading and they all display and perform properly using the Arial Unicode font. In our preliminary testing which involved importing of Hebrew translations, this was our feedback: The translation file is correctly set-up and translated – Israeli team confirmed. However when imported into the database it’s incorrectly shown (mix hebrew and english words) It gets even wor…
-
- 6 replies
- 1.5k views
-
-
i have a portal filed that has two conditions. if value is >10 calculated percent difference is old value +/- 10% returns green if value is <10 calculated percent difference is old value +/- 1 returns green if outside range returns red. i have tried case conditions and the formatting works for the <10 condition only. thank you all in advance
-
- 1 reply
- 1.7k views
-
-
In my List Layout, I have quite a few records all sorted by a date field on the left from december - October. When I enter the layout, I'm trying to have filemaker Go To Portal Row via (Get (currentdate) or Month (get (currentdate) so that when we're in the month of November the portal rows thats selected are november dates. Thanks
-
-
- 7 replies
- 1.4k views
-
-
Any suggestions to if it is possible to scrape data from javascript variables using the web viewer? What I am trying to is to pick up the longitude and latitude from this page: http://130.225.211.158/utmkort/koordinatfinder.htm You see, when the map is clicked, the values are stored in javascript variables - but how can I "read" these from within the web viewer to pick the up and put them inside two filemaker fields?
-
- 9 replies
- 5.9k views
-
-
I know that I can simply create a script that takes the user to the targeted object in a popover, then assign the script to a standard button. But this requires two buttons, a standard button and the popover button. How can I trigger the script from the popover button?
-
-
- 7 replies
- 5.8k views
-
-
I have a layout in my database thats basically a table of all of our records. Multiple users view this table then select a record to go into the actual record itself to work on it. The problem I'm having is when someone else is viewing this table and i enter the same table layout I get the (User is modifying this record) is there a setting I'm missing or anyone have thoughts on why this is happening? Thanks Matt
-
- 1 reply
- 1.3k views
-
-
I've spent most of the day trying to figure this out so I'm asking for help. I'm trying to make a home budget solution. I've got multiple categories (e.g., food, gas, electricity, etc.) I've got it set up so that when I want to add a record, it's linked to a separate table to enter that subject's date and total spent. Those two fields show up in that category's layout in a Portal from the Payment table. So far so good. What I'm also trying to do is to have a running total of how much has been spent in each category. What I'm getting is the total in all categories. Again, what I'd like is that as you move from the food window you see each individual expense (seen…
-
- 0 replies
- 849 views
-
-
Hi, I am now setting up a inventory database, I encounter one problem.. some of the products I have to record with long description and some items simply with a few words as description.. This is easy to handle in the per record browse mode, I can simply make a large description field that can hold up more words.. Now I need to to have all these item to be put in the portal as one item one single row, for items with long descriptions, the row is not long/large enough to show all the description information, if I make the row size larger then I will have too much unused space for those item with a few words description.. Please let me know what is the sugge…
-
- 3 replies
- 1.6k views
-
-
I'm trying to set one of my custom menus' label to be the Account Name, however I want this to appear in Uppercase, or possibly even title case if I decide. I've tried using TextStyleAdd ( get ( accountname ) ; Uppercase ) however it doesn't do anything, leading me to believe custom menus can't have styles added to them, which I suppose makes sense. I've also tried creating a new global field and applying the style to that field and using that field as the title override for the menu - nada. Any ideas on making this work?
-
-
- 5 replies
- 4.8k views
-
-
I have a table named "city" I have many records and record more everyday. I have done value list with checkbox set. I can find with multiple checkbox. I did it in my project. I can select one by one in find mode but I can't select all by one button. I need just select all in find mode one button. Checkbox.zip
-
-
- 7 replies
- 1.8k views
-
-
Hello, I continue developing the POS and so far I have almost got everything to work as desired. However, there is still a functionality I will like to add. Right now I have a portal on the left which shows all the products pictures in grid, and when I click on the picture the script trigger adds the related item to the line_item table on the invoice. So far the script looks like this: Allow User Abort [ Off ] #--------------Set Variable Product ID Set Variable [ $PRD_ID ; Value PRODUCTS::ID_Product ] #--------------Add new item to portal Go to Field [ LINE_ITEM||id_invoice|::Product ] Go to Portal Row [ Last ] Set Field [ LINE_ITEM||id_invoice|::id_product ; $PR…
-
-
- 33 replies
- 5.4k views
-
-
Hi all.. Can a portal be filtered to a certain number of records it can display.. For example, I have a portal that shows my contacts (100).. I want to filter the portal to show only max of 10.. I have tried removing the scroll bar and limiting portal records to 10 via the portal settings, but I still have the feeling that filemaker actually served all 100 records just that I am being able to see 10.. Reason for my question : I have read that to enhance performance issues and fast loading of data especially via 3G networks, it is advisable to limit the records been served.. Such that only needed ones are served to the user... I don't know if I h…
-
-
- 3 replies
- 4k views
-
-
Hello , i have a invoice solution and i want to prevent duplicate the items products on the same invoice portal. for example if i have a product called " 2525 " and then im trying to add the same "2525" shows me a custom dialog to stop . i use global fields with a button script to add items to the portal . please let me know how to resolve this, I've been trying many ways with no luck thank you
-
- 2 replies
- 2.4k views
-
-
Hi, New to the forum but have been using with FM13 & 14 for past 12 months to produce a Recipe Database based on an earlier Template EOS posted (attached). Tried a number of different fixes but the following have me stopped - any advice would be appreciated. The main things that have me stumped (and have spent too much time trying to solve) - see attached my modified file of script that adds a selected ingredient from a selection portal to another recipe portal - to allow entry of a quantity. (The script is a modified EOS original - post IngredientsAndSuppliers_eos ORIGINAL.fmp12): For a recipe I need to add the same ingredients more than once -…
-
- 0 replies
- 1.3k views
-
-
Greetings FileMakers! Is it possible to have a Body part as well as a Portal within that body part both resize, dynamically, based upon the number of records within that portal, within certain pre-defined bounds? For example: I have a table of Foods (in database speak, not in the literal sense). The Foods table has a child table called Ingredients. We show the Ingredients via a portal on the Foods layout. The Foods layout is Browsed in List View. The Body part is, say, 150 pixels tall. Within that, we stuff a little 140-pixel-tall portal showing a few rows. We could define, say, 4 rows. But that would be boring. Not all Food have 4 ingredients. Some might h…
-
- 7 replies
- 4.8k views
-
-
Hi Guys, I have a web viewer which is simply a clock. I have looked over the forum for the solution but can not seem to get my head around where to retrieve what I want which is - the current time sent to a variable.From what i can gather - you have to use a left, middle etc in a calc to return the value ( or thats what i am assuming) my issue is where and how?. Here is the detail inside my webViewer: "data:text/html, <html> <head> <script language='javascript' type='text/javascript'> function displayClock() { var digital = new Date(); var hours = digital.getHours(); var minutes = digital.getMinutes(); …
-
-
- 7 replies
- 1.4k views
-
-
This post is simply to make others aware of a usage of placeholder text that I haven't seen mentioned before. We have situation where, when opening a popover to create a new record, the new record isn't created until the User enters data. However, there are a few auto-enter fields which are defaults and they do not display. This is confusing to Users since, from their perspective, that data should already be there - they don't fill it in unless they want to change the value.! I always keep a field (global) called PLACEHOLDER. It is set to auto-enter ( replace ) with: If ( not IsEmpty ( Self ) ; "" ) and I use it for displaying calculation results on layouts when…
-
-
- 13 replies
- 2.1k views
-
-
hi Please can anybody help me , i want to aviod going to the next record by mouse scroll , how do i stop that
-
- 2 replies
- 951 views
-
-
I've got a Subsummary layout. The layout is based upon the table, lets call it "Materials". The subsummary part is sorted-by the field "Type". Type can have say, one of three possible values in it: Glass, Paper, Plastic. When we sort this layout, we get subsummaries by the types, Glass, Paper, and Plastic, as expected. There's a script that performs some Finds, based on user-entered criteria, to narrow down that list. What I need to do now is have a script gather the IDs of only the records under, say, Paper. And only Paper. Suppose three records are showing under Paper, I want those three records' IDs in some form or another. So far I've only been able to have it ga…
-
-
- 4 replies
- 1.5k views
-
-
We are developing a contract layout for a client. There is a modestly long header (260 its.), short body (26pts), but a very long footer that is one large text box detailing terms and conditions. Its boiler plate but they need it there. Since it is one large block it won't print on the first page. Instead in preview mode the bottom half of the page, below the body, is blank and the boiler plate starts on a second page. Is there a way to have this last large text block start on the first page and spill over onto a second page? How can I get this to format correctly as one cohesive document?
-
- 3 replies
- 1.4k views
-
-
I have a working database that uses a Double Booking system provided by the FMForums commenters (attached). My problem is that I need a way to quickly select multiple rooms and apply them to 1 conference. My goal is to use a one click method on either a button or field to add the room to the list. I also need a visual way to determine if a room is booked or not. I have already experimented with conditional formatting and buttons but this seems to not be the best way to make this work. It would also be nice if the item clicked to assign and the conditional formatting were one item. I already have the system functional using this example but I cannot seem to figure out…
-
- 6 replies
- 1.8k views
-
-
I have a table showing the following 3 fields StartDate, EndDate and Location I would like to show a portal with a line for everyday from StartDate to EndDate. with a field Name (Without creating a child record) A child record would be created if an entry was added to the field name Any help would be much appreciated.
-
- 2 replies
- 1k views
-
-
I have been creating a sports card database. I think I've got all the bugs out of the main database and the feeder tables. Now I'm on to working on getting the finial reports/tables from an idea to a working filemaker table. So, this is what I have in mind. I want a table that at the top, I have Manufacture, Brand, Year, Card #, and Sport. This table would pull from the other tables to get info. Those areas are easy to configure, but I want to be able to see what cards I'm missing in a set and what I have for complete sets. As you see from the screenshot, it has check boxes by each card number. I was thinking of mirroring this, but I am having a hard time on thinking of h…
-
- 16 replies
- 2.3k views
-
-
I would like to have the font size of a text field grow or shrink, based upon the number of characters or overall length of text, in order to "always completely fill" a text field to its boundaries. We've seen this happen here-and-there in OSX. I have one idea on how to accomplish it, but it seems "clunky". I am wondering if there's a better way. My idea: use Conditional Formatting to change font size, based on Length(Self). I'd need many, many of those "steps", say, 30 of them, if I wanted to account for every possible font size between 12 point and 42 point, for example. That seems tedious to set up, and not truly "dynamic". Is there a better way?
-
-
- 8 replies
- 6.2k views
-
-
We have a table of Suppliers. We also have a table of Tasks. When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory. i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable. However there are some Suppliers that work across ALL territories. I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories. Ideas?
-
- 2 replies
- 1.8k views
-
-
I'm trying to incorporate a Set Time and Get Time component to my webviewer, which currently plays video. I want to be able to jump to certain times in the video, based on what we enter. So if a certain dialog starts at 3:04, we can click on that story and the video will skip ahead. Can't seem to get any form of script to work within the web viewer, but this is what I'm going for: http://www.w3schools.com/tags/tryit.asp?filename=tryhtml5_av_prop_currenttime though a more advanced and ideal set-up would be this: https://www.developphp.com/video/JavaScript/Video-Player-Custom-Controls-Programming-Tutorial I'm having no luck with either. Any advice?
-
- 0 replies
- 1.2k views
-
-
I have a customer database and with a customer table and a service call table. I am looking to create a report that would summarize total payment received in each month and a total for any given year with a grand total of every year. Not sure how to set up the layout part for the Year and Month so that they will produce the desired result. Thank you for any assistance. Greg
-
-
- 5 replies
- 3.9k views
-
-
Using FMP 14. Have a file called Donations that tracks gifts from donors. How do I set up a portal that will show all gifts to date for eg: donor 1043. There is one other table in this file called Donor Info.
-
- 1 reply
- 916 views
-
-
Not sure if this is a bug or a feature. Has anyone else noticed this? When editing a Value List, specifically, entering carriage returns, then copying the whole list to a text editor BEFORE saving changes to the VL, a text editor reveals a high-ascii character in place of the newly-entered carriage return(s). Only after saving the Value list, does this char "convert" to a carriage return. Curious feature.
-
-
- 17 replies
- 1.7k views
-
-
We have a database that's been upgraded from FM9 through FM14. It works great, except for today one of our users (on Windows) said that she was seeing gibberish on the Tab control. We looked at it on Mac and did not see the gibberish, but did see that the fonts were not being rendered properly (e.g. we have 3 Tab panels on the Tab control, and all are set to Trebuchet MS 12, yet one shows as Trebuchet MS 12, but the second and third are showing up as Arial or maybe Helvetica. It's a subtle difference and we didn't notice until now). Weird. Opened it up in Layout mode, and tried to change the font, and things got weirder: I could change the font to something else …
-
- 1 reply
- 1.9k views
-
-
I am building a digital asset manager in FM 13 for Windows. I am having problems displaying filtered data in a portal. I have series of scripts that bulk imports the file names & folder structure and creates a collapsible hierarchical keyword structure that is comparable to the folder structure. It creates all the joins between keywords and assets. Example: C:\Automobiles\Cars\Fiat\Model1.pdf results in C: ---Automobiles -----Cars ---------Fiat When "Fiat" is clicked, all assets associated with this path are shown in a second "Asset" portal using the filter: not IsEmpty ( FilterValues ( Data for Keywords::ID ; global::gCurrent Keyword ) ) This portion works f…
-
-
- 4 replies
- 1.4k views
-
-
Hello everyone, I have two questions:1/ How to display all records of a TO after a filter; 2/ How to update the field “Number of sanctions” according to the filter dates. Thank you
-
-
- 2 replies
- 3.4k views
-
-
I'm using Filemaker to keep inventory of personal digital video including many on youtube. I store urls to youtube videos and launch them within FM's Web Viewer. When I advance from one FM record to another, the new url launches the different youtube video, however the audio from the previous record continues. Is this a bug? or should I be using a "clear" or "stop" command in a script that I'm not aware of.
-
- 0 replies
- 1.2k views
-
-
I'm using Filemaker 11. I have a table called Computers with fields:UID, Computer Name (MacBook0001, MacBookAir00002 ect.) this is a parent of the Hard Drives table which lists Hard Drive size and Hard drive type (SSD, or SATA) along with UID. I have a portal on the Computer layout which lists Hard Drive size and type that were assigned to the computer on the Hard Drive layout. I have setup basic report just listing the Computer name. I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD. test.fp7
-
-
- 4 replies
- 2.3k views
-
-
On a simple invoice DB I built, while adding line items, how can I automatically increase the quantity of the product for products that have already been added.. Rather than having duplicate items occupy the invoice... Items are added via script... Thanks
-
-
- 2 replies
- 1.3k views
-
-
Hi I have in my model two fields having the same formatting (police, size, color) (Mode models) BUT in use mode, the two fields don't take the same format. (see in attachment) Thanks LG
-
-
- 2 replies
- 1.4k views
-
-
Hello I have a layout called "follow up" its a reminder for jobs wether COMPLETED or require FOLLOW UP. I have a Name sort script on the layout already via a dropdown and when i select a NAME that persons records only are shown. This works fine. I have a HOME (First Layout show data from Company Dashboard) Layout that opens upon login . On here i wanted to add a portal to FOLLOW UP and the portal to filter automatically the current username records only . I could then sort them by FOLLOW UP at the top and Completed below Whats bugging me is i just cant figure it out, Thanks for any help
-
- 5 replies
- 1.1k views
-
-
Over the years—and particularly for FM14—has anyone come up with a user-convenient way to toggle spellcheck on/off for a particular entry field? Spellcheck is so simplistic in Filemaker that it flags partial words that are being typed ... plus all urls ... and occasional supporting references like "libeay32.dll". Ideally, there would be a toggle button somewhere on the GUI. But how can you achieve that effect? Thanks in advance for any suggestions.
-
- 7 replies
- 2k views
-
-
I'm probably missing something obvious.... If I open the attached file in a webviewer, it works as expected. "file:/" & Get(DesktopPath) & "testpopup.html" However, if I copy the code from that file and paste it into a field codeHTML and then use the following webviewer calculation "data:text/html," & codeHTML, then the popups don't work. I'm on Filemaker Pro Advanced 13.0v3 on Mac OS X 10.10.5 The code will be changing dynamically so I'd rather not have to be exporting a temp file every time in order for popups to work. Any ideas? [p.s. the code allows you to create popups using CSS only, no Javascript. credit goes to Prakash Nakrani: http://www.seven…
-
- 0 replies
- 1.6k views
-
-
FileMaker crashes when I choose field picker for a specific table which happens to have a large number of fields: 226. I don't know if that's the issue, but Flied Picker doesn't seem to crash for other random tables I tried. I'm using the latest version of FM 13 (.0v9). I checked the consistency of the file: no apparent problem. Is this a known issue?
-
- 0 replies
- 1.2k views
-
-
I have a basic form with edit boxes. Some can be edited in browse mode and others can't. I've noticed when I click on the form, the edit boxes which are editable are highlighted with a bunch of tiny dots around the field borders. Is there a setting that controls whether these dots display or not? Thank you!
-
- 1 reply
- 874 views
-
-
Filemaker 13 Pro Advanced. Mac Yosemite. I'm pulling my hair out - maybe somebody can offer a suggestion before there is no more hair left. I can't for the life of me figure out how to script a click in a web page or a web viewer. I have tried all of the following: • Opening a web page outside of FM (in Safari) and trying to click in that window via: - AppleScript from w/i FM (get an Assistive Access error, even though I've allowed FM in Privacy & Security settings - Opening an Automator-created application via Send Event (can't choose the application) • Opening the same page in a Web Viewer and trying to click via the same methods above. Same problems. …
-
- 0 replies
- 1.3k views
-
-
FM 12. When I create new fields the text name is always right aliged. Is there a way I can have it default to left align?
-
- 2 replies
- 964 views
-
-
Hi, I think what I'm trying to do is similar to the post here : http://fmforums.com/topic/43137-creating-html-templates-using-data-fields/#comment-201362 but expanding the idea quite a bit. I'm adding products to ecommerce site Volusion. Eventually, I'm moving the site to the Magento platform. I've been using Excel and the concatenate function, however, I'm seeing the time saving benefits of using FM12Pro but hung up on adding fields that contain html tags and populating them with attributes. I've attached a text file that more fully explains. Thank you for your assistance. We lost a member of our team and We're just trying to get all the work done. I'm also attaching,…
-
- 6 replies
- 1.6k views
-
-
I have 20 fields that can either be "Yes", "No", Maybe, empty". Each field is controlled by a pop-over button with those 4 choices. When a choice is made, I want the pop-over button to be a color associated with the value (Yes, No, Maybe, or Empty(no fill/color). I am looking if these is a more elegant way to setup my scenario, other than setting up 60 conditional formatting rules. Does anyone have a good way to do this? Thanks!
-
-
- 6 replies
- 2k views
-
-
I am very much a novice with FM so any assistance is greatly appreciated. I am using FM 13 to develop a local digital asset manager. I have one portal with a list of keywords connected to a list of assets via a join table. When a keyword (button) is selected, the related ASSETS are displayed in a second portal. On a basic level, this setup works correctly. However, I am trying to expand the ASSETS that are displayed. Currently, the ASSET portal is filtered using: global::gCurrent Keyword = Data for Keywords::ID Given this example 1 doc1.pdf 1 doc2.pdf 2 doc3.pdf 2 doc4.pdf If I enter "1" or "2" in global::gCurrent Keyword, then the expected records are displa…
-
- 2 replies
- 1.6k views
-
-
Hi I am a novice at filemaker pro. I am trying to get it to show what report version it is in the header of a report. I have tried several solutions and none seem to work. I want to have a separate layout table where I can put what report version it is what script it is working off and what schedule it is working off. I have put in the information in the report layout 2 layout and when i want it to show up in the all units report. But when I click on the all units report within the scene details layout it doesn't show up the report version it is just blank. Can anyone help guide me to what I need to do to ahceive this and what I have done wrong. Please remember I am a n…
-
-
- 4 replies
- 1k views
-
-
I am trying to make a list that is select-able and the values are base on another field. I have tried the following but for some reason the values are all or none. If(at_client_sn=814; List(at_department; "ALBANY MEDICAL CLINIC"; "ALBANY SURGICAL ASSOC"; "ALBANY SURGICAL CENTER"; "ELM ST. PROFESSIONAL"; "EYECARE ASSOC"; "GEARY ST. CLINIC"; "INTERCOMMUNITY HEALTH"; "LEBANON COMM. HOSPITAL"; "LEBANON IMAGING DEPT."; "LEBANON SURGICAL ASSOC."; "MAIN ST. CLINIC"; "N. LINCOLN MEDICAL PLAZA"; "PHYSICIANS REF. NETWORK"; "REBOUND PHYSICAL THERAPY"; "SAMARITAN ADMITTING"; "SAMARITAN ENDOCRINOLOGY"; "SAMARITAN HEMATOLOGY"; "SAMARITAN INTERNAL"; "SAMARITAN NEURO SURGERY"; "SAMARIT…
-
- 11 replies
- 1.7k views
-
-
Hi there I have a use case where it's necessary for FM to run a script which updates records - the script takes around 10 seconds to complete. I want to run this on an occasion when a user edits or adds to a portal set of records. I could just use a script trigger, but as I say, this would fire the user into a 10 second update quite frequently and get annoying very quickly. Instead, I want to run the script just once and update all records which are changed in one go. In order to do this, the user will click a button labelled 'Commit Changes' and it's this I want to draw their attention to. When the user edits or adds a record, I want a flashing box to appear around …
-
- 5 replies
- 1.6k views
-
-
Hey there, I'm sure others have come across this issue and I've even done some extensive research prior to asking for help. I have an employee database set up and I'm attempting to set up a scheduling module. I'm no stranger to conditional value lists, but this has me stumped. In my parent table I have my employee details (including job types and classifications). In my child table I have all the necessary scheduling info. I currently have a conditional value list that allows me to pick employees based on job type and classification. Since employees can be booked on various jobs at different sites, I need to add a date filter to keep folks already booked that day…
-
- 0 replies
- 865 views
-
-
Hey All, I'm taking a stab at some custom controls and came across this example here: http://scarpettagroup.com/using-jquery-ui-filemaker-part-2/ I'm using this slider: http://jqueryui.com/slider/#steps It seems simple, but it's not rendering in my webviewer other than the title: "Donation amount ($50 increments):" Thanks!
-
- 0 replies
- 1.9k views
-
-
I'm trying to duplicate a record displayed in a tab control. The script has two steps: Duplicate Record/Request and Go to Field. The duplicate is created ok, but the Go to field step switches panes making the default tab the top most. Without the Go to field step the switch stays on the pane. What gives?
-
-
- 2 replies
- 3.7k views
-
-
Hello, I am trying to learn FM and at the same time build myself an ebook library tool that will scrape Amazon.com to pull data like title, author, rating, etc. -- based on the user (me!) submitting a book product ID -- which Amazon calls an "ASIN." I have searched online for a similar solution or template, but have only found bits and pieces of a solution so I am trying to build one myself -- and hopefully learn FM in the process. Here's what I have been able to accomplish so far. Don't laugh... 1) Create a field into which a user can enter an Amazon ASIN (like "B00FYW9VHC") 2) Use that data to generate an Amazon image URL (like ' alt='' class='ipsImage'…
-
-
- 10 replies
- 6.6k views
-
-
Hi, I was here a while back learning how to build a horse racing form. Thanks to those that helped, I've been producing a form for several months now. However, I never did figure out how to make the track averages and have FM calculate my speed figures. I'd like to give it another shot, as it will save me a tremendous amount of time. Right now I am doing all the dirty work in excel and importing the track averages and speed figures into FM -- so I'm using FM as a desktop layout program, which I suppose sounds crazy. I can get FM to produce averages in a summary report, but I need separate summaries to get my speed ratings (I think). I'll try and attach a photo of a moc…
-
- 13 replies
- 2.1k views
-
-
Hello Gurus, I have a tables which I called Dashboard Table; Materials Table and I have a related table Which I called Expiring Next Month & Retest Next Month. I want to save all my Expiring Materials for the Next Month and Retest Materials for the Next Month in one Excel sheet. Please find attached file that Im working. Thank you so much. Warehouse Management.fp7
-
- 9 replies
- 1.6k views
-
-
I'm trying to hide a certain field when the table is Sorted by - field Is this at all possible?
-
- 5 replies
- 2.6k views
-
-
Hi All, I Have 4 tables 1. Button Menus Field Names Type Comments Button_Name Text Button_Highlight Calculation Unstored,=If( Dashboard::MenuKey = Button_Name; Globals::Menu_Graphics[1] ) Button_Display Calculation Unstored,=If( Dashboard::MenuKey = Button_Name; TextStyleAdd ( Button_Name ; Bold ); Button_Name ) 2. Dashboard Field Names Type Comments ButtonKey Text Global Username Text Global 3. Warehouse Field Names Type Comments constant Calculation 1 MATERIALS ID MATCH FIELD Text Indexed, Auto Enter-serial ; Cant Modify Material Receiving Number Number Auto Enter-serial Material Name Text Indexed Material Lot…
-
- 4 replies
- 1.5k views
-
-
I've got a simple relationship. Customer->Order via customerID as a foreign key in Order table. Typical operation, I want to jump to the record that I click on from the portal row. When I put a simple button with a script step Go To Related Record on the portal row it works properly. When I create a script with GTRR and some other steps in there attached to that same button, it always brings me to the wrong record. I've even tried grabbing the OrderID from the portal row and performing a search, but it always grabs the wrong Order ID. I've experienced this before, but I can't remember what I did to fix it. Any ideas?
-
-
- 6 replies
- 4.2k views
-
-
Hi Guys, I've wrote some javascript which works fine in internet explorer. When I run the script from my hosted server from the web viewer it fails. Does anyone know of any methods/ways I can use to capture whats happening in the console. The Mac version allows you to inspect the element and write to a log, however I'm really stuck with debugging the Windows version Thanks Jalz
-
- 0 replies
- 1.3k views
-
-
I have a portal showing items, i want to have a column that displays serial number for each item, serial number has to start from 1,2,3,etc. i want the serial number to adjust accordingly when the user deletes any item, i.e. if user deletes item no. 3 i want all the items to shift up and fill the space left by number 3. How do i achieve this.? Am using filemaker pro 13.
-
-
- 2 replies
- 2.1k views
-
-
Hi all I have a web viewer in a FMP database layout. All is functioning fine in the web viewer. Inside the web viewer I have a variable which is just a string of text. I can get this variable to print on screen in the web viewer so I am sure it is performing properly. However, I would like to now take this variable and its value and pass it back to FMP for use in a search script. I have fiddled around with the FMP URL, but I can not make it work. Currently, the variable name is "msg" and the url I am attempting to use looks like this: <a href="FMP://$/MyFMPdatabase/script=isolatesearch¶m=msg&value=$msg"> The error it throws is this: "The file M…
-
-
- 8 replies
- 5k views
-
-
I am new to Filemaker and developing a document manager in FM13. I have spent a lot of time trying to search this forum and others to find a solution but, probably due to my ignorance, I have not found (or just missed) anything that has been able to move me towards a viable working solution. I have a master list of keywords that I am using with the intent of simplifying navigation instead of using a bunch of cascading portals or drop downs. This approach seems to be the base of my issue. From the image, the portal on the left side is the keyword master list based on the demo by 1-More-Thing, which is populated using executeSQL. Initially, I tried to setup value lists to …
-
- 0 replies
- 1.5k views
-
-
I currently have a web viewer that contains a google map. On this map I can draw a rectangle to select an area of the map. I collect the the latitude and longitude of the southwest corner and northeast corner into java variables. I am able to print these java variables on the web viewer. They look like this in the web viewer and are formatted in such a way as to be ready for a search range in FMP: NE: 43.02144735023339...43.06470481674727SW: -76.24412939453123...-76.07445532226564 I would like to collect each of these variables and pass them back to a FileMaker scrip which will perform a find on two fields. Is there a way to grab these two Variables from the web vi…
-
- 3 replies
- 1.7k views
-
-
This should be easier, but I am having a small issue on how to limit records in Drop Down. Currently, I can not get File Maker from showing all my records within the Drop Down. Even when File Maker has a limited found set. See attached fmp12 file Help. Here are my records: If I click on my Pending script it creates a found set of just pending: But if you click on my DropDown you get all the records. I just want the pending records. How can I limit the Drop Down to represent only those records that I have in my found set? Thanks in advance, Chuck Help.fmp12
-
- 15 replies
- 4.3k views
-
-
I have a portal with X number of fields and a default eight lines within the portal. Based on the text entered into the second (or third, etc) field, I need the program to auto-populate several other fields with info from a previous record (within the same table) based on the entered text. In the above example, if I enter "Atlanta" into the "location 1" field, I want the text for "location 1 rep" and "location 1 phone" to auto enter based on the last record created that had a value of "Atlanta" (the text in the first field). Same thing with the "location 2" field which should enter the data into the contact and phone fields for location 2. Can this be done via import…
-
- 2 replies
- 1k views
-
-
Would anyone happen to know how to set the background color of a popup? I understand that it might be defined as part of the theme. But the theme my project was assigned during its FM11 to FM14 upgrade is Classic ... and I've read that Classic can't—or shouldn't be—changed. A picture of what I'm after is shown below ... and thanks for any help on this.
-
- 2 replies
- 1.5k views
-
-
I have a pop up menu with the following choices: Premium Taxes Fees Other When I click on Premium, I'm trying to create another pop-up menu that lists 1-4 aircraft that I can select. Is this at all possible or better served by creating a hidden popover window?
-
- 2 replies
- 1.1k views
-
-
GOAL: I would like to either click on a button within main portal and in doing so the Sub Portal FK activate those records that match the Portals PK. CURRENT PROBLEM: When I am within the Main Portal if I want to time-stamp PK record 6 I would have to manually type it into the FK. In addition, it would get confusing because it is showing TimeStamps from both of the Main Portals PK. HELP REQUESTING(Thanks in advance): I would like to write a script that when I click on a button within the Main Portal it only SHOWS those records within the sub portal that are related to that PK. EXAMPLE: Within Main Portal:{See Figure 1 below} I click on the red button. In doing so,…
-
- 4 replies
- 1.6k views
-
-
I am new to FMP so this maybe a pretty elementary question for some of you. What I want to do is have a dropdown list that is defined by certain options that I have pre-defined. In my example these would be Serial key, Credentials, keygen, or patch. If serial key is selected i want a text entry field to appear below or next to this dropdown list. if credentials is selected, I want to have a username and password text enter field to appear. If keygen or patch is selected i want to have a hyperlink entry field show up.
-
- 1 reply
- 1.4k views
-
-
Hello All, I have two tables: Materials Table and Label Table What I want to accomplish is when Click my Print Label Button but I want to see my Label Table in a Separate window. For Now I have a the following script: Freeze Window Go to Layout ["Labels"(Labels)] Show all Records Delete All Records [No Dialog] Loop New Record/Request Set Variable [X; Value (GetFondCount)] Set variable [$_Text; Value Material Description:".........] Set Field [Labels::Label; $_text] Set Variable[$_text; Value"Location: & $Location] Exit Loop if $X≥$_MatnContainers End Loop Enter Preview Mode [Pause] Print [Restore] Go to Layout [("Materials)] Enter Browse Mode …
-
- 6 replies
- 2.6k views
-
-
Hi, I am currently trialling Filemaker Pro 14 with the intention to create custom layouts for particular data sets. I am using the standard Product catalog and the Products layout. For example I would like to create a separate layout for specific Product Categories. I create a script but it returns all records, it does not filter the records based on the field value. I am probably running the script from the wrong place, as I run it as trigger 'onlayoutenter'. I attached a screenshot of the script. if anyone can help point a newbie in the right direction.
-
-
- 2 replies
- 973 views
-
-
I want to create a check box that has two main items, from which a user can select one or more from one of the main items, but cannot crossover and check from both main categories. I would prefer to keep a single field. For example main category: "Apples" possible check boxes' red, tart, small, fresh OR "Oranges" navel, blood, tart, large. They would be allowed to check one or more but cannot mix apples and oranges.
-
- 7 replies
- 1.3k views
-
-
I'm using FMP 11 on a Mac running Yosemite. I have a button that says "Editors" in my "Submissions" page, and a portal linking to my "Editors" database. However, it was showing that the "Editors" field was unrelated. After establishing a relationship between one field in my "Editors" database, the database was considered relevant, whereas before it would say that the "...target was part of an unrelated field." Now, it is telling me that "...this layout cannot display the result." No calculations are involved, it's all text with info about contracts and the editor's information/previous work. What information am I missing to help others identify the problem? What can be do…
-
- 5 replies
- 1.1k views
-
.thumb.jpg.293ece268c4e1896f21f27e4c88a57f0.jpg)
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online