0
 
Author: Sorting First Post on Top ↑ Message:
4A-HEALTHY-BMI's Photo 4A-HEALTHY-BMI Posts: 5,969
11/7/13 7:49 A

My SparkPage
Send Private Message
Reply
I have facilitated giving goodies by using a spreadsheet. This helps when you have a fairly small number to grant, like 20 or 30.

I have a column of the spark ids to whom I want to give a goodie.

I make a second column with a formula that concatenates the spark id with the URL that grants spark goodies, complete with the appropriate goodie code.

So, for example, if "PASTAFARIAN" is in cell A1, the Google Spreadsheet formula to grant them clapping hands is

=concatenate("http://www.sparkpeople.com/goodies_send.asp?id=",upper(A1),"&goodie=248&gid=1111")

and will create a link that looks like:

http://www.sparkpeople.com/goodies_send.asp?id=PASTAFARIAN&goodie=248&gid=1111

That way I can generate quickly a list of the links I need for awarding goodies, which speeds up the process a little.

Since I use goodies as "prizes" when people complete challenges, etc. I don't usually have an unwieldy number to grant.

Never, ever, EVER give up!

From BMI 53 (336 lbs) to under 30. Now aiming for less than 20% body fat.

Media
tinyurl.com/4a-healthy-bmi-me
dia


Weight chart
tinyurl.com/4A-HEALTHY-BMI-graph

Blogs
tinyurl.com/4a-healthy-bmi-in
dex


Maintenance Info
tinyurl.com/maintenance-links

Goal 155 +/- 3%


246 Maintenance Weeks
 
0
65
130
195
260
PASTAFARIAN's Photo PASTAFARIAN Posts: 1,919
11/6/13 11:08 A

My SparkPage
Send Private Message
Reply
I gave up trying to distribute team sparkgoodies. Too time consuming. Instead, I just pick one person each month and give them a sparkgoodie worth all the points that the team has. Not particularly fair but better than not awarding them at all for lack of time.



 current weight: 154.0 
 
195
184.75
174.5
164.25
154
WENDYASEDBERRY's Photo WENDYASEDBERRY Posts: 97
11/4/13 6:58 P

My SparkPage
Send Private Message
Reply
I wonder if there is a developer that could help make this more efficient? Something along the lines of enter user 1, a comma and user 2, a comma and user 3, etc. This would save a tremendous amount of time for the team leaders to send spark goodies to several members at one time. My group has a lot of users, but only about 20 that have posted this year. If my group were as big as some, I imagine this would be a very daunting task and likely deemed not worthwhile so users could be missing out on goodies.

Co-Leader, Little Rock Sparkers


 Pounds lost: 11.0 
 
0
15.5
31
46.5
62
SP_COACH_NANCY SparkPoints: (158,833)
Fitness Minutes: (112,042)
Posts: 46,222
3/15/13 10:53 P

Send Private Message
Reply
That would be the case.

Coach Nancy



MOONSTREAM's Photo MOONSTREAM SparkPoints: (30,936)
Fitness Minutes: (55,603)
Posts: 858
3/15/13 10:52 P

My SparkPage
Send Private Message
Reply
so if I have enough goodie points to give to 478 members - I have to type each of their usernames?

~"For nothing is impossible with God." Luke 1:37
Team Administrator...Leaving 170-ville & SP Class of Nov 25-Dec 1, 2012
- Ohio -


 Pounds lost: 29.6 
 
0
12.5
25
37.5
50
SP_COACH_NANCY SparkPoints: (158,833)
Fitness Minutes: (112,042)
Posts: 46,222
3/8/13 8:14 A

Send Private Message
Reply
Hi,

The team SparkGoodies are given out individually just like they are if you were to give them to your friend--but they are from the Team. Because the teams limited in the number of Goodie Points (3000), some teams don't have enough points to give a SparkGoodie to every member.

Coach Nancy



MSBOOTCAMP's Photo MSBOOTCAMP SparkPoints: (66,555)
Fitness Minutes: (57,532)
Posts: 1,568
3/8/13 8:02 A

My SparkPage
Send Private Message
Reply
To send a goodie to my team, must I manually enter every single team member's name?

That seems unbelievable, but, after a very long time, I still don't see any logical, simple way to gift all members at once.

Otherwise, are Team Goodies NOT structured to be sent to all members?

Thanks.

MsBootcamp

MsBootcamp

"The most effective fitness workout is the one you do!"

"In 10 sessions you'll feel the difference, in 20 sessions you'll see the difference, and in 30 sessions you'll have a different body"- Joseph Pilates, on his training method

30 to 90 mins of cardio and strength/resistance, 5 days/wk

Dr-supervised Bio Hormone Therapy + Nutrition + Sleep + Stress Mgmt might start to = Fitness (partly borrowed from Fitness on the Run, Alexandria, VA USA)


 September Minutes: 847
 
0
625
1250
1875
2500
Page: 1 of (1)  

Report Innappropriate Post

Other Site/Technical Help Topics:

Topics: Last Post:
Team Blogs Needed 5/1/2014 8:26:18 AM
Muscle pain 9/23/2014 3:23:13 PM
A suggestion for future updates 5/3/2014 7:06:43 AM
LOGIN ISSUE 7/13/2014 11:53:31 AM
Poll center? 7/10/2014 12:57:02 PM

Thread URL: http://www.sparkpeople.com/myspark/messageboard.asp?imboard=5&imparent=30387290

Review our Community Guidelines





Diet Resources: soy good | soy nutrition | is soy bad