FileMaker Interface Features
-
Hi all, i've got a portal with a correlated container field, containing mp3s. Seems FM not seems able to play the multimedia file, i can see only the name of the file in the container. is it possible to playback the audio in the container? any suggest is appreciate. best regards Corrado
-
- 1 reply
- 1.3k views
-
-
Image 1 Image2 Image3 WorkerList field is a calculated field for which the calculation is : List(Worker::Name) All occurrences are sorted by the created time stamp (descending) as in the example in Image3 I would like the workerlist field to list in the order of workevents so in the example above (Mary,Eric,Ann,Luke) The only way I got it to work like that was by adding another sort for the Worker occurrence as illustrated below the bct field is a calculated field that gets WorkEvent::ct Image4 It works but it's sorting on a calculated field and it's certainly not ideal. Is there an easier way other than using SQL ?
-
- 33 replies
- 2.8k views
-
-
I am running Filemaker Server11 (standard) with Filemaker 11 Pro and Filemaker 11 Pro Advance. My company has asked to create a dashboard that will display information from with multiple databases. Some possible information: How many orders/value of orders that are still in house How many quotes were created and open (not booked) How many orders have problems Each one of those would come from a different database, however they are all linked together, Quotes->Orders->Problems. Any ideas how this might be accomplished? I'm at a loss on how I would do this. if there's a 3rd party software that can be customized I can research into that too. …
-
- 5 replies
- 3.9k views
-
-
Add New Record Button I have a portal on my Customer layout to display essential details of a customers Devices. Currently I can a new Device for a customer using the following method: Go to the last Portal Row Select a DevceType from a dropdown list (this creates a new record in the Devices table) I then click on a button (Edit) which takes me to the newly created record, now linked to the Customer table I then edit the Device record in full I would instead prefer to have a Add Device button: Click add device This creates a new record related to the customer from where I clicked the button Edit the Device record in full. In this manner I can then have the…
-
-
- 2 replies
- 12.6k views
-
-
hello everyone, in my format I have set a popover through which you can create new records, and in this case, enter the identity of new contacts (name, surname). my problem is when I want to see the new contact in the portal of the format ... portal remains empty even though the records are properly stored in the related table. you will find the file attached in order to have a clearer overview. popover data entry.fmp12.zip
-
-
- 1 reply
- 1.6k views
-
-
We have came across many scenarios where we want to,get a filter of related records inside a portal as per our need or our requirement,We want advance search in portals like, Example:- Suppose we want to get all names in a portal starting from the word "Z",or any phone number having this code 111 as the starting point. This can be easily achieved,we are going to describe the steps by which one can implement this mechanism of advance or instant searching in Portals,Please have a look below: Let us consider two tables: Customer Communication Information Create a Custom Function which will be used to segregate the word into a pyramid, Custom Function Name -- StackP…
-
- 1 reply
- 1.1k views
-
-
Hi, I am having a Javascript countdown game-clock (period's - minutes - seconds ) running in a webviewer. I need to retrieve (on button click) the period - minutes - seconds from the clock into Filemaker As far as I know there are 3 ways to get the data out: - use the 'Insert from URL' script step and filter the needed data out ( at a Filemaker button click ) - use the FMP URL protocol ( Javascript triggers a Filemaker script ) to 'Set' a field in Filemaker ( maybe each second ) - Javascript writes the period - min's - seconds as parameters in the URL each second ( a Filemaker script only fetches the data from the URL when needed - at a button click - ) I …
-
- 1 reply
- 1.3k views
-
-
I just grouped a lot of fields together in one tab and copied them as a formatted group. I then pasted the group into all of my other tabs within my tab control. When I click onto browse mode and actually enter in data, the data is transferred to all of the fields in my other tabs, not just the one tab I'm entering data into. How do I fix this? Do I need separate fields for every single tab??? Â Thanks!! Â
-
- 6 replies
- 3.2k views
-
-
Sorry, I´m absolute new to FileMaker. I'm trying to create a checklist like those found in collectible trading cards. Each record in my database has a collection of trading cards. Each collection has a different number of cards. So, when I enter the size of a collection, let´s say 127, I need Filemaker pro to create a checklist with 127 numbered checkboxes on the fly. I need the checkbox list to be functional, that is, when I click an a checkbox, it performs a simple inventory calculation. Is that possible? I hope it is! I speak Spanish, sorry, if I didn´t explain myself correctly let me know and I will try again. Thanks! Enrique
-
-
- 7 replies
- 2.4k views
-
-
I'm still waiting patiently for actual Tick boxes! 29 years and counting!!! Come on FM14 you can do it baby!!!
-
-
- 16 replies
- 4k views
-
-
Alright, it's simple. I have a solution for newspaper delivery. I have 3 tables: location, client and dropData. Location is information about the place to put newspapers (e.g. Bob's corner store, Yummy Pizza Shop, etc), client is each newspaper (Herald, Express, etc), and dropData is how many copies to deliver. I've got location and client related via a locationID, and dropData and location related also via a locationID. Then I've got a report for the delivery person that shows location records, sorted by route (multiple routes per person). I have a portal on each row showing only the dropData for each newspaper, but I can't for the life of me figu…
-
- 8 replies
- 1.4k views
-
-
I have a simple FM 13 db with lists of Insurance Agents and the percent commission they make for each policy. This was previously an MS Works Mail Merge. Â I easily got the company logo and address into a layout and am able to filter (FIND) on a PayDate for those agents earning a commission at say the end of the month. I can also get each Agent's SubTotal and the Preview looks great for the letter I would send to each agent with their commission check. Â I run a report (Script) based on the PayDate and my have 30 agents getting paid. Â The "problem" comes in when an agent has enough policies that that more than a one page letter is generated. Each page has the co…
-
- 2 replies
- 1.2k views
-
-
This is a bit complicated to explain but here goes: As you can see in the picture attached, I have a table with container boxes all along the right side. I currently have a script attached to those container boxes that says OnObjectModify - Perform this script. The script basically exports the container file, then goes to the related record in the related table and executes further actions. Heres the problem, everything works great, as long as the portal row has been (selected) (you can see this in the picture attached as its a bit darker) The portal row selector must be the same as the container field I drop my doc into. For me this works great but for the whole o…
-
- 1 reply
- 1.1k views
-
-
I've got a situation with value lists that I'm trying to find a "simple" solution for. I have a table of records...300,000+ records. I have two fields of interest, Code1 and Code2. Code1 is a general filter and Code 2 is a more specific filter that has values that ONLY occur for Code1. Code 2 is a child of Code1 Example: If Code1 = A then Code2 will only be Red, Blue, Green OR If Code1 = B then Code 2 will only be Alpha, Beta, Gamma. This is inherent in the records. I need to search for specific Code2 values but I need the value list to be filtered by a Code1 selection, otherwise my Code2 value list from field values is TOO long and non-nonsensical. I'…
-
-
- 4 replies
- 1.8k views
-
-
I have a portal that displays multiple fields from 2 separate Tables. The portal is associated with table TDL The portals first 3 fields are associate with my main database table BWI, and the portals last 3 fields are associated with the table TDL. When I delete Items from the table TDL they aren't deleted from my portal. Thoughts? Thanks Matt
-
- 1 reply
- 870 views
-
-
I cannot figure out how navigate between tabs in Browse mode. I set up two fields in each tab (they are the same fields), and when I click on Browse, I can switch between tabs, and more, if I click on the front tab panel,a field from another tab nested behind it shows up! What am I doing wrong?? Â Â
-
- 1 reply
- 1.4k views
-
-
Greetings. I am new to the Forum and look forward to your help. I am using the Surface Pro Tablet while I am in the field - I am using a cloud hosting server - to complete reports. The issue I am experiencing is when I open the table/form, the screen does not size properly and I am forced to use the Vertical/Horizontal scroll bars. I would like for the table/form to size correctly so I can eliminate the sliding bars. Any help would be greatly appreciated.
-
- 1 reply
- 2.2k views
-
-
I have several applications where I would like the FileMaker server to act as a web proxy. In other words, I want to grant access to some private corporate web sites that only the filemaker server itself is allowed to get to (controlled by firewall). From what I can tell the web viewer works from a client perspective meaning that whatever URL is set in the web viewer is reached directly from the client rather than from the server. What I would like is for the FileMaker server to be able to set itself as a proxy address for anything viewed through the web viewer and then run a proxy in the background that permits any filemaker user with the correct permission to use it.…
-
- 1 reply
- 3k views
-
-
Hi All, Please be gentle. New to filemaker and FM forum! Did a search and didn't see any items on this! which probably tells me I have gone down a dark lonely road here! This is my first FM database. I have setup a layout with a list of items. I want to see the list, select a row and view detail of a selected item on the same layout to the right ( in pro at least). I elected to use the method I had seen posted somewhere along the lines of creating a global selected field in the principle TO for the sibling TO. For example : a customer has many orders. The detail is then presented to the left of the portal list. I have a slider with portals in each panel base…
-
- 2 replies
- 1.2k views
-
-
Hey all, I'm trying to find a way to insert a page break BY record. That is, mark a specific record in some way, and say no matter where that record falls in the layout, break the page afterwards until the next record. I've played around with a "break field" and sub summary parts a little bit but I can't seem to make it do what I want. Also, I don't want any of this mechanism to be visible when I print. Any thoughts? Thanks, -Andrew
-
-
- 14 replies
- 1.9k views
-
-
We have a message in the database that is sent out to end users at certain times. Filemaker used to properly format the line break tag <br> at the end of the lines where it was needed. Now it sends them along in the message which is confusing a lot of our non-technical users. I have removed them but now the message is not properly formatted and comes in on large chunk of text. Has anybody experienced this as well and have any advice for a solution to restore formatting the way we would like? Thanks in advance.
-
- 0 replies
- 1.6k views
-
-
Hello all: I was wondering if someone can shed some light on the SnapShotLink script step. I was able to create a SnapShotLink to the Temporary Path and send it in an email. All fine and good. Now the problem. When I open up the SnapShot file it opens up to a very small window which just happens to be the same size as the floating menu pallette I created when a user first logs into the database. Question : Is there any way to preserve the original window size of the SnapShotLink when it was created? Hope that make sense. Dom
-
- 2 replies
- 1.3k views
-
-
On a customer layout we have a portal displaying the names related contacts. Each portal row has a popover button on it that when popped will give the operator more detail about the contact. The addition of a new related contact is scripted. It sets the customer id in a variable, flips to a contacts utility table, creates the new contact record, sets the customer id from the variable and then flips back to the main customer record. Using the go to object step I'd like it to pop the popover from the newly created record. Instead it always pops the popover from the first record in the portal. I've tried Go To Last Portal Record and then pop. I can't seem to …
-
- 3 replies
- 1.7k views
-
-
I am creating a pop-up menu list from a calculation within a table. For some reason the value being displayed is always showing twice. Would someone experienced this problem before ? Pop-up menu (double).tiff
-
- 2 replies
- 1.5k views
-
-
I’m working in a database that needs to be moved to the top of the display when a certain layout is entered. Obviously I’m using a OnLayoutEnter trigger to call a script including the step Move/Resize Window [Current Window; Top: 0]. Unfortunately, this doesn’t work reliably because almost every user has a multi-display setup and places the database on the larger (not necessarily primary) display. So, when it sets the window top to 0, it uses 0 from the primary display, which is only very rarely identical to 0 on the display where the window actually resides. Anyone have any bright ideas for moving the window to 0 on the relevant display? (Note: cross-platform, FM…
-
- 1 reply
- 1.5k views
-
-
I tried using "IsEmpty(Self)" as a condition in the Hide Object section of the object inspector but it does not work (it always hides). Am I missing something ? P.S. If you are wondering why I want to hide something that is actually empty it's simply to "disable" the button of this object. Of course I can use "IsEmpty(TableName::FieldName)" as the condition but certainly more painful when you have a lot of objects to hide .
-
- 9 replies
- 5.2k views
-
-
Hello, I have created a database with a bunch of patients. Each patient has a unique hospital number put on their charts. This number is usually assigned to them once they are registered in hospital. In some cases we like to keep track of people who donate bone marrow to another patient and they want to remain anonymous. In this case, we would put a "dummy" number in the hospital number field. I would like to make a value list of a bunch of dummy numbers that would come up in a dropdown for patients with this case. This is very easy as I can make a value list but my problem is that I want the dummy numbers to be eliminated from the value list once used, that way …
-
- 6 replies
- 1.3k views
-
-
I have page numbers inserted into several layouts in a text box in the form "Page {{PageNumber}}" Since installing FMP13, all of my page numbers have started printing out in the form "Page $1.00" I've never had this problem and I'm sure it is something very simple, but I just don't see how to return it to a simple page number (e.g., "Page 1"). Any assistance would be greatly appreciated.
-
-
- 2 replies
- 1.5k views
-
-
I'm trying to find a way to format the browse screen. In other words when I allow the layout to show a browse mode it takes up the entire screen, is there a way to lets say have a browse of a table show up within a box on the layout as opposed to the taking the entire screen? Or is it possible to have a browse show up in a popover? Thanks Paul
-
- 4 replies
- 1.3k views
-
-
Hi, I have a portal set up on a layout for Table A, which shows records from Table B. In the portal records, I am also displaying fields from Table C, which is related to Table B. When I export records from my source layout (Table A) to Excel, I get one row for each record in Table B, which is great. Exactly what I want. The problem is that the Table C fields from each portal record are all blank. Is there no way to get that data to appear in my export, since it is two steps away from the source table? Thanks!
-
- 2 replies
- 4.3k views
-
-
Looking for the proper syntax for a script for button that I have created with a Popover. Once they click on the button it will create the records that they have entered in the field, but first I would like it to check if that record currently exists. I'm just trying to figure out the proper way to reference the fields along with the lookup and return error if the record exists. Also I would like to create error checking to see if they click off from the popover the popover will ask do you wish to cancel this record or create and then clear the proper variables or fields when they go in again. Thanks Paul
-
- 2 replies
- 1.3k views
-
-
I created a solution in FM12 using pretty much a stock theme. When opening the solution in FM13 the fonts and layout haver gotten somewhat larger and now the layouts requires scrolling to acess the complete layout. (this is on Windows). Â
-
- 14 replies
- 3k views
-
-
Hello everyone, I am familiar with using Popovers, and have implemented them into many solutions so far. I am experiencing some strange behaviour in that the popover buttons do not display on iPad... they work fine on Mac, PC, and iPhone, but are completely missing from iPad... Any help would be greatly appreciated. Thanks in advance!
-
-
- 3 replies
- 1.5k views
-
-
I've got a line items report showing sales for a quarter, summarized by County. I'm trying to figure out how, on this same report, to show a count of invoices on the subsummary part as well. Invoices are parents of Line Items. Don't know why I'm blanking on this. I feel like it should be pretty simple. Any ideas?
-
- 2 replies
- 1.9k views
-
-
Wondering if anyone else finds this really frustrating: when working with any layout wider than the printable area, I cannot move an object outside the print margins with the mouse. I have to use the right arrows, and that is so slow!
-
- 1 reply
- 809 views
-
-
Hi, I am new to the forums so firstly thank you for the fast amount of information on this forum and apologies as I know this topic has been covered to death. However, I am struggling to make heads of tales of it. I also apologies for my wording in this post as Im sure I will not use the correct terms to explain myself. Please bear with me. I started to create a database and teach myself by watching tutorials and reading forums. I have made some blunders along the way and I am probably going to have to abandon or heavily modify what I have already got going. In lieu of this I have just made a new database to help myself clearly understand how relationships wo…
-
-
- 17 replies
- 2k views
-
-
Hi,  I would like to know if I can remove the "Filemaker Preferences" in my custom menu.  I've created a menu set with no actions � completely blank.  However, I still get the "Preferences" and the "Help" ??  Is there anyway I can remove them.  Please see pic.  Thank you.  Tom
-
-
- 6 replies
- 4.8k views
-
-
To better control the database table navigation I've chosen to hide the toolbar. I've been able to recreate most of FileMaker Pro navigation functions. However, there are places where I would appreciate to get help. I've attached a filemaker sample of why I've done so far. If I want to go to record number 5, I type 5 in the edit box. However, I always have to double-click in the edit box to highlight, clear the number and enter the desired record number. Is there a way for not having to double click. I.e As I am entering the a number the action occur. Also, when entering "Firstname" in search, there are 6 records which are found. A little round green image app…
-
-
- 5 replies
- 1.6k views
-
-
Sorry this relates to FM 11 Pro, I couldn't find a place to post about FM11. I've had this issue for ages and want to resolve it as it's a right pain. I have a DB with various drop down menus, when connected to a second monitor but displaying on the laptop screen some of the drop downs work, some open the actual list on the second screen and some just open the drop down arrow and never open a list. These have all been created in the same way on the same version. Their performance is always the same i.e if it opens it always opens and if it opens on the second screen it is always on the second screen. As soon as I pull the secant monitor the menus return to normal…
-
- 0 replies
- 1.3k views
-
-
I'm trying to use fusioncharts XT to display a pie chart in a web viewer. I'm having trouble specifying or loading the javascript files to create the chart. Has anyone had any success or experience with the new funsioncharts? Thanks
-
- 0 replies
- 1k views
-
-
First time on the forum in a good while. I'm trying to rejuvenate a hire bookings database which has had several people working on the development in the past and is a bit of a mess. The main "dashboard" layout has two portals on it, which list orders due to be dispatched, and orders which are out on hire and due to come in. Each of these is accessed via a relationship, with a "start date" field in the dashboard table relating to either the date out or date in field of the orders. The main irritation at the moment is that, because there are two relationships going on, there is a lot of duplication which seems needless. (Things like conditional formatting rely on fie…
-
- 3 replies
- 1.3k views
-
-
I am attempting to import existing records from an Excel file and am having difficulty with the records showing up in the portal. I believe I have my parent/child relationship in line, and am using a script I found from another post: Set Variable [$DataTable ID; Value: DataTable::_kp_dataTableID] Go to Layout ["Initiative" (Initiative)] Set Error Capture [On] Import Records [ ] Replace Field Contents [lnitiative::_kf_dataTableID; $DataTableID] Commit Records/Requests ( No dialog) Go to Layout (original layout) ...however I am not having any success. Any help/suggestions would be greatly appreciated. Thank you PortalArchive.zip
-
- 1 reply
- 1.8k views
-
-
I'm pretty sure I already know the answer to this, but thought I'd ask anyways since I wasn't able to Google an answer... Is there a way to switch between different themes using a script? Specifically without duplicating a layout, changing the theme, and switching between the two layouts?
-
-
- 3 replies
- 4.7k views
-
-
Hi, all: I'm stuck. What I'm trying to do is...well...to save bandwidth, see my thread at FileMaker's site: http://forums.filemaker.com/posts/76d4f2428e (I tried to bump up the thread but to no avail.) Rather than set up four (Domain) tables, I'm trying to populate the data into one child table. Whether this is the best course of action, I don't fully know. I'm having trouble getting the field, HeadingNumber, to populate correctly when a user enters a value in its Data field. Also, I'm not sure I'm setting up the field correctly in the parent table in the first place: I have the Data (child) field in front of a portal box--the portal is juuuuust a bit larg…
-
-
- 4 replies
- 1.1k views
-
-
Hi I have a problem with sorting. I need this to properly create food labels. A certain product (e.g. chicken sandwich) contains several ingredients (Chicken, Butter, Tomato, Wheat, etc.). These ingredients have to appear on the food label in descending order based on their weight. Amongst others, I have a table called "Recipe" with the fields "Product Name", "Ingredient", "Amount in g". Here, I add all the ingredients of a certain product together with the corresponding amount (in grams) of each ingredient. There is also another field in this table called "Ingredient_Label_List_S", which is a statistics field that sorts all the ingredients of a product (e.g. …
-
-
- 3 replies
- 1.5k views
-
-
By default (inactive) my checkbox are grey. When clicking on a checkbox the block is filled in green with a black coloured X demonstrating a selection has been made. I would like to replace the X by something else. For example, having the block in grey for inactive and everything in green (no black) X would be just perfect. I have been using the inspector with many combination and have not been successful. Could someone guide me in where to look to fix this issue I am having? Thanks! Daniel Checkbox - selection.tiff
-
- 5 replies
- 1.9k views
-
-
We had been experiencing issues with users who use short-cut key sequences where they were duplicating records using ctrl-D when trying to put Filemaker into Find mode using ctrl-F.  Our simple solution was to establish a custom menu set where the Duplicate Record option was removed from the Records menu, and set this as the default Menu Set for the file. Shortly after this change, one of our users reported that she could no longer save or edit Saved Finds as these options were now greyed out. Returning to the particular menu set, we found that there was an option to add [saved Finds] as a menu item, and the Saved Finds icon on the Status Bar worked as it does…
-
- 0 replies
- 3.4k views
-
-
I have a database for my cabinet shop that has two fields: ACCOUNT & TASK. ACCOUNT is populated with a drop-down value list. TASK is a value list that only uses related values from ACCOUNT For example: ACCOUNT: Doors yields possible tasks of: TASK: Cut lumber, sand lumber, glue lumber ACCOUNT: Drawers yields possible tasks of: TASK: Install hardware, Install drawer Face, Drill handle hole. Is there a way to make TASK an editable field, i.e., when I click into task be presented with related values but also be able to add a value on ad hoc basis?
-
- 4 replies
- 1.1k views
-
-
I am currently updating a runtime solution that we have been using for 14 years, it is designed for crossplatform use. I am using Filemaker 13 advanced and doing my work on a Mac (Mavericks). When opening it in a windows enviroment the buttons/fonts look differently and aren't lined up correctly. I used fonts that are available on both platforms. I'm not sure what the solution is, I'm including screen shots as an example. Â Any help/ideas would be greatly appreciated. We are almost ready to roll out our solution. Â Thank you! Â Caroline Exception PC screen shot.pdf
-
- 2 replies
- 1.8k views
-
-
It's my understanding that the List function (across a relationship) should return a list of unique values. In other words, no duplicates. Apparently this is not the case. Instead I'm using Brian Dunning's UniqueValues CF to achieve this end. What's up with that?
-
- 4 replies
- 1.6k views
-
-
Once again I was playing around with slider buttons, trying out a method I 'd attempted in the past without success (although to my chagrin, I 'd forgotten I 'd tried it before...): Buttons go outside the panel, and the highlighted button is hidden or shown based on the current panel, triggered by a panel change. Should work wonderfully and it's the best way to implement buttons for sliders it seems...on paper...sadly. The problem is you need to refresh the buttons with each panel change BUT the onpanelchange scirpt trigger gets executed BEFORE the panel change, hence you can't program it to get the current panel name and if it is X,Y,Z hide the appropriate highlighte…
-
- 11 replies
- 3k views
-
-
I'm trying to use TinyMce in a webviewer in FileMaker but save the resulting HTML into a database field. I am aware of the standard practice of using an fmp:// link with a script & parameter, but that won't work in Windows (the html content returned as the parameter will likely exceed the 2048 character limit). I am using a javascript function to change the HTML DOM by putting the contents of the TinyMCE editor into another div on the page when the user clicks "Submit" inside the webviewer. However, when I use `GetLayoutObjectAttribute ( "webviewer" ; "Content" )` it shows the content of the unmodified (pre-javascript altered) page, not the page after javascript h…
-
- 4 replies
- 4.6k views
-
-
Just wondering if someone can tell me -- is there an easy way to locate "Named Objects"? I know you can show buttons, popover buttons and fields with script triggers etc BUT I can't seem to find an easy way to locate a named object without clicking into each object on the layout. Anyone? Thanks. Dom
-
-
- 8 replies
- 1.8k views
-
-
Is it possible to put a portal in a layout in database B that displays data from database A? I don't want the information to be editable from database B, just visible there. To (perhaps) complicate things further, the data I want to pull in and display is stored as a repeating field in database A. Possible or no?
-
- 3 replies
- 1.4k views
-
-
Hello, I am trying to create a bank statement-style report of a supplier statement. Basically, the statement will contain four fields from three related tables. The fields are: Date, Credit, Debit and Balance. One table is "Supplier" which contains a unique supplier ID, the next table is "Invoices", and the final is "Payments", all linked using the unique supplier ID. So, the data is stored like this: Date(Both Invoices and Payments table), Credit(Payments table), Debit(Invoices table) and Balance(summary field). But, I can't figure out how to get the information from the Invoices and Payments tables to show on my report. I have tried creating a new table call…
-
- 5 replies
- 5.1k views
-
-
Hi Maybe this is a bug, or just an undocumented feature... I set up a popover but it won't display the whole popover when there is a container below it that is within the space required for the popover - but only in BROWSE mode AND when the container is configured for interactive content. The popover gets a scroll bar instead. When the container is configured for IMAGE content it works It works in FIND mode, with either container configuration It works in WebDirect, with either container configuration It DOES NOT work in FMPro 13.0v3 Any ideas? Thanks
-
- 5 replies
- 2.1k views
-
-
I need a push in the right direction. I have a value list from a related table. All is well; however, most of the value lists contain numerous choices, but some of the value lists contain only one choice. Is there a way to automatically populate the field when there is but one choice in the value list? Thanks, Kevin
-
- 2 replies
- 1.2k views
-
-
I just created any database, kind of a simple database for keeping records of student test scores, grades and finally the result. I have a layout with portal containing the class and respective scores of a particular student. Please, how can I go about doing other calculations with these scores from the portal.. Like how can I get the total score of the student? Average score? What other use can the portal be to me in respect to dealing numbers and figures?
-
- 18 replies
- 2k views
-
-
I have a layout that you enter data in. As you enter the layout a script triggers to create a new record. Two buttons on the top "save" and "do not save" have scripts attached to them. "Save" takes you to the main layout and "do not save" deletes the newly created recorded and takes you to the main layout. Is there a better way to handle this? This layout is a form and the idea is not to see the other records created. Cheers.
-
-
- 5 replies
- 1.8k views
-
-
Hello! Wondering if anyone else has had this issue, or knows how to avoid it... I have a handful of color swatches I've set for labeling in color profile of Generic RGB. Problem is, when I select one of these swatches for conditional formatting, my GENERIC RGB get converted to color profile of DEVICE RGB. BUT!.. the opposite happens on when coloring items on layout, DEVICE RGB get converted to GENERIC RGB. I don't know which color profile to use, FMP overriding my choice and then contradicting itself! Is there a different color profile I should use, is there a setting somewhere to stop this?.. going bonkers! Why is this happening? Thank you fo…
-
- 0 replies
- 1.4k views
-
-
Hello, I would like to create a script when there is a field that is empty it's show a custom dialog. The only thing i'm struggling with is the blank row the portal creates. This the script i have: Go To Portal Row [select; First} Loop If [isEmpty ( article::Number)] Show Custom Dialog ["No Article";"No Article"] If [Get ( LastMessageChoice ) = 1] Exit Script[] End If Else If [isEmpty ( Article::Description )] Show Custom Dialog ["No Description";"No Description"] If [Get ( LastMessageChoice ) = 1] Exit Script[] End If End If Go to Portal Row [last] End Loop
-
- 2 replies
- 1.6k views
-
-
I have a layout which includes a Sub-summary part sorted by a text field named "Description" in the Line Items table. Thus, the layout sorts each sub-summary alphabetically by Description. With the goal of having more control over how the sub-summaries are displayed I have added a number field named "Line_Item_Order_Number" in the Line Items table. However, when I change the sort field of the Sub-summary part to "Line_Item_Order_Number", the Sub-summary does not even show up on the layout. Any ideas why? I'm using FMP Advanced v12.
-
- 2 replies
- 1.4k views
-
-
hi all,  I have 3 field (see attached for layout)  field 1 is a checkbox field 2 is a pull down field 3 is a date  field 2 and 3 are placed on top of field 1  the issue I have is the if I place a check on any of the option on field 1 I can no longer select field 2 or 3, if there a way around this?   Thanks RudyM
-
- 1 reply
- 999 views
-
-
One of the inspiring sessions I attended at Devcon this summer recommended this nice pack of icons as good for use with iPad solutions, so I went ahead and purchased them. http://www.streamlineicons.com I'm now realizing that I'm lacking some basic conceptual understanding of how to deploy these PNG icons in a Filemaker solution. If I "Insert Picture" to get the icon onto the layout I see that I'd need to actually store the icon in a folder somewhere accessible to Filemaker, which I'd rather not do. But when I use a copy/paste approach, the icon appears with a square white background -- not the 'transparent' effect I need. Is there a third option, or a wa…
-
-
- 2 replies
- 1.2k views
-
-
I have 10 different Layouts on the project am working.. I want to users to be redirected to a particular Layout each time They login... Sort of a default layout whenever users login.. Please, how do I make for example ''Contact layout'' the default layout?
-
- 4 replies
- 878 views
-
-
Hi, did something change ?. I have graphics ( eg logos) that I made into buttons and have the border change when the cursor hovers over it. I'm now unable to replicate it. In layout mode it no loger has the 'normal, hover, pressed, in focus' drop down, only normal. The existing buttons still work and I can turn a graphic into a button, but the hover thing isn't available Cate
-
-
- 2 replies
- 1.4k views
-
-
I am working on a Class project , which suppose to show the Class, the Classdetails and the Teacher incharge.. Thus, I have 3 tables, Class, ClassDetails and Teachers. The parent Table is the Class, while ClassDetails and Teacher are child tables.. Both ClassDetails and Teacher are related to the Class via the class id. (Classid to Classidfk of ClassDetails) and (classid to Classidfk of Teacher) my layout is based on Class table, with portal based on ClassDetail table.. Now, I want to use a value list from the field in Teacher table, so as to display the Teacher who is incharge of the class.. I have done all I could think of, the value list shows, but if…
-
- 3 replies
- 1.4k views
-
-
Hi,  FMP newbie here and I apologize in advance for a long winded post. I am creating an store signage distribution database. Basically what I'm working on is creating orders that contain lineitems of signs. Then each lineitem is shipped to many stores. Here are the tables involved:  sign_version - has a signVersionID store - Has a storeID order - Has an orderID line_item - line_items marry signVersionID and OrderID store_shipment - store_shipment marries lineItemID and storeID  *See item 1 in attached screenshot*  Everything work great until I'm working on the Store layout where I am trying to create a set of cascading portals. The first one…
-
- 1 reply
- 1.1k views
-
-
So I'm hoping it's not actually so complicated, but here goes: I have a value list called "Active Employees" that uses only related values from a field. This works perfectly. I'd like to create a new value list that includes all of the active employees as well as two other random values. These two separate values are not employee names and therefore I don't want them to show up in other places where I use the Active Employee value list. The goal here is to effectively combine two value lists. I'd be most grateful if someone can provide me with a workaround whereby I might incorporate these two additional values? Thank you in advance,
-
-
- 3 replies
- 1.3k views
-
-
Hi On the all units layout I have added some vertical lines to try to separate some of the data. However previously when I have added in separation lines and ticked sliding up based on all units and also resize enclosing part the lines displays only as long as the information that is in it. However this time the line seems to stay at a fixed length and I cannot see what is different this time. If anyone is able to have a look and see what I have missed that would be amazing. As i have spent an hour trying different things and they all result in the length remaining fixed. Thanks Sarah fully working 3.fmp12.zip
-
- 0 replies
- 875 views
-
-
Hi - Anyone know if is posible to disable the operating system toolbar to force users to use a script to close the solution. Thank
-
- 1 reply
- 884 views
-
-
Hi there, I'm a bit stuck with something and I'm hoping someone can shed some light on how to achieve what I'm after. I have a database with products and purchase orders. I have a global field that contains product id's in a list format. I am trying to work out how to take that values from the global field list and populate the purchase order line items (which are in a portal on purchase orders) with the list values. I need each list value to be inserted in a new portal row. The number of values in the list would vary each time the action is performed depending on which products were pre-selected. Can anyone help point me in the right direction…
-
- 8 replies
- 1.5k views
-
-
Using FileMaker Pro 13 I have a view in a SQL Server 2008 server that provides customer id (unique identifier), first name, last name, and full name. I have two tables in my Filemaker Pro database. One represents the external SQL view and the other is a local "customer sign in" table made up up customer id, customer first name and customer last name - and a relation to the table representing the view. I have a layout where the "Enter Name:" entry is a dropdownlist with autocomplete using a valuelist that pulls the fullname from the view. The autocomplete is working well. What I'd like to do is add "First Name" and "Last Name" fields to the layout and have them…
-
- 1 reply
- 3.3k views
-
-
Hello, I hope this is the best place to post this. I'm new to the forums, but have plenty of experience with older versions of FileMaker. I'm currently supporting a database based on FileMaker 6 / Server 5.5... You heard me. It's a rather long story, but the short version is that we will likely be redesigning the database from the ground up using FileMaker 13 in the near future. I'm in the process of researching some of the many new features that have been introduced over the years, and have hit a roadblock when it comes to designing layouts. We have many different devices, with a variety of resolutions (almost entirely Windows PCs), and I would like to be able to…
-
-
- 2 replies
- 2.2k views
-
-
Hello all, just have a small question I would love answered. Is there any real difference when you are hiding something and use... Hide Object When... vs Conditional Format (Text Size 500) Obviously in a summary or report field it should make a big difference to use hide when, but for just normal fields or values what is the better practice?
-
-
- 7 replies
- 1.9k views
-
-
Hi. I need the following. Say I have separate classes, like 9th grade, 10th grade, etc. In each class you have those students in a class. For each student you have the subjects they are taking. Something like that. If I want to click on the class drop down first (say I pick 9th grade) and the next drop down list should be the students in that class (not all the students). I click on a student and the next drop down has that students courses. I click on that and get that course to pop up on the screen. Something like this for giving new courses to a student in a particular grade as well. Click on grade, click on student in the grade and THEN click on all courses out of a …
-
- 1 reply
- 1.3k views
-
-
I've placed a popover button in a portal row. For some reason the popover is only visible in the first record of the portal. The button is correctly sized and placed within the portal boundaries properly. In a number of other portals I have this working but for this one portal it fails. Suggestions? There is also a portal on the popover. It seems like that's the issue.
-
- 3 replies
- 1.7k views
-
-
I'm a newbie and would like to use a a popover in the same way that I have been using windows in the past. I'm confused as to how to do this if the data I need is from a related table/record. Here is an example of a window that I would rather turn into a popover: In this the window is a new layout from a related table (That's actually a related table from an "external data source"). It would create a new record based on information from the originating record: New Window[] Go to Layout ["Event Details Admin Sui" (SampleEvents)] Show/Hide Status Area [Hide] Adjust Window [Resize to Fit] Enter Find Mode[] Set Field [sampleEvents::Event ID; Get(ScriptParameter…
-
-
- 8 replies
- 13.6k views
-
-
I have a value list which is the id of customers and it shows second value of their company name. This all works fine and I sometimes put the value list on a layout as reference showing the name only as pop-up except I turn off entry. This works well in that a relationship is not needed to the parent table from companies. My problem is this I have a table of SALES and in it is the company id and a sales rep id but nothing else in the sales table names it identifiably unique except the date. So I want to display in its second description for the value list, the company name and sales rep name and date. However, all that is IN the Sales table are the company id …
-
- 5 replies
- 1.3k views
-
-
Hi Folks, I'm working at my class assessment database and want to get a filtered value list working. I have a portal that shows all assessments and registers for a class. It's based on a ClassAssessJoin table. The records in the Assess table can either be Grade or Register. I'd like to create a value list that only shows the Grades. I think I should do this by creating a relationship between the Grade/Register field and a preset global Grade/Register field, but can't get it to work. Ideally, later on, I'd also like to filter the list by what year the class is as well, but I'm happy to take one step at a time!! I can't find any relevant posts that are at a…
-
- 7 replies
- 1.3k views
-
-
Hi all, Â Any FM12 file I open up (tried 2 so far) in FM13 results in Pop-up menus only showing the ID, and not the second field. See attached screen grabs. Â I've checked all the settings... "show values only from second field" is definitely checked. Â Anyone else noticed this?
-
-
- 10 replies
- 5.2k views
-
-
I'm having a difficult time trying to format a time stamp field to display only hours-minutes- AM /PM without also displaying date data. The field is populated using a "GET CURRENT TIMESTAMP" script. The result I get reads 9/12/2014 3:01:46PM. I would like to have it simply display 3:01 AM (or PM) I have tried the formatting dialog box in the inspector and have tried to set the date fields to be a custom format displaying "None" for each of the date attributes. I have attached a sample file to show what I am working with. How should I go about doing this? timeclock .fmp12.zip
-
- 2 replies
- 1.6k views
-
-
Hello all, Â This is my first time posting on this forum so go easy with me. I have started using Filemake Pro 13 on Windows 8.1 for almost two week. Â I have recently hit a snag in the form of my background resizing to the width of the windowborder. Â This probably is just a setting i missed but after some frustrated hours of trying to find a solution i have decided to ask teh people who will probably know. Â So in short this is my problem: Â Layout background with fixed width keeps resizing to the windowborder. Â Thanks in advance. Â Harm
-
-
- 3 replies
- 1.6k views
-
-
Hello everyone. I'm coming back to FM after few years I haven't used it so I'm a bit rusty. I have the 3 tables below: System Department Owner Department and Owner have a relation on the name so I have a conditional value list that allows me to filter the possible owners of a system based on the selected department. Now a system can be used in more departments so the System table I have updated the DepartmentName field to accept multiple repetitions (3) and I have updated the layout accordingly to show repetition 1 through 3. Unfortunately now the conditional value list doesn't work. I would like to display in the list all the owners related to the selecte…
-
-
- 8 replies
- 1.6k views
-
-
Hello, I need to add geo location capabilities to a solution hosted on FMS13 that should be able to run on FMGo, FMPro or Webdirect. As this is not only FMGo, i tried replicating the GeoLocation WebViewer trick we all hear about when FMGo 12 was not yet out with native location function. I have added the code below to a web viewer on a layout. When opening on FMGo, it works a snap : i can get my location data. Therefore, the old trick still seems to be working. But when i open on FMPro (Mac OS 10.9), i get the "Cant get located" error which seems to tell me that the WebViewer is not getting to the location service. Any idea ? Thanks "data:text/…
-
-
- 8 replies
- 4k views
-
-
Hello: I don't know if I'm explaining this right but I have a text field that end users are cutting and pasting into. The text they are pasting into has left justification at the Tab point. Is there any way to retain that so the text aligns correctly. After the paste the text goes back to the margin. End users pasting something like this: • The quick brown fox jumped over the lazy dogs. After the paste it displays like this in the text box: • The quick brown fox jumped over the lazy dogs. Dom
-
- 1 reply
- 761 views
-
-
Hello Forum! I apologize if this post is in the wrong place, but the 'Reports' section did not appear to have a place for just reports. I am trying to create a report using information from multiple tables. The relationships are:  Customers >-------Equipment >---------Service.  I would like the report to show all the customers that meet a certain criteria (the easy part). When I bring over their related records from Service, I only want to see their most recent 'Annual Tune Up' record, and if there are not any, then their most recent service record, and if they have no service records at all, then it can be blank.  Annual Tune Up, is a value in th…
-
- 3 replies
- 1.2k views
-
-
I am now an intermediate BEGINNER Filemaker user. (1 month as of SEPT 2014) I heard that internally Filemaker understands the DATE VALUE as an INTEGER (whole number) that starts at 1 from the year 1/1/0001 I have multiple tables that relate primarily on the date... QUESTION 1 Is there a way to see this number? QUESTION 2 Should I Not Use DATE fields as KEYs in my relationships ? The relationships seem to be working fine, but this is early in my solution and fear I may get into trouble?? POSSIBLE SOLUTION :: Make an Auto INCREMENT serial number field and then match on those? ..then How do I ensure date sequence and a separate…
-
-
- 3 replies
- 1.4k views
-
-
Greets, all: Â I'm creating a report where I need to average each heading's average but I'm scratching my head raw trying to get it to work. (Please refer to the attached.) Â For example, under Content Specialist, I want to average 2.13 and 2.71 which should equal 2.42 (4.84 / 2 = 2.42) but FileMaker has other plans and spat out 3.03...which is a result of taking all the gazillion records in the found set and averaging them out instead of averaging just the two (sub-summarized) numbers. Â I "get" that I need to create a new sub-summary but how should I code the (new) summary field so I get the average of the items listed under each heading? Â TIA for your help…
-
-
- 7 replies
- 1.4k views
-
-
Hey Guys. I have a db with a lot of different text fields, I often makes changes to these fields, and i'd like to have a log that record all the changes i make on all the text fields. It should show each change as a new line like this: On "date" field1 got changed from "something" to "new something" etc... Anyone that can help me create that ?
-
- 1 reply
- 1.3k views
-
-
I would like to use a tabbed panel to hold portal records. I do know about replicating the portal in each panel and using a different starting record number. This looks viable, but I don't know how to implement some other features I also need: I want the name of the tab to be a field from the record in the portal. One possibility seems to be a custom function or calculated field in the parent record to provide that field. Or what other way might be better? I want the number of tabs to be variable, depending on how many portal records there are (there will be less than 10). I don't see how to do that. Do I have to predefine the maximum number of tabs and copy the …
-
- 4 replies
- 2.2k views
-
-
Hi Knowledgable People! I run a martial arts club and have been busy redesigning my database to include a lot of new features. Using my limited knowledge, books tutorials and the knowledge on this forum, I have managed to create Invoicing, Roles and a variety of other things that I didn't know how to do previously. I am now trying to create a Grading Skill Set. This is where multiple techniques or skills are assigned to a Belt level. My problem is that I can't seem to create the Grading Skill Sets the way I want to. THE PROBLEM What I am trying to acheive is to create the skill set in the Grading Skill Set layout (which is working!), but add the techni…
-
- 0 replies
- 1.1k views
-
-
I am building a database for my cabinetshop that assigns tasks to workers. It relies on color coded conditional formatting to signal task priority and status of tasks. If the tasks need to be done TODAY the record turns yellow. If the urgency level is HOT the record turns red. When the task is iIN PROCESS the record is conditionally formatted to be green. The current status of each worker is reported in Global storage fields that live in the header. If a worker is currently engaged on a project his record turns green. If a worker is NOT currently engaged his record turns white again. The conditional formatting works fine when the database is on a standalo…
-
- 3 replies
- 1.3k views
-
-
Hi folks, It's a few months since I last played with portals and I'm now dosed with pain-killers, suffering brain-fade and struggling!! I'm using three tables: Day - DayClassJoin - Class I have DayClassJoin records created on the class layout, but the classes don't show up on the Day layout portal. As far as I can see, the relationships are all OK (linking the appropriate UIDs) The portal shows related records from DayClassJoin. The fields on the portal are from the class table. I've missed something stupid - any idea what? Cheers! Mike
-
- 12 replies
- 1.4k views
-
-
Hi. I have a roster with a number of individuals in it, and I want the user [of the solution] to be able to select a colour for that rostered individual. I am working on the basis (which may be wrong) of choosing the colour from a wheel (or more simply, a block of 50 colors whose RGB values are known), having the colour then stored against the [rostered] individual as an RGB value in their record, and then wherever their name appears in the roster, that field is conditionally formatted. Ideally, so the colour doesn't wash out the name, the transparency to be set as well - but thats asking too much I imagine. I have been looking at Conditional Formatting (which I…
-
- 1 reply
- 1.5k views
-
-
Hello: Â I'm sure this is a head knocker but I can't seem to get my fields in a browselist to have the field borders show up not only for the current record but for ALL records in the list. Â You'll see in my screen shots that when I highlight a record the fields have border lines but I'd like to have all fields with border lines regardless of whether it's selected or not. Â Â In the 2nd screen shot you'll see that I do have a black 1 pt. line border for the field selected but when I go into browse mode it just doesn't show up. Â What am I missing here? Â Thanks in advance. Â Dom
-
- 2 replies
- 820 views
-
-
Hi. Is there a way to open a database so that automatically opens in its own window and not within the main (fmp13) application window. A bit like kiosk mode but in it's own resizable window. The reason being so that it would (look like it) launches like a independent application and not within fmp. I understand that the user would need a copy of filmaker pro on their system. Creating a runtime is not really an option as it needs to be multiuser. Can any one help. Or even suggest a different way to acheive the same effect. Thanks.
-
- 9 replies
- 1.8k views
-
-
Hello All: Â I'm really perplexed on how this might have happened but my Filemaker 13 Pro Advanced menu bar has the label "Night Wing" where the label "Scripts" should be ( see enclosed png file ). Â If I click on the "Night Wing" it shows all my scripts BUT I was wondering what I may have done to change the application Menu Bar. Â I'm happen to be a big fan of Ray Cologon but I have no idea how I might have done this. Â ( lol ) Â I'm truly stumped. Â No offense to Ray but I'd like to change it back. Â Anyone? Â DomÂ
-
- 2 replies
- 3.9k views
-
-
Hi, Hopefully I've posted this question in the right place! I'm developing a maintenance database (spares) and have came across an issue regarding data input of items. When a user creates a new record (adding new product) there could be different wording of products entered. For example 'lamp or bulb','box or crate' etc. What I want is to prevent duplicate naming of items. I'm thinking possibly some kind of buffer table that would compare say a unique manufacturers id and/or supplier and validate the item name on entry?, meaning if the manufacturer and ID was the same then there would only be a single possible value to enter. Not sure the best way to go…
-
- 4 replies
- 2k views
-
-
I am happy with being able to create a dynamic list from relationships. What I trying to solve a away to be able to search through (or filter) a Value List of SerialNumbers from a user input of text. Both the search input of text and the calculated value list (calculated SerialNumber field) have a variable number of characters. A user would therefore enter a text string into a field (which can be a related global storage field), then I need the value list to filter based on that string. I can get this working from a exact match (ab=ab etc), but need to know if there is a way of creating a value list based on an index of SerialNumbers? To simply this to explain an…
-
- 5 replies
- 1.8k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online