concat lookuprecords within a lookuprecords on a different data sheet — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

concat lookuprecords within a lookuprecords on a different data sheet

I have been doing this manually changing the lookuprecords field within a data sheet. I'm wondering if it is possible to do a lookup within a lookup?

e.g. I currently use:

<a href="$clickthrough(concat(lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), SEND_DATE),ARTICLE7), Position=1, concat(Term=,lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7CATEGORY)), concat(Content=BodyImg,lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7DESCRIPTION)))$" style="color:#248eb6; text-decoration:underline;" target="_blank" title="$lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), ARTICLE7DESCRIPTION)$">

I would like to make the number in the lookup field dynamic so instead it would say <a href="$clickthrough(concat(lookuprecords(1_Bulletin, Bulletin_Content, EMAIL_DATE, lookup(DateReference), SEND_DATE),ARTICLEX..

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!