Data set and text display

Ask the community
,
1

Hi everyone, I wonder if I could get some help on this please.

I have a set of data which is already imported inside, and what I want to do is to utilise a slider to display the individual number or values.

I wish to connect the slider value to the “age next birthday” (column 2) value from 1-100
and the text to display whatever is in “AXA shield Plan A” (column 3) as accordance to the same row as “age next birthday” (check below images for values)
age next birthday 1 = AXA Shield Plan A 148
age next birthday 100 = AXA Shield Plan A 9865

1259×565 37.3 KB

1286×641 45.2 KB

I have tried it with some errors.
Below is in web editor mode, the pink text is what I have linked the value

900×406 2.89 KB

I have tried various methods to link with the datasets as elements:
One is Dataset (Write only) “AXAShieldApr2019 dataset”
Second is Form data set (read only) “AXAShieldApr2019 dataset 2”

424×614 32.6 KB

418×606 33.7 KB

I tried linking the slider to “age next birthday” column with Dataset (Write only) “AXAShieldApr2019 dataset”

1090×481 34.1 KB

And the test value to “AXA Shield Plan A” Form data set (read only) “AXAShieldApr2019 dataset 2”

704×388 26.2 KB

When published, the test value I get the largest number in the value of column “AXA Shield Plan A” @ Age next birthday 100

934×430 2.76 KB

I did a trial and error but cannot seem to get it work.
The text value I am looking for is:
When slider is at 1,
age next birthday 1 = AXA Shield Plan A 148

When slider is at 100,
age next birthday 100 = AXA Shield Plan A 9865

Appreciate if anyone can help me on this.

Thank you!

2

Update 1:
I realised that coding may be required from this. I have took a programming module from school years back, but my knowledge of coding is extremely basic…

I may need an “if…else” coding

If slider is at 1,
age next birthday 1 = AXA Shield Plan A 148
else
If slider =2
age next birthday 2 = AXA Shield Plan A 148
.
.
.
.
if slider is at 100,
age next birthday 100 = AXA Shield Plan A 9865

Thing is that I need some help or tutorials on this, especially to obtain the names of the elements, wonder if anyone could help!

Any help is greatly appreciated! Thank you!