Other Questions

I have a field which is populated by the body of an email. I use zapier to forward any emails sent to a dedicated “to Do” email address to airtable. The issues is that the field shows up with what I think are html tags, such as " <meta http-equiv=“Content-Type” content=“t…” How can I get just the text from the body?

I am having difficulties getting GeoJSON data from a table to generate a Vega-Lite graphic. My table has one formula field called MapGeo which generates the GeoJSON “Feature” (ie the shape), one Feature per record. The “data” property is set as follows. Vega Lite plots the title, nothing else, just blank. No errors shown. "data":{"values":{"field":"MapGeo","type":"json"}} I performed a test to see if the data from the table is valid. I copy-pasted the features from each record and set to static data (not from the table). That worked! Below is the static configuration that works, showing two rectangles. { "$schema": "https://vega.github.io/schema/vega-lite/v5.json", "title": "Test GeoJSON", "width": "container", "height": "container", "data":{"values":[ { "type": "Feature", "geometry": { "type": "LineString", "coordinates": [[2,3],[4,3],[4,5],[2,5],[2,3]] } }, { "type": "Feature", "geometry": { "type": "LineStr

We’re trying to build a searchable table for our school that allows students to view their courses and their associated labs, and information associated with it. Linking a Courses table with a Labs table is fairly simple but my question is: When sharing the view (of the Courses Table) is there a way to have the linked Labs table viewable when the course table is shared/searched? So student has access to the Courses table, and they can view the associated labs, but is there a way from this view, for them to be able to access (maybe opens a new tab?) the Labs table? So they can view more detailed information about the labs? Or do i have to have two separate shared views and they have to navigate between them? listing all the details in one table will be too cluttered considering the amount of information we need to share, (skills, work roles, labs, etc) Thank you for the assistance! -Sean

I have created a gallery view which I would like to share with my collegues. They should only be able to view, add and delete records (not configure the view or anything like that). How do I accomplish that?

Hi all, Hoping to get some advice on something I just cant figure out a workaround for. Have a series of Single Select Columns I had from an Excel spreadsheet for a variety of different HABITATS. They were originally a YES/NO option for each e.g. every single record had a YES or NO for ARCTIC. I entered these as their own column “ARCTIC”, have converted the YES to the ARCTIC title and deleted the NO, and repeated for all the other habitats. So for each column, they are either filled with the option “ARCTIC” or blank. Likewise for each other column “DESERT” or blank. “MOUNTAINS” or blank. I want these combined into one, single, Multiple Select Column called “HABITATS”; where a record can return the habitat “ARCTIC” and/or “MOUNTAINS” and/or “DESERT” etc. However if I manually go through each single-select field and copy-paste the result, it overrides the existing record rather than merging them. Any pointers? Note: As I do want these to be a separate table i.e. to be a searchable or gro

Hi! I’m curious, if there is a way to have the due date of a project visually show that it’s due that day instead of looking like it’s due the next day or at 11:59PM of the day it is due. I have a screenshot below of what I’m talking about. It’s so confusing for my team that they don’t even like using the Gantt view :confused:

how to get notifications to all collaborators in the mobile application about changes to table records or their creation? otherwise, how to avoid email notifications?

Hello. I am trying to sync Airtable with Google Calendar. In the form of “Add” the URL of Airtable’s “Calendar view” to Google Calendar. However, there was one minor problem. Airtable’s “Date” field now selects Date format and Time format, no more options. However, it would be better if there is a “predefined” time slot for Time when actually entering Airtable’s Date. (For example, 10:00/14:00/19:00 or 10:00-13:00/14:00-17:00/19:00-22:00) Creating a “predefined” time slot like this is " Single Select Field", but this field cannot be used in Calendar View. Of course, I know that it is possible by using an automation tool such as Zapier or Integromat, but as much as possible, I try to subscribe the URL of Airtable’s “Calendar” as it is to Google Calendar. In short, is there any way to use predefined time slots in “Date Field”? Or is there any way to use “non-date” field in “Calendar view”?

I want to update my Airtable fields using Excel VBA. Thus, I went through the Airtable API documentation. But there is no way I could figure out to use PATCH method inside the VBA. Is there any resource available on the internet to achieve the result? NB. I don’t want to use any third party apps as I need to update the whole sheet twice a day and there are more than 10k fields.

Hi, I have two linked record columns. Our users use a custom app to link records to these columns.,I don’t want the users to link records directly from the columns but instead use the app. since we cannot restrict permissions to a column, is there a way to open the app when someone makes changes to a column? I am thinking an Automation when the record is updated and open the app from Autmation? Thanks in advance

I have a “Requirements” table with the following fields: ID Description (rich text) Question (rich text) I want to render all of the records as a single document so I can email it. Example (with Markdown formatting): # Outstanding questions ## {id 1} {description 1} ### Question {question 1} ## {id 2} {description 2} ### Question {question 2} ... My current attempt: Write a script and use output.markdown(...) to render everything. The issues: record.getCellValue('Description') returns a string, but that string isn’t suitable for passing to output.markdown(...). For example, if there is a “[” in the string, it’s interpreted as a link. Is there a way to render rich text values properly?

We noticed the Airtable API doesn’t return the same data as it used to be when returning an Attachment record. This is what my base contains: There is a width column set to 200.00 for the record efrei-v4-logo-efrei-advisor489. This is the record I get from the Airtable REST API: { id: 'attStvRqkaEsbPNBT', width: 500, height: 500, url: null, // Hidden filename: 'XXX (3).png', size: 42687, type: 'image/png', thumbnails: null // Abbregated for clarity } Before, this API was not returning the width and height properties (at least, it wasn’t returning those with our way of building our query). This seems to be something new, which in turn broke our products because it overrode our own width and height properties (we were looping on all of the Attachment record properties to dynamically copy those properties into an aggregated record which contains a mix of the Attachment record and the Asset record). This kind of small changes should be documented, there is no changelog

Hi, I have two tables from a csv file. Programs and Partners. I have an Program_ID field in the programs table that is not an autonumber field and that links to a field in the partners table also called Program_ID. I then created a new autonumber field in the programs table so I can add new records later. But now I need to update the foreign key in the partners table with the new program id autonumber field in the program table. I tried this with automation but i keep getting test failed and I know I am doing something wrong. I don’t want a linked field because I just want to get rid of the old program ID fields when the new autonumber id is updated in the partners table. Any help would be appreciated. Thanks, Marc

We could have more than two records with the same name. But Is it possible to prevent the record with the same name from appearing? I hope it will pop up a window to warn me when a same name record is created.

I’m trying to use the web clipper to get the URL (https://www.youtube.com/watch?v=t7X_WBQ6JRA) from a button and I just can’t seem to figure it out. URL is from USA CRIME Direct link to source page: https://usacrime.com/2021/08/16/police-release-video-officer-involved-shooting-allen-mirzayan-altadena/ Code: Here’s how I set it up in the Webclipper Block: Any help would be appreciated.

Hello lovely Airtable Community! Here’s my conundrum - I work for a not-for-profit trying to give locals on a low budget access to food at low cost. We’re using Airtable to log who comes, when, what food they take, and how much they pay - we’re essentially using an Airtable form as a shop “till” of sorts, using a network of linked fields and formulas that allow our Shop team to log all this info straight onto our Airtable database. The problem we have is that if someone wants to collect two of one food item, the person using the Shop Form has to submit the form twice, once with the bulk of what they’ve collected, and again with any duplicates, as the form won’t allow the same Linked Record to be selected more than once. This really slows things down, and while it’s not the end of the world, I’ve had a few requests from the team for this to change, if it can. I’ve currently got one Tab called “Transactions”, which contains the Shop Form view, and another Tab called “Food Stock”. The two

We are trying to transfer the ownership of various bases under one account. So its easy for us to manage the payments for all the bases from one account. I was wondering if we do so will that effect the zaps we have set for the different bases and tables and to what extent will that effect be? We are also using custom apis and webhooks to update the data within the organization. So thats what out concern is regarding the transfer of ownership.

Like the attached…can fudge it using a Kanban but can’t visualise the relationships

Wow, I have been using Airtable for years and cannot figure out what I’m missing- probably something extremely obvious. I’m trying to set up two views with opposite information. In one view, I only want the records that are not done, or are not identical to show, so I want two things filtered out: “Done” is unchecked OR “Are the forms identical” is unchecked. On the other view, I want the reverse- records that are done or are identical, so I have the filters as: “Done” is checked OR “Are the forms identical” is checked. However, the first view is only working if I select AND instead of or, even though I am not looking for records with both of these conditions, rather, either of these conditions. What am I missing here? Screenshots: The view showing the records I want to filter out, and the filters I think should do it, having no effect. Same view with the records filtered out, with AND instead of OR. The other view, with the reverse records- using OR.

Hi Team, Soooo, because Airtable doesn’t have a stand alone time field (it really needs one) I need to create a ridiculous bodge… I start with a Date field set to local format lets call it {CommDate} Next I have a bulk standard number field set to integer we’ll call that {Day} The third field uses DATEADD to add {Day} to {CommDate} easy enough, we’ll call that field {StartDate} it’s set in local format with “use same time zone” unchecked cos I’m in Australia. Field 4 is a text field with a time of the day written in it in HH:mm format, lets call that field {Time} Now here’s where it gets tricky… I CONCATENATE {StartDate} & {Time} it spits out an answer which looks like YYYY-MM-DDT00:00:00.000ZHH:mm The YYYY-MM-DD matches what’s in {StartDate} and the HH:mm matches the text in {Time} and I can only assume the T00:00:00.000Z is a representation of the UTC/GMT timezone. Let’s call this field {Date&Time} But here’s where the problem comes in… My next field is a DATETIME_PARSE of {D

Hi! So, I’m using Airtable to organize volunteers and delegate tasks based on their interests. I have a multiple select column called “Interests”, with options such as education, research, communications, and design. I want to organize my data in such a way that I can see everyone interested in education, everyone interested in research, and so on. However, some volunteers marked multiple interests. When I try to group the table by Interests, it creates unique sections for those who marked multiple interests. I’d like to have four discrete sections that include the volunteer in each section they marked. I’ve seen in other forums that I should create a join table, but I have no idea what that is and I need someone to break it down for me. Thanks so much!!

Hi I have an airtable app that I use to tract diecast cars. I want to know if its possible to say query ebay for an item that I have and pull in the price that it recently sold for? I’ve looked around and I’m not sure if its even possible. Maybe an API call to ebay? Thanks Greg

If a person is ON the CRM but their ‘Current Title’ field is empty in the CRM. When they select their name on a dropdown list on the survey, how can I show the current title and company fields ONLY to them and not show to those that have their current title completed on the CRM?

Hello community, I’m impressed by Airtable features, in fact i’m a Pro User, but the IPad APP has a terrible user experience so i’m trying to use desktop versione but is IMPOSSIBLE to scroll. I don’t know why it’s not possibile to scroll but for my work i need it absolutely otherwise it’s impossible to work. thank you, Alex

Hello! We’ve come up with a way to use web clipper to pull data from our forum website using css classes, however, we have multiple records we need filled but the clipper only pulls the very first. Is there a way to pull multiple entries if the same class shows up on the page we are clipping from? Thank you.