Can you reference a specific cell ID in a grid layout?

Ask us anything
1

Hi,

I have a grid layout with many rows and columns. Is it possible to refer to specific cells in formulas?

For example, if I have data in the top left (cell A1, if it were Excel) and I wanted to check if it was larger or smaller than the value in cell E7, how would I do that? I want to do more complicated stuff–I just need to figure out how to get the reference for the formula builder.

These different cells are not in a collection, as they come from different data sources.

Thanks!

2

Hi Dhew! Data is referenced by variables or collections, not by grid position like a spreadsheet (A1, E7, etc.). So instead of referring to a cell’s visual position, you’d access the variable or data binding linked to that part of the layout, for example by → row_id.value_A1

Maybe you can show us what’s your use case or share screenshot to understand better what is it you’re trying to achieve.

3

Hi,

Sure, I posted about it yesterday here as well.

But this question is just to see if an approach to solving the larger challenge is possible.

Put simply, if you were trying to have unrelated data (in terms of database relation) reference each other across a grid, how might you do it?

In my specific case, I have a calendar…so cells in columns that visually correspond to a day and a time of day (one cell might ‘mean’ Friday at 9am, for example,). And I have rows across those columns from a data collection that represent specific database items (boats).

What might be a good way to work with formulas in each individual cell (row+column ‘mapping’), so I can conditionally alter them?

For example: "
Boat 1" (in row 1) has no ‘bookings’ (another collection/data item) this Friday at 9am (column 6). Show nothing in row 1, column 6.

But “Boat 2” (in row 2) does have a booking at that time, so indicate that (shade it a different color, show an icon, etc.) in that specific cell: row 2, column 6 (i.e., it can’t float ‘up’ to the row 1, column 6).

Lastly, there will be roughly 600 cells visible in the end (multiple boats x multiple ‘time slots’ x ‘days of week’), so creating individual variables would not be practical!