How to set dynamic value in sublist as hyperlink in suitelet
I have created a suitelet to show the sales On the basis of the Two Field that is “Start Date” and “End Date”. on the basis of the these date all calculation happen and report get generated as table like –
| Customer Cohort | Total | Average | Jan-20 | Feb-20 | Mar-20 | Apr-20 | … |
| Jan-20 | $ 570,000.00 | $ 114,000.00 | $ 100,000.00 | $ 90,000.00 | $ 80,000.00 | $ 100,000.00 | |
| Feb-20 | $ 415,000.00 | $ 83,000.00 | $ – | $ 200,000.00 | $ 50,000.00 | $ 65,000.00 | |
| Mar-20 | $ 270,000.00 | $ 54,000.00 | $ – | $ – | $ 50,000.00 | $ 20,000.00 | |
| Apr-20 | $ 340,000.00 | $ 68,000.00 | $ – | $ – | $ – | $ 40,000.00 | |
| … |
Now I want that each and every value except in Total and Average should be a hyper link. so user can click and see the corresponding details from there.
Please suggest how can we do this….
