[IzzyMad]

Hi sorry to be thick but I am trying to set up a custom column from two other custom columns; I don't even know if this is poss; and I am having a few problems sort out how it works

first I want a column to show three digits ranging from 001 up to 999 showing all three digits including the zeros; If poss. Called "Book Index"

Second I want a column to show two characters from 01 to ZZ; if poss; if not then just 01 to 99 again showing the zeros, Called "Series Index"

Thirdly I want a column that show both these columns in one, ie. 10~110. Called "File Index"


Is any of this possible and if so how do I do it.

I have looked through the through the FAQ and the manual and the other forums but to no avail I found the section about "Template Language" but due to my Dyslexia I was not able to understand what I did with.

If you can make it simple as to what needs to be done then if I fail to understand then I can get my wife to help but she understands nothing when it comes to this sort of thing.

Also is there any way of setting the default value for "File Index" to "00~000"

Thanks

Izzy

Hold that I think I have sorted it with {#series_number:0>2s}~{#book_number:0>3s}. I was not putting the "#" in.

I've set the original columns up as integers I know this means I can't use letters an numbers so if there is a way around that bit please let me know.

See I told you I was thick but I got there in the end. Sorry to have bothered you.

Thanks any way