Combining column values to create unique key
Hello All,
I have a table with four (4) columns: 1.SWOT ID 2.SWOT Name (to be entered by user)
3.SWOT categories (Values: Strengths, Weaknesses, Opportunities, Threats) 4.PESTEL categories (Values: Political, Economic, Socio-economicโฆLegal)
I want the SWOT ID computed as follows: [1st 3 characters of SWOT Category value] + [1st 3 characters of PESTEL Categories value ] + Record Number
So for example, if the values selected for record #1 was strengths, political I would like the ID computed as follows:
[ STR ] + [POL] +1 = STRPOL1
How would I go about implementing this?
Thanks!
May I ask where do you get that number (1)?
Other than that, the formula would be likeโฆ CONCATENATE(LEFT([1st 3 characters of SWOT Category value],3),LEFT([1st 3 characters of PESTEL Categories value ],3),Record Number)
how to get record number?
@Aleksi_Alkio it doesnโt exist in the file.
Thinking about it as a record counter that can be attached. Similar to how the uniqueid() generate a code.
It is as if uniqueid() generated the record counter starting at the number 1
Thanks. Where do I place that formula?
If you have more than one user, the numbering wonโt work. When two users are using the app at the same time, there will be two records with the same number.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |