Showing ideas with label Base design.
Show all ideas
Submitted on
Jun 19, 2020
12:43 AM
Submitted by
Richard_Foxwort
on
Jun 19, 2020
12:43 AM

It’s not useful to have the history record for records display in ‘days ago’ or ‘months ago’.
Much more useful to display the actual date.
Rationale is that when looking at history, its very likely you’ll be auditing or reconciling events on that record, so seeing that a record change happened ‘3 months ago’ is not at all useful.
I’ve discovered through this forum (thanks @ScottWorld !) that you can hover to see the detail, but why force users to d that? Much better to show actual date, potentially useful to hover to reveal time which can sometimes also be useful.
Cheers
... View more
Submitted on
Jun 18, 2020
11:15 AM
Submitted by
Sal_Ohcin
on
Jun 18, 2020
11:15 AM

For those with LONG records (such as >30 fields)…
Wouldn’t it be nice to VISUALLY break up the record in a way such that you know where you are in the record?
I routinely work on a database that has approx 60 fields per record. The new Conditional Forms field on Airtable has been a lifesaver and is a GREAT upgrade.
However, when you are NOT entering the data in the “Form”, but rather looking at the record in the Grid view, you still see all the fields and it can be overwhelming to scroll through them all. (And in my case, creating a different view with some fields turned OFF is not a good solution)
My idea would be to add horizontal divider lines and/or spacers to visually break up the record to allow you to see where you are within the record.
Alternative #2, have vertical colored lines that run along the side of the opened record which signal where you are in the record. (You could choose the color label when you create the field).
See example below:
... View more
Submitted on
Apr 24, 2020
11:52 PM
Submitted by
ScottWorld
on
Apr 24, 2020
11:52 PM

When grouping records, we should be able to sort the groups by those little “summary fields” instead of ONLY being able to sort by the grouped field itself.
In other words, we could group our records by PROJECT NAME, but then sort the groups based on whichever group has the “newest date” or whichever group has the “highest total dollar amount” or whichever group has the “largest number of projects” or whatever.
We can already choose all of these options by clicking on those little “summary fields” which appear in the group headers — but we’re not able to sort on those “summary fields”. So we’re allowed to display these “summary” options onscreen, but we’re not allowed to sort by them.
... View more
Submitted on
Apr 11, 2020
03:48 PM
Submitted by
typo
on
Apr 11, 2020
03:48 PM

I posted this in a comments thread, but I wanted to re-post it as a product suggestion:
For reporting purposes, it would be helpful to be able to break apart one-to-many (or many-to-many) data links . I understand that AirTable doesn’t want to duplicate records, but maybe AirTable could add a block feature or a reporting/export feature which would let you break apart the one-to-many (or many-to-many) relationship and then export that report as a CSV? (The Pivot table kind of accomplishes this, but there’s no way to export the data into a spreadsheet or view it item by item). Bosses and supervisors often want these kinds of reports. Right now, I generate the report by creating a script in integromat which parses out the data and then moves it into a google sheet. But that solution is a fragile and I have to hand adjust the script for each new table. I’d love to have a quick way to generate this report. (Yes-- I know I could achieve this by adding/linking additional tables for each and every one-to-many or many-to-many relationship, but that would require completely restructuring my data and adding dozens of superfluous tables-- tables which would ONLY exist for the purposes of generating the report. It makes much more sense for AirTable to provide a quick way to parse, view, & export the data).
... View more
Submitted on
Apr 07, 2020
02:59 PM
Submitted by
Ash_Nazarizadeh
on
Apr 07, 2020
02:59 PM

One thing that is currently missing in Airtable is the concept of a Current Row. This would be the current row of each table that is currently in the base. Current Row of a table could be used in filters to filter in only the children of a parent record (e.g. Order Header and Order Items). This would make the creation of applications much easier. There are many other use cases.
... View more
Submitted on
Mar 16, 2020
05:30 PM
Submitted by
Jess_Sand
on
Mar 16, 2020
05:30 PM

I love the new Base Schema block. As a content strategist, it has some really great potential applications. The degree of control in the settings, however, is far too limited to be useful for complex bases—which is likely to be a major use case. Some controls I’d need to have to be able to put this to practical use (in order of priority):
Select which tables within a base to map
Choose to map all fields, or only non-hidden fields.
Apply specific colors to connection types that persist, not just on rollover
Apply specific line type (e.g. dashed, dotted, solid) to connection types that persist, not just on rollover
Additionally, I’d love to see the following enhancements:
Export to PDF or PNG (table stakes for any visualization, if you ask me)
Bézier control over the line curves
I so want to be able to make good use of this block, and will continue playing with it in more simple bases. From my limited interaction so far, it’s not super usable for the types of bases it would be truly useful for. I do love that I can rearrange the position of the tables, and the interactivity of the lines is nice (though feels like secondary importance to some of the stuff in my list above).
Thanks!!
... View more
Submitted on
Mar 04, 2020
08:41 AM
Submitted by
RnJ
on
Mar 04, 2020
08:41 AM

Something I found that would be really helpful with tracking down conditional color triggers would be to have the ability to click the color to see which condition is triggering the color. I have a large table where we have a lot of conditions that if anything is incorrect it is Red and if everything is good it is Green. Sometimes it takes a while to track down what issue is causing the Red.
... View more
Submitted on
Mar 03, 2020
12:10 PM
Submitted by
Oli_Steadman
on
Mar 03, 2020
12:10 PM

For these table features:
FILTER BY
COLOR BY
… we currently have the following options, but they do not cater for tables where many records with very similar substrings can be difficult to separate from each other:
contains
does not contain
is
is not
is empty
is not empty
is any of
is none of
… so it’d be helpful to have the following additional ways to filter:
“starts with”
“ends with”
… for example if I have 1000s of records named by format:
YYYYMMDD-hh:mm:ss-[0-9][A-Za-z0-9 -]
… I would be able to separate records of a particular year from each other by filtering/coloring on
name starts with ‘2022’
... View more
Submitted on
Feb 24, 2020
11:44 AM
Submitted by
Kevin_Li
on
Feb 24, 2020
11:44 AM

Grouped records and the summary bar - functionality here is great, but the only way to sort the grouped records is by the order of the grouped by field options. I’d like to be able to sort by the numerica values in the summary bar (e.g. revenue or # of records)
... View more
Submitted on
Feb 18, 2020
07:47 AM
Submitted by
Darin_Bellisari
on
Feb 18, 2020
07:47 AM

Hi all - while the Color feature is fine, it does not visually separate rows well. It would be excellent to have a feature where you can color/highlight/grey out entire rows.
In my use case for example, it would be greying out and/or italicizing rows that have a start date in the future
The problem with simulating this via grouping by a calculated field is that when you group by a calculated field you can no longer add new entries, which is cumbersome (to have to remove the grouping and re-add it every time you want to create a new item, such as when you’re walking through the list as a team)
... View more