Ask the Community

In a calendar view, I used to have the ability to click an eye to preview the calendar view AND share externally. Now when I go to the calendar view its not an option which is preventing me from getting a link to share externallyExample of the eye 

I would like to create a button or url so when it is pressed it will go to WhatsApp.com Share on WhatsApp WhatsApp Messenger: More than 2 billion people in over 180 countries use WhatsApp to stay in touch with friends and family, anytime and anywhere. WhatsApp is free and offers simple, secure, reliable messaging and calling, available on phones all over... {gsm} is the phone number and should open up WhatsApp Desktop. Any ideas?

I am looking for a view where the users can only see the modified status but unable to edit it.i have a scenario reserving a seat for an event.if two agents reserves a same seat at the same time, we cannot tell under whose name it will show as in the view it is filtered to hide reserved seats. can we get a view where they can see the finalised reservations and cannot edit anything in that view

I need help creating a formula.Basically I need this to do this:If there is an extension marked yes than the move-out date changes to how many day per the extend plus the move-out date. Ex if there is an extension original move-out date was 1/1/23 and there was 30 day extend the new date would be 1/31/23.If there is no extension then move-out date is move-out date. Ex: 1/1/23 is move out no extension then 1/1/23 stays the move-out. I would think this formula is it but it is not. IF({Is there an extension} = "yes", DATEADD({Lease End Date} + {If there is an extension how many days approved}, "days"), IF({Is there an extension} = "no", {Lease End Date}))

Hello community,I am trying to automate the following problem:I have a stock table "Stock" and a catalogue of products "Catalogue". Not all products from the Catalogue are listed in the Stock and the Stock changes on a regular basis. The availability of products from the catalogue is linked via "Link to another record" field to the stock the value used for this is the "articlenumber" So when the stock changes (e.g. we have a new product) I need to manually select the article number in the linked field for the new product.So I created an automation that runs daily at 8:00 am and runs a script that is supposed to copy values from field "Articlenumber" to field "Articlenumber-linked" in the catalogue if a record with this article number is found in the stock. This is my script:  // Get the current tableconst currentTable = base.getTable('Catalogue');const linkedTable = base.getTable('Stock');// Load all records in the current tableconst query = await currentTable.selectRecordsAs

I am trying to create an automation. I have succesfully created a trigger for when a "Delivery Date' gets updated however when i go to create the action, it will not allow me to select the trigger as the input.  Essemtially, when the delivery date is updated, i need the "Location" to update to "Out". Any help would be appreciated. Thank you

I am trying to send a form link to a customer who does not use airtable but when they try to access the link, it brings them to an airtable registration page. Is there a way around this? I want them to be able to fill out the form without having to sign-in or register. Thank you!

I want to provide some self-serve capabilities to customers so they can view and update their customer record in my Airtable, plus ideally also access a Stripe-hosted subscription management portal. I need to allow users to login to view and update various fields in their own record only - preferable magic email style login rather than make them remember yet another username & password. I also want to embed/link to a Stripe-hosted subscription portal from within this more general Airtable Portal, so a subscriber may authenticate with the general portal, then access Stripe subscription portal functionality. This requires the Airtable general portal page to host some JS : Integrate the customer portal | Stripe Documentation Does anyone have experience achieving similar things? I’ve found some candidate external apps that look like they could be useful starting points: Stacker Pory Mini Extensions Softr Noloco Jet Admin Does anyone have particular experience or recommendation for or

Hi I'm not a programmer so bear with me, i found a script online that can send information to a webhook for another automation.i have defined the following fields in the input.config( ) panelnumbers (works)message (this is a block of text with line breaks)Script:let url = "webhook url"; // Replace the [ZapWebhook] with the webhook provided from the Zap Trigger step.let config = input.config(); // This allows the Input Variables to be used in the code. await fetch(url + "?number=+" + config.numbers + "&text=" + config.message); this all works but my question is in my config.message - how can i send it with the formatting and line breaks? right now its a big block of text without line breaks when its sent to the webhook

Hello, I want to know if a button in a field in a base can open up an interface page (in list form) with pre-defined conditions? Like for example it shows only those results that satisfy certain criteria. Further any changes done on the interface should also be reflected back to the base through the click of a button. Is this possible through the script extension?

Hey thereI created a simple invoice document extension for a table. Now the new year is coming I created a new table and when I duplicate the extension, choose the new table the extension is empty. I guess the connection/affiliation to the fields are incorrect.My idea would be to create an extension template so I can duplicate it and use it for multiple tables. Is that possible or is there an easier way?

Does airtable support a user-friendly calendar field? The calendar that I currently see on an interface is not too great. I need to keep clicking the back arrow to go to previous month. So if I want to go from the year 2023 to 2018, I need to keep clicking back multiple times.  I want to know if there is a way to have a calendar that allows easy selection of years and months. If not available in airtable directly, is there an extension that can be used?

I want to add a formula where I the cell value is equal to the row number. So when I move the records around, the cell value dynamically changes. Any suggestions on how I can do this?

I work for a small institute. We'd have only 2 (max 3) editors on AirTable. Do I understand correctly that for Team it'd be 40dollars/month (for two editors) and with Enterprise it'd be 45dollars/month (for unlimited? editors)?What would you recommend (I expect we'd have 3-4 bases, of about 1500 records each)?Thanks!

Hi,I'm getting an 'over-limit' warning and I don't understand what's going on:My base shows 791 lines with records (I'm using the free version, up to 1,000 records). But, in my settings, it says I have 1341 records. I cannot see where these additional records might be.  I have no records hidden that I can figure out or any in trash.I've had the warning for 5 days now.What am I missing?Avital

I have a field where an agent selects a status and it will show last modifed by his name.But when another guy redo the same thing, it is changing to his name. How can i restrict modifcation of a field which is already done by one agent.

Dear All, for facilitating a workflow, I'd like to integrate an Calendar element in a form interface. From my understanding the new form editor is based on the interface designer, but when you are in the form builder, there is no option to add any other element. Does anyone had an Idea on how can I do that? Many thanks, Claudio

Hi all, I need to know if it is possible to somehow create a process to receive incoming data from a form on an airtable Wix site, There will be a form on my site to fill out and I would like this data to be passed to airtable. if it is necessary to write code or if there are tools dedicated to this function, any help and advice is valuable. Thank you.

I have a table in Airtable that contains a lot of data that currently is used for an app i published. Is is possible to create a website and, using the same data, create a page where this data is showed? Ex. My table contains job offers from all over the world, i want these job offers to be displayed automatically on the website (Wix or Wordpress or others) gathering data from the same table. Did someone ever experienced something similar? Thank you very much

I need to pull in the airtable table into Wix so that I can have visibility controls on wix. Is this possible?

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 connected to Table 1 and 2.  This is just a

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:let url = "MyURL"; // Webhook URLlet&n

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 paramters.I'm at my w