If you want to add a second unique field of type text to a custom object in Creatio we recommending to use the [Autonumber] field, it provides an out-of-the-box feature that allows you to generate unique identifiers automatically. You can configure an AutoNumber format for your custom object's second unique field and define rules for its generation. This approach can be useful if you want to have a consistent format for your unique identifiers.
For all the records that get inserted into the Creatio table (Objects: section, details, or Lookup) the inserted record is distinguished by the "Id" (GUID Type) column which is a unique identifier for the record.
If an additional column has to be considered into account before inserting a record, then a custom implementation has to be made to validate the additional field value.
Please click, view and select display columns and add Id, and Name. Then Id field will be displayed with a unique value for each record.
I have added a custom lookup object to the order section and i added few lookup values. But in the record when i clicked on lookup field i want to display the available unique/distinct values.
1. The best approach is to add a new column “Inactive” in the object, you can do this when you open the object in configuration, and in the behavior, section click in the checkbox “Allow records deactivation”
After that publish your object and go to the lookup section. Here in your lookup, you will see one additional column, called “Inactive”, for records you do not want to see, please fill in this checkbox.
After you will see only records in your dropdown that are not inactive.
2. Another approach that is not recommended is to implement filtering after you receive the collection of values. You should do this after receiving because you cannot apply isDistinct property for you select, because the Id for each record is different, so it will always return you all records. In your page (OrderPage) add one more method:
You can make this a popup selection, where you can display some other fields in the lookup which will help you to distinguish or filter proper value. For e.g. Order number +Account Name + City
This is a simple lookup field which has duplicate values. In a record if i click this i want to display the unique values of the lookup object.
Step 1 : I have created a lookup object
Step 2 : I haved added values for that lookup object (with duplicate entries)
Step 3 : but when i use that field in a section record i.e if i clicked that lookup field it is populating all the values of the lookup (including duplicate entries). Here i want the distinct vales to be shown.
1. The best approach is to add a new column “Inactive” in the object, you can do this when you open the object in configuration, and in the behavior, section click in the checkbox “Allow records deactivation”
After that publish your object and go to the lookup section. Here in your lookup, you will see one additional column, called “Inactive”, for records you do not want to see, please fill in this checkbox.
After you will see only records in your dropdown that are not inactive.
2. Another approach that is not recommended is to implement filtering after you receive the collection of values. You should do this after receiving because you cannot apply isDistinct property for you select, because the Id for each record is different, so it will always return you all records. In your page (OrderPage) add one more method: