Help! Update field based on referenced name

Ask the community
,
1

Hi
I have a dataset called “User_Info” and it contains names and monthly contribution amount.
I want to update a second dataset call “Contributions” which pulls in the monthly contribution amount based on the users name from the “User_Info” dataset.
I need this info to be pulled in so I can do some simple calcs.

For example of second dataset
Month User Contribution
1 BOB 10 <= want the ‘10’ to be pulled in when I select BOB
1 SUE 25 <= want the ‘25’ to be pulled in when I select SUE
2 SUE 25 <= want the ‘25’ to be pulled in when I select SUE
3 BOB 10 <= want the ‘10’ to be pulled in when I select BOB
3 SUE 25 <= want the ‘25’ to be pulled in when I select SUE

Thanks in advance for the help!
Will

2

Hi,

I believe these articles about Reference Fields will help you:

Best,
Sapir