Improve Speed of Data Entry

[adelaiderobinson]

• [x] method for switching tab before entering data

• [x] faster method than for loop?

• [x] read in lookuptable in global environment

• [ ] asynchronous shiny (multiple users)

[adelaiderobinson]

updated data entry so that it actually enters when the tab is switched to improve speed for all tabs except the final one. Also combined the lookup tables.

[adelaiderobinson]

removed redundant code, and made it so that all new rows for a category are entered at once. Would be good to change edited data so that it only overwrites if something has changed.

[adelaiderobinson]

updated edited data to change only if edits have been made. Moved asynchronous shiny to possible future updates.