Add Prefix to all Table values
Currently a prefix can only be added to Prefixed Autonumber and Random ID. But, it would be nice to set a prefix on a table or view column.
So, if the datatype is integer, the user is required to add an integer to the form. But when it is viewed through a datapage, it would display a prefix leading the integer. Example: B001, B002, ..., B0028. Where "B00" is the prefix.
Josh Jobin
shared this idea
Thank you for the idea. To add a prefix to any field in the table, you can create a Formula Field to concatenate the prefix with an integer value and display the field in the DataPages. In your example, the formula will be ‘B00’ + CONVERT. More information about the formula field can be found at http://howto.caspio.com/tables-and-views/data-types/formula-fields/.
This idea is now closed and if the suggestion above does not meet your need. Please open another idea with your specific use case.