Ask the Community

I want to populate a calculated field using data input into other fields.Example: Q1 = XYZQ2 = ABCCalculated Field = Q1&Q2 = XYZABCIs this possible to achieve in either an interface or a form?Thanks!   

Hi,I have a base with a lot of records being submitted that have dates attached such as events. I want to be able to show the next 20 records coming up, keeping in mind this will change any time a new record is created with an upcoming date in the next day or two. So that might make record number 5 in the sequence be pushed out to record number 6 since a new once came in. But I still just want to present 20 records at any point in time.Thanks!

HI All! I'm trying to create a formula but am stuck. A $100 product minus 5%.That total minus 25%.That full total minus $25.For an end total of $46.25Here's what I have as a formula, but it's just not working out! I can't tell if it's the parenthesis or the actual 25%.((({Product}-({Product}*.05))-(25%))-{COGS}) Any help is appreciated!  Thanks

I am sorting alphabetically the Primary Field which is a Single line text. It does not work. I have some data for this Primary Field that are duplicates and when I sort it, it should be right next to each other but it’s not. How can I fix this?

I have a long text field that may include newlines. Example: Where is Margaritaville? It’s in the tropics somewhere between the Port of Indecision and Southwest of Disorder, but no parallels of latitude or longitude mark the spot exactly. You don’t have to be a navigator to get there. Palm trees provide the camouflage, ocean breezes bring the seaplanes and sailboats, tourists and travelers. Passports are not required. Island music rules. No waiting lines for anything. There is a beach and a thatched roof bar perched on the edge of the turquoise sea where you can always find a bar stool. There are lots of lies and loads of stories. It’s a comical concoction that blends together like tequila, salt, and limes. Where is Margaritaville? It’s in your mind. When I use the translate block, the result has had its newlines stripped: Où est Margaritaville? C’est sous les tropiques, quelque part entre le po

Hi!I'm building RMA system in AT. I'm creating Form outside of my table for manufacturers, but some manufacturers have their own RMA form. So I want to somehow recreate their PDF (use it as a template and add my fields from AT).  Can I create Form by adding existing PDF (or photo) and just add my fields on top?Thanks.

Hi guys! Is it possible to automate the translating with google translate extension in airtable? So that you don't have to go to the extension and press the button "Translate with Google"?

Hi, How Can I batch add texts into a text field? Please see attached, how Can I add text "outdoor" into "Note" field under the exist texts?thanks

Hi allWe have been using Tableau to visualise Airtable data for a while now. As of July 3rd we are experiencing failures in Tableau, although not consistently, with error message "java.lang.RuntimeException: unknown is not supported by this version of Tableau.". Does anyone know the reason or even solution for this?Many thanks!Ester, part of Red Cross Flanders data management team

Is it possible to insert a chart or graph block into page designer? I can’t seem to figure out how. Any help will be greatly appreciated! Best wishes, Jason

Hi. I want to send a form to customers, for filling out their personal information and information of the product they want to return (but they are not sending it back yet). When we check their information and approve it, then they can send the item back to us. In this step I want to update form, by adding the field "tracking number". Is this possible?I already have a form, but I was wondering if I can update it, by adding extra field. To that I would get another field when the form is updated. I know that you can update info in a form using Fillout.Thanks in andvance

In table 1, I will collect the personal data (+ product data) of customers who want to advertise the purchased product via the form.In table 2, I would like to keep a list of all customers (with all personal data) + which complaint cases they have + the total sum of all complaints they have (per customer).How to connect the tables to each other so that all personal data that comes from the form (in table 1) is transferred to the customer table?I already tried with lookup fields, but if the same customer has two different complaint cases, the values are doubled.https://airtable.com/appAHXw6BaUIsoBE5/shrjZYXs9PpqyquLy

Hello I wanted to create a base that will auto populate Week 1, Week 2, Week 3, and so on for a number of date, Date is linked to another base which is synced to that base with a view.The purpose of this is we have a product that has a weekly interactive virtual sessions that isn't yet finished planned out so instead of putting titles of the event I wanted it to link to our content calendar where there'll be a list of week at that rage of dates and we can add records as we have.. if that makes sense. Thanks

I have a Multiple Select field that has several choices, like Camp, Membership, Donation. I want to create a Formula field that says Member or Nonmember. I know how to make an IF question for blank fields, but not for a specific Select from a field. I tried just IF(Field = “Member”), “Member”, “Nonmember”), but that doesn’t work. Thanks.

Hi, where do I find completed record when it disappeared in the table?

Y'all.  I'm losing my mind over here.  I've done other automations in the past, but I've spent 2+ hours on something simple, and still can't make it work!  I'm trying to outline a sequence of lessons for a course.  Each lesson has a Prerequisites column and a Follow-Ups column.  I simple want to create an automation that will do the following:When a record is updated in the follow-ups field,Update the records that are referenced as Follow-Ups (children) to reflect that the original record is a Prerequisite (Parent)Why is this so hard???

Entering and editing data in one logical form that is stored in multiple joined tables seems like such a common use case (e.g., contacts with addresses and phone numbers; invoices with company and line items; etc.).  Yet, this seems difficult (impractical at best) natively in AirTable.  How are people solving this?  Is the only solution really to pay $$$ for additional tools?  Or write complex scripts?Any thoughts/advice much appreciated!

I want to create a single compact form where the top half of the screen is a tabular view of my Contacts table records and the bottom half of the screen is a tabular view of my Activities table records. Any given Contact record selected in the top view is the filter criteria for Activities records displayed in the bottom view. I know how to create linked tables and fields, my question is how I create this classic (old school) parent-child DB browsing view? Thanks.

How do I share an entire table with multiple views? I don't want to share the entire base or a specific view. I want to share the table within the base, and it has multiple views. This prevents me from sharing an table of information, without having to share a link for each view.  The views I have designed make it easier to progress through helpful views of the information. There is no need for someone to get the entire base. And it makes no sense to give the person 10 view links for the same table of information, just presented differently.  It also is less helpful to provide all the views in an "everything view"; which defeats the point of using the views in the first place which is to highlight relevant information.  I don't want to have to create an interface either just to share a table.It is called Airtable, not Airview or Airbase. Why is it not more straightforward to share an entire table of views? Where can I find this feature? And if the f

IF({Status}='Complete','✅','❌')IF({Status}='Billed','✅','❌') It does not let me, how can I combine them for one formula?The status section has 15 statuses, but only these 2 can go green. Please help!

I create some summary reports for a client. Data is read from a view I iterate through the records to generate the HTML/Markdown for the email.However, to get the formatting correct, I have to use this odd amalgamation of markdown and HTML. Using one or the other alone results in unpredictable results. When using markdown to create the 2nd or 3rd level header worked on the first record. Each subsequent record simply had the "## " in the email.Also, I can't use markdown or HTML to get a horizontal rule... annoying. Any answers for this. Not critical but nice to have.  for (let i=0;i<recordsLockReady.records.length;i++) { let fileString = recordsLockReady.records[i].getCellValueAsString("File").replace(/"/g,''); let coeDateString = recordsLockReady.records[i].getCellValueAsString("COE (Estimate)"); let daysToCOE = "-n/a-"; if(coeDateString != "") { let coeDate = new Date(coeDateString);

We’re having to maintain data records in two tables, rather than one, because forms only create new records, not updates.Here’s the scenario:New Assets are created in the Assets table:ASSETSAsset NameAsset LocationModule NameAppleapple.comTruckBananabanana.comTruck; PlaneGrapegrape.comBoatThe Module Name column is Linked to the Modules table:MODULESModule NameModule Location

HELP! I am new to Airtable. I signed up... chose the lemonade stand template as a starting point, and set about my first base!   Task 1 was getting about 300 rows into the inventory table. My intent is to use this to build shopping lists for my deli. I have maybe 8 suppliers... added a column called "Category" to allow me to sort by things like Produce, Deli Meats, Beverages, etc.... Finally figured out how to import the data. Cleaned it up... and added all the categories.. Now the fun begins. I opened the app on my IPad and go to the inventory table and I see "Main View" and "Low Supply" as Views I can choose to look at the data on the ipad. I go back to the web interface, duplicate the Main View into a new view called "Shopping List" and a second called "Order List". Both of these have several filters and groupings. I also added one final column to the Inventory table called "Order" as a Yes / No check box. The workflow should look like open "SHop

I am receiving an error when testing a twitter automation. Trigger: record is created Action 1: find a record with conditions (character count=good, status =approved) Action 2: post tweet of only that record Error on action 2 test that twitter is missing the status parameter. I got a twitter automation to work the other day using similar steps, except that it was tweeting ALL records instead of just the most recent one. (Secondary issue) Question: how do i fix the status error? I’m a beginner. Please speak beginner language. Thanks!