Ask the Community

Hello everyone,Any clarity or information on this time and date issue would be awesome!I have 2 tables which are linked through a record. In each table, I have a formula field which produces a date. I need the dates to match. Unfortunately, the formulas are not the same. One is based on a date field in the first table and is a dateadd formula. In the second table, it is a createdtime formula. On the first day of operations, the date is submitted through a form to the date field in the first table. The formula field in the first table adds one day to this date so that process which happen on the second day are kept track of. In the second table which keeps track of the processes which happen on the second day of operations, I have the createdtime field. I need this field to match the dateadd field so that I can automatically link the records. However, something is happening with the formulas such that they are not the same day when I want them to be. Does anyone know how to fix this?I h

 I am looking for the best way to set up an Airtable to keep track of a lot of book publishing details with minimal repetitive data entry and as human proof as possible. I’m on the free plan.  The situation:I have several book series (Power of Five, Dragons, Talonswood, Trident, Draken). Each book series has multiple books. Each book can be published in multiple formats (ebook, paperback, hardback, discrete paperback, discrete hardback). Each book is being translated into multiple languages (English, German, French, Italian). After translation, each book, in each format, needs to be uploaded to several platforms (KDP, Kobo, Ingram, Tolino, D2D). Not all books get uploaded to all platforms. For example, English language books don’t get uploaded to Tolino.  I need to somehow keep track of this mess so me and my assistant know what’s been done and what hasn’t. Also would be good to keep track of an error log so we know what’s needs to be fixed.  how would you set this up?? 

Example Of URL/Link in email thats broken, and I need help fixing: Image 2021-02-11 at 10.40.0... Use Case: This email gets sent from an air table automation. The URL is from a field in my table that I’m using CONCATENATE to dynamically add an email to the URL. DT HR: General Phase 1&2 - ... When I click on the URL in the cell in airtable it works. Example: docs.google.com Phase 2 of the Hiring Process Video Recording Phase The link is just being cut off in the email. See first image example above. Help?

Hi there!I want to transform a ChatGPT output (30 words/names) into a multi-line column (30 lines) in Airtable. I'm using Make as my automation engine and its Iterator module. I'm having trouble finding the right array formulahere is the one I have: split(trim({{5.choices[].message.content}}); newline)It would be awesome if someone could help me!! 

Hello,Quick question: when I use a record picker in an Interface, why can I create a new linked record… but not pick an existing one?It is called a “picker”, right? 😅Context: I’m building a CRM to manage photography projects. A project can have multiple venues. I’ve got a field linking to my “Venues” table, and yes — the field allows multiple links.But in the Interface: I can only select one item at a time, I can’t pick multiple existing venues, But weirdly, I can create a new venue every time. Which… leads to dozens of duplicates, breaks the logic of relational design, and honestly makes me want to go back to Google Sheets and sticky notes.You used to have this working (RIP Record Lists and side panels). It was beautiful. It made sense.Now, even for simple things like choosing two people for a project or adding a venue that already exists, I need to invent workarounds that feel more 1998 than 2025.Or it is just me that don’t really understand the new logic of the interface and re

Hello,I am working with a formula field that I have created to take a Select list value from Field 1 and change it into a number. Example:Switch ( {field 1}“Choice 1”, ‘1’,“Choice 2”,  ‘2’)The output of this is a text value of 1 or 2 not a numeric value. The tool will not allow me to use the following , the 1 and 2 turn red.Switch ( {field 1}“Choice 1”, 1,“Choice 2”,  2)Using the first switch function how do I now set the 1 and 2 to a numeric value?

Hi friends! I work for a cleaning company and we are trying to find a better way to manage our cleaning supply inventory better. We currently have a complicated situation where our cleaners need to notify us when they need cleaning supplies, we then move it to a master list, and then onto a distribution list. Cleaners often will forget to ask for a product and are in need of something so they’ll ask to grab something the day of. This always messes with our ordering process as sometimes it will be so busy when they come in, we forget to mark it down and we’ll run out of products faster than expected. Wondering if there is a way through airtable to scan the barcode and have it automatically subtract one from the master inventory.

I am hoping to use a cutdown “form” or interface designer method to enable stocktakes of our database items via mobile phone and the airtable app. I have created an interface with a barcode field to be used as a key to all the items and an associated display of the fields for each record that can be changed - location, number of items etc. As others have mentioned I was surprised ot see that sharing the interface also shares the entire base but this doesn’t worry me as its only for internal use. When I look at the barcode field for the base/table on the phone app, I can see the camera/scan option and can scan in a barcode. But when I launch the interface and see the barcode field, I can’t see a camera option. If I select the barcode field it just shows a screen keyboard and I can’t see how to enable the camera. I want to use the camera/barcode to find the item in a record list then manually enter the associated data. Also there doesn’t see to be a way to access the interface from the m

Hello everyone, I am looking for barcode readers for my company, has anyone used the services of hdwr? I’m thinking of buying these readers https://hdwr.eu/en/products/30/barcode-reader-hd73 anyone recommending?

From this URL Webhooks table changed webhook suppose to send notification for below actionsdestroyedFieldIds createdFieldsById changedFieldsByIdI have added sufficient scope permission to my webhook to get these triggers payload. When I create new field proving type and description I am not receiving response via webhook. Where as if I add new record entry to that field on Airtable web ui then I get notification in changedRecordsByIdCan anyone check if these are working functionality in webhook. Thank you

Hi, each record in my table has an email address {email} and photo {photo}. For each record, I’d like to send the record’s photo to the record’s email address. Is there a way to do this using SendGrid? I’ve tried turning on “Send as HTML” and doing <img src="{photo}"> but doesn’t work as {photo} is replaced by “filename (url-to-file)” when I only want url-to-file.

I set up an interface for reviewing and managing customer credit limits and I can’t figure out how to set a field to display with the numbers right-aligned.It would look so much better and be more readable with the currency values right-aligned the way they should be! 

Hi dear folks, I want to ask a solution suggestion on Barcode solution that our company is trying to build the inventory list which we want each item has its own barcode (any code type including QR), and we can scan it and locating its place. I would want to ask: 1). which is the best barcode generation system? anything can be better integrated to airtable? 2). which scanner we should purchase? or just using our iphone? thanks for your answering.

Hi there 🙂I have a base for keeping track of inventory for a warehouse. I'm using barcodes. I have a home table that gives an overview and stock count. There's also a table that logs every movement (in and out of items). I add a movement to the log by linking to the home table stock item that's identified by its barcode. On my phone, I can search for the item I need to link to by using my camera to scan it's actual barcode but this isn't possible with all devices. All I need to know is which tablets are able to do this as well. I'm struggling to figure this out as I need to get a tablet for my warehouse that's able to do what my phone can (without having to purchase an ipad because they're too expensive). Could someone please advise me on more affordable tablets that are able to do this? 

Hi For some reason when I try to fill-out a form, when I scan a barcode, the form does not recognize it.  I scan a barcode that reads LE100 and it will just give me the first item that's embedded in the form. And this does not happen when I use the form in the edit view nor does it happen on any other base or view. Only on the actual form does it not work correctly. The scanner works, I tried filling out the form on different computers, I refreshed the form or exit it out and open another one. We have been using the scanner for almost a year now and it worked so I have no idea why all of a sudden it's not working now. I have no idea what could possible be wrong and would like help. 

I have an existing list of barcode numbers in my base.  I need to be able to scan a stack of corresponding barcodes and have Airtable check off that barcode so that I know the barcode from the list was matched with the scanned barcodes.  Is there a way to create this in Airtable?

We utilize Airtable to keep record of barcoded assets located at 10 different locations. When we do a physical inventory we have to manually search the item by barcode number and use the checkbox field to check that it has been inventoried.  I'm looking for a way to set an automation to simply scan a barcode the item being inventoried and using automation Airtable will find the record and update the checkbox field.

Please have pity on an absolute newbie. I have been tasked with creating an inventory control system for a community theatre’s extensive prop inventory. What I would like to do is create barcodes for each item, and then devise a simple way to check them in and out. I am confused by the airtable app barcode function - it appears to allow me to scan barcodes only when creating records. Can I use it to scan the actual item in the warehouse and pull up the existing record? In a perfect world, our users would be able to go to the warehouse, pull out half a dozen items, scan them and have the inventory location move from it’s designated shelf to a “checked out to:______________” status. Can I get there from here, or do I need to seek another solution? Cheers, Randy Storms Newport Performing Arts Center Newport, Oregon USA

Hello, we are a Charlotte-based organization and started experimenting with Airtable in our Operations department and now are trying to build Airtable for our organizational project management. We are looking for a contractor/consultant that is ideally in the Charlotte area and able to help us with our base, tables, interfaces and dashboards, ideally building it in a way we can easily manipulate in the future, if needed (e.g. no code?)  -Susan 

Hello. I am working on a form to list specific medications, the vendor it originates from, cost, qty, etc. I’d like to be able to input the brand names of medications into the form and have the generic names of that specific medication auto-populate in a field below the brand name on the form and in the grid view. I’ve tried creating a separate table and inputting the medication brand and generic names in a list, but I cannot figure out how to use conditional formatting (or lookup) to populate the generic name in the form. Hopefully this makes sense. I’m struggling to describe what I’m looking for. Example: Single Line Text Field: Medication Brand Name - Adrenaline Conditional Field: Medication Generic Name (to auto-populate) - Epinephrine

Hello! I am looking for an advanced questionnaire, either in Forms for Airtable or an integration. I would need it to be in sections (each section having a little header with directions), and an if-then conditional type of response, where if they answer a question one way, the next thing pops up based on that answer.Any thoughts on how to do this in Airtable or what integrations may be best for this?Thanks!  

I am on the free plan. A few Co-workers can add an event to the calendar by submitting a shared form. The Airtable calendar is then updated. That works well. But say they need to delete an event. How can that be done using the same form, or do I need to make a new shared form? 

My organization is implementing a new Airtable base structure complete with integrations with Softr, Fillout, and Make. It’s a complex build that has taken over a year to build. We recently upgraded to Business to take advantage of higher record limits and 2-way table sync. Now I have learned of the limitations of the 2-way sync and I am doubting everything.We were advised to design our operation in two bases; let’s call them People and Things. About half of the tables in each base have been synced into the other base. Here’s the problem:A table in People (Names) is synced to Things The synced Names table needs a rollup from a table in Things (Furniture). A linked field and the rollup are added to the synced table. We need that rollup back in the People base, but it does not sync back because of how 2-way syncing works (records sync, not fields native to in the target base). So, we sync Furniture to the People base - it includes the linked field to the Names table on Things. We try to

We have embedded an iframe with an Airtable Interface into our Website. The problem is that the content of the iframe is not updating in realtime once i change data inside Airtable which SHOULD reflect in an immediate change of the iframe (Interface) contents. The content in the Airtable Interface however is updated immediately - only the website embedded iframe is still showing old content.How can i make the content inside the iframe update immediately?

Hello!I am trying to create a field that returns matching values from 2 other fields.In the screenshot below, ‘Budget’ and ‘Offered’ have the same options (multi-select fields). I would like to have the third field, ‘Budgeted and Offered’ that shows the matching options from those fields.   How can this be accomplished within airtable?