I am trying to think around this problem - joining two different sources of information into one.
I have a data range search that returns Adjunct Agreement to teach entries and puts them in a table format with Update Word Document action (columns like Name, Course Name, Course Code, Start Date, End Date, and Pay).
There is a query from one of our SQL server that returns whether or not grades have been posted (along with columns like Name, Grades Posted (yes/no), Course Name, Course Code, Start Date).
How do I match the rows created by the Search action with the query data to fill out the correct row with the Grades Posted data?
I know I can probably have another workflow place the Grade information into my Laserfiche entries first which would resolve this issue. But this is my backup option.