Ask the Community

Structure is as follows:Project tab has all of our project records with around 50 fields of project-specific details.Some project records are categorized as "Original Project" and some are categorized as "Revision""Revisions" are linked to their "Original Project"I want to do the following:1. Create a new "revision record"2. Fill out ONLY the fields that will be changing 3. Link the "original project" in the "Original associated project field"4. When that field is updated, I want an automation to run that will copy and paste fields from the original project record to the revision project record, but ONLY for fields of the revision record that are empty.Example:"Original project record" fields/Project info:Unique Project Number: #557 (Autonumber)Customer name: John DoeSolar module: Mission Solar 400WQuantity: 25Inverter: Solaredge 7600kWProject type: Ori

Hello, this morning I noticed a change within a few of my interfaces. Certain elements aren't auto resizing, and I can't manually resize them either. This was a recent change. I tried deleting these elements and adding them back, but they seem to keep word wrapping on the value instead of the heading.    

We have a list of questions in a base that we want to email out to gather answers, or ratings on a scale of 1-5. Is this possible to automate?

Hi,I'm using a form so users can enter their data into a table. In that table one field always has to have the value "SUM" I want that every new record to be receiving default “SUM” Thank you

I'm not authorized the table in my vs code using nodejsAirtableError {error: 'NOT_AUTHORIZED',message: 'You are not authorized to perform this operation',statusCode: 403}

Hello! I'm new to Airtable formulas & could use some much needed guidance! I need to calculate the total with an option of a discount if a multi-select answer is chosen. For context, this is in reference to grades of elementary curriculum books purchased. I am trying to create a formula that will show me:If Rural Discount multi-select = 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $250 + additional invoice amount= total invoice costIf Rural Discount multi-select does NOT equal 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $500 + additional invoice amount= total invoice costHere was what my closest effort was: Additional info:

I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week 

I was wondering if there is a way to fetch data of all automations that are created in my account, as well how many times they were ran. I tried to find an API for this, but didn't found.

Hi all!I'm looking to use Noloco like @scottsworld suggested, and I'm curious if having a button to allow people to edit or create records in airtable on that interface means we'll be billed extra for these peoples since they will be doing 'creator' level actions.Thanks a bunch 🙂

Hi, I am trying to automate an email message with invoice details for the finance department to create an invoice. For each record (invoice) I have one or multiple sales, invoice lines, so each record will have fields with multiple linked data. In the body of my email I would like to split out these fields by the invoice line (sold item), but they lump together by the fields on one line.Message body build up: Below you can see Sale #1 and Sale #2 with their corresponding fields are clustered on the same line. I need them to be on separate lines with their corresponding fields:Thank you.Best regardsChristopher

Currently I have a Date & Time (duration) field.  I have combined them into  The combined date & time formula is showing a different time zone it seems?  I want it to be Los Angeles.  Is there a way to do this?"COMBINED START DATE & TIME" FORMULA:IF( ({All Day Event}), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY"), DATETIME_FORMAT({Start Date & Time}, "MM/DD/YYYY HH:mm") ) 

Hi, please help me with this automation. For added info, this is created on a Base within a workspace on a Pro plan. All members on this Base are part of this Workspace as creators.I want to assign a record to a member of my team based off another field's data. We operate in several markets (UK, Nordics, US, etc) and different team members work with different regions. When a record is created with a region, I want to automatically assign the relevant team member to that record.I have tried this multiple ways, and the only one that seems to make sense is the following, which isnt working. I have created multiple automations (1 for each market to assign to the right person)Trigger: When a record matches conditionsTable: Table 1Conditions: When market is (market name) - for this example "UK"Step 2: Update RecordTable: Table 1Record ID: "Assigned to | Name"F

Is it possible to do a header / group each section? I am looking to put a few points under different sections but I cant seem to find the option to add a heading or a divider. Kindly assist.

I've been using airtable in its most basic functionalities for a year or so now, though hoping to dive into it a little more deeply this winter. There's a specific tool I wish to build and have a roadblock that I think shows my novice status. The vision of the tool is that it'd function for capturing and organizing ideas and information I get in my day to day between the different life focuses (categories) and I'm not sure how to structure the tables or links/relationships. Essentially I currently take down my ideas and useful information in a notepad. Every once and a while I go through and sort it into some documents with sections. However, I figured why not create a form I can put the ideas into that categorizes them upon entry?For example, I'd have some main categories and each would have subcategories so I could have a field for inputting the idea, then choose the category it belongs to and subcategories and it'd organize it upon entry. For example

Hi all, i need help form you 🙂i have 2 tables : - VariantTable -CostTableThe key is the SKU, this field is in the 2 Tables.I would like to add colunn in VarianTable with the CostPrice.How to create field with Automaticaly put the CostPrice when SKU is same.  Thanks for you help

Fairly new here…so…I’ve created a form but the recipient needs to fill in the form over the course of a year (Growing vegetables for us & includes info/observations for the whole growing year)…is it possible for the recipient to save the form and add to it and then submit when all the data is complete? Or would it be better for me to create an app that they can fill in? Thanks for any advice, much appreciated.

We have a very lengthy form that requires the employee to go back and forth between apps and input information. Is there an option to save the form and go back to complete later? If this isn’t available in Airtable does anyone have any suggestions on creating a fillable (mobile) form to collect data while out in the field?

Hello everyone!Im trying to automate a LinkedIn Image Post using Make. But i have some problems:Even tho my scenario runs successfully, the post dosnt get posted to LinkedIn, the problem is the image.I dont know how to get the image from Google Sheet/Airtable to the LinkedIn module, even tho i use a HTTPmodule, which is weird.Here is the scenario:This is in the output from the LinkedIn module:The image URL is public, so Make can find it.Do you guys have any tips?

Using the insert Grid/List of Records into Automation email how can I include more than the Name field of the record,? Similar to what you can do with a Grid in the Page Layout designer? So the result in the email would look like:Name 1 Date StatusName 2 Date StatusName 3 Date Status Again this is a field in the main record that looks up related records that I want a Grid of, but with more details.

If I add an attachment of an Image via DropBox, is there any way to see, use a formula, or API, to pull the actual DropBox URL instead of the Airtable URL which of course expires?

Hi Community,I have a team annual plan. I have a base with 8 editors. How do I read this bill?Thanks!

I have a table of grants data for 20+ foundations, many of whom have overlapping grantees. I'd like to create a linked record that will pull the name of all the foundation that support a common grantee but cant figure out how to do it. Grateful for any tips/advice. Thanks!

Hey All, I’m looking to have a field that stores a hyperlink version of said URL field that is generated from a formula. I’d like to create this text(hyperlink) either via a formula, or more what I’m thinking an automation? Anyone aware of an ability to update a field with a hyperlink? Thanks

Is it possible to query my Airtable bases, add and modify records, etc. using chatGPT-like interfaces. Anyone encountered such a tool?I mean if you can ask human language questions, like "how many records created today?" just for example. 

I have an automation attached to a button, and I want to insert the user who is logged in to a field. I can’t seem to figure this out. Is there a current_user() formula?