Jump to content
You must now use your email address to sign in [click for more info] ×

How do I fix my custom index order?

Recommended Posts

I am trying to include a bible verse index that is organized by biblical book order.  I finally figured out that I could do this similar to WORD by adding a numerical field in the sort by entry of "Edit topic" 

so Genesis would be 01, Revelation 66  and so forth. This works fine, though took forever to manually update over a hundred records, especially since it was already done once in WORD. 

But the problem comes when I reach  the psalms that have 3 digit chapter numbers. So what would be 1910305 for example (ps 103:5) ends up at the end of my index instead of after anything before PS 99.  I thought that adding the psalm entries with 3 digits so PS 99:1 would be 1909901  for example, would help, but that sent all the psalm entries to the end since the resulting  value is larger than every other book.  

So short of going through all 100+ entries and adding an extra leading 0 to all chapter numbers, I'm not sure the quickest way to fix this. 

some programs sort number lists like 4,40,400,5,54,543... while others sort as they should be without needing leading 0's. (4,5,40,54,400,543)   It appears affinity may be sorting the latter method, but it creates the challenge mentioned above.   Is there a better way to sort by Bible book order? And if so, is there a faster way to clear or alter the sort by list than the 3-4 clicks it takes with current method? 

Link to comment
Share on other sites

I think it's a straight alpha sort, which means adding the extra 0s may be your only workable approach.

-- Walt
Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases
    Desktop:  Windows 11 Pro, version 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 

    Laptop:  Windows 11 Pro, version 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU.
iPad:  iPad Pro M1, 12.9": iPadOS 17.3, Apple Pencil 2, Magic Keyboard 
Mac:  2023 M2 MacBook Air 15", 16GB memory, macOS Sonoma 14.3.1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.