within an action, if i want to display a specific value of a field by row and column, can i do this? I want to do this to display a google sheets formula total of the added numbers, but within google sheets this will not be in a field of the row of the app entry being edited. Is this what JSON is?.. and if so, how do i make this work? Thanks for any input
If you have a way to establish a relation to that other row, then you can use a lookup column to retrieve the value.
You also have the option to use a single value column, which can retrieve a single value from any column in any row of any table.
With, that said, I do have to ask why you are using a google sheet formula? Is this something that could be better served by using a Rollup column?
Thanks so much Jeff… I am kind of a novice who learns what I need to… when I need to I am not familiar with Rollup Columns… do you by any chance have a link to get details on this feature… or where on the app dashboard that I find this feature so that I can play around with it?