Solved

Hello, i am working on a look-up for a 2 dimensional matrix. A little bit of context for my problem: I am trying to find a value based on two different (numerical) inputs: mileage of a car and operational time. I have already implemented the matrix and a junction table in the style of this base, which was posted on a quite simmiliar topic ([Probability matrix value driven by two "single-select" fields / nested-ifs / multi-variate lookup]) before: [[https://airtable.com/shr2THQFtsbPF8Bdz/tbl7Jhxg5UWlfGzgv/viwkkudWdLBdVdPqC?blocks=hide]] My roll-up formula in my “opportunities” table is using a combination of MID(), LEN() and FIND() formulas, in order to return the assoicated percentage. However, i have encountered several problems: The fields which are to be looked have a range of different lengths (e.g. -0.01, 0.14), so that the MID() formula doesnt work as the different values do not have the same length The Rollup formula in my “Opportunities” table is not returning a percentage but

Hey everyone! I’m looking to provide users of my website an easy way to search the content of my airtable. I figured the Search app would do the trick. It works well - but I can’t determine if there is a way to embed the Search App into my website, similar to how you can embed your airtable view into your website using an iframe. Anyone know of if this is possible or how I might accomplish this? Any help is appreciated!

I have a field called “Category” where each of the categories are plural (i.e., “Widgets”, “Cogs”, etc.) In the first field (record) i have a formula that grabs a product name, concatenated with the “Category” at the end. I would like to have the “s” removed from the category name. Here’s my current formula: MFR & " " & {Model} & " " & {Category} So essentially, I would like to remove the last letter, from the {Categroy} name. Thanks in advance for any help on this!!

Hello, Is there a way to sort by name, but ignore “The” in the sort calculation. I am trying to sort albums with a Artist + Album field and would like the sorting to ignore “The” in the artist name.

I have a larger base (for Airtable), about 30,000 rows and want to change one field with about 60 options to single select, to help prevent human error in the future when adding new items to this base. When I attempt to change this field from short line text to single select, it times out and asks me to refresh the page, and the change is not saved after several attempts. I’ve tried to turn off the “color” feature to make it easier to process, and still no luck. Is there a limit to this feature? What am I missing?

Hi everybody, I got 7 fields that are either empty OR contains a name… Is there a formula which sums up how many of these 7 fields contains a name (and aren’t empyt)? Thanks in advance!

Hi, I’m new to airtable and could really need some help. I’m trying to automate a flow where an email is send to a client every time a new attachment is added to an existing record. For that purpose i’m using the build-in automation feature. The trigger I’m using is “When a record is updated”, View “Grid view”, and Fields “Attachment”. The action i’m using is the Gmail: send email. All this works fine. My problem is that is sends the email twice when I upload a new attachment? I have tried the same setup with Slack, and also here is triggers the actions twice. What am I doing wrong? Any help is much appreciated! Best regards, Jarl

How would I calculate days in foster care from the intake date to today but have it stop counting once the animal’s status is adopted? Ive got the intake date and adopted date but wasnt sure how the formula should be worded. an example of the info

HI! I’m creating three forms for an event -individuals, groups and events - and I’d like them all to appear on the same map. Can someone explain how to add markers from different bases to one map? Thanks, Yan

Hello everyone, I tried searching for an answer but unfortunately couldn’t find one. I am trying to upgrade to the Pro Plan but it looks like I have to pay the full amount for monthly, I just paid for an annual subscription on the Plus Plan. any thoughts?

In my [Workers] table, I just copied 6,000 cells from formula field {All employers for automation} to a link records field {All employers new} which is linked to the table [Employers]. All of the text strings in {All employers for automation} were taken directly from a linked records field {Temp employer} which is also linked to [Employers]. 5,700 of them went through with no problem and linked back with the original record in [Employers] no problem. About 300 of them, though, failed to link and created a new record with the same name in [Employers]. Why would that be? Am I just asking too much of AT? (to be precise, i did this for three columns at the same time, totaling 18,000 records copied and linked. the other items were serial numbers and matched perfectly with their counterpart). The applicable structure of the table is {Temp employer} linked to [Employers] {Temp empID} lookup of {Temp employer} “orgID” {All employers for automation} returns a unique array of {Temp employer} and

Hi there, I am a new enthusiastic in Airtable, so forgive me stupidity ;-), but: A few days ago there handles most left on the records so I could drag them in another group of records (in the same table of course). But now these handles suddenly seem disappeared. Does anyone know what is going on here? Best regards,

I see when sharing a grid view link, users can’t see and therefore can’t click on the hidden fields, but when I create a base view link, the blue box with the hidden fields can be seen and clicked on. Is there no way to hide the hidden fields in base view? I was hoping to give users just 1 link so they can see the whole base with all the tables. If I can’t hide the hidden fields (with lots of formula workings), I’ll have to create 23 grid view links, 1 for each table! Hoping I’m missing something obvious here. Any help would be greatly appreciated it!

hey everyone, I want to start using the comments on records but I’m hesitant due to the warning about only having 1 year of history. What does this mean? is it just revision history or does it include comments? Appreciate your time people

Hello everyone, It may sounds stupid but I have an issue to sync cancelled events (Calendly) to my Tickets Table (Airtable) via Zapier. Basically, when someone cancels their attendance on Calendly, I don’t know how to change their status from ‘Booked’ to ‘Cancelled’ on Airtable via Zapier. I am using Calendly for my ticketing/attendance management. I have different kinds of recurring events, with different times/dates, with different users booking/cancelling their ticket. On Airtable my ticket table has a single select column called ‘Status’ so I would know when someone has booked or cancelled their attendance. The problem is I don’t know how to make Zapier updates the status column automatically from Calendly when it’s a cancellation (I know how to create a record when someone books though).

Is it possible to get the “Suggested Views” to stop showing in the sidebar? This takes up a lot of prime real estate. On my screen I can only see 5 of my many views :stuck_out_tongue: Also, I would prefer to have a single “Create a view button”, but that’s more of a feature request.

I can’t figure out a simple formula. Name (field) = John Smith I need the formula to come up with a result if the search for “Smith” is true. I tried IF(FIND('Smith', Name) > 0) Does not work. Please share ideas.

I’m trying to make a script that will read from a Date field and copy and paste that data into a Link to field in the same table. If there is a better way of doing this I am completely open to it. The end goal is to setup an Automation that will check for a change in date from the source and reflect that in a weekly report table.

I have a table that tracks the steps and results in a process. Sometimes we modulate the steps, but often the steps remain the same over multiple submissions/rows. For example, we have molds that need to be cleaned using a variety of different tools, solvents, and methods. I have a column titled Mold Cleaning with options “Standard” and “R&D”. I would like to be able to have subsequent columns autofill based on the selection in this column. If “Standard” is selected, then I would like the tools/solvents/methods to input our standard selections for that. If “R&D” is selected then I would like for the tools/solvents/methods to remain blank for input. Can this be done through scripting or some other means?

Hi! I have a Lookup column that gets one or more images from another table. Now I need to get each image link in its own column. I already have the formula to extract the images URLs, but how do I get each of the URLs in a separated column? Thanks!

Hi again! One more question from me for this base. I want to combine multiple IF statements from data in two columns. I’m working with the ‘points length’ field and the ‘total rating’ field. I’m attaching screenshots of what I’m talking about and the formulas I’ve tried, since it’s probably easier than me trying to explain. (I’m new to Airtable formulas and still not entirely sure what I’m doing!) In this screen shot you’ll see that the documentation status column doesn’t differentiate between ‘well-documented’ videos with perfect point length (40) and those with less. This is the formula I used to get the screenshot above: IF({Total rating} <=3, “Unsatisfactory”, IF({Total rating} <=7, “Passing”, IF({Total rating} <=9, “Well documented” ) ) ) Here’s what I would like to incorporate: ‘Well-documented’ status should only go to videos with points length of 40 and total rating of 8 (if the total rating is 8 and points length is less, like others you will see in the example, it

I need to populate a field with a value based on three conditions: Checkbox Field “Current Edits Complete” = 1 or Checkbox Field “No Changes Suggested” = 1 AND Checkbox Field “Content Implemented” = 0 So, if Edits are complete or No Changes Suggested are checked - BUT - Contentent Implemented must be empty, I want to bring back the {Editor copy}, otherwise I want the cell blank. Here is what I have built, but it doesn’t grab the records where No Changes Suggested is selected. IF({Current Edits Complete}=1,IF({Content Implemented}=1,"",IF(OR({No Changes Suggested}=1,{Current Edits Complete}=1),{Editor copy}))) Thoughts???

How can we make a judgment between each date in column {Directive status 1} cell and the date in Column {Calculated ETA}, and then return the “Overdue” if one judgment result is false? Or how do I get the smallest date in column {Directive status 1} cell.

How do I remove collaborators who are grayed out and seem to “come with” a template base? There are a couple templates I am trying to use but extra collaborators cannot be removed. I tried right clicking, I tried left clicking, I tried every other possibility that works in other bases and cannot remove the grayed out collaborators. Any suggestions? Thank you in advance!

Had a good formula going for the status of the books in our shop… IF({Sales}, “ :green_circle: Sold”, “ :white_circle: For Sale”) But then I realized, we also “ :orange_heart: Donate” and “ :beer: Trash” books (we only trash them if they get damaged, say, in a flood, and the Microsoft garbage emoji is garbage, so beer it is!). Like the {Sales} field, the {Donations} field is a linked one, only, unlike {Sales}, in {Donations} it’s not enough to say EMPTY=For Sale and NOT EMPTY=Sold because there are three options in the Donations table {Beneficiary} single select field: Charity, Thrift, and Trash. What’s the formula for this? Do I need to create lookup fields first?