Other Questions

I’ve got 2 fields set as ‘Last Modified Time’ types, and updating those based on another field being updating. However the timezone is GMT, even though I have ‘Use current timezone for all collaborators’ turned on. Any suggestions?

I am trying to create a section but my Airtable does not allow me. Now all my views were moved to “more” and they are grouped with a bunch of random views. Help! I need to be able to create my own section!

Hi everyone, is there a way to change the first day of the week when I open the “date” filter? Here in Italy the week starts on Monday

Hi, thanks for any assistance. I’m working on quantifying the time that I am spending on each of the steps in my production line, and am using a datediff formula to compare the last modified date to the start date, divided by the quantity of the steps i have completed. It works great to give me an average of each of the steps, but I would like to be able to also get a “lap” time for the current step. In other words, if i have done the step 10 times in 15 minutes, that means it is 1.5 minutes per step, but i would like to know that the last iteration took 1.4 minutes, vs the previous one was 1.6 minutes, etc. The goal is to know both the average and then the last one, so i can keep track of how i’m doing. Whatever formula i am trying to create is not able to compare the last modified time of the current iteration to the previous one. Any ideas?

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”

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

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 o

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

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