RSVP Lists

We use two different formulas to extract each person’s RSVP info. You don’t need to include both in your doc, these are just two examples of creating a list and the one you choose depends on the use-case you need it for.

Display email and status

The first option is a bulleted list that includes more than one type of information. Since we’re combining a couple data points for each person and traversing through a list, we need to use a FormulaMap().

⁠

In this formula, we first filter the list of Event.Attendees by their CurrentValue.ResponseStatus. Then we run the resulting list through the FormulaMap() to Concatenate() the values we want to display. Lastly, we take this final list and make it a BulletedList(). There are several steps involved in the formula, but the result is a nice list including the attendee email and response status.

Email list for a particular status

The second option is a simplified formula that will only return the email addresses of attendees that have marked the event with a certain status. This is useful when you just need a list of emails to send an update to for those attending or a reminder for those that have not decided or declined.

For this use-case, we can use a simple filter by status and return the email address only. The natural resulting data is in list form already.

⁠

Summary

Choose the use-case you need and don’t feel that you have to display all data in every possible way. Part of engineering a great doc is optimizing the information you display to keep things quick and readily apparent at a glance. With more focused tables and information comes speed and ease of use. Great benefits to optimize for in already crowded work days!

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.