Ask the Community

I have two tables Properties list and Budget. In the Properties table, I have a user field that we can assign the property manager to that particular property and that manager is only able to view and edit the Budget(budget table) details belonging to the property.But in budget table has many records of multiple properties detail. But that particular property manager should be able to view and edit Budget details belonging to that property. The rest of the details can be visible or hidden but should not be editable.Is that possible?

Hi,I have a situation where a public user would need to fill out a form, be able to view ONLY that record with their responses (with additional dependent fields displayed), and then print that record in a nice-looking format.  I've explored other integrations, the public interface option, etc. but I can't find something that would work for the entire process.  Does anyone have any suggestions? 

Hello all,I'm wondering if it's possible to indicate certain records in a table as read-only. The idea is that once these records have been validated they should not be modifiable (except perhaps through a special procedure). It's for accountancy records that have been transferred to an external database and so should no longer be modifiable.Any tips or tricks anyone to achieve this?Thanks,Mark

When creating a Form view, it would be helpful to be able to specify a “Read Only” view for a specific field. I am using linked records to display data from other tables but in some cases, only want to display the pertinent data, with no ability to modify it, or to add a new record. Not seeing that this is possible at the moment.

Hiya!I'm trying to create a registration form to send out to external users, but want them to be able to see the remaining capacity of each event, to know if they can register for the event. I tried to do this via a lookup field and as a read only field to find that Lookup fields aren't supported in Forms and Read Only fields won't appear in the public facing form. Is there a work around for this?I have the form set up where if an event is at capacity it won't show in the form, but haven't found a way for it to not accept registrations causing the event to go over capacity, which is why I though the registrant seeing the remaining capacity would be helpful. For example:A teacher wants to register their class of 40 for one of our spring concerts. Their first choice is Concert A, but when they selects Concert A, they sees it only has 30 spots left, thus they should go with a different choice. [as it stands right now Concert A is still a choice since it is not at capacity, but it wou

We use AT to manage rental properties. Here is a scenario and then what I am looking to accomplish. We list each house as a record in a base. We have a filed for when a house goes vacant to track when the rental turn project start and another for when it ends. I don't want to lose historical data the next time this same house goes vacant and needs a turn project. I would like to keep track of each time these change and create a place where we notate the last time before update the new updates. This will allow us to have a history of how long vacancy lasted and over time and with multiple properties we can get a feel for how long they last on the whole portfolio.Thank you in advance for your help.

Hi,I want to make it so it's possible to download a grid view off my Interface. Is this possible?

Hello Airtable community! I need your precious help as I’ve been spending the last 2 days trying to figure this out and can’t seem to do what I want done here… In one table I have a field name “Country” and another field right next it that’s named “States”. I am trying to show a selected number of options in the “States” field based on what has been selected in the “Country” field. e.g: I choose “USA” between all other countries available in the (single-select!) field “Country” and I want the field “States” to return ONLY the results corresponding to States with the USA. So, depending on what’s selected in field “Country”, it needs to show only a few selected options in the field right next to it. If I choose “USA”, I want the column next it to give me the 50 states (Choosing between California, Nevada, etc) If I choose “CANADA”, I want the column next it to give me the canadian states only! etc… I have tried creating a different table with all information included, per country and use

I am considering switching from Click-up to Airtable. But I have found a limitation in the calendar display that is stopping me.Click-up allows me to display multiple fields in a calendar view and each is on its own line.Airtable also allows me to display multiple fields in a calendar view, but they are all on the same line and are not visible. Is there any way to make the Airtable Calendar view more like the Click-up view? (See attached)

We use WordPress with Elementor and have noticed that the page containing our embedded Calendars and Galleries frequently freezes when viewed in Chrome. Additionally, the Calendar and/or Galleries in most instances do not appear at all. The embedded Calendars and Galleries work as expected in Firefox and Edge, though they can take some time to load. Is anyone else experiencing this issue? We've contacted support, but haven't heard back from them as of yet. 

I have conditional visibility set for 2 fields in my form. One is working correctly, and the other is not. I  need to know what I am missing on the one that is not working correctly.Here is the one that is working correctly as it is in the form and what the conditions are: Here is the one that is not working correctly, as the Clients Location Link is still showing up when it should just  be the Love is Blinds Location Link:   Any help would be appreciated. 

I have a select drop down  field with number rating from 1 to 10,  1 - 2 - 3 - 4 .. etc...  .   I want to filter all the records that have a rating bigger than, let's say 6, but there's no number operators (">", "<") for the select field.Is there a solution to this?thank you in advance.

Hi there, I'm trying to bring a value from a previous row into another row, matching on two conditions.For context, I am ultimately trying to compare the difference in revenue between two rows, submitted by the same company, in adjacent quarters.Does anybody know how this could be done? Thank you!

I have a sweet automation set up for a client that lists important dates in a grid format. The date includes "UTC" and I can't figure out how to get rid of UTC. As you can imagine with all employees in the same time zone, the addition of UTC is not only unnecessary, but unattractive. I appreciate any ideas you might have to remove this from the email auto. 

Hello everyone! I’m a complete beginner in Airtable and would greatly appreciate your guidance. I’m trying to set up a simple “Lab Reservations” system and have created the following structure:Terminy (Slots)Stores all available lab time slots.Fields include: Date, Start Time, End Time, Researcher, and Status (Available/Reserved).I’ve built a form called “Add New Slot,” where I want to include this instruction for lab assistants:“Here you can add your availability when you can conduct research in the laboratory. Remember that each study lasts a minimum of 30 minutes. Please add slots in 30-minute increments. For example, if you’re available on February 13 from 1:00 PM to 3:30 PM, you should add six separate slots: 1:00–1:30 PM, 1:30–2:00 PM, and so on.”Rezerwacje (Reservations)Allows people to sign up for a specific slot.Fields include: Full Name, Email, and a linked record to the Terminy table.I also have a form, “Registration Form,” which should only display slots with Status = “Avai

I'm trying to create a new Base for Donor information. I've successfully created the new Base and everything seems to be syncing fine. However, I have been using just a Autonumber Field for the Original Donor Primary Field and have converted it to a Formula so I can include Donor names with the Serial #. Now, in the synced base, I am unable to assign the new Field as the Primary because it's synced. Is there a way to override this? Why doesn't the change in the original migrate to the synced Base?

I am trying to receive party size data in my airtable for an integrated bland.ai voice assistant. If I remove the party size record in the airtable module, everything goes through smoothly but it is only party size that brings up this 403 error. Can you give me some insight on how I can resolve this?

Hey Gang.I know there's probably multiple ways to do this but I'll ask.If there's an automation way of stripping/grabbing two(as there will always be two) linked records in a field and placing the first in the "first instructor) field(email type), and placing the second in the "second Intructor" field(also an email type).Obviously, I'd need to grab, each of those and place them in their respective field.Simple enough, right?Or if just placing a formula in a field to reflect those emails, that'd be fine too, I guess. thanks

I am new to airtable. I used this  Standard Deviation STDEV - Quick Reference - Airtable Community to calculated the standard deviation. However I have 5 fields in this table and sometimes only 3 or 4 values are entered. I would like to only consider the fields that have a value entered. for n I added a field called number of runs, which helped, but it still considers the fields that are empty and includes them as the value "0". How can we fix this? 

I am so disappointed in the updated Record Review layout. My team was satisfied with the filtering and sorting available with the legacy element-based record review layout. I am trying to find a way to customize an efficient arrangement of fields, but all I can do now is list them one per row..? I don't want to have to look for an Airtable alternative just to build an attractive record browsing interface.

Hi all, I have read a couple of posts on this question and tried the suggestions but I can’t seem to get it to work. I have a view that I am sharing via a view only link with various collaborators. In order to allow them to update certain fields of the records, I have an Edit Record button in the grid that opens a form where they can update the information, then an automation to update the form. One of the fields they can update is an attachment field. I want them to be able to add new documents without deleting the existing ones, as for certain records there are multiple documents that will be added over time. I would rather not create a separate field for each attachment and instead just add the new ones in with the existing ones. Is there a way to do this without using a script or an external program. I am on a free plan, and we have no budget for anything more. @Kamille_Parks I saw that you offered some solutions in the past. Below is a sceenshot of how the automation works at

Hi all! I am running a T-shirt business and currently am filling orders. I have embedded a form onto my website so that when customers want to place orders, their info goes straight into AirTable. My question is this: is there a way to save this info in a customized PDF or Word doc template, and send this back to my customers? Any help would be awesome! Thanks!

I am hoping to use Airtable Forms to manage applications for a grant, but I am running into issues in finding the best way to export the results so I can review each application/record individually. Clearly exporting to .csv is not the best way to do this. Further, the grant requires an attachment upload. For a simpler grant, I used page designer to print to PDF each record, and pulled in the required fields in order to evaluate. The application data takes up one page, so I just print the pages I need. This is becoming harder as more applications are received, however, because the print options are only “print current record” or “print records in a specific view” (i.e. my entire grid/all results). What I need is to only export/print certain records that have not been reviewed yet. For the more complicated grant, I want to export each record including the attachment. Not export the entire grid to CSV then download each attachment. Is this going to be possible? Each application requires

Relative Airtable Rookie (Well, maybe a Sophomore) here… So forgive me if this is obvious or somewhere - but I sure have looked and haven’t been able to find it! I know you can use Airtable forms for other people to input info directly into your spreadsheets. Cool. Got it. But I need the opposite. What if I have all the info, but I want to generate a report or a form to distribute that? (And make it look nice?) Case Study: I produce a television talk show and I want to generate several different “forms” or reports. Examples: a research dossier for the hosts to prepare for their on camera interviews of these subjects with headshots, bios, topic-related background, social media links, etc. on the guest as opposed to a different one for the editor - with much of the same overlapping info but links to where all the A/V assets are (DropBox, whatever) versus one for “transpo” - providing home address and cell phone for the limo driver to pick him/her up, drop them off (but no one else should

Hi, how can I download the submissions to my form? I need to save each form individually as a pdf, word doc or something similar (not in excel format!) so that I can include it in the file for each person that completes the form. I kindly appreciate guidance on how to download each form individually. Thanks,