Question about unique id

[Former Community Member]

Can I make it so that the user can create the unique id in detail view?

Perfably by enum?

I would like to make it so that the first few alphabet and digits are like a sub category.

So for example, I get to choose between;

aa001(means Fruit category)

bb001 (means Vegetable category)

and then a  unique id followed by it.

[Joseph_Seddik · Accepted solution]

You can make the user choose the category, then put the following expression in your key column:

[category] & UNIQUEID()

[Joseph_Seddik · Accepted solution]

You can make the user choose the category, then put the following expression in your key column:

[category] & UNIQUEID()

[Former Community Member]

Do I make a Enum Type and put that expression in the INITIAL VALUE?

[Joseph_Seddik · Accepted solution]

Category column can be Enum, while the composite key column should be Text. 

Yes, Initial Value. 

[Former Community Member]

Thank you sir!

[Joseph_Seddik]

Welcome my friend!

[Former Community Member]

@Joseph_Seddik 

Follow up question!

Your method has worked perfectly, thank you.

But one thing;

 [category] & UNIQUEID()

made me allow to put the information of category with unique id, but for instance let's say I made a mistake and chose the wrong category at first. Then I can't seem to change the category that has now combined with the unique id.

Is there a work around?