restrict number selected on multi select grid
Comments
-
i have a multi select data grid on a form. the results of contracts being pushed to it can exceed 1500 at a time. i would like to restrict the number of contracts the user can select to 100. after the user selects the 100th one they would get some kind of error/warning on the 101 selected contract that they have exceeded the allowed limit.
i have tried 2 ways so far with no luck.
i created a flow and attached it to the data flow on the form. the flow takes in the selected contracts, loops through them, and adds 1 for each one. i am unable to figure out how to pass the selected contracts in real time to this flow so on the 101 contract it will give a warning.
i also created a rule of selectedContracts > 100, but again i cant figure out how to pass to the rule the total selected contract number. -
Kirk,
We are currently looking into a solution for you.
Thanks,
Erik
-
Thanks for the solution.
Solution: on the form, under validation rules, i have a rule that takes in the count of the object in the data grid and makes sure its below the limit i set.
detail: my data grids object type is from a query to get contracts - q_get_contracts (example). I created a rule that has an input - contract_limit - with the same type - q_get_contracts. It is set as a list. with list there is an option to get the count of items within the list - contract_limit.count. my rule is setup as contract_limit.count is less than or equal to 100. the rules behavior is Form Rule.
The apply to controls is set to my data grid.
The rule inputs is set to Form Component as InputType, and FormDataName is the data name of my data grids output - Selected_Contracts. When the contracts are selected and the button to continue is clicked, those contracts are passed by the Output Data > Data Name which is Selected_Contracts.Actions: the user selects the contracts, as they are selected the number is passed by Selected_Contracts to the rule, which takes the count of them, and validates it.
thanks again you guys
Howdy, Stranger!
Categories
- 4.2K All Categories
- 67 General
- 11 Training
- 202 Installation / Setup
- 1.1K Flows
- 106 Rules
- 262 Administration
- 212 Portal
- 490 General Q & A
- 695 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 52 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 179 Pages
- 5 Process Mining
- New Features
- 179 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 78 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 83 Lunch And Learn Questions