How to set mapped options based on a datasource

[DavidM]

I have a table with a status id that I want to map to human readable tags with colours and icons

Is this possible to do with a data source instead of manually adding entries for each table that has this ID?

I've tried playing around with various array and object formats, but have had no luck

Has anyone else managed this?

Thanks,

David

[minijohn]

Hi @DavidM,

I would use a transformer to store the mapping and use the tag column with the mapper set to the transformer:

return [
  {status: 100, label: "new", color: "blue", icon: "/icon:bold/interface-alert-alarm-bell-delete-alternate"}
]

Let me know if that works for you

[DavidM]

@minijohn

return [
  {status: 100, label: "new", color: "blue", icon: "/icon:bold/interface-alert-alarm-bell-delete-alternate"}
]

Thanks so much @minijohn
That's working great for me.

Cheers,

David