Tobias_Brenner - profile

Tobias_Brenner · Mar 27, 2020

Hi Everyone, I recently started using Airtable and I think the whole tool is great. I am now setting up a Base for planning a private birthday party. Some background information: We are multiple people celebrating together. Everyone can invite people...

Tobias_Brenner · Mar 30, 2020

@Mohamed_Swellam, I implemented the sum by adding a link to all guests in all the hosts (and vice versa) and then rolling up the name. Is there a better solution then that? Also what do you mean with Base Id?

Tobias_Brenner · Mar 30, 2020

I mean I can read the total number in the sum bar at the bottom, but I cannot use that value in a formular for calculating the costs, can I?

Tobias_Brenner · Mar 30, 2020

@Mohamed_Swellam I am sorry but I don’t get it. How can I sum-up the number of all guests using the new roll-up field that is summing up the number of guests per person? I am sorry for missing something here…

Tobias_Brenner · Mar 30, 2020

Hi @Mohamed_Swellam, sorry, one additional question: To properly divide the costs to the hosts, I need to know the total no. of Guests in the Hosts table. Do I really need to add an additional field in the Guest table “All hosts” and always link all ...

Tobias_Brenner · Mar 30, 2020

Hi @Mohamed_Swellam, Thanks a lot for your solution. This is exactly how I did it in the end, so I am very happy that you confirmed that this is the best / only solution. Best Tobias

User Statistics

User Activity

Event Planning: Count of Guests and Calculate Prices

Re: Event Planning: Count of Guests and Calculate Prices

Re: Event Planning: Count of Guests and Calculate Prices

Re: Event Planning: Count of Guests and Calculate Prices

Re: Event Planning: Count of Guests and Calculate Prices

Re: Event Planning: Count of Guests and Calculate Prices