Class of 2020
14.5Avg
Name Email DOB Age Grade Guardians
1 Miguel De Cervantes miguel@de.com 12 Mar 10 13 Albert Cervantes +
2 Gabrielle-Suzanne suzy@suzy.com 11 May 07 12 Lisa-Suzanne +
3 Isaac Newton isaac@newton.com 11 Mar 04 13 Jean NetwonJack Netwon+
4 Mary Shelley m@shelly.com 12 Jan 06 9 Tom ShelleyIse Shelley+
5 Herman Melville h@yahoo.com 4 Mar 11 10 Samantha Lee+
6 Emma Dorothy emm@hotmail.com 12 Mar 20 13 Sean DorothyRaj Sharma+
7 Scott Fitzgerald scotty@f.com 12 Dec 07 15 Natalie Dunning+
8 George Orwell g@orwell.com 12 Aug 01 16 Alex Orwell+
9 Nnedi Okorafor nn@gmail.com 22 Mar 10 8 Tom Okorafor+
Add
Class of 2019
14.5Avg
Name Email DOB Age Grade Guardians
1 Miguel De Cervantes miguel@de.com 12 Mar 10 13 Albert Cervantes +
2 Gabrielle-Suzanne suzy@suzy.com 11 May 07 12 Lisa-Suzanne +
3 Isaac Newton isaac@newton.com 11 Mar 04 13 Jean NetwonJack Netwon+
4 Mary Shelley m@shelly.com 12 Jan 06 9 Tom ShelleyIse Shelley+
5 Herman Melville h@yahoo.com 4 Mar 11 10 Samantha Lee+
6 Emma Dorothy emm@hotmail.com 12 Mar 20 13 Sean DorothyRaj Sharma+
7 Scott Fitzgerald scotty@f.com 12 Dec 07 15 Natalie Dunning+
8 George Orwell g@orwell.com 12 Aug 01 16 Alex Orwell+
9 Nnedi Okorafor nn@gmail.com 22 Mar 10 8 Tom Okorafor+
Add
Fields

Drag elements between toolbar and form


Design
2 Columns
3 Columns

On Form submission..


Subforms from linked tables

GuardiansAdd

Student Intake Form

Name

Email

Grade

Age

Guardians

New Rule

When this Happens

  • A record is created

    Example: A new job application in your hiring process.

  • A record or field is updated

    Example: A new job application in your hiring process.

  • A date or time condition is met

    Example: A new job application in your hiring process.

  • The record moves to a phase

    Example: A new job application in your hiring process.

Do this

  • Send an email

    Example: Send a new hire an email when they are selected.

  • Update a field

    Example: Perform a calculation.

  • Move a record

    Example: Move a lead to closed phase when sale is won.

  • Create a record

    Example: Create a task when a condition is met.

Class of 2020
Name Email Phone Photo Address Children
1 Albert Cervantes albert@de.com 324-765-2341 Miguel De Cervantes +
2 Lisa-Suzanne lisa@suzy.com 711-890-9862 Gabrielle-Suzanne +
3 Jean Netwon jean@newton.com 564-908-2654 Isaac Newton+
3 Jack Newton jack@newton.com 444-564-7655 Isaac Netwon+
4 Tom Shelley t@shelly.com 675-078-3256 Mary Shelley+
4 Ise Shelley i@shelly.com 645-345-7654 Mary Shelley+
5 Samantha Lee sl@yahoo.com 645-056-0088 Herman Melville+
6 Sean Dorothy s@hotmail.com 266-235-8263 Emma Dorothy+
6 Raj Sharma r@hotmail.com 644-254-5681 Emma Dorothy+
7 Natalie Dunning nat@dunning.com 662-783-0001 Scott Fitzgerald+
8 Alex Orwell alex@orwell.com 334-234-8934 George Orwell+
9 Tom Okorafor tom@okra.com 932-437-8234 Nnedi Okorafor+
Add
Fields

Drag elements between toolbar and form


Design
2 Columns
3 Columns

On Form submission..


Subforms from linked tables

GuardiansAdd

Student Intake Form

Name

Email

Grade

Age

Guardians

New Rule

When this Happens

  • A record is created

    Example: A new job application in your hiring process.

  • A record or field is updated

    Example: A new job application in your hiring process.

  • A date or time condition is met

    Example: A new job application in your hiring process.

  • The record moves to a phase

    Example: A new job application in your hiring process.

Do this

  • Send an email

    Example: Send a new hire an email when they are selected.

  • Update a field

    Example: Perform a calculation.

  • Move a record

    Example: Move a lead to closed phase when sale is won.

  • Create a record

    Example: Create a task when a condition is met.

Allergic Students
Name Allergy Emergency Contact
1 Miguel De Cervantes Wheat Albert Cervantes
2 Gabrielle-Suzanne Nuts Lisa-Suzanne
3 Isaac Newton Nuts Jean Netwon
4 Mary Shelley Bee Sting Tom Shelley
Global Students
Name Country
1 Miguel De Cervantes Portugal
2 Gabrielle-Suzanne France
3 Isaac Newton UK
4 Mary Shelley Italy

Acme School of Excellence

New Student
All Students for 2020
Name Email
1 Miguel De Cervantes m@cervantes.com
2 Gabrielle-Suzanne gabby@suzanne.com
3 Isaac Newton isaac@newton.com
4 Mary Shelley m@shelley.com
5 Herman Melville h@yahoo.com
6 Emma Dorothy emm@hotmail.com
7 Scott Fitzgerald scotty@f.com
8 George Orwell g@orwell.com
9 Nnedi Okorafor nn@gmail.com

Total vs. Exchange Students

Students Year on Year