FileMaker Interface Features
-
I have a Data base with people in it. It is filemakers contact management data base. I added a table for adding kids with there DOB, and so on. With a portal I display on the main table the Kids and there ages. Is there a way to display the portal on a list layout, I would like for it to display horizontal with the Kids name First name only. If you have seen the data file it is the second tab to the list view. Thanks in advance.
-
- 1 reply
- 1.1k views
-
-
Hi guys, I'm working on a database in FMP 9A and i need to call out specific items from a ".doc" file and import it into various fields... for instance... i need to search a document and pick out the word "call" then put in the entire sentence including "call" into a field also i want to put in images from a .doc document into a container field automatically. thanks in advance... Eukanuba
-
- 1 reply
- 1.4k views
-
-
So I'm a complete beginner at FM, but I'm trying to put together a database where my lab can store all of our info. To give you an idea of what I'm trying to do, we have a bunch of DNA sequences that we want to put into a list. I've tried modifying the included 'Research Notes', but the sorting does not work. Can someone explain the code behind the sorting (I'd like to sort by plasmid name, size of the plasmid, and who created the plasmid)? Or at least tell me the code I'd have to input into the script so that when I press the header thing the list would resort itself up or down? My other question is that with the 'Research Notes', you can have a running list (ie…
-
- 11 replies
- 2.9k views
-
-
I am creating a database to keep track of three different things, I am not sure how to best set them up. Trucks Drivers Trailers I have developed a data file for each and after I have created them I feel there would be a better way So I am going back and creating tables for each. Now the question, I would like to create portals to assign the truck a driver and trailer. I need to be able to unasign the driver from the truck and trailer visa versa. Basically I need to keep track who is driving which truck and trailer it could be different each month. I do not know which way would be the best to set this up. I am trying to avoid red…
-
- 4 replies
- 1.2k views
-
-
Hello, I love the way the filemaker template (task Management) inserts new(or old) customers into a customer portal. You click on assign new contact in the task tab and it pops up a list of customers and you either add a new customer or pick from a list of current customers and then it copies it into the portal. (I have attached an image for reference). Yet, I do not know how to replicate it into my own solution, I basically need to know the script to get the button to popup a list view of customers and be able to select a record to use in the portal? Any help would be appreciated. Thanks
-
- 1 reply
- 2.1k views
-
-
I set a web viewer to show my gmail account. I can basically bookmark conversations URLs to FM fields, the only thin I can't do is pass my user name and password from a couple of filemaker fields to the gmail authentication form in the web viewer... Is anyone aware of a way to do this ? Thanks!
-
- 1 reply
- 2k views
-
-
FileMaker 8.5 on OS X 10.4 Is there a limit on the number of records displayed in a pop-up list? • I have 8,000 record to display on the list Only around 50 display correctly, it starts in the wrong place. I think this is a bug and not corruption. Anyone else know of a limit/issue ? best Stuart
-
- 4 replies
- 1.6k views
-
-
I have a calendar layout with a portal that shows all Jobs for a Day. There are multiple Jobs per Order. The portal is sorted by start time, but different Jobs on the same order may start at different times. It would be unusual to have more than 10 different Orders (and 30 Jobs) per day. I'm trying to come up with a way to assign a highlight color to each Job of the same Order. Having the same color to an Order over multiple days would be ideal, maybe required. An Order would rarely have Jobs that cover a span longer than 2 weeks. It's unlikely more than 20 Orders would ever overlap. I imagine it would require a deconstruction of the Order id and a custom…
-
- 10 replies
- 1.9k views
-
-
I have been working on a request to provide a UI that presents information in a grid view for data entry. The database has Jobs/Job Items/Job Item Tasks. The view would ideally show Job Item and Job Item Task info so a user could create and edit records from. In the task records, there are fields that are common (Qty, Round, Description) but have different context based on what other fields are filled out relative to the record. There are filtered portals to get each task record to show up correctly in the layout. I'm using zippscript to execute a script on field entry but also need to execute a script on field exit. The field entry script execution is performe…
-
- 0 replies
- 1.1k views
-
-
I found a huge post that seemed to be roughly about what I'm trying, but I couldn't find an applicable solution. Here's what I want. I have a value list that is made up of values from my "product_name" field in my inventory table. I would like the value list to be sorted by my "product_category" field, also in my inventory table. So instead of this: Product 1 Product 2 Product 3 Product 4 Product 5 Product 6 It would look like this: Category 1- Product 1 Product 2 Product 3 Category 2- Product 4 Product 5 Product 6 Any suggstions?
-
- 1 reply
- 1.1k views
-
-
First of all, I want to thank everyone on this site. Everyone is so helpful and quick to respond. So I have a database that keeps track of an exchange program of American and French students, that are exchanged between their home universities. I'd like a layout (almost like a student directory printout) that has French students on the left and American students on the right, sorted by which American University they're going to and coming from respectively. It seems impossible because we'd have to create a list layout with different data from two tables. Is this at all possible? Are there any other ideas/solutions? Thanks so much!
-
- 1 reply
- 1.1k views
-
-
Simple example of using conditional formatting to change content of a calc field. Global variables are set by conditional formatting "Let" statements. cfcontent.zip
-
- 0 replies
- 1.1k views
-
-
Is there a way to designate which repetition number in a repeating field the conditional formatting is applied to. I can add a formula to a repeating field but it always changes the first repetition. Thanks, Steve
-
- 2 replies
- 3.3k views
-
-
I hope I am in the right forum. I updating to FileMaker 8.5 and want to make some changes to my database. My database contains a service call ticket for each and every invoice that is processed through our company. I want to include a few important pieces of info in a record for each invoice and then link a pdf of the invoice to the record. (e.g. while in a record you can click on a link that will open the corresponding invoice so that the user can view the entire invoice, eliminating a trillion file cabinets and saving time). If this is possible where can I find directions on how to do this? I am working without a server right now, but I am not sure if I need one as this…
-
- 0 replies
- 1.4k views
-
-
I am trying to find a set of records that are identified by a Category record id#, duplicate them and then switch the id number on the duplicates to a new Category record #. Of course when I try to script this it can create a new record, copy over info in the set variables but gets hung up on going back to the second record in the found set. If you want to see my current script you can but I'm pretty sure it's monstrous. I still have a hard time thinking in loops and steps. help?
-
- 2 replies
- 1.1k views
-
-
Hi, This one is driving me nuts. I have a Job table, a Company table and a Contact table. In the Job table each record is a Job - represented by Job Number. In the Company table each record is a Company - represented by a Company Number. The Contact table is only used as a portal. When entering a Company you can also enter Contact names via a portal. Company ABC has John Smith and Ben Gold as contacts. Company XYZ has Jim Jones and Betty Downs as contacts. I create a Job in the Jobs table - Job Number 1001. I have 4 fields on the layout: Job Number - Auto Entered Customer Number - Drop Down List Company Name - Fills in af…
-
- 2 replies
- 1.1k views
-
-
I'm looking for a way to hide or show radio buttons based on whether two text boxes have data in them or not. So far, I've tried conditional formatting for the buttons, but this only hides the text, while the buttons themselves stay showing. I've also tried the 'trick' with a single row, self-relational portal containing them. The portal does hide and show when I change the value of the text boxes, but the portal only shows the radio option chosen, not the buttons themselves (i.e. when I choose a different radio button, the value in the portal changes). Is there any way to make the buttons completely 'invisible'? I would like to make it so that when neither text…
-
- 1 reply
- 1.4k views
-
-
I have 2 tables. One table has names and each name is assigned a type. The second table is linked to the first one by a unique number assigned to each name. When adding to the second table I want have the user select the name from a dropdown list but only for a certain type. Ex. Table 1: # Name Type 1 Name1 A 2 Name2 B 3 Name3 A Table 2 will store the number of the name chosen. But during entry of table 2 the dropdown list should only show names of type 'A' Thanks
-
- 0 replies
- 1.3k views
-
-
Hi there My apologies for repeating this question for the xth time, but I've read most of the threads relating to this problem and have tried to implement proposed solutions, without much success. I have 4 tables: 1 - Families, providing a list of families 2 - Genera, providing a list of genera linked to a family 3 - Species, providing a list of species linked to a genus (Genera) 4 - DNK, showing a sample identification record with additional information about each sample. Should be able to create new genera linked to existing families and new species linked to existing genera. In table DNK, needs to show the Genera for the selected Family, and…
-
- 4 replies
- 1.7k views
-
-
Hi all, Does anyone know how to programatically set the values of a custom value list? For example, i can get the values of a value list with: [color:green]ValueListItems ( fileName ; valueList ) in a script step. But then how can i take this list and within a script set a different custom value list to have the same set of values? Using FMPro 8.5 Advanced. Peace, Dan
-
- 4 replies
- 2.3k views
-
-
Hi All, We're in the process of migrating our fm tables to mysql, however we'll have to carry on using fm for a while and so we need to link the external tables back to fm. I had a table called membership_types in fm which I duly moved to mysql with all it's data and then linked it in the fm database. However one of my value lists used data from this membership_types table (when it was still in fm) and when I tried to do the same with the linked mysql membership_types table fm wouldn't let me (external tables are greyed out when trying to select a table for the value list). Is there some sort of workaround so that value lists could display data from extern…
-
- 2 replies
- 1.5k views
-
-
I am running FMPro Advanced, Server, and Pro 9.0. Server is on Mac, Advanced and Pro on on a mixed pc/mac platform. My relationships for the particular portal I'm having trouble with are set to add new record. The folks that are trying to add a new record via the portal have full access privileges. We can delete the records in the portal, we can also update records in the portal. The problem is we can't add another record. We go to the empty field, type something in and it comes back with the error "This action cannot be performed because this field is not modifiable". It does this on every field. However, if I go to the original table, I can enter record…
-
- 2 replies
- 1.8k views
-
-
In all of my portals, I always get an extra portal row/record at the end. I do allow records to be created via the relationship, but is there anyway to disable this?
-
- 2 replies
- 1.4k views
-
-
For my invoice table, I have a Trailing Grand Summary part. All it really lists is the total for the invoice, but it's important that this total be near the bottom of the last page (above the footer). Being a trailing grand summary, it already appears on only the last page as it should, but is there any way to cause it to appear at the bottom, instead of right after the invoice's body? I can expand the height of the summary, but since each invoice is a different length, it sometimes jumps to the top of the next page.
-
- 1 reply
- 1.3k views
-
-
Hi everyone, I have a portal with around 2000 records in it, sorted alphabetically . What I'd like to do is put a search field above the portal where I can enter a few letters from the name of one of the records and have the portal only show records that start with those letters. Like if a record I wanted to find was called "Anderson", I would just enter "and" and the portal would only show records that started with that. This would let me narrow the portal down and quickly find the record I'm looking for. I saw another post that suggested using a global field as the search field and using that in a relationship to the name of the record. However, I think that w…
-
- 2 replies
- 1.3k views
-
-
dear peepz, i have to warn you that although i am an experienced programmer and database designer, i am a total newbie when it comes to filemaker. so bear with me. i was wondering if it is possible for filemaker to automatically create a new record in another table when a new entry is made. for example:- table1: pk id_no, name, address, contact_no table2: fk id_no, field1, field2 so when i create a new record in table1, i want filemaker to automatically create a new record in table 2 for me. i have established the relationship between the each table in my database. for the convenience of my users, i have created a form where the subtable/child t…
-
- 2 replies
- 1.1k views
-
-
Hello I have a summary field in a portal that summarizes a monetary value for like records having the same value for another qualifying field in the portal: Field1 Field2 Field3 00001 $100 $300 00001 $200 $300 00002 $500 $500 My issue is when I enter data for a new record in this portal (which is sorted for the summary field), the sort instantly occurs when I first enter the value for the first field. This messes up data entry because the field where the cursor ends up after the instant sort is not the field in the new record. Is there any way to have a summary field in a portal where the sort d…
-
- 0 replies
- 965 views
-
-
I am making a Football Stat database and I don't know what I did to make my Portal not show up anymore. I have attached links to 2 files, FootballWorks and FootballDoesnt. I want the FootballDoesnt file to be the one I keep. Here is how my database should work. Enter the game data on Game Stats screen and it should show up on Player Stats screen in the portal which draws from Players Table and Freshman Stats graph. I am only concerned right now about the Freshman Passing stats for Ben Konen (only one with stats on both) because once I get this fixed, I can get the rest. Now it looks like the relationships are the same in each graph. Why won't this work in Footb…
-
- 0 replies
- 1k views
-
-
Hi all I am new to FM. when I was using MS access it was easy to create drop down lists to filter related records only. you can do that using find mode and after you make your choice you press find. I was looking for a way that helps me to do this as soon i change the content of the drop list without the need to enter the find mode. I appreciate your help.
-
- 7 replies
- 6.5k views
-
-
hello i have a layout [in listview] and want to trigger a script whenever user clicks on the layout [outside the fields]. almost all the fields on the layout are locked and cannot be clicked in/on with the exception of one field which is active for some calculations. this field must keep a focus all the time for the calculations to work. this is the only reason why i want a layout level script to prevent the user from losing the focus on that field and when the user clicks on the layout i reset the focus back to that field. so this way field will never lose the focus [hopefully]. so how can i link a script to the layout for this purpose? thanx in advance. …
-
- 13 replies
- 2.1k views
-
-
I have searched to find a solution to what is probably a very simple question. I have a client layout with a portal that displays all the invoices for that client. I want to limit the portal display to a specific year. Tried creating a global field gFilter which I related to the Year field. Then set the value of the gFilter in a script to use as a find but that did not work. There are a number of portal queries in the Forum but I have not been able to get any of them to fit my circumstance or possibly I have not understood them. Any help greatly appreciated. Thanks Mitch
-
- 4 replies
- 1.5k views
-
-
How do I show a portal's summary field on the layout of the parent table? When I put a portal summary field in a layout of the parent table it gives me the the summary of the related record only.
-
- 3 replies
- 5.1k views
-
-
Hi, I have a field with a file path and I want to extract just a word from it, how I do it? Example: file: //Mac/Users/Me/Documents/Images/ProjectA/sculptures/A1.jpg returns: sculptures file: //Mac/Users/Me/Documents/Images/ProjectB/photographs/File5abc.jpg returns: photographs
-
- 4 replies
- 1.8k views
-
-
I have a conditional valuelist based on a field that shows dates. I need to sort the date values in descending order with the most recent date appearing at the top of the list. But FileMaker wants to keep sorting the values "alphabetically" which puts dates in an ascending order. HELP???!! :
-
- 3 replies
- 10.7k views
-
-
I have a database of transactions that contains a 38,000 unique transaction numbers and customer number field. There are dramatically more transactions than customers. I want to generate a report that looks something like this: 1 transactions - 30,000 2 transactions - 5,000 3 transactions - 2,500 4 transactions - 400 5 transactions - 90 7 transactions - 4 11 transactions - 1 Total Transactions - 38,000 The report simply tells me how many repeat customers i have. How do i create a report that looks like this? I've included the data.
-
- 17 replies
- 2.4k views
-
-
I would like to change the color of a text button using conditional formatting. The formula needs to be based on the priviledges of the user on the linked layout (forward). When I use "Get ( LayoutAccess ) > 0", it is just returning the access of the layout the user is currently on. I need it to read the access of the layout the button links to. Any thoughts of how to do this? thanks,
-
- 9 replies
- 2.1k views
-
-
Hi All, I am having a hard time trying to explain this one! I have a database for a tradeshow. I want to keep the same database for each year of the show to hold history, money spent, points, etc. I have built a portal to capture this data. The problem I am having is there is a booth# field that is unique but if one of the years show has past and we go into the second year (same portal) all the booth numbers are taken because its looking at the year prior. Do i need a calculation to fix this or is the portal a bad idea to capture this?
-
- 9 replies
- 1.6k views
-
-
I have a boatload of daily transactions that i want to create a report with. Comparing revenue from one year to the next. How do I create a report that shows 2005 sales and 2006 side by side? It would look something like this: DATE - 2005 - 2006 -------------------------------- Jan 1 - $1234 - $3456 Jan 2 - $3456 - $2341 Jan 3 - $567 - $97 Etc. --------------------------------- Jan Totals - $5287 - $5894 I've enclosed some sample data. Thanks in advance for your help! Peter 2005_2006_transactions.txt.zip
-
- 0 replies
- 1.1k views
-
-
Hi, I'm trying to use a hard coded filter for value lists similar to a WHERE clause in SQL. I have one table with the main records and three "settings" fields. The user should be able to select a value for each of these settings from a value list displayed in a drop down. My problem is that I want to use values from a single table for all three but I want the value list to be filtered: one field in the table with the values is called "selectionType" and contains either the number 1, 2 or 3. For "settings 1" I would like to only display the values that have the number 1 in the field "selectionType". In SQL this would be so simple to just specify "WHERE selectionT…
-
- 6 replies
- 3.7k views
-
-
I have an invoice database that lists all items in a portal, and is designed to print them. The portal is 32 rows, which it prints. A script then rolls the portal down to show the next 32 rows, and print them as well, until it nears the end. When the script realizes that it won't be able to scroll another 32 rows, it simply goes to the end. My problem is that, for an invoice, I can't be printing the same data twice. This occurs at the end, when the portal only scrolls, say, 17 rows. The 15 rows above that would appear on this page, as well as the one I printed last. I'm wondering, is there any way to purposely get FM to dynamically show more empty rows at the…
-
- 9 replies
- 1.7k views
-
-
My current layout is centered around a table containing RMA information. We then have a portal that contains information about individual products. I'd like to add a field that would be for problem diagnostics. The only problem with this is that a single field per product isn't cutting it. Thus, my first thought: A portal in a portal! Well, that didn't work. I would assume it didn't work because the newly created portal is still related to the main table, even though it's inside of another portal. Bummer. Now, making a new layout that is centered around the products, rather than the RMA records is not an option, as the records are most commonly brows…
-
- 4 replies
- 13.7k views
-
-
Is there any way to zoom to 125%? 100% is too small and 150% is too big. :
-
- 1 reply
- 2.1k views
-
-
Help. Sorry, I've seen posts about this but for some reason, they don't seem to help me. Simplified: Fields: APPROVED CONTRACT_PRICE CONTRACT_PRICE is typically editable. But, if APPROVED is checked, or not IsEmpty or whatever, CONTRACT_PRICE becomes not editable. *I am not using buttons to initiate any scripts. *I'm assuming I can do this as a calculation w/in one of the the two fields. *I don't know where and I don't know what functions/language to say "Don't make this field editable anymore". Thanks a bunch.
-
- 2 replies
- 1.9k views
-
-
Hello all. The kind young person who's testing my database form is having trouble copying information from one portal's field and into another portal's field. However, when I log in as administrator and use the same data entry form I can copy and paste as much as I like. The data entry user's account has privileges to change records in all tables and layouts, so I'm puzzled about this. Please offer me some ideas about what the problem might be? I mean other than that I'm a rank beginner who's in over his head, of course. I already know that. Thank you.
-
- 2 replies
- 1.3k views
-
-
I have looked all over for a solution that should be fairly simple. I don't know if I am asking the wrong questions or not understanding the posts I've viewed. What is so hard about summarizing a simple two value value list? It is for specifying gender. The value list is "F" or "M". If you can't summarize a value list what is the point of a value list? I have spent hours and hours on this problem without success. I have tried extracting "F" to an intermediate field called "Female" and "M" to an intermediate field called "Male" but this no longer works and I don't know why. It worked in an earlier 8.5 version of the database. Shouldn't this be a simple operation?
-
- 24 replies
- 5.5k views
-
-
I am creating a layout that will eventually be exported as a pdf and emailed, I have not gotten to the difficult parts of this yet, but have designed a basic layout. The problem is that all i have put on the layout so far is some text and a date field, when i switch to preview mode to see what it will look like the page is blank. what did i miss here?
-
- 5 replies
- 1.6k views
-
-
I have a table related to its child,(that holds related data),the relation is built by auto generated serial(like usual) The portal works all fine and always create a new records as its past on is filled. But i want to create a button that creates new rows without being needed filling past records. Will help alot in IWP!!
-
- 1 reply
- 1.5k views
-
-
I have 2 tables - one is the main customer log and the other is a table to collect 'Next Action' dates. I have a script set-up so that when you click on "Next" to move between records it will automatically create a 'Next Action' record for that lead in the next action table. I have a portal created in the Main customer log to show a log of all next actions. For some reason the portal information is not showing up. I checked in the next action table and there is a record for a lead number (this is how the tables are linked) with all of the information filled in, but in the portal in the main customer log it is not showing up. I'm not sure why it's missing?
-
- 1 reply
- 1.1k views
-
-
hello... is it possible to have multiple headers on a layout? like one at the top [default] and one on the left/right of the layout with body after it. the reason why i want to know is because i want to hide the status area bar and add my own there in that very same space/place. also layout is a listview that is why i want the top header for logo and headings for the columns. : something like this... =============================================== LOGO / HEADINGS HERE [TOP HEADER] =============================================== LEFT HEADER | BUTTON 001 | BODY OF THE LAYOUT IN LISTVIEW BUTTON 002 | BUTTON 003 | BUTTON 004 | BUTTON 005…
-
- 7 replies
- 1.7k views
-
-
I've decided I want to hide the left status area. I have easily put the total record count and record number on my layout. Even if the records were unsorted, the status bar showed an incremental record number. In other words, what I have right now on my layout is shows "3 of 97" then the next one may be "45 of 97" etc. The status bar whether sorted or not kept this incremental, is there anyway to mimic this?
-
- 5 replies
- 1.5k views
-
-
i have a list based layout which i would really like to turn through 90 degrees ie headings on the left with records in columns left to right any ideas?
-
- 2 replies
- 899 views
-
-
I am looking for the easiest way to grab an image from an Axis network camera whilst in Filemaker. I had the idea of using the web browser to view the image by setting the url to the net address of the camera. I Then want to capture this image in a container field. Does anybody know if this is possible? I have looked around for a plugin but apart from an old Troi one that's no longer supported , I came up with nothing. thanks
-
- 1 reply
- 1.4k views
-
-
I have youmehub 2, a filemaker pro database... I need some help in getting my address and logo properly inserted into the invoice. The "email invoice" button generates a PDF as a mail attachment in Apple mail and sends it to the contact recipient. There is no place to edit an invoice template, like in their version 3 program. I can upload my logo for letterheads, and this gets used for invoices, but nothing else: I just want to get my address on the invoice... stupid stupid developers for not including the company address in their invoice code. Also, my logo is blurry, even though it is a PNG file. It looks good before the import, looks horrible on the invoice. …
-
- 2 replies
- 1.2k views
-
-
We recently had a fellow whom, being very proud of his Irish heritage, wondered why our system always displayed his name in title case, rather than allowing for a second capital letter in his family name. I figured that this was a simple formatting issue, but I can't seem to turn it off. When the field was originally defined it had an auto replace calc on it to set the contents of the field to title case, but that is switched off at this point. The reformatting happens as the name is being keyed; not at commitment. Anyone have any ideas? At this point it just seems bizarre to me.
-
- 12 replies
- 2.2k views
-
-
PROBLEM: I am trying to display a portal of only those Activities that have not reached capacity yet. I know the problem is as follows: Reservations Layout Reservations::ActivityAvailabilityLink (Which I have created an auto enter field of “1” to use as a link – this may not be the best way to do this either) Times2::RemainingCapacity (this is a calc field – which I know is the problem – but I need to display only those “activities” that have not reached capacity yet) Any ideas? QuikTiks.zip
-
- 2 replies
- 1.2k views
-
-
Hey everyone, what I'm hoping to create is a check box menu for users to select which fields they wish to see, clicking on a button, and then seeing a table view of all the records with only their chosen fields visible. Is there any way to accomplish this? Thanks for your help
-
- 0 replies
- 1.1k views
-
-
Hi, I'm hoping someone can help me out. I'm a bit of a beginner with some of the more advanced filemaker features - specifically with calculations and formulas. I am hoping someone can help me with a portal filter solution. I'll try to describe the specific sections of my database as best I can so you can understand what I am doing. I have a database setup with a bit of a time/expense tracking system for consultants working on projects and tasks. Along with this, we have built a budgeting feature so we can provide an estimated cost for fees and expenses on a project to compare against actual fees costs for each project and task. I have a numbe…
-
- 3 replies
- 1.3k views
-
-
Hello, I have a situation where I have a Customer Table and Invoice table and I have them merged on a layout I call Sales Slips. I want to be able to add new customers to the customer tables, but if they are repeat buyers, I don't want to be typing their information again, because then I would have a duplicate entry. So.... I need a way to still add new customers, but at the same time have filemaker tell me if it is a repeat buyer so I can just use their information again for another invoice. I know this is probably hard to follow so let me know if something needs clarifying, otherwise any help would be appreciated, thanks - Jeff
-
- 4 replies
- 1.2k views
-
-
hello as the topic says, i want to disable or completely remove/hide the top right corner buttons [clsoe,min,max] of a popup window n limit the user to a button only to close the current active window. the reason to do is that the button is linked to a script for some calculation and i don't want the user to create problem by using the window [x] button to close it and by-passing the script. so how can i accomplish this? thanx in advance for the help.
-
- 6 replies
- 5.8k views
-
-
I've developed a pretty nice database for running my cabinetshop. Most of the components are in place and running well. I'm having problems, however, with one report. I need to develop a document that shows task fields in a column and cabinet identification numbers in a grid. I can generate this report easily in MS Excel but this would be the only component for my cabinetshop that comes from the dark side. Can anybody tell me how to generate a filemaker layout that looks like this, or is there anybody available to hire for this purpose? Thanks for looking at my problem, Jarvis table.jpg.zip
-
- 10 replies
- 2.2k views
-
-
I have a bunch of nav buttons for the user on top (to navigate from one layout to the next) How do I display the button for the layout the user is on? Different color? How do I make it look like it's pressed? What is the best practice? Thanks in advance
-
- 1 reply
- 995 views
-
-
Hi Guys I'm fairly new to file maker and would like to make entering data into a description field easier. The area for entering the data is quite small, however, as the data is entered it enlarges the data field. When entering large amount of data I would like the box to open up - eg - when I enter information into an "other" area - a window opens and the data can be entered. In other programs I have used - when the edit box is double clicked - a window opens up which can be sized up as needed. In this way it is clearer to see the information entered. Question - Is there a way to set this up in Filemaker9 pro : Thanks for your assistance. …
-
- 5 replies
- 1.7k views
-
-
Hello, I am trying to print a list of products by category from our inventory list with each category name being printed first then indented underneath the complete list of products in this category. At the end of the product list for a specific category it would print the next one with its complete list of products and so on. I would like the list not to break for a new page when it's reaching the end of a particular category. This obviously involved a loop (for checking all categories one at a time) with a loop inside to check all the products within each category. What is the best way of achieving this goal? Thank you in advance for your help.
-
- 2 replies
- 1.1k views
-
-
I'm wondering if there is a way to make a certain part of a layout not printer, like the header or footer, I know I can do it with fields and objects in the set sliding/printing option, but I want to make it so that my header does not print and for the layout to start printing at the beginning of the body of the layout, thanks - Jeff
-
- 3 replies
- 1.2k views
-
-
Hi, Here's the picture, I have a database with a table invoice and a table employee. Each invoice is related to an employee who created it. 1-to-many relationship. Invoice (pkInvoiceID, ..., fkEmployeeID) Employee (pkEmployeeID, ..., isActive) Some employees don't work anymore for the store, there's a field named isActive which is a boolean (number). In the invoice layout, I'm trying to make a value list with only the active employee, but without success. Is there a way to do value list which represent this query "Select * from Employe where isActive=true"? Thank you
-
- 4 replies
- 1.6k views
-
-
Is it possible to display all records of a table in a portal that doesn't relate to any other table? What I'm trying to do is displaying all the records of a a table through a portal. Can it be done?
-
- 1 reply
- 1.2k views
-
-
I am trying to show related records where the relationship is based on unstored calc. Please take a look at the attached file. Any suggestion will be highly appreciated. Thanks InvPmt.ZIP
-
- 5 replies
- 1.4k views
-
-
Is there a way to open a new window (sized correctly) on top of the main window. I have made a script that opens a new window but the main window resizes when I do this. I need to be able to make a new window open on top of the current window without the main window resizing. Also is there any way to take off the thick blue header on the new window -- not needed. Any ideas? Joseph
-
- 5 replies
- 7.3k views
-
-
I'd like to make a back button which returns the user to the previous layout. Any suggestions on how to make this happen? Thanks.
-
- 1 reply
- 1.3k views
-
-
How can I make a filed change text color based on input? For example, if I type "red", the text "red" turns into red. Thanks
-
- 1 reply
- 3.3k views
-
-
When viewing an [color:purple]Order record, I have a portal for [color:purple]Items Ordered. Inside this portal is a container field from [color:purple]Inventory showing a photo of the item ordered. It all works fine when viewed in Filemaker, but when viewed online the images don't load. All that shows is a box with a ? inside of it. Also, for some reason the scroll bars don't show on any of my portals when viewed online (but they do in Filemaker). Someone using a slower internet connection than me said they saw the images for a split second before they went to "?" I tried moving the container field outside of the portal onto the main body of the layout and…
-
- 1 reply
- 1.2k views
-
-
Hello I am working on a contacts database which requires companies to be classified by Category and then sub-category. So for example, emergency services would be sub categorised as fire ,police etc. Basically I would like to limit the choices on the sub-category field according to what is entered in the main category field ie if category emergency services is selected then only choices related to that category are available (by drop down list), in the sub category. If someone could point me in the right direction re scripting I would be very grateful
-
- 2 replies
- 1k views
-
-
i want to be able to view a found set of records individually on the left of my layout and as a list via a portal on the right so i can then get an overview of the whole set. i have found examples of this but cant get my head around how to dissect them! thanks
-
- 3 replies
- 1.4k views
-
-
I am trying to get a drop down list to only display the values based on another table For instance, if I select in College- Science, then the departments for Art or History should not show up I am doing something really silly as it's not working Any help would be greatly appreciated. Thanks in advance samplecollege.fp7.zip
-
- 1 reply
- 1.3k views
-
-
I am setting up a database for my emails but the junk mail is killing me. I have set up elaborate rules to get rid of the junk but some always comes through. What I am trying to figure out is how to select multiple records at once in a table layout and delete them. I want to be able to check records 1-3, record 6, and reocrds 11-30 for example as they are all junk mail. The problem is that hitting delete for each one is tedious. Does anyone know a way to just click on a grouping of records in the table layout so that they can be deleted together once Im done picking through all the records? I have attached some samples of what im dealing with. Thanks mail.fp7…
-
- 8 replies
- 2k views
-
-
I have a portal in a layout. The layout only has one record and I related the table to a global field in the table for the portal so it currently shows all records in that table. What I want it to do is when the layout is opened it will filter the portal's records to be only when the staff field is the same as the logged in account (using a get function). Is there a way to filter the portal records like this or should I give up and put this data in a separate window.
-
- 8 replies
- 1.3k views
-
-
On Filemaker Pro 9 I have set up a field with numeric values as a currency with two decimal places (e.g. £100.00) however, when this information is merged over to a Layout that i have set up, the merge field only appears as 100 without the £ or the decimal places. The two decimal places only appear if they are not zeroes. Please can anyone advise how i can enable this field to merge as it is shown originally? Thanks
-
- 1 reply
- 1.1k views
-
-
Basically I have a portal in Order layout which displays records from Line Items. I would like to be able to sort the portal by each field that is in portal (I have field labels above the portal identifying each field) - for example: Item Cost Total Row 1 IT001 25.00 25.00 Row 2 IT002 35.00 35.00 So when Item is clicked it would sort by item, when Total is clicked it would sort by Total. I have searched here on forums and have found some methods on how to accomplish this. One involved creating relationships and setting the sort orders there. That would mean that I would have to create as many relationships as I have …
-
- 9 replies
- 2.3k views
-
-
Hi, I'm trying to make FileMaker open and span the application screen (window desktop) across two monitors. Is that possible within FM? If not, would I need to use an VB Script or AppleScript triggered by an SendEvent Script within FM? Thanks in advance, Peter
-
- 0 replies
- 1.2k views
-
-
I thought I'd try building an interface that used conditional formatting instead of the status area to indicate Find status but I'm running into some odd things. 1) Get(RequestOmitState) doesn't update immediately. The function will update in the Data Viewer, but not the formatting, until I perform a script step or navigate to another request. 2) Both G(ROS) and Get(RequestCount) persist even when in Browse, Preview, or Layout Mode. I guess FM is storing the request for the Modify Last Find and Perform Find[] script steps. Both are easy to work around (1-change the button from running the Omit script step to a script that runs the Omit step followed by …
-
- 0 replies
- 1.3k views
-
-
Hi, I apologize for this dumb question. I have a line item db which consists of cust #, inv #, date of inv, item code, item description, amount. There is an invoice layout with a subsummary. If I manually select each inv #, I can print the invoice without issues. My boss wants to enter one invoice date in a find, which would return a large group of records, and print all invoices based on inv #. Currently, all found records (based on the date) print on the invoice, regardless of inv #. Within the found date, how do I tell FM to print all the line items associated with that invoice #, then move on to the next, and the next?
-
- 5 replies
- 3.4k views
-
-
Is there a way to make a field perform a specific search? Say I want to find all records with "Colt" in them, I want to type "Colt" in the single field and have it search all records for that word. Any advice?
-
- 13 replies
- 2.2k views
-
-
New Member. Have been using Filemaker for ages and now am starting to get a bit more advanced. I have been developing a database and it is a main file that allows the creation of portals rows in a related table. Each record in the reference table auto enters a incremental number. The portal is then sorted by this number. I am trying to find a way of changing the sort order i.e. moving records up and down in the portal by swapping the previous records unique number with the one after or before thereby swapping the order up or down. Have tried and tried and not got anywhere and am now asking for help. thanks Duncan
-
- 4 replies
- 1.4k views
-
-
Does any one know why, or how to solve, that when the cursor is in a FM field, that after Dashboard is invoked the user needs to re-click into the very field that the cursor was and remains in, and where the focus still apparently is, in order to continue typing?
-
- 3 replies
- 1.2k views
-
-
Does anyone know how to crack a password for FileMaker 4.0 PC version? We are updating the database and the end user forgot the admin password. Any Ideas? Thanks Rob
-
- 0 replies
- 1.1k views
-
-
ok, i have a table that holds all of my customer's data (name, address, and id) i have another table (linked by id) that holds a 'call history' that has the following fields: id date time call notes contact name technician now...i have a layout designed that has a portal inside of it to show all of the call history for that customer. my problem is that i want it to automatically fill in the "id" field with the value of the "id" field in the customer info table. is this even possible?
-
- 3 replies
- 1.5k views
-
-
hello... i have 3 fields [type [listbox], date1, date2]... i want to set/reset date-field-1 and date-field-2 to blank [if not already blank] if a user changes the value of drop-down-list-box. for example initial value selected... Value selected = 1 date 1 = 12/12/2007 date 2 = 12/12/2006 and then when the user selects value selected = 2 date 1 = "" [changes/reset to blank] date 2 = "" [changes/reset to blank] also i want to keep date 1 and date 2 fields active to receive input from user. so how can i accomplish this? thanx in advance for ur help and input.
-
- 7 replies
- 1.8k views
-
-
I am entering text only on a set of layouts providing "help" information. Some of the text areas automatically return to the next line as I type. Other areas push the right hand margin further to the right if I don't do a manual carriage return. I can't find the setting that makes the return to next line automatic. Thanks in advance for any shared knowledge.
-
- 3 replies
- 1.3k views
-
-
Is there a way to have an IF function return a graphic if the criterion is met? Let's say, IF ( This = That , {graphic} , "" )
-
- 3 replies
- 1.4k views
-
-
Hi Folks, I haven't been able to find a definitive answer on this. I am researching the feasability of using a web-published FileMaker database to collect information from projects. Here'a a scenario: I created a quickie test DB using a template. I edited a few fields. I changed one field to "Projects" and then imported the Project names from my primary FileMaker database. I have 2 primary questions: 1)I would like Projects to then be able to go to this new database via the Web, select their project, then fill out a few fields and potentially attach a .pdf file and perhaps a .jpg. Has anyone done this? 2) Some Projects may also have video clips, although I …
-
- 2 replies
- 1.2k views
-
-
I have set up a text field as a button script so that it takes me to another layout when clicked. But sometimes I want to enter the field instead and have therefore set the script so that holding down the shift key will go to the field instead of switching layouts. This works fine in principle. However, the script is disrupted if the conditional formatting for the field is set in a particular way. In those cases the shift key doesn’t work and I get a 102 error. I’ve attached two files. In Format1 everything works as it ought to. In Format2 I have the shift key problem. The only difference between the 2 files is that the conditional format command for the t…
-
- 2 replies
- 1.6k views
-
-
I have set some fields to change font colour when certain conditions in other fields are met. This works most of the time. But some fields in some records do not operate the change when the condition is met. In some records the change happens, but in others it doesn't. This is independent of the layout too (i.e. same problem with the same record in different layouts.) The only way I can get the formatting to work is to clear the relevant field data in the problematic record and then retype it in. Then it works. But this doesn't work if I copy and paste the data, or copy it to another field and then copy it back, or if I use the set field command, so there is no…
-
- 4 replies
- 1.9k views
-
-
I am having trouble relating three drop-down boxes to each other correctly. There are three related tables: Item Categories (Category_ID) Item Makes (Make_ID, Category_ID) Item Models (Model_ID, Make_ID) The Item table has a field called Model_ID from which I can draw the name values for Model, Make, and Category based on their related fields, and concatenate them all together (example: CPU PC - Dell - Optiplex GX620). I have no trouble displaying that information if the item already has a Model_ID, and, in fact, that is how I'm allowing the user to select the Model_ID for a new item now--one HUGE dropdown box (because there are a LOT of models). I need…
-
- 5 replies
- 1.7k views
-
-
I'm having trouble with a Contact list within a portal for our Suppliers (ie having multiple contact for each supplier complete with name, nbrs, email address etc). I have an ID field that is set to create a serial number and increment by one for each entry. The relationship is set between the portal ID and portal ID on the parent Supplier entry. My problem is that each entry within the portal has the same ID number (although if I enter ten entries into one supplier, the next portal entry in another supplier has a serial number eleven higher than the previous)> Not sure if I have explained this well and I'm sure it's simple, but I am complete numpty. Please f…
-
- 5 replies
- 1.6k views
-
-
Hi, I was wondering if there is a function or script that would automatically resize user input text in a field so that it fits to the box. I have a form that requires user input, as well as the ability to print the form, so if a user inputs a lot of text into one field, I have to have it so that it makes the font smaller to fit in the box. Is this possible? Thanks for your help!
-
- 3 replies
- 2.1k views
-
-
I am getting a following error when pointing the viewer to: http://pages.ebay.com/help/sell/fees.html * I store the url in a global field and point the viewer to get the url from the field. The error: A runtime error has occurred. Do you wish to debug? Line: 11 Error:'vjo.darwin.core.ebayheader.rebate.Rebate' is null or not an object Anyone has any info on the error or how to get rid of it?
-
- 0 replies
- 1.3k views
-
-
I have a database with pilots names, aircraft flown, hours, etc. I am having a meeting tomorrow with some people in my dept and want to bring a list of this basic information. However, with the layout I made the 5 necessary fields are next to each other across the top of the page, which is what I want, but the layout only prints one record per page. I want to have multiple records per page so that I won't waste a million sheets of paper. How do I make it so that I can use multiple records per page?
-
- 2 replies
- 1.6k views
-
-
I have a new PROJECT table which is related to the main table with the main ID. I plan to use the Project table to keep track of all actions for each project. In the main table, a found set of 2000 people are assigned to ProjectA. How can I create the 2000 records in the project table and put them in ProjectA? Thanks for any help! -Sal
-
- 4 replies
- 1.3k views
-
-
hello... as the topic says, i want to open a popup window [though a button in main window] without resizing the main window. as of now, whenever i open the popup window it resizes the main window which i don't want. is there any way to accomplish this? thanx in advance.
-
- 1 reply
- 3.9k views
-
-
hello again... i have a portal showing 100s of records for 100s of patients. but i only want to show the last two records for each patient. i don't want to keep these records in DB aswell [except the last 2 for each patient]. so i want to know how can i delete these records from db, leaving only the last two records for each patient. i was thinking whether looping through records for each patient and delete them one by one will be a possibility? or is there some other easy way to achieve it? i only want the last/latest two records and nothing of the rest. PS: records are being displayed in a portal. thanx.
-
- 2 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.