That’s indeed possible.
I looked at your previous posts (Table with No PK) and will suppose you are using forest-express-sequelize
Here is a code sample I wrote based on the information in your post:
const { collection } = require('forest-express-sequelize');
const models = require('../models');
collection('a_collection_name', {
fields: [{
field: 'owner_display_name',
get: async (record) => {
if (record.owner_type === 'Operator') {
const operator = await models.operators.findByPk(record.owner_id);
return operator.name;
} else if (record.owner_type === 'Team') {
const team = await models.teams.findByPk(record.owner_id);
return team.name;
} else {
return null;
}
}
}],
});