Discussions

Expand all | Collapse all

Can I make a report with repeating use of fields?

  • 1.  Can I make a report with repeating use of fields?

    Posted 04-10-2017 23:08
    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!


  • 2.  RE: Can I make a report with repeating use of fields?

    Posted 04-10-2017 23:11
    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?


  • 3.  RE: Can I make a report with repeating use of fields?

    Posted 04-10-2017 23:14
    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.


  • 4.  RE: Can I make a report with repeating use of fields?

    Posted 04-11-2017 04:45
    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.


  • 5.  RE: Can I make a report with repeating use of fields?

    Posted 04-11-2017 17:36
    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.



  • 6.  RE: Can I make a report with repeating use of fields?

    Posted 04-11-2017 17:48
    Okay thanks.  Here's what I'm thinking this would look like...


  • 7.  RE: Can I make a report with repeating use of fields?

    Posted 04-11-2017 19:23
    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.

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1581284/RackMultipart20170411-25029-ihzz00-screenshot_inline.jpg?1491938755">

    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


  • 8.  RE: Can I make a report with repeating use of fields?

    Posted 04-13-2017 18:19
    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.  


  • 9.  RE: Can I make a report with repeating use of fields?

    Posted 04-13-2017 18:24
    Actually I had a demo in progress when we lost power the other day. Let me finish in now.


  • 10.  RE: Can I make a report with repeating use of fields?

    Posted 04-13-2017 19:14
    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