since ‎12-10-2016
‎10-12-2019
blue_monkey1
Level 1
Completed Survey
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Like

1

Replies

1
Re: Finding Min Date from Multiple Columns
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Finding Min Date from Multiple Columns
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Like

1

Replies

2
Delivery through WebForm
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

2

Replies

2
Re: Contact History
Avatar

blue_monkey1

blue_monkey1
- Adobe Campaign Standard
Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

blue_monkey1
- Adobe Campaign Standard
Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

blue_monkey1
- Adobe Campaign Standard
Hi Florent,I sent the details in a PM.Thanks,Neil

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

blue_monkey1
- Adobe Campaign Standard
Hi Florent,I sent the details in a PM.Thanks,Neil

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Contact History
Avatar

blue_monkey1

blue_monkey1
- Adobe Campaign Standard
Thank you Florent. Appreciate the help.

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Contact History
Avatar

blue_monkey1

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

(val/1000)?string[".0"]}K

Likes

0

Replies

18