Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Grouping Records
- This topic has 3 replies, 2 voices, and was last updated 3 months, 3 weeks ago by Kyla Lemon.
-
AuthorPosts
-
September 3, 2024 at 9:40 AM #51101
Kyla LemonParticipantHi 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
JScottAParticipantMaybe 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 LemonParticipantI 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 LemonParticipantOMG – I figured it out, I needed the new form to be in the same place as the existing form. Little by little. – Kyla
-
AuthorPosts
You must be logged in to reply to this topic.