FileMaker Interface Features
-
Hi All, I would like to create a quoting system that is similar to the Quotewerks system available for PC which we currently use - www.quotewerks.com. I have created a database with two tables. One contains details about the customer etc, and the other contains the products related to that quote. They are linked via a QuoteID field. I have created a layout with a portal and all is great however I would like to be able to do the following in the portal: 1. Insert a new "row" in the middle of the existing portal list (like I would in a spreadsheet) 2. Copy and paste rows (copy a row, insert a blank row and then paste the copied row into it) 3. Be a…
-
- 4 replies
- 1.5k views
-
-
I have a database with a many to many relationship between 2 tables tblMedia containing container fields and tblProducts. Could I use portals to display media in tblMedia on a layout based on tblProducts TO? Does this work the same way as for text fields? Or Can portals display media fields?
-
- 1 reply
- 1.2k views
-
-
I just checked my notes from DevCon, and it seems sad but true: Client formatted text overrides conditional formatted text. So -- we are still forced to create calc fields or use to display data cleanly for a report? Or did I miss something? Is there some way to set a field to refuse or ignore client formatting (other than key command to paste unformatted)? I'm also thinking of using a replace or loop command to strip it on existing data. (Client had been pasting text from all sources, retaining many fonts, color and sizes.) I can try to teach them to paste as unformatted, but the existing data is a mess. I'd like to fix with the least amount of fuss.
-
- 9 replies
- 2.3k views
-
-
I'd like to be able to reference a Flash File on a Filemaker application that is distributed via a CD-ROM. Customer installs Filemaker application on their own hard drive Customer opens Filemaker file and Flash introduction runs automatically I've checked everywhere for information on relative or local file paths. I'm even willing to convert Flash file to Quicktime, but need assistance in configuring the right file path in web viewer. Thanks in advance, and I apologize if this has been requested elsewhere.
-
- 0 replies
- 1.5k views
-
-
Since I havent been on here regularly in weeks, I guess I will give you guys a goodie as a post. I found a bug with conditional formatting when the test is with repeating fields. I am not sure if anyone has found this already but I have reported it to FMI. Here is a test file. conditional_issue.zip
-
- 25 replies
- 5.2k views
-
-
Greetings, Does anyone know of a way to get a cross-tab report to be viewable through the web? Since the preview mode is not available with IWP, I am struggling to try to find away to make it work. Thank you
-
- 0 replies
- 988 views
-
-
I have a system set up with an item database and a picture database. In a layout in the item database I have a portal to the matched picture in the picture database. When I view the item database in FM Pro 8.5 itself the picture shows up as it should, keyed by an item number. But when I view using Web Sharing where the picture should be I see ''. Both tables are open, both databases are set to allow web sharing. Yet the portal contents are missing when web shared. Any ideas about what I might do to fix this?
-
- 16 replies
- 2.4k views
-
-
I have the field “Industry Type” in two layouts (“Customer Layout and “About a Company” layout), which are already made and populated with fields. I have a value list called Industry Question: Is there a way to attach this value list to that field in both layouts without manually attaching it in each layout?
-
- 1 reply
- 1k views
-
-
I'm a newbie at this. I have a report that uses a field called Last Call from a different table. That table lists all the calls made by a sales person. I want to show just the most recent one (Last Call) in my report, but it shows the first one (oldest). How I get the last one to display (most recent)?
-
- 6 replies
- 1.4k views
-
-
I am having difficulty getting my pop-up menu data to display how I want in a portal. I have one table with tasks, and for each task I have a pop-up menu where I can select the department(s) responsible for the task completion. I have another related table for requirements. For each requirement, I am relating the tasks we perform to meet the requirement. I have a report layout of the requirements table that uses portals to also display the task data, so that for any requirement you can (theoretically) see all the departments that do work to support it. My issue is two part: 1. The portal only seems to display one of the selected departments in the pop-up men…
-
- 0 replies
- 1.5k views
-
-
Hi. I am attempting to include various sized pictures into a layout. The container box has a pre-determined size but when I try to insert a picture it is expanded/contracted to fit the box thus adjusting the aspect ratio. Is there a way in which I can maintain the ratio without having to ensure that all pictures that I use have the same ratio to begin. Thanks
-
- 2 replies
- 966 views
-
-
This is pretty inconsequential, but a niggling detail that's plagued me for ages. When I'm working on a layout for data entry that is intended never to be printed, I find it distracting to be seeing the squiggly vertical and horizontal lines that indicate where the boundaries for printing are located. I can't find anything under the 'View' menu that enable me to turn these off. What am I missing? (Or am I being too easily nettled?) Wickerman
-
- 1 reply
- 884 views
-
-
I have two db's that talk to each other. One of them stores all of the information about our mentors and the other stores all of information about our students. Each student is assigned a "cohort" year (the year they entered the program) and each student receives a specific mentor for the cohort year. In the student db a unique identifying ID for the mentor is entered to link the mentor and student. In the mentor db I've created a portal to list all of the students with that mentor's ID. Since mentors work more than one year (so more than one cohort) the mentor portal will pull up all years/cohorts that have the mentor's ID. I want to be able to limit th…
-
- 0 replies
- 893 views
-
-
You are going to luv this one. We are using FileMaker Pro 4.0, yes that's right 4.0. So my resources are limited. I need to display the first record found within a row. The code is simple and pulls the correct item but displays all items found - how do I modify this to select the first one or only one? thanks [FMP-Record] [FMP-Field:drop_deadline_date] [/FMP-Record]
-
- 2 replies
- 848 views
-
-
Hi there, I'm trying to figure out the best way to do this: I have a "Passengers" table on a trip. Each passenger must choose several options from a list of "vendorServices" related to a "Vendor" table (for example, there are 5 vendors on this trip, each offering 3 meal choices. Every passenger must choose one option from each of the 5 vendors). The process of selecting the options is currently in place and when a selection is made, a related record is created for that passenger in a "Passenger Options" table. When completed successfully, each passenger will have 5 line items in the related "Passenger options" table, one from each vendor. On the layout I have 4 p…
-
- 0 replies
- 1.1k views
-
-
ARRG. : With Layout Tabs, I have quite the solution now, only somehow, I have a number 2 tab (second from the left) in a row of 4 tabs that pops up first on navigation to the layout where the layout tabs exist and I cannot remember how to fix this so the number 1 tab comes up first. I know I read it somewhere on here but there are at least 3 different kinds of tabs in FMP, so finding the article is proving difficult. Can anyone help?
-
- 2 replies
- 906 views
-
-
Hi all, I am VERY new to this application and need a few questions answered. I appreciate anyone's input. 1. I have a button that I created to toogle between my list layout and my form layout. There is a separate button on each page. The button on the list page works and will transfer me to my form layout when I push it howver will not work from form to list. What am I doing wrong? 2. How do I set up my columns in the list layout the be sortable by clicking the heading at the top of each column? I see that in some of the pre-made solutions there is this feature and I can not figure out how to replicate. 3. Is there a way to make the orientation different fo…
-
- 5 replies
- 1.2k views
-
-
Hi Guys, this is my first post and I am very new to Filemaker Pro, but I am working on a simple catalog database. One of the main features is that there are tabs for different items. I have a list of clickable items such as: Lavatory Faucet Tub Faucet etc. and on the bottom have tabs that show the same items. I want to show the correct tab of Lavatory Faucet when someone clicks the Lavatory Faucet list item. I have tried with Object Name and then creating and If Else statement but I don't seem to know how to properly set it up. Any help is greatly appreciated. -MaNu
-
- 1 reply
- 1k views
-
-
Hello, Is there a way to have a script enable a dialog box to set column width while in table view??? Thanks, Tom
-
- 2 replies
- 881 views
-
-
Hello, I have a layout that looks best in table view, but it has several columns that i would like to have a total of each column at the bottom of the layout. I can't find a way to display the running totals on the table view...any suggestions?:?
-
- 3 replies
- 913 views
-
-
Hello, I'm having difficulty getting a pop-up menu to display how I want it to in a portal. I have one table with defined tasks and each task has a pop-up menu to select the responsible department(s) for the task [can be more than one]. In another, related table, I have requirements. I am relating the tasks to the requirements and have a portal to display the departments responsible. However, the portal is only showing the first selection in a pop-up menu with multiple selections. Also, when multiple tasks with the same responsible departments are related to the requirements table I get repeats in the portal (department 1 listed multiple times in the p…
-
- 0 replies
- 762 views
-
-
Greetings I have a text field that I want to populate with members of a value list. The value list contains a small list (about 10) of accounts, eg, 102, 103, 104 etc. I can populate the field with the check boxes just fine. What I want to do is count how many items are checked. Ultimately I need to use that number as a divisor in a calculation. Can I do this or do I need to set up a portal and related field and get a count that way? Thanks
-
- 1 reply
- 1.2k views
-
-
I have created a portal displaying songs from a songlineitem table. How do I go about showing only the songs of a certain style and have the ability to also show all the songs via a conditional field. I've been able to do this with a repeating field, but I want to stay away from that because of the limits to report with a repeating field.
-
- 0 replies
- 686 views
-
-
hello everyone--a little help please-i go to the create new layout--select the labels vertical enter my field into the first box. my question is how does one enter the second(grey out area)to enter a different field to print labels for. i have used a merge field and placed it into this grey field but it does not show up when printed only in the browse mode
-
- 0 replies
- 749 views
-
-
Hello! I am having a problem with filtering a portal. Here are my table relationships: case -- contact_linker -- contacts -- actual_contacts(client, attorney, witness, etc.) Those are my four tables in order... I have a portal on the "case" layout that looks into "contact_linker" and displays all the related contacts for that case... it works fine. But, I also have another portal on the "case" layout that looks into another T.O. of "contact_linker" in an attempt to show only 'opposing contacts'... The only difference in the relationships is an extra field called "Opposing_Counsel"... User's can click the checkbox for opposing counsel in the "contact_…
-
- 3 replies
- 2.5k views
-
-
Help me please! I am desperate. My goal: I want a list of organisations and how they relate to each other (subsidiary/parent/customer/supplier etc) I have an Organisation Table, I have a link table to record who links to who and what type of link it is. My problem comes when I try and display this in a layout. I can easily show the links in a portal, but they are always from the point of view of the organisation I am editing. So links that come from another organisation show the wrong side of the link. e.g. my link table is setup as.. isrelatedto isrelatedfrom type so I setup a link from org a isrelatedto = org b isr…
-
- 0 replies
- 902 views
-
-
Hi All, I am developing a filemaker based solution for a company, what I want is I need to make it uneditable for users(ie locking in layout mode). I am not able to make it uneditable in layout mode, so what happens is that the users are able to modify the layouts. No one should be able to modify the layout/scripts except me, since the number of users are going to be quiet high (> 20). Please help in providing me a good solution. Many thanks for you help in advance. RajDS
-
- 3 replies
- 1.7k views
-
-
Sorry for the repeat post. I am a Newbee attempting to create a program for multiple visits to a medical clinic. Each visit includes multiple data points that need to be tracked longitudinally (change of weight of time etc). How best should I set up the visits? Tabs? Suggestions?? Thanks
-
- 1 reply
- 922 views
-
-
Hello, I have a portal that currently shows all related records (as it should). Sometimes, however, I'd like it to only display certain records. Every record in my related file has a field called "active" - this displays whether the player is active or not (with a "Yes" or "No"). I would like to create a button that - when pressing it - will only display those players listed as "active" in the portal. I can then have another button that will reverse this (i.e., do the default - show all). What would be the easiest way for me to set up this "find?" -- I can then throw it in a script, for the button... I'm using FM 5.5. Thanks! Chris
-
- 0 replies
- 620 views
-
-
Hi everybody, I have been trying to find out how to adjust a column hight in a table view but can't figure out how to do it. Does anyone have an idea about how to solve my problem? Thanks in advance
-
- 4 replies
- 1.3k views
-
-
We've installed FileMaker server 9.0 advanced but since the server where not stable and where crashing to often, we backed up to FM server 8.04 advanced, but our conditionnal formatting still works...? Where's the conditionnal formatting is store?... Thanks!
-
- 3 replies
- 1.8k views
-
-
Hi here I just added a feature to record sound in my data base and when played I get the spinning beach ball, (it stops when the sound stops playing) has any one had this before and is it problem? the program does not crash.... also will adding sound to the database make it large and the database unstable? cheers D
-
- 3 replies
- 1.1k views
-
-
In some ways Filemaker Pro has very old fashioned limitations, like the missing option to display a found set of records in multiple rows & columns in Browsing mode. This option is limited to the View/Printing mode, and .. in that last mode no interaction whatsoever is possible with what one sees nicely on the screen. Of course there are work-arounds and I have build one: - exporting thumbnail pictures to rows of repeating fields That works fine, but of course it needs a little time (each time) to construct such a lightbox of pictures. I tried to scan this forum for solutions, but alas the search engine of FM Forums is pretty limited and comes up wit…
-
- 7 replies
- 3k views
-
-
In a portal, each row has a button. This button pops-up a larger window of that same portal row. The problem is, if the user has started typing something in the portal, then runs out of space and so without committing the changes clicks the zoom button to get to a larger view of that record ... ... we have a conflict, because the record is being edited from two different windows. If we use the commit function before calling the popup window then the "go to related record" step is lost. Is there an elegant way to commit before going to a related record ? (right now I have to do some trickery with having both windows and then bringing the previous wind…
-
- 2 replies
- 1.3k views
-
-
FMP V6.04 I like to create a button that by clicking it would copy 8 fields (all address details of a client) so I can paste it in to another document. I am not sure how to go about this. Do I need to write a script, and if so does anybody have a sample as I am not sure how to go about it. Alternatively I can think of creating a layout like an envelope and copy it from there. However I am not sure how to do this either as I can not find a way of copying this text field. In other words I would like a user to only have to click one button to perform the whole copy routine. Maybe it is not possible? does anybody know? Thanks for your help
-
- 7 replies
- 1.5k views
-
-
How do I add this html code to a desktop app to view the content without having to post it on the web first and use a web viewer to see it? CURRENT MOON [color=#888888]moon phase info[/color]
-
- 2 replies
- 3.6k views
-
-
Can I somehow emulate in filemaker the tooltips that popup when the mouse pointer hovers over a button or a field? Or am I better off using a common tip area and set a calculation to change the text dynamically? Or is this even possible?
-
- 3 replies
- 3.2k views
-
-
I'm sure this must be simple, but I can't figure it out and am going a bit crazy! I have a portal that shows records from a self-join relationship. I want to devise a calculation that automatically highlights the current record in the portal list. I don't want to use a script to do this. Can anyone help? Thanks
-
- 23 replies
- 3.6k views
-
-
Some labels are not on an 8.5 x 11 sheet. When I try to change the paper size in page set up to my labels...the labels print to the left as opposed to the center based on the printer's feed tray. Any ideas how to solve this issue?
-
- 2 replies
- 980 views
-
-
I need a way to have my data adjust to fit within a defined field size. I want it to be the biggest possible size for the field but when it's longer, it needs to be smaller. I am creating a dynamic vocabulary database for my school and I want to be able to print vocab. lists and then go to half-sheet word wall cards and to 8-to-a-page flash cards etc. Some words are short like "sum" and others are "scientific method" and I don't want "sum" to be a small font in the middle of a huge card but if I make it that big, then "scientific method" wraps off the card. I can individually adjust the font size in the record itself but then that travels with it as data and you have a li…
-
- 1 reply
- 820 views
-
-
Hi -- I'm new to this site and looking forward to helping out where I can -- and hoping to get some help too! Let's say I've got a table called Films and a table called Actors and I want to build an index of Appearances using a 'join field' by that name. When I add a film record via the Films layout I plan to use a portal to the Appearances table to create the various apearances records. (Each film will have several actors, each actor will appear in many films). In the Appearances portal I have the foreign key field that links the join field records to the appropriate Actors' primary key. I have the field set to a pop-up menu making use of a Value list based o…
-
- 1 reply
- 895 views
-
-
Hi - Me again, with a second question for the same scenario I just described. . . Q2 -- What is the best way to allow users to add new Actor names "on the fly" as they work? Is there a way of doing it in this same portal, or must I build an interface for an "Add new Actor to List" process --perhaps in a separate window? I'm thinking also of situations where I want to use a 'Join Table' to track subject keywords relating to each film, where I want the user to build the lexicon as she goes, adding terms to the Keyword table as needed as she assigns them to specific films. thanks again for any pointers. Albert
-
- 0 replies
- 940 views
-
-
Greetings, Still a pretty new FMP user. I started defining my databse fields while importing; thus none of my fields show up on the layout. I know that in layout view I can manually drag out fields one by one, but is there a way to have all of them be placed on the layout simultaneously? Thanks!
-
- 3 replies
- 1.4k views
-
-
The event management template in filemaker allows to add guests in the portal that shows up in the events layout. When clicking on a row in the portal showing related records from the guests table, it takes me to a layout to add guests. This is perfectly fine if attendees for a conference are different all the time. I am trying to modify the template so that I can track the attendance of a set of people in the guest list I already have added in the database before creating an event. Tracking attendance for the people in the guest list should be as easy as checking off checkboxes rather than entering attendee details every time. How do I get this functional…
-
- 4 replies
- 7k views
-
-
I'm new to filemaker and I'm in trouble with this situation: I have 3 drop-down fields Producer (field ProducerID) Director (field DirectorID) Actor (field ActorID) I'm loading all 3 of them with external data from another table as: CrueMemberID - CrueMemberFullName I have already stablished relations between CrueMemberID and all 3 fields I'm only showing the CrueMemberFullName in the 3 drop-down menues, but storing the first value. Sometimes the producer is the director and maybe also the actor of the movie, so I need to be able to click on a button and copy the producer selection into director, and another button that updates direc…
-
- 1 reply
- 1k views
-
-
I have a calender that is represented via portals to days, with initial row offsets to get the month's correct days. Now within each day may be any number of todo items. these items are represented via a portal. so we have a portal within a portal. i have done portal filtering before. but this is on quite a large scale and i would like to get some input before continuing. below is the layout and below that the realational diagram. as u can see all days have the two todo tasks. which are actually from different days. Thankyou in advance. Brendan
-
- 3 replies
- 1.5k views
-
-
Just downloaded the 2.0 version of the business prod. kit and, unless I'm wrong, it looks like fields and tab control 'resizes' when the screen is adjusted. I'm lost on how they did this...does anyone know? I know of at least one layout I can really use that on!
-
- 1 reply
- 1.6k views
-
-
I am totally new to this, my apologies...I am working with an invoice database that I would like to produce reports with. The Problem: when I set up a columnar/list report the invoice tables do not all add up, only the first line in the report shows up. The invoice contains about 15 rows and each row is categorized by a pull-down "id". How do I get the report to reflect the remaining 14 rows when I do a report for a single month? Please help - Im tired and the people are losing faith. :)
-
- 4 replies
- 1.2k views
-
-
I have used .png's with transparency successfully in the client just fine but when I see them through a browser, they all have white backgrounds. Does instant web publishing kill transparency or am I ever so slightly retarded? Attached Example shows screen shot with transparency working in client but not in web browser (either safari or firefox on mac) Thanks!
-
- 3 replies
- 1.2k views
-
-
This is a fairly complicated request. I have two tables in one file, Shipping & Invoicing. Each Shipping Record has a shipping_number, each Invoicing Record has a invoice_number. The Invoicing Table has a repeating field populated with the shipping numbers that are being used for that invoice (an invoice can have more than one shipping record). I would like to show the invoice_number on the Shipping Table based on if the shipping_number is included in the repeating field. I can make a value list from the repeating field but I am having a hard time writing the calculation to see if the shipping number on the Shipping Table is a value in the value list on the I…
-
- 6 replies
- 1.2k views
-
-
Once again I am appealing to the great gurus on this site who have been sooo helpful in the past. I have a table that contains 2 types of records: Sales and Returns and 2 layouts; one to enter/modify sales, one to enter/modify returns. My problem is how to permanently hide sales records when using Returns layout for data entry and vice versa permanently hide Returns records when using Sales layout. One solution would be to change the structure to 2 separate tables (1 for sales and 1 for returns); however reporting is so much easier with one table. Thanks for any pointer/suggestion.
-
- 7 replies
- 1.2k views
-
-
Is it possible to override the sort order for a two field value list derived from values in a table where second value only displayed? I noticed that if i have table 1 pk field 2 1 Alpha 2 Bravo 3 Charlie 4 Delta and i make a value list from the values in table 1 field 2 and use the value list as the source for a drop down the choices available are always sorted from A to Z. I want to see the list in the drop down as Delta Bravo Charlie Alpha or some order other than a b c d. Any thoughts? TIA Kris
-
- 4 replies
- 1.1k views
-
-
can anyone help. How do I create a number of records in one layout based on the number of records found in another layout. EG..Layout 1 looks up layout 2 field X - Field X is related to 3 records in Layout 3. Layout 1 creates 3 records based on Layout 3. I hope this makes some sort of sense
-
- 15 replies
- 2.5k views
-
-
Hello, I am needing help with this: I have a value list with 8 values. I would like a field to appear next to the value list, the field being based on which value is selected. There are 8 different fields that I am trying to accomplish this with, each based on the value list selection. The field that appears needs to be editable by the end user. Any help would be appreciated.
-
- 4 replies
- 1.7k views
-
-
Hey guys - I've uploaded an example to show you guys the issue. Layout 1 is the page I want to link to. I know I can do it from Layout 3, but that's not how I want it. I need Layout 2 to somehow link to the proper RMA number. If you click on the left side button, it will take me to Layout 1, but not the right one. I'm starting to believe this is an issue with the way I organized by database - I know it's not good, but can somebody help me out with this? Thanks! layoutlink.zip
-
- 3 replies
- 1.3k views
-
-
I am new to FM and am running FM 9 Advanced. Here is the setup: [color:red]3 tables: [Patients] ______ [LINK] ______ Doctors] pk_patientID ___ fkPatientID ___ pk_DocID PatientName ______ fkDocID _______DocName The LINK table is a linking many to many table between Patients and Doctors. I am missing some fundamental understanding of how to bring up a patient record and then ADD doctors to that patient. (without using a portal) If I put the patient name at the top of the layout and the doctor name below it, when I 'add new record' it adds a new patient AND doctor record. Is the only way to do this to write a script that will call a…
-
- 26 replies
- 4.4k views
-
-
Hi - I have a drop down field that shows values from a value list, defined to show only the second field in its definition. Works fine except that each time a new value is added (on a different layout in related table), when I come back to the layout where the drop down field is, the new value is not there the first time. If you click on a blank area of layout, and then drop down list again, the new value is there. Sometimes, just dropping it down a second time shows it. Is there a reason it's not showing up the first time, and is there anything I can do in a script after adding a value so that this doesn't happen? Thanks, Michael
-
- 1 reply
- 1k views
-
-
I have used filemaker for Mini DV tape jacket labeling at previous employer. Is there a plug-in or a custom layout for this? I think they had a custom lay out that you could edit information like tape number, format, audio… I have tried looking for different post but have not come up with the information I need. Does anyone know how to format the text so that it would be perpendicular on the ½ inch spin of the mini DV tape jacket? I figured out if I shrink the text box the lettering goes vertical. But that is not what I need. I need the text in a normal horizontal layout where it can be rotated ninety degrees. Can that be editable? I am defiantly new at this and need s…
-
- 2 replies
- 1.3k views
-
-
Hi all, anyone have any thoughts on this? I have 2 related databases, related by city (in a contact list type layout) One db contains the contact info and the other is a form view of sorts, displaying all related contact info. Currently I set it up as a portal and it's working well. I also have a check box in each record and I'd like to tell it to export (or import to another database) only those that are checked. I can get it to export all records in the portal with no problem, but I'm not able to reduce the export set by omitting the checked boxes. So essentially I'm getting too much info. One current way I can think of is by doing the import…
-
- 7 replies
- 1.5k views
-
-
If this has already been answered, feel free to redirect me to the correct thread. I could not find it through a search. We are migrating our information from Excel to Filemaker Pro 9. One of our commonly used forms is a Percentage of Completion Inspection form for some large items we manufacture. We use this weekly to track the percentage complete status of our long projects. For example: CAD Drawings Printed: 4% Materials Ordered: 3% Frame Assembled: 6% Electrical Components Installed: 8% I want to place a checkbox next to each of the approximately 40 line items of the project. I then need a summation box at the bottom that will show the runni…
-
- 14 replies
- 3.3k views
-
-
Hi, i've a FM9 solution, with some mysql datq, is possible to define a value list with value from a field of a mysql table ? thanks
-
- 2 replies
- 1.2k views
-
-
Hello, I created a database a few years back (with version 6 pro or version 6 developer, I can't remember), and it always opens with the layout mode unavailable. It never asks for a password. I seem to remember a keyboard button that you hold down while opening a file to force it to ask you for a password, but I can't figure it out. Anyone have any idea how I can re-gain access to administer this darn database!? I'm sure I have the password, I just can't get it to ask me for it... Sorry if this is in the wrong forum, but it seemed like the best choice. Thanks! Chris
-
- 10 replies
- 2.3k views
-
-
Here is my question. Is there a way where filemaker can make fields editable on 1 layout but when you switch to another layout the fields are not editable? What am I trying to do is have a list view of my records where the fields are not editable, however when a user clicks on a certain record from the list it will switch to the "form" layout and in this layout the user can edit field content. Thank you in advance, Carlos C.
-
- 2 replies
- 1.1k views
-
-
Help! I am new to filemaker and am not sure how to delete the PART that I created. Here's what I did: From the left-side tool menu I dragged part to the page. It became LEADING GRAND SUMMARY and now the page is split in two. When I print, an extra page comes out. I simply would like to delete this. Any suggestions?
-
- 5 replies
- 978 views
-
-
One of my layouts is in “table view” mode for quick data entry, per the users’ request since they are coming from excel spreadsheets). Even if I rename the field names to more friendly names on the layout, in form view they are cool but in table view, only the actual field names show up. For instance, I have nameF (in data dictionary) for first name and renamed it to “First Name” for the layout. Table view only shows nameF, but form/list view will show First Name. It’s especially long and confusing for related tables like student:nameF Is there a way to fix this? Thanks in advance
-
- 1 reply
- 927 views
-
-
OK, I'm "dark green" when it comes to web viewer...what I'd like to do is the following: Using a report layout, have the web viewer appear in the footer. So the user can view each employee that needs to be updated and have the web viewer at the bottom. This way they don't have to toggle between applications. The problem I'm seeing is that as you scroll the web viewer restarts itself (goes to the URL specified each time). I'd like it to stay 'static'. All I can think of now is having two pop-ups which is not what I want to do. Any ideas anyone>
-
- 2 replies
- 1.3k views
-
-
I have a value list for a field called “Status”. If the status is “Denied” I would like the word to show up in red. If I do change the field type to calculation, the value list won’t work. Or can I use a script to show the user a pop-up info screen that says “If this is Denied, Please send the form to the Supervisor” ? What is a more preferred method? Thanks in advance
-
- 2 replies
- 860 views
-
-
Hi., I have a settings layout where I have about 150 fields (300 total, 150 regular and 150 global where global = regular so that global fields problem when more then one user uses the db is avoided). The layout is restricted to one record only. I made a self join via foreign key and what I would like to do is: Display 150 fields in portal (or something similar) so that they will fit onto one screen and no scrolling of the layout is required. Scrolling of the portal would be fine. I cannot figure it out as the portal scrolls only when it has more then one row and as I have only one record to display it would mean one row only. Thank you.,
-
- 11 replies
- 1.3k views
-
-
I use FM Pro 5.5, and I'm looking for a way to select an element in layout mode using a drop down list of elements in the layout I'm working on. For example, in MS Access, there is a drop down in properties where I can select an element of that layout whether it be a field, text, or some other element. I'm after a way to do that in FM. My reason is that the layout I'm working on may have a lot of closely spaced elements that are difficult to select or may by positioned behind other elements making it very difficult to select. Thanks
-
- 5 replies
- 1.1k views
-
-
I've read the discussions on sliding but I just can't make it work with the attached sample we are proposing to use for our school student directory. I tried it in a number of layouts but can't eliminate the white space within each record. Directory_07-08.zip
-
- 1 reply
- 1.2k views
-
-
Just wondering if they've fixed or added the feature to print webviewer-inline PDFs from a layout yet in v9. Really bugged me since in 8.5 with the introduction of the webviewer, I could view PDFs beautifully on my layout, but they wouldn't print out. Thanks! Kane.
-
- 3 replies
- 1.6k views
-
-
I have a lecture tracking database & I'm trying to figure out if I can send an email that contains data that's displaying in a portal. There are 5 lectures that occur each Thursday. I have a layout that displays the lecture date with a portal that displays the 5 lectures for that date. I'd like to be able to generate an email that has the date, then lists the 5 lectures for that date. Is there any way to do this? Each lecture also displays as an individual record in a different layout--I thought I could generate the email using that layout with a script that first finds the desired date (found set contains the 5 records for that date) but I can't figure…
-
- 3 replies
- 1k views
-
-
Hello. I think this isn't possible, but asking anyway: I want to sort a value list by a field without the values in that field appearing in the value list itself. For layout reasons I need to use a drop-down or pop-up value list (can't use a portal, for example). The values come from a related table. The values to be selected are unique. The values in the field I want to sort by might not be, so I can't use it as the first field. The values in the sort field are meaningless to the user, so I don't want him to see them, even during the actual selection process. Is there a way?
-
- 4 replies
- 2k views
-
-
I want to show a listing of the records entered in my customer database at the bottom of the screen. Any suggestions on what I "should" do?
-
- 4 replies
- 1.9k views
-
-
Is there a way to have a flash video be placed in a form? Lets say I want to have a video of how to pour water. I make a flash video of this and I want it to be shown in my app, however I do not want anyone using it to be able to remove it or mess it up by accident or otherwise. Any ideas? Thanks
-
- 5 replies
- 1.7k views
-
-
I have a calender layout that i will be using multiple times., for various date related reporting. there are quite a large number of layout elements. i am dublicating the tables and using the relationships to filter in various data to reprot. Anwayt the question is there anyway to change multiple fields to a different table, or am i going to have to go through a click on all of them. a nice export to txt and re-import would be nice. a simple find and replace. it is such a simple task but is going to take a large chunk of time. this is where filemaker fails. i think it has a clunky layout design system; but thats enough winging : anyone got any ideas.
-
- 1 reply
- 1.1k views
-
-
I have a log portal that includes text from emails sent to and from a person. Is there a way I can include a layout that prints out all the portal records in variously sorted formats while not wasting space. So that, if the first record has 3 lines of text, it uses that much vertical space, and that if the next record has 3 pages of text it expands to the necessary amount of space. This all happening for all the records in the portal, so that the user can print out the entire portal of emails without printing out whitespace?
-
- 9 replies
- 1.5k views
-
-
I am wondering if there is way to not show the number of records in a table when the file is viewed over TCP/IP or IWP in the Status area or Browser? Extensive exploration of the privilege sets do not seem to offer a way to do this....
-
- 0 replies
- 873 views
-
-
I'm attaching a registration form that we are currently producing in a desktop publishing format. I'd like to design a layout in Filemaker Pro that will show the Course Selection box (course names, dates offered, price for members & nons, & CME) along with the hotel information. Any suggestions? I have the course information in a table already and can add a field that denotes when we are offering it ("2007 Fall Institute"). I can create a similar table for hotel information, if that's key. I'm not having any luck with Columnar Layout/Reports. Is a portal the answer? 20070904122526637.pdf
-
- 1 reply
- 920 views
-
-
I am trying to use a value list to display a job selection field that is easier for a user to view. I am using related value lists to display and use JobID numbers associated with a spefic job name. For instance, job_001 is a unique record with a decrption field of "Uptown". In the selection field, the user selects a drop down list of a value list of all related jobID's, but it only shows text from the second field, the job description, i.e. "uptown", "downtown", etc. That part works great. The problem is that when we create an invoice. When the user selects the "invoice" button to run a script, it creates a new record in my invoice table, and pulls info …
-
- 1 reply
- 1.2k views
-
-
I am building a data base to handle home inspections, I am attempting to make it generate the report. For each section of the report than can anywhere from 2-45 code violations, I have the sections as separate table related to the actual report table. Originally I was going to make a layout that had a give space for ever code violation and then use sliding objects to hide the unused ones on a given report, the issue with that is the max layout size was no where near big enough. Me next thought was trying to set up multiple sub summary reports for related tables to fill in the data into one long report. I am having trouble implementing this, i would need mult…
-
- 2 replies
- 1k views
-
-
I am not sure I can explain this correctly but I will try. I have two related databases which work fine. The parent contains all the data and in the child is where additional data per end user is entered. For example one shipping container ( one customer )contains 10 different items - such as 3 boxes with spoons and 7 boxes of forks. The data in the child is further manipulated to reflect the distribution to up to 5 different end users. Each shipping container is a record. Example: 2 boxes of forks and 2 box of spoons are to be delivered to end user A, 3 boxes forks and 1 box spoons to end user B and so on. The problem is I cannot create a delivery receipt , thus de…
-
- 6 replies
- 1.2k views
-
-
Hi, Great forum! I have a question I hope someone can answer. I have a layout with a TCO with four panes, each pane representing one of four categories. I have four "new record" buttons, one for each category - and a script that shows the relevant pane accordingly. What I would like is to have FM automatically switch to the relevant panes while browsing records. Is this possible? Oyvind Odegard
-
- 24 replies
- 4.9k views
-
-
Sorry if this has been asked before.. I've been through the FM knowledge base and looked at Conditional Value Lists and such and couldn't figure out a way to do this. Would dearly appreciate any help. I'm using FileMaker Pro Advanced 8.5 on Windows XP. I have one table called Projects. Its unique identifier is the Project Code. Inside that table are eight different fields in which the user can enter text. These are used to label different debts relating to that Project. I have another table called Disbursements. It also has a field called Project Code which is linked to the Projects table. I want each Disbursement to relate to a specific debt on that projec…
-
- 5 replies
- 1.5k views
-
-
Hi, When a portal is sorted. Is it possible to find the new portal row position of the record that was current before the portal was sorted. Henk
-
- 1 reply
- 1.1k views
-
-
I need to have two different value lists for a field. The value lists show items from different related tables. The field is a part number and the value lists are (1) parts from the entire inventory and (2) a subset of the parts based on a job, if it defined. I had the idea of using a Tab field to switch between hidden tabs based on whether a job is defined or not. That would make the part field with the appropriate value list defined "appear". Is there a better way? Can the position/arrangement of a field be scripted to make a field come forward or backward? Thanks for any tips.
-
- 12 replies
- 1.7k views
-
-
Hi, Does anyone know a way of changing the Sliding/Printing settings, via a script? I have a form view layout with a logo at the top which in some cases needs to be printed in a PDF and in other cases it does not. I don't really want to create another layout, but simply have 2 buttons at the top of the layout: BUTTON 1 for printing with the logo and BUTTON 2 for printing without the logo. Any ideas? Thanks in advance. Nik
-
- 11 replies
- 1.4k views
-
-
Hello, I'm a relative newbie to FMP, so please bear with me. I'm stumped at what seems to me to be a very basic level. Any help will be appreciated. I'm building a DB to manage purchase orders for plants at the landscaping company where I work. All we have at the moment is FMP 4.0, which may be part of the problem. I'm trying to create a layout that will show a list of plants for a job, plus the related info, and then save it as a file for future reference. My problem is getting the layout to display all of the records for that job at one time. I need to do this so I can work with the data. In layout mode I've tried copy/paste, control+drag and duplicate fi…
-
- 1 reply
- 1.1k views
-
-
Greetings everyone I wanted to see if there is an easier way to do what I'm doing. I'm using a combination of the Field Comments and Tooltips feature to give the user more explanation what a particular field is for besides the small field label next to it. I've used this calc in defining the Tooltip - FieldComment ( FileName; Get ( ActiveFieldName ) ) Which works great, but obviously the user has to click in/on the field to make it the ActiveField, and for the Tooltip to show up. This might be a bit cumbersome to some users. Is there a better way to do this (have the tooltip come up without having to click in the field), without hardcoding …
-
- 4 replies
- 3.5k views
-
-
Hi Guys, Is it possible to apply conditional formatting to a label, so if a user hovers over that label (possibly using object names?), the text would underline or turn bold.
-
- 3 replies
- 2.2k views
-
-
A recent post got me thinking about error reporting. I do error trapping to prevent data corruption, but haven't implemented error reporting in my solutions. I like the simplicity of Genx's custom dialog. "Note to Developer:... " which can help diagnose problems and gives the user the tools to help the developer. What are other ways of error reporting that you've used? E-mail on error? Setting a $$log that gets written to an separate table on close? Include Get(ScriptName) and Get(LastError) in the $$log? I'm thinking out loud here, but don't want to reinvent the wheel so am interested in other's thoughts/practices. Thanks, David
-
- 1 reply
- 1.2k views
-
-
Hello All - FM9: trying to shrink a portal so it shows no empty lines on a printout. FM Help says: Portals slide like any other non-field object, but objects within a portal can't slide. If you specify that a portal slides up and the enclosing part shrink, FileMaker Pro omits empty portal rows. - But it doesn't seem to work at all. Any help or suggestions very welcome. Thanks in advance.
-
- 2 replies
- 3.5k views
-
-
Something weird has happened to my database. When I go into layout mode and select "go to layout" there is nothing in there anymore! Before I would see the list of layouts I had made. What on earth is going on? I know that these layouts do exist because I can get to them through various scripts that I created.
-
- 1 reply
- 860 views
-
-
Hi guys Does anyone know how I can trigger a script on switching tabs? I would like to trigger different scripts depending on which tab I select. Thanks Joseph
-
- 3 replies
- 2k views
-
-
Hi Guys, I want to have a popup layout without the border (header, scroll bars etc). Is this possible? I know it can be done in access, how about FMP?
-
- 2 replies
- 1.4k views
-
-
Just a quick question about IE and web viewer. I have IE 7 and have very little inclination to upgrade to a newer version unless I can take advantage of certain features in the web viewer. The question is will IE tabbed browsing open tabs within the IE window in the viewer when links are clicked that open new windows? Rather than open a new IE window outside of FileMaker. If anyone has dealt with this I would greatly appreciate any input you could offer. Obviously this is at the mercy of the current users settings if it is possible, and it would have to configured in the browser prefs but I could handle that if I knew that it was at least capable.
-
- 4 replies
- 1.4k views
-
-
I'm making a form with 20 fields. Each field is for a product feature. I use these fileds to mak several different outputs, like a product leaflet and a catalogue. Some of the features may be used for the leaflet, and some for the catalogue. To gain this, I want checkboxes behind every field. One for every output. Once checked, the feature must appear to the output and if unchecked, this feature will not appear on the output. I've made the form and the outputs also, but I cannot get it to splite the features into different outputs. Can anyone give me a hint and help me out on this? Thanks!
-
- 15 replies
- 2.9k views
-
-
Hi- I have a simple question and have been trying to find a solution to no avail. I am making a patient database. Each patient can have any number of photographs associated with them. So I have one table with a patient name field and a unique ID field (I'll call this the ID table). And I have another table (Photo table) that is an image table with a container field and a field that relates back to the Patient ID. I have made a relationship between the two based on the ID number. I made a layout with the ID table as the data source. I want to be able to add multiple photo records and relate them back to a particular ID. So I enter a patient ID, and then I try to …
-
- 5 replies
- 2k views
-
-
I seem to have come across a problem, I am attempting to create a customer contact notes system. The fields we will have will be 'reason for call', 'notes', 'client id' and 'date'. What I dont seem to understand is how I get to have a single line of notes, then once that has been completed for the program to have another empty fields line created, is this possible. If not is it possible to have a large number of available columns within the database, what I dont want is to have loads of columns and having the user to tab through all of them. Is there a good way to sort this? Cheers in advance
-
- 5 replies
- 1.3k views
-
-
Is it possible to manipulate the look of a layout through a field? Say I had some radio buttons on top... could I make certain fields/text/images appear based on what radio buttons the user selects?? Thanks, Chris
-
- 3 replies
- 918 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online