Skip to main content

how can i use "If" with checkbox?

  • December 20, 2022
  • 4 replies
  • 112 views

Forum|alt.badge.img+7

Hey friends
I want to create a star rating in the system based on V in existing checkboxes.
That is, if you watched video 1 - one star.
If you also watched video 2 - 2 stars
And so on.
How can you create such a thing?
That is, an IF that depends on a checkbox.

Thank you!

 

4 replies

Forum|alt.badge.img+16
  • Inspiring
  • December 20, 2022

Hi, You can set up a series of automation, one for each video.

This is my dataset.

This automation will update when you click the checkbox "video 1".

This is for video 2, and you should set up the same for videos 3, video 4, and video 5.

Let me know if you have any questions 😊


TheTimeSavingCo
Forum|alt.badge.img+31

You could try this in a formula field:

IF({Video 1}, 1, 0) + IF({Video 2}, 1, 0)


Forum|alt.badge.img+7
  • Author
  • Known Participant
  • December 21, 2022

You could try this in a formula field:

IF({Video 1}, 1, 0) + IF({Video 2}, 1, 0)


and is it going to bring the "stars rating"?


Forum|alt.badge.img+7
  • Author
  • Known Participant
  • December 21, 2022

Hi, You can set up a series of automation, one for each video.

This is my dataset.

This automation will update when you click the checkbox "video 1".

This is for video 2, and you should set up the same for videos 3, video 4, and video 5.

Let me know if you have any questions 😊


good idea!

but it has to be 1 star for 1 video - I mean if someone jumps straight to video 2 - he doesn't have to get 2 stars but only 1.