Other Questions

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 meaningful way with 100+ stakeholders. I could just add a bunch of hyperlinks or URLs to our password-protected Team Site,

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": { "x": { "field": "NAME", "type": "nominal" }, "y": { "type": "quantitative", "field": "value" }, "color": { "field": "key", "type": "nomin

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 off one by one. Does this make sense? How can I stop Airtable combining all the tasks that have the same name but belong to different projects? Grateful for yo

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!

Hi, I’m brand new here and new to Airtable. I’m a psychotherapist and want to create a document template to make writing session notes easier. My wishlist includes: Sections that are only visible in the template when they’re selected. For example, if a drop-down menu has only variables related to symptoms of depression and there are no symptoms of depression that section won’t be visible when I print the document. hierarchical single/multi-select fields where the selection in column A creates the options for column B. I found a product suggestion post from 2017 (Hierarchical Single/Multi Select fields) requesting this feature, but no indication that it’s been created. I’ve been looking at various apps/software to create what I’m looking for (Filemaker Pro, Excel/Word, Smartsheets, etc) and Airtable is the most recent. If I can’t do this with Airtable I may need to move on to the next product.

Hi all ! I have 2 tables (N°1 and N°2) I have an automation on the N°1 that creates record (named tasks) in the N°2 On the N°2, I have a checkbox field for each records it creates. I’d like on the N°1 add a rollup or a formula that displays the latest checkbox that has been validated on the N°2. Right now, im able to display the unchecked checkbox using rollup - but I can’t find a solution to only display the latest checked task. Do you have any recommendation ? thanks !

Is it possible to set up autofill fields in a form without using a third-party app?

Hello guys, I am trying to insert Multiple Select data into Airtable. When I select only ONE data, it successfully inserts it into Airtable. But selecting more than one data gives error. Yes, I have already checked and data is perfectly identical on both sides, not even a space difference. (Note: I am not trying to insert new data, the same data is in the Airtable already) Query: mutation { insert_studentRecords( studentPreferences: "{{student_preferences.value}}" ) { studentPreferences } } Error: "errors": [ { "message": "Unexpected error value: { error: \\"INVALID_MULTIPLE_CHOICE_OPTIONS\\", message: \\"Insufficient permissions to create new select option \\\\"\\\\"Standard Selection,Premium Selection\\\\"\\\\"\\", statusCode: 422 }" Things I already tried but didn’t work: Using “typecast”: true as I found in other answers. It gives another set of errors. Looked everywhere but could not find the solution. Thanks.

My new collaborator never receives the invite email. If i provide him with the link for account creation he gots the following message (see picture) mynewuser@mydomain.fr doesn’t look like an email… He can’t access my workspace. Any automation including his email continously fails… What kind of evil is this…?? How is this possible???!!!???

I’ve just done a 67-entry long table, but only the first 13 entries appear on the website page - yes, it’s possible to scroll down to see more or to view larger table, but ideally I’d like all 67 entries to be visible at a glance. Possible???

In my mobile app, a linked record shows the opposite order from how it is on desktop. I’m linking to records where the name starts with a date. In the desktop app, it shows the latest on top (that’s what I want), whereas on mobile it shows the oldest on top. Does any know why? Feature or bug? Adding images of mobile vs. desktop below. Thanks!

Hi, I’ve created an Airtable with 3 different tables. -1 table for survey 1 -1 table for survey 2 -1 table to summarise both surveys In my “summary” table I need to get data from 1 column in survey 1 and from 1 column in survey 2. I’ve tried lookup and link record but couldn’t manage to do it. The surveys tables are made of copy/paste data from CSV files that I update when i need by doing more copy/paste. Columns name and order in both surveys table are different. Do you have any ideas on how I can manage this? Many thanks for your help1

Hello, I have a rollup of a linked field using the formula, ARRAYUNIQUE(ARRAYCOMPACT(values)) For all records which do not have a link, the rollup field is blank. When I group a view by this rollup field, most without the link used by the rollup are grouped by a blank value. For some, however, the rollup grouping’s value is (Empty). Any idea why this is happening? Thanks!

I have invited a collaborator to my base and she has accepted the invitation. However, I am unable to ‘tag’ or ‘ping’ her like I have been able to do with other collaborators I have invited to Airtable and the collaboration process becomes entirely dysfunctional without this. Anybody else experience this??

I have searched the community for an answer to this and I am beginning to think it isn’t possible. I am wanting to use the scripting app to generate unique lot numbers for products my company sells. To keep the lot number unique, I want to have a single field in a single record in a single table to simply keep track of the sequential number section of the lot number. I have had no issue accomplishing this using the scripting app and creating a new table in the same base. My boss really doesn’t like the idea of their being no security around that number, so I thought I might be able to “hide” it in another base and use the api to get and update it. I have no trouble getting the value from another base, but I can’t figure out how to update the record with the new value after new lot number are created. Here is the method I used to get the value in the other base using the scripting app. let response = await fetch('https://api.airtable.com/v0/appXXXXXXXX/Lot/recXXXXXXXXX?api_key=keyXX