jcc5018 Posted November 28, 2022 Share Posted November 28, 2022 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? Quote Link to comment Share on other sites More sharing options...
walt.farrell Posted November 28, 2022 Share Posted November 28, 2022 I think it's a straight alpha sort, which means adding the extra 0s may be your only workable approach. Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1 Link to comment Share on other sites More sharing options...
Recommended Posts
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.