You can create a formula field that will display the concatenated value and formula field would be of type text and would have formula similar to FieldName1+ ' ' +FieldName2
Yea but I want it to throw an error if the resulting value isn't unique. My basic intention is to ENSURE two other fields in the table that I concatenate together are unique (idc about individually).
FieldName1+ ' ' +FieldName2
Check below reference
https://help.salesforce.com/articleView?id=bi_integrate_data_prep_recipe_formula_field_stringFunctions_concat.htm&type=5
Thanks,
Using the value in the field, do a SOQL. If you get any results, throw an error and stop the save.
regards
Andrew
it can be done with formula field
field 3 will be Data TypeFormula type text
Data TypeFormula
field1__c + '' + field_2__c
Please mark it as best answer if it helps