Hi all,
It’s that time of year! I am creating a master spreadsheet for 22 renewals and am stuck specifically with pulling Package Codes and Price Types. We have some custom elements that make it easy to pull seating info and day/time. The main issue is multiple rows because of pulling based on sub-package instead of super package in addition to some patrons having more than one package a year. I’ve tried multiple combinations of output set elements and filters. I can pull all the info I need in analytics, but it’s not in a helpful format. I attached a screenshot of the format we are looking for.
I have some sql knowledge and have created a few custom output set elements from the recipe book.
Any thoughts?
Michelle Blau (Past Member) said:The main issue is multiple rows
I've written something like this several times over the years. Please see image below. This particular code also adds HTML, but you could skip that or edit as desired. Please let me know if this code interests you.
Definitely interested! If you're open to sharing, my email is mblau@studiotheatre.org.
Please see my code here:
https://gcloud.guthrietheater.org/s/6jfNW7ZRAY8fSmZ
A little demo view, as I recall, but this will hopefully give you an idea or two. I hope that the code is helpful.
thank you!