FileMaker Interface Features

I am not sure what this feature is called. I don't know how I ever found it to begin with. If I use the normal text tool on a layout and enter // I get a date when I print the layout. If I enter ## I get a page number. Is there a list of these functions? And specifically is there a time stamp like the date stamp? Thanks in advance, May the Lord Jesus Christ bless you unto salvation through faith in his work on the cross, Greg!

• • 
• 4 replies
• 1.3k views

GregInChrist

February 6, 201313 yr

Hi, I'm having some difficulty getting a portal to work as expected in the solution I've been working on. The solution is basically a catalog of different legal documents (like deeds, mortgages, and so forth). These documents are reviewed in the context of writing a legal opinion, so the solution also tracks opinions. You could think of an opinion as a project. So it's possible that a document could be reviewed multiple times in the context of different opinions, thus a many to many relationship between documents and opinions. So I set up a join table between the Document and Opinion tables. In the join table, I have fields for information like the review number and the…

• 3 replies
• 2.1k views

Opotoc

February 5, 201313 yr

I have a quick question.  We use a drop down menu to choose a certain color on a work order form. We them manually fill in a circle on the form with a marker to match the color on the order. Is there a way to either trigger a colored circle when a choice is made or to change the font color when the choice is made??  Any thoughts would be helpful...keep in mind that I am a bit of a newbie with Filemaker!  I have attached a screen shot for you to look at. The field with the term "dark grey" is the drop down box.  mhburris

• 14 replies
• 4.1k views

mhburris

February 5, 201313 yr

Hi There, I have a quick question to ask, well I think it is a quick question. Is it possible to have a feild display 2 different value lists? What I mean is, in my solution I have a field that when a certain value is set it calculates a table to get values to populate a dynamic value list. Now I need to find out if there is a way to display a static value list in the same feild should the other option be selected. So in a nutshell: If Field A is selected with option 1, then run script to sort table and get values to populate in ValueList A that is used in Field B. If Field A is selected with option 2, then Field B uses static ValueList B I was thinking of duplica…

• 2 replies
• 1.5k views

bcooney

February 5, 201313 yr

Seems basic, but I'm stuck with a simple issue here: To simplify the problem, suppose I have One table "Invoices" and related table "Items". The Items of an invoice can be shipped on more than one transport, so the latter has a textfield "transportNo" whose values are stored in a valuelist that uses values from the field, so that each time a "transportNo" is added in the job, it is available in the listbox for subsequent added items. Now, for some reasons, I'd rather not create a separate table for transports... but I need to know how many different transportNo have been inserted in the textfield, for every job. Unfortunately, Both count summary field or "ValueCou…

• 2 replies
• 1.1k views

desta

February 2, 201313 yr

Ever since FIlemaker modified the Table Views so that users could crwate new FIELDS "on the fly", I've been kind of terrified of them -- because every once in a while *I* click on the "+" button on accident and wind up with a new Field. Usually I try to craft List Views that fulfill my clients' needs, but they almost always want to be able to use Table view, so I think I should "get over it. So, what is the best way to "Client-proof" the Table views from user errors? Would it just be by using Privilege Sets that bar access to Layout View? (I assume that if you don't have Layout privileges, FMP won't let you create new Fields, right?) Or is there an alternate t…

• 6 replies
• 1.2k views

Vaughan

February 1, 201313 yr

I have a Container field that will be used for Displaying Quicktime Files. The client wants to simply store a filepath to where the Quicktime file will "live", so I'm notusing the new remote storage option, just the old school approach. So, s I understand it, the user should click into the Container field and then select "Insert Quicktime" from the INSERT menu and then navigate to the file and bingo. So, I can tell them that's the way to do it. BUT - - - I worry a little that a user might insert a file by "drag & drop" instead, because they're used to doing this sort of thing. If they do that they get an image of the file, and I guess it's actually st…

• 9 replies
• 1.3k views

Lee Smith

February 1, 201313 yr

I am running 12. 03 Advanced on Mac and Windows On my Mac, I created a custom menu which has, as it's last option under File... the menu item "CLose Application". When I save the app to a flashdrive and then open it on my WIndows 7 computer there, under File... is 'Close Application" AND under it EXIT. Question: "Where did this EXIT command come from? It is not part of my Custom Menu set. And, "Is there some way to get rid of it?" "Is it part of Windows?" Thanks Perplexed Ron

• 9 replies
• 2.1k views

hbrendel

January 31, 201313 yr

Hey all. Wanting to write a script that removes all related records displayed in a portal row. Currently I have several scripts a user can run that will create a certain number of related records (in this case, 5 days): Freeze Window Set Variable [$weekid; Value:${Weeks and Data}::week id] Set Field [Weeks and Data::global_days_count; 5] Go to Layout ["Hours" (Hours")] Loop Exit Loop If [${Weeks and Data}::global_days_count = 0] New Record/Request Set Field [Hours::week id; $weekid] Set Field [Weeks and Data::global_days_count; ${Weeks and Data}::global_days_count - 1] End Loop Go to Layout ["Weeks and Data" (Week and Data)] Now, the user can create as ma…

• • 
• 4 replies
• 3.5k views

Rick Whitelaw

January 31, 201313 yr

I have a layout with a Tab Control on it, housing 3 tabs. In each tab, I have a portal, all pointing to the same table occurrence, but displaying different data. 90% of the time, everything works fine. However, some of the time, when I click on a tab to switch to the data I want, the view switches to show everything as <Table Missing>, and sometimes, clicking on the 2nd or 3rd tab takes me to the 1st tab showing <Table Missing>. A second click on the desired tab causes the portal to refresh and show the proper data, but I can't figure out what's going wrong in the first place to fix it. Anyone have any ideas on how this can be fixed?

• 1 reply
• 1.3k views

Opotoc

January 30, 201313 yr

I currently have a web viewer that is displaying user avatar images in an iChat-like display window. I am currently referencing the avatar images from our company's webserver. <img src = "http://mydomain.com/FM_ICHAT_IMAGES/avatar01.jpg" /> I would rather pull the images directly from a remote container field that are being stored on a FM12A server. Is this possible?

• 1 reply
• 1.3k views

dansmith65

January 30, 201313 yr

I have a portal with a long list of data. I have added two global fields so that the user can narrow down the results. I would like to do this real-time as they type into the global fields. I have the filter function working close enough, but what I can't seem to figure out is how to refresh the portal. If I leave the layout and come back, the correct data shows up, but where's the "Refresh Portal" or "Filter Portal" function??? Thank you in advance, Ryan

• 5 replies
• 2.8k views

RyanESmith7

January 29, 201313 yr

Matt Petrowski produced this excellent video. I thought I would pass it along. http://fmforums.com/forum/topic/87415-easy-custom-menus/

• 1 reply
• 1.8k views

Lee Smith

January 29, 201313 yr

Hi I am VERY new to FileMaker, having spent a wedge of cash on it some months back with the good intention of learning to develop my own bespoke solution for tracking customers, their computers and the work carried out, as well as build lists (for components of new, custom PC's) and easy reports of customer's unit's due for servicing after X months. However, I hit a road block - I have never used FMP before, nor have I developed a database on this scale before.  In the past I have some experience with MS Access, having developed small solutions for myself such as contacts and inventory databases, but nothing close to the scale of what I wish to achieve.  Also, d…

• 3 replies
• 3.5k views

danielrmitchell

January 29, 201313 yr

I have a text field with a vertical scroll bar with an excess of text in each record due to limited layout space. I'm not sure the user will know to click inside the field in order to bring up the vertical scroll bar drop-down arrow. Is there a way to make this Arrow permanent? Or alternatively, I could make a tool tip that says "Click inside the text box to scroll" but how could I create a calculaiton as part of the tool tip that takes away that message once the user has clicked inside the text field? Thanks so much for the heads up.

• 3 replies
• 5.7k views

Aussie John

January 29, 201313 yr

I've been on FileMaker Pro 7 Developer for ages, but I like the idea of tool tips, and so I finally I upgraded to FileMaker 11 Advanced. Yes, yes I know there is FileMaker 12 but I didn't want to go through the hassle of converting all of my existing files from .fp7. Anyway, in the Layout Inspector (which is new to me) I assume that one selects the field or the field name and then types in the text of the tool tip in the Inspector. I'm assuming that most people are choosing the field itself, rather than the name or header. Is that true?

• 2 replies
• 4.7k views

Aussie John

January 29, 201313 yr

Once I have entered Manage Scripts the keyboard shortcut to Manage Layouts (Shift-Command-L) no longer works. If I exit Script Manager the keyboard shortcut is still lost, only restarting FM re-instates the shortcut. I tried this on a virgin file and it's still the same problem, so it's not file corruption. (Apparently not a problem in Windows) Any one experienced the same or know a workaround? Mac OS X 10.6.8 FMP Advanced 12.03 Thanks

• 6 replies
• 1.1k views

Rick Whitelaw

January 27, 201313 yr

I'm having a bit of problem finding the solution to what I want to accomplish. I have a layout with a 15 tabs. I want to have the label and possibly the fill color on the Tab that's currently selected change from black to white. I'm on FMP12.

• 1 reply
• 1.9k views

Lee Smith

January 27, 201313 yr

I just discovered that I can customize my toolbar in FM11. It's been a great discovery! As I was playing around in the customize window, I noticed that the toolbar screen has four buttons - New, Rename, Delete, Reset. Does this mean I can create new toolbars? The button seems to be greyed out, but why else would they have a button labeled "New"? Really, my ultimate goal is to have a toolbar that either has scripts on it, has a button that will open a new file, or both. If there is no way to create a second toolbar for this, is there a way to do either of those on the main status toolbar? Thanks, Joe

• • 
• 3 replies
• 2.5k views

DPaquin

January 26, 201313 yr

I chose a layout theme and I now want to change ALL the colors. The only problems I've run into are that I can not find a way to change the quickfind button line when it is in hover mode, and I can't change the color of tabs that are not currently chosen. Any help would be appreciated, thank you!

• 1 reply
• 1.5k views

Lee Smith

January 25, 201313 yr

Okay, here's a real head-scratcher. I have a multi-part report that is, in virtually every way, behaving as expected. Expect for one Field, "LOCATION" which is the only field in a Sub-Summary part. The Field has Entries Like Box 1 Box 2 etc. In terms of Sorting and accurately ordering the hierarchy of records beneath it, it's behaving just fine. When I go to "Preview" Mode, it's looking good to go! But when I actually *print* -- or save the report as a PDF file . . . the *Numeral* isn't printing! To begin with, this just seems like it can't be -- how can I see characters in Preview that don't actually print? It's *not* a margin issue, or a matter of …

• • 
• 9 replies
• 1.4k views

Wickerman

January 25, 201313 yr

Hi, I run a small tree business and I'm trying to create estimates that have line items linked to each tree we perform work on. I have CLIENTS --< PROPERTIES --< TREES and ESTIMATES--< SERVICELINES >-- SERVICES. What relationships and/or table occurrences do I need to create to place multiple conditional value lists inside of an ESTIMATES layout via a portal based on SERVICELINES? On an ESTIMATES layout I have a drop down value list to display clients. I want conditional value lists that display 1) only properties relating to a particular client and 2) only trees related to a particular property. Thanks for any help.

• 1 reply
• 1.6k views

Glenn Butler

January 24, 201313 yr

Hi: I've been having a one man brainstorming session for several months now and I'm down to the wire and could use some fresh ideas if any are to be had. I work for a magazine publisher. I develop custom solutions for my employer and I'm working on an upgraded version of a CRM solution with Sales Order module to create insertion contracts. We sell ad space across a few media now, Print, Online (web and email), Digital Enhancements (digital editions of our print magazines with items like links, videos, etc.. Historically, our contracts have been separate for each media because they don't always contain the some columns of data as a rule. with this new CR…

• 2 replies
• 1.4k views

rothdavid

January 24, 201313 yr

Hi There. I have a table called: Users which contains the fields User ID, Level, Gender I have a table called Result Events. It contains Event ID, Level, Gender. I have a table called Results. It contains the fields User ID, Event ID, Result. What I would like to do is have a value list (a pop up menu) which only shows user IDs which are in the same level and gender as the event ID (eg if an event is Male, Junior, the value list in the table results will only show users which are Male Junior) Any advice would be greatly appreciated. I am stuck and can not get it to work - I have been looking on various sites and not be able to find a solution. Than…

• 2 replies
• 918 views

Tim Hampton

January 24, 201313 yr

Hello and thanks in advanced. Is it possible to make RTL layout? Also i need the cursor to star from right to left in all input fields [Arabic language]. Thanks so much Mohd

• • 
• 3 replies
• 1.4k views

pbouquet

January 23, 201313 yr

FM12 Advanced. I want to show a screen at start up and go to another layout in about 5 seconds. How do I do this??

• 2 replies
• 885 views

IEW

January 22, 201313 yr

Hello How can you access the print layout in the style sheet or XML file? This may be a surprise but I don't want the theme color or image to print in the background. I understand the basics of modifying the style sheet and creating custom themes but do not see where modes are differentiated. Thank you

• 2 replies
• 1.6k views

nleon307

January 22, 201313 yr

I think what I'm looking to do shouldn't be that hard to figure out, but for some reason, I can't really find my answer. I've searched and searched but I might be searching using the wrong question! All I want to do is have a checkbox or radio box, (or even drop-down... I'm not picky!) that is a yes or no ("Do you have a member number?"), so if the user chooses "Yes", then either a text field appears, or a dialog box opens and the user can type in their member number and it gets stored in the proper "Member_Number" field. If no, (if possible) I'd like it to store a "None" in that "Member_Number" field. Also, if the user chooses "Yes", can I make it required that…

• 2 replies
• 980 views

Vaughan

January 22, 201313 yr

PNG buttons added to a layout via INSERT-PICTURE from a FMP Advanced v11.3 Windows client to (assumed to be FMPv11) server hosted database display properly on the Windows client, but cannot be seen from a Mac client. The converse is NOT true: png pictures inserted by the Mac client CAN be seen by both the windows client and the Mac client. When this occurs, the graphic looks like a place holder, sort of like the picture is missing. (I am developing on the windows client using FMP11 Advanced, and my client is viewing from FMP11 Standard for Mac, and the database is hosted by a 3rd party. I do not know the version or platform of server installation that is hosting…

• 4 replies
• 2.1k views

Daniel Paquin

January 22, 201313 yr

I have this layout... a record gets auto generated auto increment Id # There is a Add button and a Delete button.,, but the user clicks the top right corner X Can i prevent the X being enabled? thanks

• 4 replies
• 873 views

RodM

January 19, 201313 yr

I'm using Filemaker Pro Advance 10 to make a simple invoice for line items of different products, each with varying colours. I, however, can not seem to get it to work. I created a table of products, whose layout has a portal to another table. This is where, using a drop down list, the varying colours of the product are input. The colours are listed in yet other table. Some products can have a limited number of colours while others have access to all colours. Ideally, on the invoice, by line item, The product is selected in one field and then one of the colours relevant to that product is selected from a drop down list. How do I make this happen? I have t…

• 2 replies
• 1.5k views

Masood Bacchus

January 18, 201313 yr

Hi, I have a relational database in which surveys are carried out and recorded in a survey table (parent table) and all manta rays sighted (they each have unique patterns) on the survey are recorded (child table). surveys < manta ray sighted The GPS location of each manta ray is recorded as a Latitude and Longitude coordinate (2 variables) in the child table. So first I would like to link a Google Map web viewer to show the location of that individual on a map. Google Earth would be preferable if that's even possible, but Google Maps will suffice. I have another parent table (catalog table) to the manta ray table that has one record for each unique …

• 6 replies
• 21.9k views

Dani Rubenstein

January 17, 201313 yr

Pre-FM12, groups of objects on a layout were selected by encircling them. If they weren't completely within the circle they weren't selected. In FM12, any object touched is selected. Is there a 'preference' in FM12 to use the old means of selecting objects on a layout? Or am I stuck with the new way which is a real pain when editing complex layouts?

• • 
• 21 replies
• 3.1k views

Lee Smith

January 17, 201313 yr

I am working on making a report that shows which items a sales person had sold in a month. The way the database is set up is that there are 12 worksheets. These worksheets are used to provide a price for either different rooms or different plans depending on how the salesperson wants to price the cabinets they are selling. They can price up to 3 different cabinet styles. This calculates the cost of worksheets for each style. Everything is working on that aspect but now I want to add the ability that they can print off their commission report at the start of each month for the jobs they sold last month. Here is where I'm needing help. Sometimes a customer will bu…

• 7 replies
• 1.2k views

Lee Smith

January 15, 201313 yr

Guys, I learned this technique from this forum and am thankful for whom provided it. ( Mr.Vodka ) I think. Anyway, I can't seem to wrap my head around why it doesn't work in 12. I can convert a file containing this trick and it works fine. Has anyone found a workaround or am I just overlooking something? Thanks MergeVarPortal.zip MergeVarPortal.zip

• 7 replies
• 1.3k views

bruceR

January 14, 201313 yr

In FM 12 Pro Adv... I have an already existing layout with fields populating it from a table. I went to Manage Database and created 12 more all new fields in the same table. Now I want to add those 12 new fields to the same already existing layout. It seems that all I can do is to individually drag the new fields on to the layout using the Field Tool. Isn't there a way to select multiple fields (from a dialog?) and add them en masse'? I know how to do this with an all new layout. Thank you all...

• • 
• 5 replies
• 9.9k views

Lee Smith

January 14, 201313 yr

Any time I try to select just one field or object in a layout I have to move any object that surrounds the one object I am trying to move. Please tell me there is some easy solution to selecting THE object that I want. Â In the attached screenshot there is a box outline that surrounds all of the fields. In order to select any one of the displayed fields I have to remove the outline. This seems crazy.

• 1 reply
• 1.6k views

Lee Smith

January 14, 201313 yr

I want to record horse treatment notes in a patient's Visit Notes layout. To aid in entry speed, I want to place a series of buttons to the side of the layout (this will be for iPad), that when tapped, will add(insert, append) to text in a Notes field. Initial thoughts are to design the layout with the buttons, and associate a script that simply inserts the text into the Notes field, for that patient, on that visit. Is this too simple, or should I be setting up a more complex structure?

• 2 replies
• 861 views

db_tragic

January 14, 201313 yr

Hello, I am trying to create a value list based upon a single field. This field is populated via AppleScript with the names of the calendars in iCal or Calendar. The list is in a single record, with a line given to each calendar's name. Without having to parse out the individual field into multiple records, how can I achieve a value list with each of these calendar names? Thanks for your thoughts! Regards, Stephen

• 3 replies
• 1.1k views

argwallace

January 13, 201313 yr

Had a layout with labels on the left and fields on the right. The fields were partially on top of the labels and I simply wanted to move them off to the right. I slid the right palette margin line some number of px to the right to make room. I grabbed all the fields and moved them some number of px to the right. Now it's messed up Browse mode. See BadLayout3.jpg. And I can't seem to get the fields to show data except for the top field in the array. All I did was attempt to move the fields. Anyone know how I can get them to show? Using the Inspector, noting that the fields that don't show data have some different characteristics than the one field that does show. …

• 2 replies
• 923 views

Hoib

January 12, 201313 yr

I created a sub summary report that also uses filtered portals to create a report for our companies sales. I thought it would be neat if I could show the monthly sales by department for each year we have on record. My goal was to show each department as a row and each month's sales as columns. The report works, and shows the correct data, however it takes hours to run and summarize the data making the report unusable as it stands. I even tested just using one department and one year to see how long it would take to generate the report, and it took about 30 minutes before it was finished. In a nut shell this is what I did. For the basis of this report I have a "Sa…

• 3 replies
• 1.5k views

Wim Decorte

January 11, 201313 yr

I have a layouts with several global fields, each of which has a SQL driven, calculated value list attached. It works fine but I wanted to reduce the number of fields in the table for clarity sake and I was wondering if there was a way to have a single global field with multiple repetitions then use a Case function that SELECTS the appropriate value list. The effect would be that, instead of having 5 globals with 5 corresponding c_Valist fields, I could have single global with multiple reps and a single c_Valist field. I've been able to achieve something like this in a portal where I can easily set out conditions for which value list to trigger. But I can't seem to f…

• 1 reply
• 804 views

eoneon123

January 11, 201313 yr

I am working on designing a database where someone can custom build a computer. I have tables for each type of component. I have built some conditional value lists that only show compatible parts. Now what I am trying to accomplish is how to filter out these parts to only show items that are still available. I don't want it to show items that are compatible but discontinued. I have a field that I have a drop down list that I have selected if an item is "Active", "Unavailable", "Discontinued". I am not sure how to have my my value lists filter based on this condition. Any help would be greatly appreciated.

• 7 replies
• 1.3k views

comment

January 11, 201313 yr

I have a many to many relationship between my Jobs table and my Contacts table. I have created a tabled called Jobs_Contacts that looks like this: ID (numerical, serial) JOB ID (foreign key to Jobs table) CONTACT ID (foreign key to a Jobs_Contacts_TO, this is a table occurrence of my Contacts table) Relationship (Text) This table (Jobs_Contacts) is being represented by a portal on a layout tied to my Jobs table. This portal displays the following fields: Relationship Jobs_Contacts_TO:Full Name Jobs_Contacts_TO:Work Number ... What I would like to happen is to display the list of all names in the database in the field control within the portal for Jobs_Contacts…

• • 
• 8 replies
• 1.2k views

RyanESmith7

January 10, 201313 yr

Hi Brand new here I would like to make a filemaker file to become a filemaker go solution. ( I haven't made it yet) But before I do I was wondering how to make a solution that doesn't allow the user to add records in a given table, Enter data. I would like to have a script driven solution that I could control and use a webviewer etc. I just want one layout and buttons to do things on one record. If I need to I can have records on another table that could be accessed, But I wanted to ask before I did too much without knowing how to set this up. 1 record, not able to delete or input from the user. Just use buttons to activate scripts. It will be an educational peace. …

• 2 replies
• 753 views

bcooney

January 9, 201313 yr

I have a text field that contains a list of companies (from a contacts database). I want to be able to put this into a portal. The reason for this is to have the user be able to click on a line, and it go to a specified layout based on that. (If this is possible without doing it in a portal, then I am all ears also...) I have considered creating a table called Companies, that when someone updates the 'Company' field in the contact, it adds to this table. However, when someone updates the company field, it won't delete if that is the last of that company entered. I would rather have the portal rows directly linked to the list stored in the text field.. Has …

• 1 reply
• 631 views

Matt Malyschko

January 8, 201313 yr

I want to create a pricing calculator for my customer service team. I want the layout to ask Size X: ___ Size Y: ___ Size Z: ___ [submit] based on that information, it will generate a price code. They will take that price code and enter it into a different database. I don't want this calculator built into the 1 database, because it may be used in other databases, or independently. I was thinking about using a single record. But if I have 2 people generating price codes, they can't use the same record (IE it would be locked via record-locking.) Has anyone tried to do something like this before? I know I can do this in MS Access, because i'm not usi…

• 3 replies
• 1.2k views

Scott Pon

January 7, 201313 yr

I've got a list layout which allows a user to view a parts stock forecast over a 13 week period, which makes use of conditional formatting to highlight certain aspects of the data.   The body of the list consists of 13 separate calculated fields which represent the stock on hand each week; these are called _cWeek01 through to _cWeek13  In the header I have a global repeating numeric field with 13 repetitions; I recalculate the week number based n the current date as needed so, for example, the first rep would contain the week of year for Monday 7th January 2013 (2) and the last rep would contain the value of 14, to represent week of year 14.  Call this _g…

• • 
• 5 replies
• 2k views

comment

January 7, 201313 yr

HI, I have been going around in circles with a DB I am building for my small buisness. It is a simple service request / report DB so we can keep track of what was done to where and when as well as printing a report for the client. It is a flat file as I have not defined any relationships. I can't quite get them to work and they do my head in but I know the answer is in them! We have CLIENTS that have multiple LOCATIONS which have multiple ROOMS/VENUES I have made the above fields, in the service request layout, a drop down list based on a value list of the field with the option to add "other". This works OK as it will standardise the entries. But, th…

• 3 replies
• 1k views

Rick Whitelaw

January 6, 201313 yr

Dear FileMakers, I'm trying to get a checkbox menu to work. Please see the example. There are 10 trains. When I select train 5, the find brings up train 5's data. Then, when I also select train 6, it finds train 56's data. There is no train 56 - I'm trying to bring up results for train 5 OR train 6. Seems it should be very simple, but it's had me going around in circles. If someone could the attached to work, and provide a explanation of how you did it I'd be so grateful! Ben CheckBox.zip

• 16 replies
• 2.8k views

comment

January 4, 201313 yr

I have a portal on a layout. I want to conditionally disable the ability to enter information in one of the fields based on a value in a related table on a row by row basis. Is this possible? Suggestions? Thanks in advance.

• 1 reply
• 744 views

comment

January 4, 201313 yr

Dear FileMakers, I'm trying to create a single button with three different states, through which the user can toggle. I've completed the following tutorial: http://www.filemaker.com/11help/html/fmpa_tools.24.23.html ...and have the button with it's three different colours toggling nicely. Where I'm stuck is attaching a value to the different states. How do I get the button to output values (1, 2 and 3) into a field? Thanks in advance, Ben

• 6 replies
• 1.3k views

benmayo

January 2, 201313 yr

Hello... Â Firstly Thanks All forum member. I learn many special feature on file maker by this forum. Â Im newbie on filemaker... I want build some special software for my business.. Â Now I need help. Â I Have 3 tables. Â 1- Product ID (Matching Field) Name Etc.. ( any spesification for this product. not important ) Â 2- Buying Details ID (Match Product ID) Quantity Price Total Price ( quantity * price ) and below sum total price (sum= total of total Price) Â 3- Selling Details ID (Match Product ID) Quantity Price Total Price ( quantity * price ) and below sum total price (sum= total of total Price) Â --- My main layout is Product lay…

• • 
• 5 replies
• 1.3k views

LaRetta

January 1, 201313 yr

Howdy, all:  I know I've seen a simple script somewhere that parses a checkbox'd value list and through a looping function, is able to create a summarized list based on the parent value list choice related children values, but I just can't find it here and online. (After two hours of searching my eyes feel like hamburger.)  Attached is a screenshot I threw together: the checkbox'd fieldname is "Class" and its (children) values (fieldname "Value") are in the portal to its right. So, in this example, a user has selected three values (shown also in the box in the middle of the layout for clarity's sake):  Duration Relationship Diplomat Type  ...with Diploma…

• 0 replies
• 888 views

Rich S

December 28, 201213 yr

Hi, I have a stupid problem that's been annoying me for some time now. Basically, I have an "On StartUp" script that I trigger when the user open the datafile "OnFirstWindowOpen". And the "On Start Up" script puts the user on a specific layout THAT I NEED to have priority. The only problem, Filemaker for some reason, opens with my largest layout width for a split second. Long enough to make the database look unprofessional, instead of looking to the script and holding the layout view until it's called. Now I've pushed the layout to the Top of the Layout Manage window, I've opt in on the Layout in the On Start Up File Option in Filemaker where it says "Sw…

• 4 replies
• 1k views

"... you mean these fans?"

December 28, 201213 yr

Hello again. Back with more on my food pantry solution. I'm trying to figure out now how to set up a portal from Session_Ops to Session_Volunteers to handle volunteer hours, sort of like a time and attendance module.  I've done up three attachments to show where I am. The problem is I can't seem to save the volunteer information for later retrieval. I envisoned that Session_Volunteers would hold all volunteer specific info like time_in and time_out in an historical context. I can't write it so that it properly saves the history.  Vol_1.jpg is what the layout looks like now. I can drop down and install volunteers at will. But Vol_2.jpg shows the Table…

• 8 replies
• 2.4k views

bruceR

December 24, 201213 yr

Database setup (relevant fields) Client (parent) - client ID - g_Selected Date (global field to pass date to another layout) Department (child; many depts linked to one client) - dept ID - client ID (linked to client table) KPI (grandchild; many KPIs to one department, one for each date) - dept ID - KPI date - KPI 1 - KPI 2 I setup a layout (based on client table) with a portal (based on department table). The fields in the portal are the four listed in the KPI table. The Problem: How do I limit the portal to only show KPIs with a date based on a variable passed to the layout (actually, the global field in the Client table)? I've tried to …

• 2 replies
• 1.3k views

comment

December 24, 201213 yr

Using the Starter Solution in FMPRO 12 called "Contacts" I have conditionally formatted the Work Address & Home Address Tabs (in the "Contact Details" layout) to color the tab label's text green IF there is anything in the "Work Address 1" field or the "Home Address 1" field. Since you can only see EITHER the Work Address OR the Home Address at one time (in that layout) this color change let's me know if the currently unselected tab has any data or not. If both are empty, they remain white; if one or the other has info, that tab ("Work Address" or "Home Address") is green; if both have info, they are both green. Question: Can I use this conditional formatting (the…

• 0 replies
• 1.7k views

mascotca

December 24, 201213 yr

I have a field set as a checkbox list (5 rows high in the layout display). On another layout, I want to use only the chosen options from the checkbox list, but I want to display them in a single line separated by a comma and a space (I'm pushed for space in the new layout). The field will be displayed as an edit box in the new layout. So, assume the list below from original layout containing checkbox: A B C D E Options A, B and E are chosen. In the new layout, I require: A, B, E Any help much appreciated. John

• • 
• 2 replies
• 1.6k views

McG

December 23, 201213 yr

I'm planning on using a number of drop lists, which when individual items are selected, a script would run (on Object modify) that would insert(append) specific text into a text window. Just after some help on scripting this one. TIA

• 4 replies
• 1.4k views

Lee Smith

December 22, 201213 yr

FM 11 Adv. Frequently, as I am working in the layout mode I’ll get the message “the layout cannot be modified in the window because it is already being modified in a different window”. The layout names then appears in the Windows menu. I have to exit FM and restart to close these windows. I know the idea is to prevent editing a record in two different windows, but editing occurs in the browse mode, and I’m working in the layout mode. This is just a database for use on my desktop PC only. What can be causing this? And when this happens, is there a way to close the window (although I did not create it) without restarting? And where can I find good information on the Windows…

• 3 replies
• 1.5k views

LaRetta

December 21, 201213 yr

We have a database that is our sales orders database. One of the fields is "Closed Date" Is it possible to make the layout locked or read only when the closed date is filled in? this way the record can't be edited. (I'll handle editing it with a closed date at another time). Any thoughts or suggestions?

• • 
• 29 replies
• 12.2k views

comment

December 20, 201213 yr

Filemaker 12 gave us an absolutely fantastic new feature, among many others: the gray area to the right of the layout, in layout mode. The thing is, does anyone know the nitty-gritty details on how it works, and interacts with browse or preview modes? I'd love to have it spelled out in black and white for me, to eliminate the murky grey area (haha, see what I did there? ). Anyways, the help file simply says all objects in the gray area are right-anchored, skipped in the tab order, and appear in Table view. Upon testing, it seems that fields in the grey area ARE summoned, calculated, pulled, whatever, same as if they were visible (important to know, if you were plannin…

• 0 replies
• 1.1k views

KaosMaker

December 20, 201213 yr

Hi I am having trouble making a report for my file. In a nutshell I have These Tables "Written Sales", "Sales People" , "Salesperson hours", and "Sales Person Goals". I am pretty happy with my yearly report / comparison, but now I want to show the same data by salesperson then by month. I tried using sub summaries but have not been able to get all the data needed for the report this way, namley my hourly productivity and goals. I have attached a copy of the file I am working on for your viewing pleasure.  The file is pretty basic, and I am a novice so please be easy on the crtiticisim, but any and all comments are appreciated!!! I am sure I am just not seei…

• 2 replies
• 1.3k views

Goetch

December 18, 201213 yr

Does anyone know how Filemaker chooses what Sample Data to present in Layout mode? I'd like to have a little better control over it, ideally, for fine-tuning field sizes and whatnot. Relatedly, does anyone know how Filemaker refreshes said sample data? For instance, if I have a global calculation field on the layout, and the result changes (but the calculation definition doesn't), what would it take for Filemaker to refresh the sample data in Layout mode, for that field, since it seems to prefer the original result from the moment Layout mode was first entered. I know these are rather weird questions, but thanks so much in advance!

• • 
• 2 replies
• 1.3k views

KaosMaker

December 17, 201213 yr

Firstly Database includes the following tables: HorseOwner, Horse, TreatmentNotes Have set up a 'start' screen as a starting point for users. They have the choice to search by Owner Surname, Horse Name or Invoice To fields. I've set up value lists for each of these, which the user can choose from a drop down list. Firstly, Once they select the appropriate record from the pop-up, what's the best way to take them to the related record? Secondly, I considered an alternative for the Owner Surname value list so it included the Location value as well (in case there were more than one instance of a given surname (different individuals) thus identifiable b…

• 9 replies
• 1.3k views

LaRetta

December 17, 201213 yr

I have layouts that are sized the same. But when I go to my Quiz that is sorted by records it takes the whole screen. The "Header", "Body", and "Footer" have the same measurements as my other layouts. I even went to the little icon in layout and made sure that the desktop is checked for 1024x768 and it is. So my "next" button is sitting in the middle of the page when I go to browse mode and the record fills the whole screen. In layout mode the button is where it is suppose to be. Please advise.

• • 
• 1 reply
• 894 views

dansmith65

December 16, 201213 yr

I am using FM 12 v 3 (even if v3 is buggy)  I have a main layout based on Members:   On the left is another Members TOC called Members Portal  Everything works great.... except that when I press the right (or left) 'next record' arrows, FM goes to the next Record ID and not to the next Member's Name.  Here is the script I am using: (pretty simple)   Question: "How can I, regardless of recordID, advance to the next 'Member Name' and not next RecordID?  I am almost embarassed by what should be a pretty simple and common situation... but I am stumped. Can someone give me a 'kick start'?  Thanks

• 5 replies
• 1.4k views

comment

December 15, 201213 yr

Hi, I guess that my tag line is not that clear...lol... that's what beginners are all about..lol I am looking for a way to influence the value list according to a certain value... i'll try to explain Lets say i am creating a company restaurant and that i have everyday 8 different type of offers I have created a library of recipes. When i go to my weekly planning i find a table that looks much like an excel table with on top the 5 days of the week and on the side i have OFFRE1 to OFFRE8. When i select OFFRE1 i would have a list poping up so i can select if OFFRE1 is SOUP, STARTER,SANDWICH...etc. According to my selection i would like that if i select SO…

• 2 replies
• 983 views

bcooney

December 14, 201213 yr

Hi! I have a web viewer which loads an HTML file that is located in the same folder as the calling program, the testing put the full path in the web browser "filewin://D:/Dropbox/Receipt/Graphics/gifs/file.html" and I run it on my laptop and no problem, load the file, but now that I opened the file in my office from the same DropBox folder, but on another computer the address changes in the drive letter that is now the address is: "filewin://F:/Dropbox/ Receipt/Graphics/gifs/file.html" as they see the path just change the letter, now I read somewhere that to avoid problems in recall just enough to put files on the same folder where the file FM and did not need to refere…

• 0 replies
• 1.3k views

Hectorcc

December 13, 201213 yr

I want to display a moving gif file in my presentation of FM12, to do this I embed the gif file in Web Viewer, but in the presentation appears the browser scroll bar on one side, how I can remove this bar of your browser? FileMaker Pro Advanced 12 Windows 7 Héctor Cornejo Cravioto Think different ... and live better

• 2 replies
• 1.6k views

Hectorcc

December 13, 201213 yr

I have a simple portal that i have placed a button on the portal row. I have tried just running "delete portal row" I have also tried tying it to a script that has the command "delete portal row". The problem is that if I click the button the row does not delete. Once in a while I can open up filemaker and get it to work but it is very random. I have watched the script get called in "script debugger" and have no errors. But yet it does not delete the record. Any ideas? Thanks Thom

• 6 replies
• 2.4k views

LaRetta

December 13, 201213 yr

Hi I'm currently working on a database where photo's are ordered on a website and need to be managed (via .csv imports) in FM12. This is all working pretty well so far but my problem is with the reporting/summary. The setup is that a FMdb (iPad/FMgo) generates the data that is imported into the site CMS where customers can order specific prints. That works fine. The modified data is exported (CSV) from the CMS and imported into another FMdb, that is related to the initial FMdb (where the data is generated). This second FMdb is the one that will generate invoices and ordertickets and so on. The structure is: VENUE (keyA) -> GROUP (keyA) | (keyB) -> A…

• 1 reply
• 1.3k views

balooka

December 13, 201213 yr

Ignore Below - Just realised I didn't have a surname value present in the record I was testing it on so there was none to copy/past (Is working fine)- Doh!!! Simple scenario: Contacts table includes 'FirstName' and 'LastName' fields. Also has a field 'Invoice To'. I want to place a button next to the 'invoice To' field, which, when clicked, fills the field with 'FirstName'(space)'LastName' fields (ie like inserting two merge fields I guess, so it reads as "Bob Jones" in the 'Invoice To' field, where 'Bob' is from the 'FirstName' field, and 'Jones' is from the LastName field. It looks like the 'lookup' function only allows me to reference a diff…

• 7 replies
• 1.1k views

db_tragic

December 13, 201213 yr

With my upgrade from 8.5->12 Filemaker has gone bananas with the font/size/color of my tab labels at the tops of my layouts. SOme layouts are fine, some have mixed with some as they were originally and the others huge light blue text. Some have tiny black text.. All show the correct parameters as the original. Where could FM be getting these bizarre display ideas from? -jim lee

• 1 reply
• 755 views

Lee Smith

December 13, 201213 yr

I have a database with thousand of records. The users are held in a value list called userID. I user this script to assign records to users. Go to layout [ "Data" (Main data)] Enter find mode [ ] Set field [ Main Data::Assigned_to "=" ] Set error capture [ On ] Perform find [ ] If [ not Get ( FoundCount ) ] Go to layout [ original layout ] Show custom dialog [ "no unassigned leads found" ] Exit script End if #. Records found so loop them Set variable [ $list ; ValueListItems ( Get ( FileName ) ; "userID" ) ] Set variable [ $count ; ValueCount ( $list ) ] Loop Set variable [ $num ; Case ( not $num or $num >= $count ; 1 ; $num + 1 Set field [ Main Data::Assigned…

• 3 replies
• 1.2k views

Pavlk

December 12, 201213 yr

Is it possbile to create a layout for an eCourse with FileMaker Pro 12 Advanced. I am looking at presenting the material and then have the user answer questions and get feedback. I also what to be able to input a video. Thank you.

• 2 replies
• 867 views

TaiChi56

December 11, 201213 yr

I have a FileMaker database that is formatted as dd/mm/yyyy as default. Any New date field I put on a layout, I have to format each one to mm/dd/yyyy. This is a pain in the butt! Any computer I try it on, it dose the same thing. How do I fix this problem?

• 2 replies
• 2k views

Lee Smith

December 11, 201213 yr

Hi all, I am trying to populate a portal with all the items that are used in an installation. If I perform a find in the portal on the installation number I am only getting the first portal row. How do I get this right.

• 14 replies
• 1.5k views

Oyseka

December 10, 201213 yr

When rolling over text in a text box black text/ lite blue background ... I can hardly see the highlighted area.. is a faint pink Can i make it more pronounced? TIA

• 2 replies
• 710 views

RodM

December 10, 201213 yr

I'm coming up with questions on an hourly basis it seems...I've done google searches and still can't seem to find answers, but sometimes asking the right question is the hardest chore. Â Ok, I want to have an concession stand customer ordering system and this made sense "to me" in my graphical way of thinking, HA!: Â I have layouts for each step, such as... Â [step 1] "Select order type..." (OrderTYPE is a field with Value List to choose from via radio buttons: Walk-Up, Delivery, Pick-Up). Â I then made a 'NEXT' button that I thought I'd send to the corresponding Layout calculated by the choice selected---let's say [step 2: Walk-Up], [step 2: Delivery], [step 2:…

• 1 reply
• 1.5k views

rivet

December 10, 201213 yr

Hi guys, hope you can help and point me in the right direction, ive been using filemaker for a few years but never created anything. well now its time for me to create a little print management system. Basically i have started creating a contact detail page which is fine, saves nice and lists them out lovely. But what i want to do is add a button by each contact and if they bring a new job (which they do) i want to click on that button and it open up my job bag layout which ive created and it fill in all the relevant details. now this may seem really easy to you guys, but i am struggling. I thought i would pick this up really easy as ive coded visual basic and director…

• 3 replies
• 1k views

DaveHunt1979

December 7, 201213 yr

I'm wondering if someone can tell me if what I want to do is possible and point me in the right direction. I'm creating a list style report of postal information with six fields. I want to create a sub summary with the total of the numeric values 6th field when grouped by the 4th field. However, I only want the subsummary to appear when there is actually more than one field to total up. Most lines of the report will look like this: Job State Zip CRRT Week Count XYZ NJ 07891 C001 1 50 XYZ NJ 07891 C002 1 50 XYZ NJ 07891 C003 1 75 However, there will be places where the CRRT r…

• 1 reply
• 708 views

Lee Smith

December 7, 201213 yr

Hi, I have to write articles that are 350 words in length. My "default" word counter is MS Word so I have to copy and paste what I'm writing into Word to get the current word count. Does FMPro have a word count feature? How do I set it up? Want to say I've had lots of help on this forum and want to thank you ahead of time! David

• 4 replies
• 1.8k views

Raybaudi

December 6, 201213 yr

How can I put a header in portal view ? or at least have that functionality….? Thanks...

• 1 reply
• 1.1k views

LaRetta

December 6, 201213 yr

I have a table of over 10,000 health codes that I'd like the user to select from but I'd like to limit the list to the most relevant ones. I've added a field in the table called "relevant" and I'd like to display all values with this field set to "Yes" When the user selects one of the codes it should populate a portal row. I know how to do it easily in MSAccess but I've tried using a multi-predicate selection in FMP12 without any success. Have any ideas? Brian

• 3 replies
• 2.7k views

bkhackett

December 5, 201213 yr

I have an unusual request - to stop people from entering the 3rd line into the address text field (they should be able to enter one line or two lines but not the 3rd line and not the gap). However hard i try, i could not figure out how to do this. This is an address field without town, county and postcode, which are in the separate fields. Users should be able to put unlimited number of characters in the first line, press enter/return, than put what ever number of characters in the second line and THAT SHOULD BE IT. They should be restricted from putting anything in the 3rd line of that particular text field. Thanks

• • 
• 4 replies
• 2.5k views

milanm

December 5, 201213 yr

In my FM 12 ADv app I have a button that opens a window that has the Web Viewer in it. In WV there is a simple https: URL. I do my development on my Mac. When I run the script that opens the Window and URL on the Mac everything is fast and as it should be. When I copy the same app to my Windows 7 PC it takes f o r e v e r ......................45+ seconds .................... to load. I turn on the progress bar and can see it slooooooooooooowly creep across the bottom. In both apps I am using FireFox... If I change the URL to http://www.filemaker.com it runs as expected. Is it the httpS that is the problem? If so, how do I work around this 'featu…

• 1 reply
• 2k views

milanm

December 5, 201213 yr

Hopefully a simple one here - but not 'intuitive' to me as yet. As the title suggests, a layout contains client info, which includes a LastName field, and FirstName field. I want to bring the two fields together in the header to display the client's first and last name, without the extra spacing in the fields. Cheers, Chris

• 4 replies
• 748 views

Lee Smith

December 4, 201213 yr

Have a database with 3 main tables: 1. Horse owner 2. Horse details 3. Visit Notes As one owner may have several horses, I have set up a simple portal on the Horse Owner layout which shows the 'Horse Name', and 'Date Last Modified' fields from the related Horse Details table. Obviously for a new client, the portal window is blank (no horse/s recorded yet). I want to put a simple button in the Horse Owner layout that switches to the Horse Details layout, with a new record created and ready to fill in - and related to the currently open Horse Owner. I'm not sure on the correct button set-up details to make this happen. Thanks in advance Chris

• • 
• 9 replies
• 1.7k views

db_tragic

December 4, 201213 yr

Hello, Newbie here...please bear with! Not sure what I'm missing but I have created a new address layout. Here's the problem, I don't know how to get diff fields from the same record to display. John Smith has an address, but wife Mary wants stuff sent to her business address, and I want both to display like so: John Smith 1234 Acorn Street Candycane NE 98765 Maria Smith 3232 Molasses Dr. Lolipop NE 98743 Juan Black 9090 Sugar Lane Carmel WY 80012 Leslie Black 4444 Okra Dr. Grain Fed WY 80013 Right now I am only getting repetitive info...John's info twice: John Smith 1234 Acorn Street Candycane NE 98765 John S…

• 1 reply
• 665 views

doughemi

December 2, 201213 yr

How can I select all fields in a layout and make them say 20 pixels deep not the 16 to 17 they currently are ? and also distribute them correctly, the database I am working on seems to pull them off the page when I try to distribute the space between them automatically...

• • 
• 4 replies
• 872 views

Lee Smith

December 2, 201213 yr

I new to this web scraping. This is my first time. I have looked at many examples and I can not see what is wrong. I always get a failure. Can someone please tell me what I am doing wrong. It does not seem to matter what web page I scrape of what tag I am looking for. If I go to "Chrome" I can see the source all ok. I am suspecting it is something external from the code .... Set Web Viewer [ Object Name: "source"; URL: "http://www.filemaker.com" ] # Loop Pause/Resume Script [ Duration (seconds): 1 ] Set Variable [ $html; Value:GetLayoutObjectAttribute("source";"content") ] Set Variable [ $elapsed; Value:Get(CurrentTimeStamp) - $start ] Exit Loop If [ Patt…

• 4 replies
• 1.8k views

comment

December 2, 201213 yr

I am working in FM pro 11 advanced. i have a layout using Monotype Corsiva, but it is printing in something like Arial. It looks correct in Preview, and the sizes and spacing are correct. Why is this happening, and what can i do to correct it?

• 1 reply
• 3k views

Matthew F

December 2, 201213 yr

I have a portal that lists the number of steps in a process. I want, when you first select the portal, for it to populate Step # with 1. And then when going to the next line, Step # = 2. I've tried messing around with an auto enter calculation, but cannot seem to get it to trigger.

• • 
• 11 replies
• 1.7k views

LaRetta

December 2, 201213 yr

I have a portal sorted by a field 'Vendor Name' This field is text, but sometimes contains numbers, eg: Vendor 1. When I sort by this field in my portal all vendors that contain a number appear at the top of the portal, instead of under the appropriate letter. Is there a way to fix this? Cheers!

• 3 replies
• 938 views

LaRetta

December 1, 201213 yr

I am trying to run a list report and have it as layout and created a script for it. It is all based on info from my "clients" table. When setting it up i put to sort by sale date however it does not sort. It is a random order. When i am in the layout i try the sort tool by that particular date field and change from descending to ascending order it moves them around but in no particular oder. I can't even make sense of what it is trying to do. I can sort by other fields. Any ideas of what might be wrong with the field. The field is an automatic field that puts the date in when the record is created and shows the date as 17, November 2012

• 3 replies
• 935 views

Lee Smith

November 30, 201213 yr

Hello gentlemen and lady-types, Not sure if this is the appropriate place to put this since Im sure what Im trying to do can be done in every version of Filemaker, but we will start here. Basically why I became a member here was to have my work critiqued by more experienced users than myself and hopefully find a way to collect a running total field based on some known information. I have a working database set up in the way I think we will need it. Not sure if I can attach it to this post so I will wait until told to do so. My problem: I have a field set up for "Part Number". I would like to have a "Quantity" field that will total up all of the entries wit…

• 5 replies
• 1.1k views

bcooney

November 30, 201213 yr

I have two tables Company & Parts. I have a one to many relationship from company::companyID -----< parts:companyID I want the user to be able to select a company from a drop down when they use the Filemaker New Record button from the toolbar. I can only see the current value list I have created if I have the customerID filled in manually, otherwise the drop down doesn't display any of the companies so the user can make a selection. Any help would be great. TIA, Nate

• 2 replies
• 2.2k views

natemclain

November 30, 201213 yr

Hi there!! Lets see if my english allows me to explain my problem in a proper way!! I have a "list view" layout, where I have three parts: Header, a Sub-summary by Sku (sku= product unique id), and a Trailling Grand Summary (I only use this part to place a footer image basically). No body part, because I only want to show the total quantity and total money that has been sold of a products list. Here I paste a pic of the layout view Im talking about: Well, the problem comes when I show this layout on browse mode. I dont know why it places an undesirable space between the Header part and the Sub-summary part. Here I paste a pic that shows the p…

• 4 replies
• 1.8k views

Pamps

November 29, 201213 yr