As a Zoho Creator newbie, I am attempting to run a schedule that sends a daily email.  Simply, it is a database of quotes I like that gets sent to friends and business associates.  

The quotes are in one table with the intended send date (Thoughts_View)

The details about the author are in another table (Authors_View)

I have been successful in getting the email to send with data from the primary table (thougths_view) but have not been able to get the date to send inclusive of the related table (authors_view).

I do see that the related fields are available when scripting but not when using scheduling.  Having scoured all of the help topics, I am stuck.  Here is what my current code looks like.  The "wiki_link" below is intended to relate to the author table but is unsuccessful.

DELUGE

sendmail

[

    from:zoho.adminuserid

    to:"matt.v@labelmatch.com"

    subject:"Testing Zoho Daily Quote"

    message:"QUOTE:&nbsp;&nbsp;" + input.Quote + "<br />\n<br />\n          AUTHOR: &nbsp;" + input.Author1 + "<br />\n<br />\n          QUOTE CATEGORY: &nbsp;" + input.Quote_Category + "<br />\n<br />\n          WIKI LINK: + input.Wiki_Link     <br type=\"_moz\" />"

    content type:HTML

]

Any help you can offer is appreciated.