Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Field Modification Flag


Mr. Bungle
 Share

Recommended Posts

I want to have a calculation that will look at a series of fields and set a flag if any one of them has been modified. I would then create a script that would find all the records that has this flag set, then export them and clear the flag.

 

Sounds simple, but I'm at a loss as how to go about it...

Link to comment
Share on other sites

Try a number field with an auto-entered calculation (replace existing) of:

 

Let (

watchFields = Somefield & Anotherfield & YetAnotherfield

;

1

)

 

Perhaps using a timestamp field with Get (CurrentTimestamp) instead of the "1" flag would be better: then you can find records that were modified since last export, and you don't need to clear anything.

Link to comment
Share on other sites

  • 2 weeks later...

Comment:

 

Thank you, thank you, thank you. Not only did you solve my problem, but your advice gave me valuable insight in to the LET function.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use