Colour Highlights only inside the form

[Sayad]

I want to set a condition. I want FKS***** to be highlighted in the colour when the start value is FKS*****. But only inside the form. 

 

[WillowMobileSys]

In the Format Rule, set the condition using the CONTEXT() function to specify that it applies ONLY to that specific Form.  something like this:

CONTEXT("View") = "MySpecificForm"

[Sayad]

Function is not working suggest me.

AND(AND(STARTSWITH([CAPL BARCODE], "FLIP"),
CONTEXT("View") = "FILL THE DETAILS"),

AND(STARTSWITH([CAPL BARCODE], "FKS"),
CONTEXT("View") = "FILL THE DETAILS"))

ALL these statements are true:
....1: ALL these statements are true:
........1: (The value of column 'CAPL BARCODE') starts with the text value ("FLIP")
........2: (CONTEXT(
............"View")) is equal to ("FILL THE DETAILS")
....2: ALL these statements are true:
........1: (The value of column 'CAPL BARCODE') starts with the text value ("FKS")
........2: (CONTEXT(
............"View")) is equal to ("FILL THE DETAILS")

[Josh_Klassen]

Check this out:

https://help.appsheet.com/en/articles/2347640-context

CONTEXT("ViewType")="Form"

Put the formula in "only if this condition is true" field 

[Sayad]

Not working

AND(AND(STARTSWITH([CAPL BARCODE], "FLIP"),
CONTEXT("ViewType")="Form"),

AND(STARTSWITH([CAPL BARCODE], "FKS"),
CONTEXT("ViewType")="Form"))

[Josh_Klassen]

Can I see the whole screen for the formula?  It looks to me like you are missing wrapping the expression in an OR() but I cant see enough. Thank you. 

[WillowMobileSys]

The expression is not correct.  Try this:

AND(
    CONTEXT("ViewType") = "Form",
    OR( STARTSWITH([CAPL BARCODE), "FLIP"), 
        STARTSWITH([CAPL BARCODE), "FKS")
    )
)

[Sayad]

Hi @WillowMobileSys  @Josh_Klassen 

I only want to do colour formatting inside the form. I have tried all the functions mentioned by you. But there is no solution yet. I have given you all the screenshots below. You see this and tell me how can I do the formatting. 

AND(
    CONTEXT("ViewType") = "CAMPUS SCAN SHEET_Form",
    OR(STARTSWITH([CAPL BARCODE], "FKS"),
       STARTSWITH([CAPL BARCODE], "FLIP")))

ALL these statements are true:
....1: (CONTEXT(
........"ViewType")) is equal to ("CAMPUS SCAN SHEET_Form")
....2: ANY of these statements is true:
........1: (The value of column 'CAPL BARCODE') starts with the text value ("FKS")
........2: (The value of column 'CAPL BARCODE') starts with the text value ("FLIP")

 Related Screenshot

Here's an inside view of the form.Format Rulesform view

[Josh_Klassen]

Have you tried:

 AND( CONTEXT("ViewType") = "Form", OR(STARTSWITH([CAPL BARCODE], "FKS"), STARTSWITH([CAPL BARCODE], "FLIP")))

[WillowMobileSys]

If you wish to specify the formatting for a specific view as opposed to a set of view types, then you need to change the CONTEXT function...such as:

AND(
    CONTEXT("View") = "CAMPUS SCAN SHEET_Form",
    OR( STARTSWITH([CAPL BARCODE), "FLIP"), 
        STARTSWITH([CAPL BARCODE), "FKS")
    )
)

Please read the help article for CONTEXT located here:

https://help.appsheet.com/en/articles/2347640-context

[Steve]

Input fields in form views are not subject to format rules, and therefore cannot be formatted.