Stuck finding related data

[ollyrouse]

Hi all,

 

Was hoping I could be pointed in the right direction here - hopefully I can explain myself fully as to what I want to achieve...

 

TASK: A user has many fridges/freezers in their kitchen, they need to record the temperatures of their fridges twice daily.

 

[FRIDGE NAME TABLE]

To set-up their database, a user first must create a new fridge record and name/number each one, and select range of temperatures the fridge could be running at when the records are taken, 

For instance:

"Fridge 01" temperature zone could be "1°C", "2°C", "3°C", "4°C"

"Freezer 02"  temperature zone could be "-24°C", "-23°C", "-22°C", "-21°C"

 

I don't want the user to have a long a list of ranges which aren't relevant - and so the range selected would shorten their options when recording a fridge temperature on a day.

 

[TEMPERATURE TABLE]

To be clear, I intend the database to have several records of the temperatures available [approx 100 different records/temperatures], and then ask a user to select 8 via a checkbox to allow this quick selection per fridge for when they make their daily records.

 

- So far so good - this works fine.

 

[RECORDED FRIDGE TEMP TABLE]

A new record is produced to record the fridge temp per fridge per session [twice daily]. This needs to be a list of all the created fridge table records and display a pop-up list of the available temperatures per fridge.

 

A new record for this table would need to create a new record for every fridge record - to allow the user to easily input the information required.

For instance, on this table a new record would:

1. Display a list of all records made on the "Fridge Name Table" i.e.: "fridge 1", "fridge 2", "fridge 3"

2. Allow a user to select one option via a radio button from a list of options already defined by the fridge ID from the "Temperature Table"

 

I am a loss to make this work, I keep going round in circles.

I have attached my file as is - please could anyone shed some light on where I am going wrong?

 

Many thanks - really appreciate you guys!

 

Olly

 

FRIDGE_5.fmp12.zip

[doughemi]

Something like this?

FridgeRev.fmp12.zip

[ollyrouse]

Hi Doughemi,

 

Many many thanks for the file! This is close to the information I need the system to create.

One of the biggies though, is for a user to create their own parameters for the device types range of temps. Your file allows "fridge" or "freezer", and then values for one or the other. I need the value list to display many options for the user to select.

What I'm trying to achieve [if possible] is a checkbox set of many values [different temperatures], and the user chooses which values then become available in the value list.

 

Blimey this sounds confusing to me now....

User creates a new record [FRIDGE ID]

User is prompted to select many values via a checkbox [These values are now related to this FRIDGE ID]

 

User creates a NEW READING, selects a FRIDGE ID from pop-up and then options that display are their temperature choices for that FRIDGE ID. Selection inputs that temperature to that fridge with the timestamp....

 

Please if you have the time could you help me out further?

 

Many thanks once again

Olly

[doughemi]

Are the allowable temperatures for each device a continuous range, or can there be gaps in the allowable ranges?

[ollyrouse]

Gaps could be permitted,

 

For example - 

FRIDGE ID 1:  "1.0, 1.1, 1.2, 1.3, 1.4, 1.5"

FRIDGE ID 2:  "1.0, 1.5, 2.0, 2.5, 3.0, 3.5"

 

Thank you 

[doughemi]

IOW, Fridge id 1 temp could be any value between 1.0 and 1.5, right?  Its range would never be  1.0, 1.1, 1.2, 3.0 ?

[ollyrouse]

Different fridges would have different ranges.

 

When setting up the range for Fridge ID 1 the user needs to be able to select 8 temperatures from a long list via a check box.

The selection then becomes the value when creating a new 'reading' for that fridge.

 

Fridge ID 2 would have a different set of selected temperatures, to allow a different shortened value list.

 

My original file attached achieved this on the 'fridge name' table, but I'm struggling to add this back into your nicely working file you posted.

 

Please help?

[doughemi]

What I'm trying to say is each fridge has a minimum temp allowable and a maximum temp allowable.  Any value within that range ought to be acceptable. You don't need discrete temperature steps.  So the user simply enters the observed temp, rather than pick from a list.  Only the min temp and max temp are stored in the Devices table.  Use conditional formatting to flag a temperature in the Readings table outside the range. This would eliminate the Temperature table as well. 

 

Or don't I yet understand the problem?

[Brooks]

One issue you had was you were using the fridge name instead of the fridge ID in Temp record. You needed to set the VL to use ID field and set second field to show name. Look at my example.

I gave you 2 options 1 uses a high and low, the other uses your method of picking the temps one by 1

Then you create a relationship with  a high and low number or Selected temps to the fridge record in a 2nd temp TO. Base your value list on that and Bingo.

Updated this from yesterday to include 2 methods including your original pick each temp.

FRIDGE_5 Fixed.fmp12.zip

[ollyrouse]

Doughemi - I think I get what you mean now - huge thanks for your time and patience.

 

Brooks - super job - thank you so much! The file you posted is getting close to what I set out to do.

The min / max range works a treat - much better than I anticipated and easy to add triggers if the ranges then get too large

 

I have tidied up the file so its functioning as I need - almost!

 

Is there a way to create several new records within a portal, based on the records in a related table?

 

In my file attached on the layout "Date Records Stored" I want to add a button to create a new record, but when the button fires it will add all the portal lines with all the records from the related [FRIDGE NAME] table.

 

Any pointers please folks?

 

Many thanks

Olly

FRIDGE_7.fmp12.zip

[Brooks]

Yes. You need to research the loop Function. Start by building a script that will create 1 record in the portal. Set variables for field data and then go to portal go to last row ( make sure to enable scroll bar) and set fields. Once you have it working use a loop to repeat that function for each parent record. There is already plenty of tutorials on how to do loops. So I'm not going to right a whole tutorial here. If you have a specific question about how something works after you learn about loops, post the question and ill try to help you out.

[ollyrouse]

Struggling at the first hurdle on this

 

I have set my script to place data into the field on my portal. Setting up the variable works if I have "dummy text" but just leaves the portal row blank if I specify the data to be from a related table.

 

I was hoping this would work:

Go to Portal Row [Last]

Set Variable [$i; Value:FRIDGE NAME::NAME]

Set Field [RECORDED FRIDGE TEMP::FRIDGEname_IDkf; $i]

 

 

This works as I expected:

 

Go to Portal Row [Last]

Set Variable [$i; Value:"Dummy Text"]

Set Field [RECORDED FRIDGE TEMP::FRIDGEname_IDkf; $i]

 

 

What am I missing for the portal to bring in the data from a related table?

Thanks again

[Brooks]

OK this is one of many ways to accomplish what you're trying to do. This method is a bit more advanced than the most basic method of hoping layouts back and forth. It also needs a little more error trapping. I put one check in there, but you should do more to make sure you don't end up with a death loop, or blank records. 

FRIDGE_7.fmp12.zip

[ollyrouse]

Thanks Brooks - truly appreciate your time effort and expertise! I have completed my solution now and I'm very happy with its functionality.

I have found however the solution on FileMaker Go lags when creating new data in portal records.

Thanks anyhow - you're a star

Olly

[Brooks]

Thanks and your welcome. Is your go working over wan or wifi? There could be an extra second or two but if its more than that post your file and ill take another look.