FileMaker Interface Features

Parent table is Account table in layout. Portal shows many "Apples" from my Child1 table belonging to only this account# with several other items , Oranges and Bananas too Apples, Bananas and Oranges, get populated in Child1 file, from a value-list from a 2nd Child table for all all counts When looking at 1 account layout, the portal are 3 apples of 5 other items How might I get an ongoing count of all the Apples, Oranges, Bananas when I relate to a different Parent account# I figure probably need something like a Count FOR calculation field. TIA

• 1 reply
• 1k views

David McQueen

February 9, 201016 yr

Is there a way to concatenate 2 value lists? For example, I want to have one value list derived from a field (call it "account name") Then I want to be able to append a value list with hard-coded values, such as "Add new account…" The only place I want this for is on a popup menu on a layout. The only way I can think of is to create a dummy record with the hardcoded value, but then it'll have to be hidden everywhere else, which seems like rather a lot of work.

• 2 replies
• 2.8k views

wintergreen

February 8, 201016 yr

I'm really desperate... I just upgraded to Snow Leopard 10.6, and I cannot start any of the databases I develop. The results is a application crash (libFontParser.dylib). Is there some kind of font cache I could delete. Or is there any other hint? Thank you for your advice.

• 5 replies
• 2.6k views

Ralph Schwegler

February 8, 201016 yr

My NAV buttons first/left/right/end buttons work fine When using Mouse Wheel my layouts aren't changing?? Using the RecordRquest/Page Previous GO layout1 or 2 etc RecordRquest/Page Next GO layout1 or 2 etc RecordRquest/Page Last GO layout1 or 2 etc RecordRquest/Page First GO layout1 or 2 etc

• 3 replies
• 1.2k views

bruceR

February 8, 201016 yr

Hi All, Okay, by hook and by crook and by kludge, I have made FileMaker print out most any kind of report I have ever wanted. However, it is always "just" a Chapter in any FileMaker book. Where there are several books on some pretty ubiquitous (and IMHO less effective) reporting tools disambiguated from an orderly, repeating arrangement of atoms and molecules. I am at a juncture where I need to "put it all together" where I have Statements by FamilyID where one or most student may be on a single statement, where the header should be for column continuation and the footer is for page numbering, and the title header needs to fit in a window envelope showing …

• 1 reply
• 1.7k views

ferdly

February 8, 201016 yr

How do I go about forcing users to use a drop-down list instead of typing in the field? I have a drop-down with six different K9 breeds and of course spelling is important because of some of the searches I have scripted (and of course I have people who get happy fingers and type too fast and misspell). I do not want to use a script trigger. Any suggestions? Thanks, Jim

• 2 replies
• 1.7k views

Totes

February 7, 201016 yr

I'm having a problem with using filtered portals to display information that has different status i.e. - Not Received, Received, Finalized. I've set up a field on the main record itself to display the status information but I'm having difficultly in developing a relationship that will only display one type of status on each portal. I'm wondering what the best way to accomplish this would be?

• 5 replies
• 1.7k views

comment

February 6, 201016 yr

For a module that generates text overlays over two superimposed picture container fields (one = background; the other a half transparent PNG image) I want to be able to change by script the alignment settings of my Text overlay field on a specific layout (using for instance its object name). I may have overlooked a function or workaround, but till now it seems to me that this not possible. Suggestions (also for plug-ins allowing this) are welcome...

• 6 replies
• 2.4k views

Tjebbe van Tijen

February 5, 201016 yr

Awhile back comment gave me this calculation to give me an expiration date on Jan 01 for some membership cards: Self≥Year ( Get (CurrentDate) ) ≤ Year ( Max ( expiration date::expire date ) ) This works perfectly, but now i need to add another expiration on top of it. The cards will have to expire 2 times now. The first date is Jan 01 and the second date is 6 months later on Jun 01(it is a six month grace period). I have been trying to get this to work: Self≥Year ( Get (CurrentDate) ) ≤ Year ( Max ( expiration date::expire date ) )+ Date ( Month ( expiration date::expire date ) + 6 ; Day ( expiration date::expire date ) ; Year ( expiration date::expire da…

• 6 replies
• 3.6k views

mr_vodka

February 5, 201016 yr

We have a strange situation in FM 10 that we have not encountered in previous versions. Windows environment, server host, 25 users. A user logs in using an account that has restricted privileges – can view layouts but not edit; can create, edit and delete in some tables; run scripts; view lists, menu commands set to all. When the user runs a script to produce a multi-page document, the script pauses in preview mode for inspection but the page arrows are dimmed out and are inactive. The same report for a user with full privileges will pause with the page arrows enabled. A user who has the highest levels for data access and design but not the pre-defined full…

• 1 reply
• 1.6k views

bcooney

February 5, 201016 yr

Is it possible to filter a value list in FileMaker? I don't want to reduce the value list. Rather, I would like to show only certain values and I would like to show them every time. For instance, in the Demo file attached, the parent table has three records: "Guitar", "Amp", "Microphone." On the child record I would like to use a drop-down with a value list in order to set the foreign key. However, I do not want to "Amp". So, every time I set the foreign key in the child record, I would like to see a value list of "Guitar¶Microphone". Demo_FilteredVL.fp7.zip

• 1 reply
• 2.8k views

Daniel Shanahan

February 5, 201016 yr

how can i prevent duplicate record in portal? if a data is exist in the portal row then in other row the same data should not be entered again. how can i do it?

• 1 reply
• 1.9k views

IdealData

February 5, 201016 yr

Hi all, I have never run into this problem with web publishing and portal. The main problem I am running into is that assuming I have 2 table, 1 is the parent and 1 is the child table. You have a layout base on the Parent table with a portal to the Child table. In the filemaker client, you can create a new record in the Parent table, then create as many record in the Child table as you like. However, the problem I ran into is when I publish that database on the web. When you create a record in the Parent table and save (do not create a child record in the portal yet). Then try to click directly inside the portal to create a child record, it simply …

• 2 replies
• 1.1k views

dangkevin

February 4, 201016 yr

Using Filemaker 9, I have a calculation that summarizes data based on date and and a dollar amt to determine a sales persons commission. For example, if the salesperson books between 13 and 20 loads the sales person gets an extra $25 a day. I have that working fine: Case (GetSummary(Total Booked; PU Date) ≥ 13 and GetSummary(Total Booked; PU Date) < 20; 25; 0) It finds a salesperson and sorts by date & puts the subsummary at the bottom of each date correctly. But I also want a grandtotal, so at the end of the week it adds up each of the days. The problem is the summary field doesn't add it correctly because now it's doing it over. Am I missing something? I…

• 1 reply
• 3k views

comment

February 3, 201016 yr

I'm not sure if this is the correct place to ask for help with a custom portal sorting function, but I am running into an issue when using portal sort extreme that I cannot figure out. I've successfully implemented all of the portions of this custom sorting function, but for some reason when it comes time for the Evaluate function to be used on the custom sort_formula field, the evaluate returns a "?". Looking at the contents of the sort_formula field everything appears correct (contents of field are "." & field_name) and is set up as a global text field but the evaluate still fails. Can anybody help?

• 0 replies
• 1.1k views

James Gill

February 3, 201016 yr

I thought I saw this "trick" once upon a time but I can not find it now that I haev a need for it...of course! Is there a way to place a portal in a portal? Steve

• 1 reply
• 1.2k views

bcooney

February 3, 201016 yr

Hi all, I have a complex summary report I need to produce. I do not want to report on the underlying data, just the summary. The data is made up of a lot of related tables. At the moment I've created a script which essentially searches for each component of the report, populates a set of variables and concatenates it into a text field. The problem with this is I need it to get a bit of eye candy to go to a client. i.e I can't do columns, nor appropriate tabulation in this format So my question is this, in your experience, what is the cleanest, best practice to produce these sorts of reports. I can do HTML, but do not have the knowledge of XML, an…

• 1 reply
• 1.3k views

ferdly

February 3, 201016 yr

Hello, I have 2 tables "Customers" + "Appointments". The Customers table collects all the basic info: Name, Address, Phone number, etc. In Appointments I've created a drop-down list (a value-list based on customer names in the Customer's table). That works fine. However how would I get it to pull the related "Address" + "Phone number" into the Appointments view once I select their name from the drop-down? I've created duplicate field names in both tables, and linked those fields via a relationship. I'm just at a loss as to what would be the type of Auto-entry options to get this working. Any guidance would be appreciated, thanks. Marco

• 1 reply
• 1.1k views

Marco L.

February 3, 201016 yr

Hello, I am working on a database for my company, I am working on our project table, which has projects listed by year with a related table of Contacts which can be related to a number of project years. I have a relation setup Projects_by_Year:Year = Contacts:Years I then setup a checkbox set showing project years (Use Values from Field:Projects_By_Year:Year), therefore if the year is checked that contact is related to that years project. What I am trying to do is uncheck a year via a script, where someone may want to remove that contact for a particular year but not delete the record all together, for example say we have 2007, 2008, 2009, 2010; 2007 and…

• 2 replies
• 1.2k views

JustinC

February 3, 201016 yr

Hi All, Here's my situation. I have a button to print fax or email an invoice along with several checkboxes for other documents that we may wish to include. For instance there is a checkbox to include a thank you letter (This is a jpeg copy of a signed letter in a container field) or we may wish to send a price list, etc. The way I have it set up now is by using multiple layouts each with a different combination of desired docs. So If I want to print an invoice it goes to a layout with just an invoice. If we want invoice and Thank You letter it goes to a layout with both the invoice and the thank you letter. Invoice, Thank You and Price List, yet another layout. The …

• 3 replies
• 1.2k views

mr_vodka

February 2, 201016 yr

I am almost embarrassed to ask this because it seems so simple, but I cannot figure it out after searching the forums or poking around in the database. Basically I have a field that contains a price value that data entry users have to fill in, however, I do not want read-only users to be able to view this field. Is there a way to have that field hidden to them as described above? Is there a way to create a separate layout that different only privileged users can view? Conditional formatting based on privilege? Thanks in advance.

• 2 replies
• 2.6k views

Jeremy Hodge

February 2, 201016 yr

Is there a way to format a value list which has 2 Columns of fields in it. My 2nd column of data practically runs into the end of column 1 making it not very legible. There is a need to format the value lists with a width value, or maybe it can be tabbed a certain number of tabs Thanks

• 0 replies
• 1.2k views

E Gish

February 1, 201016 yr

I have a little issue I am hoping someone else may have run into and solved? I have a Work Order with a portal line item list. I allow input to the line item list via the portal (layout context in the main Work Order). The portal rows have a button which brings up a new window in the same line item record (Context Line Item Table) with another portal of content choices for the line item. Buttons in that portal input the chosen content into that line item. The problem is I have a conflict because I am on the same record in the Portal on the Work Order page and in the line item content choice window. Sadly the "commit" command in the choose script from the…

• 2 replies
• 1.2k views

BilesterM

February 1, 201016 yr

I have a report that shows client payments. I have a sub-summary that shows the total of the payments. Say i have 4 client payments, this report shows 2 payments per page in preview mode and I can print them o.k. If I put the sub-summary field at the top under the header it shows the total of the four payments correctly. (I need it at the bottom) If I put it at the bottom beneath the body it goes onto a third page with other records. it shows the correct total though. This is driving me mad any ideas?

• 2 replies
• 1.4k views

ianmuir

February 1, 201016 yr

Hi all, I have searched the forum without finding answer to my doubt. I am setting up an invoicing system with FM10, and I have two tables, one with orders and one with line items. I have set an input layout where the user inputs in a portal the line items for each order. Now I am setting up a print layout, the idea is to print a table with all the line items of a record. The table should be dynamic and show as many lines as the line items in the order. I think that the idea is to put column names in the header and than line item fields in the body. Unfortunately it shows only the first line item. How can I obtain what I am trying to do? Thank you…

• 9 replies
• 2.4k views

ilnave

February 1, 201016 yr

I have a portal with a gField above and a button next to it that creates a new record. This works just fine, my problem is that the portal shows a empty row that is not needed. Is there away to turn off the empty row?

• 8 replies
• 4.1k views

BilesterM

February 1, 201016 yr

I have a layout with a grid of 24 buttons, each one with an Object Name — 1 through 24. When the user clicks on a button I'd like to provide the user with visual feedback on which button was selected. My thought is to use Conditional Formatting to make the number bold, colour it, and change the fill colour as well. No confusion on which button was chosen. The CF formula I was planning on was something like "Get (ObjectName) = $$GlobalVariable" but I haven't found a way to signal to CF the current object name. Is there a way, or perhaps a workaround? Appreciated.

• 2 replies
• 1.7k views

sandyinlet

February 1, 201016 yr

Several days... My label routine parent table1 with a cDataID field structure as calculations[50]= Case( GET(calcualateRepetitiveNumber) , Extend(LabelsQty); Extend(Data1) ) Looking at this table-1 calculation field and comparing it with a working example that works.. they both react the same, repeats the field depending on LabelQty I think problem is on Child side or the label layout or creating process.. I am making a new layout using Label instruction dialog I have tried all kinds of combination... and label 5160 including Data1 field etc until i am sick in the stomach not repeating i have create a layouts sets with some m…

• 1 reply
• 1.2k views

comment

January 29, 201016 yr

I've created a portal to a table with a container field. In this field I added a file reference as a test. I want to be able to have others access the file using this reference however when others try to open the file it gives them an error and has then try to find the file. I can open it just fine. The file is stored on our server. What am I doing wrong? I was hoping to use the container field as an electronic file storage system. Any suggestions?

• 3 replies
• 1.3k views

Cin

January 29, 201016 yr

Hi all, I have a database system where I can assign categories to a product. There are three levels: category, sub-cat, and sub-sub-cat. I have managed, with a little help, to create conditional value lists for the categories. The sub-category you can select depends on the category you have selected etc. Now I want to be able to compile orders, so I have created two extra tables: orders and order_line_items. From the order layout, I would like to have a portal for the creation of this order. I then want to be able to select the category and sub categories and then finally, based on the sub-sub-category, the product. The first problem is that my conditional …

• 5 replies
• 3.6k views

steveald

January 28, 201016 yr

I have a portal with 80 rows. When it prints, at the page breaks I lose one or half of one of the records When it goes across the page break, the record on the break either disappears, or only appears as the lower or upper half of the record in Preview and when printed. I have tried the body summary options, none of which seem to do what I need. What am I doing wrong?? Thanks Frommy (I originally posted this as a reponse to a different thread a few days ago, but have had no response, so am trying again with it on its own)

• 1 reply
• 1.3k views

mr_vodka

January 28, 201016 yr

I'm almost certain this is in the wrong place, so admin feel free to move it. I would like to know if it is possible to get the small yellow labels you see on most interfaces when you 'Mouse over' a button or link. Just the small yellow box with a little bit more detail in it. If so how do you go about doing this. Please point me in the right direction. Mark.

• 2 replies
• 6k views

Mark Grafton

January 28, 201016 yr

My database uses a job Number which is incremented by 1 every time a new record is made. My boss uses the "Duplicate record " from the Filemaker menu to duplicate a record. When you duplicate a record it adds the next job number to the duplicate record. My boss wants to make a duplicate record with no incremented job number. Any Ideas?

• 0 replies
• 1.3k views

ianmuir

January 27, 201016 yr

I need to figure out a way to indicate that two records are similar within a portal. Within the portal records I have a specific field that where I want the value to be unique within the portal. If any of the values within the fields of the record within portal are the same I'd like to indicate that somehow or make it stand out. Does anyone have any suggestions?

• 2 replies
• 1.3k views

Søren Dyhr

January 27, 201016 yr

It must be me that I am tired but I can't believe I cannot make a calculation field to change as the related data does! The only new thing to me is that I am working from data from a portal, but it shouldn't matter:THEY ARE NUMBERS FOR GOODNESS SAKE!. I use FM since the time it was claris. I am sure things got better with the new stuff, but this is basic and I am growing frustrated with 8.5 as it was a difficult migration (still is) from previous versions!

• 22 replies
• 4k views

neldom

January 27, 201016 yr

I would like to create a value list that lists all the records for one table (values from a field) AND also includes "Add New" and a seperator at the top of the list (custom value). If someone chooses "Add New" I'll have a script that runs. Can this be done??? Thanks in advance!

• 4 replies
• 1.4k views

AnnieT

January 26, 201016 yr

Hi All, I'm creating a project management database where the relationship structure is Category (parent), Project (child), ToDo (grandchild). Each category is a record, each project a record, etc. For sake of navigation, I'd like to create a grid layout where users see what is essentially a "home page" grid of categories (categoryName fields are all that need to be shown), 6 across and an infinite number of rows down. Users click on a category and are taken to another grid of projects that belong to that category. They can then click on a project to see details and todos etc. I can make the navigation work if I forget about the grid and use the list layout. But…

• 1 reply
• 1.3k views

mr_vodka

January 26, 201016 yr

maybe someone can help me on this "problem" I have a contact database ... and I want to include the whitepages.com funtions for looking up phonenumbers and to verify addresses ... instead of typing everthing into the website I want to automate it with FM this is the "query" I have .... the red part is the name of the respective fields but I always get an OOOPS ........ "http://www.whitepages.com/search/FindPerson?firstname_begins_with=1&/*firstname=*/ [color:red]Contacts::First Name & /*name=*/ [color:red]Contacts::Last Name & /*where=*/ [color:red]Contacts::City 1%2C+[color:red]Contacts::State 1"

• 1 reply
• 1.5k views

mr_vodka

January 26, 201016 yr

This is more of a user interface question, but I was wondering what most of you do with a delete button in a portal. Do you place it on the left or right side with-in the portal? Are there any interface guidelines out there that show people prefer a certain side? Some of my portals also have a go to related record button as well as a delete portal row button, and when I had them together that went over like a lead ballon as I can see now it is to easy to click the wrong one.

• 2 replies
• 1.2k views

mr_vodka

January 26, 201016 yr

I can't figure out why when I try to move layout objects all the way across the layout with my mouse, I cannot place them very far to the right. I can slide these object with the arrow buttons - but I cannot place an object past a certain point with the mouse. Any ideas?

• 0 replies
• 1.3k views

Darren Emery

January 26, 201016 yr

I am using a List of Numbers in a field on layout 1 from Table2. The values are populated from another field table in Table1. The Table1 values are Sorted in Descending order such as: 7003 7002 7001 7000 etc... But when i click on the field in Table2 to view the value list items from Table1, they are sorted as: 7000 7001 7002 7003 etc.. Is it possible to re-sort them in Descending order instead in the Value List? If so, how? Corey....

• 4 replies
• 7.5k views

capisco

January 26, 201016 yr

Hey, As you may know you can Freeze pain in Excel, where a selected row of cells stay on screen as you scroll further down the screen. Is it possible to do this with a header in Filemaker? I would like the page navigation tabs to always be in view. Would this also effect print out of records? Any advice appreciated! Mark

• 1 reply
• 2.1k views

bcooney

January 26, 201016 yr

I am pretty new to FM but I have created a database that contains three tables. 1) Client list - name, address, etc. 2) Task list - date and work done, 3) Fees - invoice number and charges. I created an invoice layout with appropriate client name and invoice relationships between three tables - one invoice/client with all tasks listed by date with charges. It works fine. Except, some tasks require a longer description than others and portals evidently don't slide to eliminate the blank space inside the description field but keep the set number of lines. Naturally the question is "How do I remove that blank space?" Thanks.

• 2 replies
• 1.3k views

Lee Smith

January 26, 201016 yr

Hi there everyone, I'm starting to explore the wonderful world of Filemaker. I'm trying to create a specific report. Here are the details. I'm trying to create a report of a list of numbers per category per location by date. So if I look up a specific date, I want the report to first list everything grouped in locationA, then in categoryA, but list out every number. Then repeat by categoryB and so forth. I've tried changing the amount of columns, and that sort of works, but I would like a cleaner look with each sub-summary and result all on one line instead of each being on separate lines. I hope this makes sense. Thanks for your help.

• 3 replies
• 1.1k views

hoon

January 25, 201016 yr

Hello again great community! Is it possible to have a radio button be triggered base upon a field belonging to a specific value list? I've seen a lot about using value lists for ease of data entry, but not a whole lot for verification purposes. I know I can do this as part of a script or as a replace field command, but is there something that will update automatically so I don't have to run the same thing all the time or have to list every item separately? Scenario. I have a field called "product", and 2 value lists called "fruit" and "vegetable". I also have two radio buttons with the same labels. If I enter apple and apple is in the fruit value list, can I …

• 0 replies
• 1.1k views

hoon

January 25, 201016 yr

I have to set a max number for each category in a found set. I set up a script to handle adding in the max value of a found set but I would like for it to handle adding the max value for each found category. I have the category set as a value list. Is it possible to loop a find with the set max script to go through each of the values found in the value list? There are approximately 30 different categories, and I know that I could manually have it go through each of them, but I figured there must be an cleaner and more concise way. An example would be there there are records in CategoryA that have a number field value of 2, 3, and 4. There is a field called maxNum. I…

• 4 replies
• 1.7k views

hoon

January 25, 201016 yr

Hi All I'm curious to know whether it's possible to construct a key (global) that emulates the * wildcard from find mode but operates on a relationship. eg Two fields in a table and a separate file with globals. Field one is a product code and field 2 a product name. Say for example we have the 1000 series, 2000 series etc in the product codes and they end with 08, 09 etc for a year. Is it feasible to construct a pair of keys for the relationship that accepts such things as 1*09 or 2*09 or the more complex variations like 1*0809 and returns the appropriate Descriptions to a value list ? And if so is it efficient where the tables begin to run …

• 2 replies
• 1.3k views

Eric W

January 25, 201016 yr

I have a row of 12 buttons, each of which finds a set of records. When I click a button, it momentarily changes color, but I would like it to remain a different color when the particular set of records is found, so that the user knows which set is operating. I have set a conditional formatting for the button to change the color of the button and text, but am not sure which formula to apply. I figured a variable to toggle the button on and off using Abs ($$color -1), but this only applies to a single button. What I want to do is loop through the other buttons and turn them all off when the button pressed comes on. Does anyone know a script which does this?

• 4 replies
• 1.3k views

Mark Grafton

January 25, 201016 yr

Hi, I have 2 fields Time_from and Time_to. They are both time fields. They are formatted as 24 hour HHMM. when you click on the fields they show the time and the seconds and I can not get rid of the seconds, any ideas?

• 4 replies
• 1.8k views

comment

January 24, 201016 yr

Help with Merge Field in the body of a letter I'm very new FMP10, teaching myself from "The Missing Manual" I have a merge field that shows the info from some records but nothing in others (in Browse or Preview modes) I've tried all I can think of. I would be glad to send the DB if need be. thanks raustin (Rich ...

• 4 replies
• 1.4k views

efen

January 24, 201016 yr

Hello, I'm trying to setup a WebViewer that would get a shipping quote from the CanadaPost server. It seems it should be fairly simple. In the attached HTML file the entire xml is taken from a field of the form. I want to turn it into a PHP file that takes the various pieces of data (not the whole XML) from the URL so I can have a WebViewer that's set to refresh http://www.myserver.com/getcpquote.php?CPCID=CPC_DEMO_XML&FZIP=mip1c0&TAT=24&...... And give me the text string of the server reply in a variable or field so I can parse it a present it to the user. How ? Thank you :

• 1 reply
• 1.6k views

cincin

January 23, 201016 yr

how can i remove tools menu using custom menu in filemaker pro 10 advance?

• 3 replies
• 2.4k views

Arny

January 22, 201016 yr

Hi, I'm having a small problem trying to resolve a puzzling language problem. How can I create radio button set which change language depending on the user settings? I attached a file to show what I'm trying to do. PS I know there is a problem with attached files so click the link to download the file. http://www.mediafire.com/file/n4wuykjyezm/Languages.zip Thanks

• 5 replies
• 1.6k views

Peter (duksis3)

January 22, 201016 yr

I am trying to restrict a value list as follows: two fields - one named "Subject" the second named "Category". There are multiple subjects for each category. I have the database setup so that when I enter the Subject field in Find mode, it drops down to show all the subjects. Then based on the subject chosen it shows a restricted list of categories to choose from. When the Find proceeds it goes to the full record that has that Subject and Category. --My problems is that I don't want to show all the Subjects in the dropdown - I want to restrict the dropdown list in Subject to only those Subjects in the current Found Set. So far nothing I do to the way the Value List i…

• 2 replies
• 1.7k views

PBrooks

January 21, 201016 yr

Hi everybody, this is my first post here as I have just recently landed on FileMaker. I am trying to develop a simple program that my mother will have to use for her job. Basically she will have to input several fields in tables and then she should be able to use those data to: -track orders -generate invoices I have some knowledge with MS Access but I am looking into FM as I am using a Mac and she is using a PC, plus I would like to make somehting graphically more evolved than Access. The structure: Table 1: client contacts (name, address, email...) Table 2: client order numbers (name, order number, order date) Table 3: order detail (order…

• 5 replies
• 1.4k views

ilnave

January 21, 201016 yr

I'm simply trying to allow the portal text field to auto expand as moret ext is entered via browse mode. ie I have one row set for the view, but i want it to expand to two or three rows if the user enteres this much info - right now it disappears beneath the border, and I can't see it from browse mode. Thanks!!

• 1 reply
• 1.2k views

mr_vodka

January 20, 201016 yr

If I have a portal with all of the information I want to export to an excel spreadsheet, is there an easy way to do this? I was thinking I could make a special layout with all of the same fields... and run a scripted button on the portal that would "Find related Records" and display it on the other layout, and then export it. It would be nice if I could just export the portal records directly from the portal.... is that possible?

• 7 replies
• 5.3k views

Lee Smith

January 20, 201016 yr

Let me try to explain. I have 3 Tables called - "ContactManagement";"AssetManagement";"ServiceManageMent". All tables are related to each other based on ID: (equipment) and Contact: (Full Clients' Name). My issue is with the layout I call "Service_Form". On this form I have several fields for typical help desk stuff but 3 fields I want to populate via my example. They are: [color:red]ID; [color:red]Asset; [color:red]Serial;. I have inserted a portal that relates to the "Contact" field that lists all equipment assigned to the [color:red]"Contact" that is pulled from the "AssetManagement" table. Ok. . . so this is what I am trying to do. . . In the port…

• 15 replies
• 2.4k views

xxx202xxx

January 20, 201016 yr

Hi, Is there a way to copy the tab order when I duplicate a portal? The problem is I need 4 portals since the data needs to be disp-layed horizontally. Each portal is a copy from the first one, except for the shown record. The tab order doesn't follow the same order as the first one. Thanks for any help

• 1 reply
• 1.2k views

bruceR

January 20, 201016 yr

I simply want to know if there is any way you can make a portal auto-resize in function of the number of displayed records shown within the same portal. It is a feature that would greatly improve layout designs in general. Also: I have seen a portal that resize automatically when the window is resized... I think it was in "starting point" free solution. How do I do this? I tried the "anchors" in the object info, with no results (it only resizes horizontally upon resize... why not vertically?) And finally: just like the way the topics are shown in this forum, there should be a way to "minimize/show" portal records from a whatsoever kind of titlebar button... or i…

• 1 reply
• 1.4k views

bruceR

January 20, 201016 yr

I assume this has already been asked but I can't find anything and I've been working in a cave for 2-1/2 years so I'm way behind on using the web viewer. Googles new speed requirements are creating a big problem for me because of the speed of FMS and the required physical distance between my web servers and the database server (Linux web servers in New Zealand, Canada, South America, etc. with the Windows database server in Calif.) I have some existing 'full featured' websites that have a few dozen pages that use the FM PHP API but are fairly static. I'd like to leverage what I already have then create static pages via FMS or a robot then send them to the web se…

• 5 replies
• 1.8k views

comment

January 19, 201016 yr

I'm running into formatting issues when copying layouts and then trying to resize the body part of the layout. For some reason Filemaker sometimes decides that it will not let me drag a part size to the same size that I have on another layout. While this is a minor issue, when navigating between different layouts that are relatively similar, it's very annoying to see things jump around because a part isn't exactly the same. Is there a way to specify an exact part size in Filemaker? Whenever I click on the part to resize it I can see its size the status window, but as soon as I unclick it I loose the ability to specify the size.

• 1 reply
• 1.1k views

bvo12585

January 19, 201016 yr

I'd be most grateful if any of you could tell me of a way to disable the right-click/copy mouse option in Filemaker 6, so as to prevent people from copying the images in the container fields of a layout Any method that prevents unauthorized copy/paste would be welcome. Sorry if this has been answered elsewhere, but I've been checking and couldn't find it. Regards

• 4 replies
• 2.8k views

thersites

January 18, 201016 yr

I have a field in a portal column.. selecting from a valuelist of fields Once i set its field from blank with text.. How can i disable any further editing of that field clicking on same field field again Field is plain text, theres no calculation set on field..

• 3 replies
• 1.7k views

bcooney

January 18, 201016 yr

Hello all! I was woundering if there was a way to do conditional formatting on a feild to make it hide all of the contents of a certain field. For example you can do an IF formula to say if something is chosen in this field such as "Consumer", then hide this field (a feild that holds information for businesses). As that feild would be irrelevant for a customer. (if you know what i mean) Also i have added a botton to the form and when ever you click anywhere on the page it activates the button (this is annoying) lol. Does anybody know how to activate the button ONLY whne you click on it (not anywhere on the page). Many Thanks!! :)

• 1 reply
• 1.8k views

Josh Ormond

January 18, 201016 yr

Hello. I am working on a filemaker database for a small sales team that keeps track of contacts, companies, projects, and leads. Most projects start out as a lead. In other words, some leads turn into projects, but most don't. My client wants to keep track of projects and leads on separate layouts. Since projects and leads share 90% of their fields in common, and I need to be able to easily convert a lead into a project, it makes sense to have one table called "Projects" and a boolean field to specify whether or not it is a lead. Then, once a lead graduates to a project, all that needs to happen is a change of that boolean value. I have a Projects layou…

• 9 replies
• 10.4k views

Mark V

January 18, 201016 yr

I'm a filemaker user/developer with a small 3 Mac network which has been running without issue for years. I upgraded a machine recently to a new Imac Intel core 2 duo (as I do every couple of years) and as per usual, transferred all applications from the old to the new machine including FMPro 10.0v3. On the new machine FM launched OK and opened the FM application on a linked machine but most (but not all) of the portals are not working (only) on the new machine. In Layout mode on the new machine none of the field names are visible. In the portals on the new machine there are dotted outlines where the fields should be and double clicking these will correctly open linked f…

• 9 replies
• 1.8k views

reddust

January 17, 201016 yr

I don't know if this is possible but i have a databse file that contains 3 fields ie PART_NO DESCRIPTION ACTIVE_PART this is a stock database. I can create a value list by selecting use values from field and selecting PART_NO as the first field and then DESCRIPTION as the second field showing only values from the second field. This allows me to show the values of DESCRIPTION in the list but place the PART_NO in the correct field of another tables field?. What i would like to do though is get this value list only to show values for records that have the ACTIVE_PART field set to true as i do not want to delete records when a part becomes obsolete but would like to set …

• 7 replies
• 3.1k views

bcooney

January 16, 201016 yr

Strange.. I have a portal that i am adding a 4th numerical field ... The field displays Yes, when i click on it i see my numbers.. Pd Price Recv Qty Sell price Qty Bal And Date I 've change field names, created a new... added a 5th field being a text type okay Copied a good num field to, change it flips doing the same thing? When I open the file, create a form and browse via Filemaker my data is fine.. There no field CONTROL setup Create completely new field same strange thing What goes here?

• 7 replies
• 1.7k views

RodM

January 16, 201016 yr

Oooo-kay, here I go again! I'm working on an expenses db currently. For report purposes, I want it to look like this: [Category] [sub-category] [individual entries] . . . (etc.) [sub-category] total: [total by sub-c.] [next Sub-category] [individual entries] [next Sub-category] total: [total by sub-c.] (and so forth... followed by:) [Category] total: [total by Category] (and then at the very bottom:) Grand Total: [total of all items] I'm attaching the db in question, so some smart person can take a look at it. The thing…

• 2 replies
• 1.3k views

zenmom

January 16, 201016 yr

Hi Guys, Im creating a merged letter within filemaker, is it possible to create 'conditional' lines of text without having to introduce another field which does the calc for you. Im thinking along the lines of - if(field value = "M") then display "Male" as in the text....and I'm trying to avoid creating unnecessary fields in FileMaker to do this as its only used for report purposes. Thanks Jalz

• 3 replies
• 1.2k views

Jalz

January 15, 201016 yr

Not explaining myself well a previous post Attach test.fp7.. with FILE1 with 3 records Listfile with 7 records I created a simple valuelist on FILE layout How would when clicking on my pulldown I only get listed or those only approaiate records in valuelist? When you click on my get button I am getting all seven records test_ValueList.ZIP

• 3 replies
• 1.3k views

LaRetta

January 15, 201016 yr

I am having a difficult time getting a multiple page report to print out via a script. My goal is to print 3 separate pages; a dynamic fax cover sheet, a second page containing order line items, and a static page containing pre-created text. So far I have got everything that I need working up to 2 pages by fiddling around with the title header, header, body, and footer parts, but I am unable to get filemaker to print a 3rd page. Admittedly I don't even know if this is the right way to create a report like this, but it was working very well up to 2 pages. Any ideas?

• 12 replies
• 2.1k views

bruceR

January 15, 201016 yr

I have a Microsoft mouse that scroll wheel moves my records in Browse any clues how to fix this other than disabling my mouse

• 1 reply
• 2.7k views

Fitch

January 15, 201016 yr

Anyway to load watermark images in the background and keep multi column printing? I need it to fill the entire body. If I just enlarge the image, then I just get one record per page. And if I use a portal that works fine, but then I get half the watermark in each column. I guess the question at this point is if there is a way to make a graphic fill the entire page when using columns or if there is some other way to create columns where I can have a background image span the two columns. Or do I really need to use Word to do this... FM9 advanced. Thanks, -leo

• 2 replies
• 1.2k views

The Dude

January 14, 201016 yr

Hey. Not sure if this is the right place, but as a "learning as i go" user, i wanted to share a tip that i had to learn the hard way... I have a database setup which works great for my needs. I was trying to write a script to run on all the computers that use the database...some Mac, some XP, some Vista. All was fine until Vista. The short story is that the script would not work on Vista no matter what i did. It wasnt until i realized that my date used in my script was being pulled from a global date field, however the field type was set as TEXT, rather than DATE. This caused the formatting of the date to not jive with the rest of the fields being called in my scrip…

• 1 reply
• 1k views

lawaid

January 14, 201016 yr

Is there a way to change the color of an object (a button in particular) in a script?

• 5 replies
• 13.4k views

bowhall

January 14, 201016 yr

Not sure where this one belongs, so here goes. I have a storefront file, and in the register part, upon checkout, I have a dialog box that pops up at one point asking how much is being paid - normally it's the whole bill as one payment, but let's say you want to pay part in cash, then the remaining on your credit card. So what I have done is when the dialog box pops up, the total remaining due (whether the whole bill or what's left to be paid) is in the entry field, and highlighted. That way if you are paying the full amount due, the clerk just hits enter, or they can just type in the partial amount. That part all works great, but the problem is I can't format…

• 4 replies
• 1.5k views

titanium

January 14, 201016 yr

Is it possible to have a Value List, to list data from several Tables of records? I have several related Tables, but i wanted to place a value List on a field, that will contain data from several other tables, not just 1 or 2.

• 2 replies
• 2.4k views

comment

January 14, 201016 yr

Hi All, I apologise in advance if this is posted in the wrong forum, but I'm a total FM newb! Anywho, What I'm trying to do is make a database for my pharmacy that records all the formulas we prepare. Without going into details (don't wanna bore you) these formulas are made up of different APIs and each API has multiple batches associated with it (APIs are delivered in batches and we need to record which one was used. Each Batch may only belong to one API.) I have an AddBatch table with two fields; API ID and Batch ID. Each time a batch comes in we record the Batch ID and the API that it is. Now in the Formula table I want to be able to choose an API from a …

• 1 reply
• 1.7k views

comment

January 13, 201016 yr

With Instant Web Publishing, accessing a valued list, via radio boxes, pop up lists etc. dont work that well. Is there a solution that makes these work better. It seems to me that the file doesnt update quick enough for them to work.

• 2 replies
• 1.7k views

IdealData

January 13, 201016 yr

How to number pages in preview mode in Filemaker ?

• 5 replies
• 1.6k views

comment

January 12, 201016 yr

Like Costco.... take a picture it gets laid to membership card.. We have additionally, also 2 standard sheets 8 1/2x11 size to scan and attached to our client.. My application is done up to .. currently operator using Filemaker right clicks or inserts image to container... The major problem is any photoshop editing... etc... ANy suggestion how we can proceed with a dummy simpler way of doing this?

• 1 reply
• 1.8k views

TheTominator

January 12, 201016 yr

Two clients, (multiple users, similar solutions) have reported this problem beginning a few weeks ago. We have FM 8, 8.5 and 9 users with this solution as well and so far, no report of this problem. A user will be typing in a field and the cursor will suddenly exit the field; subsequent keystrokes are not entered, no other field is selected. The user must click back into a field to resume entry. It is described as the keyboard freezing or the screen freezing but a click in a field or on a button seems to reestablish focus on the FM window. I don't believe it is a slow screen redraw issue because it can happen in a screen that has been open for a few minutes. There ar…

• 1 reply
• 1.3k views

John Kamm

January 12, 201016 yr

I'm trying to make a 1 pt. horizontal line that is conditionally formatted to: Case( Get( PageNumber ) = Data_9_:${$$Last_Page}; 1) I can't conditionally format a graphic line so I tried using an empty text box but the smallest height the field would allow was 5 pixels (I formatted the font to the smallest size allowed within the field). Any ideas?

• 4 replies
• 1.7k views

IplayWoW

January 12, 201016 yr

Hi all, I am working with a system which needs quite some reporting, so I have decided to use conditional formatting to create a nice overview. I have five fields in a column on my layout, and a "total" field. What I want to do is give the five fields a color based in their value: First I determine the minimum value and the maximum value. The fields that have a value within the highest 20% between those values are red, the second highest 20% are orange, etc. I use the following formula: Self ≥ ( ( ( ,8 ) * ( Max ( field1 ; field2 …

• 9 replies
• 7.2k views

comment

January 12, 201016 yr

I have a database with many layouts: 1. is there a way to sort the layouts? 2. is it possible to edit the layout numbers? I also found the very helpful layout file from 'genx', would anybody know about an updated file of his version? http://fmforums.com/forum/showtopic.php?tid/181969/ Cheers Greg

• 3 replies
• 1.6k views

Greg O'Connor

January 11, 201016 yr

Hello - I have a table called DocType with the following fieds dtID (num) and TypeName(text). I have created a Value List called vlDocTypes from this table. I have another table called Vendor it has all the normal fields you would expect and then it has the following 3 fields: dtID_purchase (num), dtID_creditmemo (num), and dtID_payment (num). As you would guess each of these are supposed to have values from vlDocTypes. Now, I can of course could have 3 different TOs (of the DocType Table) for each of dtID_xxx fields... However is there a way to do this with a single TO relationship between Vendor and DocType? Thanks Rich

• 1 reply
• 1.2k views

bcooney

January 11, 201016 yr

After upgrading to FMP 10, I started noticing that the fields would lockup on me in Layout mode when I tried to move them. The fields are unlocked and un-grouped. This behavior is only visible on our PC systems and not the Mac's. Currently we have a Mac Server hosting to a variety of PC's and Mac's, and the operating system for the PC's includes XP/Vista/7 and all exhibit similar behiavor. Does any one have a solution for this? Thanks in Advance for any assistance. Byron

• 0 replies
• 1.1k views

nanigimusic

January 11, 201016 yr

Hello, Is there anyway to print a list of the field name on a layout (not the whole database)? Thank you.

• 6 replies
• 3.1k views

bruceR

January 11, 201016 yr

Hi to all i need help about modifing and reordering a filemaker database.. what i don't understand is how to group some radio button values ... i mean - i have 20 radio buttons , they are unchecked as default - i need to add another button which reports if , for a selected record, any of these button are pressed, simply reporting "yes" or " none"... Any idea to do this? thank you very much

• 6 replies
• 2.1k views

comment

January 11, 201016 yr

Hi, I'm working with FileMaker Pro v10. I'm back mucking around with it after being away from it for awhile. I find the text or data in the cells easier to read if there's a little white space between the edge of the cell and the beginning of the text. I figured out how to go to Layout Mode, then Format > Text > Paragraph and then specify an indent value. So the leading edge now has that lovely little sliver of blank space before the text starts. However, (and this is not a huge deal, just frustrating because I keep thinking there *ought* to be a way to do this), I haven't been able to find a way to do the same with the vertical spacing. I see the Line Spacing secti…

• 2 replies
• 2.9k views

Ralpho

January 11, 201016 yr

Hi all, Relatively new to this but am slowly catching on. I've created a database to record a group of people and their involvement in a series of projects. I have a table of People, a table of Projects, and a join table of Interactions, which records the two foreign keys and information about each individual person-project interaction. This all seems to work fine, including the relationship between the three. The trick comes in when I attempt to divide the interactions into two categories. A person can be involved in a project in one of two ways (Staff or Volunteer) and can change type from project to project. On the Project layout, I'd like to have two porta…

• 9 replies
• 2.3k views

BPT

January 11, 201016 yr

I've used FM over the years in a very superficial way. Now I'm trying to adapt one of the existing templates: Expense Report. I want add a field, Expense_Vendor (in order to identify the company the expense went to), to the Expenses table and have it show up in the portal of the layout "Expense Report". I've done that with no problem, but I'm not able to type into the field in the portal. I've tried looking at the other fields in the portal (Expense_type, Expenses_day 1, _day 2 etc.) to find what the difference in my new field is without any luck. I notice that these other fields have a small rectangle at the bottom, in layout view, that my field doesn't. Any ideas wh…

• 4 replies
• 1.4k views

bcooney

January 10, 201016 yr

Not sure where to post this. I have an annoying feature/bug that I can't figure out. I have a FM10 DB shared on one computer. On the remote computer when the DB is opened, the FM window is small, narrow, and off to the right side of the screen. (Used to be the size I wanted on the left of the screen.) I can resize it, but next time I open the remote file, it's back to small and on the right. I've rebooted both computers and trashed all the FM preference files I could find on both computers. Nothing makes a difference. Any idea where I can find that setting and clear it? Any help would be appreciated.

• 1 reply
• 1.3k views

PacificStar

January 9, 201016 yr

Hi Folks! How does one right a script that would take data from a portal and compile it into a single list in one field for that one order? I have a currently have a portal in my Order Table that shows what Purchase Orders are related to that job. I need to compile just the PO ID, the supplier name and the date ordered into a list that can print on the job docket. Thanks again for all of the help!

• 5 replies
• 1.6k views

skearton

January 9, 201016 yr

Can I move the status toolbar to display on the left instead of on the top? I could really use the extra display that this now takes up. (I'm using Win 7, not Vista. Win 7's not a choice in the drop down Platform menu?)

• 6 replies
• 2.2k views

Lee Smith

January 8, 201016 yr

I have some price information in a field that I want to hide from certain users. I've been playing around with conditional formatting and did the following: 1) I did an image overlay that is transparent for "User X" and applied a white fill for "User Y". Apparently even with the image overlay, you can still click the field and it brings it to the front (displaying the price that was previously hidden). 2) I applied the same conditional format to the field itself. I left the text black for "User X" and turned it white (to match the background) for "User Y". Again, it works but if "User Y" were to click the field the conditional formatting disappears. Is…

• 3 replies
• 1.8k views

comment

January 7, 201016 yr

This will sound strange, but I am looking for a dev platform that I can allow the end user (of a runtime solution) to move or resize fields on the layout. This would be kind of like a simplified report writer. I have written a DB project in FMPro 8 before and am familiar with it, but wonder if there has ever been anything that can create an on-the-fly customization tool. (am willing to upgrade if need be.) Any thoughts would be most appreciated.

• 3 replies
• 1.2k views

comment

January 7, 201016 yr

Please bear in mind that this may be a stupid question but I'm going to ask anyway. I have a series of invoices that I currently have displayed based on due date, then by invoice number, finally the items per invoice as below, the invoice date and Invoice number are in one table, the line items are in another related table. 01/01/2009 (this is in a subsummary part) Invoice #12345 (this is in a second subsummary part) Item1 (these are in the body) Item2 Item3 01/05/2009 Invoice #12345 Item1 Item2 Item3 I would like…

• 1 reply
• 1.3k views

bcooney

January 7, 201016 yr