Ask the Community

I'm trying to follow this guide, but everytime I reach the "Concatenate step" the link that shows up to me says "The private share link you tried to reach is not available.".That's a copy of the table I'm using to, why it doesn't works and how to fix it?https://airtable.com/appFaino3o1b2cqEG/shrHoTe908izs7JPn

Is there a way to download multiple attachments at once? A group of photos has been uploaded for a project and the designer would like to download all of them at once instead of one at a time. Is this possible?

Is there a way to do a mass download of photos from my airtable? The Bulk Upload worked well, now I need to do the reverse! Thanks, All

Hi there! I am looking to see if it’s possible to download a zip file of all attachments for a particular field. I did look at This Post and it does not seem to cover what I’m looking for. I don’t need to download ALL files attached to the base as the aforementioned thread is describing. I want to be able to zip and download the attachments for one field instead of having to download each one individually. I could have sworn I was able to do this at some point in the past, but can’t seem to repeat it! Any advice would be greatly appreciated. Thank you!

#needhelp! I have a gallery view, in my records there is a field with 20+ attachements (pictures). When I share this view, and I would like people to be able to download the 20+ images from a record all at once. Just by clicking on a button. How can I do that please ? Thanks for you help.

HI,Is there a way to trigger an automation an hour after a date time field is set? For example I have a field set to Feb 4 at 3:00 PM, and an hour after this time set i.e. at Feb 4 at 4:00 PM, I want an automation to be fired?

I usually use linked record for choice option instead of single select, just in case of use with other tables. As my records keep growing, I am worried about the record limit.Does number of choice in single select also count as record limit per table?

I have a data in airtable of clients.For each clients I want to create a dashboard and share with them so they can check-in daily and see the progress.Let's say I have 100 clients.But airtable interface has limit of 50. What should I do now?

Im over limit on a base and trying to upgrade to Business Plan. I cant get a response from support on this item. The system is only giving me annual options, not monthly, which we are currently on. Ive attached a screenshot. The system shows monthly price before entering this page, but once in, it seems its only annual options. I appreciate anyone's help on this. A little confusing and frustrating. I need to upgrade ASAP for my team but dont want to be suprised with a 5K+ bill next month.

I have rollup field that sum all the records from a table. I want to limit the sum from all to sum for current month only.How can I do it? 

Looking for a solution for a public view where I would like to share information partly. To be exact - I'd like to hide the last characters of the text string by replacing the last letters with stars ***Tried to look up for ready solutions but had no luck.Would appreciate any help.

I have a personal facebook art page where I post to many related facebook art groups, when a post is submitted to a group it goes into a moderation state, then I just wait for their admin to accept/decline the submission.I've setup a base that contains:All posts: Individual art piecesGroups: Each Facebook group I belong toIn the "All posts" table, I've added a "Roll out" column which is to show the status of whether I've posted to all groups. But I don't think this is ideal as it has no relationship to the groups.What I would love to see is some kind of progress state column that tells me how many groups there are outstanding which I have yet to or are waiting on post approval.

Hi,I am trying to automatically create or update records based on certain criteria from another table. It's to create invoice with line items. The process is the following:1. if a record's date field is today, create a record in table A.2. then find a record with the same client in the table invoice, 3. if not found, create a new client record in invoice table with a line item that is linked to the newly created record from table A.4. If find the client, then append the line item field with the new record from table A.The problem is that sometimes there are multiple records matched in the first step of the automation, then both try to update the line item field in the invoice table and the later automation run overwrites the previous run.I imagine there could be problem if no client found then two clients records would be created in the invoice table. I haven't encountered it in my testing yet.What's the recommended solution here?Thanks!

Hi there! I'm trying to design a base with a public facing form for camp registrations. I was planning to use multiple select as the camp selections field, so folks can sign up for Camp A, Camp C, and Camp D all through one form. Where I'm running into issues is designing an automation that disables selections when they reach a total. For ex. only 12 people can register for Camp A, so when 12 form submissions come in with that selected, it needs to be removed from the list of options. In a different setup, I've used lookups, views, and table links to create this utility, but that was date/time based, so I could use it as the primary field. I can't use multiple select as a primary though, so I'm a bit stuck. 

Hi everybody,Let's assume I have 3 tables:ToolsUsersRequests (= Audit Log)Users can create a request to get access to a certain tool. When the tool admin approves the request, the user is linked to the tool. That's fairly simple and already working.Now tool admins can also add ore remove users directly to their tools, by linking or unlinking them.In that case, I want to automatically create a record in the Requests table that contains the user and the tool that was either linked or unlinked, as that table serves also as my audit log. Any idea how I could solve that?

HiI’m a beginner and so far I’ve only done one use case with Airtable. Now I would like to use it for my daily life and I thought it would be nice to have a table like Excel linked with all the applications I’ve made via LinkedIn, Welcome to the Jungle and I would like to know if there is an API?  Thank you.

i want to migrate my data which includes attachment from spreadsheet.com to airtable. Please help..!!!

Hi. I'm sorry if this sounds a bit vague, but what I'm trying to do is this:I conduct sessions with students and each session is a record. At the end of a month I have a table with multiple students and their sessions. Some students will have 4 or 5 sessions per month.What I want to do is find all sessions for each student, then extract the 'date' and 'duration' fields data to make a list of all the sessions the student has had in that month. I will then use an automation to email this information.I'm not sure where to start with this one. Is there a nice, elegant way to do this? 🙂

Hey everyone,So i created an automation that email to texts a group of individuals when certain criteria are met. This is a large list of people (sometimes over 100). This works flawlessly unless someone changes their carrier... or their phone number and I have to wait for the automation to fail to see which email to text address is incorrect.This is fine however it will not send to the remaining valid email addresses it just halts the whole automation. I'm hoping to still have the automation fully fire even if one of the email addresses is invalid. Is there anyway to do this or is this a limitation of validating email addresses before sending within airtable?

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, then we would have a new date to calculate the 2nd year.                 Each customer will have a separate start date so the formula would have to be connected to the start date column.              

I have five tables, each with a list of contacts. I want to identify the contacts who appear on more than one table.  One setup is: When a contact appears in two or more tables, I want to add this contact to a new "cross-check" table. The new table will have a record with the name of the individual, and the tables this name appears in. This has proven to be really cumbersome to automate.I just need some simple setup that enables us to easily see who appears on more than one table, and flag when a new contact is added and that person is already on another table. Any creative ideas for this?Thank you in advance!

I have a Sales Pipeline base, and have set up an automation to run based on a change in deal stage (to "closed-won"). This creates a new record in my Master Customer List airtable. When I filter my Sales Pipeline base and then unfilter, the automation assumes that the unfiltered "closed-won" records are new and therefore should create new records in my Master Customer List airtable. This is causing issues with mass duplications. Is there a workaround for this? 

[First time Airtable user] I am working to create a master database of contacts linked to their segments in the industry. And in those new tables I want there to be more information on the companies. Table 1: Master contact list I want this table to hold all contact information of the person including if their company that they work for is in the Top company list on other lists that I have. These lists are detailed statistics and information on each company in my industry. Other tables I thought I might have are: Clients, Topp Supplement Companies, Top Raw Material companies, etc. I need help in organizing this data to where if I go to a person. And I know they are the CEO of X company, then I can see if that company is in the other lists I have (maybe in another table?) and from there I can see all of the information I have on this company and having all of this linked… If this makes any sense at all please let me know and if you have any suggestions that would be greatly appreciated!

Hi there! I have a form that generates a single record that has multiple attachment fields. I am trying to find a way with either a script or an automation to pull all the different attachments together and print. (Maybe an automation trigger that collates all the attachments into a singular pdf and a prompt to print..?) Any suggestions? I read through some very sophisticated responses that @Jeremy_Oglesby  @JonathanBowen gave to @Matthew_Hilshor back in 2021 for a question titled "Moving Attachments"- do you guys have any ideas?

I just found this article today: https://support.airtable.com/docs/mobile-interfaces-in-airtableLike many/everyone, we really, really need a mobile interface view for our Non-profit organization. We're looking at purchasing a cheap laptop to keep onsite, but it would be so much easier to have ONE iPad, which we can easily get donated. I was searching about whether we could use chrome to view our interface on a chromebook, and I came across the above article that was posted yesterday. I have messaged support, but though I'd check here as well. The airtable version in the app store is 2 weeks old, and I am still getting the "view on desktop" message.  Looks like google play store was updated on 2/14...guess I need to wait and download it on my kid's android when she gets home from school 🙂