Custom render that calls an outside data structure

Tags: #<Tag:0x00007efc62650b48>
#1

Hello, I have the following implementation idea:
I want to have the HOT table display data from an array stored elsewhere in the javascript, would that be possible with the custom renderer? For example, I would be able to type US-2020-POPULATION into the table, and then the custom renderer would look up that key in an external dictionary, and display the corresponding numeric value. Would that be possible with custom renderer, or would it be better suited for a custom formula using HyperFormula? Greaatly apreciate your guidance. Thanks.

#2

Hey @mariothomas

Sure, you can use the cell renderer. You’d just need to have the table of references (to that numeric value) be available for the cell renderer. Here’s an example https://jsfiddle.net/ncvg1fmk/1/

#3

Thanks,@aleksandra_budnik, this solution is perfect. Appreciate it!

#4

I’m glad to hear that, @mariothomas :slight_smile:
Feel free to open a new topic when needed.

#5