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.
Solved! Go to Solution.
You can make the user choose the category, then put the following expression in your key column:
[category] & UNIQUEID()
Category column can be Enum, while the composite key column should be Text.
Yes, Initial Value.
You can make the user choose the category, then put the following expression in your key column:
[category] & UNIQUEID()
Do I make a Enum Type and put that expression in the INITIAL VALUE?
Category column can be Enum, while the composite key column should be Text.
Yes, Initial Value.
Thank you sir!
Welcome my friend!
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?
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |