TauryAnderson1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Removing duplicates from a textlist
var number field = 311; var text deebid = [_DBID_ITEM_DETAIL]; var text PETfilters = "{'314'.EX.'" & [Related Project (formula)] & "'}" & "AND{'400'.EX.'" & [Substrate Size] & "'}" & "AND{'368'.EX.'" & [PET Bottle Color] & "'}" & "AND{'367'.EX.'" & [Label/Substrate Type] & "'}" & "AND{'271'.EX.'" & [Label/Substrate Supplier] & "'}" & "AND{'370'.EX.'" & [Closure Finish] & "'}" & "AND{'371'.EX.'" & [Closure Color] & "'}"; var text CANfilters = "{'314'.EX.'" & [Related Project (formula)]&"'}" & "AND{'400'.EX.'" & [Substrate Size] & "'}" & "AND{'374'.EX.'" & [End/Lid Color] & "'}" & "AND{'163'.EX.'" & [Tab Color dropdown] & "'}" & "AND{'252'.EX.'" & [TabType] & "'}"; var text GLASSfilters = "{'314'.EX.'" & [Related Project (formula)] & "'}" & "AND{'400'.EX.'" & [Substrate Size] & "'}" & "AND{'369'.EX.'" & [Glass Bottle Color] & "'}" & "AND{'367'.EX.'" & [Label/Substrate Type] & "'}" & "AND{'271'.EX.'" & [Label/Substrate Supplier] & "'}" & "AND{'370'.EX.'" & [Closure Finish] & "'}" & "AND{'371'.EX.'" & [Closure Color] & "'}"; var text ALUMITEKfilters= "{'314'.EX.'" & [Related Project (formula)]&"'}" & "AND{'400'.EX.'" & [Substrate Size] & "'}" & "AND{'370'.EX.'" & [Closure Finish] & "'}" & "AND{'158' .EX. '" & [Related End/Closure] & "'}" & "AND{'371'.EX.'" & [Closure Color] & "'}" & "AND{'91' .EX. '" & "CAN" & "'}" & "AND{'157' .EX. '"& "BOTTLE CAN" & "'}"; var text filters = If([Primary Substrate]="PET", $PETfilters,[Primary Substrate]="GLASS", $GLASSfilters,[Primary Substrate]="CAN" and [Container Design dropdown]="BOTTLE CAN", $ALUMITEKfilters, [Primary Substrate]="CAN",$CANfilters); var text query = ToText(GetFieldValues(GetRecords($filters, $deebid), $field)); $query ------------------------------ Taury Anderson ------------------------------13Views0likes1CommentRe: Removing duplicates from a textlist
I like your solution for removing duplicates, but now I have on that is more complicated. My formula query pulls text values from it's sibling records where we might have a list like this: red blue green green blue red red I want my formula query result to be: red; blue; green not red; blue; green; green; blue; red; red I am basically trying to use a Formula Query to get Summary field results from sibling records. (There is a wide ranch of variability of choices in the field in question, so I cannot call out each option individually in a formula) ------------------------------ Taury Anderson ------------------------------45Views0likes3Comments