Other Questions

What can I do if the field values of the first name are not shown on the email content on the Gmail automation?

I use a single-line text field to store Dropbox paths of certain files. When clicking on the file’s URL, I’m taken to Dropbox viewer whereas I would prefer to be sent directly to my file in the Finder (I’m on Mac but I guess the problem is the same on PCs). On Wrike, one of Airtable’s competitors, that feature is standard. Am I missing something ? Thank you for your help.

I have a date field that imports like this: 2021-09-13 00:00 I need to extract the year and month and day from there … in different columns. Is there an automation for this?

I am trying to add a formula that if the status is “Available” and “Becoming Available” in “General Listing Calculation” tab it will show the price from “Price (from Room Details)”. Not sure how to start. I guess it will be like this IF({General Listing Calculation}= “Available”, {Price (from Room Details)}) but not sure how to add “Becoming Available” in the formula

I set up a customers table with an email address and job title field (blank). Have another table with email address and job title field, linked the tables and trying to look up the job title in table to and populate table one and it only works if I click into the field and search and manually do this. I’m sure there is a better way. Thanks!

Hello! I’m working with a client that currently uses an Airtable Form to collect data from applicants to a job posting. All fields are required in the form. We are receiving form submissions that have the email field or other fields completely empty. What is causing this? Does this happen when forms are refreshed or a tab is closed in a browser? I’m really not sure. I’m thinking it may be best for the client to use a third-party form, but I’m perplexed by this issue of empty required fields. Thanks for your help!

I have a field that is an entry field and that is part of a rather complicated page design, where I need to be able to trim away and spaces at the end of an entry as sometimes the user ads a whitespace I guess out of habit. Is this possible? I’ve been playing around with the TRIM() and SUBSTITUTE(), but I have a hard time finding a solution that’ll apply just to the end of the entry? I’ve tried this, but it dosen’t get rid of the white space at the end IF(RIGHT({Alcantara},1)=" ", LEFT({Alcantara}, FIND(' ', {Alcantara}, LEN({Alcantara})-1), {Alcantara} )

This is my first post here. I’ve been getting up to speed on AirTable the last several days and finding there’s much to like about AirTable. However, while it appears to nicely cover certain basic use cases, I’m not seeing how it covers many common use cases that come standard with some database apps such as FileMaker. With AirTable I see a form designer, page designer and now interface designer all in addition to configurable views but they all fall short with many common use cases. One example use case would be to submit or edit multiple rows (including the ability to sort, select and edit related records) all related to a single record. This is a no-brainer in FileMaker via their portal widget to related records. I am aware of AirTable extended functionality which may provide some aspects of this but only in a view only, browse only mode. Before I invest additional time on this I need to know if there’s something I’m missing which allows one to create the following type of

In Airtable’s T&Cs it says they can access our information at any time for security reasons, or something of that sort, meaning the data in the Airtable is not actually secured. Is there an encrypted and private way that information can be stored on Airtable, where there is a guarantee, barring a court order, that Airtable cannot view my company’s stored information?

Hi Guys, im quite new to airtable and i am so far loving it With my business i make memorial jewellery and once an order comes in it goes into my airtable with the status of their order shown below. Is there any way i can create each card so when someone goes to check their order on my website and this table is embeded they can view a photo of the completed work and add notes to it or approve the design before it is shipped to them is there also an option with airtable that when that particular card is updated i can link that card to their email so they get notified of the update Is there an option to add a reminder to each order when their order is coming up to being due to complete? I am hoping to have each card private only to that customer - i know this is doable on monday.com so i am hoping as airtable is similar this can be done here too. or does anyone have any other su

Hi Community, I would like to do something rather simple however, I am struggling with linking tables. I have an E-mail address column in table A and the same in table B. All addresses from B are in A, but not all of A are in B. Whenever a new record (including a 5-star rating column) is added in B, I would like to synch A such that the rating is reflected in a column there too. Thus, similar to VLOOKUP in Excel, when the e-mail addresses match, Airtable should pull the rating in B to A. Any ideas?

Hi community. I am trying to “clean up” my list of collaborators by converting all email addresses from personal or @gmail addresses to our @organizational email addresses. When i delete or remove the collaborator with the gmail or hotmail address, I resend an invite to their organizational email. Some have accepted the invitation but it has their @gmail address listed again. What could be the cause of that?

I have listed multiple addresses in the cell for the maps app, however only the first address listed in the cell is plotted on the map. Is it possible for the maps app to pick up multiple addresses listed in one cell? Thanks!

In Google Sheets, I’m experimenting with making a Sheet to log blood test results. Types of things (eg. proteins, minerals, red blood count) tested for are on the Y axis. Adjacent, each has a normal-range threshold, defined by the lower limit and the upper limit. Then, the subsequent X axis includes a number of different date columns, carrying the specific numerical result for each test type. Due to complexity of views, I can imagine using an Airtable Table eg. to group test types - eg. there are a number of White Blood Cell test types. But how else / how well could this translate to Airtable? Each thing tested for has a normal range, defined by two column cells containing the lower and upper thresholds, accordingly. This allows me to use Conditional Formatting to shade the cell background cell green/red if the reading is out of range. What can I do with Airtable here? Indeed, do I have the axes the right way around?

I cant work out how to produce a report in page designer without it taking a seperate page for each record. I expect I am missing a really obvious setting but I cqannot find it. Thanks for any help.

Hello Friends! I’ve been getting very excited by the Gantt view! Especially the ability to push tasks and have all of the following tasks push with it. Is it possible to pull all of the following tasks when pulling tasks backwards? Or a way to update a set of records to have no “dead” space between tasks? Thank you! Paul Warren

Context: We have an airtable form for speakers to submit a topic, bio, date, and time for their workshop and our speakers are from all over the country. Issue: We wanted people to be able to select their own date and time. From there we had an automation that, once we changed the status internally on the grid view to “Add to Calendar”, the automation would add the event to Google Calendar. It all worked perfectly until we had someone from another time zone use the form. We’ve tried toggling on and off the “Use GMT for all collaborators” and we tried telling people to enter the time zone as Eastern, but in both cases we haven’t been able to have this process flow as intended. Are we missing something? Is it possible for someone to enter a date on a form and have that form consistently give us a date/time in Eastern?

Dear Community, Could you please help me with the database transportation between different workspaces? Is it possible transfer my existing database from my free workspace to the paid workspace? or It’s impossible. Thank you!

Dear Community, Could you please help me with an airtable billing plans. For now I have a workspace with a free plan with 12 collaborators with an “editor” access that I’ve added for free. I’d like to add another workspace as a paid “Pro”. I know that I need to pay for each collaborator that I invite in a “Pro” workspace. My question here, do I need to pay to my existing collaborators within a free workspace when I have a paid workspace? Thank you!

Hey everyone, here’s an advanced question: We have 4 AirTable bases, all of which have their own version of a table called “Sales”. I am currently centralizing the 4 different Sales tables by creating a 5th base which has the other 4 tables synced to it (via sharing the views with no filters). Let’s call this the Central Base. What we need to do now is to take specific columns for all 4 tables synced to the Central Base, and put them in a new table called “Central Sales”. Here’s an idea of how it would look like: So the “Client” column on all 4 other Sales tables would feed the “Client” column on the Central Sales table. This is what I don’t know how to do. Does the requirement make any sense? And if so, how would you do it? Thank you ver

I duplicated a table, and I have a column of long text, where I wrote A LOT of text in 2 different cells. When I wanted to copy that text, it disappeared and showed me a text from a different cell. I need this information - why did it happen and how can find it?

Hi. A Euro problem, mainly. I am importing data from Filemaker via Excel, all on a Mac. However I save the CSV file to be imported, the accented characters don’t import. I can correct them on-screen, so it isn’t that your system doesn’t accept such characters, just that it doesn’t accept them in a CSV file. Is there a solution?

I have three air tables in one workspace. One as a blog calendar, thought leadership calendar and social content calendar. Is there a way to pull all these dates into one calendar?

The manual way to copy text described above doesn’t work for fields Long Text Fields with Rich Text Formatting because if there is a rich text formatting in the copied text, doing Copy and Past (at least on MacOS) will add line breaks after every block of text and you end up with double or tripple line breaks. I don’t care about preserving formatting, just don’t want to end up with line breaks. So I am avoiding quotes and end up with linebreaks doesn’t help. This is a minor annoyance with copying text out of Airtable. Unless you do the extra steps to only copy selected text, copying the entire cell will add (mostly) unwanted quotes marks at the beginning and end of the copied text. Before you can use in another appliation, it’s almost always neessary to strip the quotes away from the text. There are a few tools on Windows but on Mac there are less options due to sandboxing etc, however, there are a few that work. If you are on MacOS, there is TextMate is one, WordServi

Want to confirm that you have to have a “date” field type to create a calendar view…is that correct? For example, you can’t create a calendar view if your date field is “single text” type…