# User Specific Columns + User Profiles Demo **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [April 15, 2020, 2:02pm UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097 "2020-04-15T14:02:28Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Nico](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nico/32/3616_2.png) [@Nico](https://community.glideapps.com/u/Nico)\ **Post date:** [April 15, 2020, 9:39pm UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/21 "2020-04-15T21:39:12Z")
Hey @Robert_Petitto, wow I like this example of yours. I am not exactly sure how your App works, but I am fascinated by the way you are showing a picture(USA map) with different areas in different color. How were you able to do this? Do you use the already in testing available web embeed? Or do you have for every possible election results different colored pictures? The reason why I am asking is, because I am working on a gardening app. Where each users should be able to manage their plants be selecting which one is in which place in their garden. Not easy withoput drag and drop I know, tahts why I am super excited about the web embeed function and its abilities. But maybe there is another way thats why I am interested in your app. Thanks for the help. Cheers Nico ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 15, 2020, 10:57pm UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/22 "2020-04-15T22:57:40Z")
Hi Nick, I use a platform called Cloudinary that will let you manipulate images on the fly using URL parameters. So, I don’t have every iteration, no. Using a series of it then statements I concatenate the state status into a complex URL that results in the custom image. ![IMG_3334.jpg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/830599338aa65572492946dbede62cba0401eeba.jpeg) I have a few posts on Cloudinary in the forum. Take a look! ---
**Author:** ![Nico](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nico/32/3616_2.png) [@Nico](https://community.glideapps.com/u/Nico)\ **Post date:** [April 15, 2020, 11:18pm UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/23 "2020-04-15T23:18:44Z")
Hey Robert, that´s pretty genius! It ssems more convienent than i thought, thanks! 🙂 Cheers Nico ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [April 16, 2020, 2:00am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/24 "2020-04-16T02:00:51Z")
Hey buddy, great video. Have you checked if these user specific columns can detonate zaps in Zapier? Since the data is not on the Google Sheet… 🤔 🤔 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 16, 2020, 2:02am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/25 "2020-04-16T02:02:15Z")
Well, any sheet \>\> Zapier zaps are out. Glide \>\> Zapier should still work I think since Zapier is using Glide’s API and not Sheet’s. Haven’t tested though…what were you thinking?! ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [April 16, 2020, 2:08am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/26 "2020-04-16T02:08:41Z")
I was talking with a prospect about this just today… I’ll do a demo app and try it tomorrow. I agree with you, Zapier’s integration is with Glide and not with the sheet, so, in paper, it should work. Will update tomorrow. ✌ ---
**Author:** ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva)\ **Post date:** [April 16, 2020, 4:41am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/27 "2020-04-16T04:41:32Z")
Dude, I can now fully appreciate why you are one of the Certified Experts. Well done! @JackVaughan better watch out. 😆 ---
**Author:** ![matt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt/32/289_2.png) [@matt](https://community.glideapps.com/u/matt)\ **Post date:** [April 16, 2020, 7:51am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/28 "2020-04-16T07:51:26Z")
So helpful! Many thanks Robert… ---
**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\ **Post date:** [April 16, 2020, 8:42am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/29 "2020-04-16T08:42:37Z")
Super many thanks Robert! ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [April 16, 2020, 11:42am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/30 "2020-04-16T11:42:31Z")
Nice one @Robert_Petitto - this is great. Will be a little while before I do one for various reasons so awesome you’ve shown people. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 16, 2020, 11:43am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/31 "2020-04-16T11:43:49Z")
Just trying to do right by you and the rest of the Glide team. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [April 16, 2020, 12:22pm UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/32 "2020-04-16T12:22:06Z")
Yeah, let the team add the other options first 😉 ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [April 17, 2020, 1:19am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/33 "2020-04-17T01:19:06Z")
I’m trying to count the number of times a user checks off a value in a user-specific column. When I do a Rollup on the User-specific column, it just puts a 1 in every row and doesn’t seem to count each rows checkmarks individually. Am I doing something wrong? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 17, 2020, 1:43am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/34 "2020-04-17T01:43:06Z")
If the checkbox is user specific, it should work…here’s my screenshot. I have two boxes checked. ![Screen Shot 2020-04-16 at 9.42.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ce7594356533d463bbeefccbe3e9071b6b527192.png) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [April 17, 2020, 2:03am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/35 "2020-04-17T02:03:52Z")
Do you have two boxes checked for each row, or two boxes checked in the entire user-specific column? When I do this, it rolls up all the checkboxes in the user-specific column, but I’d like to know how many checkboxes are checked for each row. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 17, 2020, 2:05am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/36 "2020-04-17T02:05:42Z")
Oh…mine is in the column. I don’t know if there’s a way to do this…you might need a series of ifs that result in “1” if true. Then do a math column to add. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [April 17, 2020, 2:13am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/37 "2020-04-17T02:13:50Z")
Hmm I’m basically just trying to count the number of booleans that have been recorded for a row. I would think this is something that could be a popular thing if you create a “like” or “favourite” checkbox — it would be helpful to be able to provide users with a count of how many likes, etc. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 17, 2020, 3:12am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/38 "2020-04-17T03:12:39Z")
Right…usually, those likes count down though…not across. So, the only way to do that would be to sum them with a math column. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [April 17, 2020, 9:40am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/39 "2020-04-17T09:40:19Z")
Hmm maybe I’m thinking about this the wrong way. I have a sheet of resources and have added a user specific Boolean to the details view for the resources. If I go into Resource A and check it off (aka “like” it), my count of Likes moves to 1. Then, if I go into Resource B, the count of Likes is displayed as 1 because it’s taking into account the “like” from Resource A. This doesn’t make sense though because the purpose of the “like” was to figure out which Resource is most popular/liked. If I have to use a Math column, how would that be done if I don’t know how many possible user-specific values could be generated? What would the formula look like since all the values would be stored in the same user-specific column. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 17, 2020, 11:47am UTC](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097/40 "2020-04-17T11:47:40Z")
Hm…I think I understand now. You have a user specific column so that each person can mark it as “liked “ but you still want to total the number of likes that every user can see? [Previous page](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097.md?page=1) [Next page](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097.md?page=3)