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
{{batchActionsCtrl.state.selectedCount}} {{batchActionsCtrl.state.selectedCount==1?'reply':'replies'}} selected Move Cancel
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

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

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

    Reply Like
  • Spam
    • Remove post
    • Remove and block user
  • Edit
  • Publish
  • Unschedule
  • Cancel event
  • Uncancel event
  • Set status
    • Clear status
  • Pin
  • Unpin
  • Bump
  • Open replies
  • Close replies
  • Clear flags
  • Move
    • Move to category:
    • Learn & Share
    • Get help
    • Webinars
  • Copy
    • Copy to category:
    • Current category
    • Learn & Share
    • Get help
    • Webinars
  • Change type
    • Change topic type to:
    • Discussion
    • Question
    • Idea
    • Issue
    • Article
    • Event
  • Restore post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Remove post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Publish
  • Spam
    • Remove post
    • Remove and block user
  • Edit
  • Pin
  • Unpin
  • Open replies
  • Close replies
  • Label
    • Clear label
  • Move
  • Clear flags
  • Restore post
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
  • Remove
    • Spam
    • Offensive
    • Inappropriate
    • Duplicate
    • Other
Like Follow
  • 1 yr agoLast active
  • 3Replies
  • 356Views