Hi From Greece, I have a question about a ap...

references
(Akis Karentzos) #1

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 ?

(Mary Jane Pender) #2

@Akis_Karentzos

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.

(Aleksi Alkio) #3

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

(Mary Jane Pender) #4

@Aleksi_Alkio

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 .

@Akis_Karentzos

How are you getting the temperatures now?

is someone manually checking the temperature?

Let us know.

(Akis Karentzos) #5

@Mary_Jane_Pender

Yes manually

(Mary Jane Pender) #6

… 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.