Smart Field with Multiple References

Hi @Arda_Yurdakul

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;
      }
    }
  }],
});