• Skip to primary navigation
  • Skip to main content

Social Good Software

Creating amazing guest experiences through innovative software solutions for the social good community

  • Features
    • Deduper
    • Calendar Builder
    • Email Designer
    • Barcodes Scanner
    • Online Template
    • Checkout Flows
    • Membership Portal
    • Data Bridge
  • Pricing
  • Contact
    • About
    • Contact
    • Feedback
    • Careers
  • Login
  • Get Price

How to add additional programs to the calendar

December 14, 2021 By Rick Hernandez

Calendar Builder of Social Good Software is a tool designed to create calendars from Altru data. It is useful in creating calendars for time ticketing, school programs, and special events. Learn how to add additional programs to your calendar and make necessary adjustments using the Altru query and enjoy the benefit it can bring to you and to your organization. 

Adding Additional Programs to the Calendar

1: Go to your Social Good Software account.

2: Proceed to Calendar Builder and click on the existing calendar where you want to add events.

Adding a program to the query of Timed Ticketing Calendar

1:  Go to Settings and click the query for Timed Ticketing under Events to start and make necessary adjustments.

2: It will redirect you to Altru’s Ad-hoc Query wherein you need to click Edit Definition.

3: You can now enter the program that you want to add to your query:

  • Go to Program Events then under Fields click Name and drag to Includes records where section.
add additional programs to the calendar
  • A dialog box will pop out where you can put the name and criteria of the event you want to add. Click OK. See the sample below.
  • You can now make adjustments to your Event query. For illustration, we made the following adjustments:
    • The newly added event is moved up just after the old one.
    • OR was used instead of AND
    • Added open and close parenthesis () from the beginning of the old event to the newly added event.
add additional programs to the calendar
Note: this is just a sample added event and an illustration of how to properly adjust the said program in a query.
  • Click Preview Results to check if the query with the newly added event is working. Click Save and Close if it is to your preference.

Adding a program to the query of Reserved Events

1: Go back to Calendar Builder. Click on the other query under Reserved Events. This query will show you if the event tickets were sold out or not.

2: Same with the first query, just click the link which will prompt you to Altru’s Ad-hoc Query where you need to click the Edit Definition.

  • Go to Sales Order Item and select Sales Order Item Ticket then Program Events. On the Fields section select Name and add to ‘Include records where’ which will redirect you to a dialog box. Set up the criteria to Contain and put the name of the event you wanted to add. Click OK.
add additional programs to the calendar
  • Back to “Sales Order Item Ticket”. Select “Tickets” and on the “Fields” section drag Status to “Include records where” in which a dialog box will appear. Just set it up as “Equal to Value” and “Active”. You also need to add the Status under the “Results field to display” and add COUNT
add additional programs to the calendar
add additional programs to the calendar
  • We will make the following adjustments to the query on this example:

Under Include records where:

  • From AND to OR
  • Put open parentheses before the Sales Order Item of the existing event and close parentheses at the end of the added event.
  • Remove Refund status is equal to 0

Under Results fields to display

  • Remove the Quantity
  • Click on Save and Close once all is done and good.

Syncing of Data

1: Back to Calendar Builder. Go to Sync Activity and click on Request Data then another Request Data on the dialog box. This will sync over all the information based on the recently made query into our calendar.

add additional programs to the calendar
add additional programs to the calendar

2: Once it’s done syncing, proceed to Settings then click on the gear icon and select COUNT(Sales Order Item Ticket\Tickets\Status) before you click Save.

add additional programs to the calendar
add additional programs to the calendar

3: Click Preview to check your output. From here, your calendar will automatically update on your website if you have it embedded. We ask for your patience when doing this because it takes a minute or two before it reflects on your site.

If you have more questions please reach out to us through our support channel.

Filed Under: Calendar Builder, Help Center, Implementation Guide, Query Examples

Helping Arts & Culture Organizations Integrate With Altru by Blackbaud

Learn how you can have a seamless integration with Altru by booking your free demo.

801-822-0183
Book a demo
Social Good Software

  • Privacy Policy | Terms of Service

© 2015 Created by Salty Slopes LLC
All Rights Reserved

Features

  • Deduper
  • Calendar Builder
  • Email Designer
  • Barcodes Reader
  • Online Template
  • Checkout Flows
  • Membership Portal
  • Data Bridge
  • API Integrations

Professional Services

  • Landing Pages
  • Account Manager
  • App Development
  • Digital Marketing
  • Custom Themes
  • Consulting

Contact us

9690 South 300 West #303
Sandy, UTAH 84070

hello@socialgoodsoftware.com

801-822-0183 | Contact Form

Careers (We're Hiring!)

This site is not a part of the Altru website or Blackbaud Inc. Additionally, This site is not endorsed by Blackbaud in any way. Altru is a trademark of Blackbaud Inc.

  • YouTube
  • LinkedIn

Social Good Software | Altru software integrations | Deduper | Calendar Builder | Email Designer | Barcodes Reader | Checkout Flows | Membership Portal | Online Template | API Integrations