Making a dynamic sum based on user

Ask the community
, ,
1

Hey guys,

well, this one might be complicated to explain. I have a members area where I use a dynamic page to display campaigns. Each time a person completes a campaign would get assigned a number of X points. These points are to be displayed in their account page.

In order of events:

  • A campaign is displayed
  • Participant completes the campaign
  • Points are assigned (based on the field containing the campaign points()
  • Points are added (from all completed campaigns)
  • Sum of points is displayed in the account page of the user.

I’m completely lost on where to start building here. Please help!

2

Hi Andres,

I would add a column to the collection called “total points”. Every time a member completes a campaign add the needed points to this column using wix-data API.

In the dynamic page bind the total points editor element to this column.

If you need someone to build it for you, you can search for relevant partners in https://www.wix.com/arena

Thanks,
Asaf

3

Hi Asaf, i’ve been trying for a couple of days without any good results. I already posted on the arena but didn’t get any response so far. Although it would be easier to have it built, I would really like to learn how to do it myself! :slight_smile:

Thanks!

4

Hi Andres,

You can go over some the Corvid help center https://support.wix.com/en/corvid-by-wix/basics

You mostly need to know $w and wix-data API.

If you get stuck, feel free to share your site URL and what part you are stuck on and I will have a look.

Thanks,
Asaf

5

@asafr Thanks! I will be taking a look at the link. You can also see the discussion i had with @J. D. about the topic here where he tried to help me already but we couldn’t manage to find the problem https://www.wix.com/corvid/forum/community-discussion/filter-results-and-sum-based-on-user/p-1/dl-5d83879d6c7b180017fa4bb4-5d8369203829de0017d4e6b7-13