FileMaker Interface Features
-
Hi All, I need someone to push me in the right direction here. I have a number of Products (that can change) and a number of Discounts (that can change) and I need to create a Cross Tab report that displays each Product for each Discount, thus showing the product price after the discount. I tried with Calculated fields, Relationships, Portals, but nothing seems to work. Please give me a hint if you can. I am attaching a small sample database and a picture of what I am trying to accomplish. Thanks. Cross_Tab.fp7.zip
-
- 3 replies
- 3.3k views
-
-
I have a field for number of pupils. How can I prevent a user from entering in something like 275-300? All I need is the whole number or I cannot search on that field. Thanks.
-
- 5 replies
- 1.5k views
-
-
Can I get or set the preferences settings in FMP10/11? I'd like to disable the Automatically check for updates every 7 days setting because my users don't have admin access on their machines so can't install updates anyway. If I can't set this via script, can I modify a preferences setting file? Sorry if this is too off-topic here. I can't see a better forum than where people control what the users' menus are. Thanks, Gary
-
- 2 replies
- 1.9k views
-
-
Anyone know what happens in this scenario? You're running a script and you freeze the current window. The script launches a new window, does some stuff and closes that window. Now you're back to the original window. Is that original window still frozen or do you have to reissue another freeze window step? Does the act of opening a new window hork your frozen status on the first window?
-
- 9 replies
- 3.4k views
-
-
I'm using comment's dwindling value list (in FMP 8.0), which uses the ValueListItems function and a script to refresh window [flush cached join results], in a portal. It functions perfectly except for one thing. If I'm creating a new record in the last portal row and enter information and then use this script (which is fired by button attached to the field being entered) the other information, the entire row or record in fact, disappears and I'm now selecting a value in a second new record. Is there a way to not flush cached join results when in the last portal row? And while on the subject of last portal row - is it possible to not tab into the last row when en…
-
- 0 replies
- 1.3k views
-
-
Hiya, I am stuck. I am trying to get a button in a portal row to take me to the assiciated record. I have attached screenshots if this helps. I am trying to get whichever record I select via the green "+" button ("screenshot 01") to take me to the "Data Entry" tab - "screenshot 02" and show me that record. The unique value in the recored is "Invoice Number". I have tried building a script. Here are the steps... goto the portal goto field "Invoice Number" copy enter find mode goto "Invoice Number" on the Data Entry tab paste enter browse mode. It will probably come as no suprise to you all but it does not work!!! How do I do th…
-
- 3 replies
- 1.9k views
-
-
I'm using FM Advanced 8.0v3 on Windows 7 64 bit. Whenever I am working with a layout the screen goes solid black when I drag an object. It makes it pretty hard to work with, as I just have to imagine I've got the object where I want it, then nudge again, then again, then again..... It doesn't do it if I just move using the arrow keys, but that's pretty slow too. Any ideas?
-
- 4 replies
- 3.3k views
-
-
Hi - part of my database is dealing with input of clinical measurements of vision, specifically lens powers (I'm an optometrist). The units of lens strength are by convention in 0.25 steps, so lens power goes +0.25, +0.50, +0.75, etc (or the same in minus values). General practise in clinical work is to shorthand these when entering, as (for example) +050, +100, -250, etc. Actual powers are very rarely above +/-20.00, so we would know to read them as +0.50, +1.00, -2.50, etc (rather than +50.00, +100.00, -250.00, etc). My problem - I need to set up the data entry so that users entering any shorthand versions (such as "050", "+050", "0.50", "0.5", +0.5", "+.5",…
-
- 2 replies
- 1.5k views
-
-
FMP Advanced 8, OS 0.6.2. I have a database with a pull down menu (3 options) to change the sender when printing a envelope. Now instead of the company name typed out, I want to use the logo on one occasion and typed text on both other occasions. Does anybody know how to do this in the pull-down menu? or have an other way of doing this? Thanks.
-
- 8 replies
- 1.5k views
-
-
I have 2 tables one containing stock items and one containing Stock Requirements. They have the following fields:- STOCK Stock_code (number auto enter serial) Qty_in_stock (number) Qty_on_order (number) Cost Price (number) Stock Required Part_no (text) related to STOCK STOCK CODE Count_of_part (Summary = count of Part_no) Qty_Required (calculation Case(GetSummary ( CountOfPart ;Part_no )-Stock::Qty In Stock-Stock::Qty On Order â�¥ 0;GetSummary ( CountOfPart ;Part_no )-Stock::Qty In Stock-Stock::Qty On Order;0)) Total_item_cost (calculation qty_required * Stock::Last Cost Price) This all works and allows me to use a layout…
-
- 0 replies
- 985 views
-
-
Hi I am trying to get the innerHTML of my webviewer, as the data is set by JavaScript. Is there any possibility to achieve this? I was thinking of using the following technique: Set the URL to : javascript:a=document.body.innerHTML; ... and then grab it with the GetLayoutObjectAttribute function. but I have the feeling this is not going to work
-
- 10 replies
- 5.8k views
-
-
I am new to filemaker. I am wondering if it is possible to have some sort of lookup function. What I want to do is develope my own database for my movies, books, etc and have a function or script that will lookup information from the internet about the item. I want to create something like what delicious library is doing. You can put in your book ISBN, and it will pull the author, title, year, ect and populate the fileds you want.
-
- 1 reply
- 1.5k views
-
-
I am remedial with Pro 9 but I am inserting photos in a field and the photos are too small when within proporation and too skewed when I do not keep it proporationate. I have used the graphic enlarge & reduce command. I didn't have this problem before with the same photos is there anyone who can help.
-
- 0 replies
- 967 views
-
-
Hi all, I currently have a structure for my employees that allows them to punch in and out, multiple times a day. This table is called Employees InOut, now I'm trying to filter this portal by month (2 for February), this works fine, however, it shows: 02/01/2010 02/01/2010 02/01/2010 02/02/2010 Meaning some dates are showing multiple times (because they punched in multiple times that day). Now I really just want to show each date once. How would I be able to do this?
-
- 0 replies
- 1.3k views
-
-
I know I've seen this somewhere before, but I can't find it now. What's the easiest way to limit the number of subsummary categories to the top "N" categories when the subsummary part is resorted based on the count field? Another way I'm thinking about this is that rather than omitting the minor categories, lumping them in together as "other" and getting the count for the rest. Here's an example Bob Methanol 10 Water 8 Chloroform 6 Other 5 Bill Hexanes 15 Acetonitrile 12 Formaldehyde 10 Other 8 etc. This is rather than all the different categories gro…
-
- 5 replies
- 2.2k views
-
-
I have a problem with IWP and Internet Explorer. When using IE some of the fields doesn't allow entering. This happens in a tabbed page. I have used "Open record/request" script step in the script, but it doesn't help. If I move that field out side of the Tab, it works perfectly. So the problem seems to be in Tabs. I know there's some problems when using IE, but is there a way to solve this. Many of the users are still using IE - for some reason...
-
- 0 replies
- 1.2k views
-
-
Hey there, I am working with CSS to format data that can be viewed via the webviewer. I am in the middle of trying a few things and would like to keep CSS information in a seperate file outside the webviewer. However, I cannot manage to refer to the external CSS. The content of my webviewer starts with: "data:text/html, ... Both the Filemaker file and the CSS file are in the same directory. I tried this with a "normal" HTML file (without "data:text/html,) and things worked. Any ideas...? Thanks a lot, Mike
-
- 0 replies
- 1.8k views
-
-
I am trying to find a way if there is one of storing a web page from the webviewer as either an image, pdf or as a web page archive to a container field rather than just the html code I am creating a monitoring system for a price comparison site. When a customer clicks on the item it takes them to a third party site to purchase. When they finish and close the browser window they are presented with a feedback form to indicate if the price on the third party website was correct , near or way wrong. These responses are then submitted and auto emailed to the original price comparison site The idea is to be able to monitor which retailers are uploading mislead…
-
- 0 replies
- 1.2k views
-
-
I have a database that tracks employee performance per part number. Records are entered with the employee name, part number, and a performance value. I'd like to create a report that will summarize by employee, with a sub-summary of each part number so I can easily report each employee's performance summary of each part number. How can I accomplish this?
-
- 1 reply
- 1.3k views
-
-
Just updated from FM10 AdvPro to FM11 AdvP. I have a DB(from v.10) with very specialized vocab; with upgrade the dictionary is, of course, without my laboriously managed library. Can I find and import my v10 library to v11? Where might I find it? How would I do that? TIA
-
- 1 reply
- 1.3k views
-
-
I think I saw this somewhere as a plug-in, but I may be mistaken: What I want to do is have the ability to select from three separate value lists to pop a value into a text field. For example, there's one value list for Building, one for Room Name and one for Room Number. What I'd like to do is click on a text field to pull up the value list for Building; When I select a building from the list then a fly-out value list for Room Name would appear; I'd draw over to Room Name, select a value, then a fly-out value list would appear for Room Number to select a room number. When I unclick the mouse, those three values would populate the field. Is there such a plug-i…
-
- 0 replies
- 1.2k views
-
-
Hey all, I've got a layout with a bunch of calc fields that get the sum of related records. For some reason that I cannot seem to identify, one particular set of fields: "Subcon1" thru "Subcon8" do NOT show a $0.00 amount if they are $0, but all the other sum calc fields on my layout do! I have compared these Subcon fields to all my other fields over and over and cannot figure out what is different! Can anyone tell me how to make these Subcon fields show $0.00 like the others? It has to be some setting that I am missing, right? Screen-capture:
-
- 1 reply
- 1.1k views
-
-
I have a field within my DB that contains a URL, this in turn loads the URL's website into a defined Web Viewer. I've tried searching for this but was unable to find an answer.... Is there a way that when the website loads into the Web Viewer it can automatically resize the site/content to the size of the actual Web Viewer?
-
- 1 reply
- 1.5k views
-
-
Good morning, everyone. I have a question the about the auto complete feature of Filemaker 9 Advanced. Is there any way possible to have the auto complete feature work with a drop down list that is tied to a value list and be able to click on the arrow and choose from a list of items. Here's an example. If I'm looking for all items relating to "Transmission" If I type the letters "tr" the autofill fills in "tracking bar" with "acking bar" highlighted. If I click on my drop down list it lists everything that starts with "tr" and I can choose from anything on the list. The problem is that the "tr" is no longer highligted and if I choose "transmission" from the list it …
-
- 1 reply
- 1.3k views
-
-
I am using FM9. I am trying to create a dynamic value list from all the content of a specific field, across all the records. I have created a table where one can input, e.g., titles. I would like all that content from that specific field across ALL the records in that table, available to me, eventually as a value list for another field. Is there an easy (or any way) to do that. I can't find a function that will aggregate text from a field from ALL the records in that table. This list will become a dynamic list, available as a pulldown in another field in another table. I know that there are probably a few steps involved. Can anyone help, please? :
-
- 1 reply
- 1.6k views
-
-
Maybe I'm just having delusions of grandure here, but I thought that I saw someplace that Filemaker 11 would include a script step for "sort portal row". Does FM11 include this requested feature or have I been had?
-
- 2 replies
- 1.6k views
-
-
hi there. it's been a while. i would like to create photo pages from photo's that i have in a database. each product has an image that i would like to show a thumbnail then have it do a lightbox effect to a larger image and information. i was able to do this with just the images using a thumbnail generator. i have the code that i would like to use and the java scripts... just need to put it together. thanks
-
- 1 reply
- 1.5k views
-
-
Is there anyway to make fields transparent or clear, or must they always contain a color? Thanks
-
- 3 replies
- 1.7k views
-
-
Hi all, I have a slight problem. I need to make labels for the back of peoples badges that will have their conference schedule printed on them. I have two related tables: Organizers (with a record for each person running one or more events). Events (a record for each event durning the conference). I want print a label for each person that will have their name and schedule of events on it, like this: John Doe Event A, 2:00PM, Room 4 Event B, 2:00PM, Room 4 Event C, 4:00PM, Room 6 There has to be an elegant way to do this, but I cannot seem to figure it out. I thank you all in advance for any and all help with this matter. …
-
- 5 replies
- 1.3k views
-
-
I want to do something simple - but I can't see how FileMaker can do it. I want to prevent user changes to a field based on the value of another field (in the same record). Specifically: If FormIssued = "issued" then FormNumber field is read only. Privilige sets only seem to control editablity of whole records, and validation doesn't kick in until the record commits (which confuses users).
-
- 1 reply
- 1.3k views
-
-
Hello, I am creating a letter as a layout. Ant inside the letter, I need to print a global variable which was previously computed in a script. I tried using the Merge Field but it only ended up printing the <<$$variablename>> during Browse mode. How should I do it? Thanks in advance
-
- 6 replies
- 1.9k views
-
-
I have a popup course id in student register. In this list it shows all the course id and otherthings that belong with that course id. What i am trying to do not show the course id that are in the past in student register. Or only show the classes that the roster submited yes box is unchecked In Course schedule there is a check box that says (Roster Submitted Yes or No) I would like to use this to not show class once the check box has been check yes. Here is what i have set up in relationship graph: Students::Student ID = Student Register::StudentID //enable "Allow creation of records..." for Student Register here// Course Schedule::Cou…
-
- 0 replies
- 1.2k views
-
-
I have 3 tables: SoldJobs, Labor, and Employees. These 3 tables are related: SoldJobs----------->(Allow/Delete)Labor<----------------Employees On the SoldJobs layout, I have a portal using the SoldJobs_Labor relationship. The portal fields are as follows: Date - EmployeeID - EmployeeName - HourlyRate - Hours - TotalLaborCost - CostedTo When the user enters data in this portal, most of the time there will be quite a few rows where only the date and hours data will change. I want to create a scripted button that does the following: Duplicate highlighted portal row In the newly created row, I'd like to delete the data in the…
-
- 3 replies
- 2.1k views
-
-
Is there a setting where upon entering into a field the data is highlighted? In the use of "Proper (name)" in the calculated value of for a name field, names that use "O'" or "Mc" require a space before creating the capitolization of the second part of the name, ie, require "Mccabe" or Mc Cabe" but not "McCabe" -- is there way to refine this?
-
- 2 replies
- 1.2k views
-
-
I am looking to find a way to show more then 2 values in a pop up. In student register when i click on the popup I would like to see course id, Offering Title, Location, Class Start Date, Course Start Time This way i can actually see the all the course info in on box before i select that course and enroll a student in the course. The reason for this type of popup is that we offer the same course at many location and times. Here is a jpeg of what I am trying to do. (popup jpeg) On the left side of the photo is the popup, and the right side were it says [color:blue]click here is what pops up in the photo on the left. This is all in one window i put the…
-
- 1 reply
- 1.4k views
-
-
Hi, I was wondering if it's possible to have dynamic tab names? E.g. I have a contact page, if the contact is an employer, I would like the Mail tab to become the Salary tab, so it's name and function should be dynamic? Or some tabs should be restricted to some records, is that possible?
-
- 3 replies
- 5.2k views
-
-
Hi, for some reason the Zapf dingbats font will not work in Filemaker 10 on my Mac. Instead of the graphic icon, I just get the letter "H" (which is the keystroke for a "black star" in Zapf Dingbats). It works fine in Text Edit. I've even tried copying the star from Text Edit, but it reverts to "H" once in FM, even though FM's font formatting bar says Zapf Dingbats 14 point. I think it may have something to do with Unicode. Can somebody enlighten me?
-
- 1 reply
- 1.4k views
-
-
I Use FileMaker Pro 5.5 , I want you help me please. My document's Layout Mode off.I don't open layout mode and layout.What should I do to turn this? I want to change document but I don't. How do i change document? View>Layout Mode -> I can not click it because it is lock . How do i open it ? Layout and Layout Mode lock . Looks soft . have password but i believe password. password to enter. it is saved file . Please Look, I can not open layout and layout mode.LayoutMode and Layout lock,don't click Problem ; Prepared by the document was locked Layout Mode and Layout.How can i do open these? I don't …
-
- 15 replies
- 3.9k views
-
-
I have three table one is student, the second is Student register, and the third is course schedule The field that I am trying to count is in students copy called (PAID) located towards the bottom it is a radio button. The radio button say yes paid or not paid. The field that I need the count to be in is in the course schedule (TO) where it say registered paid this is a number field I am trying to count how many student paid for that class so i know the count with out manually looking at each individual student. I would like the count to be in the course schedule SO WHEN I look at the class that are coming up i know how many student paid. You …
-
- 3 replies
- 2.1k views
-
-
I want to create long descriptions next to my radio buttons. The text would be long enough to wrap down a line or two if it was in a normal field. Radio button text seems to not be able to wrap and wants to show up as a really long line which will truncate on a layout. Is there any way to get around this limitation (I know I can program a separate radio button selection box and put it next to fields laid out on the screen and program that, but I wanted to do it directly from the results of value list). Embedding CR/LF doesn't seem to work either. Any ideas on this? Thanks. --Peter Brooks
-
- 0 replies
- 2.2k views
-
-
Hello, I apologize for the title - not very descriptive. I have a couple of questions, but first let explain what I'm trying to accomplish and what I've done thus far. A company has 50 employees which work on different days. There are 20 positions that could be filled, but on an average day 10 to 12 are filled. Each employee could work at any position (and it changes frequently). What I'd like to do is track who works in what position for each shift (2 shifts per day). So far, I have the following tables: Employee employee_ID first_name last_name etc. Positions position_ID position_desc position_callsign Shift shift_ID shift_d…
-
- 10 replies
- 1.9k views
-
-
I imported an application from FM4 to FM10. Table A and table B connected with an Id. Layout of table A with a portal where table B records are shown. Because I often enter portal records with several fields having the same data, I have a few variable fields on the layout and a pushbutton launching a script that does: Go to Portal Record(Last) - this creates a new portal record Set (portal) field x from variable x Set (portal) field y from variable y Go to Field(Z) - this is where I want to enter values. In FM 4 this worked like charm. Clicking on the pushbutton always gave me a new portal record with default values filled and the cursor in the field wh…
-
- 11 replies
- 2k views
-
-
Hi, I have developed a application which will running on run time and kiosk mode in this what i want is that when the user run that application in kiosk mode then it will automatically increase the size of the layouts and its object depending upon the screen resolution.plz help me in this regard. Regards, John wiliams.
-
- 1 reply
- 1.2k views
-
-
I have a print layout where I use sub-summaries. There is no body. That is because the table has thousands of records and I just want the sub-totals. I am trying to get two vertical lines to span the length of the page... on each side of the data field (like a spreadsheet). I am trying to accomplish this by setting each field's Field Border as "Right" and "Left"; Black; Hairline. The problem is that I have a miniscule break in the line at each sub-summary. Is there an easy way to get one solid vertical line accross sub summaries?
-
- 1 reply
- 1.3k views
-
-
Hi I have multiple portals on a layout and would like to have a script that can copy all the rows from one portal to another. Portal_1 is a Estimate portal. Portal_2 is the one used for costing. I have other portals on the layout which do not need changing. There can be several rows in the Estimate Portal_1 so I need it to copy all rows and add these to Portal_2 any ideas.
-
- 16 replies
- 7.2k views
-
-
This is a real shortfall in FM, I have a databox in a layout with displays results from a calculation. The data can be various lengths. I have the mailit plugin which copies the layout and emails it (FM pleae add html email to the next update). Trouble is layout preview is always A$ so if data is too much I loose some, how the hell do I get round this?
-
- 4 replies
- 1.6k views
-
-
HI there! I have a database with related tables which are all shown in a layout using portals placed in separate tabs. What I need to do is to be able to print a total concise report of the current record, but showing all the information from all the individual portals (relate records) which will be shown as separate sections of the report. The number of related records in each portal is not constant and therefore need something like sliding-and-auto-reducing for all portals. One of the problems also is that two of the related tables have around 100 fields each... I don't seem to have any idea for all of this. Does anyone?
-
- 4 replies
- 1.5k views
-
-
Why is the "New..." button is greyed when I want to create my own toolbar? I looked at the help file without success. I have never created a toolbar before and I would like to create my own buttons. Thanks
-
- 2 replies
- 1.8k views
-
-
Hi All, BottomLine, GoToObject() now behaves exactly as I want it to. And this post is just to put my ever diminishing mind at ease. But has there been a change since 8.5? Let me explain the reason I ask with an example: Say you have a tab control set with "Car" and "Phone" tabs (object names of tabs always identical to label for this example). Then within the Car tab you had another tab control set with "Make" and "Color"; and within the Phone tab you had a tab control set with "Carrier" and "Smart". Then outside all the tab control sets you have a button with GoToObject("Smart"). Then if you were on the "Color" tab within the "Car" tab and you click that …
-
- 1 reply
- 2.2k views
-
-
I am trying to learn how webviewers work, can someone answer the following questions and provide any help? 1. How does the customizable report in the Webviewer example file of the FM site work? I tried to understand the scripting methodology, but I'm not awre of the whole concept behind it. Can anyone explain? 2. Can someone use a web viewer to show related records portal-likewise? If yes, can you use a web viewer to gather related records from multiple tables into one multi-section report? How can be done? Thanks in advance
-
- 0 replies
- 1.2k views
-
-
In a student database, I have created a portal which details the student's enrolment. Example: Subject Year Assessment Institution Problem 1 I've created a new layout letter to advise the student of their enrolment details. However, if a student is enrolled in more than one subject, only the first subject in the portal appears on the letter. The 2nd and 3rd subjects in the portal do not appear on the letter. How do I resolve this? Problem 2 I want to create a report in a new layout which indicates a subject and lists all students enrolled in this subject. How do I do this based on the portal above?
-
- 14 replies
- 2.9k views
-
-
Not sure if this is the right area, but here it goes. I have a grouped set of buttons that I have given an "object" name of "menu". I also have a container field named menu. Is it possible to place into that container field the menu object that I have on a seperate layout? I know you can place an "outside" object, but can you do the same with a true object from the same file?
-
- 0 replies
- 937 views
-
-
Hello, The attached file sets out what i am trying to overcome. Any thoughts would be great. Trying to do a little formatting magic. Best Stuart Format.fp7.zip
-
- 3 replies
- 1.6k views
-
-
Hi, I'tried to get my MAC solution to WIN but the layout isn't nice anymore. There are gradiants on Windows which I don't have on MAC. In the demo file I created a search box, which looks nice on MAC but on WIN 7 it's half transparent, WHY? The search box has 3 parts, left, middle, right. The middle part is originally 1px large. In my example I stretched it to 250px, maybe there is the problem but why the difference MAC, WIN by ChiSao demo.fp7.zip
-
- 2 replies
- 1.2k views
-
-
Can someone please look at the attached file, and tell me why I would be getting a blank first portal row? Maybe I have my script set up wrong? I'm trying to get it where when I add a "stop" on the "loads" layout, it is automatically entered in the portal, and in the stops table. Thank you. Download file from here: http://www.crazyjamz.com/test1.zip until they get file attachments fixed, Thanks.
-
- 20 replies
- 5.5k views
-
-
Hello, I searched for this, but didn't find anything. I was wondering if there is a way of changing the fill color of a tab panel by script?
-
- 2 replies
- 2.8k views
-
-
Hi, i wonder if there is a way to format numbers or text in show custom dialog box functions. Like how to define number as percentage or currency?
-
- 1 reply
- 1.8k views
-
-
Is there a function or technique for capturing the Custom menu selection that a user makes? That is, if a user selects from my Reports custom menu the "Admissions Audit" item, can I somehow capture that menu title in a variable? I would then pass that variable into the script called by the menu. Such could then be used to navigate to the correct layout or whatever.
-
- 1 reply
- 1.7k views
-
-
Hi there. I am investigating the possibilities of making a database which will contain geographic data (taken from Google maps) and display them in a small window inside FM. Also the ability to select the exact location from within the FM environment woould be great. Does anyone have an idea of the overall implementation for the task?
-
- 7 replies
- 8.9k views
-
-
Hello, Is there a way to remove the header from all pages after page 1? Thanks
-
- 1 reply
- 3.5k views
-
-
This is going to be lengthy to explain - please bear with me. A while back, I noticed when I launched my FM6 files, that I got a message "Date and time are not the same as System settings - do you want them to be the same?" Obviously, I clicked "YES" - who wouldn't? Of COURSE I want my dates and times to be the same as the system settings!! After that, I also began to notice that FM wasn't accepting dates in the (logical) UK format of DDMMYYYY - it was insisting "Dates must look like ...." and allowing only the endlessly frustrating, illogical US system of MMDDYYYY. This baffled me no end. The date on my Mac was displayed in the UK format - what had gone wrong? …
-
- 0 replies
- 1.1k views
-
-
Hi all, I have a button that currently goes to a new record. I would like to add a script that will warn the user if one of the fields is empty. On another layout this field needs to remain empty so I don't want to require the field to have an entry. I hope that makes sense. Thanks in advance
-
- 2 replies
- 1.4k views
-
-
Hi Guys, I'm running a system that involves switching between two files. If I've got a window from another file open in the background, how can I tell filemaker to select that window, and select a record then run a script on it?
-
- 6 replies
- 1.7k views
-
-
Ok, I'll do my best to explain. I have a web page (form) that i've make viewable in a my FM database via webviwer layout. What I want to do is be able to create a few buttons in FM that will allow me, after clicking into a form field "paste" text into the field on the web page that I've linked to the button. Can this be done? I can do it within the FM layout into FM fields, but can I do it into a form on a webpage in webviewer? If I can, I can't figure it out.
-
- 1 reply
- 1.6k views
-
-
I'm kind of new at creating portals so bear with me please. I am setting up a database that has four main tables; Client, Contacts, Projects, Communications. The main layout is a view of the Client information with three portals showing all of the contacts related to that client, all of the projects related to that client and all of the communications related to that client. The portals are working fine on this layout. I also have layouts where individual contacts are entered (showing which client they are related to), individual projects are entered (showing which client they are related to) and individual communications are entered (showing which client and …
-
- 1 reply
- 1.1k views
-
-
How do I show a specific related record, not just the first matching one, in a non-portal field? I have a table Class with the Student_ID as a key. Every Student_ID appears in multiple records (once for history, math, biology, etc.). In a related table Phone, I want to say, "Show me the phone number only for students who are taking history." FileMaker does list only those students, but the field for Class::classname displays "biology" or "math" or "history", depending on which record was created first in the related table. How do I (1) restrict the list only to history students and (2) ensure that the field "classname" displays the class that I ente…
-
- 4 replies
- 1.7k views
-
-
Basically, I am trying to create a punch list for portions of a job that still needs to be completed. The fields I need are - Date Notes Item 1 Item 2 Item 3 Item… the number of items will change depending on the job. But there will be a setup layout to input all Items before records are created. I would like to use check boxes or radio buttons for Items If 3 items have the same date & notes I need to create 3 separate records with one commit button. How can I do this? I hope this makes sense. Thanks in advance
-
- 3 replies
- 1.6k views
-
-
Any way to scroll a text and not let user edit?
-
- 5 replies
- 1.3k views
-
-
Not sure what topic this belongs in but here goes - I have an application that displays questions that need to be answered (not user modifiable). Next to each question I have a radio button set so that a user can select the answer they want and it generates a numeric answer. Some of the questions in a record can be blank. Right now I am using conditional formatting to make the blank fields disappear and a gray text box that covers the radio button if the field is empty. This works, but is kludgy because filemaker leaves ghost lines around the field when any field is selected and when in the radio button set you can select the hidden radio button if you click in the em…
-
- 3 replies
- 1.2k views
-
-
Hello I have a strange problem. I created a portal and use Kieran MacMillan's FastCreate to enter the data. It goes well except for the first portal entry. It goes like this: I create a new record. Fill the client's name (or any other field). Then I go directly to the portal entry field and make a selection in the value list (or any other entry field, value list or not ). When clicking outside the entry field to commit it. The datas disappear. In my line items, the datas are there but not the client id (so it seams the relation doesn't work). Now if after entering the client's name I click outside the field to commit it, the portal works perfectly. …
-
- 0 replies
- 1k views
-
-
I have a common type of database that handles customer information and invoices using the following linked tables. Clients –< Invoices –< Line Items >- Products What I am trying to achieve on the CLIENT LAYOUT is a portal that lists the products that customer has ever ordered and the volume to date with a valuation based on the latest price indicated in the products table i.e. Product Quantity Latest Price Valuation Product A 10,000 $5.00 $50,000 Product B 12,000 $2.00 $24,000 This assumes the client ordered both products, so if they had only previously ordered Product B it would show just. I think Filemaker does this …
-
- 5 replies
- 1.5k views
-
-
Hi there, I'm working on a billing statement, and I'm trying to sort something out. On the "Account Terms and Conditions" portion of the statement, it shows the late payment interest rate. If the rate is an even number, for example 24% it displays correctly, but if it's a rate like 22.75%, the decimal place doesn't appear. I've tried changing fonts to see if the decimal place wasn't a recognized character in that font set but it does the same for Arial, Times New Roman, etc.. The field it uses is specifically for displaying the interest rate in examples like this Account_InterestRate = 0.2275 Account_DisplayRate = Account_InterestRate * 100 = 22.7…
-
- 2 replies
- 1.2k views
-
-
I want to use a portal to display I guess what you'd call two "instances" of one field. Table "Glossary" has only two fields: "GlosId" and "Word." See following: Table: Glossary Field: GlosId (number, where records 0-199 are for Spanish words, and records 200-299 are for French words) Field: Word (text, Spanish or French words, depending on the value of field "GlosId") In the data entry/viewing GUI of the database (layout for table "References"), I've labeled the left "instance" as "Spanish" and the right "instance" as "French," but it does not work right. I want the Spanish "instance" to display only records whose "GlosId" values are 0 to 199, and I …
-
- 2 replies
- 1.3k views
-
-
Hello, I'm using filemaker 10 and I'm trying to get fields to show with quantities. I don't think that makes sense so here's an example: I have a field called products. In this field I have: apple apple apple orange pear pear Is there any way of getting that to display as: apple - 3 orange - 1 pear - 2 or something like that. Thanks in advance
-
- 1 reply
- 1.2k views
-
-
Hi all! How can I change the fields format by choosing a value from a list? I want to use it to change between dollar ($) and euro (€) and this value should valid all number format in the record. I can't find any describe in help and forum maybe I have to creat a new layout but change the format is more simplier.
-
- 4 replies
- 1.9k views
-
-
Hello I Built a script to force people to enter certain data before the script can execute. If they are missing I use the Show custom option dialog to ask for the data. Now my question is. In the Input field. Is there a way to give the user all the options by integrating a value list. Right now for certain fields, I have to tell them the field has not been filled and kick them out of the script and tell them to recalculate again. Not fun. Thank you Zab
-
- 2 replies
- 4.3k views
-
-
Is it possible to customize layouts so that a particular field size can vary? I'm creating a layout of meeting attendees that displays names, titles, and biographies. Some biographies are much shorter than others, so when I preview the layout there's a huge amount of white space in between each person's listing. I want to be able to tell the layout to adjust the 'bio' field size according to how much text is in it so that each bio is positioned right under the previous one. At the moment I have a very weirdly spaced document.
-
- 2 replies
- 2.2k views
-
-
Ok I have a simple checkbox on each portal record. It allows the user to multiselect items. It is tied to a number field and the checkbox set is attached to a lookup list that has a single value of "1" in it. My plan is if it is checked then 1 else nothing. The problem is that a majority of the time if it is checked/unchecked I get a value of 0 carriage return 1 instead of 1. Below is how it looks. So what am I doing wrong?: Thanks Thom _____ 0 1 _____
-
- 2 replies
- 1.2k views
-
-
I think for my problem there is no solution but maybe I've overseen something. Is it possible to get dynamic labels in the tableview? Why? I'm trying to create a multilanguage solution. Almost everything is multilanguage now. only the table views aren't. Is there any way to control names of the labels?
-
- 4 replies
- 1.3k views
-
-
I am a bit confused on how to create a layout with either regular field or a merge field that will expand, even into multiple pages. I am creating a letter function that will allow the user to type or paste the body of a letter into a global field and then print for each record in the found set. I am using a simple layout with just a body part so far. Please Help...
-
- 3 replies
- 1.4k views
-
-
Hi. I have a document storage solution that shows in a portal all documents pertaining to a customer. Some are letters in, some letters out some product images etc. The solution works fine. In one layout, I want to limit the records in the portal to a particular document type. Doing a search (either scripted or manually) on the document type field (within the portal) and the customer ID (outside the portal) fails to show just the desired documents within the portal. How can I achieve this goal? Thanks SB :
-
- 13 replies
- 9.6k views
-
-
Hello I want to use a popup menu as the first field in a portal. But it seems impossible to select it. I have a "No value defined" whenever I want to use it. If I put another field let's say to enter a quantity before the popup then everything goes well. Is it normal or am I missing something? In the respect of the design of this layout I want to make a portal with only one field... the popup menu. Thank you
-
- 2 replies
- 1.2k views
-
-
This is a bit difficult to explain, so much so I'm not sure if I have posted it in the correct section. But here goes. Whenever I click on the screen to deactivate a record (click outside a field). The program automatically does a sort of 3 to 5 records. This seems to be indiscriminate of the number of found records and it happens every time I click out of a field. I am wondering if this has something to do with how I have stored the fields but I would appreciate any help. I Hope this makes some sort of sense.
-
- 4 replies
- 1.4k views
-
-
I have a list layout for printing with a header,a body and a footer. Now I would like to duplicate the layout and ad a Fax cover page for faxing. I tried extending the header part down to add the fax cover above the other information. But it won't except the header being larger than the first page. Then I added a Title header for the fax cover and the moment I add the tittle header part my header no longer prints. What am I missing?:??????
-
- 2 replies
- 2.1k views
-
-
In trying to create a patient/disease database for use in my blood pathology practice I am running into problems. My intent is to have patient information and Disease/diagnosis. Selecting a diagnosis should bring up salient criteria/features of the disease for viewing, classification criteria and an industry standard diagnosis "checklist". Classification schemes vary with organ systems; schemes and checklists will version-change with time. The Patient Table includes items such as NameFirst, NameLast, DOB The confusion is in how to create the disease side of the database; I may be making this more confusing than needed, but Diseases and their classifications…
-
- 4 replies
- 1.6k views
-
-
Just implementing a documentation system for documentation on the internet; works fine using webviewer BUT... There is an oddity with pages that autostart and/or loop audio-visual content; once such a page has been started within my webviewer and I change the active URL of the webviewer, the audio/vis content keeps playing (without the page.... Example this URL http://iaaa.nl/hh/LBclips/win-hh.html When you open this URL in a standard web brwoser and click away from it, it stops (of course) palying; not so with FMP 10 webviewer. Only while this URL is active I can "kill" the looping audio/vis URL by using the webviewer command Go URL and make the URL an emp…
-
- 0 replies
- 1.7k views
-
-
Everytime I close my database on my inventory layout it crashes filemkaer completely closing all my other databases. This layout has alot of fields and I dont know if there is a limit as to how many fields you can have in a layout? Or any ideas of what else causes filemaker to crash from closing a certain layout?
-
- 3 replies
- 1.9k views
-
-
I have a question that is difficult to explain. Essentially I want a field(A) to display one of two numbers. Each number is the value from two fields(B & C) entered on another layout. That would be easy enough but I want the decision of which number will be displayed to depend on another field(D). That field is a Pop-up Menu with 10 options, displayed as a value list. So, dependent on which option is selected in (D) one of two values will automatically be entered in (A). I think I need to define my database. But I can’t figure out how to write out the option for field(A). Should it be a calculation? It seems like I should be able to write a script that would automatic…
-
- 1 reply
- 1.1k views
-
-
I'm working on a database that is used in a production environment. One workstation in particular, is notorious for having 50+ FMP windows open, because they won't shut the windows when they are done with them. Is there a way to lock users out of background filemaker windows, until they have dismissed the foreground window?
-
- 2 replies
- 1.8k views
-
-
Is there a way I can display a container that is within a portal row(a preview if you will)? I'd like to be able to display the file in a preview window in the same layout as the portal itself without having to run a Go To Layout script to see the file. Along with a nomenclature, this would aid in distinguishing which file is the correct container the user needs/wants to export.
-
- 1 reply
- 2.6k views
-
-
First time post.. I don't have a lot of experience with FileMaker but do have many years experience with other databases. Trying to figure out the best way to accomplish the following scenario. I'm building a basic invoice system. I have a relationship between my Invoices table and my Contacts table. I have enabled the ability to create new Contact records via the relationship. This works great but I would like to prevent people from creating duplicate contact records. What would be considered the best way of letting users search for a Contact record before creating one. Open a window and letting them search contacts is trivial but how would I let them 'sel…
-
- 2 replies
- 1.5k views
-
-
I have a field with a value list based on a related child. Each time I add a record in the mother table and enter one of those values I would like the value list to no longer display that name. Is this possible? thanks
-
- 2 replies
- 2.1k views
-
-
Hello. For the past couple weeks, we've been developing a website in PHP, and would like to make the site usable through Filemaker via a web viewer. The problem is that, while the site renders beautifully on Firefox, Chrome, Safari, etc..., it just does not work on IE! I know that on Windows, web viewers are based off of Internet Explorer, so I was wondering if there is a way to change which browser Filemaker's web viewer is based off, so that it renders correctly. Thanks.
-
- 1 reply
- 1.4k views
-
-
Hi, Is it possible to install a menu set by name? The purpose of this is to refresh the menu set if the user change the language of the project interface. Here is what my script would look like scriptname menu_refresh Freeze window $menuName = Get (CustomMenuSetName) Install Menu Set ["Standard Filemaker menus"] Install Menu Set [$menuName] Thanks for anyhelp
-
- 2 replies
- 2.1k views
-
-
Background: Payment Detail Table >- Payment Table >- Payor Table -< Product Group Table -< Client Table also: Product Group Table -< Product Table The troublesome layout is based on the Payment Table with a creation-permitted portal to the Payment Detail Table. Within the portal is a drop-down field for Product Number with a value list based on the associated field in the Product Table. I've tried setting it to "show all values" and "show related values starting with..." (I've tried multiple tables). At best it will display the values from one Product Group (always the same Product Group) for a total of five Product Numbers (no scr…
-
- 0 replies
- 1k views
-
-
Hi all, I just started with Filemaker and have been able to find answers to most of my questions, but I can't seem to find one that quite fits this one. I'm creating a packing list for order shipments -- I have several fields that may or may not contain data. I want to put these fields on the packing list as just a line of data with a "," in between each piece of data. I can list all the fields on the packing list but if there are fields that are empty, then I have a bunch of spaces and carriage returns. I want to remove any empty spaces and put the "," in betwen each field that does have data - hope that makes sense. example: field1 = " labo…
-
- 3 replies
- 1k views
-
-
Hi, I'm trying to figure out a way to show all related records which are related to a phone number. When the user enters the phone number, I want the portal to show the representatives or companies to which the typed phone number is related to. A representative is a person who works for one or more companies he may have multiple phone numbers (mobile, office, fax, etc) or none. The same thing for a company. So basically I've made 4 tables. Companies (pkCompanyID, ...) Representives (pkRepID, lastname, ...) worksFor (pkID, fkCompanyID, fkRepID, ...) phones (pkPhoneID, fkParentID, phone, extension, type, ...) As you can see, a phone can be…
-
- 1 reply
- 1.2k views
-
-
Ok I have been using Filemaker for a long time for my own stuff. I have other people starting to use my stuff, and now I need to learn about formatting screen resolution. Can someone give me the gist, perhaps a sample script?
-
- 1 reply
- 1.5k views
-
-
I'm looking to have a web portal on each customer record that will display the weather and current time for their address. I found this script at weatherforecastmap.com. forecast for This should be ablt to be pasted into a web page but in fairness a portal is not a webpage. I tried this at home on my Mac and pointed the link to the HTML file inside the weather widget and it worked great. When I bring the file back to work, it doens't work because the path to the widget library isn't valid on my work machine. 1) does anybody know if the parts inside the weather widget can be packaged into a corss platform widget so this can be used on a mac …
-
- 4 replies
- 4.9k views
-
-
Parent table is Account table in layout. Portal shows many "Apples" from my Child1 table belonging to only this account# with several other items , Oranges and Bananas too Apples, Bananas and Oranges, get populated in Child1 file, from a value-list from a 2nd Child table for all all counts When looking at 1 account layout, the portal are 3 apples of 5 other items How might I get an ongoing count of all the Apples, Oranges, Bananas when I relate to a different Parent account# I figure probably need something like a Count FOR calculation field. TIA
-
- 1 reply
- 1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online