• DevLaura
• NEWBIE
• 20 Points
• Member since 2008

• Chatter
Feed
• 0
• 0
• 0
Likes Given
• 7
Questions
• 9
Replies
I'm trying to create a formula field that will look at a person's birthdate and check an "Under 18" checkbox. Then, I need to create another formula or workflow that will uncheck it once they turn 18 and check an "18 and over" checkbox OR will just check the "18 and over" checkbox for those people that are over 18. I'm not the greatest with anything math-related and could use some help. Thank you in advance!
I need to create a workflow on the Email field that will check Email Opt Out if the Email field was previously NOT blank, but has been changed to be blank.

I've tried the following and it doesn't work. Is anyone able to help with this? Thank you in advance:

AND(
ISNULL(Email),
NOT(ISNULL(PRIORVALUE(Email))))

I'm trying to write a formula that basically says that if the values of two different fields are equal to something, then certain values exist for one field. I'm creating a new formula field for those values and here's my (sad) attempt at a formula. How can I write this?

OR(CASE(Number_of_Trees__c ,
1, "A tree",
2, "Two trees",
3, "Three trees",
4, "Four trees",
5, "A grove of five trees",
6, "A grove of six trees",
7, "A grove of eight trees",
9, "A grove of nine trees",
10, "A grove of ten trees",
11, "A grove of eleven trees",
12, "A grove of twelve trees",
13, "A grove of thirteen trees",
14, "A grove of fourteen trees",
15, "A grove of fifteen trees",
16, "A grove of sixteen trees",
17, "A grove of seventeen trees",
18, "A grove of eighteen trees",
19, "A grove of nineteen trees",
20, "A grove of twenty trees",
21, "A grove of 21 trees",
22, "A grove of 22 trees",
23, "A grove of 23 trees",
24, "A grove of 24 trees",
25, "A grove of 25 trees",
26, "A grove of 26 trees",
27, "A grove of 27 trees",
28, "A grove of 28 trees",
29, "A grove of 29 trees",
30, "A grove of thirty trees","",
(CASE(Other_Number_of_Trees__c
1, "A tree",
2, "Two trees",
3, "Three trees",
4, "Four trees",
5, "A grove of five trees",
6, "A grove of six trees",
7, "A grove of eight trees",
9, "A grove of nine trees",
10, "A grove of ten trees",
11, "A grove of eleven trees",
12, "A grove of twelve trees",
13, "A grove of thirteen trees",
14, "A grove of fourteen trees",
15, "A grove of fifteen trees",
16, "A grove of sixteen trees",
17, "A grove of seventeen trees",
18, "A grove of eighteen trees",
19, "A grove of nineteen trees",
20, "A grove of twenty trees",
21, "A grove of 21 trees",
22, "A grove of 22 trees",
23, "A grove of 23 trees",
24, "A grove of 24 trees",
25, "A grove of 25 trees",
26, "A grove of 26 trees",
27, "A grove of 27 trees",
28, "A grove of 28 trees",
29, "A grove of 29 trees",
30, "A grove of thirty trees",
31, "A grove of 31 trees",
32, "A grove of 32 trees",
33, "A grove of 33 trees",
34, "A grove of 34 trees",
35, "A grove of 35 trees",
36, "A grove of 36 trees",
37, "A grove of 37 trees",
38, "A grove of 38 trees",
39, "A grove of 39 trees",
40, "A grove of forty trees",
41, "A grove of 41 trees",
42, "A grove of 42 trees",
43, "A grove of 43 trees",
44, "A grove of 44 trees",
45, "A grove of 45 trees",
46, "A grove of 46 trees",
47, "A grove of 47 trees",
48, "A grove of 48 trees",
49, "A grove of 49 trees",
50, "A grove of fifty trees",
51, "A grove of 51 trees",
52, "A grove of 52 trees",
53, "A grove of 53 trees",
54, "A grove of 54 trees",
55, "A grove of 55 trees",
56, "A grove of 56 trees",
57, "A grove of 57 trees",
58, "A grove of 58 trees",
59, "A grove of 59 trees",
60, "A grove of sixty trees",
61, "A grove of 61 trees",
62, "A grove of 62 trees",
63, "A grove of 63 trees",
64, "A grove of 64 trees",
65, "A grove of 65 trees",
66, "A grove of 66 trees",
67, "A grove of 67 trees",
68, "A grove of 68 trees",
69, "A grove of 69 trees",
70, "A grove of seventy trees",
71, "A grove of 71 trees",
72, "A grove of 72 trees",
73, "A grove of 73 trees",
74, "A grove of 74 trees",
75, "A grove of 75 trees",
76, "A grove of 76 trees",
77, "A grove of 77 trees",
78, "A grove of 78 trees",
79, "A grove of 79 trees",
80, "A grove of eighty trees",
81, "A grove of 81 trees",
82, "A grove of 82 trees",
83, "A grove of 83 trees",
84, "A grove of 84 trees",
85, "A grove of 85 trees",
86, "A grove of 86 trees",
87, "A grove of 87 trees",
88, "A grove of 88 trees",
89, "A grove of 89 trees",
90, "A grove of ninety trees",
91, "A grove of 91 trees",
92, "A grove of 92 trees",
93, "A grove of 93 trees",
94, "A grove of 94 trees",
95, "A grove of 95 trees",
96, "A grove of 96 trees",
97, "A grove of 97 trees",
98, "A grove of 98 trees",
99, "A grove of 99 trees",
100, "A grove of 100 trees",
"")

This is what I'm trying to do. I need to transform the following picklist options:

1 tree, \$25.00
2 trees, \$45.00
3 trees, \$65.00
4 trees, \$85.00
Grove of 5 trees, \$100
Grove of 6 trees, \$110
etc.

to the corresponding text:
A tree
Two trees
Three trees
Four trees
A grove of five trees
A grove of six trees
etc.

I have a few options, I think. I can create a workflow that uses IF, PICKLIST or maybe CASE and populates "A tree" etc. into a text field or I can create a formula field. I also tried making the "1 tree, \$25.00" and etc. picklist a master picklist and the "A tree" and etc. picklist the sub-picklist, but the sub-picklist remains blank and I don't know if there is a formula that would make it autofill. I am an Advanced Admin; not a Developer and I have always struggled with formulas and cannot figure out the right way to do this.  I've tried several different formulas and I get error messages with them.

Any suggestions or formula samples that you can share with me? Thanks in advance.

I have previous obligations for that weeken. Otherwise, I would stay for the whole thing.
I am looking for a visualforce page solution that would allow me to do a few things on one visualforce page:

1) show campaign members currently signed up for any campaign I specify
2) allow me, on that same page, to add campaign members quickly by simply entering their info into fields
3) allow me to create contacts when they do not exist and then do #2
4) through another app or other solution (I'm looking at EZsign), add an electronic signature field

I would want this page to be easily viewable on an iPad. I have already looked at EchoSign and DocuSign and having info that flows directly into the Campaign Member object appears to be problematic. I also need to come up with a cost effective solution.  Also, I have searched in the Code Cookbook and came up empty handed.

One use case (the main use case) is for events in which campaign members plant trees. They need to be able to sign in OR be very quickly added as a contact (if not in Salesforce) and campaign member and then sign in. We need the signature field because they need to give us the OK to take their picture and understand that they must report any injuries received to a staff member immediately. The form needs to be very easy to quickly complete because people will be showing up to volunteer within limited time and we cannot spend too much time just signing them in.

How can I create this? Does anyone have similar code examples? I hope someone can help and look forward to your responses.

We are having an outside company enter our opportunities.  We are a non-profit organization and use opportunities to record donations.  Unfortunately, our outside company is experiencing a slow load time when a button that references an apex class is pushed.  The button is for a new opportunity. I have tested the partner portal several times and do not experience a slow load time.  For some reason, someone in our development department has tested it and still is experiencing a slightly slower load time.

The outside data entry company says that the lag time is significant on their end.

We already contacted Salesforce about this and they think its the Apex Class.  However, the load time has not always been slow for those entering into the partner portal - so it seems strange to me that this could be the cause.

Has anyone experienced something similar to this?  If so, what was the cause or can you offer me any advice on how to trouble-shoot this?

Laura

TreePeople

I'm trying to create a formula field that will look at a person's birthdate and check an "Under 18" checkbox. Then, I need to create another formula or workflow that will uncheck it once they turn 18 and check an "18 and over" checkbox OR will just check the "18 and over" checkbox for those people that are over 18. I'm not the greatest with anything math-related and could use some help. Thank you in advance!
I'm trying to write a formula that basically says that if the values of two different fields are equal to something, then certain values exist for one field. I'm creating a new formula field for those values and here's my (sad) attempt at a formula. How can I write this?

OR(CASE(Number_of_Trees__c ,
1, "A tree",
2, "Two trees",
3, "Three trees",
4, "Four trees",
5, "A grove of five trees",
6, "A grove of six trees",
7, "A grove of eight trees",
9, "A grove of nine trees",
10, "A grove of ten trees",
11, "A grove of eleven trees",
12, "A grove of twelve trees",
13, "A grove of thirteen trees",
14, "A grove of fourteen trees",
15, "A grove of fifteen trees",
16, "A grove of sixteen trees",
17, "A grove of seventeen trees",
18, "A grove of eighteen trees",
19, "A grove of nineteen trees",
20, "A grove of twenty trees",
21, "A grove of 21 trees",
22, "A grove of 22 trees",
23, "A grove of 23 trees",
24, "A grove of 24 trees",
25, "A grove of 25 trees",
26, "A grove of 26 trees",
27, "A grove of 27 trees",
28, "A grove of 28 trees",
29, "A grove of 29 trees",
30, "A grove of thirty trees","",
(CASE(Other_Number_of_Trees__c
1, "A tree",
2, "Two trees",
3, "Three trees",
4, "Four trees",
5, "A grove of five trees",
6, "A grove of six trees",
7, "A grove of eight trees",
9, "A grove of nine trees",
10, "A grove of ten trees",
11, "A grove of eleven trees",
12, "A grove of twelve trees",
13, "A grove of thirteen trees",
14, "A grove of fourteen trees",
15, "A grove of fifteen trees",
16, "A grove of sixteen trees",
17, "A grove of seventeen trees",
18, "A grove of eighteen trees",
19, "A grove of nineteen trees",
20, "A grove of twenty trees",
21, "A grove of 21 trees",
22, "A grove of 22 trees",
23, "A grove of 23 trees",
24, "A grove of 24 trees",
25, "A grove of 25 trees",
26, "A grove of 26 trees",
27, "A grove of 27 trees",
28, "A grove of 28 trees",
29, "A grove of 29 trees",
30, "A grove of thirty trees",
31, "A grove of 31 trees",
32, "A grove of 32 trees",
33, "A grove of 33 trees",
34, "A grove of 34 trees",
35, "A grove of 35 trees",
36, "A grove of 36 trees",
37, "A grove of 37 trees",
38, "A grove of 38 trees",
39, "A grove of 39 trees",
40, "A grove of forty trees",
41, "A grove of 41 trees",
42, "A grove of 42 trees",
43, "A grove of 43 trees",
44, "A grove of 44 trees",
45, "A grove of 45 trees",
46, "A grove of 46 trees",
47, "A grove of 47 trees",
48, "A grove of 48 trees",
49, "A grove of 49 trees",
50, "A grove of fifty trees",
51, "A grove of 51 trees",
52, "A grove of 52 trees",
53, "A grove of 53 trees",
54, "A grove of 54 trees",
55, "A grove of 55 trees",
56, "A grove of 56 trees",
57, "A grove of 57 trees",
58, "A grove of 58 trees",
59, "A grove of 59 trees",
60, "A grove of sixty trees",
61, "A grove of 61 trees",
62, "A grove of 62 trees",
63, "A grove of 63 trees",
64, "A grove of 64 trees",
65, "A grove of 65 trees",
66, "A grove of 66 trees",
67, "A grove of 67 trees",
68, "A grove of 68 trees",
69, "A grove of 69 trees",
70, "A grove of seventy trees",
71, "A grove of 71 trees",
72, "A grove of 72 trees",
73, "A grove of 73 trees",
74, "A grove of 74 trees",
75, "A grove of 75 trees",
76, "A grove of 76 trees",
77, "A grove of 77 trees",
78, "A grove of 78 trees",
79, "A grove of 79 trees",
80, "A grove of eighty trees",
81, "A grove of 81 trees",
82, "A grove of 82 trees",
83, "A grove of 83 trees",
84, "A grove of 84 trees",
85, "A grove of 85 trees",
86, "A grove of 86 trees",
87, "A grove of 87 trees",
88, "A grove of 88 trees",
89, "A grove of 89 trees",
90, "A grove of ninety trees",
91, "A grove of 91 trees",
92, "A grove of 92 trees",
93, "A grove of 93 trees",
94, "A grove of 94 trees",
95, "A grove of 95 trees",
96, "A grove of 96 trees",
97, "A grove of 97 trees",
98, "A grove of 98 trees",
99, "A grove of 99 trees",
100, "A grove of 100 trees",
"")

I am looking for a visualforce page solution that would allow me to do a few things on one visualforce page:

1) show campaign members currently signed up for any campaign I specify
2) allow me, on that same page, to add campaign members quickly by simply entering their info into fields
3) allow me to create contacts when they do not exist and then do #2
4) through another app or other solution (I'm looking at EZsign), add an electronic signature field

I would want this page to be easily viewable on an iPad. I have already looked at EchoSign and DocuSign and having info that flows directly into the Campaign Member object appears to be problematic. I also need to come up with a cost effective solution.  Also, I have searched in the Code Cookbook and came up empty handed.

One use case (the main use case) is for events in which campaign members plant trees. They need to be able to sign in OR be very quickly added as a contact (if not in Salesforce) and campaign member and then sign in. We need the signature field because they need to give us the OK to take their picture and understand that they must report any injuries received to a staff member immediately. The form needs to be very easy to quickly complete because people will be showing up to volunteer within limited time and we cannot spend too much time just signing them in.

How can I create this? Does anyone have similar code examples? I hope someone can help and look forward to your responses.

We are having an outside company enter our opportunities.  We are a non-profit organization and use opportunities to record donations.  Unfortunately, our outside company is experiencing a slow load time when a button that references an apex class is pushed.  The button is for a new opportunity. I have tested the partner portal several times and do not experience a slow load time.  For some reason, someone in our development department has tested it and still is experiencing a slightly slower load time.

The outside data entry company says that the lag time is significant on their end.

We already contacted Salesforce about this and they think its the Apex Class.  However, the load time has not always been slow for those entering into the partner portal - so it seems strange to me that this could be the cause.

Has anyone experienced something similar to this?  If so, what was the cause or can you offer me any advice on how to trouble-shoot this?

Laura

TreePeople