Help

Re: Sign-up sheet

1239 0
cancel
Showing results for 
Search instead for 
Did you mean: 
CPMSM
4 - Data Explorer
4 - Data Explorer

Hello- I watched this video but it's not clear to me what happens between minute 1:00 and 1;07.  

https://youtu.be/ES1RyNPv_Kg

I am looking to create a sign-up sheet for one day in 5 minute increments between the hours of 12:00 pm - 5:00 pm, and have 4 rooms running at the same time. 

How do I pre-populate the times?

CPMSM_0-1691458728601.png

Any help is greatly appreciated.

1 Reply 1
AirOps
7 - App Architect
7 - App Architect

Hi @CPMSM

What I believe happened in the video between 1:00-1:07 is manual data entry for all of the available appointments for that date. There was no formula that auto populated the table. Airtable is different from excel/google sheets where you cannot have a formula that you can drag to continue to add 5 minutes to the cell beforehand for example. All formulas apply to the entire column in Airtable rather than individual cells as in excel/google sheets. 

My recommendation for populating your table in a more efficient manner is either to ask ChatGPT to create your data set for you, or to create the data set in excel first, and then you can copy and paste your data straight into Airtable.  You can prompt ChatGPT with something along the lines of "please create a table of appointments in 5 minute increments for xx day between 12-5pm for 4 different rooms named A, B, C, D "

I hope this helps, please let me know of you have any questions. 

Chantal