[Jesse Mulert]

Hi all,

I have a scheduled workflow that runs every half hour to make sure that a few fields contain correct values. The problem is that if a user is already editing the record when the workflow executes, they will receive a warning upon saving that states that another user has made edits to the record since they started editing. The users changes will be rejected.

Is there a way I can tell whether a record is currently in edit mode? I’ve thought about adding a timestamp that triggers when the record is opened in edit mode, but this value clearly wouldn’t be registered by the server until save, defeating the purpose.
This is a cached copy. Click here to see the original post.

[sklett]

Your design begs the question: Why do this as a scheduled process? Is there really no appropriate events to hook into and validate on?

As you pointed out, the timestamp needs to be written somewhere to be accessible to the WF.

Additionally, WF seems a potential bad fit for field value validation. I don’t know what you’re doing exactly, but if it’s a single State workflow you should use a script.

[dmatyas]

Script is not really necessary, workflow can do the the job as well, but as sklett mentioned … reconsider the type of workflow. Why not execute the workflow on record edit on “After Record Submit”. This will still evaluate the correctness of fields, but prevent the “record has been changed” errors.

[Author]

Posts