FileMaker Interface Features

I would like to select record(s) via a checkbox that I can automatically put into a found set in order to e-mail a select number of students from my database. Does anyone have any ideas on this? Charles

• 2 replies
• 1.5k views

mr_vodka

February 26, 200818 yr

Hi all, There is a "description" field that may have a single line of text ... or 20 pages of text (it could be book chapters). I would like to have a report that expands or contracts in length; depending on the contents of this field. In form-view this field has a scroll-bar to access the rest of its content, but it will only print the visible text in the field box.

• 1 reply
• 1.2k views

bcooney

February 26, 200818 yr

Is it possible to change the format of a pop up menu? Currently I have a menu that has over 40 items which produces a long thin menu with scroll arrows at top and bottom. Is it possible to change the format so that almost the full width of the screen is used and the box is more "wide and short" than "long and thin"? Many thanks

• 1 reply
• 990 views

grumbachr

February 26, 200818 yr

I created a layout with portals from relationships with two criteria (ClientID and SlotUsed, between Client table and Prescription table). Works great. Needed the same layout involving another table (Client table and OTC table), so I did for it what I did for the other. I have checked the variables, the relationships, the layout, and everything matches. Except, nothing in these new portals show on OTC layout. You can't even click into the fields (yes, I have browse checked in the behavior). I duplicated the layout, changed the portal to the corresponding OTC verison, the variables to the corresponding OTC version. Prescription layout Layout based on: Cl…

• 7 replies
• 1.1k views

Søren Dyhr

February 26, 200818 yr

Hi I am trying to have a custom function where I can add a tooltip to a field which is the comments set in the field defination. The calc is: FieldComment ( Get ( FileName ) ; FieldName ) But when I use this either with the sysntax FieldComment ( Get ( FileName ) ; "FieldName" ) it does not work. Please help. :

• 1 reply
• 2.7k views

mr_vodka

February 26, 200818 yr

How can I sort records in a portal so it recognises the number (as a whole number) inputted and not just the first number. i.e Sort order should be 6 8 20 100 [color:red]Not 100 6 8 20

• 6 replies
• 1.3k views

Ben Ball

February 26, 200818 yr

In FM9Adv is there a way to Copy something from one layout and Paste it in the exact same position on another layout? Thanks Sean

• 2 replies
• 1.2k views

phunkidude

February 26, 200818 yr

Hey there all. I hope I am posting my querry in the right area. I am adding to what i have built for my road manager reports. I'm learning how to put this all together as I go, so if you can help please use beginner terms. I have just started working with calculations and it seems to be going pretty well, considering I didn't have a clue how to make them work. By calculations I mean mathmatical functions, by the way. My question is this: I have rebuilt my settlement spreadsheet from excel into filemaker so that I can keep track of how many people paid, comp tickets and what my band actually made that night. My filemaker layout is almost identical to what my…

• 3 replies
• 1.9k views

Lee Smith

February 25, 200818 yr

I have a portal in a layout which pulls events from our calendar database. I want to be able to limit the portal to only pull the next 5 events listed. I have the portal setup to filter only events from today's date onward and can set it up so that I can get the next ten days, but I think only seeing the next five events would be clearer for users. I know I can setup the portal so you only see five rows and hide the scroll bar, but I'm setting it up for custom web publishing which ignores the portal viewing settings and displays all the records. Any help would be appreciated. jon

• 1 reply
• 1.1k views

Ocean West

February 25, 200818 yr

Is there a way to make a pop-up menu list limit the fields displayed below it? For exmaple... When Pop-up Menu selected is "POP1" Display fields: Date1, EditBox1 When Pop-up Menu selected is "POP2" Display fields: Date2, EditBox2 And so on... Thanks

• 1 reply
• 1k views

mr_vodka

February 25, 200818 yr

FMP9 Adv Win XP Working on school math layouts that will serve as resources for students learning to answer math word problems… Q1: Is there a FileMaker compatible (x-Platform) font that will allow math symbols (division sign -- line with dot above and dot below; fractions -- horizontal line with numerator above and denominator below -- rather than "/")? Q2: Also is there a way to show borrowing, carrying, long division, etc? Don't know how to do that. We want to be able to type model answers in a way more like what the students should write. TIA lpm

• 0 replies
• 1.1k views

lpm

February 25, 200818 yr

I am sure this problem has been asked and answered many times. I searched and searched but couldn't find anything on it. Anyways, here goes. What I need to do is print statements for my clients. Some of these are short, 1 page, header, body, footer. But some have a ton of items that will take 2 or more pages. The data is coming from many tables not just one. First, I am running a script to run over to the deposits table and searching for all transactions that haven't been added to a statement before. It jumps into loop mode, setField to a global back on the statement table, with the date, descripition, amount and such. Goes to next record with exit on last set. Then i…

• 9 replies
• 1.5k views

Søren Dyhr

February 25, 200818 yr

: I am attempting to reconstruct a DB i wrote in MSAccess 2 years ago, only this time with filemaker. One field requires a unique ID which consists of 3 uppercase letters and 4 numbers eg ABC1234. How can I restrict the input to only accept this format? Any help would be greatly appreciated.

• 1 reply
• 1.1k views

comment

February 25, 200818 yr

I am setting up value lists together with pop up menus. The value list is taken from two fields (code number & description), with the second field being displayed in the pop up menu. The first value list I set up works as it should. The description is displayed and the code number is stored behind the scenes. BUT, every value list I've set up since does not work. It is only displaying the code number. The description is displayed in the pop up menu, but when selected, the code number goes to the field. I've went through it time after time and made sure I wasn't doing something different by accident. It is set up identical to the first. Any ideas why the first value li…

• 7 replies
• 1.6k views

comment

February 24, 200818 yr

I wrote a relational database for a therapist. The main database has personal info like insurance company address contact numbers etc. It is linked to a database that contains all the daily notes written on the patient. I want to produce a report that has a cover page containing only the patient name and confidential on it. The Second page contains just the pesonal info and starting on the third page would be all the notes related to the patient. I can't figure out how to achieve this Any help please

• 8 replies
• 1.6k views

kgasman

February 24, 200818 yr

I'm trying to re-create a Column Sorting example from the book QUE Special Edition Using Filemaker Pro 9. Page 324. Sorting of columns works just fine but I'm having trouble trying to get the background color for the column heading to work, it will show up once but won't jump from heading to heading when clicked on and when it does show the color it only partially fills the field, even though the gHighlite field is much bigger than the column heading field.

• 0 replies
• 1.3k views

Mickdn

February 24, 200818 yr

I currently produce 4 different reports using 4 different layouts to properly report on my data. I'd like to condense this into one continuous report without page breaks. Is it possible somehow to make multiple distinct find/sort requests, including 4 different instances of records and intervening header info and other static text, to produce this single report . I'm envisioning something like you could do via cdml or ldml on a web page. But I'd like to do it just within fmp and maybe in conjunction with a companion app of some kind.

• 0 replies
• 1k views

dennisw1mac

February 24, 200818 yr

Hello. Is there a way to make a record's recycle bin in file maker? thanks

• 2 replies
• 1.8k views

Reed

February 23, 200818 yr

To allow entry of different types of products into the same inventory table from the same parent (one invoice from a supplier), I have created multiple portals to the inventory table: (Diamonds, Emeralds, Rubies, etc.), each on a different tab. Also on the same layout, I have a simple portal that shows all the items, regardless of type, so the user can see all entries in a list. What I want to do is be able to place a button in the general portal that will then open the appropriate tab and go to the correct portal row for that item. I've got the first part, through an If-Else If-Else If structure, with Goto Object and named tabs. But whenever I try to go to a fi…

• 3 replies
• 1.4k views

Withan

February 23, 200818 yr

I'am trying to create a solution where users can choose their prefered theme. It works fine, but under Windows XP, whenever I click a line in a list view (which have a button in the background)all images from the theme file disappear for as long as I hold the mouse button. I attached the files so you can see for yourselves (they are not from my original solution by the way, but a reproduction of what I'am doing). Is there a workaround for that or am I stuck with it? Thanks in advance! Themes.zip

• 3 replies
• 1.9k views

vsiegle

February 23, 200818 yr

How can i take out the dialog when i run a script with "perform find" and it doesnt has any result. I want no dialog to appear in no moment. Thanks

• 1 reply
• 1.5k views

Fitch

February 23, 200818 yr

FM 9, for some reason when I add a field to a layout, is automatically putting the font of that field into Old English 36 point, rather than my default font, Palatino. I can change it back after it's on the layout but anything new on starts out in this strange way. Why this new behavior and how to change it?

• 1 reply
• 5.2k views

Lee Smith

February 23, 200818 yr

So... you would think I would know this but I don't. How do I change my default font?? Every time I added a new field it is formated as bold, italic..blah and I have to go change it to what the rest of the layout looks like. Thanks, Lisa

• 3 replies
• 3k views

UpNorth

February 22, 200818 yr

I'm having a bit of a problem. People have been scheduling panels for a convention using a spreadsheet, with the times going down the left hand column and 7 room names running along the top. They fill each cell with the name of a panel and cut and paste them around the spreadsheet until they get the final schedule. This worked, but it did not keep track of things like who was on which panel and other details. So I created a solution that contained three tables, Events, Panelists and a join table. The database has made it much easier to keep track of things, but the people in question really miss the old spreadsheet view. Is there someway to make a layout that w…

• 6 replies
• 1.4k views

comment

February 22, 200818 yr

I am a newbie for FileMaker. When I check for scroll bars in the portal setup dialog they don't show up on the interface. But if click in the corners, the I can scroll down. I just cannot see the scroll bars. Users will not know that there are scroll bars. I am using FileMaekr 8 version 3. Thanks for any help.

• 2 replies
• 1.2k views

suku

February 22, 200818 yr

Hello, I have a script launches a 'floating window' for users to view and then click OK to. The Window is an instance of a file (A) and the button that lunches it is in another file (. I have found that if all current instances of windows for file A are minimized then the 'New Window' script step ignores the size and position fields I have specidfied in the script. This happens on Windows and Mac machines. Any ideas how to get round this? I'd like to be able to test if the current file A window is minimized but cannot work out how to do it. Regards Isobel

• 0 replies
• 1k views

Heckate

February 22, 200818 yr

I have a layout part, Trailing Grand Summary. And I want to have a total cost on my report. In the body of the layout I have the cost field from the Asset table. In the Trailing Grand Summary, I have the same cost field from the Asset table. However, the Trailing Grand Summary Cost field is only displaying the cost of the last line item instead of adding all costs on all lines. What am I doing wrong? I don't think I need to build a relationship since the field is from the same table, right? Help please. :)

• 5 replies
• 1.5k views

mr_vodka

February 22, 200818 yr

Following the recurrent sound advice on this forum I’m trying to convert all my repeating fields into properly related tables, but I’ve run into a problem. I have two main tables: Courses and Staff, which I want to join in a many-to-many relation so that eventually I can see which staff will be teaching which courses (from the Staff layout) and which courses will be taught by which staff (from the Courses layout.) Record creation needs to work in both directions. I know the basic principle of how to do that by creating two one-to-many relations through multiple table occurrences. But the intervening variable is Timeslots. Each Course may run in a number of di…

• 11 replies
• 2.1k views

aliquis

February 21, 200818 yr

Ok so i have a Inventory of certain items. Within my layout i have information about the items. Then i have a portal showing related items. I have a Self relationship to display the portal. I am trying to make it so that you can click the portal row and go directly to that record. Ive tried most of the basic stuff its probably somthing simple i have over looked. Thanks ao

• 3 replies
• 1k views

all-out

February 21, 200818 yr

I have one layout that contains job information. There's one field named Status. The Status can either be 'not approved' or 'approved' . If the status is not approved I need the users to see only a few fields, when the status becomes approved, I'd like them to see more fields. What I did is designing 2 tabs one for not approved and one for approved and using ZippScript I made a script that goes to the right tab when you change the value in the Status field. All works well until you navigate to the next record. At that point the default tab kicks in whether the status is approved or not... Should I change my approach to the problem? Any suggestions? Thanks!

• 6 replies
• 2k views

mr_vodka

February 21, 200818 yr

I am inserting the date symbol // in a mail merge letter. In the "format date" menu I have selected to show the date in words, eg December 1, 2008, yet when I print the letters the date appears as 12/1/2008. Thanks for any suggestions.

• 2 replies
• 1.2k views

zim528

February 21, 200818 yr

I have created a layout (in this case an envelope address layout) which I want do copy into another database, rather than having to "recreate" the identical layout. The databases are not linked in any way. Is there a way to copy a layout from one database to another (the fields all exist with identical names in each database). Thanks for any suggestions.

• 1 reply
• 1.2k views

comment

February 21, 200818 yr

Hello there This is probably a really silly question but I have just started trying to work with tabs I have two tab controls on a layout. Any field I enter on the front tab shows up on the second tab when the layout is put back into entry mode. Can someone tell me why this happens and how I can change it - I want half the fields on one tab and half on the other

• 5 replies
• 2.8k views

Johnny777

February 21, 200818 yr

Hi, Quick description first. I have a Loans database. There are three tables: Loans, Loan Line Items and Items. Loans has a portal to Loan Line Items which does a lookup to Items. Each Item has a status: Available, Not Available, Reserved. Here is the question...as I enter an item in the Loan Line Items portal, is there a way to get immediate feedback as to the status of the item (beyond just having the field there). For instance, a dialog that says "This item is reserved you can't loan it" and then have the item removed from the portal? What would be the best way to accomplish this behavior? Thanks, Matt

• 5 replies
• 1.5k views

Søren Dyhr

February 21, 200818 yr

Hi guys, I've got a portal with about three records in it. But there is a blank extra row also available under the three records where a user could input a record etc. I wish to remove this and force the user to click on a New Record button. Is this possible with Portals? Thanks, Sully

• 1 reply
• 1k views

mr_vodka

February 21, 200818 yr

I'm trying to call up a floating window for a cross platform solution. A simple New Window, Pause, Close Window when users selects a Continue button. It's fine on a Mac where non-maximized windows are the norm, but on a Windows (via Parallels) it seems that a the New Window script step "Adjusts" the original window and resizes it. I'm not familiar with Windows' window management. Am I barking up the wrong tree here or can I get a floating window over a maximized window in Windows?

• 5 replies
• 1.3k views

David Jondreau

February 21, 200818 yr

I travel alot and I have a database in progress and my employees are wanting to start entering data. I still have a lot of work to do on the reports and different scripts for certain functions required but all fields are there to input the raw data. I need to work on the complete database and save the work that I have completed when I get back home to the database without disturbing the actual data. How do I do this. I hope that you understand what I am asking. I am new to FM so I have limited knowledge to the terminology of this program.

• 5 replies
• 974 views

Fenton

February 20, 200818 yr

Does anyone know how to format a field so the text is hidden and replaced with asterisks?

• 1 reply
• 885 views

comment

February 19, 200818 yr

Since I'm a beginner with FM, I attempted to use one of the build-in templates for my purposes (the template is Education - Administration -> Registration). I chose the template because it has a portal each on two different layouts (connected to two different tables) and basically the portal on layout A shows records from table B and the portal on layout B shows records from table A. I'm really sorry if this sounds all like gibberish, I'm only beginning to grasp FM. | When adjusting the template to my purposes, I must have made one or several mistakes. Now the first problem is, choosing a certain row (via a button with a script) in the portal on layout A will…

• 6 replies
• 1.5k views

uvern

February 19, 200818 yr

I have a Layout with two portals I have each portal set up to "allow deletion of portal records" I have a trash can button on each portal line with the button setup set to "Records" and "Delete POrtal Row" I have this exact same setup on other layouts that work perfectly, it delets the portal row. On the other hand one portal works fine where the other delets the whole record from the main layout and the informat in the other portal as well. I have checked the setting quite a few times and they are all the same. Can anyone help??? The Tramp

• 3 replies
• 1.1k views

Saddletramp

February 18, 200818 yr

I need to know how to get the title header to not interfere with my layouts when printing. When i go to print, it will print my title header. When I set it not to print under the sliding/printing option, it will just leave a big blank space. I'll try to scan 1 of the forms i'm printing, and show you what's happening if you need any more explanation.

• 4 replies
• 1.5k views

comment

February 18, 200818 yr

WinXP FMP9A Time billing database. Each record is a month with a portal listing the date, project, activity, hrs billed, amount. I’d like to have fields that show (on each record/month) outside the portal the total hrs billed for the month for each activity. Not sure how to do this. Hope you can help. TIA

• 1 reply
• 1.1k views

mr_vodka

February 18, 200818 yr

I have a fairly complex layout with around 50 fields. The odd thing that I don't understand is that I have a single field based on a calculation that the screen does not update until after I've clicked on that particular field. All of the other calculations are instantaneous. What could I be doing wrong? Thanks in advance!

• 5 replies
• 1.2k views

Vaughan

February 18, 200818 yr

: Just wondering if it is possible to have filemaker play radio stations in the background similar to Itunes.? I am asking if anyone has tried to do this and if they have had any success. I would like my user to be able to get a radio station playing from filemaker.

• 0 replies
• 1.1k views

hartmut

February 17, 200818 yr

Hello ... I have a drop down box pulling values from a item database into a purchase order database.. What I find is that I don't get all the data... Ex- products from a-z in items database... In drop down box in purchases.. I see only products from a-s.. t-u-v-w-x-y-z is missing..The drop down is in a portal.. Hope this is clear.. thanks

• 0 replies
• 1.2k views

rfm1966

February 16, 200818 yr

Can you remove the lines in a portal? Thanks ao

• 1 reply
• 953 views

all-out

February 15, 200818 yr

Hi, is there anyway to auto resize the body part of the layout before printing. I have a layout wich displays email, some are short some are long, i display the email in a browser object so when the email is small everything fits in but when its long i only get the top part of the email. Is there anyway to automatically resize the body part or just the browser object to show the complete email. thanks mfrapp

• 1 reply
• 2.3k views

Lee Smith

February 15, 200818 yr

HELP!!! Please save my computer, because if I don't figure out what is wrong I'm going to throw it out of a window. This is saying something as I am generally a very easy going kind of guy. I created a report with a sub-summary a while ago. It was working fine. The only difference between then and now, that I can think of, is that I have switched from tiger to leopard. Now, my sub-summary section is MIA whenever I switch to preview mode. I've tried everything I can think of. I've deleted the report and created a new one. I've started from "scratch" and deleted the table I used to create the report, recreated it, recreated the report and it still didn't work. …

• 2 replies
• 920 views

Akak

February 15, 200818 yr

Ok, I have a layout with data. It was 10 fields for text input. I have a check mark next to each field to change the color of the field when there is something that I need to be warned about. I would like to create a summary page that will only list the fields that I have set the conditionals (check marks) for. What would be the best way to do this? Portals would show all of them. I only want the ones that I've marked. Thanks.

• 3 replies
• 1.2k views

comment

February 14, 200818 yr

Hi, I'm trying to figure out how to have my field labels default to a larger size than they currently are. Shouldn't they match the default size for the text IN my fields?

• 0 replies
• 1.3k views

phunkidude

February 14, 200818 yr

I have decided to change how i will be doing my database, as my last attempt was hopeless. I am trying to put in some checkboxs. When i go to print, if a certain checkbox if checked, then the layout it corresponds to, will print. If it is not checked, then the layout will not. I do not want to do fields that you put an "x" in, I have that, and don't like it. Thanks

• 1 reply
• 1k views

Fitch

February 14, 200818 yr

I have setup conditional formatting on a field which works fine Value = Proposal (Field turns to Green) How can i get the rest of the fields in the same record to turn green too please.

• 3 replies
• 1.8k views

_henry_

February 13, 200818 yr

Is it true that a tooltip cannot "know" which portal row (and hence, which record) it is hovering over? I've been reading about -- and experimenting with -- having a tooltip display information out of a record displayed in a portal. So far, I've been able to bring up related information -- but not from the specific record I'm hovering over. For example, I can click on a portal row, then hover over a different row and bring up info for the selected record (by using the combination of GetNthRecord and Get(PortalRowNumber)). Before I abandon this effort, I'd just like to get confirmation that the above question/statement is true -- but I'm certainly open to suggestio…

• 2 replies
• 2.6k views

K1200

February 13, 200818 yr

Hello, Is there any way to sync to Google calendar from FM? I would like to be able to have FM putting an event on a Google calendar for each job entered into the database, then we could have terminals in the shop where everyone could check the calendar to see what needs to be done. The ones in the shop would also need to be able to drag jobs around and have them being updated in the database. The updating could even be done by a script or something on a timed interval, if its not possible to have it automatic. Is there anyway to accomplish this, with a plugin or otherwise? If theres no way to do this someone should certainly make one, as I think a lot of people wo…

• 1 reply
• 2k views

obdata

February 13, 200818 yr

Hi I'm trying to create a layout using two related tables. I want the parent table to display the clients info. I want the child table to display the booking(s) the client has made with the ability to add new bookings. The problem is the contract info contains 45 fields way to many to display in a portal without using hrizontal scroll bars. So my question is how can I get this to work?

• 1 reply
• 980 views

Vaughan

February 13, 200818 yr

Can containers (in this case pictures) be placed into portals in fmp9? If so, would the picture size down to the container field size or would the picture be occluded if the container wasn't the same size. I'm thinking about how different sized pictures in the portal would work.

• 4 replies
• 1k views

Lee Smith

February 13, 200818 yr

hi, newbie here. on os x 10.4.11 using fmp 8.5 and 9 i use both "mail" and entourage for email clients. how do i specify which application in fmp script i'll use? my default is mail. sometimes i want to use entrouage sending out email via fmp database/script. any help would be great.. THANK YOU

• 3 replies
• 2.8k views

hooty

February 12, 200818 yr

Anyone know of a good way to snap shot the displayed row range of any given portal? I.E. the top most displayed portal row is 17 and the bottom is 26 for a 10 row portal. Running scripts always horks portal row positions and I'd like to restore the portal to the way it was before the script ran. Thanks

• 3 replies
• 1.2k views

Hijack

February 12, 200818 yr

Hello all, Apologies if this has been asked already. I searched the web and these forums to no avail. I have an older filemaker solution with 4 different tables converted to filemaker 7 files. I use filemaker pro 9 advance and I know it can be done. Invoices, Clients, Daytimer and appointments. It's a cludge, but it works. I need to merge, so to speak, all these tables into one table and use either tabs or buttons to change the view of the table. Is there an easy solution to this? Thanks for any pointers:)

• 12 replies
• 1.9k views

Søren Dyhr

February 12, 200818 yr

My database looks beautiful on my Mac, but not so great on a PC -- the fonts don't look at all professional, and the graphics created within FM look coarse and amateurish. I thought I could maybe get some improvement by changing the font smoothing on the PC, but I didn't notice any difference. Any advice? Or will I always have this issue with PCs?

• 11 replies
• 2.8k views

comment

February 12, 200818 yr

I understand that in FM9 pro you can make custom menus. If you create a custom menu in an applicaiton in FM 9 Pro, can you have a workstation running regular FM 9 Pro access that application with the custom menu?

• 7 replies
• 1.9k views

Lee Smith

February 12, 200818 yr

I am trying to customize a script to perform differently based on which tab control on the layout is currently active. Any ideas?

• 8 replies
• 6.6k views

Saubs

February 11, 200818 yr

I have three tables: STORES --< PRODUCTS >-- CATEGORIES Each store can hold many products (one-to-many relationship). And each product belongs to one of several categories. Several products can share the same category. So, for example, the "Main Street" store might have the products "Frog Fountain", "Copper Birdbath", and "Lion Fountain" in stock. The "Frog Fountain" and the "Lion Fountain" are each assigned "Fountain" category. The "Copper Birdbath" is assigned the "Birdbath" category. When I'm on a STORE layout, I'd like to see a list of products in stock. That's easy: I just create a portal between STORES and PRODUCTS. However, I would l…

• 3 replies
• 1.5k views

Søren Dyhr

February 10, 200818 yr

Is there any way to change the background color of a button when it is selected.

• 1 reply
• 1.2k views

LaRetta

February 10, 200818 yr

Is there any way to change the background of a text field in browse mode. I have a container field that I want to have different text in for each record. Sometimes the picture in the container field is so busy that I need a solid background color in that record only. Is this possible to do?

• 2 replies
• 1.5k views

hartmut

February 10, 200818 yr

To clarify: 1) I have a database with multiple records. 2) There is a drop down box with one of the values being "x" 3) I want to query based on a period of time to find the number of "x" related records in the drop down field. Question: How do I create a calculation to add up the number of "x" occurences and be able to pass that value for further use? Any help is appreciated. Thanks, Marc

• 3 replies
• 1.5k views

mqbui

February 9, 200818 yr

Over the last year I've become fairly comfortable with portals but this one has me stumped. Excuse my typing but I have the flu...so don't get too close to this post! I've overlayed an object over a portal and placed several fields on top of that. No matter what I try I cannot keep the user from entering into a portal row or a field inside the portal. I've set the fields in the portal to "no entry", I've tried overlaying an object over the entire portal then placing my object and fields on top of that, I've placed a large field over the entire portal set it so that it can't be entered, locked it and got a notary to stamp it. Still no good. When I say I'm…

• 7 replies
• 1.5k views

comment

February 9, 200818 yr

I have a global field to hold a company name. It is all working correctly, except for this one issue. I make the font to be black, but in the form and reports it shows up as white! No matter what I have tried, changing fonts, colors, backgrounds, etc... it is still white. Any advice??

• 5 replies
• 1.5k views

Leather Knight

February 9, 200818 yr

Hi, I'm a bit over my head here and would be grateful for any ideas that anyone has about this problem. I'm working on a student database for my department. This database (whose relationship layout is attached in a pdf) has tables for students, teachers, and courses, and a join table called Enrollment that serves to show which students are in which courses and to hold the grades and attendance records. What I'm having trouble with is creating a layout that shows, for each teacher, a list of all students in his/her classes, and for each of those students, a list of all their grades in each of their classes. So each line of the report needs to have the student …

• 0 replies
• 843 views

JeffN

February 9, 200818 yr

I have two fields in a portal: Resource and Amounts. The resource field is based on a conditional relationship, which works fine, except that it does not display values until something is entered into the amounts field--it would be better to have the resource values display from the beginning. If I have the amounts field auto-enter a zero, that succeeds in creating resource values up front, but it only works for the first row in the portal, not subsequent ones. Any ideas how I can get the resource values to show up initially in each row?

• 2 replies
• 930 views

blissland

February 8, 200818 yr

I created a database with a global field in FM 6 , we have upgraded to FM9 and now use server to serve it. Now the global field erases any changes when we close the file. How do I get it to hold the changes?

• 5 replies
• 1.4k views

comment

February 8, 200818 yr

I apologise for what seems a simple question, but how do I change the colour of the background fill on a layout? I cant find it in any of the literature with FMP and nor any of my books. I can see that I could edit a theme and then use that to set the background, but surely there is a simple way. thanks

• 2 replies
• 1.1k views

tdc

February 8, 200818 yr

As one will soon be able to see I'm a novice at using FM and I need some help trying to figure out how to use data from inactive tabs for a calculation on the main layout. What I have is four tabs in a layout and I would like to add the contents from a field of each tab and show that in the layout where the tabs exist. When I try it I only get the result to be the contents from the "active" tab. Is there help? I can send the file if this explanation fails to make sense. Thank you in advance.

• 8 replies
• 2.7k views

mjc

February 8, 200818 yr

I have a table of contributions containing the following fields: Contributor_ID Date Amount I'd like to prepare a report with three columns, one row per contributor: Contributor_ID.....CurrentMonthTotal.....YearToDateTotal Is there any way to do this simply, using Summary fields, Subsummary layout parts, etc.? Or do the two overlapping control breaks make this impossible without using temp tables or something? Thanks, Chap

• 6 replies
• 1.6k views

Mandu

February 8, 200818 yr

I'm attaching a picture of a button. When I click on any field on the screen, I see this dotted outline around the buttons. Any tips on how to stop or cover that up?

• 4 replies
• 1.3k views

Fenton

February 7, 200818 yr

We have a Registrant table and a Program table in our non-credit database and I'm having an issue trying to filer the list of registrants in the portal that resides on the Program layout. Each registrant in the Registrant table has a status within the program; Active, Completed, or Cancelled. The Program table contains a portal displaying all those that have registered for the program. I would like to filter the portal out to only display those registrants that are listed as Active in the Registrants table and I'm not sure how to do that...if it's even possible. Thoughts? And sorry for the newbie question. Thank you.

• 1 reply
• 1.2k views

Breezer

February 7, 200818 yr

Hello, i have a layout (diary) that show a complete week from monday to sunday and on that layout i have portal of another occurrence of diary (diary_p) related by X on Diary_ID that shows all the weeks in the diary (1 per row of the portal). when i enter the layout Diary i have a script that goes to the portal row of the current week. My problem is when i change the record of Diary the portal of diary_p goes back to the first row even tho i have the portal option "reset portal when exiting record" unchecked. I would like to have the portal row stay where it was. Any help would be greatly appriciated. Thanks mfrapp

• 0 replies
• 851 views

mfrapp

February 6, 200818 yr

HI I'm using Business Productivity Solution - Contacts, that you can download free. I want to add an Invoice Number into a letter that I send to the Client but I have more than one invoice number for that one person. I have just merged field before and it has worked fine till I now have more than one product that was bought for that one person, is there a way that I can get merge field to choose the most recent product Order. Thanks anything would be a great help Thanks Michael

• 4 replies
• 995 views

Michaelj

February 6, 200818 yr

I have a portal that lists current records correctly. I placed a button next to each record so i can go to that record and print same. The script for the button involves omitting the record so it previews alone from the other records and calculates correct page numbering etc. When i always run the script the first time in this portal layout, it previews all records which is not what i want but when i go back after the first script run and try it again and again, it works correctly. What is causing the script to list all records in preview mode the first time? Here is my script? Any help is much appreciated. Go to Related Record [From Table etc.etc…

• 2 replies
• 1.2k views

Breezer

February 5, 200818 yr

Hi, Can anyone tell me how i can sort the contents of a Portal by a field in a related table? For example, I have master table and layout with a portal showing data relating to the LINE ITEMS table. The LINE ITEMS table has a primary key, ProductID Foreign Key, Quantity, etc. and a separate PRODUCTS table from which i import the contents of of the primary key ProductID into the foreign key ProductID in the LINE ITEMS table. Thus the LINE ITEMS table is populated every time i run the import script with say 100 records (for 100 products) placing the ProductID in the aforementioned foreign key field. I have chosen not to show the ProductID in the porta…

• 1 reply
• 1k views

comment

February 5, 200818 yr

It's my first time to actually try this. I have an art database with three tables Artwork, Inventory (supplies) and Inventory Used. In the Artwork layout, I'm trying to show two portals: One with all the Inventory items with a search box and the other will have a list of inventory items used to create the art. I'm having a problem searching the portal using a global constant ("1") compared to a pattern count of the search string. I have all three tables related with two extra instances of the Inventory table used to list all of the items and filter them (creating a total of 4 relationships). I'm trying to take the search string and use it in a pattern…

• 5 replies
• 2.7k views

DMDewey

February 5, 200818 yr

Hi everyone, My apologies if this isn't the right forum for my question, but i wasn't sure where exactly to post. My situation is as follows: I am setting up an inventory system for a bar and have and INVENTORY table and an INVENTORY LINES table. The INVENTORY table has the details of the employees that took the manual inventory and a foreign key with the InventoryLineID that references the INVENTORY LINES table. The INVENTORY LINES table contains a primary key InventoryLineID, a foreign key for the productID (a separate PRODUCT table contains the necessary data), a date field and a Quantity field. I view the INVENTORY LINES table via a portal in …

• 5 replies
• 1.9k views

Søren Dyhr

February 5, 200818 yr

Is there a simple way to have custom values appear in alphabetical order using a drop down list? I have approx. 300 values. The values were entered in random order.

• 1 reply
• 1.2k views

comment

February 5, 200818 yr

I notced that when you create an edit box the default fill color is "unselected". This creates a transparent fill condition yet their is no easy way to change a controls fill value from having a fill back to this transparent fill condition. The format paintbrush does work however... That's my observation.. my question is .. is their a way to set a "transparent" text color? This would be very useful in portal where alternating lines are filled differently. TAI Kris

• 3 replies
• 1.4k views

Kris M

February 4, 200818 yr

Abstract: How to get evenly-spaced alternating bands of white/color for the rows of a columnar layout using a calc field calling a global container? Details: I have a browser list view, columnar. I have a container global field with a color in it. I have a calc that works. The body part is 25px tall. My container field is 25px tall, also. Issue: When viewed in browse mode, the color field is slightly less tall than the "white" background. I have a sneaking suspicion this is related to field border settings I can't quite parse... any advice for me? Thanks!

• 16 replies
• 1.7k views

LaRetta

February 4, 200818 yr

I'm a beginner trying to establish a FM database for our school. Our teachers teach private lessons to students and I need to generate monthly contracts for them. I have four tables: FACULTY, STUDENTS, PAYMENTS and CONTRACTS. I would like to be able to go to the "student" layout and choose each teacher's students by entering a certain code and when I go to the "contract" layout enter that code and I get that teacher's student list. How do I do that?

• 0 replies
• 1k views

_samuel_

February 3, 200818 yr

Mac 0S 10.5.1, FM Advanced 9.0v3 I'm trying to specify a different font in a layout theme file, but I can't get the change to work. I've changed the Windows Standard theme, replacing all occurrences of "MS Sans Serif" with Georgia, but when I create a new layout using the altered theme, all the fields end up as Helvetica. I've tried this with various font names, but the result is always Helvetica. Any ideas what I'm doing wrong? Here's a snippet from the altered file: <?xml version="1.0" standalone="yes" ?>

• 0 replies
• 1.3k views

John Nolan

February 3, 200818 yr

I have a layout that's setup for printing from a 3" thermal receipt printer. Right now I just have a little portal in there displaying the items purchased on the order but I simply made the layout pretty tall in order to fit at least 10 items or so. The obvious problem with this is too many items wouldn't fit, and the other problem is that when there is only 1 or 2 items a bunch of blank white space is coming out and wasting printer paper. Any information on how I can make the layout expand based on the number of items in the portal would be greatly appreciated. Thanks!

• 1 reply
• 1.2k views

IdealData

February 3, 200818 yr

I've been working on this one for a while, and I can't seem to figure it out either on my own or from existing questions and answers in the forums. I have the following tables and fields (formatted table:field) Timesheet:Project Code Timesheet:Filter Name Projects:Project Code Projects:Project Name Projects:Status Projects:Client Key Client:Key Client:Name Timesheet:Project Code relates to Projects:Project Code and Projects:Client Key relates to Client:Key. I also have a second Occurrence of the Timesheet table that is related by Timesheet:Filter Name to Client:Name. Currently, the user selects a Timesheet:Filter Name and is pr…

• 1 reply
• 1.3k views

The Big Bear

February 2, 200818 yr

How often do you guys use the table view in lieu of list view for user entry? I've never done it, but I'm working on this solution there's a couple attractions: 1) Resizable columns 2) Sortable columns 3) Ease of layout development The downsides I see are: 1) I have to rename my fields to something user friendly 2) I've got to come up with a workaround for my single value checkboxes that can now show "1" instead of just the box 3) I can't make the pop up lists "look nice" (I usually remove the borders and make my own without the ugly drop shadow). 4) I can't put buttons on a line (ie "Delete") Any perspectives out there? Thanks, David

• 5 replies
• 1.8k views

AudioFreak

February 1, 200818 yr

I am cusotmising an example db that came with FMPRo 9 and it has what appears to be field data in text boxes denoted by <><>. How do you add this? What do the "<<" and ">>"" mean? and why use this method rather than placing a field on a layout? Regards Craig.

• 2 replies
• 1.2k views

CRoberts

February 1, 200818 yr

Hello, I am not sure how to word this question so let me try to describe what I have and what I want to do. I have a field in my database that has 2 values in a value list. They are "Verified" and "Not Verified" What I woudl like to do, when in table view is to be able to have that when "Verified" is the selected value for that field, the field background will be yellow. If the field value is "Not Verified" Id like to field value to just remain white. Now I know I can change the background/fill color of the field as a whole but that would make the field always the same color regardless of what value is chosen. Is this possible? Seems like with a…

• 1 reply
• 1.1k views

Søren Dyhr

February 1, 200818 yr

Hi, I have two layouts. One for inputting data and one for printing with the same data etc. I have placed a button on the data entry layout so when users click it, it should go to the Printing Layout in Preview Mode. I would like the user have the ability then to click enter to cancel this preview mode view and return to the original layout which would be the Data layout but the script pauses in Preview mode and i can't exit it as i have the Status Area hidden. Is this possible? I have it working on another layout fine with the script below but i'm not switching to another layout. Allow User Abort [Off] Enter Preview Mode Show/Hide Statu…

• 1 reply
• 1.1k views

Søren Dyhr

February 1, 200818 yr

Hello community, I was wondering if you could help me with the following scenario. Is it possible to enable or disable a field based on another field's input? For example let's say I had a field with a payment option of cash or credit card, and another field with a credit card number. If the payment option is cash then the credit card field would would not accept any data entry. However if payment option is credit card then the credit card number field would accept input. Is this possible in filemaker? Thank you for all your help. Carlos C.

• 3 replies
• 1.2k views

Lee Smith

January 31, 200818 yr

Hi folks, Hope you can help. Using FMP 9. I have a database that tracks customer orders through quote, purchase order, acknowledgement and invoice stages. I generate the various documents (using a wordprocessor, normally), save them as JPEGs, and add these to 'picture' container fields within my database. I sometimes like to print the documents I have stored in these container fields. I can't find a way to do this without first exporting the field contents - am I missing something? The workaround is to create a new layout, single page, have the container field fill the whole page, then print directly from Filemaker. However, I might have 3 quotes …

• 1 reply
• 1.1k views

comment

January 31, 200818 yr

Hi I want to set default value to the dropdown. How to set the value from value list?

• 1 reply
• 5.2k views

Søren Dyhr

January 31, 200818 yr

Currently my database is set up in a typical fashion with records of advertisers available in form view (with many fields) as well as List view (with a few fields & merge fields for quick reference). I thought that it might be nice to see my list while having full access to an advertisers records at the same time, without having to switch back and forth. Is there anything wrong with taking the fields that I had on the form and placing them within the footer of a list? The fields seems to behave the same and everything works just fine, but I have never seen this suggested so I was wondering if it could be problematic. Thank you, Marc

• 0 replies
• 960 views

mkruter

January 30, 200818 yr

Hi Again, I'm getting close to a deadline and would like to try to solve a few remaining minor issues. First, is to do with layout. I've got a series of screens that present either film clips or slides, where the screen real estate is valuable - so I can see good reasons for removing the status bar. Obviously I can navigate between records with simple "Next" and "Previous" arrow buttons on the layout. However, sometimes it would be good to know how many records I have in my found set and which record I'm currently on - information that the Status Bar always gives me. Is there a simple way to access this info and make it available on the layout. Since FMP already does …

• 2 replies
• 1.6k views

gessie

January 30, 200818 yr

Hello, all-- I've applied conditional formatting to a merge field but I'm not getting the expected result. The formula is simply this: Length (firstNameField) <6 If this condition is met, I simply want the font size of the merge field to grow to, let's say, 24pt. That's how I've got it set up in the "Conditional Formatting/More Formatting" window, but it doesn't seem to be working. I'm in Form View, btw. I must be overlooking something very simple. Suggestions greatly appreciated...

• 8 replies
• 2.5k views

comment

January 30, 200818 yr

In my database I have a number of relationships built up and a few portals on different forms to display related records (display only, not to add them, if this is important.) But I've started finding a disturbing problem. Say there are 20 records to view in the portal but the portal only has 10 rows. I click on the scroll bar to view more records. Instead of stopping when the last record is reached it keeps going. Sometimes, depending where I am clicking in the scroll bar, it shows repeating blank rows. At other times it simply duplicates the last record over and over again. If I enter one of the rows, the cell or row contents revert to a different "actual" record repres…

• 2 replies
• 1.2k views

Vaughan

January 30, 200818 yr