Ask the Community

Hello everyone,I have created an Approval / Status Process for a table. The following options are available: Planning is automatically selected when a new element is created. Then a user should be able to select Ready to Review but none of the other options. This starts an approval process. After approval, the status is automatically set to Approved. Now the user should be able to switch back to Realization but none of the other statuses. Completed is automatically selected when the end date has passed.How can I ensure that the user can only select the desired options? Thank you and best Regards.

Can I add a table to “long text” field?I want to add table that include columns " code - description - price" example:code - description - price“1167 - bike tire - 75”

Hi all 🙂 I would like to import a larger amount of old emails into my base (at this moment I use a ZAP between Outlook and Airtable, but it is only for the current incoming mails).Is there a solution, or somebody had a similar problem and experience?Thank you in advanceImelda

Hi!I'm trying to design a database where products are made up of a number of different units. Let's say there are a maximum of 10 types of units, but the quantity differes from each product.For example:The product Box1 consists of 64 units of part X and 64 units of part YBox2 consists of 12 units of part XBox2 consists of 128 units of part X and 400 units of part Z.How do I design the database to make it easy to add a new product and enter information about the units?

Hi there I do not have found a solution on the community or the web to my problem I try to resolve using AT. I have a huge library of books. Instead of typing all books into a AT database (e.g. Book Catalog provided by AT) I would like to Scan the ISBN bar code (which is on each book) and populate my database with author, title, year etc. - basically all the record available on apps such as goodreads etc. After all, the barcode can be read easily, it should after reading “simply” populate the record with the relevant data. Does anybody have any idea to do this? I have read, that it may be possible using API - but I have never worked with this. If so - could anyone give me some initial information how this could be achieved? Any help is highly appreciated. Thanks

Hello Airtable Community,I am currently facing a challenge with importing data into Airtable and properly linking it to existing lookup fields. I have a set of customer names that I've exported from a FileMaker database into a CSV file, and I'm trying to import these names into my Airtable base. My goal is to link these imported names to a lookup field that references customer names in another table.Here's a brief overview of my setup:I have a table (let's call it "Customers") that contains a list of customer names.There's another table where I'm importing my data (let's call it "Orders").In the "Orders" table, I have a lookup field that should display information from the "Customers" table, based on the customer names.The issue I'm encountering is that the impo

Hello,After the customer submits a request form to the client for order fulfilment, if the client has a follow-up question for the customer - Is there a feasibility/workaround to submit a comment/question on the request so that it can be re-directed to the customer for further clarifications/information? Can somebody suggest a workaround? Thanks!

I'm looking to run a script when a record is created which would created a new form for that individual record. I need to do this because when clients will be using the forms, I can't have them be able to add data to other clients so by default I'm creating a form with the default values that can't be changed. Does anyone have a better solution to this problem or is there a way to do this?

I have a base that has all of our employees (~200) in a people tab. Every month our finance department sends me an updated Excel with everyone that months actuals in terms of employees. Given the number I would like to be able to CSV import this file and then be able to update the people, as well identify who is no longer on the list - and who is new to the list. Additionally, it would be helpful to be able to use this information in the extensions/interfaces to show charts on the over month-to-month headcount change.I think I will need to have some record indicator for each person that the records can align to but every idea I have had so far seems overly complicated. 

In AirTable, I have 3 Bases; ● One base that includes a table with all student records ● One base that includes testimonials ● One base that includes a record of all questions submitted when we do a Q&A How can we merge all these bases into one base and ensure that everything is linked?

Hi there.I am trying to create a voting system in airtable. Basically, I am hosting an awards show kind of thing (think oscars kinda structure) where people are nominated for awards, and judges vote on the nominees. There are 2 rounds: round 1, each judge in each award catagory individually rates each nominee by a set of 5 criteria; round 2, all the judges from every award get together and vote which of the top 3 from each award should win the award. I am currently finishing up round 1, and am running into a few issues. The issue that I would like to address here is about a "Power Point" or "Je Ne Sais Quoi" point that each judge is able to give 1 nominee per award (its basically there so that if a judge thinks one nominee deserves an extra point they can give it to them). The issue is that as my base is set up right now, a judge can add this Power Point to multiple nominees. Ideally I would like to make it so that if a judge decides to add the power point to anot

I have a base that is designed to be refreshed with data from a CSV file periodically. It has about 140 fields right now and I need to add approximately 50 more. I would like to be able to do this using the CSV Import app, but I can’t find a way to have it load data into existing fields AND add new columns to the base at the same time. I have field descriptions entered for most of the existing fields, which is a big reason why I don’t want to just start over with a new import to create the new fields. If I could get and set field descriptions via API, that would be another route to my goal, but I haven’t found any evidence that’s possible. Am I stuck adding the new fields one by one or is there another way? Thank you for any light you can shed.

Hi, I want to know if:1) Are there are any extensions that would help me with the ability to see the 'saved' information on the lengthy forms started by my customers but not submitted yet?2) Can one customer start multiple forms and save and come back to complete the form at a later time? Example: Adding multiple employees information one at a time by filling up a form for each employee.Thanks! 

I see that lookup fields now have an option to limit the data shown, but it seems very limited to only showing you the data associated with first or last record linked?Is there any way to limit to unique selections only but retain the color labels? We use color on single select to indicate different things like status and priority. So while i can use a Rollup Array Unique, that loses all color and becomes a comma separated list. And no, i do not want to make a special automation to then copy said results to a new field showing the results, as this is excessive and not 100% reliable when there is automation errors or server errors, etc.Would love if Rollup field could retain color on the unique array, OR lookup fields to offer more flexibility to show the unique selections.

I have an image field used in my timeline that i would like to refine. Currently the timeline label can show the first image as the cover image - perfect.Then the popup window when you click on a record should show the "hero" style view of that image lookup field, but instead is currently showing each image separately making you scroll far to see all the fields/images in the little popup window. Then you expand the record details to see the sidepanel, and the images show correctly as a Hero style viewer. - perfect. Any way to fix the popup window to have option to use the Hero viewer?

I'm trying to use this feature of passing the name of the user logged in to the record when a new record is created and it is just not working and for the life of me can not figure out why, clearly I'm missing something. 

How to create a checkbox inside a field Send Email. Need steps.

We have a use case that involves getting goal level data into GBQ so we can blend those with campaign data to build monitoring dashboards. Has anyone successfully gotten their data into GBQ and if so via which connector/ingestion service did you use? We have work arounds that involved exporting to a google sheet and then into GBQ but just wanted to check if there was a less round about method. Thanks!

Our team ran into what seems to be a pretty annoying bug with the timeline view.After a while if you keep on scrolling up/down, eventually the sidebar where it shows how things are grouped by completely disappears. To me this feels like a bug where whatever is suppose to trigger redrawing it hasn't been fired. To fix it you have to scroll again to force it to redraw, though sometimes it also still disappears. Another way to force it to redraw is to resize the splitter.I managed to replicate it in a new Base with a very simple table (see attached gif). Although it doesn't look so bad in this example, in our actual Base this can be incredibly frustrating as it's happening frequently enough, hurting Airtable's ux. 

I have an automation set up that sends an email (through gmail) based off a row.I want to send this with an attachment where the attachment is the same for all users or it is provided as a lookup field based off a value.i.e Option 1: Send all users the same attachmentOption 2: Depending on the value of a field send one of 3 attachments However it seems that with the gmail automation we can only send attachments from an attachment field in the row. So I can't just choose the attachment or point it to a lookup field.Are there any workarounds for this? I've considered Zapier/SendGrid as alternatives but would prefer not to.

Hi Everyone,I can't seem to figure out how to make a summary of all the expense records within a category. I have a table with  expense names with their respective number values and a single select to categorize the expense.However when in the interface designer I can't seem to "rollup" "sum(value)" per category to report the high level rather than every list item.  

Hi allany ideas how to solve this problem?can this be doen with the automation or do i need someone to write me script?night shifts should be split per day, if the time span is over the midnight insert a new row with the working times (Hours) on the next day ... or something like that?  Thx!  

Hi,Does anybody know why the comment section is not loading/working properly? I have this issue in multiple bases. See attached screenshot for visualisation.Hopefully somebody can help. Cheers 

I have a field where people can select multiple options. The question is “what are some emotions you experienced” and they can select from 9 options. I want to know how many people choose Joy and Anticipation, whether they’re the only options selected or if they’re part of a bunch of responses. I’ve found several ways to set up a formula field that tells me if someone ONLY chose Joy or Anticipation, but it doesn’t pick up if someone chooses Anticipation and Sadness or Joy and Anticipation together. There are too many possible combinations to realistically set up a nested IF formula. Is there a way to write a formula that will tell me if someone chooses either option, regardless of whether they chose other options too? I have tried OR, FIND, SEARCH, and REGEX, though it’s likely I’m just setting it up incorrectly! If it helps, the data is coming in through an external site via Zapier, so if needed I can change the field type from multi-select to

Hi Everyone, I am trying to prefill a form with a range of record information and just can't seem to get it to work. I would like to produce a unique prefilled form link for each record and fill the invoice number in for each.   My current formula:CONCATENATE({Base Form Link},'?prefill_Invoice=',{Record ID}) But when I click the concatenated form link it is putting the record number in the invoice field (which is supposed to be just a 5 digit number) I tried moving the invoice number from the primary field (a number) to a single line text field but still wont work Any help would be mu