FileMaker Interface Features

I have a "notes" field using an edit box that the user can scroll up and down for adding text on a record. I want to have a button that when clicked it will insert the current date in red and bold at the point the pointer is in the notes field and have the text the user enters in black. I can make a button and get it to insert the date but I cant work out how to have it do it in a different colour. I would also like it to add a space after the date so the user can click the button and just type the note, It would be very cool if the button could also make the pointer got to the top of the notes field insert the date and then the user can type so they dont n…

• 3 replies
• 994 views

mr_vodka

February 26, 200719 yr

OK - I have finally figured out how to assign different colors to a value (e.g. <60 red, 60 orange, >60 green) using a calculated field and a case statement .... however in my layout, the color gets overwritten by the color used for the field - when i click on the field it changes to the correct color, but when i just look at it - it does not..... how can i tell the layout to use the color assigned to the field??

• 13 replies
• 1.5k views

LaRetta

February 26, 200719 yr

Is there any way that a click on a button can pass the object name of that button to the script that the button runs? It would be OK if this is done as a script param, or some other way. As long as I don't have to enter the object name again as a hard-coded script param. Thanks! M.

• 11 replies
• 1.6k views

Raybaudi

February 26, 200719 yr

hi, i'd like to duplicate a record and all the portal records attached to it. any good ideas of how to code this so that my end users can do it seamlessly? thanks!

• 3 replies
• 1.5k views

rfm1966

February 26, 200719 yr

I have a tab with 3 sections. Passwords, Cards, Reminders. In each tab there is the same portal row that displays a field of a record. How can I show different found sets in different tabs? For example password shows all records with passwords and reminders just shows records that have reminders in them in the portal? Thanks Thomas

• 15 replies
• 2.2k views

tmas73

February 26, 200719 yr

Further to my questions, I am creating a Trivia Database with question and answers. I want to run a report, where I can go into my database and show me a random list of 50 records. (ie. Question & Answers) (each record contains a question and answer) and print them out. I know out to create a layout and to print, but don't know how to pull 50 records randomly every-time I run the script. Many Thanks, Dean

• 1 reply
• 1.1k views

comment

February 26, 200719 yr

Hi All, Can anyone help me on this question? I am creating a database of trivia questions, I have created 3 fields 1. Question No 2. Question 3. Answer I want to print them out, but to save paper, I want the Question & Answer field to re-size for each question, as they will have long & Short - Answer / Questions. Can anyone help me on this one? Many Thanks, Dean

• 2 replies
• 955 views

Dean Redding

February 26, 200719 yr

I want to make a library of PDF files available to my IWP users through Web Viewer. I can write a path that works on my machine, but am having trouble making it work in IWP. How do I write a path that will direct a web viewer in IWP to a PDF file on my host drive? I'm using Tiger at home and XP at work, if that helps. Peace, Pennsyltuckian

• 4 replies
• 1.6k views

pennsy

February 25, 200719 yr

I've got a portal in my app that's a selector - user clicks on a row, and that determines what is displayed elsewhere on the screen. I've got now problem making this work in general. My question is about visuals for the selection portal itself. Normally I might go with the native portal highlight, or script a container field in the protal to change the background. However, some rows in the portal will already have a different background color, as this is used as a visual metaphor in the app (for newness). Not open to suggestions to change that. So I need an alternate method of highlighting a row, that doesn't involve the background color. I'm lookin…

• 4 replies
• 1.4k views

Genx

February 25, 200719 yr

I have seen some solutions wherein you can highlight a record in a portal view and in another portal view right next to it all the related records highlight. So, rather a portal selection filtering to show only related records, it continues to show all records but highlights the related ones. How is this done?

• 10 replies
• 1.7k views

mscholtz

February 25, 200719 yr

I have been trying to work out a way to trigger a language change in "NoTrigger" in order to make it work like "IsThisJustBetter". I suppose i would like a way to make the first file work but at the same time am asking "IsThisJustBetter"? I suppose i would like to try and keep the language database centralized. best Stuart NoTrigger.fp7.zip IsThisJustBetter.fp7.zip

• 3 replies
• 1.2k views

Stuart Taylor

February 24, 200719 yr

Wondering if anyone has done this. I need a calc field with a scroll bar to always present scrolled to the bottom - whether or not the cursor is in the field. Any thoughts?

• 6 replies
• 1.1k views

Stuart Taylor

February 24, 200719 yr

I have a portal in Companies that shows all related Contact. In the Contact file I have checkboxes for MAIN, SPECIALS, PRICING... I would like to have the portal in Company file sort these on the value list for the checkboxes (MAIN, SPECIALS, PRICING). This works fine when 1 checkbox is selected but as soon as the Main Contact also receives specials the person goes to the end of the list. Does anyone know how i can fix this?

• 5 replies
• 1.1k views

comment

February 23, 200719 yr

For some reason I am having a tab order problem on my layout. Scenario: I added a field to the layout and it automatically put in a tab #. I had complaints from staff as this was a field out of the normal view for admin use only. I deleted the tab # and then reorganized the order. This messed up the way it was ordered. I've looked at a backup copy and reset up the tab order the way it was but it still isn't working like it was. I have tabs 1-4 in fields from the current table on the layout. The next tabs are in the portal. The backup copy skips 5 and then goes to 6 7 8 9 skips 10 then 11 and 12. When I set the same numbers when I click ok it changes them to be…

• 14 replies
• 1.5k views

Lee Smith

February 23, 200719 yr

I have a list of invoices with a product; the quantity sold; the price of product; the royalty rate as a percentage and a calculation field that calculates the royalty rate times the price to give the royalty payment. It works fine. I have them sorted by product. I have a sub-summary with price summary and a royalty payment summary that shows what the total of the price paid is and the total of the royalty payments owed. It shows up in the preview mode of my report just fine. What I would like is to see only a list of the sub-summaries without seeing the individual invoices. It would look something like this: [product #1] [total quantity sold] [total of pri…

• 1 reply
• 801 views

Twd70

February 23, 200719 yr

I'm trying to omitt records that I use for tracking my jobs. Once a job is complete I would like to Omitt it from the report. I wrote a script that omits the jobs that are complete and it works. Each job has multiple records under each job title and it gets rid of them all. Woot! My problem is the jobs that are not complete it omits some of the records in them as well. It still lists the job as not complete, but some of the related records are gone. There is nothing in the fields that I told it to compare with to find out if the job is complete, but it still omits them. Has this happened to anyone else?

• 3 replies
• 775 views

skbrimer

February 23, 200719 yr

Hi I'm not sure if I am in the right area. I am entering data and creating a new record each time. I want there to be some kind of eit box automatically displaying the information that has just been entered, (info from all records). Thanks Trevor

• 3 replies
• 1k views

Rehoboth

February 23, 200719 yr

ok so i'm using the contact management to keep track of clients in our non profit agency. we have clients come in multiple times a month, for these clients, every time they come in, data is inputed in the notes section regarding the purpose of their visit. the problem is that every time these clients come, we have to input the data in the same "notes" section and if we ever need to print out info for a certain visit, the program will print out the filemaker page with ALL of the notes in the notes section what i want to do, is perhaps format a new entire page or tab for notes only, where i can create multiple fields and separate the notes by month, maybe even have like…

• 1 reply
• 745 views

l_gomez

February 23, 200719 yr

Once again I'm flummoxed by a simple sliding problem. I just want a List view with a Name on the left, and up to three phone numbers, arranged vertically, to the right. Joe Smith___111-2222 ____________222-2222 ____________333-3333 (Underscores are shown here to maintain horiz. spacing in this posting. In the actual application this is just white space) I want the phone numbers to slide upward, and I want the row height (the body) to be reduced, when some of the numbers are missing. Currently Joe Smith is a text box with <> merged, and the telephone numbers are a single text box with <> <> <> merged. Both text box…

• 5 replies
• 953 views

Raybaudi

February 23, 200719 yr

hello! i want to know what calculation should i do in a field so that it displays the count of fields in a portal. Thanks!

• 3 replies
• 1k views

Genx

February 23, 200719 yr

I just *know* I'm missing something obvious, but I've never done this style of value list before. Apologies in advance if I don't post my file, but it has my company name splashed all over it and it's internal... I have two tables. One of them is designed to hold onto values to be used as a value list in the other table. The idea is if an edit is made to a value, that value changes everywhere it was used in the other table (i.e. the field value changes but the key value remains the same): TABLE: networkPortLocationList __kp_networkPortLocationID (primary key) netPortLocValue (list value) TABLE: networkAccessTable __kp_networkAccessID (primary key) …

• 27 replies
• 3.9k views

Genx

February 22, 200719 yr

I have a script that will select an object that is a field, but what is the next step to get the cursor in that field ready for editing?

• 2 replies
• 1.1k views

rivet

February 22, 200719 yr

Hello all! I have an issue that has perplexed me for years, and now it's time to see if I can't get it worked out. The problem is unwanted blank space in line 2 of my (auto-generated) Avery 5160 label layout when there is no person #2 in that <<>> field. For instance - the lauout looks like this: <> <> <> <> <> <> <> <> <> When "<>" and "<>" do not have any values in them, there is a blank line there. How do I get rid of that blank line? Sliding/Printing does not seem to work becuase it only appears to handle "box-type" fields, not these "<<>>" fields…

• 2 replies
• 770 views

Tony Martin

February 21, 200719 yr

I have a table and layout devoted to 'Courses' which has a Course ID, Course name, room number, etc. Also, courses are given a "Status" as either Active or Inactive. I then have a 'Registrations' table and layout where I pull courses into via a value list. The value list is comprised only of the Course ID and Course Title...and it works fine. I'd like the value list in the Registration layout to only display those courses which are Active. I tried doing this: If (Status = "Active" ; CourseID ; " " ) along with this: CourseTitle&" "&Section&", "&Program The idea was to create a value list based on these two field calculation…

• 3 replies
• 957 views

jbullydawg

February 21, 200719 yr

I created a database to manage the Advanced Placement (AP) program at my high school. I am trying to create a layout that displays the total number of test takers and the total number of tests administered (some students are taking multiple tests). I used a field with check boxes to indicate which of up to 10 tests each student is signed up for. How do I define a field for my summary layout which allows me to display the total number of tests to be administered ( I already figured out how to display the total number of test takers)

• 4 replies
• 841 views

comment

February 21, 200719 yr

Sorry if this is a simple question, but I haven't found the answer! I have a Header that has a small object, about an inch in height. I am trying to expand the Header, but it won't move. It won't budge. How can I "unfreeze" the Header? Alison

• 2 replies
• 1k views

Alisun

February 20, 200719 yr

Here is what I have done: On a layout I inserted a movie (audio-only) that plays back perfectly. When I switch to another layout that contains the same record, but in a portal, when I try to click in the container within the portal, it asks me to record a new sound rather than playback the movie. If I then re-import the file in the portal, then it plays back. Question: why won't it play back in the first place? Why do I have to re-import it from within the portal before it realizes there is data there? It's as if the portal isn't getting the data the first time. Thanks.

• 0 replies
• 1k views

hayesk

February 20, 200719 yr

...the bars on the bottom and right of the window? The left side of the window, sans status area, is neat and flush. But the bottom has the zoom and view buttons and a whole bar across the bottom. The right side is there for the scrollbar, of course, but I don't need it. I can't find any view option that lets me eliminate those. Any ideas? J

• 3 replies
• 1.3k views

Raymond Gonzalez

February 20, 200719 yr

I am crating a database to compute student scores for a contest. I have most of it done, but cannot find a way to easily/ automatically calculate their rank. For instances the highest score is 1, next highest 2, etc. Any help would be great.

• 8 replies
• 1.6k views

Genx

February 20, 200719 yr

I am creating a FM database that I will use Instant Web Publishing and host on FM Server 8 Advanced. When my new users are creating their account name and password on one of the layouts, is there any way to mask their password with asterisks as they create it? Thanks

• 2 replies
• 1.1k views

Genx

February 20, 200719 yr

I created a FM database which basically is a timesheet tracking database. However, the output reports are based on 3 seperate forms. These forms were imported from MS Word documents. I created a layout for each form. I need to be able to print each form individually and I need to be able to print all 3 forms as a 3 page document. I made a 4th form that I created by copying and pasting each form in to this form. The problem I have is maintenance. To edit form 1, I have to edit both Layout 1 and Layout 4. Is there a way to have only 3 layouts and be able to print the 3 layouts as a 3 page document? For example if you print or save a layout as a PDF…

• 1 reply
• 867 views

Lycanthrope

February 20, 200719 yr

Hi I have one field called Vendor Type. User can select either "Print" or "Broadcast" here. Now depending on what the user selects in this field, I would like to display different value lists for another field called "Pub Type". I cannot figure out how to do this. Any help will be greatly appreciated... Thanx

• 2 replies
• 796 views

edmonton

February 20, 200719 yr

This is a temp solution. I want to give access to the Account & Privileges off the menu line in a custom menu but I only seam to be able to give for all Define not just the Account & Privileges. I know they would need to have full access and could then change thier access. But like I said this is just a temp solution. Is there a way isolate Account & Privileges? Thanks in advance

• 0 replies
• 1.3k views

elanahy

February 20, 200719 yr

Are there any issues with deploying the Webdings font in a cross platform solution? are all characters identical with all key combos even "fn" (The font is listed as part of a default install on both OSX and Windows) I know this is not exactly FM specific but is in relation to the deployment within a FM DB. best Stuart

• 0 replies
• 937 views

Stuart Taylor

February 20, 200719 yr

Okay, I am very new to working with FileMaker but I need some help as I have been charged with creating a database in 4 days. Argh! In my database, I am managing incoming students into a summer school session with a number of different classes. Each student gets three choices of what they would like. I set up a value list with the class choices and used the same value list for my firstchoice, secondchoice, and thirdchoice fields. If I want to search by, say, Algebra...how would I bring up all that have that choice somewhere in their record? Whether they had it for their first, second, or third choice, I would like it to come up on the same report. Is that…

• 1 reply
• 760 views

mr_vodka

February 19, 200719 yr

Hello, This is my first post on here. Great forum design! I have a situation where I want to have a table that contains "Quotes" (sales quotes) and want to be able to move that data to an identical layout (just different field names) "Invoices" with the click of a button (script I would assume). The data on the Quotes and Invoices are both in an identical portal minus where they display info from, etc.. Not sure if I'm giving enough info, but would really appreciate a tip or two on how this can be accomplished. Thank you Dave

• 2 replies
• 820 views

videopuppy

February 19, 200719 yr

We have a database of donors. We need to send them letters of various sorts and want to use an electronic signature so we don't have to sign every letter. We have various letters, each in its own layout. Each layout has merge fields, text (the body of the letter), and a place for the signature. I have succeeded in inserting the signature onto the layout but because each letter in a given found set has a different number of lines of merged data, etc, the signature is sometimes in the correct place, sometimes too high, sometimes too low. Is there a way to make the signature stay in place depending on where the text immediately above and below it appear on the pag…

• 1 reply
• 930 views

Lycanthrope

February 19, 200719 yr

Hi I have created 12 records in my database but when I am in browse mode I cannot see them. I can find them in find mode on the left it says there are 12 records, just can't see them. Any help appreciated. Trevor

• 5 replies
• 914 views

Rehoboth

February 19, 200719 yr

While the user manual is a little thin on this subject, other info says that I can set a tab order to include a button on the layout. I have followd the instructions, selected "objects" and numbered the fields so the next tab numbered after the last field is a button. Problem is , it won't go to the button, it just skips back to the first field in an endless loop. I tried removing all tabs and starting over rather than renumbering and deleting existing tabs but it doesn't make any difference so I am stumped. Anyone have this problem besides me.

• 2 replies
• 822 views

Racer Bob

February 19, 200719 yr

Does anyone know if there is any way that you can tab to a button and use the "Enter" key to activate the button. Just like when you log in here....you enter your user name and password then you can tab to the "login" button and hit "Enter"

• 6 replies
• 1.6k views

Racer Bob

February 19, 200719 yr

Hi Everyone i just joined this forum and to say i am excited about it is an understatement, i think i may have fallen in love with filemaker, i tried Access for a while but...well you probably all know the next sentence, anyway, i have a question and remember i am a total Newbie at filemaker, my question is how do i get icons and buttons into filemaker, i am designing a frontend for someone and would like to make it aesthetically pleasing, hiope someone can help, i am using FM pro 7 but maybe switching upto 8.5 Michael

• 2 replies
• 845 views

djemboy2

February 18, 200719 yr

Hi, I wrote an AP Application that did not address read-only access - I now need to allow a user the ability to search certain tables for a given record (an invoice or check record) and if found allow them to look at it and print it (an option);I currently have a different sub-system that is handling these read only requests - once the user enters the find key and the find is valid the script goes into "PREVIEW MODE" and calls a new layout - with in this layout I have two buttons - one calling a script to return to the previous screen and one to print it. The BUTTONS are not working - I'm thinking it has to do with being in PREVIEW Mode? My goal is to allow access t…

• 3 replies
• 1k views

Lee Smith

February 17, 200719 yr

I have three records that contain a phone name and a phone number, and they are all related by a store number. For example, the records contain: Store Number - Phone Name - Phone Number C0001 - Store - 404-555-1212 C0001 - Truck - 404-555-1213 C0001 - Office - 404-555-1214 I need to create a text field that I will use to create a label to place on the back of each phone (they are cell phones), where each label will have the phone number of itself followed by the two other phones. So, the label for the Store phone would look like this: Store 404-555-1212 (with Store in bold type) Truck 404-555-1213 Office 404-555-1214 And the la…

• 1 reply
• 970 views

comment

February 17, 200719 yr

Here’s what I have: a text field on a layout and a portal of related values (names of people) along side the text field. Here’s what needs to happen: when I click a name in the portal a value from that related record is inserted into the text field wherever the cursor was located prior to clicking the name. Here’s what’s happening: using the Insert Calculated Result script, regardless of which name I select in the portal or where the cursor is located in the text field, the first name in the portal is always placed at the end of the text. With Filemaker I knows there’s a way. I’m just hoping it’s not to complicated. Thanks for your help. It is really apprec…

• 2 replies
• 1k views

Norvin

February 16, 200719 yr

The new Web Viewer looks pretty nice and I can see some useful applications for it. However, what do you do when you encounter pages that use the POST method such as Filemaker's own store? http://store.filemaker.com/ In the left column there is a field where you can enter your Order Number and track your order's status. The form appears to use the POST method which does not embed parameters in the URL. How could you incorporate a Web Viewer to track the status of an order from from Filemaker's website?

• 11 replies
• 3.7k views

murtje

February 16, 200719 yr

The popup menus that I created on a Mac, and now host on Server 8 (also on a Mac), behave strangely on a Windows 8.5 client. When I click on a popup menu and select an item, the whole field disappears. Works fine if on a Mac FM 8.5 client. Any suggestions? I've tried resizing the field box to no avail. Thanks, Jason

• 0 replies
• 904 views

Jason Goldsmith

February 16, 200719 yr

Is there a way to make portals automatically resize based on the number of records found in a given search? Along those same lines, is there a way to make a report automatically move a portal to a new page when it hits a page break? Thanks.

• 4 replies
• 1.2k views

Genx

February 15, 200719 yr

Hello, when i make a report in "table view" i cant modify it the way i want, i mean, change the names, add new buttons, things like that, is there a way i can do it? thanks!

• 1 reply
• 777 views

Lee Smith

February 15, 200719 yr

Okay I have three portals on one page that have the potential for MANY rows. Certain scripts I run on this page will freeze the window and jump to another layout temporarily to do some stuff and then jump back to the original layout. Unfortunately when this happens, the portals all go back to the top. I would love a way to force my portals to scroll back to the last active record. I already coded something to grab the portal rows from each portal and store them in a global so they can be returned to. The "Go to Portal Row" script step will select the appropriate row but it won't scroll down to it! Any ideas on how this can be done? Thx, Dan

• 2 replies
• 1.2k views

dbrowdy

February 15, 200719 yr

hello - I s there a plug-in or any way to automate the publication of web pages using filemaker?I would like to be able to export my records and their layouts as HTML pages. Is this any way possible. Thanks Very much in advance Dave

• 4 replies
• 1.1k views

comment

February 15, 200719 yr

Hi, I have the following design doubt. I am thinking of creating an interface with a: - Left panel with menu selection (Companies, Contacts, Quotes, etc.) - Central panel with record by record view in a tabbed design - Right panel with a list view of all selected records. For instance, if a user selects Companies in the left menu: - the central panel would show one Company record, and would allow the user to navigate from record to record. - the left panel would show an Excel like list of all companies, allowing the user to jump from record 3 to, lets say, record 18 (assuming both records are present and visible in the right table). Can you …

• 1 reply
• 1.1k views

bluearrow

February 15, 200719 yr

Hi I want to create 12 tabs on a file for 12 months. I want exactly the same fields in each but obviously being able to enter different values. Is there a way of setting this up so that you don't have to create everything from scratch 12 times? Thanks Trevor

• 4 replies
• 1.5k views

Rehoboth

February 15, 200719 yr

My apologies if this has already been asked, but I couldn't find it anywhere in my documentation or on the forum. Is there a way to format a regular field (a pop-up menu, FYI) as a rounded square? I have it on a layout with a bunch of other buttons and I want it to look uniform. Alternately, is there a way to format a button as a drop down list? I can script each entry, but wasn't sure if this was even possible. Any help would be greatly appreciated.

• 2 replies
• 833 views

Inky Phil

February 15, 200719 yr

I'm working on a computer inventory database for the school I work at. Part of this inventory records the hardware addresses (MAC addresses) for each computer. I also receive the blocked page notifications from our firewall and I try to monitor their screen in Remote Desktop. However, the firewall likes to send the notifications with the hardware addresses formatted like this 00.03.93.xx.xx.xx, while our inventory (like everyone else's in the world) has them formatted like 00:03:93:xx:xx:xx. Is there a way to have a script reformat the hardware address from the version with the periods to the version with colons? It would make the lookup process a little quicker with…

• 7 replies
• 1.4k views

mr_vodka

February 14, 200719 yr

I've searched everywhere... I've just upgraded from v6 to v8.5, and have combined 4 DBs into one with 4 tables. Can I import the layouts (on which I have spent many hours) as well as the data?

• 2 replies
• 6.1k views

Hug B

February 14, 200719 yr

Hello, i have just changed a layout from repeating fields to a join table with a portal, all works well as you can see by the demo.it adds the line items up. or advise me if there is a better way. but i want to "sum" the total of all records, i have tried calc fields summarys but nothing works for me, and i cannot work it out. can some one please take a look and tell me where i am going wrong thank you. Robert expenses.fp7.zip

• 5 replies
• 1.7k views

RT

February 14, 200719 yr

As shown on my attachment, I use the 'Sub Summary'(probably incorrectly) to contain the field 'Room' so that each renovation task for a particular room, is listed in that room...to be followed by the next room and its tasks. Question - how can I adjust the task's numbering system to reset to '1' each time a new 'Room'and its tasks are printed. Walter

• 4 replies
• 1.2k views

wh8342

February 14, 200719 yr

Using 8.5 I'm trying to create a simple invoice layout using a database with only x2 tables: Order Placed & Order Item(as supplied by a 3rd party)related by Order ID. I've created the layout to show from the Order Item table and set it up with Title Header, Header, Body, Footer & Title Footer and included sample text in all layout parts to test the results. But when viewing the results in Preview Mode I don't get anything showing in both the Header & Footer. Can anyone advise?

• 0 replies
• 819 views

Carl Smith

February 14, 200719 yr

Hi everyone - I'm busy transfering an order system onto filemaker from excel. I need to add a table (not in the FM sense of the word - a regular table as you would insert in word or use in excel) to my layout. Is this possible? thanks!! :)

• 4 replies
• 1k views

mz123

February 14, 200719 yr

Hi - I don't know if you can do this. I am building a database, and i have created 3 layouts within it. When we use it at work, we will need to save both 'order' layout and the 'delivery note' layout as one pdf (with each layout a separate page on the same pdf). i can't find a way to do this.. I assume i can do it in scriptmaker? Any help greatly appreciated -) Rach.

• 2 replies
• 911 views

racht

February 14, 200719 yr

I'm sure I'm missing something basic. I have this exact set-up in one file that is working perfectly but, for some reason, am having problems in another. I have a field in a portal row which is defined as a button (basically go to related for further detail). For some reason, the button won't click. I thought it had to be something with the layout layers but even when I have brought the field in question to the front, I still can't click. If I take the field/button out of the portal, it works fine (other than the fact that it's not in the portal so I can only ever access the first record, of course). What am I missing?

• 1 reply
• 970 views

consultgal

February 14, 200719 yr

I want a value list to display one value and enter another. Is this possible? I've set up a value list that pulls a Title from one field and then an ID# from a second and diplays them on a single row, like this: Title1 #1234 Title2 #5678 Title3 #2345 Searching by title is the only way to go, as the number of items in the list is 500-600. But I need to enter the ID# and not the title. It's easy enough to create another value list with the ID# as primary and the Title as secondary field, and then change the sorting order so that the list is still sorted by Title, but it's not only ugly it also renders the keyboard search useless (so you'd have to scr…

• 4 replies
• 1k views

kellerman

February 14, 200719 yr

Hi, I need help on my DB, I have two portal ( first his Projet and second his Phase). I want to select (on one click) a row in the first portal and have apear the related record in the second. Can you help me on this....I came from ''access'' and I'm new too Filemaker and I realy love it! I'hope it's write correctly because I'am not bilingual...sorry.

• 5 replies
• 1.1k views

SteeRod

February 14, 200719 yr

I am new to these forums and I have a problem. I have created a database where i have the name of a company and a relationship to partners in a portal. Each partner has a different role, example 1 or 2 may be Grantor, 1 or 2+ may be Trustee / Co-Trustee and 1 or 2+ may be Beneficiary. So what I need to do is be able to print lets say the Grantor in one part of the letter, the Trustee in a different part of that letter, and the Beneficiaries in another part of the same letter. I have been searching the web for about a week on how to do something like this and have been unsuccessfull. Please any help will be much appreciated. Thanks in advance!

• 8 replies
• 1.1k views

Titan3

February 13, 200719 yr

I am trying to have Customers names be automaticly entered when I go from the customer info layout, to lets say, a Customer Change order layout. I would like to enter the information in the Customer Info. field, and then when I go to the next layout, the Customer name field is automaticly filled in with what I put in the Customer Info field. If I make the Customer name field global, in the Customer Info layout it seems to work, but when I select a new record, the old info is still displayed.......any ideas.............

• 1 reply
• 831 views

mr_vodka

February 13, 200719 yr

Hope someone can help me out with this. I have made a score field in my DB (edit box / number). I want to be able to fill in a score like 50% or 100%. The percentages correspond with the status of a project. I would like to link the percentages to a layout. For example if a score is filled in of 50% the project status I would be in Phase 2 and I would like it to show the phase 2 layout. Have no idea how I would be able to do this. Through a calculation perhaps? Dutchy

• 1 reply
• 854 views

mr_vodka

February 13, 200719 yr

Hi I having trouble constraining portal. I have field which I have yes/no and I wont the portal to just show the list of related yes Does any one have some ideas here? I set up scripts before to sort and filer layouts with tables but not with portal Cheers Damian

• 6 replies
• 1.8k views

Hack

February 13, 200719 yr

One of my files (and various derivative copies of it) are intermittently not showing up in the Window manu. I'm well aware that hidden files are behind the "Show Window>" menu item, and these aren't there either. Anyone else seen this? A sign of corruption, possibly? (God, I hope not.) Or is there some non-bug non-corruption reason this would happen? It occurs no matter whether the window in question or another window has the focus. If I spawn a new window from one of the files with the problem, the new window inherits the disease. This doesn't happen all the time. When I first open these files they show in the menu as normal. Then at some point…

• 0 replies
• 788 views

mscholtz

February 13, 200719 yr

I just upgraded to FM 8.5. I want to know which tab (1 -4) is in front. How can this be done.

• 5 replies
• 1.8k views

1Adam12

February 13, 200719 yr

I'm having a problem with one of my layouts. I am pulling fields from two joined databases. The information from the fields in the one database show on the screen correctly, but the information from the other database only show when the field is clicked on and then disappear again. What am I doing wrong? Thanks for your help. It's a columnar layout.

• 1 reply
• 958 views

Brian C

February 12, 200719 yr

I have3 a match field that I would like user's to type in a Puchase Order # so they can filter to a specific order when we receive a product from a vendor. I'm familiar with the High/Low filter when it comes to names gMatch_Name = Col... (User input) High_Name = Colzzz (Calc Field) Low_Name = Colaaa (Calc Field) How do you do it with numbers? Would it be: Note(PO# are 6 digits) gMatch = 134... High = 134999 Low = 134000 What happens if they type four numbers? gMatch = 1347.. High = 1347999 Low = 1347000 This then exceeds the character number, will this cause my high/low filter to not see the extra character? Do I ne…

• 6 replies
• 1k views

Mike J

February 12, 200719 yr

I have a layout that is used to select records to put in a match table (attendance) that links two other tables (students and courses). It accomplishes this very well using two portals. One on the left that shows all students, and one on the right that show the related (attending) students only for a given course. In between the portals are buttons with scripts that allow you to directly add or remove records from the right portal by selecting a name from the left to add, or selecting a name from the right to delete. While this setup works fine with a perfect user, if someone clicks on the portal on the "all students" list and then clicks on the button to remove (w…

• 5 replies
• 1.5k views

TimmyT

February 12, 200719 yr

Hello, very new to filemaker actually just got 30 trial version today i cannot figure out how to create the drop down boxes i can set the edit box to read drop down with scroll bar but cannot proceed to enter any options in the box .help please jacky

• 4 replies
• 1k views

bmen

February 12, 200719 yr

I searched and hadnt found this issue. Has anyone found a way to use the Google Maps and return just the graphci map portiona nd not the space above the map where you input more info. I want to conserve screen relestate and this space is just a waste to me. Perhaps there's another map program out there that is better suited? Also - the default view of the Google map is the street view, is there a way for it to go straight to the Hybird (combo street and satelite view).

• 8 replies
• 1.8k views

Genx

February 12, 200719 yr

I have a table 'a' containing a 'total' field summaryzing several related records. Sometimes I need the sum of the 'total' fields from a long quantity of records from the 'a' table. I save this into a 's.total' calculation field using the GetSummary function. When in browse mode I go into the layout containing 's.total' it takes a long time to get the calculation. I just need to have the calculation sometimes, so in order to accelerate it I would like to script a button that shows or hides the field containing 's.total' into one layout. I know I could use two identical layouts (except 's.total') and switch from one to another, but I would prefer some…

• 2 replies
• 954 views

naio

February 12, 200719 yr

I wondered if there is any way to script the change of the color of a box or circle in a layout through a script. Thanks

• 3 replies
• 1k views

xoomaster

February 12, 200719 yr

Hi Everyone, I have strruggled with this for years but now I am trying to take my FileMaker Skills to a different layer and I have to avoid being embarssed and just ask the question! Is there as technique that I can use to produce what I can only call multi-page documents that are created dynamically? My example is this....I also use QuickBooks at work. In QuickBooks when I am filling out an invoice that invoice can be as many lines as I want it to be and I will just get XX number of pages to the invoice when I go to print it. At no point does the program ever tell me that I ahve entered too much inforamtion to fit on one page (I.E. layout). I have de…

• 4 replies
• 1.3k views

comment

February 11, 200719 yr

Does anyone know of where to get some good background images and UI icons for application development? Roger

• 0 replies
• 1k views

MintonMagic

February 11, 200719 yr

Just wondering if anyone here knows how to resize the charting add on Filemaker released. I got it working fine but i would like it to be smaller. Just wondering if its possible with the charting example they released. Didnt find anything here about resizing flash. Help would be mucho appreciated

• 0 replies
• 1.1k views

cknight

February 11, 200719 yr

I hope I can make this make sense... I want to track all the different expenses related to the improvement of a product. Specifically I want to track all of the repairs done on a product among the many other types of expenses. I have one layout with the product info and calculations. I want to put another layout on top of that with just the entry for a single repair. I would like to be able to have several records of repairs linked to only one record for the product. Also, I would like all the repairs on the repair layout that are related only to this product add up and form a total calculation on the product layout. Any help would be great. Let me …

• 1 reply
• 887 views

jamesducker

February 11, 200719 yr

I have a db on server 8 adv and have IWP turned on and I can not see the web viewer in my browser. if I have the same db locally and view the db via iwp in my browser it works. Any ideas why i can not see the web viewer via IWP when my db is hosted off of server? I am baffled.

• 4 replies
• 1.9k views

Buzzeo

February 10, 200719 yr

I've read a couple of threads that might relate to this question but the solutions seem rather complicated. I have a very simple (and flat) database listing some fabrics. I have a checkbox field where I check who has chosen a given fabric. At the end of the day, I'd like Filemaker to give me a total of how many accounts have chosen each fabric. Is there any way (without completely redesigning the database) to have Filemaker simply count the number of "checks" for each fabric and return the total in a field? When I tried a calculation using the Count function, it would only return "1" for each fabric regardless of how many boxes were checked for that fabric. Thank you. …

• 11 replies
• 3.6k views

comment

February 10, 200719 yr

Hi All, Hopefully this will be a simple question. I want to make it so that when someone clicks on an e-mail (in the layout, or web browser)address it opens up the mail client and fills the address portion of the e-mail. (Just like like the html "mailto" command) Any suggestions?

• 3 replies
• 1.6k views

Genx

February 10, 200719 yr

I have set up a web viewer page that does a Google search on my contact name. I then look for pertinent info on my contact. Some times I have to go several pages deep. After I go 2 or 3 pages deep if I click on a link to another website I get the "Buffer Overrun" error message and FM crashes. I am concerned that this will eventually corrupt the entire database. Is this a bug in 8.5? Is there some way to increase the buffer size. Please help! Al

• 4 replies
• 1.4k views

aldipalo

February 10, 200719 yr

Good morning, everyone, After working all day on my database I have come to several conclusions. First off, I appreciate the help that everyone offers on this site. Without it I think I would be totally lost. I come from using Lotus Approach. Which is still the database that I use most often. The main reason I try to use Filemaker is if I want to distribute my finished product. Something that Approach sadly doesn't support. No runtime version. I read many nice articles about FileMaker and it's ease of use. Well, here's what I find. In most everyday situations I find it to be on an ease of use par with Approach. What really annoys me is the simple things are made SO d…

• 4 replies
• 1.4k views

Genx

February 9, 200719 yr

Hi, everyone, I'm trying to make up a database of my record collection. I hav the fields YEAR, LABEL, TITLE and ARTIST. I can get my conditional value list to work so that when I click on LABEL it brings up the lables for the YEAR that I selected. My question is, how can I get the TITLE to show only the titles for the label and year previously selected and then have the ARTIST field display only the artists for that TITLE, LABEL and YEAR? I would really appreciate any help with this.

• 4 replies
• 1.7k views

REGGIE MAGER

February 9, 200719 yr

Has anyone seen this, the headers are in my table view are massive (see attached) If so how can I adjust this?

• 2 replies
• 1.1k views

Raybaudi

February 9, 200719 yr

I have noticed this question posed a couple of times but have either not seen an answer or (maybe) have just been too dim to understand it. If setting up a web viewer url to my local machine I can either: "file:/C:Directoryfile" or "file:///C:/Directory/file" If setting this web viewer url to a server on my network I..... Have no idea what to do. Every filewin, file, include or not the IP address, forward or backward slashed variation has failed me. Just a pdf file on a server...should be simple. Yes?

• 9 replies
• 2k views

pahtooco

February 9, 200719 yr

Good day too all, I have a question with a portal refresh issue I have run into. I am using two DataBases(DB), one as a calendar, another as my LeadManagement table. What I am trying to accomplish is to display records from the LeadMgnt DB on the Calendar for any given day, through a portal. Because I don't have a different database for Appointments, the LeadMgnt file has appointment dates in it, and these records are of families, so multiple people from one family can show up on one date, annoying! That problem is fixed with a custom function, but the issue now is Portal Refreshing. When I move to a different date, the portal stays at the date I started w…

• 4 replies
• 8.9k views

dbrowdy

February 8, 200719 yr

I have a form I am creating, so space counts. I have portal linked to equipment serial numbers, and it works fine, but there is not enough room to display it vertically. I would like to be able to use something similar to bieng able to print in more then one column, but on only part of the lay out. Is this possible?

• 2 replies
• 2.5k views

Lee Smith

February 8, 200719 yr

Is there any way to get the web veiwer to pick wich browser you want to use? IE7 or Firefox?

• 3 replies
• 1.4k views

mberding

February 8, 200719 yr

I have two separate files. One is a Sales Order.fp7 containg records holding my sales data. The second file is an Inventory.fp7 containing my product inventory. My inventory is setup so that each item has a category. For example, Main Category --> Fruit, Item --> Apple. I have setup on my Sales Order screen the ability to choose the Main Category using a dropdown list. I now want to filter the choices based on the Main Category selection. Is this possible across two seperate files, or do both tables need to be in one file? Thanks!

• 1 reply
• 1.6k views

Genx

February 8, 200719 yr

I am new to Filemaker(though I have been using Access for many years), so this is a very newbie question. I have just created a portal from a one-to-many relationship in our volunteer database. I created a layout based upon the "many" table that I call the "data entry" screen, where volunteers can enter information into the table that will then appear in the portal. However, the information is not appearing in the portal. If I enter the data directly into the portal, it shows up in the portal, and it shows up in the data entry layout table. But if I enter it via the data entry layout table, it doesn't show up in the portal. I'm sure it's something re…

• 7 replies
• 1.3k views

Genx

February 8, 200719 yr

I've created a form letter in FM pro advanced 8, all the content is as I'd like it with merge fields, text and logos, but when I go to print a sample letter, the margins are all wrong for a business letter. Does anyone know how to fix this so that it looks like a formal letter? Thanks so much, Jake

• 3 replies
• 1.4k views

Ender

February 7, 200719 yr

I am trying to remove the text that is displayed from a checkbox field that is displaying a Value List. I tried just changing the text color to match the background but it is on a portal with alternating colors....

• 4 replies
• 1.5k views

Joel Saltzman

February 7, 200719 yr

I've been developing a solution for a couple weeks now after taking a hard look back at the philosophy of FMP. After some very constructive critism, reading, re-reading and testing I've made an almost functional multi-user database. I have a question on an inconsistancy I've found in the FMP User books published by FMP 7: Lane, Bowers, Love, Moyer FMP 8: Lane, Bowers, Love After reviewing the section "New Record Only" relationships in Working with Portals I've found a relationship problem that I can't see to figure out which is correct or if it doesn't matter if your working with FMP 8-8.5. FMP 7 states (pg452) primeID_neighborhood-----[foreignID_…

• 0 replies
• 1.3k views

Mike J

February 7, 200719 yr

Hello, I have 6 different tables a;b;c;d;e;f...and each table has a field named source code. Is there a way to combine all the source codes from each table into one value list?? Thanks, Tom

• 2 replies
• 890 views

tommypmadison

February 7, 200719 yr

I'm confused. I have two related databases, one that holds information (demographics) and another that most displays the data through multiple portals. I want the users to be able to scroll the portal and the larger text field within (student_information). The issue I've run into is that on some layouts users are allowed to edit the student_information field - no problem with the scroll bar working fine. The issue is I need to lock entry of that field on some layouts, but still allow scrolling. If I sent the behavior to enter only in edit mode the scroll is gone. I thought about changing permission on a field level, but the users need to be able to edit on in one por…

• 2 replies
• 1k views

ggh

February 7, 200719 yr

i am trying to think of how to allow a user to navigate < and > through the last say 5 layouts visited similar to a web browsers back and forward buttons, and ideas? so far im thinking of variables or some form of list.

• 3 replies
• 1.4k views

digitaljunkie

February 6, 200719 yr

Hi, I have searched but can’t find an answer to this exact question: I have a yes/no dropdown on my layout, is it possible to have a report printed if the user selects “yes”. I am attempting to do it via a “Case” calculation, but I am not getting too far…I think Im going about it wrong. Could someone please point me in the right direction once more J Thanks for your time. James

• 5 replies
• 910 views

Totes

February 6, 200719 yr