Other Questions

Is there any way yet to export a table with formula fields staying intact? I need to export a table that has roughly 50 formula fields.

Would love some troubleshooting advice. I have always been able to manually drag records to reorder them in grid view. Suddenly I’m not able to move the records. I searched help, and the community questions, and saw that I should look at whether I have a sort indicated or locked. I looked, and I don’t. Anyone know what else I can do to be able to reorder records again? Thank you!

Hope this is the right area to ask for help. The link at Airtable

Thanks in advance for any insight from the AT community! I have a base that includes a bunch of school enrollment information. Some is static/historical, and some is updated monthly. There is one table that with the list of schools as the primary key, and those schools are linked in another table for monthly enrollment tracking. From the latter is a form that schools complete to enter their monthly enrollment information. The form submission has a “Date Created” field. I want to be able to provide the updated enrollment total based on the MOST RECENT entry date. Because different schools provide there updates on any given date of the month (and some haven’t submitted since the previous month), I can’t just filter by date because I will lose some data. For instance, if I put a filter on the date for the last month, it won’t catch a school that last submitted five weeks ago. For example: Monthly Registration Tracking (School names ar

I have a view of records, sorting the amount ($) field from max to min. I only want to show the top 3 amounts in this view. How do I constrain the view to show only the top 3 records?

Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/21 - that’s 10th September, unless you’re American then it’s 9th October… sorry, I mean October 9th. I know I can use “friendly format” which shows the full length of the day and month (i.e “Friday, 10th September, 2021”) and cuts off half the date unless the column is unnecessarily wide. I’ve looked at this thread but it doesn’t mean much to me:

I have a base with a few thousand rows and I have a column that is single select type. Is there any way I can automatically populate that entire column with random values from the single select list (about 15 possible values stored there).

Hi, Airtable community I have tables from multiple vendors. Each table has the same fields. I have to combine the records from each of these tables into one table. is there a way to combine multiple tables into one table? One thing I tried to sync table but multiple sync option is not available. Thanks, Veeral

Hi Can anyone help please? I have just found Airtable’s own Extract Base Metadata Script which is amazing! I am using it to build a library of all data across my bases by syncing to a master base. Have found that when it runs it amends but does not delete any fields that have been deleted. Does anyone know how I can add this to the script as it runs? Deleting records in the new table works and then running script but no good now as all my new added fields with reference info will go. Thanks, Maria

Hi. I am using Airtable Desktop app on Macbook Air M1. When I expanded a row to view in details, there were hidden fields that I can’t scroll to the bottom. Below is the example screenshot. Anybody else having the same issue? How can I solve this issue? Thank you.

How can I configure my expanded calendar view beyond hiding fields? How can I move things to the top of my calendar view without affecting my grid view? Wish I could just drag the field that I want to see in my expanded calendar view but I don’t see how to do that

If the search is limited to a field with pre-defined values could there be a drop-menu of those options as the only way to enter criteria?

Bottom Line Up Front: I need help sharing my AT data with external users in a simple and meaningful way. Background: My organization is a nonprofit with over 100 active members, but a team of 2 managing the AT database. We share information and resources with our members using a password-protected web page, this saves us from sending tons of emails each week/month because people can just check the password-protected Team Site, which has all the latest information. We share things like: A list of team members and contact information A list of team members grouped by their cohort/small group A form for submitting appointment information A form for submitting technical difficulties And the list goes on! Problem: It is wonderful to have a sleek design, linked tables, and other benefits of AirTable, BUT I do not know how to share all my tables, bases, forms, etc. in a

Hi Airtable Community, I am replacing a SharePoint calendar with a calendar built in Airtable since it’s so much easier to modify entries - you can just drag them to different dates in the Calendar view. But, the one thing I can’t figure out is how to automagically create entries in the table for the following sample situations: Payday on the 15th of every month Staff meetings every Tues and Thurs Virtual Happy Hour on the 3rd Thurs of every month … and so on. For now, I’ve copied entries and modified then to build out the calendar items but would love to figure out how to perhaps use automations to create the entries I need. Thanks in advance!

In the desktop app, we don’t get the scroll bar anymore… Anyone else has this bug? I already contacted support, but haven’t got an answer yet.

I have set up an integration between AirTable and Mailchimp. I have a field in Airtable called “MailChimp Tag” but don’t see a way to import that tag in Airtable into a tag in Mailchimp? Can this be done? Any help would be appreciated.

I uploaded a spreadsheet that has an image URL in a column. In Airtable, that’s displayed as a simple URL. Is there any way of turning that URL into an actual attachment? I previously used this spreadsheet in Trello where I imported via Zapier (much more time intensive then Airtable) but could specify the URL as an attachment. Therefore, it was displayed as an image on the Trello card. Thanks

This is driving me nuts: I’m importing events from a Google Calendar sync and it generates HTML markup from the event’s “description” field. I can’t for the life of me figure out a reasonable way to get rid of the HTML. HELP. This seems like it should be easy, but short of some kind of laborious Zapier recipe, I can’t figure it out.

I have two tables. The first one lists the name of classes and the second is a list of students. In the student table, I want to have a field that will allow me to select multiple classes from the other table. How can I create that? I.e. I want a multiple select of the Class Name field in Classes to appear on Students.

I just found the vega-lite block today and am trying to get a stacked bar graph using 2 fields. I stumbled onto the fold example (Fold | Vega-Lite) and was able to convert it to stacked instead of columns… and it looks like exactly what I want inside the vega-lite editor. But inside airtable, it seems that it doesn’t like the return “key” and “value” from the fold command. Gives the error: value is not a valid transform name, inline data name, or field name from the Table1 table: Anyone know if I’m doing something wrong, if this is missing functionality in airtable, or a bug? { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Table1", "width": "container", "height": "container", "transform": [{"fold": ["Field1","Field2"]}], "mark": "bar", "encoding":

Hi all, thanks in advance for any tips! I’ve created a couple of custom views in our main database, and wondering if it’s possible to move all of those views (there’s 5 of them), into a new tab, or base. They are currently spread out across 3 or 4 tabs in one base. So, i’d like to ‘collect’ the 5 custom views i’ve made, and move them to a new tab called ‘to do’ (for example). Any tips?

Hi there, I have lots of projects / published blog posts which need stuff doing to them periodically ie tasks. Currently I have a list of the projects with lots of different data points of which one is the field ‘Task list’ a long form text of tasks, separated by a comma (within same field) eg not all blog posts have tasks attached to them most tasks are unique to that specific project some tasks are duplicated over multiple projects eg several projects might need their headings checked so all would have ‘headings to check’ in the task list. What I want is for all tasks to be appear on my task list table as separate lines. This is mostly workinng fine except for the tasks which are duplicated across multiple projects where I get a single line ‘headings to check’ and all the projects are then in one field so I can’t tick them o

Given multiple other people have posted this and all of their threads have been closed I’ll just open another. TLDR: How long until access will be available to the meta api. We are literally desperate for this as our clients just forget they cannot change the field names as the integrations and automations depend on them. Honestly this is actually a problem of your own making. I don’t know who decided not to include the field id in the REST Api - but if it were there this wouldn’t be an issue for us. Secondly if the field id could be used in place of the string in Airtable Automations to select variables that would also be a big help. So my concise questions are: What is the timeline for this to be open to applications again? Are you processing any atm? Where are you announcing information about this? ie if you keep closing threads in here then where should we look? WE♥️AT Thanks Dan

Using Scripting app to set default values. I set a default value and click Done I get the error, j: userInputStartTime at start on line 352 No matter which field I set I receive the error. Is there a webpage that shows the steps to a solution? I see others have experienced the same issue but have not found a solution. Thanks.

Hi! I’m looking for a formula that would allow me to find the intersection of 2 dates range. For example: Date range 1: 01/01/2021 → 10/01/2021 Date range 2: 08/01/2021 → 16/01/2021 Result: 08/01/2021 → 10/01/2021 I was hoping to find an already built-in formula but I can’t seem to find one. How would deal with this case? Thanks!