Matching values in 2 repeating groups

Need help
1

Hi,

I hope someone can help me. I am not too new to bubble, but this one issue is giving me some trouble. Probably something silly
I have two sets of data

  1. Role
    Within this role there are 29 themes each with a score.
    I use a repeating group to sort score highest to lowest and only display the top 12
  2. Employee
    The employee has the same 29 themes and different scores attached

I need the following:
If an employee top 12 theme matches the theme of the Role top 12 then count score.
Essentially, sum all scores that match on both Role top 12 and employee top 12.

Chat gpt is giving me looping suggestions and I am not too familiar with that.
Any help would be greatly appreciated.

Thanks in advance

2

When you say there are 29 themes, does that mean 29 fields on the Role datatype? Or is theme it’s own datatype. Can you post screenshots of your data structure?

3

This topic was automatically closed after 70 days. New replies are no longer allowed.