• DataRecoveryNederland
• NEWBIE
• 25 Points
• Member since 2013

• Chatter
Feed
• 0
• 1
• 0
Likes Given
• 3
Questions
• 10
Replies

hey,

im trying to implement a SEO solution but not having any luck.

all SEO software i see are for leads.

whats the best way to implement this for cases.

kind regards.

Is it possible to get case source details just like leads.

We are only working with cases.

Our costumers are comming into our system trough web to case.

Hey,

i got a formula that creates an enddate from a startdate without weekens

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, Data_recovery_akkoord__c +4,
1, Data_recovery_akkoord__c +4,
2, Data_recovery_akkoord__c +6,
3, Data_recovery_akkoord__c +6,
4, Data_recovery_akkoord__c +6,
5, Data_recovery_akkoord__c +6,
6, Data_recovery_akkoord__c +5,null)

this worked great for 4 workdays.

now i want to make the 4 workdays a variable so it can be 4,5 or 6 or even 20 (dropdown menu)

and im lost cause i dont know how to calculate the exact amount of weekend days without exceeding the 5000 limit.

i made the 2 following formulas;

111 duur expres eind:

CASE(Recovery_duur_Expres__c,

"4", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 4,
1, 4,
2, 6,
3, 6,
4, 6,
5, 6,
6, 5,null),
"5", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 5,
1, 7,
2, 7,
3, 7,
4, 7,
5, 7,
6, 6,null),
null)

111dagen test:

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
1, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
2, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
3, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
4, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
5, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
6, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),null)

this gets me way over the 5000 limit.

can anyone help me.

Hey,

i got a formula that creates an enddate from a startdate without weekens

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, Data_recovery_akkoord__c +4,
1, Data_recovery_akkoord__c +4,
2, Data_recovery_akkoord__c +6,
3, Data_recovery_akkoord__c +6,
4, Data_recovery_akkoord__c +6,
5, Data_recovery_akkoord__c +6,
6, Data_recovery_akkoord__c +5,null)

this worked great for 4 workdays.

now i want to make the 4 workdays a variable so it can be 4,5 or 6 or even 20 (dropdown menu)

and im lost cause i dont know how to calculate the exact amount of weekend days without exceeding the 5000 limit.

i made the 2 following formulas;

111 duur expres eind:

CASE(Recovery_duur_Expres__c,

"4", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 4,
1, 4,
2, 6,
3, 6,
4, 6,
5, 6,
6, 5,null),
"5", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 5,
1, 7,
2, 7,
3, 7,
4, 7,
5, 7,
6, 6,null),
null)

111dagen test:

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
1, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
2, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
3, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
4, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
5, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
6, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),null)

this gets me way over the 5000 limit.

can anyone help me.

hey,

im trying to implement a SEO solution but not having any luck.

all SEO software i see are for leads.

whats the best way to implement this for cases.

kind regards.

I'm not sure if the button I have in mind is even doable in Professional edition (or at all), but here goes:

I want a button on the Lead object that:

1. looks at the Lead Source field

2. Sends an email from an existing template (which template is based on the value of the Lead Source field)

3. Changes the value of the Lead Status field (same change regardless of Lead Source)

If a single button can't do all this at once, can it at least be set up to just send the email?

Hi Y'all..

Need F1(help.. :))..

F1 = Date Field without weekends.

F2 = Custom Formula Field (number)

F3 = Date Field

I need to calculate:

F1 = F2+F3, but I should not get dates with Weekends.

This is my Previous code with standard number of days, this time its variable number based on a field.

CASE(MOD((RFP_Review_Start_Date__c ) - DATE(1900, 1, 7) , 7),
0, F3+1,
1, F3+1,
2, F3+1,
3, F3+1,
4, F3+1,
5, F3+3,
6, F3+2,
null)

Need assistance in this please. Please let me know if any further things needed..

• March 01, 2013
• Like
• 0

Is it possible to get case source details just like leads.

We are only working with cases.

Our costumers are comming into our system trough web to case.

Hey,

i got a formula that creates an enddate from a startdate without weekens

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, Data_recovery_akkoord__c +4,
1, Data_recovery_akkoord__c +4,
2, Data_recovery_akkoord__c +6,
3, Data_recovery_akkoord__c +6,
4, Data_recovery_akkoord__c +6,
5, Data_recovery_akkoord__c +6,
6, Data_recovery_akkoord__c +5,null)

this worked great for 4 workdays.

now i want to make the 4 workdays a variable so it can be 4,5 or 6 or even 20 (dropdown menu)

and im lost cause i dont know how to calculate the exact amount of weekend days without exceeding the 5000 limit.

i made the 2 following formulas;

111 duur expres eind:

CASE(Recovery_duur_Expres__c,

"4", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 4,
1, 4,
2, 6,
3, 6,
4, 6,
5, 6,
6, 5,null),
"5", CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, 5,
1, 7,
2, 7,
3, 7,
4, 7,
5, 7,
6, 6,null),
null)

111dagen test:

CASE(MOD(DATEVALUE(Data_recovery_akkoord__c ) - DATE(1900, 1, 7) , 7),
0, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
1, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
2, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
3, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
4, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
5, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),
6, (Data_recovery_akkoord__c +X111_duur_expres_eind__c),null)

this gets me way over the 5000 limit.

can anyone help me.