Other Questions

Hi, How can I hide data in column for specific colleagues with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

I’m working on an app that will have a free tier and a paid tier, and I’d like to add a button to let users sign up to a paid tier from inside the app. What are the general guidelines regarding building sign up and payment features into AirTable apps?

When I create new records and pull in information into my fields, I make individual changes on the fields, however the records are linking with previous records, I selected unlink and it doesnt seem to help

I need to import data from a .bentodb file. How can I do it?

Is there any way to set up any sort of vertical stacking within a kanban view? e.g. to categorize Project Status columns by Users or by Sub-status? I’ve seen this set up in other project management software and it would be incredibly helpful for workflows if I could set this up for my team.

I have an inventory base that I am creating with multiple tables for a hotel. Tables are as follows: Inventory Table with linked fields for “Measurement” Table & “Department” Table. We would like to limit record selection in the Measurement linked record field based on which Department has been selected in its linked record field. For example: Maintenance department has the ability to select Feet, Inches, Pound, ect. as a selection of measurement when adding a new item to their inventory While Food & Beverage department would only see Gallons, ounces, pounds, ect. Limiting record selection by a view solves the problem if I only had one department but in our case we have 9 departments to plan for. I would greatly appreciate anyones suggestion on how to handle this situation.

Hello guys, I have a workspace shared with 10 collaborators (all of them with the same permissions as Creators), in it they have created 15 bases. Is it possible to know which collaborator worked on a specific base? Thank you.

Hello everybody, I was wondering if anybody knew how to build a wordcloud based on long text responses to a survey that appear in Grid View? I have various Views from a growing dataset and code the responses under a “Multiple Select” field to generate a Chart in my dashboard. However, it would be great to have a wordcloud generated within a dashboard from another long text field as the data is too broad to code into clean categories? I saw a conversation here from 18 months ago and wondered if there was any newer ways of doing so? Thank you in advance!

We are using AT to track student information across the multiple courses we offer. Each course or set of courses(up to 6) has a different facilitator. We simply want the facilitator to see all the students enrolled in their courses or courses and then input one piece of information in a field from a dropdown: complete, incomplete, NA. It seems Forms would be overkill for this and we would have to prefill too many other fields. What might be a better solution? We don’t want to give them edit rights for their view unless we can lock the other fields like the student names, email, etc. Thank you for any help!

Hi All! So here is what I’d like to do. I have a base with four tables. All look precisely the same in terms of fields (types and names). For your understanding, the first three tables are lists with data about particular individuals. And the last table includes all individuals. My goal is to create a field on the fourth table that will let me know by the person’s “Name” (which is the first field) in which table he/she is located. But, some of the records repeat themselves in different tables, so I’d also like to know if the record is in “table1” and “table 2”. Thanks In Advance, -Bar.

Hi Guys, I’m wondering if anyone has had much success syncing with Primavera P6? I’m particularly keen to know if its possible to to create Projects & Activities in P6 from records in Airtable. Any info is much appreciated. Kind regards

I know this question was asked here earlier and yes I can use browser spellcheck. It was asked here… Add Spell Checking to Desktop App Product Suggestions The Airtable Electron app—like many others, but

I didn’t receive the upgraded version even though I paid. I have had money deducted from my bank account and have transaction information

I am publishing some table on our public facing website. I am using Share View to grab the embed code for the website. Testing some url links (found in our table) from our website, specifically for twitter and IG, I have discovered the links don’t resolve properly. Here is a screenshot after clicking on a twitter link. IG has a similar error response. Any idea how I can work aroud this? When I use the website links from my mobile (iphone) the twitter and IG links work fine. I’m only seeing this issue when using our public website from a desktop. Thank in advance.

Hi AT community! Is there a way to extract a persons name from an email address? I have a form that requestors fill in that automatically creates a record. In the form it asks for an email address, and there’s another column for their name. If column A has the email address they entered, I’d like column B to hold their name. Also, all company emails follow a pattern of: fname.lname@domain.com How can I add “fname lname” into column B? I just need what’s before the dot, and after the dot with a space in between.

Hello. I recently created a survey in Airtable and can see the results, but am having trouble getting totals for certain result areas. Such as how many people voted 1, voted 2, etc. If someone could help me with this it would be greatly appreciated! Thanks.

Hi, Folks. I had created a form for collecting data. I put in example link. Airtable

Hey there- Need a bit of help with a complicated formula. I’d like to create a formula that tells me how much to bill any customer on any given month. A customer’s bill is determined by how many square feet their space covers. Billing begins when we deploy our product in their space, which can happen at any point in the month. I’ve created formulas for the following: -Billing start date {Billing Start Date}- This is based on the date our product goes live -Number of billable days in the month when billing began {First Month Billable Days} I have created fields for January-December. I’d like the prorated monthly amount to show up in the appropriate month field (correlates to the {Billing Start Date}, and for any monthly field following that to show the regular monthly fee. For a customer whose space was deployed on 10/12/21, I’m envisioning an output that looks like this: August: (blank) September: (blank) October: $400 November: $10

Hello, I have a website built with ReactJs, Gatsby & deployed to Netlify. Hosting at rebel.ca. I am sending a very simple data to my Airtable form. Everything works perfectly in development, Netlify builds without any issue, link from Netlify work perfectly. However once I deploy to my domain hosted at rebel.ca, I am getting an error that API key is missing for Airtable (but for example not for Prismic which I am using as well). You can check netlify deploy here: https://61a3b5aaf233072f7e8c1e05--elated-tesla-b54a59.netlify.app/ And domain here: https://www.oldgear.ca/ There is Newsletter form at the botttom of the home page, once I submit, preview returns OK submission, domain returns Error in console that Airtable API undefined. I am not sure why this is happening, env variab

I have set up several “Single Select” field types, but editors still keep bypassing this by manually typing in data, many with typos and spelling errors, and its driving me crazy! Is there a way to force them to select one of the options I made available (like excel does) ? Thanks

I would like to lookup entries from another table. But ONLY if they have a certain value in a special field. Is this possible? Example: Table 1: Matchdays Table 2: Players In Table 2 players can either be “available” or “not available”. In Table 1 I want to ONLY list the names of the players that are available. Not ALL players that are linked to that matchday.

Twitter’s web app was refactored and I’ve re-jigged my web clipper as best I can. This web clipper will take a Twitter user’s profile information into a table with fields for: Name Profile from page URL - to be trimmed Avatar Bio from selected text The refactored mark-up in Twitter web app means this clip action needs a little extra work. The steps I follow: go to someone’s Twitter profile eg https://twitter.com/khoi select the text on their bio click their avatar to enlarge it (this exposes a CSS selector for clipping the image, and appends /photo to the URL eg https://twitter.com/khoi/photo) activate Airtable web clipper action trim off the /photo from the page URL tidy up any undesirable

when can I use interfaces features in mobile app?

Hi everyone, I am new to airtable and trying to create a view that will give me a ‘count’ of how many times a client attended a session in the month. I have linked the ‘client’ table and select all the clients that attended for each session. As can be seen, I have also added an ‘attendance months’ field so I can group by month. I am having trouble trying to structure one of the tables to provide the count for each client for the given month. Any help is appreciated, thanks.

Does anyone know how to export VCF files (contact cards) from an app in Airtable? I have seen previous posts but they are closed :confused: