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, 20241 yr by Gopala Krishnam Raju Ambati
TYPO ERRORS

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, 20241 yr by comment

List ( 
If ( B1::AR ALERT = 1 ; B1::AR ALERTS ) ;
If ( B1::MR ALERT = 1 ; B1::MR ALERTS ) 
) 

will try this tx

 

Edited June 22, 20241 yr by Gopala Krishnam Raju Ambati

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

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, 20241 yr by Søren Dyhr

9 minutes ago, Søren Dyhr said:

ChatBotPro says: 

--sd

difference between case and list function pleasseeeeeee

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

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, 20241 yr by Gopala Krishnam Raju Ambati

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, 20241 yr by Søren Dyhr

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, 20241 yr by comment