Skip to content

Add calculated fields to Accession #4802

Closed

Description

@grantfitzsimmons

Is your feature request related to a problem? Please describe.
Specify 6 has a number of calculated fields for Accession that are not supported in Specify 7.

  • totalCountAmt - Sum of all Preparation counts based on the countAmt field
  • actualTotalCountAmt - Sum of all Preparation counts based on the actualCountAmt virtual field (the count of preparations available after subtracting preps used in interactions)
  • collectionObjectCount - Count of all Collection Object records in the Accession
  • preparationCount - Count of all Preparation records associated with COs in the Accession

Reported By
CSIRO

From my comment:

image

Specify 7 supports the actualTotalCountAmt calculated field, but as Bronwyn mentioned, we do not support the other fields included on the default Accession form (totalCountAmt, preparationCount, or collectionObjectCount )

The count field you are looking for to give a sum of all collection objects is unfortunately the collectionObjectCount field rather than the actualTotalCountAmt field which sums the counts of all preparations in the list of associated collection objects.

See on Asana

Activity

  1. added
    1 - RequestA request made by a member of the community
    2 - InteractionsIssues that are related to interactions, including loans, exchanges, gifts, and more
    on Apr 17, 2024
  2. grantfitzsimmons commented on May 3, 2024

    @grantfitzsimmons
    MemberAuthor
    image

    @acwhite211 @CarolineDenis Did we add this in 7.9.4? This is on edge

  3. CarolineDenis commented on May 24, 2024

    @CarolineDenis
    Contributor

    @grantfitzsimmons, this can be closed

  4. added this to the 7.9.x milestone on May 28, 2024
  5. emenslin commented on Jul 9, 2024

    @emenslin

    Fixed

  6. removed this from the 7.x milestone on May 5, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

1 - RequestA request made by a member of the community2 - InteractionsIssues that are related to interactions, including loans, exchanges, gifts, and moreSeparationFrom6

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions