Ask the Community

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é

Hello, I am trying to use a lookup field from another sheet.  It seems that I can only search by the primary field, not by the field I have selected as the source.  For example:Sheet 1 - Primary field: Job #Job #: 1234Job Name: Sheet 2Lookup field in sheet 1 - Job Name: (I can search for Job # (1234), but not by job name. Is there a way to fix this or work around?

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??    

How do I duplicate records with Create Automation but not linked to original record?This is for purposes of taking Project Schedule snapshots and currently the data in the new table where the records are getting created, remains linked to the original data.This means the data which I want to be a snapshot is getting updated when changes are made to the original data. 

I have it set so that users can change the sort order in a grid view interface, but how can I set the default sort order that is displayed when the view is accessed?  The interface is embedded into a website for public viewing, and I can’t figure out how to set the default order to be a logical one for most viewers.  Suggestions?

I have a column of numbers. I would like to be able to press a button on an interface and set all values in that column for all rows to zero using a button automation trigger.  Could someone please give a step by step guide?I can create an interface button linked to a record picker that updates the values one at a time… but that is quite tedious.  Please advise, thank you!