I don’t have a lot of free time to create an app from scratch to show with screenshots. Where in my description are you stuck?
Then create an IF column that will compare that completed question count for the level and compare it to the number 5. If the rollup count equals 5 then return ‘true’. Then you can create a custom action on the level list that contains an If statement and will check that IF column value in the table to see if its ‘true’. If it’s true then the level is complete and you can show a notification. Else you can have an action to Show the Details screen of that level.
Did you create an IF column that checks if the rollup column value equals 5?
yes. @Jeff_Hager like this know ?
yes, but type in ‘true’ the THEN spot. For the ELSE, you can leave it blank or type in ‘false’ if you want. Now if the count is equal to 5, it will return ‘true’, so you will know that the level is complete.
Ah ok. I created the column
@Jeff_Hager
Then what should I have to do?
The next step. Create a custom action on the Level list.
I have to create that IF column in questions sheet know?
Sorry for disturbing you @Jeff_Hager .
No, you create a custom action, like I specified above, on the Levels list.
@Jeff_Hager can you tell me what has to be included in the custom action?
An IF condition that checks if the IF column you created in the Levels sheet is ‘true’. On the true branch add a notification action that says the level is complete. On the Else branch, add an action that shows the details screen of the level. Did you go through the documentation on custom actions…especially the Conditions section? It’s up to you what you want to happen when you select a level, but based on your description, this is what I would suggest.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.