Other Questions

If I have fields in a table with specific types why doesn’t the form validate those types before submitting the data? There seems little point in specifying a field type of email if someone can enter whatever they like into the form. I realize that client-side form validation is non-trivial but there at least some native browser validations that could be implemented fairly easily.

Hey Community! Here’s my problem: I have users adding phone numbers to records. Problem is, the way the are inputting records doesn’t allow me to have Data validation. I need the number they input in a specific format, and I was hoping there might be a formula that could do this. Format we need: 1 (XXX) XXX-XXXX Inputs we might get (because users make mistakes) = 1 xxx xxx xxxx xxx xxx xxxx xxxxxxxxxx 1 (xxx) xxx xxxx (xxx) xxx xxxx What is important for us is there is the area code, aka, a “1” at the front of every number. I was thinking about creating a formula that adds a “1” at the start, but in the circumstances where a user does what we want, and adds a “1”, I don’t want to add it as it’d break it. Does anyone know how to put a formula together that’ll do this? PS, Bonus points if you can ensure it looks “pretty” by formatting it in this wa

Is there a way to enforce data validation on a field? For example, if I want to enforce users to enter a name under 20 characters or less, can I do that?

Hi guys,I'm creating a escape room form, so the group can select the room and time they want to play.There are 3 rooms (each one with 5 different times to play).When a group select the room/time (example: Room 1 - 20h) this room can't appear on the form anymore.How can I do that?I read in other message here to create a new table with all the possibilities (I already did that), and created a link to another record in the main table (which is used to create the form).I tested it but it didn't work.If anyone could help me, I appreciate it! Thanks

I have some equipment inspection checklists that I am trying to move from paper to Airtable, and I was wondering if there was a way that I could convert it into a fillable PDF and put it in an Airtable form. The employees fill out these checklists when they’re at worksites, and the office is out of their way, so the forms don’t get dropped off as soon as we’d like. What I am hoping to do is have the employees fill out the PDF in the form, then have the PDF saved to the base as an attachment so that we get the forms as soon as they’re finished, and it’s easier for everyone at the worksites. I already tried converting the checklists to Airtable forms, but there are just too many checkboxes that would each need their own field, and it would just end up being too inconvenient to fill out and sort through. I also tried using the attachment field in a form, but this would require the PDF to be filled out in a different app (or scanned), then saved, and then submitted through the fo

there are so many options out there, but I have our employees work exclusively out of the Interface Designer.  What is the best options out there (affordable or free) to generate letters at a click of a button?  

Imagine you have set a rule that your kids are only allowed 2 cookies from the jar when they get home from school. They have access to the cookie jar (a particular table), but they can only have 2 cookies (2 records per day). When they try to take a 3rd cookie they will be blocked, and redirected to a different page.How would one do this with AirTable? We have tried doing it from the UI in Softr, but this requires us to update the UI when users in the kids group have taken 2 cookies, which is a little tricky to get right. It would be much better if this limit could be implemented on the server side, in AirTable, somehow.Any thoughts anyone, please?

Hey there, I'm stuck at this point and really hope some expert could help me out. As a language center, we collect payments from the students in phases. We have a "master" table including students' information, I then sync the view to another base for payment tracking. I really want to keep using that "synced view" for accounting purpose, because then I don't have to type in the whole list of names again. In another way, I want to keep the information consistent and save time from creating and updating many lists for different departments in the company. However, for the accounting base, I can't add rows below each student's name (as it is a synced view!) to track their different payments (divided  into 4). I had to track those veritically (adding columns instead of rows) and this causes some inconveniences. I want to filter the Data by status, for example "Due soon" or "Overdue" and see the sum of the amount of money we expect  to collect in the fu

Hi, for some reason, when I input numbers with two decimal places in my 'number' field, they automatically round up to 1 decimal place. How can I prevent this from happening? Thank you!

Hello folks!Total newb here!I have a base with 2 tables. Table 1 is orders that are placed by customers. Table 2 is a list of those products with a corresponding URL to the image.I'm trying to have the Cover Art field in Table 1 populate with the corresponding date from Cover Art URL in Table 2; based on the Product field in Table1 when the customer places the order.Basically when a customer places an order, I want the Cover Art field in Table 1 to pull the appropriate URL from Table 2, based on the Product field in Table 1.  Does that sound utterly confusing?I've attached some screenshots in case it's helpful.I've been spinning around online trying to figure out how to accomplish something I believe is actually simple.With grace,JQ

Hi there, I have 4 tables that are linked - they are as followed: Table 1) People who fills in the form Table 2) Companies (105) Table 3) Research Areas (17) Table 4) Questions (5) I want to create forms that match one company, in one research area, with one question - like; Company 1-105 + Area 1-17 + Question 1-5 - where these variables change, so each form is sent to a person who fills in the form with a specific combination. One person, one combination. So I select the combination (best if it’s automated) and the form only makes it possible to answer the question with predefined options. So the first fields are pre-filled by me - hope it makes sense. I’m new to Airtable. Best, Eva

Hi, is there a way to have a field prefilled in a form AND hide the field at the same time? IMO it should be standard option since most of the time when you prefill a field for users, you don’t want them to even see the field and have the ability to mess with it.

We are trying to setup a notification when a new file is uploaded to a record in a specific table. We have created a new Slack channel to receive these notifications. When connecting with Slack, only a subset of our team’s Slack channels appear. The new channel we just created doesn’t show up. Is this integration working currently? What are we missing? We’ve logged in/out of each app several times and retried but no luck. The new channel never appears.

A few of us have been using the Free plan.  I created a workspace. My colleague created a workspace. We added a few other colleagues.Got to a point where it made sense for us to upgrade so one of us purchased the Team plan, for a total of 8 users. So now all of my colleagues are part of my paid plan.After upgrading, I can confirm that I have 8 licensed users. When I log in, the workspace that I created now shows as being part of the 'team' plan, but our other two workspaces still show as 'free'. Why? Those workspaces were created by one of my colleagues that I just upgraded to the Team plan.The pricing is whacked, and having to upgrade my subscription (again) to the higher plan which is more than DOUBLE what I just paid, just to get the admin console, is ridiculous.I also find it very difficult to get in touch with anyone at Airtable. The chat bubble just prompts you to enter your info and it took 2 days for someone to send me a canned response that

Hello,I would like to create an automation where I enter the working hours of the respective month and employee from "Table A" into the column of the respective month and employee in "Table B". (January, February, ...) the whole thing should be done once a month.

I have a form where every month the team leader enters the hours of the employees as follows: Employee 1: "35 hours"Employee 2: “48 hours”. up to 15 employees per team leader. Table A shows me all the hours entered by each employee in each month. All employees are listed in “Table B”. In this table I would like to add up all the hours worked so far. how do I get this done. Employee A can be listed under "Employee 1" in month 1 and under "Employee 4" in month 2. Theoretically, every employee could be entered in the 1st - 15th position. So I would have to add up all the hours of each employee, regardless of whether, for example: the employee is under “Miztarbeiter 1” or “Employee 12” and so on. you would have to tie the hours to the names or something.

Hi there, I was wondering if and how I can make a (prefilled) field in a form read-only. I am basically creating a form to answer a question. The form should be generic, but the question should change. But it should not be changed by the user themselves. I know the field wouldn’t “really” be read only since the user could modify the query string parameter, but that would be good in my usecase to prevent unwanted changes to one of the fields. Thanks!

I have three columns: Email Sent (Yes/No) Date (Sent) I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?

I’m trying to expand a base we use as a booking system for photography sessions but feeling stuck. In our current system, users fill out an Airtable form with their contact info and select a time slot (field linked to a table of time slots, filtered by what’s still available). That info generates records in the main Appointments table. This system has worked well so far, as we’ve only been offering slots with one photographer at one location. We’ve been offering 30 slots per day and about 3 different dates at a time, so at most the user sees 90 options, which is more than ideal but has worked ok. Now we’d like to offer 5 dates, but more critically, we want to add a second photo station in a different location on the same dates. That means the user will now be selecting a time slot from a field with 300 options, and there will be two slots for each date and time (eg 10A Monday @ Location A vs. 10A Monday @ Location B). The biggest limitation I’m hitting is

I set prefill data for certain columns and created form for other fields. On entering form data, new row is created but these prefill records returned empty. I thought new row will contain prefill data regardless of how it is created. I referred this for temp solution: Can I prefill a portion of a form?

I want to give one link to my users that will help them fill out two forms with pre-filled fields in them. The first form would have pre-filled in field called ProgramID. I'd like it to redirect (or have a button to) a second form with the same ProgramID pre-filled.  I can't for the life of me figure this out even thought this was a pretty straightforward feature on Typeform.  Any one have a solution? I just would really prefer having one flow vs. having to share two different links. Thank you so much!

Is it possible to prefill a form with an attachment field so an image renders on the form? I see this question has been asked twice but no one answered. If possible, it would save us soooo much time.

I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportHowever, I'm having an issue that some seemingly random columns aren't being picked up by PowerQuery. I've done this with 5 tables, some have worked perfectly, some haven't. The columns that are missing are different types, sometimes check boxes, sometimes free text fields. I can't work out what the pattern might be, and therefore how I might fix it.I'm hoping someone might have come across the same issue in the past, and know exactly what I'm talking about and how to fix it. 

Hi all, We are on the Pro plan, which seems to default duplicated views to personal even if they were originally collaborative. We mainly use Airtable for grid views, though I’m not sure that has anything to do with the issue. I have searched high and low for a setting or option to NOT do this, as we would prefer duplicated collaborative views to stay collaborative, and not have to manually change it each time. Any ideas?

Basically, I'm wondering how to change the fields shown in a linked record field dropdown/select menu.These fields below (Record ID, First, Middle) do little to help me distinguish among similar records.Note that this particular screenshot is of a linked field to a table that is synced in from another base. But my question stands generally, whether for a table«»table link or for a table«»synced table link—what's the best way to choose my own fields to display, if it's possible at all?