Skip to main content

I’m an event promotor. I’ve been using AT for a while to keep track of community member applications, event details, and general ticket sales. I want to get a better sense of real time income via sale so I’d like to update the base.

Right now, I have 3 tables in the base:

  1. Member List - Record for each member with personal info
  2. Events - Record for each event (Party A, Party B, Party C, etc)
  3. Ticket Types - Record for each type of ticket (Full price, 25% off, 50% off, comped, etc)

None of these include price of the ticket and I would like to start tracking that.

Thinking the tables should be this, but I’m not sure:

  1. Member List - Same as above
  2. Events - Same as above, but add in pricing columns for different ticket types — Tier 1 = $90, Tier 2 = $100, Tier 3 = $110, etc. The pricing can change from event to event so the amounts cannot be a universal across all events.
  3. Discount Codes — This would be a conversion of the above Ticket Types table and apply an actual percentage off of the event — Full price = 0%, Friends & Family = -25%, VIP = -50%, Comped = -100%, etc)

I would ultimate like to be able to use an AT form to select each member who buys a ticket and then choose the event, ticket tier, and discount code (if any) that they used.

This would allow me to see that John Smith bought a Tier 2 ticket to Party A at $100, but used the Friends & Family code which netted me $75. From there I can run all sort of calculations to see who my highest spending members are, what I might be losing in discounts, etc, etc.

Any guidance that could be offered here would be greatly appreciated.

 

 

I’d have these tables:
Members
Events
Pricing (maps to events)
Discount codes
Sales (maps to member, pricing and discounts and contains actual amount that hit your bank)

Remember, you create a table for each entity type that can possibly have a many:1, 1:many or many:many relationships with other entity types.
Pricing would be all price points for an event. Discount codes could be enabled for a single event or more than one. Sales could be linked to members, or to pricing, or to discounts. 

​@Geoffrey_Badner 

When you say that you want to do this from a form, will you be doing this while logged into Airtable? If so, you can do this from within an interface inside of Airtable.

However, if you are thinking about doing this from a publicly-facing “external” form, then you probably wouldn’t be able to achieve this with Airtable’s native forms unless there will only be one “line item” on your form.

Will you be allowing multiple “line items” worth of tickets per form submission?

If you’re allowing “multiple line items” on your form, then you would need to use Fillout’s advanced forms for Airtable, because Fillout lets you add multiple line items to each form — and each line item can have its own linked record selections within each line item.

In other words, Fillout lets you have linked records within linked records, which it sounds like you need to do. (This is not possible with Airtable’s forms, unless you are logged into an interface page and doing it from an interface.)

To better explain how this looks in Fillout, check out my demonstration video in this Airtable podcast episode: ​​​​

Fillout is 100% free, and it also offers tons of other form features that might benefit you, such as the ability to accept payments on forms, update Airtable records using a form, create custom PDF files from a form submission, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, perform math or other live calculations on your forms, and much more.

I have another video here that demonstrates some of these advanced features:

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

+1 for Vika’s suggestion, and I’ve set it up here for you to check out.  The end product looks something like this:

You’d pull over the Price and Percent via lookups, and if you’re on a paid plan, you’d set your ‘Prices’ field to have a conditional filter to only display the prices for the linked event:

And your form might look like the following:

If this works out be sure to mark Vika’s post as the solution!

Terms & ConditionsAccessibility statement