Ask the Community

Hello, a very simple question … How can i do an ordinary percent-calculation as follows (column “Percentage”): Region +++ Sales +++ Percentage (favored result) North +++ 40000 +++ 20 % East +++ 70000 +++ 35 % South +++ 30000 +++ 15 % West +++ 60000 ++ + 30 % ++ Sum 200000 ++ Sum 100 % How is the formula for the column “Percentage”? I tried it with “Sales/SUM(Sales)” in different ways, but the result is always 1. Shame on me, but I have no idea anymore. Thanks for advice.

Hi, I couldn't find an automation trigger that ignites actions "when a record is deleted".  I have 3 tables interconnected (Projects, Tasks and Allocations), and when a project is deleted I need to delete the associated Tasks and Allocations.  How can I do this?Thank you since now,Gustavo Chelles

  A good example of what I am trying to do . . . . when you fill out a job application and it says list your most recent employment and it provides categories for date, company, address, title, etcetera.  I want the person answering to be able to say I have two and then a table is created where they can then fill in the information for each.  The number would/could be different for individuals answering . . . I want airtable to take the answer to one question and create a custom table within the questionnaire to collect the data needed for the specific number answered.How do I create something like this in airtable?

Hi,I'm trying to find a way but have yet to find anyone who has managed to solve this specific problem. I want to include an image, a big thumbnail in the body of the email, and it needs to be fetched from an attachment field "Artwork" in the trigger record.I have tried;1. Adding the small attachment thumbnail to the body, which makes the thumbnail too small and compressed.2. Using a formula to derive a public image URL from the attachment and including that in the body, which doesn't seem to work anymore since Airtable doesn't support public URLs from attachments (?).3. Simply adding the attachment in the email and choosing "Thumbnail" which leads to an error message saying "map(Artwork, propertyGetter("thumbnails")) cannot be converted to a string".Unsure of what to try next. Thank you for any help and input!

Hi I have a formulaDATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes") Whereby {Kick off} is an date field set to ISO and 24 hour time{Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequenceI want the DATEADD formula above to return the expected job completion date and time so that I can feed it straight into my calendar. Weirdly, it's an hour out.For eg a kick off date of  2023-05-10 00:01 with a fibonacci of 21 returns 2023-05-09 23:22, when it should be 2023-05-10 00:22.Any ideas? 

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 });console.log('Variables sent to Airtable:', variables);console.log('Airtable response:', response.data);this is the code i dont know where is the problem can someone help me

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 + "&LastName=" + config.LastName + "&Phone=" + config.Phone + "&Email=" + config.Email); // Concatenates the webhook URL with query string parameters and Input Variable values. ^^^ code being used if you don’t want

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  IF({Date 1}, DATETIME_FORMAT({Date 1}, 'YYYY'),IF(NOT({Date 1}), DATETIME_FORMAT({Date 2}, 'YYYY'),IF(NOT(AND({Date 1}, {Date 2}, "Pending Date"))))) Can someone tell me where I'm going wrong? 

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)}={Total Amount Due (ToDate)},"FULLY PAID",IF({Total Amount Paid (ToDate)}>{Total Amount Due (ToDate)},"OVER-PAID","N/A"))))  There are only two fields used in the formula and i noticed that whenever the value of the {Total Amount Due (To

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 table_roof = base.getT

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 email is only send out at the end of the month.Of course I tried to read up on that because I guess I am not the first person who

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 be able to help me with this. It's a puzzle for me.Andrew 

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!