Can the result of a Calculation be defined as UNique?

[Baylah]

Greetings,

Can the result of a calculation field be defined as unique? I have a calculation that combines a unique identifier with a suffix and I would like the result to be unique so I can be warned if I have created the resulting "art number" before.

It is kind of a long story why I need to do it this way but it is necessary. Also, I know I could creat another field that would be autopopulatd based on the result of the calculation (and I could define that as unique) but I was wondering if I am missing something basic here.

thanks,

Steve

[comment]

Can the result of a calculation field be defined as unique?

No.

I know I could creat another field that would be autopopulatd based on the result of the calculation

You could have this field INSTEAD of the calculation field, not in addition to.

[Baylah]

Yes, I suppose I could, but the two fields combined are the result of an automated serial number and a drop down selection box. It would be a hassle to manually enter both.

Thanks for the definitive answer though. I suspected that was the case.

Steve

[comment]

Yes, I suppose I could, but the two fields combined are the result of an automated serial number and a drop down selection box. It would be a hassle to manually enter both.

I don't think you need to enter anything manually. If you change your calculation field to type Text (or Number, depending on your formula), and set it to auto-enter a calculated value (with replacing), you can also apply validation to it.

[Baylah]

Thank you for the tip...I will try that out. I knew there had to be a better way.

SF