How to get total items in a column

upon rereading your request it seems like you wish to get the NUMBER OF ITEMS in a column (instead of the sum), i would suggest this block:
image

however if you need the SUM of all the items in a column that happen to be text, use this function:

and use this block instead:
image

2 Likes

Yes, you will not find it. You are using StP and connecting to Aitrable using the Airtable component but @zander is talking about the blocks that you will only see once you connect your table using the Data Source option in the bottom of the component tree.

2 Likes

Yea,but I would still go with the provided option first

2 Likes

Use this

image

[Update]
This will give you number of items (rows). If you want a running total of all item values let me know to share the codes.

3 Likes

i forgot to mention that the base records for multiple user,so therefore if am getting total number of a row,it will be a current user

1 Like

Check this post out. If might be exactly what you are looking for.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.