Other Questions

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 not all (see Slite’s app)—lacks support for checking spelling errors as you type. Look, I’m gunna level with you… I suck at spelling. But, I’d rather not have everyone else know it. If you could add spell check support you’d be doing me a solid. Thanks! and here… Spell Checking within Fields Product Suggestions Would it be feasible to have optional spell checking for fields? This needs to be optional to allow for columns which would regularly have values which would not pass a check. and here about Grammaly… Grammarly doesn't work Ask the community As I mentioned before, I only saw it appear right away on one site that I use (Evernote), with nothing showing up here. After seeing the green

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 Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. I didn’t set up any option in my form. But the form link dosen’t work that customer can not fill in the form. The link moved to log-in page. How can i fix it? Best, Daniel

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: $1000 December: $1000 Any help would be much appreciated!

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 variables are saved in UI of Netlify domain setttings and as mentioned other API keys are ok, only the POST request for this Airtable link does not work… Do you have any idea why this is happening? Thank you in adv

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 new lines in the Bio text produced by @mentions or #tags Here’s the clip action recipe for Twitter profiles: { "schemaVersion": 3, "fieldMappings": [ { "fieldName": "Name", "fieldType": "singleLineText", "defaultValue": { "type

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:

Hi! I work at an Ad Agency and we use Airtable as a project management tool between all of our clients and creators. We specifically track each concept we are working on in a single row. We charge clients against a monthly hourly allotment of 30 hours per month. We are looking for an easier/ better way to track monthly hours per project per client. Some projects hop month to month and a designer may spend 5 hours in January and 6 hours in February. We need a way to track these hours in each month for each concept. Currently, we have 12 columns, one for each month of the year, for the designer to put the hours used per month per project. Some projects only last 1-3 months so it is kind of redundant to have so many collums. Ideally, I want one column that can allow a designer to input their total hours per month as needed vs 12 different collums

Hi everyone, Basically, I’m putting together online forms for staff uniform orders for my organisation, a heritage organisation which manages over 80 visitor sites across the country. We have two broad categories of uniform sites – Formal and Casual. Formal is shirts, smart trousers, waistcoats etc — Casual is polo shirts, cargo trousers etc. What I’m looking to achieve is to have a form where staff can click on their site and the form automatically reveals the options relevant to them — so those who click “Site A” (which is a Formal site) see the options for shirt and waistcoat sizes, whereas those who click “Site B” will see options for polo shirts, but not for shirts or waistcoats. I have a Sites table that contains all of our sites which staff can select from. It includes addresses, management and whether the sites are designated as casual/formal. I even have the “Site type” (i.e. Formal or Casual) included in the Form’s table as a Lookup field pulling from the Sites table. The pro

Hello. I’d like to share an org chart app but I don’t wan’t the corresponding view to be visible to the viewer. Is this possible? Thank you.

I saw another question here about this, but it had no answer. I have multiple choice questions in typeform, and when I try to map them to multiple select, I see the fields listed but they’re grayed out. It only happens sometimes and I can’t figure out why it doesn’t work all the time. The answers I’ve added in airtable match typeform exactly. This is a huge blocker for me!

Hi! I’m trying to make an automation that will notify me when an entered record shares a field with other entries within a certain time. Essentially, we track issue tags and want to know if there have been 3 issue tags in the same state within a two week period (the state and receipt date are tracked as fields on the issue tag). My thought is to make a formula that counts how many entries within the past two weeks share a state with the given entry, and make that the condition for the automation. My question is, what formula (or group of formulas) would I use to look at other entries? I can’t seem to find formulas that look anywhere except inside entry that the formula outputs on. If I can’t do it with formulas, is there an app that will help me? Thanks

I’m integrating Typeform with AirTable and all is working great with most fields but not with single-select and multiple-select fields. Documentation states these AirTable fields map to Typeform fields that are Multiple Select, which is what I used. When mapping these fields in my block, I can enable my AirTable select field but the equivalent fields in Typeform are greyed out so cannot be selected. Any help would be greatly appreciated. Thank you.

Hello, I am trying to connect Qonto (a bank) to Airtable. I made a first import from my Qonto external database to Airtable by mapping the columns with Integromat, and no problem. It has information like the VAT rate which is only updated later in Qonto database (the bank) So I would just like to map the two columns and update the data, but I can only find the option to map a cell (a record). I can’t find a way to update an entire column. Thank you for your help ! Quentin

In order to use Airtable Sync, do I have to Do I have to turn on the external publication of Share View Link in order to use Airtable Sync? I’d like to sync another BASE with Airtable Sync. In the case of AIrtable to Airtable, I need to create a Share View Link on one of them. If I set Access restricted to to a specific domain (@test.com) in Share View Link, it does not work with Airtable Sync. Can I somehow share the Airtable BASE without external users having access to it?