Submitted on
May 03, 2016
05:09 AM
Submitted by
Sarah_Cliff
on
May 03, 2016
05:09 AM
Continuing the discussion from Changing Displayed Field in Calendar View:
Just wanted to cross post this in the correct forum since it’s not a feature I couldn’t find but a feature that doesn’t exist yet.
It would be nice if we could change the display field of a table to be something other than the primary key field.
Thanks!
... View more
Submitted on
May 02, 2016
08:49 PM
Submitted by
Ben_Fisher
on
May 02, 2016
08:49 PM
Hi. Amazing software.
One thing I’ve long dreamed of is a database that can interact with spreadsheets. Add them as attachments, open them from within the database, get data from and put data in certain fields.
It would be a simpler way to do some calculations.
As far as report printing goes, even that could be done as an A4 spreadsheet.
Thanks!
... View more
Submitted on
May 02, 2016
02:59 AM
Submitted by
kiyo_e
on
May 02, 2016
02:59 AM
i want to set default value based on params.
In other page link to public view.
... View more
Submitted on
May 01, 2016
09:08 AM
Submitted by
Michael_Berman
on
May 01, 2016
09:08 AM
I have looked around and I can’t seem to find information on this although it does seem that it should be possible: When I format a field as a linked field, I get the key field - I would like the possibility to display a different column in a manner similar to hlookup in excel - does this ability exist?
This would also seem to be the answer to the display value in the calendar view - the key value is useful in that it is unique but does not display the useful information contained in the row. For example, I would like to see the billing values on the calendar - not the billing number. I did a bit of a workaround using concatenate, but it is not an elegant solution…
Otherwise - the concept of an open online database is something that I have been hunting for for years, so you get 5 stars on app with most potential this year!! Good job…
... View more
Submitted on
Apr 29, 2016
03:24 PM
Submitted by
auroraafable
on
Apr 29, 2016
03:24 PM
I don’t know, maybe it’s just me. I’d like to have the option to have bullet points for the cells. I sometimes have awesome ideas for my editorial calendar and sometimes using dashes don’t just cut it. What do u think?
... View more
Submitted on
Apr 28, 2016
02:33 PM
Submitted by
Andrew_Enright
on
Apr 28, 2016
02:33 PM
Please add the ability for a formula to reference a alphanumeric string in column A and then generate a barcode in column B. When using Airtable as a backend for creative workflow, and you want barcodes in things like slugs and job tickets, this could be HUGE. I’m sure for small retailers too! Thanx.
... View more
Submitted on
Apr 28, 2016
11:11 AM
Submitted by
Andrew_Enright
on
Apr 28, 2016
11:11 AM
I know this is a spreadsheety thing, and falls apart once relational, but when actively editing in a table view, it’d be REALLY helpful to highlight cells that are missing info, or for which the data has not yet been fully confirmed. Question marks don’t work in number fields, so that;s not an option… Basically we need a way to identify data that’s near-final. Thanx!
... View more
Submitted on
Apr 28, 2016
11:08 AM
Submitted by
Andrew_Enright
on
Apr 28, 2016
11:08 AM
Please add a fit-to-width option for columns. Right now I have to manually shrink each column for short-data columns. Thank you!
... View more
Submitted on
Apr 27, 2016
08:52 AM
Submitted by
Nuno_Sousa
on
Apr 27, 2016
08:52 AM
Hi. Simple suggestion the web form work great in international use except for the submit button. Could we have an option of customizing the button ? Thanks.
... View more
Submitted on
Apr 26, 2016
04:38 PM
Submitted by
Natalie_Bates
on
Apr 26, 2016
04:38 PM
I am convinced that Airtable is the only thing I will ever need for all the complex organization I do for basically everything in my life, but there is one thing that would help immensely: the ability to group fields, like in the sense that a particular field would be subdivided into two different fields that always occur together.
Here is an example for something frivolous for the sake of being easy to understand:
Airtable can be an effective wiki, so I’ve been using it to keep track of some stuff in a video game. In the video game, there are certain Actions that can result in items, which can vary, and those items come in varying quantities. Say there’s an Action that sometimes gives me 3 Knives, but other times it gives me 8 Flowers.
There’s not really any way for me to record that right now.
For one thing, you can’t have multiple values for a Number field. (I’ve already bumped the request to have multiple values for any field, not just linked records and multiple selects and attachments.) And I really do want it to be a number field, because I’d like to do calculations with it.
But let’s say I give up on the calculations capability and just enter numbers in a Multiple Select field called Item Quantity. And then I have another field where I link to the Item. So I enter the Action I described at the beginning – let’s say it’s “Give the old man a penny.” Sometimes when I give him a penny, he gives me 3 Knives, so I enter “3” in the Item Quantity, and link to the Item record Knives. But sometimes the old man gives me 8 Flowers instead, because he’s supposed to be batty and fickle and it’s luck-based or whatever; this is all made up, but tons of games have changing luck-based or other-based outcomes. Okay, so I enter “8” in the Item Quantity as another multiple select option, and also link to the Item record Flowers. Then I keep playing.
I hit a point in the game where I need to stockpile Flowers, so I go look up all the Actions that result in Flowers. After all, this is exactly why I bothered to keep a personal wiki. I find “Give the old man a penny.” Except… hmm… does he have a chance to give 3 Flowers, or 8 Flowers? It makes a difference because if it’s 3 Flowers, it’s not worth spending an Action point in the game; there are other actions in my Airtable that show I can get more than 3 Flowers per Action point, and 8 Flowers would be the best return on an Action point I could get. But I don’t remember which is which; I made the Airtable so I wouldn’t have to memorize stuff like that. I then have to waste time and points going around the game trying these things and then simply memorizing which are my best options, which defeats the point of recording the data in the first place.
Basically, if a field could have two or more components to it, I would not have this problem. I could have a field called Outcome with the subcomponents Item Quantity (which would be a number field) and Item (which would be a linked record, or a short text for some people’s uses, etc).
The only way to do this now is to have a separate table for each action, with separate records for each outcome, so they don’t share fields for Item Quantity and Item record links and it’s very clear what you get in what quantities. But there are thousands of actions in the game, and most only have two or three possible outcomes. Making that many tables is simply not feasible because it would become excessively difficult to find a table whenever I need to edit it, and I’m not even going to be editing the vast majority of the tables I’ve made in that case. All the tables would also have long names that would get truncated. I’d also have to keep a template table around to duplicate with all the necessary fields configured, and then constantly duplicate it, which is just annoying.
There are more complex ways I’d like to use this for less frivolous projects as well, this just took the least specialized knowledge to explain. I am working on a big biochem project where this functionality would be so helpful. I once tried to do this in Drupal, where people had programmed a handful of ways to do field groups, but Airtable is less buggy and much easier to use than Drupal and I can enter things lightning fast from my phone. I point this out because it shows there is demand for field groups for similar uses on another platform, plus I know Airtable can be used as a CMS and I really think it has the potential to blow Drupal out of the water for some kinds of uses, but the lack of field groups makes some uses infeasible or impossible.
... View more