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 | |
30 | |
23 | |
16 |