Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    McLean, VA
    Posts
    125
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Autonumbering using a TBD-xxx format (2000/SR1)

    Reports I am editing have TBD codes scattered throughout to indicate products or services that are

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    I've picked up a few ideas on fields here over the years. You can coerce a numbering field to show leading zeros by embedding it in a formula field, and then prepend or append text to it using the QUOTE field. I don't know why the formula returns a negative number (macropod?), but since you want a hyphen, that's okay with me. See if this works. You'll need to use Ctrl+F9 to create the field braces before typing in the text:

    { QUOTE TBD{ =({ SEQ TBD * ARABIC }) # "000" } * MERGEFORMAT }

    As for the REF issue, that I cannot help you with.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    McLean, VA
    Posts
    125
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Thanks, jscher. I never would have thought of that. It works beautifully for inserting the TBD codes!
    If anyone out there does know how to do REFs to this { QUOTE TBD{ =({ SEQ TBD * ARABIC }) # "000" } * MERGEFORMAT } field, I would appreciate hearing from you because it would simplify my TBD summary table.

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    It should be easy enough to put a bookmark round each TBD field.

    StuartR

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    McLean, VA
    Posts
    125
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Yes, I put a bookmark around each field. Then in the summary table I use cross-refs to the bookmarks, one row for each cross-ref. But this table of cross-refs goes out of numerical order when the TBD codes are rearranged. The TBD codes themselves do renumber themselves correctly using jscher's method.
    Granted it's not that big a deal to rearrange the rows in the summary table. But if there is an easy method to get these cross-refs to arrange themselves numerically by the TBD numbers they reference, I'd like to know what it is.

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    I assume you just need Table > Sort to re-order the summary table?

    StuartR

  7. #7
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Can you do anything with Insert > Reference > Caption... and defining a new caption type of TBD.
    You could then create a table (Insert > Reference > Index and Tables... > Table of Figures > Caption Label: TBD

    The inserted captions look like
    <code>TBD { SEQ TBD * ARABIC }</code>

    But you can edit this to look like
    <code>TBD - { SEQ TBD # "000" } </code>
    and the Table of Figures will still work.

    (In the screen shot I have used "Toggle Field Codes" on one of the captions)

    StuartR
    Attached Images Attached Images
    • File Type: gif x.GIF (2.8 KB, 0 views)

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    McLean, VA
    Posts
    125
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Of course! Duh, why didn't I think of that! Thanks, Stuart

  9. #9
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Honest, I tried that first, but couldn't get the leading zeros to stick! Of course, I deleted my test document so I don't know what I was doing wrong...

    Added: Or maybe I couldn't get rid of the pesky leading space before the numbers...

  10. #10
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    McLean, VA
    Posts
    125
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Thanks, Stuart. Your caption method works, but I would have to reformat the Table of Figures to conform to the govt's table format (that I never showed you!-my bad)
    I'm fine using the QUOTE/SEQ code (of jscher's) / Create bookmarks / Sort the summary table approach. I just tested it and it works beautifully. It's gonna save lots of aggravation! Thanks all!

  11. #11
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Hi Jefferson,

    FWIW, the reason your field code returned negative values is because you enclosed the SEQ field in brackets.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  12. #12
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Tallahassee, Florida, USA
    Posts
    901
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Hi Jefferson. You can get rid of that pesky leading space by including the TBD within the number format. A hyphen won't work, but you can use an en dash from symbols. I can get it to work with this [b]( SEQ L1 # "TBD
    Attached Images Attached Images
    Karen

  13. #13
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Hi Karen,

    You can use a hyphen with:
    {SEQ TBD # TBD'-'000}

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  14. #14
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Tallahassee, Florida, USA
    Posts
    901
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumbering using a TBD-xxx format (2000/SR1

    Thanks macropod! I had tried putting a backslash in front of it which did nothing. Hadn't thought of the single quotes.
    Karen

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •