Get Invoices From Zoho Books To Zoho Creator

Get Invoices From Zoho Books To Zoho Creator

I need create a lookup field in Zoho Creator to locate all invoces with a balance due in Zoho Books. I currently have:

 invoiceslist = zoho.books.getRecords("invoices", "936496201", "invoice_number");
Invoice:ui.add(invoiceslist.get("invoices"));

under the 'on add' 'on load' and I'm getting a drop down that includes all invoice details in the lookup field ({"date":"2016-12-4","Zcrm_potential..... etc, etc.). I just want INV-XXXX to show up in the field then populate "Client Name" and "Amount Due" in the appropriate fields. 


Please do not refer me to the following link as I have yet to be helped by the zoho.com/creator/help pages.


Note: The organization id is made up for this post. 

Thank you in advance!