action buttons

[bnmers]

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 

[Suvrutt_Gurjar · Accepted 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.

[Suvrutt_Gurjar · Accepted 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.

[bnmers]

It works perfectly 

thank you so much you are a genius

s

[bnmers]

Next challenge  

how can i make one notes column for all the enum =fail conditions like a global notes column that i can add to each time fail is selected

[Suvrutt_Gurjar · Accepted solution]

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.

[bnmers]

Works perfectly 

thank you so much again

[bnmers]

Hello

i am working on another problem and was hoping you could help me with it

I have a table called Time Tracking and inside i have a depart column that is a time for each load.

I have a task that adds a new row each time a load is added and finally sends an email at the end of the day. I am trying to add all the rows from the column Depart to the attachment but nothing seems to work 

the table is called Time Tracking and the key column is Time Tracking ID 

i have tried <<Start: Select(Time Tracking[Time Tracking ID],[Depart] in many different combinations but nothing seems to work

Thanks

steve

[Suvrutt_Gurjar]

In general, if the [Depart] column is of Datetime type, you could have the template expression something like

<<Start: Select(Time Tracking[Time Tracking ID], DATE([Depart])=TODAY())>>

DATE([Depart])=TODAY() will select all the records having the [Depart] date of today.