Ask the Community

Hi, I'm new to airtable and am trying to get a simple conditional VAT formula to work. I feel like I am circling the solution but I'm not quite there. Essentially I am trying to track various hires and purchases for work, some of which have VAT and some do not. I have a Gross cost but I need the NET cost (without VAT).I currently have a VAT Field that is a single select field with options None and 20%. I'm trying to write a conditional formula for the NET Cost that is based on the VAT field and essentially works as follows:IF {VAT="NONE", Gross AmountIF {VAT="20%", (GROSS Amount/120)*100I keep getting invalid formula and error messages and I'm not quite sure what I'm missing.Any help greatly appreciated! 

Hello all,I have a problem that I'm trying to fix, and I have not been able to fix it with the posts with related questions.I have a field with numbers that I want to round up to another field with numbers. I'll explain the situation:So it's about ordering products. I get an order recommendation let's say for product A this is 55. But the products are packed in boxes of a certain quantity (let's say 20), so I cannot order 55 pieces, I'd have to order either 40 pieces or 60 pieces (2 or 3 boxes of 20 pieces).Is it possible to use a formula to automatically round the number upward to meet the required amount (in the examples this should be 60)?

Hello! I am trying to automate the following process: when a file is uploaded to a specific Dropbox folder, a new record is created in Airtable with the file attached. This works fine, but there is no preview in Airtable. I have created the following automation in Make (formerly Integromat):Here are the details of each step:  Below is what is seen in Airtable. As you can see, no preview is shown.I have already done some troub

I have 2 different tables in one base that I want to connect to one Calendar for easy to view access without having to switch to different calendar views constantly. Is this doable? 

   let table = base.getTable("Cashflow Grid (Sales Pipeline)"); let inputConfig = input.config(); let record = inputConfig.record; let mmyy = inputConfig.mmyy; let i = 0; const table2 = base.getTable("Cashinflows") const fieldName = "Name" const queryResult = await table2.selectRecordsAsync({fields: ["Name", "Record_ID"]}) const ids = queryResult.records.filter(record => ( record.getCellValueAsString(fieldName) == mmyy )) console.log(ids[0].id); output.set('Cashinflows_Record_ID', ids[0].id); let id1 = ids[0].id; console.log(id1); for (let records of record) { let recordId = record[i]; console.log(recordId); await table.updateRecordAsync(recordId, {'Cashinflows x 1st AZ': [{id: id1}],}) i = i+1; } console.log(record);    

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...

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

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

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

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

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?