Solved

I’m trying to roll up linked records from multiple columns and return only the unique ones (ideally in record form, not string). For my example imagine I have different car models that can have different packages of wheels, chassis, and accessories. Each of those have separate tables where they have keywords associated with each package. I’d like to display a unique list of keywords associated with each car model that is a rollup of ALL the unique keywords associated with all 3 packages associated with each car. I’ve tried 3 solutions on the far right but I’m running into a few challenges: CONCATENATE({Keywords-Wheels},", “,{Keywords-Chassis},”, ",{Keywords-Accessories}). My solutions are returning strings. Is it not possible to return the actual records so they’re linked? I have commas with empty spaces in between for cases where columns may not have any tags associated ARRAYUNIQUE({Keywords-Wheels},{Keywords-Chassis},{Keywords-Accessories}). When I try to apply ArrayUnique() across

HI, I have a guest list for an event and want only the last /recent entered values to remain. Unique identifier is guest name guest code as F1,F2,F3,F4,F5. Suppose guest F2 again enters the form after 10 days with new arrival date and departure date - then he previous entry one should be hidden from my sheet and only this be considered in all rollups/lookups/linking.formula etc. I shall calculate rooms required, catering etc when guests enter arrival/departure/no.of persons etc. data using a form When there are two entries in the form for same guest, say F2 - I want the Last modified time to be picked up /maybe in a different view and the first one should be hidden and out of my calculations. Effectively- Duplicates in the same column (F2, F2) need to be removed and only the value (F2) with last modified time should remain. With this feature- I allow guests to change their plan/date/no.of persons requirement in future by entering their guest code.

I’m new to AirTable. One of our vendors has provided us with a shared view that I want to automate downloading via the API with a C# console app. All of the documentation I see refers to a base ID, and I’m able to get the sample APIs to work. But our view doesn’t have a base. When I go to the URL directly, I simply get a password prompt. Entering that, I get access to the grid/view. I’m looking for a little guidance for how to connect to our page via the API. Thanks

Hi all, I’m using Airtable to make a list of contacts for conflict checking in a law firm. I made a single table of all “contacts” including both people and organizations, and added some basic info like phone numbers, emails, etc. I also added a column which says “contact type” and splits the contacts into people or organizations. I want to be able to list the individuals who make up or work for organizations. I did this by making a new column called “members” and linking it to the same “contacts” table. Then I type in and select individuals’ names. However, I don’t want to be able to list individuals as members of other individuals. Can I write a formula by which an individual is unable to be added as a “member” of another individual? If you’re wondering why I don’t separate individuals and organizations into distinct tables–the reason is because (1) it will be easier to search a single table and (2) I also want (and made) a separate “cases” table which has a column for clients a

I am trying to patch fields, however I am facing trouble with the record ID: Here are the records {"records": [{"id": "recMcKXnqXUsJ2Ptu", "fields": {"Name": "GoodLife"}, "createdTime": "2019-10-10T11:56:56.000Z"}, {"id": "recayWtmjGL5k1kgK", "fields": {"Name": "Love"}, "createdTime": "2019-10-10T11:56:56.000Z"}, {"id": "recqCoVKArOQS4UPL", "fields": {"Name": "Fashion"}, "createdTime": "2019-10-10T11:56:56.000Z"}]} And here is the error message I received {'error': {'type': 'ROW_DOES_NOT_EXIST', 'message': 'Record ID recayWtmjGL5k1kgK does not exist in this table'}} As you can see above, there actually is a record with the ID recayWtmjGL5k1kgK, hence I do not understand the error message.

I’m about to develop a public view of our entire product database, which is one Airtable base of around 2000 records. Right now we’re having something like that in place, but basically just as an embedded view (the standard Airtable functionality) – but we’d like to enhance this public view, hence the custom developing need of it. The functionality of our public view will have to enable filtering all of the products on multiple levels – e.g. product category, price range, colour … you name it. Since this will be a public view, and hitting the api limits would happen easily with around 2000 records (I guess), I believe some sort of caching of the entire base data is in order. My main question is: how, and in what way? My first thought is to poll for the Airtable base at like an hourly interval, and saving all that data in one json file, then reading that json file on the client side with vue.js and outputting it in a gallery sort of way, with all the filters in place. That still leaves

Hello everyone, I use Airtable to manage projects and elements (Balcony, Terrace, Stairs, Separator Screen) in projects. I look for a method to automatically create drawings numbers. Indeed in elements table I have a link to projects table and for each element I create a drawing. I want drawings numbers drawing like this: ProjectNumber-ElementCode-Number the numbers is reset for each different element in same project. Example: Project1-Balcony A-01 Project1-Balcony A-02 Project1-Terrace X-01 Project1-Terrace X-02 Project2-Balcony A-01 Project2-Balcony A-02 Project1-Terrace X-01 So, as you see, the numbers at the end are reset for each element in same project, and reset between project. Can someone help me? Thanks SDionne

Hi there I’d like to make a formula that whenever I mark the checkbox (I’ll unmark it later again), it will add +1. It’s a counter for how many times I already did a recurring task. Any ideas on how to do that? Many thanks in advance Cheers Marc

I have a table/records with a computed column/fields (using a lookup function) - let’s call this field/column F0. I would like to PATCH the table by changing the values of field F1 and leave everything else as is. However, when I send the request I obtain the following error { "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Field \\"F0\\" cannot accept a value because the field is computed" } } Any guidance would be appreciated!

Hello, Seeking help from the community for a printing error. Printing from any view worked fine until the most recent major Windows update (Windows 10). Now, after trying to print, I will get a preparing to print dialogue and nothing happens after that. Any tips?

Hello there For recurring tasks, I’d like to calculate the data depending on what I select in the single select field. For example: if “2 weeks” choose the formula which adds 2 weeks to a date or if “1 month” then add 1 month and so on. Is that possible? Thank you. Cheers Marc

Column #1 {Need Hotel?} Yes or No Column #2 {Hotel Cost (Estimate)} {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)} What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

I have two tables: ‘events’ ‘people’ (including single select field for ‘dietary requirements’) I can assign multiple people to each event. I then use a rollup field in ‘events’ linking to ‘people’ and the ‘dietary requirements’ field with this simple formula: ARRAYJOIN((values), ", ") It returns something like: None, Pescatarian, Vegetarian, None, None, None, None, None What I would really like to see is: 1 x Pescatarian 1 x Vegetarian 6 x None (or No dietary requirements) There are more than three options at the moment (e.g. ‘nut allergy’ and others, and as I add more people there will be additional dietary requirements to add to the single select field, no doubt. What is the way to achieve this ‘count of same items’ please?

Hi everyone, I’m not sure if I’m missing something or what but when I clear out all the data in a column and then paste new data into the column, it still has the previous data saved? I know this because when I switch from single line text to multiple select, the old data shows up as a bunch of choices. Any help? The solution I found is to delete the column and make a new one but I have a ton of data and this seems like it may lead to issues half way through my project. Thanks.

Hi! I am trying to create monthly columns that tell me if a staff worked the entire month, a portion of month or not at all. For example… staff 1 starts 9/8- 11/12 - my formula would show staff 1 worked 73% of the month. Same if staff 2 starts 8/31-9-1…would work 3% of september. I have it almost working…but issue with start date on the first of the month. Any ideas? Thanks! Matt IF( AND( IS_BEFORE({Start Date},‘9-1-2019’),IS_BEFORE({End Date},‘9-1-2019’)),0, IF( AND( OR(IS_SAME({Start Date},‘9-1-2019’),IS_BEFORE({Start Date},‘9-1-2019’)),IS_BEFORE({End Date},‘10-1-2019’)),DATETIME_DIFF(DATEADD({End Date},1,‘days’),‘9-1-2019’,‘days’)/ DATETIME_DIFF(‘10-1-2019’,‘9-1-2019’,‘days’),IF(AND(IS_BEFORE({Start Date},‘9-1-2019’),IS_BEFORE(‘9-30-2019’,{End Date})),1, IF(AND(IS_BEFORE(‘9-1-2019’,{Start Date}),IS_BEFORE(‘9-30-2019’,{End Date})),(DATETIME_DIFF(‘10-1-2019’,{Start Date},‘days’))/(DATETIME_DIFF(‘10-1-2019’,‘9-1-2019’,‘days’)), IF(AND(IS_BEFORE(‘8-31-2019’,{Start Date}),IS_BEFORE({En

I’m trying to get a formula that allows we the take the total of numbers in the linked filed to be summed together For example Total Amount, Amounts used, Total Amount used, Currently in Stock 10 1,4,5 10 0 Idk if this makes any sense at all i just have a list of items in one table with all their information in another table any time i use the item i track the date and the amount used I would like my stock table Currently in Stock number to be able to subtract the total amount used since i may use a product multiple times in different areas or times My Total Amount is to help me track the amount i started to help know if we should get less or more incrase our amount

Hello, I was wondering if it’s possible to configure a form to auto-complete different fields when accessing it from a URL. The documentation for forms does not seem to mention any of this, and I think this would be a great feature to enhance our workflow. In my case, a Slack bot automatically posts player reports for my game, and a in-line link button is generated on the message so that I can add a “Ban” record if the report is valid. Right now, the administrator has to fill a few fields that would otherwise already be specified in the message. I believe adding parameters to a URL would make the implementation and usage of this possible feature very intuitive, like the following example: airtable(dot)com/MY_FORM_ID?MY_FIELD_NAME=MY_FIELD_VALUE

Hello, I’ve been tinkering with this idea but I’m stuck. I have a form with a Multiple Select field. Each option of this Multiple Select is the name of an activity. When the form is submitted, I’d like the table to add a value (I’m calling this “points”) according to the activity selected. So if Activity 1 was selected and the form submitted, 10 points are added to a field in the table. If Activity 2 was selected, it’s 8 points, and so on. Anyone have an idea how to make this? Many thanks in advance.

I have one table of people, and another with records of their visits. In the people table, I am trying to add a field that will tell me the date of the earliest visit… after 9/30/2016. I tried adding a formula field in the visits table to return the date of the visit only if it is after 9/30/16, but I have no idea how to build a specific date into the formula. I really don’t want to add another field to the table that will force me to add “9/30/16” to every single visit record just so I can do an IS_AFTER formula with two date fields. (Which reminds me, why don’t default values you set for certain fields show up when you add new records in the mobile app? Real bummer. But I digress.) IF(IS_AFTER(DATE,9/30/16),DATETIME_FORMAT(DATE,‘MM/DD/YYYY’),"") returns #ERROR everywhere. I am really hoping my format “9/30/16” is the problem, but I have tried other variations with no success. Meanwhile, if it is possible to get that formula to work, will a roll-up field in the people table let me pul

I have an Event Check-In form that allows people to add an Event, which draws from the Event table. EVENT CHECK-IN GRID EVENT GRID EVENT CHECK-IN FORM While we only have two events right now, I can imagine this form getting very difficult to use when we have more and more events. Is there some way to limit which linked records the form can link to based on a parameter like date of the event?

Hi everyone, I am trying to do a lookup from another lookup. To illustrate my request, I have created this base The first field is the close family relationship to Mister A. Mister A has parents and children > Linked record fields Mister A has Grand parents, Brothers and sisters, Uncles and aunts > Look-up fields But I can’t create a lookup from another lookup to have a field with Mister A’s Cousins. Can someone can help me to create a look-up or a formula to display Mr. A’s cousins in a new field. Thanks in advance. Thibaud -

Hello, I need to download a CSV file, displaying the name of the attached files of an Attachment field (without the link). Do you know how to display only the name of the attached documents ? Thanks a lot for your help ! Milarépa

Without going to Google sheets, how can I format an imported date/time from 2019-09-06 7:52 PM in the formula field to 9/06/2019 7:52 PM? Everything I’ve found just sets everything past 12pm to 12:00 AM. Also, is there something I’m missing using the regular date/time field? This doesn’t seem like a big stretch, but when I change the field type it just clears everything. Thanks!

Hi everyone ! I’ll try to explain my problem as clearly as I can… I am using Airtable for research purposes, for my PhD in archaeology. I produced a table for the objects of my corpus, and another one for my bibliography. In my objects table, I created for each object a field “bibliography”, in which I can enter links to records of my bibliography table. At this point, no problem in doing so. What I would like to do, is add a comment or a precision to this link : page and catalogue number that relate to my object. But I don’t know if it s possible… Any idea ? Hope this is clear, it’s not easy to explain, especially since English is not my native language… Thanks a lot !!

I have been setting up Airtable for the records of our large chorale singing group about 6 months. A lot is great, but there are still some things I am trying to figure out. I have a Members table in which the primary field is the member name. Among a number of other tables, I one called Ticket Sales to track the number of tickets sold by each member. I set up the link from Ticket Sales to Members and successfully created the Lookup so that I can bring in the Member Name to Ticket Sales. However, I also want to bring in the Active Status information for each member, which is a field in the the Members table (people who are on leave aren’t assigned tickets for an upcoming concert). But even though in the Lookup field I choose the Member table, and Active Status field, nothing is returned. What am I doing wrong?