It has come to light that the VALUE() function is broken. The VALUE() function is supposed to extract numbers from a string. It’s designed to be used as a simple filtering tool to remove non-numbers from a field. This is how it is documented on the formula field reference page. Instead, the VALUE() function does at least 2 completely different things: The VALUE() function converts certain letters into numbers, and then multiplies those numbers by the closest numbers that it can find! This issue is documented here:   Value Formula Returning Numbers not Found in Cell Formulas Hi Andrew— I can’t find any documented place that lays out this behavior or why it’s happening, but I did figure out what’s going on. The VALUE() formula seems to be responding to memory units of measurement. It’s actually reading 2020 MAINT TBZ as “2020 times 1TB”, IE 2020 x 1099511627776 (the amount of bytes in one Terabyte) = 2221013488107520. Same thing for INSP 2021 AMB West, which it’s reading as “2021 times 1MB” I discovered it’s reading memory units this way, from kilobytes all the way… The VALUE() function interprets certain symbols as operators to perform math on all the extracted numbers from a string. This issue is documented here:   Interesting discovery: The VALUE() function performs math Formulas This is an interesting little discovery regarding the VALUE() function. On the formula field reference page, it makes it seem like VALUE() will simply extract all the numbers from a text string. But this isn’t true under all circumstances. The VALUE() function will sometimes perform mathematical functions as well, if certain symbols are included within the text string! For example, the formula VALUE("**6hxyzb0**00987**") will extract all the numbers and return 6000987. This is expected. But… We do not know what the complete list of letters & symbols are that cause the VALUE() function to fail, so there is no telling how many different ways this function can fail. In my opinion, everybody should avoid the VALUE() function. Or at the very least, proceed cautiously when using it. ... View more

Hi there - I live in the United States, but my industry uses Sunday as the week ending day, so we always distribute calendars that read Monday to Sunday. I saw in another thread that this problem was “solved” by simply updating your computer’s location settings. However, as I’m in the US, I do prefer that dates look like US dates throughout my system (month/date/year), so this is not really a good solution for me. I imagine I’m not the only one. I’d like to purchase the Pro plan for my team so that we can take advance of Airtable calendars, but we need to be able to set the start and end day of the week as an Airtable setting, not as a computer setting. Is this a possibility? Google Calendars can do this, as well as most other calendar apps I use, so hopefully it’s not a big thing to solve. thanks! ... View more

Hi, It would be really nice if I could have a 3rd field shown at the intersection of these two others. For instance, the countertop in the powder room is called “Topus Concrete”. Instead of a number, I would like if that name could be displayed instead of the quantity. I know you can click on the numbers to see all the records that it’s referencing, but in terms of printing this out and having it handy, the name would be far more useful. ... View more

Found myself accidentally deleting something, then went to undo the delete and realized there is no undo on iOS, or at least I couldn’t figure it out ... View more

**Static Queries: **The ability to create a new table which is a procedurally filtered subset of another table. I.e., creating a table which is a view of another table. Filtered views is all well and good, but not useful for creating filtered look-up tables for other linked tables. Example: I have a table of Instructors. I have a table of Students. I want to add a field “mentor” to Students, so that each student can have a mentor. But I want only Instructors who have been certified for more than one year to be selectable as mentors. Right now, I can manually create a new table called Experienced Instructors (extends Instructors) and manually add a record linking one-to-one to each instructor whose time as an instructor is greater than one year, and then link a student to one of these Experienced Instructor records, but I have to manually update this derivative table, manually checking each day for instructors who have passed the one year mark. If I could create a table which is a filtered derivative of the Instructors table–i.e., a true Query, filtering by time since certification, then I could link student records to records in that Query. Then only valid options would be available, and valid options would always be up to date. **Procedural Queries: **Even better would be a procedurally generated query as a datatype. Explanation: I create a field of type Link To A Query. I select a Table to which to link, just like the current link to another table. But then I get an additional option, WHERE {select: field} {select: comparison} {key value}. Example: In table Classes, field Classes:“Instructor” is type Link to A Query of table Instructors WHERE {Instructors:“Certification”} {is equal to} {Classes:“Subject”} Additional query options for (1) and (2) above, such as cross-joins. Refer to feature request multi-table-queries/1799 by [Jyrki_Keisala] ... View more

For most content, I like to have all the text visible, but I don’t want the column to be any wider than it needs to be. Excel lets users auto-size columns (and rows) so that they’re just wide (or tall) enough to fit all their content. The Excel shortcut for this useful feature is to double-click the right edge of the column header. ... View more

I would like to see some Table Formatting options. For example, having every other line be slightly colored makes it easier for the eye to track across a wide table. If you sort the table, the formatting should be reapplied so the table stays “striped”. ... View more

When creating a form you are given the options to have a “Submit another response” button, show a new blank form after 5 seconds, or receive an email that the form has been completed. It would be extremely helpful to have an option for a completed copy of the form to be emailed to the person who has filled out the form. Like the option that googleforms and survey monkey provide, the person filing out the form can submit the form and then have a copy of their answers emailed to them for their records. This would be helpful in our organizations as people are filing out applications and answering essay questions. It is helpful for them to have evidence/copies of what they submitted. ... View more

It would be really good if you could view Timelines as a Calendar - showing individual days as well as weekends, and if possible add local public holidays as an option. Similar to yearful.io, see image below - I find this so much more intuitive to read (but doesn’t have the functionality of Airtable!) ... View more