Ask the Community

I have a field defined as Currency however when I add that field to the Message section of an email that I am creating from an Automation, the value does not appear as Currency. It does have the decimal point for the cents, and I can easily add “$” as part of the preceding text, but I would really like to see the commas that are part of the defined format on the field. Any ideas?

What would be the most practical way to incorporate multiple tables worth of calendars into one?  In an interface, to be specific.I have three tables worth of data I'd like to mix together in a single calendar.  I suppose I could have them all in one table, but I'm concerned it might make things a bit busy in that main table.I have Table 1 that is basically like a CRM for any incoming proposal requests for my business and I have a few date fields there.  3 sets of start and end dates to cover dates we'd hold for the client.Then I have Table 2 where we actually schedule specific events.  Just a start date (with a time) and an end date (with a time) for a specific event stemming from an approved project in Table 1.  1 entry in Table 1 could have 20 events in Table 2, mind you.  But every Table 2 event is linked to an entry in Table 1, so there's already a natural link there.Table 3, on the other hand, is less con

Hi EveryoneI have been trying to link my airtable base with Make.com via a webhook that then uses a 'get a record' module to view what has gone into the base and can change the fields via chatGPT and place it back into airtable with the 'update a record' module. The webhook is working fine and both of the airtable modules can find my base. my problem is that when I try to run once on make.com the process stops at this 'get a record' module and gives the fault code:BundleValidationErrorValidation failed for 1 parameter(s).Missing value of required parameter 'id'.My current assumption is that it is to do with the 'recordID' variable within airtable and I have tried looking into a lot of other possibilities but I have hit a wall now and don't know what else there is that I can try to change to make it work as it is intended. Any help is greatly appreciated.This is the code that I have used in the Automations section:

Hi, I'm trying to set up a filter to target certain records, but it appears like they are not filtering as they should.So basically I'm trying to exclude records that contain certain words in a field, but they still show up, as you'll see in the attached screenshot.I've played around with "AND", "OR", "contains", "does not contain" but the records always show.Thanks in advance for any help 

Within an HTML form, my users must submit a photo that is critical for validating accompanying data in the submission, but I cannot get Airtable to recognize my attachment as an image.The form is processed with Google Apps Scripts, saving the image to my Google Drive (w/ public permissions), returning the newly created url. I then pass that URL to Airtable via a webhook and the file is uploaded in the appropriate field, however, I cannot get Airtable to recognize the file as an image. Instead, it's given a type of 'text/html' with the name of 'convert' (the name is of no concern, only mentioning it in case it helps to expose the issue).Ive tried creating/saving the file to my Drive as a blob & base64 -- I've tried setting the file type upon saving to Drive and I've tried without -- all successfully saving as images to Drive, but not once recognized as an image in Airtable. I've tried sending the Drive url as-is and I've also tried removing some of the included para

The aim is to use a form to book seating for film screenings, however, the issue is that the form must show how many seats are available. I was thinking of possibly using a rollup to connect fields with the maximum capacity, the number of previously reserved seats, and thus a field in the form which would show how many seats remain available. I'm not entirely sure this could work, but I would appreciate any and all ideas to solve this!

Hey all!I'm trying to embed some search functionality on my personal training website, so that users can search for trainers in our team by postcode or specialisms, and then click through to the URL of that trainer once they've found them.My understanding is you can't currently embed interfaces using Airtable.I've started using Glide recently, and it offers this functionality but unfortunately it looks like you have to pay for the whopping £250/month business plan for the privilege. Eek.Does anyone know of any other platforms that offer this functionality, e.g. Softr etc? It may be worth a small subscription fee if I can find the right platform.Thanks in advance! 

I have successfully gotten airtable to upload a PNG and a PDF from Dropbox. But when airtable processes the file, the type is listed as text/html If I include a type field, I get an error: { "fields": { "Type": "Test", "Comment": "", "Attachments": [ { "url": "https://www.dropbox.com/s/XXXXXXX/robots.png?dl=1", "type": "image/png" } ], "User": "", "Part": [ "recFI6JhdkwTCeB9q" ] } } And I receive this: { "error": { "type": "INVALID_ATTACHMENT_OBJECT", "message": "Invalid attachment object for field Attachments: {\n \\"url\\": \\"https://www.dropbox.com/s/XXXXXXXX/robots.png?dl=1\\",\n \\"type\\": \\"image/png\\"\n}" } } But if i just strio out the “type” there is no error, just the type is wrong.

Hi, I've been struggling with this for an hour and I'm hoping someone might be able to help.I have a Timeline Interface that displays a series of tasks, and I want my users to be able to edit the task fields - changing the assignee or the status for instance. I would either like to be able to add additional fields here to the initial small modal that appears when you click a task:Or, I would like to make the fields in the sidesheet editable. Based on what it says on this documentation page that should be possible, i.e. Click into record details - This setting allows end users to expand a record to see more details. You can choose to 

Hi, Is there a way for me to automate the following:1. a team member is @mentioned2. The @mention would automatically be placed into the "Mentions/Comments" TableThe reason I am trying to do this, is because I am trying to build an interface/dashboard for each team member where they will see their daily calendar; tasks assigned to them and any comments in which they were @mentioned. Hope this makes sense.

I have a field which contains product names with measurement unit in the same field."Product Name 100grams" or "Product Name 500ml"I want to create a formula to extract 100grams or 500ml (these measurement units need not to be in the last place of the field.Is there any way to grab these units?

So I have two tables the "products" table and the "Wholesale Products Sync", the trigger of this automation is when a field is unchecked in the "products" table I would run this find records action: then I would run this script to delete the record in "wholesale products sync" but I get an error:  

Hi! Does anyone know or have resources on how to setup the task view with "all tasks / my tasks" as show in the screenshot below and in this video (at 15:05)? Thanks so much!  

I have three tables in one base - Schools, Teachers (teachers are linked to a school) and Bookings (bookings are linked to a school and a teacher).  I would like to create a one linked text field that I can update in any of these tables.  How do I do that?  I don't want to swap to a different table or click into a linked record to update the text.

Hello everyone! Relatively new to scripts, but I think I am starting to get the hang of it.Basically, I am trying to convert a currently overloaded automation into a script for easier maintenance and better customization. Overly simplified automation process:If record is updated > set [Ticket Status] = [Status] for that recordThe script so far: let table = base.getTable("Quick Adds"); let inputConfig = input.config(); await table.updateRecordAsync(inputConfig.RecordId,{ "Ticket Status" : inputConfig.Status }) console.log(`The value of Status is ${inputConfig.Status}`); If I remove the "await" line, everything runs and it outputs the status value. When I run the script with the addition of updating the second field, I get a "Error: Field "fldjRCz6y0ku2XxIY" cannot accept the provided value." for line 3.inputConfig.

There are a few options to fill in external forms by filling them with the data coming from Airtable. I mentioned earlier Selenium https://www.selenium.dev/ but it has a high learning curve and working with code.There is another more user friendly app Katalon based on Selenium https://katalon.com/ , but still requires working with code and this requires manual loading of CSV.There is Axiom https://axiom.ai/ which is quite good but pricing is quite high to get Make or Zapier integration, although the lower tear works with Google Sheets.And then there is https://browserflow.app/ which works via Google Sheets The main issue I have is how

Hi Everyone, I want to create multiple forms to gather contacts for different reasons - Subscribers who want our newsletter Those who want to download our resource Those who fill out our profile form All of the forms capture Name, Email and then they have different fields. I want to keep all these contacts in the same table. I was hoping to have one table with 3 different form views. The issue is, I want to track how each contact came in, and I can’t figure out how to tag the submitted responses by the form they submitted. Instead, I have these split across different tables and I manually tag each, then copy/paste new responses into a master list. Am I missing something obvious here? I keep all the tables structured the same so the copy/paste to master is easy.

I am in search of a roadmap to becoming a certified expert on Airtable. Would anyone be able to point me in the right direction?Would be greatly appreciated. 

I am currently developing a restaurant app in Bravo connected to Airtable, and I could use some assistance. I've created a script on Airtable that selects a random record from my database of restaurants. The objective is to display the image of a randomly chosen restaurant from Airtable when a specific button is clicked within my Bravo app.I'm facing two challenges:I need to make an API call to my Airtable script, but I'm unsure how to obtain the API URL for the script. In the image enclosed it's said "your script code (including any sensitive data or API keys) will be visible in shared base links" but I don't see the result of the Airtable script in Bravo. Is it due to my billing plan?I'm struggling with data binding to trigger the event in Bravo and execute the script.Your guidance on these matters would be greatly appreciated. Thank you in advance for your assistance!

We have a table called Documents and I want to use a formula that pulls the name of the file in the {Attachment} field in order to provide the Name of the record. I've been using the LEFT({Attachments},FIND("(",{Attachments})-1) for this purpose and it works great, but I've now found that if the name of the attached file contains a comma, then the formula name adds a quotation mark at the beginning of the name. So now I'm trying to combine the SUBSTITUTE and FIND formulas to:1. Look at the name of the attached file, and if it contains a comma then replace it with a hyphen (eg. 'Ocala, FL' becomes 'Ocala-FL' )  2. Then use the name of the attached file as the name of the record without the URL at the end (using the FIND formula). Another acceptable option would be to just remove the comma from any

Is there any way to be notified when a base has no new records in a period of time.I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.Anyone know of a way to do this?

Hi there,In the last few months we been happy with getting an email on each new lead being created in one of our tables. The email contains all the needed data relevant for our sales team. BUT i'd really want that email to contain an attachment which is a .eml file (email) which is populated specifically with the records data. How can i accomplish this?Goal is to minimize errors when our sales rep copy/paste the data from the email. 

Hello,Looking at the current Airtable fields API, there doesn't seem a way to view or modify the filters for count and rollup fields. If I look at the field options for either of these field types, this does not seem to be supported. Is there a possibility to create a rollup field with a filter programmatically, and/or to see which filters are applied on an existing rollup field?If this is currently not feasible, do we know if there are any plans to implement this in the future?Thank you in advance.

I have embedded a “grid view with grouping by date” into a page on my website. When I view it in a browser on my desktop it looks fine. But when I view it in a browser on my Android phone (mobile), the grouping does not show and there is no menu bar at the top of the grid view. Menu Should be: Hidden Fields, Filter, Grouping, Sort, row height, print (this menu does not show on mobile) What am I doing wrong? https://lircal.com/airtable-browse-view

I saw elsewhere that Airtable-limited markdown is available for Automations (possibly only for emails? - not clear), but I can’t seem to get the markdown to work for Slack message automations. :loudspeaker: : The Accounting base in :airtable: has been updated by  [Record (Step 1: Trigger) | Field values | By | Name] with the following release notes: ‏‎[Record (Step 1: Trigger) | Field values | Description ] So that the message in Slack looks like this: :loudspeaker: : The Accounting base in :airtable: has been updated by frozenforum with the following release notes: Created a new Client Companies table Converted Client Company field to be a link to Clie