Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

how can i use "If" with checkbox?

113 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

zerem_0-1671564602862.png

 

4 Replies 4

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

40.PNG

This is my dataset.

41.PNG

42.PNG

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

43.PNG44.PNG

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 😊

You could try this in a formula field:

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

Screenshot 2022-12-21 at 2.12.44 PM.png

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

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.