since
10-12-2019
Level 1
Completed Survey
blue_monkey1
- Adobe Campaign Classic
2.7K
1
1
blue_monkey1
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
Like
Replies
Re: Finding Min Date from Multiple Columns
blue_monkey1
- Adobe Campaign Standard
2.1K
0
0
blue_monkey1
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
Likes
Replies
Finding Min Date from Multiple Columns
blue_monkey1
- Adobe Campaign Standard
2.9K
1
2
blue_monkey1
Can anyone help me find the minimum date of multiple columns per
recipient? I have 7 date columns some of which are null.
Views
Like
Replies
Delivery through WebForm
blue_monkey1
- Adobe Campaign Standard
1.4K
2
2
blue_monkey1
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
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
Thank you Florent.Works perfectly. Appreciate your help and
patience.Cheers,Neil
Views
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
Thank you Florent.Works perfectly. Appreciate your help and
patience.Cheers,Neil
Views
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
Hi Florent,I sent the details in a PM.Thanks,Neil
Views
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
Hi Florent,I sent the details in a PM.Thanks,Neil
Views
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
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
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
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
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
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
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
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
Likes
Replies
Re: Contact History
blue_monkey1
- Adobe Campaign Standard
1.6K
0
0
blue_monkey1
Thank you Florent. Appreciate the help.
Views
Likes
Replies
Contact History
blue_monkey1
- Adobe Campaign Standard
10.8K
0
18
blue_monkey1
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
Likes
Replies
