Grid

Answered
Avatar
James Cortez

How does one access the data an app user enters into a grid(looped screens) to perform calculations? Whenever I try to pull data with a summary field, it totals everything in the column, instead of individual cells. 

0

Comments

4 comments

Sort by Date Votes
  • Avatar
    Sara Kaplow, Community Manager

    Hi James,

    To calculate within the row of a loop, you'll need a calculation field on that screen. Here's what that looks like in the App Builder: 

    In the App, here's how that plays out: 

    And in the grid: 

    Summary fields give you the ability to total all of the columns; calculations on the loop screen itself allows you to total within the row.

    Hope this helps!

    1
    Comment actions Permalink
  • Avatar
    James Cortez

    Thank you so so much Sara. Now everything works. Just one more question. I have multiple fields running calculations. I can hide them by un-checking the "Mobile Visible" setting under more, but how can they not be shown as a column in a grid?

    1
    Comment actions Permalink
  • Avatar
    James Cortez

    Never mind. They display on the app builder, not not on my actual phone. Silly me. Thanks again for your help.

    0
    Comment actions Permalink
  • Avatar
    Sara Kaplow, Community Manager

    Glad it's working for you! 

    0
    Comment actions Permalink

Please sign in to leave a comment.