Skip to main content
Question

Can I make a report with repeating use of fields?

  • April 11, 2017
  • 0 replies
  • 45 views
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!
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • April 11, 2017
      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?
      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.
      • MCFNeil
      • Registered
      • April 11, 2017
      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.
      • anomDiebolt
      • Registered
      • April 11, 2017
      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.

      Okay thanks.  Here's what I'm thinking this would look like...
      • anomDiebolt
      • Registered
      • April 11, 2017
      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
      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.  
      • anomDiebolt
      • Registered
      • April 13, 2017
      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
      Terms & ConditionsAccessibility statement