Make Rating Mandatory

[andy88]

Hi, 

I have a star rating system from 1-5, when we refresh the page the ratings should clear and be set to the default of 0. However we do not want anyone to skip those questions and output a rating of 0 so would like the button to move to the next page to be disabled when the rating is 0 (rating not filled in). 

Any help would be great. 

[timl · Accepted solution]

Hi @andy88

Assuming that your button calls the Navigate function, you can wrap this in a conditional statement to prevent the navigation when the rating value is 0. The formula would look something like this:

If(Rating1.Value <> 0, 
    Navigate(YourOtherScreen, ScreenTransition.Cover), 
    false
)

[andy88]

Thanks for the reply. 

The button actually patches to my SP list rather than Navigate. 

Can I use 

If(Rating1.Value <> 0,

 part of the code to prevent the patch? 

[timl]

Yes, you can use that syntax to prevent the patch.

[andy88]

Hi would the code be like this: 

If(Rating1.Value<>0, Patch(
    SPList,Defaults(SpList),
    {Columnname:Dropdownname.Selected.Value}
   )),false

Not sure if this is right?

[timl]

I think your closing bracket is in the wrong place, but assuming that your rating control is called Rating1, then this code should work.

If(Rating1.Value<>0, 
   Patch(SPList,Defaults(SpList),
         {Columnname: Dropdownname.Selected.Value}
   ),
  false
)

[andy88]

Thanks, got it working so that it won't navigate or patch when the rating is 0.