Code to Generate PO Numbers

I look forward to seeing some ideas around auto-increment the next letter. I've seen numbers but not letters.

For the other part you will have to take your date field and create three formula fields to transform the milliseconds to useful numbers.

year(datefield)

month(datefield)

day(datefield)

Then another field to concat the other fields together.

Here you go...

let a := this;
let b := format(today(), "MMDDYYYY");
let c := "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
let d := "";
let e := substr(last(((select Orders where substring(Ref, 0, 8) = b) order by Ref).Ref), 9, 1);
if e = null then
d := "A"
else
d := substr(c, index(c, e) + 1, 1)
end;
a.(Ref := b + "-" + d)

Regards

John