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.
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"
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")
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
Not working
AND(AND(STARTSWITH([CAPL BARCODE], "FLIP"),
CONTEXT("ViewType")="Form"),
AND(STARTSWITH([CAPL BARCODE], "FKS"),
CONTEXT("ViewType")="Form"))
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.
The expression is not correct. Try this:
AND(
CONTEXT("ViewType") = "Form",
OR( STARTSWITH([CAPL BARCODE), "FLIP"),
STARTSWITH([CAPL BARCODE), "FKS")
)
)
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
Have you tried:
AND( CONTEXT("ViewType") = "Form", OR(STARTSWITH([CAPL BARCODE], "FKS"), STARTSWITH([CAPL BARCODE], "FLIP")))
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
Input fields in form views are not subject to format rules, and therefore cannot be formatted.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |