Hello! How can I publish my base in a specific view type and publish in airtable universe? All my collaborator’s end up seeing different view types. Thanks! ... View more

As the base collaborator, (sole owner, responsible party, department head, etc.) it would be helpful to make changes to the locked view. Yes, it’s quick to switch the view over, but it’s annoying to do this every single time, even when minor changes are needed. For instance, changing the size of a table. To attempt the change, then realize it’s locked, then We have asked no personal views are made on a specific table due to the fields not relevant to their role in the company. If I have to change the locked view to personal or collaborator every time even a minor change is needed this opens the risk of others following suit and making changes on the whim. I also would love to prevent users from creating a personal view. One of my team members assumes the “lock” means the page is locked (yes, I’ve told him a million times but well…I’ll let your imagination run with that one) so he creates a personal view unlocks hidden fields and fills in the info necessary. problem is - he skips multiple steps and upload in the wrong area because he is using a personal view. Not to mention the ability to unhide information that was hidden and on a locked human resources table. ... View more

I’d love a NORMALIZE and STANDARDIZE functions. ... View more

Unless I’m missing something major, there doesn’t seem to be an out-of-the-box solution which allows you to filter so as only display records which have a checkbox field unchecked. Checked yes, but unchecked no. Is this an accidental oversight by Airtable? Some reason why this is not possible? Seems like it would be an easy and really great thing to implement. Unless of course this is actually possible and I’m missing something really obvious… (am new to Airtable!) ... View more

The Airtable table I tried to share in the following thread is not correctly displayed. Track Room Items Base design I want to track what items are in which room. What is the ideal solution for this? For now, I am not interested in the quantity, but only that a certain item exists in a room or not. For the items exist unique categories, namely furniture, tool and machine. This is what I have created so far, two tables ‘Room’ and ‘Interior’: Currently, I do not have a junction table. I created three columns in the ‘Room’ table based on the unique categories and linked it to the ‘Interior’ table. I restricte… ... 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

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

Hi, I suggest an usefull feature that will help a lot the forms for complicated table. On any form view, the Submit button will offer an option “Link other table” If my current table have field linked with other table, it will suggest one of those, then it will propose the list of forms views of the other tables. When the form filler will clic submit, it will redirect his webpage to the other form & automaticly link the record. Example of case scenario ; CRM Base with these tables : Lead, Meetings In this scenario the Lead table will have a form view called “New Lead”. The first thing the form filler will see is “Enter you informations, name, address, business…”, then when he clic “Next”(The submit button), at this point he will be redirected to the “Book a meeting” form of the Meeting table then he will chose a meeting date and a brief description of what he want in this meeting. Then he will clic submit, and at this point the system will automaticly link the Lead record with the Meeting record. In this form Inventory Base with these tables ; Requests, Items To be able to request an item the form filler will go in the “Requets form” and fill the request (his name, employee number, reason why he need it, who is his supervisor…) then he will clic next where he will be redirected to “Add new Item Form” where he will insert the picture, the price, the name of the item, the quantity, etc… and then clic submit. At this point it will send all the informations in the table items & Request but not only the informations, it will also link the Request record with the “Item Request” field of “Items” Table. Options : It would be great to be able to do more than 2 forms in a row It would be great to be able to insert multiple Submit so the form filler have multiple redirections choice It would be great if we could do a conditional Submit ... View more

There are discrepencies with Rich Text content causing issues. If I copy/paste a rich text field into another rich text field, then create a formula that checks to see if they are equal: IF({Rich Field 1} = {Rich Field 2}, "SAME", "NOT SAME"), then it shows these as being equal. But if I take the content from {Rich Field 1} via the API, and perform an update via API to {Rich Field 2}, the formula comparison says they are NOT SAME. Even though if I compare them from the API they have the exact same values. So something not working when pushing via API to reflect same underlying content. ... View more