Shirley_Kawafuc - profile

Shirley_Kawafuc · May 30, 2023

Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc. This gets recorded in the Attendance table under their ...

Shirley_Kawafuc · Feb 24, 2023

Hello, I want to calculate the total cost per tickets ONLY IF they are a specific type, and then I want to deduct that from a total amount that I set manually. My fields are currently set up: Total tickets (# field)Per ticket cost ($ currency)Total c...

Shirley_Kawafuc · Jun 14, 2023

Just sent! Please note it is a LIVE form with responses already coming in. Thank you for your help and please feel free to direct message me with any questions.

Shirley_Kawafuc · Jun 13, 2023

@TheTimeSavingCo , I did some final tests and I'm having trouble with my Rollup for "Sum of Tickets Requested" because "number of tickets" is listed in separate fields, by date. I feel like there is an extra linking step I need to do. Can I invite yo...

Shirley_Kawafuc · Jun 06, 2023

Performances tab is solved, but I just did another test submission and am definitely having something weird going on with my lookup formula in Attendance. For one of the performances, it's returning 576,776 instead of just 576. Not sure where the ot...

Shirley_Kawafuc · Jun 06, 2023

Thank you so much Adam!! Your steps worked. The only thing that remains wonky is now my lookup field in my Attendance table. It's doing what it's supposed to (displaying the value of Total tickets remaining), but displaying it within each entry is a ...

Shirley_Kawafuc · Mar 13, 2023

Weirdly, for some reason, my Deduct formula column isn't working now. In screenshot, you'll see the amounts it's giving are incorrect. I have the formula set up like: IF({Revenue Source} = "Student ticket Campaign",{Total cost} - 44,899)

User Statistics

User Activity

Rollup/ Formula to deduct # tickets claimed from tickets available

If/then formula

Re: Rollup/ Formula to deduct # tickets claimed from tickets available

Re: Rollup/ Formula to deduct # tickets claimed from tickets available

Re: Rollup/ Formula to deduct # tickets claimed from tickets available

Re: Rollup/ Formula to deduct # tickets claimed from tickets available

Re: If/then formula