Building a URL which Dynamically passes attributes based on grouping criteria

Good Afternoon Team

Hope all is well.

I am hoping you can help me,

Aim : Dynamically passing attributes to build a URL in column D.

Example of URL :

HTML Code: 

This part of the URL will always remain static ;

HTML Code: 

Setting the master record

HTML Code: 

The last segment is a collection of IDs. All use the parameter name of "&cid="

HTML Code: 

There are three columns which need to be referenced.

Column A : ID(18 digits long)
Column B: Grouping Mechanism
Column C: Indicator of what record is Master

Example 1

3 Columns :
Example1.JPG

Column A : ID
Column B : Group ID
Column C :Outcome
Column D: Full URL

Scenario Logic

Group ID = 21
Outcome = Master
Master id = A1


URl Outcome:

HTML Code: 

Example 2

Example2.JPG
Column A : ID
Column B : Group ID
Column C :Outcome
Column D: Full URL

Group ID = 25
Outcome = Master
Master id = A7

URl Outcome:

HTML Code: 

Please note that my data set is approx 2500 Rows

I have attached example mock up example

Good afternoon!

Your thread has had 563 views since you first posted. That's quite a lot. There must be a reason why nobody has offered help, but just bumping a thread without asking if you need to offer more information is unlikely to change that. I will have a look at your attachment and see if I can see why you aren't getting any help.

OK - I've had a look.

I understand the basic premise of your request for help. However, I do not understand at all the designations and resulting sections of the URLs you are building. I think you need to explain these clearly in WORDS, as the examples alone are not speaking for themselves.

Hi AliG,
More than happy to provide additional details .
I thought a member would of said could u explain xyz. But apologises I shlukd it took the Initiative and asked.

I have said above what I think is missing - perhaps start with that. We need to understand your logic.

Okay i will try my best:
High level I want to build a url that pre populated I’d based on the logic defined in three columns . The first part of the url remains static

But what I would want help on is the following ;
for a particular group I’d where the outcome column says “master” populate the id in column a of that particular group id

This part of the url remains static

&p2=

However after the = the id of master record needs to be populated

&p2=001j000000hdOIW p

Please attach the workbook you had prepared that has more information about the logic in it (you mentioned this in a duplicate thread).