Other Questions

Hey, I am having trouble with a formula using multiple IF statements with OR and FIND. Essentially, what I want to do is assign certain statuses to a single text-based column called “phrases”. The column contains a variety of food types that are embedded in sentences. I want the following functions in one formula column: -If a cell in the “phrases” column contains the word “strawberry”, “grape”, “apple” or “raspberry”, then assign that record “fruit”. -If a cell in the “phrases” column contains the word “avocado” or “squash”, then assign that record “vegetables”. -If a cell in the “phrases” column contains the word “rice”, or “quinoa”, then assign that record “grain”. -If a cell in the “phrases” column contains the word “milk” or “yogurt”, then assign that record “dairy”. -If a cell in the “phrases” column contains the word “butter”, “olive oil”, or “fat”, then assign that record “oil”. -If a cell in the “phrases” column contains the word “chickpeas” or “lentils”, then assign that reco

Hi all, I’m asking this question, knowing that it can probably be done with a Pro account. But the thing is it’s the only thing I would need a Pro account for, changing “Submit” to an equivalent in French, in 2 forms. So, Is there any way to change just that without paying 20$US per month (more like 28$CAN here)? I don’t mind at all paying for an account if I will use many features. But just for that, its a bit much. Thx for any insight or answer!

I’ve connected a check-in check-out template to a Softr page and we can update inventory from either side, which is great. However I’m trying to add a new item which has a quantity of 24 however, when I jump over to Airtable there aren’t 24 individual records. Is there a way to configure the base so that when we add a new item with more than 1 quantity the base automatically creates a record for each individual item? Thank you!

Would it be possible, or is there already a way, to view 360° photos through Airtable?

I am on a plus account and want to sync this job board. Airtable - [Public] 80,000 Hours job board vacancies I am only able to make a copy. Why is this?

Hey, Webclipper is great but it keeps the browser scrollbar when I take a page screenshot. Is it possible to not have it ? Also, is it possible to choose the size of the image that is taken and upload into the airtable base? Thanks

I am using Airtable with Integromat, but am having issues filtering in Airtable using the TODAY() function. I have a field in Airtable with a date (no time). I have an automation in Integromat which runs every 15 minutes, searches my Airtable base using the filer IS_SAME({publication_date},TODAY()) I want my topic to publish at 12am every day GMT + 2 (CEST), but I can’t see a way of achieving this through Airtable, other than setting a specific publishing time, not just a date. Does anyone have any thoughts on how to solve this? I know I could probably create a formula in the filter that transformed GMT to GMT + 2, and filtered in this way, but it seems overkill… any help much appreciated.

Hi all! Does anyone have built an “availability” feature in a people marketplace through Airtable ? For one of my customers, I would like users give theirs availabilities (which days in the month they are available for example) to do a matching with the order of my customer. Any idea to build this data model in Airtable and then to make the matching feature? My first idea is to create a “Days” Airtable table in Airtable (one record per day of the current year) to allow users to select which days they are available. An order will contain one or more days linked items. But I do not know if I should rather use two “date” field (to do a period picker) but I do not see how to manage several available periods… Cheers Florent

I’ve got the map block set up to plot records from a specific view, and in that view are only like 30 records, yet the map seems to have all the records in my table plotted instead of just the ones in the specified view.

Hi, I was wondering if it is possible to split a row which had been populated with data using a multiselect, into separate rows. e.g. I would want to create 2 lines for Campaign “Client 1||3” one for “Driver 2” and one for “Driver 4”. Similarly for the 2nd Campaign I would need 3 lines. Not too phased if in same or different table - although different table may be easier. TIA.

Hey! I’ve seen this stock chart in the Airtable marketplace, but I can’t figure out how to add multiple Y-axes, does anyone know how to do that? How my base look like: cln.sh CleanShot 2021-04-16 at 13.40.56 Powered by CleanShot Cloud Screenshot from the marketplace: cln.sh CleanShot 2021-04-16 at 13.40.28 Powered by CleanShot Cloud

Hi folks! I have a question regarding password protection for Share link views . I wonder if it’s possible to create dynamic passwords for sharing links. I want to restrict access to share links but I want to give different password for every user. It’s possible? So far I know you can add a single password, but it’s possible to create several passwords for just a Share link? Hope you can help me, Thanks!

Hi, How can I sign in/out between different oneDrive accounts for attachment linking in records? I notice once I signed in to a oneDrive account, there is no option to sign in to a different account even after I have signed out oneDrive account. Thanks!

When I paste the link to my airtable form on facebook or whatsapp, the message should display some content (at least the top part) of my form. If it is all about airtable branding then how can I get people interested to answer my survey??

Hi Community, i’m extracting the date from the below string 27909270100235 = 1979-SEP-27 using a formula below DATETIME_FORMAT(RIGHT(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),4),2)&"/"&RIGHT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)&"/"&IF(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)>50,“19”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2),“20”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)),“DD-MMM-YYYY”) the result is ok, 27-sep-1979 but I’m trying to get the age by further calculations/formula but it seems it doesn’t recognise the date above to make further actions and I realised that the formatting tye in the field doesn’t recognise it too, and received below message Blockquote Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date. Blockquote any suggestions?

Is it possible to place form fields side-by-side instead of having everything in one long scrolling form? If not, this needs to be a thing.

We’re a small hotel, so I have a Contacts Table, and all my Guests are updated … I’m not sure how to link to automatically. I have a linked field there, but i need to select it manually … shouldn’t there is an automatic way of doing this? When the reservation comes in the guests’ email and name is given … so … can’t I just use an ‘if this than that’… type of thing?

Hi, is there a way to connect several fields. I have several fields: dress name, dress style number, dress retail price, and dress wholesale price. Is there a way that when I enter the name of the dress in that field, the base can fill in the other fields with the accompanying information?

How do I find out when someone has completed my form and submitted answers? I did a test run and received zero notifications after entering my information. I need to see the data after people have completed these forms.

Hello Airtable gurus, Not a native english speaker and already awake for 18hours so my explanation might be bad My primary field is a concatenation of 3 fields… Is there a way to use Zapier and link a record by only using that data has a partial match from any of the 3 concatenated Primary field? I mean when assigning a linked record manually, we can just type anything and if it matches the primary field, the record shows up right? Is there a way to replicate this via Zapier? image|700x493 I tried but I get this error unless it’s an exact match Context: I want to use Typeform as a customer registration form . I have 2 tables, Customers and Addresses. I have to separate the Address table so i can assign multiple address to customers and be able to just choose a PRIMARY shipping address, similar to Amazon/shopify. With the help of zapier, customers fills up the profile part of the form which goes to Customers table, and Shipping address goes to Address while it automatically link the c

How can I create a formula to set a reminder every interval of X months for a period of P time? For instance for the second column, create a reminder on 6/1/2021, 9/1/2021, 12/1/2021, 3/1/2022

I am trying to upload a pdf to airtable. It was working fine. Today, I am facing a weird situation where pdfs are getting uploaded and suddenly disappearing from the table. This behavior is random. I couldn’t find any solutions to fix this issue. Could you please help me with this?

I have a set of data that contains first name, last name, timezone, and email address. I’d like to create automatic groups of 3 based on time zone (each participant needs to have the same timezone per group) and then somehow (hopefully in an automated manner!) communicate the peer groups with their first, last, email to each group. Anyone have any ideas for how this could be done with Airtable? Thanks in advance!

I have a table that tracks every donation made to our charity, which includes the title of the fundraiser to where the funds were donated. This is triggered by each new donation. What I need to do is find a way to AUTOSUM the donations by the fundraiser title. The stick in my widget is that this number will be constantly updating as more donations come in. Currently, I can group by single select and see the AUTOSUM for each fundraiser. As new donations come in, this number automatically updates. Gorgeous. Since I need that number to use in other places, I’ll need that value to inhabit a single record. What I’ve tried to do is create a NEW table to do a ROLLUP. My issue with this is that I need to manually add each new donation to get an accurate snapshot of the current SUM. Since this value will be used in client-facing data, it has to be up to the minute. So, if a new donation came in for Sam’s page in the first image, the sum of the grouping would increase. But the record in the li

I wish the field order in dedupe was useful. Putting them in order of creation is not helpful when you have hundreds of fields.