Conditional Formatting

Hi, Is it me or we cannot do conditionnal formatting based on global variables? Check the attached file, it's quite simple. I want to use two buttons to navigate through tabs. The buttons call the "gotoObject (objectName)" Script which set the global variable $$currentObject to the destination object name. The conditionnal formatting must match the $$currentObject. BTW I forgot to add a format to the "Text" button. forum_tab_button.zip

Hi, I have a button: NEW RECORD Now if there is already a record, I would like to change the text into: EDIT RECORD The Problem: I have two tables: FIRST TABLE, SECOND TABLE The button is on the layout of the FIRST TABLE and if I klick it goes to layout of SECOND TABLE and will create a related record in the SECOND TABLE. How could I check if there is already a related record? (It's a one to one relationship) THX by ChiSao

I'd like to conditionally set the size and location of a field but have had no luck figuring out a way to set the filedBounds values. Any suggestions where I might find info on this?

I have a functioning system whereby I hide a button using an empty textbox. It works perfectly, except that Filemaker will *not* let me set the "hide" color of the box to match the background. I have tried everything I can think of (using the eyedropper tool, setting the background to a stock color from the color picker and then setting the "hide" color to the same one, letting Filemaker screw up the color of the button and then changing the background to match)... no luck). Filemaker always insists on making the "hide" box darker than the background. This is driving me nuts. What am I missing?

Hi All, I have a layout with a sub-summary part that works just fine when sorted by the breakfield. What I would really like to do is use some sort of conditional formatting to simulate a "alternating background fill". Here's the difference: I don't want to literally alternate every other row. I want to color them in groups. So, the first subsummary part, and all associated body parts are one color. Then, the next group is an alternate color, and so on. I've searched a lot for this, and haven't found a solution, and I keep running into dead-ends while trying to write a clever conditional formatting statement. Can anyone point me in the right direction?

The attached file is an example of how you can do the following: 1) The active record is automatically highlighted when you access a record 2) Ctrl + click on a record to highlight more than one record at a time 3) Shift + click to highlight all records between the currently active record and the one you click on 4) Click the "View Highlighted" button to view only the highlighted records in a new window 5) now open a new window and do all of the above again - each window has it's own set of highlighted records! All documentation is in the file. Requires FileMaker 10. keywords: highlight current record, hilite row, hilite record, select row, sele…

Hello Everyone. I have this FM 10 i have a portal with 35 rows, i have to enter dates into one field i have a button that duplicates these dates then i go back and enter my Dates. I would like to do this. If i have the same date twice i would like it to turn RED with conditional formatting. how do i do it. : :qwery:

Hi - I am wanting to conditionally format an object based on the value of of a GetLayoutObjectAttribute calculation field: Focus = unstored calculation; GetLayoutObjectAttribute("tab_1" ; "isFrontTabPanel") However, the Focus field does not seem to change value in an "unstored" way. When selecting different tabs, it changes on the layout only when I click into the field - but it seems it IS changed in the underlying table because when I click into and then out of the object (another field) that is conditionally formatted (based on the value of Focus), the conditional formatting works... but this does NOT change the displayed value of Focus... and I definite…

Haven't been able to figure out if this is possible - if there is more text than fits within the boundaries of the text box on screen, I'd like to change the background color or give the user some other clue to click on the field and read everything.

I've searched the entire site looking for conditional AND format AND checkbox but didn't find anything that addresses my particular question. In an event tracking db, I have a portal in a layout (based on the events table) that shows all the expected participants (from a join table - registrations - between participants and events) for a specific event. In the portal I have the participant's name, attendingStatus (yes, no, no response), and a field called activities_mealsLodging. This field is linked to a value list -- a hard-coded list of possible meals and nights' lodging (basically the same for all events) and looks something like breakfast_1, breakfast_2, lunc…

I have a table with a field called "sex" for the user to enter "M" for male and "F" for female. I have a healthcare report that requires that I display a box for male and a box for female. I am looking for a way to put a field on the report for "Male" and a field for "Female" and I want the "Male" field to display "X" if the table field sex is "M" and blank if the sex field is "F". I want the same conditional formatting for the "Female" field on the report to display "X" if the table field "sex" has "F" and blank if the sex field has "M".

how can i do a calculation that i will get if it is a even number the .... ?

I have a budget layout that may be modified and submitted several times. I need to know the most appropriate way to highlight the fields that have changed since the last time it was submitted. My brain says use conditional formatting but I don't know how to tell it...If (Field01 *has been modifed since* SubmittedDate" Any help is always appreciated

Normally you can't put a border around a merge field because Field/Control - Borders isn't available. I found a way to put a box around merge fields that appears to be an anomaly. I'm using the Windows version of FileMaker Pro 10 Advanced. In Layout mode select a database field that's formatted the way you want the merge field text to be formatted and click on the Format Painter icon. It doesn't make any difference if the field has or doesn't have borders defined. Now click on the merge field. It will show a border. Go to Browse or Preview mode or print the page and that border is still there. Useful! To get rid of the border, in Layout mode select a field like …

Hi, I'm new to filemaker and am trying to create a check box which will display an object when pressed. How can I do this with conditional formatting or am I barking up the wrong tree? Thank you.

When the laps = a certain amount of miles ie 100,150,200,250 I would like to automatically enter Todays date in that particular field. The file (YMCA 50 Mile Club 2 Excel Converted Copy.fp7) can be found at (public.me.com/rsrys)

I have a global field with a conditional to change colors on certain events. I am using that field in many layouts and tabs across my app. I created the global and set the conditionals, then I copied that field everywhere I want to use it. I thought I could go back in and change the conditional on the global field and that would propagate to all other occurrences of the field, but it only changes on that one. Is there a way to setup a field with conditionals so that if the conditional is changed, it will change in every use of that field? I thought maybe with a calc field, but I could not get that to work either. Thanks.

I've looked, and haven't found an answer to this question. Say that a date field is black, bolded. You want a conditional format that evaluates the date in the field, and if past today's date, changes the color to gray and removes the bolding. If you use text functions in a formula, eg TextColor or TextStyleRemove, do you check the relevant button on the conditional dialogue, eg Text Color & Bold, or leave it unchecked? Would not the formula be: Case ( Self < Get ( CurrentDate ) ; TextStyleRemove ( TextColor ( Self ; RGB ( 206 ; 206 ; 207 ) ) ; Bold ) ) Yet it doesn't work, whether I check the button or not. Thanks fo…

This will probably be another 'duh!' for me, but I can't get a conditional formula to work. I am trying to get a value to appear in red when it is out of range. Yes, the values 'not between' works dandy. This time, however, the range depends upon the gender of the person. So here is the formula I wrote: Case ( Gender__lxt = "Male " and RBC__lxn > 5.9; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Female " and RBC__lxn > 5.1; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Male " and RBC__lxn < 4.5; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Female " and RBC__lxn &l…

Hey people New on here, so be gentle... I have a table named 'ASSESSMENT' which creates a primary key '_pk_assessment_id'. Within that table there are also two foreign keys, '_fk_student_id' and also '_fk_unit_id' which both link back to the STUDENT and UNIT table respectively. What I would like to know is, how can I put in a conditional (and what do I need to put) if I want to check if the combination of _fk_student_id & _fk_unit_id exists within another _pk_assessment_id row of data. Not sure if I've explained it properly, but basically there can every only be one instance of the combination between _fk_student_id & _fk_unit_id and I want to …

Hello, I have a database with two tables. In the first table (rgbtext) there is a text field "Category" with 3 other number fields "red" "green" "blue" The second table (rgbcontainer) has a text field "Category" and there is a join between the category fields. In the second table I have a calculation field called category_color that uses the TextColor function and pulls the values from the red, green & blue fields I also have a container in the second table which I'd would also like to display the same rgb color as the category_color. So it needs to pull the "red","green" & "blue" values from the rgbtext table. I've messed with the condition…

I want to create a help file for my runtime app for my office. It will house alot of info and want it condensed enough to not take up to much space but still be able to scan thru a large grouping of topics. Is it possible to have a list of topics on a layout and when you click on a specific topic it opens up so you can read the info about the topic underneath it and minimizes when you select another topic?

I'm working with two tables, Vendors and Products. There's a join table listing matches of Vendor IDs and Product IDs. The interface shows two portals, one listing Vendors, the other listing Products. When the user clicks on a Vendor its vendor id goes into a global. Vendor #9 is selected by the user. There are two records in the Join table showing "9" in the Vendor ID column, with a value in the adjacent Product ID column. I need those two Product Names in the Products portal to become bold. How can this be done? With appreciation

Hello again... Conditional formatting does nor work in IWP-environment, but is there any way to get around that limitation ? I remember that I saw somewhere a trick to do that but now I cannot find it anymore... //R2D2

I have a daily calendar that's linked to our service ticket table. Sometimes more than one item is scheduled at the same time, it's okay if multiple items are scheduled on the same service ticket number. But there is a conflict if multiple items are scheduled at the same time for more than one service ticket. For example: Ticket 123 Termite Insp 9 am Ticket 123 Home inspection 9am Ticket 456 Termite 9 am I want the field to go red or add an asterisk, something so I know that there is a scheduling conflict. The scheduling conflict would be ticket 456. I can conditionally format when there are multiple items at that time but I want to do it based on t…

I found this inconsistency the other day. It seems as though when using a date format on a merge field in conjunction with conditional formatting, conditional formatting fails. See attached file. ConditionalFormat_DateFormat.zip

I'm using filemaker 7 adv, my users are on fm8 I need to change the text color of my "days" field, if the value meets specific conditions. Days = <90 color green Days = >90 color blue days = <120 color yellow days = <180 color orange days = >270 color red Heres what I tried so far. I'm not sure if i need if/else or if im on the right track just need alittle guidence. The code i have below was working for conditions 1 and 2 but thats it. any help is appreciated. thanks Case ( days ≤ 90 ; TextColor (days ; RGB ( 51 ; 153 ; 0 )); + days > 91 ; TextColor ( days ; RGB ( 102 ; 0 ; 204 )); +days ≥ 120 ; TextColor ( days ; R…

Hello, Is there a way or plugin that would allow me to create or validate a text field with a fixed number of lines regardless of the number of characters. Thanks RudyM

One of my tables has a certificate layout that, when printed, generates what is essentially a Certificate of Merit with the person's name on it. That layout has, among other things, a field for the person's name. The field's default text size is 60pt and it works fine. The problem is that sometimes there will be more than one name in that field. It's even possible that there could be many names in there (like, 15 or more) and 60 point type won't cut it. I've managed to set up conditional formatting that will adjust font size based on the number of words. Generally this works well except when I have really long names to contend with. So when it's "John Smith, Mar…

History 2::Status = "broken" & Contacts::Contacts_TId="2". I sued work if this to condition ate true?

I have a CMS in Filemaker where the fields that remain to be filled in by the user are highlighted in red through conditional formatting. Is there a way to determine which fields on a layout are coloured red, so that when the user tries to exit the record I can check that all the necessary fields have been filled in? Or is there another way to organise this? Many thanks in advance, W.

I have created a simple data base for my wife, and for reporting I have imported a word file that I need to circle 1 of 4 in a list. Since the text is there, I would like to format an oval to be black or white if conditions are met. I know that you can do this with a field, but can it be done with an object?

Hi - my apologies if this is long winded. I'm creating an employee management system to keep track of conversations and issues that arise. I'm using a portal which has a drop down menu allowing the manager to choose what if any action was taken regarding an issue: ie, verbal, written warnings, final notice, suspension termination etc. I've got a line of text (outside the portal) at the top of the page which will allow the view to quickly identify if the employee's issue record was flanged with the above action. This text pulls it's information from the 'Action' field in the table. The conditional formatting works great when the specified value is met d…

I have a 'Membership Form' layout showing customer details which I print blank for new customers to fill out. Problem is, I also merge some organization data onto the layout from global fields in a settings table e.g. branch, area etc. That works fine for the merge fields in the header, but those in the body print blank (of course) when I 'Print Blank'. Is there a way around this or can I not have my cake and eat it too?

I am trying to setup my own version of a barcode scanner to be used in conjuntion with FM. I have it working but when I scan the barcode i get the characters to show up however it doesnt tab once entered like excel. 1. How can i get it to auto tab once a specific number of characters are entered. I am using 3of9 barcodes and will need alpha numeric setup. 2. Can I set to to know that if the first three(3) characters are alpha and the rest numeric then it enters and if its doesn't have alpha characters for first Three(3) then its null and doesn't do anything.

I have a several identical buttons (Jobs, Vehicles, Tasks, etc.) that I'm using for navigation among layouts. All of this works OK, but here's what I'm wondering: If I give each button an object name that corresponds to a layout name, can I use conditional formatting to give that button a different formatting when that particular layout is active? In other words, if I assign the Jobs button the name JobsDetail, can I change the formatting of the Jobs button when the JobsDetail active is active? I generally know how to use conditional formatting but don't know how to set up this particular formula. Thanks for any help. James www.james-mc.com

I know this is a simple one, but I'm not quite getting it -- instead of labelling a field using text above the field box, I'd like to have the field name *in* the box, and have it disappear if there is a value entered in the field (in which case the purpose of the field won't need labelling). In the olden days we did this with a calculation field, but I know there's a simpler way now with conditional formatting. So, have typed the label the same color as the background, and set the formatting to use a darker color if the Field IsEmpty" -- but of course, now the label becomes visible as clutter because the value entered in the field is black and the backgound color…

I have 5 different "fact" fields that I am outputting in a merge field. The challenge I have is when one of the fact fields is blank, I get a orphaned bullet point with no content. Is there a way to build conditionality into the merge field so that bullets are omitted if the following field is blank?

I can't imagine this is possible, but, I see the topic here, so I'll ask. I have a table that defines various terms for paying royalties. Basically, it's set up as: person Rate type (value list: fixed, percentage) rate Amount (such as $1675 and 3.875%) Now, I know very well that the rate amount can happily hold 1675 and .03875 But, when I print the report for anyone, they need to see the info as $1675 and 3.875% Suggestions? I looked at Format->Conditional and that helps me a bit... I could make anything > 10 be formatted in bold, for example... but that isn't ideal. Thank you !

I tried to post before, but can't see it anywhere, sorry if I've double posted. I'm trying to conditionally format a field according to whether or not a record with the same id exists in another table. I'm using this... PatternCount( List(OtherTable::ID ); ThisTable::ID) >0 but if ID number 10 exists in the other table, the item in this table with ID 1 also seems to meet the condition. Gotta be an easier way right? Phil

I have a "status Field", and i created a new field, that i would like to fill Green is the Status Field gets change to "approved" (drop down List) or Red, if the Status Field gets turn to "Not Approved" any ideas how to do this. Thanks

Is it possible to use conditional formating to format a number field in a portal so that if the number is lower than the number above it in the portal the text will turn red. Month Amt Jan 20 Feb 19 text turns red Mar 16 text turns red Apr 20 May 19 text turns red

Hi, Is there a way to "paste" conditional formatting from one object to another? When I use the brush tool the text and everything else gets formatted, too. But I want only the conditions and the results of the conditional formatting transferred, without having to write everything time and agin... Thank you, Mike

I want field "A" to be auto set to 1000 unless field "B", "C", and or "D" have a value of a number less than a 1000. I need the new value to be defined as the new value. How would i do this without looping it?

I have a text field called "message" I want to be able to type a word in to a global field so that every instant of that word that appears in the text body of "message" is then formatted/highlighted. Is this possible using conditional formatting? Any help greatly appreciated.....

Is conditional formatting supported in IWP. I can't seem to get it to work..... Ive checked the help file and nothing seems to be mentioned.

I have a field in the same layout that displays a total weight of a product in stock. By the use of the product the weights gets lower, I have a conditional calculation that makes the text red when it reaches minus (-). Is there a way to calculate the color green when the weight hits close to zero (0) amount like as a warning that the product is low in stock. so for example 1000 g - regular color 50g - green color -1 - red color. How can that be done? Thanks

I want a button to 'disappear' under certain conditions. But when the conditional format is applied, the 3-dimensional shading for the button still remains. Buttons that have been around forever (FM6 or earlier) don't seem to have the 3 dimensional effect so do disappear. Is there an option for button formatting that removes the 3-d effect so I can make the button completely 'disappear'?

I am using the the following conditional formating rule to control the attributes of a button: If (GetLayoutObjectAttribute ( "Tab 1" ;"isFrontTabPanel") = "0" ; 1 ; 0 ) My Layout has two tabs. I want he button to behave differently depending on which tab is active. What I am finding is that the formatting works correctly, but it does not take effect until a "Refresh Window" is done. For example, I click on Tab 2 and the button is grayed out the way I want it. I click on Tab 1 and it remains (incorrectly) grayed out. I want it to take effect as soon as the tab is selected. I get the desired results only if I do a Refresh Window after each tab selection. …

Hi there, can I use the conditional formatting using a variable as part of the field name. The example is:- I have quite a complex set of conditional formats and I want to write a formula which takes account of part of the field name: I have "field 1" to "field 53" I want to have a formula to read something like this:- if(GLOBAL NUMBER>rightwords(getactivefieldname);1);colour blue;colour red) Can that be done? Or something like that? Or a custom function? I am sure it is easy, but I'm blowed if I can find how to do it! Thanks in advance.

I have a table of around 25000 "Parents" and 11000 "Children". I want to display the Parents (or a foundset thereof) in a List view, each with an indicator (implemented by Conditional Formatting) of whether or not that Parent has any Children. I placed on the body of the layout a related field Children::Name, and set Conditional Formatting for the field as follows: Formula: Count(Children::Name) = 0 Format: set fill=red When I display this layout in Browse mode, it renders VERY SLOWLY - row by row - and puts up a Find-in-progress message between each one. Each row takes about 5 seconds to add to the list. When displaying any significant number of paren…

I have tried many times to figure out a good way to adjust the space of the border around a text field. I dislike that there is only 1 pixel space between the border and the text when the text is left Justified. I would also like to add more space to the top and bottom of the text. Any suggestions on how to add more space? Thx

In FMP10 Conditional Formatting doesn't always evaluate consistently. The script involved is just a single step, set a field value. Conditional on that value the field contents change colour. That's it. I've added a Refresh Window step but that doesn't make a difference. I suspect it has something to do with exiting a field because clicking on a neutral place on the layout forces the evaluation when it stalls. In FMP6 there was an Exit Record script step, but not in FMP10. Any ideas? Kind regards,

Hello all, I have a field that I would like to make inaccessible, unless a checkbox has been checked. Is this possible in FMP10? Best regards, Jes

Anyone know why the "Value is" condition in the conditional formatting drop down would be grayed out? I have one condition already set based on a "Formula" and need another using "Value Is".

I'm trying to put a conditional format on fields in a sub-summary layout part. The condition is a 'formula' condition. The formula tests whether a summary field (count of records being summarized) = 1. FM does not apply the conditional formatting. Is this a limitation of the conditional formatting?

I have a report which gets printed as a pdf. It contains several categories - the category name field is in the leading subsummary part, the break field is the category name. Very often, the body of any particular category continues on the next page of the report. I have put the category name field (along with "cont'd.") in the header as well with the condition that it not print on the first page. So far, all is good. When the category at the end of the first page continues onto the second page, the top of the second page shows the name of that category cont'd. However, sometimes, the categories do NOT break across pages. How can I formulate a condition so that the header…

Hi All, I have lists of ingredients in my recipes, and when these are special ingredients, ie relying on my seasonal garden or that need to be bought from the shop, I want their text to change colour as a warning when contemplating what to cook. My Ingredients table has both "Ingredients" and "Ingredients Source", but I have no room in the portal to show the Ingredients Source, so want to change the colour of the "Ingredient" text itself. I've tried using the formula in the conditional formatting dialogue box by saying that IngredientsT::IngredientSource = "Seasonal Garden" but this doesn't work. Is what I want possible? Thanks heaps!

Is there an easy way to conditionally format a field if the value is a non-integer?

In Filemaker 9 is there a way to Conditional format check box row color or at least text color? I want to "check" a few check boxes and have only those rows be highlighted (Red). I want to also "check" other particular check boxes and have only those rows be highlighted in a different color (Green).

Is there a way to have a field "Invoice Number" to be blank when starting, and then have the user input the starting number, after which all subsequent records would increment by 1 and still allow the user to over-ride the data if needed?

I don't know is this correct place for this. (sorry if its wrong section) My question is that. I would like to have so called ghost text in few fields. this ghost text would explain what other users should write in those fields. Idea was that I have ghost text there that is maybe gray colored and when you click that field or start writing in it or click it that ghost text would dissappear. At the moment I have just written that text in that field and selected option that when you click that field it selects all text inside of it. When user starts writing something that text disappears, but this has created few problems so I would not use this if there …

I'm not sure that this can be done with conditional formatting, but I couldn't think of what a better approach would be. Basically, I just want to get my fields to show their own names when they're empty, i.e. the First Name field will contain the words "First Name" until you enter something into it. This seems like something pretty basic, I apologize for the newb question if it's answered in the help - as I say, I'm just not sure what to look under. Thanks in advance!

Hi All Looking for some newbie help here. I'm trying to figure out how to deal with "nested" data... That probably didn't make sense because I have yet to see the term 'nested' used in databasing, so I'll try to explain... I'll put this example out there: in a table for cars, I've got a field called "car maker" (can you see where this is going?) So attributes of a field for car maker would be Chevy, Ford, Honda But under each make are several models: Chevy -silverado -lumina -cavalier Ford -Focus -Crown Vic Honda -Accord -Element etc etc.... So I can see how this would be set up in the table - a field for make, another field for …

Is it possible to highlight the active row in list view using conditional formatting? Thanks! James www.james-mc.com

Hi, I'm creating labels. I have 3 text fields : prefix base suffix I have a calculation field with text as a result that goes like this: prefix & " - " & base & " - " & suffix I want the result to be : prefix - base - suffix So I used the conditional format : value comprised between - and - but I do not obtain the desired result. Any suggestions? Thanks PS this is a liberal translation of the Filemaker commands as my software is french. If you need further explainations, please let me know.

How would I do a calculation in conditional formatting the would say "turn the text red if it is before today's date." I am getting suck on the date part. How would I specify a changing date like that?

Left over from earlier FM versions, I have some fields with unstored calcs used to conditionally highlight records/fields. I saw somewhere that unstored calcs slow down your solution. Would I be wise to delete theseunstored calc fields and just conditionally format the relevant fields/objects now that CF is available in FM9?

Create a table with two text fields, "Color" and "Sample". Allow the user to enter a hex color (e.g., FF0000 for red, 00FF00 for green, etc) in the "Color" field, and have the fill color of the "Sample" field change to that color. Possible?

I have a text box like: texttext <> text and field name are normally different colors On a certain condition, I want both to be invisible on a white background, so I set the condition for the text color to be white. Under that condition, only the 'texttext' part of the box becomes white. Anything I can do?? TIA

I am trying to highlight multiple entries in a portal by using conditional formatting. So far, I can only get it to highlight one row at a time. Does anyone have any suggestions on how to make this work? Thanks!

I dunno if anyone has done this as a sample yet, but here is one just in case there isnt one out there already. Highlighting portal rows in FM9 using conditional formatting. It will work with seperation of data as well, so no more added relationships and calcs needed in the data file strictly for highlighting purposes. Enjoy. Highlight_portal_FM9.zip

hi everyone, i suppose the answer to my question is very easy: how can i highlight the search results in a portal row field thank you

I want to be able to highlight a portion of the text in a field and then run a script to change the text's color. Is there a way to do that? Thanks

I want to have a button under "IM Names" so the user can change the field label to what they want, IE Yahoo, MSN and so on. Any advice on how to make this button perform this action?

Hi all, I have a button that performs a script that can only be run once per record. Is there a way of reading a field in the table that stores whether the script has been run and then hiding the button so that it cannot be run again? many thanks Rich

I would like to have all numbers with a length of <2 prefixed by a zero. 01 02 03 How could pre-pend the zero when the user exits the field? Thanks, jdholzen

I have 2 fields, "Dues Paid" and "Dues Due On" to calculate if dues are current or delinquent. However, the code is not working. Say the dues are paid yesterday and today is the due date. The word "Delinquent" should NOT show but Current should. However, that is not the case. How do I make it so if dues are paid today and due yesterday, it will still show current and not delinquent? If ( Dues Paid > Dues Due On ; "Delinquent" ) and If ( Dues Paid < Dues Due On ; "Current" )

I have been trying to get conditional formatting to work on a tab. I want it to change to be either yellow or blue depending on what is in a particular field. Any ideas???

I'll cut right to the meat of the issue and will be happy to elaborate upon request. I have a database with membership numbers that are a different length depending on the global region (North America, Europe, etc.). I wanted to flag membership numbers that are not the correct length for the region by using conditional formatting to change the field background color to red. Here's my problem. I've chosen "Formula is" for the condition and specified an "If" function for the calculation. But I am not getting the results I expected, the field is changing to red for all records, not just the incorrect ones. Perhaps it's a logic issue or perhaps I'm not writing …

I'll try to keep this as simple as possible. I'm designing a comprehensive database in which one element logs uniform inventory and assignment. Generally, the uniforms are distributed as separates (i.e., jacket #13 and pants #24, not necessarily matching jacket #13 and pants #13), thus it is necessary to record all uniform components separately. In order to accommodate the various measurement methods used (i.e., chest/bust/waist for jackets, and waist/length for pants), I have a radio button field named Measurement Method, as well as individual fields for each measurement per method listed. The idea is that all measurement fields are grayed out and are invalidated unl…

Hi all, I am new to this list and have a question. Is it possible to format the second third and subsequent entires in a list so that they are not seen. I have a list of entires in a portal that are listed in date order - fields are date, event name, start time. However, to make the list easier to read - see that there multiple events on the same day - I wish to supress displaying the date of the second and subsequent entries so that only the first date shows in the list. Year - 2008 Month - May ___________________________________ 4 May | Rehearsal Follies | 4:00pm 7 May | Myrid Dance School | 9:00am | Farmers Market | 2:00pm 9 May | Ec…

Could anyone help me solving this? How to create a script for the Flag that can control the "NO" and make all fonts inside "Description" becoming bold + underline, even when I print out? Example attached. Best James Portalrow.zip

I'm trying to get some system of conditional formatting to display RECENT or OUTDATED depending on the date with regards to a "Date" field. I'm just a newb, so be nice =P I'm not sure if I can do it as a drop down list and set it up as values (0 = Recent, 1 = Outdated) or if I need to set it up as regular text (Displaying Outdated to match background when within desired time period... and vice versa). I've attached a quick .fp7 to give you a visual and the field names. Thanks for any help. Dated.zip

two questions: 1) i have FIELD 1 wherein i input data separated by semicolon (. sometimes there can be 2 or more values. what i want is on FIELD 2, to put automatically the first value. so if field 1 contains: group1 ; group2 ; group3 then field2 should contain only group1. 2)somethins like q.1 above but this time the separator is not ; but a space between data. thank you for any help

This seemingly simple problem is stumping me. Basically, I have a Checkbox and I have some text (not a field, just some text on the table). I want to set it up so that when the checkbox is NOT checked, the text is invisible (that is, the same color as the background) and when it is checked, the text is bright red. This seems like it should be easy (and it may turn out to be) but I cannot seem to find any way of checking if a particular checkbox is checked or not. Any help would be appreciate. Thanks.

In the old days (pre-Conditional Formatting), if I wanted to give a background color that would changed based on a field's contents, I would use a Calc field resulting in a container. Let's say I have a layout with 30-35 of these fields, would conditional formatting be slower over a network than these calc fields?

Hi: I want to have a button that allow me to show all records. But i would like to show this button only when a "finding" operation makes records to be filtered (showing the records that fit the finding request). Can you help me? thanks! Jaime Bunzli

I have a database of companies with a dropdown field ("Status") that lists their membership status as Active or Inactive. I'd like to conditionally format so that the "Company" field goes grey when the user selects Inactive from "Status". My mind's drawing a blank, here - any help appreciated!

[color:red]Can someone help or point me in the right direction? I'm trying to make a Drop-Down Menu, Check List, Pop-up Menu, etc... that creates a condition for a resulting layout. For example: If checked/selected Client, then display "Client" layout. If checked/selected Prospect, then display "Prospect" layout. I think it's possible... if it is can anyone point me in the right direction? If one were to enter info as a Prospect and change it to a Client (later down the road) could I get information to transfer to the Client layout fields or would I have to make a "Lookup Function" or a script? (I.E. [set Field [Clientes::Companía; Prospectos…

Hi, Can I define a repeating field in a script ? Like how we define the array ? I will have different number of values each time. I want to count the values .. say 3 array[1]=aaa array[2]=bb array[3]=cccc then use the values from array. The number of values will vary each time based on how many products the customer orders. I know we can define the repeating field in the table, but is it possible to define this kind of variable and assign the values in the script ? I know that we can get the values from the repeating field using GetRepetition(variablename;#) or just variablename[#] But how do we define that in a script and assig…

I applied CF to a field. I had a few scripts that would end with script step "go to field". After applying the cf, A user stated her button wasn't leaving her in that field as the last step anymore.. the script ran and ended it but didn't perform the "go to field" step. I tried, Insert calc.. just to leave cursor in that field, I tried set selection, insert text. Finally the only thing that I was able to do was name the field as an object and then use the "go to object" step. Anyone else encounter this?

I've attached a file showing basic worksheet I'm working on. These repetitions will pre-fill with statistical data and also allow User entry. There are 5 portal rows side by side. The child records are one per year (as specified in StartDate plus numb_months (the number of months to jump ahead). Records are then created which span this period. There will be NO need to ever report on these worksheets. If the block being displayed is between (and including) the start month/year and the end month/year, I would like the repetition to turn white so it is clear what period of time is 'predicted.' So in 2007, January - April will remain grey but the remainder of 2007 …

Dear peepz, Could you please share with me how the auto-calculate function work? I have made field3 store the result of the addition of field1 and field2 in the same table. However, when I enter the data for field1 and field2 in the form, field3 remains empty. Regards, Farah K.

Simple example of using conditional formatting to change content of a calc field. Global variables are set by conditional formatting "Let" statements. cfcontent.zip

Is there a way to designate which repetition number in a repeating field the conditional formatting is applied to. I can add a formula to a repeating field but it always changes the first repetition. Thanks, Steve

I would like to change the color of a text button using conditional formatting. The formula needs to be based on the priviledges of the user on the linked layout (forward). When I use "Get ( LayoutAccess ) > 0", it is just returning the access of the layout the user is currently on. I need it to read the access of the layout the button links to. Any thoughts of how to do this? thanks,

Help. Sorry, I've seen posts about this but for some reason, they don't seem to help me. Simplified: Fields: APPROVED CONTRACT_PRICE CONTRACT_PRICE is typically editable. But, if APPROVED is checked, or not IsEmpty or whatever, CONTRACT_PRICE becomes not editable. *I am not using buttons to initiate any scripts. *I'm assuming I can do this as a calculation w/in one of the the two fields. *I don't know where and I don't know what functions/language to say "Don't make this field editable anymore". Thanks a bunch.

I thought I'd try building an interface that used conditional formatting instead of the status area to indicate Find status but I'm running into some odd things. 1) Get(RequestOmitState) doesn't update immediately. The function will update in the Data Viewer, but not the formatting, until I perform a script step or navigate to another request. 2) Both G(ROS) and Get(RequestCount) persist even when in Browse, Preview, or Layout Mode. I guess FM is storing the request for the Modify Last Find and Perform Find[] script steps. Both are easy to work around (1-change the button from running the Omit script step to a script that runs the Omit step followed by …

Is there a way to make a field perform a specific search? Say I want to find all records with "Colt" in them, I want to type "Colt" in the single field and have it search all records for that word. Any advice?