FileMaker Interface Features
-
Hi there, I've built an invoicing database off of the supplied filemaker pro template and I'm trying to sort my portals through a category field that I define. By using the portal setup I sorted the portal records by that category variable...it seems to work fine and sorts them accordingly. However, when I then try and print out all of the portals into an actual invoice, it no longers takes this sorting into account and lists them as they were entered. Any hints how to keep them sorted? I admit I don't even know how I managed to make it this far. This is really my first attempt at filemaker pro and I don't really claim to understand it in the slightest. Let me kno…
-
- 3 replies
- 1.2k views
-
-
In reference to: http://fmforums.com/forum/topic/83953-portal-sorting-with-fm12/?p=408698 Hi, I am doing a task and I am thinking to use this Virtual Sort from Jeremy, by the way, excellent! But I don´t have any portal and what I need is to make something like the Sort Dialog Window, I know how to coose fields, maybe comments clarify them better for the end user and with the field list I´d like to do the same you did in your work jbante, but, have you anything more to help me? any advise or something to use your modules in a normal layout and sorting data with your scripts, I have no buttons, I´d have the list of fields and the order (ASC / DESC) of each one separ…
-
-
- 11 replies
- 2.3k views
-
-
Hi all I'm a little stumped here and after trying numerous methods I figured I would ask for help. I have an Asset table which contains records imported from an external source. There are three key fields in this table: Product ID (SKU), Asset ID, and Department. I have a second table called Product IDs. This table includes: Product ID (SKU) and Product Description. The two tables are joined by the SKU. Each asset department has a separate layout on which their respective records can be modified. Each layout has a search feature that will constrain the found results depending on their department. For example, one of my departments is called Lenses, und…
-
-
- 9 replies
- 1.5k views
-
-
I have text field. The text size entered is variable from record to another; it may fits in one line or few lines. Is there a way to set the field length automatically to show the entire content of the field in list view? THANKS
-
-
- 8 replies
- 4.1k views
-
-
I am new to FileMaker and I am loving every moment of it. It is so powerful. I have took some training (online) and have been reading on best practices and other related topics. My solutions for my business are coming along, but I am stuck on some areas. I have constructed a database that will collect information for my business. This information will have Topic and Subtopics. It was suggested to me that I try a setup like this. INFORMATION------<TOPICLIST>-------INFORMATION_Topic INFORMATION::pk_information = TOPICLIST::fk_infoparent INFORMATION_Topic = TOPICLIST::fk_infochild INFORMATION and INFORMATION_Topic are both Tabel Occurrences with the same data…
-
- 0 replies
- 1.3k views
-
-
Hi, Â I use "Tool Tips" quite often, and I have a client where the tool tips were not working except for one. Â As I investigated the tool tips that did work, which was only one, I notice that the "Tool Tip Image T" in Layout Mode was bigger than the "Tool Tip Image T's" that were NOT WORKING. Â No matter what I did to change the size of the Tool Tip image "T" to no avail. Â I even tried coping the text, then changing it to the text but the image "T" goes small all the time now on this file Very strange. Â This is the only clue I've got to why the "Tool Tip" is NOT WORKING for my client. Â Now the "Tool Tips" all work on my computer regardless of the "Tool Tip T…
-
- 0 replies
- 857 views
-
-
Hi, I need the value list number, not the "Value" base on "A" number. So, lets say I have a value list relationship of ID's ... 345 567 678 786 799 801 Value 799 is number "5" in the list. I can get the value 799 if I manually enter "5", but I have a field where I've built a relationship that puts the ID of 799 into an ID fields base on the customer selection of drop down menus. Based on this ID field ( 799 ) I would like to extract "5" from the ID value list relationship above. And the following functions below don't seem to give me that option of extracting the "5" ( it would appear ). ValueListItems ( Get ( FileName ) ; "Inventory I…
-
-
- 27 replies
- 2.2k views
-
-
I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field. Chapter Title Sentence ABC aaba ABC abac ABC efgdf ABB bdc ABB cdfegdf . . . What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1 For example: Searching the above data for the title: ABC should show the output in a fi…
-
- 4 replies
- 3.1k views
-
-
I have a FMP file that loads various other FMP databases into a single file. In my header, I have a logo and a portal-based menu that links to layouts that load data from those individual files. For all other layouts (photographs, boxes, exhibitions..etc) everything works fine, but with Contacts, the header contents will not appear. Similarly, the Photographs layout loads an image and title information from the Images database file. Again, the header contents will not load until I have entered the ID# from the Images database. Does anyone know what could be causing this? Thanks in advance, Ryan
-
-
- 12 replies
- 1.5k views
-
-
I want to have a portal displaying records in the found set. For example: I have an Inventory table that has a self-relationship. I have a layout to show the full details of each record, and a layout that shows a list of inventory (through a portal). I have a side search area that filters this portal. However, I want to be able to allow users to be able to search all fields if they wish to - not just limited to those I have in the search area. So, I want to allow to enter find mode, perform the search, and then display it in the portal. I was hoping there was a way in FileMaker to determine if a record is in the current found set. I couldn't find a…
-
- 1 reply
- 2k views
-
-
OK, so I've asked other questions about scripts in the appropriate section, but think this might be better posted in this section. I have a List View report that contains a list of data appropriate to the logged on user. Whilst the amount of data shown will be different based on the user, it will always only show a list of client names. What I need is for the user to be able to select a client name and that to take them to another screen, which is populated with the appropriate data from another table based on the selection. I have a table called ClientDetails, and another call ClientContacts. The field (ClientName) is a relationship between the two, with a Value …
-
-
- 20 replies
- 2.6k views
-
-
FM11 Starting with the first tab, I fill the field with the required information, then it takes me to ne next field in order, but after a nth field in order, the "unmodifiable field" message appears, where is the error ?
-
- 5 replies
- 1.2k views
-
-
I have a check box that displays two values from a value list. I want to make it impossible for the user to select both check boxes, and required to select one. I don't know if this will cause a problem later, but in another table, I will be reusing the same value list as the source for a check box and will need the option to select both in that record. So the properties that restrict the user to select only one check box in the first table can't interfere with the ability to use that same value list on another table and be able to select both. Should I make another table with just one field and two records instead of the value list and use a validation calcul…
-
-
- 13 replies
- 11.5k views
-
-
Digging into conditional formatting. Can buttons/fields be "flickered" the same way they can be assigned an alternative color, if certain conditions are or are not met? I don't think FM Pro Adv 12 has this built in. I'm thinking this may be some sort of loop, customized to "pulse" or "flicker" (animate?) the background color (lighter-darker-lighter...) until it's pressed. Am I off base with "loop"? Do we have another method to "flicker" a screen element? Thanks.
-
-
- 6 replies
- 3.3k views
-
-
I found several others have stated this conplaint as far back as FM7 so I guess I'm with company. Kind of surprised that it is still not fixed. Anyway, I couldn't input certain Thai and Lao characters in FileMaker text fields or labels. But it can read those characters all right when those text are input directly via MySQL and displayed in FM (I use FM12 Pro). Even more curious is that I can type those characters in FM Go! Have seen a lot of suggestion about copy/paste, opening up scripts and all, but I would really prefer a built-in solution. I'm trying to push FileMaker to replace my company's current database software, but the inability to type common Thai/Lao …
-
- 3 replies
- 1.7k views
-
-
Not to sure where to post this so I will try here. Â Playing with themes used to work fine and now all of a sudden every time I change a theme it ruins everything. Â I have tried re-installing and even other computers with new databases and it is still the same result. Â Attached is a picture before making a change and then the same theme re-loaded. Â
-
- 5 replies
- 1.8k views
-
-
Hi Folks, I’m new to Filemaker and cannot figure how to get past a particular point using conditional value lists. I understand the conditional value list and have it working. It’s a two table file. One table has all the values and fields where we have Breakfast, Lunch, Dinner in a Menu table. A second table called Order has all the food choices related to the Menu table. Here is where I need help. What I want to be able to do is when I click on my final related selection—say Lunch...Hot Dog—is have a couple of windows (fields, portals?) be available to enter narrative data into to fully describe the second object chosen—the Hot Dog. One window entry could descri…
-
- 1 reply
- 1.1k views
-
-
Hi  I'm trying to solve a problem regarding excluding certain records from showing in a drop down list. I have a list of volunteer drivers that are available for hire and show in a drop down list, however there are times when a particular driver won't be available due to holidays, sickness, etc. What I'm trying to do is display just those drivers that are available in the driver drop down list.  I have a table that contains all the driver details including both the driver name field as the drop down and a field called status which points to a value list containing the list of availabilities. I have googled this and been on the forums to read up on value lists …
-
-
- 11 replies
- 3.8k views
-
-
I'm pretty sure the answer is "No", but just in case I've somehow overlooked the obvious in my various searches, I was wondering if anyone knows a way to change FileMaker's Default Table View Properties.  Specifically, I pretty much ALWAYS want to "Include Header Part" and "Include Footer Part" when in Table view, but I have to go in and check the appropriate checkboxes every bloody time I create a new layout. I don't think it would be so annoying if it weren't for the fact that it's buried a couple of layers deep...  Thanks--
-
- 1 reply
- 930 views
-
-
I have a pop-up menu upper left corner of attached image. That button is configured like this. The "Display data from" is set as a global field and the "Values from" is set with a value list from a Employee table. The "Use values from first field" is the EmployeeID the "Also display values from second field" is the FullName from Employee table. The button displays the employees just fine. Now I want to display the selection of the employee name to the portal. I have relationship set up from Employee table to WorkOrder table based on the employeeid. The portal section will display fields from the work order table. When we first load the layout the portal …
-
- 1 reply
- 1.1k views
-
-
These fall into the category, "things that baffle me but are so simple I'm almost too afraid to ask..." 1. Sometimes, in Layout mode, when I click on a field directly the layout tools are dimmed (font, bold, underline, etc.). However if I select the field by dragging the mouse across it, then all the layout tools are active. What's that all about? 2. What is the best way to ensure that layout text, text fields, and numeric fields all line up nicely on a straight line? It seems like numeric and text fields don't always line up well, especially if they have been stretched vertically. Setting the alignment to the bottom, and using the 'align > bottom edges',…
-
- 7 replies
- 1k views
-
-
I'm pulling my hair out over this one. I know I've seen the answer to this one somewhere, but no amount of googling seems to be helping me find it again. I've created a value list that uses values from a "Drivers" table. The first field value is the DriverID, and the second is Full_Name. When I select to sort values using the Second Field, the value list shows only the first record from the Drivers table.
-
- 4 replies
- 1.2k views
-
-
I have a strange issue. We have a table of data with about 250,000+ records. On occasion a new record created by one user will show for another user with "??" in some data fields and the other data fields will be blank. This persists for the affected user until they quit FileMaker and re-open the database. 1) Does not appear to the be typical data corruption issue that shows a "?" in every field. - Issue only appears one user's FileMaker Pro while other users can see the data fine. - A restart of the user's FileMaker Pro client always resolves the issue. - "?" shows as a "??" in some fields while other fields appear blank. 2) Issue appears to affect records a…
-
- 1 reply
- 1.1k views
-
-
Can anyone think of the pro's / con's between: a) Custom script attached to "close window" (set in a custom menu) Custom script attached to OnWindowClose (set in File Options, script triggers)
-
- 3 replies
- 2.5k views
-
-
Hi all, Â Seasoned FM developer here but really never done a lot with reports. Â So me thinks this might be a simple question... Â How do I have a summary field in a trailing grand summary, but summing a field from a parent table? Â See the attached screen shot which should explain pretty quickly what I'm trying to do. Â I think the issue is, I can have a trailing grand summary of a field that's based on the current table (and of fields showing the "body" section), but I can't have a trailing grand summary of a field that lives in another table and / or displayed in a sub-summary part.
-
-
- 7 replies
- 1.1k views
-
-
Hi all, I have a solution that I've recently split out into UI and data so users have better speeds when using over a WAN. And it works nicely... still kinda slow but acceptable. However, I have an "overview" or "dashboard" layout of portals which is going horribly slow even with a simple (one field, stored) relationship. The portals show order statuses so in one portal it shows all the orders at "waiting on payment" and in another portal, all the orders with a status of "ship", etc. The status is a stored text field on each order. So the relationship is really easy. But even across 600 records, it takes about 1 minute per portal to display the res…
-
- 5 replies
- 2.1k views
-
-
I needed a way to manually reorder portal records from time to time and to keep a sequential number with each record for export purposes. This example I created does this via a looping script which allows individual records to be moved up and down the sort order and also delete records from anyplace in the sequence and have the remaining records automatically resequenced. I am not sure if it might get slow when dealing with large numbers of records but in my case there are unlikely to ever be more than a dozen or so. I am still a relative novice with FM so would be interested if there is a slicker / quicker / better way of doing this. Codeus ManuallyR…
-
-
- 12 replies
- 8.7k views
-
-
I import the results for UK handicap races into Excel but it has grown to a large spreadsheet and has its limitations. I am the wrong side of cemetery hill and decided to keep the grey matter ticking over learning filemakerpro to import the resuts. I have successfully imported a small test database of results. So far I have the form in the database with the tables and relationships below but when I try to make a layout to view the form I get the horse name and form I get 1 outing and when I scroll through the same horse displays again with it's next run. I think it's because I have failed to fill the foreign keys in the horse_Race table. I also want to add a Todays runne…
-
- 5 replies
- 1.2k views
-
-
I have a three table database in FMP 11 with the following tables: Contacts, Projects and Organizations. I have a layout that shows information on a particular project, based on the Projects table. Each project is associated with a client organization and another unrelated contact from the Contacts table - the salesperson. There is a drop-down menu on the Projects Layout for the contact person from the organization assigned to the project. This drop down list grabs information from the contacts table (a field for the contacts full name) which is sorted by the organization. For example, if Organization A has three project managers Bill Smith, Betty White and George Jones, …
-
- 2 replies
- 1.1k views
-
-
I have created a custom menu set that swaps the shortcuts for "paste" and "paste without formatting" (command+v now becomes "Paste Without Formatting" and command+shift+alt+v now becomes "Paste"). This works fine except for when a dialog box is presented to the user. For some reason, the "Paste Without Formatting" function is disabled and the only option available to the user is the normal paste command, so in essence the paste shortcut (command+v) is now disabled. A quick search of Google returns no results, but is this an issue with Filemaker or is there a known limitation of shortcuts and dialog boxes?
-
- 5 replies
- 2.3k views
-
-
Hello everybody, Reporting from Filemaker.com "When you view records in a table, FileMaker Pro displays data in rows and columns. Each row displays a record, and each column displays a field." And that is fine in most of the occasions...now what if one would like to invert this order ? In other words...would it be possible to set the layout (or data) so that each row displays a field and each column displays a record ? In particular I can very easily obtain something like this: Exam Date Field1 Field2 Field3 1 Jan A A B 2 Jan B C D 3 Jan E F G But would i…
-
-
- 6 replies
- 4.7k views
-
-
Well that title wouldn't help much! haha I'll try and explain this with exactly what I'm aiming to do. I'm trying to create a layout for when I do our wages. The plan is to have 3 portals: 1. staff_LIST: a list of all the staff members that have completed work for clients within the wage period 2. staff_SHIFTS: a list of all the work (shifts) the selected staff member (from staff_LIST) has done within the wage period 3. client_SHIFTS: a list of all the work done for the client within the period which is selected from the staff_SHIFTS portal. All these portals would be based on a table called Shifts - it contains all the work done for each client. Kind o…
-
- 5 replies
- 1.8k views
-
-
Anyone number of a way to align text in web viewer? GetAsCSS will preserve the font formatting of text from a field being pulled into a web viewer but the alignment is lost. I've searched a fair bit but I can't find any way of preserving the original text alignment (center, right, etc). Thanks for any advice.
-
- 5 replies
- 3.4k views
-
-
Hello, I am building a database for a hospital program and I have a table "patients" that is related to another table "tasks". On the main layout I have a button that goes to the "tasks" records In the tasks table each record corresponds to a task the doctor must complete for the patient its related to. There is a field that has a checkbox "completed" I want the button to conditionally turn red when the at least one task is incomplete. where the field completed="completed" Is there a calculation step i can put in the conditional formatting that tells filemaker to check all of the related records in "tasks" to patients that are incomplete? Thanks f…
-
-
- 3 replies
- 1.5k views
-
-
I'm sorry for asking this question, as I know it is in the help section somewhere. I just cannot seem to find it. How do I set up a field so that's when I enter data into it, it always goes back to the font I use in my database? Currently, if I paste something with a different font, the fonts that was pasted remains. I want the font to resort to the default of the program. Thank you very much for your help, Fed
-
- 3 replies
- 933 views
-
-
Attached my little code snippet and alarm layout.. I have 2 buttons to accept or postpone this triggered alarm... I want to ring a bell sequence, to recur over & over.... until.... maybe as an option.... For waking up operator not near or at their desk.. possibly sleeping on the job! To perform the alarm action.. How might i do this... TIA rod
-
- 9 replies
- 1.7k views
-
-
Hi, I'm new to javascript, but I've made some great progress using SQL (via 2empowerFM) and JQuery to build some tables that have exactly the data, and look and feel that I'm looking for. But I cannot figure out how to navigate back from a web viewer. Is it possible to navigate back to a Filemaker TO layout for a given record being reported in the jquery table? I realize this is straight forward in a FM portal table, but it's limited compared to what can be achieved with SQL/JQuery. Any help would be greatly appreciated. Thanks, Anthony
-
- 2 replies
- 2.1k views
-
-
Hello, all-- Â When switching tabs, any text that had been selected in the original tab is no longer selected in the second tab. Â original tab: subsequent tab: An OnTabSwitch trigger, calling this simple script, didn't solve the problem; it seems like the conclusion of the script causes a jump back to tab1: Â Any suggestions appreciated. Thanks very much! Â Â
-
- 5 replies
- 2.4k views
-
-
I seek help on various forums from time to time but this time I'd like to give back. I had been seeking a solution to integrating Skype into a database for the purposes of dialling phone numbers or initiating Skype-to-Skype calls or chats, and got so far with it but it wasn't working cross platform. Various tips on other websites helped along the way, but I couldn't find a fully documented solution for cross-platform integration. Perhaps I didn't look hard enough, but a few weeks ago, I figured it out and have two scripts (one for dialling phone numbers and one for initiating calls/chats to a Skype name) that work on Windows, Mac and iOS. I have finally got around …
-
- 2 replies
- 1.5k views
-
-
I need probably to figure more information B4, but maybe something simple will comment back Station station 1 works real well/ Parent Message file .. I have 2 instance of same , in Relationship chart... 1)Alarms, 2)Recurring Then on a simple layout, I have 2 portal, The only difference between each alarm and recurring is a field set .. to 0 or a 1 Never B4 noticed that on my Remote Log station #2, or even on my iPhone... All the message records are showing in the one Alarm Portal and other portal skeleton is there.. just not any fields or data. All my records are all showing in other portal?? Any quick thing comes to mind why?…
-
- 2 replies
- 1.1k views
-
-
Hi folks, I'm stuck again!! I have a portal I'm using to input grades for class asessments. At the moment, to go from one row to the next I have to click on it with the curser. When I tab, I go to the start of the next row and have to then tab across to get to the same field on that row. I'd really like to be able to tab (or use the keyboard arrows) to navigate the same field on different rows of the portal, ideally using arrows to go to different fields on the same row; just like you would on a spreadsheet. Is the possible? I've tried with script triggers, but have had no luck! Cheers, MIke
-
-
- 18 replies
- 2.1k views
-
-
Hi guys, Hopping some can help and if what I am trying to do is even possible. I have a database with three tables user, project, project notes. I have one layout where I have a portal that lists all the projects (works fine), when I click on a project (using show related record) it show the details on the project as well as a list of notes of the project on another portal (works fine). My problem comes in when I click on a note from the notes portal it gives me the following message: " this operation could not be completed because this layout cannot display the result." I'm attaching a sample database. the error is on the "projects" layout with…
-
- 4 replies
- 3.2k views
-
-
Hi, Im sure many peoples facing this problem. we will get the alert message by editng the particulat record when someother user doing the edit with the same record on other layout. Please tell me the possibility to modify the single record more than one user on multiple layout at the same time? I hope it could be possible to stop other users and do the edit. Thanks in advance.
-
- 5 replies
- 1.3k views
-
-
Hi, I have a value list which gets its data "from Field" "Allow editing of value list" is greyed out. Is there any way I can remove some of the values in this list? Thanks Ian
-
- 2 replies
- 1.9k views
-
-
I have an inventory table. It is the items of inventory only. There is no transactions of inventory bought (in) or use (out). As inventory prices change on purchase invoices the information is manually updated. I have decided I would like to track the history of prices. I have a child-table to hold the price and the invoice date. I need to populate the original purchase price field with the most recent entry in the portal. Other fields on the layout reference the purchase price field. I have related the parent-table to the child-table by a serial number on the parent-table. How do I populate the inventory record from entry on the portal?
-
- 1 reply
- 1k views
-
-
I took over an FM12 database and found a button ( see enclosed attachment ), when in layout mode, with a blue line down the left side and was wondering if someone could tell me what it is? I could not find anything in the help.  Dom
-
-
- 3 replies
- 927 views
-
-
Just like in a date filed you can have it that you click on the data entry box and a calendar pops up, from which you can choose a particular date, in a number filed, is there a way to get a calculator to pop, so you can calculate the value you want to put in the data entry box as a plain number?
-
- 9 replies
- 1.7k views
-
-
Hi All..! I'm new here as I just started in FileMaker (transiting over from MS Access) so I'm not familiar with everything. I'd like to ask about possible solutions to a problem I am having with value lists. Here goes ... Table 1 -- "look_Category" Field 1 -- <pkID> (Serial Num.) Field 2 -- <Category> (A list of financial categories: "Firm," "Product," etc.) Table 2 -- "look_Product" Field 1 -- <pkID> (Serial Num.) Field 2 -- <fkCategoryID> (Relationship with pkID in Table 1) Field 3 -- <Product> (A variable list of financial products: "All Cap Growth," "Fo…
-
- 2 replies
- 5.8k views
-
-
I have attached a image that shows most of the URL i need to view  BUT, I do not want to scroll right and down.. Is there a auto sizing technique? This image typically is 4 x3 down or 12 blocks my client like to see in a window Thanks
-
- 1 reply
- 1.2k views
-
-
I have a portal on our tuition bills that show all payments, one per line. The number of lines in the portal can increase, for a few parents, to more than fits on a page. Any ideas on how to continue a portal on a second page (like first 25 receipts come out on page one and the rest on page two)?
-
- 2 replies
- 1.2k views
-
-
The "no fill color" option when applying conditional formatting to text does not work. Instead of making the text transparent it makes the text white. In the past I have worked around this problem by simply making the text the same color as the background. Unfortunately in my current solution the background is a photographic image so the workaround does not work. Does anyone have a trick for dealing with this issue?
-
- 4 replies
- 4k views
-
-
I am a newcomer, but am making progress, I hope. At any rate, I am trying to use a portal to display line item records that include a unique reference number, a short description (40 characters or so) and a much longer explanation that reads more like a note field. Each explanation typically has anywhere from 150 to 400 characters in the populated field. I would like a portal that allows me to add records, much like an invoice item, and then display the short description and long explanation field in their entirely in a wide line item portal format, which I assume will require much taller field boxes to display the contents in their entirely on an 8 1/2 x 11 size page. Is…
-
-
- 3 replies
- 1.5k views
-
-
Hello I have a subsummary report with a main group and subcategories. Some main groups only have one subcategory which is the same as the main group. Other main groups have up to 4 subcategories. Is there a way to hide the subcategory line for the groups with only one subcategory which is the same as the main group? If it were a pivot table in Excel I would just close the row. Thank you
-
- 2 replies
- 1.3k views
-
-
Is there any way to script the deleting of layouts and tables, or must it be done manually?
-
- 10 replies
- 1.3k views
-
-
Hey everyone. I hope this is the right place for my questions. I've recently upgraded from Bento as there's a lot more I wanted to do with my database. Now, knowing what I want to do and being able to do it are two completely different things! So, I have a small (c.1,000 entries) database for my video game collection. It's flat file and contains all my hardware and software. I use forms which only display the relevant information for each item (info for hardware is dramatically different for software) so while I know there will be some data redundancy I don't think it's too big a deal on such a small database. To dip my toe in the water of FM I want to make it so…
-
-
- 5 replies
- 2.1k views
-
-
Hi, I have searched around as I thought this would have been asked numerous times, but couldn't find what I was after. I have a field that stores a 0 or 1 depending on whether there is a related record elsewhere. The button take you to that related record and associated layout. I want to disble the button if the field contents is 0 (no related record). I thought I might be able to use conditional formatting, but there's no 'disable' option (which would be nice). How do I do this please? Thanks, Steve
-
- 3 replies
- 3.5k views
-
-
This must be so elementary I can't find anything about it in the forums. Forgive me, be as tolerant as you can ... I've got FMPro 12; on an iMac. I've made a database of about 2000 people ("A"). And I've got a file ("B") of portraits of about 250 of them. I have a button in A: it uses the ID of a person to find an entry in the portraits file B. All that works fine. Two problems: 1. It would be good to grey out the button if the person hasn't got a portrait ---saves time, and is considerate to the user. How do I do that? 2. Some of the people in A have got more than one portrait in B. My working button finds the …
-
- 2 replies
- 1.7k views
-
-
I am trying to create a filtered value list based on a property from a related table. The first table is Products. The second table is Customers. I want a value list on the customers layout that shows only the products associated with that customer's SIC Code. There is a field in the customers table that lists their SIC code. For purposes of this solution, there is only one SIC code per customer. I want a value list that will show only the products from the products table that have the same SIC code as the one shown on the customer's layout. I won't bore you with the 200 approaches I have taken - I'm sure I am missing something basic, I have just been looking at the …
-
- 2 replies
- 1.1k views
-
-
i have this portal with 3 records with checkbox box on it and a droplist field for that portal what i want is to show only portal records with checkbox ticked for example if i have 3 records photos, documents and files. If it ticked photos and documents in dropdown list it should be photos and documents only
-
- 9 replies
- 4.7k views
-
-
I am using FM 12 Adv Since my membership application was started, I have stored the version number as a global, calculation (so that my import will not over write it). As I release a new version, I just change the value of the "Version" field.  Today I updated from version 1.48 to 1.49 and to my surprise even though the Global::Version field shows 1.49, on my layout it says 1.48. How can that be?  Shouldn't my layout say 1.49???  Â
-
- 8 replies
- 1.1k views
-
-
Hi all, FM 11Adv for widnows here I have a checkbox list such as: Apple, Banana, Orange, Lemon Now, I would like to add another text value to each selected value of the checkbox, in real time. So that when the user select "Orange" in the list, there will be a Custom dialog box that will let her to insert an adjective (i.e. "Good", "Bad, "tasty" or whatever she likes). Finally, I would like to report in a second field the combination of checked value (from the checkbox) and the free adjective I have let the user add, to have: "Orange good", "apple Bad", "lemon tasty" etc... I am trying to play with triggers so that the custom dialog box pops up as far as a val…
-
- 5 replies
- 1.5k views
-
-
I am using FM 12 Adv. I haven't seen a question about this so maybe I am the last person to get the memo. I have a layout. I have set Status OFF, Toolbar off etc... Yet, the layout still shows the '+' '-' buttons that let the user adjust the 'zoom' Question, is there a way to shut that bottom toolbar off??? Thanks
-
-
- 4 replies
- 1.2k views
-
-
Hi, How can I extract the following Values where the "x" is the check box in the value list: Apples x Grapes Oranges Pears x Lettuce x Cucumbers Pork Steak Flowers x Brown Rice I want to auto populate a second field ( below ) with only the check item from the value list ( above ). Grapes Lettuce Cucumbers Brown Rice Thank you. Tom
-
- 6 replies
- 1.2k views
-
-
Hi, i'm creating a presentation of IDC-10 for myself, but can't make it work. I would appreciate all the help. I've this table, which has in the first row the IDC-10 code (CIE10) that matches the diagnosis description in the second row (DX) I've create this presentation, and use list to select data, so when i select in the DX list i will like to automatically put the matched code in the CIE10 field. Thanks IDC10.fmp12.zip
-
-
- 7 replies
- 2.2k views
-
-
This question could as easily have gone in ESS or FM GO, but this seemed like the place. I have a portal in a FM Go iPad layout. It displays records from a related products table. The products table is a SQL ESS table. The relationship is defined by two global fields in the interface file which relate to a "locationID" and "categoryID" field on the product side. The product table has a field named "productID" which is not a primary key and is not unique. The primary key is named "entryID." So, in products you can have records such as "entryID: 100, product: widget, version: widget 1.0, productID: 500," …
-
- 0 replies
- 1.1k views
-
-
I have 2 tables Members->>DES DES is a portal on Members. I have a report based on Members in which I need to pick off the top row of values in DES. (It is sorted Descending by Date) In my report, when I specify DES::Date, I do not get the top row of the portal. I think I can set up a 'scratch' field that will hold nothing but the current date and write to it when I input the date, but the question is "Is there a simple way to make FM recognize the top row of a portal and when the report sees DES::DATE it pulls up the TOP portal row DES::Date?
-
- 3 replies
- 889 views
-
-
I'm trying to find a way to use the "Self" function in conjunction with conditionally formatting on tab panels to create an aesthetically pleasing yet simple way to show users which tab panel they have selected. I originally tried adding conditional formatting to one of the tabs using the calculation: GetLayoutObjectAttribute ( Self ; "isFrontTabPanel" ) Unfortunately, this does not work. However, when I replace the Self function with the actual object name it works! Am I not understanding how the Self function works or is this a gotcha with Layout Objects? Reading through the tech docs on the Self functions makes it seems like this may only apply to Fields and…
-
- 2 replies
- 1.7k views
-
-
I am using FM12 adv in windows  The situation is pretty simple but I find it perplexing. I have 2 tables: Members and DES  Members-->>DES  DES is a portal on Members  I wrote a script that deletes a potal row in DES but when I run debug it clearly shows that despite using 'go to portal row (first) when I look at the values in what I think is the first portal row, I am actually getting the values in another portal row.  How can this be?  BEFORE The Delte Script   AFTER / During the Delte Script: Â
-
- 1 reply
- 1.4k views
-
-
Hi everyone. I’m trying to accomplish a conditional value list and I’ve been working with a few sample files I have (I still don’t get the whole picture of how it works, I always miss something), and I’m stuck (once again, lol). The idea is: Meeting Holdings Companies Executives Is going to take place a meeting where some executives may go. That depends on what Holdings (not single companies) are going to be represented in the meeting. I need to condition the Executive value list to the Holdings they are in. I attach my sample file. Thanks in advance. Conditional VL Join Tables.zip
-
-
- 9 replies
- 1.9k views
-
-
I have a layout, LayoutOne. I made a duplicate of it LayoutOneCopy. I made changes to LayoutOneCopy, and now I want LayoutOneCopy to be my new default layout. The problem is, all my links, scripts, etc. say Go To LayoutOne. If I rename LayoutOne to LayoutOne-Old, all the scripts make the change. Is there a quicker way to have all the scripts reflect the new layout name rather than going through each individual script and link? Thanks!
-
- 1 reply
- 937 views
-
-
I have a pop-up menu that displays standard ad sizes for specific publications. "Allow Entry of Other Values" is activated so that users can put in a special size when appropriate. If someone puts in an "Other" value all is fine. However it seems that this disables the value list for that record. i.e. if someone enters an "Other"value and then changes their mind and wants to use one of the standard ad sizes from the value list, it can't be done except by typing the name in the "Other" dialogue box. This is not effective if the user wants to review the available options. Is there a way to ensure that if the "Other" value is deleted, the original pop-up menu is re…
-
- 2 replies
- 1.2k views
-
-
Sorry if "Portals" is not the correct forum for this question (For some users, that's better important than help us) maybe belongs to Scripts I have a layout with some portals to calculate a Statement, and I want to have scripts to add new portal row to an especific portal. The original layout is named "Enterprise" The portals shows info from "Statement" Table This is the script for the "Sales" Portal on "Enterprise" layout: Set variable [$StatementID; Value Enterprise::Statement_ID] Go to Layout ["Statement" (Statement)] New Record/Request Go to Layout (Original) Go to portal row [Last] Set Field [statement::id_edo_result; $StatementID] it works, but…
-
- 2 replies
- 2.5k views
-
-
Hi, I have a wholesaler contact database in which I use a portal that points to my document database. Among the document database, I have a field named "expiration Date" the premise is that one of these documents, and there can be many, in the portal is a license, and that license expires. The expiration date field which is within the portal is only populated if it is a license document type (using a "document Type" field). How can I take that experation date and show it on the top of my form (outside the portal) so as we browse through the records I can see the experation date of the company's license.
-
- 2 replies
- 1.1k views
-
-
Hi All - Up until FMPro12v3, I used a little trick in order to create a custom sort order in value lists that were derived from field values... I would define two fields in the table in which the field values lived....one for entering a number(Position) and one calculation field(SortBy) that stores a quantity of space characters equal to the number entered in the Position field. So, if the number 5 was entered in the Position field, 5 spaces were in the SortBy field. I would then define my value list to use values from a field, select the actual field that I wanted to display and then select "Also display values from second field" and select the SortBy f…
-
- 2 replies
- 1.2k views
-
-
Hello all, i had build a database for one of my sales reps. im testing the database just with him. the database is on his laptop , not server hosted. basically the database has one portal where the sales rep put the items the customer is ordering, then when he sends to print the purchase order the database sends an email (client email) with a pdf attached. now he is telling me that some records has no items on the portal ( not all of records) , but the record is in there with the customer name date of creation and everything except the portal records( empty portal). the strange thing is that the pdf i got from him of all purchase orders are perfect , all rec…
-
- 3 replies
- 1.1k views
-
-
Hi folks, I'm a filemaker newbie doing my best to develop a personal rental property management database. I have quite a good understanding how conditional pop-up menu menus work after watching several tutorials online. However I'm unable to figure out the task at hand. I'm looking to the following. In the tenants layout I choose an apartment number (via a pop-up menu through the relationship with the apartments table) that the tenant wishes to rent. Once that apartment is considered "rented" I would like that apartment taken off the conditional pop-up menu. Any help/clues would be greatly appreciated. Thanks
-
- 2 replies
- 2.3k views
-
-
I have created several layouts - apparently successfully and they display and work OK - but suddenly, when I proceed to edit the layouts, the theme background and margins are stuck at a position much narrower than the displayed width and and I can no longer drag it to change it. I can drag the length up/down OK but the width is stuck (see attached screenshot) Â This used to work fine but has recently got stuck. Â The layouts still seem to work OK but the editor has this problem. Â Â
-
- 1 reply
- 2.9k views
-
-
Hello Everyone, I was wondering if it is possible to make a field show a different value list based on the outcome of another field. For example, lets say I have a drop down field that contains a value list of "Books, CD's, VHS's, DVD's" and then another field that shows a drop down list that would be unique to each one of the values in the first field? Thanks in advance for any help!
-
- 1 reply
- 909 views
-
-
I have a form which has two seperate fields ( Fruit1 & Fruit2) and I would like to create a value list to show both fields...for example: Fruit1 might have values of Apples, Banana, Grape Fruit2 has values of Lemon, Mango I want a value list when the field is selected to show all 5 as a selection: Apples Banana Grape Lemon Mango Any thoughts?
-
- 2 replies
- 1.5k views
-
-
Hello FM Gurus From starter template Contacts.fmp12 , can someone please tell me how to change background color of a tab panel without changing the header? When I tried to change the background on the tab control, the header "work address" changed as well. attached is the sample file Thanks in advanced y'all Contacts.zip
-
- 11 replies
- 4.8k views
-
-
I have a layout with a set of tabs that are not visible to the user. I would like to apply condition formatting to a button when a specific tab is selected. So for example, I have a "notes" tab and a "calendar" tab. When the user clicks the "notes" button it take them to the "notes" tab. I would like the color of the button to change so it's clear to the user what they have selected. On a side note, I am sending the user to the tab as by assigning an object name to the tab and then using the "go to object" script step. Is there a newer/better way to do this in FM12?
-
- 3 replies
- 1.8k views
-
-
This is a tough one.  I have a Membership application.  I have a popup that works. (not the problem). Part of the data I collect on each Member is if they are "Active" or "Inactive" (Members::ActiveInactive) To that end there is a Members::ActiveInactive field that holds the appropriate "Active" or "Inactive" value.  My tables are :   I have a layout based on Meetings. on the left side of the layout there is a portal based on: MemberMeetingJoin . This holds the members to show at a particular meeting.  On that portal there is a field: KF_Member which is a popup that grabs:              MembersTOC::KP_MemberID and Member…
-
- 2 replies
- 1.2k views
-
-
Hi there, I have a customer layout in my solution. there is a button to create a new customer. All was working fine, then just recently, wWhen clicked it inserts a random address, city and state. These are not calculated fields. Just started. Dave
-
- 4 replies
- 1.1k views
-
-
Greets, all: Â Here's what I'm trying to do (please refer to the attached): I have a portal via a self-join with the current table that stores addresses. What I'd like to happen is that the address in the current record (on the left) be highlighted in its related record in the portal (on the right). Obviously, this uses conditional formatting but the I don't know how to set up the calculation; at first I thought that the key field could be used to compare the current ID in the current/parent record to the child record in the portal, but nope, that's not it since they share the same fields. :S Â I'm sure it's a simple calc, just that I can't think of it. (Being old sucks…
-
-
- 4 replies
- 1.5k views
-
-
Hello, I am reading on the forums here and I cannot seem to wrap my head around dynamic value lists in the way my search is set up on my layout for my db. My database consists of multiple tables, only one is significant in my question. My table designated as "main" contains the following relevant fields parental key: pk_main field 1: Last name (text) field 2: first name (text) field 3:Full name (calculation=last+first name) global field: Patient search On my layout I have every letter of the alphabet displayed as a button. When I click it it searches the first letter of the patients' last names and does a find. It works great. I have a global field th…
-
-
- 7 replies
- 1.7k views
-
-
hello im still confuse how to use smtp can some give me a sample layout how SMTP works and send email with attachment
-
- 1 reply
- 1k views
-
-
I'm used to seeing the icons in Filemaker and know they each mean different things (coffee cup, spinning beach ball mean the server is busy, hourglass or butterfly means something is busy on your local machine). But recently, I think since switching to FileMaker 12, we also get icons of double headed arrows -- sometimes pointing both up and down, sometimes pointing both left and right. What do these mean?
-
-
- 5 replies
- 1.7k views
-
-
In my database there are 2 tables: 1 named "Project" with "project id" and "project name", and the another table for "Statement", related by "project id" field I need to have portals like this example image: To have input fields that i can type any information, input dropdown fields, and a button to add new records to the portal. http://1.bp.blogspot.com/-8N4sZht1XQc/UhTmArnkkUI/AAAAAAAAAJM/msslQlA6oZM/s1600/portal-dropdown.bmp I dont own the Data base from the image, not sure if the fields shown in the portal are from only one or many related tables, buy I just wanna know how to do it (input fields and dropdown) to try it on my database.
-
- 1 reply
- 810 views
-
-
Hi everyone. New here, just trying to see if what I am trying to do in filemaker is possible, as I am pretty novice with the software. So I have been working on a banking database for a student deposit program for a financial literacy program for schools. The database stores student information such as the school year and the corresponding grade, homeroom, and teacher for that school year. This is all identified by a bank ID # given unique to each student, and I use that as my primary key. We are coming up on the second year of the program, and I need to update these records for the new school year, grade, teacher, and homeroom for these students, as many of the…
-
-
- 6 replies
- 1.5k views
-
-
OK. I have two files one with GUI and one with the data. Now I want to make value lists but both files seem to be able to create the same value list in their own file using the table occurrence there but also can create a value list from the other file. Is it better to create the value list in the data file since it is closest to the real data? Or is it better to create the value list in file my people will work in, the UI since that is closes to them? When would I use the part that says "use value list from another file" and why would I use it? This is being set up where everything happens in the GUI file. I can find nothing in searching so the question is pr…
-
- 6 replies
- 2.3k views
-
-
I'm doing my first major project and experiencing a great deal of trouble with keeping my portals operating correctly. I'm an old-time FM developer, almost full time since v2.1, and understand fully how portals work in every version of the program from 3-11. It seems like there are bugs in the portals in v12. I have a field in a portal, I nudge it one pixel to the right or down, still within the portal visually, and suddenly it doesn't work any more... it doesn't repeat, and if I drag the whole portal, it doesn't move with it anymore. My understanding was, the top left corner of a field determines whether it is in a portal or not, and in FM12 you have to drag it into …
-
-
- 9 replies
- 2.5k views
-
-
I would like to apologize if I am not using the proper naming convention for what I am asking for help with. Until about a year ago, I was a PC woman, who had used Access forever. So, I'm having a little trouble with the same tasks or features having different names. So, please correct me! Here is my problem. My database (I'm the only user and it resides on my MacBook) is for my art supplies. I have my Primary Table, that pretty much holds all the data, related tables, and a few extra tables that I added (Vendor Table for example) for future use. My Primary Table is as follows: tblArtSupplies ArtSupplyID ProductCode ArtSupplyName ManufacturerID Me…
-
- 6 replies
- 1.5k views
-
-
I am trying to create a scenario whereby a check symbol (Container field) appears when the result of a calculation in a subsummary part is true. I have the check symbol field: g highlight, container, global I have a calculation field; container, The calculation is: when x - y ≠ 0; g highlight; "" (x & y are summary fileds) I have inserted this field into the subsummary line. It does not function as hoped? Is it because this calculation is in a subsummary part? Are thoughts? Thanks
-
- 9 replies
- 1.5k views
-
-
Lots of real estate is wasted on field name labels, especially in iOS. I'd like to see the field name label UNDER the field and visible only in Find Mode; in Browse Mode, the field data in this particular solution is self-evident. This is not what I want: I've been experimenting with conditional formatting with only frustration; I think I want a format that depends on the view mode but we don't have it. And, I've downloaded examples of solutions that others have designed, including the starter solutions, but haven't seen a resolution. Instead, lots of wasted space: Â I wonder if anyone else has resolved this?
-
- 6 replies
- 1.2k views
-
-
Hi everyone please help me i have a text field containing "my 18th birthday" i want this to convert in "my eighteenth birthday" thank you
-
- 10 replies
- 1.6k views
-
-
Hello , i would like to know why in filemaker 12 all the templates when they use portals, they use a field "ID MATCH FIELD" on the table , what is this field for? please let me know thank you
-
- 2 replies
- 2.3k views
-
-
Dear Friend, I have a solution converted from FMP11 to FMP 12 and i want to change the behavior of my Field Border as per attached pic. Thank you for your help. Kishan
-
- 6 replies
- 1.9k views
-
-
I have two tables. One contains color info (red, blue, orange, yellow, etc.). The other contains artwork info. What I want to do is put a table on the artwork layout that would allow me to assign certain colors to the different art files. The trick though is that I don't want it to create a new "red" record every time I assign a design red. More of like a lookup value type of table. Is this possible?
-
-
- 8 replies
- 1.4k views
-
-
Forgive me if this has already been asked, I looked and could not find anything realitive within the forums and not seraching via google either. I am also very new to FileMaker but have done a very large amount of research and study before starting my project so I do have a farily good understanding of the program. Just to give a better idea: I have a layout for client information and then a checklist(which is on a different table, same table as the portal also on this layout). The idea was you could check off one of the values within the checklist, the value would then autopopulate within the portal: Set up via "Auto-complete using existing Values". Along with th…
-
- 2 replies
- 1.3k views
-
-
Hi.. Sometimes i might have a larger width dialog log... once done... then all my dialog boxes are that large size.. even if FM is restart... Thanks
-
- 1 reply
- 784 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online