Is it possible to set color by field type? I would love to be able to see what data is being generated in that Table and what fields are being pulled from other Tables. ... View more

One of the aspects of working with blockchain-type data for cryptocurrencies is that the values recorded have a large number of decimal places. Bitcoin has 8 decimal places, and so just barely fits within the max number of decimals Airtable allows. However, Ethereum has 18 decimal places, and many of the tokens built on that infrastructure followed suit, and have very high number of fractional decimal places. Many spreadsheet applications max out at 15 significant digits for numbers, and so are hard to work with Ethereum values that use that full spread. Since Airtable has such a robust API system, I experimented with using it to solve some of these issues and here are the pain points with that: Because the “Number” field cannot go up to 18 decimal places, a “Single line text” field format is needed instead. Using a base that has a Date column and a “Single line text” field, an outside script (capable of high-precision math calculations) can create “running total” values fairly well. However, in displaying those values, it then becomes a problem of alignment: if a base has values of: 0.12345 12.5454555 1.7 7235.3 0.000111222333444555 (a mix of number of digits left of the decimal point, and right of the decimal point) Then when they’re all left-aligned (as Airtable columns are, and how this bulleted list appears here), it’s very hard to see which numbers are bigger at a quick glance. If Airtable allowed text columns to be displayed right-aligned, then each of those values could be padded to make them align nicely: 0.123450000000000000 12.545455500000000000 1.700000000000000000 7235.300000000000000000 0.000111222333444555 Alternatively, if the Number field were able to go up to 18 decimal places, that would be even more beneficial (and able to do math on cryptocurrency values right within the UI as a formula), which would set Airtable apart from other spreadsheet tools which are limited in that regard. ... View more

I just want a Kanban view without editing option in one of the tables. I have created a base with two tables - 1. Tasks, 2. Sub-tasks. When I complete all my Sub-tasks, the status in the main task automatically updates. In main task, I have 3 statuses - 1. Not yet Started, 2. In progress, 3. Completed. This statuses are formula based. I want to view this statuses in Kanban View and it is a view which I would never edit but it would update on its own based on the formula. If there is any available solution for this purpose, I open for it. ... View more

So this is strange… In Airtable’s formula field reference, several of the examples refer to fields that don’t exist anywhere within the example itself. For example, check out this example that was given for the WORKDAY_DIFF function: WORKDAY_DIFF({Assignment date}, {Due Date}, '2017-09-04, 2017-10-09, 2017-11-10') => 8 Okay, that’s great that the formula results in 8, but we can’t truly understand the formula if we don’t know what the values are for “Assignment Date” & “Due Date”. Interestingly, we also can’t tell whether the dates are in YYYY-MM-DD format or YYYY-DD-MM format. Yes, we can type up this formula in our own database and play with it ourselves, but if we’re just reading through the formula field reference, it leaves more questions than it answers. For example, my immediate question about this formula is whether this formula includes the start date & the end date as part of its “count”. Same problem with this function: IS_SAME({Date 1}, {Date 2}, 'hour') => 0 Huh? Why does this result in 0? What are Date 1 and Date 2? And this function: WEEKNUM({Date}) => 46 Why does this result in 46? What was the original date? And this function: WORKDAY({Launch date}, 100, '2017-09-04, 2017-10-09, 2017-11-10') => 6/20/2017 Why does this result in 6/20/2017? What was the Launch Date? But there are many more examples — just like these — in the formula field reference. We can’t truly understand the functions properly from the formula field reference unless we understand which inputs you’re putting into the functions. Yes, I get it that we can just play around with these functions ourselves in our own tables and figure this all out on our own, but it would be really nice to have a fully fleshed-out reference guide that we can fully comprehend. ... View more

We love Airtable! We work a lot with tasks! However, I’d like to filter out “finished” tasks. Of course I can filter within “task table” not to show tasks with “finished” checkbox However, these tasks still show up when linked to other tables. For example, I assign a certain task to certain people, with cross table filtering I mean, that in people’s table only unfiltered tasks of task table shall show up. How do I achieve that? It’s about getting rid of finished tasks (not messing up the views) without deleting them - kind of archiving them. Thanks for your support Thomas ... View more

The ability to add a new filtered view to quickly access it just like the grid, calendar and other views. ... View more

Newbie here (obviously). Is there a way to show a row (or multiple) at the bottom of the current view that could have various calculated/aggregated values from the rows that are currently displayed via the active filters? For example, I might want to have three rows, always visible (similar to the Summary row, floating on the bottom) that might have, for example: Min, Max, and Avg. ... View more

Is there anyway we can get notifications to be more customized. For example, i want notifications for when I am tagged in a comment but I do not want them when there is just a general note. Currently the only way to do this is if we mark each data entry as “not watching”. While this is possible it is meticulous and repetitive Thanks Ron ... View more

I want to add social media icons with the links in Airtable to improve my airtable embed view. I wouldn’t like to present this as a naked URL, it looks monotonous. ... View more