Get field value from linked record

Java Script
#1

Hi,
I select the Project name from the Project table in the Timesheet form (table). How to get the value of the Project type field for JavaScript in the Timesheet form from the Projects table? Checkbox Load for JavaScript option in select fields for link does not work.?
Jan

#2

Hi,

If you checked the Load for JS option (Select fields for link), you should be able to use doo.table.getData to query the data from the linked table.

How to get data from the Owner(email: load for JS option) table and set setValue.
const owner = await doo.table.getData(‘owner’,{filter:email_2(eq)${doo.currentUser.login}})
doo.model.owner.setValue(owner.data[0].id);