Make a field of an entity unique
Comments
-
I wanted to know if there is a way to make a field of an entity unique.
-
If you are looking to make an entity field unique, you have a few options to accomplish this task based on the document attached below. You can have a validation rule or a validation flow. Validation flows are used for more complex cases and can include rules within them. For this demonstration I will create a validation flow. Assuming you have an entity setup, you can add these validation rules and flows to the configuration folder of the entity. I have an entity that allows users to submit a “Travel Request” . The following are the fields for the “Travel Request” entity”.
[img]https://lh3.googleusercontent.com/BgP48qhoSZFqtI_tMJCLUgVUNXrBRDIB6wjYfjM0Q40N0YWJu61JQbnKEMJ1E9k8fEH9vOX5AUEbpBOtXhfIRZSb1TOi1REfMWyaxhZQlDi9O0NIfk5-7SbDTL40pc2gRpTn-z_I[/img]
To initiate a Validation flow, you will go into the configuration folder for the entity and in the bottom tab, you will click validation rule drop-down menu to select “Validation flow” user action.
[img]https://lh3.googleusercontent.com/ezcdDSZE-2fLLtGPqYFXa5F0GRubW1oGPwCFmUQdnt4abHdhCj1GCuQbcBX9G24JDUZtEzasra3g4330ZdbmITRpeFa-SXJBxKr1-GRt9F4TMK4E7Ql36OEf6-HbxQfn0o0xQl9M[/img]
For this use case, I want to make the “Travel Amount” field to be unique; users can’t request a trip that is over $1000. So, I will use a rule within my flow to evaluate the "Travel Amount" before the user is able to submit it. The results will show that the user will get an error when they enter a value above 1000 for the Travel amount.
Howdy, Stranger!
Categories
- 4.3K All Categories
- 70 General
- 11 Training
- 206 Installation / Setup
- 1.1K Flows
- 109 Rules
- 267 Administration
- 212 Portal
- 496 General Q & A
- 706 Forms
- 338 Reports
- 3 Designer Extensions
- 48 Example Flows
- 56 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 184 Pages
- 5 Process Mining
- New Features
- 182 Datastructures
- 69 Repository
- 228 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 130 Lunch And Learn Questions