I Have a datagrid and for one of the data Item I need to get value from a different table.
Was able to manage and filter the value.
But How do display that value in the data grid.
e.g I need to get the Company_Name
from this table
I Have a datagrid and for one of the data Item I need to get value from a different table.
Was able to manage and filter the value.
But How do display that value in the data grid.
e.g I need to get the Company_Name
from this table
Instead of using the filter system you can use our lookup formula, it will return the company, then you will be able to add a .companyName at the end to get only the name
lookup(boundId, companies.data, 'company_id').companyName