# Available for copy: Newest form choice, progress bars & joined texts concept **URL:** \ **Category:** Project Showcase\ **Created:** [August 27, 2020, 11:28am UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799 "2020-08-27T11:28:20Z")\ **Posts on this page:** 17\ **Page:** 2
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [January 7, 2021, 11:16am UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/21 "2021-01-07T11:16:19Z")
> [@User Experience Revamped with Custom Actions!](https://community.glideapps.com/t/user-experience-revamped-with-custom-actions/19312): > > I tried using various actions to improve the workflow in one of my apps [Pluhg](https://gopluhg.com/) and it works so beautifully. It has completely redefined the user experience and will probably make more users stick to the app because of its ease. I have said this multiple times before that the Actions in Glide are the most powerful feature upgrade yet! And they are just beginning!! This is how I do the same thing now with Actions ---
**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:** [January 7, 2021, 4:12pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/22 "2021-01-07T16:12:04Z")
> [@Darren\_Murphy](#): > > I suspect that if @ThinhDinh was to re-create this app now, he’d probably do the same thing 😉 Fully agree. ---
**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\ **Post date:** [February 5, 2021, 11:20pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/23 "2021-02-05T23:20:16Z")
> [@ThinhDinh](#): > > # 5/“Textjoin” inside Glide > > You may have faced a situation where you have to join multiple columns of text to give a good display, but your array doesn’t always have the same sizee. This is when you collect many fields of the same category in an array column via form (i.e Activities 1, Activities 2, etc.) without all columns required. > > With the new Joined List column, we can do this inside Glide. > > First, create a multple relation matching the array column back to the Choices sheet, then make a joined list column using that relation and separate them with a delimiter, in this case I use the default comma. > > With that setup, I can use them in a template column to display the text inside the details view. > > However, this approach would only work when you have a reference choice list to relate back. When you take random values from users, there must be a further step to combine all of user inputs into a column for this to work. Hey @ThinhDinh this is a super cool feature, I’d love to copy it if possible. Is this app still available? The link in the original post seems to be “not found.” Would this join text feature work with check boxes or just text entry/choice components? I have users selecting check boxes for things that apply to them and am trying to find a way to display these choices gracefully. ---
**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:** [February 5, 2021, 11:34pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/24 "2021-02-05T23:34:20Z")
I think I have deleted this a while ago, sorry for that inconvenience. For your case, you can create: - A template column that holds the value “true”. - Make a relation of that template column to the user-specific boolean column. - Return the title of the checkboxes in a joined list column, in whatever format you prefer. I usually use a “new line” character. ---
**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\ **Post date:** [February 5, 2021, 11:45pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/25 "2021-02-05T23:45:56Z")
Thanks so much, I’ll try that out 😃 ---
**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:** [February 5, 2021, 11:50pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/26 "2021-02-05T23:50:51Z")
I use the Joined List column in the examples here, if that helps. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… ---
**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\ **Post date:** [February 5, 2021, 11:58pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/27 "2021-02-05T23:58:10Z")
Hmm, I’ll read it closer later but I don’t think so…? I’m looking for an alternative way to display selections instead of what I have below, the check boxes are redundant if I can get it to just list the things selected. Unless I’m misunderstanding where you’re pointing to. ![Screen Shot 2021-02-05 at 3.57.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/438688e6cce7d1d239935a7426f6f27a3a1d766a.png) ---
**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:** [February 6, 2021, 12:15am UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/28 "2021-02-06T00:15:41Z")
Below my list is a rich text component that is built from all of the items that were selected in the list. ---
**Author:** ![GioRinaldi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/giorinaldi/32/11069_2.png) [@GioRinaldi](https://community.glideapps.com/u/GioRinaldi)\ **Post date:** [February 6, 2021, 3:35pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/29 "2021-02-06T15:35:52Z")
Sorry man, is the link not working? Thanks Gio ---
**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:** [February 6, 2021, 3:42pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/30 "2021-02-06T15:42:56Z")
@GioRinaldi > [@ThinhDinh](#): > > I think I have deleted this a while ago, sorry for that inconvenience. ---
**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:** [February 7, 2021, 1:38am UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/31 "2021-02-07T01:38:26Z")
If you have any specific needs just leave a comment here, we’ll try to help. ---
**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\ **Post date:** [February 7, 2021, 4:29am UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/32 "2021-02-07T04:29:43Z")
> [@Jeff\_Hager](#): > > Below my list is a rich text component that is built from all of the items that were selected in the list. Oooh! I see what you’ve got there, that’s great. I’ll see if I can incorporate that list. I do like the clear all component as well. Thank you! ---
**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\ **Post date:** [August 9, 2021, 10:10pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/33 "2021-08-09T22:10:58Z")
I emailed you about this Thinh Let’s say I have 20 forms inside my app. Each form when completed adds up to 5% to a total 100% once all of the forms are complete. If I understand you correctly, let me know if this looks correct: - Add a Progress column and a Date Column to Each of 20 forms - When a form is submitted, increment the progress by 5 - Create a rollup column which adds all of the individual forms progress, for an overall progress? Does this make sense? I think i explained it better in the email I sent you… ---
**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 9, 2021, 11:24pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/34 "2021-08-09T23:24:07Z")
Replied to your email 😉 Please check it and let me know your thoughts. ---
**Author:** ![Blue\_Community](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blue_community/32/16616_2.png) [@Blue\_Community](https://community.glideapps.com/u/Blue_Community)\ **Post date:** [August 10, 2021, 6:15pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/35 "2021-08-10T18:15:01Z")
Thank you Thinh… much appreciated… ---
**Author:** ![Fer\_Ele](https://avatars.discourse-cdn.com/v4/letter/f/f1d935/32.png) [@Fer\_Ele](https://community.glideapps.com/u/Fer_Ele)\ **Post date:** [July 13, 2023, 2:40pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/36 "2023-07-13T14:40:51Z")
> [@ThinhDinh](#): > > [https://interesting-history-7076.glideapp.io/](https://interesting-history-7076.glideapp.io/) Hi, this link is not working anymore: [https://interesting-history-7076.glideapp.io/](https://interesting-history-7076.glideapp.io/) Do you have any other to show how to apply a filteres form choice like the one in choose your car? Many thanks! ---
**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:** [July 14, 2023, 12:54pm UTC](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799/37 "2023-07-14T12:54:30Z")
It’s a very old app. You can do it easily with choice components now though. Assuming you have a structure like this: TABLE 1 | Category ID | Category Name | | --- | --- | | ID001 | Apple | | ID002 | Banana | | ID003 | Orange | TABLE 2 | Category ID | Sub-category ID | Sub-category name | | --- | --- | --- | | ID001 | S001 | Red | | ID001 | S002 | Green | | ID001 | S003 | Yellow | | ID002 | S004 | Yellow | | ID002 | S005 | Blue | For the first choice component to choose the category, you write the category ID to the destination column. For the second choice component, point the choices to the sub-category table. Filter by category ID is this screen \> category ID, and visibility set to category is not empty. [Previous page](https://community.glideapps.com/t/available-for-copy-newest-form-choice-progress-bars-joined-texts-concept/14799.md?page=1)