Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

blue_monkey1
Community profile blue_monkey1 Level 2
Job title here
Location here
9 BADGES
Level 2

Level 2

Learn more
Joined the community 12-10-2016 8:28:13 AM
Offline
Top badges earned by blue_monkey1
Customize the badges you want to showcase on your profile
Completed Survey
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Classic
Morning all,I have a survey set up which customers can complete many times, however, I only want customers to complete this once,The date the customer has completed the survey first is stored in a field in the database. I want to use this field so that if it is populated a different page is displayed.How would I go about this?Thanks,Neil

Views

2.9K

Like

1

Replies

1
Re: Finding Min Date from Multiple Columns
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
I had thought of that initially but as 7 columns, I wanted to see if there was an easier solution. Thanks for your answer.

Views

2.2K

Likes

0

Replies

0
Finding Min Date from Multiple Columns
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Can anyone help me find the minimum date of multiple columns per recipient? I have 7 date columns some of which are null.

Views

3.1K

Like

1

Replies

2
Delivery through WebForm
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi folks,Anyone know of a way to send a delivery to a visitor based on details they have entered onto a webform?I have a webform that collects Visitors Name and Email address but want to send a delivery to these potential customers.Thanks

Views

1.5K

Likes

2

Replies

2
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Views

1.9K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Views

1.9K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi Florent,I sent the details in a PM.Thanks,Neil

Views

1.9K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi Florent,I sent the details in a PM.Thanks,Neil

Views

1.8K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Thanks, I am now getting a different error:17/10/2016 14:17:31 504734_3_1_G W3 JOIN wkf369504734_3_1 W2 ON (W2.iRowId = W3.iRowId) WHERE (((T1.tsLog > Coalesce(W2.tsBroadLogRcp3Event , W2.tsBroadLogRcp2Event , W2.tsBroadLogRcp1Event)) AND (T1.iUrlId <> 1)) AND (W2.iRowId = W.iRowId)) AND ((T1.iTrackingLogId > 0 OR T17/10/2016 14:17:31 1.iTrackingLogId < 0)) GROUP BY T1.iRecipientId, W2.iRowId' could not be executed (error in position 96: 'T1.iTrackingLogId,').17/10/2016 14:17:31 Oracle error: 'O...

Views

1.9K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Thanks, I am now getting a different error:17/10/2016 14:17:31 504734_3_1_G W3 JOIN wkf369504734_3_1 W2 ON (W2.iRowId = W3.iRowId) WHERE (((T1.tsLog > Coalesce(W2.tsBroadLogRcp3Event , W2.tsBroadLogRcp2Event , W2.tsBroadLogRcp1Event)) AND (T1.iUrlId <> 1)) AND (W2.iRowId = W.iRowId)) AND ((T1.iTrackingLogId > 0 OR T17/10/2016 14:17:31 1.iTrackingLogId < 0)) GROUP BY T1.iRecipientId, W2.iRowId' could not be executed (error in position 96: 'T1.iTrackingLogId,').17/10/2016 14:17:31 Oracle error: 'O...

Views

1.8K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi Florent,This is great. I am encountering an error along the way though and its probably something straight forward I am not doing. I cannot see a field for @eventDate in the broadlogRcp1 etc...Thanks,Neil

Views

1.8K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi Florent,This is great. I am encountering an error along the way though and its probably something straight forward I am not doing. I cannot see a field for @eventDate in the broadlogRcp1 etc...Thanks,Neil

Views

1.8K

Likes

0

Replies

0
Re: Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Thank you Florent. Appreciate the help.

Views

1.9K

Likes

0

Replies

0
Contact History
Avatar
Ignite 3
Level 2
blue_monkey1
Level 2

Likes

4 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Ignite 3
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
blue_monkey1
- Adobe Campaign Standard
Hi folks, need some help with a query/report in Campaign.I am trying to find out "of the last n emails received by a recipient a count of how many they have opened and clicked."Thanks,blue

Views

11.2K

Likes

0

Replies

18