Grouping Records

Viewing 3 reply threads
  • Author
    Posts
  • September 3, 2024 at 9:40 AM #51101

    Kyla Lemon
    Participant

    Hi All –  I am running a Quilt Show using Tap Forms!  I have done so much already (actually very easy to use), but I need to figure out one more thing.  I have 200 records, one record per quilt entry.  I have already made layouts for display cards, layout cards, and spreadsheets for other committees.  But I need to group/link records by “quilter”.  I need a layout that will list all of the quilts entered by one individual.  We use this layout to check-in and check-out quilts.  Some people enter 1 quilt, others have 5 or more.  Not sure if this requires a script or linking records?  Any advice would help, as I am running out of time, the show starts on 9/19.  Thank you! – Kyla

    September 3, 2024 at 12:02 PM #51102

    JScottA
    Participant

    Maybe this response will help…it is from “Tap Forms 5 Assistant” a custom GPT created to help with TF5 questions. It is unofficial and a generative AI. So use what helps and through the rest out!

    To achieve what the user wants—grouping or linking quilt records by quilter and creating a layout that lists all quilts entered by one individual for check-in and check-out—a combination of Tap Forms’ built-in relationships and custom layouts will be useful. Here’s how you can do this:

    ### 1. **Linking Records by Quilter**

    To group records by quilter, you should use a relationship field to link all quilt records to a specific quilter.

    1. **Create a Quilter Form:**
    – Go to Forms and create a new form called “Quilters.”
    – Add fields like Quilter Name, Contact Info, and any other relevant information.

    2. **Add a Link to Form Field:**
    – In your Quilt Entry form, add a “Link to Form” field.
    – Set the “Link to Form” field to connect to the Quilters form you just created.
    – This will allow you to link each quilt entry to a specific quilter.

    3. **Set the Relationship Type:**
    – Choose a “One to Many” relationship, meaning one quilter can have multiple quilts linked to them.

    ### 2. **Creating the Layout for Check-In/Check-Out**

    Now that you’ve linked the quilt records to the quilters, you can create a layout that displays all quilts by a specific quilter.

    1. **Design a Custom Layout:**
    – Go to the Layouts section for your Quilt Entry form.
    – Create a new layout that includes fields like Quilt Name, Quilt Number, and any other relevant details.
    – Ensure that the “Link to Form” field is also included so that it pulls in the associated quilter’s name.

    2. **Grouping in the Layout:**
    – Use the “Grouping” feature to group the quilts by the quilter. This will make it easy to see all quilts associated with a particular quilter on the layout.
    – Ensure that the layout is optimized for printing or digital use during the check-in and check-out process.

    ### 3. **Viewing Quilts by Quilter**

    Once the relationships are set up:

    – You can easily filter or sort the records in your layout by quilter name.
    – Alternatively, use the search or grouping features to display only the quilts for a selected quilter during check-in or check-out.

    This method should meet the user’s need for organizing quilt records by quilter and efficiently managing the check-in/check-out process.

    For further details on setting up relationships, you can refer to the section on Relationships in the Tap Forms manual, particularly on page 91 [oai_citation:2,1328_16794_en_1538683502.pdf](file-service://file-15C3MsaZPdU2JvfF2hiej31w). Additionally, the Layouts section (starting on page 80) will guide you through designing custom layouts [oai_citation:1,1328_16794_en_1538683502.pdf](file-service://file-15C3MsaZPdU2JvfF2hiej31w).

    September 8, 2024 at 2:20 PM #51105

    Kyla Lemon
    Participant

    I have created the link to form field in the quilt entry form, but the “Quilter” form does not show in the pop-up choice to link to…  I only see the form I am in?  How can I get my new quilter form to show up?

    • This reply was modified 3 months, 3 weeks ago by Kyla Lemon.
    Attachments:
    You must be logged in to view attached files.
    September 8, 2024 at 5:38 PM #51109

    Kyla Lemon
    Participant

    OMG – I figured it out, I needed the new form to be in the same place as the existing form.  Little by little.   – Kyla

Viewing 3 reply threads

You must be logged in to reply to this topic.