Formatted String for Order Number

Help Center Get Answers
1

Hi

Is there a way on a field type to be able to do the following:

Create a field formatted like this

PO-000001 and the number is incremented on each new record so PO-000002, PO-000003 etc.

Thanks

Steve

2

Hi Steve,

Please see the below video explanation for how Iā€™d achive this with some Conditional Rules and a concatenated Text Formula. As mentioned on the video, replace the Number field with an Auto Increment

1 Like
3

Thank you very much Carl, whilst not ideal, this definitely works for me.

PS. Iā€™ve just watched one of your YouTube videos for some education as Iā€™m brand new to Knack.

Keep up the good work!

Steve

2 Likes
4

Hi Steve - welcome to Knackā€¦. if you could mark this as a ā€œsolutionā€ it would be appreciated :+1:

There is probably another way to do this, that Iā€™m not aware of :thinking:. Itā€™s not pretty but Iā€™m glad the mix of conditional rules provides a solution.

Glad that you found my YouTube channel :tv:

Donā€™t forget to subscribe, be great to get to 300 subscribers :rocket: