Ask the Community

Hi, I’m fairly new to airtable and having a hard time setting up what I think should be a relatively simple base. I have a staff of about 40 individuals. They only have access to the share views of two of my bases, if that is relevant (so anything they do on airtable has to go through forms). The 40 staff are each assigned between 1 and 4 shifts a week. Each day is divided into 4 shifts of 6 hours, so we have 28 shifts per week. The number of staff members assigned to a given shift varies. Right now I just have a base with two tables: staff names and shifts (listed as mondayshift1, mondayshift 2, etc.). Staff members fill out a form and select their shifts so that the resulting tables fill in. What I would like is a way to track attendance and then later, set up automations (for emails) if someone misses a shift. I was thinking I would create a form for them to fill out when they clock out, with name, shift, and then one optional question

I have been trying to help my son (13) start up his lawn care business.  I'm familiar with, and use airtable regularly for some small tracking.  I love its accessibility, range, and adaptability.  Thought it would be a good fit.  Created an easy to use base with services available (with fees) table, service provided and dates table, and client table.  Then created an invoice table that he can simply add the services provided to certain customers from the "services provided" table.  Works flawlessly.  He has grown the business and uses written invoicing.  Tried to help him save a step by automating the invoice so he could send it as a text to the clients each month.  Page designer creates the invoice.  Is there a way to send the invoice created as a text or email to an email in the invoice? To sum it up, use page designer to create a document.  Send the document via text or email.  Solution needs to be sim

We used to be able to select a photo size option ie: small, medium, large when uploading photos from the iOS AirTable Mobile app. Now it doesn’t seem to offer the option and forcing you to upload much larger than needed photos and wasting my data. Is there a way to turn this on or am I missing something? Thanks in advance for any assistance here. Thanks, Thomas

As a future feature request, would anyone else benefit from the preview links for URLs being more personalised?I send out a lot of forms via email to people in my network, but often when they're in the field they contact me and ask me to send the link by text... When I do, the links just show up with the generic Airtable preview.Because we have so many forms, there is no way for the individual to identify which of the links in their messages is the correct one. See attached image of how they appear in a SMS exchange.It would be great if instead of "Everyone's app platform" it would have the name of the form, or the view that was being shared in the link.If it also had the base icon instead of the airtable/blue/laptop icon, that would be a bonus.

In my workspace, when I hover over a base it either says “open data” or “open interface”Does anyone know when it will make “open data” the behavior or “open interface” the behavior. It seems kind of random to me. Just curious.

I want to send different people emails containing a link to a form that they can only submit once. Once submitted, if they click the form link to the form again, they wouldn’t be able to do another submission. How do I do this? Ideally, the form would be tied to a record in airtable, and if the status column of the record is no longer “new” and transitioned to “progress” or “finished”, the form would no longer work.

I'm wondering if there is a way to restrict a date field to a range of dates. We have a base that grants people access to our website. In order to get access, they need to fill out a form saying how long they need access for, but we want to restrict it to dates that are 1 or two months from now so they don't put 2025 or something ridiculously far away. Does anyone know how I could accomplish this? Thanks!

Hi  Dear Community I’m facing issues with the print layoutJust 2 days ago everything was smooth and today I hace noticed this issue with the printing layoutIt does’nt som th complete information here a copy  

Hi, I need an attendance tracker for nonprofit organization that organizes different extracurricular activities throughout the year. I'm working on a generic form that the coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried to use the link to the form, not the form builder view and it was still not allowing me to add a new record. Is this even possible? or am I missing something? The objective is to be able to have a beneficiary registry or a complete list of beneficiarie

Hello, I seem to be running into a problem where I can't get my automation to uncheck a checked box when certain conditions are met in a linked table. Essentially, I want the "Ordered" Checkbox on my primary inventory table to be unchecked automatically when a new order of the associated item enters my "Received" table. Here's the setup for the automation:And the result where I'm having trouble:Airtable seems to recognize the cell that I want to affect with the automation as evidenced by the fact that the box is highlighted in red, but it doesn't actu

When can we expect an EXPORT function for interfaces??

Hi, I am pretty new to Airtable. Is there are some easy way to sync (or at least export) an Airtable base to relational DB?

Please change back your UX to the old one. The new one is so washed out its difficult to use!!!

I'm setting up an automation triggered by updating a field in one table, which updates a field on the linked record in another table. I'm using "Find records" to search the linked table based on condition that the record's name/title matches the name/title of the linked record from the source. Essentially, I'm just trying to find the record linked to the updated record.However, when selecting "Dynamic" for the condition value, the name/title field to be used is not selectable, with the pop-up message of "no valid nested values" when hovering over the field. It really seems like this should work, and this error message is cryptic and not helpful.Does anyone understand this "no valid nested values" error?Should I be grabbing linked records to be updated in a different way?

Can we restrict who fills out the Form, if we already have them logged in to a parent app that can authenticate via SSO to the airtable app?And by detecting who fills out the Form, is it possible to pre-fill the other fields in the Form?

Hi! I work at a digital school and I would like to have an easy view where I can see all my classrooms whether they are booked with a course or not. I have a total of 20 classrooms. I already have calendars where I can put the dates, the courses and the classrooms the courses will be taught in. In the calendar view, I also created a returning view telling me whether a classroom is already booked. I have a tab with all my classrooms and another one telling me if there’s an error due to booking the same classroom for two courses at the same time. I also am able to create a view of all the classrooms that are booked but I don’t seem to be able to add the classrooms that are available. I’m sure there’s a way to add the empty classroom. Is there someone who can help me? Thank you :)

I’m building a database for products that sell on multiple marketplaces (Etsy, Creative Market, and my own website). I have one table for the products and another for the marketplaces. I have URL fields for inputting direct links to product listings (separate fields for each marketplace), and fields for linking the products to the marketplaces they’re listed on.Currently, I have to manually add both the URL and link to the related marketplace, but I’d love to create an automation that updates the marketplace link to include all marketplaces for which the URL field isn’t empty. For example, if a product has only an Etsy URL, it should only link to the Etsy marketplace record. If it has both an Etsy URL and a Creative Market URL, it should link to the marketplace records for both. I was able to successfully create an automation that l

Doing a search on "fill in PDF forms", I see that some Airtable users have asked for PDF form features beyond what Airtable currently offers. We have completed a new PDF forms only solution that may help.Our new solution adds value to fill in PDF forms by making them easy to: upload, fill, save, duplicate, retrieve, sort, combine, email, print, and fill to other forms. It also allows you to invite someone else to help you complete any form. A log automatically keeps track of who makes what changes to each form.If you or your users need to work with fill in PDF forms, please try our new solution at: https://fillinpdf.comThe site includes a few short videos that demonstrate how to use the software. Currently, it can be used along side Airtable. We are also open to integrating with Airtable. Please let me know your thoughts and suggestions. Dea

Hi, We’re battling getting contact duplicates from Meta lead campaigns. Basically people forget they’ve already signed up, and send in a new registration. Since these are Meta, we cannot control anything upstream. A first step is to get our people, who only work in interfaces, alerted that there’s a duplicate to a contact. It would therefore be enough, for now, to achieve a field that tells the user the amount that the current user’s e-mail address can be found in the total base (~2.000 contacts now). I’m trying an approach where I link all contacts to one record in another table, then lookup all e-mail addresses. Back in my main table I link to the second table and lookup the e-mail addresses. I would the like to count the instances of the field “email” in the lookup field where all e-mail addresses are. FIND finds only the first and gives the position, SEARCH does the same. COUNT and COUNTALL do not work on text. 

Hi, can someone people assist with my formula? This is what I’m currently working with;IF({Post Sale Date},{Post Sale Date},{Event Date}) I want to expand on this to check the ‘Result’ field so it functions as below. IF ‘Post Sale Date’ exists then use ‘Post Sale Date’IF ‘Post Sale Date’ is empty and ‘Result’ is not ‘SUTH’ then leave blank.IF ‘Post Sale Date’ is empty and ‘Result’ is ‘SUTH’ then use ‘Event Date’ Any suggestions would be much appreciated! Thank you

Hello, I wanted to know if it is possible to embed an Airtable table on my website with the Kanban view for example, and to be able to change status from my site without going through Airtable.

Since last week my HTML forms began to fail with scripts apps which I could send data and pdf files to airtable the file as it is, now it doesn't allow I don't know what to do someone knows a safe method but that is not using the drive download URL, thank you

I’m building a table in Airtable as part of an internal tool for my company to track client project statuses.We’d like users to be able to: Change the order of the columns in the Interface Designer Set sticky filters that persist across sessions We’re aware this is possible in Personal Views, but we haven’t found any documentation or settings that allow these behaviors directly in the Interface Designer.Is there a way to enable persistent column order and sticky filters for users within an Interface? Or is the only option to instruct users to use Personal Views outside of the Interface?Thanks for any guidance or workarounds.

Hello,My team uses forms to enter data into our Airtable bases. For one form, we have a multiple line field that appears only if one or more other fields are selected. It would be helpful to know why the conditional multiple line field appeared.Is there any way to show which fields caused the conditional field to appear on the form?

I came back to my bases tonight to find the header colors all muted pastels. Some of us rely on the color to differentiate bases. Also, the contrast is much lower on the tables and the text on them… less accessible and more difficult to read. On interfaces, it’s still the same vibrant color… can we not retain that color in the Data view? Am I missing some setting that got changed? Also, the info in the far left (icon, help, notifications) is taking up more horizontal screen real estate. Maybe I’m the only one, but having huge changes for no benefit seems to be a bad idea for productivity. End of rant. For now. 😁