last_back_box_record = back_box [back_box_site = input.back_box_site] sort by back_box_reference desc;
if (last_back_box_record.ID = null)
{
input.back_box_reference="01";
}
else
{
input.back_box_reference=((last_back_box_record.back_box_reference.toLong() + 1)).toString();
}
I need to prefix all entries with "BB" and for the number format to remain 2digit i.e. ""BB01" to "BB99"