Conditional Formatting

Greetings all: Here's a puzzler: In the style that I'm using for the attached edit box, I've chosen "No Fill" for Pressed and In Focus, but when I click on it I get a dark green fill; there's no assignment of conditional formatting to the field, either, so where is it coming from and how can I change the default(?) color from green to something less obnoxious? TIA for your help.

Hi Everyone, just wondering if it's possible. Here's a screen grab of two radio buttons, and I'd like to have it so that if a button is not checked (ie the button on the right), then its colour is changed to grey, rather than the blue that you can see. I don't think this is possible though? This is Filemaker Pro 19.6 Thanks for any advice

I am trying to write an IF/THEN statement than presents a dialogue box if the name field is blank. If it has a name is in the field, continue.

I'm building a survey app and I have multiple types of questions that fall broadly into two categories: Single Mention and Multiple Mention. Is there a way to conditionally set the answer fields to either be radio buttons or checkboxes depending on the question type? For example, each question has an "instruction" field that says if it's One Mention or Multiple Mention. So I'd like to do a condition like If MyTable::InstructionText = "One Mention" the responses are radio buttons and if it's Multiple Mention, it's a checkbox set.

Tables are Gigs, Performances, Singers, and SetList Summary. Gigs is the hub, and Performances is a join table that pulls other elements together. On the Gigs layout, I have a portal listing the singers in a Gig (bottom right circled in blue). I have a TO called OtherGigSingers on which this is based. The portal lists the names of all singers who share the GigID being viewed. I have another portal top/center which represents records from Setlist Summary. This table uses GigID and SingerInitials in related records from Performances to summarize information for a given Singer in a particular gig. This related table only has one record for ea…

I have a printed container label layout, for which a customer would like me to "invert" the colors of the Month of a date field. Is there a creative way to accomplish this, aside from creating three fields to separate DAY, MONTH, YEAR and piece it together? See attachment for goal. TIY!

I have a portal through which I create records. The relationship involves a date field in the parent table (so I set a date and then create the records in the portal that gets automatically the date given). I also use that date field to filter the portal content so I can navigate and see the created records. What I’d like to accomplish is what I’ve faked in the image attached. As I create several sets of records for different days, I loose track of what days have records created. So I came with the idea I represented in the image. What I’d like to accomplish is that in the given “string” of the 31 days (maybe a button bar?), what ever day that has reco…

Greets, all: I have a form where users are required to fill out a minimum set of fields for the record to be valid; once they do, a calculation within a Button Bar button changes its text from Incomplete to Complete. That works fine. What's problematic (to me) is that as the user enters text in the last field that requires data, the aforementioned button won't change state until the record is committed. I tried setting the Script Trigger in that last field to OnObjectModify or OnObjectKeystroke, but with every keystroke FileMaker barks "Before typing, press Tab or click in a field, or choose the New Record menu command," even with the Commit Record's dialog is s…

Hopefully I am in the correct forum. I am using FM Ver 14 to document accessory install dates. When traveling, I use an iPad (iOS) to track the dates, but update the accessory date installed on my iMac and share with my iPad. If I use the 1/22/2023 date format, my calculations are correct, however when I share with my iPad or iPhone, the dates are 01/22/2023, resulting in "Time in Service" date errors. How can I format the dates in order for the iOS (iPad) dates to show correctly? I have attached screen shots of the issue

Greets, all: I have a portal where I want to highlight the text field in it (in the first row) if a user fails to select a value for it; it would de-highlight after at least one value is chosen. I tried using not IsValid ( EVENT_PRESENTER::_kflt_Event_ParentID ) as a calculation, and it sorta works: the field de-highlights after the first portal row field has a value, but still highlights the empty waiting/next portal row field beneath it. Since the portal row isn't active (because I don't want to force the user to go to the field/portal row every time the record is loaded), I don't think a calc based on the active portal row will work...but I could be wron…

Hello. I may be aiming to do something that isnt possible and hence not able to do it, but thought I would ask before I gave up. I have a set of tabs in a layout, that shows multiple records below (based on a portal record filter.) It is cell tower information on signal strength. I have a field that for each record shows if the Quality of service is good or poor etc. I want to be able to make a conditional format, so that if there are say 5 records, if 3 are excellent, one is good and one is poor, the tab is marked with a colour to indicate poor (Being the lowest quality on that tab. I have gone around this by using a calc that m…

Hello Forum, another brain fog, despite doing this before, and looking at my files & sample files. I have these relationships: On the JOBS layout I have a portal of GALLONS. One of the GALLONS fields is Vehicle_Name. I want to attach a drop down list, conditional value list to aid in data entry (for IOS). So a CUSTOMER, can have many JOBS. And any JOBS record can have multiple GALLONS records (in the portal). What I want the drop down list to only show, are all the existing GALLONS::Vehicle_Name values, from the same CUSTOMER, regardless of JOBS. IOW, CUSTOMERS Bob has 5 JOBS records Debbie has 3 JOBS records Mike h…

Night all, Is there a way to get a count\s based on a conditional format. I have two a calculation field to determine time between to entries, then i have a conditional format for the calculation field if < 0 = color is "red", if > 900 = Color " pink. Is there a way to know how many are red and how many are pink. Thanks

Good day all, My apologize if I am posting in the wrong group. Can someone tell me why this calculation does no work. It always teturn the same value "Picking" I have a button bar with 6 segments, each element pertains to a department, i am trying to change the labels as each department enters data. It works is is not nested. Case ( not IsEmpty ( WTS v2.0::PickerDatePickingStart ); TextColor ("Picking"; RGB (255; 0; 0)) ; not IsEmpty ( WTS v2.0::PickerDatePickingEnd ); TextColor ("Picked"; RGB (255; 0; 0)) ) Thanks JMart

I have a portal which display fields songs titles from related tables. One such field indicate the Genre of the song. I'd like the portal row to change color based on the Genre field. My current implementation has a text field containing a space and sized the same as the portal row with conditional formatting. While this basically works, I find it inelegant, plus, when editing the layout, it's another object to deal with. Suggestions?

Hi Group how do i create a calculation / script to place data into the search bar in the top of the window? See image I want to click a button, then in the script i want to collect data from few fields (i can already do this) and then i want to paste the data as a search string into the search box (i don't know how to do this)

Hello, I'm sorry if I am asking a repeat question. I searched the forums and found plenty of information on formatting, conditional formatting, check boxes and so on, but not what I was looking for. I have a value list with checkboxes, and have formatted the default text. What I would like is for the text to change to a different color when the corresponding check box is checked. How can I accomplish this? Thank you for any help!

I use FM Pro 12, and I hope this is the correct forum for my first post. I have a text box on my website into which I often add dates in this format: 5th November 2020. Is there a way to have FM automatically change the “th” after the date number to the superscript version of itself? In other words, the date is entered as 5th November 2020, but FM changes it to 5th November 2020. By way of example, it is certainly possible to have Microsoft Office do this automatically, but I would like to know if FM is also capable of this function. Thank you Richard

I am not sure if this topic belongs here or not. I have field that I'm attempting to define conditional formatting for, and I am unable to scroll down to the table occurrence with the field I need. The bottom choice of the list is ZREP_UHLP_TH_TenantHistory, and zrep_uhpd_TAH_TenantAgreementsHistory is the one I need. There are at least a dozen others after ZREP_UHLP_TH_TenantHistory. I do not know many Table Occurrences for the 36 Tables I have. I have attached a screenshot of the Table Occurrences. Have I run into a limit of displayable choices? If so, is this solved with the 64-bit version of Filemaker? Thank you for any help.

Hi there, a guy came to me with this request: He used multiple fonts, sizes and styles under a text field and he'd like to reset that field to Arial - 14 points - Plain text. He has more than 4,000 records. Any suggestions to set the field with a new format?

Hello everyone, I have a Preference table with status options. The user can create a new status and through a script can assign a color (see attachment). The calculation is the following: Allow user abort [off] Set error capture [on] Set variable [$start ; value: Get ( ActiveSelectionStart )] Set variable [$end ; value: Get ( ActiveSelectionStart ) + Get ( ActiveSelectionSize ) -1 ] Insert Calculated Result [ TextColor ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize) ) ; Get ( ScriptParameter ) ) ] Set Selection [ StartPosition : $start ; End Position : Send$ ] The ScriptParamete…

I have a portal with the alternate row colors turned on. There is a field in the rows that is overlayed on top of another one. So as to not mess up the appearance, the upper field needs a fill. But this looks ugly in every other portal row. Is there a way to format this, depending on whether it's an odd or even row? At least in my v13 I can 't see this, but perhaps there's a better way to accomplish the same thing. Thanks

Hi! I have a list view which have 7 "columns" (Monday to Sunday) and about 50 records (rows). Looks like an Excel sheet with numbers. Is it somehow possible to highlight ALL similar numbers on the table (i.e. in all records) when I enter one field. Meaning... If there is number 1002 in the first record on Monday, entering the field would highlight all "1002" -containing fields in all the record. Conditional highlight seems only handle that one active record. I was thinking also a possibility to do a script trigger which runs thru all the fields and highlights similar numbers when entering any of those fields. Did anyone understand what I'm trying to do...?😁

Hi! I'm new to the forum and I don't know if this is the right place, if I'm not sorry. I am developing a database for a project in my school subject and I can't finish could they help me? The teacher asked us to create a formula so that following the SSN criteria and randomly and automatically the filemaker gave this number. The example he gave was as follows: When creating a new record student A automatically received the following SSN: ###-##-1234 which according to the same criteria is valid, repeating the same step student B automatically received the following SSN: ##-##-1235 which according to the criteria is the same.

How do I conditional farmat a portal row based off matching fields in another portal? I have created a table for employees with thier schedule for next 3 weeks. A global table so I may have two incidents of the same table filtered by global fields. This way I can display two employees schedules side by side using one table. So Table1 with Store Number, Employee Name, Work Date, Start Time, End Time. Table2 Store Number, Trainer Name(Global), Traniee Name(Global). Related field Table1::Store Number to Table2::Store Number. Table1 Copy::Store Number to Table2::Store Numbe…

Greets, all: I want to use a Conditional Formatting calc to apply to a set of (required) fields in a portal so that empty ones are highlighted in the first row of a portal, only. (The logic is that the portal must contain at least one record, so only first row needs to be used as a flag to users.) I tried using Get ( ActivePortalRowNumber ) in the calc but the problem is that unless a portal row is active it doesn't have row number. Any ideas? TIA for your help!

Dear Sir, i have 12 Images Random forms are irregular and i want to enter values (numbers) depending of these number how can i change these images color such example: if value no1 = 10 change color image no1 to red and if the number is 5 change the color to green ( 3 color for each value)

conditional Ok as often I have answered my own question, for any newbies with the same question. formula = field A = "Mrs" and field B = "Mrs"

In addition to the FM tab interface, I also use tabs that looks similar but actually move to different layouts (so that the table focus can change). Is there an easy way (in FM 13) to have the tab buttons change color just like the built-in tabs using a conditional format? Thanks, Stefan

I want to conditionally format the items (btns, fields) in the active row of the master portal. Thus my formula is : Get (ActivePortalRow) = Get (RecordNumber). This works ok, but when I click outside the portal, the formula no longer validates correctly. (however, in the Data Viewer, the Get(ActivePortalRow)=Get(RecordNumber). I am using FM17 on Windows 7 machine.

I have a field that contains a "percentage". I get data from several outside sources to populate this field. The rub is I need to format this field to read correctly as a percentage example 55% or 100%. The data come from outside sources as follow 100, 100%, 100.00 or sometime 1. Another example 55, 55%, 55.00, & .55.I would need this to all be one format with a condition, but I am having a hard time figuring out how to do this. I am sure it is easy but I am stumped.

Every January, I send out a note referring to the previous year. Is there a way to have the previous year inserted automatically in the sentence? ex. "Total number of hours served in 2017 . . ."

Good Morning I am wondering how I would go about this wee problem. I am developing a simple system which takes subs from members. I would like to display only the records that have paid, with an amount in a certain date. Any help would be great. Or maybe even if anyone has such a system developed already. Thank you.

I sometimes use a trick in Conditional Formatting to give fast hints in form views.. i'll place a merge field (name of field, or helpful hint) BEHIND the actual form, then will format the field to have a clear/no backcground, using a calculation of "IsEmpty(Table::FieldName) - to trigger it.. So if the field is empty, the hint is visible, but if there is any value in it, the hint disappears. See screenshot below.. The problem is that this falls apart in List View.. active fields work.. inactive don't.. what ca I do?

I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, even though 10 is larger than 9.8. When we change it 9.9 it isn't red, but 10.1 ma…

Hello forum. I'm in the process of rebuilding a FM12 db into a FM16 db. I have many places where I used conditional formatting to hide an object. Some layouts (mostly reports) there are many objects formatted this way. I plan to change them to take advantage of 'Hide object when'. Does anyone know which one renders faster? Or is it a matter of 'it all depends'? Thanks Steve

Hi everyone! I have been searching all over for answers, and there seems to be none. I have a data entry "Comments" field and I want the field to expand when the text goes over the size of the field. Is there ANY possible way? I do not want to make a huge 'Comments' field and use the slide function for printing. I want the field to expand as the text goes. I was thinking there might be a solution using some calculation, script trigger, or conditional formatting. I haven't figured it out yet. Any suggestions? Thank you!

Howdy, all: This is for a FileMaker Go solution where there are arrow-shaped sort indicators for select fields that when clicked, will sort their respective fields in ascending or descending order, depending on which arrow is clicked. What I'd like to do is script it so when the arrow is clicked, the indicator color changes to reflect that that field's sort order is in ascending/descending order. That part is easy using scripted flag field and a script parameter to set it. The problem is deactivating an indicator's conditional formatting should a user decide to perform a manual sort using FM Go's native sorting control. Any ideas? TIA for your help!

Hi Guys my database as 50,000 records and 1 field as the following formatting (7numbers-2numbers-5numbers) "1234567-01-12345" and i would like to change all the "-" to "_" without effecting the numbers, is this possible? if so then i would like to make all future entries use the underscores automatically in place of hyphens? Thanks for any help..

Hello, I am not a developer so excuse me for asking something that might seem simple. I manage a filemaker database for a fire department. There are many tables but the ones I am referring to are "Incident Reports" and "Pre Plans" Chiefs or firefighters enter the address of an incident into a new record in "Incident Reports". On that layout is a button that will take the address and perform a find for that address in the "Pre Plan" table and tell you if that address has a record. In Pre Plans we store address specific info like electric shutoff and other things. My question is: How do I get the button on the "Incident Report" To change color after s…

Hi guys, not sure how to do this. These are my 3 tables Student --<Enrollment >--- Course I need a button on the students layout to turn green if the status field on the enrollment table ="Passed", How can i do this? Keep in mind that a student has many enrollments

Hi I am hoping someone can help me to do the below. I have two fields 1 "Letter Sent" field(date) and 2 "Letter Received" field (date). I would like the "Letter Received" field to go red if no dated entered 7 days after the date entered in "Letter Sent" field. I hope that makes sense.

Hello, I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record Now, I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record . Note: I also have script triggers attached to first and second field which runs on exiting the fields. (I don't think they affect anyways , but just mentioned to give idea)

Can the conditional formatting be used to highlight a field when you want to show if a field is plus or minus 5%?

I elaborated a bit on this technique, more specifically the showing/hiding of things in portal rows based on conditionals. I wanted to show or hide a "delete portal row" button in a QUE_ANS portal on a QUE layout using this conditional statement PatternCount ( QUE::Emps ; QUE_ANS::_Emp_IDfk ) > 0 QUE::Emps is a multi-line field holding Employee IDs. QUE_ANS is a portal on the QUE layout, based on QUE::__Question_IDpk = ANS::_Question_IDfk. QUE_ANS::_Emp_IDfk is a single-line field holding an Employee ID. My challenge is to SHOW the "delete portal row" button on a row in the QUE_ANS portal in case the QUE::Emps does NOT contain the QUE_ANS::_Emp_IDf…

I'm new to Filemaker so excuse my naiveness (although I have programmed in other languages). I have 2 tables that are related in Filemaker and essentially on the form I only want fields from the second table to show on screen or be unhighlighted if the record in the first table is found. For example, perform search for item_no in 1st database and if found display item_no and vendor, once that is found open a new record in the second table for user to add info for the item found. Also if the item is no located in the first table, give user an opportunity to add a new one and then go on to open a blank record in second related table. Any easy way for me to impleme…

Hi. I built a database about a year ago but it wasn't required at the time, a year later and it is needed so I'm pretty rusty at present ref FMP but need to is user friendly. All I want to do is add a slight tint to the background colour of certain fields in list view when the row is not active but try as I might I just can't seem to do so. In the active state yes, but not when the row isn't active. I have made a little video that might help the reader understand my predicament, any help would be appreciated. https://drive.google.com/file/d/0B687aT8LAHKmRHEyZjh5OFdlSnM/view Karl.

Hello forum! I have an issue I'm trying to solve. I know why it doesn't work, I just don't understand how to make it work. I have a button, 'Show All', which basically performs a show all records. I want to hide/show this button (FM ADV12) on a layout depending on the obvious condition-hide when all records showing, show when not all records showing. The layout is based on products with a self join portal (Products_Self). The portal is filtered for basic type ahead. When I type into the search box, the portal filters. As the portal records are filtered, I want the 'Show All' button to appear. The expression being used for conditional formatting…

i have a portal filed that has two conditions. if value is >10 calculated percent difference is old value +/- 10% returns green if value is <10 calculated percent difference is old value +/- 1 returns green if outside range returns red. i have tried case conditions and the formatting works for the <10 condition only. thank you all in advance

I'm using Filemaker 11. I have a table called Computers with fields:UID, Computer Name (MacBook0001, MacBookAir00002 ect.) this is a parent of the Hard Drives table which lists Hard Drive size and Hard drive type (SSD, or SATA) along with UID. I have a portal on the Computer layout which lists Hard Drive size and type that were assigned to the computer on the Hard Drive layout. I have setup basic report just listing the Computer name. I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD. test.fp7

I have 20 fields that can either be "Yes", "No", Maybe, empty". Each field is controlled by a pop-over button with those 4 choices. When a choice is made, I want the pop-over button to be a color associated with the value (Yes, No, Maybe, or Empty(no fill/color). I am looking if these is a more elegant way to setup my scenario, other than setting up 60 conditional formatting rules. Does anyone have a good way to do this? Thanks!

Hi FileMaker Advanced 11 question. I have two separate conditional value lists in one layout showing Provinces, Districts and PostalOffices. One shows the provinces in one country and is linked: Table1::OrginalProvince = Provinces::Province. The Province table has following attributes: ID, Province, District and PostOffice Then I have another conditional value list showing the Districts (with related values only) And finally I have conditional value list showing the PostalOffices (with related values only). This works ok. I used this method: http://www.teamdf.com/weetbicks/24/conditional-value-lists-pt-1-what-are-they-how-to-build-them My problem is that I want t…

Hi, My layout has 2(two) sub-summary when sorted by, each part shows a list of products based on product category, how can i conditionally change summary heading color when each individual summary has less than two records ? Pls see picture in attachment for a clarity.

I want some buttons to switch between slide panels, and want a visual representation of which panel is the front one. I used Conditional Formatting to change the fill color of each button using the GetLayoutObjectAttribute("ThePanelObjectName"; "isFrontPanel") function. Most of the time, the button fill color does not change until the mouse pointer is no longer hovering over it, and other buttons (for which "isFrontPanel" is no longer true) do not change until the mouse pointer hovers over them. Occasionally, it works as iI intended. See the attached sample. Is there a workaround, or a better method to create the desired behavior? GLOA problem.fmp12.zip

Hi, I have being trying to work this out, but I am finding the following problem: - I would like to have a field that would contain info about account numbers for payments. However, the account number should be generated when it is feeded from the combinations of 5 different fields which should contain a max. number of characters, such as 4. When entering the data into these fields the desire behaviour should be that if I am in field 1 and write the first 4 characters, when I enter the 5th one then it should jump to the next field. I have seen this for example when you enter a serial number for a software or at online banking when asking to write the IBAN number. So …

Right, this is so easy, I know, but I've caught myself going around in circles and I'm giving in and asking for help. I'm modifying an existing db and I'd like to avoid re-constructing it as it's working quite nicely as it is. I have a global called 'Name' on a layout called 'System', that the user must enter a unique name into. User then clicks a button to execute a script that creates the record and clears the global field - the script catches if the Name isn't unique and exits, however I want to take this a step further and still have the global field turn red before the script is executed. The global field (gName) is located within a table called "Global", the recor…

Hi Everyone, I am having an issue with conditional formatting on a portal. Currently, I am attempting to have portal text change color when a record exists on a specific date in a related table. My problem is that it is only working for one portal row and not for the others. I have observed that it is only changing the portal row that is the "first" record created in the related table. As soon as I delete this record, the formatting is "bumped" to the next record that was created. Any ideas how I could have the entire portal format correctly? Thank you!

I have a portal and I want to change field's colour when a record is duplicated and I can´t make it. i.e.: States. New York California Texas California So should be New York California Texas California Thanks to all.

I am busy creating a system where documentation needs to be collected before an application can be made for a loan. User phones client, creates client profile, then I need it to create conditional formatting after 3 days has passed to remind user to contact client and request outstanding documents. Cannot get conditional formatting to appear after 3 days.

I have a field configured with field validation - set to a maximum of 55 characters. I would like to display some visual feedback to the person entering data when they have exceeded this limit. Since the validation occurs after the field is exited, it's not very smooth throwing an error dialogue after they have typed beyond the limit. I am unable to provide visual feedback while they type. It would be helpful to display the text in black as the type while under the limit, and maybe display the overset portion in red text. Any techniques for this?

I use a list view layout to review records. When I want to make a change to a particular record I use a GO-TO-RELATED-RECORD step, make the changes, then return to list view.The active record is highlighted in blue on this list. I find the blue highlight distracting. It calls my attention to a record that at this time may or may not be important. Is there another way to highlight current record so by default nothing is selected until something is selected?

I've got filemaker identifying open and closed orders so I can generate on time delivery. To help see the late vs. open field I would like the color to change to red in the back ground with open. How would i go about this. The below is the input data i'm using for the open vs. closed. If(GetAsNumber(BALANCESHIP)=0;"CLOSED"; "OPEN")

Hello there, I am thinking on having two or three different themes on the main list layout of my solution, one of my operator likes more an specific set of colors for the background on the lines and alternate lines, the others like it on a whole different set of colors etc. The thing is that if I change that color I must change the conditional formating as well as the ones I have set are totaly dependent of the background color of the line. So the questions, using script lines, can I change the background color of an layout object lets say the body of the layout? Can I set a script to change the conditional formating as well? If yes, then I can have the same layout and …

I am trying to create a parts database that has many parts that are exactly the same but have different colors and sizes. Lets say that one part is a blue widget that is 4" tall. I can also buy the part in green, red and gold and all of which are 4 inches. But i can also purchase the same item and it is 5" tall with the same/Different colors. Lets say the 5" version that gold is not available. I have tried to create a relationship by creating a supplier family to try to achieve this but it is not really the answer I am looking for. . What I am trying to accomplish is to have a list that shows the sizes and colors without repeating all of the size and color informati…

Hello, Hope someone can help with this one! I have a simple Prospects list, where I have an 'Expected Date' field (Date), which is set to just show month and year. How would I setup the conditional formatting to set the colour of this 'Expected Date' field according to the 'current month', 'next month' and 'month after next' basically to give you: Current month = Colour 1 Next month = Colour 2 Month after next = Colour 3 Cheers Peter

After serching the forums and finding nothing, I think I am asking the wrong question. I have a calcualtion field where I send out email receipts. However, I need to put in a .png of a signature in to the text. The Database is housed on a server. What subject area do I need to be looking into? A thousand thanks, kim

I have a question about the impact of conditional formatting on hosted database performance. Is it the calculation itself that adds the weight to the transfer of data or is it the act of invoking the calculation that does this? I have a task management database for my cabinet shop that depends on conditional formatting. This database displays in list format the tasks that remain for a cabinet. The task status is color coded as well as the skill level required to accomplish the task. For example: If the skill level is equal to (2) then the task turns green. If the skill level is equal to (3) then the task turns yellow. These conditional sta…

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

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

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

I tried using "IsEmpty(Self)" as a condition in the Hide Object section of the object inspector but it does not work (it always hides). Am I missing something ? P.S. If you are wondering why I want to hide something that is actually empty it's simply to "disable" the button of this object. Of course I can use "IsEmpty(TableName::FieldName)" as the condition but certainly more painful when you have a lot of objects to hide .

Hello! Wondering if anyone else has had this issue, or knows how to avoid it... I have a handful of color swatches I've set for labeling in color profile of Generic RGB. Problem is, when I select one of these swatches for conditional formatting, my GENERIC RGB get converted to color profile of DEVICE RGB. BUT!.. the opposite happens on when coloring items on layout, DEVICE RGB get converted to GENERIC RGB. I don't know which color profile to use, FMP overriding my choice and then contradicting itself! Is there a different color profile I should use, is there a setting somewhere to stop this?.. going bonkers! Why is this happening? Thank you fo…

Hello all, just have a small question I would love answered. Is there any real difference when you are hiding something and use... Hide Object When... vs Conditional Format (Text Size 500) Obviously in a summary or report field it should make a big difference to use hide when, but for just normal fields or values what is the better practice?

I am building a database for my cabinetshop that assigns tasks to workers. It relies on color coded conditional formatting to signal task priority and status of tasks. If the tasks need to be done TODAY the record turns yellow. If the urgency level is HOT the record turns red. When the task is iIN PROCESS the record is conditionally formatted to be green. The current status of each worker is reported in Global storage fields that live in the header. If a worker is currently engaged on a project his record turns green. If a worker is NOT currently engaged his record turns white again. The conditional formatting works fine when the database is on a standalo…

Hi. I have a roster with a number of individuals in it, and I want the user [of the solution] to be able to select a colour for that rostered individual. I am working on the basis (which may be wrong) of choosing the colour from a wheel (or more simply, a block of 50 colors whose RGB values are known), having the colour then stored against the [rostered] individual as an RGB value in their record, and then wherever their name appears in the roster, that field is conditionally formatted. Ideally, so the colour doesn't wash out the name, the transparency to be set as well - but thats asking too much I imagine. I have been looking at Conditional Formatting (which I…

Hi all. Hopping a guru can enlighten me. I have a field called "Service Performed" next to this field I have bottom with the below script. TextStyleAdd(TextSize(ticket::Service Performed" & "- " & Get (accountName) & "- " & "" & Get(currenthosttimestamp) & "Enter" ; 12 ); Bold) The basic idea is as users are typing and a new event needs to be entered a users would press the bottom and a time stamp with the username is inserted. It works find except the formatting. Now what I would like to happen is to either bold or change the color of the inserted line. but what I get is the entire field in bold. Is this possible. thanks R…

Hi, I want to do a conditional format of a button based on a self TO which the relationship is based on a get(currentdate) field .. but it's not working ie Table::datedue < [self]Table::Get(currentdate) I do tons of conditional formating but it's always been TOs which are not based on any calc fields .. so maybe it's a fundamental thing... or I'm missing something thanks Cate

Hello I am having some trouble with conditional formatting. In my database i have a table with the fields entry type, start date and end date These fields are in a portal on the main page and it displays the info perfectly and the way I want it. However, I want to change the colour of some fields based on the Start and End date. For example, If I set the field (entry type) as lab with the date the lab work was done, and another entry (record) with the entry field set as chemotherapy with a start date and end date, I want the lab row to change a different colour if its date falls in between the start date and end date of the chemotherapy. Is this possible? Pl…

I have a table called Services I have another table called Versions. This table services has a portal into the Version table and shows all software versions associated to a given service. So for example if I am on Service A the portal window shows all Versions of software that are part of that service. I have conditional formatting setup so that a version row is out of date in more than a year it is filled in green If it is out of date in less that 6 months it is filled in Amber. If it is already out of date it is filled in Red. It looks at the support date field and compares it to the system date and colors it accordingly. Some services show lots of…

I created a VAT field. Now I would like to use conditional formatting when I enter a VAT number. I want it to make the color of the text green if the VAT number exists, and make it red if the VAT number doesn't exist/wrong number. To do this, I can use a calculation together with conditional formatting. However I need to send a request to an api and catch the response. Let's say it returns "1" if the VAT number was found, and a "0" if the VAT number can't be identified. Then it will be easy to handle it in the calculation. How can I talk to an API and let the conditional formatting behave according to the response? EDIT: Found it I think. I have an API that out…

I have a invoice layout that only has room for 10 portal rows. I'd like the last portal row to show something like "X addition items" if there are more than 10 items in the portal. If someone could point me to some examples of how this might be done, it would be very helpful. Thanks.

Hi Is it possible to change a fields background colour depending on the data entered. I have a field that will display text which is 1 of 2 variables ether "Final" or "Concept" selected via a drop down value list, If "Final" is selected I would like the field background to be Green if Concept is selected i would it to be Red. Is this archivable at the moment in Filemaker? many thanks

Hi, I have a FileMaker database that is acting as an archive for items deleted from our primary database (not FileMaker). Effectively, the 'Home' layout shows a fairly standard set of contact data. Below that, I have a Tab control, each with a Portal showing related records (so the tabs are Orders | Subscriptions | Advertising | Futures | Company Details | Mailings ) I would like to alert the user to the fact that there are related records somehow. Whether conditional formatting is the best tool for this I'm not sure, but either way, I'm torn between (and don't know how to implement) the below scenarios; Disable a Tab if there are no related records (portal reco…

If there a way to, when I hover over a certain container field, other text fields are conditional formatted? I want to hover over a container and have the text disappear when hovering... Thoughts?

Hi, My customer hate ID Fields, matter of fact they tell to keep them OFF their Layouts!! So I struggle hiding them. But Filemaker Needs them. I've posted to FM suggestion. Is there a why to color my "Field TEXT" to "CLEAR" NO COLOR like the "OBJECT" is assigned FILL: NONE. When I select the text color palette box with the red diagonal it defaults to "WHITE" Not "No Color" Shouldn't the diagonal across the box mean NO COLOR?? I've tried conditional formatting but it is the same, WHITE TEXT. I've been able so scoot around this issue for quite some time by coloring the layout and the ID Fields the same. This however does not work in a port…

Hi everyone. This one's simple I'm sure. I have a text field where my client can type freely, but most commonly uses two key phrases (PAA and DRM). In another field, I need to format the text color to red when either of these phrases exist in the other field. The imoprtant thing to remember is that the other field may contain a lot of other text. Brain not working this am (coffee maker broken). Any ideas? Thank you! Tony

FM 12. Each record has Status field which is either active or inactive. Is it possible to setup a conditional value list so it displays data from records Status = active?

I want to recreate the Show all Records button (with text) on my layout. What's the script behind the conditional formatting? When all records are showing the icon is grayed out. If I use text in place of the icon how do I gray out the text when all records are showing?

Hello! Is it possible to have a script run to change the color of a simple text box - I am trying to have it actually blink, between like, Red, and white. I am looking to get it to blink if certain conditions are met for the record, like, if it's an exempt (vs. non-exempt) item -it would blink to notify the user. Ideally, I would be great to loop it, so it runs non-stop when the DB file is opened. Any help is appreciated, thanks so much! Karen

I have text field. The text size entered is variable from record to another; it may fits in one line or few lines. Is there a way to set the field length automatically to show the entire content of the field in list view? THANKS

I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field. Chapter Title Sentence ABC aaba ABC abac ABC efgdf ABB bdc ABB cdfegdf . . . What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1 For example: Searching the above data for the title: ABC should show the output in a fi…

Digging into conditional formatting. Can buttons/fields be "flickered" the same way they can be assigned an alternative color, if certain conditions are or are not met? I don't think FM Pro Adv 12 has this built in. I'm thinking this may be some sort of loop, customized to "pulse" or "flicker" (animate?) the background color (lighter-darker-lighter...) until it's pressed. Am I off base with "loop"? Do we have another method to "flicker" a screen element? Thanks.

Hello, I am building a database for a hospital program and I have a table "patients" that is related to another table "tasks". On the main layout I have a button that goes to the "tasks" records In the tasks table each record corresponds to a task the doctor must complete for the patient its related to. There is a field that has a checkbox "completed" I want the button to conditionally turn red when the at least one task is incomplete. where the field completed="completed" Is there a calculation step i can put in the conditional formatting that tells filemaker to check all of the related records in "tasks" to patients that are incomplete? Thanks f…

The "no fill color" option when applying conditional formatting to text does not work. Instead of making the text transparent it makes the text white. In the past I have worked around this problem by simply making the text the same color as the background. Unfortunately in my current solution the background is a photographic image so the workaround does not work. Does anyone have a trick for dealing with this issue?

This must be so elementary I can't find anything about it in the forums. Forgive me, be as tolerant as you can ... I've got FMPro 12; on an iMac. I've made a database of about 2000 people ("A"). And I've got a file ("B") of portraits of about 250 of them. I have a button in A: it uses the ID of a person to find an entry in the portraits file B. All that works fine. Two problems: 1. It would be good to grey out the button if the person hasn't got a portrait ---saves time, and is considerate to the user. How do I do that? 2. Some of the people in A have got more than one portrait in B. My working button finds the …

I'm trying to find a way to use the "Self" function in conjunction with conditionally formatting on tab panels to create an aesthetically pleasing yet simple way to show users which tab panel they have selected. I originally tried adding conditional formatting to one of the tabs using the calculation: GetLayoutObjectAttribute ( Self ; "isFrontTabPanel" ) Unfortunately, this does not work. However, when I replace the Self function with the actual object name it works! Am I not understanding how the Self function works or is this a gotcha with Layout Objects? Reading through the tech docs on the Self functions makes it seems like this may only apply to Fields and…

I have a layout with a set of tabs that are not visible to the user. I would like to apply condition formatting to a button when a specific tab is selected. So for example, I have a "notes" tab and a "calendar" tab. When the user clicks the "notes" button it take them to the "notes" tab. I would like the color of the button to change so it's clear to the user what they have selected. On a side note, I am sending the user to the tab as by assigning an object name to the tab and then using the "go to object" script step. Is there a newer/better way to do this in FM12?

Greets, all: Â Here's what I'm trying to do (please refer to the attached): I have a portal via a self-join with the current table that stores addresses. What I'd like to happen is that the address in the current record (on the left) be highlighted in its related record in the portal (on the right). Obviously, this uses conditional formatting but the I don't know how to set up the calculation; at first I thought that the key field could be used to compare the current ID in the current/parent record to the child record in the portal, but nope, that's not it since they share the same fields. :S Â I'm sure it's a simple calc, just that I can't think of it. (Being old sucks…

I frequently will apply Conditional Formatting to a field and later decide that I want to apply the same settings to additional fields on my layout. In the past I have had success by selecting the field with conditional formatting and then subsequently selecting the additional fields that I want to clone the settings to. After I have the fields selected I simply open the Conditional Formatting dialog window and my settings for the field that I selected first shows up. Next, I simply close the Conditional Formatting window and the settings get applied to all of the objects that I had selected. I thought that the order in which I selected the fields determined which fie…

I've dug around a bit and not found any solutions to my needs, so here I go. I'm guessing for some of you this will be a pretty simple task. What I need is for certain text (simulating field labels) on print layouts to vanish if the merge fields that immediately follow are empty, for example in this case I would want "Birds:" to disappear and then "Cats: have scratchy claws" to move up one line (labels in bold, merge field contents in plain text after): Dogs: have floppy ears Birds: Cats: have scratchy claws Simple, right? Just use conditional formatting. But wait... The space occupied by the labels if I were to set the conditionally formatted label te…