LinkedIn
Twitter
So far, I have successfully made the apps to randomly select a person for me from my database list.
There are two mode (separated with two tables)：one is repeated, another one is non-repeated selection.
What I want to do now is make a result list (column D) for each of this tables, so that I can have a selected record.
Below is the source of my random draw view.
For column C, I set something like random draw formula for me to pick a person. (now selected Carry)
I would like to append the person in column D every time I select a person. Therefore, every time I use this apps, I can have a list for me to know which person have selected at the end. Meanwhile, there would have a button for me to clear the list.
Is it achievable? how should I do this?
@bbbird wrote:
Is it achievable? how should I do this?
Since a person could change the selection of the [Result] column multiple times while adding or editing the row, you need to wait to append the value once the user has Saved their choice. You can do this is two ways:
1) Create a custom action that appends the choice to the [Result List] on Save of the Form. Each Form View has a Behavior section in which there is a Form Save property. You would attach your action here.
2) Create a Bot that is triggered on the row changes and executes a custom action (same action as above) to append the new value to [Result List]
**********
Depending on your use case their may be a MUCH simpler solution. Have ONLY the [Result List] that is defined as an EnumList and the user simply selects or more names from this dropdown list. If editing in the future, the user simply selects the additional names to be added.
I hope this helps!
