Status Formula

Overview

The status formula plays a significant role in understanding how the event works. With this read-only formula field, you'll learn what is the current status of your event, ticket or session. So when you see the event is Sold Out, it's because the Status Formula field = Sold Out.

Example Event -

London Tour Event having no remaining capacity and waitlist enabled = True.London Tour Event having no remaining capacity and waitlist enabled = True.

London Tour Event having no remaining capacity and waitlist enabled = True.

Status formula showing Sold Out and waitlist open.Status formula showing Sold Out and waitlist open.

Status formula showing Sold Out and waitlist open.

Let's dig further to see how these statuses are derived!

Instructions

You will need to add the Status formula to your Event/Event Item/Session page Layout.

  1. Visit Setup > Object Manager > Choose object > Page Layout > Drag the Status formula on the Layout > Save.

Reference below tables to understand the criteria for each of the status formula.

Event

Status Formula

Set on Criteria

Event Ended: This means your event has ended and prospects can't register.

An event has ended when the event's end date and time are in the past or the Status field = Completed.

Sold Out: This means your event is sold out based on the capacity.

When the event's waitlisting is disabled and the remaining capacity is 0.

Sold Out, Waitlist Open: This means your event is sold out but waitlisting is available.

The event's waitlisting is enabled and the remaining capacity is 0.

Sold Out, Waitlist Closed: This means your event sold out and waitlisting is closed.

The event's waitlisting is enabled and the waitlist remaining capacity is 0.

Disabled Event: This means the registration button will be hidden on the Event.

The event's Hide Register Button picklist value is Yes.

Event Active: This means your event is active and allows prospects to register.

An event is active when the event's end date and time are still in the future.

Canceled: This means your event has been canceled and prospects are no longer allowed to register or view the event.

When the event's Status field is updated to Canceled.

Ticket (Event Item)

Status Formula

Set on Criteria

Pending Registration Start Date (Public): This means the public ticket isn't for sale yet.

The start date and start time are in the future and Hidden is unchecked.

Pending Registration Start Date (Private): This means the private ticket isn't for sale yet.

The start date and start time are in the future and Hidden is checked.

Registration active (Public): This means the public ticket is currently available.

The current date and time are in between the ticket's start and end dates and times or the start date/end date is not defined and other status criteria are not met. Hidden is unchecked.

Registration active (Private): This means the private ticket is currently available.

The current date and time are in between the ticket's start and end dates and times or the start date/end date is not defined and other status criteria are not met. Hidden is checked.

Registration ended (Public): This means the public ticket's registration has ended.

The end date and time are in the past and Hidden is unchecked OR the Event has ended.

Registration ended (Private): This means the private ticket's registration has ended.

The end date and time are in the past and Hidden is checked OR the Event has ended.

Sold Out: This means the ticket is sold out based on capacity.

When the ticket's quantity remaining is 0 OR the Event is sold out.

Sold Out, Waitlist Open

When the ticket's quantity remaining is 0 and Waitlist Enabled is checked OR the event's waitlist is enabled.

Sold Out, Waitlist Closed

When the ticket's quantity remaining is 0 and the remaining waitlist capacity is 0 OR the event's waitlist is closed.

Session

Status Formula

Set on Criteria

Pending Registration Start Date (Public): This means the session isn't available yet.

The start date and start time are in the future and Hide on Event Page is unchecked.

Pending Registration Start Date (Private): This means the private session isn't available yet.

The start date and start time are in the future and Hide on Event Page is checked.

Registration active (Public): This means the public session is currently available.

The current date and time are in between the session's start and end dates and times or the start date/end date is not defined and other status criteria are not met. Hide on Event Page is unchecked.

Registration active (Private): This means the private session is currently available.

The current date and time are in between the session's start and end dates and times or the start date/end date is not defined and other status criteria are not met. Hidden is checked.

Registration ended (Public): This means the public session's registration has ended.

The end date and time are in the past and Hide on Event Page is unchecked.

Registration ended (Private): This means the private session's registration has ended.

The end date and time are in the past and Hide on Event Page is unchecked.

Sold Out: This means the session is sold out based on capacity.

When the session's quantity remaining is 0.

Sold Out, Waitlist Open: This means the session is sold out but the waitlist is enabled.

When the session's quantity remaining is 0 and Waitlist Enabled is checked.

Sold Out, Waitlist Closed: This means the session is sold out and waitlisting is closed.

When the session's quantity remaining is 0 and the remaining waitlist capacity is 0.

Here is an example of a event that has already been completed.Here is an example of a event that has already been completed.

Here is an example of a event that has already been completed.

Here is an example of a event that has already been completed.Here is an example of a event that has already been completed.

Here is an example of a event that has already been completed.


Did this page help you?