Solved

I saw a post with the following formula: IF(IS_BEFORE({Due Date}, TODAY()), “ :boom: ”, " ") This formula puts the emoji in a column if the due date for something is past. I’m not really good with formulas. Is there a way to make it have that emoji if it is ON the due date AND after?

Hello, I have a table and need to assign a price depending on the status AND the Language: {Status} = Confirmed & {Language} = Spanish Then $95 {Status} = Zoom & {Language} = Spanish then $85 {Status} = cxl on time then $0 {Status} = Late cxl & {Language} = Spanish then $95 {Status} = Zoom & {Language} = X-Exotic then $115 {Status} = Confirmed & {Language} = X-Exotic then $150 {Status} = No Show & Zoom & {Language} = Spanish Then $95 {Status} = No Show & Zoom & {Language} = Exotic Then $115 Thanks in advance!

Hi there, I’ve been working on this and cannot seem to figure it out. I’m trying to write a conditional IF statements that essentially says - IF Field A= 1 and Field B=2- output 3 IF Field B=1 and Field A=2- output 4 IF Field C = X- Output X Here is the current syntax I have written- I’ve gotten it to do the first two parts, but cant get the last part running. Any help is wildly appreciated!! IF(AND({Are you in recovery for a mental health disorder?}=‘Yes’,{Are you in recovery from a substance use disorder?}=‘No’),‘MH’,IF(AND({Are you in recovery from a substance use disorder?}=‘Yes’,{Are you in recovery for a mental health disorder?}=‘No’),‘SUD’),IF {Field 60}=’CO’,’Co’,’Z’)

Hi. Is there any way, programmatically or by some setting (either on block or on the dashboard) to change the height of the block within the dashboard? No matter how many blocks are displayed in the dashboard, each of them seams to be 304px tall (including its heading). So even if there’s just one block, there’s a lot of unused whitespace while at the same time the block would be able to display more data. Our custom block displays a lot of content within an iframe, it expands the iframe to occupy as much space as available. But since the height of the block is fixed, it’s rather limited (read “very small”). I know the user can switch the block to the fullscreen, but that doesn’t help as that covers the data in the table, so when the user wants the block to react to cursor change (which is the coolest think and the only reason to use the block in our case), they need to exit the fullscreen, select another record in the table and then either scroll within the block or enter the full scr

Does Airtable offer view of family tree. i.e say I want to know all the family members of my uncle, does it come in one page. ( earlier I would have put the details of uncle and all his family members in separate rows- so is there a feature to connect them and then retrieve the family in one page) . It would come to use when I meet my uncle , I want to recollect all his family members names and birthdays, etc

Has anyone retrieved data from multiple tables via the api? I can retrieve one set from one table no problem and I know how to to do this in SQL for muliple inner or outer joins but I have a little bit of a block doing this in node.js using the api. Thank you

how to return the values ​​of a related table, not the key, I try to do this from the javascrip api, what i have is this: const response = await airtablePlanes.list(); and he answers me: [ { “id”:“recJhPPsonGK6WQiO”, “fields”:{ “valor_mensual”:4569, “Name”:“PLAN_4”, “planesToCoberturas”:[ “recGBXvrvXt6KhatT”, “reckjMfRzp6jnHEED”, “recCFBaAfBirzw6V3”, “recg1TjYd6ekRHXqJ”, “recM04lVdWj2CDIeI” ], “descripcion”:"Plan 4 ", “valor_anual”:54825 }, “createdTime”:“2020-04-08T22:25:48.000Z” }, { “id”:“recZQkZ6hI62FqvJ0”, “fields”:{ “valor_mensual”:1286, “Name”:“PLAN_1”, “planesToCoberturas”:[ “reczIR8pPZBAJdSsM”, “recH0CU0TqA9cfiFg”, “receQ9xxWZqrtd2V9”, “recG7E3gux8diAm2D”, “recSsWKkZTCda0kab” ], “descripcion”:“Plan 1”, “valor_anual”:15431, “registros”:[ “recovGEbYXVD3ISb3” ] }, “createdTime”:“2020-04-08T22:24:27.000Z” }, { “id”:“recpDt0xL5yDPcrec”, “fields”:{ “valor_mensual”:2380, “Name”:“PLAN_2”, “planesToCoberturas”:[ “rec9zIsScaSyFwTc0”, “recRFqypir5CyMG9z”, “recNIguFd32J9H5ma”, “recDNT4YUm

Hello, I am building out a client database and want to have a column that designates which consultant is the lead relationship manager on each client. I want to relationship manager column to be a Collaborator field, but I don’t want those collaborators to receive the invite email yet, this is because I am adding about 40 people, and I want to complete this first iteration of the database before allowing everyone to get into it - I don’t want to cause a bunch of confusion in my organization by inviting those collaborators and having them start looking at and using the data before it is ready. Is there anyway to add emails as collaborators but just hold the invite back?

When I try to set up my clipper it says my fields with dates are unsupported. Is there a workaround or specific field I can use to add a date stamp of when the clip is stored?

Hi I am using the free version of Airtable and using one base very heavily for my day to day work to manage workflow. Suddenly over the last 3 days I have been getting a warning message saying “This webpage is using significant memory and closing it could improve the responsiveness of your Mac” I didn’t ever get this before and also I have the latest (1 month old) 16 inch MacBook Pro with significantly greater memory and faster processor than my old MacBook Pro which was 5 years old and a lower level model Please help!

Hello, I have a formula for UTM and its pulling from the other columns in the sheet, but for some reason, it is not hyperlinking the entire URL. I not sure why, But I have doubled checked the formula to make sure there are no spaces. I am new to Airtable formulas so I am not sure what I am doing wrong. Thanks!

Hello All! How can I edit an air table row? I would like to input data on one of the rows and i am having a hard time doing so. Thanks!

I just upgraded to the pro plan (from the free). I don’t see anywhere where it gives the price to add a base collaborator. I really don’t think i want to pay much for something that i don’t know if they are going to use much. i paid for Airtable myself because it was my choice to get myself more organized. I really only need my boss to come in every now and then (like once or twice a month) and change a drop down for a job from “billed” to “paid”. That and maybe she would log in every now and then to see the status of things. Is there not a way she can do this without me having to pay to add her as a collaborator? I can make her “view only” for free, right? or can i give her my login so she can just check in every now and then? (and change those drop downs). i know she’d have access to all of my bases, but that is fine, i’m probably only using this for work anyway.

I’m importing a csv with the Airtable markdown for pretty urls but, they’re not parsing. If I manually create the individual record it parses fine. So, I’m importing this: Google Search e.g. the above in markdown as [ x ]( x ) I have a ton of records and doing this manually cell by cell will be difficult. I’ve tried clearing my history, logging out/in, and refreshing the page many times with no change. I have also tried manually copy/pasting CSV, as well as using the CSV import block both as a new table and by replacing existing data. Nothing is working. Thanks!

I have created a bunch of categories that I am using in a multiple select field. My question: how can I export those categories that I created into a list somewhere so I can manipulate it?

Hello. I’m having a problem importing ICS data, where the start and end date from the ICS file are importing as one day earlier in Airtable. The ICS file is set to Europe/London, but not sure if the timezone would affect the days themselves. Can anyone suggest how I investigate further or fix this? I have a few thousands of records to import from a Google calendar.

Hello, I have a contacts record with peoples first and last names and for some reason many of them (not all) were imported with a space before their name. Is there a way to remove this space for each record? Thanks in advance!

\I have created a base on the free version of Airtable that I want to share for free with others; But I do not want them to be able to make changes on my original base. Basically I want them to be able to make a copy of it for themselves. What is the best way to do this …that I could then easily share on social media for people to try out.

Hi, I am using Google Keep for my to do list. But I want to migrate to Airtable, because for each to-do I want to have additional columns. My question is - can I automatically move the item down on the list by using a checkbox on another column? I don’t want to sort it by the last checkbox column because this way somehow all the content gets rearranged. thanks! see screenshot: airtable|690x174 .

I’m converting a table that has multiple text field columns into one multiple-select column. The old form had text input fields so the most of the data is like this: and now that form has condensed those fields into one multiple-select field, like this: . I don’t want to keep the old text columns around, and want to collate those fields into the single existing multiple-select column. I think the way to do this is in a step-wise fashion: create a lookup table that converts the text into the new multiple-select labels use a rollup field on the main table to concatenate or arrayjoin the data into one comma-delineated string, copy that data over into the existing multiple-select column delete the old columns and the reference table But I’m not sure what aggregate formula I can use to create the string. And I’m not sure how to reference the data within the rollup formula field: (I know this isn’t right…) Any help would be much appreciated! We’re about to add a lot more organizations t

Hi there! I have a Table called Projects and another called Updates (both are connected via Linked Records), both are in the same Base. I’d like to have a flag (a binary 0/1 or true/false so I can put them in a Count Block on a Dashboard) for all Projects (that have a Status of In Progress) if they don’t have an Update for them for the previous week. In the Updates Table I have the name of each record as the number of the week (calculated via a formula, with a little nuance for stragglers who might not update until Monday). Any idea how’d I’d go about doing this? Thanks in advance for your help! James

Can I please get some assistance with a conditional statement. I’ve looked at examples, but have not been able to crack this. Goal: First Name space Middle Initial space Last Name or First Name space Last Name Not all names have a middle initial therefore my current formula is creating a double space when no middle initial present. I know this will require some kind of conditional if statement. There may also be a more graceful way of handling the spaces between field values. Current Formula CONCATENATE({First Name}," ",{Middle Initial}," ",{Last Name}) Data Structure First Name Middle Initial Last Name Todd Roberts Rene M. Johnson

Dear lovely people, I’m stuck with a formula (again). I have a base for coordination of translation work. I’d like to get an alert emoji if in a record: “activity” is “translation” and WC is empty or “activity” is “review, proofreading, upload” and “time task” is empty or “activity” is empty Do you know if this is possible to build in a formula field? Thanks so much in advance! :blush: Belén

Hello… I’m using a rollup with ARRAYJOIN(values,"\n • ") Which is giving me this result Item 1 • Item 2 • Item 3 I want this result • Item 1 • Item 2 • Item 3 How do I create a formula that puts a bullet on first item?

I’ve read the help article, but when I want to add a new column and choose Long text, there is no option to toggle “RTF” anywhere. Is this something I need to do within the settings at a higher level?