Please refer to two scenerios below i.e. 1 and 2. Scenerio 1 is from issuance table and this is where the ticket form that populatet this table. Scenerio 2 is from another table that is Tool Assign talbe. Both scnerio 1 and 2 expression is workable. The question is is there a simple way to combine both expressions as one expression at Issunace Table to achieve (1) fileter off the red font at te drop down (2) allow edit mode (turn STANDARD TOOL ID field into valid condition) after the form is saved and the user open up the form again to sign off ?
Scenario 1 - OR(AND([ISSUANCE COUNTER]=0,[TICKET OPEN COUNTER]=0,[TICKET DISPOSE]=4.1,[TICKET CLOSED]=3,[SCRAP]=0),AND([ISSUANCE COUNTER]=0,[TICKET OPEN COUNTER]=4,[TICKET DISPOSE]=0,[TICKET CLOSED]=3,[SCRAP]=0),AND([ISSUANCE COUNTER]=0,[TICKET OPEN COUNTER]=4,[TICKET DISPOSE]=4.1,[TICKET CLOSED]=3,[SCRAP]=0),AND([ISSUANCE COUNTER]=0,[TICKET OPEN COUNTER]=0,[TICKET DISPOSE]=0,[TICKET CLOSED]=0,[SCRAP]=0),AND([ISSUANCE COUNTER]=0,[TICKET OPEN COUNTER]=0,[TICKET DISPOSE]=4.1,[TICKET CLOSED]=0,[SCRAP]=0))
If youâre asking how to exclude from the list the values that are formatted in red in your screenshot, you should indeed be able to do so. You could probably leverage the expression in the format rule that makes them red.
Yes, itâs possible for a column to be editable when an existing row is opened in a form view. If thatâs not already the case for the column that youâre asking about, check the columnâs Editable property.
âIf youâre asking how to exclude from the list the values that are formatted in red in your screenshot, you should indeed be able to do so. You could probably leverage the expression in the format rule that makes them red.â
Mind to show some example? I am not very good in all these.
âYes, itâs possible for a column to be editable when an existing row is opened in a form view. If thatâs not already the case for the column that youâre asking about, check the columnâs Editable property.â
So sorry to confuse you. I am talking about data validity. Not editable field. Indeed its already set to editable because the date need to add so it has to be editable but it also has to be valid. See below setting
Find the format rule that defines the condition when those values should be red. You can use the format ruleâs expression that defines that condition elsewhere in the app to define the same conditionâi.e., return a list of values that meet the criteria for being formatted as red
If the columnâs current Valid if expression returns a list of values that includes values you want plus values you donât want, then one technique to exclude the values you donât want is list subtraction. This is where you might be able to repurpose or adapt the expression used in the format rule. You might need an expression along the lines of the following:
{current expression returning desired and undesired values} - {additional expression returning only undesired values}
Thnks anywhere. I got the result I wanted in another way. What I did is I filter off the data in TOOL DESING tab to another tab AGE with this formula =QUERY(SORTN(SORT({âTool Assignâ!F2:F,âTool Assignâ!C2:C,âTool Assignâ!H2:H,âTool Assignâ!A2:A,âTool Assignâ!N2:O,âTool Assignâ!S2:S,âTool Assignâ!R2:R},1,0,2,1),9^9,2,2,1),âSELECT * WHERE Col3 IS NOT NULL AND Col3<>âMY OFFICEâ AND Col3<>âMY STORAGEâ AND Col3<>âOFFICEâ AND Col8<>6â,0) I.E. Col8<>6 will filter those garbish bin icon. Then ref it back to the AGE will give you a completely clean drop down, Wonder is this the correct and easiest way or not LOL
