Hi Kimaike,If you wan to do this in a single table you'd need to use a script for this. However you can do the bulk of the work by splitting it into 3 tables like so:Edit: Just to clarify - you can get the Promoter/Detractor field using an IF stateme...
I've just rechecked the tables you've suggested in your jpeg and its definitely not the way to go. You'll end up with a table for both Bookings and Non Attendees. You just want 1 table (the attendances table) where you log bookings and if they turned...