Some great ideas here already! Here are some of my main niggles and wants (in no particular order because everything on this list would be really helpful):
Lock Fields (See: Lock Fields to Avoid Accidental Editing)
I’d love to be able to lock fields after they’ve been filled or based on the state, etc. to avoid accidental changes to fields that need to be visible but shouldn’t be edited after a certain point.
Lock Entity by Rule (See: Lock Entities from Automations or State)
For example, when marked as final state, lock the entity.
Filters: Personal Filters & Quick Filters
I think View filters needs some work in general. These need to be quicker and more intuitive for non-technically-minded users. Quick filters have so many limitations and you often need a LOT of them so it just becomes visual overload.
- On the grid view, I’d like users to be able to filter each visible field similar to how you can with an Excel table, for example. This is pretty common functionally, so users are used to it.
- Also, in personal filters, it would be better to be able to choose which fields users can filter so it’s not overwhelming. Currently they see all fields, including a lot of helper fields that are irrelevant to them.
Fix Hide Empty Groups
This would be such a great feature–but it doesn’t work when you’re changing the filters, which makes it functionally useless for us! I’d absolutely love a fix.
Logic In Date Fields
If I have two dates, Start and End, I want the End date to always be after the Start date, or maybe the End date to always be within 7 days of the Start/Created date. Therefore, I’d love some simple date options such as:
- Date must be after: choice of field (i.e. Start), or relative dates as already used in filters.
- Date must be before: as above.
Formulas in More Areas
Being able to use formulas in Filters would stop so much helper field clutter. It would also be extremely useful in automation rules.
Rule If Logic / Branching Paths
Or even just filters for each Action of an Automation, because sometimes I only want to do a second action for some items, which means creating a whole new Rule atm. It would help with clutter and limits to be able to keep several related things in one Rule.
Show More Fields in Relations, etc.
In large lists, there may be more than one entity with the same name. Icons help a bit, but I want to use different icons in different scenarios and I can only choose one. Therefore, I’d love to be able to show other fields, or perhaps group fields (like tasks per stage, or per assignee). Showing more fields would also be useful when searching entities.
Forms
Forms would be so useful, but they currently aren’t in most cases because:
- You cannot filter or sort fields.
- There’s no if logic or branching.
- You can only use one database. [I’ll use the example of setting up a new project: To keep it simple let’s say I need to add the client as a contact (1 database), then create the project (a second database). A form would make setting up a project a lot easier for users.] Being able to add more databases, perhaps as separate pages so the previous item would save and allow for linking of the entity to the next new form item, would make forms so much more useful.
Show Field If
We have several databases where entities may need slightly different fields based on (for example) their type.
View Permissions
I have several fields which a general user doesn’t need to see. I can move these to another View, but to keep things simple for general users, I would like to be able to hide these ‘Admin’ views from non-Admins as they can get quite complicated.
Hide + New Button
If a user has View access rights only, any + New buttons should be hidden for clarity. It’s still visible on Grid view.
Calendar View
I’d love to be able to hide weekends (as a business that doesn’t work weekends it would give more screen real estate).
Timeline View
- To to create a Gantt-type view like showing tasks under stages, I currently have to create a complicated ‘Order’ formula and sort on this, otherwise the two databases show after one another (so all stages then all tasks, or vice versa).
- A button to move to the previous/next visible entity would be good for when you’re looking at historical/future items.
Dependencies
A great start with dependencies, but I’d love to see it expanded beyond timeline view. Tasks often require dependencies, but if you prefer to see these in a Grid or List view, then dates won’t change and update. I’m currently sticking with a complicated formula with several helper fields.
Documents
This one isn’t a priority for me, but would still be useful.
- In Notion and Loop, you can drag and drop paragraphs/blocks. This would be useful because if I’m copying and pasting something with certain formatting (like a callout or quote), it can be a difficult to get it to copy to where I need it without it messing up.
- Tables could do with some work as well. If I copy a table from elsewhere, it sometimes brings formatting that I can’t change. This means I have to create everything from scratch. Being able to freeze rows/columns and mark as header, etc. with different formatting easily would be great too.