FileMaker Interface Features
-
Hey, I work on filemaker's program, and I want to know what is anchor (ancre) and a mark (empreinte). I saw that in a tutorial, but I don't know that it is. Thank you for your help Sylvain I have Windows 8.1 and Filemaker 14
-
- 3 replies
- 1k views
-
-
. . . and out of the Portal altogether! I'm trying to set my Tab Order for a layout with a Portal on it that is used for record creation. If the user creates a record in the portal and Tabs out of the final field, the portal creates a record on the new row and puts the cursor there, ready for action. This is great if you have to enter many rows of data, but not so good if you want to enter just one and then move onto other fields on the layout. Even if the user clicks out of the portal (which is a bit of a nuisance in its own right) -- you wind up with a useless blank record in the related Table. So what's the best way to avoid this tabbing behavior? Sho…
-
- 23 replies
- 4.6k views
-
-
Hey guys, i have a question, i have more then 100 layouts and i wanted to know if there is a way to change the color to all layouts with just few clicks instead of going one by one? I need to change color to font and to to fields. thanks for any info.
-
-
- 4 replies
- 1.9k views
-
-
I have been requested to produce a report consisting of Employee Names, each with the single task assigned to them. I have a large DB table ALL_TASKS where each record is a unique TASK_NUMBER, and each record has an employee assigned to it (EMPLOYEE_NM) from a value list (unique values from the field EMPLOYEE_NM). There's also a lot of other summary data assigned to tasks, like time to complete, etc. (Tasks are added sequentially all the time throughout our work day). So far I created a new empty table for my report, REPORT_SUMMARY, where each record will be an employee name, with TASK_NUMBER and some other summarized time info alongside it. (TASK_DURATION) I want to c…
-
- 1 reply
- 1.1k views
-
-
Anyone achieved this? I want to add [a] line(s) to a portal and have it sub-total the lines above it. The portal has drag-n-drop functionality, so the calc needs to update if a related record is "dragged" above the sub-summary line. I found the following article, but I'm having a hard time following it because the author is using fields in relationship joins that he never explains. http://www.linearchat.co.uk/2011/05/sub-summarys-with-in-portals-pt-ii-may/
-
-
- 12 replies
- 6k views
-
-
Every once in a while I come up against an issue that reminds me how little I really know about Filemaker. Creating summary reports is often the issue. I think what I want to do is possible, but I'm stumped. We track violations by address. Every time a violation is found at an address, and new record is created. I would like to create a report that tells us how many times an address is cited once, twice, three times, etc. in a given time frame. I can pretty easily create the summary report that groups by address, and then tells me how many times that address is cited. I need to take it one further step. In a given year, we might have 2k violations. The vast majo…
-
- 2 replies
- 1.6k views
-
-
Hey Guys, Has anyone implemented a html WYSIWYG editor in FileMaker using javascript files stored inside of filemaker and not hosted on a server. I've implemented TinyMCE into the web viewer, however I'm hosting the tinyMCE files onto a server and then posting data to a PHP page which returns it back into FileMaker. I find this a little slow performance wise and I would rather try and get the fmp URL and post data directly back to FileMaker. Would be interested to hear thoughts, ideally need an editor where I can pick the database fields from a drop down. Ive looked at JQTE editor and thats too basic to use as you can't initialise fields to pick from.
-
- 2 replies
- 2.9k views
-
-
Hi Forum, don't know if this is the right place, but I'll give it a shot. I wonder if this is expected behavior, regarding windows/layouts found sets. I tried it manually after not being able to do this with scripting and it's not working. And of course watched it through the Script Debugger. I'll give the basics, and if someone requests more info I would be happy to oblige. I have a layout based on a Customers Table. I have a second layout, sub-summary report based on a related table-Interactions. From the customers table, I click a button, perform a script that opens and sorts the sub-summary report. I have a button on the report that omits records, changing the…
-
-
- 7 replies
- 1.3k views
-
-
I have several reports which I'd like the user to be able to select from a list and then have FM print overall upon one button press, rather than the current set up I have which is a button on each report which fires the relevant print script. To add a little layer of complexity to the process, the reports need a letter index added to them prior to printing. This is because, depending on the circumstances, in one instance Report XYZ could have an index position of say, 'D', but the next time, due to an additional report being required, Report XYZ would have the index position of 'E'. This index position needs to be visible on the report. The reason I'm posting is beca…
-
- 2 replies
- 1.4k views
-
-
Newbie question here - so please be kind In a record belonging to the table "company"I have a portal that shows related records from the table "tasks". The table "tasks" has a field called "subject" and this is being shown in the portal correctly. The table "tasks" also has a field called "id_user", but rather that just showing this (which is an integer), I would like to show the first name of the user. This information however is not stored in tasks, but in a table called "users". I have found two solutions (I like the latter better), but was curious to what is the common approach. Solution 1: Create a relationship between the table "tasks" and the table "users". …
-
- 5 replies
- 1.1k views
-
-
I’m on Windows 7 w/ FMP Pro 13. My issue: the text in my checkbox fields is randomly being truncated whenever I print (directly to a printer or to PDF). See attached image; highlights are areas where text is cut off. There does not appear to be a pattern. I had temporarily solved the problem when I turned all checkbox text from Arial to Tahoma, but the problem came back (even though all checkbox text is still Tahoma). Thoughts?
-
- 0 replies
- 1.8k views
-
-
I am filtering a portal where one method works and other other does not. WORKS Case ( IsEmpty ( table::globalTextField ) ; db_payment::id > 0 ; PatternCount ( table::globalTextField ; "/" ) > 1 ; db_payment::date = GetAsDate ( table::globalTextField ) ; db_payment::invoice = table::globalTextField or PatternCount ( db_payment::reference ; table::globalTextField ) > 0 ) DOES NOT WORK line 1 and 2 of case work but not line 3 Let ( [ txt = GetAsText ( table::globalTextField ) ; num = GetAsNumber ( table::globalTextField ) ; dte = GetAsDate ( txt ) ; dt = PatternCount ( txt ; "/" ) > 1 ] ; Case ( IsEmpty ( txt ) ; db_payment…
-
- 3 replies
- 2.2k views
-
-
I am using the web viewer to listen to .wav files. This works great 90% of the time. My inconsistency problem comes from URL encoding I believe. Actual file name: -CCSKD#W01568613.WAV I can navigate to this working url in safari: http://1.1.1.1/folder/-CCSKD%23W01568613.WAV This is the url I am setting the web viewer to: http://1.1.1.1/folder/-CCSKD%23W01568613.WAV This is what GetLayoutObjectAttribute ( "player" ; "source" ) shows: http://1.1.1.1/folder/-CCSKD%2523W01568613.WAV I know that a pound sign (#) is encoded only if a number character (0 through 9) follows it. This is the calc used to set the web viewer. Part of it ta…
-
- 13 replies
- 4.6k views
-
-
I am parsing a webpage to extract information for my database. It works great on my iMac, but on iPad it doesn't work. I have included a file with an example. I would like the "Copy/Paste" solution, as the "GetLayoutObjectAttribute" does not give me the info, just the http that hasn't run yet. Any help would be great. Thanks, Fed WebviewerGO.fmp12
-
- 7 replies
- 1.6k views
-
-
I was wondering if it was possible to have the Body of a layout invisible. I would like to have a toggle to have it visible and not visible. Do I have to make 2 layouts? Or can I have a toggle that will make if invisible (even if sorting is needed to do that, like with leading summaries). Thanks you in advance, Fed
-
-
- 2 replies
- 1.1k views
-
-
If one sets up a field to validate as 'member of value list' AND If that value list is custom and it includes a dash separator THEN ... typing a dash in the field will PASS validation. It seems that FileMaker gave a single hyphen a special role as separator but forgot to handle it from validation context. Please see attached file. Clear the drop-down on text1 and type a dash in it. I envision some User wanting to select 3.75 (the line between two values) and can't so they type dash in the field. It's the only character outside of legitimate values that is accepted. I went back and checked version 11 and same behavior so this has been here for a long time. Part of…
-
-
- 9 replies
- 2.7k views
-
-
Running Filemaker Pro 13 on Mac OS X 10.10.5 I found some earlier posts on this issue, and many suggest to open the file in Safari and copy the location URL, but that isn't working for me. I keep getting "The requested URL was not found on this server." error in the Web Viewer field. Seems like this should be a fairly straightforward use case right? Alternatively, if someone knows how to allow an image to scale to fit horizontally in a container to allow for vertical scrolling, that's what I'm trying to do with the web viewer. Thanks, Ryan
-
-
- 4 replies
- 2.5k views
-
-
Good morning, I have a table with Jobs and each job is related to a specific year. I would like to have a Drop down list in my Jobs layout that would filter all the jobs for the specfic year. I have tried to use Value lists and read the year data from a table. Both options and due to the fact that I have to select a Jobs table related field to use the Dropdown invalidates my attempts. I would like to have a dropdown list that does not store anything and it just serves as a trigger to filter data. Is this possible? If so, how? Thank you for your time in advance. Nuno Neto
-
- 9 replies
- 2.9k views
-
-
I have a need for a value list that updates when I update the master list of values in another related table but does not globally update all records where the list is used. For example, I have "customer" table with radio buttons of various subscription rates that are populated by a value list in another table of "subscription rates". What I'm trying to do is when I update the table of subscription rates it will NOT affect individual customer table records and update them. It only affects new customer records created and rates from when the "subscription rates" table is updated. So every previous record before the subscription rates table is updated to new rates will re…
-
- 1 reply
- 1k views
-
-
I have a new table named CourseList - a self join table using courseID. Within a layout, I have a portal which is filtered and sorted based on dropdown menus and checkboxes. For example, I can see which courses are assigned to a particular budget for a particular quarter (e.g., in fall 2015, I have (7) courses for budget A, which are taught by (3) instructors). I have also created a duplicate single-row portal to get the record count (or # courses for that qtr). How can I get unique counts for number of teachers from the filtered portal data. For example Smith teaches (4) classes, Jones teaches (2) classes and Wilson teaches (1) class - I need to get a count of (3).
-
- 5 replies
- 2.8k views
-
-
I was wondering how to change the colors of tab panels. For example the onyx theme, the tab panel content area has a different color than the tab panel title headers. The active panel's content area is a dark gray while the title part has a black background color with light gray text. I can see how to change the text color and the fill color for the content area, but not the background color of the title area of each tab. Can anyone point me in the correct direction in the inspector pan under appearances? Filemaker 14 adv
-
-
- 2 replies
- 4.9k views
-
-
I'd like to create a layout where i would have a list of buttons on the left side to show various informations of the DB (scripts that find and sort records). and i would like to have those records as a list on the right side. I know i could do this with buttons within the header of the layout, but i would like it much better if i could split the screen left/right instead of up/down. Is it possible? Thanks
-
- 6 replies
- 1.4k views
-
-
Hi FileMaker Advanced 11 question. I have two separate conditional value lists in one layout showing Provinces, Districts and PostalOffices. One shows the provinces in one country and is linked: Table1::OrginalProvince = Provinces::Province. The Province table has following attributes: ID, Province, District and PostOffice Then I have another conditional value list showing the Districts (with related values only) And finally I have conditional value list showing the PostalOffices (with related values only). This works ok. I used this method: http://www.teamdf.com/weetbicks/24/conditional-value-lists-pt-1-what-are-they-how-to-build-them My problem is that I want t…
-
- 0 replies
- 1.6k views
-
-
I am not sure where to put this question, but I figured it was closest to Web Viewer in nature. I am using the 'insert from URL' script step in order to get information from yahoo stock prices. It works just great on wifi on FM Go, but on Mobile (iPhone) it does not work any longer. I get the error 'Connection Failed'. The funny thing is that if I put my iPhone on tether (personal hospot), and use my iPad or another iPhone and connect to the tethered phone via the iPhone's wifi hotspot, it works just fine. Confusing, I know, but I hope I got the idea across. Any ideas?
-
- 6 replies
- 1.4k views
-
-
I have my main database layout which is a form that displays all the customers information. I'm trying to make a popover button that displays a search (quickfind) field with a table below the quickfind but within the popover button. When I type into the quickfind field and hit enter I'd like the portal within the popover to display all found records as a list. The problem i'm having is when I enter information into the quickfind and hit enter, it searches the main database (instead of the table within the popover) How do I get quickfind to search the correct table?
-
- 2 replies
- 1k views
-
-
Hi there I need to put together a sub summary report from a list of data which includes several 'grand summaries'. The basic report layout would be something like this, where each record has a sorting field present to identify it as either 'Group 1', 'Group 2' etc... I'm struggling because, in order to get the Group 1 and Group 2 Summary for example, I need a further layout part against which to hold the calculation - or do I ? That's the question I'm stuck at and seeing as the same sort of thing occurs further down the page, the report is a non starter at the moment. So what I need to do is add together previously summarised results of specific groups and have the…
-
- 1 reply
- 1.3k views
-
-
I'm looking to see if there's a better way to do what I'm currently doing, which is effectively making cross tab tables from a single column of data. My main data table columns are (in a very simplistic format for digestion here): Date Amount TrueFalse1 TrueFalse2 TrueFalse3 There are around 70,000 records, each with entries in every field above. Records tend to be grouped into months and I need to get columns per month on a report. To do this, I use CASE statements initially and then summarise the results: JanTotal::Case ( TrueFalse1 = "True" and TrueFalse2 = "False" and Date = "Jan" ; Amount) FebTotal::Case ( TrueFalse1 = "True" and TrueFalse2…
-
- 1 reply
- 1.3k views
-
-
HI folks, I have the following Portal Filter set up: ExamPaper 3::Skills = AcademicExam::gFilterPaperMarks This works fine, just showing the exam papers examining the relevant skills. However, I'd like to be able to show more than one skill at a time. If I change the global to a checkbox I can select more than one skill to view, but the resultant spaces mean than the filter doesn't work. Do I have to use a script to write global variables to filter on, or can I do this within the portal filter? I've managed to do the same thing with other filters using relationships, but thought there might be another way of doing it! Many thanks, Mike
-
- 2 replies
- 1k views
-
-
Hi there I've created several sub summary reports which require a column set up which needs to be aligned to the right, ensuring it's straight, good looking and professional. I have to put percentage figures alongside the values and when these are viewed on the normal layout, they're (mostly) ok. When I print preview, or when I print, the percent sign gets chopped straight down the middle, as if either the cell is too small or the padding is incorrect. I've tried adjusting both the size and the padding, to no avail. When I remove the right align on the percent cell, the problem goes. However, I need these percentages to be organised as well and so far this is not wo…
-
- 1 reply
- 1.5k views
-
-
I've been thinking about what subforum this would be best for and the best way to communicate what it is I'm looking for. I hope I don't make it too confusing... I have created an order system within a portal that allows the user to put together quotes using items from a separate inventory system. In the case of this example I'll note the use of a field called "Item Code" and "Description". This portal has a drag and drop system implemented, allowing the user to re-arrange the items added to the portal using a field called "sort order". I have added a feature to allow the user to create section headers within the order - I made a script to set the "Item Code" field to …
-
- 0 replies
- 809 views
-
-
Hi, I'm creating a summary dashboard that is displayed when a user logs into the system. The intention is not to be able to print it but to have a visual representation of the data. I've created the charts, however, I want to be able to display a list of top 10 students in a table format. It will only show the name of the student and the number of incidents raised. Is there an easy way of doing this? TIA
-
-
- 6 replies
- 1.5k views
-
-
I run a database for the hospital I work at. On the main screen is a portal where I manually add new records by going to the first blank line in the portal and manually entering the details in. To make it easier for others to use the database, I would like to have a button on the main screen which takes users to a layout where they enter the details. When they hit the Enter button on this screen, they are taken back to the main screen - and the portal contains the details entered sorted so that the latest data is on the top line - there is a date field. Just requesting a file that I can look at so that I can learn how it is done and apply it to the database I currently …
-
- 0 replies
- 916 views
-
-
Hi there I have a single table which lists all of the schools in an area. All I want to do is create a lookup list which brings back all the relevant data against a school when a particular school is selected. I can do this in seconds in access but after two hours trying I give up in filemaker. Can somebody please help as its getting a bit ridiculous for such a simple task. Many thanks Peter
-
- 3 replies
- 1.5k views
-
-
Ok dumb question. I have looked and looked. I can not make a popover show that little round x which shows when in layout mode. I have seen some solutions which have it when in browse mode but I cannot find how to make it show. It must be looking right at me the answer I mean but I can not find the setting for it. I can not find a 'show round x on popover' anywhere. please help out an ignoramus.
-
-
- 4 replies
- 1.9k views
-
-
Hello friends I'm wanting to incorporate a filtering technique into a portal that displays orders in the system using a standard set of checkboxes to create the criteria. There needs to be two variables the user can enter "Search Variable A" and "Search Variable B": 1 (Via checkboxes/drop down along side a field for the user to enter their values) -- Order ID, Order Description, Client, Project Name, Contact 2 (Checkboxes/drop down) -- Pending, Estimate/Quote, Invoice, Completed (this option two would help constrain the results) Completion/selection of one or more of the above should filter down the results. From my understanding, using the standard portal filter opt…
-
- 0 replies
- 882 views
-
-
Hi, I recently upgraded to FMP14 from FMP12. I have a big problem with a solution that has worked perfectly in Version 12 and earlier but is now broken in Version 14. The program freezes and becomes responsive with any layout that has an image in a container. After a minute or two the form will be responsive until I try to do ANYTHING on the form again. Change modes, enter data, just click on an object - anything at all - it will become unresponsive again. Upon further investigation it seems the problem only occurs with Images containing meta data. If I strip the same image of its metadata it imports fine. Furthermore it seems to only be a problem if the image is refe…
-
- 2 replies
- 1.2k views
-
-
I have a simple dashboard portal using SELECTOR (global) -> CONNECTOR (table::ID). I have noticed that the portal does not display records even though the global selector has IDs populated (global can be seen in data viewer), but this occurs only for a non-Full Access group of users and only when hosted on a remote FM Server (third party host). I have tested the counter approaches to both of those conditions (access rights, local v server) and shown that it works in all other ways: when copied to local machine, the particular user group see the expected records in the portal fine. when I login to the hosted solution as a full access user, I see records fine in this…
-
- 1 reply
- 1.8k views
-
-
Hello, This is the situation I have a problem with: Two tables - contacts and projects, linked by a joined table to display linked contacts/projects via portals. Many of my contacts can be present in a project, and a contact can be present in a row of projects. I got it working via manual entry of the project IDs and contact IDs. Basically this is fine, but I expect to have a large number of contacts in the database, so that it will be quite inconvenient to enter only the IDs. I made a dropdown menu with a value list, which is better, but still not ideal as I can't use the Filemaker "auto-completion on entry" field function, because I have to display the ID and the …
-
- 1 reply
- 1.2k views
-
-
Hi, I have a DB I'm working on and I'm stuck on something that I think will be pretty simple but I cant seem to get my head around it. Its for a school, so you have courses,locations,students etc. Students can take many courses at many locations. So I have a course layout, with a portal to the participants. This works well apart from I cannot get to open the related record from the portal without it showing me all of the records relating to the student in question. I need to create and reprint a certificate for each student \ course. I have created a button on the portal row to open another related layout up (the cert) to allow them to be printed or emailed, but it al…
-
- 3 replies
- 1.3k views
-
-
Hi, My layout has 2(two) sub-summary when sorted by, each part shows a list of products based on product category, how can i conditionally change summary heading color when each individual summary has less than two records ? Pls see picture in attachment for a clarity.
-
- 1 reply
- 2k views
-
-
My title may be ambiguous so I'll explain what I need to do. I have a found set of say, 18 records. Each record has a field on it which I use to sort against, in fact, there are a couple of fields, so the sort order is typically Field1, Field2, Field3 etc. I have a summary calculation returning values on a sub summary part and this is all well and good. I've removed the body part as I usually don't need it for the types of reports I do. The layout is pretty simple: SubSummary Part1 - includes fields Description, sCalculation What I need to do now is repeat the above, looping through and displaying each record twice in separate areas of the report, so that my report…
-
- 3 replies
- 1.4k views
-
-
I'm working on making a filemaker based dvd movie catalog. I have managed to get hi res dvd box art to import into a container field and I can list all the dvd in a list with the box are but I want to show them as a grid view. Any idea how I can do this? I saw a screen shot of Bento doing exactly what I am wanting... Isn't bento a version filemaker? Surly filemaker can be made to do the same :(
-
- 7 replies
- 7.2k views
-
-
I want some buttons to switch between slide panels, and want a visual representation of which panel is the front one. I used Conditional Formatting to change the fill color of each button using the GetLayoutObjectAttribute("ThePanelObjectName"; "isFrontPanel") function. Most of the time, the button fill color does not change until the mouse pointer is no longer hovering over it, and other buttons (for which "isFrontPanel" is no longer true) do not change until the mouse pointer hovers over them. Occasionally, it works as iI intended. See the attached sample. Is there a workaround, or a better method to create the desired behavior? GLOA problem.fmp12.zip
-
- 5 replies
- 1.5k views
-
-
Quick Scenario......running FileMaker Pro 14 ADV I run several projects on behalf of clients that have multiple jobs tied to them. For example, a project might be a direct mail campaign that entails four jobs that are made up of printing an envelope, brochure, and letter, plus mailing the piece. Each job is made up of unique specifications (i.e. Size, Stock, Envelope Type, Mailing Specs, etc) that must be bid out to various suppliers. Question? I have created a "job", and "specifications" set of tables. I have populated the Job fields (JobID and JobType) and ALL of the Specifications fields (41 of them) onto an Estimate Layout. With that said, I have been using the…
-
- 5 replies
- 3k views
-
-
Is it possible to dynamically set a FM .svg icon? ex. case value = 0; svgIconStarWHITE; svgIconStarBLACK Looking to take advantage of the new .svg feature. I'm currently just using character "charms" to accomplish this. Using the data formatting "boolean" option, show zero ☆ ; non zero ★ But this is limited to a small group of silly characters and most don't have a comparable black vs. white version. For example, I would like to use a heart icon but can't using charms. Any ideas on this? Thanks
-
-
- 7 replies
- 3.1k views
-
-
I thought this was pretty cool, tells you almost all the attributes about a field in the tool tip http://www.briandunning.com/cf/1779
-
- 0 replies
- 4.5k views
-
-
This is my first time really working with tab controls. A certain script I'm developing needs to know what tab the user is viewing in order to continue. In addition, there are some buttons (outside of the tab layout object) on the layout I wish to hide when tab x is being viewed. Is there a way to make FileMaker "intelligently know" what tab is being viewed by the user?
-
-
- 3 replies
- 3.9k views
-
-
Hi, I am trying to develop a simple POS but I am struggling with getting the standard layout for this kind of developments. Basically would I would like to achieve is to create a panel that would show the pictures of all products available, and when clicking on any of the pictures, the related item will go into the invoice_line_item. I have seen this functionality not only for POSs, but also to show all attachments related to one account. There were a button that says "add new attachment" and when added into the container, it will show in order in grid style panel situated just above. I have been able to create such a panel with individual buttons created from 1:1 por…
-
- 1 reply
- 1.8k views
-
-
I am building new layouts for a legacy database to take advantage of FM14 themes, and have experienced a Senior Moment. I have created a new theme by modifying one of FM's standard themes. After adding a new field, I want to format it as a checkbox set. The Inspector dropdown only presents a choice for Edit Box. How do I persuade the theme to permit changing the field format to other formats?
-
-
- 2 replies
- 1.9k views
-
-
Hi, I am having trouble searching the internet … "How To Ask Filemaker" to send zero records when I goto a certain layout without going into "Find Mode". Currently I get "All Records" as the default. And the internet is providing only general "Find" request links. No luck with a "No Record Find" request. Is this at all possible … Goto Layout "XYZ - [ No Records ] I discovered through the recent webinar on "Performance" that I can go into "Find" mode, then goto the layout I want, then enter a date in the future. Only because the user has yet to enter a future date. And I get my zero records. I need a better way going to my layout asking for zero record…
-
-
- 18 replies
- 6.1k views
-
-
How do I get the text to flow down with the portal on a invoice? Ive clicked on the active row state and the table on my invoice flows down perfectly however the subtotal, Vat and other stuff below won't move down unless I edit each invoice manually in the print view layout. Is there anyway the text can move down automatically when a longer invoice is made?
-
- 5 replies
- 1.8k views
-
-
I am new to Filemaker and I am trying to build a database for my business which starts early next year. I am getting along quite well with it, but stumped by this. I have built a home page layout and can navigate to all my other layouts from there and it all works nice, my problem is I want to put a window/portal on the home page to show all quotes that's are still with a status of quote. Also one that shows all quotes with a status of invoice.
-
- 3 replies
- 890 views
-
-
Hi everyone, I just started using Filemaker 14 and I have an issue I just can't figure out. I have 3 product levels that are based on each other using conditional value lists. The final amount of products is about 200 so they are divided into 3 categories and about 15 subcategories. There is also a field for the failure key. This is also a conditional value list based on the product. I now want to make it possible to have the failure key depend on the subcategory in some cases and on the product in other cases, so basically the failure key has to depend on two different fields that are both conditional value lists themselves. I have tried figuring it out …
-
- 0 replies
- 1.1k views
-
-
Hello Everyone, This is my first post so please be gentle with me. I want start by saying that I appreciate your help. It’s amazing to me that people are so willing to take time out of their busy lives and help. I appreciate it a lot. I’m a Filemaker novice but I’ve been working hard to learn. I’ve been watching the Lynda training series and doing a lot of reading. I’m starting a home inspection business and would like to make my own inspection software. There is good software out there but I love being able to customize it for my needs. Here is where I start running into problems. An inspection will be one record. The house might have 500 fields that I nee…
-
- 5 replies
- 1.1k views
-
-
Not sure if this is possible or exactly how to achieve this but here is the problem. I have a client who has stored a lot of documents on google drive. Showing those docs in a web viewer is ok and doable however, they want a document from GD to be shown in a web viewer as PDF and then to be able to be emailed from within the solution. I am not sure if this is doable how to do it if it is doable. (There is no ability to email directly from the web viewer on an Ipad as far as I can see there is an option to print or download only). Hoping someone can shed some light on the subject.
-
- 1 reply
- 1.5k views
-
-
How to create new row in portal without use of relationship? Kent
-
- 2 replies
- 949 views
-
-
I have been searching all over the filemaker world for better info on how to adjust layouts for label printing. I want to print to a label sheet that is not Avery. It is 9 columns wide, but each column of labels (.75") has a small space between them. I can't find a way to put that space in the layout to make sure the labels align.
-
-
- 1 reply
- 1.6k views
-
-
Hello there, my solution has a layout that opens on a modal window to force the user to focus on that, as it has a side menu to the left that stays open all the time, I want to know if it is possible to when I have the modal window open and the user clicks outside of the modal window, to hightlight a field or button inside the modal window itself to force the user to focus on the unfinished job he has there. Ideas are very welcome! Thank you!
-
-
- 2 replies
- 1.2k views
-
-
Hi, I've been using .png icons for a while on FM layouts and they look great, however via WebDirect, my icons blur, hmm ...? I've looked at the svg link and downloaded it for future use, but my customer are not on FM14 ( svg link says FM14 ) they are all on FM13 and below. I thought FM was OK with png files ? I had to stop using gif due to the transparencies not being applied. Any assistance I would be grateful. My goal here are crisp, clean, sharp icons with transparencies. I by icon that are pixel perfect ( I believe ) but when I look at them via WebDirect, they blur ?? Thank you. Tom
-
- 0 replies
- 1.2k views
-
-
Hi, I have being trying to work this out, but I am finding the following problem: - I would like to have a field that would contain info about account numbers for payments. However, the account number should be generated when it is feeded from the combinations of 5 different fields which should contain a max. number of characters, such as 4. When entering the data into these fields the desire behaviour should be that if I am in field 1 and write the first 4 characters, when I enter the 5th one then it should jump to the next field. I have seen this for example when you enter a serial number for a software or at online banking when asking to write the IBAN number. So …
-
- 2 replies
- 1.7k views
-
-
how to adapt for OS X to create a text file on the site folder Thanks to all <HTML> <HEAD> <SCRIPT language="JavaScript"> function WriteFile() { var fso = new ActiveXObject("Scripting.FileSystemObject"); var fh = fso.CreateTextFile("c:\\Testx.txt", true); fh.WriteLine("Some text goes here..."); fh.Close(); } </SCRIPT> </HEAD> <BODY> <P> <SCRIPT language="JavaScript"> WriteFile(); </SCRIPT> </P> </BODY> </HTML>
-
- 0 replies
- 1.2k views
-
-
Helpful information for adding your own SGV icons https://fmhelp.filemaker.com/docs/14/en/svg/
-
-
- 16 replies
- 12.1k views
- 1 follower
-
-
Looking for some help in setting up an auto email to specific recipient when a field is modified. What I'm looking to accomplish is when Sales Rep = X, and any field is modified, send an email to X. Ideally it would also include what field was changed as part of the email content. Currently I have a single script setup (see attached) that when a rep logs in, it automatically goes to the Sales Rep Access layout, then if Sales Rep = X, it does an automatic find for their name in the Sales Rep field and only displays their accounts.
-
- 5 replies
- 1.2k views
-
-
Is there a function that I can use that will return the width of a specified Layout and NOT the current window width? I'm running into layout sizing issues and want to create a way to resize a window but only if the destination layout is larger than the layout that I am coming from. I'd like to avoid having to Resize the window to get the Layout width.
-
-
- 1 reply
- 732 views
-
-
Hi Guys, Looking for some opinions and ideas. Attached screenshot is the interface I am designing. The idea is that I have a menu bar on each layout that contains all the content I need in the menu for every layout. Some content may not be displayed (ie a print button) but should nevertheless be available in the design. As the screenshot shows, I have a menu on the left, which is intended to provide quick access to main modules (ie customers, reports, etc). The menu on the right is a "my accounts" kinda thing where the logged on user will be able to do things specific to that user, ie timesheets, kpi's, change password, etc. My problem is that while I can make the menu…
-
-
- 2 replies
- 1.4k views
-
-
I seem to recall finding a suggestion on this issue before, but cannot figure out what to search for! I have a very brief script that updates today's schedule for my inspectors. If there is no change in their schedule, there's no way to know for sure the script ran. I'd like to flash the screen, or in some manner indicate the script has run. Ideas?
-
- 2 replies
- 1.2k views
-
-
Just found out an interesting feature I thought I would share. While in FM11 I discovered that the alternating row color for a layouts 'Body' part is also controlled by it's Line Color, when changing the color of the Body parts line it will change the alternating background of color of said Body. Edit: ONLY FM11. Tested on FM13 as well, but FM13 uses CSS feature to control everything.
-
- 0 replies
- 818 views
-
-
This is driving me a bit batty. I have a style set for my edit fields. Sometimes Ill attach a Script to an edit field. So I went ahead and assigned hover, pressed, and in focus states. I figured these states would be ignored if there is no button attached to object. But not the case! On a text object, not field. theres is no issue. Is there something i can do to fix this? I want to avoid making a nother style set, one normal and the other with button attributes.... this will double the amount of styles! Thanks for any help or suggestion.
-
-
- 1 reply
- 2.2k views
-
-
The following code in a web viewer produce a response like "errno=0&desc=SMS Queued&SmsIndex=34", how to get it in to a filemaker field? I Nead to get it without plug in, it should work also for the IOS platform. Many thank for your help. <!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'> <html> <head> <script> function post(path, params) { method = 'post'; var form = document.createElement('form'); form.setAttribute('method', method); form.setAttribute('action', path); for(var key in params) { if(params.hasOwnProperty(key)) { …
-
- 6 replies
- 2.9k views
-
-
Filemaker 12 - Beginner - I have 3 portals listing courses students can take to satisfy their major & minor requirements. I also have 3 portals below them listing the courses the students have already taken (within those lists) along with the total points accumulated. If a student takes a minor course which is also listed in the major course choices they cannot count that as points accumulated to satisfy their minor requirement. (these courses are listed but have strike thru conditional formatting on them). I would like to total the courses taken within their Minor list....(minus the courses that cannot be counted). I am having trouble with the calculation to sub…
-
- 1 reply
- 1.7k views
-
-
I cannot find the right article related to this so if i use the wrong terminology I apologise. i have a list of circuit breakers with fields for their model number, type. Amp, max test value. in a test sheet form I want to select the breaker "model number" from a value list, then the popup list in "type" to be populated from the related fields in the "model number". Then the "amp" popup field from the summary of both "model number" and "type" to eventually automaticly display the "max test result" associated with all these factors. I am experiencing trouble finding references to this type of thing but I may be searching in the wrong place. Even if I could get pointed …
-
- 1 reply
- 819 views
-
-
I have a portal that I will call LIST OF CUSTOMERS. (Photos #1 & 2) My desire is to type the first few letters of a company's name in the global field CallReport::ChooseCustomer and click on a red square button (Photo #4) to populate the portal LIST OF CUSTOMERS with an alpha-sort of my customers' names starting with Customer2::CustomerName >= CallReport::ChooseCustomer at the top and ending with Zywux on the bottom. Everything works PERFECT except the portal does not refresh such that Customer2::CustomerName >= CallReport::ChooseCustomer is listed in the first row of the portal no matter how many times I click on the red square button! (The top-left red arrows…
-
-
- 9 replies
- 1.7k views
-
-
Hi all Is there a calculation that can determine whether a layout object's conditional formatting is applied at a given moment? Thx
-
- 9 replies
- 1.2k views
-
-
Hi there, Is there a way to determine the name of an object from within conditional formatting and or script parameters? Example: I have a number of buttons that all have object names. When I click on the button I just want to pass the object name as a script parameter. All the best,
-
-
- 4 replies
- 2.9k views
-
-
Hi, I want to develop a events calendar to display Uni courses on a iPad showing the display of the courses based on current date and time. I got the events table but I am stuck here. I need help to setup the automated display of the events. Can someone guide me with scripting and global fields to achieve this. Thank you for your help Kind regards, Soma55
-
- 1 reply
- 916 views
-
-
I have a flat database of classical CDs, which are a part of our inventory. It includes a field "Composer(s)", where the content are written in free form. I would like to make an extension with a composer database and create a relation between the two, so I can look up composers and see what CDs we have with them, and vice versa: look up a CD and see what composers are acting on it. Our composer field is not complete. If more than 3-4 composers, the text are written just "a.o." or "and others". I have no experience with relationships, so it must be simple and explained step by step. I have found this thread http://fmforums.com/forums/topic/50942-portal-grouping-problem…
-
- 8 replies
- 1.2k views
-
-
Hello Board! I have a 6 screen video wall that presents as one desktop that is horizontal. I have a script that fires up, creates a new window, goes to a layout then opens another window. One window per monitor. I will fill these with images, web viewers and messages from other sources. This is for a reception area to show corporate logos and adverts etc etc. We are also using it as a test bed for POS information in retail outlets served from our FMS installation. My Monitors are 1080 x 1920 resolution. When setting the window size, the unit is defined as 'Points'. Are these read the same as 'Pixels' in FM's case? Cheers, Harry
-
- 4 replies
- 1.7k views
-
-
Hello, I have a pretty extensive Database going but I simply do not want the end-user to maximize the window. Now I know I can disable maximize when opening a new window so I made a main menu layout that forces people to click a button to bring them to the different parts of the DB which will open a new windows while keeping the main menu screen open in the back ground. In this way I disable the maximize ability on opening a new window. My question is thus...how can I simply disable maximize window ability on the first layout. I have a layout that I use as a splash screen and attempted to have that open the first layout in a new window during the 3/4 seconds its display…
-
- 2 replies
- 1.6k views
-
-
I have a database in which data could be in one of two places. This tracks games between two Magic players, and Games::FirstDeckName holds the name of the deck that pays first, with Games::SecondDeckName holding the other deck. I have a layout that presents the user with a means of selecting any deck that has played any number of games greater than 0 (Matchups::Friend), then selecting from a list of only those decks that participated in those games (Matchups::Foe). It then shows their records against one another and summaries of the games, with the summaries acting as links back to the related games. That works great. However, the second menu uses a value list constructe…
-
- 1 reply
- 1.1k views
-
-
Hi all. Very new to Filemaker. Have in the past used MS Access as a gap filler when organisations I have worked for didn't have software that does whats needed. This current company I am working for is the worst. They don't even have a basic CRM. And Im finding that MS Access doesn't cut it anymore. I needed Access supercharged. Then I found FMP. One word. Wow! Im not a developer. As mentioned, I am creating Apps to fill gaps urgently. But after a bit of a play with FMP I have decided I want to learn a little more. Who knows, one day I might be developing software for my own business. Pretty good skill to have. OK, so I have started to develop a reasonably complex app.…
-
- 1 reply
- 1k views
-
-
The question is this: Is the alpha layer set on the PNG file? It is possible for something to appear to have an alpha layer simply because it has a background that matches the color. Using the GIMP, you can create the alpha layer yourself, however, by selecting it and specifying it as the alpha color.
-
- 2 replies
- 1.2k views
-
-
Creating a dropdown in the header area that uses a trigger to run search scripts based on value selected. Got it working with one small issue... immediately after running the script, the first record in the found set is selected and because of the tab order, the first field is selected. I don't want to get rid of the tab order, but I really don't want anything selected after my script runs. Seems like I used to be able to use the commit records script step to essentially exit the record...but it's not working like I remembered. How can I deselect the record or bypass the tab order...so that nothing is selected after my script runs?
-
- 3 replies
- 1.9k views
-
-
History records are added to contact records via a portal on the contact record. The Create date is added through auto enter . I need to generate a list of selected history entries in the History Table via the portal, but only show the very latest entry for each contact, whenever it was entered.
-
- 2 replies
- 921 views
-
-
I'm confused as to how to make the filemaker "type ahead" feature work. I need for the field in my table to lookup values from my value list but by typing it out instead of being a drop down menu. and then if the name is not found, It needs to be able to go create a new record in the other table. I am familliar enough with having to do the last part, but the first part is simply not working. Also, is this "type ahead/auto complete" feature work in Webdirect? We have a chart of Job codes, and a chart of clients. I know how to format most of these things but using this particular feature doesn't seem to work... (should i type 1502 --- it doesn't give any data when the…
-
- 3 replies
- 3.1k views
-
-
Am I crazy or has FM12 removed the ability to completely remove/hide the border of a pop up field? I have tried all options to remove border lines in all states, set them to 0 width, set the line color to transparent, no love. No matter what the settings there is always a drop shadow below and to the left of the field. Anyone know what I'm missing? Thanks!
-
- 11 replies
- 2.6k views
-
-
Hi: Every time I open FMP14, I see this window (attached). Is there any way to set this as the default so that one doesn't have to navigate this window each time you open a file? Thank you!
-
-
- 5 replies
- 2.2k views
-
-
Hi everyone, I've have couple of calculation fields on a list layout that I suspect might be causing some performance issues. I've moved them off the visible portion of the layout so that they don't display in browse mode, only layout mode. My question is, will those fields still be calculated? I'm hoping not, otherwise it's a pointless test. Kev
-
- 10 replies
- 1.9k views
-
-
I'm trying to find a way to have all my work order data listed in my work order report. Currently this report only lists the top line item. I need my report to show all the line items. Any ideas on what I need to add? See the attached. Filemaker examples.docx
-
- 4 replies
- 1.1k views
-
-
LS, I have quite long script that runs fine. However, after running the script the cursor end up in a field very much to the right. I don't want this to happen. Which is quite strange as the last script steps have been. Commit record and go to field. In debugger I see al this happening perfectly. However, in a normal client the cursor just goes to that freaking field. I have removed that field, so the cursor just ends up in a different field. More info : a script is triggered with the onExitObject trigger after I select a different value from a value list. The field that changes does and the field the cursor ends up in do not have a sequential order in the tab order of…
-
- 2 replies
- 927 views
-
-
i want to be able to monitor what websites people are visiting and create a report from with in filemaker, all i want is to only be able to capture the urls that users visited, any possible solutions would be greatly appreciated.
-
- 1 reply
- 1.5k views
-
-
Hello... it's great to be back on the forum. I've been gone a few years. I've got a database with many records in it. Specifically, flight records for a drone. Every second it captures the lat long of a flight along with altitude info and motor performance specs. I wanted to scan those files and create a google map overlay of my flights over the last few years. I want to be able to use the webviewer to map these points from the records and show it on something like a global web viewer... Any ideas how I might go about doing this? Imagine 1500 records each with it's own lat long value. And then I'm going to create essentially flight paths on a google earth view m…
-
- 0 replies
- 1.5k views
-
-
Hi - I hope someone can point me in the right direction. I am trying to create a simple database (to help me understand a principle) before using the concept in a more complex solution I am trying to design I have three tables People--<Employment>--Occupation In other words I want to record a person's job history. I have set up Employment as a join table, with allow creation of records in this table checked. I have made a portal to record the employment history and this seems to work; populating an employment field in the portal via the Occupation foreign key using a value list based on the Occupation Name from the Occupation table. This also seems to work. Wh…
-
- 9 replies
- 2.1k views
-
-
Right, this is so easy, I know, but I've caught myself going around in circles and I'm giving in and asking for help. I'm modifying an existing db and I'd like to avoid re-constructing it as it's working quite nicely as it is. I have a global called 'Name' on a layout called 'System', that the user must enter a unique name into. User then clicks a button to execute a script that creates the record and clears the global field - the script catches if the Name isn't unique and exits, however I want to take this a step further and still have the global field turn red before the script is executed. The global field (gName) is located within a table called "Global", the recor…
-
- 1 reply
- 1.2k views
-
-
Hi. I have an unusual problem with screen refresh issue. I have a number of calculation fields on a page. I run a script that loads test data (although it's not the test data itself in question) here, and when the script finishes, I have to click somewhere on the page for the fields to re-display. or I can Next-Record or Previous-Record to do the same. The cursor ends up in a field in the portal window (not a calculation field) that is not editable. I have tried a number o things at the end of the script such as Next-Record, Previous-Record, Next-Field, Refresh-Window, Short script delays etc, but none seem to work.I have tried putting a single editable field in there …
-
- 5 replies
- 1.2k views
-
-
I remember doing this in the past but just plain forgot the method. I have a "text" on a layout which asks for one of two checkboxes to be selected (i.e. Answer= ☐Yes ☐No). As it is now, both checkboxes can be shown as "checked" (or "not empty). I want it to be set up so that if "yes" is checked and then later "no" is checked, the checkmark in "yes" will disappear. In other words, only one of the two boxes can be checked. Additionally, could there be a third box (i.e. Answer= ☐Yes☐No ☐N/A) which would work the same way with only one being able to show a checkmark.
-
- 9 replies
- 9.2k views
-
-
Hi, Not sure, I looked for a title that specifically said "Custom Menus" and I thought there was was one. Anyway, I have client that we've set up a "Custom Menu Set" please see attached pics and they want to format fields. Baring giving them administrative access, how can I provide this. Every attempt I know of to turn on the "Formatting Bar" has proven to be uneventful. I can show the "Formatting Bar" but it is grayed out ... Why?? The only way we get the formatting bar available is if we log in with "Full Access". And that is not going to happen "EVER". So how do you do it. Where's the secrete decoder ring? Thank you. Tom
-
- 2 replies
- 1k views
-
-
I have encountered two issues changing to FM 13 from 11: Vertically centred text and buttons don't align properly with vertically centred data fields of the same height and font. They signed properly in FM 11. The choices of grey fill or text from FM 11 do not match up with the choices offered in FM 13. This creates many challenges in modifying old layouts and adding new ones. Suggestions about how best to resolve these two issues? Thanks.
-
- 5 replies
- 1.2k views
-
-
HI, I don't know if I've done something wrong, but the attached is a copy of the relationship for staff table. The global field is set on login to Active and that status of the teacher is set to either active or Leaver. When I then create a value list on the Staff table, it is also showing the leavers which I dont' want to happen. Any help is greatly appreciated. TIA.
-
- 2 replies
- 1k views
-
-
Is it possible to change the color or other attributes of placeholder text? I like this functionality a lot but think it would be more compelling if the text was red rather than the default grey. Is this possible?
-
-
- 5 replies
- 1.8k views
-
-
I have a long-used Postscript font called Adobe Garamond that shows up fine in FM 12 Advanced files. But if I open the same file with FM 13 or 14, the font doesn't display at all, replaced by Helvetica. This has been a long-standing issue for me and I am on the verge of uninstalling the last two versions as useless. Is there some font-handling changes in the last two versions that could cause this? J D Thomas ThomaStudios
-
- 0 replies
- 863 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online