Ask the Community

Hi everybody,Let's say I've got 2 tables linked to one another (NUMBERS and OBJECTS)Table 1: 100 NUMBERS ranked from 1-100Table 2: OBJECTS which are randomly linked to these NUMBERS OBJECT A is linked with 6 random NUMBERS: 5, 6, 7, 11, 12, 13In OBJECT's there's a field {ranking} that says 11My question...In OBJECTS I would like to create a rollup field that shows me all the NUMBERS ranked higher then 11 according to the {ranking} field in OBJECTSIt can't be done with the "regular" condintional settings. So I tried to include a formula at the bottom of the Rollup field: IF(value > {ranking},ARRAYJOIN(values, ", ")) I was hoping to see:  12, 13 but i got #ERROR instead... Is there a way to include logical operators and field values within the formula of a Rollup field?Also... w

Hello! In my Inventory Tracking table, I want to name each item as: #Order Date-Product-Supplier. Everything looks good in my form when I'm entering the info, with the date format as expected, but then in my "Name" function field, timezone is included as "T00:00:00.000Z" I've tried reformatting the date field, deleting and re-adding, hiding it - nothing works to remove this extraneous info... any ideas? Formula looks like: (((("#" & {Order Date}) & " - ") & Product) & " - ") & SupplierI'm brand new to AirTable and appreciate any help. Thanks so much. https://airtable.com/appog8wBGoDN5Xiet/tblQuZFbeHjodwxpi/viwWiVK7K2wJqOX2E/

Hello Airtable Community,I have a table with projects and an interface with a timeline view.I would like to display graphically when the project timeline changes. This does not necessarily have to be displayed in this timeline, a new view can also be created. I would like to see when the old estimated start & end date was and when the new ones are.Perhaps something very simple like this: I would be very happy about any ideas 😊 Thank you and best regardsMirko  

HelloI would like to know if it is possible to build an automation --> if Column B (Actual timeframe) changes and does not match with Column A (Initial timeframe), then the Column C (On time?) would change to YES or NO (single select option YES/NO)? Additionally, the actual timeframe value comes from Miro board. Thank you in advance! 

Hi, I'm using an automation to Find Records on a quote and then to Sort this list before duplicating these records onto a Purchase Order.  I'm using the Sort list function and the the Looping function to go through each record, referencing the sorted list instead of the original set of records from the Find Records step.  Unfortunatley I'm using Manual Sort, and Airtable doesn't recognize its own Manual Sort means of using lowercase and upper case letters to sort this list properly.  Has anyone else run into this?For example, in this list: c1KWVc1KYc1KZc1Kbc1Kdc1Kec1Kgc1Ki The sort results put C1Kb as the first result, while Manual Sort puts C1KWV as the first record... Thanks in advance for any tips or suggestions.  

Hello community,I'd like to use a field from a different table in a formula.How can I do this ?--I have a table with a list of attending people to a specific event and how much they paid.I have a table with a list of the different events and I want to display the total payments received. Marine

Hello all,We have an automation set up through Zapier that searches for a record and updates the record if it finds it and creates a new one if it doesn't. The problem I am having is that duplicate records are being created that match the search criteria. I am unsure why and where to look for the issue (Work Flow: Jot Form to Zapier to Airtable).Additionally, if anyone has a fix for a dupe record created because there is an extra space in the field (where and how can I strip it out or make it part of the search criteria)Attached are my search criteria (with a fictional test person) in Zapier and the ID in Airtable.Thanks for any suggestions. 

I'm new and have watched a lot of excellent tutorials that seems to indicate that I should be able to do what I want, but I wanted to ask the user-base to confirm, and perhaps to add any "to do that, do this" comments. I'm on the free plan, but if i can get this to work, I definitely want to upgrade to the paid plan and support the service, but I've been so bad about getting started on projects and then get distracted by some other shiny object and abandon it.  But this time I'm hoping it's different, as the product seems pretty simple to use.I help run a local makerspace, and we have members that pay dues to get access to our space that has tools and stuff.  People apply for membership, and our rotating board of directors (elected by the membership) approve the members.Currently, our process is:member sends google form to apply.the board members get an email, and they reply all with "aye" or "nay".If we get 2 "aye's",  I ma

looking to create a simple automation to match people up based on age and interest(s). Brand new to AirTable. I built a table for "users" and "matches"My use case is to match people up based on age range, gender, and interest.Any suggestions on how to build out the logic? I want to have a drop down of gender/age/interests. So would need to find matching people in the "users" table and email them the matches full profile.  Thank you! 

I have a cell containing multiple dates.I want to have a column retrieving the most recent date from this cell.Which formula can I use? Tried with Max, or even last time modified but didn't do the trick...

I have uploaded images as attachments to about 250 records in a base. Each one uploads without issue and I’m able to see the preview in grid view and the full image in gallery view. I checked each attachment as it was uploaded. The problem is after the fact: now, about 25% of them are coming up as empty jpg icons in both views. When I attempt to open the image within an individual record, the same thing happens - a white box with the jpg icon and the file name. Any insight? I’ve tried refreshing the base, but to no avail…

TLDR: Is dokuwiki a reasonable solution for non-airtable user account management? Or is there something better?As I'm trying to build my application for a social maker related nonprofit organization  that has about 105 members that cycle in and out, some are leaders in the group (9 board members, 4 officers, 6 area leads, etc), I want to have airtable data available to all registered members such as read only the member list and their contact information, and other people that can have access to member maintenance.  And each member would be able to update their own information (self help).  But with 100+ members, giving each an airtable account would be difficult to manage.But then I realized we have a wiki page that supports user management, and I might be able to embed forms and views in certain pages that require different access. I'm curious if any of you see a flaw with this idea, or if there's a better solution.Background: There's a free ope

Hello,  My facebook automation dont't work.I need to reconnect all the time. When I relogin to account it work idk for 5min ? and  then i need to connect one more time...;/How to solve that issue? 

Hello guys, I hope you are doing well. I was wondering if you also have this error? The letters are superimposed on the gallery cards. Could you tell me if it's a bug or if it's me?Greetings!

Hi folks!I recently received an Airtable email that allowed me to download a calendar invite using a button inside the email. I was wondering if there was any way to do this using email automations? I've included the email I'm talking about as an attachment. 🙂 Thanks a lot!

The public api returns a very limited set of attributes in the list and get endpoints for bases and records, such as who to attribute creates and updates to. This would be very useful information to include in the api response so that third party apps can attribute Airtable records / bases to their authors. Currently record comments are the only thing to reference a user.Even at the enterprise level, the audit logs have some limited user information on creates and updates to bases, but nothing around records.

Hi! I noticed the following bug in airtable. The formula that I actually paste in a formula field is not getting saved . Here is a proof of this.:https://app.screencast.com/8pYl20QKMc0fM?conversation=yInYcEQeuFQHhsuAgeFxWNIf you have a solution for this please let me know. 

Hey there, I'm new here and I'm trying to access Airtable Academy (yes, we do have a Business plan), but the page doesn't open at all. Am I doing something wrong or is Airtable having issues with Airtable Academy today?Thanks,Carina.

I have been staring at this too long and thinking myself into circles, need some fresh eyes! I have a base set up with 4 linked tables: schools, which are then linked to 3 program tables for SFS registrations, YF events, and Grants (2 sub-programs, AP grants and YF grants). The overall structure:  Each time a school participates in a program, a new record is created in the program table and linked to that school. A unique record name is generated indicating the program, year, and a unique id # (e.g. SFS-23-24-001). All of this is working great - in my schools table I have nice linked fields for each program where I can see what a school is up to. Awesome! Love it! Where I'm getting myself confused is zooming out a

Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached). Suggestions please!

Hi Airtable Fans, what I am going to ask will sound crazy, but bare with me :grinning_face_with_big_eyes: Sofar, Airtable has been a fantastic ace in my sleeve to build prototype and MVP (minimum viable product) applications faster than any of my colleagues can spin off a Java Virtual Machine. Saving, malaxing and serving data with Zapier and co. is absolutely fantastic. Some of those prototypes even landed “in production” and are still in use today because rewriting them “for real” wouldn’t have a high enough return on investment. Big THANKS to the Airtable team for that! Right now, I am facing the next challenge. The next prototype I’d need to validate a business application idea with, would require some kind of user- and user-specific-data management. And I have no idea if and how I could do with with Airtable. To make it easier to understand, let’s take the idea of a todo list. How could I create a distributed, mutli-user todo-list ap

Hoping someone here has the missing piece. Goal: In an Airtable form when selecting the Other option to a pre-defined list of options, and entering a single line text for that option, that text then presents in the original table with the other pre-defined options for future selecting. I have:Table 1 that populates via a form built in Form View. The form asks for the submitters State.Multiple tables that are predefined lists of Group names based on State. For example one table is all CA group names, another all MA group names, etc. Each table has an Other option.In the form when someone selects a state, the respective table of their state's Group options presents. If they select Other a single line text field presents to add in their required response. That  is working correctly. What is not working correctly is the aut

Very new to AirTable and I'm working in a file created by someone else. Right now, I need to know how to move a row. (The data is in Alphabetical order, and one entry name has changed. I need to re-order it. I just want to drag the row to a different place but it doesn't work)Also, I have grouped the data but can't seem to UNgroup it! The chat bot said to unselect the grouping criteria, but there is no way to do that. Help!

The List interface allows for Grouping of fields within records - which makes it visually much easier for users when records have many fields.Is this available for other types?  I would like it on Record detail but cant make it work.Margaret  

Hi,Our process includes creating hundreds of Google Drive folders for client sharing during a year. This is now done manually, and I am looking at automating it if possible. Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.Alternatively, Airtable would be watching a specified Google Drive directory for creation of new directories, then initiate the process of changing access and pushing the link to Airtable.Any ideas?Rgds,BjörnPS. We use Zapier, so that is a viable option for us. For cost and maintenance reasons I'd like to avoid other 3rd party systems.