Hi guys, as I work with my latest apps, I discovered some tricks that may help with your app design, so I thought it would be nice to share. App link: https://interesting-history-7076.glideapp.io/ 1/Filtered form choice Very recently, it seems Glide has added support for filtering choices within a form, so in this concept app I applied it to two cases: Filter a choice based on a previous choice in the same screen: You can find in the car choice that the car model will be filtered based on the car make. Prevent duplicate choices for different choice components: You can find in the activities/food preference choices that when you have selected activity X for activity 1 field, it will not be in the choice list for activity 2 and vice versa. Same applies for the food choice components. [image] [image] 2/Progress bar for forms Many of us have forms that are very long, and it would be nice to have sections inside the form like Google Forms. In this app, I do it by creating a number column called “Progress” from Glide’s data editor so it would honor the number format. I also create a datetime column from Glide’s data editor. How would there be progress bars when there’s actually no progress? The answer is by changing the max and min value of the progress bar. The progress bar takes value from the previous screen, and as I never write the actual progress number to the Sheet, it will always be 0. [image] [image] With 2 sections, and a progress number that will always be 0, the 1st progress bar would have a min of -1 and max at 1 so it will show a 50% progress. With the 2nd progress bar, it will be a min of whatever you want and max at 0. Same process applies for forms that would take more sections. 3/Navigation between sections Navigation would include “Next section” and “Previous section”. Different to the progress bar, which takes the value from the previous screen, these navigation buttons can increase a value inside the form, which is also set to Progress. For the first screen, there will be 2 scenarios: either the progress is empty (at the start), or it equals 0 (when a user navigates backwards). The first “Next section” button will be tied to an increment action for progress column, and as we also have to take into account the condition that each field in the section must not be empty before a user can go to the next, there must be 2 buttons for the 2 scenarios mentioned above. (as we can not do and + or at the moment) For “Previous section”, only 1 button is needed, and it will show up when Progress is greater or equal to 1. 4/Cards without images & grouping As you may have noticed, cards can now be configured without images and it gives a lovely nice look. [image] I also used a grouping action on the preferred date column to show an alternative view for a “calendar”. 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. [image]

Just use a filter condition on something that you know will never be true.

Hey @Darren_Murphy, Wish you a very Happy Birthday! :blush: Tried that but than Submit sign is enabled as the text entry is filtered out.

oh yeah… haha sorry, my bad. Didn’t think that one through :crazy_face: Okay, so I guess what @Manan_Mehta is saying is if you put a Text Entry component at the bottom of the screen with no Title and no Placeholder, it will just appear as a horizontal line at the bottom, so users may not even notice it. You could set it to write to a dummy User Specific column, just in case somebody puts something in it. Not a great solution, but would work. Personally, I just prefer to create my own forms - then you don’t have this problem as you have more control. I suspect that if @ThinhDinh was to re-create this app now, he’d probably do the same thing :wink:

[image] User Experience Revamped with Custom Actions! Ask for Help I tried using various actions to improve the workflow in one of my apps Pluhg 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

[image] Darren_Murphy: I suspect that if @ThinhDinh was to re-create this app now, he’d probably do the same thing :wink: Fully agree.

[image] 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.

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.

Thanks so much, I’ll try that out :smiley:

I use the Joined List column in the examples here, if that helps. [image] Reset Multiple Rows At Once Project Showcase 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…

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]

Available for copy: Newest form choice, progress bars & joined texts concept

Project Showcase

Jeff_Hager February 5, 2021, 11:50pm 26

I use the Joined List column in the examples here, if that helps.

Topic		Replies	Views
Multirow Choice Component (aka Chips UI) Feature Requests	156	9452	October 8, 2021
🎤 We'll Do It Live - Episode 5 General	117	3354	July 22, 2021
🌪 Use Multiple Choice Components to Filter an Inline List Community Resources tutorial	201	13804	October 18, 2024
Shouldnt I be able to choose this LookUpColumn? Project Showcase	41	924	July 24, 2022
Choice Component - multiple selections Ask for Help	65	9370	December 24, 2022

Available for copy: Newest form choice, progress bars & joined texts concept

Related topics