FileMaker Interface Features

Hi Guys, Is there a way that when a particular value is entered in a field, the entire row that the field is in will become hightlighted with a specified color? The idea is, we've made a call log and want the row of the unreturned call to become hightlighted when we select "Call back" in our "Call status" column. Also, I'm working in "Table View". Thanks

• 1 reply
• 912 views

Lee Smith

January 18, 200719 yr

Hi, I'm creating something akin to a ticketing system and I want to create a new 'status' record everytime I update the status of this ticket. So, the 'status' table contains the ticket ID, the date modified, and the text. How can I make a portal on my 'ticket' page that shows *all* the text I typed in for each update, and not just one line? I've followed examples for portals, and all I've seen are 'line items' where the data is only one line deep anyways, not a paragraph of data. Am I coming at this the right way?

• 5 replies
• 1.2k views

The Gardener

January 18, 200719 yr

Whenever I create a new record each file increments by 1. This shows how many companies I have. EG 1 2 3 But say that I delete number 2. How can I then create another company so that it automatically numbers this as 2 and not 4? Thanks in advance if someone can help.

• 3 replies
• 883 views

Lee Smith

January 17, 200719 yr

This is probably a simple question, but is there a way to hide a portal in a layout besides changing the text color, etc.? I want to use the portal info in a merge but do not need it displayed. thanks, MT

• 1 reply
• 977 views

mr_vodka

January 17, 200719 yr

i was wondering how one would go about inserting symbols into a field. This would be such as percentage and dollar signs. Like when i enter .002 into a field if it could show 2% or if i enter 5.35 it would show $5.35. Thanks, Jonny

• 1 reply
• 842 views

comment

January 17, 200719 yr

I would like to have a single field be able to display several different value lists based on context from another field without doing it relationally or changing layouts. Example: There are 2 fields. field#1 can have a value of a, b, or c. field #2 will then have a particular value list based on the value in field#1. In this example, there would be 3 different value lists, each corresponding to a, b, or c. Using a script, I can change the values displayed in field#2: If [table; field#1="a"] Insert Calculated Result [table:field#2; ValueListItems [file; "ValueListName a"] Set Field gives the same result as Insert Calaculated Result. Unfortunate…

• 2 replies
• 872 views

Steve E.

January 16, 200719 yr

Thanks in advance for reading my problem and providing your input, here we go: I have 2 test fields, Text field A and Text field B. Text field A, is set as Drop-down list and the "Include "Edit.." box is checked to allow users to add values. What I want to do is, when a value is selected or new value is added in Text field A, Text file B (which is also set up as a Drop-down list with Edit box checked) will only drop down a value list that is somehow pre-associated with the vale in Text field A and if there is none, it will just show a blank field allowing uses to Edit and add new value. Eg: User chooses "Seasons" in Text field A, in Text field B, only Summer, Wi…

• 0 replies
• 1k views

diehardfan

January 16, 200719 yr

I would like to create something like the following: Calibration 123456 The above text needs to have button attributes so that when clicked it opens an associated PDF document. I tried using the open file option in the button script menu but this tries to open a FM file.

• 7 replies
• 1.1k views

Genx

January 16, 200719 yr

I am creating a database to track scientific instrumentation. Many items require a yearly calibration and it is important to keep records of previous years results. I wish to place the cal sheets as individual PDF's in container fields. Do I have to create multiple containers manually and then populate with files or is there a technique to do this automatically ?. This idea will be used for equipment photographs as well. I guess another way would be to create a scrolling text box that has each line as a link to an image, PDF etc. However I have not seen any facility for adding this type of format to text.

• 4 replies
• 1.1k views

The_Crofter

January 16, 200719 yr

does anyone have a solution to the problem of looping audio never stopping from web viewer windows. after browsing 10 records i have 5 audio loops still playing.

• 0 replies
• 975 views

Tim Rosencrans

January 16, 200719 yr

Hello, I have a layout which I would like to "auto sort". In other words, whenever the layout is viewed the contents are sorted by date. I know I could achieve this using a scripted button, but I would prefer it if whenever this layout is viewd that the contents will sort automatically. Is this possible, or should I use a portal to acheive this result. Many thanks

• 7 replies
• 1.6k views

fingers

January 15, 200719 yr

I'm a newbie to FMP, and currently am doing a trial to see if I can get away from the problems I ahve with MS access. I have an application that is somewhat inverted: The normal view is the summary, but I want to click on things to get more detail. I've built a database for orienteering. An orienteering control is a marker attached to tree or fence post in the field. Each marker has a bunch of data associated with it, GPS coordinates, local description, maintenance history, who placed it, when it was last checked, used in a meet, found in a meet. This is the top level. The second level are clues. These are what the participants are given to find the m…

• 1 reply
• 1.3k views

Fenton

January 15, 200719 yr

Is there a way for me to center my layout and still stay within the printing margins? I've accepted the fact that I need to stay within the 8 x 11 boundaries for printing purposes, but it sure drives me crazy when working in the database and my database is shoved to the left while I have a huge margin of empty area to the right of the center. I would like for it to be dead center in the middle of the screen. Thanks for your help.

• • 
• 8 replies
• 7.7k views

JCJXXL

January 14, 200719 yr

When creating new layouts the default font size is 10. How can I change it to 14 or create a layout template that will show up in the layout templates choice at the end of the process? Near sighted. Thanks in advance.

• 1 reply
• 836 views

Genx

January 14, 200719 yr

Is there a method of executing a script for printing labels from a layout served via the IWP? Printing direct is out because it's essentially a web page, but a script? Is this possible? Using Server 8 to distribute info throughout a company using web browsers, but the warehouse needs to print labels of parts (both sheet and Zebra printers). Any ideas?

• 2 replies
• 850 views

T-Square

January 14, 200719 yr

I'm still a newbie to FMP and am struggling with the page breaks. I work on a 19" wide screen set to 1440 x 900. So of course I have designed our database interface to take advantage of the extra screen space. The problem is my interface does not fall within the 8 x 11 page FMP has given me to work with. So when I print, instead of it being on one page, it is split between two pages. I have searched the forums, gone through the FMP men options and just can't seem to find a setting to change the page breaks. Any suggestions? Thanks in advance!

• 14 replies
• 1.9k views

Genx

January 14, 200719 yr

Hello, Here is what I am sure is another simple newbie question, but I just cant figure it out. I have a layout with a date field and about 25 fields each one containing a number. EX: Date: 01/13/2007 Field 1: 2 Field 2: 55 Field 3: 8 Etc. When a new record is created the date field is automatically entered. So now I have a date field and 25 fields containing numbers. What I am attempting to do (without success) is to be able to run total for each field for a certain date range. I may need to run a report for 11/01/2006 to 01/11/2007 for example and I need to see the totals for each of the 25 number fields for that date r…

• 4 replies
• 1.3k views

comment

January 14, 200719 yr

Hello In my database I have created a couple of different layouts that will print contracts for my customers and contractors. I would like to be able to auto enter the current date on these contracts but have not been able to find a way to successfully do it. Any ideas Cheers M

• 1 reply
• 830 views

Stuart Taylor

January 13, 200719 yr

Is there a Tabbed Navigation How-To for FM-8? I searched this site and could not fine an answer. I followed the example in "Using FileMaker 8 Special Edition" (page 360-361) but couldn't get it to work. Thanks, Bob...

• 8 replies
• 1.5k views

Brudderman

January 12, 200719 yr

I have layoutA for tableA related to tableB with a cartesian (by their respective uniq id's). On layoutA I have a field set up to display a dropdown using a value list. The value list is supposed to come from a field called AcountName in tableB. In tableB, these Account records have a SortOrder field, each with a unique character. In the relationship, I have tableB set to sort by that SortOrder field, but when I use the dropdown on LayoutA, the AccountName items do not appear in the sorted order. What am I doing wrong? Now I know I can pull the SortOrder field into the valuelist as well and tell the value list to sort by that field, but that disa…

• 0 replies
• 962 views

aharown07

January 12, 200719 yr

Hi Guys I'm having a problem which I suspect is very simple to sort out. I normally use FM on a Mac, where I can easily select multiple items in a value list at the same time by using the Apple / Cmd key, then hit return to add all of those items to my choice. However, I don't appear to be able to do the same thing on a PC. This may be because I'm attempting to do it using Virtual PC running Windows XP rather than a seperate machine, but maybe someone can help? I've worked out that (on my Mac via VPC at least) I need to use Shift and Ctrl together to select multiple items, but when I select an item then try to select an item below it in the list, it de…

• 4 replies
• 1.6k views

comment

January 12, 200719 yr

In trying to use a single-row scrollable portal to display large blocks of text, I've encountered a couple of strange behaviors that I haven't been able to figure out. Basically, the text within the portal is affecting areas of the layout outside of the portal (behaviors are described in detail in the example file). Before I abandon this approach, does anyone know of any "rules" to apply for such extended uses? Or am I completely off of the pavement in trying to use portals this way? Thanks for any help. TextOverflow.fp7.ZIP

• 5 replies
• 1.6k views

K1200

January 12, 200719 yr

I need to remove value list enty based on a field value. For istance, I have two fields, one is text field that contains a value from the value list, and other is a calc field counting the occurences of the text field entry. When the calc field hits 10 I want to remove the value of the text field from the value list. Any ideas? Thanks, r

• 0 replies
• 962 views

ricardito

January 12, 200719 yr

Does anyone know how I can get this effect(highlighted on "invoice")? The Invoice Pic is just some generic pic found on the web. The Preveiew is what my form looks like. I have the description field set to slide as needed and works quite well I just think the seperators make it look more professional. The description can be 1 to 20 or more lines of text. My company makes unique parts and each requires a little different wording. Sometimes there is only 1 line item, sometimes as many as 20. Would like the form to have line seperator to always fit full page dimensions. I could not find any other post like this so I hope someone can help. Thanks in advance Invo…

• 7 replies
• 1.3k views

abomb

January 11, 200719 yr

I have downloaded an 8.5 trial and a few Web Viewer examples and so far I'm pretty disappointed. None of the examples I have been toying with will display a PDF, local or otherwise, stored as a reference or file. The only thing that happens is that the first time I import a PDF and FM tries to display it in the Web Viewer, I get a dialog box asking me to open something. What I am supposed to be looking for, I have no idea — files are grayed, browser apps are grayed, and Acrobat is selectable but nothing happens when selected. I am totally confused by this. The reason for this post is this: I have developed an in-house workflow for our Production and Creative processe…

• 8 replies
• 2k views

chrisk1

January 11, 200719 yr

Page margins for A4 In layout mode FM shows the page for A4 205 X 270mm but every printer has sizes for A4 210X297mm. This makes the document to be printed in less area of the paper. I tried to fix page margins of the layout printing but the mistake is regard to the dimensions of the paper not of the page. I suppose that FM takes the dimensions of the paper the printer gives not its dimensions. Any help please... Pascal

• 2 replies
• 1.1k views

edudna

January 11, 200719 yr

I was wondering if it was possible to create a column within a list view. So i could print pages that have same information running down the page twice. Thanks, jonny

• 1 reply
• 851 views

Mikhail Edoshin

January 11, 200719 yr

I don't know if I'm pushing the capabilities of FileMaker but it appears so. Is there a limit the number of layouts you can create? I'm trying to simply copy and paste components in different layouts and the spinning beachball is spinning for a good 30 seconds each time (sometimes longer). I've tried cranking the memory allotment way up (256MB). Performance is only slightly better in 8.5 vs. 8.0 I have a ton of relationships and over 170 layouts. I just tried to copy a simple box, nothing more, and the beachball just sits there spinning away. I checked the performance stats in Activity Viewer (Mac OS X) and it is showing a huge amount of processor activity. …

• 3 replies
• 958 views

Ender

January 11, 200719 yr

When working on developing layouts I gotten to wondering just how is the Display Data From list organized in the Field/Control Setup window? Sometime the list looks just as I have all the fields defined and organized in the custom order I have in Define database window but other times the list is all discombobulated. Does anyone know what criteria does FileMaker uses in organizing that list?

• 2 replies
• 765 views

Paradigm

January 11, 200719 yr

I want to be able to put text on a layout, and when I run my mouse over it (without holding it down) I want a little window to pop up with text info that I have entered. Like a balloon window with directory information. I don't know if this is possible in Filemaker but if it is, I want to do it. Can someone help me? If I haven't explained what I want well enough, please email me and I will try to be more explicit.

• 10 replies
• 1.6k views

Genx

January 10, 200719 yr

I think tabs are pretty nifty. My application already has a bazillion layouts and being able to parse the view from within a layout is outstanding. Until it comes to printing the document. Is there a way to disable the graphic or somehow otherwise make it disappear from the printed document. What I want to print out is the data within each tab, not the tab graphic itself. Any ideas? Thanks, Jarvis

• 4 replies
• 1.6k views

Lee Smith

January 10, 200719 yr

Good Day - I have a customer file, I want to view past invoices for each customer in a portal in the customer file. I want to look at the customers entire history so I need to portal into Invoicng 2007, Invoicing 2006, Invoicing 2005, etc. and show all past invoice history. What's the best way? Thanks in advance, Royce

• 2 replies
• 1k views

Royce

January 10, 200719 yr

I use FM Adv 8.0 to modify my app. The clients all have custom menus without access to any layout functions. Anyone know of a way to edit the "tool" menu which is only in Dev/Advanced so I can put some of the functions I need in it?

• 4 replies
• 1.8k views

Ender

January 10, 200719 yr

I am trying to convert my list views to tables to be more usable. Everything is working well except I used to have a button on each line to allow the user to just to a form view. Anyone have an idea how to display a button PER LINE in table view? I have one on the header, but my users are complaining they want the one on the line back. :

• 6 replies
• 1.3k views

Edward Newman

January 10, 200719 yr

New at this so please bear with me. I am designing a database for work and need to recall data into one layout from another. e.g. In Quotes Iayout I have: Room A, 4.5m length, 5.0m width, 3.0m height Room B, 7.2m length, 5.0m width, 3.6m height etc, etc. In Accounts layout I wish to recall all the relevant data just by typing in say Room A and having all the dimensions displayed automaticaly. Any guidance would be greatly appreciated Thanks Rax

• 1 reply
• 778 views

T-Square

January 9, 200719 yr

In your help files I have noted that " Can't place tab control in a portal". I want to place a portal on a tab control layout but can't achieve it. Have created a self join but still no luck. I would be much obliged if you can advise me if it can be done. Regards Hans vab Dorssen University of the Third Age Hawthorn Vic. Australia

• 1 reply
• 1.2k views

LaRetta

January 9, 200719 yr

If I remember correctly, there is no BACK button functionality in the Web Viewer right? Is there anyway to program one? Also, if not, what about being able to create a button that will refresh the original URL set for the web viewer on a given record? Thanks

• 6 replies
• 3.3k views

Bulletproof

January 9, 200719 yr

Hi everyone! Just a quick formatting question... I'm not sure if this is even possible. I have a pop-up list containing about 20 items. When the list pops up, it only shows around 10 items in the window -- the rest you must access with the scroll bar. Is there anyway to change the size of the actual pop-up list so it shows all the possible values? Any help would be much appreciated! :

• 2 replies
• 831 views

LaRetta

January 8, 200719 yr

We're rolling out 8.5 to our clients and have discovered that automated print scripts that worked in 8.0 no longer work in 8.5. Clients are using Zebra and Dymo printers. When comparing the two, preview of the label looks and prints fine in 8.0. In 8.5 it's totally hosed and won't print correct (FM is fairly close to previewing what will print). Has anyone else experienced this? How did you fix it?

• 0 replies
• 847 views

Rob P

January 8, 200719 yr

Hi, has anyone any idea how to get rid of the ugly borders around the webviewer on Windows? All I found out is that it has nothing to do with the border-settings in FileMaker. On Mac the webviewer integrates seamlessly into filemaker - which looks really cool. Any ideas? Regards, Horst

• 7 replies
• 2.4k views

Stuart Taylor

January 8, 200719 yr

Hi, I am not sure this is the right forum for this question. If not, please excuse me. Here is my question: is there any way to implement a drag and drop functionality in Filemaker? (not in the web version, just the plain client/server network version). What I would like is, having 2 or 3 portals, to be able to select, drag from one portal and drop to the other portal and in this way stablish a relationship between line X in portal 1 and line Y in portal 2. A drop down list in portal 2 with the values in portal 1 is not a viable solution (too many lines in portal 1, among other reasons). Thank you and regards

• 2 replies
• 1.6k views

bluearrow

January 8, 200719 yr

Hi How can i make a Field/text in a layout that always shows the number of found and total records. depending on the search the user are doing ?

• 2 replies
• 834 views

CobaltSky

January 8, 200719 yr

I was thinking that I could do this with a portal so I posted here. And I have not yet been able to do what I want. Which is to have a list of the found set appear on the screen without leaving Browse Mode. My Browse Mode screen is a record about a single plant, and I search using various criteria to create a list; and then want to click the list so I can see more info about the plant. I hope this isn't so confusing. I tried a portal based on a self relationship but this won't work. Am I trying to do something impossible? I also tried having a new window appear, with the found set in a list view, but was unsuccessful withat that as well. Michael

• 23 replies
• 4.8k views

msadesign

January 8, 200719 yr

Advice needed please. I want my cursor to go to a certain field when the layout it belongs to is opened. I thought there may of been some sort of on open section in scriptmaker to tie it to the layout but cannot find anything there. Thanks in advance h

• 8 replies
• 1.2k views

h123

January 7, 200719 yr

The FM charting example is great... But, I've found that you can't really use the graphs within a report which is kind of a pain. Is there some sort of work around here?

• 2 replies
• 1k views

Genx

January 7, 200719 yr

Can some layouts be set to print in portrait and others in landscape in a file. Or is it just only allow one.

• 1 reply
• 996 views

mr_vodka

January 7, 200719 yr

I have a DB that contains a field for Zip/Postal codes. I would like to click on the zip/postal code field and have the web viewer link to google maps and find me the map for the zip/postal code that I have clicked on. Is this possible ?

• 2 replies
• 1.4k views

Happy Hickey

January 7, 200719 yr

Hi, I am very new to this application and I am trying to have repeating regions for calculation part of the invoice. Thus, Hours, Labour Description, Unit Price and Amount. However, underneath I would like any unpaid invoices added. I have looked at other solutions, and they seem to use a Portal Setup, but I can not see where this information is coming from. I also would a time sheet for ongoing jobs, but again how can I just have repeating regions to enter data. Hope this makes sense. Grant

• 1 reply
• 1k views

Genx

January 5, 200719 yr

Quick question for all, I am trying to filter a portal in a somewhat difficult way and was hoping someone might have some advice. I have a Calendar DB and a Lead Management DB. I want to display booked appointments from the Lead Mgnt DB in the Calendar for everyone to see through a portal. The two DB's are linked through a type and date. Now the complicated part is the Lead DB is of people, separated my numbers and letters; ex: 25823.AB or 35813.AD, 35813.BD, 35813.CD, ect. The extension is to id whether this is a part of a group of people or solo. So I have the portal set up and it is now showing multiple booking lines for one family. If two people are i…

• 6 replies
• 1.5k views

Brett W

January 5, 200719 yr

How do I go about increasing the list of known fonts FileMaker recognizes on a particular machine? I have one computer that has all the fonts in its fonts folder that were used in creating the layouts in one of our systems. However, FM only lists 3 fonts it recognizes. Oddly, the layouts look fine as FM subs for one of the fonts it knows. The problem lies in printing. IF Fm doesn't have the font it prints meanignless garbled messes. Any ideas on how to add more fonts the the FM list? Thank you.

• 3 replies
• 1k views

Raybaudi

January 5, 200719 yr

Hi there, Does anyone know of a way to abort the closing of a file when the user closes the file's last open window? If they close their last open window accidentally, I want to provide an opportunity to cancel shutdown and restart the application. I have a Shutdown script that's performed automatically when Closing the file. Cancelling the Shutdown script (and performing a Restart script) is no problem, but the file continues closing once the Restart script is finished. Is there anyway to stop the file from closing? Thanks, Dave

• 2 replies
• 857 views

42n81

January 5, 200719 yr

I am trying to derive an exclusion list from related tables. Simply - I have 3 tables, Groups, Contacts and Joiner. There are many Groups. There are many Contact. One Contact can be in Many Groups and the group membership is stored in the Joiner table. Using different layouts with portals I can 1. Show a Group and in a portal all it's related Contacts and I can 2. Show a Contact and in a portal all the Groups it belongs to. What I want to do is show a Group and all the Contacts that do not belong to it. (Ultimately I want to create a script to add Contacts to groups that are not already members) I tried by putting a "not equal" sign in the rel…

• 8 replies
• 3.3k views

comment

January 4, 200719 yr

I'm creating a list layout from scratch. I want to show a checkbox that is checked if a field has a date entered and not checked if the field is empty. What's the best way to do this? (I'm a total FMP newbie, please have mercy!) TIA. Bill.

• 6 replies
• 1.2k views

Adrian Thompson

January 4, 200719 yr

What is the easist way to validate a field by makeing sure it is not in a value list. I have a field "Fruit" and need to make sure that the entered value is not in my value list "Forbidden Fruit" I tried to use validate by calculation, some thing like "Fruit" ≠ "Forbidden Fruit" but cant figure out how to use a value list in a calculation field.

• 2 replies
• 814 views

Tyra

January 4, 200719 yr

I downloaded a layout that I have used to create screens for data entry and I would like to create a columnar report format using the same layout. I tried making a report by duplicating the layout and making it viewable as a list but instead of consecutive rows of data on the one layout I get each record on an individual layout. Is there a way to import a layout into the layout themes that are available in the New/Layout Report option? What I want is a columnar report using the custom layout that lists consecutive rows of data and has a summary field on the bottom. ANy advice is greatly appreciated. Thanks.

• 0 replies
• 721 views

Brainiac58

January 3, 200719 yr

Simple database. Tables Customers Jobs Orders Staff I have two customers in this sample database. Related to the Jobs table with League ID. On the Jobs table, I want to select the "League Name" which is the Customer's Business Name for practical purposes. I set up a Value List based on fields, with a drop down box - selecting the League ID & League Name and enabled the "return second value only" which in my case is the League Name. When I select one of the League Names, it was returning League ID instead. And, in the Customer's table, it was editing the League Name to the League ID. Now, I can't even get the drop down box to show. …

• 6 replies
• 1.1k views

Agent Ska

January 3, 200719 yr

I know it's possible but I can't find it yet !! I looking for the option, maybe plugin, for a autocomplete (Microsoft description) on a field in V8.5 Adv.

• 4 replies
• 1.2k views

AVD128

January 3, 200719 yr

Hi, First off, this is for an IWP solution... Here's the problem. I have a user defined "Find" script in which the user is first taken to a layout to set the date range in a couple of Global fields. (Thank you to Stuart, Mr. Vodka and many others for that help!) Then the user advances to the next layout, the search criteria window. (this allows the setField to calc the date range and plug it into the date to search window.) After plugging in the rest of the search criteria the user clicks the "find" button and advances to the list view with the found record set. Everything is beautiful, BUT! If the user plugs in an invalid date such as 11/3…

• 28 replies
• 4.2k views

Søren Dyhr

January 3, 200719 yr

Hi, I am looking for a calculation which can create a value list from a found set or a relation, which I can use for a input of xmCHART. Example Record 1 Flied data = [12 ] Record 2 Flied data = [9 ] Record 3 Flied data = [17,8] Record 4 Flied data = [0 ] Calculation flied = [12 9 17,8 0] [color:red]I want to use it to draw a graph without triggering a script!

• 5 replies
• 1.7k views

AVD128

January 2, 200719 yr

I am working on a test application and have run into a snag. I have created the database in FM Pro 8.5 advanced. I have some basic fields and one Container for Quicktime movies and audio files. The Files are recorded through Quicktime Player, and then saved to the desktop. From there, I "right-click" the container and add the Quicktime file. The files are viewable and playable in the Filemaker Pro application without complication, BUT, when the database is shared using web sharing, I cannot view the multi-media content in the container. What am I doing wrong? Thanks in advance.

• 0 replies
• 989 views

Yaniv

January 2, 200719 yr

I'm trying to build my FM solution. I need to make it so when a new record is created I need to auto enter the next workday automaticly. If there is no previous work day, I need it to fall within a defined date range. I have a timesheet layout and a days layout and the days are viewed within a portal on the timesheet layout. Thanks.

• 2 replies
• 1.2k views

LaRetta

January 2, 200719 yr

Is it possible to remove the bottom bar and scroll bars from a popup window?

• 2 replies
• 1.2k views

Kevin Cheesman

January 2, 200719 yr

Hi, I am not quite a newbie, but have a pretty simple question for most of you here. I have revamped the FMP Business Productivity Solution to suit my business. I have been able to change ALL but one thing, and cannot figure it out. When in the sales orders section, I select an invoice, and click sales invoice, which runs a script to report the Sales Invoice, but on the sales invoice there is still a Generic place holder, at the top that says, "COMPANY NAME & LOGO", "Company Address - Phone - Fax - Email. I have searched all over for a place to edit this, I cannot go to Layout mode, as it is in the middle of a script, and the only place to go from here …

• 1 reply
• 958 views

K-OS

January 1, 200719 yr

Hi, I have a field for a person height, and I have attempted to convert a persons height from: 610 to 6'10" or 63 to 6'3" I can get the first sign for the feet (') but I cant get the inch sign (") to set properly it keeps adding the first number to the end. Can someone help, I have done a search but cannot find anything. Thanks

• 6 replies
• 1.3k views

The Shadow

January 1, 200719 yr

FMP V6.04 I like to create a button that by clicking it would copy 8 fields (all address details of a client) so I can paste it in to another document. I am not sure how to go about this. Do I need to write a script, and if so does anybody have a sample as I am not sure how to go about it. Alternatively I can think of creating a layout like an envelope and copy it from there. However I ma not sure ho to do this either so I do not have to leave the record in order to do this. In other words I would like a user to only have to click one button to perform the whole copy routine. Thanks for your help

• 10 replies
• 1.5k views

ChangeAgent

January 1, 200719 yr

I'am building a multi language solutions and having problems with building dynamic tabs. Is there a option to insert a code like <> ? (Tabel: P1 - Field: F07) What I don't want is to put a text field uppon a tab. The reason is want to able to suffle the tabs without to put the text manualy on the correct tab!

• 7 replies
• 4.2k views

Jukkie

January 1, 200719 yr

Is there a way to enable an input feild mask, so users dont have to enter the ':' in time.. 22:00, takes longer to enter 2200 would be easier -> transformed to 22:00 thanks

• 8 replies
• 2.1k views

theyetti

January 1, 200719 yr

I am using an email script to have FMP 6 send an email via Microsoft Entourage. In my signature in Microsoft Entourage I have a pic. However if I use the script Microsoft Entourage produces an email without my picture in the signature. Any tips? Second problem is that it puts the new email in the drafts folder; I would like it to open the email and leave the new mail open. Any tricks for this? Thanks

• 4 replies
• 1.7k views

ChangeAgent

December 31, 200619 yr

I have a portal that I would like to sort different ways via buttons. So far, the only way I can see is to create a different layout for each portal since the sort order is set when the portal is created. This would be a huge pain. I'm guessing there's a better way.... HELP! Thanks, Mel

• 3 replies
• 4.1k views

Stuart Taylor

December 30, 200619 yr

Is there any way to acheive tight vertical line spacing on printed reports with FileMaker? I've tried both normal fields and merge fields without success, yet the line spacing for a plain text block can be set to less than one line (e.g., line spacing = .7) and receive the desired result. As my example file shows, setting a normal field to less than the font's default causes descenders to be cut off. Can anyone suggest another approach to try (short of a calculated field that tries to combine hundreds of lines into a single field)? Thanks for any help. LineSpaceTest.fp7.ZIP

• 2 replies
• 1.2k views

K1200

December 30, 200619 yr

I want to create a checkbox called "Void" that, when checked, will print the word "VOID" across my entire record. Thanks for any help! Steve

• 7 replies
• 1.8k views

comment

December 30, 200619 yr

FMP V6.04 I would like to create a button that would dial a telephone number over the speaker of my computer, so that I could hold my phone in front of it and as such dial the number. BTW I use tone dialling. Is there a script for FMP 6 to do this? Or is there a standard way to set it up and it would work? Thanks for your help

• 0 replies
• 978 views

ChangeAgent

December 30, 200619 yr

Hello, I have a layout which is password protected. Screenshot Here My question is this, how can I get the password box (in screenshot) to clear out and not keep the password, which shows up when the dialog box is reopened. Ive tried to “Clear field’ but its not working for me. Thanks, James

• 2 replies
• 1k views

Totes

December 30, 200619 yr

Howdy, howdy... I have a run-time solution with a script that takes users to a splash screen/EULA agreement (see attached). The problem is, with the script as written (also attached), users can simply click on the Continue button in the Status Area as well as blow past the screen by selecting a different layout. What I'd like to do is take the users to the EULA screen where they'll be forced to click on either the "I agree" or "I disagree" buttons, then they'll be handed-off to the next script. As always your help is greatly appreciated! Have a happy and prosperous 2007, Rich

• 2 replies
• 836 views

Rich S

December 29, 200619 yr

I am setting up our FM data base to use Canada Post's online shipping. I would like to use the Web Viewer to populate the shipping form with data (name, address, etc.). However the form is built with Java Script, and it doesn't have parameters as part of its URL. I've tried writing a script to do this. But executing the script, even with key commands, pulls the focus out of the form. Even naming the Web Viewer object and using Go to Object doesn't help. Perhaps including a tab character in a script would help, but I haven't found a way to do that. Help will be much appreciated.

• 0 replies
• 1.2k views

Audioguy

December 29, 200619 yr

Hi, Brand new to FM. I probably don't even know the terminology well enough to ask a question in a way that can be understood, so I'd appreciate your patience as well as any advice. I'm sure there's a simple way to get around this problem, but I haven't seen it. I have a text field on a layout that has to be filled in. But I want to allow for the case where a user starts to enter data, then changes her mind and wants to go elsewhere without entering anything. I set the field to be a "Required Value". But that seems to make it impossible to get out without entering something. In fact, I can't even seem to bail out of FM without entering something. I n…

• 4 replies
• 918 views

TenTwentyFour

December 29, 200619 yr

In my educational database I have many student records and many other tables with school elements. I need to create a special layout from fields from different tables to make an autocomplete certificate or a perfomance paper. I wonder if I should create a particular table with fields from all related tables. Does anyone have to suggest a respectable solution to this problem? I really have a problem because portals or like that in such a layout do not work at all. Certificates also do not need a portal but many fields from different tables...I am confused. Pascal Help!

• 6 replies
• 1.1k views

edudna

December 29, 200619 yr

Hi Everyone, I am new here, so I searched a ways back in the archive but did not find a post explicitly about my question. If this has been covered in previous posts, I apologize and humbly ask for direction to that post. Anyway, my problem is that I have a checkbox set populated by a value list, and what I am wanting to do is tally up--across all my records--how many times each checkbox was checked. Specifically, I consult with clients about many topics in a given conversation, and I have a checkbox for each of those topics. I am trying to generate a report that shows how many times in a given year I discussed topic 1, how many times I discussed topic 2 …

• 9 replies
• 2.3k views

PaddyO

December 29, 200619 yr

In my main database, I want to set a field from "NO" to "YES" if all fields in the portal have a specific field set. Specifically, I've got a portal with academic transcript information, one line per institution. I set the RcvdTranscript field to YES once I've received academic transcripts from a particular institution. In the main database, I need to create a calculation that sets from NO to YES if ALL the transcripts in the portal have RcvdTranscript set to YES. This used to work under previous versions of FMPro, but with FMP8 it stopped... If(Count(Rx Enrollment::RcvdTranscript) = Sum(Rx Enrollment::RcvdTranscript); "Yes"; "No") Can anyone prov…

• • 
• 20 replies
• 5.8k views

Matt Klein

December 28, 200619 yr

Hi, I'm having trouble trying to figure out how to jump to records via a pull down menu. For example, if I had a database of records each containing a first name field and a last name field. I would like a pull down menu where you see a list of all the last names, and when you select a last name from that pull down menu, you are taken to the record containing that last name. I've included a basic demo file hoping someone could help out and tweak it so it does what I want. I can get the pull down list to show the names, it just doesn't do anything. Can anybody please help me figure out how to make it work? PullDownNav.zip

• 10 replies
• 1.7k views

Søren Dyhr

December 28, 200619 yr

I am almost done with this project. It has been a year and you guys have helped me out a lot. I have one more question. I have a created a group data report that lists the workflow (design, production and design/production), relevant information for each record in that workflow, then the subtotal for the workflow. I need to also show a monthly break down. I have a date field (01/01/2007) that contains this data for each job number when it was created. I need for the report to first group the month, then the workflow along with the job number and the total for each work flow. Example: December Design Job Number 12222 …

• 2 replies
• 961 views

Kaiden

December 28, 200619 yr

Hello, How can I force a field to retain the font size, style, and formatting that i've set it to? Users are able to override this and change the font when they enter data, but I don't want them to be able to do that. For example, they'll cut and paste from a Word document and my pretty Arial 10pt field will suddenly have Times New Roman 12pt text in it. Is there a calculation or something I can do to the field so that it re-sets the field's text formatting or simply ignores any formatting that the user tries to do? Thanks in advance, Frank

• 4 replies
• 1k views

jctull

December 27, 200619 yr

Hi, I am a beginner in filemaker programming. I am trying to achieve the following: In a layout, the user will enter a record number (eg: 0001, 0002, 0003)and click on a button. Based on the number entered the code in the button should connect to an Oracle db using ODBC, get the required values from the selected record and create a record in filemaker db. So, if I enter an employee number and click the button in the layout, the employee name, salary, age etc. should be populated in the layout. How can I achieve this. Any help will be greatly appreciated. Thank you

• 0 replies
• 833 views

jestjug

December 27, 200619 yr

Hello, For some time I've been using a script to copy the content of a portal to a textfield. It's been working great and I tried to take it to the next level by adding more portals and an equivalent number of textfields. The portals seem to be working without any problem. It seems however that the script to copy the content is only working correctly for the original portal. For the added portal only the first line is copied. Weird thing is that the first line is multiplied by the number of rows in the other (original) portal. The files can be found at: http://www.wijngaart.com/PDB_fxnl_linkpartners_copy.fp5 http://www.wijngaart.com/fxlinkpartners_copy.…

• 2 replies
• 1.3k views

peter100

December 27, 200619 yr

Hi, I have read through a bunch of articles on this site about hiding buttons in portals and I still don't quite get it. I want something very similar to what is present in a lot of the built in templates that come with Filemaker 8 (ie Lending Library). I need a button to delete records in a portal, I only want the button to be present if there are portal records. I have gone through some of the templates to see if I can discover how it is done and still no luck. Any help would be appreciated. Thanks, Matt

• 3 replies
• 1.4k views

mr_vodka

December 27, 200619 yr

I am a piano tuner in the panhandle of Nebraska. I have an awesome database for my business thanks to the help of a Filemaker Consultant out of Colorado. I'm trying to learn how to add more features to my database myself and am having a lot of fun doing it. I added a webviewer so that I can see a map for the address of each client. This is great for seeing where they live when I'm at home and connected to the internet, but I would like to be able to see the map on my laptop while driving to their house. Once I zoom in or out and configure the map the way I like, I want to be able to save the map with the clients record to use while driving. Anyone know h…

• 3 replies
• 1.4k views

David Pritchard

December 27, 200619 yr

Hi Folks, I am a newbie to the Forum and FMP. Find it more user friendly than Access . I have a very simple request for help (well I thnik so) I have managed to import to my database from excel all the membership info of my Club. I have designed a resonable layout, and have managed to place a couple of buttons, now this is where I am stumped. I wish to assign a script to one of the buttons for a [color:red]Surname search. ie click on button blank window pops up type in surname looking for, enter and it goes to first one found, also click other button to scroll through all other names matching the search criteria. How do I do this please ?

• 2 replies
• 887 views

Clubracing

December 26, 200619 yr

I have incorporated Filemaker Magazine's technique for creating a dynamic value list into my database. If you look at my file: www.jarrodprice.myhomeserver.com/sampledb.fp7 in the first layout called Web Interface, you can select from my dynamic value list which was built with the Categories_me table. This technique appears to require that every field has a unique name. This does not make sense. Every field has its own id, but the way it is set up, it doesnt work. To recreate the problem: If you select bracelet > bangle > amethyst the database uses the first instance of the category name amethyst in the database, rather then the correct on…

• 0 replies
• 956 views

jprice

December 26, 200619 yr

Hello Everyone, I was just looking at an audit program someone posted here from nightwing.com.au and at the top of the toolbar, there is a text link for “Nightwing”. I did not see any program on their site which would allow this feature. How did they get that there? I’ve looked over the custom menu section, but am unable to see any method for inserting an item such as this. James

• 14 replies
• 1.5k views

Stuart Taylor

December 26, 200619 yr

Situation: A laboratory setting, in which Patients (with personal information) need one of 3 types of Tests (with information). One Test (A) at times requires SecondLevel Testing (results are distinct but must later be analyzed jointly). I created tables: PatientInfo TestA testA1 testA2 testA3 TestB TestC I need a layout (based on PatientInfo) that will a) allow me to create a Test (A,B or C) through a portal disallow the creation of the other 2 tests once the serial number has been used for another top level test and still allow me to create a sublevel test with the same number.... Clear? Example: Patient1 (J…

• 2 replies
• 1.1k views

PathGeek

December 26, 200619 yr

Ok, I’m lost as an Easter egg on this one. This is kind of a layout question so I will post it here. I have a report that can be printed two ways…either by button 1”All Hours” or by button 2 hours “By Year” for an individual. The “All Hours” of the report I have in place and prints great. Now to my question: if the user selects button 2 to print the hours “By Year” I am attempting to have something in place so that they can select a drop-down to reflect the year they wish, and the report will print all hours of the report for that selected year. Can I do this via a drop-down selection, or will they have to manually enter the year? Will I ha…

• 2 replies
• 825 views

Totes

December 26, 200619 yr

Hello and Merry Christmas. Is it possible to script the url in filemaker to go to a certain anchor or location on a web page? That would be truly wonderful. Just asking if anyone knows Thanks Dave :o

• 0 replies
• 1.3k views

DAVE/

December 24, 200619 yr

Hi Folks, Is there a way to create a global template for layout? I want to create a template for 15 layouts and be able to change the template in one place and have the changes apply to all layouts. Thanks.

• 1 reply
• 1.1k views

Inky Phil

December 24, 200619 yr

Im new to portals, I am creating a simple database where a telemarketing company needs to lookup a client and see past donations and also enter new donations i would like to have them all show up in portals but im having trouble doing this any input would be great

• 6 replies
• 1.1k views

busabrent

December 24, 200619 yr

Hello all, I currently have a tabbed layout, one of the tabs contains a portal “Qualification” another tab contains a protal "Certifications". In the first tab is the "Qualification" portal containing dates, names etc fields… and,at the end of the portal row is a notepad icon. This icon will open a new window in which notes can be entered about this portal row. This link shows the script, which opens the new “Notes Window” (which works fine on the first portal) Script Link Here I have another portal in another tab “Certifications” which has the same note icon at the end of the portal row so that notes can be added via a new window “Notes Win…

• 2 replies
• 1k views

Totes

December 24, 200619 yr

If someone can help to find a respectable solution to this problem: I have some groups of costumers, for example costumers from five different countries. The costumers have orders all the year. And the orders have of course prices. I want to show in the same layout: For a specific period, for example 1-9-2006 until 12-12-2006 By a specific group of costumers. All the costumers, all the orders companied and all the prices of the orders. Without some fields repeated again and again. A general layout for all the tables I have. Pascal

• 2 replies
• 987 views

edudna

December 23, 200619 yr

Is there any way that I can make a button not show up on the empty line after the last entry in a portal. The button allows me to go to a related layout for that line. Is there away to make it not appear on the next blank line? Why does the button act different than fields? D. Cannell

• 2 replies
• 1.5k views

John Mark Osborne

December 22, 200619 yr

I'm using a portal to add records in an order. In this specific cases, the added records are date when our service will be provided and the name of employee in charge of providing it. I'd like this info to appear in the letter to be sent to the customer using mail merge or something like this. What should I do ? Im my database, I have several tables witht he following relationships: Customers <--> Orders <--> Ordersline <--> Products Thanks for your help

• 1 reply
• 976 views

John Mark Osborne

December 22, 200619 yr

Hello everyone. I'm having a problem with a set of radio buttons on my layout. I have a field that is configured to be a radio button field with three options. The field works fine and sets the value based on the selection. My question is that the radio button doesn't "fill." You click on the button but it doesn't turn black or show what you selected. Is there something I need to configure so that when you click one of the options the little circle turns black. Thanks js22

• 2 replies
• 870 views

js22

December 22, 200619 yr

I have an Invoice layout (invoice table) with portal rows(invoice data table) of invoice line items. Would like to be able to duplicate the invoice and have the line itmes in the portal be duplicated as well. This would create a new invoice with the serial number incremented by one and the portal data duplicated with the new serial number. End result would be: two invoices with identical data but different invoice numbers.

• 4 replies
• 1.8k views

Chris L

December 22, 200619 yr