Other Questions

Imagine a name string: Nina and Ian Fowler I want to end up with: Nina and Ian by finding and removing: Fowler. FIND() seems to function left to right, so while I can use: LEFT(Name,FIND(" ",Name)-1) To get: Nina How can I remove the last name: Fowler To get: Nina and Ian Any ideas welcome :slightly_smiling_face:

Hi, I am not a developer and am wondering if any of you can help me out with an easy-to-understand explanations. I need to collect credit card data from our customers and export it to our clients. Our clients use various payment service providers, so I want to use a vault system like ‘PCI Vault’ to store the credit card data. Is it possible to integrate Airtable to a vault system like that?

Hi, i would like to disable horizontal view as i only have ONE column. Tx.

I’d like to use Airtable as an IT helpdesk of sorts. I want to be able to open my users/asset table, select a record, and have a block that shows a record list that is filtered based on that selected record. So, if I have a computer asset selected, it will list all of the ticket’s related to that specific asset. Is this possible somehow?

I feel like if I could have a block that would pull a specified field from a selected row, that would act like the “Long Text Field” popup window, I’d be able to ditch Notion. I just need a place to easily see longer text. Here’s an example. I just want to to change each time I select a new record. The popup is nice, but it’s not persistent.

I run courses at an art school. I have initially populated a base and various tables with student information imported via csv. Now I need to import new information regarding new courses. Some students will be the same. How do I update the original student records with this new information? It seems basic like there should be a check box to update existing records where name and phone number are equal. Any help would be appreciated

@Mohamed_Swellam @Justin_Barrett Hey, I’m trying to integrate Zapier and Ship Station. My orders have a linked field “products” with multiple records. When the items get imported to ship station it is as one item “item 1, item 2, item 3” if I use a lookup field. They need to be separated into individual columns. Is there a way to expand all the linked items into their own column or integrate a better way? BH

Hi I am converting a Google sheet to Airtable. In Google sheet I have a formula that: Counts down 7 days from Last touch to 0, this acts as a reminder. If a follow up date is set, it counts down the number of days from the reminder date If certain conditions are met (e.g. dead/stop) shows '-" You can see it working here: https://docs.google.com/spreadsheets/d/1sca1LgSu46ouOAigppAQYfQNwW48vOgu3c9wcux5HCE/edit?usp=sharing The formula I am using is: =if(and(F2>0,F2>E2),F2-today(),if(or(E2=0,C2=“11 - stop”,C2=“11 - dead”,C2=“09 - lead (Booked a call)”,C2=“10 - sale”,C2=“08 - email follow up sent”),"-",E2-today()+7)) Can you please help me to write this in Airtable? Thank you

I have a base with volunteer information, and for each volunteer record, I have a field for skills. This is a linked record to a separate table that lists the skills. I’m trying to create a grid view of the skills that is grouped by the name of the skill, with each linked record (volunteer) listed on a separate row below. What I’m getting is one record with each of the linked records listed together in the Volunteers field. Is there a way to list them separately?

I currently have a base sync for which I want to reverse the direction of that sync–so that the source table is now the destination table and vice versa. To do this, can I simply delete the URLs in the remote record URL field and switch the source/destination tables?

Hi, I would like to know if it is possible to dublicate data from a table to another one (with more fields) For example a table called STUDENTS (with students informations) And another one called MARKS (for students marks), so basically student information must be in MARKS table too. and if I update a record in a table the record must be updated automatically in other one! How can I do that please?

I am looking for a way to essentially reproduce the Airtable form within slack. I.e. create a slack app that emulates an Airtable form whereby I can fill out the form and push data into Slack. Has anyone tried to accomplish something like this? I am familiar with the Zapier push integration and /cmd line options but I haven’t yet seen a good example of a way to push structured data from slack into Airtable in a way that emulates the correpsonding Airtable form.

Hi. I’m setting up a base that has data relevant to different suppliers and adding blocks to show headcount, chart of headcount by skill type etc. It is possible to set up blocks in a dashboard that are only relevant to the view being accessed, i.e. if i’m in the overall resource list I see blocks reflecting all data. If I access a specific supplier view (within the same base) I only see blocks reflecting data for that supplier? Hope that makes sense!

I want to create a view that only shows the last 8 entries. The reason why I’m not satisfied with just sorting by time created and just looking at the top 8 is because this is going to be a public gallery view for users. I know I can create a separate checkbox field and give a check mark to the last 8, but I don’t want to manually check off boxes. Is this possible?

I have a form in Jotform that contains a text, note and image field, when integrated with Airtable into an add-on field, the text and notes are added well, but the image is not added.

Dear AT community, Doing inventory. I have 3 tables with a list of items, each having their quantities, re-order levels, price, etc. Reason for 3 separate tables below. Looking to create a combined “shopping view” - items from all 3 tables that are below re-order quantities. What is the best way to build this view? Context - Each table has a re-order level column (1/0), that calculates based on a formula. Each table has a corresponding “shopping” view that is filtered on items where re-order level =1. The items are separated into tables by consumption types. Table 1 consists of items measured in numbers/units, 2 has items measured by weights and 3 by lifespan. I could do these as separate columns in a single table but I figured 3 separate tables will make for clean design. Also, curious to learn creating a single view from multiple tables. As always, really appreciate the guidance and learning. Regards, Sunny

Hi new to Airtable, and getting stumped combining data on 1 table from 2 other tables. using 1 table to reference another table. The setup is: I have 3 tables Staff/Projects/Billing, in the projects table I assign staff to a project and count the hours in the staff table I have each staff member and their rate and location in the billing table I list a billing line item link it to a project and then from the projects table I pull in the assigned staff member and the hours worked. I then want to perform a lookup on the staff table using the staff name pulled from the projects table, using this to get the country and the price. But this is where I am getting stumped. The obvious answer is that I pull the staff data to the projects table and then pull that data again to the billing table, but I want to avoid the doubling up if possible as in the long term this will be used on a largish database so any optimization I can achieve will help. FYI in this situation, linked columns are single

I have .docx files in attachment field that fail to render a preview. Wouldn’t be a problem if I could download it and open in MS Word but there is no option to download the file. How can I solve this?

Imagine you have a long text field with rich text enabled that’s called Notes. You have a form view with shared link https://airtable.com/baseid. How do you prefill the Notes field with markdown formatted content? When I prefill with markdown formatted text, it get’s processed as plain text. For example: https://airtable.com/baseid?prefill_Notes=Test%20list%0A*%20A%0A*%20B prefills the Notes field with Test list * A * B Instead of Test list A B

Do Airtable forms meet minimum accessibility requirements? If they don’t meet standards when embedded, do they meet minimums when linked it from a site? If standards are met, what level (example: WCAG 2.0 AA)? Thank you.

Hello!, i have 1 base with 6 table. Everything worked fine, now i have 2 tables navigation problem. I see duplicate view of the table, with same information (as a mirror), with different navigations bar to move independent. I want only one. Thanks.

Hey everyone, I’m using Airtable’s new built-in automations feature but am running into some trouble. The first major roadblock is that my input variables are “null” even though there’s data in the actual field. I know this feature is new, so I’m actually thinking this is a bug but has anyone else had similar issues? When I run a test, sometimes my input variable doesn’t even show that it exists! I’ve attached a screenshot to show what I mean. I’m also getting inconsistent results with my fields and the values they have once brought into the code editor. I’ve had a situation where 2 identical fields (rollup fields configured to be the exact same thing) were brought in as input variables but one was an array with only 1 item in it (all of the values were mashed together as a single string) and one was an array with all the items as individual values in the array (which is what I would expect and want to happen). Anyone else getting inconsistent results like this? It’s making it really

Hello, I am trying to setup a data base for vechicle management, to facilitate followup on different issues depending on a deadline. What I need is it to return a value as it follows: Deadline overdue = Overdue Deadline between 0-10 days = Urgent Deadline between 10-15 days= Soon I created a column for calculating the no. of days to the deadline and used the following formula but it works only for the first two criteria: IF({Deadline}<=0,“Overdue”, IF(AND({Deadline}>=0,{Deadline}<=10,“URGENT”), IF(AND({Deadline}>=10,{Deadline}<=15),“SOON”))) Thankyou in advance!

Diacritical marks in names do not import properly into Airtable.

Hi Team, I am starting out in the CRM environment and came to know about you. I have a small business running. I have a few questions and wonder how you guys can help me manage my business with you. Please listen to me carefully: Well, I run a B2B business. I got around 200 clients from all over the country. I ship the products to them over their request and receive the payments digitally or by cash. The problem is that I got around 1000 products and which I ship to 200 different clients. I need to remember the pricing I quoted to different customers, different type of products I have shipped to them, their dimensions, details and all. The thing I want is: I make the profile for each one. Update all the products I shipped to them with details, dimensions and pricing I quoted. Whenever, a client returns, ask for the same product he bought in the past. I search for the client and see what price I quoted to him for that particular product. This will help me to manage long-term relations