Forum Discussion
ArchiveUser
Qrew Captain
Hi Michael,
Thanks for reaching out via the QuickBase Online Community!
You can in fact use custom reports with sorting and grouping in Exact Forms. Here's a our Help Article on how to customize Exact Forms, with formatting specifics towards the bottom: http://www.quickbase.com/user-assistance/Default.html#creating_exact_forms_tips.html
Daniel
Thanks for reaching out via the QuickBase Online Community!
You can in fact use custom reports with sorting and grouping in Exact Forms. Here's a our Help Article on how to customize Exact Forms, with formatting specifics towards the bottom: http://www.quickbase.com/user-assistance/Default.html#creating_exact_forms_tips.html
Daniel
AnthonyGuillen1
7 years agoQrew Cadet
Amanda, on my exact form, it shows up as a simple table with no edit/view icons at all. See below. Here is my query:
~=qdb.GetURL("tokenidhere", "API_GenResultsTable^query={'36'.EX.'"+ field["Work order ID#"]+"'}AND{'40'.LT.'20'}^clist=26.22.24.17.19^slist=40^ts="+ new Date().getTime());~
Again, I could never figure out how to call a specific report by ID because the example query doesn't have it and customer service could not help, and so I replicated the report. The first part of the query uses a boolean to match field 36 with the record ID (Work order ID# in my case) AND field 40 being less than the value 20. Clist calls fields 26,22,24,17, and 19; which are the 5 fields you see below. And slist sorts by field 40 which i don't even use in the table, but it works nevertheless. No edit/view icons show up.
Perhaps you were using a simple call for the related table like ~Orders~ where "Orders" is the report link field? If I recall, that does give you a full table, but my problem with that was that it had all the columns and maybe it did have edit/view icons, too. Which is why I had to use a custom query to show the table the way I needed it.
~=qdb.GetURL("tokenidhere", "API_GenResultsTable^query={'36'.EX.'"+ field["Work order ID#"]+"'}AND{'40'.LT.'20'}^clist=26.22.24.17.19^slist=40^ts="+ new Date().getTime());~
Again, I could never figure out how to call a specific report by ID because the example query doesn't have it and customer service could not help, and so I replicated the report. The first part of the query uses a boolean to match field 36 with the record ID (Work order ID# in my case) AND field 40 being less than the value 20. Clist calls fields 26,22,24,17, and 19; which are the 5 fields you see below. And slist sorts by field 40 which i don't even use in the table, but it works nevertheless. No edit/view icons show up.
Perhaps you were using a simple call for the related table like ~Orders~ where "Orders" is the report link field? If I recall, that does give you a full table, but my problem with that was that it had all the columns and maybe it did have edit/view icons, too. Which is why I had to use a custom query to show the table the way I needed it.