• leave Summary outling errors on one computed entry

    By Ted Hardenburgh 2 decades ago

    The Leave Summary outline shows an error for the first computed entry. Looking at the other computed entries, they include some error checking to get around a problem with the DBLookup, if one occurs. It looks like it's occuring in this instance, so I copied the formula from the other computed entries and adjusted it to be the following.



    @If(

    !@IsError(@DbLookup("";"";"Countries";"LEAVE";2));

    @DbLookup("";"";"Countries";"LEAVE";2);

    "Leave"

    ) + " by"



    Looks like all the computed entries error with this lookup and use the fallback text in the formula.

    • It's a Bug!

      By Bob Brodsky 2 decades ago

      Ted,



      Thanks again for your interestin Vacation Request!



      You are right! The code that you quoted should be in the first outline entry as well.

      I'll update the release.



      More importantly some documentation is missing from the Help,Using document:



      There is a "special" Location Code (LEAVE) that should always be in your list of locations. The Location Name for the "LEAVE" Location Code should be whatever word that you would like to appear in various navigation aids rather than the default word "Leave." So, if you would like to have a Holiday Tracking system, then create/update the "LEAVE" location document so that its Location Name is "Holiday" and the navigator will display "Holiday Tracking." Some of our people wanted to use the system for "Event" tracking rather than Leave tracking…





      Sorry for the problems,

      Bob