Ask the Community

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 our th

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 1Record 2Record 3etc

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 review

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-2000I 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

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. 

I am migrating a base and form from SmartSheet - on that form, there is a check box for “Send me a copy of my response” and when checked, it reveals a box to input your email address. Is this possible in Airtable?

Hello, I have a table with only 2 columns (Name and Creation Date) now I need to send a form from that table but that contains 5 Name fields so that the client can register 5 people at a time and each of them will be a different record.

I am trying to implement a notification to go out to my team via Slack whenever a particular sentence text (named "Changes") is updated via Airtable. This is how I have it set up:1. Trigger Type: When record updated2. Table: Log-in3. View: (none selected, watching all views)4. Fields: ChangesSo the automation is watching only the Changes field.  Now, whenever an update is made, the automation is sending a notification several times, once for every few letters typed. I want it to send only when the team member typing leaves the field after making a change. Is this possible. 

Hi all, I have a base that date and timestamps new records. But since I had to import thousands of records from an old spreadsheet, it doesn’t correctly reflect the original date/time in the CREATED TIME field. So I created a field called DATE + TIME - MANUAL that is a date field that has the original submitted dates for the old records. All future records will get a submitted date/time in the DATE + TIME - AUTOMATIC field. In a third field called DATE + TIME SUBMITTED, I need to use a formula to say that, for a new record, if the DATE + TIME SUBMITTED - MANUAL field is blank, to use the data in the DATE + TIME SUBMITTED - AUTOMATIC field, but using this formula doesn’t bring in the data from the automatic field if the manual field is blank:IF(NOT(BLANK({Date + Time Submitted - Manual})),      {Date + Time Submitted - Manual},      {Date + Time Submitted - Automatic})Am I doing something incorrectly? Or is there a better way to achieve this? In the end, I just need to have a date field

I've been using Pabbly with Airtable for a long time, suddenly today I'm having to update the connection data. No problem, I have done that before. Today, I get this message that pops up while connecting in the Pabbly dashboard. I assume the message is coming from Airtable - “invalid_client”My airtable account just renewed and there was as issue, but that is settled and my account is paid. I created a support ticket, but I hoped a user might understand what is happening. 

Hi teamI have created multiple charts like the one below:I now want to be able to add an average line to cross the chart - something like Let me know how can I achieve this

I have an existing table with 800+ records (imported from a CSV). Now, I’d like to add an image for each record (import from a folder of PNGs–with matching file names). Is there a way to do this in bulk? Example Records: Name, Type1, Type2, Image Abomasnow, Grass, Ice, [to add: abomasnow.png] Aerodactyl, Rock, Flying, [to add: aerodactyl.png] Aggron, Steel, Rock, [to add: aggron.png] etc.

I have a strange one. There is a single line text field in my table definition (‘active’), but it’s not showing up in the API doc for that table, and the API throws an error when including that field in the get requested. I’ve deleted and re-added the field to no avail.  

Any ideas on how to connect Airtable to Replit? TIA

Hi All, very new to AT!  But this has been an incredible community but I haven’t been able to find an answer to this question:I have a column on Table A called “System A Identifier”I have a column on Table B called “System B Identifier” The column on Table A will ALWAYS have more data than the one in Table B.  I would like to create a Table C that links to the “System A Identifier” in table A and a new column that shows me a “Exists: or “Missing” value if that record is available or not based on the field “System B Identifier” column. I think an IF formula is the way to go, i just have not been able to figure it out. Thanks!

In my Contacts table I have 2 types (single-select) - “non-profit” and “legal” - and a linked record field to a Requests table. The Request record has two Lookup fields pointing to Contacts - one a lookup filtered by a view of nonprofit-type only, the other filtered by a view of legal-type only.  This is so my user can quickly distinguish the two types assigned to the request.Now, I add 1 contact to each of the two fields in the Request. I would expect to see both Contacts linked to that Request. But the only Contacts shown as linked to that request are those entered in the first (“nonprofit”) column. If I force a “legal” contact into that first Request column, It shows up as expected on the Contact side.I’m not understanding something about how linked records work. How should I structure the linkages between these fields across the two tables?  thx 

Bonjour, je cherche la page des formule AIRTABLE sur le site AIRTABLE , Merci.Hervé