• Problem vith running the agent

    By Attila Peter 2 decades ago

    Hi,



    I get the following error message when I tried to run the agent:



    "Invalid value for NotesViewColumn property formula."

    The formula value is the following:

    " vc.Formula="@If(CSjobVisitDate=[2005.08.22];@If(CSjobCategory=""Time off - holiday"";@Char(120);CSjobStatus=""Tentative"";@Char(99);CSjobCategory=""Duty Phone"";@Char(212);@Char(103));@Char(99))" "



    The other strange think is that the "DD" value did not appear in the command line.

    I'm using Hungarian date format YYYY.MM.DD



    Attila

    • More info on Bug

      By ace aceindy 2 decades ago

      Hello Attila,



      I need a bit more info; what version of notes are you running (Client/Server).



      Also keep in mind that writing a columns value/title is only possible from version > R6.

      In earlier versions, the data exsists, but is read-only.



      From designer help:

      The formula for a column that is based on a simple function or a formula.

      Note This property is read-write with Release 6.



      Defined in

      NotesViewColumn



      Data type

      String



      Syntax

      To get: formula$ = notesViewColumn.Formula

      To set: notesViewColumn. Formula = formula$







      Let me know,

      (also, this database is a raw example; you will have to modify it to your own needs).

      • By Attila Peter 2 decades ago

        Hi Ace,



        I'm using R6.5.4. So it should work. What date format do you use?



        Attila

        • re-format formula

          By ace aceindy 2 decades ago

          I see now; indeed it goes wrong with the date format.



          Try to change this line (ScriptLibrary\CommonLS\UpdateColumnHeaders, row 19)

          from:

              dd = Today()+ daycount      'set dd to datecount<br/>

          into:

              dd = Format$(Today()+ daycount,&quot;dd/mm/yyyy&quot;)          'set dd to datecount<br/>



          to force use of standart date-format



          Let me know if it works, and I'll update the design, thanks for the report :-)

          • By Attila Peter 2 decades ago

            Thanks for the correction. It is working now. I suggest to add the date format to Notes.ini, and create a button to modify this settings. In this case the can be used with different date formats. (I hope)

            • Already solved

              By ace aceindy 2 decades ago

              Hello,



              Thanks for the suggestion,but that shouldn't be neccesary anymore;



              I re-format the date format using format$(dd,"short-date"), so all dates turn out the same.

              (short-date depends on international settings on server)



              I've also fixed another date issue which messed up the colors when different date formats where used, so R2.12 should appear soon.

              (Found out I don't need @Contains in the color-column formulae, I can use = instead)



              Thanks anyway :-)