# Individual Progress Bar **URL:** \ **Category:** Ask for Help\ **Created:** [August 19, 2020, 12:00am UTC](https://community.glideapps.com/t/individual-progress-bar/14162 "2020-08-19T00:00:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 12:00am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/1 "2020-08-19T00:00:57Z")
I am trying to make an individual progress bar, but I can’t get it to work. First, I tried to put a switch in a form that submits the user’s inputted value to my assignment sheet. I want the switch value to go into a user-specific column, but I can’t enter (via the form) or relate the value into the user-specific column. Am I doing something wrong, or are there any methods that I can use to accomplish my goal? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 19, 2020, 12:15am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/2 "2020-08-19T00:15:33Z")
Why do you want to put a switch in a form though? So your current setup is, let’s say you have a goal that you want multiple users to achieve, and you want to show individual progress bars based on user-specific columns? ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 12:23am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/3 "2020-08-19T00:23:16Z")
Yes, but I do not know **how** to set it up. I put the switch/checkbox in a form because I can’t select the user-specific column. I tried to relate it into the user-specific column, but that didn’t work either. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 19, 2020, 12:43am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/4 "2020-08-19T00:43:26Z")
You should be able to point a switch component to the user-specific column, or is there any problem there? ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 8:18pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/5 "2020-08-19T20:18:34Z")
I am not able to point a switch component to the user-specific column. ! ![Screenshot 2020-08-19 at 3.14.12 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bbcb08447a29c3e45f40e64772afcd8266afb464.png) . ![Screenshot 2020-08-19 at 3.14.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/ba8cc2c86a88d7334890be721992b51ab3a8b2e3.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 19, 2020, 9:25pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/6 "2020-08-19T21:25:01Z")
This is inside a form right? Why don’t you do that outside of the form? ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 10:12pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/7 "2020-08-19T22:12:20Z")
With the form, I can choose which sheet I want the input to go. If it is outside of the form I can only use the sheet for that tab. The emails and Row IDs are in a different sheet so I wouldn’t be able to use user-specific columns. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 19, 2020, 10:41pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/8 "2020-08-19T22:41:28Z")
What type of info do you capture in that column, and why does it need to be user specific? It looks like a sheet for profiles. ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 11:01pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/9 "2020-08-19T23:01:31Z")
I am capturing the user’s inputted switch value. I want to use user-specific columns so the progress bar is individual. Am I supposed to use a different feature? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 19, 2020, 11:18pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/10 "2020-08-19T23:18:02Z")
You only use user-specific columns when you need other users to interact on the same row. Is that the case here? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 19, 2020, 11:18pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/11 "2020-08-19T23:18:28Z")
A form is going to create a new row no matter what, so in most cases it defeats the purpose to try to fill a user specific column in a form response sheet. Especially if the row is already specific to a user. Nothing wrong with having them in the sheet or the concept of filling a user specific column through a form I guess, but I can’t think of a lot of scenarios where you would need to do that. A form will not update an existing row. Maybe we need a better idea of how you plan to translate a true/false switch value into a progress bar. ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 11:24pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/12 "2020-08-19T23:24:13Z")
So if I wanted to have an individual progress bar in a specific tab, the user specific column would have to be in the sheet for that tab? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 19, 2020, 11:29pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/13 "2020-08-19T23:29:15Z")
Forgetting about user specific columns and forms for a minute…what is your ultimate goal. What kind of data are you collecting and how do you want to display it. It’s hard to give a solid answer without knowing what you specific goal is. I think you are taking the wrong approach, but I’m trying to understand. What is your progress bar for? What kind of information does it represent? What is the purpose of the screen where you are trying to show this progress bar? Is it an accumulation of data for 1 specific user, or is it an accumulation of data for all users? Do you ultimately want to count the total true values where the user turned on the switch? ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 11:37pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/14 "2020-08-19T23:37:18Z")
My goal is to create a progress bar that counts each user’s assignment in a tab (I will be making three of these). I want to count the accumulation of true values, or completed assignments for each specific user, and for that count to be represented in the form of a progress bar. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 19, 2020, 11:42pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/15 "2020-08-19T23:42:24Z")
Still a little confused. Does each tab represent an assignment or does each progress bar represent an assignment? Is it showing the number of assignments one student completed, or the number of students that completed one assignment? ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 19, 2020, 11:47pm UTC](https://community.glideapps.com/t/individual-progress-bar/14162/16 "2020-08-19T23:47:28Z")
There are three tabs that hold a certain amount of assignments. The progress bar is showing the **user** how many assignments they complete. ![Screenshot 2020-08-19 at 6.46.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5dae55d6baf6ab1809fee4909a3c2cfce609e792.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 20, 2020, 12:00am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/17 "2020-08-20T00:00:17Z")
In the assignments tab, make a user-specific column that holds a boolean value. In your user profiles sheet, make a template column joining the signed-in user’s email and the true value (e.g: [a@gmail.com](mailto:a@gmail.com) true), in the assignments tab make a template column joining the signed-in user’s email and the value of the user-specific column. Create a relation matching those two columns and make a rollup using a count calculation. That should give you the number of completed assignments for the signed-in user. ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 20, 2020, 12:04am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/18 "2020-08-20T00:04:31Z")
Thanks! I will try that. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 20, 2020, 12:06am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/19 "2020-08-20T00:06:06Z")
To add to that, make a rollup in your user profiles sheet pointing to your assignment sheet, any column would work, then use a count action to take back the total assignments you have in the app. Then make a progress bar with the two rollups. ---
**Author:** ![Austin\_Urban\_Technol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/austin_urban_technol/32/11241_2.png) [@Austin\_Urban\_Technol](https://community.glideapps.com/u/Austin_Urban_Technol)\ **Post date:** [August 20, 2020, 12:11am UTC](https://community.glideapps.com/t/individual-progress-bar/14162/20 "2020-08-20T00:11:42Z")
Got it. Thanks again! [Next page](https://community.glideapps.com/t/individual-progress-bar/14162.md?page=2)