AppFlowy-IO/AppFlowy

Fork 0

mirror of https://github.com/AppFlowy-IO/AppFlowy.git synced 2026-03-24 04:46:56 +00:00

[GH-ISSUE #8470] [FR] Add Formula, Status Property, Load Limit, and Gallery Controls #3867

New issue

Open

opened 2026-03-23 21:33:43 +00:00 by mirror · 7 comments

mirror commented

2026-03-23 21:33:43 +00:00

Owner

Originally created by @mohipa454 on GitHub (Feb 3, 2026).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/8470

Description

Based on my use of AppFlowy, I propose the following five features for a significant improvement in database functionality and user experience:

Formula Support in Databases

Enable the creation and use of Formulas within database properties. These formulas should support calculations (math, dates), text manipulation, conditional logic (if), and referencing values from other properties.
This is the backbone for building smart, dynamic systems. Users can create calculated fields (e.g., durations, totals), automatic status labels, or complex trackers (like budgets) without manual updates, greatly increasing accuracy and efficiency.

Dedicated Status Property

Introduce a new, dedicated property type called Status, distinct from a regular Select. Ideally, it would have a few fixed, unchangeable base statuses (e.g., To Do, In Progress, Done) while allowing users to create custom sub-statuses within each (e.g., Review, Testing under In Progress).

Configurable Load Limit in Grid and Gallery Views

Add a user setting (preferably in each View's settings) to define the maximum number of rows/cards loaded and displayed at once. This setting could include presets like 10, 25, 50, and 100 items, with an option for a custom value.

Customizable Card Preview Source in Gallery View

In the Gallery view settings, add a "Card Preview" section allowing users to choose the source for the image displayed on each card. Suggested options:

None (no image)

Page Cover (use the page's cover image)

Page Content (use the first image found in the page content)

[Property Name] (a dynamic source using an image from a specific File & Media type property).

Properties Visibility & Layout Control in Gallery View

Add the ability to manually select which properties are displayed on Gallery cards (Properties Visibility), instead of showing all by default. Additionally, allow the layout of these selected properties to be set as a vertical, stacked list under the card title, replacing the current side-by-side layout.

Impact

These features are critical for performance (Load Limit), professional workflow (Status, Formulas), and user-centric design (Gallery controls). They address fundamental gaps for power users seeking a robust, customizable, and efficient data management experience in AppFlowy.

Additional Context

No response

Originally created by @mohipa454 on GitHub (Feb 3, 2026). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/8470 ### Description Based on my use of AppFlowy, I propose the following five features for a significant improvement in database functionality and user experience: Formula Support in Databases Enable the creation and use of Formulas within database properties. These formulas should support calculations (math, dates), text manipulation, conditional logic (if), and referencing values from other properties. This is the backbone for building smart, dynamic systems. Users can create calculated fields (e.g., durations, totals), automatic status labels, or complex trackers (like budgets) without manual updates, greatly increasing accuracy and efficiency. Dedicated Status Property Introduce a new, dedicated property type called Status, distinct from a regular Select. Ideally, it would have a few fixed, unchangeable base statuses (e.g., To Do, In Progress, Done) while allowing users to create custom sub-statuses within each (e.g., Review, Testing under In Progress). Configurable Load Limit in Grid and Gallery Views Add a user setting (preferably in each View's settings) to define the maximum number of rows/cards loaded and displayed at once. This setting could include presets like 10, 25, 50, and 100 items, with an option for a custom value. Customizable Card Preview Source in Gallery View In the Gallery view settings, add a "Card Preview" section allowing users to choose the source for the image displayed on each card. Suggested options: None (no image) Page Cover (use the page's cover image) Page Content (use the first image found in the page content) [Property Name] (a dynamic source using an image from a specific File & Media type property). Properties Visibility & Layout Control in Gallery View Add the ability to manually select which properties are displayed on Gallery cards (Properties Visibility), instead of showing all by default. Additionally, allow the layout of these selected properties to be set as a vertical, stacked list under the card title, replacing the current side-by-side layout. ### Impact These features are critical for performance (Load Limit), professional workflow (Status, Formulas), and user-centric design (Gallery controls). They address fundamental gaps for power users seeking a robust, customizable, and efficient data management experience in AppFlowy. ### Additional Context _No response_

mirror added the

database

label

2026-03-23 21:33:43 +00:00

mirror commented

2026-03-23 21:33:43 +00:00

Author

Owner

@annieappflowy commented on GitHub (Feb 4, 2026):

We actually support 'Customizable Card Preview Source in Gallery View.' Is there anything we missed?

@annieappflowy commented on GitHub (Feb 4, 2026): We actually support 'Customizable Card Preview Source in Gallery View.' Is there anything we missed?

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@mohipa454 commented on GitHub (Feb 4, 2026):

@annieappflowy Right now, the Gallery only shows the Page Cover image on cards. I'm requesting a setting in the Gallery view that lets us choose the image from other places, like:
The first image inside the page itself (Page Content).
An image from a specific property, like a "Photo" field (Property Source).
An option to show no image (None).
This setting does not exist currently.

Image Reposition Limitation
I can use the Reposition tool to adjust an image inside a single card's cover (when I open that page). However, in the main Gallery view (where I see all cards at once), there is no way to reposition which image is shown as the main preview for a card.

"Fit Image" Not Working
Also, the "Fit Image" option doesn't work. The image shows as is and doesn't actually fit.

@mohipa454 commented on GitHub (Feb 4, 2026): @annieappflowy Right now, the Gallery only shows the Page Cover image on cards. I'm requesting a setting in the Gallery view that lets us choose the image from other places, like: The first image inside the page itself (Page Content). An image from a specific property, like a "Photo" field (Property Source). An option to show no image (None). This setting does not exist currently. Image Reposition Limitation I can use the Reposition tool to adjust an image inside a single card's cover (when I open that page). However, in the main Gallery view (where I see all cards at once), there is no way to reposition which image is shown as the main preview for a card. "Fit Image" Not Working Also, the "Fit Image" option doesn't work. The image shows as is and doesn't actually fit.

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@annieappflowy commented on GitHub (Feb 4, 2026):

Which app version did you use?
The features you mentioned are supported ☺️

@annieappflowy commented on GitHub (Feb 4, 2026): Which app version did you use? The features you mentioned are supported ☺️

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@annieappflowy commented on GitHub (Feb 4, 2026):

I will also try to reproduce the issues you reported and get back to you later.

@annieappflowy commented on GitHub (Feb 4, 2026): I will also try to reproduce the issues you reported and get back to you later.

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@mohipa454 commented on GitHub (Feb 4, 2026):

Which app version did you use? The features you mentioned are supported ☺️

I am using the latest version available for download from the official website/GitHub (v0.11.1). However, the specific controls I am requesting for the Gallery view do not appear in the settings for me.

@mohipa454 commented on GitHub (Feb 4, 2026): > Which app version did you use? The features you mentioned are supported ☺️ I am using the latest version available for download from the official website/GitHub (v0.11.1). However, the specific controls I am requesting for the Gallery view do not appear in the settings for me.

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@annieappflowy commented on GitHub (Feb 5, 2026):

Which app version did you use? The features you mentioned are supported ☺️

I am using the latest version available for download from the official website/GitHub (v0.11.1). However, the specific controls I am requesting for the Gallery view do not appear in the settings for me.

Could you please double check the version number? You can find it in the '?' icon located at the bottom right of the corner.

@annieappflowy commented on GitHub (Feb 5, 2026): > > Which app version did you use? The features you mentioned are supported ☺️ > > I am using the latest version available for download from the official website/GitHub (v0.11.1). However, the specific controls I am requesting for the Gallery view do not appear in the settings for me. <img width="1040" height="612" alt="Image" src="https://github.com/user-attachments/assets/8572f85d-7dd9-4c2c-a11b-9aa69473163b" /> Could you please double check the version number? You can find it in the '?' icon located at the bottom right of the corner.

mirror commented

2026-03-23 21:33:44 +00:00

Author

Owner

@mohipa454 commented on GitHub (Feb 5, 2026):

@annieappflowy I double-checked the version by clicking on the '?' icon in the bottom right corner, and it confirms I am using v0.11.1

However, I have discovered a critical detail that explains the discrepancy in our observations:

When I install AppFlowy using the .exe installer (for Windows), the advanced card preview settings (None, Page Content, Property Source) do not appear in the Gallery view settings. It only shows the cover image.

When I install AppFlowy using the portable .zip archive and run it from there, all those card preview options become available.

Even in the portable .zip version where the card preview settings are visible, selecting the "File & Media" property option causes an immediate application crash. The app simply closes without any error message when I try to choose a specific media property as the image source. This makes the feature unusable.

Furthermore, in both installation methods (.exe and .zip), the "Fit Image" option for cover images does not work correctly. Unlike in Notion, where "Fit" scales the image to be fully visible within the frame regardless of its original aspect ratio, in AppFlowy the image is displayed in its original crop/aspect ratio and does not properly "fit" or scale to the frame.

@mohipa454 commented on GitHub (Feb 5, 2026): @annieappflowy I double-checked the version by clicking on the '?' icon in the bottom right corner, and it confirms I am using v0.11.1 However, I have discovered a critical detail that explains the discrepancy in our observations: When I install AppFlowy using the .exe installer (for Windows), the advanced card preview settings (None, Page Content, Property Source) do not appear in the Gallery view settings. It only shows the cover image. When I install AppFlowy using the portable .zip archive and run it from there, all those card preview options become available. Even in the portable .zip version where the card preview settings are visible, selecting the "File & Media" property option causes an immediate application crash. The app simply closes without any error message when I try to choose a specific media property as the image source. This makes the feature unusable. Furthermore, in both installation methods (.exe and .zip), the "Fit Image" option for cover images does not work correctly. Unlike in Notion, where "Fit" scales the image to be fully visible within the frame regardless of its original aspect ratio, in AppFlowy the image is displayed in its original crop/aspect ratio and does not properly "fit" or scale to the frame. <img width="1299" height="385" alt="Image" src="https://github.com/user-attachments/assets/3041242e-8649-4cca-9b45-6ca1f32c4f4b" /> <img width="208" height="426" alt="Image" src="https://github.com/user-attachments/assets/b8dd59ff-89a5-4ff9-86f2-1a573fe9a150" />

mirror referenced this issue

2026-03-23 22:20:57 +00:00

[PR #3877] [MERGED] fix: calendar event editor field name overflow #5929