How to add the vaules of filtered data dynamically on screen

Ask for Help
1

Hi Everyone,

I have a DB which is collecting the users data for appointments booked, these are then verified whether its approved or rejected.
I want that on the screen once I select particular user, its total booked appointments sum as well as total approved appointments sum shall be displayed. Is there solution to this?
Thanks

2

A couple of query columns…one linking the entered user id to the appointment user ID along with a condition to check the approved status…and one just checking the userid should work. Follow that with a couple of Rollup columns to sum the number of row in each query.

3

Thanks Jeff,

It worked perfectly fine. However, I am curious to know how to display data on the screen, as the DB contains repetition of the user ID whenever they enter a record and to all those field Booked count and approved count is displayed.

Is it any way where on front side we can only show the roll of each user.

4

Are you showing a collection and you want the collection to only show unique users?

5

So, I was thinking of data grid to use for example. If DB has Jack, Mat, Tina with data it must show as:

Name Booked Approved
Jack 5 3
Tina 2 2
Mat 6 5

I am attaching a snapshot hows its showing now to me

image

6

Ok, so what I do for that is first make sure you have a Row ID column. Then create a single relation that links the user email to itself. Then create a Lookup column to retrieve the Row ID from the relation. Now you can filter your grid to only show rows where the Row ID is equal to the Lookup Row ID.

7

That was smooth. It worked 100%.

Thank you so much Jeff for your support

1 Like
8

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