how can i use "If" with checkbox?

791 4
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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 4
8 - Airtable Astronomer
8 - Airtable Astronomer

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 😊

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"?

6 - Interface Innovator
6 - Interface Innovator

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.