Ask the Community

I’m currently a Pro user and I’m considering an upgrade to Enterprise. I’d like to know if the following workflow is possible with Enterprise. A billable collaborator creates a form for a Base in their Enterprise Workspace. The billable collaborator shares the form with a non-billable collaborator from their domain. The non-billable collaborator accesses the form, authenticating with SSO prior to seeing the actual form fields. The non-billable collaborator submits the filled form, and their user ID is passively submitted along with the other form values. (I suppose this ID would be the email address they used to authenticate with SSO.) A billable collaborator can see the new record (with the ID of the user who submitted it) in a grid view. Reasoning: I’d like many individuals from my organization to participate in data collection and entry but want to restrict administrative access to a small team. The number of potential participants is around 300, and I’d prefer not to have to pay th

Hi! I created a base and interface for a game I have been playing, Schedule 1. Yes, it is a game where you create drugs based on different combinations and then sell those drugs :P. I have included a public view of it below. I have it basically how I want it, but I need a way, anyway, to From the drugs table, have a view that pulls the Teir 1 drug from any drug that isn’t a T1 drug. And then display in each row, the T1 drug, the different mixed supplies, and the drug effects. The challange is, in the game, when you make the drugs, they randomize the names after mixing. So, what for me, mixing ‘Aspen Grool’ which is a T3 drug, might be called something different for another user. It would be rather daughting to dig through each drug combo and source it back to the T1 drug, so I was hoping there was a way to do it in a formula or view or something. Thoughts? https://airtable.com/appXdxs1ShjFgTxFE/shrbWwxkofvHeaHNr

Hi, I am new here. I have some columns like name, email, job title. I have 3000 rows of these data. I want to send personalized emails to all of these 3k users with their name and job title. How can i do it? Is there any automation or extension available which can help me with sending these email automatically? Thanks for help.

Hello everyone, Goal: When new or updated Record in Airtable --> Create Event in Circle Airtable: https://airtable.com/app2Ndd4eV463aOsy/shrbaX4IOs9mGkQoP Circle API: https://microconf-de57a9.circle.so/settings/api?page=1 There are 3 required fields to Map: Name of Item --> Name of Event (Single Line field in Airtable) Description --> Description of Event (Long Text field in Airtable) Start Date Time --> I have tried both in Date Format and Also Single Line Field. I have tried both Zapier and Integrately. In Zapier I get JSON error and in Integrately I get [object Object] error. I believe the Start Date Time is the error but I have tried multiple formats, ensuring it matches with Circle API and even tried converting to plain text and copied the exact same format as in Circle API (minus updating the year to the future). Not sure what I am missing.

Can anyone tell me how I would write a formula that will return the lowest date from a series of dates? this would be very simple in excel, but it seems impossible

Hello, I am currently trying to send an Airtable automation where it bulk emails people from a table. However, I am in the ‘To’ section to send an email, but I can’t find an option under ‘Current item from List of records’ that has just a general statement of ‘Applicant Email’. Currently, it’s showing a specific Applicant Email, but I want to send more than this person. This is also happening for the message when I am trying to include their names. I’ve attached one of the screenshots as a reference. Can someone help me resolve this issue please?

Hi everyone! I have created an interface to keep me organized, and one thing I would like to add is a table that would function like the data side, just within the Interface. For my specific example, I have various groups I invite to events, and it would be helpful to have a table with the group name, group contact, and then a checkbox for when I’ve contacted them. My interface is a “Record Review” interface. Does anyone know how I can achieve this? Any help is appreciated!

The problem: Our manufacturer will ship the contents of a Purchase Order as they are made and ship the remaining products when completed. We have had several occurrences of not knowing what’s coming and what is left until it arrives and we open the box. (We have a middle man, there is no direct comms with the supplier). My goal: Build an interface that the manufacturer can open, select the PO number, and input how much of each SKU is in the upcoming shipment, and put in the tracking number. Where I’m at: I have a Master Products Base with all of my SKUs in one table, and purchase orders in another table. I can add my skus from the products table into each PO, but I can’t assign each sku an order qty within the PO record. The other nuanced issue is that sometimes PO’s overlap and we will have the same SKUs on multiple POs. I want to be able to assign different order quantities to each SKU in a PO, and keep track of how many have been shipped from each PO.

I’m a big fan of look-ups but I would really like to be able to remove records the occur more than one time. Is there a way to do that?

Hello, I have built a table with links to spotify, Instagram, twitter and tik tok and I also include the number of followers of each of the artists in the table. I update this data by hand and I would like to know if there is a way to automate this update or to do it on demand for a previously selected group of artists. Thank you!

Hey All, I am trying to add a button to an interface which will simply duplicate the existing record the interface is looking at. The Interface is a quote builder and we often want to make different iterations of a quote for a customer. I know we can simply go to the grid view, find the record, right click and duplicate the record, but I am trying to not give my sales team access to that level of data. You know how sales teams are. 😉 I imagine a script of some sort would work, but I'm more of a no-code guy, so I'm looking for some help. Thank you for your time.

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

I am new to Airtable and created my first form a few days ago using the new Form Builder interface. After the fact, I realized there was a field I hadn't included that I'd like to prefill. I read through all the various instructions on prefilling by altering the URL - all makes sense to me - but I can't figure or WHERE to do the URL edit in the Form Builder interface? I can copy the form URL to the clipboard, but WHERE to I put it where the alteration to the URL will be pulished and saved?Any guidance would be greatly appreciated. Thanks!

Hey AT community. I downloaded the “Sales CRM” template and created an account (a potential customer), but I am not able to see it in Interactions, so I cannot add any interactions. https://airtable.com/appIirQcIOaiJSq0w/tblpZMgRZq8MVJaGi/viwSC4OGJxNSvEex2?blocks=hide. The account I have added is SunRise, if you are able to see it in the link I have provided. Can you please help with this? Thanks.

NPO TEAM ACCOUNT (just to let folks know) So I love having master sync tables and create views off them for different usages in a base. For example: I have a common base for State and Country, absolutely love this, and use it across a lot of our bases for different purposes. In our CRM we use it for Contact, Company, Communities, Speaker/Facilitator Bureau, Charity Compliance, and Grants tables. There are some privacy requirements, and access controls that we have in place. I have set a VIEW - States, just for lookup that does not show ANY other fields except the STATES field. So why if the view doesn’t show any of the other fields (where it is being used in the other tables) why does the individual record show. And then when I open it up - I see all the other areas I really don’t want some of my team messing with. Have I missed how to not show the other tables? Yes, I know I could make an interface but some of us like to work in a different manner, and bulky block interfaces are not o

Hi guys, I'm trying to connect Airtable with Make. My Make.com module is returning "Status Code Error: 403" and I can't connect up my Airtable. I initially had it working and then created some new bases, so I generated a new Personal Access Token. Not working. Have tried different permissions. Logging out, logging in (I know). Etc. Any suggestions?

I’m exporting data to a pdf via Typeflow. One of the fields is a Link to multiple records, which happen to be street addresses. When I export the data to a pdf, the default view is to separate each linked record by a comma. I’m trying to create a line break instead of a comma. I created a formula field with SUBSTITUTE(Addresses,”,”,”\n), however the street addresses contain commas, so this didn’t work. Any ideas for another work around? Huge thanks in advance. Current format: Record 1, Record 2, Record 3 Desired format: Record 1 Record 2 Record 3 etc

Hello, I help run a nonprofit that has a mentoring program where both mentors and mentees apply and then we make matches between them, and this is the first year we’re using Airtable to help power this. I have two tables within the same base: one for mentors, who have filled out a form and indicated topics that they are interested in mentoring, and then another for mentees, who filled out a different form and indicated topics they would like to be mentored on. Both “topics” fields have the same list that fills in a multiselect field. I have a junction table (“Match”) setup to be able to link mentor+mentee, but I’m running into a lot of difficulties automating the process. Ideally, here’s what I’d like: An automation that goes through every entry in the Mentor list, and then for each Mentor, adds every potential Mentee match to the junction table if any topic matches, and A field for each match in the junction table that tells us how many topics match, so for instance we can manually re

Hi all, we had developed a nice data base application, but sometime users have limited access to internet, I’m trying to work around this challenge, so one of the Ideas are: Question: Can the final users in the field download the Airtable application on their Tablets and work on the database offline since there is poor or no connectivity at the sites. Then, when they are back in the office can they sync it to the main cloud-based database Ideas: Download the portion of the DB into CSV to the local PC, then updates offline and then upload it back to the DB, however and afraid the users enter wrong information or get confused by the layout. Install or add an extension to the DB but I don’t know which could be to let the users work offline. I will appreciate your ideas and thoughts …

Hi everyone ! I am trying to authenticate a request using Basic Auth. I then need to base64-encode my logins. (could encode them manually and then insert but would prefer to keep that logic in the code) I didn’t found how to achieve this “natively” without rewriting the entire encoding function. btoa() does not seems to work :confused: Can anyone help me on this ? Thanks

I am trying to solve the problem with dates validation. The prerequisites are: A date field to check A text string where days of the week AND times of the operation of an establishment are stored. This string might have a format of: H24 or DLY 1500-0530 or MON-FRI 0700-2300 SAT SUN 0800-2300 or MON 0415-1415 1900-2000 TUE THU 0600-1300 1830-1930 WED 1800-2000 FRI 0415-2000 SAT 1400-1600 SUN 0415-0730 1200-1415 1900-2000 I need to check if the date in the date field falls into these periods of time and use the result TRUE/FALSE. Any idea on how to create a formula will be greatly appreciated. Thank you

I have a table where you can chose a proposal number and in another column you can add an amount. In another table (linked to the first one) I want to be able to chose a specific proposal number and sum all the amounts related to that specific proposal number. In the second table I have a rollup but it only includes the first amount associated to the proposal number. For example if a specific proposal has 4 entries (same proposal number but 4 different amounts on 4 rows) it only includes the first amount and omits the rest. Any thoughts on why this is? Thanks!

The amount of bugs and lack of feature parity between Android and iOS is astounding. Is this something that Airtable is working on actively? For example linked records on a mobile interface. There are totally different views for Android and iOS, and the functionality between the two is completely different. iPhones can only add linked records from the "pill" view (which is a bug with the card view for iPhones only), but the pill view has an android bug that doesn't let them add new records through a form from pill view! It feels like I can't win. Android also currently crashes when opening any attached files, or attempting to add any attachments (easily replicable, try for yourself). Android also has no ability to click interface detail view buttons. This is some very critical functionality that has been promised to clients and is not working how intended. These issues are more or less brushed off when I reach out to support. I am posting here so that others can see that you are not al

This might be a bug or I’m doing something wrong. I have a self-linking field in the object_types table called parent that establishes a child parent relationship between types. In my part_object table I lookup the part’s parent’s object_type. The desired behavoir is that any part that is a child of an assembly will only display object types that are a child of that assemblies object type. When I set this up I’m not getting anything. Either I’m missing something or there is a bug with dynamic filters for self-linking relationships. Anyone have any experience with dynamic filters for self-linking relationship fields?

I have two table A and B, table A has product status variable that tracks the different phases of product and helps with different views to see specific inventory. Table A is also linked to table B, I would like to be find a way to edit table A’s status field from B once I am done processing it instead of manually going to A to change it. so far I couldn’t find a way to change. any advise is highly appreciate.