Cloud based database with functions

Project details

Create a cloud-based database using Zoho Creator, Google docs, or your preferred platform that can:

1) Store and add member form information

2) Produce printable summaries and various views

3) Create an order form

4) Automatically update submitted order forms into database

5) Allow Administrators to add information directly

Here's how we imagine it may work. We are open to advise and if something is tricky/time consuming or overly complicated we can talk about ways to simplify.

For New members

Step 1 someone emails us saying they are interested in membership and ordering

Step2 We email them a link to the Member form

Step 3 They fill it in and submit it (admin should verify and also be able to add New member info from normal email or word of mouth as well as add/change existing members info)

Step 4 We then email them a link to the Order form which they fill out and submit

Step 5 If the form is correct they get an automatic email (thanks for your order of_______ See you at_______, on Thursday the ___ of ____for collection) If they have trouble an admin person can help them by email.

For Existing members

Each Tuesday we send out an email gmail (via mail chimp) that includes link to the form, existing members can fill out to place an order

Members form (filled out once by new members, updateable by Admin)

Member number (username)

Name (Password)

Best contact number

Email Address

Street Address

Best collection location (i)Brunswick East, (ii)Coburg or (iii)Delivery)

Order status (i)Tria (ii)Member Standing Order (standing order automatially repeats weekly or fortnightly) or (iii)Member Order as need via form

Order Form

Member number (user-name)

Member name (password)

(email us if you have forgotten your member number,)

Local Organic fruit and veggie boxes (choose one or more of the following from drop down menu)

$30 Bag good for 1 person

$35 Box good for 1-2 people

$42 Box good for small families

$50 Box good for large families

$42 Famer's Mixed box

Crumbs Organic Sourdough Bread (choose one or more of the following from drop down menu)

Seven Grain $6.30

100% Spelt $7

Sprouted Wheat $6.50

Casa $6

Sesame $6

100% Rye $6.20

Schultz Organic Dairy (choose one or more of the following from drop down menu) (NB milk order cut off Monday 10am for collection following Thursday Milk not visible after this time )

1L Full Cream Milk $3

2L Full Cream Milk $6

1L Skinny Milk $3

2L Skinny Milk $6

2L Bath Milk $7

500g Yogurt $5

1kg Yogurt $7.5

375g Quark $5.5

375g Feta $8.5

Pick up date (choose any Thursday except if order placed after 10am Wed can not choose to pick up following day)

Pick up Location

Pick up Thursday the_____ between 330pm-9pm Brunswick East

Pick up Thursday the _____ between 3pm-7pm Coburg

Late Pick up (please leave it out for me I WILL collect after hours on Thursday evening (Brunswick East only)

Delivery (can only choose this option if registered by admin for delivery, needs to be within certain boundary)

Payment (Show total)

Please direct deposit total into xxx account

using this Tag for easy admin

(Tag equals member number, name and pickup date eg 45Emily1705)

As administrators we need to be able to view and print information in the following ways

1)As a table of orders with member numbers/names running down vertical axis and pick up dates on the horizontal axis (showing past, present and future dates)

2) The exact same except showing all members numbers/names not just ones who have orders placed (It would be ideal if administrators could manually place an order into this table choosing from drop down menus)

3) A printable summary that would show totals for each Thursday

Total number of boxes

Total number of $30 bags

Total number of $35 Boxes

Total number of $42 Boxes

Total number of $50 Boxes

Total number of $42 Farmer's Mixed boxes

Total number of each type of breads and Dairy also

4) A printable list for each pick up location (i)Brunswick East and (ii)Coburg (iii) Deliveries

Showing total number of different types of boxes, breads and dairy for each location

Followed by a list showing the following info

a) Member no. (Trial members 000 top of the list)

b) Name

c) Contact nd) Veg order

e) Dairy order (or blank)

f) Bread order (or blank)

g) Payment box (paid, amount, date)(entered by admin)

f) Tick box for collection (or show after hours collection option)

g) Comments

We imagine this will be printed landscape so there is enough room

Other things to consider

1) Ideal if table is a continual calendar so we could look back and forward (thinking this system is a temporary system we hope to be succeeded by a website in September/Oct 2012)

2) Ideal if standing orders are shown in a different colour to emailed orders

3) Some members will not be able to use the form so Admin needs to be able to take info from a normal email or word of mouth and search member name or number and input information for them

Compétences : Informatique en Nuage

en voir plus : work search creator, seven axis, search member, room summary, printed names, past member, n equals, local same day delivery, landscape forms, how to get a temporary work, how to choose username for new website creator, google docs mail, easy website creator, direct deposit not showing up, cloud computing needs, zoho forms, print menus, how to work google docs, how to use zoho, how to google docs, google docs status, google docs how to, google docs gmail, good docs, gmail google docs

Concernant l'employeur :
( 0 commentaires ) Australia

Nº du projet : #1637062