Other Questions

Was playing around with the new function for dynamic linked records and was intitally very excited about it, but am wondering if there's something that I am doing wrong. After setting the dynamic filter, if I try to look for records that were not filtered when i try to add a linked record, I don't see those records (aka working as intended).However, when I copy and paste a name of a linked record that I know should pass the filter into the field, it shows up there. In my use case, I am using an automation to copy and paste from one field into a linked record; is there a way to only paste the ones that are allowed in the filter for linked records? (seem to have this issue regardless of whether its a static or dyanmic filter and not sure if its a bug)

Not sure how to even ask this - below is a nice calendar view with tasks on it that have durations set for them.  I don't need to set durations for tasks, but I do want to have "successive" tasks shift by the same amount as any "predecessor" task that I drag to a new place on the calendar as I reorder things.  So if "Task1" is currently due April 1, and "Task2" is due April 15," any change to one should change the other equally.  The commonality between the tasks is a project or client name, and all tasks live in a table called . . . wait for it . . .  "Tasks."The example below is from AT itself:  Collecting Base Metadata - Universe (airtable.com) which was not really what I wanted to do.  Traditional Gantt views are just unreadable to me.  Calendars are.  I think I'm kind of looking for a Gant

I have a date field in my table named “Date Paid”. I would like to determine the week number of the month that date falls into in another field. Example, 2017-11-01 falls into week one of November, 2017-11-06 falls into week 2. Is there a formula that will do this? I know in VBA I can write a function to do this but want to do this in Airtable. I’ve been able to determine the month “Date Paid” falls under pretty easily with, MONTH({Date Paid}) but don’t see any built in functions for week number of the month Thanks for any tips you can provide for this!

When using Calendar view, I really need to be able to look at “This week” on the first line, and the next 2 or 3 weeks. This is easy on Google Calendar, I have a “3-week” custom view set up on it. As long as I’m set up on 3-week view, I can see “This Week” as the top line and the next 2 weeks. Right now, I’m at the end of January, and I need to see “This week” on Airtable along with the next 2 weeks of February. All I can find is the 2-week view, which only shows me “this week” and “next week” and that’s not sufficient for the way we schedule our tasks. It would be even better if I could do this with a total of 4 weeks (this week, and the next 3 weeks) but seeing a total of 3 weeks would suffice. Any help? Also, any possibility of a scrolling yearly calendar that would show 3-4 weeks at a time, but give me the ability to scroll one week at a time? This would be even better.

Is there a way to build a Calendar view that allow us to scroll 1 week at a time through a 3 or 4 week view, using the scroll wheel on the mouse? You need a large monitor for that to work but I have a 42" 4K so that’s not a problem lol. I am a rookie here so if this is a super-simple answer, forgive me lol.

Hi everyone! I am creating a directory by linking a shared Airtable view to a webpage and most users will be on mobile. I would need external users to have the ability to sort and filter within the Airtable view when using a mobile device, similarly to what is currently doable on the desktop version. Is that possible? Thanks in advance for your help!

**3/18 UPDATE: AT support was unable to find any evidence of why this happened; we were also unable to recreate the events and have it happen again. The ticket with them remains open; best guess is that it happened during the same time as a service outage (there was one that affected rich text fields around the same time.)We have a table in a base set up as a simple ticketing system, nothing fancy.Users update a long text field with any actions/updates to the ticket in question.All users who have access to the base access the same way (grid view), though they each have their own view set up.We utilize the '@mention' feature to notify the responsible party after certain actions, and when they become responsible.We've noticed that any time someone enters new information in the long text field and '@'s' someone, the record removes all previous '@'s'.I've watched this happen in real time, and am confident that the system (Airtable) is making th

I have a paid account that I need to move to a free account. I created an inventory for a client that I don't want to lose access to, but that I don't need to update or change at all. It has more than 1GB of attachment data that I don't want to lose, but don't need to actively use. What will happen if I switch to a free plan? Will I just lose the ability to add anything, or will I lose data entirely or partially? Thank you!

Hi there! I'm new to Airtable, and want to know if I can automatically add a task to a base if I email someone with that task?Thanks for your help!

Hello - We have a table of home improvement companies and we use the multiple select feature to indicate what services they offer. There are 82 services under the select feature and we add as many as the company does. For example, Best Painting is tagged for "Interior Painting" "Exterior Painting" etc. During a bulk upload, we use the website as a unique ID, and we want to add services to existing companies without replacing their old ones. Best Painting is on our bulk upload list, and we want to add "Cabinet Painting" to their services. When we do this using the CSV extension, it always clears and replaces the existing services. We have merge records toggled on and it will say "1 record will be updated" - but it always replaces instead of adds. Any tips?

Hi all – I’m brand new to Airtable and super excited about what it can do for our business. Has anyone tried migrating from the Streak CRM (which embeds within Gmail) to Airtable? Although I love Streak, it can get clunky for ongoing and complex relationships – and I think Airtable will be better suited to that. If any experienced Airtable users have already done this, I would love to learn from you!

Hello,I have a table called "applications" containing all the information of students who have applied for a grant. As part of the grant requirements, I'm requesting students to submit a final report. To facilitate this process, I'm using Fillout to populate a new table called "reports." One of the advantages of Fillout is its ability to edit form submissions, among other features not available in Airtable.Now, my question is regarding the setup of the "reports" table. I plan to use the students' emails as the primary field in the "reports" table. Since the same emails will already exist in the "applications" table, I want to link these primary fields to the corresponding emails in the "applications" table. This way, I can easily access and view all the information related to each student in one place.Is it possible to achieve this using an automation? Any suggestions or guidance on how to accomplish this would be greatly appreciated.Thank you.

Hi, I am trying to design a scheduling tool for my business, and the timeline view is proving itself to be very handy. One think I can't quite work out is what 'precise' or 'expanded' does - in certain views. For example, if I have a morning and afternoon booking on the same day, when viewing the whole week, these display as 'full day bookings', and therefore take up two lines. I expected that 'precise' view would show these as two bookings on the same line (representing exactly the amount of time they take up), and 'expanded' to show as I've described, but that doesn't appear to be the case. I can't see why it wouldn't do that - as obviously the software can render records smaller - the month view demonstrates that. It would be great to see these bookings in a single line. Can anyone shed any light on whether this is designed behaviour, or something unusual in my setup?Thanks for the help,Richard 

Hi to all 🙂Maybe someone knows, is there a possibility to import archive Mbox files to Airtable?For every mail, new record in Airtable (sender, receiver, date, Subject, Content, Attachments, etc.)Thanks aheadRegards, Imelda

Hello everybody, at first I set one column in my table 1 so that I can link it to items of records from a different table 2 (via multi-linking to record). Then I wish to fill a different column in table 1 through rollup function with another matching item of the same records from table 2. Problem is, that the order inside the rollup column is automatically opposite to the order in the first column linking to the record. I would like to have the same order in both columns, but I cannot set anything about the order connected to the rollup function. Can anybody help, please?

The new Interface feature allows you to filter a collaborator field by “current user” which is a great time saver. Anyone know if they will make this available in regular AirTable views? I really need it.

Suppose you have a series of records that include zip codes. There may be many of one zip code and a few of a bunch of others. How do I get a list of the frequency of these zip codes? So 14757 occurs 6 times and 14722 occurs 9 times and 20021 occurs 3 times, etc. I want to get a list of the zip codes by how often they occur and if possible a count of that frequency.Any thoughts would be greatly appreciated.Scott

Apologies if this has been asked/answered but I couldn't find that thread - I really did look!I have some MAKE scenarios with many Airtable Modules, all linking to single Airtable BASE - itself having many Tables. But, I want to set up a clone of everything (All MAKE Scenarios duplicated and pointed/linked to newly duplicated Airtable BASE).I am using "Column IDs" in the Advanced section of all my Airtable Modules in MAKE. Why? It seems to offer a bit more flexibility for changing field names in Airtable, so they update automatically when referenced in MAKE. However, this seems to be working against me now - see below.Column IDs doesn't make any difference if I simply CHANGE an existing Airtable Module to connect/link-to the New Airtable base - the field mappings downstream break. Fine.But, I never give up, and I have the Developer Tools for Chrome, and it has this weird tool called Remap Source, which does what I want! But in order for it to work, I have

I’m starting using AirTable and VoiceFlow. I use the following URL Endpoint to GET JSON string and it works fine. httpx://api.airtable.com/v0/appRDBju2BbYrBKCc/colori?maxRecords=1000&pageSize=1&offset={offset} I need to add filterByformula function. Could you suggest me syntax and how i have to use it? Is there a good documentation for this anywhere? Thanks very mach. Federico

The "Add record" and "Add milestone" controls are disabled in our Gantt view. Removing all filtering, all grouping, and disabling/re-enabling "Use milestones" in the view's settings have not helped.'How is this supposed to work? 

I recently started having this issue in Safari where select option fields are causing autofill login prompt to appear. I’ll have to look into it but I was wondering if anyone else has come across this too?

I would like to use a content calendar to create a mockup or preview of my instagram grid based on the dates and images in a record, so that I don’t need to go outside of airtable to preview it. Has anyone found or built a solution that does this?

Hi! I already created and published a form that has received entries. I realized I need to add another question in the form so I added the question in the form, and added that column manually into the base that collects the data. I published the form, but answers for that added question doesn't show up in the Airtable base where it collects data. Where am I going wrong? I made sure to add the column with the exact text in the same order as the form. I also published the form. I can't see anywhere else I need to make changes in order for this response to reflect in the base data. Any advice?  

This morning, trying to use an interface created a long time ago, I encountered an anomaly:when I go to create a record, it does not extract the list of valid values if it has to extract them from a table via a filter.I enclose two screenshots showing how the list on the form is empty, while the preview list of selection criteria has the correct values.Thank you for your support in resolving this anomaly

I've got an automation in Airtable to send a record ID to Make to then fetch some data and send a whatsapp message. When I send the content of a 'Long text field' - it fails. I've tried adding a function in Make to remove all special characters like line feeds etc. and send to WhatsApp - but I can't get it right. Anybody know what special characters are used or the regex I could use?In my trouble-shooting, I created a single line text field and copied the text in there - then use that to send to whatsapp - and it works...  just without the line breaks. Any ideas for me please?