Use a different table column in a if condition

[Denis_Dal_Soler]

Hi I made a custom new action in "behavior" named "Change". It's  called from my view for every row clicks and allow me to change  this row within an  if condition . Now I need that this condition use a column sites in another table (not the same of my view) linked in the same app. Wow can I use this column in my expression? I specify that I'm just using a  reference column. Thanks

[jyothis_m]

Dereference expressions

[Steve · Accepted solution]

I do not understand your question, so I'm going to guess you need to pull a value from a referenced row (using a Ref column value), but the column you want the value from is dependent on the value of a different column of the original row.

SWITCH(
  [choice],
  "choice-1", [ref-column].[column-for-choice-1],
  "choice-2", [ref-column].[column-for-choice-2],
  ...,
  "choice-N", [ref-column].[column-for-choice-N],
  ""
)

SWITCH() - AppSheet Help