Forum Discussion
ASullivanFFRASu
8 years agoQrew Trainee
OK, I tried to do this, but I am coming up with an error; what am I missing?:
List("\n",
If([E-flyer Requested], List(" ", "E-flyer","Qty: " & Totext([E-flyer QTY]), [E-flyer Notes])),
If([8.5x11 Poster Requested], List(" ", "8.5x11 Poster","Qty: " & Totext([8.5x11 Poster Qty]), [8.5x11 Poster Notes])),
If([1/2 Page Flyers Requested], List(" ", "1/2 Page Flyers","Qty: " & Totext([1/2 Page Flyers Qty]), [1/2 Page Flyers Notes])),
If([11x17 Poster Requested], List(" ", "11x17 Posters","Qty: " & Totext([11x17 Poster Qty]), [11x17 Poster Notes])),
If([22x28 Poster Requested], List(" ", "22x28 Posters","Qty: " & Totext([22x28 Poster Qty]), [22x28 Poster Notes])),
If([24x36 Poster Requested], List(" ", "24x36 Poster","Qty: " & Totext([24x36 Poster Qty]), [24x36 Poster Notes])),
If([30x40 Poster Requested], List(" ", "30x40 Poster","Qty: " & Totext([30x40 Poster Qty]), [30x40 Poster Notes])),
If([3x5 Banner Requested], List(" ", "3x5 Banner","Qty: " & Totext([3x5 Banner Qty]), [3x5 Banner Notes])),
If([3x6 Banner Requested], List(" ", "3x6 Banner","Qty: " & Totext([3x6 Banner Qty]), [3x6 Banner Notes])),
If([3x8 Banner Requested], List(" ", "3x8 Banner","Qty: " & Totext([3x8 Banner Qty]), [3x8 Banner Notes])),
If([Napkin Holder Ads Requested], List(" ", "Napkin Ads","Qty: " & Totext([Napkin Holder Ads Requested Qty]), [Napkin Holder Ads Requested Notes])),
If([4x6 Table Tent Ads Requested], List(" ", "4x6 Table Tent Ads ","Qty: " & Totext([4x6 Table Tent Ads Qty]), [4x6 Table Tent Ads Notes])),
If([Brochure Requested], List(" ", "Brochures","Qty: " & Totext([Brochure Qty]), [Brochure Notes])),
If([2-sided Tabletent Requested], List(" ", "2-sided Tabletents","Qty: " & Totext([2-sided Tabletent Qty]), [2-sided Tabletent Notes])),
If([3-sided Tabletent Requested], List(" ", "3-sided Tabletents","Qty: " & Totext([3-sided Tabletent Qty]), [3-sided Tabletent Notes])),
If([Business or Punch Card Requested], List(" ", "Business or Punch Cards","Qty: " & Totext([Business or Punch Card Qty]), [Business or Punch Card Notes])),
If([Publication Ad Requested], List(" ", "Publication Ad Requested", [Publication Ad Notes])),
If([Web Ad Requested], List(" ", "Web Ad Requested")),
If([Facebook Cover Ad Requested], List(" ", "Facebook Cover Ad Requested")),
If([Facebook Event Cover Ad Requested], List(" ", "Facebook Event Cover Ad Requested")),
If([Instagram Ad Requested], List(" ", "Instagram Ad Requested")),
If([Mobile App Ad Requested], List(" ", "Mobile App Ad Requested")),
If([Email Newsletter Ad Requested], List(" ", "Email Newsletter Ad Requested")),
If([Newspaper Ad Requested], List(" ", "Newspaper Ad Requested")),
If([Bowling Ad Requested], List(" ", "Bowling Ad Requested")),
If([Theater Ad Requested], List(" ", "Theater Ad Requested")),
If([Facility Kiosk Vertical Requested], List(" ", "Facility Kiosk Vertical Requested", [Facility Kiosk Vertical Notes])),
If([Facility Kiosk Horizontal Requested], List(" ", "Facility Kiosk Horizontal Requested", [Facility Kiosk Horizontal Notes])),
If([Custom Request], List(" ", "Custom Request ", [Custom Notes])),
If([Outsourced/Billable Request], List(" ", "Outsourced/Billable Request�, [E-flyer Notes])),
If([Foam Core/Mounting Requested], List(" ", "Foam Core/Mounting Requested", [Foam Core/Mounting Notes])),
If([Lamination Requested], List(" ", "Lamination Requested", [Lamination Notes]))
)
List("\n",
If([E-flyer Requested], List(" ", "E-flyer","Qty: " & Totext([E-flyer QTY]), [E-flyer Notes])),
If([8.5x11 Poster Requested], List(" ", "8.5x11 Poster","Qty: " & Totext([8.5x11 Poster Qty]), [8.5x11 Poster Notes])),
If([1/2 Page Flyers Requested], List(" ", "1/2 Page Flyers","Qty: " & Totext([1/2 Page Flyers Qty]), [1/2 Page Flyers Notes])),
If([11x17 Poster Requested], List(" ", "11x17 Posters","Qty: " & Totext([11x17 Poster Qty]), [11x17 Poster Notes])),
If([22x28 Poster Requested], List(" ", "22x28 Posters","Qty: " & Totext([22x28 Poster Qty]), [22x28 Poster Notes])),
If([24x36 Poster Requested], List(" ", "24x36 Poster","Qty: " & Totext([24x36 Poster Qty]), [24x36 Poster Notes])),
If([30x40 Poster Requested], List(" ", "30x40 Poster","Qty: " & Totext([30x40 Poster Qty]), [30x40 Poster Notes])),
If([3x5 Banner Requested], List(" ", "3x5 Banner","Qty: " & Totext([3x5 Banner Qty]), [3x5 Banner Notes])),
If([3x6 Banner Requested], List(" ", "3x6 Banner","Qty: " & Totext([3x6 Banner Qty]), [3x6 Banner Notes])),
If([3x8 Banner Requested], List(" ", "3x8 Banner","Qty: " & Totext([3x8 Banner Qty]), [3x8 Banner Notes])),
If([Napkin Holder Ads Requested], List(" ", "Napkin Ads","Qty: " & Totext([Napkin Holder Ads Requested Qty]), [Napkin Holder Ads Requested Notes])),
If([4x6 Table Tent Ads Requested], List(" ", "4x6 Table Tent Ads ","Qty: " & Totext([4x6 Table Tent Ads Qty]), [4x6 Table Tent Ads Notes])),
If([Brochure Requested], List(" ", "Brochures","Qty: " & Totext([Brochure Qty]), [Brochure Notes])),
If([2-sided Tabletent Requested], List(" ", "2-sided Tabletents","Qty: " & Totext([2-sided Tabletent Qty]), [2-sided Tabletent Notes])),
If([3-sided Tabletent Requested], List(" ", "3-sided Tabletents","Qty: " & Totext([3-sided Tabletent Qty]), [3-sided Tabletent Notes])),
If([Business or Punch Card Requested], List(" ", "Business or Punch Cards","Qty: " & Totext([Business or Punch Card Qty]), [Business or Punch Card Notes])),
If([Publication Ad Requested], List(" ", "Publication Ad Requested", [Publication Ad Notes])),
If([Web Ad Requested], List(" ", "Web Ad Requested")),
If([Facebook Cover Ad Requested], List(" ", "Facebook Cover Ad Requested")),
If([Facebook Event Cover Ad Requested], List(" ", "Facebook Event Cover Ad Requested")),
If([Instagram Ad Requested], List(" ", "Instagram Ad Requested")),
If([Mobile App Ad Requested], List(" ", "Mobile App Ad Requested")),
If([Email Newsletter Ad Requested], List(" ", "Email Newsletter Ad Requested")),
If([Newspaper Ad Requested], List(" ", "Newspaper Ad Requested")),
If([Bowling Ad Requested], List(" ", "Bowling Ad Requested")),
If([Theater Ad Requested], List(" ", "Theater Ad Requested")),
If([Facility Kiosk Vertical Requested], List(" ", "Facility Kiosk Vertical Requested", [Facility Kiosk Vertical Notes])),
If([Facility Kiosk Horizontal Requested], List(" ", "Facility Kiosk Horizontal Requested", [Facility Kiosk Horizontal Notes])),
If([Custom Request], List(" ", "Custom Request ", [Custom Notes])),
If([Outsourced/Billable Request], List(" ", "Outsourced/Billable Request�, [E-flyer Notes])),
If([Foam Core/Mounting Requested], List(" ", "Foam Core/Mounting Requested", [Foam Core/Mounting Notes])),
If([Lamination Requested], List(" ", "Lamination Requested", [Lamination Notes]))
)