Creating and Editing Lists on The African Exponent

Creating a List

1) Get to the Manage List View.

2) Go to the New List view by clicking on the New list tab.

3) You will be presented with a prompt to create a new spreadsheet. This will be created automatically using Google Sheets. In the prompt, fill out the required information.

3.1) Spreadsheet Heading: This will be the heading of the spreadsheet. Most lists can be updated by easily modifying the values in the underlying spreadsheet so a good heading will make it easier for you to remember the spreadsheet when viewing it in your own Google Drive account.

3.2) Edit Permissions: Enter a comma separated list of the emails of people who will have write permissions on this spreadsheet. Naturally, you will want to have your list included in this email so that you can be able to edit. e.g. [email protected],[email protected].

3.3) Click Create and wait for the system to create the spreadsheet. When it is done, you will also receive an invitation email from Google Drive with the link to the spreadsheet.

4) Now you will be presented with the opportunity to create the List.

4.1) Heading: This will be the heading of this list. Note that this can be the same or different from the heading in 3.1 above. 3.1 is the heading of the spreadsheet in Google Sheets, this is the heading of the list on the site (the one you will be seeing when you go to Manage List View.

4.2) Spreadsheet: This is just the link to the underlying spreadsheet of this list. If you did not receive an invitation email to edit list from Google Drive, you can use this link to get there.

  • In case you still don't have the permissions to edit the spreadsheet in Google Drive, you can click the Add People button to invite yourself again. You can also invite more people this way. Add people to lists

4.3) Add your data into the spreadsheet: Check our tutorial on List Spreadsheet Format and Data Types for the details of how to input your data into the spreadsheet.

4.4) Authors: Select the authors of this list.

4.5) Synchronize & Save: When finished editing, click Synchronize & Save to synchronize (download data from the spreadsheet) and save (save list information) to the database.

Editing a List

1) Get to the Manage List View.

2) Look for the list and click Edit.

3) You can now change the heading e.t.c of the list.

  • To edit the values of the list, go to the list's spreadsheet and update the values.

  • You can also invite more people to the spreadsheet using the Add People widget. Add people to lists

4) Synchronize & Save: When finished editing, click Synchronize & Save to synchronize (download data from the spreadsheet) and save (save list information) to the database.

Note: You can edit the values of the spreadsheet at any time even without going to the List Editor, but for the new values to be detected, you will have to go to the list editor and click Synchronize & Save.