Arts Faculty » ArtsIT » ArtsWeb » Resources » Forms »

From Form to Spreadsheet

2.0 Format of Spreadsheet(s):

When getting ArtsWeb to create an online form you will need to consider how the data is going to be formatted in a Spreadsheet. You may wish to create several Spreadsheets. For each spreadsheet you wish to create you will have to tell ArtsWeb of its format.

As an example we are going to use a form that was created by ArtsWeb for the Research area. The names, addresses used herein are all fictitious.

These are the data fields:

Surname
Given Names
Student ID
Address Line 1
Address Line 2
Address Line 3
State
Postcode
Email
Phone
Faculty Belonging To
School Belonging To

Seminar 1
Seminar 2
Seminar 3
Seminar 4
Seminar 5
Seminar 6
Seminar 7
Seminar 8

Requires Childcare
Child 1:
- Surname
- Given Names
- Sex
- Age
Child 2:
- Surname
- Given Names
- Sex
- Age
Child 3:
- Surname
- Given Names
- Sex
- Age

* The Seminar 1-8 fields and Requires Childcare are Yes/No fields

Here are some spreadsheets that could be created from the data:

Contact Details:

Surname:	Given Names:	ID :	Address:			State:	PC:	Email:	Phone:	Faculty:	School:

Seminar Attendees:

Surname:	Given Names:	ID:	Will Attend Seminars:
Surname:	Given Names:	ID:	1	2	3	4	5	6	7	8

Childcare:

Surname:	Given Names:	ID :	Address:			State:	PC:	Email:	Phone:

Child 1:				Child 2:				Child 3:
Surname	Given Names:	Sex:	Age:	Surname	Given Names:	Sex:	Age:	Surname	Given Names:	Sex:	Age:

Contents Back Next