Zoho Creator表单关联与记录统计求和技术咨询

Hey there! Let’s break down exactly how to link your two Zoho Creator forms and get those point totals rolling. I’ve worked through similar setups before, so here’s a step-by-step guide tailored to your needs:

First, we need to create a solid connection between the two forms using your "UID - Lastname, Firstname" primary key. Since Form B stores these as separate fields, we’ll start by building the full identifier there:

• In Form B, add a Calculated Field (name it something like Full_Member_ID). Use this formula to stitch the components together:

  UID + " - " + Lastname + ", " + Firstname
  

  Double-check the spacing and punctuation to match the exact format used in Form A’s person identifier column.
• Next, head to Form A and add an Association Field. Choose Form B as the linked form, then set the matching fields to:
  • Form A’s person identifier column
  • Form B’s new Full_Member_ID field
    This will tie every points record in Form A to the correct member in Form B.

Now that the forms are linked, you have a couple of ways to display total points and other stats:

Option 1: Show Total Points Directly in Form B #

• In Form B, add a Summary Field. Select Form A as the data source, pick the Points_Earned column, and set the calculation type to "Sum".
• This field will automatically tally up all points records from Form A that are linked to the current member, updating in real time as new records are added.

Option 2: Build a Custom Report for Aggregated Stats #

• Go to Zoho Creator’s Reports module and create a new report using Form A as the source.
• Add a Group By rule: Use either Form A’s person identifier column or the linked Form B member details (like Full Name) to group records by individual members.
• Add a Summary Calculation for the Points_Earned column, choosing "Sum". You can also add other stats here, like count of records per member, if needed.

Bonus: Real-Time Sync with Workflows #

If you want to ensure totals update instantly when a new point record is added:

• Create a Workflow in Form A that triggers when a record is created or edited.
• Set the action to "Update Records" in Form B, targeting the linked member’s total points field with the latest sum from Form A.

• Matching Format is Critical: Even a single extra space in the identifier will break the association. Use data validation in Form A to enforce the exact "UID - Lastname, Firstname" format.
• Check Association Links: If summary fields aren’t populating, verify that the association fields in both forms are correctly mapped and that there are matching records between Form A and B.
• Bulk Data Fixes: If you’re importing existing records, make sure the identifiers are consistent across both forms before importing to avoid mismatches.

内容的提问来源于stack exchange，提问作者Johan Brink