Check Box + If / Else Skip a Screen

Ask for Help
21

Does every user see the same video and they won’t see it again after they check the box?

22

Her’s a couple options:

Option 1: This will work if your home screen is the user profile sheet. If not, try the second option

  • Add a template column in the user profile sheet that will contain the video link.
  • Add a user specific boolean column that will hold the checked value once a user has watched the video
  • Add a button with a ‘Link to Screen’ option that is further set to ‘This Item’. This will allow you to create a subscreen of the user profile screen where you can place only the video and the checkbox.

Option 2:

  • Set up to sheet that contains the video link to also contain a user specific boolean column that will hold the checked value once a user has watched the video
  • On your home screen sheet, create a template column with the value of ‘true’
  • Create a relation column that links the template column to the boolean column in the video sheet.
  • Set visibility on the button to only show if the relation ‘is empty’

Option 3:

  • Do the same as option 2, but instead of a template and relation column, just use a single value column that will pull the user specific boolean value from the video sheet. I would think this should work.

Basically you cannot write to a column outside of the sheet you are viewing. You also cannot set a boolean column on sheet based on a value elsewhere. You can only bring in the value via Single Value or Relation/Lookup.

1 Like
23

Hey Jeff,

Option 2 worked with the addition of an If Else to get the value out of the boolean, then relate to it.

Thanks @ThinhDinh too.

Andy

2 Likes