Other Questions

Said formula: AND({FORMULA1}!="", {FORMULA 2}!="", {FORMULA 3}!="") no matter what combination of those 3 fields are empty or populated it always returns 1. i only want it to return 1 once all those fields have returned a value. conditional automations using ‘and’ also return true even if not all of the options are true when using formula fields. are we seriously not able to check if several formulas did or didnt populate? am i missing something? seems to me that AND() is behaving more like OR() but i have no idea what im talking about

Hello! I searched for this, but I could only find similar results – but not the result I need. I have a Purchase Order table and a PO_ITEMS table where I create one line for each item I’m buying. I need to control serial numbers of these items, so each record is later linked to a sale. What I need is to create the PO, add the PO_ITEMS and in the end, have a pretty Purchase Order (Page Designer form) with the total quantity I need for each model. This is the form which will be sent to the manufacturer. The examples I found show the Purchase Order with every line from the PO_ITEMS table, not a summarized table. Can anyone help me? I’m attaching an image to help understanding.

We have many views which group items and create summary data at the bottom of the view. FOr example, all of the sales for a day of the week, with summary totals after each day. These appear find in the views, but DO NOT appear when exporting to CSV. It appears to only export the hard data. When printing and saving to PDF, these summary rows DO appear (but this is not helpful). This is supposed to be for salespeople to simply export and see all the totals. They will not be able to manually add the functions to Excel on each column to sum them manually. Is there another tool we can link to that will do this?

Hello, I have two coworkers who have recently left the organization. Since we pay by user I will be deleting their accounts. Will their activity history and entries into shared workspaces and bases still be viewable by other paid users/collaborators in our organization? Thanks! Lisa

Hey everyone, Airtable’s billing system is confusing me. Likely this is simple, but I can’t figure it out. How do I add users to my 5-user Pro starter pack? I swear at one point it asked me to and I said “skip for now,” but now I can’t find that anywhere. Thanks, Eric

Hi! Any idea why my date fields won’t sort? I click 1-9 and 9-1 and nothing changes, perplexing??? Thankful for your expertise! :pray:

Is there a way I can add an attachment that coordinates to the entire table and not just a particular record or field in that table. For instance, instructions on how to complete the table and the rationale behind it. I did include field descriptions for each field but I need to explain WHY we need the data that goes into each field and record.

I need help with emailing selected records. i understand that you can select records and send them and this works great. I need this same function but able to have the app user / end user enter their contact information and send the records to a hard coded email address. The user also needs to be able to add comments in a field such as notes. The end result is the email should contain a copy of the selected records , a form for the user to add their contact information with the send to address already filled out a button to send and a confirmation email back to the user stating requests submitted. Please and thank you.

Hi, I am currently on the free version of Airtable and working out how it can be used at my company. I want to email one record in a table to 14 recipients, I have attempted this both with the comma between addresses and the comma and space between and still no luck, the email is never received by any of the email addresses- these email addresses are not collaborators; however, I didn’t think that would be an issue? Can anyone help me with this problem please?

Hi there, I am wanting to see if anyone can help me with this. I have done a search but (probably by my own lack of knowledge) can’t find a reasonable answer. I work with students. When I enter a new record, I want one of my fields to auto-populate with a new email address assigned to that student. So for example, I have an email of student+112@nameofcompany.com. What I am wanting is for the next record I enter, which would be a new student, to result in a new email assigned that reads student+113@nameofcompay.com. Is that even possible? I have done a formula of (99+{name of autonumber field}) for their student ID which results in on going new IDs for each student, now i need the email to have the same result. Thank you in advance, I’m new here.

Mabye this is an easy one for you Airtable gurus. I am currently creating a more or less complex ToDo list and want to create a field which calculates the difference between Estimate and ACTUAL use of time. Does anyone know a simple trick or formula to solve this? Many thanks in advance !

I’m looking for a little help with the Gantt App. In each task, I’m tracking resources’ pay rate, bill rate, hours and expenses. I’ve got summary apps to show total payable to contractors (say $5000) and total billable to client (say $10k). I want to get an app that’s going to calculate margin for me. Any advice?

Hi everyone, I’m looking to see if there’s a way to change the apps that display based on the table I’m in or the view I’m in? Right now, I can change tables but the apps remain. Is this possible?

I’m using the Button field type, then using the Open URL action to open an external document link (that URL is in a separate hidden field). Works great, however on iOS app, this button slides the record detail window from the right side, versus actually opening the link. On my MacBook Air and Safari, the button opens the document immediately. This extra step is annoying and unnecessary, and even the URL field does the same thing; that is, you touch to open the link, and it slides the record detail pane (pain) from the right. Any suggestions or is this just how it works on iOS?

Hi y’all, I just deleted a Base and replaced it with a snapshot. I wanted to see the recently deleted base to make sure that the snapshot includes all the data that was done in the time between the snapshot and deleting the original. Unfortunately, the deleted base is not showing up in the trash. I deleted other bases and they show up and can be restored. Anyone know why this particular base wouldn’t be showing up in the trash?

I’m expecting this group of records to be sorted in the opposite direction. It doesn’t seem like it’s sorting by the entire string since “.5” is before “.25” and “.75” is after “.25” Is there a way to correct this?

Hello guys! I’m trying to create an operation report, in checklist format, which has steps filled in on different days throughout the week. Is it possible to start filling out the form on a certain day, close it and reopen it at another time continuing from where we left off, without doubling the record and losing the information? Thank you! Daniel

I can load our databases lightening fast as owner… however, people that have COLLABORATOR access to the same base CANNOT even load the records today. I facetimed with a coworker and the records spin and spin and give her a reconnecting message on and off as well as a “saving” function at the top. She CANNOT aaccess data… it’s not loading. It’s a big base, but this is a new (but concerning) problem. Anyone else encountering this?

Hey community, We’re having issues with “some” of our page designer blocks. When we create an output PDF from the block, some of the URL links are clickable, while from other blocks the links are not clickable. Also of note, ALL used links used to be clickable but then about 2 weeks ago we started experiencing issues. I’ve recorded a little video showing the issue. I hope someone can help. We were just starting to get into the groove of our new system. Page Designer URLs Clickable Issue

I put together a shared view and it has a sort configuration, but I’m noticing that the sort configuration is absent from the actual shared view. I don’t want end users who I’m sharing the view to do anything. It should be sorted per the sort configuration. What am I missing?

Some context: I’m trying to create a massive list of Payment Processing companies to embed on my website. Customers will then be able to search based on whatever criteria they want. As you can see from the screenshots, I have put the logo near the left of my Airtable Base. However, after I embed the code into my website, the logo appears all the way on the right hand side. How can I organize the columns so that the logo appears on the left hand side?

Hi everyone! I was wondering if there would be a way to create a count of how many times information is copied from a particular field? Just so I can keep count of how effective particular information is. Thanks!

Hello Step 1 : I want to create a database of all startups in Belgium. I will call all startups myself, ask them questions, and register the answers manually in my airtabel database. This, I know how to do myself. Step 2 : I want to get a website developed ( preferably in laravel ), that must publish all startups, using ( extracting ) the data from the airtable. So visitors of the website can see all startups, and use filters on the website to search, filter, save etc…the startupdata they search for. My question : can this be done ? And if yes, how to connect airtable with an extarnal website ? Is this difficult ? Costly ? Or can I use airtable itself to get this done ? Thanks for helping me out ! Ivan

We’ve had several mysterious changed to fields, rather than record, recently in a few of our bases. I cannot see any way to check the revision history of a field. Am I missing something? If not, how/where are we meant to leave requests for new features? Thanks

I’d like to have an auto-created “Today Date” when a record is checked in my “Response” checkbox. So every time a new customer responds, I’d like to have the received date created when I simply check the “Response” checkbox. I can’t figure out the formula. Thanks