Summing Meal Choices in Registration Table

[John_Dlouhy]

Greetings! I am trying to track event registrations. My table has these fields:

Primary First Name
Primary Last Name
Event #1 Status (Single Select: Yes, No, Cancel, Didn’t Attend, Hasn’t Replied–applies to attendee coming alone or to attendee bringing a guest)
Event #1 Meal for Primary First (Single Select: Meat, Veg)
Guest First Name
Guest Last Name
Event #1 Meal for Primary Guest (Single Select: Meat, Veg)

How best to see a total sum of all the meat meals and all the veg meals?

Thank you–any assistance is greatly appreciated!

[John_Dlouhy]

Wow! Thank you Neads!! This is so cool—I will need to spend time with it to understand the set up.

Yes—meals for all sessions. Future events would be a combo of sessions with meals and without.

I’ll need to see how to handle the scenario when someone brings a different guest to one or more sessions, etc.

OK to follow up with questions as they come up?

Hope you had a great Labor Day weekend.

Cheers—

John

[AlliAlosa]

Hi John,

You’re entirely welcome and of course! Feel free to reach out with any questions!

To handle different guests, I would add them into the [People in Sessions] table. You could pull the original guest’s name over from the [People] table with a lookup, and use a formula field to override it if a different guest is attending. :slightly_smiling_face:

[John_Dlouhy]

Hello again! Hoping you can help again with a quick question.

I am trying to create a formula field to return the following result:

• If ‘Donors YES’ is not empty/is not blank, enter ‘SCHOLARSHIP’

My attempt is doing the exact opposite! It’s entering the SCHOLARSHIP name where Donors YES is blank.

Here’s my formula attempt:

• IF({Donors YES}=BLANK(),{SCHOLARSHIP })

And a screen shot of the results:

[Jeremy_Oglesby]

Hi @John_Dlouhy,

Just remove the =BLANK() from your formula.

IF({Donor YES}, {SCHOLARSHIP})

That will fill the field with the {SCHOLARSHIP} if there is anything at all in the {Donor YES} field.

[John_Dlouhy]

Thank you Jeremy!

I am realizing I have to factor in another field as well,

If Scholar YES is not blank, and Donor YES is not blank – return SCHOLARSHIP.

Is this an IF/AND or IF/Or?

[Jeremy_Oglesby]

IF(
   AND(
      {Donor YES},
      {Scholar YES}
   ),
   {SCHOLARSHIP}
)

[John_Dlouhy]

Greatly appreciated, Jeremy! Thank you so much.

[ I sent this on the go from my iPhone, so please excuse my brevity and any typing errors. ] :pray: