Ask the Community

Hi,I have added a number of bases to a screen/page on my Samsung A53. Normally, I would just be able to click the icon and this would bring up the base concerned - but this hasn't worked in the last couple of weeks. Instead, all I get is the list of my Airtable bases after a lengthy wait (not at all unusual).Would anyone be able to offer insight?Thanks  

Hi, How do I get currency (ie. $22.00) to display the cents “.00” when exporting? I have an integromat automation that links Airtable to email and when I use mapping for my dollar amount it only shows the whole number (ie. $22.00 shows 22 – $22.50 shows 22.5). Thanks!

Hello community,Please, can someone explain (or where can I find the information) on how to add 2 decimal places after the comma in the currency format in email automation?Thanks

Hi all,I'm using Airtable to plan and track renovation and landscaping tasks. I have a table that has one field (text) for tasks and a 'prerequisites' field that is linked to the tasks field. This shows me other tasks that need to be done first. I am trying to create a formula that will show me whether the task at hand is a prerequisite task for any others.I tried  IF(FIND(Task, Prerequisite), "Yes", "No")  but that (kind of obviously) always return "No" because a task is never a prerequisite of itself.How can I get it to identify if the a task is a prerequisite for any other task?Alternatively, is it possible yet to automatically produce a field for the link in the opposite direction when records are linked within the same table?Thanks!

I am planning on doing a clean install, totally reinstalling my MAC when Apple releases the next version of the OS this Sept. In preparation I wanted to create an Air Table with the license keys and more importantly the location to the installation files. I would like to be able to click on the field and then open the location of the install files. Thanks in Advance. Steve

I am using a date and time field that shows in ET- i.e 9/22/2023 11:00am. It was showing up in a weird way in automations, so i followed a formula that i saw in a pervious post to format it -DATETIME_FORMAT({Launch Date & Time},'M/D/YYYY \\at h:mma') - but then for some reason it's showing is as "9/22/2023 at 4:00pm". I obviously want it to show as "9/22/2023 at 11:00am"- What am i doing wrong?

in what i am working ?i am working with a bot the bot ask questions and the response have to apered in airtable but its not working i try to fix it with a staff of botpress that is were i do the bot but they told me that it was an error of air tableconst airtableAccessToken = 'patrKShGndYDE36XQ.c35584fd7450be9fba9669453b09eac22583d3aa7d584d5b42ce7ede4da3822b';const variables = {name: workflow.name,email: workflow.email,phone: workflow.phone,budgetforproject: workflow.budgetforproject,service: workflow.service,adress: workflow.adress};const url = 'https://api.airtable.com/v0/appFWL0WUh6Sd78Im/color%20flux%2023';const headers = {Authorization: Bearer ${airtableAccessToken},'Content-Type': 'application/json'};const response = await axios.post(url, { records: [{ fields: variables }] }, { headers

I am attempting to send information from Airtable to Zapier and ultimately a message to a client. I am using the Automations > When Record Is Created trigger to Run Script. I am using the script from this article: Instant Webhooks with Zapier and Airtable My automation says it runs successfully in Airtable, and my Zapier says the Catch Hook runs successfully, but my QueryString is returning everything “Undefined” Basically none of the data is being sent from Airtable to Zapier. let url = "[ZapWebhook]"; // 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 + "?RecordID=" + config.RecordID + "&FirstName=" + config.FirstName + "&LastNa

Greetings! I'm currently exploring how to sort data in columns while using Airtable's grid interface. I can successfully sort data on the backend, but I'm seeking a way to enable users and viewers to sort this data directly within Airtable's grid interface. Your guidance on this matter would be greatly appreciated.Thank you!

Hi everyone,I'm trying to create a formula field that pulls either one of two dates (depending on which one is the earliest) or gives "Pending Date" if both columns are empty. I've tried several different formulas and have gotten close, but I can't get the formula to fill in "pending date" still -- it always gives me #ERROR. Here are two formulas I have tried: IF(IS_BEFORE({Date 1}, {Date 2}), DATETIME_FORMAT({Date 1}, 'YYYY'),IF({Date 1}=BLANK(), DATETIME_FORMAT({Date 2}, "YYYY", "Pending Date")))and  I

Hello Everyone!Can someone help me troubleshoot why using IF formula with arguments containing field values with decimal points return errors? All the fields are in currency format with precision of 1.00 except one with duration type field in seconds and in decimal format. Here's my formula and there's at least 4 different results to expect (FULLY-PAID, PARTIALLY-PAID, OVER-PAID, NO PAYMENT and N/A if all 4 logical arguments are false. Below is my formula.  IF({Total Amount Paid (ToDate)}=0,"NO PAYMENT",IF({Total Amount Paid (ToDate)}<{Total Amount Due (ToDate)},"PARTIALLY-PAID",IF({Total Amount Paid (ToDate)}=

Hello,I have a script running automatically when the USD balance of my expense sheet is changed. It updates the balance column to track expenses.   // change these names to pick a view: let table = base.getTable('Tangle Treasury Expenses'); let view = table.getView('Grid view'); let result = await view.selectRecordsAsync(); let runningTotal = 0; for (let record of result.records) { // change the field names here to adapt this script to your base runningTotal += record.getCellValue('USD Formula'); await table.updateRecordAsync(record, { 'USD Balance': runningTotal, }); }   It keeps timing out at 30 seconds. Randomly it successfully completes at 28 seconds but rare.Any options to fix this?

I am attempting to authorize an AirTable application to use OAuth with Matillion ETL (an orchestration tool).I am getting a an error while trying to authorize the application, related to the "state" field not being configured correctly. Can anyone help?

Hello, I am creating a json object from my airtable data to send it to a google script: //Table Bail --> xxxxx //Table Locataire --> xxxxx //Table Facturation --> xxxxx //Table Roof --> xxxx //Table Chambre --> xxxxx let url = "https://script.google.com/macros/s/XXXXXX"; const id_bail = input.config().id_bail; //Recupere l'id du bail let table_bail = base.getTable("xxxxxx"); let query_bail = await table_bail.selectRecordsAsync(); let record_bail = query_bail.getRecord(id_bail); //on filtre la base en fonction de l'id du client ////////////////////////////////////////////////////////////////////// let error_log = record_bail.getCellValue("Error_Log") let bail_statut = record_bail.getCellValue("Statut_bail") if (error_log !== null){ console.error(` Oups, une erreur est survenue: \n${error_log}`) } else if (bail_statut !== "Fini"){ //Table Roof let id_roof = record_bail.getCellValue("Roof"); //id_roof associé au bail let ta

Dear community,We have a group coffee and drinks pool at work that everyone can help themselves to as long as they write up their use. I am using airtable to track everyones consumption and payments, which works great. I managed to set up automations for emails to notify what the users owe and when their payment has been received. The only thing that I can't figure out for the life of me is how I set up an automated email reminder if they haven't paid after 14 days.I have the following table (simplified):Let's say I do the invoicing every 15th of the month and want to send out a payment reminder on the last day of the month. In my example above person ABC wouldn't need a reminder because they already paid while person XYZ still owes $30. I figured out how to send out an email if the Total is >$0 but I can't figure out how to make it conditional that this

HiFirst time here ! I have a problem with the Google form automation. I use the trigger "When response arrive" to get the answer from a Google form. The automation was working well, retrieving the answers from the google sheet and adding them to my database. But for a few weeks now, the retrieval no longer works (it doesn't trigger at all). I've checked that the trigger and action tests are ok.I also noticed that when I modified the width of a line in google sheet, the automatization was triggered and brought back all the records that hadn't been taken.  I've tried duplicating the automation and reconfiguring the trigger, but it doesn't change anything....

Hello! I have two fields as per this table:ScoreLikelihood15%220%340%460%580%Is it possible to type a score 1-5 in that field and return the associated percentage in the Likelihood field. Then also being able to do the reverse when needed: ie. typing in the percentage in the likelihhood field and return the associated score in the score field? Many thanks to anyone who might

I have a table with many fields but only a few records. Horizontally scrolling to see all the fields when there’s a lot of empty vertical space feels weird. Is there a way to flip the display of rows and columns so the screen space is used more efficiently for these kinds of tables? To be clear - I’m not talking about pivoting the data. I just want to see rows vertically to make best use of the space.

Hey everyone, I’m looking for an option to quickly add another record within a multi select field at mass without having to do it manually for each one. Eg. Taking geographies as an example. I have a bunch of fields that have Europe and I want to be able to easily add ‘France’ without having to go into the cell manually, in fear that France will just override Europe and there will only be one value. Would appreciate any help! Thanks

Hi all,I am stumped but I feel like the answer is staring me in the face!  Hoping yall can help!I have a membership tracking base set up as follows:TablesPeopleEventsAttendancePeople and events are stand-alone tables.  The Attendance table basically links them with a field for People and a field for the Event.What I need is a total number of events (within a date range) to be used in calculating a minimum attendance requirement per person.Anyone have an idea how to accomplish this?  TIA!EDIT:  I know how to calculate how many events each person has attended.  What I need is the total number of events so I can do a formula something like {# Attended} / {Total Events} = % of Events Attended.  Thanks!

Good afternoon, I am very new to Airtable. You will realize it, if you read my post ! :slightly_smiling_face: I have a table with the dates and times of arrivals and departures of guests at the airport. I want to know the number of days I will have to allocate the cars that will transport them. The cars are rented on a full day basis. I am trying to calculate the number of days for the cars, taking into consideration the dates of arrivals and departures of the guests. I am using the formula DATETIME_DIFF({Date departure},{Date arrival},‘d’)+1 The formula is returning the result taking also into account the time of the day of the arrival and departure, and I really want only the full day. I believe that the solution is very simple, but someone can help. For example, one guest arrives on 26/06 at 11:00am and departs on 02/07 at 09:00am. the result that I’m trying to obtain is 7 days, and not 6 days Many thanks in a

That's a bizarrely framed title, but I'm unsure how to surmise..Here's what I'm trying to do:I run a garden. We have 3 different nutrition programs, that use a different mix of ingredients, and share some ingredients. The amount to make depends on how many m2 are to be treated (or how many L of water are used to drench seedlings).These programs are:Foliar 1 (mixed for m2)Foliar 2 (mixed for m2)Transplant Drench (mixed to vol of water used for seedling drench).I need to keep records for our organics certification on what inputs are used, and when and where they are used.So I want the user to be able to select "Foliar 1," input how many m2 of garden they are treating (or how many L of water they are using to drench seedlings). I then want Airtable to "generate" the quantities of each input they need, without needing to do any potentially confusing math. It ca

OVERVIEWI'm using Airtable as a main inventory of the products I sell.I have a table wherein a new record is created with an SKU whenever I scan a barcode of my product. WHAT I WANT TO ACHIEVEThe Main Inventory is located in another table. I just want to automatically link the MAIN INVENTORY whenever the StocktakeID ( or SKU) has a match.Here's my automation PROBLEM: The test works but nothing happened. I also tried doing a direct automation like When a Record is created, upda

Continuing the discussion from Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B: Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B To me this sounds like a job for a rollup. Not knowing the specifics of your base, I’m going to just take a

Hoping for some help! I have a column with a date in, and two other columns, one with a start date and one with an end date, I want to do a conditional / IF rollup that brings me through a value if the date in question falls between the start date and end date in my other columns grateful for any help!