Hi From Greece,
I have a question about a app in appsheet.
i want an app to monitoring containers temperature. for each container i want three temperatures in day. and i want for each container history for 6 months in one row.
how i can do it ?
Just as Aleksi said earlier … at its simplest, you would have a table that lists each unique container – that would be a tab on a Google Sheet – it should have data like:
ContainerID
(should be unique id), Container Description,
Monitor Start Date, Monitor End Date.
then you would have another google sheet that
for each temperature reading
– 3 times a day for each container.
You would relate each Temperature record to its “parent” Container.
The temperature records should include the following data:
Date,
Reading Time , ContainerID (relationship), Temperature.
Go to the link Aleksi provided on how to create a link between tables and create your app.
good luck.
m.j.
May I ask why do you need to have all your temperatures in one record? You would need to have about 550 columns which is not a good solution.
I believe you have more than just few containers and you could use a related table structure. The container would be the parent record and the temperature record would be the child. Please check this article… help.appsheet.com - References Between Tables References Between Tables help.appsheet.com
I think Akis means he would like to have all the temperatures every day for 6 consecutive months.
I would be interested in how we get the the temp data from the containers.
I am thinking of something like and Arduino board with temp sensors and a comm component .
How are you getting the temperatures now?
is someone manually checking the temperature?
Let us know.
Yes manually
… one more thing.
Delete any empty columns from your google sheets.
Google limits allow 2,000,000 cells per sheet (a sheet has one or more tabs)
calculated as rows X columns.
But for now, just get started and capture the data.
Over 6 months each container will have 182 days X 3= 546 records or rows X 4 data columns = 2,184 cells.
Using my example you could reasonably track 800 to 900 containers for 6 months each.
After that you may have to consider archiving older data.
If you need more capacity you may have to get into a mySQL database.
m.j.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |