Virtual Column Question: I want to create a virtual column that functions like a Yes/No column.
I donโt want to store the result, but I want to trigger a workflow if user selects true Orโฆis there a different way to do this?
Thanks!
In the workflow condition insert: [Virtual Column Name]=โYESโ, the complete the workflow with what you want it to do.
Thatโs how I trigger the workflow. I want a โvirtualโ true/false function to occur on the form, like a standard Yes/No column, instead of a constant. My goal is to let the end user have the option to send or not send.
Inserting a column stores the result, I donโt want that, which is why Iโm playing with a virtual column.
@Rod I usually face the same problem at times and i donโt think virtual columns are capable of doing that. I use a column in my table dedicated to that yes/no question and allow the user to press an action button to select yes or no. Once they do that, workflow is triggered and then i set another action to wipe out the yes or no for that cell.
hmm, an action to clear the cell, I was thinking about that, Iโll give that a tryโฆthanks!
How are you triggering and action?
So, create a โGroupedโ action that has 2 actions โSetโ and โClearโ.
The โSetโ action is an action that sets the value of the yes/no column (once this is set, the workflow will trigger automatically if the workflow condition is the same as i mentioned in my first comment).
The โClearโ action will the the value of that column to โโ (this will clear it out.
Let me know if this works for you.
My Bad, havenโt been paying attention to the new features, workflow data change triggering an action works perfectly. Thanks for your input! Helps.
I normally use a datetime field for this purpose because then you donโt need to clear a field and the last timestamp is recorded as well. If you trigger that function with an action button (with expression NOW()), you can add a condition rule AND(ISNOTBLANK([DateTime]),[_THISROW_BEFORE].[DateTime]<>[_THISROW_AFTER].[DateTime]) for your workflow and it will send the email only, when the action button is pushed.
Interesting. Thanks Aleksi! Extremely helpful
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |