AnsweredAssumed Answered

using repetitions vs using lists

Question asked by JamesPeragine on May 3, 2017
Latest reply on May 3, 2017 by BruceRobertson

I'm doing a new build out of our CRM and there are many instances in which I have to make lists from the values in the portals on my layout.   So far I have been using a text field to create lists.   I've never fully delved into using Repetitions and Variable repetitions and I'm wondering if this is a more efficient method for what I need to accomplish.   Will this put more or less strain on the system

 

One example of this is the following:

 

I have a portal that pulls email addresses from a portal list for emailing. Here's the code that I have implemented.  This script is tied to a script trigger when a portal row is clicked.

 

  • Set Variable [ $count; Value:ValueCount ( List ( Deals_777::_rSubmissionList ) ) ]
  • Set Variable [ $funderEmails; Value:Funders_Deals77Submissions::SubmissionEmailAddress ]
  • If [ PatternCount (Deals_777::_rSubmissionList ; $funderEmails) = 1 ]
  • If [ GetValue ( List ( Deals_777::_rSubmissionList ) ; 1 ) = $funderEmails ]
  • If [ $count = 1 ]
  • Set Field [ Deals_777::_rSubmissionList; Substitute(Deals_777::_rSubmissionList;$funderEmails;"") ]
  • Else
  • Set Field [ Deals_777::_rSubmissionList; Substitute(Deals_777::_rSubmissionList;$funderEmails & ¶;"") ]
  • End If
  • Else
  • Set Field [ Deals_777::_rSubmissionList; Substitute(Deals_777::_rSubmissionList ;¶ & $funderEmails;"") ]
  • End If
  • Else
  • If [ $count = 0 ]
  • Set Field [ Deals_777::_rSubmissionList; $funderEmails ]
  • Else
  • Set Field [ Deals_777::_rSubmissionList; $funderEmails & ¶ & Deals_777::_rSubmissionList ]
  • End If
  • End If

 

 

Am I better setting up a field or variable with 30-40 maximum field repetitions instead?

Outcomes