So running into a lookup situation on a form.
The user has a form that has a hidden unique ID. This ID is in SQL and populates half the fields on the Form.
The other half of the fields on the Form are also populated from the same SQL database but the information may not be available at the time the user A is looking at the form. If the info is not there, user A basically waits until User B (in another process) submits their form which updates the database with the info. Then when user A opens their task again the info is filled in.
What happens sometimes is that the user A does a little work and then does a Save As Draft while the other fields are blank. User B finishes there work but when user A goes back to their form they open the draft and the info is empty. I end up un-hiding the unique ID, clearing it, putting it back in, and then it triggers.
Is there a way to get the lookup to trigger even when a draft is opened or everytime it's opened?
I already have the .attr("vo","e") on all the fields that get populated.
Thanks,
Chris