FileMaker Interface Features
-
Hello World, I am using a web viewer to display/preview some text from a data field before printing and I've run into an interesting situation and could use some guidance. I have created some fields to process raw data and create some HTML/CSS for a webviewer which works great. The only thing is the text formatting does not follow through to the web viewer as it does not generate any HTML formatting tags. I was wondering if there is anyway to check the existing formatting on individual words (ie if Bold, italics, underline, etc)? This way I could run a CF or calculation to sub in HTML tags where needed. Thanks In Advance, Chris
-
- 2 replies
- 1.7k views
-
-
Hello everyone, i have attached the file for anyone who may be able to help. questions are in file. What the issue(s) are is. 1. when the user chooses an ITEM - they have to then choose which type it is & based on that, a global relationship is established using a script and another LineItems TO which has specific details to choose from. 2. IN those options i would like to have user choose [qty -- flavor] ( dont know how to do that within portal ) 3. Then if i would like to print the final invoice, what i would need to do in order to eliminate any issues. thanks, i pos Copy.zip
-
- 8 replies
- 1.5k views
-
-
I am housing Word documents in a container field. However, when I try to open them there is a problem and something funky happens. Am I doing somethin wrong here...? Thanks... Dr.L
-
- 5 replies
- 1.1k views
-
-
I have a simple report layout for my CRM database that shows a sales rep's activities. The CRM has tables for contacts and related activities. The layout shows records from Activities, with a summary count field for each contact in a trailing sub-summary, so you can sort the layout by Contact and see just one line per contact. There is no Body part in the layout, just the sub-summary. I control what the report displays using three global variable fields in the header: the sales rep's name (actually the ID underlies the name), the beginning date for the report and the ending date. Once you set those, then I have a "GO" button that runs a script that finds a set of…
-
- 3 replies
- 1.7k views
-
-
I have a tab control with two tabs. Each tab has a portal in it. It displays properly in edit layout mode, but when I re-enter browse mode, all of the portals get superimposed on top of each other. The portals are well within the margins of the tabs, so I'm not sure what's up.
-
- 2 replies
- 2.2k views
-
-
I have a checkbox field called 'Age' that contains the following possibilities of target age group for which my games are intended for; 2 - 4 5 - 6 7 - 9 10 -15 Some games can be played by both toddlers & older children, so I have ticked two, three or all of the checkboxes. When clients search the games database, They view the game description and under age they see a field called 'Age inclusive' which is a formula grabbing the left word &"-"& the right word of the 'Age' field, which works nicely when I have ticked one box or ticked several in order from lowest to highest. HOWEVER, if I tick '7 - 9' and then '2 - 4', the calculation result…
-
- 4 replies
- 1.6k views
-
-
Simple question: If there are no portal records, is it possible to display a message in the portal to indicate that? I'm sure there is already a thread answering this, but I can't find it.
-
- 4 replies
- 1.2k views
-
-
I read up on conditional value lists in a portal from this thread, which was very helpful: http://fmforums.com/forum/topic/64665-conditional-value-lists-in-a-portal/page__st__20 In my case, I am using this technique to cite documents from one table in several different portals. From this thread, it would seem that in order to do this, I would need to create a new TO of the table I'm citing from for each sub-category in each portal. I have over a dozen portals in my database, which would mean about a bajililion TOs of the source table. In turn, when I define the VL for each portal field, I need to cite the specific TO in that portal relationship, so it seems like th…
-
- 0 replies
- 979 views
-
-
I'd like to have a conditional format have the ability for the same field to respond differently to two variables. So, if choice 'A' is selected in the field it would alter the fill color to red while if the condition is 'B' the same field would alter to fill in green...is there a clculation I'd use for this. I can easily format for one condition but multiples is very different... Thanks... Dr.L
-
- 34 replies
- 5k views
-
-
Hi, I have a script that creates a master job and then in a related table creates 'sub jobs'. I have a table layout that shows all the records are in the sub job table with correct foreign keys for the master job table. The relationships are stated correctly and I have allowed the creation of records in the 'edit relationship' dialog. However when I view the portal in the master job layout I can see the multiple rows for the sub jobs but some of the data is not showing in the portal??? I've checked the height of the fields to ensure they are not outside of the portal, but can't think what else could be the problem. This is turning into a serious …
-
- 6 replies
- 1.8k views
-
-
First, I'm using FileMaker because it's a lot more user friendly than access and I'm not a DB guy. so I may be thinking about this all wrong. I'm making a software inventory db for my department. it will have all the standard pertinent Software Fields in one Table, and then where we have installed the software, and the "where it's installed" is where I'm having problems. I want to have a drop down menu from a "building" table (I did this part) then have a second drop down menu with "Room Numbers" and then have a check box list of the "client" Lastly, I'm going to need multiple copies (I'm thinking 4 will do it) because the same software entry will be in…
-
- 1 reply
- 1.1k views
-
-
I am trying to show users to enter certain data but i dont want to have headers like [ firstname ] _________ What i want is something that looks like this firstname & when the user starts typing it gets overwritten. thanks, -i
-
- 8 replies
- 2.2k views
-
-
I am especially interested in the information on good Filemaker design that was presented. Thanks Neil Murphy
-
- 8 replies
- 2.8k views
-
-
So I made a drop down menu for a field, when you click the value it tabs to the next field automatically. I changed the behavior but it doesnt do anything. How do I make it stay on the field once I make a selection?
-
- 0 replies
- 958 views
-
-
It seems like much of Filemaker has evolved over the years with the exception of how pop-up menus and scroll bars look. I am trying to design a modern looking GUI and these two elements are holding me back in 1989. What's the deal with these, why hasn't Filemaker given us an way to alter the appearance of these two elements in over a decade? I am trying to design an interface for a touch screen display and the scroll bars are just plain butt ugly and way too tiny. Are there any third party add-on that can help solve this problem?
-
-
- 7 replies
- 4.3k views
-
-
We are rendering PDF files into a web viewer, and the images do not print out if you print the layout directly. It is possible to print the PDF image if the web viewer has focus and the user presses ctrl-p or uses a right mouse click to select print, but to complete the print, the user has to click the OK button in the resulting print dialog box. We need to be able to generate a 'silent' print request from a Filemaker script, so that the user does not have to handle the dialog box. We've been able to achieve this using Javascript, but this involves the use of a plug-in to pass the javascript request to the web viewer. We'd like to avoid the cost of managing and …
-
- 0 replies
- 3k views
-
-
Hello, I have been experimenting with the FileMaker web viewer object to test for HTML5 behavior when running Firefox as the default web browser. But so far it consistently acts like an Internet Explorer web browser. Is the FileMaker web viewer object linked to the default web browser in the OS? I am trying this using Windows XP with Firefox and FileMaker Pro 11 (latest version). This works on Mac OS X, but that is primarily because of Safari. Has anyone had any success with HTML5 tags when using the FileMaker web viewer? Thanks for any feedback. -Charlie M.
-
- 1 reply
- 3.5k views
-
-
I am trying to create a sub summary of certain data in my database. I have one table that lists patient IDs, and this parent table is linked with multiple child tables through this field. I would like to generate summaries of the number of patients who have certain qualities as specified in some of the child tables, such as a certain condition. I'd like to generate a list of such patients. While in patient list layout mode, I went to "insert" then "part" then sub-summary" and then specified a specific field from a specific table. However, nothing shows up after having done this. Can anyone please tell me why?
-
- 5 replies
- 1.1k views
-
-
I am trying to replace the scroll bar in a portal with buttons. I have been able to scroll up and down the portal records successfully without a scroll bar. However, when I scroll down past the last visible record in the portal, the portal does not scroll down to make that record visible. For instance, if I have a portal with 10 rows (and is showing the 1st 10 records) that has 11 records and I scroll down from the 10th row, the 11th record is highlighted but the record is not visible. I am using "Go to Portal Row" to navigate. Any Ideas
-
- 6 replies
- 2k views
-
-
Dear All, I have a very interesting issue with the following database structure: Production Plan, key: planID Plan details, keys: planID, productID Product, key: productID, recipeID Recipe, key: recipeID Recipe details, key: recipeID, materialID Material, productID Material is a TO of Product The following relation is set: Production Plan (planID) >---< (planID) Plan details (materialID) >---< (materialID) Product (recipeID) >---< (recipeID) Recipe (recipeID) >---< (recipeID) Recipe details (productID) >---< (productID) Material The fileds I use are as follow: Production Plan: month Plan de…
-
- 3 replies
- 801 views
-
-
I defined a value list, called "client names" from a text field that is indexed and chose, includes all values. On a layout that displays the same field, from which the value list is defined, as a related field (no portal) I defined the field to display as a drop down list using values from "client names". This field can only be entered in find mode by the way. I wanted to use the "auto-complete using value list" but the inspector will not allow me to check off this option and the option is not dimmed. I don't understand why. From what I have read using the Help tool this should be possible. Have I missed something? Any help will be greatly appreciated. …
-
- 6 replies
- 4.1k views
-
-
Hi, I've got a pool of product IDs (it's for a book database - so these are 13-digit ISBNs). I get these from a pool of IDs that I keep in one table. I'd like to allow users to select an ISBN from a drop down list and assign it to a product in another table, without using an ISBN that has already been used before. I've managed to use a value list to get the drop down box happening, but can't seem to filter it based on whether it already appears in the product database. I tried using a calculation field in the ISBN pool table that verifies whether the ISBN is used in the product database (I set the relationship to link the ISBN field). The field will give me a …
-
- 14 replies
- 2.8k views
-
-
I know this has been solved before. Can someone please direct me to the appropriate thread? I'm having trouble differentiating between what look like lots of similar but not quite identical requests. Here's the gist of the problem: We collect many different types of documents for each of our patients. Each patient is a record in the main table. I also have a document type table with a linking table to store each record that a patient has a separate record (i.e. a line item). I want to create a value list that will serve to provide users with choices of documents to cite when entering data into the system to make sure we know where it came from. And I want to make sur…
-
- 2 replies
- 1.9k views
-
-
I want to add a field to my layout that is a checkbox, which I can tick or un-tick to represent a simple Boolean Yes or No. Do I have to create a Value List of One Item? If I create a Value List of "Compiled?", then that is value that gets put into the field, rather than a 1 or 0 or Yes or No? Is there an easier way, or am I going to have to write a script to sort out this seemingly simple piece of interface? Many thanks
-
-
- 7 replies
- 2.2k views
-
-
Is it possible to call a FileMaker script from a web viewer? This would be a controlled HTML file, either local or hosted. A button in the HTML file would need to call a script and possibly pass a parameter or two.
-
- 2 replies
- 4.6k views
-
-
Hi All.. Not sure if this is the correct forum.. but here goes.. Is there a way to format insert merge variables with Dollar signs and 2 decimals. When I try to format this with the inspector telling it to use dollar sign and 2 decimal I just get the number without the Dollar sign or the decimal Thanks Stu
-
- 2 replies
- 2.9k views
-
-
I have a web viewer window which uses custom web address to open a PDF file located on one of our network drives. Each record in the file holds the filepath to the PDF file, so as you move from record to record, the webviewer displays the PDF. We are using IE8 and have the Acrobat Plug-in installed so the PDFs render in the web viewer. This works fine until you start browsing through a large number of records, when you suddenly get the message from Acrobat that the Maximum number of files are open and you will have to close some files before you can view or print any more. At this point the web viewer goes blank and ceases to respond - although you can continue to us…
-
- 1 reply
- 1.7k views
-
-
Hi, I'm trying to create Drop downs that only pull the info that corresponds to the previous field. Meaning. I have 4 Drop Down Fields and want to be able to click on the first drop down and only See "Girls", under the second drop down i want to see "T-Shirt", under the 3rd drown dow i want to see "A,B,C" and under the 4th dropdown i want to see only the fields that pertain to the 3rd field. Meaning if i select "A" i want to see on my 4th dropdown "3710" and "3900", if I select "B" i want to see "8000" and if i select "C" i want to see "1300" and "1400". How can i make this happen. Please see attachment. its the last Value List that's giving me trou…
-
-
- 2 replies
- 1.2k views
-
-
Hello all Can anyone advise me on this one I have three value lists on a table the second one is dependent on what is entered on the first and the third dependent on what is entered in the first and second I have got all this working fine, the only problem is that the second and third drop down lists are coming out in alphabetical order instead of the order they have been entered in the table I have tried to get round this by adding a number in front of each value but ideally I would like this to be invisible - I can make them invisible in the tables by changing the text to white, but this attribute is not retained in the drop down list or in the final entry Doe…
-
- 5 replies
- 1.3k views
-
-
Help...I don't know why I'm having this issue but I can't seem to delete the prior row entry for the first field in the second row of a portal. I've attached a pdf of the screen. It is in the voucher_detail layout. You can see that row one has a drain # of S24-59 with data populated in the other field and then in row 2 it also show's S24-59 but the rest of the row is empty. How do I eliminate this line from showing? I've been working on tweaking this file all day here and there and I think my brain is about to explode. Thanks! ic voucher.pdf
-
- 2 replies
- 834 views
-
-
I am looking for the most efficient / fast running way to swap the content of two records (first / last, choosen in a script if swap needed). The idea behind this is allowing the sorting in the portal view to be disabled, as it might dramatically increase the speed. In the attached file all records with the same "ID_Offert" belong to the same offer, and will appear in a portal in "Offer". My idea would be: • store the data from the last record in variables, • write the data from the first record in the last record • write the data in the variables in the first record It will work in a server envirornment. Thank you for your advice! …
-
-
- 7 replies
- 1.4k views
-
-
This is something I've never experienced before - but then I've just moved to Lion. I have a text field that I'm trying to assign the 'radio button' option for control types. It is grayed-out and unassignable. I'm trying to assign a 'custom value' value list to the field and it and about 1/2 the other value lists in the solution are grayed out and unassignable. What's going on? Why are some Value Lists unassignable for use and why am I not able to use the 'radio button' control option? This is really frustrating. (i"m using FM11 advanced/Mac OSX Lion. Previous development on earlier versions of Mac OSx did not exhibit this behavior)
-
- 6 replies
- 1.3k views
-
-
I've set up a database for my organization that can take our total client file (about 20,000 records), drill it down using finds to a targeted list, and export that to a spreadsheet. Easy enough. I would like to have the value lists of several fields dynamically update in find mode. For example, if I had the following geographic fields: State County Town Zip Region (we've already defined this) If I select state and region in find mode, I'd like for the drop down lists for counties, towns and zips to only include those values that are in the correct state and region. Basically, I want the current value lists for any of these geographic fields t…
-
- 0 replies
- 2.7k views
-
-
I'm new to Filemaker. I am constructing a database which shows as columns in Browse and Table modes. I have sub-summary and summary fields totalling columns by category. Problem: in the summary fields I get, for example, "Total: 1325.00". How can I avoid having the "Total:" and show only the numerical result? With multiple columns the text takes up too much space.
-
- 6 replies
- 1.1k views
-
-
Hey Guys, I think i know the answer to this already, but if it is no, just wondered if you had any alternatives. Basically my clients want to convert the excel sheet they have into a layout on filemaker, or an export to excel. It is an availability sheet for staff. So there is a table called availability, which has a row per date per member of staff. The staff is referenced by another table via an id. Each date has three shifts the staff can select as available and not available. The report the client wants produced, is to have staff names down the sides (row per staff) and have the next 7 days across the top broken down into the three shifts. So…
-
- 2 replies
- 1.2k views
-
-
How do I leave a parent window restored (full-screen) when opening new window? Now when opening a new window with a small size, the parent window changes to something smaller.... You would have to restore the window once you close the current one... I have a 'Record ID' that requires a value from a value list... But the value list is 3000+ items and is simply to slow. So I want a new window where a simple search is done, the data can be selected and OK can be clicked. But the parent window resizing makes the screen jump and it's confusing for the enduser. Why does this happen anyway?
-
- 5 replies
- 1.8k views
-
-
Greets, all: I'm waffling between including Record Created and Record Last Modified fields in all of the layouts of a solution I'm about to market. I'm short on real estate and it'd be aesthetically more pleasing not to have those fields on-screen. For my own solutions I have them visible but for end-users, who 99% of the time probably don't care when a record was created or modified, does he or she really need to see these dates? As an aside, the solution doesn't involve inventory or time-critical data so there's no got-to-know-when need for the dates. TIA for your input, Rich
-
- 4 replies
- 1.4k views
-
-
Tables: user: uid, name 1, joe 2, bob 3, millie interests: item_id, interest_id, uid, where uid is associated with user::uid 1, 1, 2 2, 1, 3 3, 1, 1 4, 2, 2 5, 2, 3 6, 3, 1 7, 3, 1 interest_list: interest_id, interest_name, where interest_id is associated with interests::interest_id 1, ecology 2, economy 3, elephants I have a portal that uses the interest_list table as a value list using a standard pulldown menu to add new interests to each user and a delete button to remove them as necessary. The portal works as predicted, but I can add any interest more than once. I'd like to make it so there are no duplicate inter…
-
- 5 replies
- 2.3k views
-
-
I want the Web Viewer without any borders, but it keeps showing the 'embossed' look... All related settings are turned off (eg. Border Effect, line thickness to None, etc.) This is getting annoying, anyone with a tip? At the moment I'm on Windows 7 with FM Advanced. *** Second post... Think it's a Windows bug... just tried it on the Mac and it works just fine. On the PC, in Layout mode no borders are visible, exactly what I want. But in Browse mode the embossed effect is added. This gotta be a bug... *** Third post... Even with "Drop Shadow" effect selected, the emboss effect is present...
-
- 7 replies
- 2.8k views
-
-
Newbie question Requirement - need to have conditional value list which varies based on contents of other field in table. I realize that this is exactly what FM intended when they added this capability, but I do not want user to interact with the UI to create the filtered value list each time it is required. (e.g. - Employee table has EmployeeID and Dept. I want to create conditional value lists which contain EmployeeID, but the value lists need to vary by Dept. In one layout, I might need an EmployeeID value list which displays only the employee names which are in Accounting, in another, I need the value list to include only those in Sales, etc.) …
-
- 6 replies
- 2k views
-
-
Is there a way to populate a portal with related records and then be able to change values in the fields of the portal records without changing the original record they came from? This would be easiest to explain as an inventory/invoice database. Say I have an "Invoice" table that contains a portal which displays records from an "Inventory" table. In my case the items in the portal are populated automatically based on a field outside the portal. This would be similar to a case were Customer A always places the same order, and choosing Customer A in the Invoice:Customer field would get all related records and fill out the items in the portal. I would like to be…
-
- 21 replies
- 7.3k views
-
-
have a portal setup and sometimes, very rarely, but enough to be a headache, the line in the portal does not delete. When looking in the "lines" table, the record is in fact deleted, but it's still in the portal view. My clients can exit the database and when they log back in, it's gone. I'm using the simple "delete portal row" script step. i'm hoping other people have run into this same problem, and have a work around or perhaps i'm not doing something I should be.
-
- 5 replies
- 5k views
-
-
(Beginner)--Filemaker rocks! I have a simple time entry application, I have a portal where a manager enters employees time: emp ID 001 autoenters name and then they select time worked yada yada. I want to be able to select a team: IE manager selects team 25 and it autoenters all the employees into the portal and then they edit times if needed. I assume I make a button and set a script on it, but how do I make it enter multiple rows based on if an employee has been assigned to a team in the employee table? much thanks!
-
- 7 replies
- 2.1k views
-
-
I really wasn't sure where to put this but thought it was more a presentation problem than anything. We're looking at adding a new feature to our solution where we can SMS staff with job details. The idea was to have a pop up window which displays a 'To' field and a 'Message' field. This layout is run by a temp table (sms_table) which will get cleared once the message(s) have been sent. They're going to be sent through email so all copies of the message will be stored in the email client. So, I have a portal the shows jobs which, when clicked, builds the message part up. I worked out a nifty counter (proud of this ) so that side of things is sorted. My …
-
- 1 reply
- 794 views
-
-
I have a file which I am setting up preferences for my client to change the look of the file without entering layout mode of course. So I'm using conditional formatting on the backgrounds and text field labels. Nine of the tables are the main data entry screens. However, on 2 screens I can't get conditional formatting to work. I used container fields that provide the backgrounds where they can select a color from a repeating field of 24 choices. This works like a champ, including the 2 screens in question. I used radio buttons to select from a value list of colors. The condition is formatted as such: Global fields::TextLabelColor = "White" Global f…
-
- 1 reply
- 2.2k views
-
-
This is a nice little demo that I created for the FMWebschool newsletter. It demonstrates how to incorporate PayPal into your FileMaker solutions. Customers have to pay - to unlock the solution. I hope you enjoy! http://www.fmwebschool.com/movies/paypalmovie/paypalmovie.html I look forward to any comments / suggestions. In Kindness Stephen Knight
-
- 3 replies
- 3.9k views
-
-
I have a database with many different layouts. grouped into two folders. I would like a drop down menu pretty much identical to the in built Layout drop down menu found at the bottom left of the status toolbar. Reason being once I create a runtime solution, there won't be any status toolbar so this menu to hop between layouts needs to be in the GUI. Making 20 buttons with scripts to take the user to the specified layout is only going to clutter the screen. Thanks so much in advance.
-
- 8 replies
- 4.5k views
-
-
I've always used checkbox controls for number-type fields used to represent logical true and false. In my latest project I thought I'd try something I've seen other developers do. I found two graphics files that look like checkboxes, one checked and the other un-checked, and stored them in global container fields. I've added a calculation field to my table indicating that if the value of the logical field = 1, return the checked graphic, otherwise return the un-checked graphic. I've placed the calculation field on my layout and made it into a button which activates a script that toggles the logical field. It worked perfectly and looks very polished and professional.…
-
- 3 replies
- 1.2k views
-
-
Trying to add a new feature to FileMaker Pro in which you can have a "to do" list set up, to allow easy access to who needs to be called etc. Will appreciate any help not much experience with FileMaker. Thanks
-
- 3 replies
- 10.4k views
-
-
So I have 2 tables. Inspection and Violation. They are joined in a many-to-many relationship. There are 2 records in Inspection. There are 6 records in Violation. I have a layout set up with parts (body, sub-summary) that show both inspection reports (records) and the list of violations on each inspection report. So there are 2 pages when this layout is in browse mode with the 2 inspection records- one inspection report on each page and a list of the violations within each inspection report. My problem is the numbering of the violations. Right now, the first inspection report violations are numbered fine (1, 2, 3, 4). The second inspection has viol…
-
- 11 replies
- 2.1k views
-
-
And is there any way to stop this? Thanks so much
-
- 3 replies
- 1.4k views
-
-
I wonder if you could be so kind to help me. I've got a list of 18 vocabulary fields that need to have a word entered into each one in order to display their images. Alongside these vocabulary fields I've got a portal that displays a list of words. I would like to create script inside the portal that enters the portal row, copies the contents and then pastes it into the next empty vocabulary field. I have tried 'Go to Portal Row', Go to Related Record' etc. and have had no luck whatsoever. Any advice would be greatly appreciated. Thanks so much,
-
- 2 replies
- 5.9k views
-
-
I'm working on a solution for registrations and roll call for a small art school I'm associated with. I have a layout displaying records from my STUDENT table. There are two portals on this layout: In the CLASS_ENROLLED portal, I have a popup value list with the names of all the courses in the CLASS_DETAILS table. Here the user selects the courses the student is enrolling in. In the SESSIONS portal, each row represents a session (specific date and time) of every course the student has enrolled in for the current month. Each session (row) has a similar value list to the above mentioned, but it only contains the course(s) that the student whose record…
-
- 3 replies
- 1.7k views
-
-
Evey time I create a new field in 'Manage database' and then go back to layout mode, that new field is inserted at the bottom of the layout. Major annoyance! I'll insert it when and where I like thanks. How does one switch this ever so intrusive feature off? Thanks so much
-
- 2 replies
- 1.1k views
-
-
I have a table called Patients that stores a variety of information, including a list of medications being taken and a checkbox field indicating all drug classes represented by the medications listed. Each record in this table represents a patient. Per another user’s advice when I first attempted to solve this problem, I have created a new table MedLibrary in which each record represents a different medication and contains two fields: DrugName and DrugClass. I wanted to be able to search all records in that table to match existing medication name/class entries, so I watched this video and created a second TO (MedLibrary2) with the following relationship: [Med…
-
- 21 replies
- 3.6k views
-
-
-
Hi everyone! I am a bit overwhelmed by FileMaker and its capabilities, so I would greatly appreciate some help. Currently, I have a database of contacts throughout the entire United States, with separate groups. (Group A, Group B, Group C, Group D, Group E). I would like to create some kind of "dashboard" or "layout" for FileMaker so that I can see how many members of each group we have in each City and in each State in the country, possibly like a pie chart that adapts to the data. Could someone please explain to me how to go about setting this kind of layout up, so that I may browse these breakdowns on the fly? Best Regards, Jonathan Ross
-
- 0 replies
- 2.8k views
-
-
I am an intermediately capable FileMaker coder. I have a solution I created for an activity at work which recently broke in a critical part of a reporting process. Does anyone know if the function ValueListItems() was broken with the 11.0v4 update? It was working fine before that and I cannot think of anything that touched that part of the code. In places where possible, I prefer making code dynamic, rather than hard-coding items. One case in point is that as part of a report I build, I look at a value list and create temporary counting variables for each item in that value list. It's a bit slower, but the resulting code won't break if a value list is modifi…
-
- 0 replies
- 1k views
-
-
Hi, I want to create grouping for my six portal tools. (like in Excel - The list will have a gruouping / ungrouping button) As I can choose number of items to be grouped, I want to select these portal tools Please find screenshot of my list attached. Thank you. screen shot.zip
-
- 8 replies
- 1.6k views
-
-
I am having difficulty generating a filtered value list from existing data. These are the tables: Patient Facility Account Hospitalization Each Patient is related to 0 or more Facilities through the Account table, which serves as a join table. Each Hospitalization is related to one Account, and thereby to its Patient and to its Facility. Each Hospitalization is also related to one other Hospitalization, which is its referring Hospitalization. (For example, if a patient is transferred from one facility to another.) I am trying to create a value list that displays only valid referring Hospitalization candidates according to the foll…
-
- 0 replies
- 786 views
-
-
In Layout mode, when you select a single tab panel, you can see and edit its height (and other position data). I don't know how, but I now have a tab where one tab panel is a different height to the others in the same tab object. When I edit the height setting to make it the same as the others, the others automatically increase in tandem. So the difference in height remains the same. Can anyone tell me how to make all the tab panels have the same height? Many thanks in advance - W.
-
- 11 replies
- 2.7k views
-
-
I have a series of tabs, many of which contain LOTS of fields. I am trying to prevent users from having to scroll the whole window beyond the original window frame in order to see each tab's content and am trying to find a way to add scroll bars within a tab. I don't know what functionality would let me do that and the only other option I can come up with is to use another set of tabs within particularly dense main tabs. Any thoughts on how to address this issue most efficiently? We are worried that if there is ANOTHER set of tabs, users might forget to look at each one (which is important, as this for data entry on a research study). Any ideas?
-
- 8 replies
- 8.7k views
-
-
I have a sub-summary part that provides summary data about my database according to record type. On the main database overview page, I created a portal with a self-join relationship (displays records from the same table as the layout it appears on) with relevant fields inside. Everything looks great, but the portal records are not also segregated by record type between the sub-summary reports. I have the records sorted by record type within the portal, but that just groups them. Right now, the portal looks identical in each sub-summary report. Is it possible to filter records so they only appear in the sub-summary part designated for their case type?
-
- 0 replies
- 3.1k views
-
-
I want to create different record id as per my valuelist: ex.- i have parts and products in valuelist. If i select parts...then...in id field ,after clicking on button, a record id parts_01 should be generated and when i select product...then...in id field ,after clicking on button, a record id product_01 should be generated. After a new record, parts should generate parts_02 and for product, it should generate product_02. please help in a script test.
-
- 3 replies
- 988 views
-
-
Hi all, I've been trying to put together a portal that shows all available options, which can be 'selected' (creating a many-to-many join). The selected options would be shown in a second portal, and removed from the first. I found this reference: http://fmforums.com/forum/topic/48666-matching-values-in-separate-repeating-fields/page__p__227334#entry227334 In which Comment posts an example (1166915248-PortalToPortal.fp7.zip) that does exactly what I want, except for one problem: if there are no selections ("Installed Software" in Comment's demo), there are no available options. Works perfectly except for that. How can I get it to show all ava…
-
- 1 reply
- 1k views
-
-
Hello all, I'm trying to create a dynamic portal filter and am running into some problem. I'm a sub-summary layout that marks whether a piece of data is missing from a record in the body and then counts the total number for each record type in the sub-summary part. I am trying to create a portal that filters its contents based on a globally stored radio button field that contains all the possible types of missing data. Ultimately, I want to be able to select a data type in that field and have the portal below display only records with that data type missing. The goal is for the portal filter to be dynamic so I can select whatever data type I want in a sub-summary a…
-
- 0 replies
- 2.5k views
-
-
Hi. We want to pre-load web pages in the FM Web Viewer so that our editors can flip from one to the next without waiting for each page to load. Just like when you use your browser to open several URLs in different tabs all in one go. We have one record per web viewer and hence web page. We find the set of records We go to a layout with the Web Viewer on it We run through the records using the next record step, and pause briefly on each one. We go back to the first record. This works for small numbers of records - eg 12. When the user clicks through to the next record, the web page is already there. This does NOT work for large numbers of records,…
-
- 2 replies
- 1.3k views
-
-
I am trying to create what I thought was a fairly simple database and I am having trouble with one part of it. Maybe my brain has gone on vacation but I can't seem to get it wrapped around my problem for some reason. Here is the detail: The output of this database is to: Create a voucher write a letter to a county write a letter to the dept of agriculture I have 5 tables: Vouchers; Voucher Detail; Vendors; Drain Commissioners; Drains The scenario: Vendor A submits an invoice for work done on Drain X. Before we can pay the bill a voucher has to be created and mailed to the counties the drain is in and the dept of ag. All drain commissioners and dept o…
-
- 1 reply
- 837 views
-
-
When creating custom menus the "copy" versions of all of the main menus that filemaker provides makes it easy to modify the existing main menus. Is there any way to get copy versions (or some other solution) of the sub-menus? For example, I'd like to slightly modify the Manage sub-menu (under the file menu). thx
-
- 2 replies
- 3.2k views
-
-
Hi all, I'm hoping this is an easy fix. I have two databases the main one, we'll call MAIN has a radio box on it. On another database, we'll call SECOND has a portal to MAIN. As part of the portal is these radio boxes. I want whatever is checked in the radio box in MAIN to appear in SECOND portal and vice versa. the problem I am having is if I check the box in MAIN it turns off the checked box in SECOND portal. If I check the box in SECOND portal it turns it off in MAIN. Any thoughts on why this is happening? Thank you.
-
- 6 replies
- 1.1k views
-
-
Basic stuff, but I'm a newbie. Thanks in advance for your help. I have a portal (Line Items) on my layout (Order Form). I'd like the portal to clear (not delete, but reset to empty) when I enter a new record, so each new order form starts fresh. Can you help? Chris
-
- 1 reply
- 868 views
-
-
Thank you if you can help. Form view, data in fields. If data too much to fit in the field, the data that is displaying sits too high in the field compared to the other fields which don't autowrap to another line. This mismatch in placement of data in the field looks terrible particularly on list view. How can I stop FM from recognizing wrapped text when displaying and jagging it upwards? I tried setting alignment to upper, middle and lower but it makes no difference. There must be some trick to it or a checkbox or something. :cry:
-
- 7 replies
- 1.4k views
-
-
I did not create file because I believe this is simple for you. I could not find it. Accounts table and table Bank related on Account_ID assigned in Bank when entering lines. Want report by all Account numbers so I go to Accounts table. I want two columns, LastMonth and ThisMonth which is sum of Bank::Amount. I have summary in Bank so I create two portals and place summary in it and filter by the dates. Dandy. But now I need to also sub total the categories those accounts are based upon. Placing that same portal with summary in parts doesn't work and now I am stuck. Ideas greatly wanted. btw can I add an object to portal itself and then use that object i…
-
- 6 replies
- 1.7k views
-
-
Hi, I have defined a relationship in my filemaker project to a completely separate database, I have created a new layout and dropped in fields from the related database. I have applied formatting to these fields - font size, font family etc, however in browser mode I am still seeing the formatting from the related database, not as formatted in my database layout. I'm sure I've seen an option to change this and override the styling of the related database but I can't find it anywhere. Can anyone point me in the right direction? Cheers Kevin
-
- 1 reply
- 850 views
-
-
I have created a "Student" database with the following tables... Student Groups Grouplineitem See attached picture of layout Working from the "Student" layout, I want to create a portal on the left side of the layout and have it list all the students names who are in a certain group. For example, if I want to view just the "Band" members, I would have a global field with the name of the group. Once selected, it would then view just the "Band" students. I have been able to get this relation set up. My problem is I want to click on a students name and have it go to their record in the current layout which is the "Student" layout and table. …
-
- 1 reply
- 1.3k views
-
-
Hi - I had this formula for a while, but can't find it anywhere. I have a 3-level conditional value list Type > Category > Subject, say I select the type, category and subject, then I go and change Type, the category and subject remains there, but is no longer correct b/c I changed the original top-level setting. Can someone please point me in the formula to remove the Category field when the Type field is changed, or the Subject field when the Category or Subject is changed. I thought it was an Evaluate, but it appears I am wrong. THANKS so much, Justin
-
- 1 reply
- 875 views
-
-
hi! when i copy and paste fields into a portal, they show up when i am in "edit layout" mode, but when i return to view mode to enter records, the fields are no longer appear in the portal...it is simply blank. any ideas why this suddenly is glitchy? this was working fine before and has never happened before...i checked to make sure all of the boxes are within the borders of the portal, and tried to redo it but the same thing happened. I still can't figure out what I am doing wrong
-
- 8 replies
- 1.7k views
-
-
I have an ODBC connection to a MSSQL database that has several timestamp fields. In FM, I'd like some of the fields to display just the dates and other fields to display just the times. When I use the Inspector/Data Formatting area to make any changes, the changes do not stick - the fields always show both the date and the time regardless of my changes. I'm not sure if I am doing something wrong in FM or running into a limitation based on my data source. Any thoughts or work-arounds? Picture example of ODBC data source fields attached.
-
- 1 reply
- 2.2k views
-
-
I've got a database that includes a container field that I wish to use for PDFs, so that it will be possible to access the PDF from inside the database. Its trivial to use the "insert file" command and then navigate to the desired file to link it in the container field. But here are my problems: 1) There are over 400 PDFs altogether and each needs to be linked to a different record. The name on each PDF begins with a number that corresponds to a unique ID number for each record in the database. Is there a way to mass import the PDFs , both generally and also link them to the appropriate record? 2) The PDFs I have linked (in container fields) to the appropriate…
-
- 8 replies
- 1.4k views
-
-
This may sound simple, but I find it very annoying: I constantly end up with the text formatting toolbar showing up twice on my screen. I have a script to turn off all toolbars. That takes care of text toolbar number one. But the other one always remains on the screen and there is no way I can interact with it to have it go away. (The standard Filemaker menu shows it greyed out) It stays right on top of header section, preventing use of the navigation buttons I put there for the runtime application. Sometimes, by fiddling with the system randomly, I can get it to disappear. However, the next time I open the application, it goe…
-
- 4 replies
- 1.5k views
-
-
Hi All Have been playing with the web viewer and have visitied the fm website and it seems you can do something called web scraping. I bring up a page in the web viewer and in another field am able to retreive the source code for the web page being diplayed using the GetLayoutObjectAttribute ( "web object name" ; "content" ) Here is a small sample above of the html I now need to extract the profession of the doctor.. I can get the starting position of the profession using the position function but now nedd to extract everything that falls between the and the after the position of the profession. Any thoughts?? Really need some help …
-
- 15 replies
- 13.8k views
-
-
I'm trying to create a layout, which is used solely for searches. Let's say it's a database of Cheese-producing Nations. (It isn't.) Each main record is of a Nation and its cheese production data. Each Nation has a sub-table of farms. Then the farms have one-to-many attributes of cheese types, Delivery options, and err.... some other thing. Each of these is in its own table with an ID and a Value List. I have created a layout with a field for each of the three types, as a drop down list, and a portal that lists the farms and their Nation. I can select a value from the drop-down list, and perform the search, and I get a lovely list of results. Here's the …
-
- 20 replies
- 3.2k views
-
-
I have setup a portal and the "Show vertical scroll bar" is selected... But it (the scroll bar) is not showing up. Have not tried holding a piece of cheese in front of it, but with everything else it is not showing... Any suggestions?
-
- 2 replies
- 908 views
-
-
hi i have some questions to portals and how to make summaries. just a short description to what i´m working on. i´m an architect and i´m trying to integrate FM to my workflow. in this case I have an apartment building with 150 apartmnents. with my drawing program i´m generating a table for all rooms in the apartment building. i have a table with different informations (Fields) to rooms like ,RoomNr, Floor,Size, RoomHeight.....etc i made an other table to get different summaries of the apartments. i make a layout and place 3 portals. each of them are filtered and sorted to get the right rooms i need. my problem is i would like to have the summ…
-
- 4 replies
- 2k views
-
-
Can anyone please help me with this problem (and thanks in advance): I am using FM Pro 10 Advanced. I want the user to be able to print out a letter containing the text of any of a number of letters stored in a table (tLetter) to a found set of individuals from a table tPeople (this group of people need to receive a letter asking them to return their subscription form, or inviting them to come to a meeting, etc). I have a table (tPeople) containing people’s records (table starts with ID field for each person which is indexed), and a second (unrelated) table (tLetter) with the fields ID, title and content, containing any number of different letters (simi…
-
- 2 replies
- 1.1k views
-
-
I've got a table "Products" that has a field called "Colors". (This is a t-shirt business so I've got hundreds of products and hundreds of colors) The field "Colors" is set to create a value list based on all the colors entered for all products. So in short 1 product could have multiple colors (i.e. T-shirt comes in blue, green, purple, yellow.) In my "Orders" table when I select T-shirt I want only [blue, green, purple, yellow] to show up in my "Colors" field. However, every way I try to set this up, I'm getting every single color in the drop down list to show up. I've seen some conditional value list posts around here and have a few examples, but I don't …
-
- 6 replies
- 2.5k views
-
-
Is there a way to skip summarizing data on a layout? I have a situation where I need to "Show all records" in a script. The summary fields then have to summarize which takes forever and the data I need to get to doesn't even involve those fields. Is there a way to tell filemaker not to summarize while leaving those fields on the layout?... or perhaps you may know a different work around. Thanks!
-
- 2 replies
- 834 views
-
-
Just found a little bug related to the Tab Panel Control. If you've got a tab panel and you group a text box to it, then drop another text box on the panel, it automatically becomes part of that same group. I've tried this with text boxes and fields only, but it looks like grouping a tab panel with an item inside, makes that tab panel "sticky". David
-
- 0 replies
- 1.5k views
-
-
I have just created my first data table, and am looking to start another tab with a second data table. What I am trying to do is create a database to input patient data. The tabs will be something like: "demographics" (this one I have completed), "classification of seizures," "classification of etiology," etc. I went to tab control and began a second tab. However, I am unable to find a way to create a second table... Does anyone know how i can do this? Additionally, after reading many of these forum threads, I am now wondering if this is the best way to organize my database. Since each record will be a patient, will I be able to remain on the same patien…
-
-
- 40 replies
- 14.7k views
-
-
Anyone know how to go about printing a record (from form view) when the record contains a portal with a scroll bar and there are more child records than can be seen without scrolling? My portal shows 10 lines. Say there are 15 child records in the portal. How can I print the form view of the parent record showing the first 10 child records, then have a 2nd page print the same info from the same parent record in form view but have it automatically scroll to show the next 5 child records? I want it to be set up to require as little interaction from the user as possible. So a button on the layout linked to a script would be ideal, unless there's some built in feature t…
-
-
- 6 replies
- 3.6k views
-
-
I need to change the double click function on the container type fields. I only want images to be uploaded.
-
- 0 replies
- 728 views
-
-
Hey Everyone; I set up sliding objects on my layout but white space still there. Am i missing something? Sliding Arrows on the fields you should see
-
- 4 replies
- 1.1k views
-
-
I can put in a file path (in web viewer) such as file://C:/Documents and Settings/userName/Desktop/ ... and view the contents of a folder. And I use this ability to keep external documents attached to records where I can double-click them within the record to open them (by storing only the folder path). But can I take that display (which lists all files within the directory) and turn it into text that I can parse per line? I can do it now using old method of DOS dir and then redirect it. And I can do it via vbs. And I can parse out the files. Can I do it via web viewer? Thanks for any help folks!
-
- 0 replies
- 1k views
-
-
Is there a way to grab the numerical value of a filtered portal? I have a filtered portal in FMP 11; using the portal filter feature rather than filtering via a relationship. I can view the number of items in the filtered portal via another portal with one row (see http://fmforums.com/...ed-portal-rows/). Now, I would like to grab that value and put it into a variable. Purpose: I am "listening" for up/down arrows in order to navigate up and down in the portal (using OnLayoutKeystroke). The script works fine and I can easily navigate up and down in the portal via the arrows. I have a condition that states if I am on portal row 1 then disregard the u…
-
- 8 replies
- 2.9k views
-
-
I decided I'd try something clever, I'd create a one line portal, let's call it Portal New, that would just be used to add records. I filtered this portal so it would only show records that were being entered since there are script triggers that commit the record as it goes to refresh other portals on the layout. Under this portal is another one that shows all the records that have been entered. We'll call it Portal All. You can edit records in Portal All. What my problem is, is when you're using Portal New to enter a record once you get to the last field and tab out of it, it goes to Portal All instead of staying within Portal New and just going back to the start f…
-
-
- 6 replies
- 1.7k views
-
-
Hello all, So I'm sure this has been answered elsewhere but I can't find it with my limited vocabulary. I have created a layout with sub-summary part that produces multiple different sub-summaries with respect to a bunch of summary fields when sorted by a single field (e.g. total/percent when sorted by location for 10 locations). I want to be able to view all location sub-summaries side by side without having to see the individual record data between them, since in some cases this means scrolling through hundreds of them. Is there a way to either hide the individual data that they sub-summaries are reporting on or else basically copy and paste them all into the hea…
-
- 4 replies
- 5.4k views
-
-
I have a layout that I would like to print and have all the 'fill colors' (for fields, backgrounds, etc...) changed to white, and the graphics in the header removed. Does this require making a copy of the layout and removing the colors/graphics then printing from that new layout or is there some other way?
-
- 3 replies
- 796 views
-
-
I have a portal set up to display related records based on a field value in the main layout. When the value selected in the "Equipment" field is changed, the records shown in the portal from the "Isolation Points" table change based on a relationship. The "Isolation Points" table has a "Type" field that can only contain one value, either "Mechanical" or "Electrical". But on the layout pictured (Safety Clearance) there is a field with check boxes that will allow either or both types to be selected. I would like to find a way to filter the records shown in the portal based on which isolation type(s) are selected on the "Safety Clearance" layout. If both are chec…
-
- 20 replies
- 3.1k views
-
-
Hi, Is it possible to add conditional formatting to a drop down list? I was hoping to add a second field to my list that would show 'In Stock',then if the value contained 'In Stock' it would highlight in red. This would allow me to quickly identify the items in the list that are in stock. I have the second field with this info, but a colour change would be even better. Thanks in advance, Skip
-
- 3 replies
- 2.9k views
-
-
Hi all, I have a fairly simple database where I need to change the colour of a layout item based whether or not the expiry date is less than today's date. Basically the layout is designed like a simple card and I just want to turn the card red if the it's expired and needs renewing. So my question is, is it possible to change the colour of layout items (a simple rectangular box in this case) based on this calculation. I have no problem with setting up the script for this, I'm just not sure whether I can change the colour of a layout item based on it. Many thanks for any help Cheers Kevin
-
- 3 replies
- 905 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online