FileMaker Interface Features
-
Hello, This is on FMP 6. Here is my layout: Header Fields Portal (set to display 10 rows) Fields Footer When printing with more than 10 records in my portal, it will only print out 10. How do I get it to print the remaining records in the portal to print out as a 2nd page? So with records with 12 records in the portal: So page 1: Header Fields Portal (prints first 10 rows) Fields Footer So page 2: Header Fields Portal (prints with the remaining 2 rows) Fields Footer (without sliding to fit all of it in 1 page)
-
- 2 replies
- 1.9k views
-
-
Hello, I've created a database which tracks inventory. Some of the inventory items are "assets." My main layout page uses a portal to display the line items from each physical box where the various inventory items are physically stored. I'd like for the "asset" items on this list to appear in red. Each line item includes an asset field which records a "yes" or "no" entry. My current formula is: Inventory::Asset? = "Yes" However, this only works on the FIRST line item in the portal. Why is this? How can I get the formula to apply to ALL 20 displayed line items? (I initially had my db set up with fields "item 1" "item 2" "item 3" and so on...th…
-
- 2 replies
- 2.1k views
-
-
I don't suppose there's anyway to have custom-shaped buttons. like if you wanted a map of the 48 states with the area of each state being it's own button. I'm surprised that filemaker made that pretty impossible. (so i'm wondering if there's any chance that there's a way i have not discovered) even, if there were a way to group lines, and make their shape into a button, but there seems to be no way, because the only the actual lines would be buttons, not the shape.
-
- 12 replies
- 3.3k views
-
-
Greetings! I've working with a database of artists contracts which we have the physical contract scanned into PDF's on a shared network server. Currently using FMP 10 Adv. and not on server 10 yet but will be installing it soon. My end goal is to have IWP access so users can access via any browser with a log in. When they look at a contract I would like for them to view the pdf either in the web viewer or create an open URL button to open the file in adobe or a new window of a web browser. The Open URL would be more ideal as some contracts are 30+ pages. I can get this to work in Internet explorer 8, and the IWP works fine with firefox and chrome but when…
-
- 2 replies
- 2.9k views
-
-
Hi, I have this problem: I have a portal with different clients, and I'd need to include in the portal line another little portal... I've read here in the forum that 'portals into portals' don't work, but what should I do to solve my need? Now I have 3 different fields in the portal line, but I don't know how to produce reports joining that 3 fields contentss... please help!!! Thanks a lot people!!!
-
- 3 replies
- 1.4k views
-
-
Just starting to use my new MacBook Pro with Snow Leopard and my new Filemaker Pro 10. When I open my old files I was using on my Powerbook running Tiger and with Filemaker Pro 8.5, text fields are showing all of the words underlined in red, even words that are spelled correctly. Can't figure out why. And when you use the spell checker, there are no suggested spellings for these common words. Any ideas?
-
- 0 replies
- 5k views
-
-
I would like to have a layout as an invoices overview. First portal: shows open invoices second portal: shows closed invoices third portal: shows invoices created today As you could see the 3 portals uses the same table (invoices) How could I do this? Thanks a lot by ChiSao
-
- 2 replies
- 1.2k views
-
-
Is it possible to fire a script whenever the user navigates to a different page within the web viewer? I have tried using GetLayoutObjectAttribute ( "Viewer" , "source" ) in an unstored calculation field, but that doesn't seem to auto-update when the user navigates. If I can get that working, I think I'll be able to fire a script when the calculation field changes (using a plug-in), but that seems overly complicated. Plus I'm not sure that it will work. Is there an easier way to do this?
-
- 0 replies
- 1.3k views
-
-
Quick question, How would I set up the web viewer to go straight to Street view? I have a real estate solution i am working on and would like the web viewer to show the street view of a particular property. Thank you in advance, Anderson
-
- 1 reply
- 2.2k views
-
-
Here is my issue. We got in a new laptop that has the number pad on the right. When I am in a field and number lock is off and I hit the enter key it works great. If I turn on number lock and hit the enter key it will tab to the next field. I wish it to ad another line. I looked at the behavior and only tab is selected for moving to the next field. Thanks Thom
-
- 6 replies
- 17.5k views
-
-
Hsppy New Year and thanks all for your help, especially yesterday! I have a field that has a calculation on it that looks at a field and then copies the contents into the field so that I will hopefully be able to use it for printing labels. The calc code I used was: If (AF1L1P1 = "YES" ; AF1L1N1)& If (AF1L1P2 = "YES" ; AF1L1N2)& If (AF1L1P3 = "YES" ; AF1L1N3) etc... The problem is all the text copies but leaves no spaces inbetween. I would like a line break inbetween the text. Is this possible? Thanks all
-
- 3 replies
- 1.1k views
-
-
Hi, Thanks for the previous help. I'm almost there now!! I want to have previously entered data on fields for all of my records. I thought I could use the auto-enter data option but this only works on the fields where I have just put the conditional formatting. When browseing the remaining fields remain blank. Any ideas? Thanks
-
- 9 replies
- 1.8k views
-
-
Hi, It seems an easy task but I've been going around in circles!! I have a radio button with "yes","no" and "working towards"(WT) I would like the text color to change in another field if yes, no or wt is pressed.(I'm using fm10) Thanks all.
-
- 3 replies
- 2.7k views
-
-
I have a filtered portal that shows an account # & account name which works fine. I would like to allow the user to select a row, have the row selected highlighted to confirm his selection then insert the account # into the primary table. I don't know how to do this but feel it must be something done quite often. Can anyone offer suggestions as to how to set this up?
-
- 11 replies
- 2.4k views
-
-
Hello Filemaker world i am having a problem with portals im trying to make a cash register system for my work i have it so when you click a button it creates a new record in another table i would like then for that record to show up in the portal on the main page i think i have the relationship wrong or something Thank you in advance! Register.zip
-
- 4 replies
- 1.6k views
-
-
Is there a way to limit the browsing to just one website? Also, websites with username and password restrictions, I tried writing a URL to automatically enter that then submit, unfortunately, I have not been successful. Is this even possible? Thank you for any help.
-
- 0 replies
- 1.3k views
-
-
Can anyone lend a hand. I am trying to make a report that uses two tables. I have a table called “visain” and table called “cashout”. What I am trying to do is track the visa card (who turned it in and who cashouted it out. Sometimes the card comes in and gos out several times. Each card has its own number.
-
- 9 replies
- 2k views
-
-
I created 7 tables for an invoice management solution. I find the seven layouts. But, only the primary key and Fk fields appear on the layouts. Why do the other fields like First name etc do not show in the Customer layout? M K
-
- 18 replies
- 4k views
-
-
I have tried and find very useable Mikhail Edoshin's approach to cross tab reports. I get the report in preview looking the I want, my problem is I don't want it in Preview [i have no interest in printing]. What I want is to see the whole thing in browse mode on a particular tab. Using Edoshin's approach I get only the last row of summed data. My question is: How can I show the whole array on the tab [i am using years as rows and months as columns with performance % in the fields]? I want to see each year and each of the corresponding month's performance.
-
- 2 replies
- 1.4k views
-
-
Hi All, I am wondering if anybody encountered an issue like this. " I am using global container fields to hold interface graphics and as soon as I exit the solution... all of the graphics in the container goes away!" I am lost with this and have been searching for the answer for days with an obvious answer of no success. Help! Allan :
-
- 3 replies
- 1.3k views
-
-
Is there a way to figure out what page a user is viewing with a PDF displayed in the web viewer?
-
- 0 replies
- 1.3k views
-
-
Hi there. I am stumped on this. I made my portal where I can select any number of different products offered and then enter the quantities to purchase. I want to then view this in another layout showing the invoice and all of the items purchased in the current record. I cannot figure out how to display this information. I have created a "Line Items" table with the relationship to my invoice.
-
- 4 replies
- 2.1k views
-
-
Hello. I've got a calc field (result: container) that gets filled with a graphic when a certain condition is met: Case ( IsEmpty ( Comments ) ; Global::gYellowBar ; "" ) When I place this field on a tab panel, it does not refresh. It only updates when placed besides tab panels. The only way to get it filled is by switching to layout mode and then back to browse mode. Any ideas why this happens? Thanks for your help... Mike
-
- 4 replies
- 3k views
-
-
I'm trying to do something like OP in http://www.fmforums.com/forum/showtopic.php?tid/179306/ What I'm trying to do is have a footer that appears at the end of every page. I want the footer to contain a "Comments" field as well Total$Amount. I want the "Comment" field to appear on every page but I want the Total$Amount ONLY to appear on the last page. Like the previous post, I'm trying to make a container with a white image and another as transparent. On a 3 page order, for example, the white image is over "EX_sLineTotal" on pages 1 and 2. However, on page 3, it is transparent and the "EX_sLineTotal" is visible. I'm having NO success. Any help? Plea…
-
- 12 replies
- 1.9k views
-
-
I am trying to list a found set of records down the side of a form view. I have a script to find the found set of categories but i would then like to go to any record of the found set by clicking on it in a portal down the side. I have tried to make a self join of the found set but a portal using this doesn't seem to work. Am I headed in the right direction, or is there something else I should be doing?
-
- 1 reply
- 1.2k views
-
-
Hi everyone, I'm trying to develop a medical database. My problem is: I' m trying to make a field about the status of smoking. Ex: Do you smoke? Yes (if yes nothing will happen) No (if no another field containig 2 other radio buttons and a text box will apear next to "no" button) How can I apply this trick to my database. Thank you.
-
- 11 replies
- 2.2k views
-
-
On the standard tool bar there is a Preview button. I have just noticed, however, that if i am looking at a record in Browse mode, and click the Preview button to see what it would look like printed, i get taken to another record instead of the one i was browsing. If i click on the Exit Preview, i am taken back to the correct record again, strange behavior or is there a setting to fix this?
-
- 3 replies
- 2.5k views
-
-
Hey, This is my first post on this forum and my first deep dive into Filemaker so please forgive me if what I ask is not possible or there is a simpler way. Essentially, I have a database that has a list of managers and the employees that report to them ...An example is below: Employee: Manager: David Josh Joe Josh Jack Josh Jeff Katy What I would like to do is produce a report/layout that shows a quick view of employee by manager. Perhaps in several portals? One for each manager? Or perhaps a cross tab report... The problem is that I am entirely unsure where to start and how to proceed. I …
-
- 14 replies
- 4.8k views
-
-
Hi, Is there a way to adjust the height of the rows in Table View? It's easy to adjust column width, but I can't find a way to adjust row height. With my previous databases, this hasn't been a problem, but for some reason with this database, the rows are very tall (the text is at the very top and the rest is empty space). Why would this be? Is there a way to correct it? Thanks!
-
- 4 replies
- 6.7k views
-
-
Hi, I'm learning Filemaker for a new project. I've been an expert Access user for the past 10+ years, so the subtle differences leave me scratching my head. Here's the issue... I have a table called Domain and a table called Category. Each have an * ID field, with the respective name, sequentially numbered, etc. The Category table has the Domain ID in it as a foreign key -- all is well and good. Each Category falls into a Domain. In Access, I would store the foreign key (Domain ID) in the field, but display the text value of interest (Domain Name) via the lookup to the other table. The interface would know there were 2 columns and that the field was bound to the…
-
- 2 replies
- 1.1k views
-
-
Hi. Long time listener, first time caller... I'm working on an art inventory database requiring nested categories. I have a categories table set up like this, using a self-join to assign parent categories: id parent_id title etc... This allows me to set up nested categories to any level, and I've set up a calculation field to show me the entire hierarchy for any given category, like this: cat1::cat2::cat3... I've also set up a join table to add multiple categories to inventory records, and a portal to select from a value list of all category values. So far so good... But I only want my users to be able to select categories with no childr…
-
- 4 replies
- 2.4k views
-
-
Does anyone have an easy way to set up breadcrumb navigation in FileMaker 9? I would like to have something that would be similar to a basic web browser but in a FM setting. Basic Forward and Back. Histroy would be a bonus but not necessary. Thanks, Eric
-
- 2 replies
- 1.6k views
-
-
I do not have much experience in FMP and am trying to create a database that tracks department assets on a movie. I have one main table with many fields, one of which is called "Set ID." A 2nd table contains "Set ID" as well as "Set Color" (I am using conditional formatting based on the corresponding color, otherwise I would simply list the Set ID as custom values list within the database) The 2nd table contains the list of 18 set IDs and corresponding color codes. In the layout for the 1st table I have attempted a drop-down list that includes the values from "Set ID" in the 2nd table. My problem is this: The ONLY way I can get the drop-down list to appear …
-
- 2 replies
- 1.3k views
-
-
Here is something I'm trying to do which I've found out is beyond my ability to figure out today. I am creating a database to hold government acts and regulations for quick lookup. I have attached a copy of the joins. I added the extra ID's being carried through because a duplicate number problem across regs and acts and this solved it and kept them easier to track. However... What I want to do is have only layout with a portal in it that lists the acts and regs by number so that I could just click on it and it would should show below the portal. For example Regs are by type;section;subsection;claus;subclaus. 1 (1) (a) (i) for example of course y…
-
- 4 replies
- 1.3k views
-
-
I have a portal that filters rows based on various criteria. The portal row has a checkbox that a user can select which activates relationship so she just sees the rows with the check boxes she selected. Works great in single user mode, but what is the best way to make it multiuser compatible? So that one user can select some checkboxes and another user another grouping of checkboxes and they just see the portal rows with their check box selected? Thanks very much for taking the time to respond. WB
-
- 5 replies
- 1.3k views
-
-
Good Day, I'm trying to create PDFs from a simple data input mask. For simplicity, I have a few fields pertaining to the originator of the report followed by three blocks of fields pertaining to separate aspects of the report. Each of these three 'blocks' of fields has one field that can either be 'applicable' or 'non applicable'. What I'm trying to do is create a function to print/save a PDF that checks whether the 'block' is applicable or not and then omits or includes that block in the PDF. Any help greatly appreciated! best, Mat ps: I'm trying to not have to create 7 layouts with all possible block combinations. I do realize that that's a poss…
-
- 6 replies
- 2.1k views
-
-
Howdy... Long time since I was here last, but hoping that one of the wizards here can help me nail this down. Anyway, writing a solution that creates a simple work order and it includes the usual entities like Contacts (or customer), Service (instead of product), Invoice, etc. The majority of the contacts come from a variety of Real Estate offices, they call and request an inspection service on a home they are negotiating. Many times they will ask us to invoice an Escrow company, which brings me to the scenario... Currently, to create a Work Order means locating that Contact (if they exist, is not creating a record for them first), and clicking the …
-
- 3 replies
- 1.6k views
-
-
I am trying to reduce the potential size of a Value List, that i use on a layout. I posted a previous thread about sorting, but think if possible, i would be better off removing no longer required values from the list. Currently the value list is a Simple: ALL Records from another field in another table. How can i use a calculated field to make up the Value List instead? When i tried it, i get a Cannot be Indexed alert, and i thus get not values populated in the Value List. I am trying to use a Cal field that states: Case(Job Card Processed ≠ "Job Costed";Job Number;"") This way if the Job has been costed, the Job No will not be listed in…
-
- 18 replies
- 4.1k views
-
-
I have created a architectural material database. Each tab is a different kind of material (eg. flooring, cladding, furniture). Each tab has the excact same field structure (name, description,distributor etc). I want to avoid people from using more that one tab in the same record so that each product is by itself. I thought of being able to use the field "name of product"(available on all tabs)only once for each record, by blocking data entry at the rest of the "name of product" fields in the remaining tabs. I hope this is clear enough. Is such thing possible? Do you have any better ideas? Any advice would be very much appreciated because I cannot find the answer. …
-
- 3 replies
- 2.3k views
-
-
I have a table with the fields: date, company and performance. On a different table I want to display for each company a row for each year and the performance by month along that row. It seems that I would want a portal but when I try that I get multiple rows for each year and some strange data for each month. At this point I am not sure if the problem is with my data table or just some simple thing with a portal. Does anyone have a solution? [i am using FM 10]
-
- 1 reply
- 1k views
-
-
Hi.. I am trying get the content of my layout to fit the resolution of my screen. I have build it in the highest resolution. I have achieved to make the screen fit to the size of the screen, but not the content. Thanks for any help in advanced!
-
- 0 replies
- 1.2k views
-
-
I have a portal on "student" layout that lists details of students' applications to schools (drawing from the "applications" table). Each row is one application. One of the fields for each row (application) tells me whether that school accepts materials by email with the value "Y". I want a field that gives the total number of Y's in the portal. I.e., how many of the schools a student is applying to that will take email submissions. Is this possible?
-
- 3 replies
- 1.9k views
-
-
I'm working on a timeclock database, and need to verify if the data antered in a global employee ID field is in the value list of current employees. It seems simple, but I can't find how to do it in Version 6.
-
- 2 replies
- 1.8k views
-
-
Hi! I have a portal on my layout and the first field in it is a auto generated serial number. For some reason whenever I create a new record, the portal does not fill in the serial number on my first portal line. But if I fill in the other boxes and go to the next portal row, the second serial number will fill in and so on. Is there a trick to making the first row in the portal create this serial number? Thank you so much in advance for any help!
-
- 2 replies
- 1.5k views
-
-
How do I SPEED UP the changing of text color and other characteristics? In a page of text, I want to change the color, then make BOLD, every 2nd, sometimes 3rd, line of text... without messing with the ones in between. This means I have to triple-click the line of text, then turn change the color, then turn it bold. Doing this to 12 or so lines on a page makes it take a minute or two. I'd rather simply position the cursor, then call up a script (e.g., Cmd-4), but I can't see how to do this in a script, though I've looked and looked. Any clues for this non-programmer? Many thanks in advance...
-
- 1 reply
- 1.1k views
-
-
Good afternoon everybody, I went clueless how i can tackle the following problem. I have a table "Art Production" this table consist of - ap id_K -job ticket -item number -item name I have a second table "art file" this table consist of -ap id_F -art file id_k -art file number -art file name and a 3rd table "ink specs" -art file id_f -ink specs (15 repetitions) here is my problem. i will create one job ticket (table #1) and this job ticket will have multiple art file numbers, and each art file numbers will have up to 15 ink specs (thats the idea about the repetition field). at this point i don't know how to tackle t…
-
- 16 replies
- 2.6k views
-
-
HI i want to know that in layouts there is a line between the mid of the layout.that line suggest that the part that is on the right side of that line will not come in preview mode.i have tried so many times to extend that line but unable to do so can u tell me how to resolve that issue.
-
- 2 replies
- 1k views
-
-
Hello everyone, I recently started working with FM database and have been asked to implement a new feature to our current database. I made a portal with flight information, with different fields such as date, time, flight number, etc. For each record there may be many portal records, for example any person may go on many flights. (This is a student information database). The flight records are sorted by date. What I need to do is concatenate, all the flight information into a new field which represents flight summary. This is easily accomplished when I only have one flight, however when I have more than one, each flight must be sorted by date and put into t…
-
- 3 replies
- 1.9k views
-
-
I have a field on a layout that uses a dropdown list to select an account name. The dropdown uses a related table to populate the dropdown list. This table includes the account name & account # for each account name. I want to be able to select the account name from the dropdown so it can be entered in the account name filed of the record & have the corresponding account # automatically entered in the record's account # field. Is ther a way to accomplish this without a button? Can it be triggered in some way? I have FM Version 9 Advanced.
-
- 4 replies
- 2.9k views
-
-
I have just started working with FM10, so please excuse my newbness. I have imported several tables from CSV files downloaded from Survey Monkey. The goal of this database is to easily import CSV files downloaded from Survey Monkey that will automatically calculate the statistical data. The CSV files that Survey Monkey gives you are: Collectors (gives the survey title and a unique CollectorID for each survey) Respondents (gives a unique RespondentID for each person completing the survey) Questions (gives each question a unique QuestionID) Question Options (Gives each option for each question a unique OptionID as well as the text for each question option, and…
-
- 7 replies
- 1.5k views
-
-
See attached screenshot. I'm showing a selection screen for the user to choose a portal row. The portal shows related donors based on the data relationship using a global field called "Filter Option 2" in the Organization record. The script that displays this screen sets Filter Option 2 to "" (blank". Organization/Filter Option 2 is the field that is used on the layout shown. However, no portal data is shown until I enter something in the Filter field and hit the tab key. If I key "" into the filter, or any other value, then it works perfectly. How do I get the portal data to display on the initial presentation of the screen? Thank you. HJ das1.bmp
-
- 1 reply
- 1.3k views
-
-
I've made several form letter layouts where the user could add variables to pull info from the different recipient's records. Usually this involved creating a button for each variable with the basic script step to add text to the body of the letter such as "". From here there would be a second "body" field that would look for any variables in the text and substitute the correct field data. However, here is a way to save a lot of work. And get this, it uses a repeating field. As you can see in the layout.jpg I placed a global repeating field in the layout with enough repetitions to hold however many pre-programed variables I wanted to make available. I gave the user a…
-
- 5 replies
- 1.3k views
-
-
I'm wondering if it's possible to filter a value list that has two fields specified. Example: ID & Info Is it possible to filter this value list, based on the ID, but display Info, for example in a calculation. I am using the following to filter the list: FilterValues(ID; ValueListItems(Get(FileName);"Valuelist 1")) This filters it correctly, but displays the ID, when I would like it to show the Info instead. Also, is it possible to remove the carriage return at the end of the filtered result? Thanks heaps.
-
- 1 reply
- 1.4k views
-
-
Hi all, Im trying to plot multiple members in my database on a map (presumably flash or javascript). Does anyone know, recommend maps I can use in my web viewer to display pins of where my members are. I currently store postal codes and would like to use this to pinpoint where they are. Cheers Jalz
-
- 2 replies
- 1.7k views
-
-
Hi, I am want to know that how can we create dynamic charts in file maker pro using web viewer. plz help me how can i do this in file maker.
-
- 2 replies
- 1.8k views
-
-
Hey guys, I have a value list assigned to a radio button field, but the values or text I have displayed in it is lengthy. A user would have to use the scrollbar to scroll across the page in order to read the entire text, that is if I extended the field the full length of the text. In Filemaker I noticed it will not wrap my fields to the next line if my field is too small, however, with IWP my text does wrap to the next line just as I would want it to. My database will be used through both IWP and the FM Program. I have both Asian and Roman Line Breaking selected under File/File Options/Text. I've also tried to change my font smoothing settings in windows…
-
- 5 replies
- 2.1k views
-
-
Hii, my name is Darlan. I'm a very new filemaker pro developer. I want develop a system for a business of my family, but i don't know how to start... I like to know how to do a menu in header for every layout, without use command c and command v ... Sample. _______________________________________________________________ | | | Menu | | | | …
-
- 4 replies
- 1.9k views
-
-
I have a field "XY" which collects values such as "A", "B" or "C". I'm looking for a conditional formatting formula which allows me to cover different parts of the layout in white. What I have is this: Transparent Layout Text 1 using Custom Formatting: XY ≤ "A" and XY ≥ "A" (--> fill color white) Transparent Layout Text 2 using Custom Formatting: XY ≤ "B" and XY ≥ "B" (--> fill color white) Transparent Layout Text 3 using Custom Formatting: XY ≤ "C" and XY ≥ "C" (--> fill color white) The problem is that this fills white if A, B or C IS part of field XY. How can I reverse that? I want the layout text to fill white when A, B, or C is…
-
- 9 replies
- 2.8k views
-
-
I have set up my system so that it records when a field has been changed. The problem is that when I am in a field, and then move to another record, the field that was active in the old record now becomes active in the new record, triggering my system to mark it as being changed. Is there a way to have the active field become "nothing" automatically when moving between records? Thank for your help, Fed
-
- 4 replies
- 1.3k views
-
-
Disclaimer: My company built their database on "first name" & "last name" relationships as well as non-unique project numbers. I am trying to fix it and keep it as close to what they are used to as possible. That said... I need to recreate their Transmittals so they can ship stuff out. I have a simple one to many relationship. One Project can have many Transmittals. I have a foreign key <_kf_ProjectID> on the layout. This field is tied to a value list that displays all of the projects. This all works. How can I get it to filter further to show only the Acitve projects? After that I'd like to know if it can be pared down further to fi…
-
- 5 replies
- 1.3k views
-
-
What is a calculation I can use for conditional formating of a fields text color when on an odd portal row? For example: - if field is on portal row [even]; blue - if field is on portal row [odd]; white I'm looking for something like this so I can us a match field ID Field with the related human label on top. On a form view I would just simply make the top field a solid color and user could not see the ID field directly below it. But in my list views, I have alternating color, so obviously this does not work. I would HATE to have to sacrifice this attractive feature. I wish a user could tab to "pop up list" this would solve everything sense a pop up disp…
-
- 9 replies
- 4.8k views
-
-
We're hosting an online training on custom menus on Wednesday 12/9. Thought this would be a good place to let everyone know. Contact us ASAP if interested! - Brant - - - Creating and Deploying Custom Menus in FileMaker Pro Who should attend FileMaker developers Date Wednesday, December 9th, 2009 10:00am to Noon PST Location Online via WebEx Instructor Jerry Robin Cost $75 Learn to harness the power of Custom Menus in this two-hour online seminar, presented by world-renowned FileMaker trainer Jerry Robin. Custom Menus allow the developer to modify and enhance FileMaker’s menus, making the menus more meaningful and ap…
-
- 0 replies
- 1.6k views
-
-
Thanks in advance for the help. I am fairly new at FM. I am making a database that will do Insurance premium quotes. Here are the basics: It starts with a base premium and then we add the state tax and then add the stamping fee, then admin fees etc to arrive at the total premium. I can do all of that ok with calculations etc. Here is where I need help, each state charges a different tax amount and a different stamping fee. I would like to be able to select (or type) the state (2 digit abbreviation) and have it automatically populate the tax and the stamping fee fields. I have an excel spreadsheet with all of the states and tax rates. I don't …
-
- 1 reply
- 1.5k views
-
-
I have a layout that's shows a list of tasks: Tasks are related to projects via the projectID in the Task Table, and the job is related to the customer via the customerID in Job Table. I've created table instances of the customer, job and tasks, and the customer table has a global, gCustomerID. So I can add a new task, set the gCustomerID in a value list, tab and select the project from a value list, and enter the task description. Works like a champ. The issue is that the user sees the globalID on every record (not the "Customer Name" field, and they see the projectID, not the "Project Name". Is there a tricky way to get this to work like it does …
-
- 6 replies
- 2k views
-
-
Not sure best topic for this problem, but I would like to modify one of the pre-built starter solutions in FM10: Home Budgets. I am adding dates and sub-categories fields to the different categories. Current problem is changing the name of the "LivingExpenses" to "MaterialExpenses" in the related tables that is listed in the "Portal Setup". The drop down list shows more tables than their is when I go to manage database, 2 verses 5 tables. Where do I find the these related tables? I think for all the pre-built in functions to work every occurrence of "LivingExpenses" must be renamed.
-
- 6 replies
- 1.6k views
-
-
I am creating a layout for a resume for print. I am having a problem with the work experience. Some people only have had only one job and some people have had 4 jobs, and so on. When i made the layout i have added all the work experience fields. There is a total of 5 experiences. If Joe had 3 jobs, I only want the first three work experiences to show up, if Betty had only one job than only the first experience will show up, etc. This has to be done by omitting empty fields and a conditional formating but i am not sure how to do it. I have also a language section, training/schools sections, and many more. When all of these are on the resume it takes up 4 pages(there are ov…
-
- 7 replies
- 2.4k views
-
-
I feel as though this should be a simple problem, but I can't figure it out. I would like to replicate the "New Request" button which is on the Status Toolbar in Find Mode as a button on my layout. (I'm creating a Find Mode layout for my users.) Eventually, I'll also want to recreate the "Delete Request" Status Toolbar button and create a button which creates a new OMIT Request, but let's start simple. Any help is welcome! I'm relatively new to FileMaker, though, so the simpler the better! Thanks!
-
- 1 reply
- 1.3k views
-
-
Anyone know of some great techniques for "categorizing" a value list generated from field? I have a ValuesTable (Three tables make this, ValuesSet, Values List & ValuesLine) I use to store all my Assignment Types. The list has grown larger then expected and is hard for users to read through. I would like to categorized them in some manor to help this. For example: SERVICES - Design - Writing - Motion Graphics PRODUCTS - Printing - Ad Specialties - Signage If you can help or point me to some good material to read/view I would really appreciate it. THANKS!
-
- 2 replies
- 1.5k views
-
-
I need to have a script to select a checkbox in a set based on the value of another field. I am doing passes in school for students. The value list is Bathroom Pass Dress Code Pass Guidance Pass Hall Pass Library Pass Nurse Pass Office Pass Water Pass The checkbox set is Another Teacher, Bathroom, Checking Out, Guidance Office, ISS, Library, Locker, Office, Water. When Bathroom Pass is selected from the dropdown then I need to have Bathroom checked.
-
- 1 reply
- 1.5k views
-
-
Can a web viewer be a button in IWP? Thats pretty much the question.
-
- 2 replies
- 1.6k views
-
-
Is there any way to use conditional formatting on the colour of the tab box? I have a tab box with several tabs, and would like to colour a tab 'Green' if there is data in a particular field in that particular tab, to indicate that this tab contains data and should be looked at. The Conditional Format box is greyed out when I click the tab background in layout mode, but there may be some other way of doing this.
-
- 2 replies
- 1.3k views
-
-
I am very new to filemakaer 9. I want to copy a Mappoint 2009 map into a container in filemaker that is 200x217. When I copy the mappoint map into the container it is too zoomed in and does not show the entire map that I created. I have tried to manipulate the map by using microsoft picture manager. I can shrink it down but the map becomes too blurry and is unsuable. Any help would be great.
-
- 3 replies
- 1.2k views
-
-
I designed a generic layout in which users can perform a find with various criteria. I would like to display that criteria to them in the header so when they print out the results it includes how they found them. Any Ideas on how to do this?
-
- 2 replies
- 1.9k views
-
-
ValueListIDs ( fileName ) ValueListItems ( fileName ; valueList ) ValueListNames ( fileName ) what are this functions used for ?
-
- 2 replies
- 1.5k views
-
-
Hey guys, Is there a way to create a dynamic layout with sections that expand and retract according to how much information is present? We create callsheets for jobs so people know when they have to show up, who's who on location, etc. There are categories like Talent, Clients, Camera, Props. The number of people who fall into these categories change with every shoot. In our Filemaker database you can assign people to a job, now I want to create a layout that fills up with everybody name with everybody falling into the correct categories, one for Talent, one for Camera, etc. Ideally these would expand depending on how many names fall into that category for a spe…
-
- 2 replies
- 1.5k views
-
-
Morning. I'm linking images into a container field by inputting a link into the container field with the result being an image. This has been discussed on this forum before and works like a charm. I can however (for the life of me) not figure out how to 'center' that resulting photo within the container field. Can anyone give me a hint? much appreciated M
-
- 4 replies
- 2.2k views
-
-
I have a weird problem that I'm wondering if anyone else has come across. I have a layout in LIST view show 500+ records. In the header I have drop down boxes that when selected will alter the found set of records. Ok no problem. If I move the scroll bar down the page the drop down boxes stop working and I can't select them but if I move the scroll bar up to the top again the drop downs work. Am I going crazy or what? This is happening on a windows platform (XP Professional). Anyone have any ideas? Thanks.
-
- 1 reply
- 1.2k views
-
-
Hi there I'm just a beginner in FM and new to this forum. I don't know if this is the right section for my question... I've created 2 databases: one is called ClientInfo and the other is WorkOrder. Easy enough... They're both linked with common field k_Client_ID. On the WorkOder layout, I have a Customer box which will list the Client name, address..etc the usual stuff. I need 2 similliar boxes: One for Billing Address and the other for Shipping Address. How can I accomplish this? My second question: How to define a button that will open a database (or table)on new window? Better yet, how can I embeded in the drop down menu (Like Add New Client...) Thanks you all …
-
- 4 replies
- 1.3k views
-
-
Is there a way of making a layout read-only regardless of user permissions?- read-only to everyone. Via scripting or conditional formatting? Thanks,
-
- 2 replies
- 3.5k views
-
-
after loading custom menus menu item tools exists how to remove it help plz
-
- 1 reply
- 1.9k views
-
-
I'm using IWP and need a portal to show found records. It needs to be a portal as a list will not work in IWP and also I need to present the found files in a list so the user can scan down the list and find what they want. I cannot see what I need to base the layout and portal on. Any ideas?
-
- 5 replies
- 2.8k views
-
-
Hi, I'm using portals and within each there are some dropdown list behind edit box. The problem is the lists edit boxes do not refresh with the selected values in the list. I've done a small camcast. So you can see by yourself. Link to the camcast Thanks for your help
-
- 3 replies
- 1.5k views
-
-
Hello, is possible to show near a editbox a icon (ex up arrow) if the value is too higth and show another image i the value is too low (ex. down arrow)? help!!!
-
- 2 replies
- 1.4k views
-
-
Hi, I'm building a invoice layout for printing and I would like to combine two field values into 1 field to reserve horizontal space for other fields. These fields are within a portal. The values are in a related table to invoice, the portal is showing these values ok. So I try to show the invoiceID within the portal: <> and it shows perfectly. Problem is I can't seem to show the related field eg: <> shows the exact same thing for each row '<>' instead of my value! Combining 2 fields <> - <> doesn't work either. I double checked the spelling and the field names are the same as in the relative table. What can my mi…
-
- 3 replies
- 1.2k views
-
-
I have a value list which is populated from a repeating [4] field. Lets say that the values in this field are: [C, Z, A, F] And another repeating [4] list like: [1, 2, 3, 4] I am currently developing a Filemaker "Email Center" and I would like to include the option for pre-made emails. This way, a salesperson could go in, put in the address of a new customer, and select the "Welcome New Customer" premade email, which would then populate the body of the email with the correct text. In this way, I would like to have it so that when I select "C" from the dropdown list of premade emails, it fills the body text with "1". When I select "A", it fills …
-
- 1 reply
- 1.4k views
-
-
I am trying to make a field that is a expiration date field change to red(I can do this in conditional formation already, but i don't know how to set the jan 01), then at the same time I need another field that will change from active to expired(and become red) when the current date arrives to jan 01 2010(this needs to be done every year), Then when I go back and change the expired to active and the date field to jan 01 (ex. jan 01 2011) of the next year everything rests for jan 01 2011(and so on). Every person will have a different start date so i can not tell the calculation to expire in X days. I hope this is clear. Thank you in advance
-
- 8 replies
- 2.4k views
-
-
I've placed the line on the right side of the column on the layout in order to visually separate the columns; it appears on the first page just fine, but not on the second (and succeeding pages). It doesn't seem to matter whether I have title heading and heading or not. Nor does setting the sliding/printing seem to affect it; the record ends properly at the end of the page, etc. Mysterious.
-
- 2 replies
- 1.3k views
-
-
I tried to sum the problem up in the title, but to make it clearer. We have helvetica as our default font, and regularly copy/paste text from other programs into FM. From the web/word/pdf etc. We would like the pasted text to adopt the default font but currently we are pasting the text with the font from the original text/document. Is there a setting or method for consistantly / easily adopting the default font upon pasting? Many thanks, Brendan.
-
- 11 replies
- 5.2k views
-
-
I'm new, so forgive me if this is too simple. I have 1 table called PEOPLE. Each Contact has a required "category" field (Child, Student, College, Adult). I have a layout for each category, because I want to display slightly different fields for each group. I want to make sure that each layout only EVER shows people from 1 category at all times. I've been able to do this on a basic level. Where I run into problems is when I want to Go To Related Record. For example, I have my people related to each other in a FAMILIES table. I have the family relationships showing up in a portal on each layout. There is a button on each portal row that directs me to the rel…
-
- 1 reply
- 1.2k views
-
-
Question: If have a lot of fields without size limit. Now I'm looking for an option to show the user the whole content of these fields without giving access to modify the content. If I disable Browsemode I can't scroll down the field, the scrollbar is also disabled -( Any ideas?
-
- 9 replies
- 1.8k views
-
-
Hi, Has anybody tried to change row position in horizontal portal (multiple portal)? I want to add two small arrows inside each portals to allow the user to move the record left or right. - The records in the portal have a position field. - The portals are horizontal I know there's a complicated way using GTRR stuff, but is there a simpler way? Thanks
-
- 0 replies
- 1.4k views
-
-
I made 2 fields in a layout 1.food 2.drink. The field food has a value list in it (1.solid food and 2.liquid food), the field drink has value list (1.pepsi and 2.coke) now question is if i select solid food in the field FOOD the field drink should auto enter into coke hope u understood many are explaining not able understand please can any genius can tell me script please please i am just a beginer
-
- 23 replies
- 3.9k views
-
-
Hi, I have a project database that handles quotes for construction tenders. The way I need it to run is that we have one project(parent table) with multiple clients(child table) that we send it to. The problem I have is with the layout for the report where I want to replicate the report once for each of the clients showing their contact details but the remainder of the report (with sections, section items, and item components) stays the same. My tables are similar to this Project (Project No, Project Title) | -Clients to send it to (Client Name,email etc) | -Sections (Section Name) | -Section Items (Item Name, Qty) …
-
- 1 reply
- 974 views
-
-
I am a newbie and think that this is what I need to solve the task. I believe that it is a conditional value list, but am not sure. Here is the problem. I am grading assignments. Each assignment has various components with different values. For example -- Project Specifications 10 point max. I have two fields Value and Points. I set value to 10. I then need a drop down value list for Points 10,9,8,7,6,5,4,3,2,1,0. Each component could have a max value that is different. I am currently using a set value list from 50 to 0, but it is time consuming when you have a max for this item of 10. It is also does not make it user friendly to share with another tea…
-
- 1 reply
- 1.9k views
-
-
Basically the title says it all. I'm wondering if it's possible to create a value list whose values are the result of a calculation. For example, an event that begins on 1/1/2010 and ends on 1/5/2010... Is it possible to create a calculated field that would return a list of the dates (1/1, 1/2, 1/3, 1/4, 1/5) and could that list then be used as a value list for a drop down field? TIA
-
- 1 reply
- 1.4k views
-
-
I have a student record keeper, main table is name, etc., and related daughter table is assignment name, date, and score. I have a layout that lists all current students and those names are linked by GTRR to a layout that displays the name and below that is the related table that will show all assignments and a grade total. I switch to Preview Mode to print. Sometimes I wish to print a student's records only for a particular month. From that screen, how might I be able to query the user (me) for the number of the month (or month and year) and restrict the displayed records of the currently displayed student to that? I have been doing a "manual" search but it is tedious.
-
- 0 replies
- 1k views
-
-
Without giving too many details that may be extraneous. I have a db that tracks student applications to schools. I want a report that lists each school followed by all the students applying to that school. Basically, I want a report that lists all the records in my "applications" table and groups them by school. I can do this, but the report only lists the first student record for each school (though there are other students applying). For example, imagine that there are 10 students applying each to Harvard and Yale. The report currently returns: Harvad John Smith Yale Jim Jones The other 9 students applying to both school…
-
- 3 replies
- 1.2k views
-
-
hi again we create value list and items are in text in valuelists is it possible that we can use pictures apart from text m trying but not getting head is about to blast :(
-
- 2 replies
- 1.2k views
-
-
I am new to scripting. I want to have a tab be selected based on a dropdown box. I can do this with a script and object name, but is there a way to trigger the script based on a calculation? I am using this for class passes. I have three tabs General Pass, Nurse Pass, Dress Code Pass. The default is General. For example -- If nurse pass is selected from drop down then the nurse tab is shown. If Dress code is selected from the pass type then the dress code tab is shown. Thanks.
-
- 4 replies
- 5.6k views
-
-
as we enter new records by function show all records we can see all records in list view but i want all records with field name be enlisted automatically in a value list according to alphabetic order so that i can drop down them to view in a layout in a form view hope u understand i am just beginner complex suggestions wont enter into my mind coz m science student pls help me :(
-
- 0 replies
- 1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online