Hi, I need some help building a workflow that can compare Status' between the documents in Laserfiche to their data in MySQL. Then email any Status' that do not match. There would need to be some tricks in there as the Status name in Laserfiche would need to be modified to match a Status Code in our database.
For example:
The Contract Number will be required to match each document.
Search our MySQL database for certain Status type code (A, F, S, O) do not include other codes (about 5 of them).
Then use the Contract Numbers for those Status' to Search Laserfiche.
To compare that the Status' match, the Laserfiche Status' need to be modified from words to a code (eg Application Rec'd->F, Accepted->A, Outstanding->O, Signoffs->O, Settled->S).
Non Matching Status Codes to be emailed.
Not sure if you can help create a sample workflow for us? I am struggling with this one.
Kind Regards