hey all
I have a column with enum and 3 different value buttons, Pass Fail and N/A
in form view I am trying to make a popup to add text notes when fail is pressed but i am not having much luck
is this possible at all or is there another way of doing this sort of thing
Solved! Go to Solution.
In general , you could add another long text column for every enum field for the user to add notes. The show_if property for these long text columns could be set to [Enum]="Fail". The required property also can be [Enum]="Fail" which will make the column mandatory for the user to add notes in case of "Fail" selection in the [Enum]
However with such an arrangement, if the user selects a "Fail" and writes a note in text column and then again changes the enum setting to "Pass" or "N/A", the note still remains. So you could have an event action that executes on form saves and sets long text notes column to " " (Blank) for all enum columns with "Pass" or "N/A" status.
In general, for such a global notes column, the show_if and required_if expression for the global notes column can be something like
OR([Enum 1]="Fail", [Enum 2]="Fail",......., [Enum 9]="Fail", [Enum 10]="Fail")
Each of the enum column will need to be mentioned in the above expression. So if there are 10 enum columns, there will 10 [Enum n]="Fail" in the show_if expression.
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |