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:
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:
2 Likes
muneer
July 27, 2022, 7:15am
22
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
muneer
July 27, 2022, 7:38am
24
Use this
[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
zander
July 28, 2022, 4:02am
26
Check this post out. If might be exactly what you are looking for.
Project link:
Project Link
Purpose/description:
Pulling in all data from Airtable can be too much sometimes. pulling in only the data you need, and having it presorted can save you time and processing power in your app.
This project filters by Age and Sex, then sorts the data by age ascending.
[Screen Shot 2022-05-24 at 2.33.12 PM]
See how data comes in unfiltered when you remove the query parameters!
Goes well with:
Apps powered by airtable.
1 Like
system
Closed
October 26, 2022, 4:03am
27
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.