Help

Re: The right Formula

653 0
cancel
Showing results for 
Search instead for 
Did you mean: 
resa-me
4 - Data Explorer
4 - Data Explorer

Hi everyone :wave:

I’m pretty bad at Airtable but made a worklfow with Calendly and Airtable for a fitness coach to allow people to book lesson

Now want to limit the number of booking (at 3) per people in a week.
I don’t know want feature to use : Formula (of course), maybe Count…anything else ?

Here a screenshot of my database
Capture d’écran 2021-01-28 à 16.11.53

1 Reply 1
Nick_Dennis
7 - App Architect
7 - App Architect

Do people sign up using Calendly or via Airtable/form? You can set pretty specific availability rules right in Calendly. I know that “Maximum allowed events per day” is in the advanced availability options, but I don’t think they have a weekly equivalent.

I have a personal automation of Calendly to Airtable, just to track client meetings. I’ve also built a simple booking equivalent in Airtable, which worked fine but would be a fair amount of work to fully match Calendly’s features.

To do this from Airtable, you’ll need a way to count the number of meetings in each week, most likely using another table called Weeks. It gets fairly complex after that though, as you’ll need an automation to link it to the appropriate weeks record, a rollup to count the current bookings per week, and then some way to remove availability if that week’s bookings is equal to or greater than 3.

Personally, I’d recommend using Calendly’s features if possible, since you’re already using it, and then automating data into Airtable if necessary. I’d be happy to offer more advice, but would probably need to see more of what exactly the workflow is with Calendly.