AnsweredAssumed Answered

Getting values from fields to use in script

Question asked by strngr12 on Jan 23, 2012
Latest reply on Jan 23, 2012 by comment

Hello,

 

This is a little compliacted to explain so I hope it's clear. I have a script that allows you to set a value for "playlist 1" and "playlist 2." Every record in the database can have either, both or none of them. What I need is a calculation that will search the entire database for all the values and output each value only once.

 

So, for example, if there are five records such that

 

record 1 = playlist 1

record 2 = playlist 1, playlist 2

record 3 = newplaylist 1, playlist 2

record 4 =

record 5 = playlist 1

 

I need the output of the calculation to be: playlist 1, playlist 2, newplaylist 1.

 

Any help, please?

 

Thanks,

 

Dan

Outcomes