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.1K All Categories
- 60 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions