Digital strecklista som webapp för simpel hantering av streckvaror
Since Google Sheets can only support roughly 10,000 rows a new version with a real database would be nice to have. Some work has been done by ECarlsson however it is far from complete. As I have graduated I have decided to stop updating this. Feel free to contact ECarlsson if you want to help!
The application is comprised of two parts:
First you will make a database Sheet from a template and enable it for web requests.
There are some database settings which will be described here.
Here are the general settings for the web app.
password- This is the password for the admin page in the web app.
groups- A list of all the groups and in what order they should be shown. Note that users that are in hidden groups can still be selected in the favourite and plus menues.
buttons- Which buttons should be shown in the action bar.
mail_user- Email address and user name for Microsoft account which will be used to send out account balance reminders.
mail_pw- Password for the account above.
title- Title of the web app (shown as title of browser tab).
pin- PIN code for accessing the web app. Set to 0000 to make it accessible by everyone.
swish- Mobile number for Swish account
mail_name- Name of admin. Will be shown in various parts of the app.
negative- Global flag for allowing transactions if it results in a negative balance. There is also a flag for every user that overrides this option if it is set to Nej. This means that you can allow only certain people to have a negative balance.
days_pin- How many days will pass until the user has to enter the PIN code again. Notice that if you change the PIN code all users will have to immediately enter the new PIN code.
minutes- How far back the list of transactions will go in minutes. Apart from this limit the maximum number of transactions in this list is 10.
Here you you put all the users and their information. There are 10 possible fields:
To add a user, add the desired number of rows and input the users' information. After you are done, you can click sort at the top of the columns.
Here you can set up all the rules for account balance email reminders. You have the following fields:
The last two lines can use the variables
swish but in the form
%var%. For example if the subject line is Hello %nick%! then when the email is sent out
%nick% will be replaced with that user's nickname.
The actual interface for sending these emails is located in the app (in the admin page). When logged in, you can first send a test email to an address of your choice to see that the app has access to the Outlook account. There is also a button for fetching a preview of all the emails that will be sent. Finally the last button is for actually sending the emails.
Now you will deploy the web app to Heroku.
In order to update the app you need to first figure out if the version requires a Sheet update or not. You can do that by checking the latest version in the changelog.
You can skip directly to Update web app if the new version does not require a Sheet update. First you will update the backup file, then create a new Sheet and finally import the backup file into the new one.
User instructions can be found in the actual web app. Check out the demo!
If you have an idea for a new feature or found a bug please create a new issue.
A valid issue should
If the issue is well recieved, you can create a fork and start coding. A bad issue will lower the chances of approval for your pull request!