On my home page, I am using a Connection to a table to display a range of options for an event outcome - minor, major and catastrophic. In that second table (Event Outcome)I also have a score associated with the event outcome which I want to access in an equation on the page.
The fields are “Outcome” - (text field) and “Score”.
How can I pull in that Score field from the connected “Event Outcome” table and use it in an equation on my main page?
Thanks for your help.