Other Questions

Is it possible to set record limit in a table…If i created a table that will be contain 10 record max,this size should be fix .Can not create new row…is it possible kindly guide me…share some pic that help me easier

Hi all, I would like to just have clean text in the PDF. The highlighted lookup fields not only retain their field color but don’t respect default fonts. Thoughts? Thanks, Matthew

Hello, can anyone suggest how to create a filter where {date) is equal 2 days from today. The {date} is from Airtable and it is a lookup field. This will send email to client 2 days after the service was provided. Thank you for help

Hi, I get an error on my AT - Invalid Permissions, Refresh Page Any idea how to remove it?

Would love to know if it is possible to use the Script Block for something like this - basically, send a record to an Asana Board and create a ticket with certain fields. Is that possible?

How to navigate from one page to another with Airtable reactjs I have 2 pages(home.js and access.js) linked to index.js when I run the code via block run. it says Bundle updated but am seeing this error in my airtable Error: Objects are not valid as a React child (found: Error: [object Object]). If you meant to render a collection of children, use an array instead. in Error (created by Context.Consumer) in Route (created by HelloWorldBlock) in Switch (created by HelloWorldBlock) in div (created by HelloWorldBlock) in Router (created by BrowserRouter) in BrowserRouter (created by HelloWorldBlock) in HelloWorldBlock in div (created by BlockWrapper) in Suspense (created by BlockWrapper) in BlockWrapper (created by ForwardRef) in ForwardRef throwOnInvalidObjectType@https://localhost:9000/__runFrame/bundle.js:59956:15 reconcileChildFibers@https://localhost:9000/__runFrame/bu

I am getting close to getting this right but need help with one aspect. I have set up two tabs, one tab has responses from my questionnaire and another is going to chart the results. When I have a field that reads a certain word from my response table “ie, red” I want it to tally in my chart tab as 1 response was “red” I have linked the two charts but this isn’t automatically populating, can anyone assist? Thanks!

I’m having a lookup table in my view and I like to filter using elements from that table. I create a precise filter using the “is” statement. However, it does not work and other eletents also display – as if I had chosen “contains.” I’m now forced to exclude with an AND statement other elements, thus making my filter bloated. Please see here the screenshot: https://i.imgur.com/QhOjN4I.png

Hey Airtable Fam. I would love to build better graphs. Is the chart block super limited or am I just doing it wrong. Here is a graph of the ages of my database. I can only see the number if I hover over the age block. How can I get it to show the number of entries per age? or if I had them as percentages (I guess by building a formula to show percentage of the age and then making a chart from that) Any help to make my charts better would be massively appricaited. Thank you

I am looking to automatically categorize information submitted in a form into individual databases based on 1 question in the form. is this possible? I was thinking that maybe all information is submitted to one database and then split into multiple bases automatically based on some sort of linking. Can anyone help?

I’m still plugging along with an Airtable portfolio/project tracker PoC used to support our weekly reporting requirements. I would like to have unique milestones (i.e. different sets of milestones) tied to specific projects. Currently, I have 3 tables with the following (relevant to this discussion) information: [Portfolio] – {Project Name} - Primary field – {Milestones} - linked to [Milestones] table. [Status Report Entries] – {concatenated Project Name + Date/time formula} - Primary field – {Project Name} - Linked to [Portfolio] table – {Status} - Long Text – {Milestone} - Linked to [Milestones] table [Milestones] – {Milestone} - Primary field – {Project Name} - Linked to [Portfolio] table When our managers enter information into the Status Report Entries table, I would like the {Milestone} field to only pull milestones available for a specific project. Ex) [Milestones] has the following sample entries: {Milestone}

I’m trying to do EXACTLY what is shown in this video: Airtable - Support

Hi everyone ! Here is my issue : I have to manage the planning of different training session. For each session (ie : each entry), I have 3 dates, and each date has a trainer : Training A / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 Training B / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 … Each trainer can be on different session, and different dates. In the end : how can you get a personal planning for each trainer ? :thinking: Since filters apply to the whole entry, I have difficulties to keep only the date related to a specific trainer. I suspect I may have put my hands in the script blocks but if you have a workaround, I’ll take it ! Thanks ! Arnaud

I am using the Zapier trigger for ‘New Record In View’ to get records that have a date field that is equal to today’s date. However, as I understand it, that trigger will only work the very first time that record is shown in the view. Each record will show in this view once per year, and I’d like it to trigger each year. Seems like it won’t do that if it only triggers on the first time in that view. Is there a workaround for this?

A simple export of a table as CSV does NOT come back in tact! I added a period to another text field using Notepad to make the simplest change possible without formatting issues. Then, I imported the same CSV I exported save for the 1 period added within a text string (so it would update the record). The multiple select column kept only ONE selection for the updated row… I need to be able to import updated content reliably. This is not proving to be the case.

Hi all - I have some real estate data I want to import which is a list of property information and contact information associated with that contact. So one owner, who was a unique mailing address may have a relationship to one property or to many other properties. Is there a way I can import the data in the link below into a “Properties” Table and a “Contact” table? When i’ve done this in the past, it has imported without connecting the relationships together. docs.google.com

I recently got a response from the Airtable team that we may get back the random number from Formatter by Zapier. Here is the idea Airtable-Formatter-Airtable I want to have a random unique combination of four digits, the “0” ( or “00”, “000”) can not be in the beginning, I need some excellent folks to help, because now seems really possible that I’ve been trying to understand this Formatter to convert data into a different format. Let’s try to make this happen.

when I download a view the telephone field (column) is incomplete - only (845) is downloaded and not the whole telephone number. field is defined as Phone. Thank you for your help!

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

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

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: Si

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!

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?

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

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.