Solved

I’m not sure this is possible. I’m trying to multiply the amount of an item by a range with an attached percentage. For example, if the fuel price is $5.00 then the range is $5.00 - $5.25 and the percentage is 2%. Then multiply the Freight Amount by the corresponding percentage of 2%. So in this scenario, Freight Amount is $100, Fuel Price is $5 so I would add 2% to the freight price for a fuel surcharge. I have Freight Amount Column, Fuel Price Column, Start Price, End Price and Percentage Columns Any ideas or work arounds would be appreciated. Thanks!

Hello everybody! Inside my base we have 10-digit codes for each of our users for passwords and such. I was wondering if I could somehow use a formula field to only show a select few digits of that code. Similar to a phone number when they send you a confirmation text you can only see the last four. Thanks!

I have a fetch that calls an API and adds all of the records to my table (Title, Date, Unique ID). That is good. Now when I make another call to the API I want to run thought the existing field, match the Unique ID and update the name and date (does not matter if they are different) and if there is no record with that Unique ID add the Title, Date and Unique ID to the end of the records. let response = await remoteFetchAsync("URL", requestOptions); let json = await response.json(); let table = base.getTable("Table"); let titleColumn = table.getField("Title") for (i=0; i < json.length; i++) { if(json[0].Title !== titleColumn){ let recordId = await table.createRecordAsync({ "Title": json[i].Title, "Date": json[i].Date, "Unique ID": json[i].uniqueID }) } }; Thanks!

Hello! I have a submission table that lists dates of a submission and an associated “office” to each submission. There can be multiple submissions a day to the same or multiple offices. I want to use a rollup to gather the number of unique dates per office, so that I have a calculation of the total days of submissions associated with each office. Is this possible? Thank you!

Hi, I want to be able to upload documents in one table. These documents are usually invoices and should be uploaded to the correct supplier. When I upload a new document, I want to create a new record in a different table, for each attachment that is being uploaded. Currently, when I run it it creates a new record but the new record contains previous uploaded attachments too. How can I ensure that it is only the latest uploaded attachment that is being created as a new record? When I bulk upload, it also creates only one record. How can I make sure that it creates one record for each attachment that is being uploaded? Here is the current trigger: Here is the current action:

I have a column that is a checkbox and would like to start capturing unique ID’s in numerical order (i.e. Autonumber) for records that have a tick in that checkbox. Is this possible?

Hello community! I have the below if statement that needs revising. The issue is that the formula assumes zero when DeStaging Date is blank, when in fact, I want to see the result from the rest of the formula to popup on my Google Calendar. What should I add? IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},“No renewal charge”,CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”))

Hiii So I am trying to track checks and employees. I have an “Employees” table and I have a separate “Checks” table. They are linked. I was able to do a rollup for each employee to get the total amount they received no problem. My issue is I want my rollup to only show me the checks they received in 2021. I see a lot of the forums talking about SWITCH and IF stuff. But what I want is different. I want the formula to look at my dates, see which ones contain the year 2021, and then spit out the check amount so I can then do a rollup on each individual year. This may be way too complicated and I would love a better answer. But ideally, I want to be able to look at how much each employee made by year in the employee table and not just in the checks table. But as each check is individually added, it would need to add up all the checks of that year from the checks table.

Is it possible to create a new view automatically with scripting?

I have created a base for my companies therapists. I want our front desk to be able to filter the data to match clients up with therapists. I’m stumped on how to add the age ranges, as they vary greatly. Some therapists see ages 3-10, others 18+, or 25-40, etc. What I’m wanting is to be able to enter the clients age, 32 for example, and be able to filter out therapists that don’t work with that age. plz help

Hi there, I’m building an app separately and I’m using Airtable as my database. In my base, I have “categories”, “brands”, “products” and “inventory” tables, where the 4 tables have proper linked fields configured as one-to-many (inventory → products → brands → categories). I need to have an API that shows records from all 4 tables based on the linked fields and using filters. After reading different help topics, it seems that the way to do this is by creating view, but I understood that creating a view with linked fields is limited to maximum 2 tables (linked and linked to tables). How can I create a view (or an API) that retrieves data from all 4 tables? Your help is highly appreciated. Thanks Fouad

Hi there, How can I create automation script to delete a record when I’m changing the status to Delete. I hope someone can help me. Thank you! @kuovonne help!

Hi, I have no coding experience, Im trying to run a Vlookup to search a value from a single select field (integrated from jotform) and bring a value from another table related to that value. Saw a script on youtube but won’t work, the only difference with the video is that the selectRecordsAsync is crossed out.

Hello, I’m trying to plug a table into Zendesk. Even though I’ve set all the access role correctly (Admin), I still have an error message saying “You do not have access to this page. Please contact the account owner of this help desk for further help.” Any idea on why I have this issue? Does come from Zendesk? Thanks

Hello there! I am brand new to Airtable formulas and was hoping to get some help. I’m attempting to calculate NPS just for this calendar year of 2022. I was able to calculate the NPS for all of my results but when I try to modify it to add in just for the year 2022 as an If/Then statement it doesn’t work. Here is what I have been attempting to use. Thank you so much for your help! IF( Date}=2022 ) THEN( {NPS Score}=BLANK(),BLANK(), IF({NPS Score} < 7,-100, IF({NPS Score} > 8,100, 0)))

Hello! I am trying to create a formula to help track tenure and extension dates for personnel. Each person has a “start date” – I want to have formula fields that calculate quarterly extensions +12 months; +15 months; +18 months Here is the formula I entered: DATEADD({Start Date},+12,‘months’) but I am getting an error

Hello, I have two fields with two different formulas: Field 1:DATEADD({Date morning Start},{Number of days},‘d’) Field 2: DATEADD({Date am Start},‘4’,‘hours’) I would like to have only one field grouping these two formulas Also, I have a third formula field but the formula doesn’t work on either the date or the time: If({field date}, 09:00, ‘true’, ‘false’) Thank you for your answer

Dear beloved friends, I would do the automation to copy text from one column to linked filed in airtable, any one could help guide on this automations? Thanks inadvance and regard!

Hello! I am trying to create timestamps of the start can completion date based off of a status field I have set up. I have a status field, a Start Date field, and a Completed field. The status has the single selections of “To Do”, “In Progress”, and “Completed”. I have set it up, so timestamps are automatically populated into the Start Date and Completed fields based off of “In Progress” and “Completed” status. I wanted to know if there was a way to clear the records within the Start Date and Completed fields when the “To Do” status is selected? Is this possible? Thank you in advance for the help!

Help! I have an automation set up that when a new record is created in one table, to create a list of ‘to-do’ items in another table. Both tasks are related by their matching ID’s. (It’s a monster of an automation, so I had to shrink it to fit! lol) The problem is that when a new record appears in the 1st table it ‘fires’ the automation, right? But most of the time it is ‘firing’ so fast that it misses the ID number in the 2nd table and JUST lists all of the ‘tasks’. What am I doing wrong here??? Thanks, DG

Hello all! I am working on a project where I am inputting data that we collect into one table based around different areas we collect from and how many days it took to collect data. In the other table, I have been manually updating the rate of collection. It is structured by: Column 1 - Date Data Collected (with some repeat dates as multiple collections happen in a single day sometimes), Column 2 - Single Selection Dropdown of the Area Collected From, and then another Column - Data Points Collected. With these columns, is it possible to update data in another table that has a list of all the offices in one column and their estimated rate of collection in another column based on new data input into the first table. I hope this makes sense and thank you for your help!

I have a table which has a Payout Month Column, which is a formula: DATETIME_FORMAT({Check-in date}, 'MMMM') How can I add the month number in front of the Month word (ie: 1 Jan)?

I need an automation that, when there is a new record received in one table, to check a box with the matching ID in another table. THE BREAKDOWN: I have a (unique ID) four-digit “Repair Order” in table1 that, when the balance = $0, sends out a “Cust Survey”. The ‘Survey’ is identified by the same (unique ID) four-digit “Repair Order” number. WORKING PERFECTLY! I then have the “Survey Results” table, or table2. When a new set of ‘Survey Results’ are received in table2, we need to locate and match the “(unique ID) four-digit “Repair Order” number in table1 and check the “Survey Received” checkbox in that table. All the sudden I can’t think of a flow for the automation!?! I do know that I can’t LINK the tables because there is nothing in table2 to link to… right? PLEASE HELP ME!!! DG :heart:

Hello all, I’m trying to figure it out for weeks to solve this problem. Base A : I want to get address data (zip code) + buying rate from this base Base B : I want to get address data (zip code) + selling rate from this base Base C: When I write that specific address/zip code and it matches with the address in Base A and Base B, I want to see buying rate and selling rate in separate columns automatically. So it is like; zip code base A + zip code base B = buying rate base A + selling rate base B in base C That would be great if you could help me to solve this issue because I’m about to lose my mind :slightly_smiling_face: What is the right way to do it? Is it by a formula? Is it by something else? Please help me. Thank you.

Hey there I still don’t get AirTable to the fullest and would appreciate some help. I got a database with Birth Dates and managed to find out peoples ages with the TONOW formula. I would want a second row telling me wether the Date filed is more then 4380 days ago or not. I tried something like IF(Date > 4380 days ago , “True”, “Not True”) As this does not work - what can I do instead? Thx for any hint.