Dereferencing with Expression Return Value

AppSheet AppSheet Q&A
1

Is it possible please to dereference directly using a return value, in the same expression, instead of storing the returned value in an additional column?

Example:

  • additionalColumn app formula is: ANY(some list of keys)
  • another column’s app formula is: [additionalColumn].[desiredColumnValue]

Is there a possible single-expression equivalent for the two expressions above? something like:

ANY(some list of keys).[desiredColumnValue]

Thank you!

2

Nope

2 Likes
3

OK. Thanks much!

1 Like
4

That’s the best solution I’ve seen!

2 Likes