I have a database containing student data.
Within this, I have an html page to display (and allow staff to print) data from 15 tables. These tables are linked via a FullName lookup field. There are multiple I have created an html page and now need to:
1) Insert the zoho creator field names into relevant sections
2) Create new rows where needed to display multiple records in sections (eg My Family Contacts, My Daily Requirements, etc).
3) Enable users to be able to filter the Student records so they select to view and print certain records via this form.
Unfortunately, I seem to be failing at step one!
I have been reviewing the support pages relating to Fetch records, combined reports and html views but am finding it impossible to move forward based on this advice.
1) ref inserting fields from multiple tables, how do I reference the table and fields? I can’t see any help pages that will give me advice on how to reference the syntax of fields in multiple forms.
When I insert fields in a summary view (for example) it uses ${fieldname} as its format in html, but I need to refer to the table/form-name as well as this is a compiled report from a total of 15 tables/forms. But if I use the format ${tablename.fieldname} I can't get this to work in my html page.
Thanks for any help anyone can offer on here.