Solved

Hi! I am trying to create a simple If formula that shows how much my clients owe me. So if the amount billed is equal to the amount paid, show £0 else show the balance. My issue is, I am trying to append the £ sign before the balance calculation but it doesn’t work. IF({Amount Billed}={Amount Paid}, “£0”, ‘£’ & {Amount Billed}-{Amount Paid}) It only works if I place the £ after the balance. IF({Amount Billed}={Amount Paid}, “£0”,{Amount Billed}-{Amount Paid}&’ £’) Any help on how I can accomplish this?

I need to compare two date fields to get a specific result. I am not an expert at Airtable, so my explanation isn’t very good :). My base is for tracking training. I need to mark a month “excused” if a person’s hire date is after the meeting date and then mark the month as completed or missed if their hire date is before the meeting date. The hire date is 9/1/2022, and the meeting date is 10/1/2022. That person is required to complete the monthly program. Any suggestions on a formula? - Wendy in Michigan.

Running into a problem creating an order tracking form. I have 4 tables Customer Info - name, address, etc… Product List - products and prices Orders - each row has customer name and product and product quantity purchased. Primary field is a formula concatenating Customer name and product they purchased Now I’m creating a 4th table Order summary by customer. Primary field is an Autonumber. Second column is a linked record to Customer Name pulled from the Customer Info table. What I want to do is group by customer, everything they ordered and the total they owe. Where I am running intotrouble is I can’t pull the Quantity field from the Orders table using a Lookup; I don’t know why. Please help! Thank you

I keep getting the “Microsoft reported an error while processing this action: Id is malformed” error. I tried creating an autonumber field called “Event ID” that I reference in the Event ID automation field. Is this an ID I have to manually enter from a source? Thanks

I am connected the API of Airtable to Power BI but at the time of displaying the data it only shows me 100 records when the base has more than 1000 records.

I have 4 columns in my table, each containing numbers. In the Formula column called ‘Above Threshold’ I’m trying to create a formula that says if any of the values across the 4 columns is >100 output ‘Above’ and if <=100 output ‘Below’. So something like this IF(({Total users (last 30d)},{Total users (prev 30d)},{Total users (last 90d-120d)},{Total users (last 120d-150d)},)>100, "Above", "Below") That formula doesn’t work, so is there a way of doing it without using nested IF statements?

I have a table with Rating field which can have value up to 7. With current API I can get value for each record, but I can’t get metadata for that field, to know possible max value. Is it possible at all?

I am trying to create and if and statement for one field being empty and the other being filled. My fields Problem Category Closed Date Closed date always needs to be filled for me to provide a return to my field Charge Type. If the problem category is blank then I need to return “Marketable”. If the problem category is filled then I need to return “Problem”. I have tried multiple If And statements always getting an error or undesirable result. The latest one I have gotten is as follows If (And( Problem Category = BLANK(), Closed Date != BLANK()), “Marketable”, “Problem”)

Hi, so I am trying to make a formula that fits my gardening schedule for the upcoming spring season. I have the pro plan if that makes a difference in what I am limited to do. Here’s an live example of the problem I am having so far. I will plant my cilantro seeds on 3/22/23. It takes 4 weeks till harvest. So I have 4/12/2023 as the ending date. I will need two other harvest date’s after that. The problem is that I need formulas for each plant which is a total of 40. They all have different dates and different weeks till harvest. Would I need different formulas for an auto-fill each time I put seeds into the ground or am I able to create conditions for it to all work? Thanks.

Heyy everyone, I wonder if you can help, I am not the best at Airtable so rely mostly on learning as I go and your threads. I currently have several columns which count the time(days) between Date 1 and Date 2 but now I am looking to make it exclude a list of public holidays, currently, it just measures working days. So this is the formula currently - IF(OR({DATE 1} = BLANK(),{Date 1}<{Date 2}), BLANK(), MAX(WORKDAY_DIFF({Date 2},{Confirmed Date 1})-1,0)) But I can not seem to figure out how to make this formula not count the below, I’d have to implement this into several columns with similar formulas ! 01/01/2021 02/04/2021 05/05/2021 31/05/2021 30/08/2021 27/12/2021 28/12/2021 03/01/2022 15/04/2022 18/04/2022 02/05/2022 02/06/2022 03/06/2022 29/08/2022 19/09/2022 26/12/2022 27/12/2022 02/01/2023 07/04/2023 10/04/2023 01/05/2023 29/05/2023 28/08/2023 25/12/2023 26/12/2023 Any help is welcomed :slightly_smiling_face: Thanks

I think I should be able to do this but I’m not sure how. (I’m definitely an AT beginner!) I have a base for managing summer rentals. I’m pretty much treating it as a spreadsheet with each record a tenant name and then a bunch of info in fields… Lease, total rent, deposit, deposit received, etc. I’ve used this base for two years. I have a formula for figuring the lodging tax BUT it has changed this year. 1) I don’t want to change the formula since that will impact my records for the last two years 2) how do I set up AT so that I can reflect changing tax rates over the years? I think I should have a another sheet that calculates the tax and then pulls it into my main sheet based on the year I’m working in. create a table for the taxes and then a lookup formula? I’m not clear on how to do that. On the main sheet is a column that is empty which is where I think I should be pulling in the tax info…?

Hi We would really appreciate some assistance with one of our formula fields. Background - also see screenshot: In our first column, we have a date field called “Lifetime Last Payment”, which we manually complete. In our second column, we have a formula field called “Lifetime Next Payment” with the following formula: IF({Lifetime Last Payment}=BLANK(),BLANK(), DATEADD({Lifetime Last Payment},1,“months”)) Which automatically calculates by taking the date from “Lifetime Last Payment” and adding one month. Our third column has a formula field called ” Lifetime Payment Status” with the following formula: IF({Lifetime Next Payment}<=TODAY(),“ :triangular_flag_on_post: Change Last Payment date”, BLANK()) In our fourth column, we have another formula field called “Final Lifetime Instalment Date”, which calculates the final date of payment for each individual line based on the instalment criteria. Requirement: We need help adding/updating our third column formula: IF({Lifetime Next Payment

I am having a bit of an issue because right now I have an automation that takes that takes the URL from the image as a formula and when the automation is run, puts the image url in the attachments field of another table. Right now this works great, however, I know that Airtable has an update to the attachment field coming soon that will make those links expire every 3 hours. Is there a way to have an automation take an image and put it in an attachment field other than with the link method I am currently using, so it will not impact me after Airtables Attachment update comes out? Thanks in advance for your help!

Hi all. I have a fairly quick problem. I’m a relative novice to JavaScript and coding, so forgive me if this is a silly question. I found some code that will duplicate a record and copy all fields, with the ability to exclude certain fields. I can fill in my table and exclusion fields, and it works as intended. The original thread is here: Script to duplicate a record with select fields only or create new item based on another Extensions We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item. I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI. I am looking to do exactly what was described in this post. T

I have seen that many people are requesting advanced permissions but haven’t seen my use-case if somebody could please confirm whether this is possible. I would like to know if you can allow user view/edit rights based on cell value. I’m very new to Airtable so perhaps there’s a good way of doing this without me thinking like I’m working in Excel! I’ll use the most simple example I can think of below. Company XYZ has sales team made up of East and West, users are assigned to each team in a table. Person A - East Person B - West Then there are prospects in a new table assigned to a Team and person. When adding a new prospect, the prospect should default to the team that the sales person is attached to. Prospect A - East - Person A Prospect B - West - Person B What combination of the following can I do please? Make it so that all sales people can view all prospects but only the team who owns the prospect can edit Make it so that only the team that owns the prospect can view the prospec

I’d like to create a calculated field that should count the total amount of “checked” checkboxes on a record. Is it possible?

Hello, I have shared an interface (hence a base) with read only external collaborators. Everything is working fine, but I would like to deny permission to these collaborators to enter the base itself, but i cannot find out how to invalidate the “Go to base option”. Can anyone help me on that matter. Thanks Pascal

I’m struggling to import into tables/sheets that have a lookup field setup. I tried: import from Google Sheets import via copy paste download as csv > import via copy paste The “Account” is always disabled during mapping and has a tooltip “this field type is not supported” I found this similar sounding issue: Bulk upload interactions? Unfortunately I doesn’t specify the answer.

I am looking for some help calculating a graduated sales commission in Airtable. The sales commission is calculated at a rate of twenty-five percent (25%) on the part of the sale price up to and including $25,000; plus twenty percent (20%) on the part of the sale price over $25,000 and up to and including $100,000; plus fifteen percent (15%) on the part of the sale price over $100,000. If the sale price is $150,000, then the commission is 25% of the first $25,000, then 20% on the amount from $25,001-$100,000, then 15% on the amount from $100,001-$150,000. If the sale price is $5,000, then the commission is 25% of $5,000. The commission structure is visualized like this: Any help with this would be greatly appreciated. Thank you

@Joe_Hewes saw a thread about sending data fromWordpress. Does Forminator work with attachments? Thanks

I have a forecasting sheet pulled from our CRM. The sheet lists various deals underway, each sitting at one of 8 stages: Contract Negotiation Terms Negotiation Proposal - Sent Proposal - In Progress Evaluating and Planning a) Evaluating and Planning b) Proposal Sent c) Contract Negotiations Our CRM applies a probability of closing at each stage, but doesn’t place that in any column that I can export, so I have added a formula field to apply that. (Pic 1) As part of our forecasting process, our BDs will review the deals and if the CRM assigned probability is different than they think it should be, they can enter that. A percentage field called {Probability per BD} Lastly, I have a field column to display the CRM % or overwrite it with the BD’s %. (pic2) Now…here is where my issue is: Part of our exercise as well is to ensure that if the deal is over 50% probability of closing, AND over $50K in value, They need to establish what the start and finish date is over the contract is after

Ok, not sure I wrote the title of this topic clearly so here’s an explanation. I have “duration” data imported into Airtable in an ISO 8601 format (just into a normal long text field, more on that below). An example of this format is PT1H30M15S which is equal to 1 Hour 30 Minutes and 15 Seconds of time. PT stands for “Period of Time” for those curious. Problem: I am trying to get the ISO 8601 formatted data into airtable’s “Duration” field but the formatting does not seem to be 1:1. Using the above example, pasting “PT1H30M15S” into an airtable Duration field gives 3:36:55 instead of the expected 1:30:15. I assume this is partially why I had to import this data into a long text field and couldn’t get it to work out the box with the duration field. Can anyone help me figure out how to properly convert my data into Airtable’s duration field format? I have a feeling it’s going to require a formula so that’s why I posted here under this category, but if not my apologies.

Does anyone have suggestions to go one route over another for setting up my base? Essentially in a table called SKUs I will be linking to another table or tables for each SKU component. Each of the fields in the screenshot below will be a linked record. My question is, should I link these fields each to the same table (like the image below) or create a separate table for each component/field type (ex. A table for supplier, pattern, colour, etc.)? There will be additional information specific to each field/Sku component included as well. Like price per square inch for a specific pattern or prices for inserts, etc. Thanks in advance!

Hi, I’m hoping someone can help. My company manages projects and when a project has a formal issue, we create a Governance Ticket related to it in another Base (to ensure the underlying information is not visible to other users). This results in a series of Syncs between Bases. Projects sync to the Governance Base from a Projects Management Base Governance Tickets sync back to the Projects Management Base (showing a limited View of the issue’s details. What I can’t get to work is the update using automations of the RAG status field which lives on Projects tab on the Projects Management Base. The scenario is that a ticket is raised which moves a project to Red status, which is a field in the Governance Base. The sync occurs and shows that a ticket relating to a Project is in Red status and if the current Project is not in Red, the automation should change the linked Project record to Red status. However, I can’t get this to work. It’s almost as if the Automation doesn’t recognise the Ai

Hello, I am new to AirTable, trying to figure out how to implement my required features. I need to let users specify a payment schedule. So that the user can add dates, and values for each date. Ideally I would like to figure out how to add a column which is a “List of Date+Number pairs”. If that is not possible (and it doesn’t seem possible?) what would be the best way to simulate this feature? I have not yet looked at creating Interfaces in case there is a way to create a one-to-many with a “Payment Schedule” table and have multiple records in multiple tables be populated by an Interface. (So if this is what I need to do, please let me know) Thank you for your help figuring this out.