1 Reply Latest reply on Sep 17, 2009 1:24 PM by ninja

    Field Info Help!

    Maxvan

      Title

      Field Info Help!

      Post

      I am currently creating a sales contact log. I have a field called "heading tasks" that i type the heading into. I have a second field called "Task Entry" that i type a description into. I want to be able to press a button and the two fields together with a time stamp get automatically entered into a third field call "Tasks". Therefore as i add more entries the "Tasks" field continues to be updated but the old entries are still visible Eg below. i assume i need to create a script, but being new to filmmaker a script to do this is by far a bit beyond my current skill level.

       

      ----------------------------------------------------

      12/09/2009 9:21 PM

      Printing

      Hello hello hello hello hello hello

      hello hello hello hello hello

      -------------------------------------------------------

      10/09/2009 9:21 PM

      Web site

      Test Test Test Test Test Test Test TestTest

      Test Test Test TestTest Test Test TestTest Test Test Test

       

      Thanks!

        • 1. Re: Field Info Help!
          ninja
            

          Howdy maxvan,

           

          I personally would prefer to have a child table with related records in this case (rather than appending info onto a single field).  You could then view your activity chain through a portal and get the same result without having to click the button.

           

          If you must append (can't figure out how this would be a must):

           

          SetVariable ($Task; Table1::Tasks)

          SetField (Table1::Tasks; $Task & Get(CurrentTimeStamp) & Task Entry)

          Setfield (Table1::TaskEntry ; "" )   /##clears out the task entry field in case you doubleclick the button by accident 

           

          You could really do it in a single self referencing Setfield, but I shy away from self referencing functions as a matter of course...got myself into trouble too often with them.

          SetField (Table1::Tasks ; Table1::Tasks & Get(CurrentTimeStamp) & Task Entry)

           

          Hope this helps...especially if you choose the Child table route :)