Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,721 Replies
10000 Topics
M
Maria11Inspiring
posted in Other Questions
Calendar view using two date fields - date and date + time

Hi Can anyone help please? When using a calendar view with two date fields one with date and one with date and time - I cannot drag into time slot only full day event. Is this a bug or should I be able to? Thanks, Maria

11
kuovonne
T
Tom_QuigleyKnown Participant
posted in Other Questions
Revision history without "difference" between versions

I’m working on creating functionality for an Airtable CRM that mimics functionality found in Hubspot or other CRMs, where you can bcc an email address and it will record the message in the database under your communications with that person. I’m user Zapier with an Email > Airtable Lookup (and optionally Create) > Airtable Update flow. It’s working well enough - when I bcc a “wizard” email address, Zapier looks up the recipient in my CRM (and creates one if it doesn’t exist) and then updates a Date Last Contacted and Last Message field in that user’s record. Here’s where I’m running into trouble. This system will only give me the most recent message. I would like to use the revision history feature within Airtable to view past messages to that user. But, I found when Zapier updated the cell, Airtable did this “version history” thing where some words that were shared between message (like “the”) were maintained in green, and other words were crossed out (see image). Anyone have b

72
T
S
scotty32111Participating Frequently
posted in Other Questions
Trigger automation whenever a record re-appears in a view

Airtable’s Zapier action “New Record in View” will ONLY trigger if a record appears in the view for the VERY FIRST TIME. However, if a record falls off the view — and then that very same record returns to the view at a later date — it WON’T trigger the Zapier action again. We actually need the ability for an automated action to trigger EVERY SINGLE TIME a record re-appears in the view, whether or not the record has appeared in that view in the past. Meanwhile, It looks like Integromat.com will trigger an action EVERY SINGLE TIME a record is UPDATED (which is a great step in the right direction!), but it doesn’t look like it can monitor just one particular view in Airtable. We don’t need the automation triggered every single time the record is updated; we just need the automation triggered whenever the record re-appears in a particular view. [Alternate way of thinking about this problem: Since different views are based on filtering fields, what we’re really looking for is a way to trigg

144
M
Z
Zeena_HassanNew Participant
posted in Other Questions
Linking Tabs with one master spreadsheet

I created multiple tabs in my base. I have one master spreadsheet that I imported in - I am creating several different tabs and would like them to be real - time updated when an updated is made to the master table (same columns and options). Thank you!

133
Kamille_Parks11
B
Bruce_MaplesNew Participant
posted in Other Questions
Basic feature missing still – defaults on base fields

So, I’m back to using Airtable for a certain business project. I set up one field as a Single Select field, with four choices. Then I looked for a way to set a default value for new records. To my surprise, there wasn’t a way to do that. So, I came here, and discovered that people have been asking for this fairly simple feature for years. And it’s still not implemented. Airtable folks, this seems like a big drop to me. Every database I know, all the way back to dBase III+ (yeah, I’m old), has had a way to set a default value. When is 2020 Airtable going to have it?

54
A
A
Andrew_GoldKnown Participant
posted in Other Questions
Amazon Tablet or Android Tablet for Airtable

Has anybody out there tried to use airtable on the Amazon tablets, does it work and if it dies is it work well, I need to get airtable mobile on a tablet and this might be a Good option for me unless some has another idea ; regards Andrew

20
A
L
Lauren_BellNew Participant
posted in Other Questions
Blocks able to show linked records in different tables?

Hello! I’m trying to figure out how to make a Block flowchart or org chart to show the relationship between one main Project record (in a Project table) and many Subtask records (in a separate Subtask table). The blocks are telling me the records have to be linked within the same table… this is very inconvenient for the way my team has our projects structured, and I’m confused why Airtable wouldn’t recognize this as an expected use of the tool. Apologies if this has been asked before, I’ve been scouring the Community topics for a while now and can’t find anything about my specific question. If this is not an option at this time, 1) does anyone have any workarounds they could recommend? and 2) I would love for this to be an actual feature of the tool. Again, very surprised this was not anticipated to start with.

114
A
N
Nathan_Roberts1New Participant
posted in Other Questions
Using a form to Update Contact Info

Huge apologies if I’m asking somehting idiotic! First time poster… I run a charity and want to enable our volunteers to update their own contact info and details such as next of kin etc. I know there is no way to edit information in my main table. But can I set up another table which I pull data from using a lookup and have that lookup only pull the most recen information ie. if I am Jo Bloggs, I submit my next of kin details on a form. Something changes, I then submit another form and the first one is negated by this later additon? Thanks in advance for any help offered. Very best, Nathan

343
N
J
Julia_HarrisonNew Participant
posted in Other Questions
Add total to stacked bar chart

Hi, I am creating a chart block to use for reporting. I have been asked to create something like the attached. I have set up a table and can get all the category counts to show accurately in a a stacked bar chart block. What I can’t seem to do is add the “Total” to the top. Is there a way to do this through the chart block settings that I’m missing, or does anyone have some advice about an category I could create to house the totals and then add them to the chart block? Thank you in advance for any advice or help!

41
ScottWorld
P
Process_BoostInspiring
asked in Other Questions
Mapping Multi-Select Fields with Integromat

I have a scenario where I am mapping a Multi-Select Field in one Airtable Base to a Multi-Select Field in another Airtable Base using Integromat. The scenario requires the JSON Parse module in order to correctly parse the data to show up correctly in the 2nd Base. The Multi-Select Field can contain a variety of social media Channels, like Twitter, Facebook, Youtube, etc. The scenario works great unless I add in more fields beyond the ones that are being sent. For example, if I map it to where there are 6 potential Channels to choose from (Youtube, Twitter, Facebook, LinkedIn, Tiktok, Snapchat) but only 3 are sent in the Scenario, those 3 extra fields will be sent as “null” and this causes an error in the Scenario. Is there any way to remove that null, so that the JSON produces THIS: {“Channel”:[“Twitter”,“Instagram”,“Youtube”]} instead of THIS: {“Channel”:[“Twitter”,“Instagram”,“Youtube”,null,null,null]} Thank you!

3613
ScottWorld
J
Justin_HallParticipating Frequently
asked in Other Questions
CSV Import Block: fixing Field Mappings

We’re making use of Airtable to help manage our delivery menu for bud.com. Airtable’s CSV Import Block helps to bring on new products for various regions into our overall catalog. Now we’re running into an issue with field mapping in the CSV Import Block: Airtable mixes up the fields to match as we import different spreadsheet, and there’s no way to quickly reset the import system. Details: We import a CSV of items from Sacramento using the Airtable CSV Import block. We have matching field names for the import data, so the fields show up matching immediately - hurray! We are importing fast. Then we go to import a CSV of items from Oakland. The Oakland fields are about 95% the same, but with a few different field names, and a different order to the fields. For this second CSV, even if they have many overlapping field names, AirTable will suggest non-matches - ignoring direct matches. So if we had matched these fields for a Sacramento CSV import: Published <= Published Weight (g) <

222
B
A
Alejandro_DuranNew Participant
posted in Other Questions
Airtable and Zapier to Import Data Using the BGG XML API

Hi, I am a newbie so I apologize if the answer to my question is obvious. I am trying to create a simple Airtable → Zapier → Airtable Zap. I am using the BoardGameGeek XML API to get data to create a database of my boardgames. Zap gets a field from the triggering record (a boardgame ID), use webhooks to send a request to BoardGameGeek XML API and stores the values back into the same Airtable record. My problem is that some values appear as “null” and stored as empty cells, but some other values are working fine. I tried adding a content-type header “application/xml”, but it didn’t solve anything. I can’t find the issue and I would really appreciate some help. This is the xml I am trying to import: https://boardgamegeek.com/xmlapi2/thing?id=13

40
A
P
Paul_HolwegnerNew Participant
posted in Other Questions
Embed into New Google Site

Good morning I am trying to embed my table into the new google site and its not working. When I copy and paste the code in the embed part of the site. It is blank and when I copy and paste the site into the URL I get the following

30
P
K
Kaio_HNew Participant
asked in Other Questions
Including blocks in "View Links"

Hi! Does anyone know if it’s possible to give visibility to blocks (mainly Gantt + Timeline) while creating a shareable link to a view? Thanks!

31
ScottWorld
L
Lauren_AzicriKnown Participant
asked in Other Questions
Is there a way to have a formula tell you if a deadline is upcoming instead of just before and after?

Hi all, I am trying to format a field to show whether a deadline is “On Time” (before deadline due date), “At Risk” (same day as deadline due date) and “Late” (past deadline due date/time). Is this possible? I keep getting lost in my nested if statements and when I add another component, I am getting blank records. Thanks, Lauren

490
L
J
Johannes_BjorkmNew Participant
asked in Other Questions
Limiting my own permissions?

Hi all. I’m getting really happy about Airtable, but have one question I can’t seem to find an answer for (I’m sorry if it is actually obviously out there): I’m the owner of our workspace. Is there a way to temporarily “limit” my own permission to Editor? When I use the database for daily work, it would be good to know, that I can’t accidentally mess up the fields etc. I’ve used Knack previously and like the clear distinction between messing with the actual database and using it for work as intended. Thanks!

143
J
K
Kevin_ButlerNew Participant
posted in Other Questions
Stuck trying to implement a personal CRM

Hi, I’m evaluating using Airtable and decided to try implementing a personal CRM in the process. I’m having a few issues and appreciate any help. First, I currently have two tables: Contacts and Interactions, with a one-to-many cardinality. For instance, in Contacts I might have John Doe and in Interactions I have an email conversation and phone conversation. My goal is to be able to see all my contacts and only the most recent interaction. That way I can quickly see what happened last with everyone. However, I can’t figure out how to have lookups or rollups in the Contacts table that only bring in info about the most recent interaction. If I were doing this in some other way, I’d use SQL to join the two tables, group by contact, sort by date, and keep only the last for each group. Any thoughts on how I do this in Airtable? Another issue I have is that when I do have a lookup that is a single select from another table, it loses all of the formatting from the other table (it’s no longer

41
A
D
Dev11New Participant
posted in Other Questions
Sum of Records in one table to another

I use my airtable to book bands and organize their data. The band makes a profile using the AT form and it populates one of our tables and creates a record. I know at the bottom of the column it displays the SUM of records but is there a way of taking that number and putting it into a new table’s record. Basically I want to take the SUM of all the bands that sign up (in table 1) and in Table 2 have a record that says “Total Bands” “300” that way each time a new person signs up that number will increase. I want to eventually integrate it with zappier so I can have a counter on my website for how many bands we have and all the amount of gigs we book them.

421
kuovonne
J
Justin_GuerreroNew Participant
posted in Other Questions
Forms pro or Qualtrics

Is there any way that I can create a block or a way to integrate data from a Forms Pro or Qualtrics survey I’ve created? I see that Airtable has its own version of that but I was wondering if there are any ways to connect to the other programs. The company I work for pays for them so we’re trying to utilize the products. Thanks!

72
J
D
Daniel_SaundersParticipating Frequently
posted in Other Questions
Formula with fields from different tables

Is it possible to use information from a linked table in a formula? I’ve got an Airtable recording books that I read. In one table I have start and end dates for a book, and the details of the Book (author, number of pages) are in a second table. For some nerdy statistics, I wouldn’t mind being able to create a formula like (End Data - Start Date)/Number of Pages in Book…where the dates are in one table, and the number of pages in another. Is this possible currently in Airtable?

3714
A
C
Chris_AndersonNew Participant
posted in Other Questions
Header Printing - Multiple Page Grid

Hello, I’m curious if I need to make a change to ensure the header rows print at the top of every page when using grid view. I have a multi-page document and I’m either getting the header row only on the first page, or in one case only one of the 4 column headers on the subsequent pages. Is there a setting for this please? Thanks! Chris

114
M
M
Matteo_PotaNew Participant
asked in Other Questions
Searching a base which has a field zip code for example

Greetings! what is most efficient way to query a base for zip codes >= 12499 and <=14999 for example? Thanks

210
ScottWorld
N
Nick_Bergthold1New Participant
asked in Other Questions
Create inline form fields? (ie. multiple fields in same row)

Is it possible to display multiple fields in a single row? Seems like Airtable can only display one field per row:

512
N
D
Danny_AcunaNew Participant
posted in Other Questions
Mass Data Import from Airtable to SharePoint

We are looking to more a chunk of our data into SharePoint. Is there a tool out there that will make this process easier? We looked into Zapier but the only trigger out of AT is Add Record. We wanted to avoid having to export everything to CSV and having to recreate all the relationships between the tables. Thanks in advance, Danny

421
ScottWorld
A
Anjali_MalpaniNew Participant
posted in Other Questions
Image download not working for embedded base

Hey! I was trying to download the images in from the embedded airtable base on my website and the download button doesn’t seem to be working. When I click download it takes me to another tab and then nothing happens. Can someone please help me sort this as we need to embed it on our main website asap. Thanks for the help!

101
kuovonne

Badge winners

  • Welcome
    ROmlehas earned the badge Welcome
  • 10 Replies
    sarahschoonhas earned the badge 10 Replies
  • Welcome
    jt_hkhas earned the badge Welcome
  • First Solution
    AviChas earned the badge First Solution
  • First Solution
    mirbrookhas earned the badge First Solution
Show all badges
Terms & Conditions