I have a Gallery in which are a Label and a Slider control.
The Label is static. The slider value is determined when other
fields in the app (other columns in the SP List) have data.
I am currently using the following formula to adjust the slider value.
If(!IsBlank(Text1.Text) && !IsBlank(Text2.Text) && (Text3.Text)="Yes",44,
!IsBlank(Text1.Text) && !IsBlank(Text2.Text),22,0))
0 20 40 60 80 100
My current version persumes the fields used in the formula are populated
in a linear order, thus moving the slider value along its line. However, I don't
know for sure if this is true, the fields might be completed in any order,
causing my slider formula not to work properly.
My question, can the formula be restructred to simply add a predetermined
amount to the slider value whenever any of the fields have content added?
I've seen this down with a Slider control using 'Up' and 'Down' arrow icons.
This will allow the user to add content to the five fields in any order they like
and the slider will progress as desired.
Example: If(!IsBlank(Text1.Text),Slider.Value,+20,
If(!IsBlank(Text2.Text),Slider.Value,+20,
If(!IsBlank(Text3.Text),Slider.Value,+20,
If(!IsBlank(Text4.Text),Slider.Value,+20,
If(!IsBlank(Text4.Text),Slider.Value,+20)
0 20 40 60 80 100


Report
All responses (
Answers (