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?

3 replies

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    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

    • OccasionallyGirly
    • 3 yrs ago
    • Reported - view

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

    • OccasionallyGirly
    • 3 yrs ago
    • Reported - view

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

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 371Views