I would like to suggest integrating also the Query Tables from Zoho Reports into the Zoho Creator.

I find it hard to produce an output whenever I use the "Lookup" fields in Zoho Creator. It just loads the Row ID without it's equivalent rows like description, etc.

Customer Name is automatically loaded upon entering this form, but upon saving, I save the ID as reference.

But when I create a report using this table/view, the Customer table is not included in the columns (Pivot table) unlike in Zoho Reports when we use Lookup columns. I'd like the Name, instead of the ID, to be included in this report but I prefer to save the ID in the table because it was a rule that I follow in DB Normalization.

If this feature is already included in Zoho Creator, kindly reply to this thread.

Thanks so much!

Christian Joy :)