View Child records as form not report
Is there an option to show each child record as its own form within a parent form? I know I can embed/link the records to via a report, but my child data set contains a ton of fields that cause the ...
Forum Discussion
Follow up question, is there another type of report that could be configured to show the child records but not in a table like display?
------------------------------
Ember
------------------------------
I can think of 2 ways you could accomplish this, one custom, one native. Both come with their own complexities and risks:
OPTION 1:
Do it through a codepage. You can build your own HTML form - query your children and render your own custom form that you can use JS to paginate through in your own design. You can copy the styling from the native QB form to make it feel like its part of the form and feels more seamless if you wanted. This will be your most complex option but will probably get you exactly what you want.
OPTION 2:
This will be off the beaten path quite a bit so bare with me. I will add that I have used this A LOT lately, just never to this extent of trying to display the contents of an entire child record.
The concept is basically to build a formula-text field using all the HTML Tags/styling that you would want in each child. Basically you make a really complex formula with all the rows, columns, tables etc that you want and style that as if you're trying to recreate the display of a form inside a formula and you do this as a field in your child table.
Then you summarize that text field into your parent record using your relationship and the combined text field, and build essentially a really big combined text field. With that - you can then just display it back with a formula-rich text in your parent record and it renders the compiled version of all your children as a massive HTML block.
Just to give examples - in some cases I don't like using native Quickbase embedded reports for various reasons including that sometimes I want the width of columns to be exact or I want to color or style specific elements on my own. I build a table row text field in each child record, then summarize into a parent and plot it into a <table> and I build a dynamic table on the fly. I've done similar with building out a 'schedule', plotting out jobs that occur in a given day/hour and positioning each dot between for each hour to visually show it in a way that gantt charts/calendars can't.
------------------------------
Chayce Duncan
------------------------------