Sum selection?

Viewing 3 reply threads
  • Author
    Posts
  • August 14, 2024 at 4:08 PM #50991

    Jeff Timp
    Participant

    Hello. Loving Tap Forms as a bento alternative. Thank you so much for making this wonderful program!! Wondering if the following is possible. This is something I use in Apple’s Numbers program all the time, so hopefully it’s possible in Tap Forms as well.

    Is it possible to select multiple entries from a numbers type column and have them sum? I know how to sum the entire column which is great, but I’m looking to sum only what I have selected, for example enteries 6-10 only. But then be able to quickly choose another set of entries, for example 1-8 and sum it. I’m hoping I dont need to create calculations for each of these as what I want summed quickly changes often or I’m sorting by a different column etc, but I guess maybe a work around would be some sort of master calculation that I then edit? Any help would be appreciated and thanks again for all you do!!

    • This topic was modified 4 months, 1 week ago by Jeff Timp.
    August 14, 2024 at 8:43 PM #50993

    Anonymous
    Inactive

    As far as I know, Tap Forms doesn’t currently offer a direct way to sum selected numbers within a column like you can in Numbers. But you can try create multiple calculation fields for different summation ranges (e.g., “Sum 1-5”, “Sum 6-10”, etc.).
    Use conditional logic to populate these fields based on other criteria (e.g., a checkbox or another field indicating which sum to calculate).

    August 14, 2024 at 11:23 PM #50996

    Daniel Leu
    Participant

    How about using savedSearch? Usually, I add a checkmark field to each record and use a savedSearch on this field.

    For whatever I want to do, I select the records in question, then go to the saveSearch with checkmark=1 and have just these records. Now you get the sum for the records.

    Additionally, I’ve a form script to clear the checkmark fields.

    August 15, 2024 at 7:04 AM #50997

    JScottA
    Participant

    Good morning. Here is what the Tap Forms Assistant provided:

    To address the user’s request regarding summing selected entries from a numeric column in Tap Forms without needing to create multiple calculations:

    1. **Selecting Multiple Entries**: Tap Forms itself doesn’t directly allow summing only selected entries through its standard interface without scripting or creating calculations. However, there are workarounds depending on your workflow.

    2. **Using Filters**: One approach could be to use Tap Forms’ filtering and grouping functionality to narrow down your dataset to just the entries you want to sum. Once filtered, you could use the summary calculation options that display totals at the bottom of the list view (available in Multi-Column view).

    3. **Scripting**: If you frequently change the range of entries you want to sum, a more flexible solution would involve scripting. You could write a JavaScript function within Tap Forms that allows you to select different ranges or criteria and then dynamically sum the values. This script could be easily modified each time you need a new sum.

    4. **Summary Calculation**: For a non-scripting approach, if you have a common range of entries you select often, you could set up multiple summary calculations within Tap Forms. These could be pre-set for various ranges and simply toggled on or off as needed.

    For a deeper dive into summary calculations, see page 29 of the Tap Forms manual, which discusses the summary options available, including summing, averaging, and counting entries within a field.

    If you’re interested in the scripting approach, the Tap Forms Scripting 101 guide online would be a good place to start to create a custom script tailored to your needs.

    If you need further assistance setting up any of these methods or want more details on scripting, let me know!

    August 15, 2024 at 2:55 PM #50999

    Jeff Timp
    Participant

    Good morning. Here is what the Tap Forms Assistant provided:

    What is “Tap Forms Assistant” and how do I access it? This seems like a great resource!

    August 15, 2024 at 2:58 PM #51000

    Jeff Timp
    Participant

    Thank you all so very much for the ideas! I decided to use the advance search function and so far this is working well (thanks Daniel for the hint!), but I will be bookmarking this to return to in the future if I need more advance options like the ones shared here.

    Thank you all!

Viewing 3 reply threads

You must be logged in to reply to this topic.