# Tabulator with formatter lookup
**URL:** https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767
**Category:** General
**Created:** [3 March 2025 09:40 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767 "2025-03-03T09:40:20Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@SergioRT](https://discourse.nodered.org/u/SergioRT)
#### Post date: [3 March 2025 09:40 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/1 "2025-03-03T09:40:20Z")
Hi everyone
I have included in a tabulator object this field
{
"title":"Avis",
"field": "avis",
"formatter":"lookup",
"width": "8%",
"hozAlign": "left",
"editable":true,
"formatterParams": {
"F":"Favorable",
"S":"Suspendu",
"VAO":"Visa avec observations",
"D":"Défavorable"
}
}
But it does not work : the list is not displayed
Any idea ?
Thanks
---
### Author:  [@omrid](https://discourse.nodered.org/u/omrid)
#### Post date: [3 March 2025 10:01 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/2 "2025-03-03T10:01:10Z")
In which node type are you instantiating the tabulator object: in a template node or in `@omrid01/node-red-dashboard-2-table-tabulator` ?
---
### Author:  [@SergioRT](https://discourse.nodered.org/u/SergioRT)
#### Post date: [3 March 2025 10:03 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/3 "2025-03-03T10:03:21Z")
@omrid01/node-red-dashboard-2-table-tabulator
---
### Author:  [@omrid](https://discourse.nodered.org/u/omrid)
#### Post date: [3 March 2025 11:45 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/4 "2025-03-03T11:45:07Z")
The lookup formatter shows OK
So I guess you are looking for a drop-down menu?
You need to look into the Tabulator documentation, as there are some dependencies between the field lookup formatter, editor and filter.
Check the example flow which I provided with the node, it sets a lookup with a drop-down editor & filter:
```auto
{
"title": "Gender",
"field": "gender",
"width": 100,
"headerSortTristate":true,
"hozAlign": "center",
"formatter": "lookup",
"formatterParams": {
"M": "Male ",
"F": "Female",
"U": "Unknown"
},
"editable": true,
"editor": "list",
"editorParams": {
"values": {
"M": "Male ",
"F": "Female",
"U": "Unknown"
}
},
"headerFilter": true,
"headerFilterPlaceholder": "Select...",
"headerFilterParams": {
"values": {
"M": "Male ",
"F": "Female",
"U": "Unknown",
"": ""
}
}
},
```
---
### Author:  [@SergioRT](https://discourse.nodered.org/u/SergioRT)
#### Post date: [3 March 2025 15:50 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/5 "2025-03-03T15:50:13Z")
Thanks a lot !
It is working great as I expected !
Nice job !
---
### Author:  [@omrid](https://discourse.nodered.org/u/omrid)
#### Post date: [3 March 2025 16:02 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/6 "2025-03-03T16:02:34Z")
Go up and see my previous reply, I edited the column definition, to include all 3:
- lookup (e.g. "F"-\>"Favorable")
- drop-list
- filter
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [1 June 2025 16:03 UTC](https://discourse.nodered.org/t/tabulator-with-formatter-lookup/95767/7 "2025-06-01T16:03:07Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.