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:

5

Hi Carl, I used your solution successfully to format invoice numbers with a prefix and leading zeros. Thanks!
That said, it would be really useful to be able to add a custom number format that references another cell. For example, instead of always having a $ in front of the number, the prefix should reference another table column which would have any number of country currency symbols. It would be possible to include a custom currency symbol with a text formula, but then the field would be a text field and couldn’t be used to say, sum items in an invoice page.

-Phillip

6

Not sure I have a simple solution for that :thinking:

7

@CarlHolmes I miss something or the video is only a 1 sec gif? Is there a more detailed version?

8

@vidierre - Very odd, not sure why the link stopped working. :thinking:

2 Likes