Gopala Krishnam Raju Ambati Posted June 21 Share Posted June 21 (edited) 1:: SCRIPTED TOOLTIP FORMULA TO GET INFO FROM ANOTHER TABLE If (B1::AR ALERT = 1 and B1::MR ALERT ≠ 1 ; B1::AR ALERTS ; "" ) & ¶ & If (B1::MR ALERT = 1 and B1::AR ALERT ≠ 1 ; B1::MR ALERTS ; "" ) & ¶ & If (B1::AR ALERT = 1 and B1::MR ALERT = 1 ; B1::AR ALERTS & ¶ & B1::MR ALERTS ; "" ) WHEN THIRD CONDITION IS OK ABOVE IM GETTING EXTRA SPACE ABOVE HOW TO GET RID 2:: IS IT POSSIBLE TO CONDITIONALLY FORMAT A FIELD WITH INNERSHADOW AND OUTERSHADOW Case( B1::AR ALERT = 1 and B1::MR ALERT ≠ 1 ; B1::AR ALERTS ; B1::MR ALERT = 1 and B1::AR ALERT ≠ 1 ; B1::MR ALERTS ; B1::AR ALERT = 1 and B1::MR ALERT = 1 ; B1::AR ALERTS & ¶ & B1::MR ALERTS ; ) THIS IS WORKING BUT WHAT ABOUT "IF" SCRIPT PLZ HELP?? Edited June 21 by Gopala Krishnam Raju Ambati TYPO ERRORS Link to comment Share on other sites More sharing options...
comment Posted June 21 Share Posted June 21 (edited) I suspect your formula could be simplified to: List ( If ( B1::AR ALERT = 1 ; B1::AR ALERTS ) ; If ( B1::MR ALERT = 1 ; B1::MR ALERTS ) ) 1 hour ago, Gopala Krishnam Raju Ambati said: 2:: IS IT POSSIBLE TO CONDITIONALLY FORMAT A FIELD WITH INNERSHADOW AND OUTERSHADOW No. Conditional formatting can only change the text style, fill color and icon color. See also: https://fmforums.com/topic/110317-change-field-color-as-well-as-the-color-of-the-rectangle-shape-tool-upon-click/?do=findComment&comment=492669 -- P.S. Please fix you keyboard so that you don't appear to be SHOUTING. Edited June 21 by comment 1 Link to comment Share on other sites More sharing options...
Gopala Krishnam Raju Ambati Posted June 21 Author Share Posted June 21 (edited) List ( If ( B1::AR ALERT = 1 ; B1::AR ALERTS ) ; If ( B1::MR ALERT = 1 ; B1::MR ALERTS ) ) will try this tx Edited June 22 by Gopala Krishnam Raju Ambati Link to comment Share on other sites More sharing options...
Gopala Krishnam Raju Ambati Posted June 22 Author Share Posted June 22 On 6/21/2024 at 8:36 AM, comment said: List ( If ( B1::AR ALERT = 1 ; B1::AR ALERTS ) ; If ( B1::MR ALERT = 1 ; B1::MR ALERTS ) ) THANKS alot saves hell lot of time and scripting tons of headache relief Link to comment Share on other sites More sharing options...
Søren Dyhr Posted June 22 Share Posted June 22 (edited) 31 minutes ago, Gopala Krishnam Raju Ambati said: saves hell lot of time and scripting ChatBotPro says: Quote In FileMaker, functions and scripts serve different purposes: 1. Functions: Functions in FileMaker are predefined operations that perform a specific task and return a value. They are typically used within calculations, text manipulation, date and time operations, and other data-related tasks. Functions are designed to be used within calculations or formulas to manipulate data or perform specific operations on fields or variables. 2. Scripts: Scripts in FileMaker are sets of predefined actions or commands that can be executed in a specific sequence. Scripts allow you to automate tasks, perform complex operations, navigate between layouts, show custom dialogs, interact with external data sources, and more. Scripts are used to control the flow of a FileMaker solution and can be triggered by user actions, layout events, or script triggers. In summary, functions are used for data manipulation and calculations within fields, while scripts are used for automating tasks and controlling the behavior of a FileMaker solution. Understanding when to use functions and when to use scripts depends on the specific task or operation you want to perform within your FileMaker database. --sd Edited June 22 by Søren Dyhr 1 Link to comment Share on other sites More sharing options...
Gopala Krishnam Raju Ambati Posted June 22 Author Share Posted June 22 9 minutes ago, Søren Dyhr said: ChatBotPro says: --sd difference between case and list function pleasseeeeeee Link to comment Share on other sites More sharing options...
Søren Dyhr Posted June 22 Share Posted June 22 Case( has been around for ever, with choose( and If( ... at least for the last 30 odd years, but List( has arrived in this century, but is merely a way to stack several values with a pilcrow inbetween: https://en.wikipedia.org/wiki/Pilcrow#:~:text=In the field of publishing,used to identify a paragraph. The usage, makes especially when building multi-predicate relational keys. --sd 1 Link to comment Share on other sites More sharing options...
Gopala Krishnam Raju Ambati Posted June 22 Author Share Posted June 22 (edited) i think both gives same result correct me if im wrong pilcrow in between any example code plzzzz ? i didnt chk though Edited June 22 by Gopala Krishnam Raju Ambati Link to comment Share on other sites More sharing options...
Søren Dyhr Posted June 22 Share Posted June 22 (edited) 36 minutes ago, Gopala Krishnam Raju Ambati said: i think both gives same result correct me if im wrong You're wrong, two distinctive different functions! If both IF's are true, will two "lines" of result occur simultaneously, in Michaels function above! It could almost be written like: 1 hour ago, Gopala Krishnam Raju Ambati said: If ( B1::AR ALERT = 1 ; B1::AR ALERTS ) & "¶" & If ( B1::MR ALERT = 1 ; B1::MR ALERTS ) But on top of that it deals with the case, if the first or second half is undefined, by leaving out the pilcrow if need be! --sd Edited June 22 by Søren Dyhr 1 Link to comment Share on other sites More sharing options...
comment Posted June 22 Share Posted June 22 (edited) 1 hour ago, Gopala Krishnam Raju Ambati said: difference between case and list function pleasseeeeeee The question makes very little sense, because the two functions have very little, if anything, in common. The Case() function evaluates one or more test expressions and returns the result for the first test expression that evaluated as true. The List() function simply constructs a return-separated list of all its arguments. The important point here is that the List() function ignores empty values. So the difference between your: If ( a ; b ) & ¶ & If ( c ; d ) and mine: List ( If ( a ; b ) ; If ( c ; d ) ) is that when a is false and c is true, you will end up with an empty line above d, while my result will be just d. Or, in more general terms, your result will always contain a carriage return, while mine will have it only when both tests are true. And, as Søren already pointed out, the Case() function would only ever output either b or d, never both. Edited June 22 by comment 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now