Formulation Issue

Thanks for the degree symbol shortcut.

As for the rest, I think I'm not communicating the idea clearly. I think this code is closer to what I'm looking for:

let myID := this;
let myT := myID.'T#';
let p := text('Apps Project'.'Project Variables');
let x := if contains(p, "Cure Temp") then
'Apps Project'.'Trial Summary'.'Ink Cure Temps'.'Cure F' + " for"
else
'Apps Project'.'Ink Cure Temps'.'Cure F' + " for "
end;
let y := if contains(p, "Cure Duration") then
'Apps Project'.'Trial Summary'.'Ink Cure Duration'.Seconds + " or " + 'Apps Project'.'Trial Summary'.'Ink Cure Duration'.MinSeconds
else
'Apps Project'.'Ink Cure Duration'.Seconds + " or " + 'Apps Project'.'Ink Cure Duration'.MinSeconds
end;
string(x + y)

myT returns the current records 'T#', but I don't know the syntax to get the value of the field 'Apps Project'.'Trial Summary'.'Ink Cure Duration'.Seconds for myT. Currently it's returning 'Apps Project'.'Trial Summary'.'Ink Cure Duration'.Seconds value for all 'T#' in the 'Trial Summary'.

For further clarification 'Project Variables' is a multiple choice field that allows the user to select variables to apply to specific trials as opposed to all trials. In the example from the previous post I have only selected 'Ink Cure Duration' as a trial specified variable, which is why it's returning multple results (60s and 90s or 01:00 and 01:30), whereas 'Ink Cure Temp' is not a variable per trial and is being defined by 'Apps Project'.'Ink Cure Temps'.'Cure F'.

Hopefully that helps clarify. Let me know if you come up with something. As far as I can tell, it should be a simple solution, but syntax ignorance is getting in the way.

'Apps Project' is a table with 'Trial Summary' as a subtable.

'ink Cure Duration' is being referenced by both tables, but is only available to populate in 'Trial Summary' if "Cure Duration" is selected from the 'Apps Project'.'Project Variables' multiple choice field.

The 'T#' being referenced is technically 'Apps Project'.'Trial Summary'.'T#'

So my code is essentially trying to look at whether or not 'Ink Cure Duration' data is being applied at the 'Apps Project' level or the 'Trial Summary' level and then stringing that data out in the formula field. The code succeeds at differentiating where the data is coming from; however, it is currently stringing the 'Ink Cure Duration' data from all trials ('T#') within the 'Trial Summary'. I need it to only produce the data for the trial being viewed.

I will have to look into chosen() or numbers() for referencing multiple choice fields. Correct me if I'm wrong, but I don't think it would have an effect on what I'm trying to achieve in this circumstance other than a change in syntax.

Let me know if this helps.

Forgot to point out that 'Ink Cure Duration' is also a table. Sorry about that.

Thanks, Sean. I appreciate it.

It will often be necessary.

The 'Trial Summary' table contains multiple 'T#'s (or trials). The 'Ink Cure Duration' may vary from 'T#' to 'T#' (or trial to trial) within the 'Trial Summary'.

Well, I figured it out. Turns out I was being too specific in my callouts for the tables. The addition of 'Apps Project'.'Trial Summary' to 'Ink Cure Duration' was what was grabbing the data from all the 'T#'s. Once removed, it behaved as intended.

let p := text('Apps Project'.'Project Variables');
let x := if contains(p, "Cure Temp") then
'Ink Cure Temps'.'Cure F' + " for "
else
'Apps Project'.'Ink Cure Temps'.'Cure F' + " for "
end;
let y := if contains(p, "Cure Duration") then
'Ink Cure Duration'.Seconds + " or " + 'Ink Cure Duration'.MinSeconds
else
'Apps Project'.'Ink Cure Duration'.Seconds + " or " + 'Apps Project'.'Ink Cure Duration'.MinSeconds
end;
string(x + y)

Thanks for all the help and sorry for sending you on a wild goose chase. Another syntax lesson learned for me!