FileMaker Interface Features

Hi, I have a portal displaying transactions. I want to filter the transactions so that I'm only looking at the current year. the records I'm displaying in the portal have a DATE field (the field is imported from a mysql db as mm/dd/yy hh:mm:ss) and the information in my FM db is formatted as mm/dd/yyyy I'm filtering using the calculation If ( Transactions:_transDate >"01/01/2012" ; 1 ; 0 ) However this is not filtering out transactions from 2011 What am I doing wrong? Thanks, jim

• 5 replies
• 1.7k views

comment

February 2, 201214 yr

Hey Guys, I am a completely new user to Filemaker so please be patient with me. Everything I have done on the attached file is through self-learning. I have tried to merge Inventory management with invoicing and basic accounts for my small business. I have succeeded so far however stuck at a small point Basically for one design no. i may have multiple suppliers and multiple cartons no.s When I create the invoice successfuly selecting the design no. lot no. (Supplier name) & carton and input my desired pcs/yards, instead of deducting stock from the selected carton no. Filemaker decides to subtract it from the first carton no. only. I have attac…

• 6 replies
• 1.1k views

yadvani

February 2, 201214 yr

Hello, I have about 15 "Categories" that are set up in a value list check boxes. I would like to create a layout that only shows the text of the "Checked" boxes. Can someone please help! Thanks Dave

• 8 replies
• 3.3k views

bcooney

February 1, 201214 yr

Hi there... Slightly irritating problem... i have done a lovely layout... it fits perfectly on my screen when filemaker is maximised (screen res is 1280 x 1024) Now I go and check the layout on another PC, same res, and the layout is rendered a few pixels wider and taller!! This is causing the scroll bars to be enabled and it just looks "off" Why is there this difference? Whats causing it? Aare there any settings in windows I should be checking? It might be worth noteing, one PC is amd the other is nvidia Matt

• 2 replies
• 1.1k views

liltbrockie

February 1, 201214 yr

Hi all I have a layout divided into header body subsummary and footer - a button toggles between two views - form and list so that the subsummary doesn't show in list view I am trying to do a custom background by entering a series of graphics into the various parts and then sending to the back. The problem I have is that the graphic in the body part will not align exactly with the edges of the part (the dotted lines at top and bottom) so leaving a small gap when it is in browse mode The part boudarys will not align exactly with the grid lines or the tee square making it impossible to get them exactly aligned even if I resize the graphic So what I was wondering …

• 2 replies
• 927 views

Johnny777

January 31, 201214 yr

I'd like to have conditional formatting enabled when the value of a field is not a value of a value list. I've looked into this briefly, but am posting here in case anyone has done this. Thanks.

• 1 reply
• 1.3k views

comment

January 31, 201214 yr

I am relatively new to filemaker, I have been working on a database and its coming nicely. All my layouts are looking good except 1. When i view it in form view all the fields and containers stretch out to the length and width of window. None of the other layouts do their, if i grab the right edge and drag it to the left on the other layouts it just cuts across the fields. But on this one it stretches and shrinks based on window size and shape. I am sure i must have done something, but i cannot figure out what. it all lines up... any help you may be able to offer would be great. Thanks.. Brian [email protected]

• 2 replies
• 959 views

Bbuwell

January 30, 201214 yr

Hi, I've been searching around for a solution to this problem and can't find much on it. Nothing recent anyway, so I hope things have moved on. I've convinced my company to switch from managing our pricelists in Excel to FM. However, we had hyperlinks on all products codes which opened the product page on our website. Excel includes this information for exporting to PDF no problem, so the link is still active in the cirruclated PDF version. I have set the product code text field with a button behaviour that opens a URL, picked up from a seperate field. The thing is this is only active in browse mode and not in preview mode, which is require to sort the product and pu…

• 0 replies
• 827 views

SCVlondon

January 30, 201214 yr

I have uncheck the option "Save record changes automatically " So that "Save change to this record" dialog box appear in browse mode, when i done some changes and click on empty area. But i dont want this dialog box at browse mode, because im have written some script in save button for save the record. How to avoid this dialog box.. Could anyone please suggest me to stop or avoid this dialog box appear in browse mode Many thanks in advance for your support

• 1 reply
• 1.4k views

Vaughan

January 30, 201214 yr

Hi, All. Newbie here with a noob question (do we have any other kind?). As a noob, I don't have the FMP vocabulary that you guys have, so I'm including some screenshots of the problem to make it easier to explain. I am making a fairly simple equipment rental solution for my employer. The relevant tables here are: JOBS, GEAR, CREW, BOOKINGS_GEAR, BOOKINGS_CREW. On my main JOBS layout, I have two sets of tabbed areas, each with two tabs (see attached photo above). The two tabs in Tab Area #1 each contain portals listing All records for Gear and Crew, respectively. Tab Area #2 has two tabs with portals showing Gear and Crew that have been added …

• 2 replies
• 979 views

JonAgnew

January 30, 201214 yr

When I setup via relationship a valuelist of a date field I logically obtain a (text) list of dates. But I need to use it to control a relationship with a date field and the stuff only works when text valuelist and date field are equally formatted. I use the european date format, sorry V.list 6/1/2012 7/1/2012 8/1/2012 13/1/2012 can not be relationated to the date field 06/01/2012 or can not be found in the vList via PatternCount. Well, it does work when the date is from october / nov / dec on 10th to 31th But useless, of course. The issue is solved with relationship multipredicate but I have to set up (it is a week control scr…

• 3 replies
• 1.2k views

jorfasan

January 27, 201214 yr

Really simple question! If I'm needing to truly align two objects, my intuition tells me they should both be an odd number of pixels in size, or both even. Would that be right? Okay -- follow up question. If I'm wanting text in an Edit box to be centered vertically -- in other words, no closer to the top of the text box than the bottom -- . . . or to *appear* centered to the eye (which may not be the same answer - as framers often mat the bottom edge of a painting slightly fatter than the top) . . . . should the text box be odd and the font size also odd, or . . . ? Similar question arises when I have a text label I want to align centrally next to a fie…

• 4 replies
• 958 views

Vaughan

January 27, 201214 yr

Hello I have some buttons which allow me to define some values which will help choosing the kind of report which should be created. The button sets a variable value (for instance to "details", "daily", "monthly") and the script acts accordingly. My questions: • is there a way to show the value of the variable on the current layout? (found it after a much needed coffeebreak... ) • would it be wiser to use a global to store the choice? Thank you for your short answer. Cheers

• • 
• 1 reply
• 1.9k views

David Jondreau

January 25, 201214 yr

I have a portal where I'm using an ID field and want it to show a name, not the ID number. I used the value list, selected the popup menu option, defined the id as its name, used the 'show second value.' All the relationships are in place for this to happen. When in browse mode, clicking on the field shows the name list but the name does not persist. If you go to another layout and come back, there is the id showing, not the name. What is really puzzling is I am duplicating an example, and I swear that I followed it exactly. The example persists; mine does not. Any thoughts? Thanks!

• 6 replies
• 1.2k views

Pat

January 25, 201214 yr

I finally got around to implementing drag and drop functionality within our database. I've used this simple technique http://fmforums.com/forum/topic/62097-drag-and-drop/ mainly because it didn't need scripts (and I've looked at other methods and couldn't get my head around it). What happens is I drag a staff members name onto a shift. This then populates that the shift has been filled by this staff member. It all works perfect. The problem comes into it with our Availability table (shows when staff are available). In the past, when we assigned a shift to a staff member a script would run that would update the Availability table to show they were working. With …

• 1 reply
• 924 views

ckai

January 25, 201214 yr

I can't seem to find a way to darken the Checkboxes and the "X" in them. In my middle age the "X" seem far to faint. I would appreciate any help.... Thank you

• 6 replies
• 1.1k views

comment

January 22, 201214 yr

I have a portal that displays 10 rows with no vertical scroll bar. There are approximately 200 records in my table occurrence. I want my users to navigate by clicking on buttons, similar to the navigation in this forum. (please see attached screen capture) When I try to use a "go to portal row" script step it does not work becuase it only allows me to choose records being displayed (portal rows 1-10). Is there a way that can I display records 11-20 without changing layouts, and without showing the vertical scroll bar? Unfortunately showing the scroll bar, or even turning it on and making it transparent is not an option with this particular solution.

• 10 replies
• 6.3k views

HALBURN

January 21, 201214 yr

I have a portal showing all the students and their birthdays. I want to display only the children who have a birthday coming up this week. I tried filtering the portal with the following calculation; Students:Birthdate ≥ Get(CurrentDate) AND ≤ (Get(CurrentDate +7)) .... But no cigar. I have also tried sorting the dates by Students:Birthdate but it sort by year, then Month Name (which is not the mlnths in order) Mmm, got a few ideas about teh sorting but no clue about the filtering. Any help would be greatñy appreciated. Thanks so much

• 4 replies
• 3.6k views

MariaAux

January 21, 201214 yr

Hi All, How can I or one of my users deselect a radio button set without using the shift/click action? I intend to publish a list of two hotel categories via custom web publishing. Each category will have a radio button and if hotel category 1 gets selected then category 2 gets deselected. I have this option for 8 nights at 16 different hotels; now if a customer clicks through the hotel categories, makes his selections and then decides that he doesn't want to book the hotel on a certain day, it will still show his earlier initial selection. Thus the need for a deselect of single radio buttons or refresh of all the selections made. Thank you guys! Andy

• 3 replies
• 1.4k views

LaRetta

January 21, 201214 yr

Okay, this is a tiny question, but one that's bothered me for years. When I'm in layout mode starting a brand new project, I like to set the body part to the approximate the size of the window, and then I use the T-Square lines and the line-drawing tool to sort of sketch out how I might use the real estate. Or whatever. But always, getting in the way, is that squiggly vertical line that shows where the edge of the "page" would be. . . . but this is going to be a data entry layout, never printed. So why must I have this thing distracting me all the time? Ironically, the only way to hide it seems to be to choose "View Page Margins" -- which is even worse. …

• 3 replies
• 1.2k views

comment

January 20, 201214 yr

Hi, I have a problem regarding creating a portal from a list of record, in my case, user will be able to input some values in separate layout and the values will be displayed onto a table. The example of the table is shown in the attachment. How can I create this thing? I am a beginner user and use FMP 11 Adv on windows. Thank you Example.pdf

• 2 replies
• 1k views

Lee Smith

January 18, 201214 yr

I would like to use the web viewer for my solution but the problem is the size of the window of the browser. Any way to send a message to the browser to makes its window a certain size? Thanks

• 0 replies
• 1.5k views

hartmut

January 18, 201214 yr

Hello, It's hard to describe the report problem I have. I am not sure if what I need can be done in filemaker. I need to sort by month, and conditionally add data from other tables. Please read on for the table design and the expected report layout. 3 Tables: Projects- (Each project will have one or more â��childrenâ�� subprojects) __kp_projectID projectName SubProject- (Each SubProject will have 1 â��parentâ�� project and 1 â��childâ�� SubProjectTask) __kp_subProjectID __kf_projectID subProjectName dateA (date field) dateB (date field) dateC (date field) SubProjectTask- (Each SubProjectTask will have 1 â��parentâ�� project ) __kp_sub…

• • 
• 8 replies
• 3k views

lowkeyloki

January 18, 201214 yr

Okay, this is somewhat embarrassing, but I can't seem to get a simple sub-summary part to display summary data properly. Table 1: Stocks -- 1 record per financial stock, with fields for Ticker, Manager (each stock only managed by 1 person), and a few others Table 2: Trades -- child table, 1 record per stock sale, w/ fields for date, # of shares, buy price, sale price, net $, etc. In the Trades table, I have various summary fields like "Total $ invested" and "Count of Trades" so that from the Stocks context I can see combined data for all trades of a single stock. This works fine. So, on to the problem. I want to have a sub-summary layout where the sto…

• 10 replies
• 2.1k views

Wickerman

January 18, 201214 yr

Hello all. I have a tricky problem with authentication using the web viewer in FMPro 11 and OS X Lion. I have a solution which uses the web viewer to view password authenticated pages from one of our web servers. Many moons ago, I saved the password for these intranet pages which meant I didn't have to enter the password each time I visited a new record, nor even after closing the file and reopening. However, recently my Keychain developed some corruption so I had to delete it and start again. Since then, the password dialogue pops up every time it tries to access the page and although Filemaker's Web Viewer will create a new Keychain login item for the password…

• 2 replies
• 2.2k views

FudgeMaker

January 17, 201214 yr

I'm trying to create a list of years based on a date field in one of my tables. I am putting a dashboard together that allows the user to select the starting year from a drop down list. Each user will possibly have a different range of dates in their copy so i would like to have a drop down list of years based on the dates in a field in their copy. I hope that makes some sense and someone can point me in the right direction? Thanks

• 4 replies
• 1.5k views

Paul Webb

January 17, 201214 yr

Hi, I only program occasionally and feel as though I've overcome this before... but can't recall how I've 2 tables A and B, both can have more than 1 related record with the other, when I do a summary in A where B has more than 1 related record, I get the multiple A values (and therefore they all sum() ) they but I only want that value once, and visa-versa. I know I can create 2 layouts but Ideally I'll like to be able to do it on 1 hope if explained it properly thanks

• 12 replies
• 1.2k views

MJK.NSW

January 16, 201214 yr

Hello Everyone, Scenario: I have created 2 tables namely Agreement and Agreement Details, where AgreementId is primary key in Agreements table and refered as a foreign key in Agreement Details. I am capturing details from screen and passing to these 2 tables. Requirement: I want to display all records captured in the above scenario on a PORTAL on a different screen. Problem: The PORTAL is displaying data on record by record basis BUT I want all records to be displayed like a list. Please assist, I am stuck. Thanks, -DS.

• • 
• 11 replies
• 2.3k views

LaRetta

January 15, 201214 yr

Hi Is it possible to get Filemaker to auto adjust the field size in a portal according to the amount of text that it contains. This portal contains the entries on an invoice page I am creating and the description of the work can be one line or ten lines long. I can manually adjust the field to show all the text but then it is the same for all the other entries and I have empty spaces on my page. Maybe Im going about it the wrong way and shouldnt be using a portal in this situation. I would appreciate any help with this as I have spent two days wrestling the script to get all the info into the portal, only to be stuck at the final hurdle. Thanks

• 2 replies
• 2.9k views

plumber

January 15, 201214 yr

How can I fix my IWP interface icon? How do I get rid of that black box behind my icon? its always appear on my IWP interface Normal Filemaker icon IWP icon

• 9 replies
• 3.7k views

2ninerniner2

January 14, 201214 yr

In layout mode there is record forward and backward while mouse scroll. I would like to stop this features with the every layout. Please share your suggestions Many thanks in advance

• • 
• 2 replies
• 1.1k views

Lee Smith

January 14, 201214 yr

Hi, Just starting with FM and found problem with pop-up menu. I would like pop-up menu to have option to insert "Others" and also include that in the list next time user click on this field. I know there is a "Edit" option for pop-up menu but I don't want users to be able to edit entries, just add new ones to the list. FM Pro 11 Thanks, Mariusz

• 4 replies
• 2.2k views

Mariusz Materek

January 14, 201214 yr

Hi all - I know there is, and has been for a long time, a Title Footer layout part. I have never understood it's behavior though. I want a part that will only print in the footer of the last page of a multi-page layout NOT the first page. Has anyone ever come up with a good way to do this?

• 2 replies
• 2.4k views

comment

January 13, 201214 yr

Hi All, I am stuck with a conditional formatting issue on one of my layouts. Here's what I'd like to accomplish: I run a business for motorcycle tours. I have a total of 20 tours for 2012 with a maximum of 15 participants for each tour. For an overview of what is booked and how many spaces I have left over for a soecific tour I want to have a layout that graphically shows me how many spots on a scale from 1 to 15 are sold and how many are still available. In the attached file I'm showing a graphic example of what I want the solution to look like. Each red square shows a sold spot on the tour while the white squares show the spots that are still available. …

• 13 replies
• 2.7k views

***ANDY***

January 13, 201214 yr

Hello all I have been asked to design a table with a list of companies showing the various subscribers underneath Very easy main table - records by company then a join table to the main contacts database and show the subscribers in a portal However I have been asked to show the list of companies and then give the user the abilty to expand the record to see the subscribers as they see fit. As far as I know there is no way to do this although I understand you can re-size objects to take into account different sized windows Does anyone know a way of doing this or can you at least point me in the right direction We are still on filemaker 8.5 at the moment

• 2 replies
• 1.7k views

Johnny777

January 13, 201214 yr

Good day dear FM friends, I have hot stuck on something much trivial - something I though would be a breeze to set up, but apparently not. Please help, dear friends! I thought I could easily find a function similar to GetValue but the other way around. With a valuelist based on cities::id to show cities::name I would need to do something like: getValueListItem("cities value list"; "Paris") to return cities::id. I understand I can use position to find the position in the list, but how about the corresponding id?

• 8 replies
• 2.5k views

Jonas Löfvenmark

January 12, 201214 yr

I'm having a bit of trouble on a value list in a way I have never encountered before. As you can see in the popup, the value list shows two fields. The first field is a number field, the second is text. I would like the user to be able to select the item by typing the account number. However, a strange behavior is happening. When I start to type the number, the value list disappears and then only the numbers typed so far show in the field. Now, If I change the value list to sort by the second field, the description, it allows the selection of the value list by typing the account number. I have never seen this behavior before. Sorry about the small images b…

• 3 replies
• 1.1k views

jkluchnik

January 12, 201214 yr

I have a portal that has 2 script triggers on it, each triggered via different fields in the portal. When the portal is empty (ie no portal rows), I cannot trigger any scripts. The only way is to set up the portal at a button, but then I loose the ability to trigger the scripts I need on the two fields I mentioned above. Is there a way to trigger a script on an empty portal without setting it up as a button? Thank you, Fed

• 1 reply
• 910 views

dansmith65

January 11, 201214 yr

I have a database I have been designing and I can not figure out how to get a relationship to allow me to type in fields that are on the main table. Here is my breakdown. I have a main customer table, I have an orders table and I have a customer visit table. I want my customer info stored on my customer table, and from my orders table I want to be able to type a customers name in the name field, and that automatically creates a new customer entry if the customer isn't already in the list. I want the same to happen if an employee enters a customer name in the customer visits layout. I don't want my employees to have to go to the main customer table and create a customer e…

• 7 replies
• 1.9k views

comment

January 11, 201214 yr

My main layout is a rats nest of over two hundred fields. Some fields are duplicated (aargh!) The layout body stretches down some 60 inches, and things are sometimes almost randomly placed. Yes, it's so messy that I can't find where one particular field is located on the layout. (is it over on the bottom left of the layout? On the right side, fifteen fields from the top?) Of course, I should clean things up. But to do so, I have to find the fields that show up two or three times on this layout. Is there any way to be in layout mode and then find the location of a field ? ? ? I'll bet that there isn't ... can you prove me wrong? …

• • 
• 2 replies
• 1.7k views

LaRetta

January 10, 201214 yr

Consider my 3 tables: Customers, Line Items (that is, lines of invoices), and Items When in the Item database, it is very easy to show all the invoices on which that item has appeared in a given timeframe, via a portal on the item layout: Item::ID = Line Items::ID_Item and Item::gDateRangeStart <= Line Items::ShippingDate and Item::gDateRangeEnd >= Line Items::ShippingDate Next, my Line Items are related to the customer that bought it. Line Items::ID_Customer = Customers::ID Then, I conditionally format the customer name to only appear once within the portal row if: Line Items::ID_Customer = GetNthRecord( Line Items::ID_Customer ;…

• 2 replies
• 999 views

Quartekoen

January 10, 201214 yr

I'm trying to display the premium amount for the past 3 years in a list on the current record. I need help figuring out how to do this... I can show the date field for the current year, and the premium field for the current premium, but how do i set up the date field to be 1 year back and connect it to the premium so it shows that premium amount? Any help greatly appreciated. Matt

• 2 replies
• 806 views

comment

January 9, 201214 yr

I want to contextually assign different value lists to a field. For example: if field Select_VL is "VLB" then field VL displays value list B Its trivial to display the contents of the selected value list using the function: ValueListItems ( fileName ; valueList ) For example: Set Value List Related Example.fp7.zip However, the field contents do not behave like a value list. It is not possible to select a particular item from the value list, have it auto complete, etc. For example: if field Select_VL is "VLB" then field VL displays: Garlic Red …

• 3 replies
• 2k views

comment

January 7, 201214 yr

Good evening everyone and happy new year. I have serveral fields which use repetitive text. On layouts which use merge fields, is there anyway to embolden the text used as descriptions within the fields? Examples are below... If ( IsEmpty (ShorePowerSpecs );"Amps:____ Location:____________" ; "Amps: " & ( ShorePowerSpecs[1] & " Location: " & ShorePowerSpecs[2])). I want to embolden the words Amps and Location.

• 4 replies
• 1.4k views

Protour Travel

January 6, 201214 yr

Hi All, Okay, I have an invoice print layout (table is InvoiceLineItems) that's structured like this: • Header (logo, phone numbers, address, invoice date, salesman, ship method etc) • Body (containing only the line items data) • Trailing grand summary (totals, places for writing hand-written notes, a spot for a graphic, spot for signature) • Footer (Pg X of X) Basically, the trailing grand summary contains a lot of things (that can't be removed or re-sized) that need to be there, but there's one problem: When I have more than 5 line items, the trailing summary will no longer fit on the page, and being all one big chunk, it gets pushed onto the next p…

• 2 replies
• 1.2k views

Agnes Riley

January 6, 201214 yr

I am struggling to reproduce a breadcrumb-like graphic in FileMaker. The content needs resize dynamically. Does anyone have any ideas on how/if this could be done? I was trying to do it without using a web portal but I don't think it's possible. Thanks.

• 7 replies
• 1.4k views

HALBURN

January 6, 201214 yr

Mmmm, just wondering if we have the same possibility to customize the Status bar for the end user as we do with the Menu? Thanks so much and a Happy New Year!

• 3 replies
• 2.2k views

MariaAux

January 5, 201214 yr

I have a field that is used on two different tab panels of a layout. My script needs to select the second occurrence and then do a Select All so the user can just type over the contents. I use Go To Object to display the correct panel, but how can I select the contents? A Select All doesn't work because a Go To Field hasn't been performed. But a Go To Field causes the first occurrence of the field to be selected. A Catch 22? From the FMP help: Thanks in advance for any help. UPDATE: I've solved my own problem. Select All does work. I had too many disabled elements in my test script and didn't notice an extra Go To Field [ ]. Sorry for the fals…

• 0 replies
• 2.1k views

K1200

January 5, 201214 yr

Hi, I have a need to change the filtering of a portal on the fly. The current relationship to this portal is that of a client number, but need to narrow the filter down even more as a keyword is typed into a field outside the portal. The portal is to a duplicate table with an alias - I know my terminology here is wrong, but I needed a portal to the same table to list the records - so we are talking about the same table. How could I go about this please? Greg

• 4 replies
• 1k views

comment

January 5, 201214 yr

The attachment shows a simplified version of a situation I've encountered on a much more complicated layout. The problem is to have the filtered portals show contents in the same order as the 1, 2, 3 order of the parent records ... 1 on the left, 2 in the middle and 3 on the right. I've been mulling over some possibilities ... like having a separate "driver field" that is built by a triggered script whenever a change is detected in the order of parent records. But I can't help thinking there's a simpler way. After all, the proper order is sitting right in the parent table. I just can't figure how to put it to proper use. BTW, the order of the parent records is c…

• 4 replies
• 1.2k views

K1200

January 5, 201214 yr

Hello Everyone, i have been trying to search/ download samples provided by many sharing persons in this community, but it is quite difficult to do at least on my end. I am learning that it is best to look at these files, figure out how they work and learn from that. Can someone please let me know how i can search here for all the *.zip or *.fp7 files that are on this forum? thank you, -ian

• 2 replies
• 5.3k views

imoree

January 4, 201214 yr

hello mates first of all i wish a very good year 2012! i am trying to figure out how i can solve following problem: in a table persons i've got (among other fields) person number, initials (possibly but not definitely calculated with the name) and full name. i have a value list which is auto created. i have a popup with this list, which shows initial as first (it's the key) and full name as second. i need the sort to be done on the person number. any chance to do that? cheers

• 0 replies
• 878 views

Ralph Schwegler

January 4, 201214 yr

Hi All, Is there a way to Auto-Enter a field on Creation of a new Record based on Value List. I have a value List of the months, Ans I ant each record to auto-enter January followed by February etc. until December, and then start again at January, I know I can show only the name of the month by formatting the auto-enter date entry, but this field needs to have only the name of the month as it is related to another table through this name. Thanks a million, Maria

• 5 replies
• 3k views

comment

January 3, 201214 yr

Quick background: I work for NASA and up until 2 years ago we were using FM here to do some of our work instructions. We have since gone to another system (which none of us engineers like) and I am now trying to put together a little demo to show my management that we need to switch back to FM so we can run paperlessly runing FM Go. I am not a developer but I have built a crude system to mimic what I envision this system doing. I am hoping someone here can help me with what I hope is fairly simple: I need to be able to add "steps" (text fields). Each time an engineer writes a work document the number of steps varies based on the complexity of the task. A simple task ma…

• 3 replies
• 948 views

Andy Guymon

January 3, 201214 yr

Has anyone confirmed whether the new text highlighting feature can be used to highlight words in a text field according to a user-specified string (see attached example)? Thanks.

• 5 replies
• 4.2k views

HALBURN

January 3, 201214 yr

I want a drop down list to show me all my Vendors from my Company Table. Background: In my company table I have a field called (Name) to list the name of companies and then one with check boxes (Choices_Client_Vendor) to identify if the name is a vendor or a client. Sometimes they can be both so this is why the check box. To create the drop down list I created a new field called CompanyVendor in my Company Table based on the following Case: Case ( Choices_Client_Vendor = "Vendor" ; Name; Choices_Client_Vendor = "Client" & "Vendor" ; Name ; "" ) My value list shows me all my records that only list "Vendor" in the (Choices_Client_Vendor) field but…

• 2 replies
• 909 views

The Missing Man

January 2, 201214 yr

Hello, I have created a simple new database "SURVEY.fmp" with 4 layouts that contain a survey for my customers. One of the layouts contains 7 questions, each one can be selected by radio buttons for the category "good", "average" or "poor". Customers are supposed to go online, enter their reservation number and via buttons/scripts at the end of each page click through the survey until they reach the end and submit their survey. While the radio buttons behave correctly on my PC they don't do the same thing in the IWP. On the host computer I can select/deselect the radio buttons throughout all three categories "good", "average" and "poor". I can select a button an…

• 8 replies
• 1.9k views

comment

January 2, 201214 yr

I am using a radio button on my layout. To see the click button area I give it a stroke of 1 pt but when I do this I also get a line on the top and left hand side of my field box. In effects everything is set to none so I cannot figure out why this is happening or how to fix it. If I click off the stroke for the button the lines disappear but then so does my button. How do I get my button to show up with a stroked line and no lines to appear around my field box in the top and left hand side? As always any help would be appreciated. Thanks in advance, The Missing Man

• 2 replies
• 910 views

The Missing Man

January 2, 201214 yr

Hey Gang! HAPPY NEW YEAR TO EVEYONE!! I may be asking a question that may seem ridiculous, but please bear with me. I dont use the list view at all, but now that i have to print invoices out, i see the need as well as for searches. Can someone paste links here so i can see what others have done as searching in this site for me is quite difficult for some reasone for the list view stuff. I definately see reasons for invoice, but the layout parts i need help as documentation again is all over, but i am weeding my way through slowly. any help on how/why/when using list or table views would be great. Hope everyone has a great 2012~~~~~ -i…

• 2 replies
• 1.9k views

imoree

January 1, 201214 yr

Hello All, For nicer appearance of my layouts I have inserted a jpg image of a nice web button into my layout and assigned a script to it. Both mouse buttons (left and right) work to click the button but when clicking with the left button the graphic of the button turns into its negative colors which for the time of the click which makes it look very strange. This does not happen when I click with the right mouse button. Is there anything I can do to prevent the button from changing its colors? Thanks in advance, Andy

• 10 replies
• 2.5k views

Andy's

December 31, 201114 yr

I have two portals on a layout that show widgets from the same table (which has Allow Creation enabled). One portal is filtered to show only Type A widgets. The other shows only Type B's. When a user adds a widget to one of the portals (by entering on the last line), I'd like the add action to automatically set the widget Type according to which portal is being used. That way, the new entry will remain in the correct portal. BTW, the Type is not displayed in the portals. Indeed, the user is not even aware of the mechanism driving the content of the two portals. Is there a way to accomplish this other than having a post-process script attached to one of the port…

• • 
• 6 replies
• 1.6k views

comment

December 31, 201114 yr

Hey Everyone; Got a question about printing a report or in my case the order/ invoice . what would be the best practice here in printing the report via all these tables eg. Customer->order->orderITEMS->Payments I NEED all this information along with other info such as "company information in case of emergency,etc" i am about to do a report, plug the data into a virtual list and after place all information into a table. Does that make sense or is it just better to create a List Layout and put all information i NEed on the list layout with conditionals / text objects ,etc. thanks for your help as usual . =-ian

• 11 replies
• 1.5k views

imoree

December 31, 201114 yr

If I create a value list with custom values and begin it with a carriage return before I type my choices, the pop-up displays a blank at the beginning so that the option is also to blank the field. But if I use the same value list and attach as radio button, it does not provide the blank 'circle'. Why is the behavior inconsistent? It makes sense not providing the blank on checkboxes because they can be unchecked but radio buttons can't. I read about using shift to 'remove' a radio button selection it does not seem like the right approach. I would have to put a message above all my radio buttons (which I will allow removal of data). Also too, why does it then…

• 28 replies
• 13.9k views

Raybaudi

December 30, 201114 yr

Hi Everyone, I am trying to send an sms via the wb viewer and have used the following syntax. "http://www.smsglobal.com/http-api.php?action=sendsms&user=XXXXXX&password=********&from=61433414174&to=" & Text Messages::SentToNumberFiltered & "&text=" & Text Messages::Note User has been altered from the username to XXXX and password have been changed to **** I am getting: ERROR: Missing parameter: to If anyone has any ideas I would be extremely grateful. Milton.

• 1 reply
• 1.3k views

IdealData

December 30, 201114 yr

Sorry, I meant through not though, of course! I'd like to get Filemaker to sign in to web pages for me via a script, and then display the resulting web page in the viewer. For example, I'd like to automatically log in to my gmail. Is this possible? It seems to require passing a POST command, and I've looked at several utilities to do that (Scriptmaster, FMNexWeb, the Troi PostUrl plug in). They all seem to offer what I need, but I can't figure any of them out. Too thick I guess! Any pointers would be appreciated.

• 1 reply
• 1.6k views

Vaughan

December 29, 201114 yr

I'm using FMP10, and our database is published online. I'm the only one who has access to add entries to our value lists. The value list is created by entries into the field, as opposed to creating a list manually. With 169 entries into the value list, 12 are duplicates. They are exact duplicates, i.e., if you do a search on duplicate version #1, I get 625 matches, and a search on duplicate version #2 also finds 625 matches. I have no idea how these are being created. I know I didn't do it, and since no one else has access, I don't see how anyone else could be causing this. So, that is problem number one, how these duplicates are being created, and how can I…

• 5 replies
• 2.5k views

David Jondreau

December 28, 201114 yr

I have a potential client who has customers from both companies and individuals. What is the best practice to design the customer information? Thanks. Kent

• 7 replies
• 1.3k views

Spidey

December 28, 201114 yr

Dear All, I am working on SuperContainer. I just want to retrieve the file name of the SuperContainer file in field of my database. Please response me as soon as possible. Thanks in advance...

• 3 replies
• 1.4k views

fmbug

December 27, 201114 yr

I've seen FileMaker apps designed by others where the fill color of an object on the layout changes as the user enters that object. For example, as the user tabs from one editbox control to another on a layout, the fill color of the current object changes from white (the apparent default color) to yellow. I always thought that technique was cool and wanted to know how to accomplish it. I've recently had an opportunity to look at a file which used that technique. In layout mode I saw that all of the editbox controls on a layout had a default fill color of yellow and each of these controls had the same conditional formatting specified. Based upon the conditional format…

• 6 replies
• 2.2k views

jbante

December 23, 201114 yr

I have a repeating field with 36 vertical repetitions. I would like each repetition to have visible borders around each one. When I turn on field borders for all 4 sides it only does the outside borders of the entire set of repetition fields. The other problem / trick is that the set scales with anchors set to top, bottom, and right so faking it with other objects is tricky at best. Any ideas?

• 2 replies
• 764 views

Drew Sanderson

December 23, 201114 yr

Hey everyone; i have been looking but cant find a source here on FMFORUMS with regards to Portal search filter or the like. I have been using patterncount which is very slow over the network, but now want to learn how to filter using either a relationship or custom function or something else which is super fast. What i mean is user types '" i " and script trigger does what it has to do . any links please? thanks, -ian

• 13 replies
• 2k views

imoree

December 22, 201114 yr

As you can see in the photo attached my page margins don't match up with my layout ... I have searched everywhere and for the life of me cannot figure out how to specify the page layout/margins so they match the iPads screen size ... without changing the page margins for the entire database and regular computer layouts ... I tried to switch to landscape mode and that looked more fitting for the iPads screen size but then when i tried to print on another layout it printed incorrectly. Thanks, Matt 22.tiff

• 1 reply
• 1k views

grumbachr

December 21, 201114 yr

Hi all, Hope yo had a great weekend! I've got a report card writing Database and been trying to get a value list working all weekend, but just can't seem to do it. I've got a table with the fields (and a few examples below) as follows; COMMENTS table -------------------------- ENGLISH CATEGORY He is smart Positive Comments He is hard-working Positive Comments etc... He is lazy Negative Comments He needs to focus Negative comments etc... His reading ability is good Reading comments His Reading is improving Reading comments etc.. ...and so on I've got another t…

• 8 replies
• 2.9k views

MariaAux

December 20, 201114 yr

Hello all! I hope everyone is looking forward to a pleasant holiday. I'm wondering if Im thinking about this properly. I have set up the following tables: event, employee, employee attendance. The event table is the "master table" I would like to have a portal that displays "active employees that are paid on a daily rate" That should come from the Employee table and the filtering I have set up works properly. I then would like to make new records in "employee attendance". It would be great if I could do so with the found set of the above filtered portal so I wouldn't have to manually select every employee on a daily basis. I have tried a few diff…

• 0 replies
• 848 views

dbfreak

December 19, 201114 yr

Hi - I have decided to replace a few drop down lists with small windows/layouts carrying portals. I have set the window height (via 'New Window') to 225px, but they always open at 167px. If I click in the window (outside the portal) the height changes to 235px! It does what I expect if I use a greater height measurement (eg: 445), but why is it ignoring me at 225? Is 235 a default minimum? And, if so, why is it opening at 167? It sets to 225 if I use Adjust Window (resize to fit) based on a background item, but I'd rather not use this.

• 5 replies
• 1.5k views

Wikisnoodle

December 15, 201114 yr

It would be really nice to have a simple "Locked: Yes / No" radio button on a record, so that nobody can accidentally delete data when they wanted to find something, for example. I can handle this at the layout level by setting access rights to a particular layout using a yes/no button on a different layout, but that's pretty kludgy. Is it possible to enabled/disable field Browse using a script or conditional formatting? Or to make it impossible to change the content of the field some other way? Could this be handled with a custom function? (Can't find anything pertinent at http://www.briandunning.com/filemaker-custom-functions/list.php) Thank you for…

• • 
• 2 replies
• 2.1k views

elipsett

December 15, 201114 yr

Hello great fellow forum inhabitants! Ya'know how you can put your cursor in a field and then ctrl-i and it shows the index and you can even if you want, show word index (although I have no clue why you would want that)... Anyway, can I give person script to bring that open for them to select from? Okay, I think it is kinda handy and it might save me from having to create value lists all the time. I think it would need to be like this person has cursor in field then types (something) which does not type into the field to activate the script. Or maybe it is button on top of layout? Possible? Or triggers? then lastly, if they put something in the fi…

• 7 replies
• 2.3k views

Charity

December 14, 201114 yr

Hey all. I hope that I have a simple question, but it has been evading me. I am looking for a thorough explanation of how FM evaluates context and relationships. I know that I have seen in the FM Help "there are two starting points possible for evaluating a relationship..." but it doesn't explain how it decides which of the two to start from. My particular situation: I am having troubles getting a portal to display what I want. I have three tables that are of interest in this case: Users, Searches, Lines. The layout is based on Users. I have a portal on one side that shows Searches, and I am trying to get a portal on the other side that will show the line it…

• 11 replies
• 1.6k views

comment

December 13, 201114 yr

I have a table A, which has multiple items for each record in a sub-table B, which itself has multiple items in each record for a sub-table C. The records in C are all from a Value List. I want to create a report that sorts by C first, then A, then B, like this: Item from Value List C ------> Record from A ------> ------> Multiple records from B ------> Record from A ------> ------> Multiple records from B Next Item from Value List C Now I've tried using the Wizard, but it doesn't completely work. I get items from B in one group that belong to more than one A, without getting a new record listed for A. On wh…

• 8 replies
• 1.3k views

benwiggy

December 13, 201114 yr

I have text data which starts with a number, e.g. "1. Blah", "2. Blah", "3. Blah" .... etc. The data may also include "4a. Blah", "4b. Blah". The data is listed in a portal, and I want to sort the data by the leading number. Is there any easy way to do this, without 10 appearing between 1 and 2, but rather after 9....? I suppose I could put leading zeros, but I'd prefer not to. Thanks

• 3 replies
• 913 views

comment

December 12, 201114 yr

Dear All, Just registered here for my first day with FM ! I have seen other posts related to the topic but never really solve my target which is like a set of Drop Down Menu "Russian Dolls" like. I have modelled my database with several tables : Country : CountryID CountryName SubRegion : CountryID SubRegionID SubregionName SubRegion1 : SubRegionID subregion1ID Subregion1Name SubRegion2 : SubRegion1ID subregion2ID Subregion2Name I have created separate tables to avoid data redundance for obvious reason. Relations created based on shared fields (CountryID between table Country and SubRegion, SubRegion ID between SubRegion and SubRegion1, e…

• 1 reply
• 1.7k views

TyleDurden

December 9, 201114 yr

I have a list of patients included are the fields below. I would like create a list based off of the Insurance field and make the portal only display the patients with the selected insurance type. Is this possible? Field Names Name Insurance type Address Location

• 2 replies
• 901 views

GP inc.

December 8, 201114 yr

If I show the Formatting Bar so people can see the bold, italic, underline, it works but it does not show all of the formatting listed in the menu, such as style. Why not? There is space for Style and all formatting options to fit across the status bar. Am I missing something obvious? Surely FM did not include Bold, Italic and underline but then forget everything else. I keep looking for the hidden button to show them.

• 6 replies
• 1k views

Fitch

December 7, 201114 yr

Hi folks, I have a layout that is a template for printing CD labels. It never fails, however, that whenever I use it, it appears the whole layout needs slight tweaking to line-up properly with the CD labels I am printing on to. Since my file has users locked out of entering Layout mode, is there a way to somehow script buttons that can nudge all the objects on the layout up or down and left or right, by tiny increments, like say a few pixels? Currently the only solution is to enter Layout mode and select all the objects and manually nudge them. But if this could be accomplished in browse mode using scripted buttons, that would be great! Thanks fo…

• 4 replies
• 1.1k views

MattFM

December 7, 201114 yr

I would like to limit the size of any photo a user may upload to a container field to a maximum size of to 300 kb. Is there a way to set a maximum allowable size? Field Validation? How would I implement this? Thank You, Greg

• 0 replies
• 1.6k views

Gregory_I

December 7, 201114 yr

I am completely stuck. I created one table and one self-join relationship. I put a portal in the layout. The portal has three fields. RecNum (Calculation), Field1 (Text), Field2 (Text). Each of the columns in the portal has the possibility of sorting data. Just by pressing the column header in the portal. Depending on the sort order of rows changed in the portal. RecNum displays the row number. Up to this point everything works as expected. (Copy database in the attachment) Navigation.zip What I wanted to do? 1. Highlighting Rows in the portal I based on the following article where a similar situation is described. There is…

• 3 replies
• 900 views

comment

December 5, 201114 yr

I'd like to create a field label that overlays a text entry box and that disappears once an entry is made in the field. Any pointers appreciated.

• 2 replies
• 7.2k views

Lee Smith

December 4, 201114 yr

It is late at night and maybe I shouldn’t be posting, but I can’t get this to work the way I think is should. Users are requesting a “Back” (and “Forward”) button. We all know that they won’t work “exactly” like a web browser, but they still want it. What I did was use the “onLayoutExit” script trigger to set the variable $$layout to the Layout Name (or ID). Then I have a “back” button/script that says Go to Layout "$$layout”…simple right? Well, my little brain can’t get it to work. The layout recorded is the Layout that I go to not the one exiting from. So the “back” is the same layout. Uhg. Why is this? Feeling dumb and frustrated…especially if a bug!

• 11 replies
• 2k views

Bailey Kessing

December 3, 201114 yr

Hello, I need some advice on formatting a portal that has a lot of fields. I am enrolling students into a summer music camp (i.e., Event) and have to be able to keep different joined records for every year and keep separate records if the same student enrolls in multiple camps during the same year. Students -< StudentEvents >- Events Enrollment works fine, but the trouble is that I have a lot of data that needs to be in most StudentEvents records such as: Heath Form (just a yes/no box); First Payment, Type, Receipt; Second Payment, Type, Receipt; Final Payment, Type, Receipt; Roommate Preference; Roommate School; Dorm room; Additional Information; T-S…

• 3 replies
• 1.5k views

LaRetta

December 3, 201114 yr

Hello once again, After some time away from this forum, I've chosen to revisit & streamline my current travel agency related FM solution even further to make data entry more efficient. I've encountered a small problem while not critical but is annoying/time consuming; for this I need your wisdom. Situation as follows: From my drop down value list of contact names (containing hundreds of them), via a portal, I assign 3 participants to an airline booking... let's call them x, y, z. To do so, via a portal, I scroll thru the dropdown value list to find participant x. I then repeat same process to find participant y & z. Tedious to say the least. …

• 0 replies
• 973 views

skingjack2

December 2, 201114 yr

I am new to this forum. I joined because I am pretty new to Filemaker and I have just come through a problem I do not know how to solve. The Filemaker has, among others, 2 DB tables: Books and Artists. They are both related through a N:M (many to many) relationship. The user can select an Artist on the Filemaker solution, and then relate a few books to that artist. The user CAN NOT relate any artist to a previously selected book: this option oes not and will not exist. I would like to create a drop-down box for Book Title, but store the Book ID. I would like the user to be able to type the first few letters of the book title and have it cycle through the li…

• 0 replies
• 3.2k views

martaegluu

December 1, 201114 yr

More of an annoyed rant and a quest of why but: I discovered that when having a list of conditions to evaluate (on hold - open - open passed due - closed in that order) that if the circumstances allow for say past due and on hold to resolve as true, thus satisfying two of the conditions, the last in the order is executed instead of the first correct condition encountered... why? This seems to be counter intuitive unless I'm missing something? If it encounters the first condition in the list and it resolves as true, why waste time continuing down and evaluating the others in the list???

• 2 replies
• 1.9k views

jhomer

December 1, 201114 yr

Hi, I used the Insert Picture to place an image but mistakenly got the images from another unrelated folder thats not distributed. The ruuntime test fine showing images on My Computer ...however when i install on a virgin machine.. I have missing images.. (forgot and distributed to a client ummmm) Here is the question.. How do i see the properties of path etc of a image.. and i don't think you can?? I couldn't figure how to trouble shoot but copy my application files and folders to virgin computer so when I run it... I could now see "Missing Image File.png" Then able to see which layouts.. a bunch too And I can fix it.. Is…

• 3 replies
• 1.3k views

MParker

November 30, 201114 yr

I am developing a simple invoicing solution, and I need to provide a report that has a summary of information from 2 other tables. For the life of me, I can't seem to figure out how to apply the date range to the calculation. to simplify: table1 = labor sales, table2 = Item sales (assume each has a date field) I need to create a report that gives me summaries for a date range, a page that just has "total labor sales for date range" and "total item sales for date range". Can anyone give me some pointers on how to get the numbers to reflect the date ranges. Perhaps I don't understand how the relationship needs to be setup. Thanks kindly

• 3 replies
• 1.3k views

thejkfarr

November 30, 201114 yr

Hello , i have a database with a portal that looks something like this. this is the portal item qty '''''''''''''''''' 234 1 234 2 234 2 234 2 328 1 328 1 can i make it look like this? i need the item subsumarized by item number item qty '''''''''''''''''' 234 7 328 2 please let me know Thank you Mauricio

• 3 replies
• 1.1k views

Fitch

November 29, 201114 yr

Hey All, just wanted to know of best design strategies for user layout? Dashboard(s), tab panels, portals ( to show related information), multiple layout(s) or single layout with multi access panels. Ideas, other posts within forum would be great. thanks,

• • 
• 7 replies
• 5.7k views

Vaughan

November 29, 201114 yr

I am using FM 8.5 on a Mac with a database of 50 labels. i am using the supplied template for Avery label L7161 (18 labels per each A4 sheet) and it all lines up and prints lovely EXCEPT every 7th address in the database is not printed! I confirm that 18 labels are printed per page and that the page is set to A4. The labels are printed down and then across. Why would FM omit printing what would be the 7th (and, thus, off the page) label of every column? Any suggestions on how to remedy this situation? Roger

• 3 replies
• 864 views

LaRetta

November 29, 201114 yr

FMForum Members, my apologys in advanced for possible spelling mistakes but my written english is not that good but here goes..... I have a number of functions in a value list. This value list is used as popup when a new volunteer is created. When i create a Task i use the function value list to filter the volunteer list to set one or more volunteers on that task Now my problem: I woult like to see that when i choose a volunteer for a task that that name dissapeers from the list, a so called dwindling value list I konw that its possible i hav seen a number of examples but i cants figgure out how to make it work in my setup. attached …

• 3 replies
• 1.4k views

comment

November 28, 201114 yr

I have three tables. TabA, TabB, TabC I set relationship : TabA >--- TabB >--- TabC I created a portal based on TabA_self. I want to display a some field from all tables. I have no problems with the TabA and TabB. I do not know how to display field "ParameterC" from the table TabC. Copy database in the attachment. joins.zip Please explain to me, how to do it.

• 12 replies
• 1.5k views

comment

November 27, 201114 yr

Im using two screens screen1 : To add employee details [with name, address.. etc] screen2: Showing employee details in portal list. And i hosted this FileMaker application to fm server. and opened in two terminal. first terminal is screen1 and second terminal is screen2. My problem is when i add a employee in terminal1 in first screen, the employee will not be shown automatically in screen2 with the terminal2. When use the "refresh" script in terminal2 the records showing properly.. but without click the refresh,the employee records cant showup by automatically in portal on screen2. What can i do to show the employee record in portal on scre…

• 4 replies
• 871 views

Guru Salem

November 26, 201114 yr