0

I need to copy one date field to another but only the first time the source field is populated... how / is this possible?

I“d like to copy a field called ”Listing Date“ to another field called ”Original Listing Date“, but only once (the first time that ”Listing Date“ is populated).

I assume that trigger on create won”t work because the record is sometimes created days / weeks before the actual listing date, which means the “Listing Date” would be blank. Similarly, trigger on update wouldn“t work, as the ”Listing Date“ field will change periodically while ”Original Listing Date“ should remain static.

Any ideas?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Would this, as “Trigger on update” of field “Listing Date”, lead to the result you want:

    if “Original Listing Date” = null then
         “Original Listing Date” := “Listing Date”
    end

    Like
  • Yessss!! Worked perfectly! Thank you so much!! :-)

    Like
  • Yessss!! Worked perfectly! Thank you so much!! :-)

    Like
Like Follow
  • 1 yr agoLast active
  • 3Replies
  • 356Views