This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, I’m trying to make an App formula in a form field that returns data from another table based on the answer to a previous question. In other words, I have three teams and if I answer Team 1 to the first question, I want it to automatically fill this field with info from a slice I made of people who are on Team 1. I feel like I’m close, but need a little more guidance. Thanks!
//Assuming that you have 5 location columns
//You can alter the expressions as per needs
SWITCH(
[Location],
"KeyColumnValueForLocation_1",SELECT(ToolsTable[ToolName],AND([Location]=[_THISROW].[Location],[Quantity at Location1]>0)),
"KeyColumnValueForLocation_2",SELECT(ToolsTable[ToolName],AND([Location]=[_THISROW].[Location],[Quantity at Location2]>0)),
"KeyColumnValueForLocation_3",SELECT(ToolsTable[ToolName],AND([Location]=[_THISROW].[Location],[Quantity at Location3]>0)),
"KeyColumnValueForLocation_4",SELECT(ToolsTable[ToolName],AND([Location]=[_THISROW].[Location],[Quantity at Location4]>0)),
SELECT(ToolsTable[ToolName],AND([Location]=[_THISROW].[Location],[Quantity at Location5]>0)) //Default value
)
LinkedIn
Twitter
