Get the value from other tables cells

[deek-7f46]

Hi how could we fetch values from other tables cell values as
=Customer!A2( as in excel)

[DanielTet]

hi @deek-7f46, glad you are trying out honeycode and this forum,

Yes it is possible to use cell coordinates like you do in Excel. I have used it in a prototype to refer to some help text that I kept in a table. You can read more about it here:

Formula Syntax

Formula basics Formulas are expressions or equations that can be used to perform calculations and return information. They can range from basic math calculations to complex data manipulation. Formulas can contain references to: Cell values Operators Tables & columns Functions Conditions In Honeycode, the biggest game-changer is that formulas are also used to reference objects in your app. Formula syntax Syntax refers to the structure and order of a formula, including functions, references,…

However we recommend you use the actual column name in general as it is more flexible. Even in my case I've eventually switched to a column based approach and used the findlastrow() to find the actual row from where I wanted to take the value.

It may help to think of the tables in Honeycode as tables in a database with relationships rather than static fields on a spreadsheet. You can create lookup tables and use the find and filter commands to pivot into other tables, or select certain rows in a display.

Here are more resources on Find* and Filter functions:

• FindRow: A Better VLookup
• FindLastRow( )
• Filters in Honeycode

I don't know your exact use case but hopefully this will give you some pointers.
Cheers,
DT.