FileMaker Interface Features

Hi Folks, I'm very beginner on this platform, and may is a stupid question, but I tried to search post about this problem with nothing found I have a simple dropdown list that retrieve values from related table ( CatID ; CatName) , when go to layout mode I see only the CatID value and not CatName value What's is wrong ? Thanks in Advance

• 3 replies
• 1.3k views

gildob

February 13, 201511 yr

Hi, My client has sent me a 52 page PDF form of which quite a number of pages will be the basis of a report that comes from the Filemaker solution. Rather than manually create 52 pages in a new layout, is there a tool or method by which I can import these pages? Its mostly just text - I'm happy enough to tidy a few (display) tables and shading etc. Thanks in advance. Greg

• 4 replies
• 1.3k views

Greg Hains

February 13, 201511 yr

I'm really new to filemaker and still getting to grips with how it all works. I have been following the Filemaker Pro13 Userguide as well as online tutorials, and am stuck with portals. I appear to have followed all the steps correctly but although my portal fields appear in the edit layout mode, when I close edit layout, no data appears in the portal. I have checked my relationships which all seem to be in order. Can anyone help to point me in the right direction please?

• 2 replies
• 1.3k views

Rick Whitelaw

February 12, 201511 yr

I am conditionally formatting some field objects to change color based on a calculation. The color picker available in filemaker is far too intense for my purpose. I sometimes change the color by changing the opacity level of the fill pattern but this is still not exactly what I want. Is there a way to call out the color using hexadecimal values?

• 5 replies
• 1.7k views

Jarvis

February 11, 201511 yr

Sorry for such a basic question, but we recently upgraded from FMP9 to FMP13. Existing databases were converted. I need to modify tooltips...but apparently it has changed drastically (at least for me) with FMP Advanced 13. Silly question? How do you edit existing tooltips? I can't find the option ANYWHERE. The FMP advanced manual provides no guidance and just a vague statement that you can edit tooltips. I've been able to "show" which fields have tooltips, but nothing else. Right mouse clicking, looking in layout, format, etc., menu options doesn't show anything. Inspector doesn't show any options. Thank you!

• • 
• 4 replies
• 1.2k views

MikeKD

February 10, 201511 yr

Hey Guys, Does anyone know if its possible to insert predefined tags in a web viewer. I've got a web viewer which allows the user to enter in content, however I also have a set of FileMaker buttons with certain keywords which I want the user to click on and the text on the button gets transferred to the web viewer, where ever the cursor was. Thanks as always Jalz

• 1 reply
• 1.3k views

comment

February 10, 201511 yr

Can somebody help me with decision of one problem? - Â I have data in different tables with different dates, but i need to place them all in one layout like a map. So 2009 year - it's first column, 2010 year - it's second column, 2011 year -it's third column and so on. So as you understand i can't do this with List View, because all dates come under each other, not left to right. Â Â

• • 
• 16 replies
• 7k views

Lee Smith

February 9, 201511 yr

Every now and then, upon going into Layout Mode and back to Browse Mode, all layout objects revert to the Default Style of the Layout Theme. The overall theme and other layouts remain unaffected. What might be causing this? I have never had this issue when using FileMaker 13 Advanced on a Mac. It happened consistently when using FileMaker 12 Advanced on a PC, so I assumed the issue was with using Filemaker 12 on layouts that were mostly made in 13... but today it happened a few times when using FileMaker 13 Advanced on a PC. The database is using a custom theme, similar to the built-theme called Enlightened. Its happened on a variety of layouts.

• 2 replies
• 4.8k views

Lee Smith

February 7, 201511 yr

Hello Friends While working in list view I found that header pane freezes on scrolling window bar but in form view it does not freezes the header pane. It there any setting to do to freeze header pane in form view also. Thanks

• 2 replies
• 1.3k views

Rick Whitelaw

February 6, 201511 yr

I'm at a complete loss. Â Really simple... custom menu set, custom 'edit' menu - see attached. Â If I insert the Paste command, or Paste without style command into the menu, it's dimmed... can not be used. Â Cut and Copy work fine... can't paste. Â I can't see any reason why this is the case... it's gotta be something simple? Â To test... I put the "Omit Record" command in the menu - that works fine. Â So it's just paste commands.

• 3 replies
• 4.9k views

truelifeajf

February 6, 201511 yr

I need help here When i use the open url function I get "https://www.google.com/?gws_rd=ssl#q=%28850%29%20484-8802"  Which converts in google to the page I want But when I try to use the same script to open in the webviewer I get a different page.  I have included both images  How can I correct this? I need the same exact page to come up in the webviewer. Thank you

• 2 replies
• 1.5k views

hownow

February 4, 201511 yr

I am working on a patient record DB. Â To simplify text entry, I have a related Template table with fields displayed by a portal. Â This relationship is global with: Â Pt Record::key('1') ---->Template::key('1') Â I want to provide the ability to quickly move blocks of text from a history text field to the Template text field to create a new template. Â To do this, I have a popover that contains a portal to the Template table. Â I hoped to be able to simply copy text, open the popover to a new Template record in the portal, Â paste text, close and move on, Â but I could not get this to work. Â Thinking that it was a problem with the relationship, I created a s…

• 0 replies
• 1.5k views

DoctorB

February 3, 201511 yr

Hi All, Am I going crazy or is there no way to sort data displayed on a popup menu? I have a popup menu that takes its data from a value list. The value list looks at a table in my FM solution and uses the ID field, also displays from the name field and has "show only values from second field" checked. This gives me a great list. However, my client has asked for custom ordering - we have a new field in the table called "display order", my clients will go in and give each record in the table a numeric value and then want the popup list ordered by that rather than the default ordering. Is this possible?! Many thanks

• 2 replies
• 3.6k views

MartieH

February 2, 201511 yr

Hi, I've got two table Staff and stafftype (which are linked via a relationship on StaffType) with which I've created a value list so that a staff memebr can be chosen on a layout through a drop down box. My stafftype table tell me whether the member of staff is a teacher, TA or support staff. Currently my value list is displaying all staff in the staff table. How do I make it conditional so that it will only show Teachers or TA's? I will end up creating a number of lists to show each type seperately due to how they need to be used in the layouts. Thanks Ann

• • 
• 8 replies
• 2.9k views

MikeKD

February 1, 201511 yr

Hi folks, On my class layout (class table), I have a portal of that classes assessments (assessment join table), and when I select one the pupils (Pupils table) all come up so I can give them their marks, notes and attendance. This all works very well indeed (mainly because of the help you guys have given me!) One of the fields on the portal is a sort number (from a pupil_class_assessment_join table). I use this to put the kids into the groups they're working in. At the moment I do this by hand, just typing in the numbers. It would be great to automate this sometimes. I'd like to have a popup giving me the option run various scripts: Allocate numbers…

• 6 replies
• 1.3k views

MikeKD

January 31, 201511 yr

Hi I have lines round some of the fields such as the characters field, but when you go to preview it fails to show any of the lines. I cannot see what is stopping it. I did a test of it on the layout All Units Copy 2 Any ideas or help is very very much appreciated. thanks fully working 2 copy.fmp12.zip

• 2 replies
• 852 views

littlered136

January 31, 201511 yr

Hi. I'm making a database for employees and as there are family members within the business, I want to break-up the names as follows... 1 - Prefix: [Mr Mrs Miss Ms] 2 - First_Name 3 - Second_Name 4 - Last_Name Then use a calculation field to bring them all together as so - [Prefix & " " & First_Name & " " & Second_Name & " " & Last_Name] Then when making new records for say something like 'Disciplinary Events'... wish to be able to choose an employee from a drop-down list. Obviously I do not want to use a values list for the drop-down made-up from either the First_Name or even the Last_name, as there are family employees within t…

• 11 replies
• 6.1k views

Karlos Fandango

January 31, 201511 yr

I am a newbie at Filemaker and one of my questions is, how do you get a layout to expand to fit the window? Thx

• • 
• 2 replies
• 961 views

wlewis

January 30, 201511 yr

I have a portal and it has a popover button. Â Inside the popover button is a container field. Â I'd like to "Insert a PDF" into this container but its "grayed" out ( see enclosed picture ). Â The container is set for "interactive" but for some reason I can't seem to insert a PDF and I don't know why it's grayed out. Â Â Also, in my enclosed picture I have inserted the Filemaker Go Development Guide BUT its not interactive and I can't scroll through any part of that PDF document. Â I have the latest version of Adobe Reader installed on my Mac but I just can't seem to get this to work. Â Anyone have any ideas I can try? Â I even recreated the popover button but I st…

• • 
• 5 replies
• 4.1k views

HALBURN

January 30, 201511 yr

I am new to using themes and styles. I have chosen the onyx theme for my new project. My issue I am having is for tab controls I put in the layout are not formatting when I change object attributes. I have set fill and line to no fill and no lines yet it still shows up with borders and a bar behind the tab selection area. I use transparent tab panels for a lot of user interface objectives and have wasted hours trying to figure out why it won't change when I make them in the inspector bar

• 4 replies
• 3.5k views

Trinity32244

January 29, 201511 yr

Hi, I set up a child table for "Notes" with Time stamps and used four different portals to bring them into the layout of my main table. For reasons that I cannot figure out the timestamp is not working correctly. I have tweaked the settings to no avail. After the first attempt, I decided that it must be related to the duplication of the time stamp for each notes field. So I set up independent time stamps for each field. I am starting to think that the problem may be that I can only have one time stamp per table. here is a screen shot of the layout. http://prntscr.com/5y5kcj and screen shot of table view. http://prntscr.com/5y5njr Thanks for advice

• 5 replies
• 2.7k views

Lee Smith

January 29, 201511 yr

I have searched and surprisingly can't find the answer to something that seems so simple. I am trying to change my fonts on the tab controls, but can't seem to change them for the inactive state. Anytime I try to select them even in layout mode it makes it active and only changes the active font. I have tried what seems to be every key combination when selecting them but nothing works. Any help is greatly appreciated.

• • 
• 3 replies
• 3.5k views

GManNAtl

January 29, 201511 yr

Hi,  I've been hired to modify a database that was built to archive the work of a visual artist. She has a number of works that are related to each other (studies for a piece, or variations on a work). The primary metadata for her works are stored in a table called "inventory", for which the unique ID (and match field) is titled inventory_id. I need to figure out a way to relate various works in the "inventory" table to each other. In order to do so, I created a table occurrence of "inventory" called "inventory_2", and then set up a join table between "inventory" and inventory_2" called "related_records" with these two fields:  inventory_id  Inventory_id_2  I then…

• 3 replies
• 1.6k views

comment

January 29, 201511 yr

I'm having one of those glitches where I think I'm going mad. I have a simple Script that runs on opening a file that takes the user to the main layout, and includes a "Show/Hide Toolbars [show]" step. it has always behaved as expected. I've just finished adding a bunch of layouts / features for an iPad Go interface, so I have the start up script sensing what platform we're on and going to the appropriate layout. This is one of the first things I did, and the start-up script behaved well throughout the first 3 iterations of my new design. (I save successive 'Builds' so I can go back to a previous milestone if I screw things up.) Now with the whole solution comp…

• 2 replies
• 1.4k views

Wickerman

January 29, 201511 yr

I have an employee table, where the employee has a status of "Active" or "Inactive". I'm trying to create a Value List of Active Employees that I can use anywhere within the database, in multiple tables. I though I could create a table "TableA" with a Calc Field "Static Active" = "Active" then create a relationship between TableA->Static Active with Employe Status. Then create a value list based on TableA. but that did not work. I end up with a blank dropdown box. In the same database, I have multiple tables that are going to need this value list. I originally created multiple instances of the Employee table and linked to each table. but that's multiple rela…

• • 
• 5 replies
• 1.7k views

Scott Pon

January 29, 201511 yr

Hi, I have run into a standstill here where maybe someone could point me in the right direction. This is for a large personal project that I have been working on for a few years. I have considered all the possibilities with FM and looked at add-ons, but this is the first time I think I cannot find an answer. I have used the Webviewer just to navigate through a website to get to a certain page to scrape. That works great. In this usage, I want to do more than just scrape. I want to load the page in FM (on the webviewer), take the "content" (client-side HTML), run it through a comparative analysis in FM, append text to it line-by-line, and then reload that back…

• 2 replies
• 3k views

MyBigFM9Project

January 27, 201511 yr

is it possible to move to a new tab panel without without the data entered in the first panel being commited.

• 4 replies
• 2.4k views

Oyseka

January 27, 201511 yr

I'm looking to create a popup that determines the choices in another popup. Example: At kbb.com, looking for car makes and models, if you choose Ford in the first popup, popup 2, to the right of popup 1, lists all Ford models. If you change popup 1 to Toyota, popup 2 becomes all Toyota models. Can anyone here please explain this process? Thank you in advance.

• 1 reply
• 1.7k views

Lee Smith

January 26, 201511 yr

Hi, I am struggling to achieve what I thought would be a simple button script. My company table's layout has a portal showing the related personnel through the field - "company_id" in the personnel table. It also has a popover with a second portal which I use to enter the details of the personnel for that company record. I would like the popover, when I open it through the popover button, to go to a new personnel record. I would also like the "edit personnel" button, which is positioned on each row, to open the same popover but go to that portal row. At first I had the popover open with a filter on the portal for If [isEmpty (Personnel::First)] whi…

• 10 replies
• 3.9k views

bcooney

January 25, 201511 yr

Hi.. I been using Filemaker 12 advance.. tweaking on the template Expense Report. The screens are fine.. I just update to Filemaker 13 Advance... Now running the same Expense Report.fmp12 app.. My screens are bigger, my fields are not aligned What is possibly going on? TIA

• 2 replies
• 1k views

RodM

January 24, 201511 yr

I have two tables: Table A and Table B. Table A contains information about a television program, whereas Table B contains the shot schedule for the program. Table B is represented in a portal row within Table A. I am having an issue calculating time. I have a field in Table A (total time scheduled) that uses the following calculation: Sum(Table B::duration) *unstored* Total Time Scheduled is formatted as time and Duration is formatted as text. The duration field in Table B needs a little flexibility so I have it as a text field (time wouldn't let me enter just seconds without zeros preceding the seconds). For example, if the shot is only thirty seconds, the user en…

• 2 replies
• 1k views

comment

January 23, 201511 yr

Hi folks, I've got a portal with a list of kids in the class. I've set up two conditional formatting to flag up kids who are a certain percent below their all time average or the class average. The conditional for the class average is below (the other conditional is identical with the references replaced. Pupils::ThisYrAssesmentAverage ≤ ( Classes::AssessmentAverage - Classes::UnderachievementValue) and Classes::CompareUnderachievment="Class Average" Enabling these conditionals seems to have a disproportionally huge impact on the performance of the portal - it takes seconds to load and sometimes quite a bit longer. Class sizes vary from 2 to 28. Performance is fi…

• • 
• 14 replies
• 1.5k views

Wim Decorte

January 23, 201511 yr

Hi: I'd like to preserve line offset formatting in FMP. For example, here's what I have in Word: 1. Four score and seven years ago A. Four score and seven years ago I. Four score and seven years ago a. Four score and seven years ago b. Four score and seven years ago B. Four score and seven years ago I. Four score and seven years ago a. Four score and seven years ago i. Four score and seven years ago b. Four score and seven years ago i. Four score and seven years ago ii. Four score and seven years ago And here'…

• • 
• 18 replies
• 2.3k views

comment

January 23, 201511 yr

I can locate and edit the submenu name but how do I edit the items that are in the submenu? For example, how could I remove the keyboard shortcut for "Find Again" which is in the Find/Replace submenu?

• 2 replies
• 5k views

Rick Whitelaw

January 22, 201511 yr

In my database I have a couple fields that have currency information and I am only able to make one field per section have the $ sign show up when you look at the fields. I created the fields then used Inspector to select "currency" under Data Formatting to make the number show up with dollar signs but I can't get the dollar signs in all of the fields. Attached is a screen grab. Â Right now the Teaching Rate field on the section of the left shows up with a dollar sign and then Total Salary & Stipend Cost shows up with a dollar sign. I need all the fields related to rates and costs in these sections to show up with dollar signs. When I go to change the fields in Ins…

• 2 replies
• 992 views

InsideOut

January 22, 201511 yr

Hi all. What I want is to hide some text I placed in the footer unless I'm in a certain tab. I see a "hide control" property , but I can't figure out how to construct the command or script to put into it... Any hints? best, Andre

• • 
• 5 replies
• 3.7k views

avallejo

January 21, 201511 yr

I'm confused about the meaning of the script step Adjust Window [Resize to fit]. The official Filemaker definition is that it "resizes the window to the minimum size possible while keeping all items in the layout visible." I have many layouts that each show a different portal, and I have a button for each such layout that opens a window with the layout in it. I'd like the window to have no unnecessary space around the portal. Right now I keep global variables for the width and height of each layout (adding in a buffer below the portal and to the right). When the button is clicked, the window is sized according to the global variables. However, whenever I change the l…

• • 
• 8 replies
• 8k views

Lee Smith

January 21, 201511 yr

I think this is a simple question but I haven't been able to find an answer. When I am growing the entries in a drop-down list, the highlight colour is a deep blue making it difficult to read the text on the list. How can you change this? I've checked the Inspector options and researched on the web but can't find an answer. Thanks in advance. Tony

• 13 replies
• 6.9k views

derlandson

January 21, 201511 yr

If i have a checkbox field. How can i make a script that goes through the checkbox selections and creates a new record for each selection i choose. Example Checkbox field... A B C If I check A and C I want to have a script that goes to a new table and creates a new record for each selection New Table Record A Record C Thanks again for the help!

• • 
• 11 replies
• 4.8k views

MikeKD

January 21, 201511 yr

I have 2 tables. 1 table is a list of products 2nd table is a list of expense reports The goal is to assign a product to each expense report. For example if i have an expense report that was to buy medicine i want to assign the product "Healthcare" to that expense report and have it saved as a unique record in a new table. However sometimes I have an expense report that is for two or more different products. So again for example i may have an expense report that was for buying medicine and also two pairs of shoes. In this case the products that should be assigned to this expense report would be "healthcare" and "clothing". However i want this expe…

• 1 reply
• 1.2k views

Fitch

January 20, 201511 yr

Hello - I just noticed portals (and empty containers) don't slide if inside a Tab or Sliding panel control. Are there any workarounds? Thanks Kindly

• 1 reply
• 1.4k views

bcooney

January 20, 201511 yr

Not sure where to put this so please excuse if wrong. I am frustrated by programs which put a picture of the shortcut keys but do not explain what those little pictures mean. My latest frustration is for Status Toolbar. I know what the flower means because it is 'command' but what is the backslash with the dash thingy? Is there anywhere that shows shortcuts to ease my frustration? Thank you.

• • 
• 12 replies
• 1.5k views

mikedr

January 17, 201511 yr

Hi, I have a database that is using portals for item number entries for a job. I am looking for a way to look for duplicate item number in the portal field across multiple records. Using below as conditional formatting works but only per record ValueCount ( FilterValues ( List ( Child::Category ) ; Self ) ) > 1 How can i make it work across all the records? Do i need to use a script trigger instead?

• 3 replies
• 1.4k views

comment

January 16, 201511 yr

Hello, A topic about this was started last May, but I did not find an answer to my question, which is: in table view, how do I (or can I) add some space between the top of the letters and the upper boundary of the cell (so that the letters aren't touching it)? Thanks, novice/newby,

• 2 replies
• 890 views

chrislz

January 16, 201511 yr

Hi,  I have created an interface with a tab control panel. On my computer it looks like the DeveloperPC image. However, if my customers opens the file on his computer he sees the customerPC image. In other words he does not see the tabs on his screen. When he changes the zoom level to 150% the tabs appear. Any idea what can cause this behaviour??  Thanks,  Joost Kingma Â

• 3 replies
• 3.7k views

dataclip

January 15, 201511 yr

I have a DB where i use buttons in a portal to go to other layouts I do it with past and copy script to like the different database but i don't like it. Is it possible to do it with relations ? The example will give a better idee. some suggestions would be great PHD.fmp12 2.zip

• 1 reply
• 739 views

Aussie John

January 15, 201511 yr

Using Filemaker menu Loging in as Guest Runtime compiled version using FM12 I am forgetting something? Why can't i focus a field and use copy paste features.. Guest has full editing privileges Using Filemakers Expense Report Template thanks from rod

• 2 replies
• 1k views

RodM

January 14, 201511 yr

HI there, Â I'm trying to finish my invoice layout page. What I would like to be able to do is click a popover button to add an artwork (or artworks) to an invoice. I need to be able to list as many as necessary. Â I have managed to get the invoice addressee working fine, which is a similar idea but not a list - just a single field, so a bit more straightforward. Â I either need help with the relationships, or a script.. or somewhere it is going wrong.. I'll attach a series of screenshots rather than trying to explain more. Â At the moment my button goes to my invoice data layout but and asks me to save changes, and generally doesn't work.. I understand for a …

• 8 replies
• 1.8k views

ADJUDD1402

January 13, 201511 yr

HI all, I have a table called "locations". That table has an (int) ID (string) Location Name and (int) valid. I am using that table as the basis for a couple of popup menu "values from" lists. I can't see anywhere in FM the option to create a custom value list. What I need to do is for one of the popup menus, only include values where the valid field = 1. in SQL terms it would be select * from locations where valid = 1. Other popup lists on there will need all of the rows, regardless of their valid setting. As far as I can see, there is only the ability to include ALL rows of a table or a custom list of hard-typed values. Many thanks

• 3 replies
• 1.4k views

bruceiow

January 12, 201511 yr

I'm having difficulty replicating some of the features provided by the supplied themes, particularly the Enlightened theme and drop down lists. Each state of the drop down (normal, hover, pressed, in focus) can of course have an independent set of display characteristics, however I notice that the enlightened theme drop downs also show the arrow background as a different colour to the field entry area. It's very subtle, but the drop down arrow goes white in hover mode, whereas all other modes are a very pale grey. When I chose a graphic as a fill object then it highlighted this even more. What I cannot understand is: 1. Why I cannot create the same effect with…

• • 
• 39 replies
• 17.5k views

HALBURN

January 11, 201511 yr

Hi Guys, I'm sure this must be fairly simple, but I am a FM noob. I have a layout which includes a date field and a portal of related records. What I would like to do is have two date pickers in the header of my layout - one for a FROM date and one for a TO date. I would like to then only show records that fall between those two dates. How would that be possible please?

• 4 replies
• 1.5k views

doughemi

January 10, 201511 yr

I have a DB for entering medical test results. Each patient has about 100 tests in five categories. To make data entry easier, I have a self-relating portal displaying the tests fields filtered by the five categories . A drop down menu with the list of test categories and script trigger sets the portal to display only tests in a category. If all results for a test category are the same , I want to to auto-enter the value chosen from a drop-down menu using a script trigger. The script loops through the visible portal setting the test-value in the result field if the test category matches the corresponding variable. This all works well enough but I ca…

• • 
• 7 replies
• 1.7k views

bmill

January 10, 201511 yr

I have a pesky problem with trying to implement popovers to replace some older picker popups. I have created a popover, and attached an OnObjectEnter script trigger and an OnObjectExit script trigger (to the popover itself, not the button). The OnObjectEnter script sets some variables to prepare the popover for portal data selection. This works fine. The OnObjectExit script trigger clears the variables. I have a Cancel button on the popover that executes Close Popover command, which triggers the OnObjectExit script trigger to clear variables. This works fine. The problem is when you click the popover button itself again. I've noted the default behavior…

• • 
• 8 replies
• 8.8k views

eos

January 9, 201511 yr

We have a matter table and a correspondence table. Each matter record can be associated with multiple correspondence records, related by matter number. Each correspondence record has a correspondence name and a date. On the main layout for the matter table, I would like to show the most recent correspondence record for the currently viewed matter, in uneditable fashion. What I'm doing now is putting a portal on the layout, with a single row and without scroll arrows. The portal is defined to show related records from the correspondence table, sorted in descending order by date (such that the most recent related record is displayed). This does indeed work gr…

• 6 replies
• 1.8k views

mikedr

January 9, 201511 yr

I am looking to develop the correct technique for building out a report from data. Normally this would be easy since all of my data is controlled by me in that I build the tables and fields. In this case I need to pull records from another database system so all of the data will be pulled into one table. This table will also contain data from the year before it which will also need to be compared. What I am asking is what is the best way to attack this data. I guess the first step is to explain the data. It basically consists: sales_person_id customer_id order_entered_amount order_paid_amount transaction_date I will have one line for each order entered and eac…

• 2 replies
• 1.2k views

Kris M

January 8, 201511 yr

Hi Everyone, I have an animated GIF (spinner icon) in a web viewer that I display while running a script to show the system is busy. One of the script steps inserts a file as a reference. This step takes about 5 to 10 seconds to complete. I have noticed that if the file path uses an address with a mapped drive it is much quicker than a UNC address, unfortunately I need to use a UNC file path. When the script gets to the insert file as reference it stops the animated gif and causes the web viewer to go blank until the insert file step completes. Any ideas on a fix to keep the GIF animated while the insert file as reference completes or any other solutions? Thanks f…

• 1 reply
• 4.4k views

Matt_

January 8, 201511 yr

Hi All, I have a table called "Claims", there is a related table called "nameLink" and table related to that called "name". So there is one claim to many namelinks (claim.claimId to namelink.claimId). Then nameLink.nameId to name.nameId. So the situation is that I have many names to one claim. Currently I have a layout that has claim as my primary table. I have a portal on that layout that brings in all related nameLink rows. The portal has one popup menu, which has data displayed from namelink.nameid, and its values from names table (storing the id, but displaying the name.name field). This works great, I get a popup showing all the names in the name…

• 3 replies
• 1.5k views

Ocean West

January 7, 201511 yr

Is there anyway to suppress a layout when printing so it is not displayed? I have a menu that drops down to print several reports, essentially the script for the reports does the following Go to Layout["JPF_printitems1"(Locator)] Sort Records -Restore;No Dialog] Print [] Go to Layout ["JPF_printreports" (Locator)] The report does go to the layout but the user does not need to see the layout, I would prefer to simply "Show Custom Dialog" + with dialog message like "Please while printing" and have it print with no dialog which is easily done, but I don't seem to find a way to prevent the layout with fields from showing on screen, if possible. Just looking for …

• • 
• 2 replies
• 961 views

Lee Smith

January 6, 201511 yr

Hi i wonder if anyone can help me... I'm looking for a booking calendar year planner which can be used with filemaker pro i run a small holiday property business There are 30 properties and the objective of the business is to ensure each property receives holiday bookings. To show the bookings for each property I have been using a year planner onto which i can show how many bookings each property has and which dates are involved for each booking The year planner software i used to achieve this i was actually part of the basic software which was included with the old psion 5mx handheld pda - it's incredible that such an old piece of kit had such …

• 7 replies
• 2.9k views

databaseforumjt

January 6, 201511 yr

I have a master portal that lists an abundant of information. I then want to, based on that master portal, make a selection and transfer or link info into another layout. This same information from the master portal will get used in a variety of different records. Also the information that is transferred or linked to may change Can someone offer the best direction to tackle this as I am not sure how to get there. Looking just to be pointed in the right direction.

• 4 replies
• 1.5k views

MikeKD

January 5, 201511 yr

I created a portal that is based on a company table related to a Estimate_Line Item table. To this I have two related fields: parent client key = ::child client key and check box options= vendor (which is a calculation field="vendor) It currently tells me when I click in the portal on my company table that this action cannot be performed because this field is not modifiable. The portal is based on the Estimate_Line Item table and all fields located in it are from that table as well. Any help appreciated.

• 5 replies
• 2.4k views

LaRetta

January 5, 201511 yr

I appear to be lost in FM13. All I want to do is format my number field as a price with dollar sign and two decimal points but I cannot find the listing in the drop down. Does it not exist in FM13? Any help appreciated. Thanks in advance.

• • 
• 3 replies
• 1.8k views

Ocean West

January 5, 201511 yr

I am trying to freeze a certain portion of my record template so it stays in place while I scroll through the rest of the layout much like freezing columns/rows in Excel for convenient reference. In essence, I want to make sure I can still see things like the patient name/date of entry when I scroll down on the layout. Any suggestions?

• 4 replies
• 7.7k views

comment

January 4, 201511 yr

I want to highlight all overdue invoices in my database with conditional formating. Currently the conditional formating created works but it works for all records. I want it to work for just records with the "P_Status = Complete/invoice" I am thinking I need an if statement inside an if statement but cannot seem to get it to work. any help appreciated. Thanks in advance.

• • 
• 8 replies
• 1.5k views

LaRetta

January 2, 201511 yr

I know that I can control whether or not a popover instantly appears or "pops" up by using the script step "set script animation" on or off. This works great when the popover is being triggered by a script but is it possible to turn off the animation when it's being opened by a popover button?

• 3 replies
• 2.8k views

mikedr

January 2, 201511 yr

Hi, I am hiding an object (image) conditionally in FMP 12 adv. (making the fill color transparant). As far as I know in FMP 12 the only way to do this is to make the object a button. Than I have to assign a script step to the button otherwise it will not accept conditional formatting (stays grayed out). I do not want the button (object) to do anything. What is the lightest script step to perform ?? (exit script (no script running), goto object [ ] ) When I assign the 'Do Nothing' script step from scratch to the button the conditional formatting option stays grayed out. But when I alter it afterwards from f.i. 'Goto Object' to 'Do Nothing' conditional formatting …

• 2 replies
• 1.6k views

Fitch

December 31, 201411 yr

Lets say: T1: customers T2: invoices In the customers layout I have a portal in a popover showing their respcetive invoices (ones paid, others unpaid). What I want to accomplish is (using conditional format for example), to show a tag about the state of the invoices, but only works for the state of the first row. Is it posible to do it for all the rows? I mean, someting like: all paid, none paid, or SOME paid (if there are a few paid but other few not). Thanks for your help. I attach a sample file to show what I'm trying to explain. DB.zip

• 3 replies
• 1.8k views

Enigma20xx

December 31, 201411 yr

I'm using a "does nothing" button as a status indicator. Basically, if the value of a given related record field is zero, the button is hidden, and if the value is one, the button is not hidden. I specify this under "Hide object when" under the button's behavior. I noticed that when I browse to a particular record in the layout, the button displays OK. However, if I change the value of the related record field, the button does not automatically change state. I.e., if the value is 0, and I change it to 1, the button does not display automatically, and similarly, if the value is 1 and I change it to 0, the button does not hide automatically. If I browse to a dif…

• 1 reply
• 1.1k views

mikedr

December 30, 201411 yr

I have a listing in table view and want to have a button attached to the line items so I can go directly to a particular line item in a different layout. Is this possible? Thanks in advance

• • 
• 2 replies
• 2.3k views

The Missing Man

December 30, 201411 yr

Hi all, I'm using a single CSS theme for all layouts in a given file. I'd like to know if there's a quick way to identify any styles in that theme that aren't being used anywhere in the file. Thanks in advance! -Kent

• • 
• 10 replies
• 3.9k views

Kent Searight

December 29, 201411 yr

> Version = FM12 Pro Advanced I'm having problems figuring out why objects won't slide up for me. I'm working on a new application for the office to do employment documents. To provide more flexibility I'll have to have some merged paragraphs meaning the letter closing needs to slide up based on the object above. Doesn't seem to be working for me. In the sample file attached there are two layouts, one with the closing (text & sig graphic grouped) and the other with them ungrouped. Neither changes how the objects slide. Any advice? >>>> Sample.ZIP

• • 
• 2 replies
• 1.3k views

Mark_MC

December 28, 201411 yr

I have a purchase order layout containing project name, purchase order number and date.This layout contains a Portal showing 'Category' 'Description' 'Quantity Purchased' 'Unit Price' ' Total Price' and 'Units Used' Where I enter line items off the purchase order. The 'Category' field is a drop down list based on the values placed in that field. The 'Description' field is selected from a 'Conditional List' from the 'Category' field. i.e. Category 'Timber' Description '4x2', '4x4', etc. I show all this on a report with two sub summaries for 'Category' and 'Description. I have deleted the 'Body' part and in the second sub summary (Description) part I have Summary fiel…

• 4 replies
• 1.4k views

BadgerBlu

December 27, 201411 yr

I think I have early Alzheimers. I used to know this but now I don't... go figure At the bottom left corner of my layout is: 100 - + StatusBare Browse/Find etc.. Question: "How do i make this are 'nonfunctioning' or invisible to the user? Thanks

• • 
• 4 replies
• 1.5k views

ron G

December 27, 201411 yr

I have switched to using transactions for the situation described below, and I am finding it impossible to maintain the full functionality that I had when I used to modify the children of a parent using multiple layouts, temporary records, and non-simultaneous commits. Each workshop (parent) in my database consists of, among other things, team members (children). Team members can be assigned or unassigned. (So, too, can workshops, though this isn't all that relevant to this problem.) The user can choose to view and operate on workshops (maintained as a list view) in either an assigned mode or an unassigned mode. There is a global variable (let's call it ShowAssigned) …

• 8 replies
• 1.2k views

jjjjp

December 27, 201411 yr

I'm hoping someone else has seen this. When FM 12 first came out I watched every video I could find about it. I recall seeing in one of them the demonstrator copy a layout object, go to a different layout and paste the object in place. He even commented on how nice it was that FM 12 included this paste in place feature. Since then I have rewatched many of the videos trying to find where I had seen it but with no luck. Was I just dreaming or is there now a way to paste in place rather than have to make note of the position and type it in in the new layout every time?

• 7 replies
• 4k views

HALBURN

December 27, 201411 yr

Hi, this is for FMP 12 (not 13) I need to populate a field with the content of the web viewer (without copy and paste). Any way of doing this? please see attached file … thanks! Oops … the file attached here. md5.fmp12.zip

• • 
• 4 replies
• 2.3k views

TJ53

December 27, 201411 yr

I am using a modified Filemakers Expense Report Template for my own changing it some The report expense details page layout is forward, on the top right is a report button that show expenses reported bring up another new window stepping through the lines of code.. When I click report, it minimizes my Expense Report Layout and showing the preview of the report expense... then forcing me to maximizes report Expense Layout to continue I found, If I then drag the edge of my report expense layout maximizing it.... now clicking on report button leaves the expense report layout maximized How to i keep my layout max Hope that explanation suffices or i need …

• 1 reply
• 914 views

Steve Martino

December 26, 201411 yr

I'd like to keep the user on the currently selected tab even when the user leaves for another record. I have a script that identifies the currently active tab and another that restores that tab state. I can trigger the latter via layout script trigger "OnRecordLoad" but how do I trigger the "memorizer" - even when no changes have been made to the record? I am on FM11 so I don't have access to the new Tab-script behaviours.

• 2 replies
• 2.5k views

comment

December 24, 201411 yr

I have 2 MacBook Pro running Yosemite 10.10 with FM Pro 12.0v5 that we are using from a remote site. When i open our customer file remotely on one computer everything works fine. On the 2nd computer the 1st layout of all customer info opens up blank. All other layouts are working fine. Nothing is visible other than a couple of lines showing where a couple of fields are placed. Going into layout mode all fields are still blank...a green dot but no field names. When I click on a field box the inspector pops open and the correct field is named. I also Checked the relationships and they are correct. We have 6 stations at the home office and they are working fine. Why wou…

• 1 reply
• 1.5k views

the Otter

December 23, 201411 yr

Hi there! I am at a young creative studio. We are currently using Google Calendar to schedule 7 people in 6 rooms, and we are using Excel spreadsheets to create estimates, actuals and invoices. I really need a resource scheduling software that allows me to both people and resources available at an easy glance, allows me to see individual jobs, and people can see it on their iphones easily. Then, I need timesheet software that allows my team members to enter in their hours and it populates a spreadsheet compared to the estimate. Then once my client has reviewed the actual hours report and we've agreed upon a price tag, I need an invoice to be generated a…

• 0 replies
• 762 views

ireneyardley

December 23, 201411 yr

I'm working on a system that allows the head of each department to access and acknowledge monthly reports that are imported into the DB. 2 of the tables are as follows: (I've omitted other fields that are not required for this to work) Records table: pk_recordID, date_imported, user_name, user_dept, acknowledge_date, acknowledge_avg, kf_reportID, g_deptcode (global field that is defined based on user login) Reports table: pk_reportID I'm currently using reports table as a portal to reflect the following fields: Records::g_deptcode, Records::date_imported, and a button that displays a sub-summary list of records found based on Records::user_dept I need some …

• 10 replies
• 1.5k views

the_furious

December 23, 201411 yr

Greetings, I am needing help with a problem I have been working on for the past few days. I have a Layout with a Tab Control (Main_Tab_Control) having 5 tab panels. The first tab panel is used to determine what informaiton is displayed on the following tab panels, based on several drop-down menus. On the last tab panel I want to nest an additional Tab Control (Sub_Tab_Control). Based on the information from the the first tab panel, I want this Tab Control to display only tabs that are needed. Ex: on the first tab panel a drop-down menu displays how many floors the building has "1, 2, 3, 4, and so on". Sub_Tab_Control has 10 tabs for 10 floors. If 3 is selected, th…

• 3 replies
• 2.8k views

David Jondreau

December 22, 201411 yr

I want the page numbers in my report to start at a specific value, as the report is going to be a section of a much larger PDF document involving other stuff not from FM. I've found a couple of old threads from several years ago, involving all sorts of fields and scripts, but I'm hoping things have improved since then. http://fmforums.com/forum/topic/32139-print-different-reports-with-sequential-numbering/ Thanks

• 2 replies
• 1.3k views

benwiggy

December 20, 201411 yr

I have three checkboxes (may add more later on) describing tasks performed on a regular basis Stopped Processes Ran EV Updates Batch Compressed I also have a Work Completed text field. I would like to check a box and have its text automatically entered into a new line in the Work Completed text field. Any help please?

• 10 replies
• 1.7k views

eos

December 19, 201411 yr

I am inputting Windows Product Keys which contain 25 alphanumeric characters in blocks of 5 characters seperated by hypens " - " I wish to type the product key without the hypens and have a calculation on the field to add the hyphens every five characters For example I type 123AB456CD789EF012GH345IJ FM replaces the text with 123AB-456CD-789EF-012GH-345IJ I have seen this calculation for phone numbers, but does not work directly with the addition of letters Replace ( Replace ( Filter ( Self ; 1234567890 ) ; 7 ; 0 ; "-" ) ; 10 ; 0 ; "-" ) The output would be 123AB456CD789EF012GH345IJ123456-78-9012345 Any help would be great!

• 6 replies
• 1.5k views

danielrmitchell

December 18, 201411 yr

Hi folks, Is there a way to alter the appearance of the scroll bar? I could have sworn it used to be possible with FM advanced, but I can't work out how to do it with 13adv and the white scroll bars stick out in the layout. Cheers, Mike

• 5 replies
• 1.3k views

HALBURN

December 18, 201411 yr

Hello all. I have a question that it's not clear in my mind on whats the most efficient way of doing this. I have 2 tables: 1 - exercise Type ( id, name ) 2 - exercises ( id, type, name ) So in a layout i have a portal that is pointing to the exercises table, in the same layout I have a checkbox field with a value list that points to the exercise types For example: --- Exercise Types Bicep Tricep Plyos Sprints and so on... --- Exercises Bench Dips (belongs to Tricep) Rope Pushdown (belongs to Tricep) Broad Jumps (belongs to Plyos) Squat Jumps (belongs to Plyos) and so on... What I need to accomplish basically is that every ti…

• 4 replies
• 1.8k views

Elkpodemiami

December 17, 201411 yr

I need to have access to FileMaker pro's regular icons. Are those available to us to when designing new layouts. I am not interested in getting free icons but use the FMP ones. However, if accessible I do not know how to get to them. Could someone help me? I am using MAC's. Thanks again. Daniel

• • 
• 7 replies
• 3.7k views

Fitch

December 17, 201411 yr

I'm using FM13 Advanced (Mac) to develop a solution. I copied my original file, experimented with different background images for a layout, and also did some other development. The file size difference between my original file and the one with background image experimentation is significant...more than I would expect from the other development I did. As a test, I saved off another version of the file using the "Compacted copy (smaller)" option, but this had minimal effect. I also wrote a script to flush cache to disk, but this had no effect on file size. So I'm wondering...is it possible that FM has cached the unused background images I experimented with somewhere …

• 2 replies
• 804 views

fairway

December 16, 201411 yr

Can you copy a custom menu set between files? This would save me a lot of work.

• 2 replies
• 4.1k views

Fitch

December 15, 201411 yr

I think I'm constructing a Rube Goldberg-esque solution to my problem. Here's the application domain. I have a table of records that correspond to patent applications, which are commonly referred to as matters. A matter can claim (but does not have to) immediate priority to one and only one other matter. However, more than one matter can claim priority to the same matter, and a matter that has matter(s) which claim priority to it can itself claim priority to a matter. When a matter claims priority to another matter, this means that the former matter is of lower priority than the latter matter. I realize this is confusing, so here's a concrete example that I've be…

• 0 replies
• 1.7k views

mikedr

December 13, 201411 yr

I have a field "Completed" for a table "Task." The idea is that it's set to 0 initially, and a user can check off a box to indicate that the record has been completed. I set up the field as a number, with auto-enter data of 0. I set up a value list "yes, no" with a single value, 1. On the layout, for the field, I created a checkbox, and sized it to hide the value of 1, so you only see the box. Before the box is checked, the value stored in the field is indeed 0. However, when the box is checked, the value stored in the field is shown as: 0 1 That is, 0 on one line, and 1 on another (I have another layout that displays the actual value, for testing pur…

• • 
• 23 replies
• 8.2k views

comment

December 10, 201411 yr

Hi, Ive been searching for a solution without any luck, or maybe this just isn't how a web viewer is suppose to work, however... From my filemaker database I would like the user to click on a button whilst in Kiosk mode and bring up a window containing a web page where they can interact and then close it down which works fine, however the page won't refresh unless i right click+control and click refresh (web page contains a calendar so can see its not refreshing). Is there a way for this to be done automatically? Im using... Set Web Viewer in my script and have tried Reload also. Thanks in advance Tom

• 2 replies
• 3.4k views

reelsteve

December 10, 201411 yr

Hi! I am new to Filemaker but can understand today a little more than yesterday. =-) So, I have a database with students who apply for Examinations. Now we are using... PAPER! For this work and we want to port it to digital so the Examinations can be done faster and give faster results for students. It is all in a table like with their names in a collum on the left and blank spaces on the right for the Yes/No grade. And, there are the many subjects that are evaluated for them in the upper part of the table. Like: | Kick | Punch | Grabs | Total: Error / Detail | Result Joe | Error / Deta…

• 0 replies
• 974 views

BgusmaoKM

December 10, 201411 yr

My database has Relationships of:  Clients ----< Policies ----< Renewals  In a layout on the Clients table, I have a portal that shows all of the related Renewal records  I would also like to be able to filter the Portal with 3 different global fields.  The names of the fields I want to be able to filter by are: Year, Carrier Name and Status.  The problem (at least I think it is the problem) is that the Carrier and Status fields are stored in the Policies table  I attempted to create the Carrier filter.  I created g_CarrierFilter in the Clients table.  Created a new table instance of the Policies and Renewals tables named Policies_filter an…

• 6 replies
• 1.6k views

biiiink

December 9, 201411 yr

Hello everyone, I would like to know if there is a function that obtains the values selected in the group check boxes so they can be counted and represented in a chart.

• 2 replies
• 1.5k views

LaRetta

December 9, 201411 yr

Hi there, Anybody come across the following - please help In browse mode when i click on an edit box field to enter data it disappears or i can not at all enter it in order to modify that text information in it, this is happening only on some records and this includes a container field(when i click on it it disappears and appears on another second click)

• 1 reply
• 800 views

Miss A!

December 8, 201411 yr

I have set 3 tabs: Detail, Main Course and Other. I have set a simple script to go to Main Course and nothing happens on screen when I run it? Detail is the default tab. Script: Go to Object / Object Name: "Main Course" Please advice

• 4 replies
• 1.8k views

Bikeman17

December 4, 201411 yr

Hi, Not sure here … ? I have a client who wants to number their windows in the "Title" ... And it turns out that the calc looks like this for the active window that opens … ValueCount ( Window ( Get ( FileName ) ) ) &" of "& ValueCount ( Window ( Get ( FileName ) ) ), so ... "5 of 5" for example. The only problem I have is when the customer opens / closes windows the calculations for the other windows are static and I am not sure if there is a way to auto update the other windows without having to navigate to each open window and recalculate. Is there a way to auto update / number the other window as the user closes and open them ?? Th…

• • 
• 4 replies
• 1.3k views

Josh Ormond

December 3, 201411 yr

I set up a portal in a layout for table A with respect to related records in table B. The first screen shot shows the portal -- there is currently one related record, 1041.343US4.   I created a value list that is used in the portal. Thus, in the second screen shot, if I click in the box, you can see all the different values. This is working as intended.   Now, the problem I'm having is that the value list is not showing up for a new related record created in Table B using the portal from layout for Table A. See the third screen shot. If I click in the box, the value list doesn't show up.   However, if I were to enter anything, and pres…

• 2 replies
• 1.5k views

mikedr

December 3, 201411 yr