My project is an Inventory management system. This requires me to have a SKU for each product. Currently our sku numbering system is as follows: “Re_000000”. “Re_” is the prefix and the numbering is autoincrementing. As I can’t do autoincrementing on text I thought doing two fields. One a number field with autoincrementing and the other as calculated text that uses the following formula “CONCAT(“Re_”, skuno)”
Unfortunately when I use this formula I get an error saying that I can’t use autoincrementing fields in calculated fields.
Need help to get this going or a possible work around to get this system up and running.