Other Questions

Hi, Is there a way to hide the ‘Show Data’ option in the top right of map block embed. It allows any logged out user to see all the underlying base data across all views and tables Thanks

Hello, How do I embed an entire airtable table into my website but allow people to edit it (it will be on a password protected site with viewers who only have permission to edit). When I tried to embed the airtable it was only viewable not editable on my website? Fyi I’m using Adobe Muse html widgets.

Can you add “Page Description” for the default values of web-clipper text fields ? The Meta tag option won’t work because websites use different syntaxes. Most scrapping tool try common known meta tag then default to the first paragraph (or first N lines) otherwise use the selected text

Hi, we have a calendar of several exhibitions that ends at different dates. I would like to create an automatic email that will be sent to us 15 days in advance before the target date so we can reach out our client and ask if he want to renew the experience or not before its too late. I have downloaded Integromat but i don’t know the right formula to write… Many thanks

Hello, I am new to Airtable. I’m trying to create a project where i have different tables with Start date, end date, people. I want to write a script that will loop through the all tables to check if there is any conflict of assigned date to any person. Can anyone put me through please. Below is my script i started. let table1 = base.getTable(“Project 1”); let table2 = base.getTable(“Project 2”); let table3 = base.getTable(“Project 3”); let Conflict = await input.fileAsync() if (Conflict) { record.getCellValue('table1.Start Date') == record.getCellValue('table2.Start Date'); output.text(`Yes`); } else { output.text('No'); }

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.