Can I make a report with repeating use of fields?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Acknowledged
I'm replacing my sailing club's Access database with a QB app. One of the outputs from the Access version is a report that is used to issue food tickets to members.  The report is a single page per member with the member's name, number and year printed on each cell in a 5x5 table. Is it possible to do something similar in QB?  I think I can imagine a solution involving a child table for the tickets with the output arranged in some sort of crosstab report, but that seems like a lot of work.  Is there another approach that would make more sense?   Thanks in advance!
Photo of Thommango

Thommango

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Can you post a screen shot of what you are currently using so we have a better idea of the end goal you are looking for?
Photo of Thommango

Thommango

  • 160 Points 100 badge 2x thumb
There's really not much to see.  I have a table of members and I basically want to print the member name, member #, and the year in each cell of a 5x5 table.  I want that table to be the only thing printed on an 8x11 page, and I want to print 1 page per member.  Thanks.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
As far as a natively, and formatting it the way you are looking, no.

You are going to want to use the something similar to "exact forms".

Use have an add-on called "CirrusForms"  where you create a template, then just plug in the field IDs for the values you want, push a button and bam.  You can do "batch" creations too where you can make multiple sheets for different people all at once.

If you can't get it with the native "exact form" let me know and I can show you en example for you.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
This is trivial to do in QuickBase with script. The only question is what this means:

"The report is a single page per member with the member's name, number and year printed on each cell in a 5x5 table"

Post a screenshot of what you want the page to look like.

Photo of Thommango

Thommango

  • 160 Points 100 badge 2x thumb
Okay thanks.  Here's what I'm thinking this would look like...
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
I assume you want it to look like this:

https://jsfiddle.net/vw41arju/embedded/result,html,css,js/

This is an ideal example of using CSS flexbox with QuickBase. If you follow any of my other demos that use script this would be a snap to implement.



If you need additional assistance implementing this project feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt
(Edited)
Photo of Thommango

Thommango

  • 160 Points 100 badge 2x thumb
Thanks Dan, 
This looks great. I'm new to quickbase and very rusty on my web skills so I may be missing something.  I tried to follow your directions for the [script] technique but I must have missed a step somewhere.  I'll try again as time permits.  
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,272 Points 20k badge 2x thumb
Actually I had a demo in progress when we lost power the other day. Let me finish in now.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
Bingo Was His Name
https://haversineconsulting.quickbase.com/db/bmprmragv?a=dr&rid=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=577

You can add your own records to this demo:

https://haversineconsulting.quickbase.com/db/bmprmragv?a=nwr

The Bingo button only appears on view records (but it could be included on reports).

If you need additional help implanting this solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt