Conditional Formatting

I am looking to implement a a flag that would indicate if any records meet a particular criteria. In the header of a layout I would text to show up red if any record in the table has field1 with a value of "myValue" The idea is that any record that was created by a particular user will be scripted to set field1 with the value of "myValue". I want a flag to show up for a higher level operator to review that record. // Just to express clearly I do not want the flag to only show up on a record that said user has created, but rather a flag to show up on every record to indicated there is a new record somewhere that the higher skilled operator needs to revi…

I have a text field that holds a text of, let's say,17 lines long. When it has more then 10 lines of text, the surplus of that text has to go to another textfield. So I have textfield A that is 10 lines long (holding 10 lines of text) and a textfield B that is also 10 lines long, but holding 7 lines of text. Regardless of the length of a text line. So I don't have 17 Carriage Returns to identify a line. Just 17 lines of text that could have only 3 Carriage Returns. How can you do this? Appreciate your answer in advance. Wilfred (I have FMpro 12 on Mac)

I have an attendance status field which should reset everyday at 23:59 to a blank field. Please advise how to create a condition attached to the field to perform the task? Regards, Kishan

Cannot get this script step to work and can't understand why it won't work.

I would be grateful if someone could help me with this calculation for Conditional Formatting. I have a birth control portal that gives the next birth date according to the last service. I would like the birth date to change colour with the proximity of the event. For days > or < my formula works but not for a range of dates eg 255-269 days If (Birth control_HEATS::HEAT = "LAST" and GetAsNumber(Get(CurrentDate)) - GetAsNumber(Birth control_HEATS::SERV_date) = 255-269 ; 1 ; 0 ) I have tried using 255...269 and 255..269 but not accepted.

Is it possible to format a field so that the field's font size changes downward (reduces) when the text is longer than the field size. The object is to allow the data to fit the field content and avoid a 'wrap'. Sometimes one only needs to drop down a size (12 pt to 10 pt say) for a text to fit. It would be a useful characteristic or option for field behavior. One wants to be able to set a minimum font size since dropping down to a 6pt or 4 pt font might not be a desirable outcome. Thanks

Hi, I'm putting together a database in filemaker 11 to schedule volunteers for events and I was wondering if it is possible to have the text color change in a portal row if a volunteer gets scheduled for more than one event at the same time. So far I have 3 tables: Volunteers JoinStaffVolunteers Events Each Volunteer record has a portal that lists all the events that the volunteer has signed up for, and each event has a portal listing all the volunteers that are going to the event. I would like the text to change to red in the portal rows if the volunteer gets scheduled for two (or more) events that take place at the same time. Is this possible, and if so h…

Hello! I'm a complete novice and I'm wondering why some of the edit boxes turn red when I add additional fields  to my table?   I've added a picture on this! Really thankful if someone can help me!

Hi, I'm hoping to divine a way to achieve the following: If a particular condition is met, a checkbox will be displayed, otherwise, "invisible". I'm familiar with using conditional formatting to achieve this type of result with text fields, etc., but of course, conditional formatting cannot be applied to the line attributes of a checkbox. Any ideas? Thanks!

I need help with the above function. I have a database with companies. In the date box for when the accounts are due say 01/01/2013 - If the date goes past this date then I want the box to change to red. Example when the date goes to 02/01/2013 then the boxes turns red. Hope someone can help as I am new to filemaker. I am using Filemaker 10. Thanks for any help.

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

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

Hi. I am looking to "grey out" a screen as I bring up a custom dialogue box. I have tried to achieve this by having a dummy field covering the whole screen that is normally transparent (no fill), upon opening the custom dialogue box, I set the fill (through conditional formatting) to be 50% grey. For the most part it works, but what happens is that on the main screen is a tab control box, and this seems impervious to this method - even when the dummy field is brought to the front. Can anybody offer an explanation, a fix, or an alternative method to achieve this? It's purely aesthetic. Thanks, Greg

Hi, sorry if this has come up before, I've trawled through the posts but can't find a solution I've an Activity table with Date, Time, and Activity fields .. the data is filled in using one layout but I've another layout for printing it and on this print layout I want only the first of duplicate Dates printed and thought using conditional formationg to turn the date white would be a solution (i've used this elseswhere in the program and it works fine as we print only to white paper) at the moment I get 17/5/2012 9.00 checked doors 1 & 2 17/5/2012 9.15 checked doors 4 &15 18/5/2012 8.14 checked doors 3, 4 &5 I would like it prin…

Hi All, I was wondering if there is a possible way to turn on/off for "Allow Entry" to a field in Browse Mode. I would like the user to click a button to make the field "Active". If not possible, is it possible to set a conditional format to resize an object? Let's say I have a web viewer, when I click a button, the web viewer expands to a set size. Any help would be appreciated. Thank you, Dave

I want to conditionally format something based on the most record portal row field value. Another words, ff the most recent portal field value = "yes" conditionally format a corresponding label to read "required". How would I do that?

Does anybody know of a calc for conditional formatting that is based on whether the record has been committed. I have not been able to find an answer to this with a bit of web searching. many thanks in advance. Mike

I've got a field/checkbox with 1 single box to check. I'm trying to make it so that when the box is checked another set of text turns red, and when its not checked it stays its normal color. Any help? Thanks

This might be more of a script issue than a layout question, but I'll ask anyways. I was wondering if there is a way to format my text in a field to automatically space out on the "tabs" of the layout? I am trying to make a list with multiple columns and I don't know how long the input will be, so just putting in spaces could look correct for some input but bad for others. (i.e. In java I would use the tab escape character \t to line up the tabs) Is this possible to implement in FileMaker? Thanks.

Hi everyone! I'm relatively new to filemaker but I think that what I'm trying to do is relatively simple. I have a layout which I use to track cash. On one of the fields (Income_Expense) I have a drop-down list and either select "Income" if I want to record money that I received or "Expense" to record money that I have paid. What I want to do is: When "Income_Expense" field is set to "Expense", then "Expense_Amount" field (which is the number field where I write down the amounts) is negative. How do I write this statement?? Thanks!

Hi. I have no clue on this one. I have a table that, based on a code, gives the name of a color. When bringing in the name of the color into my related database, I want the text (red, blue, etc) to be its color. So if the code brings back the word "red" I want it to be in red or at least have the shading or something in that color. Any help here? Thanks. Mike

Hello, Would like to know if it is possible to copy the conditional formatting of one field and apply it to another field or do I have to do each field separately? The situation is I have a layout that has 4 columns of portals each having 12 rows. The same type of info is displayed in each column/row. One field has conditional formatting applied to it which changes the color depending on the content of the field. I would like not to have to manually apply the CF to each column field as there are 7 tabs that need to be modified and there are 16 CF conditions that need to be applied. Thank you Michael

I'm not sure if this is possible, but I currently have a script that replaces field contents of several records when I run it. I view these records as a list and I'd like the fields whose data has changed as a result of this script to highlight...but I only want the fields to stay highlighted until I run another script (or add a condition?) to remove the highlight. It's just a method of keeping track and double-checking the fields whose data has changed whenever I run this script.

I am not sure of best way to explain this, and i am feeling a bit overwhelmed with the concept of boolean values, but here goes... I have an 'orders' databse which contains 'order line items'. suppliers often deliver only part of an order. I want to conditionally format a parent record (order) for which delivery is incomplete. So far my thinking is as follows: in the line items have created a boolean value for 'delivered'. I want a summary field to total the number of items on the order that have been delivered and a summary field to count the order items. So if items delivered - items counted = <0, then the order (parent record) is still PENDING. …

I'm not sure how to do it, as far as writing the formula, but here is what I am trying to do: I have a little table on my database that has a list of 6 vendors, each with a start and stop date. I want them all to be color filled grey, unless I enter something in the field Vendor One, then i want the start date field and stop date field to be white. I can do the conditionally formatting that says "if not empty" then make it white, but I need something in a forumla that says basically "if Vendor One's field is NOT empty, then make the Vendor One Start Date white and the Vendor One Stop Date white". Any help would be greatly apprecaited! Thanks.

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. …

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…

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…

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.

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???

I'd like to have a conditional format have the ability for the same field to respond differently to two variables. So, if choice 'A' is selected in the field it would alter the fill color to red while if the condition is 'B' the same field would alter to fill in green...is there a clculation I'd use for this. I can easily format for one condition but multiples is very different... Thanks... Dr.L

I have a file which I am setting up preferences for my client to change the look of the file without entering layout mode of course. So I'm using conditional formatting on the backgrounds and text field labels. Nine of the tables are the main data entry screens. However, on 2 screens I can't get conditional formatting to work. I used container fields that provide the backgrounds where they can select a color from a repeating field of 24 choices. This works like a champ, including the 2 screens in question. I used radio buttons to select from a value list of colors. The condition is formatted as such: Global fields::TextLabelColor = "White" Global f…

Hi, Is it possible to add conditional formatting to a drop down list? I was hoping to add a second field to my list that would show 'In Stock',then if the value contained 'In Stock' it would highlight in red. This would allow me to quickly identify the items in the list that are in stock. I have the second field with this info, but a colour change would be even better. Thanks in advance, Skip

As shown in my attached screenshot, I'm trying to print a list of records from a found set, but only those records where the value in the LEDGER::total summary field is equal to zero. Currently, the layout is showing all records, not just the records where the total field is equal to zero. I thought I could use Conditional Formatting to accomplish this. If the field's value is not equal to zero, I want to "skip" these records by changing the text colour of each the fields to white. But, I'm not getting the desired results (the result is that it white's out all records). I thought using Getsummary function in the formula would help, but no. Any ideas? Thank you from…

Hello, I am new on File Maker. I'm using FM11 Pro. I want to learn how will I colour same date with conditional formatting? Thanks.

Hi all, I've created in my solution a portal for navigation purposes (see attached images). For the user it is clear on wich record they are when the portal row is highlighted. And beside that it is visually atractive. This kind of highlligting do we see on websites all the time. For this highlighting I'm using conditional formatting. The formula is: If ( Table::id = TablePortal::id ; RGB ( 204 ; 204 ; 153 ) ; Self ) where TablePortal is a TO from table with a cartesian relationship. A strange behavior occur. When I enter a number in the displayed field on the details area the row stays highlighted in the portal when i click another record. …

I am attempting to limit selection of calendar days to only use "Friday" and only in the future and not in the past. Is it possible to do this with Filemaker's built-in calendar drop down using conditional formatting? If so, can someone help me with how the calculation might look? If not, can you share your thoughts? Thanks

Hi, I feel a little dumb here for this easy question, but I could not figure it out. How can I display an optional date over a container field using conditional formatting a check box? - There are 2 fields : datePicture and showDatePicture. - The user has the possibility to show or not the date by checking the showDatePicture box. - There is always a value in datePicture. I was going to set the text of "datePicture" to clear pattern, but... surprise there is no transparent color for text. Is there a way to set the text transparent to make it invisible over a container? Thank you

The background color of my layout body is a black. I have a portal sitting on top with alternating white/light grey background fills. The field on the portal row is set to transparent. In BROWSE mode that's fine, as the field reveals the color of the portal row below. However, In FIND mode, because the field is transparent, it is showing the black background color of the body fill. Is there anyway to control the field background color in FIND mode so that it doesn't show the black background color of the body fill. If i add a color to the field, instead of being transparent, then it looks odd against the alternating portal field rows. A…

Hey Everyone, I've run into some formatting issues with a date fields i have. I opened up the file this morning and i discovered that my "expiry" field has a question mark instead of the date, i haven't changed anything with the layout and the field is definitely wide/tall enough so i don't really know whats causing it. When viewing the records the field displays the question mark, but when i click into the field in browse mode the question mark disappears and the date is displayed... This particular field does have custom formatting to show mm/dd/yyyy but the question mark doesn't go away even when i change the date format back to the default. I have also tried deleting…

This is a weird use of filemaker but I would like to script a slide show either between layouts or between records with container fields. I would like to have any suggestions you might have to make crossfades or transitions between records. thanks very much.

Hello all! I'm trying to figure out how to make the following conditional formatting problem work: I want it such that there is a red or green circle filled in (or perhaps displays a graphic of a red vs green button) depending on if all the data for a row is filled in (if all is filled in, then green, meaning complete), where as if there is information missing, then the button is red (meaning there is information for that specific record which is incomplete). I seem to be at a loss however on how best to accomplish this. Could someone please point me in the right direction? Thanks so much!

Hey guys. I have a database that creates a time schedule based on currently active records. I would like the text from the schedule in List Mode to be bold if the records above (and/or below) have the same start time. Basically I want anything that could be considered a double/triple start, etc, to be bold so it can catch the users attention. Thanks

Hi, Is this possible to change the Editbox border color dynamically by based on another record value. In my application if Qualification is selected from dropdown . Then the department editbox should shown. Other wise it is in hide state. Initially the department edit box ahould be invisible. I try to change the edit box background color as background color of the application. But can't change the border color using the conditional formatting. Thanks,

Good Morning, I'm working on a layout which requires conditional formatting based on the value of a related record in a one-to-one relationship. When I add the conditional formatting in the layout which the portal is based on it works without a problem, but when I add it in the portal directly it doesn't work at all. The calculation dialog when setting up the formatting states "This calculation will be evaluated based on context determined at runtime." Is conditional formatting on portal fields evaluated from the context of the portal, or from the parent layout? If it is from the parent layout, is there any way to force it to evaluate from a different context? …

Hi Filemaker Gurus! I have an OutsourcePrice field, a MaterialCost field and a LabourCost field all on the same table. How do I set up a condition that if the OutsourcePrice Is not empty, then the text color in the other two fields changes from black to a light grey? I want the user to be able to see what our cost was (in light grey text) even if we end up going with an outside provider for the product, and have a price entered in the Outsource Price field.

Hello, new to filemaker 11 and stuck with this: i have a LIST_orders layout here in are the fields orderid, productnr, productname, orderstatus, price what i want is that when i take a look at the layout List_orders that the complete records have a conditional format based on the value of the field Orderstatus for example when the status is backorder the whole row colors yellow, when it has the status send the whole row colors green i have been searching to solve it with a formule in the conditional formatting if(orderstatus = "backorder" ;0;1), but all the rows even with status send are colored yellow when i added another formule = "s…

We are creating a layout to display in table view the status of an order. We are giving it the ability to show either open orders or all orders. When viewing all orders we would like to use conditional formatting to change the background colour of the completed order rows to a different colour (say red). How would I go about this (if its even possible)?

Ok I have a summary report that groups a bunch of records in various sizes and have a summary count field to let me know how many records are in each grouping. Is there a way to set conditional formatting when I breach a total number of records ceiling, but only format the group at which the breach occurred? So right now I have a field that shows a "running total" and I can set the conditional format to trip for all the records after a record number ceiling has been breached, but what I want to do is only highlight the group where the ceiling was passed not all groups after. Any Ideas?

A button that contains text calls a script that sets a global variable ($$MultiAssign) "True" or "False" based on the current state. I want the buttons fill color to change, based on the state of the global variable. The initial format of the button is black text with a red fill. I've set a Conditional Format Formula $$MultiAssign="True" to change the fill color to green. I have verified the state of the variable in the Debugger, however the button color does not change :! Any suggestions or advice will be sincerely appreciated. Daryl

I am trying to highlight a record in a portal where the portal record ID (departmentsFL::ID) = an ID in a global field list (VIEWER_vwr::highlight_g). The IDs are alpha-numeric. I used this: PatternCount ( VIEWER_vwr::highlight_g ; departmentsFL::ID ) This is flawed because the ID DEP1 and DEP11 are both true for PatternCount(). How can I scan a list of text and check for unique text and numbers? Thanks.

using conditional formatting, how can I make a value color red for example, if it is not equal as another field on the database... I'd tryed: 1) Folrmula is: DATA::sdomo1 ≠ DATA::sdomo2 2) On conditional Formating of the Field named "sdomo1", Value is not equal to DATA::sdomo2 (then the text color change). How can I do this? what i am doing is a comparison of two entrys... If Entry A is not equal to B, to display an error message, or the color change... but I have no idea how to.. Thanks!

Hi I have a lot of fields to create conditional formatting for and their formatting is based on a second field, a different field for each one. All of the fields follow the same format. EG. the displayed field that has the conditional formatting on is JA1 and the field that determines its formatting is JA1 Copy. To save a huge amount of time I would like to set all the fields at once determining the referenced field by formula ie JA1 + copy. Is this possible? Many thanks John

I have a layout with a conditional format background field with different colours depending upon future week for each record. This works well for any Account with Full Access privilege however Accounts with a lesser privilege do not have their records conditionally formatted. Suggestions for remedy please. John

I have a trailing sub-summary that has a summary field in it. It calculates the total amount of hours for each of the sorted records. I'm trying to make a conditional format based on the value of the summary field but it doesn't work. It seems to only recognize the field as it's total quantity and not by each sorted record set. Any suggestions?

I am trying to create a medical database for my Emergency Department. I have very little experience with FM Pro Adv 11. I have been using Lynda.com and this forum to answer my question, with little success. I am trying to construct a dynamic form, that changes the questions asked depending on answers given earlier on in the questionnaire. I have created an example (attached) -nothing related to my database. How would I get the >Fruit< and >Dairy< tabs to disappear if I answered the first question by ticking both >Meat< and >Vegetables< (multiple checkbox field). Then, within the >Meat< Tab, if I tick >Beef< in the 'Meat options…

Without actually attempting yet to develop a solution for font sizes and layout difference required for different screen resoltions per workstation, I thought it best to ask about this topic to get a better understanding of what others have done, or what is recommended to address it. I'm talking about how fonts are too small to read on some screens with super hi res display settings. If I changed the layout font on the fly (if that's even possible in FM)then the text would overlay other layout objects, fields, etc. So it seems like I have to create an entirely duplicated set of layouts for the hi res systems, rename them with a prefix of, say, Hres_ or whatever, edit them…

I have a phrase that pops up in red on our work order that reads " Inventory in stock " when the condition is met. Why is the condition popping up in the FIND mode?

Is there a way to change the color of the layout body based on a calculated value? Currently the only thing I can think of is to have a duplicate layout with the different background color to achieve what I need. Anybody got any other ideas? thanks Christopher

I'm trying to have my textbox highlight a row of fields based on what the field's value is. The pseudo-code I'm trying to accomplish: If FieldA ≤ 12.5 AND FieldA ≥ 9.55, highlight Green. If FieldA ≤ 9.5 AND FieldA ≥ 6.55, highlight Grey. If FieldA ≤ 6.5, highlight Yellow. Since it is a Textbox, I have to use "Formula Is" and this is the calculation I have but doesn't work. Formula is Case ( FieldA ≤ 12.5 and FieldA ≥ 9.55; "Green";) What am I doing wrong? Thanks for your help!

Is there a way to conditional format and Field so a user can not enter information. I have a checkbox=1 I would like the corresponding date field to be able to be accessed otherwise no access. Can this be done by conditional format? Thank you

Hi, I have a number field that I'm giong to change the text color if the value is in a certain range. I don't know how to use the TextColor function in my script.. this wouldn't work- SetField(household::days; textcolor(255;0;0)) What should it be? Thanks!

hi all. i hope this is the right forum to post this in. please point me in the right direction if possible. i have created a small database for a projection booth that tracks what movies/prints are playing in certain auditoriums, etc. it also keeps track of problems that happen and i've included a log in the database. the log entries are displayed through a portal for that particular day. i want to include a "flag" button for each entry, but i'm unsure on how to make the button highlight the particular portal row that needs to be flagged. highlighting the row isn't necessarily the only way to "flag" entries, but it's one option. perhaps it changes the color of the te…

I have a form that uses conditional formatting. I would like to print the form exactly the same, but without the conditional formatting alterations. Is it possible to print without conditional formatting? Thanks, Fed

im building a database to record my data on all my pet reptiles and i have a lout that records medical information, on this layout is a field with value yes or no, which tells me if the animal is currently under medical attention. im trying to conditionally format this so when the animal is under medical attention it would show either a image or a text label on the main records screen over the animals photo saying something like "Medical Alert" and is the dropdown box is selected to "No" then the image or text label doesnt show. is this possible in filemaker 11?

I need the text in any of a certain set of fields to appear red if the field has been modified after a given date. Every two weeks or so, the formatting is wiped and all text returns to normal, and the tracking begins anew. Currently, I've accomplished this (in FM8) using an audit trail that tracks which fields have been changed. Each field has a corresponding calculation field, and if the name of the field is found in the audit trail, this display field changes color. This works perfectly, but now that we've finally upgraded to FM11, I'd love to know if there's a better way to do this without hard coding the field names and/or needing to have the slew of correspondi…

Hi, This should be an obvious one, but I can't see the solution right now. I'm trying to alternate the filling color of a label in a portal row. The label is transparent and is used to hide a button when a certain condition is met. Using conditionnal formatting, I tried with "Get (RecordNumber)" and "Get (ActivePortalRowNumber" without success. Here's my calc : Mod (Get (recordnumber); 2) = 0 or Mod (Get (ActivePortalRowNumber); 2) = 0 Any clue on this one?

I have a database full of fields where people are typing alot of content. The content fills the text field and you need to scroll down to see the text. Works fine, till you need to print. The person who made the database has it so that if the text is bigger than the box, it won't print the "hidden" text. I'm sure there is a way to do this, but it's been 2 years since I was in doing code and my brain is rusty. Can you help me figure out how to make a layout base the field size conditionally on the amount of text within the box?

Hi, I need to extract some text in the date format. For example in my text field as below, every line looks like this, starting with a date part which does not have consistent format. 3/09/2009 - text text more text here... 4/9/08 - etc etc The year part sometimes is in 2-digit format and sometimes is in 4-digit format. I would like to have the format set as MM/DD/YYYY in the final product. I've already set a date field comment_date and plan to extract the date part from the comment box to this field. Wonder if anyone has a good idea on how to do so? My current method uses GetDate() function but does not return valid output for some dates..

Hello all, I'm a little bit new to FileMaker and have been tasked by my employer to make several updates/changes and additions to many of our clients' databases. I was wondering if there was any possible way to have conditionally expanding/contracting field or object sizes (or even conditionally visible/click-able) based off of a calculation. I have seen that there's a sliding/printing option to constrain them but that's only helpful for Print/Preview mode, rather than for what I need (Browse mode). Essentially, I have a container field used for special purposes in a Portal which I need to be of certain sizes based off of the entries found in another, rel…

Hi experts, I want to conditional format a field when the field contains a name with extension of .txt, .pdf, .bmp, .gif, .jpg, .png, or .mov. This one will work, but I'm wondering if there is a better way to write it. PatternCount ( Test::Uploadnames ; ".JPG" ) or PatternCount ( Test::Uploadnames ; ".png" ) or PatternCount ( Test::Uploadnames ; ".pdf" ) or PatternCount ( Test::Uploadnames ; ".txt" ) or PatternCount ( Test::Uploadnames ; ".gif" ) TIA for your kind assistance. Kiele

Hi, I have created a layout for keeping records of all the projects my company is working on. I have created a field called 'Status' which is a drop down menu containing 2 values: Live and Complete. There is also a field in the layout that is for entering the name of each project. I want to use conditional formatting to change this field to the 'StrikeThru' style when the 'Status' value is changed to Complete. I have tried creating an If formula within Conditional formatting but its not working. Any help would be much appreciated, Ruby

Hi, I'm using checkbox in my layout, and realized that the multiple options in the checkbox are dislayed in one line/row. I just wonder if there is any way to separate the different options by rows? e.g. checkbox with three names will look like "Sarah Leah" in the checkbox. Can it be changed to Sarah Leah Thanks! :

Hi, I wonder if there is any way to reformat the time input in FM.. The default is hh:mm:ss AM/PM. Can I change that to 24-hour type of time input? e.g. hh:mm (with hh in the range of 0-24) Thanks! :

hey guys i've been lurking around a bit, trying to figure out conditional formatting. so far it doesn't quite make sense to me. i have a status field, let's say it's set to 1, 2, or 3 i want to change the color of the field and text based on the status. the examples i've seen of the conditional formatting allows me to make a container field change its color to red, blue, or green. but how do I get this container screen to evaluate the status value? i remember doing this for an invoices database i did back with filemaker pro 4 a long time ago in a galaxy far away.

I created a field called "background color" that is conditional. So if a company is a current customer, this field will be solid green. I placed this field behind several other fields so that the entire row is green ( or other color depending on condition ). On the screen, everything is perfect with the color, but when I print to printer or to PDF the this "Background color" field does not print. In otherwords, the background is green on the screen just like I want it but it does not print to printer or PDF like is shown on screen. I also made sure that the color field is not touching any border that may prevent it from printing. I even experimented with reducing its size…

Can anyone tell me why i am seeing this anomally in conditional formatting in FMP 11 Adv v 2 on win 7? Looks like ive got the calc and relation right but conditional formatting is only affecting 3 related records when i would expect that 7 are affected. See attachment. TIA Kris CondFormatting.zip

ok, here's a simple question, I think. I want to highlight (fill color of light yellow) the active field. Is there an easy way to do this?

Hi everyone, I have a date field in FM Pro defined as the auto-enter field which sets "Date" upon creation. But the output is DD/MM/YYYY which is the same as my PC's system date format. I would like to change it to MM/DD/YYYY instead. Anyone knows how to do so? I couldn't find any options in FM Pro to change the setting/format. Does it have to do with the system setting of my PC? Thanks a lot! :

Hy: I need to know, it's possible hidden objects, conditionaly. example: if value > 0 show object if value < = 0 hidden object Thanks

Hi, I have a field (jepg #1) that only shows the first 5 lines, and 90% of the time that's plenty of room to users to explain what they need, but there are sometimes that users will use 10 lines. Currently the only way to see the lines is to click on the field to extend it. (see Jpeg #2) I'm trying to see if there's a way to use the conditional formatting to flag the end user that the field has extra lines and he has to click on the field to extend. any ideas how i can do this or if its even duable. Thanks

I'm trying to find a way to set a preference on a report to show an ssn as either a full, partial (only with last 4 displayed) or all x's. How would I go about doing this?

I'm not sure if this is possible, but I was wondering if I can keep a user from entering ANY data into field1 if the value of field2 = "C". If the value is not "C," then they can enter anything they want into field1. I have a database that customers can use to generate product orders by finding items, entering a quantity and clicking an ADD button to add the item to their order. However, some of the items on the product list (which are pulled into a layout from a portal) can't be ordered by themselves because they are part of a larger kit, even though they have their own unique item number, product description and photo. A field called KITCODE will contain a "C…

Hi -- I have a Sub-summary List View layout in which I want to display the data with merge fields formatted as buttons so that the user can navigate to Form Views of various individual records of their choice. I want to enable users to do a Find on one of these fields, which I would like top put in the Header part. I know how to allow entry only in Find mode, fine, but I don't want the Field box to display any data when in browse mode -- just have the box appear empty. Is there a way of achieving this? Is there such a thing as conditional formatting based on "mode" -- so that in Browse I would make it invisible but in Find it would be visible as the user types…

Newb diving into conditional formatting needs help. I have two fields – “Date Received” & “Due By” “Due by” is a calculation field -> Date Received + 21 I would like to use conditional formatting to change the color of the “Due By” field Black for 21-15 days remaining Blue for 14-8 days remaining Orange for 7-1 days remaining Red for 0 days remaining I’ve been trying to come up with the correct calculation for Black only (baby steps) but I can’t figure it out. Am I remotely close to being on the right path with this formula? GetAsDate(Self - GetAsDate(Reviews::Date Received)) ≥ 15 and GetAsDate(Self - GetAsDate(Revie…

Using the "Modified By" selection thinking.. Is there anyway to set it to a specific field? Meaning that you can modify everything but once you modify a specific field it inputs the user name as the modifier? I assume if possible it would go in hand with time stamp as well. Or is there a way to log this info every time the user modifies the record/time/specific field?

Hi all, I am doing a conditional format in which I need to get the current year. Obviously I can get the current date but I only need the year. Is there a way to get current year? Thanks Ron

Is there a way of conditional formatting all the fields of a specific record based only on the conditions of one single field of that record? Example: Suppose I generate a report with a list of employees with fields like name, address, date of birth, etc... 1) John Doe - Poker Street - Chicago - 10/11/1952 2) Mary Lou - Chess Street - Washington - 9/15/1963 3) Mark Jones - Domino Avenue - Chicago - 7/22/1971 Suppose I want to highlight all the employees born in Chicago in my report by making the font bold for these employees. I can easily make the text "Chicago" bold by conditional formating it. But is there a way to format the whole line (includin…

Awhile back comment gave me this calculation to give me an expiration date on Jan 01 for some membership cards: Self≥Year ( Get (CurrentDate) ) ≤ Year ( Max ( expiration date::expire date ) ) This works perfectly, but now i need to add another expiration on top of it. The cards will have to expire 2 times now. The first date is Jan 01 and the second date is 6 months later on Jun 01(it is a six month grace period). I have been trying to get this to work: Self≥Year ( Get (CurrentDate) ) ≤ Year ( Max ( expiration date::expire date ) )+ Date ( Month ( expiration date::expire date ) + 6 ; Day ( expiration date::expire date ) ; Year ( expiration date::expire da…

I have a layout with a grid of 24 buttons, each one with an Object Name — 1 through 24. When the user clicks on a button I'd like to provide the user with visual feedback on which button was selected. My thought is to use Conditional Formatting to make the number bold, colour it, and change the fill colour as well. No confusion on which button was chosen. The CF formula I was planning on was something like "Get (ObjectName) = $$GlobalVariable" but I haven't found a way to signal to CF the current object name. Is there a way, or perhaps a workaround? Appreciated.

Hello all! I was woundering if there was a way to do conditional formatting on a feild to make it hide all of the contents of a certain field. For example you can do an IF formula to say if something is chosen in this field such as "Consumer", then hide this field (a feild that holds information for businesses). As that feild would be irrelevant for a customer. (if you know what i mean) Also i have added a botton to the form and when ever you click anywhere on the page it activates the button (this is annoying) lol. Does anybody know how to activate the button ONLY whne you click on it (not anywhere on the page). Many Thanks!! :)

I'm trying to make a 1 pt. horizontal line that is conditionally formatted to: Case( Get( PageNumber ) = Data_9_:${$$Last_Page}; 1) I can't conditionally format a graphic line so I tried using an empty text box but the smallest height the field would allow was 5 pixels (I formatted the font to the smallest size allowed within the field). Any ideas?

Hi all, I am working with a system which needs quite some reporting, so I have decided to use conditional formatting to create a nice overview. I have five fields in a column on my layout, and a "total" field. What I want to do is give the five fields a color based in their value: First I determine the minimum value and the maximum value. The fields that have a value within the highest 20% between those values are red, the second highest 20% are orange, etc. I use the following formula: Self ≥ ( ( ( ,8 ) * ( Max ( field1 ; field2 …

I have some price information in a field that I want to hide from certain users. I've been playing around with conditional formatting and did the following: 1) I did an image overlay that is transparent for "User X" and applied a white fill for "User Y". Apparently even with the image overlay, you can still click the field and it brings it to the front (displaying the price that was previously hidden). 2) I applied the same conditional format to the field itself. I left the text black for "User X" and turned it white (to match the background) for "User Y". Again, it works but if "User Y" were to click the field the conditional formatting disappears. Is…

Hello, I've created a database which tracks inventory. Some of the inventory items are "assets." My main layout page uses a portal to display the line items from each physical box where the various inventory items are physically stored. I'd like for the "asset" items on this list to appear in red. Each line item includes an asset field which records a "yes" or "no" entry. My current formula is: Inventory::Asset? = "Yes" However, this only works on the FIRST line item in the portal. Why is this? How can I get the formula to apply to ALL 20 displayed line items? (I initially had my db set up with fields "item 1" "item 2" "item 3" and so on...th…

Good Day, I'm trying to create PDFs from a simple data input mask. For simplicity, I have a few fields pertaining to the originator of the report followed by three blocks of fields pertaining to separate aspects of the report. Each of these three 'blocks' of fields has one field that can either be 'applicable' or 'non applicable'. What I'm trying to do is create a function to print/save a PDF that checks whether the 'block' is applicable or not and then omits or includes that block in the PDF. Any help greatly appreciated! best, Mat ps: I'm trying to not have to create 7 layouts with all possible block combinations. I do realize that that's a poss…

I have a field "XY" which collects values such as "A", "B" or "C". I'm looking for a conditional formatting formula which allows me to cover different parts of the layout in white. What I have is this: Transparent Layout Text 1 using Custom Formatting: XY ≤ "A" and XY ≥ "A" (--> fill color white) Transparent Layout Text 2 using Custom Formatting: XY ≤ "B" and XY ≥ "B" (--> fill color white) Transparent Layout Text 3 using Custom Formatting: XY ≤ "C" and XY ≥ "C" (--> fill color white) The problem is that this fills white if A, B or C IS part of field XY. How can I reverse that? I want the layout text to fill white when A, B, or C is…

What is a calculation I can use for conditional formating of a fields text color when on an odd portal row? For example: - if field is on portal row [even]; blue - if field is on portal row [odd]; white I'm looking for something like this so I can us a match field ID Field with the related human label on top. On a form view I would just simply make the top field a solid color and user could not see the ID field directly below it. But in my list views, I have alternating color, so obviously this does not work. I would HATE to have to sacrifice this attractive feature. I wish a user could tab to "pop up list" this would solve everything sense a pop up disp…

Morning. I'm linking images into a container field by inputting a link into the container field with the result being an image. This has been discussed on this forum before and works like a charm. I can however (for the life of me) not figure out how to 'center' that resulting photo within the container field. Can anyone give me a hint? much appreciated M

I am trying to make a field that is a expiration date field change to red(I can do this in conditional formation already, but i don't know how to set the jan 01), then at the same time I need another field that will change from active to expired(and become red) when the current date arrives to jan 01 2010(this needs to be done every year), Then when I go back and change the expired to active and the date field to jan 01 (ex. jan 01 2011) of the next year everything rests for jan 01 2011(and so on). Every person will have a different start date so i can not tell the calculation to expire in X days. I hope this is clear. Thank you in advance