🆕 Grouping

General
62

I get it, I guess. What would be the formula then ?
Please :mask: :sob:

63

You can use anything. Just put ‘X’ and replace ‘X’ with the value in the original date column.

2 Likes
64

4 posts were split to a new topic: Grouping function not available?

65

Hello !
Please, I have a question :
how can I add a button which groups items by something
I mean a button in which if someone clicks the items will be grouped by name on date or something ?
How can I do that ?

66

In the Data Editor
Let’s say you have a table of items and that table of items you have a category column. By indicating values in that column, you can determine if items will belong to category A, B or C for instance. Where the value is empty, the item will belong to no category.

Now in the Layout Editor
When you display the collection and source it to the table above, you will see your collection of item. In the options on the right, you can group these items by category.

You might have a number of items that are uncategorized. By using a show edit screen (for example) and then a choice component, you can assign a category to these uncategorized items. This can also be done with collection item actions, or a choice component action in table collection. Either way, the basic idea is that by triggering the action (on an edit screen or by setting a column value), you will categorize the item with a click or two.

67

@nathanaelb
What i want is create a button for my customers that will helpe them groupe the items by a category
Let’s say that when the user opens the app, will get a list of item, what I want is provide him a button that will group the list items by a specific category when he clicks on it
Can you help me with that please ?

68

I think what I described allows you to do exactly that.

69

Thank you so much !

1 Like
70

I assume you have a list of “categories” already, and you want to give the users a way to dynamically group your items based on those.

  • Add a “group by” column to your user profiles table.
  • Add a column of choices for that “group by” column in a table of your choice, I usually store it in a helper table. List them out row-by-row.
  • Add a choice component to the screen you need, then point the options configuration to the column above, write to the “group by” column in your user profiles table.
  • Go to the items table, add an if-then-else column, if “group by” is “Name” for example, return the Name column, and so on.
  • Group your collection by that if-then-else column.
1 Like
71

thank you so much @ThinhDinh

1 Like