Ask the Community

Hello! I am looking for a freelancer with references to build out my 2024 marketing tactical plan. I've used Airtable before for relatively simple project tracking, but this is more detailed. 

I’m wondering if there’s a way to open an edit record page within an Interface for a linked record field using a URL. We have several linked records fields for different resource types that get attached to our tasks, so that we can get further info about the resources associated with those tasks, but we’d prefer not to have to display on the edit page all the various linked record fields for every resource type since only one per task is actually linked. We’d used a synced table to unify the different resource types coming from different tables, but we have more than the allotted sync amount. Any idea or suggestions greatly appreciated!

Muy buenas tardes,Estoy montando mi propio gestor de proyectos, estos proyectos quiero numerarlos con números consecutivos, pero que el primer número sea un número en especifico.Por ejemplo:N. de Pedido: P003245 (Esté sería el primer campo de la tabla)Además, al crearse un nuevo pedido debe de aparecer automaticamente el número consecutivo (en el caso del ejemplo superior, P003246).Extras de funcionamiento:Además, voy a utilizar el apartado de formulario, para introducir los pedidos de una forma más automática y sencilla (no voy a ser yo la persona encargada, y se necesita sencillez). Mi consulta sería, ¿Existe alguna forma de que en el Formulario el N. de Pedido (automatizado anteriormente) aparezca de forma automática? Sin tener que incluirlo a mano.Muchas gracias____________________________________________________Hello,I'm setting up my own project

Hi, all -I'm fairly new to Airtable and use this software to track participants for trainings that we offer. In some instances we have a participant attend more than one of our trainings. I currently have our trainings set up as a multiple choice field but when I group by trainings attended, it's putting these students in a different bucket and I would rather their individual names show up in each of the attended training, not create an additional section - picture for reference of how it currently looks. Hoping this makes sense and any help is greatly appreciated! 

Hello Airtable Community,I'm encountering an issue with an automation I've set up and would appreciate any insights or advice you can offer.Here's what I'm trying to achieve: I have an automation with two steps. The first step is a "Create Record" action, where a new record is added to a table. The second step is a script that should modify a field in the newly created record.The problem: In the script part of the automation, I'm trying to access the ID of the record created in the first step. However, when I run the script, the variable that should hold the record ID (createdRecordId) is coming up as undefined.Details of my setup:The "Create Record" action seems to work fine, as a new record is indeed created.In the script, I'm using input.config() to access the record ID, like this: let inputCon

Is there a way to copy a base schema between accounts? So I don’t need the data - but I’d like to copy the schema (all the tables in a base) to another account. Is there an easy way to do this?

  

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?