I am trying to manage unique IDs using a calculated field.
However, when concatenating a numeric string (with or without decimal point or minus) entered in the string field, the string is calculated as a number, not a concatenation of strings, as shown in image 1.
The current workaround to add a fixed string before the calculation and it replace to empty at the end, as shown in image 2.
Is there another workaround?
Also, are there any modifications to the system that would solve this problem?
It would be useful to have an operator to force concatenation as a string or a function to concatenate strings.