Solved: Row Column Value From Row Key - Page 2

Connor_Allen · 02-01-2022 05:55 PM

Hello all,

I haven't been around App Sheet too long, and this is my first post, so I may be missing some easy method to this. I'm curious if there is any other way besides a LOOKUP() or SELECT() to retrieve a specific column's value from a row if I have that row's key. I've looked around the documentation and haven't had much luck in what I'm looking for, but I could be missing it.

I'm working on putting an app together that builds upon the idea that is talked about in this post: https://community.appsheet.com/t/manual-sorting-move-items-w-buttons-bonus-sequential-numbering/4108..., and I'm hoping to alter some other columns of mine when a row is moved. However, when I move a row, I'm hoping to use a value from the previous row (or next row depending on the case) in order to update my current row's values and the previous row's values appropriately. For static changes this works great, but I'm hoping to get the value of a row's Price column when I have the row's key.

I hope I've made sense here. Any help would be greatly appreciated!

Joseph_Seddik

@Connor_Allen wrote:
and then putting .[columnValue] at then end.

This doesn't work. You have to follow the syntax of the expression. You first have to do your "manipulations" and store the result in a column, then use this [column name] in the dereference expression.

View solution in original post